{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Kalkulator","Raty kredytowe","Pole ścian","$$","Prowizja handlowca","Składowe","Kalkulator cen MAX","Dane wejściowe","Baza (2)","Baza","Kredyt","Matryca","dotacja 18.07.","Matryca termo"],"not_rendered":{"charts":0,"images":5,"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":"Kalkulator","index":0,"n_rows":67,"n_cols":9,"rows_kept":67,"cut":false,"hidden":false,"merged":[[26,1,26,3],[25,1,25,3],[15,2,15,3],[16,2,16,3],[23,2,23,3],[19,1,19,3],[18,1,18,3],[22,1,22,3],[21,1,21,3],[7,2,7,3],[10,2,10,3],[12,2,12,3],[8,2,8,3],[14,2,14,3],[13,2,13,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[53,2,53,3],[37,2,37,3],[43,2,43,3],[36,1,36,3],[35,1,35,3],[41,1,41,3],[42,1,42,3],[30,2,30,3],[33,2,33,3],[32,2,32,3],[39,2,39,3],[31,2,31,3],[38,2,38,3],[44,2,44,3],[54,2,54,3],[52,1,52,3],[51,1,51,3],[55,2,55,3],[45,2,45,3]]}
[]
[]
[]
[]
[]
[]
[]
[null,"TYP BUDYNKU","powyżej 140 kWh/m2/rok",null,null,null,null,"Ilość lat kredytu:","Wpłata własna:"]
[null,"POZIOM DOTACJI","Najwyższy",null,{"$f":"IF(AND(OR($C$8='Dane wejściowe'!$A$2,Kalkulator!$C$8='Dane wejściowe'!$A$3),$C$9='Dane wejściowe'!$B$2),\"<- Podwyższony\",\"\")","v":""},null,null,5]
[null,null,null,null,null,null," "]
[null,"AUDYT + ŚWIADECTWO CHARAKTERYSTYKI","TAK"]
[null,null,null,null,null,null,null,"MAX DOTACJA CZYSTE POWIETRZE",{"$f":"Matryca!N13","v":124000}]
[null,"PC/KOCIOŁ","TAK",null,null,null,null,"WYKORZYSTNA DOTACJA CZYSTE POWIETRZE",{"$f":"IF($C$9='Dane wejściowe'!$B$3,MIN($I$12,'dotacja 18.07.'!I3),_xlfn.IFS(Matryca!N3=\"Nie dotyczy\",Matryca!N13,Matryca!N3<('dotacja 18.07.'!I3),Matryca!N3,Matryca!N3>=('dotacja 18.07.'!I3),'dotacja 18.07.'!I3))","v":20500}]
[null,{"$f":"IF($C$13='Dane wejściowe'!$D$2,'Dane wejściowe'!$E$1,\"\")","v":"Źródło grzewcze"},"Kocioł na pellet"]
[null,{"$f":"IF(AND($C$13=\"TAK\",$C$14<>\"Pompa Ciepła\"),\"Zasobnik CWU\",\"\")","v":"Zasobnik CWU"},{"$f":"IF(B15=\"Zasobnik CWU\",\"TAK\",\"\")","v":"TAK"},null,null,null,null,"AUDYT + ŚWIADECTWO CHARAKTERYSTYKI",{"$f":"IF($I$19=0,\"\",IF($C$11=\"NIE\",0,3075))","v":3075}]
[null,{"$f":"IF($C$13=\"TAK\",\"Modernizacja CO\",\"\")","v":"Modernizacja CO"},"WYMIANA GRZEJNIKÓW"]
[null,{"$f":"IF($C$13=\"TAK\",\"Ilość Grzejników (szt.)\",\"\")","v":"Ilość Grzejników (szt.)"},0,null,null,null,null,"CENA NETTO",{"$f":"IF(OR(E29=\"<- Zmień materiał !\",E32=\"<- Wybierz TAK lub NIE !\"),\"\",'Baza (2)'!F4)","v":25000}]
[null,null,null,null,null,null,null,"VAT",{"$f":"IF(I17=\"\",\"\",'Baza (2)'!F6)","v":2000}]
[null,"TERMOMODERNIZACJA",null,null,null,null,null,"CENA BRUTTO",{"$f":"IF(I17=\"\",\"\",IF(AND(Kalkulator!$C$8='Dane wejściowe'!$A$4,Kalkulator!$B$20='Dane wejściowe'!$F$3),0,'Baza (2)'!F8))","v":27000}]
[null,"TAK",null,null,{"$f":"IF(AND($C$8='Dane wejściowe'!$A$4,$B$20<>'Dane wejściowe'!$F$2),\"<- TAK\",\"\")","v":""}]
[null,null,null,null,null,null,null,"Wpłata własna klienta",{"$f":"'Baza (2)'!F28","v":9575}]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$2,'Dane wejściowe'!$G$1,\"\")","v":"REKUPERACJA"}]
[null,"NIE",null,null,null,null,null,"MARŻA DODATKOWA",0]
[null,{"$f":"IF($B$23=\"TAK\",\"Ilość rekuperatorów ściennych (szt.)\",\"\")","v":""},4]
[]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$2,'Dane wejściowe'!$I$1,\"\")","v":"OCIEPLENIE DACH STROP"}]
[null,"NIE"]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF($B$27='Dane wejściowe'!$I$2,'Dane wejściowe'!$J$1,\"\"))","v":""},"Strop"]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF($B$27='Dane wejściowe'!$I$2,'Dane wejściowe'!$K$1,\"\"))","v":""},"STYROPAPA"]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF($B$27='Dane wejściowe'!$I$2,'Dane wejściowe'!$L$1,\"\"))","v":""},1]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF(AND($B$27='Dane wejściowe'!$I$2,$C$28=\"Dach\"),\"Uchwyty GK\",IF(AND($B$27='Dane wejściowe'!$I$2,$C$28=\"Strop\"),\"\",\"\")))","v":""},"NIE"]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF(AND($B$27='Dane wejściowe'!$I$2,$C$28=\"Dach\"),\"Membrana paroprzepuszczalna\",IF(AND($B$27='Dane wejściowe'!$I$2,$C$28=\"Strop\",$C$29=\"STYROPAPA\"),\"Murowanie ogniomurów + przełożenie rynien (mb)\",\"\")))","v":""},0,null,{"$f":"H32","v":""},null,null,{"$f":"IFERROR(_xlfn.IFS($B$32=\"Murowanie ogniomurów + przełożenie rynien (mb)\",\"<- Wpisz ilość mb !\",$B$32=\"Membrana paroprzepuszczalna\",\"<- Wpisz TAK lub NIE !\"),\"\")","v":""}]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF(AND($B$27='Dane wejściowe'!$I$2,$C$28=\"Strop\",$C$29=\"STYROPAPA\"),\"Opierzenie (mb)\",\"\"))","v":""}]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF(AND($B$27='Dane wejściowe'!$I$2,$C$28=\"Strop\",$C$29=\"STYROPAPA\"),\"Murowanie komina (szt.)\",\"\"))","v":""}]
[]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$2,'Dane wejściowe'!$N$1,\"\")","v":"OCIEPLENIE ŚCIAN ZEWNĘTRZNYCH - STYROPIAN + TYNK"}]
[null,"NIE"]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF($B$37='Dane wejściowe'!$N$2,'Dane wejściowe'!$O$1,\"\"))","v":""},1]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF($B$37='Dane wejściowe'!$N$2,\"Parapety zewnętrzne (mb)\",\"\"))","v":""},1]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF($B$37='Dane wejściowe'!$N$2,\"Przedłużenie dachu - opierzenie (mb)\",\"\"))","v":""},1]
[]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$2,'Dane wejściowe'!$Q$1,\"\")","v":"DRZWI"}]
[null,"NIE"]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF($B$43='Dane wejściowe'!$Q$2,'Dane wejściowe'!$R$1,\"\"))","v":""},1]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF($B$43='Dane wejściowe'!$Q$2,\"Model drzwi\",\"\"))","v":""},"Pełne"]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF($B$43='Dane wejściowe'!$Q$2,\"SUMA POWIERZCHNI DRZWI\",\"\"))","v":""},{"$f":"IF($C$44=1,PRODUCT($C$48:$D$48),IF($C$44=2,SUM(PRODUCT($C$48:$D$48),PRODUCT($C$49:$D$49)),IF($C$44=3,SUM(PRODUCT($C$48:$D$48),PRODUCT($C$49:$D$49),PRODUCT($C$50:$D$50)),\"\")))","v":1}]
[null,null,{"$f":"IF($B$43='Dane wejściowe'!$Q$2,'Dane wejściowe'!$T$2,\"\")","v":""},{"$f":"IF($B$43='Dane wejściowe'!$Q$2,'Dane wejściowe'!$T$3,\"\")","v":""}]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF(AND($B$43='Dane wejściowe'!$Q$2,$C$44>='Dane wejściowe'!$R$2),'Dane wejściowe'!$S$2,\"\"))","v":""},1,1]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF(AND($B$43='Dane wejściowe'!$Q$2,$C$44>='Dane wejściowe'!$R$3),'Dane wejściowe'!$S$3,\"\"))","v":""}]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF(AND($B$43='Dane wejściowe'!$Q$2,$C$44>='Dane wejściowe'!$R$4),'Dane wejściowe'!$S$4,\"\"))","v":""}]
[]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$2,'Dane wejściowe'!$V$1,\"\")","v":"OKNA"}]
[null,"NIE"]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF($B$53='Dane wejściowe'!$V$2,'Dane wejściowe'!$W$1,\"\"))","v":""},1]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF($B$53='Dane wejściowe'!$V$2,\"Kolor Okien\",\"\"))","v":""},"Białe"]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF($B$53='Dane wejściowe'!$V$2,\"SUMA POWIERZCHNI OKIEN\",\"\"))","v":""},{"$f":"IF($C$54=1,PRODUCT($C$58:$D$58),IF($C$54=2,SUM(PRODUCT($C$58:$D$58),PRODUCT($C$59:$D$59)),IF($C$54=3,SUM(PRODUCT($C$58:$D$58),PRODUCT($C$59:$D$59),PRODUCT($C$60:$D$60)),IF($C$54=4,SUM(PRODUCT($C$58:$D$58),PRODUCT($C$59:$D$59),PRODUCT($C$60:$D$60),PRODUCT($C$61:$D$61)),IF($C$54=5,SUM(PRODUCT($C$58:$D$58),PRODUCT($C$59:$D$59),PRODUCT($C$60:$D$60),PRODUCT($C$61:$D$61),PRODUCT($C$62:$D$62)),IF($C$54=6,SUM(PRODUCT($C$58:$D$58),PRODUCT($C$59:$D$59),PRODUCT($C$60:$D$60),PRODUCT($C$61:$D$61),PRODUCT($C$62:$D$62),PRODUCT($C$63:$D$63)),IF($C$54=7,SUM(PRODUCT($C$58:$D$58),PRODUCT($C$59:$D$59),PRODUCT($C$60:$D$60),PRODUCT($C$61:$D$61),PRODUCT($C$62:$D$62),PRODUCT($C$63:$D$63),PRODUCT($C$64:$D$64)),IF($C$54=8,SUM(PRODUCT($C$58:$D$58),PRODUCT($C$59:$D$59),PRODUCT($C$60:$D$60),PRODUCT($C$61:$D$61),PRODUCT($C$62:$D$62),PRODUCT($C$63:$D$63),PRODUCT($C$64:$D$64),PRODUCT($C$65:$D$65)),IF($C$54=9,SUM(PRODUCT($C$58:$D$58),PRODUCT($C$59:$D$59),PRODUCT($C$60:$D$60),PRODUCT($C$61:$D$61),PRODUCT($C$62:$D$62),PRODUCT($C$63:$D$63),PRODUCT($C$64:$D$64),PRODUCT($C$65:$D$65),PRODUCT($C$66:$D$66)),IF($C$54=10,SUM(PRODUCT($C$58:$D$58),PRODUCT($C$59:$D$59),PRODUCT($C$60:$D$60),PRODUCT($C$61:$D$61),PRODUCT($C$62:$D$62),PRODUCT($C$63:$D$63),PRODUCT($C$64:$D$64),PRODUCT($C$65:$D$65),PRODUCT($C$66:$D$66),PRODUCT($C$67:$D$67)),\"\"))))))))))","v":1}]
[null,null,{"$f":"IF($B$53='Dane wejściowe'!$V$2,'Dane wejściowe'!$Y$2,\"\")","v":""},{"$f":"IF($B$53='Dane wejściowe'!$V$2,'Dane wejściowe'!$Y$3,\"\")","v":""}]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF(AND($B$53='Dane wejściowe'!$V$2,$C$54>='Dane wejściowe'!$W$2),'Dane wejściowe'!$X$2,\"\"))","v":""},1,1]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF(AND($B$53='Dane wejściowe'!$V$2,$C$54>='Dane wejściowe'!$W$3),'Dane wejściowe'!$X$3,\"\"))","v":""},1,20]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF(AND($B$53='Dane wejściowe'!$V$2,$C$54>='Dane wejściowe'!$W$4),'Dane wejściowe'!$X$4,\"\"))","v":""},0,0]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF(AND($B$53='Dane wejściowe'!$V$2,$C$54>='Dane wejściowe'!$W$5),'Dane wejściowe'!$X$5,\"\"))","v":""},0,0]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF(AND($B$53='Dane wejściowe'!$V$2,$C$54>='Dane wejściowe'!$W$6),'Dane wejściowe'!$X$6,\"\"))","v":""},0,0]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF(AND($B$53='Dane wejściowe'!$V$2,$C$54>='Dane wejściowe'!$W$7),'Dane wejściowe'!$X$7,\"\"))","v":""},0,0]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF(AND($B$53='Dane wejściowe'!$V$2,$C$54>='Dane wejściowe'!$W$8),'Dane wejściowe'!$X$8,\"\"))","v":""},0,0]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF(AND($B$53='Dane wejściowe'!$V$2,$C$54>='Dane wejściowe'!$W$9),'Dane wejściowe'!$X$9,\"\"))","v":""},0,0]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF(AND($B$53='Dane wejściowe'!$V$2,$C$54>='Dane wejściowe'!$W$10),'Dane wejściowe'!$X$10,\"\"))","v":""},0,0]
[null,{"$f":"IF($B$20='Dane wejściowe'!$F$3,\"\",IF(AND($B$53='Dane wejściowe'!$V$2,$C$54>='Dane wejściowe'!$W$11),'Dane wejściowe'!$X$11,\"\"))","v":""},0,0]

