{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Version","Compacité et K","Calculs","Liste des communes"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Version","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Modifications avril 2023 - ICEDD"]
[null,"Mise à jour de valeurs, logo, coûts, etc \n- Ajout d'exemple pour les niveaux d'isolation K \n\nAméliorations diverses \n- Ergonomie de l'outil \n- Masquage des feuilles inutiles pour l'utilisateur \n- Ajout d'une explication sur l'outil \n- Ajout d'un lien vers le site Energieplus pour plus d'explications sur le niveau d'isolation global K."]

{"sheet":"Compacité et K","index":1,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[3,1,5,8],[6,1,7,8],[30,2,31,6],[30,7,31,7],[8,1,9,1]]}
[]
[]
[null,"Contrôle de la puissance d'une chaudière"]
[null,"Ce programme vous permet d'estimer la puissance nécessaire d'une chaudière connaissant le volume chauffé et la surface déperditive (= surface des parois entourant le volume chauffé (façades, toit, sol)) et en estimant le degré d'isolation du bâtiment."]
[]
[]
[null,"Attention, ce programme n'est là qu'en simple indicateur, il ne peut en aucun cas être utilisé pour dimensionner la chaudière. Le dimensionnement réel de l'installaton doit se baser sur le calcul des déperditions du bâtiment selon la norme NBN EN 12831-1:2017. Il existe un outil d'estimation plus précis que celui-ci mais simplifié par rapport à la norme sur notre site internet : "]
[]
[null,"Cliquez ici"]
[]
[null,"- encodez les données relatives à votre situation dans les cases bleues."]
[null,"- les résultats sont repris dans les cases jaunes."]
[]
[null,"Volume chauffé :",null,6750,"m³"]
[]
[null,"Surface déperditive :",null,2600,"m²"]
[]
[null,"Niveau d'isolation global K :",null,null,null,null,null,null,79]
[]
[null,null,null,null,"Très bien isolée",null,"Sans aucune isolation"]
[null,null,"Exemples :"]
[null,null,"Type de bâtiment",null,null,null,null,null,"K"]
[null,null,"Bâtiment isolé respectant la réglementation thermique construit après 1996 :",null,null,null,null,null,55]
[null,null,"Bâtiment isolé respectant la réglementation thermique construit entre 1984 et 1996 :",null,null,null,null,null,70]
[null,null,"Bâtiment ancien sans aucune isolation",null,null,null,null,null,"150 .. 170"]
[null,null,"Bâtiment ancien avec toiture isolée",null,null,null,null,null,"110 .. 130"]
[null,null,"Bâtiment ancien avec toiture isolée et doubles vitrages",null,null,null,null,null,"90 .. 100"]
[null,null,"Maison passive",null,null,null,null,null,"10 .. 20"]
[null,null,"Exigence PEB pour bâtiment ultérieur au 01/01/2015",null,null,null,null,null,"K < 35"]
[]
[null,null,"N'hésitez pas à aller consulter notre page internet pour plus d'informations à ce sujet, il y a également un outil dédié au calcul de ce coefficient ",null,null,null,null,"Cliquez ici"]
[]
[]
[null,"Commune  :"]
[]
[]
[null,"Température extérieure de base :",null,null,{"$f":"-INDEX('Liste des communes'!B3:B575,'Liste des communes'!E2,1)","v":-8},"°C"]
[]
[null,"Température intérieure de consigne :",null,null,20,"°C"]
[]
[null,"Puissance spécifique à installer :",null,null,{"$f":"ROUND(Calculs!G9/(19-(-8))*(E39-E37),1)","v":22.7},"W/m³"]
[]
[null,"Puissance utile totale à installer :",null,null,{"$f":"ROUND(E41*D14/1000,0)","v":153},"kW"]

