{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["KALKULAČKA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"KALKULAČKA","index":0,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,7,0],[0,2,0,12],[1,2,1,5],[1,6,1,12],[2,2,2,5],[2,6,2,12],[3,2,3,5],[3,6,3,8],[3,10,3,12],[4,2,4,5],[4,6,4,12],[5,2,5,5],[5,6,5,7],[6,2,6,5],[6,6,6,7],[6,8,6,12],[7,2,7,12],[8,4,8,7],[8,8,8,12],[9,0,11,0],[9,4,9,7],[9,8,9,12],[10,4,10,7],[10,8,10,12],[11,4,11,7],[11,8,11,12],[12,4,12,7],[12,8,12,12],[13,4,13,7],[13,8,13,12],[14,4,14,7],[14,8,14,12],[15,4,15,7],[15,8,15,12],[16,4,16,7],[16,8,16,12],[17,4,17,7],[17,8,17,12],[18,4,18,7],[18,8,18,12],[19,4,19,7],[19,8,19,12],[20,4,20,7],[20,8,20,12],[21,4,21,7],[21,8,21,12],[22,4,22,7],[22,8,22,12],[23,4,23,7],[23,8,23,12],[24,4,24,7],[24,8,24,12],[25,4,25,7],[25,8,25,12],[26,4,26,7],[26,8,26,12],[27,4,27,7],[27,8,27,12],[28,4,28,7],[28,8,28,12],[29,4,29,7],[29,8,29,12]]}
[null,null,"KALKULAČKA",null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Jméno a Příjmení",null,null,null,"Petr Vrána"]
[null,null,"kód rybáře (legitimace)",null,null,null,2009403]
[null,null,"číslo bankovního účtu",null,null,null,2700686399,null,null,"/",2010]
[null,null,"CELKEM UHRADIT: ",null,null,null,{"$f":"SUM(I9:I30)","v":5600}]
[null,null,"kód platby:",null,null,null,null,null,{"$f":"VLOOKUP(\"x\",C9:D11,2,0)","v":1},{"$f":"VLOOKUP(\"x\",C12:D14,2,0)","v":1},{"$f":"VLOOKUP(\"x\",C15:D21,2,0)","v":4},{"$f":"VLOOKUP(\"x\",C22:D28,2,0)","v":1},{"$f":"VLOOKUP(\"x\",C29:D30,2,0)","v":{"$error":"#N/A"}}]
[null,null,"specifický symbol:",null,null,null,null,null,{"$f":"I6 & \" \" & J6  & \" \" &  K6  & \" \" &  L6  & \" \" &  M6","v":{"$error":"#N/A"}}]
[null,null,"ÚČEL PLATBY / POLOŽKU ZVOLÍTE ZAPSÁNÍM PÍSMENE \"X\" DO ŽLUTÉHO SLOUPCE                  "]
[null,null,"x",1,"ČLENSKÉ PŘÍSPĚVKY DOSPĚLÍ",null,null,null,{"$f":"IF(C9=\"x\",N9,\"\")","v":500},null,null,null,null,500]
["nahoře místo pro QR platbu.",null,null,2,"ČLENSKÉ PŘÍSPĚVKY MLÁDĚŽ 16-18 LET",null,null,null,{"$f":"IF(C10=\"x\",N10,\"\")","v":""},null,null,null,null,200]
[null,null,null,3,"ČLENSKÉ PŘÍSPĚVKY DĚTI DO 15-TI LET",null,null,null,{"$f":"IF(C11=\"x\",N11,\"\")","v":""},null,null,null,null,100]
[null,null,"x",1,"BRIGÁDY DOSPĚLÍ",null,null,null,{"$f":"IF(C12=\"x\",N12,\"\")","v":1000},null,null,null,null,1000]
[null,null,null,2,"BRIGÁDY MLÁDĚŽ 16-18 LET",null,null,null,{"$f":"IF(C13=\"x\",N13,\"\")","v":""},null,null,null,null,500]
[null,null,null,3,"BRIGÁDY ZTP 1. A 2. STUPEŇ",null,null,null,{"$f":"IF(C14=\"x\",N14,\"\")","v":""},null,null,null,null,200]
[null,null,null,1,"POVOLENKA MP KRAJSKÁ DOSPĚLÍ",null,null,null,{"$f":"IF(C15=\"x\",N15,\"\")","v":""},null,null,null,null,1600]
[null,null,null,2,"POVOLENKA MP KRAJSKÁ 16-18 LET",null,null,null,{"$f":"IF(C16=\"x\",N16,\"\")","v":""},null,null,null,null,800]
[null,null,null,3,"POVOLENKA MP KRAJSKÁ DO 15-TI A ZTP/P",null,null,null,{"$f":"IF(C17=\"x\",N17,\"\")","v":""},null,null,null,null,400]
[null,null,"x",4,"POVOLENKA MP CELOSVAZOVÁ DOSPĚLÍ",null,null,null,{"$f":"IF(C18=\"x\",N18,\"\")","v":2500},null,null,null,null,2500]
[null,null,null,5,"POVOLENKA MP CELOSVAZOVÁ 16-18 LET A ZTP",null,null,null,{"$f":"IF(C19=\"x\",N19,\"\")","v":""},null,null,null,null,1400]
[null,null,null,6,"POVOLENKA MP CELOSVAZOVÁ DO 15-TI",null,null,null,{"$f":"IF(C20=\"x\",N20,\"\")","v":""},null,null,null,null,650]
[null,null,null,7,"SUPERPOVOLENKA (ČRS+MRS) MP",null,null,null,{"$f":"IF(C21=\"x\",N21,\"\")","v":""},null,null,null,null,3550]
[null,null,"x",1,"POVOLENKA P KRAJSKÁ DOSPĚLÍ",null,null,null,{"$f":"IF(C22=\"x\",N22,\"\")","v":1600},null,null,null,null,1600]
[null,null,null,2,"POVOLENKA P KRAJSKÁ 16-18 LET",null,null,null,{"$f":"IF(C23=\"x\",N23,\"\")","v":""},null,null,null,null,800]
[null,null,null,3,"POVOLENKA P KRAJSKÁ DO 15-TI A ZTP/P",null,null,null,{"$f":"IF(C24=\"x\",N24,\"\")","v":""},null,null,null,null,400]
[null,null,null,4,"POVOLENKA P CELOSVAZOVÁ DOSPĚLÍ",null,null,null,{"$f":"IF(C25=\"x\",N25,\"\")","v":""},null,null,null,null,2600]
[null,null,null,5,"POVOLENKA P CELOSVAZOVÁ 16-18 LET A ZTP",null,null,null,{"$f":"IF(C26=\"x\",N26,\"\")","v":""},null,null,null,null,1450]
[null,null,null,6,"POVOLENKA P CELOSVAZOVÁ DO 15-TI",null,null,null,{"$f":"IF(C27=\"x\",N27,\"\")","v":""},null,null,null,null,700]
[null,null,null,7,"SUPERPOVOLENKA (ČRS+MRS) P",null,null,null,{"$f":"IF(C28=\"x\",N28,\"\")","v":""},null,null,null,null,3700]
[null,null,null,1,"ZÁPISNÉ",null,null,null,{"$f":"IF(C29=\"x\",N29,\"\")","v":""},null,null,null,null,200]
[null,null,null,2,"POZDNÍ VRÁCENÍ POVOLENKY",null,null,null,{"$f":"IF(C30=\"x\",N30,\"\")","v":""},null,null,null,null,100]