{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Start","Adressen","CSV-bestand aanmaken","Lijsten","DB_Tijdelijk"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":19,"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":"Start","index":0,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,2,5,5],[11,2,11,5],[7,2,7,5],[14,2,14,5]]}
[]
[]
[]
[]
[]
[null,null,"Hulpbestand CSV-upload EED-Auditplicht"]
[]
[null,null,{"$f":"\"Versie \" & LIJSTEN_VERSIE","v":"Versie 1.0.0"}]
[]
[null,null,"Welkom!"]
[]
[null,null,"Met dit Excel-hulpbestand kunt het CSV-gegevensbestand aanmaken waarin de adressen van de vestigingen van uw onderneming staan. Het aangemaakte CSV-gegevensbestand kunt u vervolgens indienen in het eLoket om aan uw EED-Auditplicht te voldoen.  \n\nKlik op de 'i' rechtsboven voor aanvullende informatie, invultips en release notes. Hier vindt u ook de handleiding."]
[]
[null,null,"Beknopte instructies"]
[null,null,"Sla dit bestand op uw lokale harde schijf op en werk vanuit daar verder. Vul het werkblad 'Adressen' in en klik vervolgens op de knop 'CSV-bestand aanmaken' op het gelijknamige werkblad. Dien het aangemaakte CSV-bestand in in eLoket."]

{"sheet":"Adressen","index":1,"n_rows":255,"n_cols":6,"rows_kept":255,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Adresgegevens alle vestigingen"]
[]
[null,"Straat","Huisnummer","Huisnummertoevoeging","Vestigingspostcode","Validatie_totaal"]
[null,"Straat\n(Géén postbus)","Huisnummer","Huisnummer-toevoeging","Postcode","Volledig?"]
[null,null,null,null,null,{"$f":"IF(COUNTA(B6:E6)=0,\"\",IF(COUNTA(B6:C6,E6:E6)=3,1,0))","v":""}]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(COUNTA(B70:E70)=0,\"\",IF(COUNTA(B70:C70,E70:E70)=3,1,0))","v":""}]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(COUNTA(B134:E134)=0,\"\",IF(COUNTA(B134:C134,E134:E134)=3,1,0))","v":""}]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(COUNTA(B198:E198)=0,\"\",IF(COUNTA(B198:C198,E198:E198)=3,1,0))","v":""}]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]

{"sheet":"CSV-bestand aanmaken","index":2,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[5,2,5,5],[7,2,7,5],[11,2,11,5]]}
[]
[]
[]
[]
[]
[null,null,"Hulpbestand CSV-upload EED-Auditplicht"]
[]
[null,null,{"$f":"\"Versie \" & LIJSTEN_VERSIE","v":"Versie 1.0.0"}]
[]
[null,null,"CSV-bestand aanmaken"]
[]
[null,null,"Na het invullen van het werkblad 'Adressen' drukt u op de onderstaande knop 'CSV-bestand aanmaken'. Het aangemaakte CSV-bestand kunt u vervolgens indienen in het eLoket om aan de EED-Auditplicht te voldoen."]

