{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Cennik","Arkusz1","Zamówienie","Excelblog.pl - Kwoty słownie","Arkusz2","Arkusz3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":10,"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":"Cennik","index":0,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["Kielnia do betonu komórkowego 100 mm",25,25,{"$f":"Zamówienie!AF41","v":50},{"$f":"IF($D$1>=300,C1,B1)","v":25}]
["Kielnia do betonu komórkowego 115 mm",25,25,null,{"$f":"IF($D$1>=300,C2,B2)","v":25}]
["Kielnia do betonu komórkowego 150 mm",25,25,null,25]
["Kielnia do betonu komórkowego 175 mm",25,25,null,25]
["Kielnia do betonu komórkowego 200 mm",25,25,null,25]
["Kielnia do betonu komórkowego 240 mm",35,35,null,35]
["Kielnia do betonu komórkowego 300 mm",35,35,null,35]
["Kielnia do betonu komórkowego 365 mm",35,35,null,35]
["Kielnia do betonu komórkowego 420 mm",45,45,null,45]
["Kielnia do betonu komórkowego 480 mm",45,45,null,45]
["Kielnia do betonu komórkowego 50 mm",25,25,null,25]
["Kielnia do betonu komórkowego 75 mm",25,25,null,25]
["Kielnia do silikatów 120 mm",25,25,null,25]
["Kielnia do silikatów 240/250 mm",35,35,null,35]
["Dozownik do silikatów 180 mm",160,160,null,160]
["Dozownik do silikatów 240/250 mm",190,190,null,190]
["Mieszadło kielichowe 100 mm",15,15,null,15]
["Młotek gumowy 90 mm",30,30,null,30]
["Paca z papierem ściernym 400 mm",30,30,null,30]
["Piła do betonu komórkowego",100,100,null,100]
["Rylec do betonu komórkowego",30,30,null,30]
["Zdzierak do betonu komórkowego z ząbkami",30,30,null,30]
["Przyrząd kątowy do cięcia ABK",30,30,null,30]
["Łącznik P30 (opak. 250 szt.)",325,325,null,325,null,{"$f":"_xlfn.CEILING.MATH(B24*1.05)","v":342}]
["Łącznik K1 (opak. 250 szt.)",390,390,null,390,null,{"$f":"_xlfn.CEILING.MATH(B25*1.05)","v":410}]
["Łącznik K2 (opak. 100 szt.)",315,315,null,315,null,331]
["Łącznik DS (opak. 100 szt.)",569,569,null,569,null,598]
["Łącznik D1 (opak. 100 szt.)",189,189,null,189,null,199]
["Łącznik D3 (opak. 250 szt.)",740,740,null,740,null,777]
["Kotwa KL-200/16 (ocynk)",52,52,null,52,null,55]
["Kotwa KL-200/20 (ocynk)",70,70,null,70,null,74]
["Taśma Murfor Compact I-50 (1 szt.)",215,215,null,{"$f":"IF($D$1>=300,C32,B32)","v":215},null,{"$f":"_xlfn.CEILING.MATH(B32*1.1)","v":237}]
["Taśma Murfor Compact I-100 (1 szt.)",300,300,null,300,null,{"$f":"_xlfn.CEILING.MATH(B33*1.1)","v":330}]
["Taśma Murfor Compact A-40",215,215,null,215,null,237]
["Taśma Murfor Compact A-80",300,300,null,300,null,330]
["Murfor EFS/Z-40 dł. 3050 mm (1 szt.) gr. ściany H+H ≥ 80 mm",43,43,null,43,null,{"$f":"_xlfn.CEILING.MATH(B36*1.15)","v":50}]
["Murfor EFS/Z-90 dł. 3050 mm (1 szt.) gr. ściany H+H ≥ 150 mm",43,43,null,43,null,{"$f":"_xlfn.CEILING.MATH(B37*1.15)","v":50}]
["Murfor EFS/Z-140 dł. 3050 mm (1 szt.) gr. ściany H+H ≥ 180 mm",43,43,null,43,null,50]
["Murfor EFS/Z-190 dł. 3050 mm (1 szt.) gr. ściany H+H ≥ 240 mm",43,43,null,43,null,50]

{"sheet":"Arkusz1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Zamówienie","index":2,"n_rows":103,"n_cols":32,"rows_kept":103,"cut":false,"hidden":false,"merged":[[57,0,57,36],[44,25,44,36],[45,31,46,36],[40,31,41,36],[45,25,46,30],[42,25,43,28],[42,31,43,36],[56,0,56,36],[47,0,47,36],[55,0,55,36],[54,0,54,36],[50,0,53,36],[45,0,46,24],[48,5,49,36],[48,0,49,4],[40,25,41,30],[42,29,43,30],[40,0,44,24],[38,12,38,26],[38,27,38,30],[37,2,37,6],[36,2,36,6],[36,0,36,1],[34,0,34,1],[37,0,37,1],[39,0,39,30],[39,31,39,36],[37,27,37,30],[37,31,37,36],[38,31,38,36],[36,31,36,36],[35,0,35,1],[35,31,35,36],[34,27,34,30],[35,27,35,30],[37,12,37,26],[36,12,36,26],[36,27,36,30],[38,0,38,1],[38,2,38,6],[38,7,38,11],[37,7,37,11],[0,0,3,15],[20,20,22,25],[20,18,22,19],[20,26,20,27],[32,0,32,1],[35,12,35,26],[34,12,34,26],[33,0,33,1],[33,12,33,26],[30,12,30,26],[35,2,35,6],[31,12,31,26],[25,0,25,18],[30,0,30,1],[31,0,31,1],[18,0,18,11],[20,0,20,11],[19,0,19,11],[26,0,26,18],[22,0,22,1],[22,2,22,11],[20,12,22,17],[18,12,19,12],[22,26,22,27],[6,35,6,36],[6,19,6,34],[5,12,5,36],[8,0,8,12],[9,0,9,12],[7,0,7,12],[11,0,11,12],[7,13,14,36],[5,0,5,11],[10,0,10,12],[13,0,13,12],[12,0,12,1],[12,2,12,12],[6,0,6,18],[14,0,17,11],[15,24,15,28],[16,24,16,28],[15,31,15,35],[16,31,16,35],[15,12,17,23],[17,24,17,30],[17,31,19,36],[21,26,21,36],[22,30,22,35],[23,0,23,36],[21,0,21,11],[15,36,16,36],[15,29,16,30],[18,13,19,30],[31,31,31,36],[30,27,30,30],[28,27,28,30],[27,27,27,30],[27,31,27,36],[29,31,29,36],[28,7,28,11],[28,12,28,26],[24,19,25,35],[27,7,27,11],[29,12,29,26],[26,19,26,35],[30,31,30,36],[28,31,28,36],[29,27,29,30],[24,0,24,18],[27,0,27,1],[28,0,28,1],[27,12,27,26],[29,0,29,1],[33,31,33,36],[32,27,32,30],[32,31,32,36],[32,12,32,26],[31,27,31,30],[34,31,34,36],[33,27,33,30],[27,2,27,6],[28,2,28,6],[36,7,36,11],[35,7,35,11],[34,7,34,11],[33,7,33,11],[32,7,32,11],[31,7,31,11],[30,7,30,11],[29,7,29,11],[34,2,34,6],[33,2,33,6],[32,2,32,6],[31,2,31,6],[30,2,30,6],[29,2,29,6]]}
["W celu złożenia zamówienia prosimy o wysłanie wypełnionego formularza drogą elektroniczną na adres instruktor@hplush.com"]
[]
[]
[]
[]
["Nabywca",null,null,null,null,null,null,null,null,null,null,null,"ver. 21 (2024_02)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zamówienie"]
[]
[]
[]
[]
[]
["tel."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nr zamówienia",null,null,null,null,null,null,"Data"]
[null,null,null,null,null,null,null,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":"TODAY()","v":"2024-01-31"}]
[]
["Adres wysyłki",null,null,null,null,null,null,null,null,null,null,null,null,"Warunki dostawy "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X",null,"Wysyłka",null,null,null,null,null,null,null,"X",null,"Pobranie / Gotówką"]
[]
["tel.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przedpłata"]
[]
["Informacje dodatkowe:"]
[]
[]
["Lp.",null,"Ilość",null,null,null,null,"JM",null,null,null,null,"Nazwa",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cena",null,null,null,"Wartość"]
[1,null,null,null,null,null,null,"szt.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(M29,Cennik!$A$1:$E$39,5,0),0)","v":0},null,null,null,{"$f":"C29*AB29","v":0}]
[2,null,null,null,null,null,null,"szt.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(M30,Cennik!$A$1:$E$39,5,0),0)","v":0},null,null,null,{"$f":"C30*AB30","v":0}]
[3,null,null,null,null,null,null,"szt.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(M31,Cennik!$A$1:$E$39,5,0),0)","v":0},null,null,null,{"$f":"C31*AB31","v":0}]
[4,null,null,null,null,null,null,"szt.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(M32,Cennik!$A$1:$E$39,5,0),0)","v":0},null,null,null,{"$f":"C32*AB32","v":0}]
[5,null,null,null,null,null,null,"szt.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(M33,Cennik!$A$1:$E$39,5,0),0)","v":0},null,null,null,{"$f":"C33*AB33","v":0}]
[6,null,null,null,null,null,null,"szt.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(M34,Cennik!$A$1:$E$39,5,0),0)","v":0},null,null,null,0]
[7,null,null,null,null,null,null,"szt.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(M35,Cennik!$A$1:$E$39,5,0),0)","v":0},null,null,null,{"$f":"C35*AB35","v":0}]
[8,null,null,null,null,null,null,"szt.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(M36,Cennik!$A$1:$E$39,5,0),0)","v":0},null,null,null,{"$f":"C36*AB36","v":0}]
[9,null,null,null,null,null,null,"szt.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(M37,Cennik!$A$1:$E$39,5,0),0)","v":0},null,null,null,{"$f":"C37*AB37","v":0}]
[10,null,null,null,null,null,null,"szt.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(M38,Cennik!$A$1:$E$39,5,0),0)","v":0},null,null,null,0]
[null,null,1,null,null,null,null,"szt.",null,null,null,null,"Koszty dostawy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF40>=250,0,50)","v":50},null,null,null,{"$f":"C39*AB39","v":50}]
[null,null,null,null,null,null,null,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":"SUM(AF29:AK38)","v":0}]
["Przy wartości zamówienia 250 PLN, koszt przesyłki wynosi 0,00 PLN.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Razem netto",null,null,null,null,null,{"$f":"SUM(AF29:AK39)","v":50}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAT %",null,null,null,23,null,{"$f":"AF41/100*23","v":11.5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Razem do zapłaty",null,null,null,null,null,{"$f":"AF41+AF43","v":61.5}]
[]
[]
["Słownie:",null,null,null,null,{"$f":"slownie","v":"sześćdziesiąt jeden złotych pięćdziesiąt groszy "}]
[]
[]
[]
[]
[]
["Sprzedawca:        H+H Polska Sp. z o.o. - ul. Kupiecka 6 - 03-046 Warszawa          NR NIP PL-5262851983"]
[]
["Bank:     Bank Millennium SA                                                     Konto PLN:  94 1160 2202 0000 0003 8108 0587"]
[]
[]
[]
[]
[]
[]
[]
["Kielnia do betonu komórkowego 100 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,15,"szt."]
["Kielnia do betonu komórkowego 115 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,15]
["Kielnia do betonu komórkowego 150 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,15]
["Kielnia do betonu komórkowego 175 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,20]
["Kielnia do betonu komórkowego 200 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,20]
["Kielnia do betonu komórkowego 240 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,20]
["Kielnia do betonu komórkowego 300 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,25]
["Kielnia do betonu komórkowego 365 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,25]
["Kielnia do betonu komórkowego 420 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,25]
["Kielnia do betonu komórkowego 480 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,25]
["Kielnia do betonu komórkowego 50 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,15]
["Kielnia do betonu komórkowego 75 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,15]
["Kielnia do silikatów 120 mm"]
["Kielnia do silikatów 240/250 mm"]
["Dozownik do silikatów 180 mm"]
["Dozownik do silikatów 240/250 mm"]
["Mieszadło kielichowe 100 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5]
["Młotek gumowy 90 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,10]
["Paca z papierem ściernym 400 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,25]
["Piła do betonu komórkowego",null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,80]
["Rylec do betonu komórkowego",null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,20]
["Zdzierak do betonu komórkowego z ząbkami",null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,20]
["Przyrząd kątowy do cięcia ABK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,20]
["Łącznik P30 (opak. 250 szt.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,215,215]
["Łącznik K1 (opak. 250 szt.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,215,215]
["Łącznik K2 (opak. 100 szt.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,135,135]
["Łącznik DS (opak. 100 szt.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,305,305]
["Łącznik D1 (opak. 100 szt.)"]
["Łącznik D3 (opak. 250 szt.)"]
["Kotwa KL-200/16 (ocynk)"]
["Kotwa KL-200/20 (ocynk)"]
["Taśma Murfor Compact I-50 (1 szt.)"]
["Taśma Murfor Compact I-100 (1 szt.)"]
["Taśma Murfor Compact A-40"]
["Taśma Murfor Compact A-80"]
["Murfor EFS/Z-40 dł. 3050 mm (1 szt.) gr. ściany H+H ≥ 80 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,21]
["Murfor EFS/Z-90 dł. 3050 mm (1 szt.) gr. ściany H+H ≥ 150 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,21]
["Murfor EFS/Z-140 dł. 3050 mm (1 szt.) gr. ściany H+H ≥ 180 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,21]
["Murfor EFS/Z-190 dł. 3050 mm (1 szt.) gr. ściany H+H ≥ 240 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,21]

{"sheet":"Excelblog.pl - Kwoty słownie","index":3,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["autor: Marcin Egert | www.excelblog.pl"]
[null,"Kwota:"]
["Kwota:",{"$f":"Zamówienie!AF46","v":61.5}]
[null,null,"Grosze 2","Grosze","Setki","Tysiące","Miliony","Miliardy"]
["Wiersz pomocniczy 1",null,null,{"$f":"ROUND((B3-INT(B3))*100,0)","v":50},{"$f":"IF(B3>=1,VALUE(RIGHT(LEFT(INT(B3),LEN(INT(B3))),3)),0)","v":61},{"$f":"IF(B3>=1000,VALUE(TEXT(RIGHT(LEFT(INT(B3),LEN(INT(B3))-3),3),\"000\")),0)","v":0},{"$f":"IF(B3>=1000000,VALUE(TEXT(RIGHT(LEFT(INT(B3),LEN(INT(B3))-6),3),\"000\")),0)","v":0},{"$f":"IF(B3>=1000000000,VALUE(TEXT(RIGHT(LEFT(INT(B3),LEN(INT(B3))-9),3),\"000\")),0)","v":0}]
["Wiersz pomocniczy 2",null,{"$f":"ROUND((B3-INT(B3))*100,0)&\"/\"&100 & \" groszy\"","v":"50/100 groszy"},{"$f":"IF(B3=0,\"\",IF(D5<=20,IF(D5=0,\"zero\",INDEX(excelblog_Jednosci,D5)),INDEX(excelblog_Dziesiatki,INT(D5/10))&IF(MOD(D5,10),\" \" &INDEX(excelblog_Jednosci,MOD(D5,10)),\"\")))& \" \" &IF(B3=0,\"\",INDEX(IF(D5<20,{\"groszy\";\"grosz\";\"grosze\";\"groszy\"},{\"groszy\";\"grosze\";\"groszy\"}),MATCH(IF(D5<20,D5,MOD(D5,10)),IF(D5<20,{0;1;2;5},{0;2;5}),1)))","v":"pięćdziesiąt groszy"},{"$f":"IF(OR(B3<1,INT(E5/100)=0),\"\",INDEX(excelblog_Setki,INT(E5/100)))& IF(E5-(INT(E5/100)*100)<=20,IF(E5-(INT(E5/100)*100)=0,IF(OR(E5>0,B3<1),\"\",\"złotych\"),\" \" &INDEX(excelblog_Jednosci,E5-(INT(E5/100)*100))),\" \" &INDEX(excelblog_Dziesiatki,INT((E5-(INT(E5/100)*100))/10))&IF(MOD((E5-(INT(E5/100)*100)),10),\" \"&INDEX(excelblog_Jednosci,MOD((E5-(INT(E5/100)*100)),10)),\"\"))&IF(E5=0,\"\",\" \" &INDEX(IF(E5<20,{\"złotych\";\"złoty\";\"złote\";\"złotych\"},{\"złotych\";\"złote\";\"złotych\"}),MATCH(IF(E5-(INT(E5/100)*100)<20,E5-(INT(E5/100)*100),MOD((E5-(INT(E5/100)*100)),10)),IF(E5<20,{0;1;2;5},{0;2;5}),1)))","v":" sześćdziesiąt jeden złotych"},{"$f":"IF(OR(B3<1,INT(F5/100)=0),\"\",INDEX(excelblog_Setki,INT(F5/100)))& IF(F5-(INT(F5/100)*100)<=20,IF(F5-(INT(F5/100)*100)=0,\"\",\" \" &INDEX(excelblog_Jednosci,F5-(INT(F5/100)*100))),\" \" &INDEX(excelblog_Dziesiatki,INT((F5-(INT(F5/100)*100))/10))&IF(MOD((F5-(INT(F5/100)*100)),10),\" \"&INDEX(excelblog_Jednosci,MOD((F5-(INT(F5/100)*100)),10)),\"\"))&IF(F5=0,\"\",\" \" &INDEX(IF(F5<20,{\"\";\"tysiąc\";\"tysiące\";\"tysięcy\"},{\"tysięcy\";\"tysiące\";\"tysięcy\"}),MATCH(IF(F5-(INT(F5/100)*100)<20,F5-(INT(F5/100)*100),MOD((F5-(INT(F5/100)*100)),10)),IF(F5<20,{0;1;2;5},{0;2;5}),1)))","v":""},{"$f":"IF(OR(B3<1,INT(G5/100)=0),\"\",INDEX(excelblog_Setki,INT(G5/100)))& IF(G5-(INT(G5/100)*100)<=20,IF(G5-(INT(G5/100)*100)=0,\"\",\" \" &INDEX(excelblog_Jednosci,G5-(INT(G5/100)*100))),\" \" &INDEX(excelblog_Dziesiatki,INT((G5-(INT(G5/100)*100))/10))&IF(MOD((G5-(INT(G5/100)*100)),10),\" \"&INDEX(excelblog_Jednosci,MOD((G5-(INT(G5/100)*100)),10)),\"\"))&IF(G5=0,\"\",\" \" &INDEX(IF(G5<20,{\"\";\"milion\";\"miliony\";\"milionów\"},{\"milionów\";\"miliony\";\"milionów\"}),MATCH(IF(G5-(INT(G5/100)*100)<20,G5-(INT(G5/100)*100),MOD((G5-(INT(G5/100)*100)),10)),IF(G5<20,{0;1;2;5},{0;2;5}),1)))","v":""},{"$f":"IF(OR(B3<1,INT(H5/100)=0),\"\",INDEX(excelblog_Setki,INT(H5/100)))& IF(H5-(INT(H5/100)*100)<=20,IF(H5-(INT(H5/100)*100)=0,\"\",\" \" &INDEX(excelblog_Jednosci,H5-(INT(H5/100)*100))),\" \" &INDEX(excelblog_Dziesiatki,INT((H5-(INT(H5/100)*100))/10))&IF(MOD((H5-(INT(H5/100)*100)),10),\" \"&INDEX(excelblog_Jednosci,MOD((H5-(INT(H5/100)*100)),10)),\"\"))&IF(H5=0,\"\",\" \" &INDEX(IF(H5<20,{\"\";\"miliard\";\"miliardy\";\"miliardów\"},{\"miliardów\";\"miliardy\";\"miliardów\"}),MATCH(IF(H5-(INT(H5/100)*100)<20,H5-(INT(H5/100)*100),MOD((H5-(INT(H5/100)*100)),10)),IF(H5<20,{0;1;2;5},{0;2;5}),1)))","v":""}]
[]
["Słownie v.1",{"$f":"IF(NOT(ISNUMBER(B3)),excelblog_Komunikat1,IF(OR((B3*10^-12)>=1,B3<0),excelblog_Komunikat2,IF(TRIM(H6)<>\"\",TRIM(H6)&\" \",\"\")&IF(TRIM(G6)<>\"\",TRIM(G6)&\" \",\"\")&IF(TRIM(F6)<>\"\",TRIM(F6)&\" \",\"\")&IF(TRIM(E6)<>\"\",TRIM(E6)&\" \",\"\")&IF(TRIM(D6)<>\"\",D6&\" \",\"\")))","v":"sześćdziesiąt jeden złotych pięćdziesiąt groszy "}]
["Słownie v.2",{"$f":"IF(NOT(ISNUMBER(B3)),excelblog_Komunikat1,IF(OR((B3*10^-12)>=1,B3<0),excelblog_Komunikat2,IF(TRIM(H6)<>\"\",TRIM(H6)&\" \",\"\")&IF(TRIM(G6)<>\"\",TRIM(G6)&\" \",\"\")&IF(TRIM(F6)<>\"\",TRIM(F6)&\" \",\"\")&IF(TRIM(E6)<>\"\",TRIM(E6)&\", \",\"\")&IF(TRIM(D6)<>\"\",D6&\" \",\"\")))","v":"sześćdziesiąt jeden złotych, pięćdziesiąt groszy "}]
["Słownie v.3",{"$f":"IF(NOT(ISNUMBER(B3)),excelblog_Komunikat1,IF(OR((B3*10^-12)>=1,B3<0),excelblog_Komunikat2,IF(TRIM(H6)<>\"\",TRIM(H6)&\" \",\"\")&IF(TRIM(G6)<>\"\",TRIM(G6)&\" \",\"\")&IF(TRIM(F6)<>\"\",TRIM(F6)&\" \",\"\")&IF(TRIM(E6)<>\"\",TRIM(E6)&\" \",\"\")&IF(TRIM(D6)<>\"\",C6&\" \",\"\")))","v":"sześćdziesiąt jeden złotych 50/100 groszy "}]
[]
[null,null,null,null,null,null,null,null,"Dostępne na licencji Creative Commons Uznanie autorstwa 2.5 Polska"]
[]
[]
[]
[null,"Kwota:"]
["Kwota:"]
[null,null,"Grosze 2","Grosze","Setki","Tysiące","Miliony","Miliardy"]
["Wiersz pomocniczy 1",null,null,{"$f":"ROUND((B17-INT(B17))*100,0)","v":0},{"$f":"IF(B17>=1,VALUE(RIGHT(LEFT(INT(B17),LEN(INT(B17))),3)),0)","v":0},{"$f":"IF(B17>=1000,VALUE(TEXT(RIGHT(LEFT(INT(B17),LEN(INT(B17))-3),3),\"000\")),0)","v":0},{"$f":"IF(B17>=1000000,VALUE(TEXT(RIGHT(LEFT(INT(B17),LEN(INT(B17))-6),3),\"000\")),0)","v":0},{"$f":"IF(B17>=1000000000,VALUE(TEXT(RIGHT(LEFT(INT(B17),LEN(INT(B17))-9),3),\"000\")),0)","v":0}]
["Wiersz pomocniczy 2",null,{"$f":"ROUND((B17-INT(B17))*100,0)&\"/\"&100 & \" groszy\"","v":"0/100 groszy"},{"$f":"IF(B17=0,\"\",IF(D19<=20,IF(D19=0,\"zero\",INDEX(excelblog_Jednosci,D19)),INDEX(excelblog_Dziesiatki,INT(D19/10))&IF(MOD(D19,10),\" \" &INDEX(excelblog_Jednosci,MOD(D19,10)),\"\")))& \" \" &IF(B17=0,\"\",INDEX(IF(D19<20,{\"groszy\";\"grosz\";\"grosze\";\"groszy\"},{\"groszy\";\"grosze\";\"groszy\"}),MATCH(IF(D19<20,D19,MOD(D19,10)),IF(D19<20,{0;1;2;5},{0;2;5}),1)))","v":" "},{"$f":"IF(OR(B17<1,INT(E19/100)=0),\"\",INDEX(excelblog_Setki,INT(E19/100)))& IF(E19-(INT(E19/100)*100)<=20,IF(E19-(INT(E19/100)*100)=0,IF(OR(E19>0,B17<1),\"\",\"złotych\"),\" \" &INDEX(excelblog_Jednosci,E19-(INT(E19/100)*100))),\" \" &INDEX(excelblog_Dziesiatki,INT((E19-(INT(E19/100)*100))/10))&IF(MOD((E19-(INT(E19/100)*100)),10),\" \"&INDEX(excelblog_Jednosci,MOD((E19-(INT(E19/100)*100)),10)),\"\"))&IF(E19=0,\"\",\" \" &INDEX(IF(E19<20,{\"złotych\";\"złoty\";\"złote\";\"złotych\"},{\"złotych\";\"złote\";\"złotych\"}),MATCH(IF(E19-(INT(E19/100)*100)<20,E19-(INT(E19/100)*100),MOD((E19-(INT(E19/100)*100)),10)),IF(E19<20,{0;1;2;5},{0;2;5}),1)))","v":""},{"$f":"IF(OR(B17<1,INT(F19/100)=0),\"\",INDEX(excelblog_Setki,INT(F19/100)))& IF(F19-(INT(F19/100)*100)<=20,IF(F19-(INT(F19/100)*100)=0,\"\",\" \" &INDEX(excelblog_Jednosci,F19-(INT(F19/100)*100))),\" \" &INDEX(excelblog_Dziesiatki,INT((F19-(INT(F19/100)*100))/10))&IF(MOD((F19-(INT(F19/100)*100)),10),\" \"&INDEX(excelblog_Jednosci,MOD((F19-(INT(F19/100)*100)),10)),\"\"))&IF(F19=0,\"\",\" \" &INDEX(IF(F19<20,{\"\";\"tysiąc\";\"tysiące\";\"tysięcy\"},{\"tysięcy\";\"tysiące\";\"tysięcy\"}),MATCH(IF(F19-(INT(F19/100)*100)<20,F19-(INT(F19/100)*100),MOD((F19-(INT(F19/100)*100)),10)),IF(F19<20,{0;1;2;5},{0;2;5}),1)))","v":""},{"$f":"IF(OR(B17<1,INT(G19/100)=0),\"\",INDEX(excelblog_Setki,INT(G19/100)))& IF(G19-(INT(G19/100)*100)<=20,IF(G19-(INT(G19/100)*100)=0,\"\",\" \" &INDEX(excelblog_Jednosci,G19-(INT(G19/100)*100))),\" \" &INDEX(excelblog_Dziesiatki,INT((G19-(INT(G19/100)*100))/10))&IF(MOD((G19-(INT(G19/100)*100)),10),\" \"&INDEX(excelblog_Jednosci,MOD((G19-(INT(G19/100)*100)),10)),\"\"))&IF(G19=0,\"\",\" \" &INDEX(IF(G19<20,{\"\";\"milion\";\"miliony\";\"milionów\"},{\"milionów\";\"miliony\";\"milionów\"}),MATCH(IF(G19-(INT(G19/100)*100)<20,G19-(INT(G19/100)*100),MOD((G19-(INT(G19/100)*100)),10)),IF(G19<20,{0;1;2;5},{0;2;5}),1)))","v":""},{"$f":"IF(OR(B17<1,INT(H19/100)=0),\"\",INDEX(excelblog_Setki,INT(H19/100)))& IF(H19-(INT(H19/100)*100)<=20,IF(H19-(INT(H19/100)*100)=0,\"\",\" \" &INDEX(excelblog_Jednosci,H19-(INT(H19/100)*100))),\" \" &INDEX(excelblog_Dziesiatki,INT((H19-(INT(H19/100)*100))/10))&IF(MOD((H19-(INT(H19/100)*100)),10),\" \"&INDEX(excelblog_Jednosci,MOD((H19-(INT(H19/100)*100)),10)),\"\"))&IF(H19=0,\"\",\" \" &INDEX(IF(H19<20,{\"\";\"miliard\";\"miliardy\";\"miliardów\"},{\"miliardów\";\"miliardy\";\"miliardów\"}),MATCH(IF(H19-(INT(H19/100)*100)<20,H19-(INT(H19/100)*100),MOD((H19-(INT(H19/100)*100)),10)),IF(H19<20,{0;1;2;5},{0;2;5}),1)))","v":""}]
[]
["Słownie v.1",{"$f":"IF(NOT(ISNUMBER(B17)),excelblog_Komunikat1,IF(OR((B17*10^-12)>=1,B17<0),excelblog_Komunikat2,IF(TRIM(H20)<>\"\",TRIM(H20)&\" \",\"\")&IF(TRIM(G20)<>\"\",TRIM(G20)&\" \",\"\")&IF(TRIM(F20)<>\"\",TRIM(F20)&\" \",\"\")&IF(TRIM(E20)<>\"\",TRIM(E20)&\" \",\"\")&IF(TRIM(D20)<>\"\",D20&\" \",\"\")))","v":"W polu z kwotą nie znajduje się liczba"}]
["Słownie v.2",{"$f":"IF(NOT(ISNUMBER(B17)),excelblog_Komunikat1,IF(OR((B17*10^-12)>=1,B17<0),excelblog_Komunikat2,IF(TRIM(H20)<>\"\",TRIM(H20)&\" \",\"\")&IF(TRIM(G20)<>\"\",TRIM(G20)&\" \",\"\")&IF(TRIM(F20)<>\"\",TRIM(F20)&\" \",\"\")&IF(TRIM(E20)<>\"\",TRIM(E20)&\", \",\"\")&IF(TRIM(D20)<>\"\",D20&\" \",\"\")))","v":"W polu z kwotą nie znajduje się liczba"}]
["Słownie v.3",{"$f":"IF(NOT(ISNUMBER(B17)),excelblog_Komunikat1,IF(OR((B17*10^-12)>=1,B17<0),excelblog_Komunikat2,IF(TRIM(H20)<>\"\",TRIM(H20)&\" \",\"\")&IF(TRIM(G20)<>\"\",TRIM(G20)&\" \",\"\")&IF(TRIM(F20)<>\"\",TRIM(F20)&\" \",\"\")&IF(TRIM(E20)<>\"\",TRIM(E20)&\" \",\"\")&IF(TRIM(D20)<>\"\",C20&\" \",\"\")))","v":"W polu z kwotą nie znajduje się liczba"}]
[]
[null,null,null,null,null,null,null,null,"Dostępne na licencji Creative Commons Uznanie autorstwa 2.5 Polska"]
[]
[]
[]
[null,"Kwota:"]
["Kwota:"]
[null,null,"Grosze 2","Grosze","Setki","Tysiące","Miliony","Miliardy"]
["Wiersz pomocniczy 1",null,null,{"$f":"ROUND((B31-INT(B31))*100,0)","v":0},{"$f":"IF(B31>=1,VALUE(RIGHT(LEFT(INT(B31),LEN(INT(B31))),3)),0)","v":0},{"$f":"IF(B31>=1000,VALUE(TEXT(RIGHT(LEFT(INT(B31),LEN(INT(B31))-3),3),\"000\")),0)","v":0},{"$f":"IF(B31>=1000000,VALUE(TEXT(RIGHT(LEFT(INT(B31),LEN(INT(B31))-6),3),\"000\")),0)","v":0},{"$f":"IF(B31>=1000000000,VALUE(TEXT(RIGHT(LEFT(INT(B31),LEN(INT(B31))-9),3),\"000\")),0)","v":0}]
["Wiersz pomocniczy 2",null,{"$f":"ROUND((B31-INT(B31))*100,0)&\"/\"&100 & \" groszy\"","v":"0/100 groszy"},{"$f":"IF(B31=0,\"\",IF(D33<=20,IF(D33=0,\"zero\",INDEX(excelblog_Jednosci,D33)),INDEX(excelblog_Dziesiatki,INT(D33/10))&IF(MOD(D33,10),\" \" &INDEX(excelblog_Jednosci,MOD(D33,10)),\"\")))& \" \" &IF(B31=0,\"\",INDEX(IF(D33<20,{\"groszy\";\"grosz\";\"grosze\";\"groszy\"},{\"groszy\";\"grosze\";\"groszy\"}),MATCH(IF(D33<20,D33,MOD(D33,10)),IF(D33<20,{0;1;2;5},{0;2;5}),1)))","v":" "},{"$f":"IF(OR(B31<1,INT(E33/100)=0),\"\",INDEX(excelblog_Setki,INT(E33/100)))& IF(E33-(INT(E33/100)*100)<=20,IF(E33-(INT(E33/100)*100)=0,IF(OR(E33>0,B31<1),\"\",\"złotych\"),\" \" &INDEX(excelblog_Jednosci,E33-(INT(E33/100)*100))),\" \" &INDEX(excelblog_Dziesiatki,INT((E33-(INT(E33/100)*100))/10))&IF(MOD((E33-(INT(E33/100)*100)),10),\" \"&INDEX(excelblog_Jednosci,MOD((E33-(INT(E33/100)*100)),10)),\"\"))&IF(E33=0,\"\",\" \" &INDEX(IF(E33<20,{\"złotych\";\"złoty\";\"złote\";\"złotych\"},{\"złotych\";\"złote\";\"złotych\"}),MATCH(IF(E33-(INT(E33/100)*100)<20,E33-(INT(E33/100)*100),MOD((E33-(INT(E33/100)*100)),10)),IF(E33<20,{0;1;2;5},{0;2;5}),1)))","v":""},{"$f":"IF(OR(B31<1,INT(F33/100)=0),\"\",INDEX(excelblog_Setki,INT(F33/100)))& IF(F33-(INT(F33/100)*100)<=20,IF(F33-(INT(F33/100)*100)=0,\"\",\" \" &INDEX(excelblog_Jednosci,F33-(INT(F33/100)*100))),\" \" &INDEX(excelblog_Dziesiatki,INT((F33-(INT(F33/100)*100))/10))&IF(MOD((F33-(INT(F33/100)*100)),10),\" \"&INDEX(excelblog_Jednosci,MOD((F33-(INT(F33/100)*100)),10)),\"\"))&IF(F33=0,\"\",\" \" &INDEX(IF(F33<20,{\"\";\"tysiąc\";\"tysiące\";\"tysięcy\"},{\"tysięcy\";\"tysiące\";\"tysięcy\"}),MATCH(IF(F33-(INT(F33/100)*100)<20,F33-(INT(F33/100)*100),MOD((F33-(INT(F33/100)*100)),10)),IF(F33<20,{0;1;2;5},{0;2;5}),1)))","v":""},{"$f":"IF(OR(B31<1,INT(G33/100)=0),\"\",INDEX(excelblog_Setki,INT(G33/100)))& IF(G33-(INT(G33/100)*100)<=20,IF(G33-(INT(G33/100)*100)=0,\"\",\" \" &INDEX(excelblog_Jednosci,G33-(INT(G33/100)*100))),\" \" &INDEX(excelblog_Dziesiatki,INT((G33-(INT(G33/100)*100))/10))&IF(MOD((G33-(INT(G33/100)*100)),10),\" \"&INDEX(excelblog_Jednosci,MOD((G33-(INT(G33/100)*100)),10)),\"\"))&IF(G33=0,\"\",\" \" &INDEX(IF(G33<20,{\"\";\"milion\";\"miliony\";\"milionów\"},{\"milionów\";\"miliony\";\"milionów\"}),MATCH(IF(G33-(INT(G33/100)*100)<20,G33-(INT(G33/100)*100),MOD((G33-(INT(G33/100)*100)),10)),IF(G33<20,{0;1;2;5},{0;2;5}),1)))","v":""},{"$f":"IF(OR(B31<1,INT(H33/100)=0),\"\",INDEX(excelblog_Setki,INT(H33/100)))& IF(H33-(INT(H33/100)*100)<=20,IF(H33-(INT(H33/100)*100)=0,\"\",\" \" &INDEX(excelblog_Jednosci,H33-(INT(H33/100)*100))),\" \" &INDEX(excelblog_Dziesiatki,INT((H33-(INT(H33/100)*100))/10))&IF(MOD((H33-(INT(H33/100)*100)),10),\" \"&INDEX(excelblog_Jednosci,MOD((H33-(INT(H33/100)*100)),10)),\"\"))&IF(H33=0,\"\",\" \" &INDEX(IF(H33<20,{\"\";\"miliard\";\"miliardy\";\"miliardów\"},{\"miliardów\";\"miliardy\";\"miliardów\"}),MATCH(IF(H33-(INT(H33/100)*100)<20,H33-(INT(H33/100)*100),MOD((H33-(INT(H33/100)*100)),10)),IF(H33<20,{0;1;2;5},{0;2;5}),1)))","v":""}]
[]
["Słownie v.1",{"$f":"IF(NOT(ISNUMBER(B31)),excelblog_Komunikat1,IF(OR((B31*10^-12)>=1,B31<0),excelblog_Komunikat2,IF(TRIM(H34)<>\"\",TRIM(H34)&\" \",\"\")&IF(TRIM(G34)<>\"\",TRIM(G34)&\" \",\"\")&IF(TRIM(F34)<>\"\",TRIM(F34)&\" \",\"\")&IF(TRIM(E34)<>\"\",TRIM(E34)&\" \",\"\")&IF(TRIM(D34)<>\"\",D34&\" \",\"\")))","v":"W polu z kwotą nie znajduje się liczba"}]
["Słownie v.2",{"$f":"IF(NOT(ISNUMBER(B31)),excelblog_Komunikat1,IF(OR((B31*10^-12)>=1,B31<0),excelblog_Komunikat2,IF(TRIM(H34)<>\"\",TRIM(H34)&\" \",\"\")&IF(TRIM(G34)<>\"\",TRIM(G34)&\" \",\"\")&IF(TRIM(F34)<>\"\",TRIM(F34)&\" \",\"\")&IF(TRIM(E34)<>\"\",TRIM(E34)&\", \",\"\")&IF(TRIM(D34)<>\"\",D34&\" \",\"\")))","v":"W polu z kwotą nie znajduje się liczba"}]
["Słownie v.3",{"$f":"IF(NOT(ISNUMBER(B31)),excelblog_Komunikat1,IF(OR((B31*10^-12)>=1,B31<0),excelblog_Komunikat2,IF(TRIM(H34)<>\"\",TRIM(H34)&\" \",\"\")&IF(TRIM(G34)<>\"\",TRIM(G34)&\" \",\"\")&IF(TRIM(F34)<>\"\",TRIM(F34)&\" \",\"\")&IF(TRIM(E34)<>\"\",TRIM(E34)&\" \",\"\")&IF(TRIM(D34)<>\"\",C34&\" \",\"\")))","v":"W polu z kwotą nie znajduje się liczba"}]
[]
[null,null,null,null,null,null,null,null,"Dostępne na licencji Creative Commons Uznanie autorstwa 2.5 Polska"]

{"sheet":"Arkusz2","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Arkusz3","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}