{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["DW"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":11,"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":"DW","index":0,"n_rows":42,"n_cols":32,"rows_kept":42,"cut":false,"hidden":false,"merged":[[8,27,8,31],[0,1,4,1],[2,5,2,7],[13,10,14,13],[10,1,11,1],[10,2,11,2],[10,3,11,3],[10,4,11,4],[10,5,11,7],[12,1,14,1],[12,2,14,2],[12,3,14,3],[12,4,14,4],[12,5,14,7],[15,1,17,1],[15,2,17,2],[15,3,17,3],[15,4,17,4],[15,5,17,7],[21,5,23,7],[18,1,20,1],[18,2,20,2],[18,3,20,3],[18,4,20,4],[18,5,20,7],[27,2,29,2],[21,1,23,1],[21,2,23,2],[21,3,23,3],[21,4,23,4],[41,1,41,3],[0,26,0,31],[1,27,1,31],[2,26,3,26],[4,27,4,31],[5,27,5,31],[6,27,6,31],[7,27,7,31],[32,3,32,7],[33,6,33,7],[34,6,34,7],[39,5,39,7],[40,1,40,3],[40,5,40,7],[27,3,29,3],[27,4,29,4],[39,1,39,3],[10,10,11,13],[5,1,6,4],[5,5,6,7],[15,27,15,31],[16,27,16,29],[16,30,16,31],[17,27,17,29],[17,30,17,31],[18,27,18,31],[9,27,9,31],[10,27,10,31],[11,27,11,31],[12,27,12,31],[13,27,13,31],[14,27,14,31],[19,27,19,31],[20,27,20,31],[33,2,34,4],[35,2,35,4],[1,5,1,7],[27,5,29,7],[30,1,30,3],[30,4,31,4],[30,5,31,7],[31,1,31,3],[24,1,26,1],[24,2,26,2],[24,3,26,3],[24,4,26,4],[24,5,26,7],[27,1,29,1]]}
[null,null,null,null,null,null,{"$f":"IF(G2=\"styczeń\",\"01\",IF(G2=\"luty\",\"02\",IF(G2=\"marzec\",\"03\",IF(G2=\"kwiecień\",\"04\",IF(G2=\"maj\",\"05\",IF(G2=\"czerwiec\",\"06\",IF(G2=\"lipiec\",\"07\",IF(G2=\"sierpień\",\"08\",IF(G2=\"wrzesień\",\"09\",IF(G2=\"październik\",\"10\",IF(G2=\"listopad\",\"11\",IF(G2=\"grudzień\",\"12\",\"\"))))))))))))","v":""},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,"LP","Podział na:"]
[null,null,"pieczęć",null,null,"dnia",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,{"$f":"ROUND((AE18-INT(AE18))*100,0)","v":65},{"$f":"IF(AE18>=1,VALUE(RIGHT(LEFT(INT(AE18),LEN(INT(AE18))),3)),0)","v":62},{"$f":"IF(AE18>=1000,VALUE(TEXT(RIGHT(LEFT(INT(AE18),LEN(INT(AE18))-3),3),\"000\")),0)","v":0},{"$f":"IF(AE18>=1000000,VALUE(TEXT(RIGHT(LEFT(INT(AE18),LEN(INT(AE18))-6),3),\"000\")),0)","v":0},{"$f":"IF(AE18>=1000000000,VALUE(TEXT(RIGHT(LEFT(INT(AE18),LEN(INT(AE18))-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,"2)","Warianty opisu groszy:"]
[null,"DOWÓD WEWNĘTRZNY NR:",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((AE18-INT(AE18))*100,0)&\"/\"&100 & \" groszy\"","v":"65/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,"b)",{"$f":"IF(AE18=0,\"\",IF(AB4<=20,IF(AB4=0,\"zero\",INDEX(Jednosci,AB4)),INDEX(Dziesiatki,INT(AB4/10))&IF(MOD(AB4,10),\" \" &INDEX(Jednosci,MOD(AB4,10)),\"\")))& \" \" &IF(AE18=0,\"\",INDEX(IF(AB4<20,{\"groszy\";\"grosz\";\"grosze\";\"groszy\"},{\"groszy\";\"grosze\";\"groszy\"}),MATCH(IF(AB4<20,AB4,MOD(AB4,10)),IF(AB4<20,{0;1;2;5},{0;2;5}),1)))","v":"sześćdziesiąt pięć 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,"3)","Cząstkowy opis:"]
[null,{"$f":"IF(XFD9=\"\",\"\",IF(A9=\"\",\"\",XFD9*A9))","v":""},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(AE18<1,INT(AC4/100)=0),\"\",INDEX(Setki,INT(AC4/100)))& IF(AC4-(INT(AC4/100)*100)<=20,IF(AC4-(INT(AC4/100)*100)=0,IF(OR(AC4>0,AE18<1),\"\",\"złotych\"),\" \" &INDEX(Jednosci,AC4-(INT(AC4/100)*100))),\" \" &INDEX(Dziesiatki,INT((AC4-(INT(AC4/100)*100))/10))&IF(MOD((AC4-(INT(AC4/100)*100)),10),\" \"&INDEX(Jednosci,MOD((AC4-(INT(AC4/100)*100)),10)),\"\"))&IF(AC4=0,\"\",\" \" &INDEX(IF(AC4<20,{\"złotych\";\"złoty\";\"złote\";\"złotych\"},{\"złotych\";\"złote\";\"złotych\"}),MATCH(IF(AC4-(INT(AC4/100)*100)<20,AC4-(INT(AC4/100)*100),MOD((AC4-(INT(AC4/100)*100)),10)),IF(AC4<20,{0;1;2;5},{0;2;5}),1)))","v":" sześćdziesiąt dwa złote"}]
[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(AE18<1,INT(AD4/100)=0),\"\",INDEX(Setki,INT(AD4/100)))& IF(AD4-(INT(AD4/100)*100)<=20,IF(AD4-(INT(AD4/100)*100)=0,\"\",\" \" &INDEX(Jednosci,AD4-(INT(AD4/100)*100))),\" \" &INDEX(Dziesiatki,INT((AD4-(INT(AD4/100)*100))/10))&IF(MOD((AD4-(INT(AD4/100)*100)),10),\" \"&INDEX(Jednosci,MOD((AD4-(INT(AD4/100)*100)),10)),\"\"))&IF(AD4=0,\"\",\" \" &INDEX(IF(AD4<20,{\"\";\"tysiąc\";\"tysiące\";\"tysięcy\"},{\"tysięcy\";\"tysiące\";\"tysięcy\"}),MATCH(IF(AD4-(INT(AD4/100)*100)<20,AD4-(INT(AD4/100)*100),MOD((AD4-(INT(AD4/100)*100)),10)),IF(AD4<20,{0;1;2;5},{0;2;5}),1)))","v":""}]
[null,"LP.","Nazwa towaru, opłaty lub tytuł i cel wydatku","Ilość","Cena jednostkowa (zł)","Wartość (zł)",null,null,null,null,"DRUKUJ DOKUMENT",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,"Miliony",{"$f":"IF(OR(AE18<1,INT(AE4/100)=0),\"\",INDEX(Setki,INT(AE4/100)))& IF(AE4-(INT(AE4/100)*100)<=20,IF(AE4-(INT(AE4/100)*100)=0,\"\",\" \" &INDEX(Jednosci,AE4-(INT(AE4/100)*100))),\" \" &INDEX(Dziesiatki,INT((AE4-(INT(AE4/100)*100))/10))&IF(MOD((AE4-(INT(AE4/100)*100)),10),\" \"&INDEX(Jednosci,MOD((AE4-(INT(AE4/100)*100)),10)),\"\"))&IF(AE4=0,\"\",\" \" &INDEX(IF(AE4<20,{\"\";\"milion\";\"miliony\";\"milionów\"},{\"milionów\";\"miliony\";\"milionów\"}),MATCH(IF(AE4-(INT(AE4/100)*100)<20,AE4-(INT(AE4/100)*100),MOD((AE4-(INT(AE4/100)*100)),10)),IF(AE4<20,{0;1;2;5},{0;2;5}),1)))","v":""}]
[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,"Miliardy",{"$f":"IF(OR(AE18<1,INT(AF4/100)=0),\"\",INDEX(Setki,INT(AF4/100)))& IF(AF4-(INT(AF4/100)*100)<=20,IF(AF4-(INT(AF4/100)*100)=0,\"\",\" \" &INDEX(Jednosci,AF4-(INT(AF4/100)*100))),\" \" &INDEX(Dziesiatki,INT((AF4-(INT(AF4/100)*100))/10))&IF(MOD((AF4-(INT(AF4/100)*100)),10),\" \"&INDEX(Jednosci,MOD((AF4-(INT(AF4/100)*100)),10)),\"\"))&IF(AF4=0,\"\",\" \" &INDEX(IF(AF4<20,{\"\";\"miliard\";\"miliardy\";\"miliardów\"},{\"miliardów\";\"miliardy\";\"miliardów\"}),MATCH(IF(AF4-(INT(AF4/100)*100)<20,AF4-(INT(AF4/100)*100),MOD((AF4-(INT(AF4/100)*100)),10)),IF(AF4<20,{0;1;2;5},{0;2;5}),1)))","v":""}]
[null,1,null,5,12.53,{"$f":"IF(AND(D13=\"\",E13=\"\")=TRUE,\"\",IF(D13=\"\",1*E13,D13*E13))","v":62.65},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,"WYCZYŚĆ DOKUMENT",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,"Opcja 1",{"$f":"IF(NOT(ISNUMBER(AE18)),\"\",IF(OR((AE18*10^-12)>=1,AE18<0),\"\",IF(TRIM(AB12)<>\"\",TRIM(AB12)&\" \",\"\")&IF(TRIM(AB11)<>\"\",TRIM(AB11)&\" \",\"\")&IF(TRIM(AB10)<>\"\",TRIM(AB10)&\" \",\"\")&IF(TRIM(AB9)<>\"\",TRIM(AB9)&\", \",\"\")&IF(TRIM(AB7)<>\"\",AB7&\" \",\"\")))","v":"sześćdziesiąt dwa złote, sześćdziesiąt pięć 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,"Opcja 2",{"$f":"IF(NOT(ISNUMBER(AE18)),\"\",IF(OR((AE18*10^-12)>=1,AE18<0),\"\",IF(TRIM(AB12)<>\"\",TRIM(AB12)&\" \",\"\")&IF(TRIM(AB11)<>\"\",TRIM(AB11)&\" \",\"\")&IF(TRIM(AB10)<>\"\",TRIM(AB10)&\" \",\"\")&IF(TRIM(AB9)<>\"\",TRIM(AB9)&\" \",\"\")&IF(TRIM(AB7)<>\"\",AB6&\" \",\"\")))","v":"sześćdziesiąt dwa złote 65/100 groszy "}]
[null,null,null,null,null,{"$f":"IF(AND(D16=\"\",E16=\"\")=TRUE,\"\",IF(D16=\"\",1*E16,D16*E16))","v":""},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,"a)","Obecna komórka to:",null,null,{"$f":"RIGHT(_xlfn.FORMULATEXT(AE18),LEN(_xlfn.FORMULATEXT(AE18))-1)","v":"F31"}]
[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":"F31","v":62.65}]
[null,null,null,null,null,{"$f":"IF(AND(D19=\"\",E19=\"\")=TRUE,\"\",IF(D19=\"\",1*E19,D19*E19))","v":""},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,"Część 1",{"$f":"TRIM(AB12&\" \"&AB11&\" \"&AB10&\" \"&AB9)","v":"sześćdziesiąt dwa złote"}]
[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":"AB7","v":"sześćdziesiąt pięć groszy"}]
[null,null,null,null,null,{"$f":"IF(AND(D22=\"\",E22=\"\")=TRUE,\"\",IF(D22=\"\",1*E22,D22*E22))","v":""}]
[]
[]
[null,null,null,null,null,{"$f":"IF(AND(D25=\"\",E25=\"\")=TRUE,\"\",IF(D25=\"\",1*E25,D25*E25))","v":""}]
[]
[]
[null,null,null,null,null,{"$f":"IF(AND(D28=\"\",E28=\"\")=TRUE,\"\",IF(D28=\"\",1*E28,D28*E28))","v":""}]
[]
[]
[null,"Biuro Rachunkowe Regina Janicka",null,null,"RAZEM:",{"$f":"IF(SUM(F13:H30)=0,\"\",SUM(F13:H30))","v":62.65}]
[null,"wersja dokumentu 2.0.1"]
[null,null,"Słownie:"]
[null,null,{"$f":"IF(F31=\"\",\"\",AB20)","v":"sześćdziesiąt dwa złote"},null,null,null,"Zaksięgowano pod"]
[null,null,null,null,null,null,"poz. nr ……………….."]
[null,null,{"$f":"IF(F31=\"\",\"\",AB21)","v":"sześćdziesiąt pięć groszy"}]
[]
[]
[]
[]
[null,"imię i nazwisko, podpis",null,null,null,"podpis"]
[null,"osoby dokonującej wydatku"]