{"sheet":"Lijsten","index":3,"n_rows":64,"n_cols":3,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
[]
[null,"LIJSTEN_VERSIE","1.0.0"]
[null,"LIJSTEN_ONTWIKKELMODUS","Uit"]
[null,"LIJSTEN_VALIDATIE_ADRESSEN_AKKOORD",{"$f":"IF(COUNTIF(tbl_ADRESSEN[Volledig?],0)>0,FALSE,TRUE)","v":true}]
[null,"LIJSTEN_FOUTENAFHANDELING_INGESCHAKELD",true]
[null,"LIJSTEN_STARTBERICHT_TONEN",true]
[null,"LIJSTEN_GESELECTEERD_WERKBOEK"]
[]
[]
[null,"Naam object: \"Handleiding_XML_upload\""]
[]
[null,"LIJSTEN_VALIDATIEBERICHTEN_MAATREGELEN"]
[null,"Validatie_volledig_eerste_kolommen","Er ontbreken gegevens in de eerste vijf kolommen van de maatregelentabel. "]
[null,"Validatie_uitgevoerd","Geef aan of deze maatregel is uitgevoerd."]
[null,"Validatie_geheel_gedeeltelijk","Geef aan of deze maatregel geheel of gedeeltelijk is uitgevoerd."]
[null,"Validatie_niet_uitgevoerd","Geef aan waarom de maatregel niet is uitgevoerd."]
[null,"Validatie_Variant","Geef van elk van de mogelijke varianten aan of deze al dan niet van toepassing is. Ten minste één van de varianten moet van toepassing zijn. \nNB: Selecteer: \"Nee\" bij 'Uitgevoerd*' (en vervolgens \"Niet van toepassing\" bij 'Niet uitgevoerd omdat...') als geen van de varianten van toepassing zijn."]
[null,"Validatie_technische_randvoorwaarden","Geef van beide randvoorwaarden aan of er aan is voldaan of niet. Aan ten minste één van beide randvoorwaarden moet niet zijn voldaan."]
[null,"Validatie_alternatief","Geef een omschrijving van de alternatieve maatregel."]
[]
[null,"Onderstaande helpteksten kunnen worden aangepast en worden zichtbaar in het informatie-dialoogvenster."]
[]
[null,"LIJSTEN_INFO_TAB_START","INTRODUCTIE\n\nDit hulpbestand gebruikt u om voor de EED-Auditplicht adressen van uw locaties vast te leggen en daarvan een CSV-bestand te maken. Dit CSV-bestand kunt u uploaden bij uw rapportage in eLoket. \n\nLet op: sla dit bestand op uw lokale harde schijf op en werk vanuit daar verder.\n\nALGEMENE INSTRUCTIES\n\nDoorloop de volgende stappen om het CSV-bestand aan te maken:\n\n1.\tVul het werkbladen ‘Adressen’ volledig in.\n\n2.\tSla het hulpbestand tussentijds op.\n\n3.\tKlik op de knop ‘CSV-bestand aanmaken’ op werkblad 'CSV-bestand aanmaken'. U krijgt een terugkoppeling op het scherm zodra het CSV-bestand is aangemaakt. Het CSV-bestand wordt automatisch in dezelfde map opgeslagen als waar dit Hulpbestand staat.\n\n4.\tGebruik het aangemaakte CSV-bestand bij uw rapportage in eLoket."]
[null,"LIJSTEN_INFO_TAB_MAATREGELEN","INSTRUCTIE\nVul het werkblad 'Adressen' per rij volledig in.\n\nVoer alleen daadwerkelijke adressen en vestigingen in. Géén postbusadressen.\n\nGeen plaatsnamen invullen.\n\nLet op, de postcode heeft een vast format: ####XX, voorbeeld 1000AA.\n\nIn dit Hulpbestand wordt niet gecontroleerd of de postcode een bekende postcode is. Die controle vindt plaats na het uploaden van het bestand in eLoket. "]
[null,"LIJSTEN_INFO_TAB_INFO","INFORMATIE\n\nDit Excel-hulpbestand voor de CSV-upload Onderzoeksplicht is door de Rijksdienst voor Ondernemend Nederland (RVO) ontwikkeld. \n\nDit bestand is voorzien van een digitale ondertekening door de Rijksoverheid. Controleer bij het gebruik van dit bestand of deze ondertekening aanwezig is. Gebruik het bestand niet als deze ondertekening ontbreekt. Mogelijk werkt het bestand niet goed meer of bevat het schadelijke inhoud.\n\nDit bestand is getest voor Excel 2022. Eerdere versies van Excel vertonen mogelijk functionele beperkingen. Neem contact op met de helpdesk van RVO.nl als u een foutmelding krijgt: 088 042 42 42.\n\nVrijgavenotities (wijziging ten opzichte van voorgaande versie)\n\nVersie 1.0.0. - Oorspronkelijke versie."]
[null,"LIJSTEN_INFO_TAB_XML","IINSTRUCTIE\n\nKlik op de knop ’CSV-bestanden aanmaken’ op werkblad ‘CSV-bestanden aanmaken’. Er vind dan eerst een controle plaats op alle ingevoerde gegevens. Als er geen fouten zijn worden de CSV-gegevensbestanden aangemaakt.\n\nDe CSV-gegevensbestanden worden  automatisch in dezelfde map geplaatst en van een unieke naam met voorzien. Nadat de bestand en zijn aangemaakt kunt u ze inzien door er dubbel op te klikken. In veel gevallen zal het bestand dan in Excel zichtbaar zijn. \n\nGebruik de aangemaakte CSV-bestanden bij uw rapportage in eLoket."]
[null,"LIJSTEN_INFO_TAB_FAQ","VEELGESTELDE VRAGEN\n\n1. Is het CSV-gegevensbestand dat door dit Exel-hulpbestand wordt aangemaakt goed vormgegeven zodat het in één keer kan worden ingelezen in eLoket?\nJa, dat is het geval. Mocht u toch problemen ondervinden. Neem dan contact op met de helpdesk van RVO.nl: 088 042 42 42 .\n\n2. Ik krijg een foutmelding die ik niet snap, wat moet ik doen?\nGa eerst naar het werkblad 'Adressen'. Hier staat bondig beschreven wat de fout is. Als het dan nog steeds onduidelijk is raadpleeg dan de helpdesk van RVO.nl.\n\n3. Ik wil mijn CSV-gegevensbestand wijzigen. Hoe doe ik dat?\nU opent het door u ingevulde en opgeslagen hulpbestand. U past de gegevens die wilt wijzigen aan, u slaat het bestand opnieuw op en u klikt op de knop ‘CSV-bestand aanmaken’. \n\n4. Kan ik de invoerde gegevens tussentijds controleren?\nKlik op het validatieicoon in de linkerbovenhoek van de tabel om een validatierapport te maken waarin eventuele validatiefouten staan.\n\n5. Het csv-bestand aanmaken gaat niet goed. Het bestand wordt niet opgeslagen. Wat moet ik doen?\nWaarschijnlijk kunt u geen bestanden aanmaken op de plek waar het hulpbestand staat. Sla het Hulpbestand op op uw lokale harde schijf op en werk vanuit daar verder."]
[null,"LIJSTEN_INFO_TAB_TIPS"]
[]
[null,"LIJSTEN_JAAR_VAN_UITVOERING"]
[null,2021]
[null,2022]
[null,2023]
[]
[null,"LIJSTEN_MOMENT_VAN_UITVOEREN"]
[null,"Optimalisatie"]
[null,"Vroegtijdig"]
[null,"Einde levensduur"]
[null,"Uitbreiding"]
[]
[null,"LIJSTEN_CATEGORIE"]
[null,"Aandrijfsysteem"]
[null,"Procesisolatie"]
[null,"Stoom"]
[null,"Procesbaden"]
[null,"Proceswarmte"]
[null,"Proceskoeling"]
[null,"Productkoeling"]
[null,"Hernieuwbaar"]
[null,"Overig"]
[]
[null,"LIJSTEN_BEOOGD_JAAR_VAN_UITVOERING"]
[null,2024]
[null,2025]
[null,2026]
[null,2027]
[null,"na 2027"]
[null,"niet"]
[]
[null,"LIJSTEN_OMSCHRIJVING_EVENTUELE_BELEMMERING"]
[null,"n.v.t."]
[null,"technisch"]
[null,"bedrijfseconomisch"]
[null,"organisatorisch"]

{"sheet":"DB_Tijdelijk","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}