{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Kalkulator","Raty kredytowe","Dane wejściowe","Baza","Kredyt","Matryca"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":0,"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":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[27,2,27,3],[20,2,20,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[26,2,26,3],[18,2,18,3],[25,2,25,3],[17,2,17,3],[19,2,19,3],[9,2,9,3],[8,2,8,3],[16,2,16,3],[12,2,12,3],[11,2,11,3],[10,2,10,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Poziom dotacji","Podwyższony"]
[null,"PC/PIEC","NIE"]
[null,{"$f":"IF($C$10='Dane wejściowe'!$D$2,'Dane wejściowe'!$E$1,\"\")","v":""},"Pompa Ciepła"]
[null,"REKUPERACJA","NIE"]
[null,"OCIEPLENIE DACH/STROP","NIE"]
[null,{"$f":"IF($C$13='Dane wejściowe'!$I$2,'Dane wejściowe'!$J$1,\"\")","v":""},"Dach"]
[null,{"$f":"IF($C$13='Dane wejściowe'!$I$2,'Dane wejściowe'!$K$1,\"\")","v":""},"Piana PUR"]
[null,{"$f":"IF($C$13='Dane wejściowe'!$I$2,'Dane wejściowe'!$L$1,\"\")","v":""}]
[null,"OCIEPLENIE ŚCIAN ZEWNĘTRZNYCH","NIE"]
[null,{"$f":"IF($C$17='Dane wejściowe'!$N$2,'Dane wejściowe'!$O$1,\"\")","v":""}]
[null,"DRZWI","NIE"]
[null,{"$f":"IF($C$19='Dane wejściowe'!$Q$2,'Dane wejściowe'!$R$1,\"\")","v":""},1]
[null,{"$f":"IF($C$19='Dane wejściowe'!$Q$2,\"SUMA POWIERZCHNI DRZWI\",\"\")","v":""},{"$f":"SUM(($C$23*$D$23),($C$24*$D$24),($C$25*$D$25))","v":0}]
[null,null,{"$f":"IF($C$19='Dane wejściowe'!$Q$2,'Dane wejściowe'!$T$2,\"\")","v":""},{"$f":"IF($C$19='Dane wejściowe'!$Q$2,'Dane wejściowe'!$T$3,\"\")","v":""},null,null,null,"Ilość lat kredytu:","Wpłata własna:"]
[null,{"$f":"IF(AND($C$19='Dane wejściowe'!$Q$2,$C$20>='Dane wejściowe'!$R$2),'Dane wejściowe'!$S$2,\"\")","v":""},null,null,null,null,null,5,0]
[null,{"$f":"IF(AND($C$19='Dane wejściowe'!$Q$2,$C$20>='Dane wejściowe'!$R$3),'Dane wejściowe'!$S$3,\"\")","v":""}]
[null,{"$f":"IF(AND($C$19='Dane wejściowe'!$Q$2,$C$20>='Dane wejściowe'!$R$4),'Dane wejściowe'!$S$4,\"\")","v":""}]
[null,"OKNA","NIE"]
[null,{"$f":"IF($C$26='Dane wejściowe'!$V$2,'Dane wejściowe'!$W$1,\"\")","v":""},1,null,null,null,null,"MAX DOTACJA CZYSTE POWIETRZE",{"$f":"Matryca!N13","v":83000}]
[null,{"$f":"IF($C$26='Dane wejściowe'!$V$2,\"SUMA POWIERZCHNI OKIEN\",\"\")","v":""},{"$f":"SUM(PRODUCT($C$30:$D$30),PRODUCT($C$31:$D$31),PRODUCT($C$32:$D$32),PRODUCT($C$33:$D$33),PRODUCT($C$34:$D$34),PRODUCT($C$35:$D$35),PRODUCT($C$36:$D$36),PRODUCT($C$37:$D$37),PRODUCT($C$38:$D$38),PRODUCT($C$39:$D$39))","v":0},null,null,null,null,"WYKORZYSTNA DOTACJA CZYSTE POWIETRZE",{"$f":"Matryca!N3","v":33600}]
[null,null,{"$f":"IF($C$26='Dane wejściowe'!$V$2,'Dane wejściowe'!$Y$2,\"\")","v":""},{"$f":"IF($C$26='Dane wejściowe'!$V$2,'Dane wejściowe'!$Y$3,\"\")","v":""}]
[null,{"$f":"IF(AND($C$26='Dane wejściowe'!$V$2,$C$27>='Dane wejściowe'!$W$2),'Dane wejściowe'!$X$2,\"\")","v":""}]
[null,{"$f":"IF(AND($C$26='Dane wejściowe'!$V$2,$C$27>='Dane wejściowe'!$W$3),'Dane wejściowe'!$X$3,\"\")","v":""},null,null,null,null,null,"CENA NETTO",{"$f":"Baza!F4","v":1600}]
[null,{"$f":"IF(AND($C$26='Dane wejściowe'!$V$2,$C$27>='Dane wejściowe'!$W$4),'Dane wejściowe'!$X$4,\"\")","v":""},null,null,null,null,null,"VAT",{"$f":"Baza!F6","v":368}]
[null,{"$f":"IF(AND($C$26='Dane wejściowe'!$V$2,$C$27>='Dane wejściowe'!$W$5),'Dane wejściowe'!$X$5,\"\")","v":""},null,null,null,null,null,"CENA BRUTTO",{"$f":"Baza!F8","v":1968}]
[null,{"$f":"IF(AND($C$26='Dane wejściowe'!$V$2,$C$27>='Dane wejściowe'!$W$6),'Dane wejściowe'!$X$6,\"\")","v":""},null,null,null,null,null,"Wpłata własna klienta",{"$f":"IF(I33-I28>0,I33-I28,0)","v":0}]
[null,{"$f":"IF(AND($C$26='Dane wejściowe'!$V$2,$C$27>='Dane wejściowe'!$W$7),'Dane wejściowe'!$X$7,\"\")","v":""}]
[null,{"$f":"IF(AND($C$26='Dane wejściowe'!$V$2,$C$27>='Dane wejściowe'!$W$8),'Dane wejściowe'!$X$8,\"\")","v":""},null,null,null,null,null,"MARŻA DODATKOWA"]
[null,{"$f":"IF(AND($C$26='Dane wejściowe'!$V$2,$C$27>='Dane wejściowe'!$W$9),'Dane wejściowe'!$X$9,\"\")","v":""}]
[null,{"$f":"IF(AND($C$26='Dane wejściowe'!$V$2,$C$27>='Dane wejściowe'!$W$10),'Dane wejściowe'!$X$10,\"\")","v":""}]
[null,{"$f":"IF(AND($C$26='Dane wejściowe'!$V$2,$C$27>='Dane wejściowe'!$W$11),'Dane wejściowe'!$X$11,\"\")","v":""}]

{"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":0},null,"Cena instalacji brutto",{"$f":"Kredyt!E3","v":0}]
[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":0},null,"Kwota kredytu",{"$f":"Kredyt!G3","v":0}]
[null,null,"Maksymalna kwota kredytu",100000,null,"Maksymalna kwota kredytu",80000]
[null,null,"RATA MIESIĘCZNA",{"$f":"Kredyt!M2","v":0},null,"RATA MIESIĘCZNA",{"$f":"Kredyt!M3","v":0}]

{"sheet":"Dane wejściowe","index":2,"n_rows":17,"n_cols":25,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[null,"Poziom dotacji",null,"PC/PIEC","Źródło grzewcze",null,"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.)"]
[null,"Najwyższy",null,"TAK","Pompa Ciepła",null,"TAK",null,"TAK","Strop","Piana PUR",null,null,"TAK",null,null,"TAK",1,"Drzwi 1","Wysokość",null,"TAK",1,"Okno 1","Wysokość"]
[null,"Podwyższony",null,"NIE","Piec na pellet",null,"NIE",null,"NIE","Dach","Wełna",null,null,"NIE",null,null,"NIE",2,"Drzwi 2","Szerokość",null,"NIE",2,"Okno 2","Szerokość"]
[null,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$10","v":"NIE"},{"$f":"IF($D$17=$D$2,_xlfn.UNIQUE($E$2:$E$4),\"\")","v":""},null,null,null,{"$f":"Kalkulator!$C$13","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!$C$19","v":"NIE"},{"$f":"IF($Q$17=$Q$2,_xlfn.UNIQUE($R$2:$R$4),\"\")","v":""},null,null,null,{"$f":"Kalkulator!$C$26","v":"NIE"},{"$f":"IF($V$17=$V$2,_xlfn.UNIQUE($W$2:$W$11),\"\")","v":""}]

{"sheet":"Baza","index":3,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Pompa Ciepła",55700,null,null,null,{"$f":"Kalkulator!I36","v":0},null,null,{"$f":"Kalkulator!C10","v":"NIE"},{"$f":"Kalkulator!C12","v":"NIE"},{"$f":"Kalkulator!C13","v":"NIE"},{"$f":"Kalkulator!C17","v":"NIE"},{"$f":"Kalkulator!C19","v":"NIE"},{"$f":"Kalkulator!C26","v":"NIE"}]
["Piec na pellet",41000,null,null,null,"Cena netto",null,null,{"$f":"Kalkulator!C11","v":"Pompa Ciepła"},"REKUPERACJA",{"$f":"Kalkulator!C15","v":"Piana PUR"},{"$f":"Kalkulator!B17","v":"OCIEPLENIE ŚCIAN ZEWNĘTRZNYCH"},{"$f":"Kalkulator!C20","v":1},{"$f":"Kalkulator!C27","v":1},{"$f":"A9","v":"AUDYT"}]
["Piec zagazowujący drewno",41000,null,null,null,null,null,null,null,null,{"$f":"Kalkulator!C16","v":0},{"$f":"Kalkulator!C18","v":0},{"$f":"Kalkulator!C21","v":0},{"$f":"Kalkulator!C28","v":0}]
["REKUPERACJA",16000,null,null,null,{"$f":"SUM(I4:T4)+F1","v":1600},null,null,{"$f":"IF(I1=A11,_xlfn.IFS(I2=A1,B1,I2=A2,B2,I2=A3,B3),0)","v":0},{"$f":"IF(J1=A11,B4,0)","v":0},{"$f":"IF(K1=A11,K3*B5,0)","v":0},{"$f":"IF(L1=A11,L3*B6,0)","v":0},{"$f":"IF(M1=A11,M3*B7,0)","v":0},{"$f":"IF(N1=A11,N3*B8,0)","v":0},{"$f":"B9","v":1600}]
["OCIEPLENIE DACH STROP",200,null,null,null,{"$f":"F4-B9","v":0}]
["OCIEPLENIE ŚCIAN ZEWNĘTRZNYCH",250,null,null,null,{"$f":"(F5*0.08)+(B9*0.23)","v":368},null,null,{"$f":"_xlfn.IFS(F10='Dane wejściowe'!B3,Baza!I4*0.7,Baza!F10='Dane wejściowe'!B2,Baza!I4)","v":0}]
["DRZWI",2500]
["OKNA",1200,null,null,null,{"$f":"F4+F6","v":1968}]
["AUDYT",1600]
[null,null,null,null,null,{"$f":"Kalkulator!C9","v":"Podwyższony"}]
["TAK"]
["NIE"]

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

{"sheet":"Matryca","index":5,"n_rows":23,"n_cols":20,"rows_kept":23,"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":"Podwyższony"},{"$f":"Kalkulator!B11","v":""},{"$f":"Kalkulator!C11","v":"Pompa Ciepła"},{"$f":"Kalkulator!C10","v":"NIE"},null,"TAK","Najwyższy","Pompa Ciepła"]
["Podstawowy(80-140)",19200,null,null,"Podstawowy(80-140)",37200,null,null,"Podstawowy(80-140)",{"$f":"B2+K21+1600","v":43080},null,null,null,null,null,null,null,"NIE","Podwyższony","Piec na pellet"]
["Podstawowy(>140)",33200,null,null,"Podstawowy(>140)",51200,null,null,"Podstawowy(>140)",{"$f":"B3+K21+1600","v":57080},null,null,null,{"$f":"IF(P1=R1,_xlfn.IFS(AND(M1=S1,O1=T1),J9,AND(M1=S2,O1=T1),J5,AND(M1=S1,O1=T2),F9,AND(M1=S2,O1=T2),F5,AND(M1=S1,O1=T3),F9,AND(M1=S2,O1=T3),F5),_xlfn.IFS(M1=S1,B9,M1=S2,B5))","v":33600},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)",33600,null,null,"Podwyższony(80-140)",63900,null,null,"Podwyższony(80-140)",{"$f":"B5+K22+1600","v":74190}]
["Podwyższony(>140)",58100,null,null,"Podwyższony(>140)",88400,null,null,"Podwyższony(>140)",{"$f":"B6+K22+1600","v":98690}]
["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)",83000,null,null,"Najwyższy(>140)",125600,null,null,"Najwyższy(>140)",{"$f":"B9+K23+1600","v":140300},null,null,"Pompa + Termo",140300]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kocioł + Termo",125600]
[null,null,null,null,null,null,null,null,null,null,null,null,"Termo",83000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P1=R1,_xlfn.IFS(O1=T1,N9,O1=T2,N10,O1=T3,N10),N11)","v":83000}]
[]
["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]