{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Select Product Type","Select Product Capacity","Select Type of Heating","Select Capacity of DHW","Select Backup Heater","Report","Img","Sheet1","Resource","Lang"],"not_rendered":{"charts":0,"images":34,"macros":1,"external_links":0,"defined_names":30,"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":"Select Product Type","index":0,"n_rows":13,"n_cols":24,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,3,0,8]]}
[null,null,null,{"$f":"Lang!C3","v":"Warmtepomp configuratie Tool"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M_0",{"$f":"INDIRECT(P2)","v":"Sheet1!$E$10:$G$10"}]
[null,null,"Lagnuage",null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"O3+1","v":2},{"$f":"P3+1","v":3},4,5,6,7,8,9,10]
[null,null,"Dutch",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(INDIRECT($Q$2),1,O3),\"\")","v":"MonoBlock S"},"Split","HydroSplit","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"Lang!C9&\"     \"","v":"CV-Water     "},null,{"$f":"Lang!$C$10&\"     \"","v":"Koudemiddel     "},null,{"$f":"Lang!$C$9&\"     \"","v":"CV-Water     "}]

{"sheet":"Select Product Capacity","index":1,"n_rows":4,"n_cols":24,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,3,0,8]]}
[null,null,null,{"$f":"Lang!$C$3","v":"Warmtepomp configuratie Tool"},null,null,null,null,null,null,null,null,null,null,null,"M_0","Sheet1!$E$10:$G$10",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(INDIRECT(Q1),1,R1)","v":"MonoBlock S"},{"$f":"INDIRECT((MID(Q1,1,8)&CHAR(64+R1+4)&MID(Q1,11,2)+1))","v":"M_1"},{"$f":"INDIRECT(P2)","v":"Sheet1!$E$12:$M$12"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"O3+1","v":2},{"$f":"P3+1","v":3},4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(INDIRECT($Q$2),1,O3),\"\")","v":"5kW, 1 fase"},"7kW, 1 fase","9kW, 1 fase","12kW, 1 fase","14kW, 1 fase","16kW, 1 fase","12kW, 3 fase","14kW, 3 fase","16kW, 3 fase",""]

{"sheet":"Select Type of Heating","index":2,"n_rows":4,"n_cols":24,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,3,0,8]]}
[null,null,null,{"$f":"Lang!$C$3","v":"Warmtepomp configuratie Tool"},null,null,null,null,null,null,null,null,null,null,null,"M_1","Sheet1!$E$12:$M$12",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(INDIRECT(Q1),1,R1)","v":"5kW, 1 fase"},{"$f":"INDIRECT((MID(Q1,1,8)&CHAR(64+R1+4)&MID(Q1,11,2)+1))","v":"M_2"},{"$f":"INDIRECT(P2)","v":"Sheet1!$E$14:$F$14"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"O3+1","v":2},{"$f":"P3+1","v":3},4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(INDIRECT($Q$2),1,O3),\"\")","v":"Verwarming"},"Verwarming en Warmwater","","","","","","","",""]

{"sheet":"Select Capacity of DHW","index":3,"n_rows":4,"n_cols":24,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,3,0,8]]}
[null,null,null,{"$f":"Lang!$C$3","v":"Warmtepomp configuratie Tool"},null,null,null,null,null,null,null,null,null,null,null,"M_2","Sheet1!$E$14:$F$14",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(INDIRECT(Q1),1,R1)","v":"Verwarming en Warmwater"},{"$f":"INDIRECT((MID(Q1,1,8)&CHAR(64+R1+4)&MID(Q1,11,2)+1))","v":"M_3"},{"$f":"INDIRECT(P2)","v":"Sheet1!$E$16:$F$16"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"O3+1","v":2},{"$f":"P3+1","v":3},4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(INDIRECT($Q$2),1,O3),\"\")","v":"200L, Enkel Spiraal"},"300L, Enkel Spiraal","","","","","","","",""]

{"sheet":"Select Backup Heater","index":4,"n_rows":4,"n_cols":24,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,3,0,8]]}
[null,null,null,{"$f":"Lang!$C$3","v":"Warmtepomp configuratie Tool"},null,null,null,null,null,null,null,null,null,null,null,"M_3","Sheet1!$E$16:$F$16",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(INDIRECT(Q1),1,R1)","v":"200L, Enkel Spiraal"},{"$f":"INDIRECT((MID(Q1,1,8)&CHAR(64+R1+4)&MID(Q1,11,2)+1))","v":"M_4"},{"$f":"INDIRECT(P2)","v":"Sheet1!$E$18:$H$18"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"O3+1","v":2},{"$f":"P3+1","v":3},4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(INDIRECT($Q$2),1,O3),\"\")","v":"Geen"},"3kW, 1 fase","6kW, 1 fase","6kW, 3 fase","","","","","",""]

