{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Kalkulator","Raty kredytowe","Składowe","Kalkulator cen MAX","Dane wejściowe","Baza","Kredyt","Matryca","Matryca termo"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Kalkulator","index":0,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[[43,2,43,3],[34,2,34,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[42,2,42,3],[29,2,29,3],[33,2,33,3],[28,1,28,3],[27,1,27,3],[31,1,31,3],[32,1,32,3],[41,1,41,3],[40,1,40,3],[7,2,7,3],[10,2,10,3],[12,2,12,3],[8,2,8,3],[13,2,13,3],[16,1,16,3],[15,1,15,3],[19,1,19,3],[18,1,18,3],[22,1,22,3],[21,1,21,3]]}
[]
[]
[]
[]
[]
[]
[]
[null,"TYP BUDYNKU","powyżej 140 kWh/m2/rok"]
[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,"AUDYT + ŚWIADECTWO CHARAKTERYSTYKI","TAK"]
[]
[null,"PC/PIEC","TAK"]
[null,{"$f":"IF($C$13='Dane wejściowe'!$D$2,'Dane wejściowe'!$E$1,\"\")","v":"Źródło grzewcze"},"Piec na pellet"]
[]
[null,"TERMOMODERNIZACJA",null,null,null,null,null,"Ilość lat kredytu:","Wpłata własna:"]
[null,"NIE",null,null,{"$f":"IF(AND($C$8='Dane wejściowe'!$A$4,$B$17<>'Dane wejściowe'!$F$2),\"<- TAK\",\"\")","v":"<- TAK"},null,null,5,{"$f":"I29","v":{"$error":"#VALUE!"}}]
[]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$2,'Dane wejściowe'!$G$1,\"\")","v":""}]
[null,"NIE",null,null,null,null,null,"MAX DOTACJA CZYSTE POWIETRZE",{"$f":"Matryca!N13","v":41000}]
[null,null,null,null,null,null,null,"WYKORZYSTNA DOTACJA CZYSTE POWIETRZE",{"$f":"IF($C$9='Dane wejściowe'!$B$3,MIN($I$20,($I$25-I31)*0.7),_xlfn.IFS(Matryca!N3=\"Nie dotyczy\",Matryca!N13,Matryca!N3<($I$25-I31),Matryca!N3,Matryca!N3>=($I$25-I31),I25-I31))","v":41000}]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$2,'Dane wejściowe'!$I$1,\"\")","v":""}]
[null,"NIE",null,null,null,null,null,"AUDYT + ŚWIADECTWO CHARAKTERYSTYKI",{"$f":"IF($I$27=0,\"\",IF($C$11=\"NIE\",0,1968))","v":""}]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF($B$23='Dane wejściowe'!$I$2,'Dane wejściowe'!$J$1,\"\"))","v":""},"Strop"]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF($B$23='Dane wejściowe'!$I$2,'Dane wejściowe'!$K$1,\"\"))","v":""},"Piana PUR",null,null,null,null,"CENA NETTO",{"$f":"Baza!F4","v":41000}]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF($B$23='Dane wejściowe'!$I$2,'Dane wejściowe'!$L$1,\"\"))","v":""},100,null,null,null,null,"VAT",{"$f":"Baza!F6","v":3280}]
[null,null,null,null,null,null,null,"CENA BRUTTO",{"$f":"IF(AND(Kalkulator!$C$8='Dane wejściowe'!$A$4,Kalkulator!$B$17='Dane wejściowe'!$F$3),0,Baza!F8)","v":0}]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$2,'Dane wejściowe'!$N$1,\"\")","v":""}]
[null,"NIE",null,null,null,null,null,"Wpłata własna klienta",{"$f":"Baza!F28","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF($B$29='Dane wejściowe'!$N$2,'Dane wejściowe'!$O$1,\"\"))","v":""},100]
[null,null,null,null,null,null,null,"MARŻA DODATKOWA",0]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$2,'Dane wejściowe'!$Q$1,\"\")","v":""}]
[null,"NIE"]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF($B$33='Dane wejściowe'!$Q$2,'Dane wejściowe'!$R$1,\"\"))","v":""},1]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF($B$33='Dane wejściowe'!$Q$2,\"SUMA POWIERZCHNI DRZWI\",\"\"))","v":""},{"$f":"IF($C$34=1,PRODUCT($C$37:$D$37),IF($C$34=2,SUM(PRODUCT($C$37:$D$37),PRODUCT($C$38:$D$38)),IF($C$34=3,SUM(PRODUCT($C$37:$D$37),PRODUCT($C$38:$D$38),PRODUCT($C$39:$D$39)),\"\")))","v":0}]
[null,null,{"$f":"IF($B$33='Dane wejściowe'!$Q$2,'Dane wejściowe'!$T$2,\"\")","v":""},{"$f":"IF($B$33='Dane wejściowe'!$Q$2,'Dane wejściowe'!$T$3,\"\")","v":""}]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF(AND($B$33='Dane wejściowe'!$Q$2,$C$34>='Dane wejściowe'!$R$2),'Dane wejściowe'!$S$2,\"\"))","v":""}]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF(AND($B$33='Dane wejściowe'!$Q$2,$C$34>='Dane wejściowe'!$R$3),'Dane wejściowe'!$S$3,\"\"))","v":""}]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF(AND($B$33='Dane wejściowe'!$Q$2,$C$34>='Dane wejściowe'!$R$4),'Dane wejściowe'!$S$4,\"\"))","v":""}]
[]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$2,'Dane wejściowe'!$V$1,\"\")","v":""}]
[null,"NIE"]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF($B$42='Dane wejściowe'!$V$2,'Dane wejściowe'!$W$1,\"\"))","v":""},1]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF($B$42='Dane wejściowe'!$V$2,\"SUMA POWIERZCHNI OKIEN\",\"\"))","v":""},{"$f":"IF($C$43=1,PRODUCT($C$46:$D$46),IF($C$43=2,SUM(PRODUCT($C$46:$D$46),PRODUCT($C$47:$D$47)),IF($C$43=3,SUM(PRODUCT($C$46:$D$46),PRODUCT($C$47:$D$47),PRODUCT($C$48:$D$48)),IF($C$43=4,SUM(PRODUCT($C$46:$D$46),PRODUCT($C$47:$D$47),PRODUCT($C$48:$D$48),PRODUCT($C$49:$D$49)),IF($C$43=5,SUM(PRODUCT($C$46:$D$46),PRODUCT($C$47:$D$47),PRODUCT($C$48:$D$48),PRODUCT($C$49:$D$49),PRODUCT($C$50:$D$50)),IF($C$43=6,SUM(PRODUCT($C$46:$D$46),PRODUCT($C$47:$D$47),PRODUCT($C$48:$D$48),PRODUCT($C$49:$D$49),PRODUCT($C$50:$D$50),PRODUCT($C$51:$D$51)),IF($C$43=7,SUM(PRODUCT($C$46:$D$46),PRODUCT($C$47:$D$47),PRODUCT($C$48:$D$48),PRODUCT($C$49:$D$49),PRODUCT($C$50:$D$50),PRODUCT($C$51:$D$51),PRODUCT($C$52:$D$52)),IF($C$43=8,SUM(PRODUCT($C$46:$D$46),PRODUCT($C$47:$D$47),PRODUCT($C$48:$D$48),PRODUCT($C$49:$D$49),PRODUCT($C$50:$D$50),PRODUCT($C$51:$D$51),PRODUCT($C$52:$D$52),PRODUCT($C$53:$D$53)),IF($C$43=9,SUM(PRODUCT($C$46:$D$46),PRODUCT($C$47:$D$47),PRODUCT($C$48:$D$48),PRODUCT($C$49:$D$49),PRODUCT($C$50:$D$50),PRODUCT($C$51:$D$51),PRODUCT($C$52:$D$52),PRODUCT($C$53:$D$53),PRODUCT($C$54:$D$54)),IF($C$43=10,SUM(PRODUCT($C$46:$D$46),PRODUCT($C$47:$D$47),PRODUCT($C$48:$D$48),PRODUCT($C$49:$D$49),PRODUCT($C$50:$D$50),PRODUCT($C$51:$D$51),PRODUCT($C$52:$D$52),PRODUCT($C$53:$D$53),PRODUCT($C$54:$D$54),PRODUCT($C$55:$D$55)),\"\"))))))))))","v":0}]
[null,null,{"$f":"IF($B$42='Dane wejściowe'!$V$2,'Dane wejściowe'!$Y$2,\"\")","v":""},{"$f":"IF($B$42='Dane wejściowe'!$V$2,'Dane wejściowe'!$Y$3,\"\")","v":""}]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF(AND($B$42='Dane wejściowe'!$V$2,$C$43>='Dane wejściowe'!$W$2),'Dane wejściowe'!$X$2,\"\"))","v":""}]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF(AND($B$42='Dane wejściowe'!$V$2,$C$43>='Dane wejściowe'!$W$3),'Dane wejściowe'!$X$3,\"\"))","v":""},0,0]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF(AND($B$42='Dane wejściowe'!$V$2,$C$43>='Dane wejściowe'!$W$4),'Dane wejściowe'!$X$4,\"\"))","v":""},0,0]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF(AND($B$42='Dane wejściowe'!$V$2,$C$43>='Dane wejściowe'!$W$5),'Dane wejściowe'!$X$5,\"\"))","v":""},0,0]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF(AND($B$42='Dane wejściowe'!$V$2,$C$43>='Dane wejściowe'!$W$6),'Dane wejściowe'!$X$6,\"\"))","v":""},0,0]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF(AND($B$42='Dane wejściowe'!$V$2,$C$43>='Dane wejściowe'!$W$7),'Dane wejściowe'!$X$7,\"\"))","v":""},0,0]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF(AND($B$42='Dane wejściowe'!$V$2,$C$43>='Dane wejściowe'!$W$8),'Dane wejściowe'!$X$8,\"\"))","v":""},0,0]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF(AND($B$42='Dane wejściowe'!$V$2,$C$43>='Dane wejściowe'!$W$9),'Dane wejściowe'!$X$9,\"\"))","v":""},0,0]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF(AND($B$42='Dane wejściowe'!$V$2,$C$43>='Dane wejściowe'!$W$10),'Dane wejściowe'!$X$10,\"\"))","v":""},0,0]
[null,{"$f":"IF($B$17='Dane wejściowe'!$F$3,\"\",IF(AND($B$42='Dane wejściowe'!$V$2,$C$43>='Dane wejściowe'!$W$11),'Dane wejściowe'!$X$11,\"\"))","v":""},0,0]

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

