{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["PK"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":"PK","index":0,"n_rows":40,"n_cols":44,"rows_kept":40,"cut":false,"hidden":false,"merged":[[24,10,24,12],[23,10,23,12],[22,10,22,12],[21,10,21,12],[25,14,25,16],[26,14,26,16],[27,14,27,16],[28,14,28,16],[29,14,29,16],[30,14,30,16],[31,14,31,16],[32,14,32,16],[29,10,29,12],[28,10,28,12],[27,10,27,12],[26,10,26,12],[25,10,25,12],[11,8,11,16],[10,8,10,16],[10,1,14,6],[4,10,5,15],[1,10,2,15],[20,14,20,16],[21,14,21,16],[22,14,22,16],[23,14,23,16],[20,10,20,12],[16,14,16,17],[14,8,14,17],[12,8,12,16],[13,8,13,16],[18,1,19,1],[18,2,19,3],[18,4,19,7],[18,8,19,8],[18,9,19,9],[15,1,15,5],[15,6,17,7],[15,8,15,9],[15,10,15,13],[15,14,15,17],[26,39,26,43],[27,39,27,43],[28,39,28,43],[38,12,38,13],[38,14,38,15],[38,16,38,17],[39,14,39,15],[39,16,39,17],[33,14,33,16],[33,10,33,12],[32,10,32,12],[31,10,31,12],[17,39,17,43],[23,39,23,43],[24,39,24,41],[25,39,25,41],[24,42,24,43],[25,42,25,43],[9,39,9,43],[8,38,8,43],[13,39,13,43],[10,38,11,38],[14,39,14,43],[18,39,18,43],[19,39,19,43],[35,3,38,4],[35,5,38,5],[33,4,33,7],[33,2,33,3],[16,8,16,9],[16,10,16,13],[18,10,18,13],[17,8,17,9],[17,10,17,17],[18,14,18,17],[19,10,19,12],[19,14,19,16],[38,10,38,11],[34,8,34,9],[37,10,37,17],[38,8,39,9],[39,10,39,11],[39,12,39,13],[34,10,34,13],[34,14,34,17],[35,8,37,9],[35,10,36,17],[30,10,30,12],[24,14,24,16],[12,39,12,43],[16,39,16,43],[15,39,15,43],[20,39,20,43],[21,39,21,43],[22,39,22,43],[39,1,39,7],[30,346,31,353],[48,343,49,344],[20,2,20,3],[20,4,20,7],[21,2,21,3],[21,4,21,7],[22,2,22,3],[22,4,22,7],[23,2,23,3],[23,4,23,7],[35,6,38,6],[35,7,38,7],[27,2,27,3],[27,4,27,7],[28,2,28,3],[28,4,28,7],[29,2,29,3],[24,2,24,3],[24,4,24,7],[25,2,25,3],[25,4,25,7],[26,2,26,3],[26,4,26,7],[75,346,76,353],[78,346,79,353],[51,346,52,353],[54,346,55,353],[57,346,58,353],[60,346,61,353],[63,346,64,353],[66,346,67,353],[29,4,29,7],[30,2,30,3],[30,4,30,7],[31,2,31,3],[31,4,31,7],[32,2,32,3],[32,4,32,7],[34,1,34,2],[34,3,34,4],[35,1,38,2],[42,343,43,344],[45,343,46,344],[33,346,34,353],[36,346,37,353],[39,346,40,353],[42,346,43,353],[45,346,46,353],[111,244,112,251],[108,256,109,260],[111,256,112,260],[108,244,109,251],[36,343,37,344],[39,343,40,344],[51,343,52,344],[57,343,58,344],[60,343,61,344],[63,343,64,344],[69,343,70,344],[72,343,73,344],[48,346,49,353],[69,346,70,353],[72,346,73,353],[45,442,46,443],[57,445,58,452],[60,445,61,452],[60,442,61,443],[48,442,49,443],[45,445,46,452],[57,442,58,443],[48,445,49,452],[51,442,52,443],[51,445,52,452],[54,445,55,452],[42,445,43,452],[42,442,43,443],[5,358,6,362],[12,358,13,362],[21,445,22,452],[5,442,6,443],[5,445,6,452],[5,145,6,152],[12,145,13,152],[15,145,16,152],[5,157,6,161],[5,244,6,251],[5,256,6,260],[12,244,13,251],[15,244,16,251],[18,244,19,251],[24,445,25,452],[27,445,28,452],[30,442,31,443],[36,445,37,452],[36,442,37,443],[39,445,40,452],[30,445,31,452],[33,445,34,452],[5,457,6,461],[21,442,22,443],[12,445,13,452],[12,457,13,461],[15,445,16,452],[18,445,19,452],[33,442,34,443],[24,442,25,443],[12,343,13,344],[5,343,6,344],[12,256,13,260],[12,157,13,161],[5,346,6,353],[12,346,13,353],[15,346,16,353],[18,346,19,353],[21,346,22,353],[24,346,25,353],[27,346,28,353]]}
[]
[null,null,null,null,null,null,null,null,null,null,"WYDRUKUJ DOKUMENT"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"WYCZYŚĆ DOKUMENT"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABELA POMOCNICZA - 1 - SŁOWNY OPIS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LP","Podział na:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1)","Grosze","Setki","Tysiące","Miliony","Miliardy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((AQ26-INT(AQ26))*100,0)","v":54},{"$f":"IF(AQ26>=1,VALUE(RIGHT(LEFT(INT(AQ26),LEN(INT(AQ26))),3)),0)","v":14},{"$f":"IF(AQ26>=1000,VALUE(TEXT(RIGHT(LEFT(INT(AQ26),LEN(INT(AQ26))-3),3),\"000\")),0)","v":0},{"$f":"IF(AQ26>=1000000,VALUE(TEXT(RIGHT(LEFT(INT(AQ26),LEN(INT(AQ26))-6),3),\"000\")),0)","v":0},{"$f":"IF(AQ26>=1000000000,VALUE(TEXT(RIGHT(LEFT(INT(AQ26),LEN(INT(AQ26))-9),3),\"000\")),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2)","Warianty opisu groszy:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a)",{"$f":"ROUND((AQ26-INT(AQ26))*100,0)&\"/\"&100 & \" groszy\"","v":"54/100 groszy"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b)",{"$f":"IF(AQ26=0,\"\",IF(AN12<=20,IF(AN12=0,\"zero\",INDEX(Jednosci,AN12)),INDEX(Dziesiatki,INT(AN12/10))&IF(MOD(AN12,10),\" \" &INDEX(Jednosci,MOD(AN12,10)),\"\")))& \" \" &IF(AQ26=0,\"\",INDEX(IF(AN12<20,{\"groszy\";\"grosz\";\"grosze\";\"groszy\"},{\"groszy\";\"grosze\";\"groszy\"}),MATCH(IF(AN12<20,AN12,MOD(AN12,10)),IF(AN12<20,{0;1;2;5},{0;2;5}),1)))","v":"pięćdziesiąt cztery grosze"}]
[null,"(PIECZĘĆ JEDNOSTKI)",null,null,null,null,"PK POLECENIE KSIĘGOWANIA",null,"NUMER",null,"DATA WYSTAWIENIA",null,null,null,"ZAKSIĘGOWAĆ POD DATĄ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3)","Cząstkowy opis:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Setki",{"$f":"IF(OR(AQ26<1,INT(AO12/100)=0),\"\",INDEX(Setki,INT(AO12/100)))& IF(AO12-(INT(AO12/100)*100)<=20,IF(AO12-(INT(AO12/100)*100)=0,IF(OR(AO12>0,AQ26<1),\"\",\"złotych\"),\" \" &INDEX(Jednosci,AO12-(INT(AO12/100)*100))),\" \" &INDEX(Dziesiatki,INT((AO12-(INT(AO12/100)*100))/10))&IF(MOD((AO12-(INT(AO12/100)*100)),10),\" \"&INDEX(Jednosci,MOD((AO12-(INT(AO12/100)*100)),10)),\"\"))&IF(AO12=0,\"\",\" \" &INDEX(IF(AO12<20,{\"złotych\";\"złoty\";\"złote\";\"złotych\"},{\"złotych\";\"złote\";\"złotych\"}),MATCH(IF(AO12-(INT(AO12/100)*100)<20,AO12-(INT(AO12/100)*100),MOD((AO12-(INT(AO12/100)*100)),10)),IF(AO12<20,{0;1;2;5},{0;2;5}),1)))","v":" czternaście złotych"}]
[null,null,null,null,null,null,null,null,"KONTO",null,"SUMY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tysiące",{"$f":"IF(OR(AQ26<1,INT(AP12/100)=0),\"\",INDEX(Setki,INT(AP12/100)))& IF(AP12-(INT(AP12/100)*100)<=20,IF(AP12-(INT(AP12/100)*100)=0,\"\",\" \" &INDEX(Jednosci,AP12-(INT(AP12/100)*100))),\" \" &INDEX(Dziesiatki,INT((AP12-(INT(AP12/100)*100))/10))&IF(MOD((AP12-(INT(AP12/100)*100)),10),\" \"&INDEX(Jednosci,MOD((AP12-(INT(AP12/100)*100)),10)),\"\"))&IF(AP12=0,\"\",\" \" &INDEX(IF(AP12<20,{\"\";\"tysiąc\";\"tysiące\";\"tysięcy\"},{\"tysięcy\";\"tysiące\";\"tysięcy\"}),MATCH(IF(AP12-(INT(AP12/100)*100)<20,AP12-(INT(AP12/100)*100),MOD((AP12-(INT(AP12/100)*100)),10)),IF(AP12<20,{0;1;2;5},{0;2;5}),1)))","v":""}]
[null,"LP","DOWÓD",null,"TREŚĆ",null,null,null,"WINIEN","MA","POJEDYNCZE CZĄSTKOWE",null,null,null,"OGÓLNE KONTROLNE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Miliony",{"$f":"IF(OR(AQ26<1,INT(AQ12/100)=0),\"\",INDEX(Setki,INT(AQ12/100)))& IF(AQ12-(INT(AQ12/100)*100)<=20,IF(AQ12-(INT(AQ12/100)*100)=0,\"\",\" \" &INDEX(Jednosci,AQ12-(INT(AQ12/100)*100))),\" \" &INDEX(Dziesiatki,INT((AQ12-(INT(AQ12/100)*100))/10))&IF(MOD((AQ12-(INT(AQ12/100)*100)),10),\" \"&INDEX(Jednosci,MOD((AQ12-(INT(AQ12/100)*100)),10)),\"\"))&IF(AQ12=0,\"\",\" \" &INDEX(IF(AQ12<20,{\"\";\"milion\";\"miliony\";\"milionów\"},{\"milionów\";\"miliony\";\"milionów\"}),MATCH(IF(AQ12-(INT(AQ12/100)*100)<20,AQ12-(INT(AQ12/100)*100),MOD((AQ12-(INT(AQ12/100)*100)),10)),IF(AQ12<20,{0;1;2;5},{0;2;5}),1)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"ZŁ",null,null,"GR","ZŁ",null,null,"GR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Miliardy",{"$f":"IF(OR(AQ26<1,INT(AR12/100)=0),\"\",INDEX(Setki,INT(AR12/100)))& IF(AR12-(INT(AR12/100)*100)<=20,IF(AR12-(INT(AR12/100)*100)=0,\"\",\" \" &INDEX(Jednosci,AR12-(INT(AR12/100)*100))),\" \" &INDEX(Dziesiatki,INT((AR12-(INT(AR12/100)*100))/10))&IF(MOD((AR12-(INT(AR12/100)*100)),10),\" \"&INDEX(Jednosci,MOD((AR12-(INT(AR12/100)*100)),10)),\"\"))&IF(AR12=0,\"\",\" \" &INDEX(IF(AR12<20,{\"\";\"miliard\";\"miliardy\";\"miliardów\"},{\"miliardów\";\"miliardy\";\"miliardów\"}),MATCH(IF(AR12-(INT(AR12/100)*100)<20,AR12-(INT(AR12/100)*100),MOD((AR12-(INT(AR12/100)*100)),10)),IF(AR12<20,{0;1;2;5},{0;2;5}),1)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,1,null,null,{"$f":"IF(ISERROR(FIND(\",\",K21))=TRUE,IF(K21=\"\",\"\",\"00\"),IF((LEN(K21)-FIND(\",\",K21))=1,\"0\",\"\"))","v":"00"},null,null,null,{"$f":"IF(ISERROR(FIND(\",\",O21))=TRUE,IF(O21=\"\",\"\",\"00\"),IF((LEN(O21)-FIND(\",\",O21))=1,\"0\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4)","Pełny opis:"]
[null,null,null,null,null,null,null,null,null,null,1.2,null,null,{"$f":"IF(ISERROR(FIND(\",\",K22))=TRUE,IF(K22=\"\",\"\",\"00\"),IF((LEN(K22)-FIND(\",\",K22))=1,\"0\",\"\"))","v":"0"},null,null,null,{"$f":"IF(ISERROR(FIND(\",\",O22))=TRUE,IF(O22=\"\",\"\",\"00\"),IF((LEN(O22)-FIND(\",\",O22))=1,\"0\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opcja 1",{"$f":"IF(NOT(ISNUMBER(AQ26)),\"\",IF(OR((AQ26*10^-12)>=1,AQ26<0),\"\",IF(TRIM(AN20)<>\"\",TRIM(AN20)&\" \",\"\")&IF(TRIM(AN19)<>\"\",TRIM(AN19)&\" \",\"\")&IF(TRIM(AN18)<>\"\",TRIM(AN18)&\" \",\"\")&IF(TRIM(AN17)<>\"\",TRIM(AN17)&\", \",\"\")&IF(TRIM(AN15)<>\"\",AN15&\" \",\"\")))","v":"czternaście złotych, pięćdziesiąt cztery grosze "}]
[null,null,null,null,null,null,null,null,null,null,12.34,null,null,{"$f":"IF(ISERROR(FIND(\",\",K23))=TRUE,IF(K23=\"\",\"\",\"00\"),IF((LEN(K23)-FIND(\",\",K23))=1,\"0\",\"\"))","v":""},null,null,null,{"$f":"IF(ISERROR(FIND(\",\",O23))=TRUE,IF(O23=\"\",\"\",\"00\"),IF((LEN(O23)-FIND(\",\",O23))=1,\"0\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opcja 2",{"$f":"IF(NOT(ISNUMBER(AQ26)),\"\",IF(OR((AQ26*10^-12)>=1,AQ26<0),\"\",IF(TRIM(AN20)<>\"\",TRIM(AN20)&\" \",\"\")&IF(TRIM(AN19)<>\"\",TRIM(AN19)&\" \",\"\")&IF(TRIM(AN18)<>\"\",TRIM(AN18)&\" \",\"\")&IF(TRIM(AN17)<>\"\",TRIM(AN17)&\" \",\"\")&IF(TRIM(AN15)<>\"\",AN14&\" \",\"\")))","v":"czternaście złotych 54/100 groszy "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5)","Podaj komórkę z kwotą, do której ma być opis słowny:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a)","Obecna komórka to:",null,null,{"$f":"RIGHT(_xlfn.FORMULATEXT(AQ26),LEN(_xlfn.FORMULATEXT(AQ26))-1)","v":"K35"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b)","Zmień na (zaznacz odpowiednią komórkę):",null,null,{"$f":"K35","v":14.54}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6)","Opis wyświetlany:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Część 1",{"$f":"TRIM(AN20&\" \"&AN19&\" \"&AN18&\" \"&AN17)","v":"czternaście złotych"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Część 2",{"$f":"AN15","v":"pięćdziesiąt cztery grosze"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[null,"ZAŁĄCZNIKÓW",null,"SPORZĄDZIŁ",null,"SPRAWDZIŁ","ZATWIERDZIŁ","INNE","RAZEM",null,{"$f":"IF(SUM(K21:M34)=0,\"\",SUM(K21:M34))","v":14.54},null,null,null,{"$f":"IF(SUM(O21:Q34)=0,\"\",SUM(O21:Q34))","v":""}]
[null,null,null,null,null,null,null,null,"SŁOWNIE",null,{"$f":"IF(K35=\"\",\"\",TRIM(AN28))","v":"czternaście złotych"}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K35=\"\",\"\",TRIM(AN29))","v":"pięćdziesiąt cztery grosze"}]
[null,null,null,null,null,null,null,null,"ZAKSIĘGOWANO",null,"DATA",null,"DZIENNIK",null,"STRONA",null,"PODPIS"]
[null,"Biuro Rachunkowe Regina Janicka | wersja dokumentu 1.0"]