{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Warmteverliesberekening","Selectie afgifte-elementen","Kringen en luchtgroepen","info"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":27,"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":"Warmteverliesberekening","index":0,"n_rows":83,"n_cols":9,"rows_kept":83,"cut":false,"hidden":false,"merged":[[3,0,3,4],[3,5,3,7],[9,7,10,7],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,6,10,6],[9,5,10,5],[4,5,4,6],[5,5,5,6],[6,5,6,6],[7,5,7,6]]}
[]
[null,"Berekening uitgevoerd door:","Firmanaam:","X","Naam:","X","Handtekening:"]
[]
["Resultaten warmteverliesberekening volgens NBN EN 12831",null,null,null,null,"Controle  afgiftevermogens en retourtemperatuur"]
[null,"Gemeente:","Beringen","θe (°C):",-9,"Totaal warmteverlies (kW)",null,"Vertrektemperatuur (°C)"]
[null,"type gebouw: ","residentieel","gebouwmassa:","gemiddeld",{"$f":"SUM(E12:E10002)/1000","v":11.152557814600002},null,{"$f":"IF(MAX(vertrek)=0,\"\",MAX(vertrek))","v":55}]
[null,"opwarmtijd (h): ","2u","nachtverlaging (°C):",2,"Totaal afgiftevermogen (kW)",null,"Retourtemperatuur (°C)"]
[null,"warmterecuperatie (% EN308): ",0.85,"lekdebiet (n50):",1.5,{"$f":"SUM(H12:H10002)/1000","v":11.299887259734222},null,{"$f":"IFERROR(IF(SUMPRODUCT(retour,debiet)/SUM(debiet)=0,\"\",SUMPRODUCT(retour,debiet)/SUM(debiet)),\"\")","v":45}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(I12:I83,F8>F6,'Kringen en luchtgroepen'!X5:X12,'Selectie afgifte-elementen'!BG10:BG81),OK,NOK)","v":" "}]
["Lokaal\nnr","Naam lokaal","Oppervlakte","Ruimte-temperatuur","Berekend \nwarmteverlies lokaal","vermogen\nper m²","Uitzondering\nvan toepassing","Totaal voorzien\nafgiftevermogen"]
[]
[1,"Living+keuken",56.399999999999991,20,4174.622856,{"$f":"IFERROR(E12/C12,0)","v":74.018135744680862},null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A12,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B12)","v":5019.497178040021},{"$f":"IF(E12=\"\",\"\",OR(H12>E12,G12<>\"\"))","v":true}]
[2,"Sas achterdeur",3.2499999999999982,16,141.95760249999995,{"$f":"IFERROR(E13/C13,0)","v":43.679262307692319},"lokaal niet voor menselijke bezetting",{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A13,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B13)","v":0},{"$f":"IF(E13=\"\",\"\",OR(H13>E13,G13<>\"\"))","v":true}]
[3,"Wasplaats",9.7499999999999893,20,544.07822499999952,55.802894871794884,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A14,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B14)","v":654.04040404040404},true]
[4,"Berging",4.5149999999999961,16,218.02274999999997,48.288538205980103,"lokaal niet voor menselijke bezetting",{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A15,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B15)","v":0},true]
[5,"WC",2,16,51.104875,25.5524375,"lokaal niet voor menselijke bezetting",{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A16,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B16)","v":0},true]
[6,"Inkomhal + trap",9.7499999999999947,16,496.45031249999977,50.917980769230773,"lokaal niet voor menselijke bezetting",{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A17,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B17)","v":0},true]
[7,"Gang (1V) + trap",23.04999999999999,16,698.2507499999997,30.292874186550975,"lokaal niet voor menselijke bezetting",{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A18,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B18)","v":0},true]
[8,"Badkamer",13.324999999999992,24,792.48630849999972,59.473644165103202,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A19,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B19)","v":848.4848484848485},true]
[9,"Slaapkamer achter",15.989999999999998,18,508.50798280000004,31.801624940587871,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A20,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B20)","v":580.88539511791487},true]
[10,"Bureau",8.1999999999999993,20,453.74679800000001,55.334975365853666,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A21,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B21)","v":489.75409836065575},true]
[11,"Slaapkamer voor (zuid)",12.094999999999999,18,501.6236184,41.473635254237294,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A22,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B22)","v":580.88539511791487},true]
[12,"Slaapkamer voor (noord)",12.094999999999999,18,470.56986839999996,38.906148689541133,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A23,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B23)","v":580.88539511791487},true]
[13,"Zolder + trap",55,16,2007.5558550000001,36.50101554545455,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A24,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B24)","v":2545.4545454545455},true]
[14,"Technische ruimte",13.324999999999992,10,93.580012499999839,7.022890243902431,"vermogen < 10W/m²",{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A25,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B25)","v":0},true]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A26,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B26)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A27,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B27)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A28,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B28)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A29,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B29)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A30,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B30)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A31,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B31)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A32,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B32)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A33,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B33)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A34,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B34)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A35,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B35)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A36,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B36)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A37,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B37)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A38,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B38)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A39,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B39)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A40,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B40)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A41,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B41)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A42,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B42)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A43,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B43)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A44,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B44)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A45,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B45)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A46,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B46)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A47,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B47)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A48,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B48)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A49,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B49)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A50,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B50)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A51,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B51)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A52,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B52)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A53,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B53)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A54,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B54)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A55,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B55)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A56,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B56)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A57,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B57)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A58,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B58)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A59,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B59)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A60,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B60)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A61,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B61)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A62,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B62)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A63,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B63)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A64,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B64)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A65,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B65)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A66,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B66)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A67,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B67)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A68,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B68)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A69,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B69)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A70,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B70)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A71,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B71)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A72,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B72)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A73,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B73)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A74,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B74)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A75,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B75)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A76,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B76)","v":0},""]
[null,null,null,null,null,{"$f":"IFERROR(E77/C77,0)","v":0},null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A77,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B77)","v":0},{"$f":"IF(E77=\"\",\"\",OR(H77>E77,G77<>\"\"))","v":""}]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A78,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B78)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A79,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B79)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A80,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B80)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A81,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B81)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A82,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B82)","v":0},""]
[null,null,null,null,null,0,null,{"$f":"SUMIFS('Selectie afgifte-elementen'!H:H,'Selectie afgifte-elementen'!A:A,Warmteverliesberekening!A83,'Selectie afgifte-elementen'!B:B,Warmteverliesberekening!B83)","v":0},""]