{"sheet":"Report","index":5,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[[15,0,15,10],[30,0,30,10],[30,11,30,12],[29,1,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[14,1,14,2],[14,3,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[20,1,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,10],[29,11,29,12],[0,0,0,12],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,10],[6,1,6,2],[6,3,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,10],[7,1,7,2],[7,3,7,4],[9,11,9,12],[8,11,8,12],[8,1,8,2],[8,3,8,4],[8,5,8,6],[8,7,8,8],[8,9,8,10],[1,7,1,9],[2,7,2,9],[3,7,3,9],[5,1,5,2],[10,11,10,12],[11,11,11,12],[11,1,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,1,10,2],[5,3,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10],[2,0,2,2],[3,0,3,2],[5,11,5,12],[6,11,6,12],[7,11,7,12],[7,5,7,6],[7,7,7,8],[7,9,7,10],[15,11,15,12],[28,1,28,4],[28,5,28,6],[28,7,28,8],[28,9,28,10],[27,1,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[26,1,26,4],[26,5,26,6],[26,7,26,8],[26,9,26,10],[25,1,25,4],[25,5,25,6],[25,7,25,8],[25,9,25,10],[24,1,24,4],[24,5,24,6],[24,7,24,8],[24,9,24,10],[23,1,23,4],[23,5,23,6],[23,7,23,8],[32,0,35,12],[20,11,20,12],[21,11,21,12],[22,11,22,12],[23,11,23,12],[24,11,24,12],[25,11,25,12],[26,11,26,12],[27,11,27,12],[28,11,28,12],[23,9,23,10],[22,1,22,4],[22,5,22,6],[22,7,22,8],[22,9,22,10],[21,1,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10]]}
[{"$f":"Lang!$C$51","v":"LG Electronic Therma V  systeem"}]
[{"$f":"Lang!$C$52","v":"Applicatie"},null,null,"Verwarming en Warmwater",null,null,null,{"$f":"Lang!$C$55","v":"Capaciteit en fase"},null,null,"5kW, 1 fase"]
[{"$f":"Lang!$C$53","v":"Product"},null,null,"MonoBlock S",null,null,null,{"$f":"Lang!$C$56","v":"Boiler type"},null,null,"200L, Enkel Spiraal"]
[{"$f":"Lang!$C$54","v":"Regeling"},null,null,"LG RS3 wired remote controller",null,null,null,{"$f":"Lang!$C$57","v":"Naverwarmer en fase"},null,null,"Geen"]
[]
[{"$f":"Lang!$C$58","v":"No"},{"$f":"Lang!$C$59","v":"Omschrijving"},null,{"$f":"Lang!$C$60","v":"Energie label"},null,{"$f":"Lang!$C$61","v":"Artikel nummer"},null,{"$f":"Lang!$C$62","v":"Aantal"},null,{"$f":"Lang!$C$63","v":"Prijs per stuk"},null,{"$f":"Lang!$C$64","v":"Total"}]
[1,"AWHP",null,null,null,"HM051MR.U44",null,1,null,4745,null,{"$f":"IFERROR(IF(AND(H7<>\"\",J7<>\"\"),H7*J7,\"\"),\"\")","v":4745}]
[2,"DHW",null,null,null,"OSHW-200F",null,1,null,1675,null,1675]
[3,"RS3 Afstandbediening",null,null,null,"PREMTW101",null,1,null,"Incl. in Outdoor unit",null,""]
[4,"Verlengkabel RS3 afstandbediening",null,null,null,"PZCWRC1",null,1,null,50,null,{"$f":"IFERROR(IF(AND(H10<>\"\",J10<>\"\"),H10*J10,\"\"),\"\")","v":50}]
[5,"3-weg klep",null,null,null,"OSHA-3V",null,1,null,450,null,450]
[6,"Boiler kit (B)",null,null,null,"PHLTB",null,1,null,379,null,{"$f":"IFERROR(IF(AND(H12<>\"\",J12<>\"\"),H12*J12,\"\"),\"\")","v":379}]
[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,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(H15<>\"\",J15<>\"\"),H15*J15,\"\"),\"\")","v":""}]
[{"$f":"Lang!$C$66","v":"SubTotal"},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L7:M15)","v":7299}]
[]
[]
[]
[{"$f":"Lang!$C$65","v":"Accessoires"}]
[{"$f":"Lang!$C$58","v":"No"},{"$f":"Lang!$C$59","v":"Omschrijving"},null,null,null,{"$f":"Lang!$C$61","v":"Artikel nummer"},null,{"$f":"Lang!$C$62","v":"Aantal"},null,{"$f":"Lang!$C$63","v":"Prijs per stuk"},null,{"$f":"Lang!$C$64","v":"Total"}]
[1,"Installatiepomp",null,null,null,"3rd Party",null,1,null,null,null,{"$f":"IFERROR(IF(AND(H22<>\"\",J22<>\"\"),H22*J22,\"\"),\"\")","v":""}]
[2,"Magneet filter",null,null,null,"3rd Party",null,1,null,null,null,""]
[3,"CV-Buffer ",null,null,null,"3rd Party",null,1,null,null,null,""]
[4,"Drukverschil regelaar",null,null,null,"3rd Party",null,1,null,null,null,""]
[5,"Lucht afscheider",null,null,null,"3rd Party",null,1,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,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
["Subtotal",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L22:M30)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,""]
["Alle informatie is onder voorbehoud van prijswijzigingen, typefouten, en marktontwikkelingen. \nAlle prijzen zijn onder voorbehoud van prijswijzigingen. \nControleer altijd de geldende prijzen en condities bij uw leverancier"]

{"sheet":"Img","index":6,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["NULL","MonoBlock S","Split","HydroSplit"]

{"sheet":"Sheet1","index":7,"n_rows":65,"n_cols":14,"rows_kept":65,"cut":false,"hidden":true,"merged":[[7,4,7,13]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Value"]
[null,null,null,null,1,2,3,4,5,6,{"$f":"J9+1","v":7},{"$f":"K9+1","v":8},9,10]
[null,"M_0",{"$f":"IF(D10>COLUMN($D10),\"Sheet1!$\"&CHAR(64+COLUMN($E10))&\"$\"&ROW($D10)&\":$\"&CHAR(64+$D10)&\"$\"&ROW($D10),\"\")","v":"Sheet1!$E$10:$G$10"},{"$f":"COUNTA(E10:N10)+COLUMN(D10)","v":7},{"$f":"Lang!$C$11","v":"MonoBlock S"},{"$f":"Lang!$C$12","v":"Split"},{"$f":"Lang!$C$13","v":"HydroSplit"}]
[null,null,{"$f":"Lang!$C$4","v":"Selecteer Product Type"},null,"M_1","S_1","H_1"]
[null,"M_1",{"$f":"IF(D12>COLUMN($D12),\"Sheet1!$\"&CHAR(64+COLUMN($E12))&\"$\"&ROW($D12)&\":$\"&CHAR(64+$D12)&\"$\"&ROW($D12),\"\")","v":"Sheet1!$E$12:$M$12"},{"$f":"COUNTA(E12:N12)+COLUMN(D12)","v":13},{"$f":"Lang!$C$14","v":"5kW, 1 fase"},{"$f":"Lang!$C$15","v":"7kW, 1 fase"},{"$f":"Lang!$C$16","v":"9kW, 1 fase"},{"$f":"Lang!$C$17","v":"12kW, 1 fase"},{"$f":"Lang!$C$18","v":"14kW, 1 fase"},{"$f":"Lang!$C$19","v":"16kW, 1 fase"},{"$f":"Lang!$C$20","v":"12kW, 3 fase"},{"$f":"Lang!$C$21","v":"14kW, 3 fase"},{"$f":"Lang!$C$22","v":"16kW, 3 fase"}]
[null,null,{"$f":"Lang!$C$5","v":"Selecteer Product Capaciteit"},null,"M_2","M_2","M_2","M_2","M_2","M_2","M_2","M_2","M_2"]
[null,"M_2",{"$f":"IF(D14>COLUMN($D14),\"Sheet1!$\"&CHAR(64+COLUMN($E14))&\"$\"&ROW($D14)&\":$\"&CHAR(64+$D14)&\"$\"&ROW($D14),\"\")","v":"Sheet1!$E$14:$F$14"},{"$f":"COUNTA(E14:N14)+COLUMN(D14)","v":6},{"$f":"Lang!$C$23","v":"Verwarming"},{"$f":"Lang!$C$24","v":"Verwarming en Warmwater"}]
[null,null,{"$f":"Lang!$C$6","v":"Selecteer Installatie type"},null,"M_4","M_3"]
[null,"M_3",{"$f":"IF(D16>COLUMN($D16),\"Sheet1!$\"&CHAR(64+COLUMN($E16))&\"$\"&ROW($D16)&\":$\"&CHAR(64+$D16)&\"$\"&ROW($D16),\"\")","v":"Sheet1!$E$16:$F$16"},{"$f":"COUNTA(E16:N16)+COLUMN(D16)","v":6},{"$f":"Lang!$C$27","v":"200L, Enkel Spiraal"},{"$f":"Lang!$C$28","v":"300L, Enkel Spiraal"}]
[null,null,{"$f":"Lang!$C$7","v":"Selecteer Boiler "},null,"M_4","M_4"]
[null,"M_4",{"$f":"IF(D18>COLUMN($D18),\"Sheet1!$\"&CHAR(64+COLUMN($E18))&\"$\"&ROW($D18)&\":$\"&CHAR(64+$D18)&\"$\"&ROW($D18),\"\")","v":"Sheet1!$E$18:$H$18"},{"$f":"COUNTA(E18:N18)+COLUMN(D18)","v":8},{"$f":"Lang!$C$31","v":"Geen"},{"$f":"Lang!$C$32","v":"3kW, 1 fase"},{"$f":"Lang!$C$33","v":"6kW, 1 fase"},{"$f":"Lang!$C$34","v":"6kW, 3 fase"}]
[null,"mono, 3ph",{"$f":"Lang!$C$8","v":"Selecteer Naverwarmer"},null,"END","END","END","END"]
[]
[]
[]
[null,"S_1",{"$f":"IF(D23>COLUMN($D23),\"Sheet1!$\"&CHAR(64+COLUMN($E23))&\"$\"&ROW($D23)&\":$\"&CHAR(64+$D23)&\"$\"&ROW($D23),\"\")","v":"Sheet1!$E$23:$M$23"},{"$f":"COUNTA(E23:N23)+COLUMN(D23)","v":13},{"$f":"Lang!$C$14","v":"5kW, 1 fase"},{"$f":"Lang!$C$15","v":"7kW, 1 fase"},{"$f":"Lang!$C$16","v":"9kW, 1 fase"},{"$f":"Lang!$C$17","v":"12kW, 1 fase"},{"$f":"Lang!$C$18","v":"14kW, 1 fase"},{"$f":"Lang!$C$19","v":"16kW, 1 fase"},{"$f":"Lang!$C$20","v":"12kW, 3 fase"},{"$f":"Lang!$C$21","v":"14kW, 3 fase"},{"$f":"Lang!$C$22","v":"16kW, 3 fase"}]
[null,null,{"$f":"Lang!$C$5","v":"Selecteer Product Capaciteit"},null,"S_2","S_2","S_2","S_2","S_2","S_2","S_2","S_2","S_2"]
[null,"S_2",{"$f":"IF(D25>COLUMN($D25),\"Sheet1!$\"&CHAR(64+COLUMN($E25))&\"$\"&ROW($D25)&\":$\"&CHAR(64+$D25)&\"$\"&ROW($D25),\"\")","v":"Sheet1!$E$25:$F$25"},{"$f":"COUNTA(E25:N25)+COLUMN(D25)","v":6},{"$f":"Lang!$C$23","v":"Verwarming"},{"$f":"Lang!$C$24","v":"Verwarming en Warmwater"}]
[null,null,{"$f":"Lang!$C$6","v":"Selecteer Installatie type"},null,"END","S_3"]
[null,"S_3",{"$f":"IF(D27>COLUMN($D27),\"Sheet1!$\"&CHAR(64+COLUMN($E27))&\"$\"&ROW($D27)&\":$\"&CHAR(64+$D27)&\"$\"&ROW($D27),\"\")","v":"Sheet1!$E$27:$G$27"},{"$f":"COUNTA(E27:N27)+COLUMN(D27)","v":7},{"$f":"Lang!$C$27","v":"200L, Enkel Spiraal"},{"$f":"Lang!$C$28","v":"300L, Enkel Spiraal"},{"$f":"IF(INT(MID(Report!K2,1,1))=1,\"\",Lang!$C$29)","v":"200L, IWT"}]
[null,null,{"$f":"Lang!$C$7","v":"Selecteer Boiler "},null,"END","END",{"$f":"IF(G27=\"\",\"\",END)","v":"END"}]
[]
[]
[]
[null,"H_1",{"$f":"IF(D32>COLUMN($D32),\"Sheet1!$\"&CHAR(64+COLUMN($E32))&\"$\"&ROW($D32)&\":$\"&CHAR(64+$D32)&\"$\"&ROW($D32),\"\")","v":"Sheet1!$E$32:$J$32"},{"$f":"COUNTA(E32:N32)+COLUMN(D32)","v":10},{"$f":"Lang!$C$17","v":"12kW, 1 fase"},{"$f":"Lang!$C$18","v":"14kW, 1 fase"},{"$f":"Lang!$C$19","v":"16kW, 1 fase"},{"$f":"Lang!$C$20","v":"12kW, 3 fase"},{"$f":"Lang!$C$21","v":"14kW, 3 fase"},{"$f":"Lang!$C$22","v":"16kW, 3 fase"}]
[null,null,{"$f":"Lang!$C$5","v":"Selecteer Product Capaciteit"},null,"H_2","H_2","H_2","H_2","H_2","H_2"]
[null,"H_2",{"$f":"IF(D34>COLUMN($D34),\"Sheet1!$\"&CHAR(64+COLUMN($E34))&\"$\"&ROW($D34)&\":$\"&CHAR(64+$D34)&\"$\"&ROW($D34),\"\")","v":"Sheet1!$E$34:$F$34"},{"$f":"COUNTA(E34:N34)+COLUMN(D34)","v":6},{"$f":"Lang!$C$23","v":"Verwarming"},{"$f":"Lang!$C$24","v":"Verwarming en Warmwater"}]
[null,null,{"$f":"Lang!$C$6","v":"Selecteer Installatie type"},null,"H_4","H_3"]
[null,"H_3",{"$f":"IF(D36>COLUMN($D36),\"Sheet1!$\"&CHAR(64+COLUMN($E36))&\"$\"&ROW($D36)&\":$\"&CHAR(64+$D36)&\"$\"&ROW($D36),\"\")","v":"Sheet1!$E$36:$G$36"},{"$f":"COUNTA(E36:N36)+COLUMN(D36)","v":7},{"$f":"Lang!$C$27","v":"200L, Enkel Spiraal"},{"$f":"Lang!$C$28","v":"300L, Enkel Spiraal"},{"$f":"Lang!$C$29","v":"200L, IWT"}]
[null,null,{"$f":"Lang!$C$7","v":"Selecteer Boiler "},null,"H_4","H_4","H_4"]
[null,"H_4",{"$f":"IF(D38>COLUMN($D38),\"Sheet1!$\"&CHAR(64+COLUMN($E38))&\"$\"&ROW($D38)&\":$\"&CHAR(64+$D38)&\"$\"&ROW($D38),\"\")","v":"Sheet1!$E$38:$G$38"},{"$f":"COUNTA(E38:N38)+COLUMN(D38)","v":7},{"$f":"Lang!$C$31","v":"Geen"},{"$f":"Lang!$C$33","v":"6kW, 1 fase"},{"$f":"Lang!$C$34","v":"6kW, 3 fase"}]
[null,"H_split, 3ph",{"$f":"Lang!$C$8","v":"Selecteer Naverwarmer"},null,"END","END","END"]
[]
[]
[]
[null,"END","END"]
[null,null,"END"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"5kW, 1Ø (HM051MR.U44)","7kW, 1Ø (HM071MR.U44)","9kW, 1Ø (HM091MR.U44)","12kW, 1Ø (HM121MR.U34)","12kW, 3Ø (HM123MR.U34)","14kW, 1Ø (HM141MR.U34)","14kW, 3Ø (HM143MR.U34)","16kW, 1Ø (HM161MR.U34)","16kW, 3Ø (HM163MR.U34)"]
[null,null,null,null,"200L, Single Coil (OSHW-200F)","300L, Single Coil (OSHW-300F)","300L, Double Coil (OSHW-500FD)","500L, Single Coil (OSHW-500F)"]
[null,null,null,null,"None","3kW, 1Ø (HA031M E1)","6kW, 1Ø (HA061M E1)","6kW, 3Ø (HA063M E1)"]
[]
[null,null,null,null,"5kW, 1Ø (HU051MR.U44)","7kW, 1Ø (HU071MR.U44)","9kW, 1Ø (HU091MR.U44)","12kW, 1Ø (HU121MA.U33)","12kW, 3Ø (HU123MA.U33)","14kW, 1Ø (HU141MA.U33)","14kW, 3Ø (HU143MA.U33)","16kW, 1Ø (HU161MA.U33)","16kW, 3Ø (HU163MA.U33)"]
[null,null,null,null,"200L, Single Coil (OSHW-200F)","300L, Single Coil (OSHW-300F)","300L, Double Coil (OSHW-500FD)","500L, Single Coil (OSHW-500F)"]
[]
[]
[null,null,null,null,"12kW, 1Ø (HU121MRB.U30)","12kW, 3Ø (HU123MRB.U30)","14kW, 1Ø (HU141MRB.U30)","14kW, 3Ø (HU143MRB.U30)","16kW, 1Ø (HU161MRB.U30)","16kW, 3Ø (HU163MRB.U30)"]
[null,null,null,null,"200L, Single Coil (OSHW-200F)","300L, Single Coil (OSHW-300F)","300L, Double Coil (OSHW-500FD)","500L, Single Coil (OSHW-500F)","200L, IWT"]
[null,null,null,null,"None","6kW, 1Ø (HA061C E1)","6kW, 3Ø (HA063C E1)"]

{"sheet":"Resource","index":8,"n_rows":37,"n_cols":26,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"Report!$D$3&\"/\"&Report!$K$2","v":"MonoBlock S/5kW, 1 fase"},"AWHP",{"$f":"IFERROR(VLOOKUP($B1,$G$2:$K$37,4,FALSE),\"\")","v":"HM051MR.U44"},{"$f":"IFERROR(VLOOKUP($B1,$G$2:$K$40,5,FALSE),\"\")","v":4745},{"$f":"IFERROR(FIND(Lang!$C$50,VLOOKUP($B1,$G$2:$K$37,3,FALSE),1),\"\")","v":""},"AWHP","Type","Product Capacity","Item","Price",null,"Type","Item","Price",null,null,null,"M_1","M_2","S_1","S_2","S_3","H_1","H_2","H_3"]
[null,{"$f":"Report!$D$3&\"/\"&C2","v":"MonoBlock S/Hydro Box"},"Hydro Box",{"$f":"IFERROR(IF(D3=\"\",VLOOKUP($B2,$G$2:$K$37,4,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(D3=\"\",VLOOKUP($B2,$G$2:$K$40,5,FALSE),\"\"),\"\")","v":""},null,{"$f":"H2&\"/\"&I2","v":"MonoBlock S/5kW, 1 fase"},{"$f":"Lang!$C$11","v":"MonoBlock S"},{"$f":"Lang!$C14","v":"5kW, 1 fase"},"HM051MR.U44",4745,null,{"$f":"Lang!$C35","v":"RS3 Afstandbediening"},"PREMTW101","Incl. in Outdoor unit",null,null,null,{"$f":"S3&\"/\"&S4&\"/\"&S5","v":"MonoBlock S/Verwarming/"},"MonoBlock S/Verwarming en Warmwater/","Split/Verwarming/","Split/Verwarming en Warmwater/","Split/Verwarming en Warmwater/IWT","HydroSplit/Verwarming/","HydroSplit/Verwarming en Warmwater/","HydroSplit/Verwarming en Warmwater/IWT"]
[null,{"$f":"Report!$D$3&\"/\"&Report!$K$3","v":"MonoBlock S/200L, Enkel Spiraal"},"IWT",{"$f":"IFERROR(VLOOKUP($B3,$G$2:$K$37,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B3,$G$2:$K$40,5,FALSE),\"\")","v":""},null,{"$f":"H3&\"/\"&I3","v":"MonoBlock S/7kW, 1 fase"},{"$f":"Lang!$C$11","v":"MonoBlock S"},{"$f":"Lang!$C15","v":"7kW, 1 fase"},"HM071MR.U44",5245,null,{"$f":"Lang!$C36","v":"Verlengkabel RS3 afstandbediening"},"PZCWRC1",50,null,null,null,{"$f":"Lang!$C$11","v":"MonoBlock S"},{"$f":"Lang!$C$11","v":"MonoBlock S"},{"$f":"Lang!$C$12","v":"Split"},{"$f":"Lang!$C$12","v":"Split"},{"$f":"Lang!$C$12","v":"Split"},{"$f":"Lang!$C$13","v":"HydroSplit"},{"$f":"Lang!$C$13","v":"HydroSplit"},{"$f":"Lang!$C$13","v":"HydroSplit"}]
[null,{"$f":"Report!K3","v":"200L, Enkel Spiraal"},"DHW",{"$f":"IFERROR(VLOOKUP($B4,$G$2:$K$37,4,FALSE),\"\")","v":"OSHW-200F"},{"$f":"IFERROR(VLOOKUP($B4,$G$2:$K$40,5,FALSE),\"\")","v":1675},null,"MonoBlock S/9kW, 1 fase",{"$f":"Lang!$C$11","v":"MonoBlock S"},{"$f":"Lang!$C16","v":"9kW, 1 fase"},"HM091MR.U44",5695,null,{"$f":"Lang!$C37","v":"Afdekplaat"},"PDC-HK10",60,null,null,null,{"$f":"Lang!$C$23","v":"Verwarming"},{"$f":"Lang!$C$24","v":"Verwarming en Warmwater"},{"$f":"Lang!$C$23","v":"Verwarming"},{"$f":"Lang!$C$24","v":"Verwarming en Warmwater"},{"$f":"Lang!$C$24","v":"Verwarming en Warmwater"},{"$f":"Lang!$C$23","v":"Verwarming"},{"$f":"Lang!$C$24","v":"Verwarming en Warmwater"},{"$f":"Lang!$C$24","v":"Verwarming en Warmwater"}]
[null,{"$f":"Report!$D$3&\"/\"&Report!K4","v":"MonoBlock S/Geen"},{"$f":"Lang!$C$30","v":"Backup Heater"},{"$f":"IFERROR(VLOOKUP($B5,$G$2:$K$35,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B5,$G$2:$K$40,5,FALSE),\"\")","v":""},null,"MonoBlock S/12kW, 1 fase",{"$f":"Lang!$C$11","v":"MonoBlock S"},{"$f":"Lang!$C17","v":"12kW, 1 fase"},"HM121MR.U34",6145,null,{"$f":"Lang!$C38","v":"3-weg klep"},"OSHA-3V",450,null,null,null,null,null,null,null,{"$f":"Lang!$C$25","v":"IWT"},null,null,{"$f":"Lang!$C$25","v":"IWT"}]
[null,null,null,null,null,null,"MonoBlock S/14kW, 1 fase",{"$f":"Lang!$C$11","v":"MonoBlock S"},{"$f":"Lang!$C18","v":"14kW, 1 fase"},"HM141MR.U34",6345,null,{"$f":"Lang!$C39","v":"Boiler sensor"},"PHRSTA0",43,null,null,null,{"$f":"$M2","v":"RS3 Afstandbediening"},{"$f":"$M2","v":"RS3 Afstandbediening"},"RS3 Afstandbediening","RS3 Afstandbediening",{"$f":"$M2","v":"RS3 Afstandbediening"},"RS3 Afstandbediening",{"$f":"$M2","v":"RS3 Afstandbediening"},"RS3 Afstandbediening"]
[null,{"$f":"Report!D3","v":"MonoBlock S"},{"$f":"Report!D2","v":"Verwarming en Warmwater"},{"$f":"IFERROR(IF(FIND(\"IWT\",Report!K3,1)>0,\"IWT\",\"\"),\"\")","v":""},null,null,"MonoBlock S/16kW, 1 fase",{"$f":"Lang!$C$11","v":"MonoBlock S"},{"$f":"Lang!$C19","v":"16kW, 1 fase"},"HM161MR.U34",6745,null,{"$f":"Lang!$C40","v":"Temperatuursensor 2e CV-circuit "},"PRSTAT5K10",99,null,null,null,{"$f":"$M3","v":"Verlengkabel RS3 afstandbediening"},"Verlengkabel RS3 afstandbediening",{"$f":"$M3","v":"Verlengkabel RS3 afstandbediening"},{"$f":"$M3","v":"Verlengkabel RS3 afstandbediening"},"Verlengkabel RS3 afstandbediening","Verlengkabel RS3 afstandbediening","Verlengkabel RS3 afstandbediening","Verlengkabel RS3 afstandbediening"]
[null,{"$f":"B7&\"/\"&C7&\"/\"&D7","v":"MonoBlock S/Verwarming en Warmwater/"},{"$f":"MATCH(B8,$S$2:$Z$2,0)","v":2},{"$f":"INDEX($S$1:$Z$1,1,C8)","v":"M_2"},null,null,"MonoBlock S/12kW, 3 fase",{"$f":"Lang!$C$11","v":"MonoBlock S"},{"$f":"Lang!$C20","v":"12kW, 3 fase"},"HM123MR.U34",6145,null,{"$f":"Lang!$C41","v":"Boiler kit (A)"},"PHLTA",259,null,null,null,null,null,{"$f":"$M4","v":"Afdekplaat"},"Afdekplaat","Afdekplaat","Afdekplaat","Afdekplaat","Afdekplaat"]
[null,5,{"$f":"IFERROR(INDEX($S$2:$Z$20,$B9,$C$8),\"\")","v":"RS3 Afstandbediening"},{"$f":"IFERROR(VLOOKUP(C9,$M$2:$O$16,2,FALSE),\"\")","v":"PREMTW101"},{"$f":"IFERROR(VLOOKUP(C9,$M$2:$O$16,3,FALSE),\"\")","v":"Incl. in Outdoor unit"},null,"MonoBlock S/14kW, 3 fase",{"$f":"Lang!$C$11","v":"MonoBlock S"},{"$f":"Lang!$C21","v":"14kW, 3 fase"},"HM143MR.U34",6345,null,{"$f":"Lang!$C42","v":"Boiler kit (B)"},"PHLTB",379,null,null,null,null,"3-weg klep",null,{"$f":"$M5","v":"3-weg klep"},null,null,{"$f":"$M5","v":"3-weg klep"}]
[null,6,"Verlengkabel RS3 afstandbediening","PZCWRC1",50,null,"MonoBlock S/16kW, 3 fase",{"$f":"Lang!$C$11","v":"MonoBlock S"},{"$f":"Lang!$C22","v":"16kW, 3 fase"},"HM163MR.U34",6745,null,{"$f":"Lang!$C43","v":"Boiler kit (C)"},"PHLTC",259,null,null,null,null,{"$f":"$M9","v":"Boiler kit (B)"},null,{"$f":"IF(F1>1,$M8,$M10)","v":"Boiler kit (A)"},null,null,{"$f":"IF(I1>1,$M8,$M10)","v":"Boiler kit (A)"}]
[null,7,0,"","",null,"MonoBlock S/3kW, 1 fase",{"$f":"Lang!$C$11","v":"MonoBlock S"},{"$f":"Lang!$C32","v":"3kW, 1 fase"},"HA031M E1",959]
[null,8,"3-weg klep","OSHA-3V",450,null,"MonoBlock S/6kW, 1 fase",{"$f":"Lang!$C$11","v":"MonoBlock S"},{"$f":"Lang!$C33","v":"6kW, 1 fase"},"HA061M E1",1069,null,{"$f":"Lang!$C44","v":"Installatiepomp"}]
[null,9,"Boiler kit (B)","PHLTB",379,null,"MonoBlock S/6kW, 3 fase",{"$f":"Lang!$C$11","v":"MonoBlock S"},{"$f":"Lang!$C34","v":"6kW, 3 fase"},"HA063M E1",1275,null,{"$f":"Lang!$C45","v":"Magneet filter"}]
[null,10,0,"","",null,"Split/5kW, 1 fase",{"$f":"Lang!$C$12","v":"Split"},{"$f":"Lang!$C14","v":"5kW, 1 fase"},"HU051MR.U44",1695,null,{"$f":"Lang!$C46","v":"CV-Buffer "}]
[null,11,0,"","",null,"Split/7kW, 1 fase",{"$f":"Lang!$C$12","v":"Split"},{"$f":"Lang!$C15","v":"7kW, 1 fase"},"HU071MR.U44",1745,null,{"$f":"Lang!$C47","v":"Drukverschil regelaar"}]
[null,12,0,"","",null,"Split/9kW, 1 fase",{"$f":"Lang!$C$12","v":"Split"},{"$f":"Lang!$C16","v":"9kW, 1 fase"},"HU091MR.U44",1945,null,{"$f":"Lang!$C48","v":"Lucht afscheider"},null,null,null,null,null,{"$f":"$M12","v":"Installatiepomp"},{"$f":"$M12","v":"Installatiepomp"},"Installatiepomp","Installatiepomp","Installatiepomp","Installatiepomp","Installatiepomp","Installatiepomp"]
[null,13,0,"","",null,"Split/12kW, 1 fase",{"$f":"Lang!$C$12","v":"Split"},{"$f":"Lang!$C17","v":"12kW, 1 fase"},"HU121MA.U33",2345,null,null,null,null,null,null,null,{"$f":"$M13","v":"Magneet filter"},"Magneet filter","Magneet filter","Magneet filter","Magneet filter","Magneet filter","Magneet filter","Magneet filter"]
[null,14,0,"","",null,"Split/14kW, 1 fase",{"$f":"Lang!$C$12","v":"Split"},{"$f":"Lang!$C18","v":"14kW, 1 fase"},"HU141MA.U33",2945,null,null,null,null,null,null,null,{"$f":"$M14","v":"CV-Buffer "},"CV-Buffer ","CV-Buffer ","CV-Buffer ","CV-Buffer ","CV-Buffer ","CV-Buffer ","CV-Buffer "]
[null,15,"Installatiepomp",0,0,null,"Split/16kW, 1 fase",{"$f":"Lang!$C$12","v":"Split"},{"$f":"Lang!$C19","v":"16kW, 1 fase"},"HU161MA.U33",3545,null,null,null,null,null,null,null,{"$f":"$M15","v":"Drukverschil regelaar"},"Drukverschil regelaar","Drukverschil regelaar","Drukverschil regelaar","Drukverschil regelaar","Drukverschil regelaar","Drukverschil regelaar","Drukverschil regelaar"]
[null,16,"Magneet filter",0,0,null,"Split/12kW, 3 fase",{"$f":"Lang!$C$12","v":"Split"},{"$f":"Lang!$C20","v":"12kW, 3 fase"},"HU123MA.U33",2345,null,null,null,null,null,null,null,{"$f":"$M16","v":"Lucht afscheider"},"Lucht afscheider","Lucht afscheider","Lucht afscheider","Lucht afscheider","Lucht afscheider","Lucht afscheider","Lucht afscheider"]
[null,17,"CV-Buffer ",0,0,null,"Split/14kW, 3 fase",{"$f":"Lang!$C$12","v":"Split"},{"$f":"Lang!$C21","v":"14kW, 3 fase"},"HU143MA.U33",2945]
[null,18,"Drukverschil regelaar",0,0,null,"Split/16kW, 3 fase",{"$f":"Lang!$C$12","v":"Split"},{"$f":"Lang!$C22","v":"16kW, 3 fase"},"HU163MA.U33",3545]
[null,19,"Lucht afscheider",0,0,null,"/Hydro Box",{"$f":"IFERROR(IF(MATCH(D1,$J$14:$J$16,0)>0,\"Split\"),\"\")","v":""},"Hydro Box","HN091MR.NK5",3095]
[null,20,"","","",null,{"$f":"H24&\"/\"&I24","v":"/Hydro Box"},{"$f":"IFERROR(IF(MATCH(D1,$J$17:$J$22,0)>0,\"Split\"),\"\")","v":""},"Hydro Box","HN1636M.NK5",3245]
[null,21,"","","",null,"Split/200L, IWT",{"$f":"Lang!$C$12","v":"Split"},{"$f":"Lang!$C29","v":"200L, IWT"},"HN0913T.NK0",5445]
[null,22,"","","",null,"HydroSplit/12kW, 1 fase",{"$f":"Lang!$C$13","v":"HydroSplit"},{"$f":"Lang!$C17","v":"12kW, 1 fase"},"HU121MRB.U30",3545]
[null,23,"","","",null,"HydroSplit/14kW, 1 fase",{"$f":"Lang!$C$13","v":"HydroSplit"},{"$f":"Lang!$C18","v":"14kW, 1 fase"},"HU141MRB.U30",3745]
[null,null,null,null,null,null,"HydroSplit/16kW, 1 fase",{"$f":"Lang!$C$13","v":"HydroSplit"},{"$f":"Lang!$C19","v":"16kW, 1 fase"},"HU161MRB.U30",3945]
[null,null,null,null,null,null,"HydroSplit/12kW, 3 fase",{"$f":"Lang!$C$13","v":"HydroSplit"},{"$f":"Lang!$C20","v":"12kW, 3 fase"},"HU123MRB.U30",3545]
[null,null,null,null,null,null,"HydroSplit/14kW, 3 fase",{"$f":"Lang!$C$13","v":"HydroSplit"},{"$f":"Lang!$C21","v":"14kW, 3 fase"},"HU143MRB.U30",3745]
[null,null,null,null,null,null,"HydroSplit/16kW, 3 fase",{"$f":"Lang!$C$13","v":"HydroSplit"},{"$f":"Lang!$C22","v":"16kW, 3 fase"},"HU163MRB.U30",3945]
[null,null,null,null,null,null,"HydroSplit/Hydro Box",{"$f":"Lang!$C$13","v":"HydroSplit"},"Hydro Box","HN1600MC.MK1",2065]
[null,null,null,null,null,null,"HydroSplit/200L, IWT",{"$f":"Lang!$C$13","v":"HydroSplit"},{"$f":"Lang!$C29","v":"200L, IWT"},"HN1616Y.NB1",6595]
[null,null,null,null,null,null,"HydroSplit/6kW, 1 fase",{"$f":"Lang!$C$13","v":"HydroSplit"},{"$f":"Lang!$C33","v":"6kW, 1 fase"},"HA061C E1",665]
[null,null,null,null,null,null,"HydroSplit/6kW, 3 fase",{"$f":"Lang!$C$13","v":"HydroSplit"},{"$f":"Lang!$C34","v":"6kW, 3 fase"},"HA063C E1",725]
[null,null,null,null,null,null,{"$f":"I36","v":"200L, Enkel Spiraal"},null,{"$f":"Lang!$C27","v":"200L, Enkel Spiraal"},"OSHW-200F",1675]
[null,null,null,null,null,null,{"$f":"I37","v":"300L, Enkel Spiraal"},null,{"$f":"Lang!$C28","v":"300L, Enkel Spiraal"},"OSHW-300F",2019]

{"sheet":"Lang","index":9,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":true,"merged":[[50,0,65,0],[8,0,9,0],[29,0,33,0],[24,0,28,0],[34,0,47,0],[1,0,7,0],[10,0,12,0],[13,0,21,0],[22,0,23,0],[48,0,49,0]]}
[{"$f":"\"Lang!$\"&CHAR(64+COLUMN($D1))&\"$\"&ROW($B1)&\":$\"&CHAR(64+$B1)&\"$\"&ROW($B1)","v":"Lang!$D$1:$F$1"},{"$f":"COUNTA($D$1:$K$1)+3","v":6},{"$f":"IF('Select Product Type'!C4=\"\",D1,'Select Product Type'!C4)","v":"Dutch"},"English","French","Dutch"]
["Title","Back",{"$f":"INDEX($D:$K,ROW(C2),MATCH($C$1,$D$1:$K$1,0))","v":"Terug"},"Back","Back","Terug"]
[null,"Heating Configuration Tool","Warmtepomp configuratie Tool","Heating Configuration Tool","Heating Configuration Tool","Warmtepomp configuratie Tool"]
[null,"Select Product Type","Selecteer Product Type","Select Product Type","Select Product Type","Selecteer Product Type"]
[null,"Select Product Capacity","Selecteer Product Capaciteit","Select Product Capacity","Select Product Capacity","Selecteer Product Capaciteit"]
[null,"Select Type of Heating","Selecteer Installatie type","Select Type of Heating","Select Type of Heating","Selecteer Installatie type"]
[null,"Select Capacity of DHW","Selecteer Boiler ","Select Capacity of DHW/IWT","Select Capacity of DHW/IWT","Selecteer Boiler "]
[null,"Select Backup Heater","Selecteer Naverwarmer","Select Backup Heater","Select Backup Heater","Selecteer Naverwarmer"]
["Type of\nPipe","Water Pipe","CV-Water","Water Pipe","Water Pipe","CV-Water"]
[null,"Ref. Pipe","Koudemiddel","Ref. Pipe","Ref. Pipe","Koudemiddel"]
["Type of\nODU","MonoBlock S","MonoBlock S","MonoBlock S","MonoBlock S","MonoBlock S"]
[null,"Split","Split","Split","Split","Split"]
[null,"HydroSplit","HydroSplit","HydroSplit","HydroSplit","HydroSplit"]
["Capa.\nof\nODU","5kW, 1Ø","5kW, 1 fase","5kW, 1Ø","5kW, 1Ø","5kW, 1 fase"]
[null,"7kW, 1Ø","7kW, 1 fase","7kW, 1Ø","7kW, 1Ø","7kW, 1 fase"]
[null,"9kW, 1Ø","9kW, 1 fase","9kW, 1Ø","9kW, 1Ø","9kW, 1 fase"]
[null,"12kW, 1Ø","12kW, 1 fase","12kW, 1Ø","12kW, 1Ø","12kW, 1 fase"]
[null,"14kW, 1Ø","14kW, 1 fase","14kW, 1Ø","14kW, 1Ø","14kW, 1 fase"]
[null,"16kW, 1Ø","16kW, 1 fase","16kW, 1Ø","16kW, 1Ø","16kW, 1 fase"]
[null,"12kW, 3Ø","12kW, 3 fase","12kW, 3Ø","12kW, 3Ø","12kW, 3 fase"]
[null,"14kW, 3Ø","14kW, 3 fase","14kW, 3Ø","14kW, 3Ø","14kW, 3 fase"]
[null,"16kW, 3Ø","16kW, 3 fase","16kW, 3Ø","16kW, 3Ø","16kW, 3 fase"]
["Type of\nHeating","SPACE HEATING","Verwarming","SPACE HEATING","SPACE HEATING","Verwarming"]
[null,"SPACE HEATING AND DHW","Verwarming en Warmwater","SPACE HEATING AND DHW/IWT","SPACE HEATING AND DHW/IWT","Verwarming en Warmwater"]
["Type of \nDHW","IWT","IWT","IWT","IWT","IWT"]
[null,"DHW","DHW","DHW","DHW","DHW"]
[null,"200L, Single Coil","200L, Enkel Spiraal","200L, Single Coil","200L, Single Coil","200L, Enkel Spiraal"]
[null,"300L, Single Coil","300L, Enkel Spiraal","300L, Single Coil","300L, Single Coil","300L, Enkel Spiraal"]
[null,"200L, IWT","200L, IWT","200L, IWT","200L, IWT","200L, IWT"]
["Type of\nB.Heater","Backup Heater","Backup Heater","Backup Heater","Backup Heater","Backup Heater"]
[null,"None","Geen","None","None","Geen"]
[null,"3kW, 1Ø","3kW, 1 fase","3kW, 1Ø","3kW, 1Ø","3kW, 1 fase"]
[null,"6kW, 1Ø","6kW, 1 fase","6kW, 1Ø","6kW, 1Ø","6kW, 1 fase"]
[null,"6kW, 3Ø",{"$f":"INDEX($D:$K,ROW(C34),MATCH($C$1,$D$1:$K$1,0))","v":"6kW, 3 fase"},"6kW, 3Ø","6kW, 3Ø","6kW, 3 fase"]
["ACC","RS3 wired remote controller","RS3 Afstandbediening","RS3 wired remote controller","RS3 wired remote controller","RS3 Afstandbediening"]
[null,"Extension Wire for RS3  Controller","Verlengkabel RS3 afstandbediening","Extension Wire for RS3  Controller","Extension Wire for RS3  Controller","Verlengkabel RS3 afstandbediening"]
[null,"Cover Plate","Afdekplaat","Cover Plate","Cover Plate","Afdekplaat"]
[null,"3 Way Valve (A)","3-weg klep","3 Way Valve (A)","3 Way Valve (A)","3-weg klep"]
[null,"DHW Tank Sensor","Boiler sensor","DHW Tank Sensor","DHW Tank Sensor","Boiler sensor"]
[null,"2nd Circuit Thermistor","Temperatuursensor 2e CV-circuit ","2nd Circuit Thermistor","2nd Circuit Thermistor","Temperatuursensor 2e CV-circuit "]
[null,"DHW Tank Kit(A)","Boiler kit (A)","DHW Tank Kit(A)","DHW Tank Kit(A)","Boiler kit (A)"]
[null,"DHW Tank Kit(B)","Boiler kit (B)","DHW Tank Kit(B)","DHW Tank Kit(B)","Boiler kit (B)"]
[null,"DHW Tank Kit(C)","Boiler kit (C)","DHW Tank Kit(C)","DHW Tank Kit(C)","Boiler kit (C)"]
[null,"External Pump","Installatiepomp","External Pump","External Pump","Installatiepomp"]
[null,"Magnetic Filter","Magneet filter","Magnetic Filter","Magnetic Filter","Magneet filter"]
[null,"Buffer Tank","CV-Buffer ","Buffer Tank","Buffer Tank","CV-Buffer "]
[null,"Differential Pressure Valve","Drukverschil regelaar","Differential Pressure Valve","Differential Pressure Valve","Drukverschil regelaar"]
[null,"Air Separator","Lucht afscheider","Air Separator","Air Separator","Lucht afscheider"]
["Phase\nRes.F1","1Ø","1 fase","1Ø","1Ø","1 fase"]
[null,"3Ø","3 fase","3Ø","3Ø","3 fase"]
["Report","LG Electronic AWHP System summary","LG Electronic Therma V  systeem","LG Electronic AWHP System summary","LG Electronic AWHP System summary","LG Electronic Therma V  systeem"]
[null,"Application","Applicatie","Application","Application","Applicatie"]
[null,"Product","Product","Product","Product","Product"]
[null,"Main Controller","Regeling","Main Controller","Main Controller","Regeling"]
[null,"Product Capacity","Capaciteit en fase","Product Capacity","Product Capacity","Capaciteit en fase"]
[null,"Capacity of DHW","Boiler type","Capacity of DHW","Capacity of DHW","Boiler type"]
[null,"Backup Heater Capacity","Naverwarmer en fase","Backup Heater Capacity","Backup Heater Capacity","Naverwarmer en fase"]
[null,"No","No","No","No","No"]
[null,"Description","Omschrijving","Description","Description","Omschrijving"]
[null,"Energy Label","Energie label","Energy Label","Energy Label","Energie label"]
[null,"Item","Artikel nummer","Item","Item","Artikel nummer"]
[null,"Number of","Aantal","Number of","Number of","Aantal"]
[null,"Per Unit","Prijs per stuk","Per Unit","Per Unit","Prijs per stuk"]
[null,"Total","Total","Total","Total","Total"]
[null,"Accessory",{"$f":"INDEX($D:$K,ROW(C65),MATCH($C$1,$D$1:$K$1,0))","v":"Accessoires"},"Accessory","Accessory","Accessoires"]
[null,"SubTotal","SubTotal","SubTotal","SubTotal","SubTotal"]