{"sheet":"Calculs","index":2,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Puissance spécifique pour Tint = 19 et Text = -8"]
["V/S","K",null,null,null,null,"Interpolation entre "]
[{"$f":"'Compacité et K'!D14/'Compacité et K'!D16","v":2.5961538461538463},50,70,150,{"$f":"'Compacité et K'!I18","v":79},null,"V/S","W/m³"]
[0.5,33.799999999999997,46.3,67.599999999999994,{"$f":"30.285*LN(E5)-83.73","v":48.598728211963746},null,{"$f":"INDEX(A6:A111,MATCH(A5,A6:A11,1),1)","v":2},{"$f":"INDEX(E6:E11,MATCH(A5,A6:A11,1),1)","v":22.805299999999999}]
[1,20.3,26.6,47.3,{"$f":"0.2668*E5+7.3893","v":28.466499999999996},null,{"$f":"INDEX(A6:A11,MATCH(A5,A6:A11,1)+1,1)","v":3},{"$f":"INDEX(E6:E11,MATCH(A5,A6:A11,1)+1,1)","v":21.2803}]
[1.5,18.100000000000001,22.6,40.6,{"$f":"0.225*E5+6.85","v":24.625},null,"Puissance spécifique (Tint = 19, Text =-8)"]
[2,16.899999999999999,21,37.200000000000003,{"$f":"0.2029*E5+6.7762","v":22.805299999999999},null,{"$f":"H6-(H6-H7)*(A5-G6)*(G7-G6)","v":21.896165384615383}]
[3,15.7,20.2,33.799999999999997,{"$f":"0.1779*E5+7.2262","v":21.2803}]
[4,15.2,16.8,32.1,{"$f":"0.0011*E5*E5-0.0535*E5+15.094","v":17.732599999999998}]
[null,"W/m³","W/m³","W/m³","W/m³"]

{"sheet":"Liste des communes","index":3,"n_rows":575,"n_cols":5,"rows_kept":575,"cut":false,"hidden":true,"merged":[]}
[]
["Commune","- Temp de base",null,"Cellule :",1]
["Aalst",8]
["Aalter",8]
["Aarschot",8]
["Aartselaar",8]
["Aiseau-Presles",9]
["Alken",8]
["Alveringem",8]
["Amay",9]
["Amel",11]
["Andenne",9]
["Anderlues",9]
["Anhee",10]
["Ans",9]
["Anthisnes",10]
["Antoing",8]
["Antwerpen",8]
["Anzegem",8]
["Ardooie",8]
["Arendonk",9]
["Arlon",11]
["As",9]
["Asse",8]
["Assenede",8]
["Assesse",10]
["Ath",8]
["Attert",11]
["Aubange",10]
["Aubel",10]
["Avelgem",8]
["Awans",9]
["Aywaille",10]
["Baarle-Hertog",9]
["Baelen",10]
["Bassenge",8]
["Basse-sambre",9]
["Bastogne",11]
["Beaumont",9]
["Beauraing",10]
["Beauvechain",8]
["Beernem",8]
["Beerse",9]
["Beersel",8]
["Begijnendijk",8]
["Bekkevoort",9]
["Beloeil",8]
["Beringen",9]
["Berlaar",8]
["Berlare",8]
["Berloz",9]
["Bernissart",8]
["Bertem",8]
["Bertogne",11]
["Bertrix",11]
["Bever",8]
["Beveren",8]
["Beyne-Heusay",10]
["Bierbeek",8]
["Bievre",11]
["Bilzen",8]
["Binche",9]
["Blankenberge",7]
["Blegny",9]
["Bocholt",9]
["Boechout",8]
["Bonheiden",8]
["Boom",8]
["Boortmeerbeek",8]
["Borgloon",8]
["Bornem",8]
["Borsbeek",8]
["Bouillon",10]
["Boussu",8]
["Boutersem",8]
["Braine-l'Alleud",8]
["Braine-le-Comte",8]
["Braine-le-Chateau",9]
["Braives",9]
["Brakel",8]
["Brasschaat",9]
["Brecht",9]
["Bredene",7]
["Bree",9]
["Brugelette",8]
["Brugge",8]
["Brunehaut",8]
["Bruxelles",8]
["Buggenhout",8]
["Bullingen",12]
["Burdinne",9]
["Burg-Reuland",11]
["Butgenbach",12]
["Celles",8]
["Cerfontaine",10]
["Chapelle-lez-Herlaimont",9]
["Charleroi",9]
["Chastre-Villeroux-Blanmont",9]
["Chatelet",9]
["Chaudfontaine",9]
["Chaumont-Gistoux",9]
["Chievres",8]
["Chimay",10]
["Chiny",10]
["Ciney",10]
["Clavier",10]
["Colfontaine",8]
["Comblain-au-Pont",9]
["Comines-Warneton",8]
["Courcelles",9]
["Court-Saint-Etienne",8]
["Couvin",10]
["Crisnee",9]
["Dalhem",9]
["Damme",8]
["Daverdisse",11]
["De Haan",7]
["De Panne",7]
["De Pinte",8]
["Deerlijk",8]
["Deinze",8]
["Denderleeuw",8]
["Dendermonde",8]
["Dentergem",8]
["Dessel",9]
["Destelbergen",8]
["Diepenbeek",8]
["Diest",9]
["Diksmuide",8]
["Dilbeek",8]
["Dilsen",9]
["Dinant",10]
["Dison",10]
["Doische",10]
["Donceel",9]
["Dour",8]
["Drogenbos",8]
["Duffel",8]
["Durbuy",10]
["Ecaussinnes",9]
["Edegem",8]
["Eeklo",8]
["Eghezee",9]
["Ellezelles",8]
["Enghien",8]
["Engis",9]
["Enines"]
["Erezee",10]
["Erpe-Mere",8]
["Erquelinnes",9]
["Esneux",9]
["Essen",9]
["Estaimpuis",8]
["Estinnes-au-Val",9]
["Etalle",10]
["Eupen",10]
["Evegnee-Tignee",8]
["Evergem",8]
["Faimes",9]
["Farciennes",9]
["Fauvillers",11]
["Fernelmont",9]
["Ferrieres",10]
["Fexhe-le-Haut-Clocher",9]
["Flemalle",9]
["Fleron",10]
["Fleurus",9]
["Flobecq",8]
["Floreffe",9]
["Florennes",10]
["Florenville",10]
["Fontaine-l'Eveque",9]
["Fosses-la-Ville",9]
["Frameries",9]
["Frasnes-lez-Anvaing",8]
["Froidchapelle",10]
["Galmaarden",8]
["Gavere",8]
["Gedinne",11]
["Geel",9]
["Geer",9]
["Geetbets",8]
["Gembloux",9]
["Genappe",9]
["Genk",9]
["Gent",8]
["Geraardsbergen",8]
["Gerpinnes",9]
["Gesves",10]
["Gingelom",9]
["Gistel",8]
["Glabbeek-Zuurbemde",8]
["Gooik",8]
["Gouvy",11]
["Grace-Hollogne",9]
["Grez-Doiceau",8]
["Grimbergen",8]
["Grobbendonk",9]
["Haacht",8]
["Haaltert",8]
["Habay",11]
["Halen",9]
["Halle",8]
["Ham",9]
["Ham-sur-Heure-Nalinnes",9]
["Hamme",8]
["Hamoir",10]
["Hamois",10]
["Hamont-Achel",9]
["Hannut",9]
["Harelbeke",8]
["Hasselt",8]
["Hastiere",10]
["Havelange",10]
["Hechtel-Eksel",9]
["Heer",8]
["Heist-op-den-Berg",8]
["Hekelgem",8]
["Helecine",8]
["Hemiksem",8]
["Hensies",8]
["Herbeumont",11]
["Herent",8]
["Herentals",9]
["Herenthout",9]
["Herk-de-Stad",8]
["Herne",8]
["Heron",9]
["Herselt",9]
["Herstal",9]
["Herstappe",9]
["Herve",10]
["Herzele",8]
["Heusden-Zolder",9]
["Heuvelland",8]
["Hoegaarden",8]
["Hoeilaart",8]
["Hoeselt",8]
["Holsbeek",8]
["Honnelles",8]
["Hooglede",8]
["Hoogstraten",9]
["Horebeke",8]
["Hotton",10]
["Houffalize",11]
["Houthalen-Helchteren",9]
["Houthulst",8]
["Houyet",10]
["Hove",8]
["Huldenberg",8]
["Hulshout",9]
["Huy",9]
["Ichtegem",8]
["Ieper",8]
["Incourt",9]
["Ingelmunster",8]
["Ittre",9]
["Izegem",8]
["Jabbeke",8]
["Jalhay",11]
["Jemeppe-sur-Sambre",9]
["Jodoigne",8]
["Juprelle",9]
["Jurbise",8]
["Kalmthout",9]
["Kampenhout",8]
["Kapelle-op-den-Bos",8]
["Kapellen",9]
["Kaprijke",8]
["Kasterlee",9]
["Keerbergen",8]
["Kelmis",10]
["Kinrooi",9]
["Kluisbergen",8]
["Knesselare",8]
["Knokke-Heist",7]
["Koekelare",8]
["Koksijde",7]
["Kontich",8]
["Kortemark",8]
["Kortenaken",8]
["Kortenberg",8]
["Kortessem",8]
["Kortrijk",8]
["Kraainem",8]
["Kruibeke",8]
["Kruishoutem",8]
["Kuurne",8]
["La Bruyere",9]
["La Louviere",8]
["La Hulpe",8]
["La Roche-en-Ardenne",11]
["Laakdal",9]
["Laar",8]
["Lanaken",8]
["Landen",8]
["Langemark-Poelkapelle",8]
["Lasne",9]
["Le Roeulx",8]
["Lebbeke",8]
["Lede",8]
["Ledegem",8]
["Leglise",11]
["Lendelede",8]
["Lennik",8]
["Lens",8]
["Leopoldsburg",9]
["Les Bons Villers",9]
["Lessines",8]
["Leuven",8]
["Leuze-en-Hainaut",8]
["Libin",11]
["Libramont-Chevigny",11]
["Lichtervelde",8]
["Liedekerke",8]
["Liege",9]
["Lier",8]
["Lierde",8]
["Lierneux",11]
["Lille",9]
["Limbourg",10]
["Lincent",8]
["Linkebeek",8]
["Lint",8]
["Linter",8]
["Lo-Reninge",8]
["Lobbes",9]
["Lochristi",8]
["Lokeren",8]
["Lommel",9]
["Londerzeel",8]
["Lontzen",10]
["Lovendegem",8]
["Lubbeek",8]
["Lummen",9]
["Maarkedal",8]
["Maaseik",9]
["Maasmechelen",8]
["Machelen",8]
["Maldegem",8]
["Malle",9]
["Malmedy",11]
["Manage",9]
["Manhay",11]
["Marche-en-Famenne",10]
["Marchin",10]
["Martelange",11]
["Mechelen",8]
["Meerhout",9]
["Meeuwen-Gruitrode",9]
["Meise",8]
["Meix-devant-Virton",10]
["Melen",8]
["Menen",8]
["Merbes-le-Chateau",9]
["Merchtem",8]
["Merelbeke",8]
["Merksplas",9]
["Mesen",8]
["Messancy",10]
["Mettet",10]
["Meulebeke",8]
["Middelkerke",7]
["Modave",10]
["Moerbeke",8]
["Mol",9]
["Momignies",10]
["Mons",8]
["Mont-Saint-Guibert",9]
["Mont-de-l'Enclus",8]
["Montigny-le-Tilleul",9]
["Moorslede",8]
["Morlanwelz",9]
["Mortsel",8]
["Mouscron",8]
["Musson",10]
["Namur",9]
["Nandrin",10]
["Nassogne",10]
["Nazareth",8]
["Neerpelt",9]
["Neufchateau",11]
["Neupre",10]
["Nevele",8]
["Niel",8]
["Nieuwerkerken",8]
["Nieuwpoort",7]
["Nijlen",8]
["Ninove",8]
["Nivelles",9]
["Ohey",10]
["Olen",9]
["Olne",10]
["Onhaye",10]
["Oostende",7]
["Oosterzele",8]
["Oostkamp",8]
["Oostrozebeke",8]
["Opglabbeek",9]
["Opwijk",8]
["Oreye",9]
["Orp-Jauche",8]
["Ottignies-Louvain-la-Neuve",8]
["Oud-Heverlee",8]
["Oud-Turnhout",9]
["Oudenaarde",8]
["Oudenburg",8]
["Ouffet",10]
["Oupeye",8]
["Overijse",8]
["Overpelt",9]
["Paliseul",11]
["Pecq",8]
["Peer",9]
["Pepingen",8]
["Pepinster",10]
["Peruwelz",8]
["Perwez",9]
["Philippeville",10]
["Pittem",8]
["Plombieres",10]
["Pont-a-Celles",9]
["Poperinge",8]
["Profondeville",9]
["Putte",8]
["Puurs",8]
["Quaregnon",8]
["Quevy",9]
["Quievrain",8]
["Raeren",10]
["Ramillies",9]
["Ranst",8]
["Ravels",9]
["Rebecq",8]
["Remicourt",9]
["Rendeux",10]
["Retie",9]
["Riemst",8]
["Rijkevorsel",9]
["Rixensart",8]
["Rochefort",10]
["Roeselare",8]
["Ronse",8]
["Roosdaal",8]
["Rotselaar",8]
["Rouvroy",10]
["Ruiselede",8]
["Rumes",8]
["Rumst",8]
["Sainte-Ode",11]
["Saint-Georges-sur-Meuse",9]
["Saint-Ghislain",8]
["Saint-Hubert",11]
["Saint-Leger",10]
["Saint-Nicolas",9]
["Sankt Vith",11]
["Schelle",8]
["Scherpenheuvel-Zichem",9]
["Schilde",9]
["Schoten",9]
["Seneffe",9]
["Seraing",9]
["Silly",8]
["Sint-Katelijne-Waver",8]
["Sint-Pieters-Leeuw",8]
["Sint-Lievens-Houtem",8]
["Sint-Martens-Latem",8]
["Sint-Laureins",8]
["Sint-Amands",8]
["Sint-Truiden",8]
["Sint-Genesius-Rode",8]
["Sint-Gillis-Waas",8]
["Sint-Gillis",8]
["Sint-Niklaas",8]
["Sivry-Rance",10]
["Soignies",8]
["Sombreffe",9]
["Somme-Leuze",10]
["Soumagne",10]
["Spa",10]
["Spiere-Helkijn",8]
["Sprimont",10]
["Stabroek",8]
["Staden",8]
["Stavelot",11]
["Steenokkerzeel",8]
["Stekene",8]
["Stoumont",10]
["Tellin",10]
["Temse",8]
["Tenneville",11]
["Ternat",8]
["Tervuren",8]
["Tessenderlo",9]
["Theux",10]
["Thimister-Clermont",10]
["Thuin",9]
["Tielt",8]
["Tielt-Winge",8]
["Tienen",8]
["Tinlot",10]
["Tintigny",11]
["Tongeren",8]
["Torhout",8]
["Tournai",8]
["Tremelo",8]
["Trois-Ponts",11]
["Trooz",9]
["Tubize",8]
["Turnhout",9]
["Vaux-sur-Sure",11]
["Verlaine",9]
["Verviers",10]
["Veurne",8]
["Vielsalm",11]
["Villers-le-Bouillet",9]
["Villers-la-Ville",9]
["Vilvoorde",8]
["Viroinval",10]
["Virton",10]
["Vise",8]
["Vleteren",8]
["Voeren",9]
["Vorselaar",9]
["Vosselaar",9]
["Vresse-sur-Semois",11]
["Waarschoot",8]
["Waasmunster",8]
["Wachtebeke",8]
["Waimes",12]
["Walcourt",9]
["Walhain-Saint-Paul",9]
["Wanze",9]
["Waregem",8]
["Waremme",9]
["Wasseiges",9]
["Waterloo",9]
["Wavre",8]
["Welkenraedt",10]
["Wellen",8]
["Wellin",10]
["Wemmel",8]
["Wervik",8]
["Westerlo",9]
["Wetteren",8]
["Wevelgem",8]
["Wezembeek-Oppem",8]
["Wichelen",8]
["Wielsbeke",8]
["Wijnegem",8]
["Willebroek",8]
["Wingene",8]
["Wommelgem",8]
["Wortegem-Petegem",8]
["Wuustwezel",9]
["Yvoir",10]
["Zandhoven",9]
["Zaventem",8]
["Zedelgem",8]
["Zele",8]
["Zelzate",8]
["Zemst",8]
["Zingem",8]
["Zolder",9]
["Zomergem",8]
["Zonhoven",9]
["Zonnebeke",8]
["Zottegem",8]
["Zoutleeuw",8]
["Zuienkerke",8]
["Zulte",8]
["Zutendaal",9]
["Zwalm",8]
["Zwevegem",8]
["Zwijndrecht",8]