{"sheet":"Raty kredytowe","index":1,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[9,2,9,3],[9,5,9,6],[9,8,9,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Inbank - kredyt do 10 lat",null,null,"Santander  - kredyt do 10 lat",null,null,"Cofidis  - kredyt do 10 lat"]
[null,null,"Ilość lat",{"$f":"Kredyt!J2","v":5},null,"Ilość lat",{"$f":"Kredyt!J3","v":5},null,"Ilość lat",{"$f":"Kredyt!J4","v":5}]
[null,null,"Cena instalacji brutto",{"$f":"Kredyt!E2","v":9575},null,"Cena instalacji brutto",{"$f":"Kredyt!E3","v":9575},null,"Cena instalacji brutto",{"$f":"Kredyt!E4","v":9575}]
[null,null,"Wkład własny",{"$f":"Kredyt!F2","v":0},null,"Wkład własny",{"$f":"Kredyt!F3","v":0},null,"Wkład własny",{"$f":"Kredyt!F4","v":0}]
[null,null,"Kwota kredytu",{"$f":"Kredyt!G2","v":9575},null,"Kwota kredytu",{"$f":"Kredyt!G3","v":9575},null,"Kwota kredytu",{"$f":"Kredyt!G4","v":9575}]
[null,null,"Maksymalna kwota kredytu",100000,null,"Maksymalna kwota kredytu",80000,null,"Maksymalna kwota kredytu",100000]
[null,null,"RATA MIESIĘCZNA",{"$f":"Kredyt!M2","v":253.09916666666669},null,"RATA MIESIĘCZNA",{"$f":"Kredyt!M3","v":250.46604166985833},null,"RATA MIESIĘCZNA",{"$f":"Kredyt!M4","v":260.67937500000005}]

{"sheet":"Pole ścian","index":2,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[38,5,39,6],[38,7,39,7],[40,5,41,6],[40,7,41,7],[42,5,44,6],[42,7,44,7],[11,1,12,8],[34,1,35,8],[22,5,23,6],[18,7,19,7],[20,7,21,7],[22,7,23,7],[24,7,26,7],[24,5,26,6],[18,5,19,6],[20,5,21,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ściana boczna sczytowa"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"wymiar a",null,1]
[]
[null,null,null,null,null,"wymiar b",null,2]
[]
[null,null,null,null,null,"wymiar h",null,3]
[]
[null,null,null,null,null,"Pole ściany",null,{"$f":"IF(OR(H19=\"\",H21=\"\",H23=\"\"),\"UZUPEŁNIJ WSZYSTKIE WYMIARY !\",H19*H21+(0.5*H19*(H23-H21)))","v":2.5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ściana boczna"]
[]
[]
[]
[null,null,null,null,null,"wymiar a",null,1]
[]
[null,null,null,null,null,"wymiar b",null,1]
[]
[null,null,null,null,null,"Pole ściany",null,{"$f":"IF(OR(H39=\"\",H41=\"\"),\"UZUPEŁNIJ WSZYSTKIE WYMIARY !\",H39*H41)","v":1}]

{"sheet":"$$","index":3,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[10,1,11,3],[10,4,11,5],[12,1,14,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Poziom prowizyjny",null,null,"Manager"]
[]
[null,{"$f":"VLOOKUP(E11,'Prowizja handlowca'!$A$2:$C$4,3,FALSE)","v":6000}]

{"sheet":"Prowizja handlowca","index":4,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":true,"merged":[[9,5,11,5],[9,6,11,6],[9,7,11,7],[9,4,11,4]]}
[]
["Hunter",0.25,{"$f":"$H$9*B2+$H$13","v":2500}]
["Doradca",0.4,{"$f":"$H$9*B3+$H$13","v":4000}]
["Manager",0.6,{"$f":"$H$9*B4+$H$13","v":6000}]
[]
[]
[]
[]
[null,null,"(+) Termo",null,null,null,"SUMA",{"$f":"SUM(H10)","v":10000}]
["Pompa Ciepła",7000,15000,null,{"$f":"Kalkulator!B20","v":"TAK"},{"$f":"Kalkulator!C13","v":"TAK"},{"$f":"Kalkulator!C14","v":"Kocioł na pellet"},{"$f":"IF(AND(E10=\"TAK\",F10=\"TAK\"),VLOOKUP(G10,A10:C12,3,FALSE),IF(AND(E10=\"TAK\",F10=\"NIE\"),B13,IF(AND(E10=\"NIE\",F10=\"TAK\"),VLOOKUP(G10,A10:B12,2,FALSE),0)))","v":10000}]
["Kocioł na pellet",4000,10000]
["Piec zagazowujący drewno",4000,10000]
["Termomodernizacja",5000,null,null,null,null,{"$f":"Kalkulator!H23","v":"MARŻA DODATKOWA"},{"$f":"IF(AND(E10=\"NIE\",F10=\"NIE\"),0,Kalkulator!I23)","v":0}]

{"sheet":"Składowe","index":5,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[[23,11,23,12],[13,0,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[16,0,16,6],[15,0,15,6],[18,0,18,6],[15,7,15,8],[14,0,14,6],[14,7,14,8],[30,0,30,3],[30,4,30,5],[31,0,31,3],[31,4,31,5],[10,15,10,16],[28,0,28,3],[28,4,28,5],[29,0,29,3],[29,4,29,5],[24,9,24,10],[24,11,24,12],[24,13,24,14],[24,15,24,16],[24,0,24,6],[24,7,24,8],[21,9,21,10],[11,13,11,14],[18,9,18,10],[18,11,18,12],[18,13,18,14],[19,9,19,10],[15,9,15,10],[15,11,15,12],[15,13,15,14],[14,9,14,10],[14,11,14,12],[14,13,14,14],[12,11,12,12],[12,9,12,10],[9,15,9,16],[11,7,11,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[11,15,11,16],[18,15,18,16],[19,11,19,12],[19,13,19,14],[9,7,9,8],[9,9,9,10],[9,11,9,12],[9,13,9,14],[10,13,10,14],[12,13,12,14],[12,15,12,16],[10,9,10,10],[10,11,10,12],[11,9,11,10],[11,11,11,12],[12,0,12,6],[11,0,11,6],[10,7,10,8],[12,7,12,8],[14,15,14,16],[19,0,19,6],[20,0,20,6],[21,0,21,6],[22,0,22,6],[21,7,21,8],[22,7,22,8],[19,15,19,16],[20,9,20,10],[20,11,20,12],[20,13,20,14],[20,15,20,16],[21,11,21,12],[21,13,21,14],[21,15,21,16],[22,9,22,10],[26,0,26,6],[16,9,16,10],[26,9,26,10],[15,15,15,16],[22,11,22,12],[22,13,22,14],[22,15,22,16],[25,11,25,12],[25,13,25,14],[25,15,25,16],[25,0,25,6],[25,7,25,8],[25,9,25,10],[23,0,23,6],[23,7,23,8],[23,9,23,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Powierzchnia",null,"Koszt brutto",null,"Koszt netto",null,"Dofinansowanie",null,"VAT"]
[]
[{"$f":"Kalkulator!C14","v":"Kocioł na pellet"},null,null,null,null,null,null,"-",null,{"$f":"'Baza (2)'!$I$5-J13","v":27000},null,{"$f":"'Baza (2)'!$I$8-L13","v":25000},null,{"$f":"'dotacja 18.07.'!I4","v":20500},null,{"$f":"J12-L12","v":2000}]
["Modernizacja CO i CWU",null,null,null,null,null,null,"-",null,{"$f":"L13*1.08","v":0},null,{"$f":"'Baza (2)'!G35+'Baza (2)'!I35","v":0},null,{"$f":"'dotacja 18.07.'!I16","v":0},null,{"$f":"J13-L13","v":0}]
["AUDYT ENERGETYCZNY",null,null,null,null,null,null,null,null,{"$f":"Kalkulator!$I$15-492","v":2583},null,{"$f":"J14/1.23","v":2100}]
["ŚWIADECTWO CHARAKTERYSTYKI ENERGETYCZNEJ",null,null,null,null,null,null,"-",null,{"$f":"Kalkulator!$I$15-1476","v":1599},null,{"$f":"J15/1.23","v":1300},null,{"$f":"Baza!N25","v":0},null,{"$f":"J15-L15","v":299}]
["Suma",null,null,null,null,null,null,"-",null,{"$f":"IF('Baza (2)'!T1='Baza (2)'!A12,SUM(Składowe!J12:K13)+Kalkulator!$I$15,SUM(Składowe!J12:K13))","v":27000},null,{"$f":"IF('Baza (2)'!T1='Baza (2)'!A12,SUM(Składowe!L12:M13)+(Kalkulator!$I$15/1.23),SUM(Składowe!L12:M13))","v":25000},null,{"$f":"IF('Baza (2)'!T4='Baza (2)'!A12,SUM(Składowe!N12:O13),SUM(Składowe!N12:O13))","v":20500},null,{"$f":"IF('Baza (2)'!T4='Baza (2)'!A12,SUM(Składowe!P12:Q13)+(J15-L15),SUM(Składowe!P12:Q13))","v":2299}]
["Wysokość wpłaty własnej",null,null,null,null,null,null,null,null,{"$f":"(J16-N16)","v":6500}]
[]
["Rekuperacja",null,null,null,null,null,null,"-",null,{"$f":"'Baza (2)'!J5","v":0},null,{"$f":"'Baza (2)'!J8","v":0},null,{"$f":"'Baza (2)'!N20","v":0},null,{"$f":"J19-L19","v":0}]
["Dach/stropodach/strop pod nieogrzewanym poddaszem",null,null,null,null,null,null,{"$f":"Kalkulator!C30","v":1},null,{"$f":"'Baza (2)'!K5","v":0},null,{"$f":"'Baza (2)'!K8","v":0},null,{"$f":"'Baza (2)'!N21","v":0},null,0]
["Ściany zewnętrzne/przegrody pionowe",null,null,null,null,null,null,{"$f":"Kalkulator!C38","v":1},null,{"$f":"'Baza (2)'!L5","v":0},null,{"$f":"'Baza (2)'!L8","v":0},null,{"$f":"'Baza (2)'!N22","v":0},null,0]
["Stolarka okienna",null,null,null,null,null,null,{"$f":"Kalkulator!C56","v":1},null,{"$f":"'Baza (2)'!N5","v":0},null,{"$f":"'Baza (2)'!N8","v":0},null,{"$f":"'Baza (2)'!N23","v":0},null,0]
["Stolarka drzwiowa – drzwi zewnętrzne",null,null,null,null,null,null,{"$f":"Kalkulator!C46","v":1},null,{"$f":"'Baza (2)'!M5","v":0},null,{"$f":"'Baza (2)'!M8","v":0},null,{"$f":"'Baza (2)'!N24","v":0},null,0]
["AUDYT ENERGETYCZNY",null,null,null,null,null,null,null,null,{"$f":"IF(AND(Kalkulator!$C$11=\"TAK\",Kalkulator!$I$15=\"\"),2460,Kalkulator!$I$15-615)","v":2460},null,{"$f":"$J$24/1.23","v":2000}]
["ŚWIADECTWO CHARAKTERYSTYKI ENERGETYCZNEJ",null,null,null,null,null,null,"-",null,{"$f":"IF(AND(Kalkulator!$C$11=\"TAK\",Kalkulator!$I$15=\"\"),615,Kalkulator!$I$15-2460)","v":615},null,{"$f":"$J$25/1.23","v":500},null,{"$f":"Baza!N25","v":0},null,{"$f":"J25-L25","v":115}]
["Suma",null,null,null,null,null,null,"-",null,{"$f":"SUM(J19:K23,J24:K25)","v":3075},null,{"$f":"SUM(L19:M23,L24:M25)","v":2500},null,{"$f":"SUM(N19:O23)","v":0},null,{"$f":"SUM(P19:Q23)+(J25-L25)","v":115}]
["Wysokość wpłaty własnej",null,null,null,null,null,null,null,null,{"$f":"(J26-N26)","v":3075}]
[]
["Kwota brutto",null,null,null,{"$f":"Kalkulator!I19","v":27000}]
["Kwota netto",null,null,null,{"$f":"Kalkulator!I17","v":25000}]
["Dofinansowanie",null,null,null,{"$f":"Kalkulator!I13","v":20500}]
["Wpłata własna klienta",null,null,null,{"$f":"Kalkulator!I21","v":9575}]

{"sheet":"Kalkulator cen MAX","index":6,"n_rows":108,"n_cols":10,"rows_kept":108,"cut":false,"hidden":true,"merged":[[3,0,3,3],[14,0,14,3]]}
[]
["Poziom dofinansowania","Najwyższy"]
[]
["Źródło Ciepła"]
[null,"ilość","Wartość umowy netto","Wartość umowy brutto","Cena netto","Cena brutto",null,3,"Poziom dofinansowania (pompa/kocioł)"]
["Pompa Ciepła",null,{"$f":"B6*E6","v":0},{"$f":"B6*F6","v":0},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E31,IF($B$2=\"Podwyższony\",'Matryca termo'!G31))","v":35200},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F31,IF($B$2=\"Podwyższony\",'Matryca termo'!H31))","v":38016},null,null,"Maksymalna kwota dotacji","Kwota dotacji klienta"]
["Kocioł zgazowujący ",null,0,0,{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E32,IF($B$2=\"Podwyższony\",'Matryca termo'!G32))","v":20500},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F32,IF($B$2=\"Podwyższony\",'Matryca termo'!H32))","v":22140},null,"Pompa ciepła",55700,{"$f":"IF(H5=1,'Matryca termo'!K21,IF(H5=2,'Matryca termo'!K22,IF(H5=3,'Matryca termo'!K23)))","v":55700}]
["Kocioł na pellet",null,0,0,{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E33,IF($B$2=\"Podwyższony\",'Matryca termo'!G33))","v":20500},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F33,IF($B$2=\"Podwyższony\",'Matryca termo'!H33))","v":22140},null,"Kocioł",41000,{"$f":"IF(H5=1,'Matryca termo'!G21,IF(H5=2,'Matryca termo'!G22,IF(H5=3,'Matryca termo'!G23)))","v":41000}]
["CO/CWU",null,0,0,{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E34,IF($B$2=\"Podwyższony\",'Matryca termo'!G34))","v":20500},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F34,IF($B$2=\"Podwyższony\",'Matryca termo'!H34))","v":22140}]
["Audyt energetyczny i świadectwo",null,0,0,{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E47,IF($B$2=\"Podwyższony\",'Matryca termo'!G47))","v":1600},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F47,IF($B$2=\"Podwyższony\",'Matryca termo'!H47))","v":1968},null,9,"Przedział klienta (dofinansowanie + efektywność)"]
["Rekuperacja",null,0,0,{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E44,IF($B$2=\"Podwyższony\",'Matryca termo'!G44))","v":2000},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F44,IF($B$2=\"Podwyższony\",'Matryca termo'!H44))","v":2160},null,null,"Maksymalna kwota dotacji","Kwota dotacji klienta"]
[null,null,null,null,null,null,null,"Pompa + Termo",140300,{"$f":"IF(H10=1,'Matryca termo'!J1,IF(H10=2,'Matryca termo'!J2,IF(H10=3,'Matryca termo'!J3,IF(H10=4,'Matryca termo'!J4,IF(H10=5,'Matryca termo'!J5,IF(H10=6,'Matryca termo'!J6,IF(H10=7,'Matryca termo'!J7,IF(H10=8,'Matryca termo'!J8,IF(H10=9,'Matryca termo'!J9)))))))))","v":141900}]
["Wartość umowy",null,{"$f":"SUM(C6:C11)","v":0},{"$f":"SUM(D6:D11)","v":0},null,null,null,"Kocioł + Termo",125600,{"$f":"IF(H10=1,'Matryca termo'!F1,IF(H10=2,'Matryca termo'!F2,IF(H10=3,'Matryca termo'!F3,IF(H10=4,'Matryca termo'!F4,IF(H10=5,'Matryca termo'!F5,IF(H10=6,'Matryca termo'!F6,IF(H10=7,'Matryca termo'!F7,IF(H10=8,'Matryca termo'!F8,IF(H10=9,'Matryca termo'!F9)))))))))","v":125600}]
[null,null,null,null,null,null,null,"Termo",84600,{"$f":"IF(H10=1,'Matryca termo'!B1,IF(H10=2,'Matryca termo'!B2,IF(H10=3,'Matryca termo'!B3,IF(H10=4,'Matryca termo'!B4,IF(H10=5,'Matryca termo'!B5,IF(H10=6,'Matryca termo'!B6,IF(H10=7,'Matryca termo'!B7,IF(H10=8,'Matryca termo'!B8,IF(H10=9,'Matryca termo'!B9)))))))))","v":84600}]
["Termomodernizacja"]
[null,"ilość","Wartość umowy netto","Wartość umowy brutto","Cena netto","Cena brutto",null,"Przedział klienta (dofinansowanie + efektywność)",null,"Poziom dofinansowania (pompa/kocioł)"]
["Styropian - system (bialy klej) + Grunt szczepny (ściany)",null,{"$f":"B17*E17","v":0},{"$f":"B17*F17","v":0},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E35,IF($B$2=\"Podwyższony\",'Matryca termo'!G35))","v":250},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F35,IF($B$2=\"Podwyższony\",'Matryca termo'!H35))","v":270},null,"1.","Podstawowy(<80)","1. Podstawowy (40%)"]
["Piana PUR (20cm)",null,0,{"$f":"B18*F18","v":0},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E36,IF($B$2=\"Podwyższony\",'Matryca termo'!G36))","v":200},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F36,IF($B$2=\"Podwyższony\",'Matryca termo'!H36))","v":216},null,"2.","Podstawowy(80-140)","2. Podwyższony (70%)"]
["Piana PUR (25cm)-strop",null,0,0,{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E37,IF($B$2=\"Podwyższony\",'Matryca termo'!G37))","v":200},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F37,IF($B$2=\"Podwyższony\",'Matryca termo'!H37))","v":216},null,"3.","Podstawowy(>140)","3. Najwyższy (100%)"]
["Welna -> na zakladke bez folii paroizolacyjnej (do 25cm)",null,0,0,{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E38,IF($B$2=\"Podwyższony\",'Matryca termo'!G38))","v":200},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F38,IF($B$2=\"Podwyższony\",'Matryca termo'!H38))","v":216},null,"4.","Podwyższony(<80)"]
["Welna -> na zakladke z folia paroizolacyjna (do 25cm)",null,0,0,{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E39,IF($B$2=\"Podwyższony\",'Matryca termo'!G39))","v":200},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F39,IF($B$2=\"Podwyższony\",'Matryca termo'!H39))","v":216},null,"5.","Podwyższony(80-140)"]
["Welna wdmuchiwana (do 20cm)",null,0,0,{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E40,IF($B$2=\"Podwyższony\",'Matryca termo'!G40))","v":200},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F40,IF($B$2=\"Podwyższony\",'Matryca termo'!H40))","v":216},null,"6.","Podwyższony(>140)"]
["Welna wdmuchiwana (do 25cm)",null,0,0,{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E41,IF($B$2=\"Podwyższony\",'Matryca termo'!G41))","v":200},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F41,IF($B$2=\"Podwyższony\",'Matryca termo'!H41))","v":216},null,"7.","Najwyższy(<80)"]
["Styropian -> na zakladke bez folii paroizolacyjnej (do 25cm)",null,0,0,{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E42,IF($B$2=\"Podwyższony\",'Matryca termo'!G42))","v":200},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F42,IF($B$2=\"Podwyższony\",'Matryca termo'!H42))","v":216},null,"8.","Najwyższy(80-140)"]
["Styropian -> na zakladke z folia paroizolacyjna (do 25cm)",null,0,0,{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E43,IF($B$2=\"Podwyższony\",'Matryca termo'!G43))","v":200},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F43,IF($B$2=\"Podwyższony\",'Matryca termo'!H43))","v":216},null,"9.","Najwyższy(>140)"]
["Drzwi (m2)",null,0,0,{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E45,IF($B$2=\"Podwyższony\",'Matryca termo'!G45))","v":2500},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F45,IF($B$2=\"Podwyższony\",'Matryca termo'!H45))","v":2700}]
["Stolarka okienna (m2)",null,0,0,{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E46,IF($B$2=\"Podwyższony\",'Matryca termo'!G46))","v":1200},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F46,IF($B$2=\"Podwyższony\",'Matryca termo'!H46))","v":1296}]
["Parapety",null,0,0,{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E48,IF($B$2=\"Podwyższony\",'Matryca termo'!G48))","v":150},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F48,IF($B$2=\"Podwyższony\",'Matryca termo'!H48))","v":162}]
["Skuwanie tynków",null,0,0,{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E49,IF($B$2=\"Podwyższony\",'Matryca termo'!G49))","v":60},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F49,IF($B$2=\"Podwyższony\",'Matryca termo'!H49))","v":64.800000000000011}]
["Opierzenie",null,0,0,{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E50,IF($B$2=\"Podwyższony\",'Matryca termo'!G50))","v":175},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F50,IF($B$2=\"Podwyższony\",'Matryca termo'!H50))","v":189}]
["Ocieplenie podłóg",null,0,0,{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E51,IF($B$2=\"Podwyższony\",'Matryca termo'!G51))","v":150},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F51,IF($B$2=\"Podwyższony\",'Matryca termo'!H51))","v":162}]
["Audyt energetyczny i świadectwo",null,0,0,{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!E47,IF($B$2=\"Podwyższony\",'Matryca termo'!G47))","v":1600},{"$f":"IF($B$2=\"Najwyższy\",'Matryca termo'!F47,IF($B$2=\"Podwyższony\",'Matryca termo'!H47))","v":1968}]
[]
["Wartość umowy",null,{"$f":"SUM(C17:C32)","v":0},{"$f":"SUM(D17:D32)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Najwyższy"]
["Podwyższony"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]

{"sheet":"Dane wejściowe","index":7,"n_rows":20,"n_cols":25,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["TYP BUDYNKU","Poziom dotacji","AUDYT + ŚWIADECTWO CHARAKTERYSTYKI","PC/PIEC","Źródło grzewcze","TERMOMODERNIZACJA","REKUPERACJA",null,"OCIEPLENIE DACH STROP","Ocieplana przegroda","Materiał","Powierzchnia ocieplenia (m2)",null,"OCIEPLENIE ŚCIAN ZEWNĘTRZNYCH - STYROPIAN + TYNK","Powierzchnia ocieplana (m2)",null,"DRZWI","Ilość drzwi (szt.)",null,null,null,"OKNA","Ilość okien (szt.)"]
["do 80 kWh/m2/rok","Najwyższy","TAK","TAK","Pompa Ciepła","TAK","TAK",null,"TAK","Strop","Piana PUR",null,null,"TAK",null,null,"TAK",1,"Drzwi 1","Wysokość",null,"TAK",1,"Okno 1","Wysokość"]
["80 - 140 kWh/m2/rok","Podwyższony","NIE","NIE","Kocioł na pellet","NIE","NIE",null,"NIE","Dach","Wełna wdmuchiwana",null,null,"NIE",null,null,"NIE",2,"Drzwi 2","Szerokość",null,"NIE",2,"Okno 2","Szerokość"]
["powyżej 140 kWh/m2/rok",null,null,null,"Kocioł zagazowujący drewno",null,null,null,null,null,"Wełna mineralna (z rolki)",null,null,null,null,null,null,3,"Drzwi 3",null,null,null,3,"Okno 3"]
[null,null,null,null,null,null,null,null,null,null,"Styropian twardy na strop",null,null,null,null,null,null,null,null,null,null,null,4,"Okno 4"]
[null,null,null,null,null,null,null,null,null,null,"STYROPAPA",null,null,null,null,null,null,null,null,null,null,null,5,"Okno 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Okno 6"]
[null,null,null,null,null,null,null,null,null,null,"Piana PUR",null,null,null,null,null,null,null,null,null,null,null,7,"Okno 7"]
[null,null,null,null,null,null,null,null,null,null,"Wełna wdmuchiwana",null,null,null,null,null,null,null,null,null,null,null,8,"Okno 8"]
[null,null,null,null,null,null,null,null,null,null,"Wełna mineralna (z rolki)",null,null,null,null,null,null,null,null,null,null,null,9,"Okno 9"]
[null,null,null,null,null,null,null,null,null,null,"STYROPAPA",null,null,null,null,null,null,null,null,null,null,null,10,"Okno 10"]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"Kalkulator!$C$13","v":"TAK"},{"$f":"IF($D$17=$D$2,_xlfn.UNIQUE($E$2:$E$4),\"\")","v":"Pompa Ciepła"},null,null,null,{"$f":"Kalkulator!$B$27","v":"NIE"},{"$f":"IF($I$17=$I$2,_xlfn.UNIQUE($J$2:$J$3),\"\")","v":""},{"$f":"Kalkulator!C28","v":"Strop"},{"$f":"IF(AND($I$17=$I$2,$K$17=$J$2),_xlfn.UNIQUE($K$2:$K$6),_xlfn.UNIQUE($K$8:$K$11))","v":"Piana PUR"},null,null,null,null,{"$f":"Kalkulator!$B$43","v":"NIE"},{"$f":"IF($Q$17=$Q$2,_xlfn.UNIQUE($R$2:$R$4),\"\")","v":""},null,null,null,{"$f":"Kalkulator!$B$53","v":"NIE"},{"$f":"IF($V$17=$V$2,_xlfn.UNIQUE($W$2:$W$11),\"\")","v":""}]
[null,null,null,null,"Kocioł na pellet",null,null,null,null,null,null,"Wełna wdmuchiwana"]
[null,null,null,null,"Kocioł zagazowujący drewno",null,null,null,null,null,null,"Wełna mineralna (z rolki)"]
[null,null,null,null,null,null,null,null,null,null,null,"STYROPAPA"]

{"sheet":"Baza (2)","index":8,"n_rows":49,"n_cols":27,"rows_kept":49,"cut":false,"hidden":true,"merged":[[32,4,32,5],[31,13,31,14],[31,15,31,17]]}
["Pompa Ciepła",35200,null,null,{"$f":"F1*1.08","v":0},{"$f":"Kalkulator!I23","v":0},null,null,{"$f":"Kalkulator!C13","v":"TAK"},{"$f":"Kalkulator!B23","v":"NIE"},{"$f":"Kalkulator!B27","v":"NIE"},{"$f":"Kalkulator!B37","v":"NIE"},{"$f":"Kalkulator!B43","v":"NIE"},{"$f":"Kalkulator!B53","v":"NIE"},{"$f":"Kalkulator!B20","v":"TAK"},null,null,null,null,{"$f":"Kalkulator!B20","v":"TAK"},null,null,{"$f":"Kalkulator!C11","v":"TAK"},null,null,"MODERNIZACJA CO","ILOŚĆ GRZEJNIKÓW"]
["Kocioł na pellet",25000,null,null,null,"Cena netto",null,null,{"$f":"Kalkulator!C14","v":"Kocioł na pellet"},"REKUPERACJA",{"$f":"Kalkulator!C29","v":"STYROPAPA"},{"$f":"Kalkulator!B36","v":"OCIEPLENIE ŚCIAN ZEWNĘTRZNYCH - STYROPIAN + TYNK"},{"$f":"Kalkulator!C44","v":1},{"$f":"Kalkulator!C54","v":1},{"$f":"A9","v":"AUDYT"},null,null,null,null,"Termo",null,null,null,null,null,"WYMIANA GRZEJNIKÓW"]
["Piec zagazowujący drewno",30000,null,null,null,null,null,null,null,{"$f":"IF(J1=A11,B4,0)","v":0},{"$f":"Kalkulator!C30","v":1},{"$f":"Kalkulator!C38","v":1},{"$f":"Kalkulator!C46","v":1},{"$f":"Kalkulator!C56","v":1},{"$f":"IF(O1='Baza (2)'!A11,B9,0)","v":2500},null,null,null,null,{"$f":"IF(OR(J1=A11,K1=A11,L1=A11,M1=A11,N1=A11),A11,A12)","v":"NIE"},null,null,null,null,null,"WYMIANA GRZEJNIKÓW + RURY CO"]
["REKUPERACJA",2000,null,null,null,{"$f":"SUM(I4:N4,F1)","v":25000},null,null,{"$f":"IF(I1=A11,(IF(E34=A1,B1,IF(E34=A2,B2,B3))+G35+I35),0)","v":25000},{"$f":"IF(O1=A11,J3*Kalkulator!$C$24,0)","v":0},{"$f":"IF(AND(O1=A11,K1=A11,K2<>'Dane wejściowe'!K6),K3*B5+Q35+R35+S35+T35,IF(AND(O1=A11,K1=A11,K2='Dane wejściowe'!K6),K3*350+Q35+R35+S35+T35,0))","v":0},{"$f":"IF(AND(O1=A11,L1=A11),L3*B6+N35+O35,0)","v":0},{"$f":"IF(AND(O1=A11,M1=A11),M3*B7+M35,0)","v":0},{"$f":"IF(AND(O1=A11,N1=A11),N3*B8+K35,0)","v":0},{"$f":"IF(SUM(I4:N4)>0,O3,0)","v":2500},null,null,null,null,{"$f":"IF(OR(K1=A11,L1=A11,M1=A11,N1=A11),A11,A12)","v":"NIE"}]
["OCIEPLENIE DACH STROP",200,null,null,null,{"$f":"IF(F4>0,F4,0)","v":25000},null,null,{"$f":"IF(A12=Kalkulator!B20,('Baza (2)'!I4*1.08)+'Baza (2)'!E1,'Baza (2)'!I4*1.08)","v":27000},{"$f":"J4*1.08","v":0},{"$f":"K4*1.08","v":0},{"$f":"IF(AND(T1=A11,L4>0),L4*1.08+E1,L4*1.08)","v":0},0,0]
["OCIEPLENIE ŚCIAN ZEWNĘTRZNYCH",300,null,null,null,{"$f":"IF(F4>0,(F5*0.08),0)","v":2000},null,null,{"$f":"_xlfn.IFS(F10='Dane wejściowe'!B3,'Baza (2)'!I4*0.7,'Baza (2)'!F10='Dane wejściowe'!B2,'Baza (2)'!I4)","v":25000}]
["DRZWI",2500]
["OKNA",1200,null,null,null,{"$f":"F4+F6","v":27000},null,null,{"$f":"IF(A12=Kalkulator!B20,'Baza (2)'!I4+'Baza (2)'!F1,'Baza (2)'!I4)","v":25000},{"$f":"J4","v":0},0,{"$f":"IF(AND(T1=A11,L4>0),L4+F1,L4)","v":0},0,0,2500,null,null,null,null,null,null,null,null,1]
["AUDYT",2500,null,null,null,null,null,null,{"$f":"I5-I8","v":2000},{"$f":"J5-J8","v":0},0,0,0,0,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,{"$f":"Kalkulator!C9","v":"Najwyższy"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["TAK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
["NIE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Kalkulator!I12","v":124000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Kalkulator!I13","v":20500},null,"Modernizacja CO i CWU",{"$f":"IF(I1=A11,_xlfn.IFS(F10=Matryca!S2,'Baza (2)'!P20,F10=Matryca!S1,'Baza (2)'!P19),0)","v":20500}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kocioł na pellet",{"$f":"'dotacja 18.07.'!I4","v":20500},null,20500]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rekuperacja",{"$f":"'dotacja 18.07.'!I29","v":0},null,{"$f":"P19*0.7","v":14349.999999999998}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Dach/stropodach/strop pod nieogrzewanym poddaszem",{"$f":"'dotacja 18.07.'!I21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ściany zewnętrzne/przegrody pionowe",{"$f":"'dotacja 18.07.'!I23","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Stolarka okienna",{"$f":"'dotacja 18.07.'!I27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Stolarka drzwiowa – drzwi zewnętrzne",{"$f":"'dotacja 18.07.'!I25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Audyt",0]
[]
[null,null,null,null,null,{"$f":"IF((Kalkulator!I19-F1*1.08)-Kalkulator!I13>0,((Kalkulator!I19-F1*1.08)-Kalkulator!I13)+Kalkulator!I15,(Kalkulator!I23*1.08)+Kalkulator!I15)","v":9575}]
[null,null,null,null,null,{"$f":"F27+Kalkulator!I23*1.08","v":9575}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OCIEPLENIE ŚCIAN ZEWNĘTRZNYCH - STYROPIAN + TYNK",null,"OCIEPLENIE DACH STROP"]
[null,null,null,null,"Źródło grzewcze",null,"zbiornik cwu","modernizacja co","ilość grzejników","Okna","m2","Drzwi","ilość",{"$f":"Kalkulator!B39","v":""},{"$f":"Kalkulator!B40","v":""},{"$f":"Kalkulator!B30","v":""},{"$f":"Kalkulator!B31","v":""},{"$f":"Kalkulator!B32","v":""},{"$f":"Kalkulator!B33","v":""},{"$f":"Kalkulator!B34","v":""}]
[null,null,null,null,{"$f":"Kalkulator!C14","v":"Kocioł na pellet"},null,{"$f":"IF(E34=\"Pompa Ciepła\",0,Kalkulator!C15)","v":"TAK"},{"$f":"Kalkulator!C16","v":"WYMIANA GRZEJNIKÓW"},{"$f":"Kalkulator!C17","v":0},{"$f":"Kalkulator!C55","v":"Białe"},{"$f":"Kalkulator!C56","v":1},{"$f":"Kalkulator!C45","v":"Pełne"},{"$f":"Kalkulator!C44","v":1},{"$f":"Kalkulator!C39","v":1},{"$f":"Kalkulator!C40","v":1},{"$f":"Kalkulator!C30","v":1},{"$f":"Kalkulator!C31","v":"NIE"},{"$f":"Kalkulator!C32","v":0},{"$f":"Kalkulator!C33","v":0},{"$f":"Kalkulator!C34","v":0}]
["PC 6 kW",45000,null,null,null,{"$f":"IF(E34=A1,B1,IF(E34=A2,B2,B3))","v":25000},{"$f":"IF(G34=\"TAK\",0,0)","v":0},null,{"$f":"IF(H34=\"Wymiana Grzejników\",'Baza (2)'!I34*1850,'Baza (2)'!I34*2800)","v":0},null,{"$f":"IF(J34=\"Kolor Obustronny\",K34*200,0)","v":0},null,{"$f":"IF(L34=\"Tłoczone\",M34*500,IF(L34=\"Przeszklone\",M34*1000,0))","v":0},{"$f":"130*N34","v":130},{"$f":"150*O34","v":150},null,{"$f":"IF(AND(Q33=\"Folia paroizolacyjna\",Q34=\"TAK\"),P34*5,IF(AND(Q33=\"Uchwyty GK\",Q34=\"TAK\"),P34*8,0))","v":0},{"$f":"IF(AND(R33=\"Membrana paroprzepuszczalna\",R34=\"TAK\"),P34*5,IF(R33=\"Murowanie ogniomurów + przełożenie rynien (mb)\",R34*150,0))","v":0},{"$f":"IF(S33=\"Opierzenie (mb)\",S34*150,0)","v":0},{"$f":"IF(T33=\"Murowanie komina (szt.)\",T34*700,0)","v":0}]
["PC 8 kW",46000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"folia out",null,"?"]
["PC 10 kW",47000]
["PC 12 kW",48000]
["PC 14 kW",49000]
["PC 16 kW",50000]
["Piec zgazowujący drewno",39500]
["Piec na pellet 12 kW",37500]
["Piec na pellet 18 kW",38500]
["Piec na pellet 24 kW",39500]
[]
[]
[{"$f":"IF(Kalkulator!$C$14='Baza (2)'!$A$1,_xlfn.UNIQUE('Baza (2)'!$A$35:$A$40),IF(Kalkulator!$C$14='Baza (2)'!$A$2,_xlfn.UNIQUE('Baza (2)'!$A$42:$A$44),'Baza (2)'!$A$41))","v":"Piec na pellet 12 kW"}]
["Piec na pellet 18 kW"]
["Piec na pellet 24 kW"]

{"sheet":"Baza","index":9,"n_rows":47,"n_cols":27,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
["Pompa Ciepła",55700,null,null,{"$f":"F1*1.08","v":0},{"$f":"Kalkulator!I23","v":0},null,null,{"$f":"Kalkulator!C13","v":"TAK"},{"$f":"Kalkulator!B23","v":"NIE"},{"$f":"Kalkulator!B27","v":"NIE"},{"$f":"Kalkulator!B37","v":"NIE"},{"$f":"Kalkulator!B43","v":"NIE"},{"$f":"Kalkulator!B53","v":"NIE"},{"$f":"Kalkulator!B20","v":"TAK"},null,null,null,null,{"$f":"Kalkulator!B20","v":"TAK"},null,null,{"$f":"Kalkulator!C11","v":"TAK"},null,null,"MODERNIZACJA CO","ILOŚĆ GRZEJNIKÓW"]
["Piec na pellet",41000,null,null,null,"Cena netto",null,null,{"$f":"Kalkulator!C14","v":"Kocioł na pellet"},"REKUPERACJA",{"$f":"Kalkulator!C29","v":"STYROPAPA"},{"$f":"Kalkulator!B36","v":"OCIEPLENIE ŚCIAN ZEWNĘTRZNYCH - STYROPIAN + TYNK"},{"$f":"Kalkulator!C44","v":1},{"$f":"Kalkulator!C54","v":1},{"$f":"A9","v":"AUDYT"},null,null,null,null,"Termo",null,null,null,null,null,"WYMIANA GRZEJNIKÓW"]
["Piec zagazowujący drewno",41000,null,null,null,null,null,null,null,{"$f":"IF(J1=A11,B4,0)","v":0},{"$f":"Kalkulator!C30","v":1},{"$f":"Kalkulator!C38","v":1},{"$f":"Kalkulator!C46","v":1},{"$f":"Kalkulator!C56","v":1},{"$f":"IF(O1=Baza!A11,B9,0)","v":1600},null,null,null,null,{"$f":"IF(OR(J1=A11,K1=A11,L1=A11,M1=A11,N1=A11),A11,A12)","v":"NIE"},null,null,null,null,null,"WYMIANA GRZEJNIKÓW + RURY CO"]
["REKUPERACJA",2000,null,null,null,{"$f":"SUM(I4:N4,F1)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(I1=A11,_xlfn.IFS(I2=A1,B1,I2=A2,B2,I2=A3,B3),0)","v":{"$error":"#N/A"}},{"$f":"IF(O1=A11,J3*8,0)","v":0},{"$f":"IF(AND(O1=A11,K1=A11),K3*B5,0)","v":0},{"$f":"IF(AND(O1=A11,L1=A11),L3*B6,0)","v":0},{"$f":"IF(AND(O1=A11,M1=A11),M3*B7,0)","v":0},{"$f":"IF(AND(O1=A11,N1=A11),N3*B8,0)","v":0},{"$f":"IF(SUM(I4:N4)>0,O3,0)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"IF(OR(K1=A11,L1=A11,M1=A11,N1=A11),A11,A12)","v":"NIE"}]
["OCIEPLENIE DACH STROP",200,null,null,null,{"$f":"IF(F4>0,F4,0)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(A12=Kalkulator!B20,(Baza!I4*1.08)+Baza!E1,Baza!I4*1.08)","v":{"$error":"#N/A"}},{"$f":"J4*1.08","v":0},0,{"$f":"IF(AND(T1=A11,L4>0),L4*1.08+E1,L4*1.08)","v":0},0,0]
["OCIEPLENIE ŚCIAN ZEWNĘTRZNYCH",250,null,null,null,{"$f":"IF(F4>0,(F5*0.08),0)","v":{"$error":"#N/A"}},null,null,{"$f":"_xlfn.IFS(F10='Dane wejściowe'!B3,Baza!I4*0.7,Baza!F10='Dane wejściowe'!B2,Baza!I4)","v":{"$error":"#N/A"}}]
["DRZWI",2500]
["OKNA",1200,null,null,null,{"$f":"F4+F6","v":{"$error":"#N/A"}},null,null,{"$f":"IF(A12=Kalkulator!B20,Baza!I4+Baza!F1,Baza!I4)","v":{"$error":"#N/A"}},{"$f":"J4","v":0},0,{"$f":"IF(AND(T1=A11,L4>0),L4+F1,L4)","v":0},0,0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,1]
["AUDYT",1600,null,null,null,null,null,null,{"$f":"I5-I8","v":{"$error":"#N/A"}},{"$f":"J5-J8","v":0},0,0,0,0,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,{"$f":"Kalkulator!C9","v":"Najwyższy"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["TAK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
["NIE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Kalkulator!I12","v":124000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Kalkulator!I13","v":20500},null,"Modernizacja CO i CWU",{"$f":"IF(I1=A11,_xlfn.IFS(F10=Matryca!S2,Baza!P20,F10=Matryca!S1,Baza!P19),0)","v":20500}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kocioł na pellet",{"$f":"IF(I1=A11,_xlfn.IFS(AND(I2=A1,F10=Matryca!S2),Matryca!K22,AND(I2=A1,F10=Matryca!S1),Matryca!K23,AND(I2=A2,F10=Matryca!S2),Matryca!G22,AND(I2=A2,F10=Matryca!S1),Matryca!G23,AND(I2=A3,F10=Matryca!S2),Matryca!G22,AND(I2=A3,F10=Matryca!S1),Matryca!G23))","v":{"$error":"#N/A"}},null,20500]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rekuperacja",{"$f":"IF(J4>0,J4,0)","v":0},null,{"$f":"P19*0.7","v":14349.999999999998}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Dach/stropodach/strop pod nieogrzewanym poddaszem",{"$f":"IF(K4>0,K4,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ściany zewnętrzne/przegrody pionowe",{"$f":"N18-SUM(N19:N21,N23:N25)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Stolarka okienna",{"$f":"IF(N4>0,N4,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Stolarka drzwiowa – drzwi zewnętrzne",{"$f":"IF(M4>0,M4,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Audyt",0]
[]
[null,null,null,null,null,{"$f":"IF((Kalkulator!I19-F1*1.08)-Kalkulator!I13>0,((Kalkulator!I19-F1*1.08)-Kalkulator!I13)+Kalkulator!I15,(Kalkulator!I23*1.08)+Kalkulator!I15)","v":9575}]
[null,null,null,null,null,{"$f":"F27+Kalkulator!I23*1.08","v":9575}]
[]
[]
[]
[]
[]
[]
["PC 6 kW"]
["PC 8 kW"]
["PC 10 kW"]
["PC 12 kW"]
["PC 14 kW"]
["PC 16 kW"]
["Piec zgazowujący drewno"]
["Piec na pellet 12 kW"]
["Piec na pellet 18 kW"]
["Piec na pellet 24 kW"]
[]
[]
[{"$f":"IF(Kalkulator!$C$14=Baza!$A$1,_xlfn.UNIQUE(Baza!$A$35:$A$40),IF(Kalkulator!$C$14=Baza!$A$2,_xlfn.UNIQUE(Baza!$A$42:$A$44),Baza!$A$41))","v":"Piec zgazowujący drewno"}]

{"sheet":"Kredyt","index":10,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Kwota instalacji","Wkład włany","Kwota kredytu","RRSO","RRSO/m-c","Okres kredytowania","M-c","Rata","Warunki"]
[2,null,null,"Inbank",{"$f":"Kalkulator!I21","v":9575},{"$f":"Kalkulator!$I$9","v":0},{"$f":"E2-F2","v":9575},0.1172,{"$f":"H2/12","v":9.7666666666666666E-3},{"$f":"Kalkulator!H9","v":5},{"$f":"J2*12","v":60},{"$f":"(G2/K2)+G2*I2","v":253.09916666666669},{"$f":"IFERROR(IF(J2=VLOOKUP(J2,A2:A10,1,0),L2,0),\"-\")","v":253.09916666666669}]
[3,null,null,"Santander",{"$f":"Kalkulator!I21","v":9575},{"$f":"Kalkulator!$I$9","v":0},{"$f":"E3-F3","v":9575},0.1139,9.4916666669999997E-3,{"$f":"Kalkulator!H9","v":5},{"$f":"IFERROR(J3*12,120)","v":60},250.46604166985833,{"$f":"IFERROR(IF(J3=VLOOKUP(J3,A2:A6,1,0),L3,0),\"-\")","v":250.46604166985833}]
[4,null,null,"Cofidis",{"$f":"Kalkulator!I21","v":9575},{"$f":"Kalkulator!$I$9","v":0},{"$f":"E4-F4","v":9575},0.12670000000000001,{"$f":"H4/12","v":1.0558333333333334E-2},{"$f":"Kalkulator!H9","v":5},{"$f":"J4*12","v":60},{"$f":"(G4/K4)+G4*I4","v":260.67937500000005},{"$f":"IFERROR(IF(J4=VLOOKUP(J4,A3:A7,1,0),L4,0),\"-\")","v":260.67937500000005}]
[5]
[6]
[7]
[8]
[9]
[10]

{"sheet":"Matryca","index":11,"n_rows":27,"n_cols":24,"rows_kept":27,"cut":false,"hidden":true,"merged":[[14,0,14,1],[14,4,14,6],[14,8,14,10]]}
["Podstawowy(<80)","Nie dotyczy",null,null,"Podstawowy(<80)","Nie dotyczy",null,null,"Podstawowy(<80)","Nie dotyczy",null,null,{"$f":"Kalkulator!C9","v":"Najwyższy"},{"$f":"Kalkulator!B14","v":"Źródło grzewcze"},{"$f":"Kalkulator!C14","v":"Kocioł na pellet"},{"$f":"Kalkulator!C13","v":"TAK"},null,"TAK","Najwyższy","Pompa Ciepła",null,null,{"$f":"Kalkulator!B20","v":"TAK"},{"$f":"IF(AND(Matryca!W1=Matryca!R2,Matryca!P1=Matryca!R2),Matryca!R2,Matryca!R1)","v":"TAK"}]
["Podstawowy(80-140)","Nie dotyczy",null,null,"Podstawowy(80-140)",37200,null,null,"Podstawowy(80-140)","Nie dotyczy",null,null,null,null,null,null,null,"NIE","Podwyższony","Kocioł na pellet"]
["Podstawowy(>140)","Nie dotyczy",null,null,"Podstawowy(>140)",51200,null,null,"Podstawowy(>140)","Nie dotyczy",null,null,null,{"$f":"IF(X1=R1,IF(P1=R1,_xlfn.IFS(AND(M1=S1,O1=T1,W1=R1),N9,AND(M1=S2,O1=T1,W1=R1),N9,AND(M1=S1,O1=T2,W1=R1),N10,AND(M1=S2,O1=T2,W1=R1),N10,AND(M1=S1,O1=T3,W1=R1),N10,AND(M1=S2,O1=T3,W1=R1),N10,\nAND(M1=S1,O1=T1,W1=R2),K23,AND(M1=S2,O1=T1,W1=R2),K22,AND(M1=S1,O1=T2,W1=R2),G23,AND(M1=S2,O1=T2,W1=R2),G22,AND(M1=S1,O1=T3,W1=R2),G23,AND(M1=S2,O1=T3,W1=R2),G22\n),_xlfn.IFS(M1=S1,N11,M1=S2,N11)),0)","v":124000},null,null,null,null,null,"Kocioł zagazowujący drewno"]
["Podwyższony(<80)","Nie dotyczy",null,null,"Podwyższony(<80)","Nie dotyczy",null,null,"Podwyższony(<80)","Nie dotyczy"]
["Podwyższony(80-140)",{"$f":"33600","v":33600},null,null,"Podwyższony(80-140)",{"$f":"63900-1600","v":62300},null,null,"Podwyższony(80-140)",{"$f":"B5+K22","v":72590}]
["Podwyższony(>140)",58100,null,null,"Podwyższony(>140)",{"$f":"88400-1600","v":86800},null,null,"Podwyższony(>140)",{"$f":"B6+K22","v":97090}]
["Najwyższy(<80)","Nie dotyczy",null,null,"Najwyższy(<80)","Nie dotyczy",null,null,"Najwyższy(<80)","Nie dotyczy"]
["Najwyższy(80-140)","Nie dotyczy",null,null,"Najwyższy(80-140)","Nie dotyczy",null,null,"Najwyższy(80-140)","Nie dotyczy"]
["Najwyższy(>140)",{"$f":"83000","v":83000},null,null,"Najwyższy(>140)",{"$f":"125600-1600","v":124000},null,null,"Najwyższy(>140)",{"$f":"B9+K23","v":138700},null,null,"Pompa + Termo",{"$f":"IF(M1=S2,_xlfn.IFS(M27=M18,J4,M27=M19,J5,M27=M20,J6),_xlfn.IFS(M27=M18,J7,M27=M19,J8,M27=M20,J9))","v":138700}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kocioł + Termo",{"$f":"IF(M1=S2,_xlfn.IFS(M27=M18,F4,M27=M19,F5,M27=M20,F6),_xlfn.IFS(M27=M18,F7,M27=M19,F8,M27=M20,F9))","v":124000}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Termo",{"$f":"IF(M1=S2,_xlfn.IFS(M27=M18,B4,M27=M19,B5,M27=M20,B6),_xlfn.IFS(M27=M18,B7,M27=M19,B8,M27=M20,B9))","v":83000}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X1=R1,IF(W1=R2,N3,IF(P1=R1,_xlfn.IFS(O1=T1,N9,O1=T2,N10,O1=T3,N10),N11)),0)","v":124000}]
[]
["termo",null,null,null,"kocioł + termo",null,null,null,"pompa + termo"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"do 80 kWh/m2/rok"]
[null,null,null,null,null,null,null,null,null,null,null,null,"80 - 140 kWh/m2/rok"]
[null,null,null,null,"kocioł","progi","zł",null,"pompa","progi","zł",null,"powyżej 140 kWh/m2/rok"]
[null,null,null,null,41000,0.4,{"$f":"E21*F21","v":16400},null,55700,0.4,{"$f":"I21*J21","v":22280}]
[null,null,null,null,null,0.7,{"$f":"E21*F22","v":28699.999999999996},null,null,0.7,{"$f":"I21*J22","v":38990}]
[null,null,null,null,null,1,{"$f":"41000","v":41000},null,null,1,{"$f":"55700","v":55700}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Kalkulator!C8","v":"powyżej 140 kWh/m2/rok"}]

{"sheet":"dotacja 18.07.","index":12,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":true,"merged":[[3,7,13,7],[3,6,18,6],[3,8,13,8]]}
[null,null,null,null,null,null,null,{"$f":"Kalkulator!C9","v":"Najwyższy"}]
[null,null,null,null,null,null,null,{"$f":"Kalkulator!C8","v":"powyżej 140 kWh/m2/rok"}]
[null,null,null,null,null,null,{"$f":"Kalkulator!B13","v":"PC/KOCIOŁ"},null,{"$f":"SUM(I4:I30)","v":20500},null,null,"WCZEŚNIEJ WYKORZYSTANA DOTACJA"]
["Kocioł na pellet",null,null,null,null,null,{"$f":"Kalkulator!C13","v":"TAK"},{"$f":"Kalkulator!C14","v":"Kocioł na pellet"},{"$f":"IF(AND(G4=\"TAK\",OR(H4=A4,H4=A5)),VLOOKUP(H1,A7:B8,2,FALSE),IF(AND(G4=\"TAK\",H4=A11),VLOOKUP(H1,A13:B14,2,FALSE),0))","v":20500},null,null,"JEŻELI($C$9='Dane wejściowe'!$B$3;MIN($I$12;($I$17-I23)*0,7);WARUNKI(Matryca!N3=\"Nie dotyczy\";Matryca!N13;Matryca!N3<($I$17-I23);Matryca!N3;Matryca!N3>=($I$17-I23);I17-I23))"]
["Kocioł zagazowujący drewno"]
[]
["Podwyższony",14350,null,null,null,null,null,null,null,null,null,{"$f":"Kalkulator!I12","v":124000}]
["Najwyższy",20500]
[]
[]
["Pompa Ciepła"]
[]
["Podwyższony",24640]
["Najwyższy",35200]
[]
["Modernizacja CO",{"$f":"'Baza (2)'!I35","v":0},null,null,null,null,null,{"$f":"Kalkulator!C16","v":"WYMIANA GRZEJNIKÓW"},{"$f":"IF(G4=\"TAK\",VLOOKUP(H1,A18:B19,2,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"Kalkulator!C17","v":0}]
["Podwyższony",{"$f":"IF(B16>=14300,14300,B16*0.7)","v":0}]
["Najwyższy",{"$f":"IF(B16>=20500,20500,B16)","v":0}]
[null,null,null,null,null,{"$f":"Kalkulator!B20","v":"TAK"},{"$f":"Kalkulator!B26","v":"OCIEPLENIE DACH STROP"},{"$f":"Kalkulator!C28","v":"Strop"}]
[{"$f":"Kalkulator!C28","v":"Strop"},{"$f":"Kalkulator!C30","v":1},null,null,null,null,{"$f":"Kalkulator!B27","v":"NIE"},{"$f":"Kalkulator!C30","v":1},{"$f":"IF(AND(F20=\"TAK\",G21=\"TAK\"),H22,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(H1,A23:B24,2,FALSE)*H21","v":200}]
["Podwyższony",140,null,null,null,null,{"$f":"Kalkulator!B36","v":"OCIEPLENIE ŚCIAN ZEWNĘTRZNYCH - STYROPIAN + TYNK"},{"$f":"Kalkulator!C38","v":1},{"$f":"IF(AND(F20=\"TAK\",G24=\"TAK\"),H24,0)","v":0}]
["Najwyższy",200,null,null,null,null,{"$f":"Kalkulator!B37","v":"NIE"},{"$f":"VLOOKUP(H1,A28:B29,2,FALSE)*H23","v":250}]
[null,null,null,null,null,null,"DRZWI",{"$f":"Kalkulator!C46","v":1},{"$f":"IF(AND(F20=\"TAK\",G26=\"TAK\"),H26,0)","v":0}]
[{"$f":"Kalkulator!B36","v":"OCIEPLENIE ŚCIAN ZEWNĘTRZNYCH - STYROPIAN + TYNK"},null,null,null,null,null,{"$f":"Kalkulator!B43","v":"NIE"},{"$f":"VLOOKUP(H1,A33:B34,2,FALSE)*H25","v":2500}]
[null,null,null,null,null,null,{"$f":"Kalkulator!B52","v":"OKNA"},{"$f":"Kalkulator!C56","v":1},{"$f":"IF(AND(F20=\"TAK\",G28=\"TAK\"),H28,0)","v":0}]
["Podwyższony",175,null,null,null,null,{"$f":"Kalkulator!B53","v":"NIE"},{"$f":"VLOOKUP(H1,A38:B39,2,FALSE)*H27","v":1200}]
["Najwyższy",250,null,null,null,null,{"$f":"Kalkulator!B22","v":"REKUPERACJA"},{"$f":"Kalkulator!C24","v":4},{"$f":"IF(AND(F20=\"TAK\",G30=\"TAK\"),H30,0)","v":0}]
[null,null,null,null,null,null,{"$f":"Kalkulator!B23","v":"NIE"},{"$f":"VLOOKUP(H1,A43:B44,2,FALSE)*H29","v":8000}]
["DRZWI",{"$f":"Kalkulator!C46","v":1}]
[]
["Podwyższony",1750]
["Najwyższy",2500]
[]
["OKNA",{"$f":"Kalkulator!C56","v":1}]
[]
["Podwyższony",840]
["Najwyższy",1200]
[]
["REKUPERACJA"]
[]
["Podwyższony",1400]
["Najwyższy",2000]

{"sheet":"Matryca termo","index":13,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":true,"merged":[[14,0,14,1],[14,4,14,6],[14,8,14,10]]}
["Podstawowy(<80)","Nie dotyczy",null,null,"Podstawowy(<80)","Nie dotyczy",null,null,"Podstawowy(<80)","Nie dotyczy"]
["Podstawowy(80-140)",19840,null,null,"Podstawowy(80-140)",37200,null,null,"Podstawowy(80-140)",{"$f":"B2+K21+1600","v":43720}]
["Podstawowy(>140)",33840,null,null,"Podstawowy(>140)",51200,null,null,"Podstawowy(>140)",{"$f":"B3+K21+1600","v":57720}]
["Podwyższony(<80)","Nie dotyczy",null,null,"Podwyższony(<80)","Nie dotyczy",null,null,"Podwyższony(<80)","Nie dotyczy"]
["Podwyższony(80-140)",34720,null,null,"Podwyższony(80-140)",63900,null,null,"Podwyższony(80-140)",{"$f":"B5+K22+1600","v":75310}]
["Podwyższony(>140)",59220,null,null,"Podwyższony(>140)",88400,null,null,"Podwyższony(>140)",{"$f":"B6+K22+1600","v":99810}]
["Najwyższy(<80)","Nie dotyczy",null,null,"Najwyższy(<80)","Nie dotyczy",null,null,"Najwyższy(<80)","Nie dotyczy"]
["Najwyższy(80-140)","Nie dotyczy",null,null,"Najwyższy(80-140)","Nie dotyczy",null,null,"Najwyższy(80-140)","Nie dotyczy"]
["Najwyższy(>140)",84600,null,null,"Najwyższy(>140)",125600,null,null,"Najwyższy(>140)",{"$f":"B9+K23+1600","v":141900}]
[]
[]
[]
[]
[]
["termo",null,null,null,"kocioł + termo",null,null,null,"pompa + termo"]
[]
[]
[]
[]
[null,null,null,null,"kocioł","progi","zł",null,"pompa","progi","zł"]
[null,null,null,null,41000,0.4,{"$f":"E21*F21","v":16400},null,55700,0.4,{"$f":"I21*J21","v":22280}]
[null,null,null,null,null,0.7,{"$f":"E21*F22","v":28699.999999999996},null,null,0.7,{"$f":"I21*J22","v":38990}]
[null,null,null,null,null,1,41000,null,null,1,55700]
[]
[]
[]
[]
[]
[]
["Zakres","Przyjęty koszt netto ER","Przyjęty koszt netto Darmowy Remont",null,"Maksymalne ceny jednostkowe (poziom najwyższy) netto","Maksymalne ceny jednostkowe (poziom najwyższy) brutto","Maksymalne ceny jednostkowe (poziom podwyższony) netto","Maksymalne ceny jednostkowe (poziom podwyższony) brutto"]
["PC",22500,41000,null,35200,38016,24640,26611.200000000001]
["Kocioł zgazowujący",23500,29400,null,20500,22140,14350,15498.000000000002]
["Kocioł na pellet",19500,29400,null,20500,22140,14350,15498.000000000002]
["CO/CWU",5000,5000,null,20500,22140,14350,15498.000000000002]
["Styropian - system (bialy klej) + Grunt szczepny  (sciany)",165,223,null,250,270,175,189]
["Piana PUR (20cm)",72,145,null,200,216,140,151.20000000000002]
["Piana PUR (25cm)(strop)",85,155,null,200,216,140,151.20000000000002]
["Welna -> na zakladke bez folii paroizolacyjnej (do 25cm)",90,145,null,200,216,140,151.20000000000002]
["Welna -> na zakladke z folia paroizolacyjna (do 25cm)",95,155,null,200,216,140,151.20000000000002]
["Welna wdmuchiwana (do 20cm)",60,133,null,200,216,140,151.20000000000002]
["Welna wdmuchiwana (do 25cm)",65,135,null,200,216,140,151.20000000000002]
["Styropian -> na zakladke bez folii paroizolacyjnej (do 25cm)",100,159,null,200,216,140,151.20000000000002]
["Styropian -> na zakladke z folia paroizolacyjna (do 25cm)",105,167,null,200,216,140,151.20000000000002]
["Rekuperacja",1700,1900,"szt",2000,2160,1400,1512]
["Drzwi",2000,2400,"zł/m2",2500,2700,1750,1890.0000000000002]
["Stolarka okienna",1120,1120,"zł/m2",1200,1296,840,907.2]
["Audyt energetyczny i świadectwo",1600,1600,null,1600,1968,1120,1377.6]
["Parapety",150,150,"zł/m2",150,162,105,113.4]
["Skuwanie tynków",60,60,"zł/m2",60,64.800000000000011,42,45.36]
["Opierzenie",175,175,"zł/m2",175,189,120,129.60000000000002]
["Ocieplenie podłóg",null,null,null,150,162,105,113.4]
[]
["rekuperacja centralna ",null,null,null,16700,"do zakodowania i ukrycia póki co"]