{"sheet":"Składowe","index":2,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[[23,11,23,12],[14,0,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[17,0,17,6],[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],[13,9,13,10],[13,11,13,12],[13,13,13,14],[19,9,19,10],[16,9,16,10],[16,11,16,12],[16,13,16,14],[15,9,15,10],[15,11,15,12],[15,13,15,14],[9,15,9,16],[11,7,11,8],[13,7,13,8],[19,7,19,8],[20,7,20,8],[11,15,11,16],[13,15,13,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],[12,7,12,8],[12,9,12,10],[12,11,12,12],[11,9,11,10],[11,11,11,12],[12,0,12,6],[16,0,16,6],[13,0,13,6],[11,0,11,6],[10,7,10,8],[16,7,16,8],[15,0,15,6],[15,7,15,8],[15,15,15,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],[17,9,17,10],[26,9,26,10],[16,15,16,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":"Piec na pellet"},null,null,null,null,null,null,"-",null,{"$f":"Baza!$I$5-J13","v":22140},null,{"$f":"Baza!$I$8-L13","v":20500},null,{"$f":"Baza!N19-N13","v":20500},null,{"$f":"J12-L12","v":1640}]
["Modernizacja CO i CWU",null,null,null,null,null,null,"-",null,{"$f":"L13*1.08","v":22140},null,20500,null,{"$f":"Baza!Q18","v":20500},null,{"$f":"J13-L13","v":1640}]
["Rekuperacja",null,null,null,null,null,null,"-",null,{"$f":"Baza!$J$5","v":0},null,{"$f":"Baza!$J$8","v":0},null,{"$f":"Baza!N20","v":0},null,0]
["AUDYT ENERGETYCZNY",null,null,null,null,null,null,null,null,{"$f":"Kalkulator!$I$23-492","v":{"$error":"#VALUE!"}},null,{"$f":"J15/1.23","v":{"$error":"#VALUE!"}}]
["ŚWIADECTWO CHARAKTERYSTYKI ENERGETYCZNEJ",null,null,null,null,null,null,"-",null,{"$f":"Kalkulator!$I$23-1476","v":{"$error":"#VALUE!"}},null,{"$f":"J16/1.23","v":{"$error":"#VALUE!"}},null,{"$f":"Baza!N25","v":0},null,{"$f":"J16-L16","v":{"$error":"#VALUE!"}}]
["Suma",null,null,null,null,null,null,"-",null,{"$f":"IF(Baza!$T$1=Baza!$A$12,SUM(Składowe!J12:K14)+Kalkulator!$I$23,SUM(Składowe!J12:K14))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(Baza!$T$1=Baza!$A$12,SUM(Składowe!L12:M14)+(Kalkulator!$I$23/1.23),SUM(Składowe!L12:M14))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(Baza!$T$4=Baza!$A$12,SUM(Składowe!N12:O14),SUM(Składowe!N12:O14))","v":41000},null,{"$f":"IF(Baza!$T$4=Baza!$A$12,SUM(Składowe!P12:Q14)+(J16-L16),SUM(Składowe!P12:Q14))","v":{"$error":"#VALUE!"}}]
["Wysokość wpłaty własnej",null,null,null,null,null,null,null,null,{"$f":"(J17-N17)","v":{"$error":"#VALUE!"}}]
[]
["Dach/stropodach/strop pod nieogrzewanym poddaszem",null,null,null,null,null,null,{"$f":"Kalkulator!C26","v":100},null,{"$f":"Baza!$K$5","v":0},null,{"$f":"Baza!$K$8","v":0},null,{"$f":"Baza!N21","v":0},null,0]
["Ściany zewnętrzne/przegrody pionowe",null,null,null,null,null,null,{"$f":"Kalkulator!C30","v":100},null,{"$f":"Baza!$L$5","v":0},null,{"$f":"Baza!$L$8","v":0},null,{"$f":"Baza!N22","v":0},null,0]
["Stolarka okienna",null,null,null,null,null,null,{"$f":"Kalkulator!C44","v":0},null,{"$f":"Baza!$N$5","v":0},null,{"$f":"Baza!$N$8","v":0},null,{"$f":"Baza!N23","v":0},null,0]
["Stolarka drzwiowa – drzwi zewnętrzne",null,null,null,null,null,null,{"$f":"Kalkulator!C35","v":0},null,{"$f":"Baza!$M$5","v":0},null,{"$f":"Baza!$M$8","v":0},null,{"$f":"Baza!N24","v":0},null,0]
["AUDYT ENERGETYCZNY",null,null,null,null,null,null,null,null,{"$f":"IF(AND(Kalkulator!$C$11=\"TAK\",Kalkulator!$I$23=\"\"),1476,Kalkulator!$I$23-492)","v":1476},null,{"$f":"$J$24/1.23","v":1200}]
["ŚWIADECTWO CHARAKTERYSTYKI ENERGETYCZNEJ",null,null,null,null,null,null,"-",null,{"$f":"IF(AND(Kalkulator!$C$11=\"TAK\",Kalkulator!$I$23=\"\"),492,Kalkulator!$I$23-1476)","v":492},null,{"$f":"$J$25/1.23","v":400},null,{"$f":"Baza!N25","v":0},null,{"$f":"J25-L25","v":92}]
["Suma",null,null,null,null,null,null,"-",null,{"$f":"SUM(J20:K23,J24:K25)","v":1968},null,{"$f":"SUM(L20:M23,L24:M25)","v":1600},null,{"$f":"SUM(N20:O23)","v":0},null,{"$f":"SUM(P20:Q23)+(J25-L25)","v":92}]
["Wysokość wpłaty własnej",null,null,null,null,null,null,null,null,{"$f":"(J26-N26)","v":1968}]
[]
["Kwota brutto",null,null,null,{"$f":"Kalkulator!I27","v":0}]
["Kwota netto",null,null,null,{"$f":"Kalkulator!I25","v":41000}]
["Dofinansowanie",null,null,null,{"$f":"Kalkulator!I21","v":41000}]
["Wpłata własna klienta",null,null,null,{"$f":"Kalkulator!I29","v":{"$error":"#VALUE!"}}]

{"sheet":"Kalkulator cen MAX","index":3,"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,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":4,"n_rows":19,"n_cols":25,"rows_kept":19,"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","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","Piec na pellet","NIE","NIE",null,"NIE","Dach","Wełna",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,"Piec zagazowujący drewno",null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,4,"Okno 4"]
[null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,7,"Okno 7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Okno 8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Okno 9"]
[null,null,null,null,null,null,null,null,null,null,null,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$23","v":"NIE"},{"$f":"IF($I$17=$I$2,_xlfn.UNIQUE($J$2:$J$3),\"\")","v":""},{"$f":"IF($I$17=$I$2,_xlfn.UNIQUE($K$2:$K$3),\"\")","v":""},null,null,null,null,null,{"$f":"Kalkulator!$B$33","v":"NIE"},{"$f":"IF($Q$17=$Q$2,_xlfn.UNIQUE($R$2:$R$4),\"\")","v":""},null,null,null,{"$f":"Kalkulator!$B$42","v":"NIE"},{"$f":"IF($V$17=$V$2,_xlfn.UNIQUE($W$2:$W$11),\"\")","v":""}]
[null,null,null,null,"Piec na pellet"]
[null,null,null,null,"Piec zagazowujący drewno"]

{"sheet":"Baza","index":5,"n_rows":28,"n_cols":24,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Pompa Ciepła",55700,null,null,{"$f":"F1*1.08","v":0},{"$f":"Kalkulator!I31","v":0},null,null,{"$f":"Kalkulator!C13","v":"TAK"},{"$f":"Kalkulator!B20","v":"NIE"},{"$f":"Kalkulator!B23","v":"NIE"},{"$f":"Kalkulator!B29","v":"NIE"},{"$f":"Kalkulator!B33","v":"NIE"},{"$f":"Kalkulator!B42","v":"NIE"},{"$f":"Kalkulator!B17","v":"NIE"},null,null,null,null,{"$f":"Kalkulator!B17","v":"NIE"},null,null,{"$f":"Kalkulator!C11","v":"TAK"}]
["Piec na pellet",41000,null,null,null,"Cena netto",null,null,{"$f":"Kalkulator!C14","v":"Piec na pellet"},"REKUPERACJA",{"$f":"Kalkulator!C25","v":"Piana PUR"},{"$f":"Kalkulator!B28","v":""},{"$f":"Kalkulator!C34","v":1},{"$f":"Kalkulator!C43","v":1},{"$f":"A9","v":"AUDYT"},null,null,null,null,"Termo"]
["Piec zagazowujący drewno",41000,null,null,null,null,null,null,null,{"$f":"IF(J1=A11,B4,0)","v":0},{"$f":"Kalkulator!C26","v":100},{"$f":"Kalkulator!C30","v":100},{"$f":"Kalkulator!C35","v":0},{"$f":"Kalkulator!C44","v":0},{"$f":"IF(O1=Baza!A11,B9,0)","v":0},null,null,null,null,{"$f":"IF(OR(J1=A11,K1=A11,L1=A11,M1=A11,N1=A11),A11,A12)","v":"NIE"}]
["REKUPERACJA",2000,null,null,null,{"$f":"SUM(I4:N4,F1)","v":41000},null,null,{"$f":"IF(I1=A11,_xlfn.IFS(I2=A1,B1,I2=A2,B2,I2=A3,B3),0)","v":41000},{"$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":0},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":41000},null,null,{"$f":"IF(A12=Kalkulator!B17,(Baza!I4*1.08)+Baza!E1,Baza!I4*1.08)","v":44280},{"$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":3280},null,null,{"$f":"_xlfn.IFS(F10='Dane wejściowe'!B3,Baza!I4*0.7,Baza!F10='Dane wejściowe'!B2,Baza!I4)","v":41000}]
["DRZWI",2500]
["OKNA",1200,null,null,null,{"$f":"F4+F6","v":44280},null,null,{"$f":"IF(A12=Kalkulator!B17,Baza!I4+Baza!F1,Baza!I4)","v":41000},{"$f":"J4","v":0},0,{"$f":"IF(AND(T1=A11,L4>0),L4+F1,L4)","v":0},0,0,0,null,null,null,null,null,null,null,null,1]
["AUDYT",1600,null,null,null,null,null,null,{"$f":"I5-I8","v":3280},{"$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!I20","v":41000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Kalkulator!I21","v":41000},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,"Piec 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":41000},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":0}]
[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!I27-F1*1.08)-Kalkulator!I21>0,((Kalkulator!I27-F1*1.08)-Kalkulator!I21)+Kalkulator!I23,(Kalkulator!I31*1.08)+Kalkulator!I23)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,{"$f":"F27+Kalkulator!I31*1.08","v":{"$error":"#VALUE!"}}]

{"sheet":"Kredyt","index":6,"n_rows":11,"n_cols":13,"rows_kept":11,"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!I29","v":{"$error":"#VALUE!"}},null,{"$f":"E2-F2","v":{"$error":"#VALUE!"}},0.12839999999999999,{"$f":"H2/12","v":1.0699999999999999E-2},{"$f":"Kalkulator!H17","v":5},{"$f":"J2*12","v":60},{"$f":"(G2/K2)+G2*0.006","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(IF(J2=VLOOKUP(J2,A2:A11,1,0),L2,0),\"-\")","v":"-"}]
[3,null,null,"Santander",{"$f":"Kalkulator!I29","v":{"$error":"#VALUE!"}},null,{"$f":"E3-F3","v":{"$error":"#VALUE!"}},0.12839999999999999,{"$f":"H3/12","v":1.0699999999999999E-2},{"$f":"Kalkulator!H17","v":5},{"$f":"IFERROR(J3*12,120)","v":60},{"$f":"(G3/K3)+G3*0.006","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(IF(J3=VLOOKUP(J3,A2:A7,1,0),L3,0),\"-\")","v":"-"}]
[4]
[5]
[6]
["83 miesiące"]
[7]
[8]
[9]
[10]

{"sheet":"Matryca","index":7,"n_rows":34,"n_cols":24,"rows_kept":34,"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":"Piec na pellet"},{"$f":"Kalkulator!C13","v":"TAK"},null,"TAK","Najwyższy","Pompa Ciepła",null,null,{"$f":"Kalkulator!B17","v":"NIE"},{"$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","Piec 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":41000},null,null,null,null,null,"Piec 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":41000}]
[]
["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"}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"WARUNKI(Matryca!N3=\"Nie dotyczy\";Matryca!N13;Matryca!N3<I25;Matryca!N3;Matryca!N3>=I25;I25-I31)"]

{"sheet":"Matryca termo","index":8,"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"]