{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Welkom","Basisgegevens","Muurisolatie","Dakisolatie","Vloerisolatie","Schrijnwerkrenovatie","Regeltechnisch","Relighting","Warmtepompen en koeling","Warmtenetkoppeling","Flex & Opslag","Hernieuwbare Energie","Indirecte maatregel(en)","Andere","Overzicht & verbintenissen","Assumpties","OVERZICHTSTABEL","Lijsten","AEE_Config"],"not_rendered":{"charts":11,"images":11,"macros":1,"external_links":0,"defined_names":41,"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":"Welkom","index":0,"n_rows":70,"n_cols":10,"rows_kept":70,"cut":false,"hidden":false,"merged":[[68,1,68,8],[69,1,71,8],[57,1,57,7],[45,1,45,8],[54,1,54,7],[52,1,52,7],[53,1,53,7],[55,1,55,7],[51,1,51,7],[56,1,56,7],[62,1,62,8],[50,1,50,8],[65,1,65,8],[66,1,66,8],[59,1,59,8],[60,1,60,8],[0,1,0,8],[26,1,26,8],[28,1,28,8],[29,1,29,8],[13,1,13,8],[14,1,22,8],[2,1,2,8],[3,1,11,8],[27,1,27,8],[33,1,33,7],[39,1,39,8],[40,1,40,8],[41,1,41,8],[30,1,30,8],[31,1,31,8],[32,1,32,8],[34,1,34,8],[35,1,35,8],[37,1,37,8],[36,1,36,8],[38,1,38,8],[61,1,61,8],[42,1,42,8],[43,1,43,8],[44,1,44,8],[46,1,46,8],[49,1,49,8]]}
[null,"Aanvraagformulier Actieplan Energie‑Efficiëntie 2026"]
[]
[null,"Het Actieplan"]
[null,"Het Actieplan Energie‑Efficiëntie (AEE) is een oproep georganiseerd door het Vlaams Energiebedrijf (VEB) binnen het interne Klimaatplan van de Vlaamse overheid om entiteiten te ondersteunen bij investeringen die het energieverbruik en de klimaatimpact structureel verlagen. Het reglement onderscheidt directe maatregelen met energie‑ en/of CO₂‑besparing, indirecte maatregelen (studies/monitoring) en flexibiliteits‑ en opslagprojecten; voor elk type gelden specifieke rekenregels voor het indicatieve steunbedrag, steeds op kosten exclusief btw. Projecten worden beoordeeld en gerangschikt op basis van kostenefficiëntie (euro per ton CO₂ en per MWh besparing over de levensduur), datakwaliteit en beleidsaccenten; toekenning gebeurt in functie van het beschikbare budget. Het volledige steunbedrag wordt in het aanvraagjaar vastgelegd (VAK) en kan vervolgens over maximaal vier kalenderjaren worden uitbetaald (VEK). Er geldt een plafond van 1.000.000 € steun per entiteit en per begrotingsjaar. Uitvoering moet binnen vier kalenderjaren na het aanvraagjaar worden gerealiseerd."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Doel van dit bestand"]
[null,"Dit bestand helpt u uw energiemaatregelen te specificeren, de indicatieve steun per maatregel te berekenen en een VEK‑planning (uitbetaling) te maken, met op het einde de verbintenissen en ondertekening. De definitieve toekenning volgt pas na scoring en rangschikking door VEB en met toepassing van plafonds per entiteit."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Hoe werkt het – stap voor stap"]
[null,"• U vult per gebouw één aanvraagformulier in"]
[null,"1. Basisgegevens invullen"]
[null,"• Ga naar “Basisgegevens” en vul de administratieve velden in.  "]
[null,"• Duid in de tabel per maatregel “Aangevraagd” = Ja/Neen aan.  "]
[null,"• Klik op “Toon Werkbladen”: de relevante maatregeltabs worden zichtbaar (de andere worden verborgen).  "]
[null,"• De macro bepaalt meteen of u in aanmerking komt voor Totaalrenovatie (≥ 3 mee‑tellige maatregelen)."]
[null,"• Vul ALLE velden die ROZE zijn: dit zijn verplichte invoervakken.  ",null,null,null,null,null,null,"Vakken met deze kleur dienen verplicht ingevuld te worden"]
[null,"2. Vul enkel de zichtbare maatregel‑tabbladen in"]
[null,"• “Investeringskost (definitief)” kunt u desgewenst laten overruled worden door een offerte; voeg de pdf als bijlage toe.  "]
[null,"• “Subsidiesteun reeds ontvangen” (excl. btw) kunt u per maatregel invullen; netto‑logica wordt dan automatisch verwerkt in het overzicht.  "]
[null,"• U dient staving te voorzien voor elke ingevulde parameter (bv. U-waardes bij isolatie, enz.). Zie ook \"indienen\". Staving mag gebeuren onder eender welke vorm, maar dient duidelijk aan te geven hoe elke parameter werd bepaald."]
[null,"• Voor Warmtenetkoppeling, Flex & Opslag, Hernieuwbare Energie en Andere vult u de resultatentabel zelf in en voegt u de staving toe, indien van toepassing."]
[null,"3. overzicht & verbintenissen (VEK en finale check)"]
[null,"• Filter bovenaan “aangevraagd?” = Ja om enkel relevante maatregelen te zien.  "]
[null,"• VAK (Potentieel Steunbedrag): indicatief steunbedrag per maatregel “mits goedkeuring”; VAK wordt in het aanvraagjaar vastgelegd.  "]
[null,"• VEK 2026–2029 (€): geef per aangevraagde maatregel de uitbetalingsplanning in."]
[null,"• Lees de verbintenissen op het blad “overzicht & verbintenissen”.  "]
[null,"• Vul Datum, Voor‑ en achternaam, Functie in."]
[null,"• Lees en onderteken de akkoordverklaring (zie website)"]
[null,"• GDPR‑clausule: staat onderaan het blad; voeg gevraagde stukken toe (offertes/bijlagen)."]
[]
[]
[null,"Indienen"]
[null,"Onderstaande documenten worden ingediend in 1 map (zip) per mail. Gelieve onderstaande naamgeving te respecteren. Het is hoofdzakelijk belangrijk dat de documenten een unieke naam hebben."]
[null,"Bestand",null,null,null,null,null,null,"Naamgeving"]
[null,"Aanvraagformulier (dit document)",null,null,null,null,null,null,"AEE26_NAAMENTITEIT_NAAMGEBOUW","bv. AEE26_VEB_HERMANTEIRLINCK"]
[null,"Stavingsdocumenten (1/meerdere)",null,null,null,null,null,null,"AEE26_NAAMENTITEIT_WERKTITELMAATREGEL_TITEL","bv. AEE26_VEB_ISOLATIEPLATDAK_UWAARDEN"]
[null,"Bewijs voorafgaande audit | Enkel indien van toepassing",null,null,null,null,null,null,"AEE26_NAAMENTITEIT_NAAMGEBOUW_AUDIT","bv. AEE26_VEB_HERMANTEIRLINCK_AUDIT"]
[null,"Offerte(s) | Enkel indien van toepassing",null,null,null,null,null,null,"AEE26_NAAMENTITEIT_WERKTITELMAATREGEL_OFFERTE","bv. AEE26_VEB_ISOLATIEPLATDAK_OFFERTE"]
[null,"Rapportering lopende maategelen van voorgaande jaren | Enkel indien van toepassing",null,null,null,null,null,null,"AEE26_NAAMENTITEIT_RAPPORTERING","bv. AEE26_VEB_ISOLATIEPLATDAK_RAPPORTERING"]
[null,"Akkoordverklaring",null,null,null,null,null,null,"AEE26_NAAMENTITEIT_AKKOORDVERKLARING","bv. AEE26_VEB_ISOLATIEPLATDAK_AKKOORDVERKLARING"]
[]
[null,"Aandachtspunten"]
[null,"LET OP – Eén formulier per gebouw/infra."]
[null,"Indien u binnen hetzelfde gebouw meerdere aanvragen van hetzelfde type wil indienen (bijv. twee indirecte maatregelen of twee keer muurisolatie), gelieve een tweede formulier voor hetzelfde gebouw (zelfde entiteit en adres) in te dienen. "]
[null,"Tip: geef in “Werktitel” kort aan wat verschilt (bv. “Muurisolatie – westgevel” / “– zuidgevel”)."]
[]
[]
[null,"Contact"]
[null,"Voor alle  vragen, bedenkingen en opmerkingen: ActieplanEE@veb.be\n\nGraag geven wij ook mee dat het pas de eerste keer is dat we via deze aanvraagmethode werken; alle feedback welkom op hetzelfde mailadres."]
[]
[null,"Ondersteuning bij offerte‑aanvragen"]
[null,"Vraag een vrijblijvende offerte aan voor uw dossier.\n\nHet aanvragen van een offerte houdt geen enkele verplichting tot uitvoering in."]

{"sheet":"Basisgegevens","index":1,"n_rows":63,"n_cols":23,"rows_kept":63,"cut":false,"hidden":false,"merged":[[1,3,1,9],[7,10,7,13],[6,3,6,5],[3,3,3,5],[22,3,22,5],[32,3,32,5],[33,3,36,3],[7,3,7,5],[8,3,8,5],[18,3,18,5],[30,10,31,13],[54,3,54,5],[59,7,59,11],[8,10,9,13],[62,3,62,5],[12,13,13,13],[44,3,50,3],[44,4,50,4],[44,5,50,5],[33,4,36,4],[33,5,36,5],[38,3,38,5],[40,3,43,3],[40,4,43,4],[40,5,43,5],[27,3,27,5]]}
[]
[null,null,null,"Dit document maakt gebruik van macro's: zorg ervoor dat ze ingeschakeld zijn. Indien u hierbij hulp nodig heeft verwijzen we naar de officiële pagina van Microsoft."]
[]
[null,null,null,"Aanvraagformulier – Actieplan Energie-Efficiëntie (EE) 2026"]
[null,null,null,"Per gebouw vult u 1 fiche in. Eén project kan uit meerdere maatregelen bestaan."]
[]
[null,null,null,"1) Vul hieronder de basisgegevens in. 2) Geef onder Maatregelen aan voor welke maatregel(en) u een aavraag doet"]
[null,null,null,"Administratief",null,null,null,null,null,null,"Maatregelen"]
[null,null,null,"Gegevens van de aanvragende organisatie",null,null,null,null,null,null,"Duid aan voor welk type maatregel(en) u subsidiesteun wenst aan te vragen."]
[null,null,null,"Naam van de entiteit : "]
[null,null,null,"Straat, nummer en bus :"]
[null,null,null,"Postcode en gemeente : ",null,null,null,null,null,null,"Maatregel","Aangevraagd"]
[null,null,null,"Telefoonnummer : ",null,null,null,null,null,null,"Muurisolatie","Nee",null,"Hieronder ziet u of uw project al dan niet in aanmerking komt voor een Totaalrenovatie"]
[null,null,null,"Maatschappelijke zetel : ",null,null,null,null,null,null,"Dakisolatie","Nee"]
[null,null,null,"Ondernemingsnummer : ",null,null,null,null,null,null,"Vloerisolatie","Nee"]
[null,null,null,"IBAN-rekeningnummer :",null,null,null,null,null,null,"Schrijnwerkrenovatie","Nee",null,"Totaalrenovatie",null,null,null,null,null,null,null,null," "]
[null,null,null,"BIC : ",null,null,null,null,null,null,"Regeltechnisch","Nee",null,"Nee"]
[null,null,null,"Beleidsdomein: ",null,null,null,null,null,null,"Relighting","Nee"]
[null,null,null,"Gegevens van de leidend ambtenaar",null,null,null,null,null,null,"Warmtepompen en koeling","Nee"]
[null,null,null,"Naam verantwoordelijke :",null,null,null,null,null,null,"Warmtenetkoppeling","Nee"]
[null,null,null,"Functie  :",null,null,null,null,null,null,"Flex & Opslag","Nee"]
[null,null,null,"E-mailadres  :",null,null,null,null,null,null,"Hernieuwbare Energie","Nee"]
[null,null,null,"Gegevens van de begrotingscoördinator",null,null,null,null,null,null,"Indirecte maatregel(en)","Nee"]
[null,null,null,"Naam begrotingscoördinator :",null,null,null,null,null,null,"Andere","Nee"]
[null,null,null,"Functie  :"]
[null,null,null,"E-mailadres  :",null,null,null,null,null,null,"Klik hier wanneer voltooid"]
[null,null,null,"Rechtstreeks telefoonnr. :"]
[null,null,null," Begrotingsgegevens"]
[null,null,null,"Begrotingsartikel:"]
[null,null,null,"Basisallocatie:"]
[null,null,null,"Begrotingsverantwoordelijke beleidsdomein:",null,null,null,null,null,null,"Per geselecteerde maatregel verschijnt een tabblad; vul alle relevante tabbladen in. \nNadien gaat u naar \"Overzicht & verbintenissen\""]
[]
[null,null,null,"Voorstelling organisatie"]
[null,null,null,"Stel uw organisatie beknopt voor"]
[]
[]
[]
[]
[null,null,null,"Project"]
[null,null,null,"Geef uw project een werktitel"]
[null,null,null,"Vat uw project beknopt samen.\nLet op: deze info kan gebruikt worden in externe communicatie."]
[]
[]
[]
[null,null,null," Geef aan hoe dit project past binnen het strategisch vastgoedplan en energetisch masterplan van uw entiteit. Indien de entiteit hier nog niet over beschikt, geef dan aan hoe de steunaanvraag past binnen haar energiebeheer en -beleid van het gebouw en/of technische infrastructuur en de vastgoedstatus."]
[]
[]
[]
[]
[]
[]
[null,null,null,"Aanvraagjaar",2026]
[null,null,null,"Indieningsronde",1]
[]
[null,null,null,"Gebouwgegevens"]
[null,null,null,"Gebouwnaam"]
[null,null,null,"Adres (Straat, Huisnr., postcode, plaats)",null,"(scheiden met komma)"]
[null,null,null,"Vastgoedstatus"]
[null,null,null,"Type recht"]
[null,null,null,"Einde looptijd overeenkomst in functie van type recht *",null,null,null,"* Moet niet ingevuld worden wanneer het type recht 'Eigendom' is.\t\t\t"]
[null,null,null,"Is dit een kantoorgebouw dat wordt ingekanteld in HFB?"]
[]
[null,null,null,"Geef nu onder Maatregelen aan voor welke maatregel(en) u een aavraag doet"]

{"sheet":"Muurisolatie","index":2,"n_rows":78,"n_cols":16,"rows_kept":78,"cut":false,"hidden":true,"merged":[[0,1,0,8],[11,1,11,4],[11,6,11,8],[2,1,2,3],[3,2,3,3],[4,2,4,3],[8,2,8,3],[6,1,7,1],[6,2,7,3],[9,2,9,3],[9,4,9,8],[5,2,5,3],[5,4,5,8],[25,1,25,4],[14,10,14,11],[14,12,14,14],[20,1,20,4],[11,10,12,15],[13,10,13,11],[13,12,13,14]]}
[null,"Muurisolatie"]
[]
[null,"Maatregelspecifieke gegevens"]
[null,"Werktitel Maatregel"]
[null,"Referentiecode maatregel Terra:"]
[null,"Referentiecode Portaal Energie-Efficiëntie*",null,null,"*Geef de referrentiecode van het EE-portaal van deze aanvraag. Geef 0 in indien niet van toepassing."]
[null,"Bijkomende uitleg/ opmerkingen:"]
[]
[null,"Binnenmuurisolatie of buitengevelisolatie?"]
[null,"Subsidiesteun reeds ontvangen*",null,null,"*geef aan voor welk bedrag (€) u reeds elders subsidiesteun ontving of zal ontvangen voor deze maatregel. Geef 0 in indien niet van toepassing."]
[]
[null,"In te vullen parameters",null,null,null,null,"Resultaten (automatisch berekend)",null,null,null,"Investeringskosten mogen overschreven worden door een offerteprijs indien de offerteprijs sterk afwijkt. Gelieve hieronder het offertebedrag op te geven en de offerte mee door te sturen als bijlage (pdf)"]
[null,"Parameter","Eenheid","Waarde (invul)","Toelichting / guidance",null,"Output","Waarde","Eenheid"]
[null,"Oppervlakte (geïsoleerd)","m²",null,"Netto oppervlak waarop de maatregel wordt toegepast.",null,"Investeringskost",{"$f":"(D14*D19)+D20","v":0},"€",null,"Offertekost, investering (optioneel)",null,null,null,null,"€"]
[null,"U-waarde bestaand","W/m²K",null,"Huidige U-waarde (of schatting).",null,"Jaarlijkse kostenbesparing",{"$f":"((IF(D17=\"Elektriciteit\",(IF(D18>0,(MAX((D15-D16)*D14*D22*24/1000*1,0))/D18,0)),0))*ELEC_PRICE)+((IF(D17=\"Elektriciteit\",0,(IF(D18>0,(MAX((D15-D16)*D14*D22*24/1000*1,0))/D18,0))))*(IFERROR(VLOOKUP(D17,CARRIER_TABLE,2,FALSE),0)))","v":0},"€/jaar",null,"Ik wens de investeringskost te overschrijden"]
[null,"U-waarde nieuw","W/m²K",null,"Beoogde U-waarde na maatregel.",null,"Jaarlijkse CO₂-besparing",{"$f":"(((IF(D17=\"Elektriciteit\",(IF(D18>0,(MAX((D15-D16)*D14*D22*24/1000*1,0))/D18,0)),0))*ELEC_CO2)+((IF(D17=\"Elektriciteit\",0,(IF(D18>0,(MAX((D15-D16)*D14*D22*24/1000*1,0))/D18,0))))*(IFERROR(VLOOKUP(D17,CARRIER_TABLE,3,FALSE),0))))/1000","v":0},"tCO₂/jaar"]
[null,"Energiedrager verwarming","-",null,"Kies energiedrager van de huidige verwarming.",null,"Elektriciteitsbesparing",{"$f":"IF(D17=\"Elektriciteit\",IF(D18>0,(MAX((D15-D16)*D14*D22*24/1000*1,0))/D18,0),0)","v":0},"kWh/jaar"]
[null,"Rendement bestaande installatie (η)","-",null,"0-1 (bv. ketelrendement).",null,"Brandstofbesparing (gas/olie/warmtenet)",{"$f":"IF(D17=\"Elektriciteit\",0,(IF(D18>0,(MAX((D15-D16)*D14*D22*24/1000*1,0))/D18,0)))","v":0},"kWh/jaar"]
[null,"Kost per m² (indicatief)","€/m²",null,"Investeringskost per m² (materiaal + plaatsing)."]
[null,"Vaste kosten (bv. werf/steigers)","€",null,"Eenmalige vaste kosten."]
[]
[null,"Graaddagen","K·dagen/jaar",{"$f":"HDD","v":2187},"Standaard via tab 'Assumpties'."]
[]
[]
[]
[null,"Grafiek: cumulatieve cashflow (indicatieve terugverdientijd)"]
[null,null,null,null,null,null,null,null,null,"Jaar","Cashflow","Cumulatief"]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(J28<=N_YEARS,IF(J28=0,-H14,H15),NA())","v":0},{"$f":"IF(ISNA(K28),NA(),K28)","v":0}]
[null,null,null,null,null,null,null,null,null,1,{"$f":"IF(J29<=N_YEARS,IF(J29=0,-H14,H15),NA())","v":0},{"$f":"IF(ISNA(K29),NA(),L28+K29)","v":0}]
[null,null,null,null,null,null,null,null,null,2,{"$f":"IF($J30<=N_YEARS,IF($J$30=0,-$H$14,$K29*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,3,0,0]
[null,null,null,null,null,null,null,null,null,4,0,0]
[null,null,null,null,null,null,null,null,null,5,0,0]
[null,null,null,null,null,null,null,null,null,6,0,0]
[null,null,null,null,null,null,null,null,null,7,0,0]
[null,null,null,null,null,null,null,null,null,8,0,0]
[null,null,null,null,null,null,null,null,null,9,0,0]
[null,null,null,null,null,null,null,null,null,10,0,0]
[null,null,null,null,null,null,null,null,null,11,0,0]
[null,null,null,null,null,null,null,null,null,12,0,0]
[null,null,null,null,null,null,null,null,null,13,0,0]
[null,null,null,null,null,null,null,null,null,14,0,0]
[null,null,null,null,null,null,null,null,null,15,0,0]
[null,null,null,null,null,null,null,null,null,16,0,0]
[null,null,null,null,null,null,null,null,null,17,0,0]
[null,null,null,null,null,null,null,null,null,18,0,0]
[null,null,null,null,null,null,null,null,null,19,0,0]
[null,null,null,null,null,null,null,null,null,20,0,0]
[null,null,null,null,null,null,null,null,null,21,0,0]
[null,null,null,null,null,null,null,null,null,22,0,0]
[null,null,null,null,null,null,null,null,null,23,0,0]
[null,null,null,null,null,null,null,null,null,24,0,0]
[null,null,null,null,null,null,null,null,null,25,0,0]
[null,null,null,null,null,null,null,null,null,26,0,0]
[null,null,null,null,null,null,null,null,null,27,0,0]
[null,null,null,null,null,null,null,null,null,28,0,0]
[null,null,null,null,null,null,null,null,null,29,0,0]
[null,null,null,null,null,null,null,null,null,30,0,0]
[null,null,null,null,null,null,null,null,null,31,0,0]
[null,null,null,null,null,null,null,null,null,32,0,0]
[null,null,null,null,null,null,null,null,null,33,0,0]
[null,null,null,null,null,null,null,null,null,34,{"$f":"IF($J62<=N_YEARS,IF($J$30=0,-$H$14,$K61*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,35,0,0]
[null,null,null,null,null,null,null,null,null,36,0,0]
[null,null,null,null,null,null,null,null,null,37,0,0]
[null,null,null,null,null,null,null,null,null,38,0,0]
[null,null,null,null,null,null,null,null,null,39,0,0]
[null,null,null,null,null,null,null,null,null,40,0,0]
[null,null,null,null,null,null,null,null,null,41,0,0]
[null,null,null,null,null,null,null,null,null,42,0,0]
[null,null,null,null,null,null,null,null,null,43,0,0]
[null,null,null,null,null,null,null,null,null,44,0,0]
[null,null,null,null,null,null,null,null,null,45,0,0]
[null,null,null,null,null,null,null,null,null,46,0,0]
[null,null,null,null,null,null,null,null,null,47,0,0]
[null,null,null,null,null,null,null,null,null,48,0,0]
[null,null,null,null,null,null,null,null,null,49,0,0]
[null,null,null,null,null,null,null,null,null,50,0,0]

{"sheet":"Dakisolatie","index":3,"n_rows":78,"n_cols":16,"rows_kept":78,"cut":false,"hidden":true,"merged":[[25,1,25,4],[20,1,20,4],[11,10,12,15],[13,10,13,11],[13,12,13,14],[14,10,14,11],[14,12,14,14],[9,2,9,3],[9,4,9,8],[11,6,11,8],[11,1,11,4],[0,1,0,8],[8,2,8,3],[2,1,2,3],[3,2,3,3],[4,2,4,3],[6,1,7,1],[6,2,7,3],[5,2,5,3],[5,4,5,8]]}
[null,"Dakisolatie"]
[]
[null,"Maatregelspecifieke gegevens"]
[null,"Werktitel Maatregel"]
[null,"Referentiecode maatregel Terra:"]
[null,"Referentiecode Portaal Energie-Efficiëntie*",null,null,"*Geef de referrentiecode van het EE-portaal van deze aanvraag. Geef 0 in indien niet van toepassing."]
[null,"Bijkomende uitleg/ opmerkingen:"]
[]
[null,"Plat of hellend dak?"]
[null,"Subsidiesteun reeds ontvangen*",null,null,"*geef aan voor welk bedrag (€) u reeds elders subsidiesteun ontving of zal ontvangen voor deze maatregel. Geef 0 in indien niet van toepassing."]
[]
[null,"In te vullen parameters",null,null,null,null,"Resultaten (automatisch berekend)",null,null,null,"Investeringskosten mogen overschreven worden door een offerteprijs indien de offerteprijs sterk afwijkt. Gelieve hieronder het offertebedrag op te geven en de offerte mee door te sturen als bijlage (pdf)"]
[null,"Parameter","Eenheid","Waarde (invul)","Toelichting / guidance",null,"Output","Waarde","Eenheid"]
[null,"Oppervlakte (geïsoleerd)","m²",null,"Netto oppervlak waarop de maatregel wordt toegepast.",null,"Investeringskost",{"$f":"(D14*D19)+D20","v":0},"€",null,"Offertekost, investering (optioneel)",null,0,null,null,"€"]
[null,"U-waarde bestaand","W/m²K",null,"Huidige U-waarde (of schatting).",null,"Jaarlijkse kostenbesparing",{"$f":"((IF(D17=\"Elektriciteit\",(IF(D18>0,(MAX((D15-D16)*D14*D22*24/1000*1,0))/D18,0)),0))*ELEC_PRICE)+((IF(D17=\"Elektriciteit\",0,(IF(D18>0,(MAX((D15-D16)*D14*D22*24/1000*1,0))/D18,0))))*(IFERROR(VLOOKUP(D17,CARRIER_TABLE,2,FALSE),0)))","v":0},"€/jaar",null,"Ik wens de investeringskost te overschrijden",null,"Nee"]
[null,"U-waarde nieuw","W/m²K",null,"Beoogde U-waarde na maatregel.",null,"Jaarlijkse CO₂-besparing",{"$f":"(((IF(D17=\"Elektriciteit\",(IF(D18>0,(MAX((D15-D16)*D14*D22*24/1000*1,0))/D18,0)),0))*ELEC_CO2)+((IF(D17=\"Elektriciteit\",0,(IF(D18>0,(MAX((D15-D16)*D14*D22*24/1000*1,0))/D18,0))))*(IFERROR(VLOOKUP(D17,CARRIER_TABLE,3,FALSE),0))))/1000","v":0},"tCO₂/jaar"]
[null,"Energiedrager verwarming","-",null,"Kies energiedrager van de huidige verwarming.",null,"Elektriciteitsbesparing",{"$f":"IF(D17=\"Elektriciteit\",IF(D18>0,(MAX((D15-D16)*D14*D22*24/1000*1,0))/D18,0),0)","v":0},"kWh/jaar"]
[null,"Rendement bestaande installatie (η)","-",null,"0-1 (bv. ketelrendement).",null,"Brandstofbesparing (gas/olie/warmtenet)",{"$f":"IF(D17=\"Elektriciteit\",0,(IF(D18>0,(MAX((D15-D16)*D14*D22*24/1000*1,0))/D18,0)))","v":0},"kWh/jaar"]
[null,"Kost per m² (indicatief)","€/m²",null,"Investeringskost per m² (materiaal + plaatsing)."]
[null,"Vaste kosten (bv. werf/steigers)","€",null,"Eenmalige vaste kosten."]
[]
[null,"Graaddagen","K·dagen/jaar",{"$f":"HDD","v":2187},"Standaard via tab 'Assumpties'."]
[]
[]
[]
[null,"Grafiek: cumulatieve cashflow (indicatieve terugverdientijd)"]
[null,null,null,null,null,null,null,null,null,"Jaar","Cashflow","Cumulatief"]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(J28<=N_YEARS,IF(J28=0,-H14,H15),NA())","v":0},{"$f":"IF(ISNA(K28),NA(),K28)","v":0}]
[null,null,null,null,null,null,null,null,null,1,{"$f":"IF(J29<=N_YEARS,IF(J29=0,-H14,H15),NA())","v":0},{"$f":"IF(ISNA(K29),NA(),L28+K29)","v":0}]
[null,null,null,null,null,null,null,null,null,2,{"$f":"IF($J30<=N_YEARS,IF($J$30=0,-$H$14,$K29*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,3,0,0]
[null,null,null,null,null,null,null,null,null,4,0,0]
[null,null,null,null,null,null,null,null,null,5,0,0]
[null,null,null,null,null,null,null,null,null,6,0,0]
[null,null,null,null,null,null,null,null,null,7,0,0]
[null,null,null,null,null,null,null,null,null,8,0,0]
[null,null,null,null,null,null,null,null,null,9,0,0]
[null,null,null,null,null,null,null,null,null,10,0,0]
[null,null,null,null,null,null,null,null,null,11,0,0]
[null,null,null,null,null,null,null,null,null,12,0,0]
[null,null,null,null,null,null,null,null,null,13,0,0]
[null,null,null,null,null,null,null,null,null,14,0,0]
[null,null,null,null,null,null,null,null,null,15,0,0]
[null,null,null,null,null,null,null,null,null,16,0,0]
[null,null,null,null,null,null,null,null,null,17,0,0]
[null,null,null,null,null,null,null,null,null,18,0,0]
[null,null,null,null,null,null,null,null,null,19,0,0]
[null,null,null,null,null,null,null,null,null,20,0,0]
[null,null,null,null,null,null,null,null,null,21,0,{"$f":"IF(ISNA(K49),NA(),L48+K49)","v":0}]
[null,null,null,null,null,null,null,null,null,22,0,0]
[null,null,null,null,null,null,null,null,null,23,0,0]
[null,null,null,null,null,null,null,null,null,24,0,0]
[null,null,null,null,null,null,null,null,null,25,0,0]
[null,null,null,null,null,null,null,null,null,26,0,0]
[null,null,null,null,null,null,null,null,null,27,0,0]
[null,null,null,null,null,null,null,null,null,28,0,0]
[null,null,null,null,null,null,null,null,null,29,0,0]
[null,null,null,null,null,null,null,null,null,30,0,0]
[null,null,null,null,null,null,null,null,null,31,0,0]
[null,null,null,null,null,null,null,null,null,32,0,0]
[null,null,null,null,null,null,null,null,null,33,0,0]
[null,null,null,null,null,null,null,null,null,34,{"$f":"IF($J62<=N_YEARS,IF($J$30=0,-$H$14,$K61*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,35,0,0]
[null,null,null,null,null,null,null,null,null,36,0,0]
[null,null,null,null,null,null,null,null,null,37,0,0]
[null,null,null,null,null,null,null,null,null,38,0,0]
[null,null,null,null,null,null,null,null,null,39,0,0]
[null,null,null,null,null,null,null,null,null,40,0,0]
[null,null,null,null,null,null,null,null,null,41,0,0]
[null,null,null,null,null,null,null,null,null,42,0,0]
[null,null,null,null,null,null,null,null,null,43,0,0]
[null,null,null,null,null,null,null,null,null,44,0,0]
[null,null,null,null,null,null,null,null,null,45,0,0]
[null,null,null,null,null,null,null,null,null,46,0,0]
[null,null,null,null,null,null,null,null,null,47,0,0]
[null,null,null,null,null,null,null,null,null,48,0,0]
[null,null,null,null,null,null,null,null,null,49,0,0]
[null,null,null,null,null,null,null,null,null,50,0,0]

{"sheet":"Vloerisolatie","index":4,"n_rows":78,"n_cols":16,"rows_kept":78,"cut":false,"hidden":true,"merged":[[25,1,25,4],[21,1,21,4],[11,10,12,15],[13,10,13,11],[13,12,13,14],[14,10,14,11],[14,12,14,14],[0,1,0,8],[11,1,11,4],[11,6,11,8],[2,1,2,3],[3,2,3,3],[4,2,4,3],[6,1,7,1],[6,2,7,3],[8,2,8,3],[8,4,8,8],[5,2,5,3],[5,4,5,8]]}
[null,"Vloerisolatie"]
[]
[null,"Maatregelspecifieke gegevens"]
[null,"Werktitel Maatregel"]
[null,"Referentiecode maatregel Terra:"]
[null,"Referentiecode Portaal Energie-Efficiëntie*",null,null,"*Geef de referrentiecode van het EE-portaal van deze aanvraag. Geef 0 in indien niet van toepassing."]
[null,"Bijkomende uitleg/ opmerkingen:"]
[]
[null,"Subsidiesteun reeds ontvangen*",null,null,"*geef aan voor welk bedrag (€) u reeds elders subsidiesteun ontving of zal ontvangen voor deze maatregel. Geef 0 in indien niet van toepassing."]
[]
[]
[null,"In te vullen parameters",null,null,null,null,"Resultaten (automatisch berekend)",null,null,null,"Investeringskosten mogen overschreven worden door een offerteprijs indien de offerteprijs sterk afwijkt. Gelieve hieronder het offertebedrag op te geven en de offerte mee door te sturen als bijlage (pdf)"]
[null,"Parameter","Eenheid","Waarde (invul)","Toelichting / guidance",null,"Output","Waarde","Eenheid"]
[null,"Oppervlakte (geïsoleerd)","m²",null,"Netto oppervlak waarop de maatregel wordt toegepast.",null,"Investeringskost",{"$f":"(D14*D19)+D20","v":0},"€",null,"Offertekost, investering (optioneel)",null,null,null,null,"€"]
[null,"U-waarde bestaand","W/m²K",null,"Huidige U-waarde (of schatting).",null,"Jaarlijkse kostenbesparing",{"$f":"((IF(D17=\"Elektriciteit\",(IF(D18>0,(MAX((D15-D16)*D14*D23*24/1000*1,0))/D18,0)),0))*ELEC_PRICE)+((IF(D17=\"Elektriciteit\",0,(IF(D18>0,(MAX((D15-D16)*D14*D23*24/1000*1,0))/D18,0))))*(IFERROR(VLOOKUP(D17,CARRIER_TABLE,2,FALSE),0))+D21)","v":0},"€/jaar",null,"Ik wens de investeringskost te overschrijden"]
[null,"U-waarde nieuw","W/m²K",null,"Beoogde U-waarde na maatregel.",null,"Jaarlijkse CO₂-besparing",{"$f":"(((IF(D17=\"Elektriciteit\",(IF(D18>0,(MAX((D15-D16)*D14*D23*24/1000*1,0))/D18,0)),0))*ELEC_CO2)+((IF(D17=\"Elektriciteit\",0,(IF(D18>0,(MAX((D15-D16)*D14*D23*24/1000*1,0))/D18,0))))*(IFERROR(VLOOKUP(D17,CARRIER_TABLE,3,FALSE),0))))/1000","v":0},"tCO₂/jaar"]
[null,"Energiedrager verwarming","-",null,"Kies energiedrager van de huidige verwarming.",null,"Elektriciteitsbesparing",{"$f":"IF(D17=\"Elektriciteit\",IF(D18>0,(MAX((D15-D16)*D14*D23*24/1000*1,0))/D18,0),0)","v":0},"kWh/jaar"]
[null,"Rendement bestaande installatie (η)","-",null,"0-1 (bv. ketelrendement).",null,"Brandstofbesparing (gas/olie/warmtenet)",{"$f":"IF(D17=\"Elektriciteit\",0,(IF(D18>0,(MAX((D15-D16)*D14*D23*24/1000*1,0))/D18,0)))","v":0},"kWh/jaar"]
[null,"Kost per m² (indicatief)","€/m²",null,"Investeringskost per m² (materiaal + plaatsing)."]
[null,"Vaste kosten (bv. werf/steigers)","€",null,"Eenmalige vaste kosten."]
[null,"Overige jaarlijkse besparing (optioneel)","€/jaar",null,"Bv. onderhoudsbesparing."]
[]
[null,"Graaddagen","K·dagen/jaar",{"$f":"HDD","v":2187},"Standaard via tab 'Assumpties'."]
[]
[]
[null,"Grafiek: cumulatieve cashflow (indicatieve terugverdientijd)"]
[null,null,null,null,null,null,null,null,null,"Jaar","Cashflow","Cumulatief"]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(J28<=N_YEARS,IF(J28=0,-H14,H15),NA())","v":0},{"$f":"IF(ISNA(K28),NA(),K28)","v":0}]
[null,null,null,null,null,null,null,null,null,1,{"$f":"IF(J29<=N_YEARS,IF(J29=0,-H14,H15),NA())","v":0},{"$f":"IF(ISNA(K29),NA(),L28+K29)","v":0}]
[null,null,null,null,null,null,null,null,null,2,{"$f":"IF($J30<=N_YEARS,IF($J$30=0,-$H$14,$K29*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,3,0,0]
[null,null,null,null,null,null,null,null,null,4,0,0]
[null,null,null,null,null,null,null,null,null,5,0,0]
[null,null,null,null,null,null,null,null,null,6,0,0]
[null,null,null,null,null,null,null,null,null,7,0,0]
[null,null,null,null,null,null,null,null,null,8,0,0]
[null,null,null,null,null,null,null,null,null,9,0,0]
[null,null,null,null,null,null,null,null,null,10,0,0]
[null,null,null,null,null,null,null,null,null,11,0,0]
[null,null,null,null,null,null,null,null,null,12,0,0]
[null,null,null,null,null,null,null,null,null,13,0,0]
[null,null,null,null,null,null,null,null,null,14,0,0]
[null,null,null,null,null,null,null,null,null,15,0,0]
[null,null,null,null,null,null,null,null,null,16,0,0]
[null,null,null,null,null,null,null,null,null,17,0,0]
[null,null,null,null,null,null,null,null,null,18,0,0]
[null,null,null,null,null,null,null,null,null,19,0,0]
[null,null,null,null,null,null,null,null,null,20,0,0]
[null,null,null,null,null,null,null,null,null,21,0,0]
[null,null,null,null,null,null,null,null,null,22,0,0]
[null,null,null,null,null,null,null,null,null,23,0,0]
[null,null,null,null,null,null,null,null,null,24,0,0]
[null,null,null,null,null,null,null,null,null,25,0,0]
[null,null,null,null,null,null,null,null,null,26,0,0]
[null,null,null,null,null,null,null,null,null,27,0,0]
[null,null,null,null,null,null,null,null,null,28,0,0]
[null,null,null,null,null,null,null,null,null,29,0,0]
[null,null,null,null,null,null,null,null,null,30,0,0]
[null,null,null,null,null,null,null,null,null,31,0,0]
[null,null,null,null,null,null,null,null,null,32,0,0]
[null,null,null,null,null,null,null,null,null,33,0,0]
[null,null,null,null,null,null,null,null,null,34,{"$f":"IF($J62<=N_YEARS,IF($J$30=0,-$H$14,$K61*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,35,0,0]
[null,null,null,null,null,null,null,null,null,36,0,0]
[null,null,null,null,null,null,null,null,null,37,0,0]
[null,null,null,null,null,null,null,null,null,38,0,0]
[null,null,null,null,null,null,null,null,null,39,0,0]
[null,null,null,null,null,null,null,null,null,40,0,0]
[null,null,null,null,null,null,null,null,null,41,0,0]
[null,null,null,null,null,null,null,null,null,42,0,0]
[null,null,null,null,null,null,null,null,null,43,0,0]
[null,null,null,null,null,null,null,null,null,44,0,0]
[null,null,null,null,null,null,null,null,null,45,0,0]
[null,null,null,null,null,null,null,null,null,46,0,0]
[null,null,null,null,null,null,null,null,null,47,0,0]
[null,null,null,null,null,null,null,null,null,48,0,0]
[null,null,null,null,null,null,null,null,null,49,0,0]
[null,null,null,null,null,null,null,null,null,50,0,0]

{"sheet":"Schrijnwerkrenovatie","index":5,"n_rows":78,"n_cols":16,"rows_kept":78,"cut":false,"hidden":true,"merged":[[21,1,21,4],[25,1,25,4],[11,10,12,15],[13,10,13,11],[13,12,13,14],[14,10,14,11],[14,12,14,14],[0,1,0,8],[11,1,11,4],[11,6,11,8],[2,1,2,3],[3,2,3,3],[4,2,4,3],[6,1,7,1],[6,2,7,3],[8,2,8,3],[8,4,8,8],[5,2,5,3],[5,4,5,8]]}
[null,"Schrijnwerkrenovatie"]
[]
[null,"Maatregelspecifieke gegevens"]
[null,"Werktitel Maatregel"]
[null,"Referentiecode maatregel Terra:"]
[null,"Referentiecode Portaal Energie-Efficiëntie*",null,null,"*Geef de referrentiecode van het EE-portaal van deze aanvraag. Geef 0 in indien niet van toepassing."]
[null,"Bijkomende uitleg/ opmerkingen:"]
[]
[null,"Subsidiesteun reeds ontvangen*",null,null,"*geef aan voor welk bedrag (€) u reeds elders subsidiesteun ontving of zal ontvangen voor deze maatregel. Geef 0 in indien niet van toepassing."]
[]
[]
[null,"In te vullen parameters",null,null,null,null,"Resultaten (automatisch berekend)",null,null,null,"Investeringskosten mogen overschreven worden door een offerteprijs indien de offerteprijs sterk afwijkt. Gelieve hieronder het offertebedrag op te geven en de offerte mee door te sturen als bijlage (pdf)"]
[null,"Parameter","Eenheid",null,"Toelichting / guidance",null,"Output","Waarde","Eenheid"]
[null,"Oppervlakte (geïsoleerd)","m²",null,"Netto oppervlak waarop de maatregel wordt toegepast.",null,"Investeringskost",{"$f":"(D14*D19)+D20","v":0},"€",null,"Offertekost, investering (optioneel)",null,null,null,null,"€"]
[null,"U-waarde bestaand","W/m²K",null,"Huidige U-waarde (of schatting).",null,"Jaarlijkse kostenbesparing",{"$f":"((IF(D17=\"Elektriciteit\",(IF(D18>0,(MAX((D15-D16)*D14*D23*24/1000*1,0))/D18,0)),0))*ELEC_PRICE)+((IF(D17=\"Elektriciteit\",0,(IF(D18>0,(MAX((D15-D16)*D14*D23*24/1000*1,0))/D18,0))))*(IFERROR(VLOOKUP(D17,CARRIER_TABLE,2,FALSE),0))+D21)","v":0},"€/jaar",null,"Ik wens de investeringskost te overschrijden"]
[null,"U-waarde nieuw","W/m²K",null,"Beoogde U-waarde na maatregel.",null,"Jaarlijkse CO₂-besparing",{"$f":"(((IF(D17=\"Elektriciteit\",(IF(D18>0,(MAX((D15-D16)*D14*D23*24/1000*1,0))/D18,0)),0))*ELEC_CO2)+((IF(D17=\"Elektriciteit\",0,(IF(D18>0,(MAX((D15-D16)*D14*D23*24/1000*1,0))/D18,0))))*(IFERROR(VLOOKUP(D17,CARRIER_TABLE,3,FALSE),0))))/1000","v":0},"tCO₂/jaar"]
[null,"Energiedrager verwarming","-",null,"Kies energiedrager van de huidige verwarming.",null,"Elektriciteitsbesparing",{"$f":"IF(D17=\"Elektriciteit\",IF(D18>0,(MAX((D15-D16)*D14*D23*24/1000*1,0))/D18,0),0)","v":0},"kWh/jaar"]
[null,"Rendement bestaande installatie (η)","-",null,"0-1 (bv. ketelrendement).",null,"Brandstofbesparing (gas/olie/warmtenet)",{"$f":"IF(D17=\"Elektriciteit\",0,(IF(D18>0,(MAX((D15-D16)*D14*D23*24/1000*1,0))/D18,0)))","v":0},"kWh/jaar"]
[null,"Kost per m² (indicatief)","€/m²",null,"Investeringskost per m² (materiaal + plaatsing)."]
[null,"Vaste kosten (bv. werf/steigers)","€",null,"Eenmalige vaste kosten."]
[null,"Overige jaarlijkse besparing (optioneel)","€/jaar",null,"Bv. onderhoudsbesparing."]
[]
[null,"Graaddagen","K·dagen/jaar",{"$f":"HDD","v":2187},"Standaard via tab 'Assumpties'."]
[]
[]
[null,"Grafiek: cumulatieve cashflow (indicatieve terugverdientijd)"]
[null,null,null,null,null,null,null,null,null,"Jaar","Cashflow","Cumulatief"]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(J28<=N_YEARS,IF(J28=0,-H14,H15),NA())","v":0},{"$f":"IF(ISNA(K28),NA(),K28)","v":0}]
[null,null,null,null,null,null,null,null,null,1,{"$f":"IF(J29<=N_YEARS,IF(J29=0,-H14,H15),NA())","v":0},{"$f":"IF(ISNA(K29),NA(),L28+K29)","v":0}]
[null,null,null,null,null,null,null,null,null,2,{"$f":"IF($J30<=N_YEARS,IF($J$30=0,-$H$14,$K29*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,3,0,0]
[null,null,null,null,null,null,null,null,null,4,0,0]
[null,null,null,null,null,null,null,null,null,5,0,0]
[null,null,null,null,null,null,null,null,null,6,0,0]
[null,null,null,null,null,null,null,null,null,7,0,0]
[null,null,null,null,null,null,null,null,null,8,0,0]
[null,null,null,null,null,null,null,null,null,9,0,0]
[null,null,null,null,null,null,null,null,null,10,0,0]
[null,null,null,null,null,null,null,null,null,11,0,0]
[null,null,null,null,null,null,null,null,null,12,0,0]
[null,null,null,null,null,null,null,null,null,13,0,0]
[null,null,null,null,null,null,null,null,null,14,0,0]
[null,null,null,null,null,null,null,null,null,15,0,0]
[null,null,null,null,null,null,null,null,null,16,0,0]
[null,null,null,null,null,null,null,null,null,17,0,0]
[null,null,null,null,null,null,null,null,null,18,0,0]
[null,null,null,null,null,null,null,null,null,19,0,0]
[null,null,null,null,null,null,null,null,null,20,0,0]
[null,null,null,null,null,null,null,null,null,21,0,0]
[null,null,null,null,null,null,null,null,null,22,0,0]
[null,null,null,null,null,null,null,null,null,23,0,0]
[null,null,null,null,null,null,null,null,null,24,0,0]
[null,null,null,null,null,null,null,null,null,25,0,0]
[null,null,null,null,null,null,null,null,null,26,0,0]
[null,null,null,null,null,null,null,null,null,27,0,0]
[null,null,null,null,null,null,null,null,null,28,0,0]
[null,null,null,null,null,null,null,null,null,29,0,0]
[null,null,null,null,null,null,null,null,null,30,0,0]
[null,null,null,null,null,null,null,null,null,31,0,0]
[null,null,null,null,null,null,null,null,null,32,0,0]
[null,null,null,null,null,null,null,null,null,33,0,0]
[null,null,null,null,null,null,null,null,null,34,{"$f":"IF($J62<=N_YEARS,IF($J$30=0,-$H$14,$K61*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,35,0,0]
[null,null,null,null,null,null,null,null,null,36,0,0]
[null,null,null,null,null,null,null,null,null,37,0,0]
[null,null,null,null,null,null,null,null,null,38,0,0]
[null,null,null,null,null,null,null,null,null,39,0,0]
[null,null,null,null,null,null,null,null,null,40,0,0]
[null,null,null,null,null,null,null,null,null,41,0,0]
[null,null,null,null,null,null,null,null,null,42,0,0]
[null,null,null,null,null,null,null,null,null,43,0,0]
[null,null,null,null,null,null,null,null,null,44,0,0]
[null,null,null,null,null,null,null,null,null,45,0,0]
[null,null,null,null,null,null,null,null,null,46,0,0]
[null,null,null,null,null,null,null,null,null,47,0,0]
[null,null,null,null,null,null,null,null,null,48,0,0]
[null,null,null,null,null,null,null,null,null,49,0,0]
[null,null,null,null,null,null,null,null,null,50,0,0]

{"sheet":"Regeltechnisch","index":6,"n_rows":78,"n_cols":16,"rows_kept":78,"cut":false,"hidden":true,"merged":[[11,10,12,15],[13,10,13,11],[13,12,13,14],[14,10,14,11],[14,12,14,14],[26,1,26,4],[11,6,11,8],[11,1,11,4],[0,1,0,8],[2,1,2,3],[3,2,3,3],[4,2,4,3],[6,1,7,1],[6,2,7,3],[8,2,8,3],[8,4,8,8],[5,2,5,3],[5,4,5,8]]}
[null,"Regeltechnisch (sturing & optimalisatie)"]
[]
[null,"Maatregelspecifieke gegevens"]
[null,"Werktitel Maatregel"]
[null,"Referentiecode maatregel Terra:"]
[null,"Referentiecode Portaal Energie-Efficiëntie*",null,null,"*Geef de referrentiecode van het EE-portaal van deze aanvraag. Geef 0 in indien niet van toepassing."]
[null,"Bijkomende uitleg/ opmerkingen:"]
[]
[null,"Subsidiesteun reeds ontvangen*",0,null,"*geef aan voor welk bedrag (€) u reeds elders subsidiesteun ontving of zal ontvangen voor deze maatregel. Geef 0 in indien niet van toepassing."]
[]
[]
[null,"In te vullen parameters",null,null,null,null,"Resultaten (automatisch berekend)",null,null,null,"Investeringskosten mogen overschreven worden door een offerteprijs indien de offerteprijs sterk afwijkt. Gelieve hieronder het offertebedrag op te geven en de offerte mee door te sturen als bijlage (pdf)"]
[null,"Parameter","Eenheid","Waarde (invul)","Toelichting / guidance",null,"Output","Waarde","Eenheid"]
[null,"Baseline brandstofverbruik verwarming","kWh/jaar",null,"Referentie brandstofverbruik.",null,"Investeringskost",{"$f":"D19","v":0},"€",null,"Offertekost, investering (optioneel)",null,null,null,null,"€"]
[null,"Energiedrager brandstof","-",null,"Brandstof voor verwarming.",null,"Jaarlijkse kostenbesparing",{"$f":"((D16*D18)*ELEC_PRICE)+((D14*D17)*(IFERROR(VLOOKUP(D15,CARRIER_TABLE,2,FALSE),0)))-D20","v":0},"€/jaar",null,"Ik wens de investeringskost te overschrijden"]
[null,"Baseline elektriciteitsverbruik HVAC ","kWh/jaar",null,"Bv. pompen/ventilatie/koeling.",null,"Jaarlijkse CO₂-besparing",{"$f":"(((D16*D18)*ELEC_CO2)+((D14*D17)*(IFERROR(VLOOKUP(D15,CARRIER_TABLE,3,FALSE),0))))/1000","v":0},"tCO₂/jaar"]
[null,"Verwachte besparing brandstof","%",null,null,null,"Elektriciteitsbesparing",{"$f":"D16*D18","v":0},"kWh/jaar"]
[null,"Verwachte besparing elektriciteit","%",null,null,null,"Brandstofbesparing (gas/olie/warmtenet)",{"$f":"D14*D17","v":0},"kWh/jaar"]
[null,"Investeringskost","€",null,"Eenmalige kost voor regeltechniek."]
[null,"Jaarlijkse onderhoud/licentie (optioneel)","€/jaar",null,"Wordt afgetrokken van de besparing."]
[]
[]
[]
[]
[]
[]
[null,"Grafiek: cumulatieve cashflow (indicatieve terugverdientijd)",null,null,null,null,null,null,null,"Jaar","Cashflow","Cumulatief"]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(J28<=N_YEARS,IF(J28=0,-H14,H15),NA())","v":0},{"$f":"IF(ISNA(K28),NA(),K28)","v":0}]
[null,null,null,null,null,null,null,null,null,1,{"$f":"IF(J29<=N_YEARS,IF(J29=0,-H14,H15),NA())","v":0},{"$f":"IF(ISNA(K29),NA(),L28+K29)","v":0}]
[null,null,null,null,null,null,null,null,null,2,{"$f":"IF($J30<=N_YEARS,IF($J$30=0,-$H$14,$K29*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,3,0,0]
[null,null,null,null,null,null,null,null,null,4,0,0]
[null,null,null,null,null,null,null,null,null,5,0,0]
[null,null,null,null,null,null,null,null,null,6,0,0]
[null,null,null,null,null,null,null,null,null,7,0,0]
[null,null,null,null,null,null,null,null,null,8,0,0]
[null,null,null,null,null,null,null,null,null,9,0,0]
[null,null,null,null,null,null,null,null,null,10,0,0]
[null,null,null,null,null,null,null,null,null,11,0,0]
[null,null,null,null,null,null,null,null,null,12,0,0]
[null,null,null,null,null,null,null,null,null,13,0,0]
[null,null,null,null,null,null,null,null,null,14,0,0]
[null,null,null,null,null,null,null,null,null,15,0,0]
[null,null,null,null,null,null,null,null,null,16,0,0]
[null,null,null,null,null,null,null,null,null,17,0,0]
[null,null,null,null,null,null,null,null,null,18,0,0]
[null,null,null,null,null,null,null,null,null,19,0,0]
[null,null,null,null,null,null,null,null,null,20,0,0]
[null,null,null,null,null,null,null,null,null,21,0,{"$f":"IF(ISNA(K49),NA(),L48+K49)","v":0}]
[null,null,null,null,null,null,null,null,null,22,0,0]
[null,null,null,null,null,null,null,null,null,23,0,0]
[null,null,null,null,null,null,null,null,null,24,0,0]
[null,null,null,null,null,null,null,null,null,25,0,0]
[null,null,null,null,null,null,null,null,null,26,0,0]
[null,null,null,null,null,null,null,null,null,27,0,0]
[null,null,null,null,null,null,null,null,null,28,0,0]
[null,null,null,null,null,null,null,null,null,29,0,0]
[null,null,null,null,null,null,null,null,null,30,0,0]
[null,null,null,null,null,null,null,null,null,31,0,0]
[null,null,null,null,null,null,null,null,null,32,0,0]
[null,null,null,null,null,null,null,null,null,33,0,0]
[null,null,null,null,null,null,null,null,null,34,{"$f":"IF($J62<=N_YEARS,IF($J$30=0,-$H$14,$K61*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,35,0,0]
[null,null,null,null,null,null,null,null,null,36,0,0]
[null,null,null,null,null,null,null,null,null,37,0,0]
[null,null,null,null,null,null,null,null,null,38,0,0]
[null,null,null,null,null,null,null,null,null,39,0,0]
[null,null,null,null,null,null,null,null,null,40,0,0]
[null,null,null,null,null,null,null,null,null,41,0,0]
[null,null,null,null,null,null,null,null,null,42,0,0]
[null,null,null,null,null,null,null,null,null,43,0,0]
[null,null,null,null,null,null,null,null,null,44,0,0]
[null,null,null,null,null,null,null,null,null,45,0,0]
[null,null,null,null,null,null,null,null,null,46,0,0]
[null,null,null,null,null,null,null,null,null,47,0,0]
[null,null,null,null,null,null,null,null,null,48,0,0]
[null,null,null,null,null,null,null,null,null,49,0,0]
[null,null,null,null,null,null,null,null,null,50,0,0]

{"sheet":"Relighting","index":7,"n_rows":77,"n_cols":16,"rows_kept":77,"cut":false,"hidden":true,"merged":[[11,10,12,15],[13,10,13,11],[13,12,13,14],[14,10,14,11],[14,12,14,14],[25,1,25,4],[11,6,11,8],[11,1,11,4],[0,1,0,8],[2,1,2,3],[3,2,3,3],[4,2,4,3],[6,1,7,1],[6,2,7,3],[8,2,8,3],[8,4,8,8],[5,2,5,3],[5,4,5,8]]}
[null,"Relighting (LED / armaturen)"]
[null,"²²²"]
[null,"Maatregelspecifieke gegevens"]
[null,"Werktitel Maatregel"]
[null,"Referentiecode maatregel Terra:"]
[null,"Referentiecode Portaal Energie-Efficiëntie*",null,null,"*Geef de referrentiecode van het EE-portaal van deze aanvraag. Geef 0 in indien niet van toepassing."]
[null,"Bijkomende uitleg/ opmerkingen:"]
[]
[null,"Subsidiesteun reeds ontvangen*",null,null,"*geef aan voor welk bedrag (€) u reeds elders subsidiesteun ontving of zal ontvangen voor deze maatregel. Geef 0 in indien niet van toepassing."]
[]
[]
[null,"In te vullen parameters",null,null,null,null,"Resultaten (automatisch berekend)",null,null,null,"Investeringskosten mogen overschreven worden door een offerteprijs indien de offerteprijs sterk afwijkt. Gelieve hieronder het offertebedrag op te geven en de offerte mee door te sturen als bijlage (pdf)"]
[null,"Parameter","Eenheid","Waarde (invul)","Toelichting / guidance",null,"Output","Waarde","Eenheid"]
[null,"Aantal armaturen","st",null,"Totaal aantal te vervangen armaturen.",null,"Investeringskost",{"$f":"(D14*D18)+D19","v":0},"€",null,"Offertekost, investering (optioneel)",null,null,null,null,"€"]
[null,"Vermogen oud per armatuur (inclusief ballast)","W",null,"Nominaal vermogen van huidige armatuur/bron.",null,"Jaarlijkse kostenbesparing",{"$f":"((MAX((D15-D16)*D14*D17/1000,0))*ELEC_PRICE)+D20","v":0},"€/jaar",null,"Ik wens de investeringskost te overschrijden"]
[null,"Vermogen nieuw per armatuur (inclusief driver)","W",null,"Nominaal vermogen nieuwe armatuur/bron.",null,"Elektriciteitsbesparing",{"$f":"MAX((D15-D16)*D14*D17/1000,0)","v":0},"kWh/jaar"]
[null,"Branduren per jaar","uur/jaar",null,"Uren dat verlichting gemiddeld brandt per jaar."]
[null,"Kost per armatuur (incl. plaatsing)","€/st",null,"Investeringskost per stuk."]
[null,"Vaste installatiekosten","€",null,"Eenmalige vaste kosten."]
[null,"Onderhoudsbesparing (optioneel)","€/jaar",null,"Bv. minder lampvervanging."]
[]
[]
[]
[]
[]
[null,"Grafiek: cumulatieve cashflow (indicatieve terugverdientijd)",null,null,null,null,null,null,null,"Jaar","Cashflow","Cumulatief"]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(J27<=N_YEARS,IF(J27=0,-H14,H15),NA())","v":0},{"$f":"IF(ISNA(K27),NA(),K27)","v":0}]
[null,null,null,null,null,null,null,null,null,1,{"$f":"IF(J28<=N_YEARS,IF(J28=0,-H14,H15),NA())","v":0},{"$f":"IF(ISNA(K28),NA(),L27+K28)","v":0}]
[null,null,null,null,null,null,null,null,null,2,{"$f":"IF($J29<=N_YEARS,IF($J$29=0,-$H$14,$K28*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,3,0,0]
[null,null,null,null,null,null,null,null,null,4,0,0]
[null,null,null,null,null,null,null,null,null,5,0,0]
[null,null,null,null,null,null,null,null,null,6,0,0]
[null,null,null,null,null,null,null,null,null,7,0,0]
[null,null,null,null,null,null,null,null,null,8,0,0]
[null,null,null,null,null,null,null,null,null,9,0,0]
[null,null,null,null,null,null,null,null,null,10,0,0]
[null,null,null,null,null,null,null,null,null,11,0,0]
[null,null,null,null,null,null,null,null,null,12,0,0]
[null,null,null,null,null,null,null,null,null,13,0,0]
[null,null,null,null,null,null,null,null,null,14,0,0]
[null,null,null,null,null,null,null,null,null,15,0,0]
[null,null,null,null,null,null,null,null,null,16,0,0]
[null,null,null,null,null,null,null,null,null,17,0,0]
[null,null,null,null,null,null,null,null,null,18,0,0]
[null,null,null,null,null,null,null,null,null,19,0,0]
[null,null,null,null,null,null,null,null,null,20,0,0]
[null,null,null,null,null,null,null,null,null,21,0,{"$f":"IF(ISNA(K48),NA(),L47+K48)","v":0}]
[null,null,null,null,null,null,null,null,null,22,0,0]
[null,null,null,null,null,null,null,null,null,23,0,0]
[null,null,null,null,null,null,null,null,null,24,0,0]
[null,null,null,null,null,null,null,null,null,25,0,0]
[null,null,null,null,null,null,null,null,null,26,0,0]
[null,null,null,null,null,null,null,null,null,27,0,0]
[null,null,null,null,null,null,null,null,null,28,0,0]
[null,null,null,null,null,null,null,null,null,29,0,0]
[null,null,null,null,null,null,null,null,null,30,0,0]
[null,null,null,null,null,null,null,null,null,31,0,0]
[null,null,null,null,null,null,null,null,null,32,0,0]
[null,null,null,null,null,null,null,null,null,33,0,0]
[null,null,null,null,null,null,null,null,null,34,{"$f":"IF($J61<=N_YEARS,IF($J$29=0,-$H$14,$K60*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,35,0,0]
[null,null,null,null,null,null,null,null,null,36,0,0]
[null,null,null,null,null,null,null,null,null,37,0,0]
[null,null,null,null,null,null,null,null,null,38,0,0]
[null,null,null,null,null,null,null,null,null,39,0,0]
[null,null,null,null,null,null,null,null,null,40,0,0]
[null,null,null,null,null,null,null,null,null,41,0,0]
[null,null,null,null,null,null,null,null,null,42,0,0]
[null,null,null,null,null,null,null,null,null,43,0,0]
[null,null,null,null,null,null,null,null,null,44,0,0]
[null,null,null,null,null,null,null,null,null,45,0,0]
[null,null,null,null,null,null,null,null,null,46,0,0]
[null,null,null,null,null,null,null,null,null,47,0,0]
[null,null,null,null,null,null,null,null,null,48,0,0]
[null,null,null,null,null,null,null,null,null,49,0,0]
[null,null,null,null,null,null,null,null,null,50,0,0]

{"sheet":"Warmtepompen en koeling","index":8,"n_rows":78,"n_cols":16,"rows_kept":78,"cut":false,"hidden":true,"merged":[[11,10,12,15],[13,10,13,11],[13,12,13,14],[14,10,14,11],[14,12,14,14],[26,1,26,4],[11,6,11,8],[11,1,11,4],[0,1,0,8],[2,1,2,3],[3,2,3,3],[4,2,4,3],[6,1,7,1],[6,2,7,3],[8,2,8,3],[8,4,8,8],[5,2,5,3],[5,4,5,8]]}
[null,"Warmtepompen & koeling"]
[]
[null,"Maatregelspecifieke gegevens"]
[null,"Werktitel Maatregel"]
[null,"Referentiecode maatregel Terra:"]
[null,"Referentiecode Portaal Energie-Efficiëntie*",null,null,"*Geef de referrentiecode van het EE-portaal van deze aanvraag. Geef 0 in indien niet van toepassing."]
[null,"Bijkomende uitleg/ opmerkingen:"]
[]
[null,"Subsidiesteun reeds ontvangen*",0,null,"*geef aan voor welk bedrag (€) u reeds elders subsidiesteun ontving of zal ontvangen voor deze maatregel. Geef 0 in indien niet van toepassing."]
[]
[]
[null,"In te vullen parameters",null,null,null,null,"Resultaten (automatisch berekend)",null,null,null,"Investeringskosten mogen overschreven worden door een offerteprijs indien de offerteprijs sterk afwijkt. Gelieve hieronder het offertebedrag op te geven en de offerte mee door te sturen als bijlage (pdf)"]
[null,"Parameter","Eenheid","Waarde (invul)","Toelichting / guidance",null,"Output","Waarde","Eenheid"]
[null,"Jaarlijkse nuttige warmtebehoefte","kWh_th/jaar",null,"Bv. uit audit of berekend.",null,"Investeringskost",{"$f":"D21","v":0},"€",null,"Offertekost, investering (optioneel)",null,null,null,null,"€"]
[null,"Huidige energiedrager verwarming","-",null,"Huidige energiedrager.",null,"Jaarlijkse kostenbesparing",{"$f":"(IF(D15=\"Elektriciteit\",0,IF(D16>0,D14/D16,0)))*IFERROR(VLOOKUP(D15,CARRIER_TABLE,2,FALSE),0)+((IF(D15=\"Elektriciteit\",IF(D16>0,D14/D16,0),0)+IF(D19>0,D18/D19,0)-(IF(D17>0,D14/D17,0)+IF(D20>0,D18/D20,0)))*ELEC_PRICE)-D22","v":0},"€/jaar",null,"Ik wens de investeringskost te overschrijden",null,"Nee"]
[null,"Huidig rendement (η_old)","-",null,"0-1 (bv. ketelrendement).",null,"Jaarlijkse CO₂-besparing",{"$f":"(((IF(D15=\"Elektriciteit\",0,(IF(D16>0,D14/D16,0))))*(IFERROR(VLOOKUP(D15,CARRIER_TABLE,3,FALSE),0)))+((((IF(D15=\"Elektriciteit\",(IF(D16>0,D14/D16,0)),0))+(IF(D19>0,D18/D19,0)))-((IF(D17>0,D14/D17,0))+(IF(D20>0,D18/D20,0))))*ELEC_CO2))/1000","v":0},"tCO₂/jaar"]
[null,"Nieuwe SCOP (seasonal-COP)","-",null,"Dimensieloos (typisch 2,5-4,5).",null,"Elektriciteitsbesparing",{"$f":"((IF(D15=\"Elektriciteit\",(IF(D16>0,D14/D16,0)),0))+(IF(D19>0,D18/D19,0)))-((IF(D17>0,D14/D17,0))+(IF(D20>0,D18/D20,0)))","v":0},"kWh/jaar"]
[null,"Jaarlijkse nuttige koelbehoefte (optioneel)","kWh_th/jaar",null,"Gebruik 0 indien niet van toepassing.",null,"Brandstofbesparing",{"$f":"IF(D15=\"Elektriciteit\",0,IF(D16>0,D14/D16,0))","v":0},"kWh/jaar"]
[null,"Huidige SEER/EER koeling (optioneel)","-",null,"Gebruik 0 indien onbekend / niet van toepassing."]
[null,"Nieuwe SEER koeling (optioneel)","-",null,"Gebruik 0 indien niet van toepassing."]
[null,"Investeringskost","€",null,"Totale investering (incl. bron/afgifte)."]
[null,"Jaarlijkse onderhouds-/energiecomponent (Δ)","€/jaar",null,"Extra jaarlijkse kosten (optioneel)"]
[null,"Bruto Vloeroppervlakte (BVO)","m²"]
[]
[]
[]
[null,"Grafiek: cumulatieve cashflow (indicatieve terugverdientijd)",null,null,null,null,null,null,null,"Jaar","Cashflow","Cumulatief"]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(J28<=N_YEARS,IF(J28=0,-H14,H15),NA())","v":0},{"$f":"IF(ISNA(K28),NA(),K28)","v":0}]
[null,null,null,null,null,null,null,null,null,1,{"$f":"IF(J29<=N_YEARS,IF(J29=0,-H14,H15),NA())","v":0},{"$f":"IF(ISNA(K29),NA(),L28+K29)","v":0}]
[null,null,null,null,null,null,null,null,null,2,{"$f":"IF($J30<=N_YEARS,IF($J$30=0,-$H$14,$K29*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,3,0,0]
[null,null,null,null,null,null,null,null,null,4,0,0]
[null,null,null,null,null,null,null,null,null,5,0,0]
[null,null,null,null,null,null,null,null,null,6,0,0]
[null,null,null,null,null,null,null,null,null,7,0,0]
[null,null,null,null,null,null,null,null,null,8,0,0]
[null,null,null,null,null,null,null,null,null,9,0,0]
[null,null,null,null,null,null,null,null,null,10,0,0]
[null,null,null,null,null,null,null,null,null,11,0,0]
[null,null,null,null,null,null,null,null,null,12,0,0]
[null,null,null,null,null,null,null,null,null,13,0,0]
[null,null,null,null,null,null,null,null,null,14,0,0]
[null,null,null,null,null,null,null,null,null,15,0,0]
[null,null,null,null,null,null,null,null,null,16,0,0]
[null,null,null,null,null,null,null,null,null,17,0,0]
[null,null,null,null,null,null,null,null,null,18,0,0]
[null,null,null,null,null,null,null,null,null,19,0,0]
[null,null,null,null,null,null,null,null,null,20,0,0]
[null,null,null,null,null,null,null,null,null,21,0,{"$f":"IF(ISNA(K49),NA(),L48+K49)","v":0}]
[null,null,null,null,null,null,null,null,null,22,0,0]
[null,null,null,null,null,null,null,null,null,23,0,0]
[null,null,null,null,null,null,null,null,null,24,0,0]
[null,null,null,null,null,null,null,null,null,25,0,0]
[null,null,null,null,null,null,null,null,null,26,0,0]
[null,null,null,null,null,null,null,null,null,27,0,0]
[null,null,null,null,null,null,null,null,null,28,0,0]
[null,null,null,null,null,null,null,null,null,29,0,0]
[null,null,null,null,null,null,null,null,null,30,0,0]
[null,null,null,null,null,null,null,null,null,31,0,0]
[null,null,null,null,null,null,null,null,null,32,0,0]
[null,null,null,null,null,null,null,null,null,33,0,0]
[null,null,null,null,null,null,null,null,null,34,{"$f":"IF($J62<=N_YEARS,IF($J$30=0,-$H$14,$K61*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,35,0,0]
[null,null,null,null,null,null,null,null,null,36,0,0]
[null,null,null,null,null,null,null,null,null,37,0,0]
[null,null,null,null,null,null,null,null,null,38,0,0]
[null,null,null,null,null,null,null,null,null,39,0,0]
[null,null,null,null,null,null,null,null,null,40,0,0]
[null,null,null,null,null,null,null,null,null,41,0,0]
[null,null,null,null,null,null,null,null,null,42,0,0]
[null,null,null,null,null,null,null,null,null,43,0,0]
[null,null,null,null,null,null,null,null,null,44,0,0]
[null,null,null,null,null,null,null,null,null,45,0,0]
[null,null,null,null,null,null,null,null,null,46,0,0]
[null,null,null,null,null,null,null,null,null,47,0,0]
[null,null,null,null,null,null,null,null,null,48,0,0]
[null,null,null,null,null,null,null,null,null,49,0,0]
[null,null,null,null,null,null,null,null,null,50,0,0]

{"sheet":"Warmtenetkoppeling","index":9,"n_rows":75,"n_cols":12,"rows_kept":75,"cut":false,"hidden":true,"merged":[[22,1,22,4],[10,4,10,8],[4,1,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[7,4,7,8],[0,1,0,8],[13,1,13,3],[2,1,2,8],[8,1,9,1],[8,2,9,3],[10,2,10,3]]}
[null,"Warmtenetkoppeling"]
[]
[null,"Kosten en besparingen van warmtenetkoppelingen kunnen sterk uiteenlopend zijn. De uitkomsten zijn sterk afhankelijk van situationele paramaters.\nOm die reden is er geen standaardberekeningsmethode voorzien. Gelieve de resultatentabel zelf in te vullen en staving (offerte + besparingsberekeningen) als bijlage (pdf) mee aan te leveren."]
[]
[null,"Maatregelspecifieke gegevens"]
[null,"Werktitel Maatregel"]
[null,"Referentiecode maatregel Terra:"]
[null,"Referentiecode Portaal Energie-Efficiëntie*",null,null,"*Geef de referrentiecode van het EE-portaal van deze aanvraag. Geef 0 in indien niet van toepassing."]
[null,"Bijkomende uitleg/ opmerkingen:"]
[]
[null,"Subsidiesteun reeds ontvangen*",null,null,"*geef aan voor welk bedrag (€) u reeds elders subsidiesteun ontving of zal ontvangen voor deze maatregel. Geef 0 in indien niet van toepassing."]
[]
[]
[null,"Resultaten (in te vullen)"]
[null,"Parameter","Waarde","Eenheid"]
[null,"Investeringskost",null,"€"]
[null,"Jaarlijkse kostenbesparing",null,"€/jaar"]
[null,"Jaarlijkse CO₂-besparing",null,"tCO₂/jaar"]
[null,"Elektriciteitsbesparing",null,"kWh/jaar"]
[null,"Brandstofbesparing (gas/olie)",null,"kWh/jaar"]
[]
[]
[null,"Grafiek: cumulatieve cashflow (indicatieve terugverdientijd)"]
[null,null,null,null,null,null,null,null,null,"Jaar","Cashflow","Cumulatief"]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(J25<=N_YEARS,IF(J25=0,-C16,C17),NA())","v":0},{"$f":"IF(ISNA(K25),NA(),K25)","v":0}]
[null,null,null,null,null,null,null,null,null,1,{"$f":"IF(J26<=N_YEARS,IF(J26=0,-C16,C17),NA())","v":0},{"$f":"IF(ISNA(K26),NA(),L25+K26)","v":0}]
[null,null,null,null,null,null,null,null,null,2,{"$f":"IF($J27<=N_YEARS,IF($J$27=0,-$C$16,$K26*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,3,0,0]
[null,null,null,null,null,null,null,null,null,4,0,0]
[null,null,null,null,null,null,null,null,null,5,0,0]
[null,null,null,null,null,null,null,null,null,6,0,0]
[null,null,null,null,null,null,null,null,null,7,0,0]
[null,null,null,null,null,null,null,null,null,8,0,0]
[null,null,null,null,null,null,null,null,null,9,0,0]
[null,null,null,null,null,null,null,null,null,10,0,0]
[null,null,null,null,null,null,null,null,null,11,0,0]
[null,null,null,null,null,null,null,null,null,12,0,0]
[null,null,null,null,null,null,null,null,null,13,0,0]
[null,null,null,null,null,null,null,null,null,14,0,0]
[null,null,null,null,null,null,null,null,null,15,0,0]
[null,null,null,null,null,null,null,null,null,16,0,0]
[null,null,null,null,null,null,null,null,null,17,0,0]
[null,null,null,null,null,null,null,null,null,18,0,0]
[null,null,null,null,null,null,null,null,null,19,0,0]
[null,null,null,null,null,null,null,null,null,20,0,0]
[null,null,null,null,null,null,null,null,null,21,0,0]
[null,null,null,null,null,null,null,null,null,22,0,0]
[null,null,null,null,null,null,null,null,null,23,0,0]
[null,null,null,null,null,null,null,null,null,24,0,0]
[null,null,null,null,null,null,null,null,null,25,0,0]
[null,null,null,null,null,null,null,null,null,26,0,0]
[null,null,null,null,null,null,null,null,null,27,0,0]
[null,null,null,null,null,null,null,null,null,28,0,0]
[null,null,null,null,null,null,null,null,null,29,0,0]
[null,null,null,null,null,null,null,null,null,30,0,0]
[null,null,null,null,null,null,null,null,null,31,0,0]
[null,null,null,null,null,null,null,null,null,32,0,0]
[null,null,null,null,null,null,null,null,null,33,0,0]
[null,null,null,null,null,null,null,null,null,34,{"$f":"IF($J59<=N_YEARS,IF($J$27=0,-$C$16,$K58*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,35,0,0]
[null,null,null,null,null,null,null,null,null,36,0,0]
[null,null,null,null,null,null,null,null,null,37,0,0]
[null,null,null,null,null,null,null,null,null,38,0,0]
[null,null,null,null,null,null,null,null,null,39,0,0]
[null,null,null,null,null,null,null,null,null,40,0,0]
[null,null,null,null,null,null,null,null,null,41,0,0]
[null,null,null,null,null,null,null,null,null,42,0,0]
[null,null,null,null,null,null,null,null,null,43,0,0]
[null,null,null,null,null,null,null,null,null,44,0,0]
[null,null,null,null,null,null,null,null,null,45,0,0]
[null,null,null,null,null,null,null,null,null,46,0,0]
[null,null,null,null,null,null,null,null,null,47,0,0]
[null,null,null,null,null,null,null,null,null,48,0,0]
[null,null,null,null,null,null,null,null,null,49,0,0]
[null,null,null,null,null,null,null,null,null,50,0,0]

{"sheet":"Flex & Opslag","index":10,"n_rows":75,"n_cols":12,"rows_kept":75,"cut":false,"hidden":true,"merged":[[10,2,10,3],[13,1,13,3],[22,1,22,4],[10,4,10,8],[0,1,0,8],[2,1,2,8],[4,1,4,3],[5,2,5,3],[6,2,6,3],[8,1,9,1],[8,2,9,3],[7,2,7,3],[7,4,7,8]]}
[null,"Flex & Opslag"]
[]
[null,"Kosten en besparingen van Flex- en Opslagprojecten kunnen sterk uiteenlopend zijn. De uitkomsten zijn sterk afhankelijk van situationele paramaters.\nOm die reden is er geen standaardberekeningsmethode voorzien. Gelieve de resultatentabel zelf in te vullen en staving (offerte + besparingsberekeningen) als bijlage (pdf) mee aan te leveren.\nBij dit type maatregel is het verplicht om het project toe te lichten in \"Bijkomende uitleg/ opmerkingen\""]
[]
[null,"Maatregelspecifieke gegevens"]
[null,"Werktitel Maatregel"]
[null,"Referentiecode maatregel Terra:"]
[null,"Referentiecode Portaal Energie-Efficiëntie*",null,null,"*Geef de referrentiecode van het EE-portaal van deze aanvraag. Geef 0 in indien niet van toepassing."]
[null,"Bijkomende uitleg/ opmerkingen:"]
[]
[null,"Subsidiesteun reeds ontvangen*",null,null,"*geef aan voor welk bedrag (€) u reeds elders subsidiesteun ontving of zal ontvangen voor deze maatregel. Geef 0 in indien niet van toepassing."]
[]
[]
[null,"Resultaten (in te vullen)"]
[null,"Parameter","Waarde","Eenheid"]
[null,"Investeringskost",null,"€"]
[null,"Jaarlijkse kostenbesparing",null,"€/jaar"]
[null,"Jaarlijkse CO₂-besparing",null,"tCO₂/jaar"]
[null,"Elektriciteitsbesparing",null,"kWh/jaar"]
[null,"Brandstofbesparing (gas/olie)",null,"kWh/jaar"]
[]
[]
[null,"Grafiek: cumulatieve cashflow (indicatieve terugverdientijd)"]
[null,null,null,null,null,null,null,null,null,"Jaar","Cashflow","Cumulatief"]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(J25<=N_YEARS,IF(J25=0,-C16,C17),NA())","v":0},{"$f":"IF(ISNA(K25),NA(),K25)","v":0}]
[null,null,null,null,null,null,null,null,null,1,{"$f":"IF(J26<=N_YEARS,IF(J26=0,-C16,C17),NA())","v":0},{"$f":"IF(ISNA(K26),NA(),L25+K26)","v":0}]
[null,null,null,null,null,null,null,null,null,2,{"$f":"IF($J27<=N_YEARS,IF($J$27=0,-$C$16,$K26*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,3,0,0]
[null,null,null,null,null,null,null,null,null,4,0,0]
[null,null,null,null,null,null,null,null,null,5,0,0]
[null,null,null,null,null,null,null,null,null,6,0,0]
[null,null,null,null,null,null,null,null,null,7,0,0]
[null,null,null,null,null,null,null,null,null,8,0,0]
[null,null,null,null,null,null,null,null,null,9,0,0]
[null,null,null,null,null,null,null,null,null,10,0,0]
[null,null,null,null,null,null,null,null,null,11,0,0]
[null,null,null,null,null,null,null,null,null,12,0,0]
[null,null,null,null,null,null,null,null,null,13,0,0]
[null,null,null,null,null,null,null,null,null,14,0,0]
[null,null,null,null,null,null,null,null,null,15,0,0]
[null,null,null,null,null,null,null,null,null,16,0,0]
[null,null,null,null,null,null,null,null,null,17,0,0]
[null,null,null,null,null,null,null,null,null,18,0,0]
[null,null,null,null,null,null,null,null,null,19,0,0]
[null,null,null,null,null,null,null,null,null,20,0,0]
[null,null,null,null,null,null,null,null,null,21,0,0]
[null,null,null,null,null,null,null,null,null,22,0,0]
[null,null,null,null,null,null,null,null,null,23,0,0]
[null,null,null,null,null,null,null,null,null,24,0,0]
[null,null,null,null,null,null,null,null,null,25,0,0]
[null,null,null,null,null,null,null,null,null,26,0,0]
[null,null,null,null,null,null,null,null,null,27,0,0]
[null,null,null,null,null,null,null,null,null,28,0,0]
[null,null,null,null,null,null,null,null,null,29,0,0]
[null,null,null,null,null,null,null,null,null,30,0,0]
[null,null,null,null,null,null,null,null,null,31,0,0]
[null,null,null,null,null,null,null,null,null,32,0,0]
[null,null,null,null,null,null,null,null,null,33,0,0]
[null,null,null,null,null,null,null,null,null,34,{"$f":"IF($J59<=N_YEARS,IF($J$27=0,-$C$16,$K58*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,35,0,0]
[null,null,null,null,null,null,null,null,null,36,0,0]
[null,null,null,null,null,null,null,null,null,37,0,0]
[null,null,null,null,null,null,null,null,null,38,0,0]
[null,null,null,null,null,null,null,null,null,39,0,0]
[null,null,null,null,null,null,null,null,null,40,0,0]
[null,null,null,null,null,null,null,null,null,41,0,0]
[null,null,null,null,null,null,null,null,null,42,0,0]
[null,null,null,null,null,null,null,null,null,43,0,0]
[null,null,null,null,null,null,null,null,null,44,0,0]
[null,null,null,null,null,null,null,null,null,45,0,0]
[null,null,null,null,null,null,null,null,null,46,0,0]
[null,null,null,null,null,null,null,null,null,47,0,0]
[null,null,null,null,null,null,null,null,null,48,0,0]
[null,null,null,null,null,null,null,null,null,49,0,0]
[null,null,null,null,null,null,null,null,null,50,0,0]

{"sheet":"Hernieuwbare Energie","index":11,"n_rows":75,"n_cols":12,"rows_kept":75,"cut":false,"hidden":true,"merged":[[10,2,10,3],[13,1,13,3],[22,1,22,4],[10,4,10,8],[0,1,0,8],[2,1,2,8],[4,1,4,3],[5,2,5,3],[6,2,6,3],[8,1,9,1],[8,2,9,3],[7,2,7,3],[7,4,7,8]]}
[null,"Hernieuwbare Energie"]
[]
[null,"Kosten en besparingen van Hernieuwbare Energie-projecten kunnen sterk uiteenlopend zijn. De uitkomsten zijn sterk afhankelijk van situationele paramaters.\nOm die reden is er geen standaardberekeningsmethode voorzien. Gelieve de resultatentabel zelf in te vullen en staving (offerte + besparingsberekeningen) als bijlage (pdf) mee aan te leveren.\nBij dit type maatregel is het verplicht om het project toe te lichten in \"Bijkomende uitleg/ opmerkingen\""]
[]
[null,"Maatregelspecifieke gegevens"]
[null,"Werktitel Maatregel"]
[null,"Referentiecode maatregel Terra:"]
[null,"Referentiecode Portaal Energie-Efficiëntie*",null,null,"*Geef de referrentiecode van het EE-portaal van deze aanvraag. Geef 0 in indien niet van toepassing."]
[null,"Bijkomende uitleg/ opmerkingen:"]
[]
[null,"Subsidiesteun reeds ontvangen*",null,null,"*geef aan voor welk bedrag (€) u reeds elders subsidiesteun ontving of zal ontvangen voor deze maatregel. Geef 0 in indien niet van toepassing."]
[]
[]
[null,"Resultaten (in te vullen)"]
[null,"Parameter","Waarde","Eenheid"]
[null,"Investeringskost",null,"€"]
[null,"Jaarlijkse kostenbesparing",null,"€/jaar"]
[null,"Jaarlijkse CO₂-besparing",null,"tCO₂/jaar"]
[null,"Elektriciteitsbesparing",null,"kWh/jaar"]
[null,"Brandstofbesparing (gas/olie)",null,"kWh/jaar"]
[]
[]
[null,"Grafiek: cumulatieve cashflow (indicatieve terugverdientijd)"]
[null,null,null,null,null,null,null,null,null,"Jaar","Cashflow","Cumulatief"]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(J25<=N_YEARS,IF(J25=0,-C16,C17),NA())","v":0},{"$f":"IF(ISNA(K25),NA(),K25)","v":0}]
[null,null,null,null,null,null,null,null,null,1,{"$f":"IF(J26<=N_YEARS,IF(J26=0,-C16,C17),NA())","v":0},{"$f":"IF(ISNA(K26),NA(),L25+K26)","v":0}]
[null,null,null,null,null,null,null,null,null,2,{"$f":"IF($J27<=N_YEARS,IF($J$27=0,-$C$16,$K26*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,3,0,0]
[null,null,null,null,null,null,null,null,null,4,0,0]
[null,null,null,null,null,null,null,null,null,5,0,0]
[null,null,null,null,null,null,null,null,null,6,0,0]
[null,null,null,null,null,null,null,null,null,7,0,0]
[null,null,null,null,null,null,null,null,null,8,0,0]
[null,null,null,null,null,null,null,null,null,9,0,0]
[null,null,null,null,null,null,null,null,null,10,0,0]
[null,null,null,null,null,null,null,null,null,11,0,0]
[null,null,null,null,null,null,null,null,null,12,0,0]
[null,null,null,null,null,null,null,null,null,13,0,0]
[null,null,null,null,null,null,null,null,null,14,0,0]
[null,null,null,null,null,null,null,null,null,15,0,0]
[null,null,null,null,null,null,null,null,null,16,0,0]
[null,null,null,null,null,null,null,null,null,17,0,0]
[null,null,null,null,null,null,null,null,null,18,0,0]
[null,null,null,null,null,null,null,null,null,19,0,0]
[null,null,null,null,null,null,null,null,null,20,0,0]
[null,null,null,null,null,null,null,null,null,21,0,0]
[null,null,null,null,null,null,null,null,null,22,0,0]
[null,null,null,null,null,null,null,null,null,23,0,0]
[null,null,null,null,null,null,null,null,null,24,0,0]
[null,null,null,null,null,null,null,null,null,25,0,0]
[null,null,null,null,null,null,null,null,null,26,0,0]
[null,null,null,null,null,null,null,null,null,27,0,0]
[null,null,null,null,null,null,null,null,null,28,0,0]
[null,null,null,null,null,null,null,null,null,29,0,0]
[null,null,null,null,null,null,null,null,null,30,0,0]
[null,null,null,null,null,null,null,null,null,31,0,0]
[null,null,null,null,null,null,null,null,null,32,0,0]
[null,null,null,null,null,null,null,null,null,33,0,0]
[null,null,null,null,null,null,null,null,null,34,{"$f":"IF($J59<=N_YEARS,IF($J$27=0,-$C$16,$K58*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,35,0,0]
[null,null,null,null,null,null,null,null,null,36,0,0]
[null,null,null,null,null,null,null,null,null,37,0,0]
[null,null,null,null,null,null,null,null,null,38,0,0]
[null,null,null,null,null,null,null,null,null,39,0,0]
[null,null,null,null,null,null,null,null,null,40,0,0]
[null,null,null,null,null,null,null,null,null,41,0,0]
[null,null,null,null,null,null,null,null,null,42,0,0]
[null,null,null,null,null,null,null,null,null,43,0,0]
[null,null,null,null,null,null,null,null,null,44,0,0]
[null,null,null,null,null,null,null,null,null,45,0,0]
[null,null,null,null,null,null,null,null,null,46,0,0]
[null,null,null,null,null,null,null,null,null,47,0,0]
[null,null,null,null,null,null,null,null,null,48,0,0]
[null,null,null,null,null,null,null,null,null,49,0,0]
[null,null,null,null,null,null,null,null,null,50,0,0]

{"sheet":"Indirecte maatregel(en)","index":12,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":true,"merged":[[19,2,19,3],[19,4,19,8],[0,1,0,7],[12,1,12,4],[8,5,9,15],[2,1,4,7],[16,1,16,4]]}
[null,"Indirecte maatregel(en)"]
[]
[null,"Voor indirecte maatregelen dient er geen besparingsberekening te gebeuren. Gelieve aan te duiden over welk(e) type(s) maatregel(en) de aanvraag gaat en de bijhorende offerteprijzen in te vullen. U voegt de offerte(s) als pdf toe als bijlage(pdf) aan uw aanvraag. Zonder offerte wordt het project rechtstreeks afgekeurd."]
[]
[]
[]
[]
[]
[null,"Werktitel Maatregel","Referentiecode Maatregel Terra","Offerteprijs","Subsidiesteun reeds ontvangen*","*geef aan voor welk bedrag (€) u reeds elders subsidiesteun ontving of zal ontvangen voor deze maatregel. Geef 0 in indien niet van toepassing."]
[]
[]
[null,"Type indirecte maatregel:"]
[]
[]
[]
[null,"Bijkomende opmerking:"]
[]
[]
[]
[null,"Referentiecode Portaal Energie-Efficiëntie*",null,null,"*Geef de referrentiecode van het EE-portaal van deze aanvraag. Geef 0 in indien niet van toepassing."]

{"sheet":"Andere","index":13,"n_rows":88,"n_cols":12,"rows_kept":88,"cut":false,"hidden":true,"merged":[[10,2,10,3],[10,4,10,8],[26,1,26,3],[35,1,35,4],[12,1,12,3],[13,1,17,3],[19,1,19,3],[20,1,24,3],[8,1,9,1],[8,2,9,3],[0,1,0,8],[2,1,2,8],[4,1,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[7,4,7,8]]}
[null,"Hernieuwbare Energie"]
[]
[null,"Gebruik dit tabblad indien u een maatregel wenst aan te vragen die niet past onder één van de andere categoriën maar wel kadert binnen het reglement en de geest van het Actieplan EE.\nGelieve de resultatentabel zelf in te vullen en staving (offerte + besparingsberekeningen) als bijlage (pdf) mee aan te leveren.\nVul daarnaast de bijkomende vragen in."]
[]
[null,"Maatregelspecifieke gegevens"]
[null,"Werktitel Maatregel"]
[null,"Referentiecode maatregel Terra:"]
[null,"Referentiecode Portaal Energie-Efficiëntie*",null,null,"*Geef de referrentiecode van het EE-portaal van deze aanvraag. Geef 0 in indien niet van toepassing."]
[null,"Bijkomende uitleg/ opmerkingen:"]
[]
[null,"Subsidiesteun reeds ontvangen*",0,null,"*geef aan voor welk bedrag (€) u reeds elders subsidiesteun ontving of zal ontvangen voor deze maatregel. Geef 0 in indien niet van toepassing."]
[]
[null,"Beschrijf de maatregel"]
[]
[]
[]
[]
[]
[]
[null,"Motiveer hoe de maatregel past binnen het Actieplan EE"]
[]
[]
[]
[]
[]
[]
[null,"Resultaten (in te vullen)"]
[null,"Parameter","Waarde","Eenheid"]
[null,"Investeringskost",null,"tCO₂/jaar"]
[null,"Jaarlijkse kostenbesparing",null,"€/jaar"]
[null,"Jaarlijkse CO₂-besparing",null,"tCO₂/jaar"]
[null,"Elektriciteitsbesparing",null,"kWh/jaar"]
[null,"Brandstofbesparing (gas/olie)",null,"kWh/jaar"]
[]
[]
[null,"Grafiek: cumulatieve cashflow (indicatieve terugverdientijd)"]
[null,null,null,null,null,null,null,null,null,"Jaar","Cashflow","Cumulatief"]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(J38<=N_YEARS,IF(J38=0,-C29,C30),NA())","v":0},{"$f":"IF(ISNA(K38),NA(),K38)","v":0}]
[null,null,null,null,null,null,null,null,null,1,{"$f":"IF(J39<=N_YEARS,IF(J39=0,-C29,C30),NA())","v":0},{"$f":"IF(ISNA(K39),NA(),L38+K39)","v":0}]
[null,null,null,null,null,null,null,null,null,2,{"$f":"IF($J40<=N_YEARS,IF($J$40=0,-$C$29,$K39*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,3,0,0]
[null,null,null,null,null,null,null,null,null,4,0,0]
[null,null,null,null,null,null,null,null,null,5,0,0]
[null,null,null,null,null,null,null,null,null,6,0,0]
[null,null,null,null,null,null,null,null,null,7,0,0]
[null,null,null,null,null,null,null,null,null,8,0,0]
[null,null,null,null,null,null,null,null,null,9,0,0]
[null,null,null,null,null,null,null,null,null,10,0,0]
[null,null,null,null,null,null,null,null,null,11,0,0]
[null,null,null,null,null,null,null,null,null,12,0,0]
[null,null,null,null,null,null,null,null,null,13,0,0]
[null,null,null,null,null,null,null,null,null,14,0,0]
[null,null,null,null,null,null,null,null,null,15,0,0]
[null,null,null,null,null,null,null,null,null,16,0,0]
[null,null,null,null,null,null,null,null,null,17,0,0]
[null,null,null,null,null,null,null,null,null,18,0,0]
[null,null,null,null,null,null,null,null,null,19,0,0]
[null,null,null,null,null,null,null,null,null,20,0,0]
[null,null,null,null,null,null,null,null,null,21,0,0]
[null,null,null,null,null,null,null,null,null,22,0,0]
[null,null,null,null,null,null,null,null,null,23,0,0]
[null,null,null,null,null,null,null,null,null,24,0,0]
[null,null,null,null,null,null,null,null,null,25,0,0]
[null,null,null,null,null,null,null,null,null,26,0,0]
[null,null,null,null,null,null,null,null,null,27,0,0]
[null,null,null,null,null,null,null,null,null,28,0,0]
[null,null,null,null,null,null,null,null,null,29,0,0]
[null,null,null,null,null,null,null,null,null,30,0,0]
[null,null,null,null,null,null,null,null,null,31,0,0]
[null,null,null,null,null,null,null,null,null,32,0,0]
[null,null,null,null,null,null,null,null,null,33,0,0]
[null,null,null,null,null,null,null,null,null,34,{"$f":"IF($J72<=N_YEARS,IF($J$40=0,-$C$29,$K71*(1+COST_INDEX)),NA())","v":0},0]
[null,null,null,null,null,null,null,null,null,35,0,0]
[null,null,null,null,null,null,null,null,null,36,0,0]
[null,null,null,null,null,null,null,null,null,37,0,0]
[null,null,null,null,null,null,null,null,null,38,0,0]
[null,null,null,null,null,null,null,null,null,39,0,0]
[null,null,null,null,null,null,null,null,null,40,0,0]
[null,null,null,null,null,null,null,null,null,41,0,0]
[null,null,null,null,null,null,null,null,null,42,0,0]
[null,null,null,null,null,null,null,null,null,43,0,0]
[null,null,null,null,null,null,null,null,null,44,0,0]
[null,null,null,null,null,null,null,null,null,45,0,0]
[null,null,null,null,null,null,null,null,null,46,0,0]
[null,null,null,null,null,null,null,null,null,47,0,0]
[null,null,null,null,null,null,null,null,null,48,0,0]
[null,null,null,null,null,null,null,null,null,49,0,0]
[null,null,null,null,null,null,null,null,null,50,0,0]

{"sheet":"Overzicht & verbintenissen","index":14,"n_rows":64,"n_cols":10,"rows_kept":64,"cut":false,"hidden":false,"merged":[[49,2,49,4],[50,2,50,4],[51,2,51,4],[63,1,63,9],[37,1,37,9],[38,1,38,9],[39,1,39,9],[40,1,40,9],[41,1,41,9],[42,1,42,9],[45,1,45,9],[46,1,46,9],[54,1,54,9],[55,1,59,9],[48,2,48,4],[3,1,3,9],[0,1,0,8],[18,10,18,13],[29,1,29,2],[25,1,25,2],[26,1,26,2],[6,5,7,8]]}
[null,"Overzicht en verbintenissen"]
[]
[]
[null,"Resultatentabel"]
[]
[]
[null,"Zet de filter \"aangevraagd\" op \"Ja'\"  om enkel de relevante maatregelen te zien",null,null,null,"Hier geeft u aan hoe u het Steunbedrag zult spreiden over de tijd"]
[]
[null,"Type Maatregel","aangevraagd?","Titel","Potentieel Steunbedrag  mits goedkeuring ( VAK)","VEK 2026","VEK 2027","VEK 2028","VEK 2029","Controle (VAK = VEK)"]
[null,"Muurisolatie",{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Maatregel Aangevraagd?],NA())","v":"Nee"},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Werktitel])","v":0},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Finale Steun na aftrekken reeds ontvangen subsidies])","v":0},0,0,0,0,{"$f":"IF(SUM(Table34[[#This Row],[VEK 2026]:[VEK 2029]])=Table34[[#This Row],[Potentieel Steunbedrag  mits goedkeuring ( VAK)]], \"ok\",\"Zorg ervoor dat de Som van de VEK's gelijk is aan het Steunbedrag\")","v":"ok"}]
[null,"Dakisolatie",{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Maatregel Aangevraagd?],NA())","v":"Nee"},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Werktitel])","v":0},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Finale Steun na aftrekken reeds ontvangen subsidies])","v":0},0,0,0,0,{"$f":"IF(SUM(Table34[[#This Row],[VEK 2026]:[VEK 2029]])=Table34[[#This Row],[Potentieel Steunbedrag  mits goedkeuring ( VAK)]], \"ok\",\"Zorg ervoor dat de Som van de VEK's gelijk is aan het Steunbedrag\")","v":"ok"}]
[null,"Vloerisolatie",{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Maatregel Aangevraagd?],NA())","v":"Nee"},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Werktitel])","v":0},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Finale Steun na aftrekken reeds ontvangen subsidies])","v":0},0,0,0,0,{"$f":"IF(SUM(Table34[[#This Row],[VEK 2026]:[VEK 2029]])=Table34[[#This Row],[Potentieel Steunbedrag  mits goedkeuring ( VAK)]], \"ok\",\"Zorg ervoor dat de Som van de VEK's gelijk is aan het Steunbedrag\")","v":"ok"}]
[null,"Schrijnwerkrenovatie",{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Maatregel Aangevraagd?],NA())","v":"Nee"},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Werktitel])","v":0},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Finale Steun na aftrekken reeds ontvangen subsidies])","v":0},0,0,0,0,{"$f":"IF(SUM(Table34[[#This Row],[VEK 2026]:[VEK 2029]])=Table34[[#This Row],[Potentieel Steunbedrag  mits goedkeuring ( VAK)]], \"ok\",\"Zorg ervoor dat de Som van de VEK's gelijk is aan het Steunbedrag\")","v":"ok"}]
[null,"Regeltechnisch",{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Maatregel Aangevraagd?],NA())","v":"Nee"},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Werktitel])","v":0},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Finale Steun na aftrekken reeds ontvangen subsidies])","v":0},0,0,0,0,{"$f":"IF(SUM(Table34[[#This Row],[VEK 2026]:[VEK 2029]])=Table34[[#This Row],[Potentieel Steunbedrag  mits goedkeuring ( VAK)]], \"ok\",\"Zorg ervoor dat de Som van de VEK's gelijk is aan het Steunbedrag\")","v":"ok"}]
[null,"Relighting",{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Maatregel Aangevraagd?],NA())","v":"Nee"},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Werktitel])","v":0},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Finale Steun na aftrekken reeds ontvangen subsidies])","v":0},0,0,0,0,{"$f":"IF(SUM(Table34[[#This Row],[VEK 2026]:[VEK 2029]])=Table34[[#This Row],[Potentieel Steunbedrag  mits goedkeuring ( VAK)]], \"ok\",\"Zorg ervoor dat de Som van de VEK's gelijk is aan het Steunbedrag\")","v":"ok"}]
[null,"Warmtepompen en koeling",{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Maatregel Aangevraagd?],NA())","v":"Nee"},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Werktitel])","v":0},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Finale Steun na aftrekken reeds ontvangen subsidies])","v":0},0,0,0,0,{"$f":"IF(SUM(Table34[[#This Row],[VEK 2026]:[VEK 2029]])=Table34[[#This Row],[Potentieel Steunbedrag  mits goedkeuring ( VAK)]], \"ok\",\"Zorg ervoor dat de Som van de VEK's gelijk is aan het Steunbedrag\")","v":"ok"}]
[null,"Warmtenetkoppeling",{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Maatregel Aangevraagd?],NA())","v":"Nee"},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Werktitel])","v":0},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Finale Steun na aftrekken reeds ontvangen subsidies])","v":0},0,0,0,0,{"$f":"IF(SUM(Table34[[#This Row],[VEK 2026]:[VEK 2029]])=Table34[[#This Row],[Potentieel Steunbedrag  mits goedkeuring ( VAK)]], \"ok\",\"Zorg ervoor dat de Som van de VEK's gelijk is aan het Steunbedrag\")","v":"ok"}]
[null,"Flex & Opslag",{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Maatregel Aangevraagd?],NA())","v":"Nee"},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Werktitel])","v":0},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Finale Steun na aftrekken reeds ontvangen subsidies])","v":0},0,0,0,0,{"$f":"IF(SUM(Table34[[#This Row],[VEK 2026]:[VEK 2029]])=Table34[[#This Row],[Potentieel Steunbedrag  mits goedkeuring ( VAK)]], \"ok\",\"Zorg ervoor dat de Som van de VEK's gelijk is aan het Steunbedrag\")","v":"ok"}]
[null,"Hernieuwbare Energie",{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Maatregel Aangevraagd?],NA())","v":"Nee"},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Werktitel])","v":0},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Finale Steun na aftrekken reeds ontvangen subsidies])","v":0},0,0,0,0,{"$f":"IF(SUM(Table34[[#This Row],[VEK 2026]:[VEK 2029]])=Table34[[#This Row],[Potentieel Steunbedrag  mits goedkeuring ( VAK)]], \"ok\",\"Zorg ervoor dat de Som van de VEK's gelijk is aan het Steunbedrag\")","v":"ok"}]
[null,"Indirecte maatregel(en)",{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Maatregel Aangevraagd?],NA())","v":"Nee"},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Werktitel])","v":0},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Finale Steun na aftrekken reeds ontvangen subsidies])","v":0},0,0,0,0,{"$f":"IF(SUM(Table34[[#This Row],[VEK 2026]:[VEK 2029]])=Table34[[#This Row],[Potentieel Steunbedrag  mits goedkeuring ( VAK)]], \"ok\",\"Zorg ervoor dat de Som van de VEK's gelijk is aan het Steunbedrag\")","v":"ok"}]
[null,"Andere",{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Maatregel Aangevraagd?],NA())","v":"Nee"},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Werktitel])","v":0},{"$f":"_xlfn.XLOOKUP(Table34[[#This Row],[Type Maatregel]],tblAEE[Type Maatregel],tblAEE[Finale Steun na aftrekken reeds ontvangen subsidies])","v":0},0,0,0,0,{"$f":"IF(SUM(Table34[[#This Row],[VEK 2026]:[VEK 2029]])=Table34[[#This Row],[Potentieel Steunbedrag  mits goedkeuring ( VAK)]], \"ok\",\"Zorg ervoor dat de Som van de VEK's gelijk is aan het Steunbedrag\")","v":"ok"}]
[]
[]
[]
[]
[null,"Finaal totaal Steunbedrag (mits goedkeuring)"]
[null,{"$f":"IF(SUM(Table34[Potentieel Steunbedrag  mits goedkeuring ( VAK)])>1000000,1000000,SUM(Table34[Potentieel Steunbedrag  mits goedkeuring ( VAK)]))","v":0},null,null,"Het maximum steunbedrag per entiteit bedraagt €1.000.000, indien uw totaalaanvraag daarover gaat wordt het bedrag afgetopt. Let op! Dit geldt voor de combinatie van al uw aanvragen."]
[]
[]
[null,"Dankzij de maatregelen bespaart u jaarlijks:"]
[null,{"$f":"SUM(tblAEE[Jaarlijkse CO2-besparing])","v":0},"Ton CO2"]
[null,{"$f":"SUM(tblAEE[Elektriciteitsbesparing])","v":0},"kWh elektriciteit"]
[]
[]
[]
[]
[]
[null,"Verbintenissen"]
[null,"Ondergetekende(n) verklaart/verklaren"]
[null,"1° dat de ingevulde gegevens met de werkelijkheid overeenstemmen, dat deze aanvraag correct en volledig is en dat de bepalingen en voorwaarden uit het subsidiereglement bij dit aanvraagformulier werd gelezen en aanvaard."]
[null,"2° dat de organisatie voor elke wijziging aan de projectgegevens die zijn opgenomen in de bewijsvoering van deze projectaanvraag, VEB op de hoogte brengt en waar nodig de documenten actualiseert."]
[null,"3° dat de uitvoering van de opdracht zal gebeuren binnen de 4 kalenderjaren en dit inclusief het begrotingsjaar van de indiening van de projectaanvraag."]
[null,"4° dat de projecten waarvoor steun wordt aangevraagd niet zijn aangevangen op datum van de aanvraag."]
[]
[]
[null,"Ondergetekende(n) onderschrijft de volgende verbintenis"]
[null,"1° de organisatie reikt op eenvoudig verzoek van het VEB bijkomende stukken aan ter verificatie van het voldoen aan de voorwaarden."]
[]
[null,"Datum :"]
[null,"Voor- en achternaam :"]
[null,"Functie :"]
[null,"Handtekening :","Gelieve de akkoordverklaring (zie website) te ondertekenen en in bijlage als pdf mee door te sturen"]
[]
[]
[null," GDPR-clausule\t\t\t"]
[null,"Het Vlaams Energiebedrijf verwerkt uw persoonsgegevens in kader van toekenning van Actieplan EE subsidies aan uw entiteit.  Als u niet wilt dat we uw gegevens verwerken, kunt u dat melden door te mailen naar de functionaris voor gegevensverwerking.  We kunnen dan mogelijks niet tot toekenning van de Actieplan EE subsidies over gaan.  U kunt ook altijd mailen om inzage te vragen in uw persoonsgegevens, onjuiste persoonsgegevens kosteloos te laten rechtzetten of bezwaar te maken tegen de verwerking van uw persoonsgegevens. Als u vragen hebt over de manier waarop we uw gegevens verwerken, kunt u mailen naar de functionaris voor gegevensverwerking op ActieplanEE@veb.be.  Bent u het niet eens met de manier waarop we uw gegevens verwerken, dan kunt u zich wenden tot de Gegevensbeschermingsautoriteit, Drukpersstraat 35, 1000 Brussel."]
[]
[]
[]
[]
[]
[]
[]
[null,"Controleer alsublieft nogmaals dat alle gevraagde velden werden ingevuld; een niet correct en/of volledig ingevuld formulier wordt als niet ontvankelijk beschouwd."]

{"sheet":"Assumpties","index":15,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,4],[2,1,2,4]]}
[null,"Assumpties & emissiefactoren "]
[]
[null,"Algemene aannames",null,null,null,null,"Lookup energiedrager",null,null,null,null,"Levensduren Maatregel"]
[null,"Parameter","Eenheid","Waarde","Toelichting",null,"Energiedrager","Prijs (€/kWh)","CO₂-factor (kg/kWh)",null,null,"Type Maatregel","Categorie","Levensduur (jr)"]
[null,"Elektriciteitsprijs","€/kWh",0.20799999999999999,"Volgens reglement",null,"Aardgas",{"$f":"GAS_PRICE","v":6.0999999999999999E-2},{"$f":"GAS_CO2","v":0.18237},null,null,"Muurisolatie","Gebouw",35]
[null,"Aardgasprijs","€/kWh",6.0999999999999999E-2,"Volgens reglement",null,"Stookolie",{"$f":"OIL_PRICE","v":7.9899999999999999E-2},{"$f":"OIL_CO2","v":0.26676},null,null,"Dakisolatie","Gebouw",35]
[null,"Stookolieprijs","€/L",0.79900000000000004,"Volgens reglement",null,"Elektriciteit",{"$f":"D5","v":0.20799999999999999},0,null,null,"Vloerisolatie","Gebouw",35]
[null,"Energie-inhoud stookolie","kWh/L",10,"Conversiefactor om €/L om te zetten naar €/kWh (aanpasbaar).",null,null,null,null,null,null,"Schrijnwerkrenovatie","Gebouw",35]
[null,"Stookolieprijs omgerekend","€/kWh",{"$f":"IF(D8>0,D7/D8,0)","v":7.9899999999999999E-2},"Afgeleid: stookolieprijs (€/kWh).",null,null,null,null,null,null,"Regeltechnisch","Technisch",15]
[null,"CO₂-factor elektriciteit","kgCO₂/kWh",0,"Niet gespecificeerd in reglement; vul in indien relevant voor rapportering.",null,null,null,null,null,null,"Relighting","Technisch",15]
[null,"CO₂-factor aardgas","kgCO₂/kWh",0.18237,"Volgens reglement bijlage 1.",null,null,null,null,null,null,"Warmtepompen en koeling","Technisch",15]
[null,"CO₂-factor stookolie","kgCO₂/kWh",0.26676,"Volgens reglement bijlage 1.",null,null,null,null,null,null,"Warmtenetkoppeling","Technisch",15]
[null,"Graaddagen","K·dagen/j",2187,"Bron: Synergrid",null,null,null,null,null,null,"Flex & Opslag","Technisch",15]
[null,"Aantal jaren voor cashflowgrafiek","jaren",50,"Voor terugverdientijdgrafiek per maatregel.",null,null,null,null,null,null,"Hernieuwbare Energie","Technisch",15]
[null,"Indexatie energiekostbesparing","%/jaar",3.5000000000000003E-2,"Volgens reglement",null,null,null,null,null,null,"Indirecte maatregel(en)","Technisch",15]
[null,null,null,null,null,null,null,null,null,null,null,"Andere","Technisch",15]

{"sheet":"OVERZICHTSTABEL","index":16,"n_rows":19,"n_cols":25,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Maatregel Aangevraagd?","Type Maatregel","Classificatie","Werktitel","Referentiecode Terra","Bijkomende uitleg","Subsidiesteun reeds ontvangen","Investeringskost","investering overschreven door offerte?","Investeringskost offerte","Investeringskost (definitief)","Jaarlijkse kostenbesparing","Jaarlijkse CO2-besparing","Elektriciteitsbesparing","TVT (jaren)","Steun (per maatregel; indicatief volgens reglement)","Finale Steun na aftrekken reeds ontvangen subsidies","Levensduur (jr)","Energiebesparing (kWh/jr)","Energiebesparing (MWh/jr)","Scorend?","Energiebesparing levensduur (MWh)","CO2 besparing levensduur (ton)","Totale besparing energiekosten levensduur (€)","UID"]
[{"$f":"_xlfn.XLOOKUP(tblAEE[[#This Row],[Type Maatregel]],Table2[Maatregel],Table2[Aangevraagd])","v":"Nee"},"Muurisolatie",{"$f":"_xlfn.LET(_xlpm.t,tblAEE[[#This Row],[Type Maatregel]],\n_xlfn.SWITCH(_xlpm.t,\n \"Muurisolatie\",\"Direct\",\n \"Dakisolatie\",\"Direct\",\n \"Vloerisolatie\",\"Direct\",\n \"Schrijnwerkrenovatie\",\"Direct\",\n \"Regeltechnisch\",\"Direct\",\n \"Relighting\",\"Direct\",\n \"Warmtepompen en koeling\",\"Direct\",\n \"Warmtenetkoppeling\",\"Direct\",\n \"Hernieuwbare Energie\",\"Direct\",\n \"Indirecte maatregel(en)\",\"Indirect\",\n \"Flex & Opslag\",\"FlexOpslag\",\n \"Andere\",\"Direct\",\n \"Direct\"))","v":"Direct"},{"$f":"Muur_Werktitel","v":0},{"$f":"Muur_RefTerra","v":0},{"$f":"Muurisolatie!C7","v":0},{"$f":"Muur_subsidiesteun","v":0},{"$f":"Muurisolatie!H14","v":0},{"$f":"Muurisolatie!M15","v":0},{"$f":"Muurisolatie!M14","v":0},{"$f":"IF(tblAEE[[#This Row],[investering overschreven door offerte?]]=\"Ja\",\n   tblAEE[[#This Row],[Investeringskost offerte]],\n   tblAEE[[#This Row],[Investeringskost]])","v":0},{"$f":"Muurisolatie!H15","v":0},{"$f":"Muurisolatie!H16","v":0},{"$f":"Muurisolatie!H17","v":0},{"$f":"IF(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]>0,\n   tblAEE[[#This Row],[Investeringskost (definitief)]]/tblAEE[[#This Row],[Jaarlijkse kostenbesparing]],\n   NA())","v":{"$error":"#N/A"}},{"$f":"IF(tblAEE[[#This Row],[Classificatie]]=\"Direct\",\n     IFERROR(IF(N(tblAEE[[#This Row],[TVT (jaren)]])>5,\n           N(tblAEE[[#This Row],[Investeringskost (definitief)]])*((N(tblAEE[[#This Row],[TVT (jaren)]])-5)/N(tblAEE[[#This Row],[TVT (jaren)]])),\n           0),\n        0),\n IF(tblAEE[[#This Row],[Classificatie]]=\"Indirect\",\n     IF(tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\",\n         30%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"studie\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         80%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"monitor\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         60%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n         0))),\n 0))","v":0},{"$f":"ROUND(MAX(0,tblAEE[[#This Row],[Steun (per maatregel; indicatief volgens reglement)]]-tblAEE[[#This Row],[Subsidiesteun reeds ontvangen]]),-3)","v":0},{"$f":"IFERROR(\n_xlfn.XLOOKUP(\ntblAEE[[#This Row],[Type Maatregel]],Levensduur[Type Maatregel],Levensduur[Levensduur (jr)]),\n\"Error\")","v":35},{"$f":"SUM(Muurisolatie!H17:H18)","v":0},{"$f":"IF(\nOR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\n\"Niet scorend\",\nIF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (kWh/jr)]]),\ntblAEE[[#This Row],[Energiebesparing (kWh/jr)]]/1000,\n0)\n)","v":0},{"$f":"IF(OR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\"Nee\",\"Ja\")","v":"Ja"},{"$f":"IF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]),tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]*tblAEE[[#This Row],[Levensduur (jr)]],\"\")","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse CO2-besparing]]),\ntblAEE[[#This Row],[Jaarlijkse CO2-besparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\n0\n)","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]),\nIF(Assumpties!$D$15=0,\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*(( (1+Assumpties!$D$15)^tblAEE[[#This Row],[Levensduur (jr)]] -1 ) / Assumpties!$D$15)\n),\n0\n)","v":0},{"$f":"TRIM(tblAEE[[#This Row],[Type Maatregel]])&\"|\"&TRIM(tblAEE[[#This Row],[Werktitel]])","v":"Muurisolatie|0"}]
[{"$f":"_xlfn.XLOOKUP(tblAEE[[#This Row],[Type Maatregel]],Table2[Maatregel],Table2[Aangevraagd])","v":"Nee"},"Dakisolatie",{"$f":"_xlfn.LET(_xlpm.t,tblAEE[[#This Row],[Type Maatregel]],\n_xlfn.SWITCH(_xlpm.t,\n \"Muurisolatie\",\"Direct\",\n \"Dakisolatie\",\"Direct\",\n \"Vloerisolatie\",\"Direct\",\n \"Schrijnwerkrenovatie\",\"Direct\",\n \"Regeltechnisch\",\"Direct\",\n \"Relighting\",\"Direct\",\n \"Warmtepompen en koeling\",\"Direct\",\n \"Warmtenetkoppeling\",\"Direct\",\n \"Hernieuwbare Energie\",\"Direct\",\n \"Indirecte maatregel(en)\",\"Indirect\",\n \"Flex & Opslag\",\"FlexOpslag\",\n \"Andere\",\"Direct\",\n \"Direct\"))","v":"Direct"},{"$f":"Dak_werktitel","v":0},{"$f":"Dak_RefTerra","v":0},{"$f":"Dakisolatie!C7","v":0},{"$f":"Dak_subsidiesteun","v":0},{"$f":"Dakisolatie!H14","v":0},{"$f":"Dakisolatie!M15","v":"Nee"},{"$f":"Dakisolatie!M14","v":0},{"$f":"IF(tblAEE[[#This Row],[investering overschreven door offerte?]]=\"Ja\",\n   tblAEE[[#This Row],[Investeringskost offerte]],\n   tblAEE[[#This Row],[Investeringskost]])","v":0},{"$f":"Dakisolatie!H15","v":0},{"$f":"Dakisolatie!H16","v":0},{"$f":"Dakisolatie!H17","v":0},{"$f":"IF(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]>0,\n   tblAEE[[#This Row],[Investeringskost (definitief)]]/tblAEE[[#This Row],[Jaarlijkse kostenbesparing]],\n   NA())","v":{"$error":"#N/A"}},{"$f":"IF(tblAEE[[#This Row],[Classificatie]]=\"Direct\",\n     IFERROR(IF(N(tblAEE[[#This Row],[TVT (jaren)]])>5,\n           N(tblAEE[[#This Row],[Investeringskost (definitief)]])*((N(tblAEE[[#This Row],[TVT (jaren)]])-5)/N(tblAEE[[#This Row],[TVT (jaren)]])),\n           0),\n        0),\n IF(tblAEE[[#This Row],[Classificatie]]=\"Indirect\",\n     IF(tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\",\n         30%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"studie\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         80%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"monitor\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         60%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n         0))),\n 0))","v":0},{"$f":"ROUND(MAX(0,tblAEE[[#This Row],[Steun (per maatregel; indicatief volgens reglement)]]-tblAEE[[#This Row],[Subsidiesteun reeds ontvangen]]),-3)","v":0},{"$f":"IFERROR(\n_xlfn.XLOOKUP(\ntblAEE[[#This Row],[Type Maatregel]],Levensduur[Type Maatregel],Levensduur[Levensduur (jr)]),\n\"Error\")","v":35},{"$f":"SUM(Dakisolatie!H17:H18)","v":0},{"$f":"IF(\nOR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\n\"Niet scorend\",\nIF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (kWh/jr)]]),\ntblAEE[[#This Row],[Energiebesparing (kWh/jr)]]/1000,\n0)\n)","v":0},{"$f":"IF(OR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\"Nee\",\"Ja\")","v":"Ja"},{"$f":"IF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]),tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]*tblAEE[[#This Row],[Levensduur (jr)]],\"\")","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse CO2-besparing]]),\ntblAEE[[#This Row],[Jaarlijkse CO2-besparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\n0\n)","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]),\nIF(Assumpties!$D$15=0,\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*(( (1+Assumpties!$D$15)^tblAEE[[#This Row],[Levensduur (jr)]] -1 ) / Assumpties!$D$15)\n),\n0\n)","v":0},{"$f":"TRIM(tblAEE[[#This Row],[Type Maatregel]])&\"|\"&TRIM(tblAEE[[#This Row],[Werktitel]])","v":"Dakisolatie|0"}]
[{"$f":"_xlfn.XLOOKUP(tblAEE[[#This Row],[Type Maatregel]],Table2[Maatregel],Table2[Aangevraagd])","v":"Nee"},"Vloerisolatie",{"$f":"_xlfn.LET(_xlpm.t,tblAEE[[#This Row],[Type Maatregel]],\n_xlfn.SWITCH(_xlpm.t,\n \"Muurisolatie\",\"Direct\",\n \"Dakisolatie\",\"Direct\",\n \"Vloerisolatie\",\"Direct\",\n \"Schrijnwerkrenovatie\",\"Direct\",\n \"Regeltechnisch\",\"Direct\",\n \"Relighting\",\"Direct\",\n \"Warmtepompen en koeling\",\"Direct\",\n \"Warmtenetkoppeling\",\"Direct\",\n \"Hernieuwbare Energie\",\"Direct\",\n \"Indirecte maatregel(en)\",\"Indirect\",\n \"Flex & Opslag\",\"FlexOpslag\",\n \"Andere\",\"Direct\",\n \"Direct\"))","v":"Direct"},{"$f":"Vloer_werktitel","v":0},{"$f":"Vloer_RefTerra","v":0},{"$f":"Vloerisolatie!C7","v":0},{"$f":"Vloer_subsidiesteun","v":0},{"$f":"Vloerisolatie!H14","v":0},{"$f":"Vloerisolatie!M15","v":0},{"$f":"Vloerisolatie!M14","v":0},{"$f":"IF(tblAEE[[#This Row],[investering overschreven door offerte?]]=\"Ja\",\n   tblAEE[[#This Row],[Investeringskost offerte]],\n   tblAEE[[#This Row],[Investeringskost]])","v":0},{"$f":"Vloerisolatie!H15","v":0},{"$f":"Vloerisolatie!H16","v":0},{"$f":"Vloerisolatie!H17","v":0},{"$f":"IF(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]>0,\n   tblAEE[[#This Row],[Investeringskost (definitief)]]/tblAEE[[#This Row],[Jaarlijkse kostenbesparing]],\n   NA())","v":{"$error":"#N/A"}},{"$f":"IF(tblAEE[[#This Row],[Classificatie]]=\"Direct\",\n     IFERROR(IF(N(tblAEE[[#This Row],[TVT (jaren)]])>5,\n           N(tblAEE[[#This Row],[Investeringskost (definitief)]])*((N(tblAEE[[#This Row],[TVT (jaren)]])-5)/N(tblAEE[[#This Row],[TVT (jaren)]])),\n           0),\n        0),\n IF(tblAEE[[#This Row],[Classificatie]]=\"Indirect\",\n     IF(tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\",\n         30%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"studie\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         80%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"monitor\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         60%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n         0))),\n 0))","v":0},{"$f":"ROUND(MAX(0,tblAEE[[#This Row],[Steun (per maatregel; indicatief volgens reglement)]]-tblAEE[[#This Row],[Subsidiesteun reeds ontvangen]]),-3)","v":0},{"$f":"IFERROR(\n_xlfn.XLOOKUP(\ntblAEE[[#This Row],[Type Maatregel]],Levensduur[Type Maatregel],Levensduur[Levensduur (jr)]),\n\"Error\")","v":35},{"$f":"SUM(Vloerisolatie!H17:H18)","v":0},{"$f":"IF(\nOR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\n\"Niet scorend\",\nIF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (kWh/jr)]]),\ntblAEE[[#This Row],[Energiebesparing (kWh/jr)]]/1000,\n0)\n)","v":0},{"$f":"IF(OR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\"Nee\",\"Ja\")","v":"Ja"},{"$f":"IF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]),tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]*tblAEE[[#This Row],[Levensduur (jr)]],\"\")","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse CO2-besparing]]),\ntblAEE[[#This Row],[Jaarlijkse CO2-besparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\n0\n)","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]),\nIF(Assumpties!$D$15=0,\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*(( (1+Assumpties!$D$15)^tblAEE[[#This Row],[Levensduur (jr)]] -1 ) / Assumpties!$D$15)\n),\n0\n)","v":0},{"$f":"TRIM(tblAEE[[#This Row],[Type Maatregel]])&\"|\"&TRIM(tblAEE[[#This Row],[Werktitel]])","v":"Vloerisolatie|0"}]
[{"$f":"_xlfn.XLOOKUP(tblAEE[[#This Row],[Type Maatregel]],Table2[Maatregel],Table2[Aangevraagd])","v":"Nee"},"Schrijnwerkrenovatie",{"$f":"_xlfn.LET(_xlpm.t,tblAEE[[#This Row],[Type Maatregel]],\n_xlfn.SWITCH(_xlpm.t,\n \"Muurisolatie\",\"Direct\",\n \"Dakisolatie\",\"Direct\",\n \"Vloerisolatie\",\"Direct\",\n \"Schrijnwerkrenovatie\",\"Direct\",\n \"Regeltechnisch\",\"Direct\",\n \"Relighting\",\"Direct\",\n \"Warmtepompen en koeling\",\"Direct\",\n \"Warmtenetkoppeling\",\"Direct\",\n \"Hernieuwbare Energie\",\"Direct\",\n \"Indirecte maatregel(en)\",\"Indirect\",\n \"Flex & Opslag\",\"FlexOpslag\",\n \"Andere\",\"Direct\",\n \"Direct\"))","v":"Direct"},{"$f":"Schrijnwerkrenovatie!C4","v":0},{"$f":"Schrijnwerkrenovatie!C5","v":0},{"$f":"Schrijnwerkrenovatie!C7","v":0},{"$f":"Schrijnwerkrenovatie!C9","v":0},{"$f":"Schrijnwerkrenovatie!H14","v":0},{"$f":"Schrijnwerkrenovatie!M15","v":0},{"$f":"Schrijnwerkrenovatie!M14","v":0},{"$f":"IF(tblAEE[[#This Row],[investering overschreven door offerte?]]=\"Ja\",\n   tblAEE[[#This Row],[Investeringskost offerte]],\n   tblAEE[[#This Row],[Investeringskost]])","v":0},{"$f":"Schrijnwerkrenovatie!H15","v":0},{"$f":"Schrijnwerkrenovatie!H16","v":0},{"$f":"Schrijnwerkrenovatie!H17","v":0},{"$f":"IF(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]>0,\n   tblAEE[[#This Row],[Investeringskost (definitief)]]/tblAEE[[#This Row],[Jaarlijkse kostenbesparing]],\n   NA())","v":{"$error":"#N/A"}},{"$f":"IF(tblAEE[[#This Row],[Classificatie]]=\"Direct\",\n     IFERROR(IF(N(tblAEE[[#This Row],[TVT (jaren)]])>5,\n           N(tblAEE[[#This Row],[Investeringskost (definitief)]])*((N(tblAEE[[#This Row],[TVT (jaren)]])-5)/N(tblAEE[[#This Row],[TVT (jaren)]])),\n           0),\n        0),\n IF(tblAEE[[#This Row],[Classificatie]]=\"Indirect\",\n     IF(tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\",\n         30%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"studie\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         80%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"monitor\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         60%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n         0))),\n 0))","v":0},{"$f":"ROUND(MAX(0,tblAEE[[#This Row],[Steun (per maatregel; indicatief volgens reglement)]]-tblAEE[[#This Row],[Subsidiesteun reeds ontvangen]]),-3)","v":0},{"$f":"IFERROR(\n_xlfn.XLOOKUP(\ntblAEE[[#This Row],[Type Maatregel]],Levensduur[Type Maatregel],Levensduur[Levensduur (jr)]),\n\"Error\")","v":35},{"$f":"SUM(Schrijnwerkrenovatie!H17:H18)","v":0},{"$f":"IF(\nOR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\n\"Niet scorend\",\nIF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (kWh/jr)]]),\ntblAEE[[#This Row],[Energiebesparing (kWh/jr)]]/1000,\n0)\n)","v":0},{"$f":"IF(OR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\"Nee\",\"Ja\")","v":"Ja"},{"$f":"IF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]),tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]*tblAEE[[#This Row],[Levensduur (jr)]],\"\")","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse CO2-besparing]]),\ntblAEE[[#This Row],[Jaarlijkse CO2-besparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\n0\n)","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]),\nIF(Assumpties!$D$15=0,\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*(( (1+Assumpties!$D$15)^tblAEE[[#This Row],[Levensduur (jr)]] -1 ) / Assumpties!$D$15)\n),\n0\n)","v":0},{"$f":"TRIM(tblAEE[[#This Row],[Type Maatregel]])&\"|\"&TRIM(tblAEE[[#This Row],[Werktitel]])","v":"Schrijnwerkrenovatie|0"}]
[{"$f":"_xlfn.XLOOKUP(tblAEE[[#This Row],[Type Maatregel]],Table2[Maatregel],Table2[Aangevraagd])","v":"Nee"},"Regeltechnisch",{"$f":"_xlfn.LET(_xlpm.t,tblAEE[[#This Row],[Type Maatregel]],\n_xlfn.SWITCH(_xlpm.t,\n \"Muurisolatie\",\"Direct\",\n \"Dakisolatie\",\"Direct\",\n \"Vloerisolatie\",\"Direct\",\n \"Schrijnwerkrenovatie\",\"Direct\",\n \"Regeltechnisch\",\"Direct\",\n \"Relighting\",\"Direct\",\n \"Warmtepompen en koeling\",\"Direct\",\n \"Warmtenetkoppeling\",\"Direct\",\n \"Hernieuwbare Energie\",\"Direct\",\n \"Indirecte maatregel(en)\",\"Indirect\",\n \"Flex & Opslag\",\"FlexOpslag\",\n \"Andere\",\"Direct\",\n \"Direct\"))","v":"Direct"},{"$f":"Regeltechnisch!C4","v":0},{"$f":"Regeltechnisch!C5","v":0},{"$f":"Regeltechnisch!C7","v":0},{"$f":"Regeltechnisch!C9","v":0},{"$f":"Regeltechnisch!H14","v":0},{"$f":"Regeltechnisch!M15","v":0},{"$f":"Regeltechnisch!M14","v":0},{"$f":"IF(tblAEE[[#This Row],[investering overschreven door offerte?]]=\"Ja\",\n   tblAEE[[#This Row],[Investeringskost offerte]],\n   tblAEE[[#This Row],[Investeringskost]])","v":0},{"$f":"Regeltechnisch!H15","v":0},{"$f":"Regeltechnisch!H16","v":0},{"$f":"Regeltechnisch!H17","v":0},{"$f":"IF(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]>0,\n   tblAEE[[#This Row],[Investeringskost (definitief)]]/tblAEE[[#This Row],[Jaarlijkse kostenbesparing]],\n   NA())","v":{"$error":"#N/A"}},{"$f":"IF(tblAEE[[#This Row],[Classificatie]]=\"Direct\",\n     IFERROR(IF(N(tblAEE[[#This Row],[TVT (jaren)]])>5,\n           N(tblAEE[[#This Row],[Investeringskost (definitief)]])*((N(tblAEE[[#This Row],[TVT (jaren)]])-5)/N(tblAEE[[#This Row],[TVT (jaren)]])),\n           0),\n        0),\n IF(tblAEE[[#This Row],[Classificatie]]=\"Indirect\",\n     IF(tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\",\n         30%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"studie\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         80%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"monitor\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         60%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n         0))),\n 0))","v":0},{"$f":"ROUND(MAX(0,tblAEE[[#This Row],[Steun (per maatregel; indicatief volgens reglement)]]-tblAEE[[#This Row],[Subsidiesteun reeds ontvangen]]),-3)","v":0},{"$f":"IFERROR(\n_xlfn.XLOOKUP(\ntblAEE[[#This Row],[Type Maatregel]],Levensduur[Type Maatregel],Levensduur[Levensduur (jr)]),\n\"Error\")","v":15},{"$f":"SUM(Regeltechnisch!H17:H18)","v":0},{"$f":"IF(\nOR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\n\"Niet scorend\",\nIF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (kWh/jr)]]),\ntblAEE[[#This Row],[Energiebesparing (kWh/jr)]]/1000,\n0)\n)","v":0},{"$f":"IF(OR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\"Nee\",\"Ja\")","v":"Ja"},{"$f":"IF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]),tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]*tblAEE[[#This Row],[Levensduur (jr)]],\"\")","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse CO2-besparing]]),\ntblAEE[[#This Row],[Jaarlijkse CO2-besparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\n0\n)","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]),\nIF(Assumpties!$D$15=0,\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*(( (1+Assumpties!$D$15)^tblAEE[[#This Row],[Levensduur (jr)]] -1 ) / Assumpties!$D$15)\n),\n0\n)","v":0},{"$f":"TRIM(tblAEE[[#This Row],[Type Maatregel]])&\"|\"&TRIM(tblAEE[[#This Row],[Werktitel]])","v":"Regeltechnisch|0"}]
[{"$f":"_xlfn.XLOOKUP(tblAEE[[#This Row],[Type Maatregel]],Table2[Maatregel],Table2[Aangevraagd])","v":"Nee"},"Relighting",{"$f":"_xlfn.LET(_xlpm.t,tblAEE[[#This Row],[Type Maatregel]],\n_xlfn.SWITCH(_xlpm.t,\n \"Muurisolatie\",\"Direct\",\n \"Dakisolatie\",\"Direct\",\n \"Vloerisolatie\",\"Direct\",\n \"Schrijnwerkrenovatie\",\"Direct\",\n \"Regeltechnisch\",\"Direct\",\n \"Relighting\",\"Direct\",\n \"Warmtepompen en koeling\",\"Direct\",\n \"Warmtenetkoppeling\",\"Direct\",\n \"Hernieuwbare Energie\",\"Direct\",\n \"Indirecte maatregel(en)\",\"Indirect\",\n \"Flex & Opslag\",\"FlexOpslag\",\n \"Andere\",\"Direct\",\n \"Direct\"))","v":"Direct"},{"$f":"Relighting!C4","v":0},{"$f":"Relighting!C5","v":0},{"$f":"Relighting!C7","v":0},{"$f":"Relighting!C9","v":0},{"$f":"Relighting!H14","v":0},{"$f":"Relighting!M15","v":0},{"$f":"Relighting!M14","v":0},{"$f":"IF(tblAEE[[#This Row],[investering overschreven door offerte?]]=\"Ja\",\n   tblAEE[[#This Row],[Investeringskost offerte]],\n   tblAEE[[#This Row],[Investeringskost]])","v":0},{"$f":"Relighting!H15","v":0},"NVT",{"$f":"Relighting!H16","v":0},{"$f":"IF(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]>0,\n   tblAEE[[#This Row],[Investeringskost (definitief)]]/tblAEE[[#This Row],[Jaarlijkse kostenbesparing]],\n   NA())","v":{"$error":"#N/A"}},{"$f":"IF(tblAEE[[#This Row],[Classificatie]]=\"Direct\",\n     IFERROR(IF(N(tblAEE[[#This Row],[TVT (jaren)]])>5,\n           N(tblAEE[[#This Row],[Investeringskost (definitief)]])*((N(tblAEE[[#This Row],[TVT (jaren)]])-5)/N(tblAEE[[#This Row],[TVT (jaren)]])),\n           0),\n        0),\n IF(tblAEE[[#This Row],[Classificatie]]=\"Indirect\",\n     IF(tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\",\n         30%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"studie\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         80%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"monitor\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         60%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n         0))),\n 0))","v":0},{"$f":"ROUND(MAX(0,tblAEE[[#This Row],[Steun (per maatregel; indicatief volgens reglement)]]-tblAEE[[#This Row],[Subsidiesteun reeds ontvangen]]),-3)","v":0},{"$f":"IFERROR(\n_xlfn.XLOOKUP(\ntblAEE[[#This Row],[Type Maatregel]],Levensduur[Type Maatregel],Levensduur[Levensduur (jr)]),\n\"Error\")","v":15},{"$f":"Relighting!H16","v":0},{"$f":"IF(\nOR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\n\"Niet scorend\",\nIF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (kWh/jr)]]),\ntblAEE[[#This Row],[Energiebesparing (kWh/jr)]]/1000,\n0)\n)","v":0},{"$f":"IF(OR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\"Nee\",\"Ja\")","v":"Ja"},{"$f":"IF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]),tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]*tblAEE[[#This Row],[Levensduur (jr)]],\"\")","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse CO2-besparing]]),\ntblAEE[[#This Row],[Jaarlijkse CO2-besparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\n0\n)","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]),\nIF(Assumpties!$D$15=0,\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*(( (1+Assumpties!$D$15)^tblAEE[[#This Row],[Levensduur (jr)]] -1 ) / Assumpties!$D$15)\n),\n0\n)","v":0},{"$f":"TRIM(tblAEE[[#This Row],[Type Maatregel]])&\"|\"&TRIM(tblAEE[[#This Row],[Werktitel]])","v":"Relighting|0"}]
[{"$f":"_xlfn.XLOOKUP(tblAEE[[#This Row],[Type Maatregel]],Table2[Maatregel],Table2[Aangevraagd])","v":"Nee"},"Warmtepompen en koeling",{"$f":"_xlfn.LET(_xlpm.t,tblAEE[[#This Row],[Type Maatregel]],\n_xlfn.SWITCH(_xlpm.t,\n \"Muurisolatie\",\"Direct\",\n \"Dakisolatie\",\"Direct\",\n \"Vloerisolatie\",\"Direct\",\n \"Schrijnwerkrenovatie\",\"Direct\",\n \"Regeltechnisch\",\"Direct\",\n \"Relighting\",\"Direct\",\n \"Warmtepompen en koeling\",\"Direct\",\n \"Warmtenetkoppeling\",\"Direct\",\n \"Hernieuwbare Energie\",\"Direct\",\n \"Indirecte maatregel(en)\",\"Indirect\",\n \"Flex & Opslag\",\"FlexOpslag\",\n \"Andere\",\"Direct\",\n \"Direct\"))","v":"Direct"},{"$f":"'Warmtepompen en koeling'!C4","v":0},{"$f":"'Warmtepompen en koeling'!C5","v":0},{"$f":"'Warmtepompen en koeling'!C7","v":0},{"$f":"'Warmtepompen en koeling'!C9","v":0},{"$f":"'Warmtepompen en koeling'!H14","v":0},{"$f":"'Warmtepompen en koeling'!M15","v":"Nee"},{"$f":"'Warmtepompen en koeling'!M14","v":0},{"$f":"IF(tblAEE[[#This Row],[investering overschreven door offerte?]]=\"Ja\",\n   tblAEE[[#This Row],[Investeringskost offerte]],\n   tblAEE[[#This Row],[Investeringskost]])","v":0},{"$f":"'Warmtepompen en koeling'!H15","v":0},{"$f":"'Warmtepompen en koeling'!H16","v":0},{"$f":"'Warmtepompen en koeling'!H17","v":0},{"$f":"IF(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]>0,\n   tblAEE[[#This Row],[Investeringskost (definitief)]]/tblAEE[[#This Row],[Jaarlijkse kostenbesparing]],\n   NA())","v":{"$error":"#N/A"}},{"$f":"IF(tblAEE[[#This Row],[Classificatie]]=\"Direct\",\n     IFERROR(IF(N(tblAEE[[#This Row],[TVT (jaren)]])>5,\n           N(tblAEE[[#This Row],[Investeringskost (definitief)]])*((N(tblAEE[[#This Row],[TVT (jaren)]])-5)/N(tblAEE[[#This Row],[TVT (jaren)]])),\n           0),\n        0),\n IF(tblAEE[[#This Row],[Classificatie]]=\"Indirect\",\n     IF(tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\",\n         30%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"studie\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         80%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"monitor\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         60%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n         0))),\n 0))","v":0},{"$f":"ROUND(MAX(0,tblAEE[[#This Row],[Steun (per maatregel; indicatief volgens reglement)]]-tblAEE[[#This Row],[Subsidiesteun reeds ontvangen]]),-3)","v":0},{"$f":"IFERROR(\n_xlfn.XLOOKUP(\ntblAEE[[#This Row],[Type Maatregel]],Levensduur[Type Maatregel],Levensduur[Levensduur (jr)]),\n\"Error\")","v":15},{"$f":"SUM('Warmtepompen en koeling'!H17:H18)","v":0},{"$f":"IF(\nOR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\n\"Niet scorend\",\nIF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (kWh/jr)]]),\ntblAEE[[#This Row],[Energiebesparing (kWh/jr)]]/1000,\n0)\n)","v":0},{"$f":"IF(OR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\"Nee\",\"Ja\")","v":"Ja"},{"$f":"IF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]),tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]*tblAEE[[#This Row],[Levensduur (jr)]],\"\")","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse CO2-besparing]]),\ntblAEE[[#This Row],[Jaarlijkse CO2-besparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\n0\n)","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]),\nIF(Assumpties!$D$15=0,\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*(( (1+Assumpties!$D$15)^tblAEE[[#This Row],[Levensduur (jr)]] -1 ) / Assumpties!$D$15)\n),\n0\n)","v":0},{"$f":"TRIM(tblAEE[[#This Row],[Type Maatregel]])&\"|\"&TRIM(tblAEE[[#This Row],[Werktitel]])","v":"Warmtepompen en koeling|0"}]
[{"$f":"_xlfn.XLOOKUP(tblAEE[[#This Row],[Type Maatregel]],Table2[Maatregel],Table2[Aangevraagd])","v":"Nee"},"Warmtenetkoppeling",{"$f":"_xlfn.LET(_xlpm.t,tblAEE[[#This Row],[Type Maatregel]],\n_xlfn.SWITCH(_xlpm.t,\n \"Muurisolatie\",\"Direct\",\n \"Dakisolatie\",\"Direct\",\n \"Vloerisolatie\",\"Direct\",\n \"Schrijnwerkrenovatie\",\"Direct\",\n \"Regeltechnisch\",\"Direct\",\n \"Relighting\",\"Direct\",\n \"Warmtepompen en koeling\",\"Direct\",\n \"Warmtenetkoppeling\",\"Direct\",\n \"Hernieuwbare Energie\",\"Direct\",\n \"Indirecte maatregel(en)\",\"Indirect\",\n \"Flex & Opslag\",\"FlexOpslag\",\n \"Andere\",\"Direct\",\n \"Direct\"))","v":"Direct"},{"$f":"Warmtenetkoppeling!C6","v":0},{"$f":"Warmtenetkoppeling!C7","v":0},{"$f":"Warmtenetkoppeling!C9","v":0},{"$f":"Warmtenetkoppeling!C11","v":0},{"$f":"Warmtenetkoppeling!C16","v":0},"NVT","NVT",{"$f":"IF(tblAEE[[#This Row],[investering overschreven door offerte?]]=\"Ja\",\n   tblAEE[[#This Row],[Investeringskost offerte]],\n   tblAEE[[#This Row],[Investeringskost]])","v":0},{"$f":"Warmtenetkoppeling!C17","v":0},{"$f":"Warmtenetkoppeling!C18","v":0},{"$f":"Warmtenetkoppeling!C19","v":0},{"$f":"IF(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]>0,\n   tblAEE[[#This Row],[Investeringskost (definitief)]]/tblAEE[[#This Row],[Jaarlijkse kostenbesparing]],\n   NA())","v":{"$error":"#N/A"}},{"$f":"IF(tblAEE[[#This Row],[Classificatie]]=\"Direct\",\n     IFERROR(IF(N(tblAEE[[#This Row],[TVT (jaren)]])>5,\n           N(tblAEE[[#This Row],[Investeringskost (definitief)]])*((N(tblAEE[[#This Row],[TVT (jaren)]])-5)/N(tblAEE[[#This Row],[TVT (jaren)]])),\n           0),\n        0),\n IF(tblAEE[[#This Row],[Classificatie]]=\"Indirect\",\n     IF(tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\",\n         30%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"studie\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         80%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"monitor\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         60%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n         0))),\n 0))","v":0},{"$f":"ROUND(MAX(0,tblAEE[[#This Row],[Steun (per maatregel; indicatief volgens reglement)]]-tblAEE[[#This Row],[Subsidiesteun reeds ontvangen]]),-3)","v":0},{"$f":"IFERROR(\n_xlfn.XLOOKUP(\ntblAEE[[#This Row],[Type Maatregel]],Levensduur[Type Maatregel],Levensduur[Levensduur (jr)]),\n\"Error\")","v":15},{"$f":"SUM(Warmtenetkoppeling!C19:C20)","v":0},{"$f":"IF(\nOR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\n\"Niet scorend\",\nIF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (kWh/jr)]]),\ntblAEE[[#This Row],[Energiebesparing (kWh/jr)]]/1000,\n0)\n)","v":0},{"$f":"IF(OR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\"Nee\",\"Ja\")","v":"Ja"},{"$f":"IF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]),tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]*tblAEE[[#This Row],[Levensduur (jr)]],\"\")","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse CO2-besparing]]),\ntblAEE[[#This Row],[Jaarlijkse CO2-besparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\n0\n)","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]),\nIF(Assumpties!$D$15=0,\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*(( (1+Assumpties!$D$15)^tblAEE[[#This Row],[Levensduur (jr)]] -1 ) / Assumpties!$D$15)\n),\n0\n)","v":0},{"$f":"TRIM(tblAEE[[#This Row],[Type Maatregel]])&\"|\"&TRIM(tblAEE[[#This Row],[Werktitel]])","v":"Warmtenetkoppeling|0"}]
[{"$f":"_xlfn.XLOOKUP(tblAEE[[#This Row],[Type Maatregel]],Table2[Maatregel],Table2[Aangevraagd])","v":"Nee"},"Flex & Opslag",{"$f":"_xlfn.LET(_xlpm.t,tblAEE[[#This Row],[Type Maatregel]],\n_xlfn.SWITCH(_xlpm.t,\n \"Muurisolatie\",\"Direct\",\n \"Dakisolatie\",\"Direct\",\n \"Vloerisolatie\",\"Direct\",\n \"Schrijnwerkrenovatie\",\"Direct\",\n \"Regeltechnisch\",\"Direct\",\n \"Relighting\",\"Direct\",\n \"Warmtepompen en koeling\",\"Direct\",\n \"Warmtenetkoppeling\",\"Direct\",\n \"Hernieuwbare Energie\",\"Direct\",\n \"Indirecte maatregel(en)\",\"Indirect\",\n \"Flex & Opslag\",\"FlexOpslag\",\n \"Andere\",\"Direct\",\n \"Direct\"))","v":"FlexOpslag"},{"$f":"'Flex & Opslag'!C6","v":0},{"$f":"'Flex & Opslag'!C7","v":0},{"$f":"'Flex & Opslag'!C9","v":0},{"$f":"'Flex & Opslag'!C11","v":0},{"$f":"'Flex & Opslag'!C16","v":0},"NVT","NVT",{"$f":"IF(tblAEE[[#This Row],[investering overschreven door offerte?]]=\"Ja\",\n   tblAEE[[#This Row],[Investeringskost offerte]],\n   tblAEE[[#This Row],[Investeringskost]])","v":0},{"$f":"'Flex & Opslag'!C17","v":0},{"$f":"'Flex & Opslag'!C18","v":0},{"$f":"'Flex & Opslag'!C19","v":0},{"$f":"IF(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]>0,\n   tblAEE[[#This Row],[Investeringskost (definitief)]]/tblAEE[[#This Row],[Jaarlijkse kostenbesparing]],\n   NA())","v":{"$error":"#N/A"}},{"$f":"IF(tblAEE[[#This Row],[Classificatie]]=\"Direct\",\n     IFERROR(IF(N(tblAEE[[#This Row],[TVT (jaren)]])>5,\n           N(tblAEE[[#This Row],[Investeringskost (definitief)]])*((N(tblAEE[[#This Row],[TVT (jaren)]])-5)/N(tblAEE[[#This Row],[TVT (jaren)]])),\n           0),\n        0),\n IF(tblAEE[[#This Row],[Classificatie]]=\"Indirect\",\n     IF(tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\",\n         30%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"studie\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         80%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"monitor\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         60%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n         0))),\n 0))","v":0},{"$f":"ROUND(MAX(0,tblAEE[[#This Row],[Steun (per maatregel; indicatief volgens reglement)]]-tblAEE[[#This Row],[Subsidiesteun reeds ontvangen]]),-3)","v":0},{"$f":"IFERROR(\n_xlfn.XLOOKUP(\ntblAEE[[#This Row],[Type Maatregel]],Levensduur[Type Maatregel],Levensduur[Levensduur (jr)]),\n\"Error\")","v":15},{"$f":"SUM('Flex & Opslag'!C19:C20)","v":0},{"$f":"IF(\nOR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\n\"Niet scorend\",\nIF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (kWh/jr)]]),\ntblAEE[[#This Row],[Energiebesparing (kWh/jr)]]/1000,\n0)\n)","v":"Niet scorend"},{"$f":"IF(OR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\"Nee\",\"Ja\")","v":"Nee"},{"$f":"IF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]),tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]*tblAEE[[#This Row],[Levensduur (jr)]],\"\")","v":""},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse CO2-besparing]]),\ntblAEE[[#This Row],[Jaarlijkse CO2-besparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\n0\n)","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]),\nIF(Assumpties!$D$15=0,\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*(( (1+Assumpties!$D$15)^tblAEE[[#This Row],[Levensduur (jr)]] -1 ) / Assumpties!$D$15)\n),\n0\n)","v":0},{"$f":"TRIM(tblAEE[[#This Row],[Type Maatregel]])&\"|\"&TRIM(tblAEE[[#This Row],[Werktitel]])","v":"Flex & Opslag|0"}]
[{"$f":"_xlfn.XLOOKUP(tblAEE[[#This Row],[Type Maatregel]],Table2[Maatregel],Table2[Aangevraagd])","v":"Nee"},"Hernieuwbare Energie",{"$f":"_xlfn.LET(_xlpm.t,tblAEE[[#This Row],[Type Maatregel]],\n_xlfn.SWITCH(_xlpm.t,\n \"Muurisolatie\",\"Direct\",\n \"Dakisolatie\",\"Direct\",\n \"Vloerisolatie\",\"Direct\",\n \"Schrijnwerkrenovatie\",\"Direct\",\n \"Regeltechnisch\",\"Direct\",\n \"Relighting\",\"Direct\",\n \"Warmtepompen en koeling\",\"Direct\",\n \"Warmtenetkoppeling\",\"Direct\",\n \"Hernieuwbare Energie\",\"Direct\",\n \"Indirecte maatregel(en)\",\"Indirect\",\n \"Flex & Opslag\",\"FlexOpslag\",\n \"Andere\",\"Direct\",\n \"Direct\"))","v":"Direct"},{"$f":"'Hernieuwbare Energie'!C6","v":0},{"$f":"'Hernieuwbare Energie'!C7","v":0},{"$f":"'Hernieuwbare Energie'!C9","v":0},{"$f":"'Hernieuwbare Energie'!C11","v":0},{"$f":"'Hernieuwbare Energie'!C16","v":0},"NVT","NVT",{"$f":"IF(tblAEE[[#This Row],[investering overschreven door offerte?]]=\"Ja\",\n   tblAEE[[#This Row],[Investeringskost offerte]],\n   tblAEE[[#This Row],[Investeringskost]])","v":0},{"$f":"'Hernieuwbare Energie'!C17","v":0},{"$f":"'Hernieuwbare Energie'!C18","v":0},{"$f":"'Hernieuwbare Energie'!C19","v":0},{"$f":"IF(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]>0,\n   tblAEE[[#This Row],[Investeringskost (definitief)]]/tblAEE[[#This Row],[Jaarlijkse kostenbesparing]],\n   NA())","v":{"$error":"#N/A"}},{"$f":"IF(tblAEE[[#This Row],[Classificatie]]=\"Direct\",\n     IFERROR(IF(N(tblAEE[[#This Row],[TVT (jaren)]])>5,\n           N(tblAEE[[#This Row],[Investeringskost (definitief)]])*((N(tblAEE[[#This Row],[TVT (jaren)]])-5)/N(tblAEE[[#This Row],[TVT (jaren)]])),\n           0),\n        0),\n IF(tblAEE[[#This Row],[Classificatie]]=\"Indirect\",\n     IF(tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\",\n         30%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"studie\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         80%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"monitor\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         60%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n         0))),\n 0))","v":0},{"$f":"ROUND(MAX(0,tblAEE[[#This Row],[Steun (per maatregel; indicatief volgens reglement)]]-tblAEE[[#This Row],[Subsidiesteun reeds ontvangen]]),-3)","v":0},{"$f":"IFERROR(\n_xlfn.XLOOKUP(\ntblAEE[[#This Row],[Type Maatregel]],Levensduur[Type Maatregel],Levensduur[Levensduur (jr)]),\n\"Error\")","v":15},{"$f":"SUM('Hernieuwbare Energie'!C19:C20)","v":0},{"$f":"IF(\nOR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\n\"Niet scorend\",\nIF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (kWh/jr)]]),\ntblAEE[[#This Row],[Energiebesparing (kWh/jr)]]/1000,\n0)\n)","v":0},{"$f":"IF(OR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\"Nee\",\"Ja\")","v":"Ja"},{"$f":"IF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]),tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]*tblAEE[[#This Row],[Levensduur (jr)]],\"\")","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse CO2-besparing]]),\ntblAEE[[#This Row],[Jaarlijkse CO2-besparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\n0\n)","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]),\nIF(Assumpties!$D$15=0,\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*(( (1+Assumpties!$D$15)^tblAEE[[#This Row],[Levensduur (jr)]] -1 ) / Assumpties!$D$15)\n),\n0\n)","v":0},{"$f":"TRIM(tblAEE[[#This Row],[Type Maatregel]])&\"|\"&TRIM(tblAEE[[#This Row],[Werktitel]])","v":"Hernieuwbare Energie|0"}]
[{"$f":"_xlfn.XLOOKUP(tblAEE[[#This Row],[Type Maatregel]],Table2[Maatregel],Table2[Aangevraagd])","v":"Nee"},"Indirecte maatregel(en)",{"$f":"_xlfn.LET(_xlpm.t,tblAEE[[#This Row],[Type Maatregel]],\n_xlfn.SWITCH(_xlpm.t,\n \"Muurisolatie\",\"Direct\",\n \"Dakisolatie\",\"Direct\",\n \"Vloerisolatie\",\"Direct\",\n \"Schrijnwerkrenovatie\",\"Direct\",\n \"Regeltechnisch\",\"Direct\",\n \"Relighting\",\"Direct\",\n \"Warmtepompen en koeling\",\"Direct\",\n \"Warmtenetkoppeling\",\"Direct\",\n \"Hernieuwbare Energie\",\"Direct\",\n \"Indirecte maatregel(en)\",\"Indirect\",\n \"Flex & Opslag\",\"FlexOpslag\",\n \"Andere\",\"Direct\",\n \"Direct\"))","v":"Indirect"},{"$f":"Table10[Werktitel Maatregel]","v":0},{"$f":"Table10[Referentiecode Maatregel Terra]","v":0},{"$f":"_xlfn.TEXTJOIN(\" ; \",TRUE,'Indirecte maatregel(en)'!B13,'Indirecte maatregel(en)'!B17:E17)","v":""},{"$f":"Table10[Subsidiesteun reeds ontvangen*]","v":0},{"$f":"Table10[Offerteprijs]","v":0},"NVT","NVT",{"$f":"IF(tblAEE[[#This Row],[investering overschreven door offerte?]]=\"Ja\",\n   tblAEE[[#This Row],[Investeringskost offerte]],\n   tblAEE[[#This Row],[Investeringskost]])","v":0},"NVT","NVT","NVT",{"$f":"IF(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]>0,\n   tblAEE[[#This Row],[Investeringskost (definitief)]]/tblAEE[[#This Row],[Jaarlijkse kostenbesparing]],\n   NA())","v":{"$error":"#VALUE!"}},{"$f":"IF(tblAEE[[#This Row],[Classificatie]]=\"Direct\",\n     IFERROR(IF(N(tblAEE[[#This Row],[TVT (jaren)]])>5,\n           N(tblAEE[[#This Row],[Investeringskost (definitief)]])*((N(tblAEE[[#This Row],[TVT (jaren)]])-5)/N(tblAEE[[#This Row],[TVT (jaren)]])),\n           0),\n        0),\n IF(tblAEE[[#This Row],[Classificatie]]=\"Indirect\",\n     IF(tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\",\n         30%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"studie\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         80%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"monitor\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         60%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n         0))),\n 0))","v":0},{"$f":"ROUND(MAX(0,tblAEE[[#This Row],[Steun (per maatregel; indicatief volgens reglement)]]-tblAEE[[#This Row],[Subsidiesteun reeds ontvangen]]),-3)","v":0},{"$f":"IFERROR(\n_xlfn.XLOOKUP(\ntblAEE[[#This Row],[Type Maatregel]],Levensduur[Type Maatregel],Levensduur[Levensduur (jr)]),\n\"Error\")","v":15},"NVT",{"$f":"IF(\nOR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\n\"Niet scorend\",\nIF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (kWh/jr)]]),\ntblAEE[[#This Row],[Energiebesparing (kWh/jr)]]/1000,\n0)\n)","v":"Niet scorend"},{"$f":"IF(OR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\"Nee\",\"Ja\")","v":"Nee"},{"$f":"IF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]),tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]*tblAEE[[#This Row],[Levensduur (jr)]],\"\")","v":""},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse CO2-besparing]]),\ntblAEE[[#This Row],[Jaarlijkse CO2-besparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\n0\n)","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]),\nIF(Assumpties!$D$15=0,\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*(( (1+Assumpties!$D$15)^tblAEE[[#This Row],[Levensduur (jr)]] -1 ) / Assumpties!$D$15)\n),\n0\n)","v":0},{"$f":"TRIM(tblAEE[[#This Row],[Type Maatregel]])&\"|\"&TRIM(tblAEE[[#This Row],[Werktitel]])","v":"Indirecte maatregel(en)|0"}]
[{"$f":"_xlfn.XLOOKUP(tblAEE[[#This Row],[Type Maatregel]],Table2[Maatregel],Table2[Aangevraagd])","v":"Nee"},"Andere",{"$f":"_xlfn.LET(_xlpm.t,tblAEE[[#This Row],[Type Maatregel]],\n_xlfn.SWITCH(_xlpm.t,\n \"Muurisolatie\",\"Direct\",\n \"Dakisolatie\",\"Direct\",\n \"Vloerisolatie\",\"Direct\",\n \"Schrijnwerkrenovatie\",\"Direct\",\n \"Regeltechnisch\",\"Direct\",\n \"Relighting\",\"Direct\",\n \"Warmtepompen en koeling\",\"Direct\",\n \"Warmtenetkoppeling\",\"Direct\",\n \"Hernieuwbare Energie\",\"Direct\",\n \"Indirecte maatregel(en)\",\"Indirect\",\n \"Flex & Opslag\",\"FlexOpslag\",\n \"Andere\",\"Direct\",\n \"Direct\"))","v":"Direct"},{"$f":"Andere!C6","v":0},{"$f":"Andere!C7","v":0},{"$f":"Andere!C9","v":0},{"$f":"Andere!C11","v":0},{"$f":"Andere!C29","v":0},"NVT","NVT",{"$f":"IF(tblAEE[[#This Row],[investering overschreven door offerte?]]=\"Ja\",\n   tblAEE[[#This Row],[Investeringskost offerte]],\n   tblAEE[[#This Row],[Investeringskost]])","v":0},{"$f":"Andere!C30","v":0},{"$f":"Andere!C31","v":0},{"$f":"Andere!C32","v":0},{"$f":"IF(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]>0,\n   tblAEE[[#This Row],[Investeringskost (definitief)]]/tblAEE[[#This Row],[Jaarlijkse kostenbesparing]],\n   NA())","v":{"$error":"#N/A"}},{"$f":"IF(tblAEE[[#This Row],[Classificatie]]=\"Direct\",\n     IFERROR(IF(N(tblAEE[[#This Row],[TVT (jaren)]])>5,\n           N(tblAEE[[#This Row],[Investeringskost (definitief)]])*((N(tblAEE[[#This Row],[TVT (jaren)]])-5)/N(tblAEE[[#This Row],[TVT (jaren)]])),\n           0),\n        0),\n IF(tblAEE[[#This Row],[Classificatie]]=\"Indirect\",\n     IF(tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\",\n         30%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"studie\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         80%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n     IF(IFERROR(ISNUMBER(SEARCH(\"monitor\",tblAEE[[#This Row],[Bijkomende uitleg]])),FALSE),\n         60%*N(tblAEE[[#This Row],[Investeringskost (definitief)]]),\n         0))),\n 0))","v":0},{"$f":"ROUND(MAX(0,tblAEE[[#This Row],[Steun (per maatregel; indicatief volgens reglement)]]-tblAEE[[#This Row],[Subsidiesteun reeds ontvangen]]),-3)","v":0},{"$f":"IFERROR(\n_xlfn.XLOOKUP(\ntblAEE[[#This Row],[Type Maatregel]],Levensduur[Type Maatregel],Levensduur[Levensduur (jr)]),\n\"Error\")","v":15},{"$f":"SUM(Andere!C32:C33)","v":0},{"$f":"IF(\nOR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\n\"Niet scorend\",\nIF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (kWh/jr)]]),\ntblAEE[[#This Row],[Energiebesparing (kWh/jr)]]/1000,\n0)\n)","v":0},{"$f":"IF(OR(tblAEE[[#This Row],[Type Maatregel]]=\"Indirecte maatregel(en)\",tblAEE[[#This Row],[Type Maatregel]]=\"Flex & Opslag\"),\"Nee\",\"Ja\")","v":"Ja"},{"$f":"IF(ISNUMBER(tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]),tblAEE[[#This Row],[Energiebesparing (MWh/jr)]]*tblAEE[[#This Row],[Levensduur (jr)]],\"\")","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse CO2-besparing]]),\ntblAEE[[#This Row],[Jaarlijkse CO2-besparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\n0\n)","v":0},{"$f":"IF(\nISNUMBER(tblAEE[[#This Row],[Jaarlijkse kostenbesparing]]),\nIF(Assumpties!$D$15=0,\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*tblAEE[[#This Row],[Levensduur (jr)]],\ntblAEE[[#This Row],[Jaarlijkse kostenbesparing]]*(( (1+Assumpties!$D$15)^tblAEE[[#This Row],[Levensduur (jr)]] -1 ) / Assumpties!$D$15)\n),\n0\n)","v":0},{"$f":"TRIM(tblAEE[[#This Row],[Type Maatregel]])&\"|\"&TRIM(tblAEE[[#This Row],[Werktitel]])","v":"Andere|0"}]
[]
[]
[]
[]
["Totalen:"]
[{"$f":"SUM(tblAEE[Maatregel Aangevraagd?])","v":0},{"$f":"SUM(tblAEE[Type Maatregel])","v":0},{"$f":"SUM(tblAEE[Werktitel])","v":0},{"$f":"SUM(tblAEE[Referentiecode Terra])","v":0},{"$f":"SUM(tblAEE[Bijkomende uitleg])","v":0},{"$f":"SUM(tblAEE[Subsidiesteun reeds ontvangen])","v":0},{"$f":"SUM(tblAEE[Investeringskost])","v":0},{"$f":"SUM(tblAEE[investering overschreven door offerte?])","v":0},{"$f":"SUM(tblAEE[Investeringskost offerte])","v":0},{"$f":"SUM(tblAEE[Jaarlijkse kostenbesparing])","v":0},null,{"$f":"SUM(tblAEE[Jaarlijkse CO2-besparing])","v":0},{"$f":"SUM(tblAEE[Elektriciteitsbesparing])","v":0},null,null,{"$f":"SUM(tblAEE[Steun (per maatregel; indicatief volgens reglement)])","v":0},{"$f":"SUM(tblAEE[Finale Steun na aftrekken reeds ontvangen subsidies])","v":0},null,{"$f":"SUM(tblAEE[Energiebesparing (kWh/jr)])","v":0},{"$f":"SUM(tblAEE[Energiebesparing (MWh/jr)])","v":0},null,{"$f":"SUM(tblAEE[Energiebesparing levensduur (MWh)])","v":0},{"$f":"SUM(tblAEE[CO2 besparing levensduur (ton)])","v":0},{"$f":"SUM(tblAEE[Totale besparing energiekosten levensduur (€)])","v":0}]

{"sheet":"Lijsten","index":17,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Organisaties"]
["Agentschap Integratie en Inburgering"]
["Agentschap Plantentuin Meise"]
["Agentschap voor Maritieme Dienstverlening en Kust"]
["Agentschap voor Natuur en Bos"]
["Agentschap Wegen en Verkeer"]
["de Rand"]
["De Vlaamse Radio- en Televisieomroeporganisatie"]
["De Vlaamse Waterweg"]
["Departement Cultuur, Jeugd en Media"]
["Departement Mobiliteit en Openbare Werken"]
["Instituut voor Landbouw-, Visserij- en Voedingsonderzoek"]
["Agentschap Opgroeien"]
["Agentschap Opgroeien Regie"]
["Limburgse Reconversiemaatschappij"]
["Muntpunt"]
["Sport Vlaanderen"]
["Vlaamse Dienst voor Arbeidsbemiddeling en Beroepsopleiding"]
["Vlaamse Instelling voor Technologisch Onderzoek"]
["Vlaamse Milieumaatschappij"]
["Vlaamse Vervoermaatschappij - De Lijn zonder tractie"]

{"sheet":"AEE_Config","index":18,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[14017275]
[null,14017275]