{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Kalkulator","Raty kredytowe","Kredyt","Baza","Obliczenia","Arkusz1"],"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":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[28,5,28,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[26,5,26,6],[27,5,27,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"ER_Kalkulator_PC_01_05"]
[null,null,"Klient indywidualny"]
[]
[null,null,"Rodzaj Źródła Ciepła","Pompa Ciepła"]
[null,null,"Moc obliczeniowa",0.5]
[null,null,"Źródło Ciepła","Eco Heat 1F mono - 6kW",{"$f":"IF(D12=Baza!A1,\"\",IF(ISNA(MATCH(D14,_xlfn.ANCHORARRAY(Arkusz1!N3),0)),\"<- Wybierz poprawne źródło ciepła!\",\"\"))","v":""}]
[null,null,{"$f":"Obliczenia!E3","v":"Proponowana pompa ciepła"},{"$f":"Obliczenia!E4","v":"Eco Heat 1F mono - 6kW"}]
[null,null,"Ilość obiegów grzewczych","1 obieg - 1 - 1 pompa obiegowa",{"$f":"IF(D12=Baza!A3,\"\",IF(E14<>\"\",\"\",IF(ISNA(MATCH(D16,_xlfn.ANCHORARRAY(Arkusz1!Q3),0)),\"<- Wybierz poprawną ilość obiegów grzewczych!\",\"\")))","v":""}]
[]
[]
[]
[]
[null,null,"Eco Wakacje","NIE"]
[null,null,"Zasobnik CWU 200l","NIE"]
[null,null,"Wymiennik Ciepła","NIE"]
[null,null,"Zasobnik CWU 150l","NIE",null,"Dotacja Czyste Powietrze"]
[null,null,"Modernizacja CO/CWU","NIE",null,"TAK"]
[null,null,"Wykonanie wentylacji kotłowni","NIE",null,"POZIOM DOTACJI"]
[null,null,"Sterownik pokojowy bezprzewodowy","NIE",null,"PODSTAWOWY"]
[null,null,null,null,null,{"$f":"IF(D33=\"\",\"\",IF(F25=\"NIE\",\"\",(Obliczenia!O3+Obliczenia!O4)))","v":14080}]
[null,null,null,null,null,"Ulga Termomodernizacyjna"]
[null,null,"AUDYT + ŚWIADECTWO DO DOTACJI CZYSTE POWIETRZE","NIE",null,0.19,{"$f":"IF(D33=\"\",\"\",IF(F28=\"\",D33*F30,(D33-F28)*F30))","v":5790.9416000000001}]
[null,null,"Pakiet","STANDARD PLUS"]
[null,null,"Cena netto",{"$f":"IF(OR(E16<>\"\",E14<>\"\"),\"\",Obliczenia!$C$2)","v":41258},null,"Ilość lat kredytu:","Wpłata własna:"]
[null,null,"Cena brutto",{"$f":"IF(D32=\"\",\"\",IF(Obliczenia!$I$3<>\"\",Obliczenia!$I$3,Obliczenia!$I$4))","v":44558.64},null,6,0]
[null,null,"Cena brutto po dotacjach",{"$f":"IF(D33=\"\",\"\",IF(F28=\"\",(D33-G30),(D33-F28-G30)))","v":24687.698400000001}]
[]
[null,null,"MARŻA DODATKOWA",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!$J$2","v":6},null,"Ilość lat",{"$f":"Kredyt!$J$3","v":6}]
[null,null,"Cena instalacji brutto",{"$f":"Kredyt!$E$2","v":44558.64},null,"Cena instalacji brutto",{"$f":"Kredyt!$E$3","v":44558.64}]
[null,null,"Wkład własny",{"$f":"Kredyt!$F$2","v":0},null,"Wkład własny",{"$f":"Kredyt!$F$3","v":0}]
[null,null,"Kwota kredytu",{"$f":"Kredyt!$G$2","v":44558.64},null,"Kwota kredytu",{"$f":"Kredyt!$G$3","v":44558.64}]
[null,null,"Maksymalna kwota kredytu",100000,null,"Maksymalna kwota kredytu",80000]
[null,null,"RATA MIESIĘCZNA",{"$f":"Kredyt!$M$2","v":886.22183999999993},null,"RATA MIESIĘCZNA",{"$f":"Kredyt!$M$3","v":886.22183999999993}]

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

{"sheet":"Baza","index":3,"n_rows":54,"n_cols":24,"rows_kept":54,"cut":false,"hidden":true,"merged":[[4,14,4,15],[3,17,3,18],[0,1,0,2],[0,14,0,16],[0,17,0,19],[0,20,0,21],[0,3,0,5],[0,6,0,7],[0,8,0,9],[0,10,0,11],[0,12,0,13]]}
["Rodzaj kostrukcji","Marża",null,"Źródło Ciepła",null,null,"Ilość obiegów grzewczych",null,"Armatura",null,"Montaż",null,"Elektryka",null,"Marża EcoRun",null,null,"Marża Supreme",null,null,"Koszty dodatkowe",null,null,0.5]
["Pompa Ciepła","STANDARD PLUS",10000,"Nazwa","moc [kWp]","Cena netto/moduł [zł]","Nazwa","Cena","Nazwa","Cena","Nazwa","Cena","Nazwa","Cena",0,5,7000,0,9,8000,"Połączenie starego źródła ogrzewania z Pompą Ciepła",2000,null,1]
["Piec","STANDARD",8000,"Piec na pelet Ferroli 12 kW",12,19500,"1 obieg - 1 - 1 pompa obiegowa",2800,"Polipropylen",2000,"Montaż PC Polipropylen",6000,"elektryka pompa",600,5.01,9,9000,9.01,22,8000,"Odcięcie starego źródła ciepła",0,null,1.5]
[null,"RABAT",6000,"Piec na pelet Ferroli 18 kW",18,19500,"2 obiegi - 1 - 2 pompy obiegowe",3200,"armatura kocioł",200,"Montaż kocioł",3000,"elektryka kocioł",1363.11,9.01,22,8000,"PP",null,8000,"Wyniesienie starego źródła ciepła",1700,null,2]
[null,"MENAGO",4000,"Piec na pelet Ferroli 24 kW",24,19500,"1 obieg - 5/4 - 1 pompa obiegowa",3400,null,null,null,null,null,null,"PP",null,6500,null,null,null,"Eco Wakacje",600,null,2.5]
[null,null,null,"Piec zgazowujący PEREKO 14 kW",14,22500,"2 obiegi - 5/4 - 2 pompy obiegowe",3800,null,null,null,null,null,null,null,null,null,null,null,null,"Integracja z instalacją solarną",2000,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zalanie instalacji glikolem",1000,null,3.5]
[null,null,null,"Eco Heat 1F mono - 6kW",6,4858,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zasobink CWU 150l",1200,null,4]
[null,null,null,"Eco Heat 3F mono - 8kW",8,5385,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modernizacja CO/CWU czyste",20500,null,4.5]
[null,null,null,"Eco Heat 3F mono - 10kW",10,5913,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Skarbonka",500,null,5]
[null,null,null,"Eco Heat 3F mono - 12kW",12,6441,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zasobink CWU PC",2800,null,5.5]
[null,null,null,"Eco Heat 3F mono - 14kW",14,6969,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wykonanie wentylacji kotłowni",1000,null,6]
[null,null,null,"Eco Heat 3Fmono - 16kW",16,7497,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wymiennik Ciepła",2000,null,6.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sterownik pokojowy bezprzewodowy",null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Audyt",1600,null,7.5]
[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,null,null,null,null,null,null,null,"Modernizacja CO/CWU czyste",6000,null,8.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dotacja Czyste powietrze",null,null,11.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PC + podstawowy",14080,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PC + podwyższony",24640,null,12.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PC + najwyższy",35200,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PP + podstawowy",8200,null,13.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PP + podwyższony",14350,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PP + najwyższy",20500,null,14.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Co/CWU + podstawowy",8200,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Co/CWU + podwyższony",14350,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Co/CWU + najwyższy",20500,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Podstawowy",null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Podwyższony",null,null,18.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Najwyższy",null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]

{"sheet":"Obliczenia","index":4,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Kalkulator!$D$14","v":"Eco Heat 1F mono - 6kW"},"Cena jednostkowa","Cena dla instalacji",{"$f":"VLOOKUP(Kalkulator!$D$14,Baza!$D$3:$E$13,2,0)","v":6},{"$f":"_xlfn.CONCAT($D$1,\" kwp\")","v":"6 kwp"},null,null,"NIE"]
["Rodzaj instalacji",{"$f":"Kalkulator!$D$12","v":"Pompa Ciepła"},{"$f":"SUM(D30,C33:C35)","v":41258},null,null,null,null,"TAK"]
["Źródło Ciepła",{"$f":"VLOOKUP(Kalkulator!$D$14,Baza!D3:F13,3,0)","v":4858},{"$f":"_xlfn.IFS(Kalkulator!$D$12=Baza!$A$2,VLOOKUP(Kalkulator!$D$14,Baza!$D$8:$F$13,3,0),Kalkulator!$D$12=Baza!$A$3,VLOOKUP(Kalkulator!$D$14,Baza!$D$3:$F$7,3,0))","v":4858},null,{"$f":"_xlfn.IFS(Baza!A2=Kalkulator!D12,\"Proponowana pompa ciepła\",Baza!A3=Kalkulator!D12,\"Proponowany piec\")","v":"Proponowana pompa ciepła"},null,null,"Klient indywidualny",{"$f":"IF($H$3=Kalkulator!$C$10,(Obliczenia!$C$2-C19)*1.08+(C19*1.23),\"\")","v":44558.64},null,null,null,null,{"$f":"Kalkulator!F27","v":"PODSTAWOWY"},{"$f":"_xlfn.IFS(AND(B2=Baza!A2,Obliczenia!N3=Baza!U36),Baza!V24,AND(B2=Baza!A2,Obliczenia!N3=Baza!U37),Baza!V25,AND(B2=Baza!A2,Obliczenia!N3=Baza!U38),Baza!V26,AND(B2=Baza!A3,Obliczenia!N3=Baza!U36),Baza!V27,AND(B2=Baza!A3,Obliczenia!N3=Baza!U37),Baza!V28,AND(B2=Baza!A3,Obliczenia!N3=Baza!U38),Baza!V29)","v":14080}]
["Ilość obiegów grzewczych ",{"$f":"IF($B$2=Baza!$A$2,_xlfn.IFS(Kalkulator!$D$14=Baza!$D$8,VLOOKUP(Kalkulator!$D$16,Baza!$G$3:$H$4,2,0),Kalkulator!$D$14=Baza!$D$9,VLOOKUP(Kalkulator!$D$16,Baza!$G$3:$H$4,2,0),Kalkulator!$D$14=Baza!$D$10,VLOOKUP(Kalkulator!$D$16,Baza!$G$3:$H$4,2,0),Kalkulator!$D$14=VLOOKUP(Kalkulator!$D$14,Baza!$D$11:$D$13,1,0),VLOOKUP(Kalkulator!$D$16,Baza!$G$5:$H$6,2,0)),0)","v":2800},{"$f":"IF($B$2=Baza!$A$2,IFERROR(Obliczenia!B4,IFERROR(IF(Kalkulator!$D$14=VLOOKUP(Kalkulator!$D$14,Baza!$D$8:$D$10,1,0),Baza!$H$3,0),Baza!$H$5)))","v":2800},null,{"$f":"IF(Kalkulator!D12=Baza!A2,_xlfn.IFS(Kalkulator!D13<Obliczenia!N19,Obliczenia!O19,Kalkulator!D13<Obliczenia!N20,Obliczenia!O20,Kalkulator!D13<Obliczenia!N21,Obliczenia!O21,Kalkulator!D13<Obliczenia!N22,Obliczenia!O22,Kalkulator!D13<Obliczenia!N23,Obliczenia!O23,Kalkulator!D13<Obliczenia!N24,Obliczenia!O24),_xlfn.IFS(AND(Kalkulator!D12=Baza!A3,Baza!D6=Kalkulator!D14,Kalkulator!D13<Obliczenia!N31),Obliczenia!O31,AND(Kalkulator!D12=Baza!A3,Baza!D6=Kalkulator!D14,Kalkulator!D13>Obliczenia!N31),\"Potrzebujemy większej mocy pieca\",Kalkulator!D13<Obliczenia!N26,Obliczenia!O26,Kalkulator!D13<Obliczenia!N27,Obliczenia!O27,Kalkulator!D13<Obliczenia!N28,Obliczenia!O28,Kalkulator!D13<Obliczenia!N29,Obliczenia!O29))","v":"Eco Heat 1F mono - 6kW"},null,null,"Klient biznesowy",{"$f":"IF($H$4=Kalkulator!$C$10,Obliczenia!$C$2*1.23,\"\")","v":""},null,null,null,null,null,{"$f":"IF(AND(B2=Baza!A3,Kalkulator!D25=\"TAK\",Obliczenia!N3=Baza!U36),Baza!V30,IF(AND(B2=Baza!A3,Kalkulator!D25=\"TAK\",Obliczenia!N3=Baza!U37),Baza!V31,IF(AND(B2=Baza!A3,Kalkulator!D25=\"TAK\",Obliczenia!N3=Baza!U38),Baza!V32,0)))","v":0}]
["Armatura ",null,{"$f":"_xlfn.IFS(Kalkulator!$D$12=Baza!$A$2,Baza!$J$3,Kalkulator!$D$12=Baza!$A$3,Baza!$J$4)","v":2000},null,null,null,null,1]
["Montaż",null,{"$f":"_xlfn.IFS(Kalkulator!$D$12=Baza!$A$2,Baza!$L$3,Kalkulator!$D$12=Baza!$A$3,Baza!$L$4)","v":6000},null,null,null,null,3]
["elektryka ",null,{"$f":"_xlfn.IFS(Kalkulator!$D$12=Baza!$A$2,Baza!$N$3,Kalkulator!$D$12=Baza!$A$3,Baza!$N$4)","v":600}]
["Sterownik pokojowy bezprzewodowy",{"$f":"IF(Kalkulator!D27=Obliczenia!$H$2,Baza!V14,0)","v":0},{"$f":"B8","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PC"]
["Audyt",{"$f":"IF(Kalkulator!D30=Obliczenia!H2,Baza!V15,0)","v":0},{"$f":"B19","v":0},null,null,null,null,null,null,null,null,null,null,5.6,"Eco Heat 1F mono - 6kW"]
["Odcięcie starego źródła ciepła",{"$f":"Kalkulator!$D$19","v":0},0,null,null,null,null,null,null,null,null,null,null,7.6,"Eco Heat 3F mono - 8kW"]
["Wyniesienie starego źródła ciepła",{"$f":"IF(Kalkulator!D20=Obliczenia!$H$2,Baza!V4,0)","v":0},{"$f":"IF(B20=H2,B21,0)","v":0},null,null,null,null,null,null,null,null,null,null,9.6,"Eco Heat 3F mono - 10kW"]
["Eco Wakacje",{"$f":"IF(Kalkulator!D21=Obliczenia!$H$2,Baza!V5,0)","v":0},{"$f":"B22","v":0},null,null,null,null,null,null,null,null,null,null,11.6,"Eco Heat 3F mono - 12kW"]
["Zasobink CWU PC",{"$f":"IF(Kalkulator!D22=Obliczenia!$H$2,Baza!V11,0)","v":0},{"$f":"IF(B2=Baza!$A$2,Obliczenia!B23,0)","v":0},null,null,null,null,null,null,null,null,null,null,13.6,"Eco Heat 3F mono - 14kW"]
["Wymiennik Ciepła",{"$f":"IF(Kalkulator!D23=Obliczenia!H2,Baza!V13,0)","v":0},{"$f":"B24","v":0},null,null,null,null,null,null,null,null,null,null,15.6,"Eco Heat 3Fmono - 16kW"]
["Zasobink CWU 150l",{"$f":"IF(Kalkulator!D24=Obliczenia!$H$2,Baza!V8,0)","v":0},{"$f":"IF(Kalkulator!D12=Baza!A3,Obliczenia!B25,0)","v":0},null,null,null,null,null,null,null,null,null,null,"PP"]
["Modernizacja CO/CWU",{"$f":"IF(Kalkulator!D25=Obliczenia!$H$2,_xlfn.IFS(Kalkulator!F25=Obliczenia!H2,Baza!V9,Kalkulator!F25=Obliczenia!H1,Baza!V17),0)","v":0},{"$f":"IF($B$2=Baza!$A$3,Obliczenia!B26,0)","v":0},null,null,null,null,null,null,null,null,null,null,9.1,"Piec na pelet Ferroli 12 kW"]
["Wykonanie wentylacji kotłowni",{"$f":"IF(Kalkulator!D26=Obliczenia!$H$2,Baza!V12,0)","v":0},{"$f":"IF($B$2=Baza!$A$3,Obliczenia!B27,0)","v":0},null,null,null,null,null,null,null,null,null,null,15.1,"Piec na pelet Ferroli 18 kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,21.1,"Piec na pelet Ferroli 24 kW"]
["Marża EcoRun",{"$f":"_xlfn.IFS($A$1=Baza!$D$8,Baza!$Q$2,$A$1=Baza!$D$9,Baza!$Q$3,$A$1=Baza!$D$10,Baza!$Q$3,$A$1=Baza!$D$11,Baza!$Q$4,$A$1=Baza!$D$12,Baza!$Q$4,$A$1=Baza!$D$13,Baza!$Q$4,$A$1=VLOOKUP($A$1,Baza!$D$3:$D$7,1,0),Baza!$Q$5)","v":7000},{"$f":"B29","v":7000},null,null,null,null,null,null,null,null,null,null,27.1,"Piec na pelet Ferroli 24 kW"]
["Marża SupremeEnergy ",{"$f":"_xlfn.IFS($A$1=Baza!$D$8,Baza!$T$2,$A$1=Baza!$D$9,Baza!$T$2,$A$1=Baza!$D$10,Baza!$T$2,$A$1=Baza!$D$11,Baza!$T$3,$A$1=Baza!$D$12,Baza!$T$3,$A$1=Baza!$D$13,Baza!$T$3,$A$1=VLOOKUP($A$1,Baza!$D$3:$D$7,1,0),Baza!$T$4)","v":8000},{"$f":"B30","v":8000},{"$f":"IF(Kalkulator!D12=Baza!A3,VLOOKUP(Kalkulator!D14,Baza!D3:F6,3,0)+SUM(C19:C27,C30),SUM(C3:C30))","v":31258},null,null,null,null,null,null,null,null,null,"PZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,11.1,"Piec zgazowujący PEREKO 14 kW"]
[]
["Pakiet",{"$f":"_xlfn.IFS(Kalkulator!D31=Baza!B2,Baza!C2,Kalkulator!D31=Baza!B3,Baza!C3,Kalkulator!D31=Baza!B4,Baza!C4,Kalkulator!D31=Baza!B5,Baza!C5)","v":10000},{"$f":"$B$33","v":10000}]
[]
["Narzut dodany przez handlowca:",{"$f":"Kalkulator!$D$36","v":0},{"$f":"IF(Kalkulator!$D$31=Baza!$B$2,Obliczenia!$B$35,0)","v":0}]

{"sheet":"Arkusz1","index":5,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rodzaj Źródła Ciepła",null,null,"Ilość obiegów grzewczych"]
[null,null,null,"Pompa Ciepła","Eco Heat 1F mono - 6kW","1 obieg - 1 - 1 pompa obiegowa",null,null,null,null,null,null,{"$f":"Kalkulator!D12","v":"Pompa Ciepła"},{"$f":"IF(M3=Baza!A2,_xlfn.UNIQUE(_xlfn._xlws.FILTER(E:E,E:E<>\"\")),_xlfn.UNIQUE(Baza!D3:D6))","v":"Eco Heat 1F mono - 6kW"},null,{"$f":"Kalkulator!D14","v":"Eco Heat 1F mono - 6kW"},{"$f":"IF(P3=E14,_xlfn.UNIQUE(F13:F14),IF(P3=E3,_xlfn.UNIQUE(F3:F4),IF(P3=E5,_xlfn.UNIQUE(F5:F6),IF(P3=E7,_xlfn.UNIQUE(F7:F8),IF(P3=E9,_xlfn.UNIQUE(F9:F10),IF(P3=E11,_xlfn.UNIQUE(F11:F12),\"\"))))))","v":"1 obieg - 1 - 1 pompa obiegowa"}]
[null,null,null,null,"Eco Heat 1F mono - 6kW","2 obiegi - 1 - 2 pompy obiegowe",null,null,null,null,null,null,null,"Eco Heat 3F mono - 8kW",null,null,"2 obiegi - 1 - 2 pompy obiegowe"]
[null,null,null,null,"Eco Heat 3F mono - 8kW","1 obieg - 1 - 1 pompa obiegowa",null,null,null,null,null,null,null,"Eco Heat 3F mono - 10kW"]
[null,null,null,null,"Eco Heat 3F mono - 8kW","2 obiegi - 1 - 2 pompy obiegowe",null,null,null,null,null,null,null,"Eco Heat 3F mono - 12kW"]
[null,null,null,null,"Eco Heat 3F mono - 10kW","1 obieg - 1 - 1 pompa obiegowa",null,null,null,null,null,null,null,"Eco Heat 3F mono - 14kW"]
[null,null,null,null,"Eco Heat 3F mono - 10kW","2 obiegi - 1 - 2 pompy obiegowe",null,null,null,null,null,null,null,"Eco Heat 3Fmono - 16kW"]
[null,null,null,null,"Eco Heat 3F mono - 12kW","1 obieg - 5/4 - 1 pompa obiegowa"]
[null,null,null,null,"Eco Heat 3F mono - 12kW","2 obiegi - 5/4 - 2 pompy obiegowe"]
[null,null,null,null,"Eco Heat 3F mono - 14kW","1 obieg - 5/4 - 1 pompa obiegowa"]
[null,null,null,null,"Eco Heat 3F mono - 14kW","2 obiegi - 5/4 - 2 pompy obiegowe"]
[null,null,null,null,"Eco Heat 3Fmono - 16kW","1 obieg - 5/4 - 1 pompa obiegowa"]
[null,null,null,null,"Eco Heat 3Fmono - 16kW","2 obiegi - 5/4 - 2 pompy obiegowe"]