{"sheet":"Selectie afgifte-elementen","index":1,"n_rows":81,"n_cols":59,"rows_kept":81,"cut":false,"hidden":false,"merged":[[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,6,8,6],[7,16,8,16],[7,8,8,8],[7,9,8,9],[7,4,8,4],[7,5,8,5],[7,7,8,7],[7,14,8,14],[7,10,8,10],[7,3,8,3],[7,11,8,11],[7,13,8,13],[7,15,8,15],[0,2,6,7],[7,28,8,28],[7,29,8,29],[7,31,7,32],[7,43,8,43],[7,34,7,36],[0,8,6,15],[0,16,6,28],[0,29,6,44],[7,18,7,19],[7,25,8,25],[7,21,7,24],[7,12,8,12],[7,53,8,53],[0,45,6,51],[7,51,8,51],[7,46,8,46],[7,17,8,17],[0,52,6,57],[7,52,8,52],[7,55,8,55],[7,56,8,56],[7,57,8,57],[7,54,8,54],[7,50,8,50],[7,26,8,26],[7,27,8,27],[7,47,8,47],[7,48,8,48],[7,49,8,49],[7,45,8,45],[7,33,8,33],[7,40,8,40],[7,44,8,44],[7,41,7,42]]}
[null,null,"Selectie afgifteelement en verwarmingskring",null,null,null,null,null,"Radiator- en convectorselectie conform NBN EN 442",null,null,null,null,null,null,null,"Selectie vloerverwarming conform NBN EN 1264-2 of WTCB TV181",null,null,null,null,null,null,null,null,null,null,null,null,"Selectie verwarmingsbatterij in luchtgroep",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Selectie betonkernactivering conform NBN EN 15377-1",null,null,null,null,null,null,"Directe ingave"]
[]
[]
[]
[]
[]
[]
["Lokaal nr","Naam lokaal","afgifteelement","Kring","Vertrek-temperatuur","Retour-temperatuur","Debiet","Totaal\nafgiftevermogen","merk en\ntype","aantal","afmetingen","vermogen\n75/65/20","Correctie-factor","vermogen bij\nontwerpregime","Debiet","Totaal\nvermogen ","Opp deel\nvloerverwarming","Vloerafwerking","Isolatie onder buizen",null,"Warmteweerstand ","buizen",null,null,null,"Werkelijk\nafgiftevermogen","Warmteafgifte naar beneden","Debiet","Totaal \nvermogen","Lokaal of\nmet luchtgroep","naam groep","luchtdebiet in lokaal",null,"Percentage verse lucht","Temperatuur lucht",null,null,null,null,null,"Rendement WTW","Vermogen",null,"Debiet","Geleverd \nvermogen","Opp deel\nbetonkernactivering","Pasafstand","aantal\nkringen","Lengte buizen\nper kring","Werkelijk\nafgiftevermogen","Debiet","Totaal \nvermogen","Merk & type","Aantal","Technische fiche","Werkelijk\nafgiftevermogen","Debiet","Totaal \nvermogen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dikte","lambda","boven buis ks","type","diameter","Pasafstand","Lengte",null,null,null,null,null,null,"Toevoer","Afvoer",null,"Ruimte","na WTW","Toevoer","Toevoer werkelijk","Toevoer van luchtgroep","Toevoertemperatuur berekend",null,"VVW","NVW"]
[1,"Living+keuken","radiator","K1",{"$f":"IFERROR(VLOOKUP(D10,kringtemperatuur,2,0),0)","v":55},{"$f":"IFERROR(VLOOKUP(D10,kringtemperatuur,3,0),0)","v":45},{"$f":"IFERROR(IF(OR(C10=afgifte1,C10=afgifte2),O10)+IF(C10=afgifte3,AB10)+IF(C10=afgifte5,AR10)+IF(C10=afgifte6,AY10)+IF(C10=afgifte7,BE10),\"\")","v":0.43168155377315037},{"$f":"IF(OR(C10=afgifte1,C10=afgifte2),P10)+IF(C10=afgifte3,AC10)+IF(OR(C10=afgifte4,C10=afgifte5),AS10)+IF(C10=afgifte6,AZ10)+IF(C10=afgifte7,BF10)","v":5019.497178040021},"producent type",3,"900x900",3261,1.9490000000000001,{"$f":"IFERROR(L10/M10,0)","v":1673.1657260133402},{"$f":"IFERROR(P10*3600/($E10-$F10)/4186/1000,\"\")","v":0.43168155377315037},{"$f":"N10*J10","v":5019.497178040021},56,"polierde beton",10,2.8999999999999998E-3,6.14,"PP",18,9,617.33333333333326,110.7009574468085,9.4500000000000028,{"$f":"IFERROR(SUM(Z10:AA10)*Q10*3600/(E10-F10)/4186/1000,\"\")","v":0.57865344054650247},{"$f":"Z10*Q10","v":6199.2536170212761},null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A10,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B10)","v":20},null,null,{"$f":"IF(AD10=lucht2,AM10,AK10)","v":0},{"$f":"IFERROR(IF(AD10=lucht1,0,VLOOKUP(AE10,luchtgroep,11,0)),0)","v":0},{"$f":"IFERROR(IF(AD10=lucht2,0,IF(AD10=lucht1,buitentemperatuur*AH10+AI10*(1-AH10)+AH10*MIN(AF10:AG10)*AO10*(AI10-buitentemperatuur)/AF10+SUM(AP10:AQ10)*1000/AF10/0.34,IF(AD10=lucht3,MIN(AL10,AM10+SUM(AP10:AQ10)*1000/AF10/0.34),\"\"))),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(AD10=lucht1,0.34*AF10*(AL10-AJ10)*3600/($E10-$F10)/4186/1000,IF(AD10=lucht3,0.34*AF10*(AL10-AM10)*3600/($E10-$F10)/4186/1000,0)),0)","v":0},{"$f":"IFERROR(0.34*AF10*(AL10-AI10),0)","v":0},null,null,null,null,null,{"$f":"IFERROR(AZ10*3600/($E10-$F10)/4186/1000,\"\")","v":0},{"$f":"AX10*AT10","v":0},null,null,null,null,{"$f":"IFERROR(BF10*3600/($E10-$F10)/4186/1000,\"\")","v":0},{"$f":"BB10*BD10","v":0},{"$f":"IF(AD10=\"\",\"\",AND(OR(AD10=lucht1,AD10=lucht3),AN10=AL10))","v":""}]
[2,"Sas achterdeur","radiator","K1",55,45,0,0,"producent type",null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(Z11:AA11)*Q11*3600/(E11-F11)/4186/1000,\"\")","v":0},0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A11,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B11)","v":16},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,{"$f":"IFERROR(AZ11*3600/($E11-$F11)/4186/1000,\"\")","v":0},0,null,null,null,null,{"$f":"IFERROR(BF11*3600/($E11-$F11)/4186/1000,\"\")","v":0},{"$f":"BB11*BD11","v":0},""]
[3,"Wasplaats","radiator","K1",55,45,5.6248099726360599E-2,654.04040404040404,"producent type",1,"450x600",1295,1.98,654.04040404040404,5.6248099726360599E-2,654.04040404040404,9.7499999999999893,"tegel",10,2.8999999999999998E-3,4.6500000000000004,"PP",18,10,97.499999999999901,81.015000000000001,9.4499999999999993,{"$f":"IFERROR(SUM(Z12:AA12)*Q12*3600/(E12-F12)/4186/1000,\"\")","v":7.5855745341614836E-2},789.8962499999991,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A12,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B12)","v":20},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0,{"$f":"BB12*BD12","v":0},""]
[4,"Berging","radiator","K1",55,45,0,0,"producent type",null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A13,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B13)","v":16},null,null,0,0,"",null,null,3,0,0,null,null,null,null,null,0,0,null,null,null,null,0,0,""]
[5,"WC","radiator","K1",55,45,0,0,"producent type",null,null,null,null,{"$f":"IFERROR(L14/M14,0)","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A14,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B14)","v":16},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0,0,""]
[6,"Inkomhal + trap","radiator","K1",55,45,0,0,"producent type",null,null,null,null,{"$f":"IFERROR(L15/M15,0)","v":0},0,0,10,"polibeton",10,2.9000000000000001E-2,6.14,"PP",18,10,100,135.095,9.4499999999999993,0.12431008122312467,1350.95,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A15,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B15)","v":16},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0,0,""]
[7,"Gang (1V) + trap","radiator","K1",55,45,0,0,"producent type",null,null,null,null,{"$f":"IFERROR(L16/M16,0)","v":0},0,0,23.04999999999999,"laminaat",5,2.9000000000000001E-2,3.38,"PP",18,15,153.6666666666666,73.8,10.66,0.16742691829909212,1701.0899999999992,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A16,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B16)","v":16},null,null,{"$f":"IF(AD16=lucht2,AM16,AK16)","v":0},0,{"$f":"IFERROR(IF(AD16=lucht2,0,IF(AD16=lucht1,buitentemperatuur*AH16+AI16*(1-AH16)+AH16*MIN(AF16:AG16)*AO16*(AI16-buitentemperatuur)/AF16+SUM(AP16:AQ16)*1000/AF16/0.34,IF(AD16=lucht3,MIN(AL16,AM16+SUM(AP16:AQ16)*1000/AF16/0.34),\"\"))),\"\")","v":""},null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0,0,""]
[8,"Badkamer","radiator","K1",55,45,7.2970507753116448E-2,848.4848484848485,"producent type",1,"450x900",1680,1.98,{"$f":"IFERROR(L17/M17,0)","v":848.4848484848485},7.2970507753116448E-2,848.4848484848485,13.324999999999992,"tegel",5,2.9000000000000001E-2,4.6500000000000004,"PP",18,10,133.24999999999991,61.375,11.275,8.3254192546583811E-2,817.82187499999952,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A17,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B17)","v":24},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0,0,""]
[9,"Slaapkamer achter","radiator","K1",55,45,4.9956699054574623E-2,580.88539511791487,"producent type",1,"450x750",1404,2.4169999999999998,580.88539511791487,4.9956699054574623E-2,580.88539511791487,15.989999999999998,"laminaat",5,2.9000000000000001E-2,3.38,"PP",18,15,106.59999999999998,66.600000000000009,10.66,0.10624449689440994,1064.934,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A18,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B18)","v":18},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0,0,""]
[10,"Bureau","radiator","K1",55,45,4.2119320451465853E-2,489.75409836065575,"producent type",1,"450x600",1195,2.44,489.75409836065575,4.2119320451465853E-2,489.75409836065575,8.1999999999999993,"laminaat",5,2.9000000000000001E-2,3.86,"PP",18,10,82,59.4,11.275,4.9840563784042044E-2,487.07999999999993,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A19,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B19)","v":20},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0,0,""]
[11,"Slaapkamer voor (zuid)","radiator","K1",55,45,4.9956699054574623E-2,580.88539511791487,"producent type",1,"450x750",1404,2.4169999999999998,580.88539511791487,4.9956699054574623E-2,580.88539511791487,12.094999999999999,"laminaat",5,2.9000000000000001E-2,3.38,"PP",18,15,80.633333333333326,66.600000000000009,10.66,8.0364427138079314E-2,805.52700000000004,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A20,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B20)","v":18},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0,0,""]
[12,"Slaapkamer voor (noord)","radiator","K1",55,45,4.9956699054574623E-2,580.88539511791487,"producent type",1,"450x750",1404,2.4169999999999998,580.88539511791487,4.9956699054574623E-2,580.88539511791487,12.094999999999999,"laminaat",5,2.9000000000000001E-2,3.38,"PP",18,15,80.633333333333326,66.600000000000009,10.66,8.0364427138079314E-2,805.52700000000004,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A21,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B21)","v":18},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0,0,""]
[13,"Zolder + trap","radiator","K1",55,45,0.21891152325934934,2545.4545454545455,"producent type",3,"450x900",1680,1.98,848.4848484848485,0.21891152325934934,2545.4545454545455,55,"beton",5,2.9000000000000001E-2,5.16,"PP",18,15,366.66666666666663,115.825,10.66,0.59828069756330626,6370.375,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A22,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B22)","v":16},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0,0,""]
[14,"Technische ruimte","radiator","K1",55,45,0,0,"producent type",null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A23,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B23)","v":10},null,null,0,0,"",",",null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0,0,""]
[null,null,"luchtverwarming","K1",55,45,0,0,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A24,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B24)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0,0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A25,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B25)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A26,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B26)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A27,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B27)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A28,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B28)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A29,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B29)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A30,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B30)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A31,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B31)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A32,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B32)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A33,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B33)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A34,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B34)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A35,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B35)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A36,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B36)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A37,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B37)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A38,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B38)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A39,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B39)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A40,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B40)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A41,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B41)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(D42,kringtemperatuur,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(D42,kringtemperatuur,3,0),0)","v":0},{"$f":"IFERROR(IF(OR(C42=afgifte1,C42=afgifte2),O42)+IF(C42=afgifte3,AB42)+IF(C42=afgifte5,AR42)+IF(C42=afgifte6,AY42)+IF(C42=afgifte7,BE42),\"\")","v":0},{"$f":"IF(OR(C42=afgifte1,C42=afgifte2),P42)+IF(C42=afgifte3,AC42)+IF(OR(C42=afgifte4,C42=afgifte5),AS42)+IF(C42=afgifte6,AZ42)+IF(C42=afgifte7,BF42)","v":0},null,null,null,null,null,0,"",{"$f":"N42*J42","v":0},null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"Z42*Q42","v":0},null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A42,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B42)","v":0},null,null,0,{"$f":"IFERROR(IF(AD42=lucht1,0,VLOOKUP(AE42,luchtgroep,11,0)),0)","v":0},{"$f":"IFERROR(IF(AD42=lucht2,0,IF(AD42=lucht1,buitentemperatuur*AH42+AI42*(1-AH42)+AH42*MIN(AF42:AG42)*AO42*(AI42-buitentemperatuur)/AF42+SUM(AP42:AQ42)*1000/AF42/0.34,IF(AD42=lucht3,MIN(AL42,AM42+SUM(AP42:AQ42)*1000/AF42/0.34),\"\"))),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(AD42=lucht1,0.34*AF42*(AL42-AJ42)*3600/($E42-$F42)/4186/1000,IF(AD42=lucht3,0.34*AF42*(AL42-AM42)*3600/($E42-$F42)/4186/1000,0)),0)","v":0},{"$f":"IFERROR(0.34*AF42*(AL42-AI42),0)","v":0},null,null,null,null,null,"",{"$f":"AX42*AT42","v":0},null,null,null,null,"",0,{"$f":"IF(AD42=\"\",\"\",AND(OR(AD42=lucht1,AD42=lucht3),AN42=AL42))","v":""}]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A43,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B43)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A44,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B44)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A45,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B45)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A46,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B46)","v":0},null,null,{"$f":"IF(AD46=lucht2,AM46,AK46)","v":0},0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A47,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B47)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A48,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B48)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A49,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B49)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A50,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B50)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A51,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B51)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A52,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B52)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A53,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B53)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A54,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B54)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A55,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B55)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A56,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B56)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A57,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B57)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A58,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B58)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A59,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B59)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A60,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B60)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A61,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B61)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A62,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B62)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A63,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B63)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A64,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B64)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A65,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B65)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A66,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B66)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A67,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B67)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A68,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B68)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A69,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B69)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A70,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B70)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A71,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B71)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A72,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B72)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A73,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B73)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(D74,kringtemperatuur,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(D74,kringtemperatuur,3,0),0)","v":0},{"$f":"IFERROR(IF(OR(C74=afgifte1,C74=afgifte2),O74)+IF(C74=afgifte3,AB74)+IF(C74=afgifte5,AR74)+IF(C74=afgifte6,AY74)+IF(C74=afgifte7,BE74),\"\")","v":0},{"$f":"IF(OR(C74=afgifte1,C74=afgifte2),P74)+IF(C74=afgifte3,AC74)+IF(OR(C74=afgifte4,C74=afgifte5),AS74)+IF(C74=afgifte6,AZ74)+IF(C74=afgifte7,BF74)","v":0},null,null,null,null,null,0,"",{"$f":"N74*J74","v":0},null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"Z74*Q74","v":0},null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A74,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B74)","v":0},null,null,0,{"$f":"IFERROR(IF(AD74=lucht1,0,VLOOKUP(AE74,luchtgroep,11,0)),0)","v":0},{"$f":"IFERROR(IF(AD74=lucht2,0,IF(AD74=lucht1,buitentemperatuur*AH74+AI74*(1-AH74)+AH74*MIN(AF74:AG74)*AO74*(AI74-buitentemperatuur)/AF74+SUM(AP74:AQ74)*1000/AF74/0.34,IF(AD74=lucht3,MIN(AL74,AM74+SUM(AP74:AQ74)*1000/AF74/0.34),\"\"))),\"\")","v":""},null,null,null,{"$f":"IFERROR(IF(AD74=lucht1,0.34*AF74*(AL74-AJ74)*3600/($E74-$F74)/4186/1000,IF(AD74=lucht3,0.34*AF74*(AL74-AM74)*3600/($E74-$F74)/4186/1000,0)),0)","v":0},{"$f":"IFERROR(0.34*AF74*(AL74-AI74),0)","v":0},null,null,null,null,null,"",{"$f":"AX74*AT74","v":0},null,null,null,null,"",0,{"$f":"IF(AD74=\"\",\"\",AND(OR(AD74=lucht1,AD74=lucht3),AN74=AL74))","v":""}]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,{"$f":"IFERROR(P75*3600/($E75-$F75)/4186/1000,\"\")","v":""},0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A75,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B75)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,{"$f":"IFERROR(AZ75*3600/($E75-$F75)/4186/1000,\"\")","v":""},0,null,null,null,null,{"$f":"IFERROR(BF75*3600/($E75-$F75)/4186/1000,\"\")","v":""},0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(Z76:AA76)*Q76*3600/(E76-F76)/4186/1000,\"\")","v":""},0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A76,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B76)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",{"$f":"BB76*BD76","v":0},""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A77,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B77)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A78,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B78)","v":0},null,null,{"$f":"IF(AD78=lucht2,AM78,AK78)","v":0},0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,{"$f":"IFERROR(L79/M79,0)","v":0},"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A79,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B79)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A80,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B80)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]
[null,null,null,null,0,0,0,0,null,null,null,null,null,0,"",0,null,null,null,null,null,null,null,null,null,null,null,"",0,null,null,null,null,null,{"$f":"SUMIFS(Warmteverliesberekening!D:D,Warmteverliesberekening!A:A,'Selectie afgifte-elementen'!A81,Warmteverliesberekening!B:B,'Selectie afgifte-elementen'!B81)","v":0},null,null,0,0,"",null,null,null,0,0,null,null,null,null,null,"",0,null,null,null,null,"",0,""]

