{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Start","Lijst","Subtotalen","Import","ImportTxt","Instellingen","Menu","NAV"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":10,"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":94,"n_cols":2,"rows_kept":94,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["¡","Algemeen"]
[null,"Deze applicatie is geschikt voor Excel 365 / 2007 / 2010, 2013 en 2016, 32 bit, platform Windows."]
[null,"Let op dat de laatste updates zijn geïnstalleerd."]
[]
[null,"Dit bestand dient normaal geopend te worden. Voorkomen moet worden dat op "]
[null,"'Bewerken inschakelen' geklikt moet worden."]
[null,"Indien een bestand vanuit de mail is opgeslagen kan het bestand geblokkeerd zijn."]
[null,"In dat geval dient de blokkering opgeheven te worden voordat het bestand in Excel wordt geopend:"]
[null,"Klik in de Verkenner met de rechtermuisknop op de bestandsnaam, kies eigenschappen en klik"]
[null,"op de knop 'Blokkering opheffen'."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Voor een goede werking van dit programma is het belangrijk dat de macro's zijn ingeschakeld."]
[null,"Dit kan als volgt worden ingesteld:"]
[null,"1. Office/Bestand-knop (linksboven)"]
[null,"2. Opties voor Excel"]
[null,"3. Vertrouwenscentrum"]
[null,"4. Instellingen voor het Vertrouwenscentrum..."]
[null,"5a. Instellingen voor macro's: de 4e optie inschakelen"]
[null,"5b. Instellingen voor bestandsblokkering: bij de eerste 4 items alles uitschakelen"]
[null,"Hierna Excel herstarten."]
[]
[null,"Bij het openen van dit bestand wordt het menu in het lint (rechtsboven) opgebouwd."]
[null,"Via dit menu kunnen alle voorkomende specifieke acties worden uitgevoerd."]
[null,"Dit menu wordt bij het sluiten van het bestand weer verwijderd."]
[]
["¡","Beveiliging"]
[null,"Alle normaal voorkomende acties dienen met ingeschakelde beveiliging kunnen worden uitgevoerd."]
[null,"Nadat de beveiliging is uitgeschakeld zijn alle bladen zichtbaar en zijn alle cellen muteerbaar."]
[null,"In deze situatie kunnen door de beheerder allerlei instellingen worden doorgevoerd."]
[null,"Let op dat er geen formules worden gewijzigd en dat de indeling van de bladen in tact blijft."]
[null,"Het wachtwoord kan worden ingesteld in het blad Instellingen."]
[]
["¡","Werking"]
[null,"Voordat dit programma in gebruik kan worden genomen dienen de juiste instellingen doorgevoerd"]
[null,"te zijn. (Hiertoe dient de beveiliging eerst uitgeschakeld te worden)."]
[]
[null,"Via de betreffende knop kunnen één of meerdere XML-bestanden worden geïmporteerd en worden"]
[null,"verwerkt tot rapportages (facturen)."]
[null,"Deze rapportages kunnen als pdf-bestand worden opgeslagen."]

{"sheet":"Lijst","index":1,"n_rows":1,"n_cols":15,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["FaktuurNr","Faktuurdatum","Incassodatum","Leveringsdatum","OrderNr","Order referentie","Totaal Bruto","Aantal","Artikelcode","Bedrag Bruto","Omschrijving","Detail","Naam","Adres","PK en Plaats"]

{"sheet":"Subtotalen","index":2,"n_rows":1,"n_cols":10,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["UBN","Naam","Adres","PK en Plaats","Ordertotaal",null,"Order","Orderdatum","Orderref","Ordertotaal"]

{"sheet":"Import","index":3,"n_rows":1,"n_cols":50,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["ns1:A402617CodeMuntsoort","ns1:A201029SoortOverzicht","ns1:A201136Faktuurnummer","ns1:A201134Faktuurdatum","ns1:A203817DatumIncasso","ns1:A800004UniekBerichtNummer","ns1:A800006AssociationAssignedCode","ns1:A204654Toelichting","ns1:A700129Naam","ns1:A700766PostadresStraat","ns1:A700767PostadresHuisnummer","ns1:A700768PostadresPlaats","ns1:A204587PostadresPostcode","ns1:A700770PostadresLand","ns1:A204581Iban","ns1:A204582Bic","ns1:A700129Naam2","ns1:A700766PostadresStraat3","ns1:A700767PostadresHuisnummer4","ns1:A700768PostadresPlaats5","ns1:A204587PostadresPostcode6","ns1:A700770PostadresLand7","ns1:A203813Relatienummer","ns1:A203838CodeBetaling","ns1:A702078Regelnummer","ns1:A702164DatumLevering","ns1:A300225BonnummerLeveringsbon","ns1:A702165Leveringsbonregelnummer","ns1:A702827OrderNummerLeverancier","ns1:A203811BedragBrutoExBtw","ns1:A203862BedragNettoExBtw","ns1:A203822HoeveelheidProdukt","ns1:A204652Eenheid","ns1:A204479DetailKlant","ns1:A203819Artikelcode","ns1:A401013PrijsBruto","ns1:A203820OmschrijvingProdukt","ns1:A202637Btw","ns1:A702004BedragBtw","ns1:A202637Btw8","ns1:A203836BtwGrondslag","ns1:A702004BedragBtw9","ns1:A700154Bedrag","ns1:A204655Bedragqualifier","Orderdatum","Referentie","Naam","Adres voll","Adres","PK en Plaats"]

{"sheet":"ImportTxt","index":4,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["OrderNummerLeverancier","Artikelcode","Orderdatum","Referentie",null,"UBN","Naam","Adres"]

{"sheet":"Instellingen","index":5,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
["Versie",null,"Wachtwoord",null,null,"FaktuurNr","C",3,null,"A","ns1:A402617CodeMuntsoort"]
["3.0",null,null,null,null,"Faktuurdatum","D",4,null,"B","ns1:A201029SoortOverzicht"]
[null,null,null,null,null,"Incassodatum","E",5,null,"C","ns1:A201136Faktuurnummer"]
[null,null,null,null,null,"Leveringsdatum","Z",26,null,"D","ns1:A201134Faktuurdatum"]
[null,null,null,null,null,"OrderNr","AC",29,null,"E","ns1:A203817DatumIncasso"]
[null,null,null,null,null,"Order referentie","AT",46,null,"F","ns1:A800004UniekBerichtNummer"]
[null,null,null,null,null,"Totaal Bruto","AD",30,null,"G","ns1:A800006AssociationAssignedCode"]
[null,null,null,null,null,"Aantal","AF",32,null,"H","ns1:A204654Toelichting"]
[null,null,null,null,null,"Artikelcode","AI",35,null,"I","ns1:A700129Naam"]
[null,null,null,null,null,"Bedrag Bruto","AJ",36,null,"J","ns1:A700766PostadresStraat"]
[null,null,null,null,null,"Omschrijving","AK",37,null,"K","ns1:A700767PostadresHuisnummer"]
[null,null,null,null,null,"Detail","AH",34,null,"L","ns1:A700768PostadresPlaats"]
[null,null,null,null,null,"Naam","AU",47,null,"M","ns1:A204587PostadresPostcode"]
[null,null,null,null,null,"Adres","AW",49,null,"N","ns1:A700770PostadresLand"]
[null,null,null,null,null,"PK en Plaats","AX",50,null,"O","ns1:A204581Iban"]
[null,null,null,null,null,null,null,null,null,"P","ns1:A204582Bic"]
[null,null,null,null,null,null,null,null,null,"Q","ns1:A700129Naam2"]
[null,null,null,null,null,null,null,null,null,"R","ns1:A700766PostadresStraat3"]
[null,null,null,null,null,null,null,null,null,"S","ns1:A700767PostadresHuisnummer4"]
[null,null,null,null,null,null,null,null,null,"T","ns1:A700768PostadresPlaats5"]
[null,null,null,null,null,null,null,null,null,"U","ns1:A204587PostadresPostcode6"]
[null,null,null,null,null,null,null,null,null,"V","ns1:A700770PostadresLand7"]
[null,null,null,null,null,null,null,null,null,"W","ns1:A203813Relatienummer"]
[null,null,null,null,null,null,null,null,null,"X","ns1:A203838CodeBetaling"]
[null,null,null,null,null,null,null,null,null,"Y","ns1:A702078Regelnummer"]
[null,null,null,null,null,null,null,null,null,"Z","ns1:A702164DatumLevering"]
[null,null,null,null,null,null,null,null,null,"AA","ns1:A300225BonnummerLeveringsbon"]
[null,null,null,null,null,null,null,null,null,"AB","ns1:A702165Leveringsbonregelnummer"]
[null,null,null,null,null,null,null,null,null,"AC","ns1:A702827OrderNummerLeverancier"]
[null,null,null,null,null,null,null,null,null,"AD","ns1:A203811BedragBrutoExBtw"]
[null,null,null,null,null,null,null,null,null,"AE","ns1:A203862BedragNettoExBtw"]
[null,null,null,null,null,null,null,null,null,"AF","ns1:A203822HoeveelheidProdukt"]
[null,null,null,null,null,null,null,null,null,"AG","ns1:A204652Eenheid"]
[null,null,null,null,null,null,null,null,null,"AH","ns1:A204479DetailKlant"]
[null,null,null,null,null,null,null,null,null,"AI","ns1:A203819Artikelcode"]
[null,null,null,null,null,null,null,null,null,"AJ","ns1:A401013PrijsBruto"]
[null,null,null,null,null,null,null,null,null,"AK","ns1:A203820OmschrijvingProdukt"]
[null,null,null,null,null,null,null,null,null,"AL","ns1:A202637Btw"]
[null,null,null,null,null,null,null,null,null,"AM","ns1:A702004BedragBtw"]
[null,null,null,null,null,null,null,null,null,"AN","ns1:A202637Btw8"]
[null,null,null,null,null,null,null,null,null,"AO","ns1:A203836BtwGrondslag"]
[null,null,null,null,null,null,null,null,null,"AP","ns1:A702004BedragBtw9"]
[null,null,null,null,null,null,null,null,null,"AQ","ns1:A700154Bedrag"]
[null,null,null,null,null,null,null,null,null,"AR","ns1:A204655Bedragqualifier"]
[null,null,null,null,null,null,null,null,null,"AS","Orderdatum"]
[null,null,null,null,null,null,null,null,null,"AT","Referentie"]
[null,null,null,null,null,null,null,null,null,"AU","Naam"]
[null,null,null,null,null,null,null,null,null,"AV","Adres voll"]
[null,null,null,null,null,null,null,null,null,"AW","Adres"]
[null,null,null,null,null,null,null,null,null,"AX","PK en Plaats"]

{"sheet":"Menu","index":6,"n_rows":84,"n_cols":2,"rows_kept":84,"cut":false,"hidden":true,"merged":[]}
["<customUI xmlns='http://schemas.microsoft.com/office/2006/01/customui' onLoad=\"Initialiseren\">",2007]
[]
["<ribbon>"]
["<tabs>"]
[{"$f":"\"<tab id=\"&SUBSTITUTE(B5,\" \",\"\")&\" label=\"&B5&\">\"","v":"<tab id=\"GDXMLRapportages\" label=\"GD XML Rapportages\">"},"\"GD XML Rapportages\""]
[]
[{"$f":"\"<group  id=\"&B7&\" label=\"&B7&\" imageMso=\"\"Info\"\">\"","v":"<group  id=\"Algemeen\" label=\"Algemeen\" imageMso=\"Info\">"},"\"Algemeen\""]
[{"$f":"\"<labelControl id=\"\"ID\"&ROW()&\"\"\"\"","v":"<labelControl id=\"ID8\""}]
[{"$f":"\"getLabel=\"&B9","v":"getLabel=\"TekstGebruikersnaam\""},"\"TekstGebruikersnaam\""]
["/>"]
[{"$f":"\"<labelControl id=\"\"ID\"&ROW()&\"\"\"\"","v":"<labelControl id=\"ID11\""}]
[{"$f":"\"getLabel=\"&B12","v":"getLabel=\"TekstVandaag\""},"\"TekstVandaag\""]
["/>"]
[{"$f":"\"<labelControl id=\"\"ID\"&ROW()&\"\"\"\"","v":"<labelControl id=\"ID14\""}]
[{"$f":"\"getLabel=\"&B15","v":"getLabel=\"TekstVersie\""},"\"TekstVersie\""]
["/>"]
[{"$f":"\"<button id=\"\"ID\"&ROW()&\"\"\"\"","v":"<button id=\"ID17\""}]
[{"$f":"\"label=\"&B18","v":"label=\"De Gezondheidsdienst voor Dieren\""},"\"De Gezondheidsdienst voor Dieren\""]
[{"$f":"\"size=\"&B19","v":"size=\"large\""},"\"large\""]
[{"$f":"\"onAction=\"&B20","v":"onAction=\"Info\""},"\"Info\""]
[{"$f":"\"imageMso=\"&B21","v":"imageMso=\"Info\""},"\"Info\""]
["/>"]
["</group>"]
[]
[{"$f":"\"<group  id=\"&B25&\" label=\"&B25&\" imageMso=\"\"ExportExcel\"\">\"","v":"<group  id=\"Start\" label=\"Start\" imageMso=\"ExportExcel\">"},"\"Start\""]
[{"$f":"\"<button id=\"\"ID\"&ROW()&\"\"\"\"","v":"<button id=\"ID26\""}]
[{"$f":"\"label=\"&B27","v":"label=\"Importeer XML bestanden(en) en genereer rapportages\""},"\"Importeer XML bestanden(en) en genereer rapportages\""]
[{"$f":"\"size=\"&B28","v":"size=\"large\""},"\"large\""]
[{"$f":"\"onAction=\"&B29","v":"onAction=\"ImporteerXML\""},"\"ImporteerXML\""]
[{"$f":"\"imageMso=\"&B30","v":"imageMso=\"ImportExcel\""},"\"ImportExcel\""]
["/>"]
["</group>"]
[]
[{"$f":"\"<group  id=\"&B34&\" label=\"&B34&\" imageMso=\"\"QueryShowTable\"\">\"","v":"<group  id=\"Documenten\" label=\"Documenten\" imageMso=\"QueryShowTable\">"},"\"Documenten\""]
[{"$f":"\"<button id=\"\"ID\"&ROW()&\"\"\"\"","v":"<button id=\"ID35\""}]
[{"$f":"\"label=\"&B36","v":"label=\"Geselecteerde bladen opslaan (pdf)\""},"\"Geselecteerde bladen opslaan (pdf)\""]
[{"$f":"\"size=\"&B37","v":"size=\"large\""},"\"large\""]
[{"$f":"\"onAction=\"&B38","v":"onAction=\"GenereerPDF\""},"\"GenereerPDF\""]
[{"$f":"\"imageMso=\"&B39","v":"imageMso=\"FileSaveAsPdfOrXps\""},"\"FileSaveAsPdfOrXps\""]
["/>"]
["</group>"]
[]
[{"$f":"\"<group  id=\"&B43&\" label=\"&B43&\" imageMso=\"\"ExportExcel\"\">\"","v":"<group  id=\"Reset\" label=\"Reset\" imageMso=\"ExportExcel\">"},"\"Reset\""]
[{"$f":"\"<button id=\"\"ID\"&ROW()&\"\"\"\"","v":"<button id=\"ID44\""}]
[{"$f":"\"label=\"&B45","v":"label=\"Alles wissen (reset)\""},"\"Alles wissen (reset)\""]
[{"$f":"\"size=\"&B46","v":"size=\"large\""},"\"large\""]
[{"$f":"\"onAction=\"&B47","v":"onAction=\"Reset\""},"\"Reset\""]
[{"$f":"\"imageMso=\"&B48","v":"imageMso=\"Delete\""},"\"Delete\""]
["/>"]
["</group>"]
[]
[{"$f":"\"<group  id=\"&B52&\" label=\"&B52&\">\"","v":"<group  id=\"Afdrukken\" label=\"Afdrukken\">"},"\"Afdrukken\""]
[{"$f":"\"<button id=\"\"ID\"&ROW()&\"\"\"\"","v":"<button id=\"ID53\""}]
[{"$f":"\"label=\"&B54","v":"label=\"Huidig blad afdrukken\""},"\"Huidig blad afdrukken\""]
[{"$f":"\"onAction=\"&B55","v":"onAction=\"AfdrukHuidig\""},"\"AfdrukHuidig\""]
[{"$f":"\"size=\"&B56","v":"size=\"large\""},"\"large\""]
[{"$f":"\"imageMso=\"&B57","v":"imageMso=\"FilePrintPreview\""},"\"FilePrintPreview\""]
["/>"]
["</group>"]
[]
[{"$f":"\"<group  id=\"&B61&\" label=\"&B61&\">\"","v":"<group  id=\"Beveiliging\" label=\"Beveiliging\">"},"\"Beveiliging\""]
[{"$f":"\"<toggleButton id=\"\"ID\"&ROW()&\"\"\"\"","v":"<toggleButton id=\"ID62\""}]
[{"$f":"\"label=\"&B63","v":"label=\"Beveiliging\""},"\"Beveiliging\""]
[{"$f":"\"size=\"&B64","v":"size=\"large\""},"\"large\""]
[{"$f":"\"onAction=\"&B65","v":"onAction=\"ToggleBeveiliging\""},"\"ToggleBeveiliging\""]
[{"$f":"\"imageMso=\"&B66","v":"imageMso=\"ProtectDocument\""},"\"ProtectDocument\""]
[{"$f":"\"getPressed=\"&B67","v":"getPressed=\"GetPressedBeveiliging\""},"\"GetPressedBeveiliging\""]
[{"$f":"\"getEnabled=\"&B68","v":"getEnabled=\"GetEnabledBeveiliging\""},"\"GetEnabledBeveiliging\""]
["/>"]
["</group>"]
[]
[{"$f":"\"<group  id=\"&B72&\" label=\"&B72&\">\"","v":"<group  id=\"Help\" label=\"Help\">"},"\"Help\""]
[{"$f":"\"<button id=\"\"ID\"&ROW()&\"\"\"\"","v":"<button id=\"ID73\""}]
[{"$f":"\"label=\"&B74","v":"label=\"Help\""},"\"Help\""]
[{"$f":"\"size=\"&B75","v":"size=\"large\""},"\"large\""]
[{"$f":"\"onAction=\"&B76","v":"onAction=\"Help\""},"\"Help\""]
[{"$f":"\"imageMso=\"&B77","v":"imageMso=\"TentativeAcceptInvitation\""},"\"TentativeAcceptInvitation\""]
["/>"]
["</group>"]
[]
["</tab>"]
["</tabs>"]
["</ribbon>"]
["</customUI>"]

{"sheet":"NAV","index":7,"n_rows":6,"n_cols":28,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"Soort","Nr.","Artikelen Code","Omschrijving","Aantal","Eenheidscode","Directe kostprijs Excl. btw","Regelbedrag Excl. btw","Regelkortingbedrag","Productboekingsgroep","Btw-productboekingsgroep","Bedrag","Productfase","KPL/Koppelnr","KP-code","Bedrijfsboekingsgroep","Btw-bedrijfsboekingsgroep"]
[null,null,null,null,null,null,null,null,null,null,null,"Grootboekrekening","01100","","div onderzoekskst GD",1,"",{"$f":"E2","v":0},{"$f":"R2","v":0},null,"DIENST","DNST-HOOG",{"$f":"S2","v":0},null,null,"VETERINARY AND VACCI","BINNENLAND","BINNENLAND"]
[null,null,null,null,null,null,null,null,null,null,null,"Grootboekrekening","01100","","div onderzoekskst GD",1,"",{"$f":"E3","v":0},{"$f":"R3","v":0},null,"DIENST","DNST-HOOG",{"$f":"S3","v":0},null,null,"VETERINARY AND VACCI","BINNENLAND","BINNENLAND"]
[null,null,null,null,null,null,null,null,null,null,null,"Grootboekrekening","01100","","div onderzoekskst GD",1,"",0,0,null,"DIENST","DNST-HOOG",0,null,null,"VETERINARY AND VACCI","BINNENLAND","BINNENLAND"]
[null,null,null,null,null,null,null,null,null,null,null,"Grootboekrekening","01100","","div onderzoekskst GD",1,"",0,0,null,"DIENST","DNST-HOOG",0,null,null,"VETERINARY AND VACCI","BINNENLAND","BINNENLAND"]
[null,null,null,null,null,null,null,null,null,null,null,"Grootboekrekening","01100","","div onderzoekskst GD",1,"",0,0,null,"DIENST","DNST-HOOG",0,null,null,"VETERINARY AND VACCI","BINNENLAND","BINNENLAND"]