{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Kalkulator","Raty kredytowe","Informator","Kredyt","Baza","Inwerter","Mój Prąd","Obliczenia","Marże"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":2,"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":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[28,5,28,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"ER_Kalkulator_01_05"]
[null,null,"Klient indywidualny"]
[]
[null,null,"Rodzaj instalacji","PV + Inwerter hybrydowy + Magazyn Energii"]
[null,null,"                                                                                                                                             "]
[null,null,"Konstrukcja montażowa","Dach skośny - blachodachówka,papa, gont pion"]
[null,null,"Ilość faz",1]
[null,null,"                                                                                                                                             ",null,"ILOŚĆ","MOC","Pojemność"]
[null,null,"Moduły PV ","Trina Vertex TSM-450","3,6 -  8",{"$f":"Obliczenia!$E$1","v":"3,6 kwp"},"-"]
[null,null,"Magazyn","Deye PRO-B 5,12 kWh",null,{"$f":"Obliczenia!$G$24","v":"2,5 kw"},{"$f":"Obliczenia!$E$24","v":"5,12 kwp"}]
[null,null,"Inwerter","Deye LOW VOLTAGE SUN-3.6K-SG03LP1-EU (1-faz)",{"$f":"Informator!$D$2","v":""}]
[null,null,"Proponowany",{"$f":"Obliczenia!$D$2","v":"Deye LOW VOLTAGE SUN-3.6K-SG03LP1-EU (1-faz)"}]
[null,null,"Wyłącznik Ppoż","NIE"]
[null,null,"Optymalizatory",0,"szt."]
[null,null,"Rozszerzenie gwarancji na falownik do 10 lat","NIE"]
[null,null,"Przekop",0,"m."]
[null,null,"Dodatkowy kabel",0,"m."]
[null,null,"Moduł bilansowania energii Eniga","NIE"]
[null,null,"UPS","NIE"]
[null,null,null,null,null,"MAX. Dotacja MÓJ PRĄD",{"$f":"Informator!$D$6","v":22360}]
[null,null,"Eco Wakacje","NIE",null,"Ulga Termomodernizacyjna"]
[null,null,"Podnośnik","NIE",null,0.12,{"$f":"Informator!$D$8","v":2911.7356800000007}]
[null,null,"Integrator do istniejącej instalacji PV","NIE"]
[null,null,"Pakiet","STANDARD PLUS"]
[null,null,"Cena netto",{"$f":"Informator!$D$10","v":43170.8},null,"Ilość lat kredytu:","Wpłata własna:"]
[null,null,"Cena brutto",{"$f":"Informator!$D$11","v":46624.464000000007},null,4,0]
[null,null,"Cena po dotacjach",{"$f":"Informator!$D$12","v":21352.728320000006}]
[]
[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":4},null,"Ilość lat",{"$f":"Kredyt!$J$3","v":4}]
[null,null,"Cena instalacji brutto",{"$f":"Kredyt!$E$2","v":46624.464000000007},null,"Cena instalacji brutto",{"$f":"Kredyt!$E$3","v":46624.464000000007}]
[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":46624.464000000007},null,"Kwota kredytu",{"$f":"Kredyt!$G$3","v":46624.464000000007}]
[null,null,"Maksymalna kwota kredytu",100000,null,"Maksymalna kwota kredytu",80000]
[null,null,"RATA MIESIĘCZNA",{"$f":"Kredyt!$M$2","v":1251.0897840000002},null,"RATA MIESIĘCZNA",{"$f":"Kredyt!$M$3","v":1251.0897840000002}]

{"sheet":"Informator","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,{"$f":"IF(Kalkulator!$D$12=Baza!$A$4,\"\",IF(ISNA(MATCH(Kalkulator!$D$19,_xlfn.ANCHORARRAY(Inwerter!$H$2),0)),\"<- Wybierz poprawny inwerter !\",\"\"))","v":""}]
[]
[null,null,null,{"$f":"IF(AND(Kalkulator!$D$12=Baza!$A$4,Kalkulator!$D$15<>Inwerter!$K$14),\"<- Zmień ilość faz !\",IF(Kalkulator!$D$12=Baza!$A$4,\"\",IF(AND(OR(Kalkulator!$E$17>=Baza!$I$11,Kalkulator!$E$17=Baza!$I$9),Kalkulator!$D$15<>3),\"<- Zmień ilość faz !\",\"\")))","v":""}]
[]
[null,null,null,{"$f":"IF(Informator!$D$11=\"\",\"\",IF(Kalkulator!$D$12=Baza!$A$3,'Mój Prąd'!$B$6,\"DOTACJA NIE NALEŻY SIĘ\"))","v":22360}]
[]
[null,null,null,{"$f":"IF(Informator!$D$11=\"\",\"\",IF(ISTEXT(Informator!$D$6),Informator!$D$11*Kalkulator!$F$30,(Informator!$D$11-Informator!$D$6)*Kalkulator!$F$30))","v":2911.7356800000007}]
[]
[null,null,null,{"$f":"IF(OR(Informator!$D$2=\"<- Wybierz poprawny inwerter !\",Informator!$D$4=\"<- Zmień ilość faz !\"),\"\",Obliczenia!$C$2)","v":43170.8}]
[null,null,null,{"$f":"IF($D$10=\"\",\"\",IF(Obliczenia!$I$3<>\"\",Obliczenia!$I$3,Obliczenia!$I$4))","v":46624.464000000007}]
[null,null,null,{"$f":"IF($D$11=\"\",\"\",IF(ISTEXT(Informator!$D$6),$D$11-Informator!$D$8,($D$11-Informator!$D$6-Informator!$D$8)))","v":21352.728320000006}]

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

{"sheet":"Baza","index":4,"n_rows":168,"n_cols":37,"rows_kept":168,"cut":false,"hidden":true,"merged":[[0,1,0,2],[0,29,0,31],[0,32,0,34],[0,35,0,36],[5,29,5,30],[0,9,0,13],[0,3,0,5],[0,6,0,7],[0,14,0,18],[0,20,0,22],[0,23,0,25],[0,26,0,28]]}
["Rodzaj kostrukcji","Marża",null,"Panele",null,null,"Konstrukcja",null,null,"Falownik ",null,null,null,null,"Falownik",null,null,null,null,null,"Magazyn energii",null,null,"Elektryka",null,null,"Drobnica elektryczna",null,null,"Prace Gruntowe",null,null,"Montaż",null,null,"Koszty dodatkowe"]
["PV Mikro","STANDARD PLUS",10000,"Nazwa","moc [kWp]","Cena netto/moduł [zł]","typ konstrukcji","cena/moduł",null,"Falownik","moc","min moc instalacji","max moc paneli","cena","Falownik","moc","min moc instalacji","max moc paneli","cena","falownik","nazwa","pojemność [kWh]","cena","min moc","max moc","cena","min","max","cena","min","max",null,"min","max","cena","obsługa",800]
["PV + Inwerter hybrydowy + Magazyn Energii","STANDARD",8000,"Trina Vertex TSM-450",0.45,240,"Dach skośny - blachodachówka,papa, gont pion",110,"0,45 - 1","Deye LOW VOLTAGE SUN-3.6K-SG03LP1-EU (1-faz)",3,3,3.65,6244,"Deye SUN 3kW - 1F",3,3,3.75,1320,null,"BRAK",0,0,0,5.5,1800,0,7,2000,null,null,null,0,3.99,550,"Transport",500]
["ME","RABAT",6000,null,null,null,"Dach skośny - dachówka ceramiczna, betonowa pion",170,"0,9 - 2","Deye LOW VOLTAGE SUN-5K-SG04LP3-EU",5,3.66,5.5,6244,"Deye SUN 4kW - 3F",4,3.76,4.75,2795,"Sofar Hybrydowy","Deye PRO-B 5,12 kWh",5.12,3871,5.51,10,2000,7.01,10,2200,null,null,null,4,10,550,"Skarbonka",500]
[null,"MENAGO",4000,null,null,null,"Dach skośny - blachodach trapezowy - mostek pion",80,"1,35 - 3","Deye LOW VOLTAGE SUN-6K-SG04LP3-EU",6,5.51,7,6244,"Deye SUN 5kW - 3F",5,4.76,5.75,3030,"Sofar Hybrydowy","Deye PRO-B 10,24 kWh",10.24,{"$f":"$W$4*(ROW()-3)","v":7742},10.01,15.5,2700,10.01,15,2500,1,999,25,10.01,20,500,"optymalizatory",135]
[null,null,null,null,null,null,"Dach skośny - dachówka karpiówka pion",110,"1,8 - 4","Deye LOW VOLTAGE SUN-8K-SG04LP3-EU",8,7.01,9,6470,"Deye SUN 6kW - 3F",6,5.76,7,3150,"Sofar Hybrydowy","Deye PRO-B 15,36 kWh",15.36,{"$f":"$W$4*(ROW()-3)","v":11613},15.51,20,3600,15.01,25,3000,"stała stawka",null,250,20.010000000000002,40,450,"Dodatkowy kabel",25]
[null,null,null,null,null,null,"Dach skośny - blachodach na rąbek pion",110,"2,25 - 5","Deye LOW VOLTAGE SUN-10K-SG04LP3-EU",10,9.01,12.3,6720,"Deye SUN 8kW - 3F",8,7.01,9,3270,"Sofar Hybrydowy","Deye PRO-B 20,48 kWh",20.48,15484,20.010000000000002,30,5800,25.01,35,3800,null,null,null,40.01,50,400,"Magazyn Ciepła",2500]
[null,null,null,null,null,null,"Dach płaski - inwazyjny ekierka pion 15",240,"2,7 - 6","Deye LOW VOLTAGE SUN-12K-SG04LP3-EU",12,{"$f":"M7+0.01","v":12.31},14.5,6790,"Deye SUN 11kW - 3F",10,9.01,11,3440,"DYNESS","DYNESS 4,8 kWh",4.8,3414,30.01,40,7200,35.01,45,4000,null,null,null,null,null,null,"Wakacje",600]
[null,null,null,null,null,null,"Dach płaski bezinwazyjnie - balast pion 15",270,"3,15 -  7","Deye LOW VOLTAGE SUN-15K-SG04LP3-EU",15,{"$f":"M8+0.01","v":14.51},16.989999999999998,7890,"Deye SUN 12kW - 3F",12,11.01,13.5,3670,null,"DYNESS 7,2 kWh",7.2,5121,40.01,50,8200,45.01,50,4500,null,null,null,null,null,null,"Zwyżka",650]
[null,null,null,null,null,null,"Instalacja gruntowa - panele montowane pionowo (bez przekopu)",250,"3,6 -  8","Deye LOW VOLTAGE SUN-20K-SG04LP3-EU",20,17,22,9997,"Deye SUN 15kW - 3F",15,13.51,16,4290,null,"DYNESS 9,6 kWh",9.6,6828,null,null,null,null,null,null,null,null,null,null,null,null,"Integrator do istniejącej instalacji PV",2000]
[null,null,null,null,null,null,null,null,"4,05 -  9",null,null,null,null,null,"Deye SUN 17kW - 3F",17,16.010000000000002,18,4560,null,"DYNESS 12 kWh",12,8535,null,null,null,null,null,null,null,null,null,null,null,null,"Moduł bilansowania energii Eniga",2200]
[null,null,null,null,null,null,null,null,"4,5 -  10",null,null,null,null,null,"Deye SUN 20kW - 3F ",20,18.010000000000002,21,5150,null,"DYNESS 14,4 kWh",14.4,10242,null,null,null,null,null,null,null,null,null,null,null,null,"Modernizacja rozdzielni elektrycznej",1200]
[null,null,null,null,null,null,null,null,"4,95 -  11",null,null,null,null,null,"Deye SUN 22kW - 3F",22,21.01,23,5340,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zarządzanie energią",2000]
[null,null,null,null,null,null,null,null,"5,4 -  12",null,null,null,null,null,"Deye SUN 25kW - 3F",25,23.01,27.5,5790]
[null,null,null,null,null,null,null,null,"5,85   -  13",null,null,null,null,null,"Deye SUN 30kW - 3F",30,27.51,31.5,6350,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ppoż",800]
[null,null,null,null,null,null,null,null,"6,3 -  14",null,null,null,null,null,"Deye SUN 33kW - 3F",33,31.51,34.5,7090,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montaż ME",500]
[null,null,null,null,null,null,null,null,"6,75 -  15",null,null,null,null,null,"Deye SUN 36kW - 3F",36,34.51,37.5,7590,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wyłącznik PPoż",1200]
[null,null,null,null,null,null,null,null,"7,2 -  16",null,null,null,null,null,"Deye SUN 40kW - 3F",40,37.51,42.5,7490]
[null,null,null,null,null,null,null,null,"7,65 -  17",null,null,null,null,null,"Deye SUN 45kW - 3F",45,42.51,47.5,6392,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rozszerzenie gwarancji do 10 lat - falownik 1 fazowy",340]
[null,null,null,null,null,null,null,null,"8,1 -  18",null,null,null,null,null,"Deye SUN 50kW - 3F",50,47.51,50,8450,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rozszerzenie gwarancji do 10 lat - falownik 3 fazowy",580]
[null,null,null,null,null,null,null,null,"8,55 -  19"]
[null,null,null,null,null,null,null,null,"9  -  20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UPS",1800]
[null,null,null,null,null,null,null,null,"9,45 -  21",null,null,null,null,null,null,null,null,null,null,null,"Deye PRO-B 5,12 kWh"]
[null,null,null,null,null,null,null,null,"9,9 -  22",null,null,null,null,null,null,null,null,null,null,null,"DYNESS 7,2 kWh"]
[null,null,null,null,null,null,null,null,"10,35 -  23",null,null,null,null,null,null,null,null,null,null,null,"DYNESS 9,6 kWh"]
[null,null,null,null,null,null,null,null,"10,8 -  24",null,null,null,null,null,null,null,null,null,null,null,"DYNESS 12 kWh"]
[null,null,null,null,null,null,null,null,"11,25 -  25",null,null,null,null,null,null,null,null,null,null,null,"DYNESS 14,4 kWh"]
[null,null,null,null,null,null,null,null,"11,7 -  26",null,null,null,null,null,null,null,null,null,null,null,"Deye PRO-B 15,36 kWh"]
[null,null,null,null,null,null,null,null,"12,15 -  27",null,null,null,null,null,null,null,null,null,null,null,"Deye PRO-B 20,48 kWh"]
[null,null,null,null,null,null,null,null,"12,6 -  28"]
[null,null,null,null,null,null,null,null,"13,05 -  29"]
[null,null,null,null,null,null,null,null,"13,5 -  30"]
[null,null,null,null,null,null,null,null,"13,95 -  31"]
[null,null,null,null,null,null,null,null,"14,4 -  32"]
[null,null,null,null,null,null,null,null,"14,85 -  33"]
[null,null,null,null,null,null,null,null,"15,3 -  34"]
[null,null,null,null,null,null,null,null,"15,75 -  35"]
[null,null,null,null,null,null,null,null,"16,2 -  36"]
[null,null,null,null,null,null,null,null,"16,65 -  37"]
[null,null,null,null,null,null,null,null,"17,1 -  38"]
[null,null,null,null,null,null,null,null,"17,55 -  39"]
[null,null,null,null,null,null,null,null,"18 -  40"]
[null,null,null,null,null,null,null,null,"18,45 -  41"]
[null,null,null,null,null,null,null,null,"18,9 -  42"]
[null,null,null,null,null,null,null,null,"19,35 -  43"]
[null,null,null,null,null,null,null,null,"19,8 -  44"]
[null,null,null,null,null,null,null,null,"20,25 -  45"]
[null,null,null,null,null,null,null,null,"20,7 -  46"]
[null,null,null,null,null,null,null,null,"21,15 -  47"]
[null,null,null,null,null,null,null,null,"21,6 -  48"]
[null,null,null,null,null,null,null,null,"22,05 -  49"]
[null,null,null,null,null,null,null,null,"22,5 -  50"]
[null,null,null,null,null,null,null,null,"22,95 -  51"]
[null,null,null,null,null,null,null,null,"23,4 -  52"]
[null,null,null,null,null,null,null,null,"23,85 -  53"]
[null,null,null,null,null,null,null,null,"24,3 -  54"]
[null,null,null,null,null,null,null,null,"24,75 -  55"]
[null,null,null,null,null,null,null,null,"25,2 -  56"]
[null,null,null,null,null,null,null,null,"25,65 -  57"]
[null,null,null,null,null,null,null,null,"26,1 -  58"]
[null,null,null,null,null,null,null,null,"26,55 -  59"]
[null,null,null,null,null,null,null,null,"27 -  60"]
[null,null,null,null,null,null,null,null,"27,45 -  61"]
[null,null,null,null,null,null,null,null,"27,9 -  62"]
[null,null,null,null,null,null,null,null,"28,35 -  63"]
[null,null,null,null,null,null,null,null,"28,8 -  64"]
[null,null,null,null,null,null,null,null,"29,25 -  65"]
[null,null,null,null,null,null,null,null,"29,7 -  66"]
[null,null,null,null,null,null,null,null,"30,15 -  67"]
[null,null,null,null,null,null,null,null,"30,6 -  68"]
[null,null,null,null,null,null,null,null,"31,05 -  69"]
[null,null,null,null,null,null,null,null,"31,5 -  70"]
[null,null,null,null,null,null,null,null,"31,95 -  71"]
[null,null,null,null,null,null,null,null,"32,4 -  72"]
[null,null,null,null,null,null,null,null,"32,85 -  73"]
[null,null,null,null,null,null,null,null,"33,3 -  74"]
[null,null,null,null,null,null,null,null,"33,75 -  75"]
[null,null,null,null,null,null,null,null,"34,2 -  76"]
[null,null,null,null,null,null,null,null,"34,65 -  77"]
[null,null,null,null,null,null,null,null,"35,1 -  78"]
[null,null,null,null,null,null,null,null,"35,55 -  79"]
[null,null,null,null,null,null,null,null,"36 -  80"]
[null,null,null,null,null,null,null,null,"36,45 -  81"]
[null,null,null,null,null,null,null,null,"36,9 -  82"]
[null,null,null,null,null,null,null,null,"37,35 -  83"]
[null,null,null,null,null,null,null,null,"37,8 -  84"]
[null,null,null,null,null,null,null,null,"38,25 -  85"]
[null,null,null,null,null,null,null,null,"38,7 -  86"]
[null,null,null,null,null,null,null,null,"39,15 -  87"]
[null,null,null,null,null,null,null,null,"39,6 -  88"]
[null,null,null,null,null,null,null,null,"40,05 -  89"]
[null,null,null,null,null,null,null,null,"40,5 -  90"]
[null,null,null,null,null,null,null,null,"40,95 -  91"]
[null,null,null,null,null,null,null,null,"41,4 -  92"]
[null,null,null,null,null,null,null,null,"41,85 -  93"]
[null,null,null,null,null,null,null,null,"42,3 -  94"]
[null,null,null,null,null,null,null,null,"42,75 -  95"]
[null,null,null,null,null,null,null,null,"43,2 -  96"]
[null,null,null,null,null,null,null,null,"43,65 -  97"]
[null,null,null,null,null,null,null,null,"44,1 -  98"]
[null,null,null,null,null,null,null,null,"44,55 -  99"]
[null,null,null,null,null,null,null,null,"45 -  100"]
[null,null,null,null,null,null,null,null,"45,45 -  101"]
[null,null,null,null,null,null,null,null,"45,9 -  102"]
[null,null,null,null,null,null,null,null,"46,35 -  103"]
[null,null,null,null,null,null,null,null,"46,8 -  104"]
[null,null,null,null,null,null,null,null,"47,25 -  105"]
[null,null,null,null,null,null,null,null,"47,7 -  106"]
[null,null,null,null,null,null,null,null,"48,15 -  107"]
[null,null,null,null,null,null,null,null,"48,6 -  108"]
[null,null,null,null,null,null,null,null,"49,05 -  109"]
[null,null,null,null,null,null,null,null,"49,5 -  110"]
[null,null,null,null,null,null,null,null,"49,95 -  111"]
[null,null,null,null,null,null,null,null,112]
[null,null,null,null,null,null,null,null,113]
[null,null,null,null,null,null,null,null,114]
[null,null,null,null,null,null,null,null,115]
[null,null,null,null,null,null,null,null,116]
[null,null,null,null,null,null,null,null,117]
[null,null,null,null,null,null,null,null,118]
[null,null,null,null,null,null,null,null,119]
[null,null,null,null,null,null,null,null,120]
[null,null,null,null,null,null,null,null,121]
[null,null,null,null,null,null,null,null,122]
[null,null,null,null,null,null,null,null,123]
[null,null,null,null,null,null,null,null,124]
[null,null,null,null,null,null,null,null,125]
[null,null,null,null,null,null,null,null,126]
[null,null,null,null,null,null,null,null,127]
[null,null,null,null,null,null,null,null,128]
[null,null,null,null,null,null,null,null,129]
[null,null,null,null,null,null,null,null,130]
[null,null,null,null,null,null,null,null,131]
[null,null,null,null,null,null,null,null,132]
[null,null,null,null,null,null,null,null,133]
[null,null,null,null,null,null,null,null,134]
[null,null,null,null,null,null,null,null,135]
[null,null,null,null,null,null,null,null,136]
[null,null,null,null,null,null,null,null,137]
[null,null,null,null,null,null,null,null,138]
[null,null,null,null,null,null,null,null,139]
[null,null,null,null,null,null,null,null,140]
[null,null,null,null,null,null,null,null,141]
[null,null,null,null,null,null,null,null,142]
[null,null,null,null,null,null,null,null,143]
[null,null,null,null,null,null,null,null,144]
[null,null,null,null,null,null,null,null,145]
[null,null,null,null,null,null,null,null,146]
[null,null,null,null,null,null,null,null,147]
[null,null,null,null,null,null,null,null,148]
[null,null,null,null,null,null,null,null,149]
[null,null,null,null,null,null,null,null,150]
[null,null,null,null,null,null,null,null,151]
[null,null,null,null,null,null,null,null,152]
[null,null,null,null,null,null,null,null,153]
[null,null,null,null,null,null,null,null,154]
[null,null,null,null,null,null,null,null,155]
[null,null,null,null,null,null,null,null,156]
[null,null,null,null,null,null,null,null,157]
[null,null,null,null,null,null,null,null,158]
[null,null,null,null,null,null,null,null,159]
[null,null,null,null,null,null,null,null,160]
[null,null,null,null,null,null,null,null,161]
[null,null,null,null,null,null,null,null,162]
[null,null,null,null,null,null,null,null,163]
[null,null,null,null,null,null,null,null,164]
[null,null,null,null,null,null,null,null,165]
[null,null,null,null,null,null,null,null,166]

{"sheet":"Inwerter","index":5,"n_rows":39,"n_cols":22,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[null,null,null,{"$f":"_xlfn.UNIQUE(Baza!J2:J1000)","v":"Falownik"},{"$f":"_xlfn.UNIQUE(Baza!O2:O1000)","v":"Falownik"},null,null,null,null,null,null,null,"Ilość faz","Falownik","Moc"]
[null,null,null,"Deye LOW VOLTAGE SUN-3.6K-SG03LP1-EU (1-faz)","Deye SUN 3kW - 1F",null,{"$f":"IF(Kalkulator!D12=Baza!A3,Obliczenia!D2,\"?\")","v":"Deye LOW VOLTAGE SUN-3.6K-SG03LP1-EU (1-faz)"},{"$f":"IFERROR(IF(G2=D2,_xlfn.UNIQUE(D2),IF(G2=D3,_xlfn.UNIQUE(D3:D9),IF(G2=D4,_xlfn.UNIQUE(D4:D9),IF(G2=D5,_xlfn.UNIQUE(D5:D9),IF(G2=D6,_xlfn.UNIQUE(D6:D9),IF(G2=D7,_xlfn.UNIQUE(D7:D9),IF(G2=D8,_xlfn.UNIQUE(D8:D9),IF(G2=D9,_xlfn.UNIQUE(D9),IF(G2=E2,_xlfn.UNIQUE(E2:E19),IF(G2=E3,_xlfn.UNIQUE(E3:E19),IF(G2=E4,_xlfn.UNIQUE(E4:E19),IF(G2=E5,_xlfn.UNIQUE(E5:E19),IF(G2=E6,_xlfn.UNIQUE(E6:E19),IF(G2=E7,_xlfn.UNIQUE(E7:E19),IF(G2=E8,_xlfn.UNIQUE(E8:E19),IF(G2=E9,_xlfn.UNIQUE(E9:E19),IF(G2=E10,_xlfn.UNIQUE(E10:E19),IF(G2=E11,_xlfn.UNIQUE(E11:E19),IF(G2=E12,_xlfn.UNIQUE(E12:E19),IF(G2=E13,_xlfn.UNIQUE(E13:E19),IF(G2=E14,_xlfn.UNIQUE(E14:E19),IF(G2=E15,_xlfn.UNIQUE(E15:E19),IF(G2=E16,_xlfn.UNIQUE(E16:E19),IF(G2=E17,_xlfn.UNIQUE(E17:E19),IF(G2=E18,_xlfn.UNIQUE(E18:E19),IF(G2=E19,_xlfn.UNIQUE(E19),IF(G2=\"?\",_xlfn.UNIQUE(D2:D9),\"\"))))))))))))))))))))))))))),\"\")","v":"Deye LOW VOLTAGE SUN-3.6K-SG03LP1-EU (1-faz)"},null,null,null,null,1,"Deye LOW VOLTAGE SUN-3.6K-SG03LP1-EU (1-faz)","3,15 -  7",null,{"$f":"Kalkulator!D15","v":1},{"$f":"IF($Q$2=Inwerter!$M$2,_xlfn.UNIQUE(Inwerter!$O$3),_xlfn.UNIQUE($O$2:$O$39))","v":"3,6 -  8"},null,null,{"$f":"Kalkulator!E17","v":"3,6 -  8"},{"$f":"IF(AND(Kalkulator!E17=Inwerter!O2,Kalkulator!D15=Inwerter!M2),_xlfn.UNIQUE(Inwerter!N2),IF(AND(Kalkulator!E17=Inwerter!O3,Kalkulator!D15=Inwerter!M2),_xlfn.UNIQUE(Inwerter!N2),IF(AND(Kalkulator!E17=Inwerter!O2,Kalkulator!D15=Inwerter!M3),_xlfn.UNIQUE(Inwerter!N3:N9),IF(AND(Kalkulator!E17=Inwerter!O3,Kalkulator!D15=Inwerter!M3),_xlfn.UNIQUE(Inwerter!N3:N9),IF(AND(Kalkulator!E17<>Inwerter!O2,Kalkulator!E17<>Inwerter!O3),_xlfn.UNIQUE(Inwerter!N3:N9),\"?\")))))","v":"Deye LOW VOLTAGE SUN-3.6K-SG03LP1-EU (1-faz)"}]
[null,null,null,"Deye LOW VOLTAGE SUN-5K-SG04LP3-EU","Deye SUN 4kW - 3F",null,null,null,null,null,null,null,3,"Deye LOW VOLTAGE SUN-5K-SG04LP3-EU","3,6 -  8"]
[null,null,null,"Deye LOW VOLTAGE SUN-6K-SG04LP3-EU","Deye SUN 5kW - 3F",null,null,null,null,null,null,null,null,"Deye LOW VOLTAGE SUN-6K-SG04LP3-EU","4,05 -  9"]
[null,null,null,"Deye LOW VOLTAGE SUN-8K-SG04LP3-EU","Deye SUN 6kW - 3F",null,null,null,null,null,null,null,null,"Deye LOW VOLTAGE SUN-8K-SG04LP3-EU","4,5 -  10"]
[null,null,null,"Deye LOW VOLTAGE SUN-10K-SG04LP3-EU","Deye SUN 8kW - 3F",null,null,null,null,null,null,null,null,"Deye LOW VOLTAGE SUN-10K-SG04LP3-EU","4,95 -  11"]
[null,null,null,"Deye LOW VOLTAGE SUN-12K-SG04LP3-EU","Deye SUN 11kW - 3F",null,null,null,null,null,null,null,null,"Deye LOW VOLTAGE SUN-12K-SG04LP3-EU","5,4 -  12"]
[null,null,null,"Deye LOW VOLTAGE SUN-15K-SG04LP3-EU","Deye SUN 12kW - 3F",null,null,null,null,null,null,null,null,"Deye LOW VOLTAGE SUN-15K-SG04LP3-EU","5,85   -  13"]
[null,null,null,"Deye LOW VOLTAGE SUN-20K-SG04LP3-EU","Deye SUN 15kW - 3F",null,null,null,null,null,null,null,null,"Deye LOW VOLTAGE SUN-20K-SG04LP3-EU","6,3 -  14"]
[null,null,null,0,"Deye SUN 17kW - 3F",null,null,null,null,null,null,null,null,null,"6,75 -  15"]
[null,null,null,null,"Deye SUN 20kW - 3F ",null,null,null,null,null,null,null,null,null,"7,2 -  16"]
[null,null,null,null,"Deye SUN 22kW - 3F",null,null,null,null,null,null,null,null,null,"7,65 -  17"]
[null,null,null,null,"Deye SUN 25kW - 3F",null,null,null,null,null,null,null,null,null,"8,1 -  18"]
[null,null,null,null,"Deye SUN 30kW - 3F",null,null,null,null,null,{"$f":"IF(AND(Kalkulator!$D$12=Baza!$A$4,Kalkulator!$D$19=Baza!$J$3),Obliczenia!$H$5,IF(AND(Kalkulator!$D$12=Baza!$A$4,Kalkulator!$D$19<>Baza!$J$3),Obliczenia!$H$6,IF(AND(Kalkulator!$D$12=Baza!$A$3,Obliczenia!$D$1=3.6),Obliczenia!$H$5:$H$6,Obliczenia!$H$6)))","v":1},null,null,null,"8,55 -  19"]
[null,null,null,null,"Deye SUN 33kW - 3F",null,null,null,null,null,3,null,null,null,"9  -  20"]
[null,null,null,null,"Deye SUN 36kW - 3F",null,null,null,null,null,null,null,null,null,"9,45 -  21"]
[null,null,null,null,"Deye SUN 40kW - 3F",null,null,null,null,null,null,null,null,null,"9,9 -  22"]
[null,null,null,null,"Deye SUN 45kW - 3F",null,null,null,null,null,null,null,null,null,"10,35 -  23"]
[null,null,null,null,"Deye SUN 50kW - 3F",null,null,null,null,null,null,null,null,null,"10,8 -  24"]
[null,null,null,null,0,null,null,null,null,null,null,null,null,null,"11,25 -  25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11,7 -  26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12,15 -  27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12,6 -  28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13,05 -  29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13,5 -  30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13,95 -  31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14,4 -  32"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14,85 -  33"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15,3 -  34"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15,75 -  35"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16,2 -  36"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16,65 -  37"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17,1 -  38"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17,55 -  39"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18 -  40"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18,45 -  41"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18,9 -  42"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19,35 -  43"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19,8 -  44"]

{"sheet":"Mój Prąd","index":6,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,{"$f":"_xlfn.UNIQUE(Baza!U:W)","v":"Magazyn energii"},0,0,null,"50% CENY, MAX. DO 16 TYS",null,null,null,null,"PV","50% CENY, MAX. DO 7 TYS "]
["koszt pod dotacje ME",{"$f":"VLOOKUP(Kalkulator!G18,'Mój Prąd'!H4:J12,2,FALSE)","v":30720},null,null,"nazwa","pojemność [kWh]","cena",null,"koszt pod dotację","max. dotacja",null,null,null,"max. koszt pod dotację","max. dotacja"]
["max. dotacja ME",{"$f":"IF(Informator!D11<'Mój Prąd'!B2,Informator!D11/2,VLOOKUP(Kalkulator!G18,'Mój Prąd'!H4:J12,3,FALSE))","v":15360},null,null,"BRAK",0,0,null,null,null,null,null,null,14000,7000]
["pozostała cena brutto dla pv",{"$f":"Informator!D11-'Mój Prąd'!B2","v":15904.464000000007},null,null,"Deye PRO-B 5,12 kWh",5.12,3871,{"$f":"F4&\" kwp\"","v":"5,12 kwp"},{"$f":"F4*6000","v":30720},{"$f":"I4/2","v":15360}]
["max. dotacja PV",{"$f":"IF(B4>N3,O3,B4/2)","v":7000},null,null,"Deye PRO-B 10,24 kWh",10.24,7742,{"$f":"F5&\" kwp\"","v":"10,24 kwp"},32000,{"$f":"I5/2","v":16000}]
["ŁĄCZNA KWOTA DOTACJI",{"$f":"B3+B5","v":22360},null,null,"Deye PRO-B 15,36 kWh",15.36,11613,"15,36 kwp",32000,16000]
[null,null,null,null,"Deye PRO-B 20,48 kWh",20.48,15484,"20,48 kwp",32000,16000]
[null,null,null,null,"DYNESS 4,8 kWh",4.8,3414,"4,8 kwp",{"$f":"F8*6000","v":28800},{"$f":"I8/2","v":14400}]
[null,null,null,null,"DYNESS 7,2 kWh",7.2,5121,"7,2 kwp",32000,16000]
[null,null,null,null,"DYNESS 9,6 kWh",9.6,6828,"9,6 kwp",32000,16000]
[null,null,null,null,"DYNESS 12 kWh",12,8535,"12 kwp",32000,16000]
[null,null,null,null,"DYNESS 14,4 kWh",14.4,10242,"14,4 kwp",32000,16000]
[null,null,null,null,0,0,0,"0 kwp"]
[null,null,null,null,"Deye PRO-B 5,12 kWh",0,0,"0 kwp"]
[null,null,null,null,"DYNESS 7,2 kWh",0,0,"0 kwp"]
[null,null,null,null,"DYNESS 9,6 kWh",0,0,"0 kwp"]
[null,null,null,null,"DYNESS 12 kWh",0,0,"0 kwp"]
[null,null,null,null,"DYNESS 14,4 kWh",0,0,"0 kwp"]
[null,null,null,null,"Deye PRO-B 15,36 kWh",0,0,"0 kwp"]
[null,null,null,null,"Deye PRO-B 20,48 kWh",0,0,"0 kwp"]

{"sheet":"Obliczenia","index":7,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[null,"Cena jednostkowa","Cena dla instalacji",{"$f":"RIGHT(Kalkulator!$E$17,3)*(VLOOKUP(Kalkulator!$D$17,Baza!$D:$F,2,0))","v":3.6},{"$f":"_xlfn.CONCAT($D$1,\" kwp\")","v":"3,6 kwp"},null,null,"NIE"]
["Rodzaj instalacji",{"$f":"Kalkulator!$D$12","v":"PV + Inwerter hybrydowy + Magazyn Energii"},{"$f":"SUM(D28,C31,C33)","v":43170.8},{"$f":"IF(C5>1,D5,D6)","v":"Deye LOW VOLTAGE SUN-3.6K-SG03LP1-EU (1-faz)"},null,null,null,"TAK"]
["Konstrukcja montażowa",{"$f":"_xlfn.IFS(Kalkulator!D12=Baza!A4,0,Kalkulator!$D$17=Baza!$D$3,VLOOKUP(Kalkulator!$D$14,Baza!$G$3:$H$13,2,0))","v":110},{"$f":"$B$3*RIGHT(Kalkulator!$E$17,3)","v":880},null,null,null,null,"Klient indywidualny",{"$f":"IF($H$3=Kalkulator!$C$10,Obliczenia!$C$2*1.08,\"\")","v":46624.464000000007},null,{"$f":"IFERROR(IF(AND($B$2=Baza!A2,Kalkulator!$D$19=VLOOKUP(Kalkulator!$D$19,Baza!O:S,1,0)),1,0),0)","v":0}]
["Moduły",{"$f":"IF(Kalkulator!D12=Baza!A4,0,VLOOKUP(Kalkulator!$D$17,Baza!$D:$F,3,0))","v":240},{"$f":"$B$4*RIGHT(Kalkulator!$E$17,3)","v":1920},null,null,null,null,"Klient biznesowy",{"$f":"IF($H$4=Kalkulator!$C$10,Obliczenia!$C$2*1.23,\"\")","v":""}]
["Inwerter sieciowy",{"$f":"_xlfn.IFS(AND(Obliczenia!$D$1<=Baza!$R$3),Baza!$S$3,AND(Obliczenia!$D$1<=Baza!$R$4),Baza!$S$4,AND(Obliczenia!$D$1<=Baza!$R$5),Baza!$S$5,Obliczenia!$D$1<=Baza!$R$7,Baza!$S$7,AND(Obliczenia!$D$1<=Baza!$R$6),Baza!$S$6,Obliczenia!$D$1<=Baza!$R$8,Baza!$S$8,Obliczenia!$D$1<=Baza!$R$9,Baza!$S$9,Obliczenia!$D$1<=Baza!$R$10,Baza!$S$10,Obliczenia!$D$1<=Baza!$R$11,Baza!$S$11,Obliczenia!$D$1<=Baza!$R$12,Baza!$S$12,Obliczenia!$D$1<=Baza!$R$13,Baza!$S$13,Obliczenia!$D$1<=Baza!$R$14,Baza!$S$14,Obliczenia!$D$1<=Baza!$R$15,Baza!$S$15,Obliczenia!$D$1<=Baza!$R$16,Baza!$S$16,Obliczenia!$D$1<=Baza!$R$17,Baza!$S$17,Obliczenia!$D$1<=Baza!$R$18,Baza!$S$18,Obliczenia!$D$1<=Baza!$R$19,Baza!$S$19,Obliczenia!$D$1<=Baza!$R$20,Baza!$S$20)","v":1320},{"$f":"IFERROR(IF(Baza!A2=Kalkulator!D12,B5,0),0)","v":0},{"$f":"_xlfn.IFS(AND(Obliczenia!$D$1<=Baza!$R$3,Obliczenia!N5=Obliczenia!H5),Baza!$O$3,AND(Obliczenia!$D$1<=Baza!$R$3,Obliczenia!N5=Obliczenia!H6),Baza!$O$4,AND(Obliczenia!$D$1<=Baza!$R$4),Baza!$O$4,AND(Obliczenia!$D$1<=Baza!$R$5),Baza!$O$5,Obliczenia!$D$1<=Baza!$R$7,Baza!$O$7,AND(Obliczenia!$D$1<=Baza!$R$6),Baza!$O$6,Obliczenia!$D$1<=Baza!$R$8,Baza!$O$8,Obliczenia!$D$1<=Baza!$R$9,Baza!$O$9,Obliczenia!$D$1<=Baza!$R$10,Baza!$O$10,Obliczenia!$D$1<=Baza!$R$11,Baza!$O$11,Obliczenia!$D$1<=Baza!$R$12,Baza!$O$12,Obliczenia!$D$1<=Baza!$R$13,Baza!$O$13,Obliczenia!$D$1<=Baza!$R$14,Baza!$O$14,Obliczenia!$D$1<=Baza!$R$15,Baza!$O$15,Obliczenia!$D$1<=Baza!$R$16,Baza!$O$16,Obliczenia!$D$1<=Baza!$R$17,Baza!$O$17,Obliczenia!$D$1<=Baza!$R$18,Baza!$O$18,Obliczenia!$D$1<=Baza!$R$19,Baza!$O$19,Obliczenia!$D$1<=Baza!$R$20,Baza!$O$20)","v":"Deye SUN 3kW - 1F"},null,null,null,1,null,null,{"$f":"IF(AND($B$2=Baza!A3,Kalkulator!$D$19=VLOOKUP(Kalkulator!$D$19,Baza!J:N,1,0)),1,0)","v":1},{"$f":"IF(AND($B$2=Baza!A4,Kalkulator!$D$19=VLOOKUP(Kalkulator!$D$19,Baza!J:N,1,0)),1,0)","v":0},null,{"$f":"Kalkulator!$D$15","v":1}]
["Inwerter hybrydowy",{"$f":"_xlfn.IFS(AND(Obliczenia!$D$1<=Baza!$M$3),Baza!$N$3,Obliczenia!$D$1<=Baza!$M$4,Baza!$N$4,Obliczenia!$D$1<=Baza!$M$5,Baza!$N$5,Obliczenia!$D$1<=Baza!$M$6,Baza!$N$6,Obliczenia!$D$1<=Baza!$M$7,Baza!$N$7,Obliczenia!$D$1<=Baza!$M$8,Baza!$N$8,Obliczenia!$D$1<=Baza!$M$9,Baza!$N$9,Obliczenia!$D$1<=Baza!$M$10,Baza!$N$10,Obliczenia!$D$1<=Baza!$M$11,Baza!$N$11,Obliczenia!$D$1<=Baza!$M$12,Baza!$N$12)","v":6244},{"$f":"IFERROR(_xlfn.IFS(B2=Baza!A4,B6,SEARCH(\"hybrydowy\",$B$2)>0,B6),0)","v":6244},{"$f":"_xlfn.IFS(AND(Obliczenia!$D$1=3.6,Kalkulator!$D$15=1),Baza!$J$3,Obliczenia!$D$1<=Baza!$M$4,Baza!$J$4,Obliczenia!$D$1<=Baza!$M$5,Baza!$J$5,Obliczenia!$D$1<=Baza!$M$6,Baza!$J$6,Obliczenia!$D$1<=Baza!$M$7,Baza!$J$7,Obliczenia!$D$1<=Baza!$M$8,Baza!$J$8,Obliczenia!$D$1<=Baza!$M$9,Baza!$J$9,Obliczenia!$D$1<=Baza!$M$10,Baza!$J$10,Obliczenia!$D$1<=Baza!$M$11,Baza!$J$11,Obliczenia!$D$1<=Baza!$M$12,Baza!$J$12)","v":"Deye LOW VOLTAGE SUN-3.6K-SG03LP1-EU (1-faz)"},{"$f":"IFERROR(IFERROR(_xlfn.IFS($D$5=Kalkulator!$D$19,Obliczenia!$C$5,#REF!=Kalkulator!$D$19,Obliczenia!$C$6),VLOOKUP(Kalkulator!$D$19,Baza!$O$3:$S$21,5,0)),VLOOKUP(Kalkulator!$D$19,Baza!J3:N12,5,0))","v":6244},null,null,3,null,null,{"$f":"IFERROR(SUM(K4:K5,L5),0)","v":1}]
["Optymalizatory ",{"$f":"Kalkulator!$D$22*Baza!AK5","v":0},{"$f":"B7","v":0}]
["Przekop ",{"$f":"IF(Kalkulator!$D$24>0,(Kalkulator!$D$24*Baza!$AF$5)+Baza!$AF$6,0)","v":0},{"$f":"B8","v":0}]
["Dodatkowy kabel ",{"$f":"Kalkulator!$D$25*Baza!$AK$6","v":0},0]
["Elektryka",{"$f":"_xlfn.IFS(Obliczenia!$D$1<=Baza!$Y$3,Baza!$Z$3,Obliczenia!$D$1<=Baza!$Y$4,Baza!$Z$4,Obliczenia!$D$1<=Baza!$Y$5,Baza!$Z$5,Obliczenia!$D$1<=Baza!$Y$6,Baza!$Z$6,Obliczenia!$D$1<=Baza!$Y$7,Baza!$Z$7,Obliczenia!$D$1<=Baza!$Y$8,Baza!$Z$8,Obliczenia!$D$1<=Baza!$Y$9,Baza!$Z$9)","v":1800},{"$f":"IF(B2=Baza!A4,1000,B10)","v":1800}]
["Zapas/drobnica",{"$f":"_xlfn.IFS(Obliczenia!$D$1<=Baza!$AB$3,Baza!$AC$3,Obliczenia!$D$1<=Baza!$AB$4,Baza!$AC$4,Obliczenia!$D$1<=Baza!$AB$5,Baza!$AC$5,Obliczenia!$D$1<=Baza!$AB$6,Baza!$AC$6,Obliczenia!$D$1<=Baza!$AB$7,Baza!$AC$7,Obliczenia!$D$1<=Baza!$AB$8,Baza!$AC$8,Obliczenia!$D$1<=Baza!$AB$9,Baza!$AC$9)","v":2000},{"$f":"IF($B$2=Baza!$A$4,0,B11)","v":2000}]
[]
["Eco Wakacje",{"$f":"IF(Kalkulator!D29=Obliczenia!$H$2,Baza!AK8,0)","v":0},0]
["Zwyżka",{"$f":"IF(Kalkulator!D30=Obliczenia!$H$2,Baza!AK9,0)","v":0},0]
["Integrator do istniejącej instalacji PV",{"$f":"IF(Kalkulator!D31=Obliczenia!H2,_xlfn.IFS(Kalkulator!D12=Baza!A2,Baza!AK10,Kalkulator!D12=Baza!A3,0,Kalkulator!D12=Baza!A4,0),0)","v":0},0]
["Moduł bilansowania energii Eniga",{"$f":"IF(Kalkulator!D26=Obliczenia!$H$2,Baza!AK11,0)","v":0},{"$f":"IF(Kalkulator!$D$12<>Baza!$A$2,Obliczenia!B16,0)","v":0}]
["Wyłącznik PPoż",{"$f":"IF(Kalkulator!D21=Obliczenia!$H$2,Baza!AK17,0)","v":0},{"$f":"IF(D1>=6.5,B17,0)","v":0}]
["Modernizacja rozdzielni elektrycznej",{"$f":"IF(Kalkulator!D28=Obliczenia!H2,_xlfn.IFS(Kalkulator!D12=Baza!A2,0,Kalkulator!D12=Baza!A3,Baza!AK12,Kalkulator!D12=Baza!A4,Baza!AK12),0)","v":0},{"$f":"B18","v":0}]
["Rozszerzenie gwarancji do 10 lat - falownik 1 fazowy",{"$f":"IF(Kalkulator!D23=Obliczenia!$H$2,_xlfn.IFS(Kalkulator!$D$19=Baza!$O$3,Baza!$AK$19,Kalkulator!$D$19=Baza!$J$3,Baza!$AK$19,Kalkulator!$D$15=Obliczenia!$H$6,Baza!AK20),0)","v":0},{"$f":"IF($B$2=Baza!$A$4,0,B19)","v":0}]
["Montaż",{"$f":"_xlfn.IFS(Obliczenia!$D$1<=Baza!$AH$3,$D$1*Baza!$AI$3,Obliczenia!$D$1<=Baza!$AH$4,$D$1*Baza!$AI$4,Obliczenia!$D$1<=Baza!$AH$5,$D$1*Baza!$AI$5,Obliczenia!$D$1<=Baza!$AH$6,$D$1*Baza!$AI$6,Obliczenia!$D$1<=Baza!$AH$7,$D$1*Baza!$AI$7)","v":1980},{"$f":"IF($B$2=Baza!$A$4,1500,B20)","v":1980}]
["Transport",{"$f":"VLOOKUP(A21,Baza!$AJ:$AK,2,0)","v":500},{"$f":"B21","v":500}]
["Montaż ME",{"$f":"VLOOKUP(A22,Baza!$AJ:$AK,2,0)","v":500},{"$f":"IFERROR(IF(SEARCH(\"magazyn\",$B$2)>0,B22,0),0)","v":500}]
["Ppoż",{"$f":"VLOOKUP(A23,Baza!$AJ:$AK,2,0)","v":800},{"$f":"IF($D$1>=6.5,B23,0)","v":0},{"$f":"Kalkulator!$D$18","v":"Deye PRO-B 5,12 kWh"}]
["Magazyn Energii",{"$f":"VLOOKUP($D$23,Baza!$U$3:$W$20,3,0)","v":3871},{"$f":"IFERROR(_xlfn.IFS(B2=Baza!A3,Obliczenia!B24,B2=Baza!A4,Obliczenia!B24),0)","v":3871},{"$f":"IFERROR(IF(OR(B2=Baza!A3,B2=Baza!A4),VLOOKUP(Kalkulator!$D$18,Baza!$U:$W,2,0),0),0)","v":5.12},{"$f":"IF($D$24<>0,_xlfn.CONCAT($D$24,\" kwp\"),\"\")","v":"5,12 kwp"},{"$f":"_xlfn.IFS(C24=Baza!W4,\"2,5\",C24=Baza!W5,\"5\",C24=Baza!W6,\"7,5\",C24=Baza!W7,\"10\",C24=Baza!W8,\"4,8\",C24=Baza!W9,\"3,6\",C24=Baza!W10,\"4,8\",C24=Baza!W11,\"6\",C24=Baza!W12,\"7,2\")","v":"2,5"},{"$f":"IFERROR(_xlfn.CONCAT($F$24,\" kw\"),\"\")","v":"2,5 kw"}]
[]
["UPS",{"$f":"IF(Kalkulator!D27=Obliczenia!H2,_xlfn.IFS(Kalkulator!D12=Baza!A2,0,Kalkulator!D12=Baza!A3,Baza!AK22,Kalkulator!D12=Baza!A4,Baza!AK22),0)","v":0},{"$f":"B26","v":0}]
["Marża EcoRun",{"$f":"_xlfn.IFS(Marże!A1=Marże!L1,VLOOKUP(Marże!K1,Marże!A:B,2,0),Marże!L1=Marże!D1,VLOOKUP(Marże!K1,Marże!D:E,2,0),Marże!L1=Marże!G1,VLOOKUP(Marże!K1,Marże!G:H,2,0))","v":3475.8},{"$f":"IF(Kalkulator!D12=Baza!A4,2500+Marże!L4,Obliczenia!B27)","v":3475.8}]
["Marża SupremeEnergy ",{"$f":"Marże!AB4","v":10000},{"$f":"_xlfn.IFS(Kalkulator!D18=Baza!U23,Obliczenia!B28,Kalkulator!D18=Baza!U24,Obliczenia!B28+1000,Kalkulator!D18=Baza!U25,Obliczenia!B28+2000,Kalkulator!D18=Baza!U26,Obliczenia!B28+3000,Kalkulator!D18=Baza!U27,Obliczenia!B28+4000,Kalkulator!D18=Baza!U28,Obliczenia!B28+5000,Kalkulator!D18=Baza!U29,Obliczenia!B28+6000)","v":10000},{"$f":"_xlfn.IFS(K3=1,SUM(C3:C4,C7:C28,E6),K6=1,SUM(C3:C4,C7:C28,E6))","v":33170.800000000003}]
[]
[]
["Pakiet",{"$f":"_xlfn.IFS(Kalkulator!D32=Baza!B2,Baza!C2,Kalkulator!D32=Baza!B3,Baza!C3,Kalkulator!D32=Baza!B4,Baza!C4,Kalkulator!D32=Baza!B5,Baza!C5)","v":10000},{"$f":"B31","v":10000}]
[]
["Narzut dodany przez handlowca:",{"$f":"Kalkulator!$D$37","v":0},{"$f":"IFERROR(_xlfn.IFS(AND($B$31=Baza!$C$2,Kalkulator!$D$17<>Baza!$D$4,Obliczenia!$D$1<=20),Obliczenia!$B$33,AND($B$31=Baza!$C$2,Kalkulator!$D$17=Baza!$D$4,Obliczenia!$D$1<=10),Obliczenia!$B$33,AND($B$31=Baza!$C$4,Kalkulator!$D$17<>Baza!$D$4,Obliczenia!$D$1>20),Obliczenia!$B$33,AND($B$31=Baza!$C$4,Kalkulator!$D$17=Baza!$D$4,Obliczenia!$D$1>10),Obliczenia!$B$33),0)","v":0},{"$f":"IF(Kalkulator!D32=Baza!B2,\"TAK\",\"NIE\")","v":"TAK"}]

{"sheet":"Marże","index":8,"n_rows":107,"n_cols":28,"rows_kept":107,"cut":false,"hidden":true,"merged":[[1,8,1,9],[0,8,0,9],[1,0,1,1],[1,3,1,4],[1,6,1,7],[0,0,0,1],[0,3,0,4],[0,6,0,7],[0,23,0,24],[1,23,1,24],[0,14,0,15],[0,17,0,18],[0,20,0,21],[1,14,1,15],[1,17,1,18],[1,20,1,21]]}
["PV Mikro",null,null,"PV + Inwerter hybrydowy ",null,null,"PV + Inwerter hybrydowy + Magazyn Energii",null,"ME",null,{"$f":"Obliczenia!D1","v":3.6},{"$f":"Kalkulator!D12","v":"PV + Inwerter hybrydowy + Magazyn Energii"},{"$f":"Kalkulator!D18","v":"Deye PRO-B 5,12 kWh"},null,"PV Mikro",null,null,"PV + Inwerter hybrydowy ",null,null,"PV + Inwerter hybrydowy + Magazyn Energii",null,null,"ME"]
["Marża ER",null,null,"Marża ER",null,null,"Marża ER",null,"Marża ER",null,null,null,null,null,"Marża PRO",null,null,"Marża PRO",null,null,"Marża PRO",null,null,"Marża PRO"]
[3.15,4000,null,3.15,5310.48,null,3.15,3049.2799999999997,"Deye PRO-B 5,12 kWh",3500,null,null,null,null,3.15,2835,null,3.15,2835,null,3.15,10000,null,4.8,8000]
[3.6,4500,null,3.6,6006.52,null,3.6,3475.8,"DYNESS 7,2 kWh",4500,null,{"$f":"_xlfn.IFS(L1=A1,VLOOKUP(K1,A:B,2,0),L1=D1,VLOOKUP(K1,D:E,2,0),L1=G1,VLOOKUP(K1,G:H,2,0),L1=I1,VLOOKUP(M1,I:J,2,0))","v":3475.8},null,null,3.6,3240,null,3.6,3240,null,3.6,10000,null,7.2,9000,null,{"$f":"Obliczenia!D24","v":5.12},{"$f":"IFERROR(_xlfn.IFS(L1=O1,VLOOKUP(K1,O:P,2,0),L1=R1,VLOOKUP(K1,R:S,2,0),L1=U1,VLOOKUP(K1,U:V,2,0)),VLOOKUP(AA4,Marże!X:Y,2,0))","v":10000}]
[4.05,5000,null,4.05,4479.45,null,4.05,4536.09,"DYNESS 9,6 kWh",4500,null,null,null,null,4.05,3645,null,4.05,3645,null,4.05,10000,null,9.6,10000]
[4.5,5000,null,4.5,4625.7,null,4.5,4749.6000000000004,"DYNESS 12 kWh",6500,null,null,null,null,4.5,3600,null,4.5,3600,null,4.5,10000,null,12,11000]
[4.95,6000,null,4.95,4931.0200000000004,null,4.95,4866.6000000000004,"DYNESS 14,4 kWh",6500,null,null,null,null,4.95,3960,null,4.95,3960,null,4.95,11000,null,14.4,12000,null,{"$f":"IF(AA4=X4,1,0)","v":0}]
[5.4,6000,null,5.4,5082.1400000000003,null,5.4,5398.9,"Deye PRO-B 15,36 kWh",7500,null,null,null,null,5.4,4320,null,5.4,4320,null,5.4,11000,null,5.12,8000]
[5.8500000000000005,6000,null,5.8500000000000005,5636.9,null,5.8500000000000005,5577.65,"Deye PRO-B 20,48 kWh",7500,null,null,null,null,5.8500000000000005,4680,null,5.8500000000000005,4680,null,5.8500000000000005,11000,null,10.24,10000]
[6.3,6000,null,6.3,6149.15,null,6.3,5923.8,null,null,null,null,null,null,6.3,5040,null,6.3,5040,null,6.3,11000,null,15.36,12000]
[6.75,6000,null,6.75,6599.78,null,6.75,6503.7,null,null,null,null,null,null,6.75,5400,null,6.75,5400,null,6.75,12000,null,20.48,14000]
[7.2,6000,null,7.2,6919.5,null,7.2,6397.37,null,null,null,null,null,null,7.2,5760,null,7.2,5760,null,7.2,12000]
[7.65,6000,null,7.65,7090.13,null,7.65,6526.55,null,null,null,null,null,null,7.65,6120,null,7.65,6120,null,7.65,12000]
[8.1,8000,null,8.1,7260.75,null,8.1,6655.74,null,null,null,null,null,null,8.1,6480,null,8.1,6480,null,8.1,13000]
[8.5500000000000007,8000,null,8.5500000000000007,7431.38,null,8.5500000000000007,6784.93,null,null,null,null,null,null,8.5500000000000007,6840.0000000000009,null,8.5500000000000007,6840.0000000000009,null,8.5500000000000007,13000]
[9,8000,null,9,7602,null,9,6914.12,null,null,null,null,null,null,9,7200,null,9,7200,null,9,13000]
[9.4500000000000011,8000,null,9.4500000000000011,7860.13,null,9.4500000000000011,7109.55,null,null,null,null,null,null,9.4500000000000011,7560.0000000000009,null,9.4500000000000011,7560.0000000000009,null,9.4500000000000011,13000]
[9.9,10000,null,9.9,8030.75,null,9.9,7238.74,null,null,null,null,null,null,9.9,6930,null,9.9,7920,null,9.9,13000]
[10.35,10000,null,10.35,9566,null,10.35,9617.24,null,null,null,null,null,null,10.35,7245,null,10.35,7245,null,10.35,14000]
[10.8,10000,null,10.8,9752,null,10.8,9775.34,null,null,null,null,null,null,10.8,7560.0000000000009,null,10.8,7560.0000000000009,null,10.8,14000]
[11.25,10000,null,11.25,9938,null,11.25,9933.44,null,null,null,null,null,null,11.25,7875,null,11.25,7875,null,11.25,14000]
[11.700000000000001,10000,null,11.700000000000001,10124,null,11.700000000000001,10091.540000000001,null,null,null,null,null,null,11.700000000000001,8190.0000000000009,null,11.700000000000001,8190.0000000000009,null,11.700000000000001,14000]
[12.15,10000,null,12.15,10310,null,12.15,10249.64,null,null,null,null,null,null,12.15,8505,null,12.15,8505,null,12.15,14000]
[12.6,12000,null,12.6,10524,null,12.6,10431.540000000001,null,null,null,null,null,null,12.6,8820,null,12.6,8820,null,12.6,14000]
[13.05,12000,null,13.05,12048.75,null,13.05,10589.64,null,null,null,null,null,null,13.05,9135,null,13.05,9135,null,13.05,14000]
[13.5,12000,null,13.5,12258,null,13.5,10747.74,null,null,null,null,null,null,13.5,9450,null,13.5,9450,null,13.5,14000]
[13.950000000000001,12000,null,13.950000000000001,12467.25,null,13.950000000000001,10905.84,null,null,null,null,null,null,13.950000000000001,9765,null,13.950000000000001,9765,null,13.950000000000001,14000]
[14.4,12000,null,14.4,12676.5,null,14.4,11063.94,null,null,null,null,null,null,14.4,10080,null,14.4,10080,null,14.4,14000]
[14.85,12000,null,14.85,13380.75,null,14.85,11596.04,null,null,null,null,null,null,14.85,10395,null,14.85,10395,null,14.85,14000]
[15.3,15000,null,15.3,13815,null,15.3,11924.14,null,null,null,null,null,null,15.3,10710,null,15.3,10710,null,15.3,14000]
[15.75,15000,null,15.75,14429.25,null,15.75,12388.24,null,null,null,null,null,null,15.75,11025,null,15.75,11025,null,15.75,14000]
[16.2,15000,null,16.2,14638.5,null,16.2,12546.34,null,null,null,null,null,null,16.2,11340,null,16.2,11340,null,16.2,14000]
[16.650000000000002,15000,null,16.650000000000002,14847.75,null,16.650000000000002,12704.44,null,null,null,null,null,null,16.650000000000002,11655.000000000002,null,16.650000000000002,11655.000000000002,null,16.650000000000002,14000]
[17.100000000000001,15000,null,17.100000000000001,16005.15,null,17.100000000000001,13578.92,null,null,null,null,null,null,17.100000000000001,11970.000000000002,null,17.100000000000001,11970.000000000002,null,17.100000000000001,14000]
[17.55,15000,null,17.55,16214.4,null,17.55,13737.02,null,null,null,null,null,null,17.55,12285,null,17.55,12285,null,17.55,14000]
[18,15000,null,18,16423.650000000001,null,18,13895.12,null,null,null,null,null,null,18,12600,null,18,12600,null,18,14000]
[18.45,15000,null,18.45,16632.900000000001,null,18.45,14053.22,null,null,null,null,null,null,18.45,12915,null,18.45,12915,null,18.45,14000]
[18.900000000000002,15000,null,18.900000000000002,16842.150000000001,null,18.900000000000002,14211.32,null,null,null,null,null,null,18.900000000000002,11340.000000000002,null,18.900000000000002,13230.000000000002,null,18.900000000000002,14000]
[19.350000000000001,15000,null,19.350000000000001,17051.400000000001,null,19.350000000000001,14369.42,null,null,null,null,null,null,19.350000000000001,11610,null,19.350000000000001,13545.000000000002,null,19.350000000000001,14000]
[19.8,15000,null,19.8,17260.650000000001,null,19.8,14527.52,null,null,null,null,null,null,19.8,11880,null,19.8,13860,null,19.8,14000]
[20.25,15000,null,null,null,null,null,null,null,null,null,null,null,null,20.25,12150]
[20.7,15000,null,null,null,null,null,null,null,null,null,null,null,null,20.7,12420]
[21.150000000000002,15000,null,null,null,null,null,null,null,null,null,null,null,null,21.150000000000002,12690]
[21.6,15000,null,null,null,null,null,null,null,null,null,null,null,null,21.6,12960]
[22.05,15000,null,null,null,null,null,null,null,null,null,null,null,null,22.05,13230]
[22.5,15000,null,null,null,null,null,null,null,null,null,null,null,null,22.5,13500]
[22.95,15000,null,null,null,null,null,null,null,null,null,null,null,null,22.95,13770]
[23.400000000000002,15000,null,null,null,null,null,null,null,null,null,null,null,null,23.400000000000002,14040]
[23.85,15000,null,null,null,null,null,null,null,null,null,null,null,null,23.85,14310]
[24.3,15000,null,null,null,null,null,null,null,null,null,null,null,null,24.3,14580]
[24.75,15000,null,null,null,null,null,null,null,null,null,null,null,null,24.75,14850]
[25.2,17000,null,null,null,null,null,null,null,null,null,null,null,null,25.2,15120]
[25.650000000000002,17000,null,null,null,null,null,null,null,null,null,null,null,null,25.650000000000002,15390]
[26.1,17000,null,null,null,null,null,null,null,null,null,null,null,null,26.1,15660]
[26.55,17000,null,null,null,null,null,null,null,null,null,null,null,null,26.55,15930]
[27,17000,null,null,null,null,null,null,null,null,null,null,null,null,27,16200]
[27.45,17000,null,null,null,null,null,null,null,null,null,null,null,null,27.45,16470]
[27.900000000000002,17000,null,null,null,null,null,null,null,null,null,null,null,null,27.900000000000002,13950]
[28.35,17000,null,null,null,null,null,null,null,null,null,null,null,null,28.35,14175]
[28.8,17000,null,null,null,null,null,null,null,null,null,null,null,null,28.8,14400]
[29.25,17000,null,null,null,null,null,null,null,null,null,null,null,null,29.25,14625]
[29.7,17000,null,null,null,null,null,null,null,null,null,null,null,null,29.7,14850]
[30.150000000000002,19000,null,null,null,null,null,null,null,null,null,null,null,null,30.150000000000002,15075]
[30.6,19000,null,null,null,null,null,null,null,null,null,null,null,null,30.6,15300]
[31.05,19000,null,null,null,null,null,null,null,null,null,null,null,null,31.05,15525]
[31.5,19000,null,null,null,null,null,null,null,null,null,null,null,null,31.5,15750]
[31.95,19000,null,null,null,null,null,null,null,null,null,null,null,null,31.95,15975]
[32.4,19000,null,null,null,null,null,null,null,null,null,null,null,null,32.4,16200]
[32.85,19000,null,null,null,null,null,null,null,null,null,null,null,null,32.85,16425]
[33.300000000000004,19000,null,null,null,null,null,null,null,null,null,null,null,null,33.300000000000004,16650]
[33.75,19000,null,null,null,null,null,null,null,null,null,null,null,null,33.75,16875]
[34.200000000000003,19000,null,null,null,null,null,null,null,null,null,null,null,null,34.200000000000003,17100]
[34.65,19000,null,null,null,null,null,null,null,null,null,null,null,null,34.65,17325]
[35.1,19000,null,null,null,null,null,null,null,null,null,null,null,null,35.1,17550]
[35.550000000000004,19000,null,null,null,null,null,null,null,null,null,null,null,null,35.550000000000004,17775]
[36,19000,null,null,null,null,null,null,null,null,null,null,null,null,36,18000]
[36.450000000000003,19000,null,null,null,null,null,null,null,null,null,null,null,null,36.450000000000003,18225]
[36.9,19000,null,null,null,null,null,null,null,null,null,null,null,null,36.9,14760]
[37.35,19000,null,null,null,null,null,null,null,null,null,null,null,null,37.35,14940]
[37.800000000000004,19000,null,null,null,null,null,null,null,null,null,null,null,null,37.800000000000004,15119.999999999998]
[38.25,19000,null,null,null,null,null,null,null,null,null,null,null,null,38.25,15300]
[38.700000000000003,19000,null,null,null,null,null,null,null,null,null,null,null,null,38.700000000000003,15480.000000000002]
[39.15,19000,null,null,null,null,null,null,null,null,null,null,null,null,39.15,15660]
[39.6,19000,null,null,null,null,null,null,null,null,null,null,null,null,39.6,15840]
[40.050000000000004,25000,null,null,null,null,null,null,null,null,null,null,null,null,40.050000000000004,16019.999999999998]
[40.5,25000,null,null,null,null,null,null,null,null,null,null,null,null,40.5,16200]
[40.950000000000003,25000,null,null,null,null,null,null,null,null,null,null,null,null,40.950000000000003,16380.000000000002]
[41.4,25000,null,null,null,null,null,null,null,null,null,null,null,null,41.4,16560]
[41.85,25000,null,null,null,null,null,null,null,null,null,null,null,null,41.85,16740]
[42.300000000000004,25000,null,null,null,null,null,null,null,null,null,null,null,null,42.300000000000004,16920]
[42.75,25000,null,null,null,null,null,null,null,null,null,null,null,null,42.75,17100]
[43.2,25000,null,null,null,null,null,null,null,null,null,null,null,null,43.2,17280]
[43.65,25000,null,null,null,null,null,null,null,null,null,null,null,null,43.65,17460]
[44.1,25000,null,null,null,null,null,null,null,null,null,null,null,null,44.1,17640]
[44.550000000000004,25000,null,null,null,null,null,null,null,null,null,null,null,null,44.550000000000004,17820]
[45,25000,null,null,null,null,null,null,null,null,null,null,null,null,45,18000]
[45.45,25000,null,null,null,null,null,null,null,null,null,null,null,null,45.45,18180]
[45.9,25000,null,null,null,null,null,null,null,null,null,null,null,null,45.9,18360]
[46.35,25000,null,null,null,null,null,null,null,null,null,null,null,null,46.35,18540]
[46.800000000000004,25000,null,null,null,null,null,null,null,null,null,null,null,null,46.800000000000004,18720]
[47.25,25000,null,null,null,null,null,null,null,null,null,null,null,null,47.25,18900]
[47.7,25000,null,null,null,null,null,null,null,null,null,null,null,null,47.7,19080]
[48.15,25000,null,null,null,null,null,null,null,null,null,null,null,null,48.15,19260]
[48.6,25000,null,null,null,null,null,null,null,null,null,null,null,null,48.6,19440]
[49.050000000000004,25000,null,null,null,null,null,null,null,null,null,null,null,null,49.050000000000004,19620]
[49.5,25000,null,null,null,null,null,null,null,null,null,null,null,null,49.5,19800]
[49.95,25000,null,null,null,null,null,null,null,null,null,null,null,null,49.95,19980]