{"sheet":"Kringen en luchtgroepen","index":2,"n_rows":16,"n_cols":24,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,22,2,22],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,7,2,7],[1,8,2,8],[1,12,1,13],[1,15,1,18],[1,19,2,19],[1,20,1,21],[1,14,2,14]]}
["Tabel 1: kringen verwarming",null,null,null,null,null,null,"Tabel 2: Ventilatiegroepen"]
["kring","vertrek\ntemperatuur","retour\ntemperatuur","Debiet",null,null,null,"Naam","merk en type","kring","vertrek\ntemperatuur","retour\ntemperatuur","luchtdebiet",null,"Percentage verse lucht","Temperatuur lucht",null,null,null,"Rendement\nWTW","Vermogen",null,"Debiet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Toevoer","Afvoer",null,"Afvoerlucht","na WTW","Toevoerlucht","maximale temperatuur",null,"VVW","VW"]
[]
["K1",55,45,{"$f":"SUMIF($J$4:$J$12,$A5,$W$4:$W$12)+SUMIF('Selectie afgifte-elementen'!$D$10:$D$81,$A5,'Selectie afgifte-elementen'!$G$10:$G$81)","v":0.97180110212716664},null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(J5,kringtemperatuur,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(J5,kringtemperatuur,3,0),0)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(MIN((buitentemperatuur*O5+P5*(1-O5))+MIN(M5:N5)*T5*(P5-buitentemperatuur)*O5/M5+SUM(U5:V5)*1000/M5/0.34,R5),\"\")","v":""},null,null,null,{"$f":"IFERROR(0.34*M5*(R5-Q5)*3600/($K5-$L5)/4186/1000,0)","v":0},{"$f":"IF(S5<>\"\",S5=R5,\"\")","v":""}]
[null,null,null,{"$f":"SUMIF($J$4:$J$12,$A6,$W$4:$W$12)+SUMIF('Selectie afgifte-elementen'!$D$10:$D$81,$A6,'Selectie afgifte-elementen'!$G$10:$G$81)","v":0},null,null,null,null,null,null,0,0,null,null,null,null,null,null,"",null,null,null,{"$f":"IFERROR(0.34*M6*(R6-Q6)*3600/($K6-$L6)/4186/1000,0)","v":0},{"$f":"IF(S6<>\"\",S6=R6,\"\")","v":""}]
[null,null,null,{"$f":"SUMIF($J$4:$J$12,$A7,$W$4:$W$12)+SUMIF('Selectie afgifte-elementen'!$D$10:$D$81,$A7,'Selectie afgifte-elementen'!$G$10:$G$81)","v":0},null,null,null,null,null,null,0,0,null,null,null,null,null,null,"",null,null,null,{"$f":"IFERROR(0.34*M7*(R7-Q7)*3600/($K7-$L7)/4186/1000,0)","v":0},""]
[null,null,null,{"$f":"SUMIF($J$4:$J$12,$A8,$W$4:$W$12)+SUMIF('Selectie afgifte-elementen'!$D$10:$D$81,$A8,'Selectie afgifte-elementen'!$G$10:$G$81)","v":0},null,null,null,null,null,null,0,0,null,null,null,null,null,null,"",null,null,null,0,""]
[null,null,null,{"$f":"SUMIF($J$4:$J$12,$A9,$W$4:$W$12)+SUMIF('Selectie afgifte-elementen'!$D$10:$D$81,$A9,'Selectie afgifte-elementen'!$G$10:$G$81)","v":0},null,null,null,null,null,null,0,0,null,null,null,null,null,null,"",null,null,null,0,""]
[null,null,null,{"$f":"SUMIF($J$4:$J$12,$A10,$W$4:$W$12)+SUMIF('Selectie afgifte-elementen'!$D$10:$D$81,$A10,'Selectie afgifte-elementen'!$G$10:$G$81)","v":0},null,null,null,null,null,null,0,0,null,null,null,null,null,null,"",null,null,null,0,""]
[null,null,null,{"$f":"SUMIF($J$4:$J$12,$A11,$W$4:$W$12)+SUMIF('Selectie afgifte-elementen'!$D$10:$D$81,$A11,'Selectie afgifte-elementen'!$G$10:$G$81)","v":0},null,null,null,null,null,null,0,0,null,null,null,null,null,null,"",null,null,null,0,""]
[null,null,null,{"$f":"SUMIF($J$4:$J$12,$A12,$W$4:$W$12)+SUMIF('Selectie afgifte-elementen'!$D$10:$D$81,$A12,'Selectie afgifte-elementen'!$G$10:$G$81)","v":0},null,null,null,null,null,null,0,0,null,null,null,null,null,null,"",null,null,null,0,""]
[null,null,null,{"$f":"SUMIF($J$4:$J$12,$A13,$W$4:$W$12)+SUMIF('Selectie afgifte-elementen'!$D$10:$D$81,$A13,'Selectie afgifte-elementen'!$G$10:$G$81)","v":0}]
[null,null,null,{"$f":"SUMIF($J$4:$J$12,$A14,$W$4:$W$12)+SUMIF('Selectie afgifte-elementen'!$D$10:$D$81,$A14,'Selectie afgifte-elementen'!$G$10:$G$81)","v":0}]
[null,null,null,{"$f":"SUMIF($J$4:$J$12,$A15,$W$4:$W$12)+SUMIF('Selectie afgifte-elementen'!$D$10:$D$81,$A15,'Selectie afgifte-elementen'!$G$10:$G$81)","v":0}]
["kring andere dan CV"]

{"sheet":"info","index":3,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"type afgifteelement",null,null,"Uitzonderingen:",null,"Lokaal"]
[null,null,null,"radiator",null,null,"lokaal niet voor menselijke bezetting",null,"Luchtgroep"]
[null,null,null,"convector",null,null,"vermogen < 10W/m²",null,"Luchtgroep met lokale naverwarming"]
[null,null,null,"vloerverwarming",null,null,"plaatselijke verwarming andere dan CV"]
[null,null,null,null,null,null,"ja"]
[null,null,null,"luchtverwarming"]
[null,null,null,"betonkernactivering"]
[null,null,null,"directe ingave",null,null,null,null," "]
[null,null,null,null,null,null,null,null,"Berekening retourtemperatuur niet OK"]