{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Kalkulator","Raty kredytowe","Kredyt","Obliczenia","Baza","Arkusz1"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":[[7,4,10,4],[24,5,24,6],[23,5,23,6],[11,5,11,6],[28,5,28,6],[25,5,25,6],[26,5,26,6],[27,5,27,6],[12,5,18,6]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"IF(D12=\"Pompa Ciepła\",\"* W przypadku braku dostępności - Model  i Producent urządzenia może ulec zmianie, na produkt o takich samych parametrach technicznych, po wcześniejszym poinformowaniu i akceptacji klienta oraz PH\",\"\")","v":"* W przypadku braku dostępności - Model  i Producent urządzenia może ulec zmianie, na produkt o takich samych parametrach technicznych, po wcześniejszym poinformowaniu i akceptacji klienta oraz PH"}]
[null,null,"ER_Kalkulator_PC_01_05"]
[null,null,"Klient indywidualny"]
[]
[null,null,"Rodzaj Źródła Ciepła","Pompa Ciepła",null,"Cena zestawu obejmuje:"]
[null,null,"Moc obliczeniowa",0.5,null,{"$f":"IF($E$14=\"<- Wybierz poprawne źródło ciepła!\",\"\",\nIF($D$12=Baza!$A$2,Baza!E49,\nIF(AND($D$12=Baza!$A$3,OR(Kalkulator!$D$14=Baza!$D$14,Kalkulator!$D$14=Baza!$D$15,Kalkulator!$D$14=Baza!$D$16)),Baza!E50,Baza!E52)))","v":"- Pompa Ciepła\n- materiały montażowe kotłowni\n- montaż i uruchomienie\n- zasobnik CWU 300l z grzałką\n- zbiornik buforowy 200l"}]
[null,null,"Źródło Ciepła","Eco Heat 3Fmono - 16kW",{"$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,"Dopłata do drugiego obiegu","TAK"]
[]
[null,null,"Wkłady kominowe","TAK"]
[null,null,"Zasobnik CWU do kotła 200l  ","TAK"]
[null,null,"Wymiennik ciepła płytowy, gdy klient chce pozostawić drugie źródło ciepła w układzie otwartym","TAK"]
[null,null,"Eco Wakacje"]
[]
[]
[null,null,null,null,null,"Dotacja Czyste Powietrze"]
[null,null,null,null,null,"TAK"]
[null,null,null,null,null,"POZIOM DOTACJI"]
[null,null,"Grzejnik + termostat",1,null,"NAJWYŻSZY"]
[null,null,"Grzejniki + wykonanie CO",1,null,{"$f":"IF(D33=\"\",\"\",IF(F25=\"NIE\",\"\",(Obliczenia!O3+Obliczenia!O5+Obliczenia!O6)))","v":41450}]
[null,null,null,null,null,"Ulga Termomodernizacyjna"]
[null,null,"AUDYT + ŚWIADECTWO DO DOTACJI CZYSTE POWIETRZE","TAK",null,0.19,{"$f":"IF(D33=\"\",\"\",IF(F28=\"\",D33*F30,(D33-F28)*F30))","v":6610.2189400000007}]
[null,null,"Pakiet","STANDARD PLUS"]
[null,null,"Cena netto",{"$f":"IF(OR(E16<>\"\",E14<>\"\"),\"\",Obliczenia!$C$2)","v":70245.95},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":76240.626000000004},null,6,0]
[null,null,"Cena brutto po dotacjach",{"$f":"IF(D33=\"\",\"\",IF(F28=\"\",(D33-G30),(D33-F28-G30)))","v":28180.407060000005}]
[]
[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":76240.626000000004},null,"Cena instalacji brutto",{"$f":"Kredyt!$E$3","v":76240.626000000004}]
[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":76240.626000000004},null,"Kwota kredytu",{"$f":"Kredyt!$G$3","v":76240.626000000004}]
[null,null,"Maksymalna kwota kredytu",100000,null,"Maksymalna kwota kredytu",80000]
[null,null,"RATA MIESIĘCZNA",{"$f":"Kredyt!$M$2","v":1516.3413393333335},null,"RATA MIESIĘCZNA",{"$f":"Kredyt!$M$3","v":1516.3413393333335}]

{"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":76240.626000000004},{"$f":"Kalkulator!$G$33","v":0},{"$f":"E2-F2","v":76240.626000000004},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":1516.3413393333335},{"$f":"IFERROR(IF(J2=VLOOKUP(J2,A2:A11,1,0),L2,0),\"-\")","v":1516.3413393333335}]
[3,null,null,"Santander",{"$f":"Kalkulator!$D$33","v":76240.626000000004},{"$f":"Kalkulator!$G$33","v":0},{"$f":"E3-F3","v":76240.626000000004},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":1516.3413393333335},{"$f":"IFERROR(IF(J3=VLOOKUP(J3,A2:A7,1,0),L3,0),\"-\")","v":1516.3413393333335}]
[4]
[5]
[6]
["83 miesiące"]
[7]
[8]
[9]
[10]

{"sheet":"Obliczenia","index":3,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Kalkulator!$D$14","v":"Eco Heat 3Fmono - 16kW"},"Cena jednostkowa","Cena dla instalacji",{"$f":"VLOOKUP(Kalkulator!$D$14,Baza!$D$8:$E$19,2,0)","v":16},{"$f":"_xlfn.CONCAT($D$1,\" kwp\")","v":"16 kwp"},null,null,"NIE"]
["Rodzaj instalacji",{"$f":"Kalkulator!$D$12","v":"Pompa Ciepła"},{"$f":"SUM(D30,C33:C35)","v":70245.95},null,null,null,null,"TAK"]
["Źródło Ciepła",{"$f":"VLOOKUP(Kalkulator!$D$14,Baza!$D$8:$F$19,3,0)","v":39170},{"$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$14:$F$19,3,0))","v":39170},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-C28)*1.08+(C28*1.23),\"\")","v":76240.626000000004},null,null,null,null,{"$f":"Kalkulator!F27","v":"NAJWYŻSZY"},{"$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":35200}]
["Ilość obiegów grzewczych ",{"$f":"IF(Kalkulator!$D$16=\"TAK\",1925.95,0)","v":1925.95},{"$f":"B4","v":1925.95},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(Kalkulator!D26=\"TAK\",Obliczenia!N3=Baza!U36),Baza!W33,IF(AND(Kalkulator!D26=\"TAK\",Obliczenia!N3=Baza!U37),Baza!W34,IF(AND(Kalkulator!D26=\"TAK\",Obliczenia!N3=Baza!U38),Baza!W35,0)))","v":0},"JEŻELI(ORAZ(Kalkulator!D26=\"TAK\";Obliczenia!N3=Baza!U36);Baza!V30;JEŻELI(ORAZ(Kalkulator!D26=\"TAK\";Obliczenia!N3=Baza!U37);Baza!V31;JEŻELI(ORAZ(Kalkulator!D26=\"TAK\";Obliczenia!N3=Baza!U38);Baza!V32;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":0},null,null,null,null,1,null,null,null,null,null,null,{"$f":"IF(Obliczenia!$N$3=Baza!U36,Baza!$W$33,IF(Obliczenia!$N$3=Baza!U37,Baza!$W$34,IF(Obliczenia!$N$3=Baza!U38,Baza!$W$35,0)))","v":4650}]
["Montaż",null,{"$f":"_xlfn.IFS(Kalkulator!$D$12=Baza!$A$2,Baza!$L$3,Kalkulator!$D$12=Baza!$A$3,Baza!$L$4)","v":0},null,null,null,null,3,null,null,null,null,null,null,{"$f":"IF(Obliczenia!$N$3=Baza!U36,Baza!$W$39,IF(Obliczenia!$N$3=Baza!U37,Baza!$W$40,IF(Obliczenia!$N$3=Baza!U38,Baza!$W$41,0)))","v":1600}]
["elektryka ",null,{"$f":"_xlfn.IFS(Kalkulator!$D$12=Baza!$A$2,Baza!$N$3,Kalkulator!$D$12=Baza!$A$3,Baza!$N$4)","v":0}]
["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"]
["Wkłady kominowe",{"$f":"Kalkulator!$D$18","v":"TAK"},{"$f":"IF(AND($B$2=Baza!$A$3,Obliczenia!$B$19=$H$2),VLOOKUP(A19,Baza!$U$2:$V$11,2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,5.6,"Eco Heat 1F mono - 6kW"]
["Zasobnik CWU do kotła 200l  ",{"$f":"Kalkulator!$D$19","v":"TAK"},{"$f":"IF(AND(Kalkulator!$D$12=Baza!$A$3,B20=H2),VLOOKUP(A20,Baza!$U$2:$V$11,2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,7.6,"Eco Heat 3F mono - 8kW"]
["Wymiennik ciepła płytowy, gdy klient chce pozostawić drugie źródło ciepła w układzie otwartym",{"$f":"Kalkulator!$D$20","v":"TAK"},{"$f":"IF(B21=H2,VLOOKUP(A21,Baza!$U$2:$V$11,2,FALSE),0)","v":2000},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,VLOOKUP(A22,Baza!$U$2:$V$15,2,FALSE),0)","v":0},{"$f":"B22","v":0},null,null,null,null,null,null,null,null,null,null,11.6,"Eco Heat 3F mono - 12kW"]
["PC do CWU",{"$f":"IF(Kalkulator!D26=Obliczenia!$H$2,VLOOKUP(A23,Baza!$U$2:$V$15,2,FALSE),0)","v":0},{"$f":"B23","v":0},null,null,null,null,null,null,null,null,null,null,13.6,"Eco Heat 3F mono - 14kW"]
["Grzejnik + termostat",{"$f":"Kalkulator!D27","v":1},{"$f":"B24*VLOOKUP(A24,Baza!$U$2:$V$10,2,FALSE)","v":1850},{"$f":"SUM(C24:C25)","v":4650},null,null,null,null,null,null,null,null,null,15.6,"Eco Heat 3Fmono - 16kW"]
["Grzejniki + wykonanie CO",{"$f":"Kalkulator!D28","v":1},{"$f":"B25*VLOOKUP(A25,Baza!$U$2:$V$10,2,FALSE)","v":2800},null,null,null,null,null,null,null,null,null,null,"PP"]
["Wykonanie instalacji CWU",{"$f":"IF(Kalkulator!D29=Obliczenia!$H$2,VLOOKUP(A26,Baza!$U$2:$V$15,2,FALSE),0)","v":0},{"$f":"B26","v":0},null,null,null,null,null,null,null,null,null,null,9.1,"Kocioł na biopellet Ferroli 12 kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,15.1,"Kocioł na biopellet Ferroli 18 kW"]
["AUDYT + ŚWIADECTWO DO DOTACJI CZYSTE POWIETRZE",{"$f":"IF(Kalkulator!D30=Obliczenia!$H$2,VLOOKUP(A28,Baza!$U$2:$V$15,2,FALSE),0)","v":2500},{"$f":"B28","v":2500},null,null,null,null,null,null,null,null,null,null,21.1,"Kocioł na biopellet 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$14:$D$19,1,0),Baza!$Q$5)","v":0},{"$f":"B29","v":0},null,null,null,null,null,null,null,null,null,null,27.1,"Kocioł na biopellet 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$14:$D$19,1,0),Baza!$T$4)","v":10000},{"$f":"B30","v":10000},{"$f":"SUM(C3:C30)","v":60245.95},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,"Kocioł 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":"Baza","index":4,"n_rows":58,"n_cols":24,"rows_kept":58,"cut":false,"hidden":true,"merged":[[0,20,0,21],[0,3,0,5],[0,6,0,7],[0,8,0,9],[0,10,0,11],[0,12,0,13],[4,14,4,15],[3,17,3,18],[0,1,0,2],[0,14,0,16],[0,17,0,19]]}
["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",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,null,0,9,10000,"Wkłady kominowe",3000,null,1]
["Kocioł","STANDARD",8000,null,null,null,"1 obieg - 1 - 1 pompa obiegowa",null,"Polipropylen",null,"Montaż PC Polipropylen",null,"elektryka pompa",null,5.01,9,null,9.01,22,10000,"Zasobnik CWU do kotła 200l  ",2500,null,1.5]
[null,"RABAT",6000,null,null,null,"2 obiegi - 1 - 2 pompy obiegowe",null,"armatura kocioł",null,"Montaż kocioł",null,"elektryka kocioł",null,9.01,22,null,"PP",null,8000,"Wymiennik ciepła płytowy, gdy klient chce pozostawić drugie źródło ciepła w układzie otwartym",2000,null,2]
[null,"MENAGO",4000,null,null,null,"1 obieg - 5/4 - 1 pompa obiegowa",null,null,null,null,null,null,null,"PP",null,null,null,null,null,"Eco Wakacje",600,null,2.5]
[null,null,null,null,null,null,"2 obiegi - 5/4 - 2 pompy obiegowe",null,null,null,null,null,null,null,null,null,null,null,null,null,"PC do CWU",20500,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grzejnik + termostat",1850,null,3.5]
[null,null,null,"Eco Heat 1F mono - 6kW",6,28900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grzejniki + wykonanie CO",2800,null,4]
[null,null,null,"Eco Heat 3F mono - 8kW",8,30200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wykonanie instalacji CWU",3500,null,4.5]
[null,null,null,"Eco Heat 3F mono - 10kW",10,30200,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,30720,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.5]
[null,null,null,"Eco Heat 3F mono - 14kW",14,38520,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,"Eco Heat 3Fmono - 16kW",16,39170,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.5]
[null,null,null,"Kocioł na biopellet 12KW Ferroli",12,20500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,"Kocioł na biopellet 18KW  Ferroli",18,20500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUDYT + ŚWIADECTWO DO DOTACJI CZYSTE POWIETRZE",2500,null,7.5]
[null,null,null,"Kocioł na biopellet 24KW   Ferroli",24,20500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,"Ferroli Kocioł zagazowujący drewno CGF PRO 12",12,26710,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.5]
[null,null,null,"Ferroli Kocioł zagazowujący drewno CGF PRO 16",16,27040,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,"Ferroli Kocioł zagazowujący drewno CGF PRO 22",22,28400.799999999999,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,{"$f":"V24/V26","v":0.4},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,{"$f":"V25/V26","v":0.7},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,{"$f":"V27/V29","v":0.4},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,{"$f":"V28/V29","v":0.7},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,{"$f":"V30/V32","v":0.4},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,{"$f":"V31/V32","v":0.7},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,{"$f":"Obliczenia!D24","v":4650},"Grzejniki + podstawowy",8200,{"$f":"IF($T$33>V33,V33,$T$33*0.4)","v":1860},16.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grzejniki + podwyższony",14350,{"$f":"IF($T$33>V34,V34,$T$33*0.7)","v":3255},17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grzejniki + najwyższy",20500,{"$f":"IF($T$33>V35,V35,$T$33)","v":4650},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,"AUDYT + ŚWIADECTWO DO DOTACJI CZYSTE POWIETRZE + podstawowy",640,{"$f":"IF(Kalkulator!$D$30=Obliczenia!$H$2,Baza!V39)","v":640},19.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUDYT + ŚWIADECTWO DO DOTACJI CZYSTE POWIETRZE + podwyższony",1120,{"$f":"IF(Kalkulator!$D$30=Obliczenia!$H$2,Baza!V40)","v":1120},20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUDYT + ŚWIADECTWO DO DOTACJI CZYSTE POWIETRZE + najwyższy",1600,{"$f":"IF(Kalkulator!$D$30=Obliczenia!$H$2,Baza!V41)","v":1600},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]
["Pompa Ciepła","- Pompa Ciepła\n- materiały montażowe kotłowni\n- montaż i uruchomienie\n- zasobnik CWU 300l z grzałką\n- zbiornik buforowy 200l",null,null,{"$f":"_xlfn.UNIQUE(B49)","v":"- Pompa Ciepła\n- materiały montażowe kotłowni\n- montaż i uruchomienie\n- zasobnik CWU 300l z grzałką\n- zbiornik buforowy 200l"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24.5]
["Kocioł na biopellet","- Kocioł na biopellet\n- materiały montażowe kotłowni\n- montaż i uruchomienie\n- wkład kominowy",null,null,{"$f":"_xlfn.UNIQUE(B50&\"\n\"&B51)","v":"- Kocioł na biopellet\n- materiały montażowe kotłowni\n- montaż i uruchomienie\n- wkład kominowy\n"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
["Zasobnik CWU do kotła 200l  ",{"$f":"C51","v":""},{"$f":"IF(AND(Kalkulator!$D$12=Baza!$A$3,Kalkulator!$D$19=\"TAK\"),\"- zasobnik CWU 200l\",\"\")","v":""}]
["Kocioł zagazowujący drewno","- Kocioł zagazowujący drewno\n- materiały montażowe kotłowni\n- montaż i uruchomienie\n- wkład kominowy",null,null,{"$f":"_xlfn.UNIQUE(B52&\"\n\"&B53&\"\n\"&B54)","v":"- Kocioł zagazowujący drewno\n- materiały montażowe kotłowni\n- montaż i uruchomienie\n- wkład kominowy\n\n"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25.5]
["Zbiornik buforowy 800 lub 1000l",{"$f":"C53","v":""},{"$f":"IF(AND(Kalkulator!$D$12=Baza!$A$3,Kalkulator!$D$14=Baza!$D$17),\"- zbiornik buforowy 500 - 800l\",IF(AND(Kalkulator!$D$12=Baza!$A$3,Kalkulator!$D$14=Baza!$D$18),\"- zbiornik buforowy 800l\",IF(AND(Kalkulator!$D$12=Baza!$A$3,Kalkulator!$D$14=Baza!$D$19),\"- zbiornik buforowy 1000l\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
["Zasobnik CWU do kotła 200l  ",{"$f":"C54","v":""},{"$f":"IF(AND(Kalkulator!$D$12=Baza!$A$3,Kalkulator!$D$19=\"TAK\"),\"- zasobnik CWU 200l\",\"\")","v":""},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]
[]
[]
[null,null,{"$f":"IF(AND(Kalkulator!$D$12=Baza!$A$3,Kalkulator!$D$14=Baza!$D$17),\"- zbiornik buforowy 800l\",IF(AND(Kalkulator!$D$12=Baza!$A$3,Kalkulator!$D$14=Baza!$D$18),\"- zbiornik buforowy 800l\",IF(AND(Kalkulator!$D$12=Baza!$A$3,Kalkulator!$D$14,Baza!$D$19),\"- zbornik buforowy 1000l\",\"\")))","v":""}]

{"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!D14:D19))","v":"Eco Heat 1F mono - 6kW"},null,{"$f":"Kalkulator!D14","v":"Eco Heat 3Fmono - 16kW"},{"$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 - 5/4 - 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 - 5/4 - 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"]