{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Toelichting & Leeswijzer","Schema"," Verbandscontrole","Openstaande punten","Updates","CSVoutput","Functielijst"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"Toelichting & Leeswijzer","index":0,"n_rows":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,"                           AFD Definitie"]
[null,"Toelichting"]
[null,"Leest u eerst de Instructie specificatie AFD-definitie voor u gebruik maakt van deze XLSM. U vindt de instructie op https://suiv.nl/instructies-en-templates/"]
[]
[null,"Deze XLS ondersteunt u bij het vaststellen van de specificaties voor de AFD-definitie. Hieronder staat uitgelegd hoe de XLSM is opgebouwd. "]
[]
[null,"De opbouw van deze XLSM"]
[null,"Deze XLSM bestaat uit 5 tabbladen:"]
[null,"1: Toelichting & Leeswijzer"]
[null,null,"U vindt hier in het kort informatie over het gebruik van deze XLSM en verwijzingen naar de Instructie specificatie AFD-definitie. "]
[null,"2: Schema"]
[null,null,"In het tabblad Schema meldt u de meta-gegevens voor de AFD-definitie en legt u de specificaties van de AFD-definitie vast. "]
[null,null,"Zie paragraven 3.1, 4.4 en 5.5 in Instructie specificatie AFD-definitie voor meer informatie. "]
[null,"3: Verbandscontroles"]
[null,null,"In het tabblad Verbandscontrole kunt u validatieregels opnemen. Deze verbandscontroles zorgen voor een snellere en betere kwaliteit van invoer door volmacht. "]
[null,null,"Zie paragraaf 3.2 in Instructie specificatie AFD-definitie voor meer informatie. "]
[null,"4: Openstaande punten"]
[null,null,"De tab Openstaande punten is opgenomen voor ondersteuning in interne communicatie over de specificaties van de AFD-definitie. "]
[null,"5: Updates"]
[null,null,"De tab Updates biedt u de optie om beheer te houden over versies in de geleverde AFD-definities."]
[]
[null,"Omzetten naar CSV voor importeren in de Online Samenstellen Tool"]
[null,"In de Online Samenstellen Tool is het mogelijk de benodigde entiteiten en attributen eenvoudig te importeren middels een CSV bestand. "]
[null,"Met onderstaande werkwijze kan dit XLSM omgezet worden naar een CSV bestand. "]
[null,"Verdere toelichting rond de import functie is te vinden in de documentatie van Online Samenstellen."]
[]
[null,null,"Optie 1: Automatisch (Let op, macro's moeten ingeschakeld zijn)"]
[null,null,"1. Druk op de knop 'CSV bestand'."]
[null,null,null,"(Een CSV bestand wordt automatisch opgeslagen in dezelfde map als dit XLSM.)"]
[null,null,"2. Open het CSV bestand."]
[null,null,"3. Gebruik de Excel functie 'Tekst naar kolommen' en kies de optie 'gescheiden' en selecter 'komma's'. Deze excelfunctie is te vinden onder het tabblad gegevens. "]
[null,null,"4. Het CSV vult automatisch de vijf functiekolommen. Is een functie ongebruikt? Verwijder dat kolom."]
[null,null,"5. Bestand is klaar voor importeren."]
[]
[null,null,"Optie 2: Handmatig (Indien macro's niet mogelijk zijn)"]
[null,null,"1. In dit XLS is een tabblad 'CSVoutput' verborgen. Klik met de rechtermuisknop op een bladwijzer en selecteer 'zichtbaar maken'. Kies vervolgens het tabblad 'CSVoutput'"]
[null,null,"2. Kopieer van tabblad 'CSVoutput' kolom I t/m O en plak de waarden in een nieuw Excel bestand."]
[null,null,"3. Sla dit bestand op als 'door komma gescheiden (* .csv)'."]
[null,null,"4. Is een functie ongebruikt? Verwijder dat kolom."]
[null,null,"5. Bestand is klaar voor importeren."]

{"sheet":"Schema","index":1,"n_rows":211,"n_cols":16,"rows_kept":211,"cut":false,"hidden":false,"merged":[[12,6,12,7]]}
["Inventarisatie noodzakelijke attributen "]
["Organisatie:"]
["Branche:"]
["POR maatschappij aanduiding:"]
["AFD Definitie naam:"]
["AFD Definitie versie nummer:"]
["Tag:"]
["Commerciele productnaam:"]
["Bronnen:"]
["Contactpersoon:"]
["E-mail / Telefoon:"]
["Datum:",null,"2022-11-15",null,null,null,"Let op: Actuele versie NVGA Protocol"]
[null,null,null,null,null,null,"NVGA Protocol ",null,"AFD-definitie","AFD-definitie","AFD-definitie","AFD-definitie",null,"AFD-definitie"]
["Entiteit","Attribuut /\n subentiteit","Attribuut/ \nsubentiteit","Attribuut","Codelijst","Omschrijving","NVGA Protocol altijd opnemen","NVGA Protocol te beoordelen","premieBerekening_aanroep","premieBerekening_resultaat","Acceptatie_aanroep","Acceptatie_resultaat","Polis\nInformatie","kunnenAanleveren","Toegestane herhaling/ Waardebeperking","Bevindingen"]
["AL",null,null,null,"","BERICHT ALGEMEEN","V",null,null,null,null,null,null,{"$f":"IF(LEFT(G15,1)=\"X\",\"X\",IF(LEFT(G15,1)=\"V\",\"V\",IF(H15=\"V\",\"V\",IF(I15=\"V\",\"V\",IF(J15=\"V\",\"O\",IF(K15=\"V\",\"O\",IF(L15=\"V\",\"O\",IF(M15=\"V\",\"O\",IF(LEFT(G15,1)=\"O\",\"O\",IF(LEFT(H15,1)=\"O\",\"O\",IF(I15=\"O\",\"O\",IF(J15=\"O\",\"O\",IF(K15=\"O\",\"O\",IF(L15=\"O\",\"O\",IF(M15=\"O\",\"O\",\"LEEG\")))))))))))))))","v":"V"},"maxOccurs 1"]
[null,"ADATMSG",null,null,"","Datum aanmaak bericht","V",null,null,null,null,null,null,"V"]
[null,"APPLNM",null,null,"","Naam verzendende applicatie","O",null,null,null,null,null,null,"O"]
[null,"APPLVS",null,null,"","Versie verzendende applicatie","O",null,null,null,null,null,null,"O"]
[null,"CPREF",null,null,"","Referentie zender","V",null,null,null,null,null,null,"V"]
[null,"FUNCTIE",null,null,"ADNFUN","Berichtfunctie, code","V",null,null,null,null,null,null,"V"]
[null,"INCLGP",null,null,"ADNLOG","Inclusief geroyeerde polissen J/N","O",null,null,null,null,null,null,"O"]
[null,"INCLOP",null,null,"ADNLOG","Inclusief opgeschorte polissen J/N","O",null,null,null,null,null,null,"O"]
[null,"INCLPP",null,null,"ADNLOG","Inclusief premievrij polissen J/N","O",null,null,null,null,null,null,"O"]
[null,"INCLVZ",null,null,"ADNLOG","Inclusief verzekerde personen J/N","V",null,null,null,null,null,null,"V"]
[null,"MNDGP",null,null,"","Max. aantal mnd. geroyeerde polissen","O",null,null,null,null,null,null,"O"]
[null,"VERSIEV",null,null,"ADNVER","Versienummer view, code","V",null,null,null,null,null,null,"V"]
["PK",null,null,null,"","CONTRACT PAKKET","O",null,null,null,null,null,null,"O","maxOccurs 1"]
[null,"NUMMER",null,null,"","Contractnummer","V",null,null,null,null,null,null,"V"]
["RC",null,null,null,"","CONTRACT RAAMCONTRACT","O",null,null,null,null,null,null,"O","maxOccurs 1"]
[null,"NUMMER",null,null,"","Contractnummer","V",null,null,null,null,null,null,"V"]
["PP",null,null,null,"","CONTRACT POLIS/ONDERDEEL","V",null,null,null,null,null,null,"V","maxOccurs 1"]
[null,"ADEFVRS",null,null,"","AFD definitieversienummer","O",null,null,null,null,null,null,"O"]
[null,"AFDDEFN",null,null,"","AFD definitienaam","O",null,null,null,null,null,null,"O"]
[null,"BETTERM",null,null,"","Betaaltermijn in maanden","O",null,null,null,null,null,null,"O"]
[null,"BRANCHE",null,null,"ADNBRA","ADN branchecode","O",null,null,null,null,null,null,"O"]
[null,"CDUUMND",null,null,"","Contractduur in maanden","O",null,null,null,null,null,null,"O"]
[null,"COASSJN",null,null,"ADNLOG","Polis ond. van verdeling/coass J/N","O",null,null,null,null,null,null,"O"]
[null,"ENDDATC",null,null,"","Beëindigingsdatum","O",null,null,null,null,null,null,"O"]
[null,"EXPDAT",null,null,"","Einddatum"," ","O",null,null,null,null,null,"O"]
[null,"GABRA",null,null,"","Volmacht branchecode","O",null,null,null,null,null,null,"O"]
[null,"GABRAO",null,null,"","Volmacht branchecode, omschr.","O",null,null,null,null,null,null,"O"]
[null,"GASBRA",null,null,"","Volmacht subbranchecode","O",null,null,null,null,null,null,"O"]
[null,"GASBRAO",null,null,"","Volmacht subbranchecode, omschr.","O",null,null,null,null,null,null,"O"]
[null,"GRNDPRM",null,null,"ADNGRP","Grondslag premieberekening, code","V",null," ",null,null,null,null,"V"]
[null,"HVVDAT",null,null,"","Hoofdvervaldatum","O",null,null,null,null,null,null,"O"]
[null,"INGDAT",null,null,"","Ingangsdatum","V",null,null,null,null,null,null,"V"]
[null,"INTKEY",null,null,"","Interne sleutel","O",null,null,null,null,null,null,{"$f":"IF(LEFT(G47,1)=\"X\",\"X\",IF(LEFT(G47,1)=\"V\",\"V\",IF(H47=\"V\",\"V\",IF(I47=\"V\",\"V\",IF(J47=\"V\",\"O\",IF(K47=\"V\",\"O\",IF(L47=\"V\",\"O\",IF(M47=\"V\",\"O\",IF(LEFT(G47,1)=\"O\",\"O\",IF(LEFT(H47,1)=\"O\",\"O\",IF(I47=\"O\",\"O\",IF(J47=\"O\",\"O\",IF(K47=\"O\",\"O\",IF(L47=\"O\",\"O\",IF(M47=\"O\",\"O\",\"LEEG\")))))))))))))))","v":"O"}]
[null,"LWYZDAT",null,null,"","Datum laatste wijziging","O",null,null,null,null,null,null,"O"]
[null,"MYAAND",null,null,"PORMAA","POR Maatschappij aanduiding, code","V",null,null,null,null,null,null,"V"]
[null,"NJP",null,null,"","Netto jaarpremie","O",null,null,null,null,null,null,"O"]
[null,"NUMMER",null,null,"","Contractnummer","V",null,null,null,null,null,null,"V"]
[null,"PRCTEKC",null,null,"","Percentage Volmachtbeloning","O",null,null,null,null,null,null,"O"]
[null,"PRODUCC",null,null,"ADNMSP","Productcode maatschappij, code","V",null,null,null,null,null,null,"V",null,"Voor NVGA protocol Inkomen zijn de volgende codewaarden uit ADNMSP van toepassing: 00249, 00250, 00251, 00254, 00258, 00259, 00297, 00298, 00309, 00357, 00358, 00359"]
[null,"SCHDVRY",null,null,"","Aantal schadevr.jaren B/M, Noclaim"," ","O",null,null,null,null,null,"O"]
[null,"SPECLIM",null,null,"ADNLOG","Special limit J/N","V",null,null,null,null,null,null,"V"]
[null,"STATUS",null,null,"ADNSTS","Status, code","V",null,null,null,null,null,null,"V"]
[null,"TJRPO",null,null,"","Tekenjaar pool","O",null,null,null,null,null,null,"O"]
[null,"TJRPP",null,null,"","Tekenjaar polis","V",null,null,null,null,null,null,"V"]
[null,"TTEKC",null,null,"","Termijnbedrag Volmachtbeloning","O",null,null,null,null,null,null,"O"]
[null,"VGCODE",null,null,"","Volmachtgever code","V",null,null,null,null,null,null,"V"]
[null,"VMPPRC",null,null,"","Perc. prol. provisie gevolmachtigde","O",null,null,null,null,null,null,"O"]
[null,"VMTPP",null,null,"","Termijnbedrag prol. provisie gevolm.","O",null,null,null,null,null,null,"O"]
[null,"VVDAT",null,null,"","(Afwijkende) Premievervaldatum"," ","O",null,null,null,null,null,"O"]
[null,"TP",null,null,"","PARTIJ TUSSENPERSOON","O",null,null,null,null,null,null,"O","maxOccurs 1"]
[null,null,"AFMVRGN",null,"","AFM vergunningnummer","O",null,null,null,null,null,null,"O"]
[null,null,"IDNR",null,"","Identificatienummer","O",null,null,null,null,null,null,"O"]
[null,"VE",null,null,"","PARTIJ VOLMACHTNEMER","V",null,null,null,null,null,null,"V","maxOccurs 1"]
[null,null,"ANAAM",null,"","Naam","V",null,null,null,null,null,null,"V"]
[null,null,"IDNR",null,"","Identificatie nummer","O",null,null,null,null,null,null,"O"]
[null,null,"MYAAND",null,"PORMAA","POR Maatschappij aanduiding, code","O",null,null,null,null,null,null,"O"]
[null,null,"TELNUM",null,"","Telefoonnummer","V",null,null,null,null,null,null,"V"]
[null,null,"TWEEDED",null,"","Tweede deel naam","O",null,null,null,null,null,null,"O"]
[null,"VL",null,null,"","PARTIJ VOLMACHTGEVER","V",null,null,null,null,null,null,"V"]
[null,null,"ANAAM",null,"","Naam","V",null,null,null,null,null,null,"V"]
[null,null,"EMAIL",null,"","E-mail adres","O",null,null,null,null,null,null,"O"]
[null,null,"MYAAND",null,"PORMAA","POR Maatschappij aanduiding, code","V",null,null,null,null,null,null,"V"]
[null,null,"TELNUM",null,"","Telefoonnummer","O",null,null,null,null,null,null,"O"]
[null,null,"TWEEDED",null,"","Tweede deel naam","O",null,null,null,null,null,null,{"$f":"IF(LEFT(G78,1)=\"X\",\"X\",IF(LEFT(G78,1)=\"V\",\"V\",IF(H78=\"V\",\"V\",IF(I78=\"V\",\"V\",IF(J78=\"V\",\"O\",IF(K78=\"V\",\"O\",IF(L78=\"V\",\"O\",IF(M78=\"V\",\"O\",IF(LEFT(G78,1)=\"O\",\"O\",IF(LEFT(H78,1)=\"O\",\"O\",IF(I78=\"O\",\"O\",IF(J78=\"O\",\"O\",IF(K78=\"O\",\"O\",IF(L78=\"O\",\"O\",IF(M78=\"O\",\"O\",\"LEEG\")))))))))))))))","v":"O"}]
[null,null,"VEIDNR",null,"","Volmachtnemer identificatie","O",null,null,null,null,null,null,"O"]
[null,null,"VOLGNUM",null,"","Volgnummer",null,null,null,null,null,null,null,"LEEG"]
[null,"WG",null,null,"","PARTIJ WERKGEVER","V",null,null,null,null,null,null,"V","maxOccurs 1"]
[null,null,"ANAAM",null,"","Naam","O",null,null,null,null,null,null,"O"]
[null,null,"PCODE",null,"","Postcode","O",null,null,null,null,null,null,"O"]
[null,null,"VRWRKCD",null,"ADNVRC","Verwerkingscode entiteit","V",null,null,null,null,null,null,"V"]
[null,null,"WGNUM",null,"","Werkgevernummer","O",null,null,null,null,null,null,"O"]
[null,"AR",null,null,"","PARTIJ UITVOERINGSINSTANTIE"," ","O",null,null,null,null,null,"O","maxOccurs 1"]
[null,null,"ARBDNC",null,"SIVARB","Arbodienst, code",null,"V",null,null,null,null,null,"V"]
[null,null,"VOLGNUM",null,"","Volgnummer",null,null," "," ",null,null,null,"LEEG"]
[null,null,"VRWRKCD",null,"ADNVRC","Verwerkingscode entiteit"," ","V",null,null,null,null,null,"V"]
[null,"OG",null,null,"","(VERZEKERD) BEDRIJF"," ","O",null,null,null,null,null,"O","maxOccurs 1"]
[null,null,"AANTPLO",null,"","Aantal personen in loondienst"," ","O",null,null,null,null,null,"O"]
[null,null,"BEDRTAK",null,"ADNBDT","Bedrijfstak, code"," ","O",null,null,null,null,null,"O"]
[null,null,"HWIAI",null,"","Hist. WAO/WIA-instroom, huidig jaar",null,"O",null,null,null,null,null,"O"]
[null,null,"HWIAI1",null,"","Hist. WAO/WIA-instroom, vorig jaar",null,"O",null,null,null,null,null,"O"]
[null,null,"HWIAI2",null,"","Hist. WAO/WIA-instroom, 2jr terug",null,"O",null,null,null,null,null,"O"]
[null,null,"HWIAI3",null,"","Hist. WAO/WIA-instroom, 3jr terug",null,"O",null,null,null,null,null,"O"]
[null,null,"HWIAI4",null,"","Hist. WAO/WIA-instroom, 4jr terug",null,"O",null,null,null,null,null,"O"]
[null,null,"IDNR",null,"","Identificatienummer waarmee de partij bekend staat in de communicatie. Dit wordt bilateraal afgesproken tussen partijen."," ","O",null,null,null,null,null,"O"]
[null,null,"JRLNFSV",null,"","Fiscale/SV jaarloonsom",null,"O",null,null,null,null,null,"O"]
[null,null,"NRHNDRG",null,"","Nummer handelsregister",null,"O",null,null,null,null,null,"O"]
[null,null,"OPRDAT",null,"","Oprichtingsdatum bedrijf",null,"O",null,null,null,null,null,"O"]
[null,null,"ZKVZPRC ",null,null,"Verzuim% huidig jaar",null,"O",null,null,null,null,null,"O"]
[null,null,"ZKVZPVJ ",null,null,"Verzuim% vorig jaar",null,"O",null,null,null,null,null,{"$f":"IF(LEFT(G103,1)=\"X\",\"X\",IF(LEFT(G103,1)=\"V\",\"V\",IF(H103=\"V\",\"V\",IF(I103=\"V\",\"V\",IF(J103=\"V\",\"O\",IF(K103=\"V\",\"O\",IF(L103=\"V\",\"O\",IF(M103=\"V\",\"O\",IF(LEFT(G103,1)=\"O\",\"O\",IF(LEFT(H103,1)=\"O\",\"O\",IF(I103=\"O\",\"O\",IF(J103=\"O\",\"O\",IF(K103=\"O\",\"O\",IF(L103=\"O\",\"O\",IF(M103=\"O\",\"O\",\"LEEG\")))))))))))))))","v":"O"}]
[null,null,"ZKVZP2J ",null,null,"Verzuim% 2 jaar terug",null,"O",null,null,null,null,null,"O"]
[null,null,"ZKVZP3J ",null,null,"Verzuim% 3 jaar terug",null,"O",null,null,null,null,null,"O"]
[null,null,"P2JEJ",null,"","Perc. ziekteverz.1e jr. 2 jaar terug",null,"O",null,null,null,null,null,"O"]
[null,null,"P2JTJ",null,"","Perc. ziekteverz.2e jr. 2 jaar terug",null,"O",null,null,null,null,null,"O"]
[null,null,"P3JEJ",null,"","Perc. ziekteverz.1e jr. 3 jaar terug",null,"O",null,null,null,null,null,"O"]
[null,null,"P3JTJ",null,"","Perc. ziekteverz.2e jr. 3 jaar terug",null,"O",null,null,null,null,null,"O"]
[null,null,"PVJEJ",null,"","Perc.ziekteverz.1e jr. in vorig jaar",null,"O",null,null,null,null,null,"O"]
[null,null,"PVJTJ",null,"","Perc.ziekteverz.2e jr. in vorig jaar",null,"O",null,null,null,null,null,"O"]
[null,null,"RELNUM",null,"","Relatienummer",null,"O",null,null,null,null,null,"O"]
[null,null,"SBIBEDR",null,"","Aard bedrijf (SBI-code)",null,"O",null,null,null,null,null,"O"]
[null,null,"SECNN",null,"ADNSNN","Sector NN, code"," ","O",null,null,null,null,null,{"$f":"IF(LEFT(G114,1)=\"X\",\"X\",IF(LEFT(G114,1)=\"V\",\"V\",IF(H114=\"V\",\"V\",IF(I114=\"V\",\"V\",IF(J114=\"V\",\"O\",IF(K114=\"V\",\"O\",IF(L114=\"V\",\"O\",IF(M114=\"V\",\"O\",IF(LEFT(G114,1)=\"O\",\"O\",IF(LEFT(H114,1)=\"O\",\"O\",IF(I114=\"O\",\"O\",IF(J114=\"O\",\"O\",IF(K114=\"O\",\"O\",IF(L114=\"O\",\"O\",IF(M114=\"O\",\"O\",\"LEEG\")))))))))))))))","v":"O"}]
[null,"AO",null,null,"","DEKKING ARBEIDSONGESCHIKTHEID"," ","O",null,null,null,null,null,"O","maxOccurs 1"]
[null,null,"BAFWST",null,"","Bedrag afwijk. op standaard tarief","O",null,null,null,null,null,null,"O"]
[null,null,"BJP",null,"","Bedrag Bruto jaarpremie"," ","O",null,null,null,null,null,"O"]
[null,null,"BRPRPW1",null,"","Premiepercentage eerste jaar"," ","O",null,null,null,null,null,"O"]
[null,null,"BRPRPW2",null,"","Premiepercentage tweede jaar"," ","O",null,null,null,null,null,"O"]
[null,null,"BTP",null,"","Termijnbedrag bruto premie","O",null,null,null,null,null,null,"O"]
[null,null,"CODE",null,"ADNDEK","Dekkingscode","V",null,null,null,null,null,null,"V"]
[null,null,"EINDLFT",null,"","Eindleeftijd risicodekking in jaren"," ","O",null,null,null,null,null,"O"]
[null,null,"GADEKCD",null,null,"Volmacht dekkingscode","V",null,null,null,null,null,null,"V"]
[null,null,"GADEKCO",null,null,"Volmacht dekkingscode, omschr.","V",null,null,null,null,null,null,"V"]
[null,null,"INDREN",null,"ADNLOG","Indexering na ingaan rente J/N","V",null,null,null,null,null,null,"V"]
[null,null,"INDRENM",null,"ADNESK","Indexatiemethode na ing. rente,code"," ","O",null,null,null,null,null,"O"]
[null,null,"INDRENP",null,"","Indexpercentage na ingaan rente",null,"O",null,null,null,null,null,"O"]
[null,null,"MAXVERZ",null,"","Maximaal verzekerd bedrag",null,"O",null,null,null,null,null,"O"]
[null,null,"MYCODE",null,"ADNMCD","Dekkingscode maatschappij, code",null,"O",null,null,null,null,null,"O"]
[null,null,"PAFWST",null,"","Percentage afw. op standaard tarief","O",null,null,null,null,null,null,"O"]
[null,null,"PERCDEK",null,"","Dekkingspercentage"," ","O",null,null,null,null,null,"O"]
[null,null,"PRCTEKC",null,"","Percentage Volmachtbeloning","O",null,null,null,null,null,null,"O"]
[null,null,"PRCWKGL",null,"","Percentage werkgeverslasten",null,"O",null,null,null,null,null,"O"]
[null,null,"PRMPRCL",null,"","Premie als percentage van het loon"," ","O",null,null,null,null,null,"O"]
[null,null,"RJRCOR",null,"","Resterende jaren voor correctie","O",null,null,null,null,null,null,"O"]
[null,null,"TCORBDR",null,"","Toegepast correctiebedrag","O",null,null,null,null,null,null,"O"]
[null,null,"TTEKC",null,"","Termijnbedrag Volmachtbeloning","O",null,null,null,null,null,null,"O"]
[null,null,"UITDUUR",null,"","Uitkeringsduur in maanden"," ","O",null,null,null,null,null,"O"]
[null,null,"VERZSOM",null,"","Verzekerde som","V",null,null,null,null,null,null,"V"]
[null,null,"VGBRA",null,null,"Volmachtgever branchecode","O",null,null,null,null,null,null,"O"]
[null,null,"VMPPRC",null,"","Perc. prol. provisie gevolmachtigde","O",null,null,null,null,null,null,"O"]
[null,null,"VMTPP",null,"","Termijnbedrag prol. provisie gevolm.","O",null,null,null,null,null,null,"O"]
[null,null,"VOLGNUM",null,"","Volgnummer",null,null,null,null,null,null,null,"LEEG"]
[null,null,"WACHTTY",null,"","Wachttijd in dagen",null,"O",null,null,null,null,null,"O"," "]
[null,null,"WPREMBP",null,"ADNPBP","Wijze premieberekening prol., code","V",null,null,null,null,null,null,"V"]
[null,null,"DX",null,"","VERLOOPSCHEMA"," ","O",null,null,null,null,null,"O","maxOccurs 1"]
[null,null,null,"PERCDEK","","Dekkingspercentage","V",null,null,null,null,null,null,"V"]
[null,null,null,"PERIODE","","Periode","V",null,null,null,null,null,null,"V"]
[null,null,null,"TERMIJN","ADNDWM","Termijn","V",null,null,null,null,null,null,{"$f":"IF(LEFT(G149,1)=\"X\",\"X\",IF(LEFT(G149,1)=\"V\",\"V\",IF(H149=\"V\",\"V\",IF(I149=\"V\",\"V\",IF(J149=\"V\",\"O\",IF(K149=\"V\",\"O\",IF(L149=\"V\",\"O\",IF(M149=\"V\",\"O\",IF(LEFT(G149,1)=\"O\",\"O\",IF(LEFT(H149,1)=\"O\",\"O\",IF(I149=\"O\",\"O\",IF(J149=\"O\",\"O\",IF(K149=\"O\",\"O\",IF(L149=\"O\",\"O\",IF(M149=\"O\",\"O\",\"LEEG\")))))))))))))))","v":"V"}]
[null,null,"MP",null,"","POOLAANDEEL","O",null,null,null,null,null,null,"O"]
[null,null,null,"MYAAND","PORMAA","POR Maatschappij aanduiding, code","O",null,null,null,null,null,null,"O"]
[null,null,null,"PLLEAD","ADNLOG","Poolleader J/N","O",null,null,null,null,null,null,"O"]
[null,null,null,"POOLNUM","","Poolnummer","V",null,null,null,null,null,null,"V"]
[null,null,null,"POOLPRC","","Percentage poolaandeel","V",null,null,null,null,null,null,"V"]
[null,"DL",null,null,"","DEKKING LOONSOM"," ","O",null,null,null,null,null,"O","maxOccurs 1"]
[null,null,"BAFWST",null,"","Bedrag afwijk. op standaard tarief","O",null,null,null,null,null,null,"O"]
[null,null,"BJP",null,"","Bedrag Bruto jaarpremie"," ","O",null,null,null,null,null,"O"]
[null,null,"BTP",null,"","Termijnbedrag bruto premie","O",null,null,null,null,null,null,"O"]
[null,null,"CODE",null,"ADNDEK","Dekkingscode","V",null,null,null,null,null,null,"V"]
[null,null,"ENDLFTD",null,"","Eindleeftijd"," ","O",null,null,null,null,null,"O"]
[null,null,"ERPRCDL",null,"","Eigen risico percentage loonsom",null,"O",null,null,null,null,null,"O"]
[null,null,"GADEKCD",null,null,"Volmacht dekkingscode","V",null,null,null,null,null,null,"V"]
[null,null,"GADEKCO",null,null,"Volmacht dekkingscode, omschr.","V",null,null,null,null,null,null,"V"]
[null,null,"MAXDKEB",null,"ADNFCT","Maximale dekking eigen behoud, code",null,"O",null,null,null,null,null,"O"]
[null,null,"MYCODE",null,"ADNMCD","Dekkingscode maatschappij, code",null,"O",null,null,null,null,null,"O"]
[null,null,"PAFWST",null,"","Percentage afw. op standaard tarief","O"," ",null,null,null,null,null,"O"]
[null,null,"PRCEB",null,"","Percentage eigen behoud",null,"O",null,null,null,null,null,"O"]
[null,null,"PRCTEKC",null,"","Percentage Volmachtbeloning","O"," ",null,null,null,null,null,"O"]
[null,null,"PRCWKGL",null,"","Percentage werkgeverslasten","O"," ",null,null,null,null,null,"O"]
[null,null,"PRMPRCL",null,"","Premie als percentage van het loon",null,"O",null,null,null,null,null,"O"]
[null,null,"RJRCOR",null,"","Resterende jaren voor correctie","O"," ",null,null,null,null,null,"O"]
[null,null,"TCORBDR",null,"","Toegepast correctiebedrag","O"," ",null,null,null,null,null,"O"]
[null,null,"TTEKC",null,"","Termijnbedrag Volmachtbeloning","O"," ",null,null,null,null,null,"O"]
[null,null,"VERZSOM",null,null,"Verzekerde som"," ","O",null,null,null,null,null,{"$f":"IF(LEFT(G174,1)=\"X\",\"X\",IF(LEFT(G174,1)=\"V\",\"V\",IF(H174=\"V\",\"V\",IF(I174=\"V\",\"V\",IF(J174=\"V\",\"O\",IF(K174=\"V\",\"O\",IF(L174=\"V\",\"O\",IF(M174=\"V\",\"O\",IF(LEFT(G174,1)=\"O\",\"O\",IF(LEFT(H174,1)=\"O\",\"O\",IF(I174=\"O\",\"O\",IF(J174=\"O\",\"O\",IF(K174=\"O\",\"O\",IF(L174=\"O\",\"O\",IF(M174=\"O\",\"O\",\"LEEG\")))))))))))))))","v":"O"}]
[null,null,"VGBRA",null,null,"Volmachtgever branchecode","O",null,null,null,null,null,null,"O"]
[null,null,"VMPPRC",null,"","Perc. prol. provisie gevolmachtigde","O"," ",null,null,null,null,null,"O"]
[null,null,"VMTPP",null,"","Termijnbedrag prol. provisie gevolm.","O"," ",null,null,null,null,null,"O"]
[null,null,"VPRCLNS",null,"","Verz. percentage van totale loonsom",null,"O",null,null,null,null,null,"O"]
[null,null,"WACHTTY",null,"","Wachttijd in dagen",null,"O",null,null,null,null,null,"O"]
[null,null,"WPREMBP",null,"ADNPBP","Wijze premieberekening prol., code","V",null,null,null,null,null,null,"V"]
[null,null,"DX",null,"","VERLOOPSCHEMA"," ","O",null,null,null,null,null,"O","maxOccurs 1"]
[null,null,null,"PERCDEK","","Dekkingspercentage","V",null,null,null,null,null,null,{"$f":"IF(LEFT(G182,1)=\"X\",\"X\",IF(LEFT(G182,1)=\"V\",\"V\",IF(H182=\"V\",\"V\",IF(I182=\"V\",\"V\",IF(J182=\"V\",\"O\",IF(K182=\"V\",\"O\",IF(L182=\"V\",\"O\",IF(M182=\"V\",\"O\",IF(LEFT(G182,1)=\"O\",\"O\",IF(LEFT(H182,1)=\"O\",\"O\",IF(I182=\"O\",\"O\",IF(J182=\"O\",\"O\",IF(K182=\"O\",\"O\",IF(L182=\"O\",\"O\",IF(M182=\"O\",\"O\",\"LEEG\")))))))))))))))","v":"V"}]
[null,null,null,"PERIODE","","Periode","V",null,null,null,null,null,null,"V"]
[null,null,null,"TERMIJN","ADNDWM","Termijn","V",null,null,null,null,null,null,"V"]
[null,null,"MP",null,"","POOLAANDEEL","O",null,null,null,null,null,null,"O"]
[null,null,null,"MYAAND","PORMAA","POR Maatschappij aanduiding, code","O",null,null,null,null,null,null,"O"]
[null,null,null,"PLLEAD","ADNLOG","Poolleader J/N","O",null,null,null,null,null,null,"O"]
[null,null,null,"POOLNUM","","Poolnummer","V",null,null,null,null,null,null,"V"]
[null,null,null,"POOLPRC","","Percentage poolaandeel","V",null,null,null,null,null,null,"V"]
[null,"CL",null,null,null,"CLAUSULE",null,null,null,null,null,null,null,"LEEG","maxOccurs 1"]
[null,null,"CLAUSNR",null,null,"Clausule nummers",null,null,null,null,null,null,null,"LEEG"]
[null,null,"CLAUSOM",null,null,"Clausuletekst",null,null,null,null,null,null,null,"LEEG"]
[null,null,"CLAUTXT",null,null,"Clausule tekst",null,null,null,null,null,null,null,"LEEG"]
[null,null,"VERSIEC",null,null,"Clausule versienummer",null,null,null,null,null,null,null,"LEEG"]
[null,null,"VOLGNUM",null,null,"Volgnummer",null,null,null,null,null,null,null,"LEEG"]
[null,null,"VRWRKCD",null,"ADNVRC","Verwerkingscode entiteit",null,null,null,null,null,null,null,"LEEG"]
[null,"VW",null,null,null,"VOORWAARDEN",null,null,null,null,null,null,null,"LEEG","maxOccurs 1"]
[null,null,"VOLGNUM",null,null,"Volgnummer",null,null,null,null,null,null,null,"LEEG"]
[null,null,"VRWNR",null,null,"Voorwaarde nummer",null,null,null,null,null,null,null,"LEEG"]
[null,null,"VRWOM",null,null,"Voorwaardentekst",null,null,null,null,null,null,null,"LEEG"]
[null,null,"VRWRKCD",null,"ADNVRC","Verwerkingscode entiteit",null,null,null,null,null,null,null,"LEEG"]
[null,null,"VRWVERS",null,null,"Voorwaarde versie",null,null,null,null,null,null,null,"LEEG"]
["XG",null,null,null,null,"TRANSACTIE PROCES",null,null,null,null,null,null,null,"LEEG"]
[null,"STATUS",null,null,"ADNSTS","Status, code"," ",null,null,null,null,null,null,"LEEG"]
[null,"STATUST",null,null,null,"Toelichting status",null,null,null,null,null,null,null,"LEEG"]
[null,"VRWRKCD",null,null,"ADNVRC","Verwerkingscode entiteit",null,null,null,null,null,null,null,"LEEG"]
[null,"XM",null,null,null,"OMSCHRIJVING STATUS",null,null,null,null,null,null,null,"LEEG","maxOccurs 1"]
[null,null,"STATTXT",null,null,"Status, tekst",null,null,null,null,null,null,null,"LEEG"]
[null,null,"VOLGNUM",null,null,"Volgnummer",null,null,null,null,null,null,null,"LEEG"]
[null,null,"VRWRKCD",null,"ADNVRC","Verwerkingscode entiteit",null,null,null,null,null,null,null,"LEEG"]
[null,null,"XPATH",null,null,"Gegevenselement locatie",null,null,null,null,null,null,null,"LEEG"]

{"sheet":" Verbandscontrole","index":2,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[14,6,15,6],[18,6,19,6],[22,6,23,6],[26,2,27,2],[26,5,27,5],[26,6,27,6],[18,2,19,2],[22,2,23,2],[14,2,15,2],[18,5,19,5],[14,5,15,5],[22,5,23,5]]}
["Inventarisatie noodzakelijke attributen "]
["Verzekeraar:",{"$f":"Schema!C2","v":0}]
["Branche:",{"$f":"Schema!C3","v":0}]
["POR maatschappij aanduiding:",{"$f":"Schema!C4","v":0}]
["AFD Definitie naam:",{"$f":"Schema!C5","v":0}]
["AFD Definitie versie nummer:",{"$f":"Schema!C6","v":0}]
["Commerciele productnaam:",{"$f":"Schema!C8","v":0}]
["Bronnen:",{"$f":"Schema!C9","v":0}]
["Contactpersoon:",{"$f":"Schema!C10","v":0}]
["E-mail / Telefoon:",{"$f":"Schema!C11","v":0}]
["Datum:",{"$f":"Schema!C12","v":44880}]
[]
[]
["Conditie","Voorbeeld verbandscontrole",null,"Conditie","Voorbeeld Pseudo-code ","Voorbeeld foutmelding","Bron"]
["If","indexering na ingaan rente = J","Aanroep Acceptatie\nAanroep Premieberekening\nKunnen aanleveren","If","AO_INDREN = J","Code bij indexatiemethode na ingaan rente moet gevuld zijn bij bevestiging keuze indexering na ingaan rente.","Rekenbox"]
["Then","moet indexatiemethode na ingaan rente gevuld zijn",null,"Then","exists(AO_ INDRENM ) "]
[]
["Conditie","Verbandscontrole 1",null,"Conditie","XPath Verbandscontrole 1","Foutmelding","Bron"]
["If","<Vul hier de conditie waaraan voldaan moet worden> ","Aanroep Acceptatie\nAanroep Premieberekening\nKunnen aanleveren","If","<Vul hier de pseudocode in waaraan voldaan moet worden>","<Vermeld hier welke foutmelding de volmacht krijgt bij een onjuiste validatie> "]
["Then","<Vul hier de validatie die moet worden uitgevoerd als de conditie waar is>",null,"Then","<Vul hier de pseudocode in die bij validatie uitgevoerd moet worden>"]
[]
["Conditie","Verbandscontrole 2",null,"Conditie","XPath Verbandscontrole 2","Foutmelding","Bron"]
["If","<Vul hier de conditie waaraan voldaan moet worden> ","Aanroep Acceptatie\nAanroep Premieberekening\nKunnen aanleveren","If","<Vul hier de pseudocode in waaraan voldaan moet worden>","<Vermeld hier welke foutmelding de volmacht krijgt bij een onjuiste validatie> "]
["Then","<Vul hier de validatie die moet worden uitgevoerd als de conditie waar is>",null,"Then","<Vul hier de pseudocode in waaraan voldaan moet worden>"]
[]
["Conditie","Verbandscontrole 3",null,"Conditie","XPath Verbandscontrole 3","Foutmelding","Bron"]
["If","<Vul hier de conditie waaraan voldaan moet worden> ","Aanroep Acceptatie\nAanroep Premieberekening\nKunnen aanleveren","If","<Vul hier de pseudocode in waaraan voldaan moet worden>","<Vermeld hier welke foutmelding de volmacht krijgt bij een onjuiste validatie> "]
["Then","<Vul hier de validatie die moet worden uitgevoerd als de conditie waar is>",null,"Then","<Vul hier de pseudocode in waaraan voldaan moet worden>"]

{"sheet":"Openstaande punten","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Openstaande punten"]
[null,1,"Controleer tab \"Schema\" (zie instructies)"]
[null,2,"Controleer tab \"Verbandscontrole\" (zie instructies)"]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]

{"sheet":"Updates","index":4,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Versie","Datum","Omschrijving aanpassing"]
[null,11,"2022-11-15","alle VOLGNUMMER attributen uit 'NVGA Protocol altijd opnemen'."]
[null,null,null,"Attribuut PP_EXPDAT verplaatst van 'NVGA Protocol altijd opnemen' naar 'NVGA Protocol te beoordelen'."]
[null,null,null,"Attribuut PP_SCHHDVRY uit 'NVGA Protocol altijd opnemen'."]
[null,null,null,"Attribuut PP_VVDAT verplaatst van 'NVGA Protocol altijd opnemen' naar 'NVGA Protocol te beoordelen'."]
[null,null,null,"Omschrijving gewijzigd attribuut OG_IDNR."]
[null,null,null,"Attribuut OG_ZKVZPRC toegevoegd aan 'NVGA Protocol te beoordelen'."]
[null,null,null,"Attribuut OG_ZKVZPVJ toegevoegd aan 'NVGA Protocol te beoordelen'."]
[null,null,null,"Attribuut OG_ZKVZP2J toegevoegd aan 'NVGA Protocol te beoordelen'."]
[null,null,null,"Attribuut OG_ZKVZP3J toegevoegd aan 'NVGA Protocol te beoordelen'."]
[null,null,null,"Attribuut OG_SBIBEDR verplaatst van 'NVGA Protocol altijd opnemen' naar 'NVGA Protocol te beoordelen' en is gewijzigd van V naar O."]
[null,null,null,"Attribuut DL_MYCODE verplaatst van 'NVGA Protocol altijd opnemen' naar 'NVGA Protocol te beoordelen' en is gewijzigd van V naar O."]
[null,null,null,"Attribuut AO_WACHTTY verplaatst van 'NVGA Protocol altijd opnemen' naar 'NVGA Protocol te beoordelen' en is gewijzigd van V naar O."]
[null,null,null,"Attribuut AR_ARBODNST gewijzigd naar juiste naam AR_ARBODNC."]
[null,null,null,"Attribuut DL_VERZSOM op 'O' in 'NVGA Protocol te beoordelen'."]
[null,null,null,"De codewaarden uit ADNMSP voor attribuut PRODUCC (productrcode maatschappij) die van toepassing zijn voor NVGA protocol Inkomen opgenomen in kolom P  \"Bevinding'."]

{"sheet":"CSVoutput","index":5,"n_rows":193,"n_cols":15,"rows_kept":193,"cut":false,"hidden":true,"merged":[]}
["Entiteit/Attribuut","Entiteit","I1","I2","I3","Pad1","Pad2","Pad3","Pad","Attribuut",{"$f":"Schema!I14","v":"premieBerekening_aanroep"},{"$f":"Schema!J14","v":"premieBerekening_resultaat"},{"$f":"Schema!K14","v":"Acceptatie_aanroep"},{"$f":"Schema!L14","v":"Acceptatie_resultaat"},{"$f":"Schema!N14","v":"kunnenAanleveren"}]
[{"$f":"Schema!A15&Schema!B15&Schema!C15&Schema!D15","v":"AL"},{"$f":"IF(LEN(A2)=2,A2,IF(A2=\"\",\"Leeg\",B1))","v":"AL"},{"$f":"IF(A2=\"\",\"\",IF(LEN(Schema!A15)=2,1,IF(LEN(Schema!B15)=2,10,IF(LEN(Schema!C15)=2,100,0))))","v":1},{"$f":"IF(C2=0,D1,C2)","v":1},{"$f":"IF(A2=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":2},{"$f":"IF(A2=\"\",\"\",IF(C2=1,B2,F1))","v":"AL"},{"$f":"IF(C2=10,A2,IF(OR(C2=0,C2=100),G1,\"\"))","v":""},{"$f":"IF(E2=200,B2,IF(C2=0,H1,\"\"))","v":""},{"$f":"IF(C2=\"\",\"\",IF(OR(E2=1,E2=10,E2=100),I1,IF(E2=2,F2,IF(E2=20,F2&\"/\"&G2,IF(E2=200,F2&\"/\"&G2&\"/\"&H2)))))","v":"AL"},{"$f":"IF(C2=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":""},{"$f":"IF(Schema!I15=\"\",\"\",Schema!I15)","v":""},{"$f":"IF(Schema!J15=\"\",\"\",Schema!J15)","v":""},{"$f":"IF(Schema!K15=\"\",\"\",Schema!K15)","v":""},{"$f":"IF(Schema!L15=\"\",\"\",Schema!L15)","v":""},{"$f":"IF(Schema!N15=\"\",\"\",Schema!N15)","v":"V"}]
[{"$f":"Schema!A16&Schema!B16&Schema!C16&Schema!D16","v":"ADATMSG"},{"$f":"IF(LEN(A3)=2,A3,IF(A3=\"\",\"Leeg\",B2))","v":"AL"},{"$f":"IF(A3=\"\",\"\",IF(LEN(Schema!A16)=2,1,IF(LEN(Schema!B16)=2,10,IF(LEN(Schema!C16)=2,100,0))))","v":0},{"$f":"IF(C3=0,D2,C3)","v":1},{"$f":"IF(A3=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},{"$f":"IF(A3=\"\",\"\",IF(C3=1,B3,F2))","v":"AL"},{"$f":"IF(C3=10,A3,IF(OR(C3=0,C3=100),G2,\"\"))","v":""},{"$f":"IF(E3=200,B3,IF(C3=0,H2,\"\"))","v":""},{"$f":"IF(C3=\"\",\"\",IF(OR(E3=1,E3=10,E3=100),I2,IF(E3=2,F3,IF(E3=20,F3&\"/\"&G3,IF(E3=200,F3&\"/\"&G3&\"/\"&H3)))))","v":"AL"},{"$f":"IF(C3=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AL_ADATMSG"},{"$f":"IF(Schema!I16=\"\",\"\",Schema!I16)","v":""},{"$f":"IF(Schema!J16=\"\",\"\",Schema!J16)","v":""},{"$f":"IF(Schema!K16=\"\",\"\",Schema!K16)","v":""},{"$f":"IF(Schema!L16=\"\",\"\",Schema!L16)","v":""},{"$f":"IF(Schema!N16=\"\",\"\",Schema!N16)","v":"V"}]
[{"$f":"Schema!A17&Schema!B17&Schema!C17&Schema!D17","v":"APPLNM"},"AL",{"$f":"IF(A4=\"\",\"\",IF(LEN(Schema!A17)=2,1,IF(LEN(Schema!B17)=2,10,IF(LEN(Schema!C17)=2,100,0))))","v":0},1,{"$f":"IF(A4=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"AL","","","AL",{"$f":"IF(C4=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AL_APPLNM"},{"$f":"IF(Schema!I17=\"\",\"\",Schema!I17)","v":""},{"$f":"IF(Schema!J17=\"\",\"\",Schema!J17)","v":""},{"$f":"IF(Schema!K17=\"\",\"\",Schema!K17)","v":""},{"$f":"IF(Schema!L17=\"\",\"\",Schema!L17)","v":""},{"$f":"IF(Schema!N17=\"\",\"\",Schema!N17)","v":"O"}]
[{"$f":"Schema!A18&Schema!B18&Schema!C18&Schema!D18","v":"APPLVS"},"AL",{"$f":"IF(A5=\"\",\"\",IF(LEN(Schema!A18)=2,1,IF(LEN(Schema!B18)=2,10,IF(LEN(Schema!C18)=2,100,0))))","v":0},1,{"$f":"IF(A5=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"AL","","","AL",{"$f":"IF(C5=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AL_APPLVS"},{"$f":"IF(Schema!I18=\"\",\"\",Schema!I18)","v":""},{"$f":"IF(Schema!J18=\"\",\"\",Schema!J18)","v":""},{"$f":"IF(Schema!K18=\"\",\"\",Schema!K18)","v":""},{"$f":"IF(Schema!L18=\"\",\"\",Schema!L18)","v":""},{"$f":"IF(Schema!N18=\"\",\"\",Schema!N18)","v":"O"}]
[{"$f":"Schema!A19&Schema!B19&Schema!C19&Schema!D19","v":"CPREF"},"AL",{"$f":"IF(A6=\"\",\"\",IF(LEN(Schema!A19)=2,1,IF(LEN(Schema!B19)=2,10,IF(LEN(Schema!C19)=2,100,0))))","v":0},1,{"$f":"IF(A6=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"AL","","","AL",{"$f":"IF(C6=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AL_CPREF"},{"$f":"IF(Schema!I19=\"\",\"\",Schema!I19)","v":""},{"$f":"IF(Schema!J19=\"\",\"\",Schema!J19)","v":""},{"$f":"IF(Schema!K19=\"\",\"\",Schema!K19)","v":""},{"$f":"IF(Schema!L19=\"\",\"\",Schema!L19)","v":""},{"$f":"IF(Schema!N19=\"\",\"\",Schema!N19)","v":"V"}]
[{"$f":"Schema!A20&Schema!B20&Schema!C20&Schema!D20","v":"FUNCTIE"},"AL",{"$f":"IF(A7=\"\",\"\",IF(LEN(Schema!A20)=2,1,IF(LEN(Schema!B20)=2,10,IF(LEN(Schema!C20)=2,100,0))))","v":0},1,{"$f":"IF(A7=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"AL","","","AL",{"$f":"IF(C7=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AL_FUNCTIE"},{"$f":"IF(Schema!I20=\"\",\"\",Schema!I20)","v":""},{"$f":"IF(Schema!J20=\"\",\"\",Schema!J20)","v":""},{"$f":"IF(Schema!K20=\"\",\"\",Schema!K20)","v":""},{"$f":"IF(Schema!L20=\"\",\"\",Schema!L20)","v":""},{"$f":"IF(Schema!N20=\"\",\"\",Schema!N20)","v":"V"}]
[{"$f":"Schema!A21&Schema!B21&Schema!C21&Schema!D21","v":"INCLGP"},"AL",{"$f":"IF(A8=\"\",\"\",IF(LEN(Schema!A21)=2,1,IF(LEN(Schema!B21)=2,10,IF(LEN(Schema!C21)=2,100,0))))","v":0},1,{"$f":"IF(A8=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"AL","","","AL",{"$f":"IF(C8=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AL_INCLGP"},{"$f":"IF(Schema!I21=\"\",\"\",Schema!I21)","v":""},{"$f":"IF(Schema!J21=\"\",\"\",Schema!J21)","v":""},{"$f":"IF(Schema!K21=\"\",\"\",Schema!K21)","v":""},{"$f":"IF(Schema!L21=\"\",\"\",Schema!L21)","v":""},{"$f":"IF(Schema!N21=\"\",\"\",Schema!N21)","v":"O"}]
[{"$f":"Schema!A22&Schema!B22&Schema!C22&Schema!D22","v":"INCLOP"},"AL",{"$f":"IF(A9=\"\",\"\",IF(LEN(Schema!A22)=2,1,IF(LEN(Schema!B22)=2,10,IF(LEN(Schema!C22)=2,100,0))))","v":0},1,{"$f":"IF(A9=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"AL","","","AL",{"$f":"IF(C9=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AL_INCLOP"},{"$f":"IF(Schema!I22=\"\",\"\",Schema!I22)","v":""},{"$f":"IF(Schema!J22=\"\",\"\",Schema!J22)","v":""},{"$f":"IF(Schema!K22=\"\",\"\",Schema!K22)","v":""},{"$f":"IF(Schema!L22=\"\",\"\",Schema!L22)","v":""},{"$f":"IF(Schema!N22=\"\",\"\",Schema!N22)","v":"O"}]
[{"$f":"Schema!A23&Schema!B23&Schema!C23&Schema!D23","v":"INCLPP"},"AL",{"$f":"IF(A10=\"\",\"\",IF(LEN(Schema!A23)=2,1,IF(LEN(Schema!B23)=2,10,IF(LEN(Schema!C23)=2,100,0))))","v":0},1,{"$f":"IF(A10=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"AL","","","AL",{"$f":"IF(C10=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AL_INCLPP"},{"$f":"IF(Schema!I23=\"\",\"\",Schema!I23)","v":""},{"$f":"IF(Schema!J23=\"\",\"\",Schema!J23)","v":""},{"$f":"IF(Schema!K23=\"\",\"\",Schema!K23)","v":""},{"$f":"IF(Schema!L23=\"\",\"\",Schema!L23)","v":""},{"$f":"IF(Schema!N23=\"\",\"\",Schema!N23)","v":"O"}]
[{"$f":"Schema!A24&Schema!B24&Schema!C24&Schema!D24","v":"INCLVZ"},"AL",{"$f":"IF(A11=\"\",\"\",IF(LEN(Schema!A24)=2,1,IF(LEN(Schema!B24)=2,10,IF(LEN(Schema!C24)=2,100,0))))","v":0},1,{"$f":"IF(A11=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"AL","","","AL",{"$f":"IF(C11=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AL_INCLVZ"},{"$f":"IF(Schema!I24=\"\",\"\",Schema!I24)","v":""},{"$f":"IF(Schema!J24=\"\",\"\",Schema!J24)","v":""},{"$f":"IF(Schema!K24=\"\",\"\",Schema!K24)","v":""},{"$f":"IF(Schema!L24=\"\",\"\",Schema!L24)","v":""},{"$f":"IF(Schema!N24=\"\",\"\",Schema!N24)","v":"V"}]
[{"$f":"Schema!A25&Schema!B25&Schema!C25&Schema!D25","v":"MNDGP"},"AL",{"$f":"IF(A12=\"\",\"\",IF(LEN(Schema!A25)=2,1,IF(LEN(Schema!B25)=2,10,IF(LEN(Schema!C25)=2,100,0))))","v":0},1,{"$f":"IF(A12=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"AL","","","AL",{"$f":"IF(C12=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AL_MNDGP"},{"$f":"IF(Schema!I25=\"\",\"\",Schema!I25)","v":""},{"$f":"IF(Schema!J25=\"\",\"\",Schema!J25)","v":""},{"$f":"IF(Schema!K25=\"\",\"\",Schema!K25)","v":""},{"$f":"IF(Schema!L25=\"\",\"\",Schema!L25)","v":""},{"$f":"IF(Schema!N25=\"\",\"\",Schema!N25)","v":"O"}]
[{"$f":"Schema!A26&Schema!B26&Schema!C26&Schema!D26","v":"VERSIEV"},"AL",{"$f":"IF(A13=\"\",\"\",IF(LEN(Schema!A26)=2,1,IF(LEN(Schema!B26)=2,10,IF(LEN(Schema!C26)=2,100,0))))","v":0},1,{"$f":"IF(A13=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"AL","","","AL",{"$f":"IF(C13=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AL_VERSIEV"},{"$f":"IF(Schema!I26=\"\",\"\",Schema!I26)","v":""},{"$f":"IF(Schema!J26=\"\",\"\",Schema!J26)","v":""},{"$f":"IF(Schema!K26=\"\",\"\",Schema!K26)","v":""},{"$f":"IF(Schema!L26=\"\",\"\",Schema!L26)","v":""},{"$f":"IF(Schema!N26=\"\",\"\",Schema!N26)","v":"V"}]
[{"$f":"Schema!A27&Schema!B27&Schema!C27&Schema!D27","v":"PK"},"PK",{"$f":"IF(A14=\"\",\"\",IF(LEN(Schema!A27)=2,1,IF(LEN(Schema!B27)=2,10,IF(LEN(Schema!C27)=2,100,0))))","v":1},1,{"$f":"IF(A14=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":2},"PK","","","PK",{"$f":"IF(C14=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":""},{"$f":"IF(Schema!I27=\"\",\"\",Schema!I27)","v":""},{"$f":"IF(Schema!J27=\"\",\"\",Schema!J27)","v":""},{"$f":"IF(Schema!K27=\"\",\"\",Schema!K27)","v":""},{"$f":"IF(Schema!L27=\"\",\"\",Schema!L27)","v":""},{"$f":"IF(Schema!N27=\"\",\"\",Schema!N27)","v":"O"}]
[{"$f":"Schema!A28&Schema!B28&Schema!C28&Schema!D28","v":"NUMMER"},"PK",{"$f":"IF(A15=\"\",\"\",IF(LEN(Schema!A28)=2,1,IF(LEN(Schema!B28)=2,10,IF(LEN(Schema!C28)=2,100,0))))","v":0},1,{"$f":"IF(A15=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PK","","","PK",{"$f":"IF(C15=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PK_NUMMER"},{"$f":"IF(Schema!I28=\"\",\"\",Schema!I28)","v":""},{"$f":"IF(Schema!J28=\"\",\"\",Schema!J28)","v":""},{"$f":"IF(Schema!K28=\"\",\"\",Schema!K28)","v":""},{"$f":"IF(Schema!L28=\"\",\"\",Schema!L28)","v":""},{"$f":"IF(Schema!N28=\"\",\"\",Schema!N28)","v":"V"}]
[{"$f":"Schema!A29&Schema!B29&Schema!C29&Schema!D29","v":"RC"},"RC",{"$f":"IF(A16=\"\",\"\",IF(LEN(Schema!A29)=2,1,IF(LEN(Schema!B29)=2,10,IF(LEN(Schema!C29)=2,100,0))))","v":1},1,{"$f":"IF(A16=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":2},"RC","","","RC",{"$f":"IF(C16=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":""},{"$f":"IF(Schema!I29=\"\",\"\",Schema!I29)","v":""},{"$f":"IF(Schema!J29=\"\",\"\",Schema!J29)","v":""},{"$f":"IF(Schema!K29=\"\",\"\",Schema!K29)","v":""},{"$f":"IF(Schema!L29=\"\",\"\",Schema!L29)","v":""},{"$f":"IF(Schema!N29=\"\",\"\",Schema!N29)","v":"O"}]
[{"$f":"Schema!A30&Schema!B30&Schema!C30&Schema!D30","v":"NUMMER"},"RC",{"$f":"IF(A17=\"\",\"\",IF(LEN(Schema!A30)=2,1,IF(LEN(Schema!B30)=2,10,IF(LEN(Schema!C30)=2,100,0))))","v":0},1,{"$f":"IF(A17=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"RC","","","RC",{"$f":"IF(C17=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"RC_NUMMER"},{"$f":"IF(Schema!I30=\"\",\"\",Schema!I30)","v":""},{"$f":"IF(Schema!J30=\"\",\"\",Schema!J30)","v":""},{"$f":"IF(Schema!K30=\"\",\"\",Schema!K30)","v":""},{"$f":"IF(Schema!L30=\"\",\"\",Schema!L30)","v":""},{"$f":"IF(Schema!N30=\"\",\"\",Schema!N30)","v":"V"}]
[{"$f":"Schema!A31&Schema!B31&Schema!C31&Schema!D31","v":"PP"},"PP",{"$f":"IF(A18=\"\",\"\",IF(LEN(Schema!A31)=2,1,IF(LEN(Schema!B31)=2,10,IF(LEN(Schema!C31)=2,100,0))))","v":1},1,{"$f":"IF(A18=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":2},"PP","","","PP",{"$f":"IF(C18=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":""},{"$f":"IF(Schema!I31=\"\",\"\",Schema!I31)","v":""},{"$f":"IF(Schema!J31=\"\",\"\",Schema!J31)","v":""},{"$f":"IF(Schema!K31=\"\",\"\",Schema!K31)","v":""},{"$f":"IF(Schema!L31=\"\",\"\",Schema!L31)","v":""},{"$f":"IF(Schema!N31=\"\",\"\",Schema!N31)","v":"V"}]
[{"$f":"Schema!A32&Schema!B32&Schema!C32&Schema!D32","v":"ADEFVRS"},"PP",{"$f":"IF(A19=\"\",\"\",IF(LEN(Schema!A32)=2,1,IF(LEN(Schema!B32)=2,10,IF(LEN(Schema!C32)=2,100,0))))","v":0},1,{"$f":"IF(A19=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C19=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_ADEFVRS"},{"$f":"IF(Schema!I32=\"\",\"\",Schema!I32)","v":""},{"$f":"IF(Schema!J32=\"\",\"\",Schema!J32)","v":""},{"$f":"IF(Schema!K32=\"\",\"\",Schema!K32)","v":""},{"$f":"IF(Schema!L32=\"\",\"\",Schema!L32)","v":""},{"$f":"IF(Schema!N32=\"\",\"\",Schema!N32)","v":"O"}]
[{"$f":"Schema!A33&Schema!B33&Schema!C33&Schema!D33","v":"AFDDEFN"},"PP",{"$f":"IF(A20=\"\",\"\",IF(LEN(Schema!A33)=2,1,IF(LEN(Schema!B33)=2,10,IF(LEN(Schema!C33)=2,100,0))))","v":0},1,{"$f":"IF(A20=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C20=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_AFDDEFN"},{"$f":"IF(Schema!I33=\"\",\"\",Schema!I33)","v":""},{"$f":"IF(Schema!J33=\"\",\"\",Schema!J33)","v":""},{"$f":"IF(Schema!K33=\"\",\"\",Schema!K33)","v":""},{"$f":"IF(Schema!L33=\"\",\"\",Schema!L33)","v":""},{"$f":"IF(Schema!N33=\"\",\"\",Schema!N33)","v":"O"}]
[{"$f":"Schema!A34&Schema!B34&Schema!C34&Schema!D34","v":"BETTERM"},"PP",{"$f":"IF(A21=\"\",\"\",IF(LEN(Schema!A34)=2,1,IF(LEN(Schema!B34)=2,10,IF(LEN(Schema!C34)=2,100,0))))","v":0},1,{"$f":"IF(A21=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C21=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_BETTERM"},{"$f":"IF(Schema!I34=\"\",\"\",Schema!I34)","v":""},{"$f":"IF(Schema!J34=\"\",\"\",Schema!J34)","v":""},{"$f":"IF(Schema!K34=\"\",\"\",Schema!K34)","v":""},{"$f":"IF(Schema!L34=\"\",\"\",Schema!L34)","v":""},{"$f":"IF(Schema!N34=\"\",\"\",Schema!N34)","v":"O"}]
[{"$f":"Schema!A35&Schema!B35&Schema!C35&Schema!D35","v":"BRANCHE"},"PP",{"$f":"IF(A22=\"\",\"\",IF(LEN(Schema!A35)=2,1,IF(LEN(Schema!B35)=2,10,IF(LEN(Schema!C35)=2,100,0))))","v":0},1,{"$f":"IF(A22=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C22=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_BRANCHE"},{"$f":"IF(Schema!I35=\"\",\"\",Schema!I35)","v":""},{"$f":"IF(Schema!J35=\"\",\"\",Schema!J35)","v":""},{"$f":"IF(Schema!K35=\"\",\"\",Schema!K35)","v":""},{"$f":"IF(Schema!L35=\"\",\"\",Schema!L35)","v":""},{"$f":"IF(Schema!N35=\"\",\"\",Schema!N35)","v":"O"}]
[{"$f":"Schema!A36&Schema!B36&Schema!C36&Schema!D36","v":"CDUUMND"},"PP",{"$f":"IF(A23=\"\",\"\",IF(LEN(Schema!A36)=2,1,IF(LEN(Schema!B36)=2,10,IF(LEN(Schema!C36)=2,100,0))))","v":0},1,{"$f":"IF(A23=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C23=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_CDUUMND"},{"$f":"IF(Schema!I36=\"\",\"\",Schema!I36)","v":""},{"$f":"IF(Schema!J36=\"\",\"\",Schema!J36)","v":""},{"$f":"IF(Schema!K36=\"\",\"\",Schema!K36)","v":""},{"$f":"IF(Schema!L36=\"\",\"\",Schema!L36)","v":""},{"$f":"IF(Schema!N36=\"\",\"\",Schema!N36)","v":"O"}]
[{"$f":"Schema!A37&Schema!B37&Schema!C37&Schema!D37","v":"COASSJN"},"PP",{"$f":"IF(A24=\"\",\"\",IF(LEN(Schema!A37)=2,1,IF(LEN(Schema!B37)=2,10,IF(LEN(Schema!C37)=2,100,0))))","v":0},1,{"$f":"IF(A24=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C24=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_COASSJN"},{"$f":"IF(Schema!I37=\"\",\"\",Schema!I37)","v":""},{"$f":"IF(Schema!J37=\"\",\"\",Schema!J37)","v":""},{"$f":"IF(Schema!K37=\"\",\"\",Schema!K37)","v":""},{"$f":"IF(Schema!L37=\"\",\"\",Schema!L37)","v":""},{"$f":"IF(Schema!N37=\"\",\"\",Schema!N37)","v":"O"}]
[{"$f":"Schema!A38&Schema!B38&Schema!C38&Schema!D38","v":"ENDDATC"},"PP",{"$f":"IF(A25=\"\",\"\",IF(LEN(Schema!A38)=2,1,IF(LEN(Schema!B38)=2,10,IF(LEN(Schema!C38)=2,100,0))))","v":0},1,{"$f":"IF(A25=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C25=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_ENDDATC"},{"$f":"IF(Schema!I38=\"\",\"\",Schema!I38)","v":""},{"$f":"IF(Schema!J38=\"\",\"\",Schema!J38)","v":""},{"$f":"IF(Schema!K38=\"\",\"\",Schema!K38)","v":""},{"$f":"IF(Schema!L38=\"\",\"\",Schema!L38)","v":""},{"$f":"IF(Schema!N38=\"\",\"\",Schema!N38)","v":"O"}]
[{"$f":"Schema!A39&Schema!B39&Schema!C39&Schema!D39","v":"EXPDAT"},"PP",{"$f":"IF(A26=\"\",\"\",IF(LEN(Schema!A39)=2,1,IF(LEN(Schema!B39)=2,10,IF(LEN(Schema!C39)=2,100,0))))","v":0},1,{"$f":"IF(A26=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C26=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_EXPDAT"},{"$f":"IF(Schema!I39=\"\",\"\",Schema!I39)","v":""},{"$f":"IF(Schema!J39=\"\",\"\",Schema!J39)","v":""},{"$f":"IF(Schema!K39=\"\",\"\",Schema!K39)","v":""},{"$f":"IF(Schema!L39=\"\",\"\",Schema!L39)","v":""},{"$f":"IF(Schema!N39=\"\",\"\",Schema!N39)","v":"O"}]
[{"$f":"Schema!A40&Schema!B40&Schema!C40&Schema!D40","v":"GABRA"},"PP",{"$f":"IF(A27=\"\",\"\",IF(LEN(Schema!A40)=2,1,IF(LEN(Schema!B40)=2,10,IF(LEN(Schema!C40)=2,100,0))))","v":0},1,{"$f":"IF(A27=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C27=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_GABRA"},{"$f":"IF(Schema!I40=\"\",\"\",Schema!I40)","v":""},{"$f":"IF(Schema!J40=\"\",\"\",Schema!J40)","v":""},{"$f":"IF(Schema!K40=\"\",\"\",Schema!K40)","v":""},{"$f":"IF(Schema!L40=\"\",\"\",Schema!L40)","v":""},{"$f":"IF(Schema!N40=\"\",\"\",Schema!N40)","v":"O"}]
[{"$f":"Schema!A41&Schema!B41&Schema!C41&Schema!D41","v":"GABRAO"},"PP",{"$f":"IF(A28=\"\",\"\",IF(LEN(Schema!A41)=2,1,IF(LEN(Schema!B41)=2,10,IF(LEN(Schema!C41)=2,100,0))))","v":0},1,{"$f":"IF(A28=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C28=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_GABRAO"},{"$f":"IF(Schema!I41=\"\",\"\",Schema!I41)","v":""},{"$f":"IF(Schema!J41=\"\",\"\",Schema!J41)","v":""},{"$f":"IF(Schema!K41=\"\",\"\",Schema!K41)","v":""},{"$f":"IF(Schema!L41=\"\",\"\",Schema!L41)","v":""},{"$f":"IF(Schema!N41=\"\",\"\",Schema!N41)","v":"O"}]
[{"$f":"Schema!A42&Schema!B42&Schema!C42&Schema!D42","v":"GASBRA"},"PP",{"$f":"IF(A29=\"\",\"\",IF(LEN(Schema!A42)=2,1,IF(LEN(Schema!B42)=2,10,IF(LEN(Schema!C42)=2,100,0))))","v":0},1,{"$f":"IF(A29=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C29=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_GASBRA"},{"$f":"IF(Schema!I42=\"\",\"\",Schema!I42)","v":""},{"$f":"IF(Schema!J42=\"\",\"\",Schema!J42)","v":""},{"$f":"IF(Schema!K42=\"\",\"\",Schema!K42)","v":""},{"$f":"IF(Schema!L42=\"\",\"\",Schema!L42)","v":""},{"$f":"IF(Schema!N42=\"\",\"\",Schema!N42)","v":"O"}]
[{"$f":"Schema!A43&Schema!B43&Schema!C43&Schema!D43","v":"GASBRAO"},"PP",{"$f":"IF(A30=\"\",\"\",IF(LEN(Schema!A43)=2,1,IF(LEN(Schema!B43)=2,10,IF(LEN(Schema!C43)=2,100,0))))","v":0},1,{"$f":"IF(A30=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C30=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_GASBRAO"},{"$f":"IF(Schema!I43=\"\",\"\",Schema!I43)","v":""},{"$f":"IF(Schema!J43=\"\",\"\",Schema!J43)","v":""},{"$f":"IF(Schema!K43=\"\",\"\",Schema!K43)","v":""},{"$f":"IF(Schema!L43=\"\",\"\",Schema!L43)","v":""},{"$f":"IF(Schema!N43=\"\",\"\",Schema!N43)","v":"O"}]
[{"$f":"Schema!A44&Schema!B44&Schema!C44&Schema!D44","v":"GRNDPRM"},"PP",{"$f":"IF(A31=\"\",\"\",IF(LEN(Schema!A44)=2,1,IF(LEN(Schema!B44)=2,10,IF(LEN(Schema!C44)=2,100,0))))","v":0},1,{"$f":"IF(A31=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C31=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_GRNDPRM"},{"$f":"IF(Schema!I44=\"\",\"\",Schema!I44)","v":" "},{"$f":"IF(Schema!J44=\"\",\"\",Schema!J44)","v":""},{"$f":"IF(Schema!K44=\"\",\"\",Schema!K44)","v":""},{"$f":"IF(Schema!L44=\"\",\"\",Schema!L44)","v":""},{"$f":"IF(Schema!N44=\"\",\"\",Schema!N44)","v":"V"}]
[{"$f":"Schema!A45&Schema!B45&Schema!C45&Schema!D45","v":"HVVDAT"},"PP",{"$f":"IF(A32=\"\",\"\",IF(LEN(Schema!A45)=2,1,IF(LEN(Schema!B45)=2,10,IF(LEN(Schema!C45)=2,100,0))))","v":0},1,{"$f":"IF(A32=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C32=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_HVVDAT"},{"$f":"IF(Schema!I45=\"\",\"\",Schema!I45)","v":""},{"$f":"IF(Schema!J45=\"\",\"\",Schema!J45)","v":""},{"$f":"IF(Schema!K45=\"\",\"\",Schema!K45)","v":""},{"$f":"IF(Schema!L45=\"\",\"\",Schema!L45)","v":""},{"$f":"IF(Schema!N45=\"\",\"\",Schema!N45)","v":"O"}]
[{"$f":"Schema!A46&Schema!B46&Schema!C46&Schema!D46","v":"INGDAT"},"PP",{"$f":"IF(A33=\"\",\"\",IF(LEN(Schema!A46)=2,1,IF(LEN(Schema!B46)=2,10,IF(LEN(Schema!C46)=2,100,0))))","v":0},1,{"$f":"IF(A33=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C33=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_INGDAT"},{"$f":"IF(Schema!I46=\"\",\"\",Schema!I46)","v":""},{"$f":"IF(Schema!J46=\"\",\"\",Schema!J46)","v":""},{"$f":"IF(Schema!K46=\"\",\"\",Schema!K46)","v":""},{"$f":"IF(Schema!L46=\"\",\"\",Schema!L46)","v":""},{"$f":"IF(Schema!N46=\"\",\"\",Schema!N46)","v":"V"}]
[{"$f":"Schema!A47&Schema!B47&Schema!C47&Schema!D47","v":"INTKEY"},"PP",{"$f":"IF(A34=\"\",\"\",IF(LEN(Schema!A47)=2,1,IF(LEN(Schema!B47)=2,10,IF(LEN(Schema!C47)=2,100,0))))","v":0},1,{"$f":"IF(A34=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C34=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_INTKEY"},{"$f":"IF(Schema!I47=\"\",\"\",Schema!I47)","v":""},{"$f":"IF(Schema!J47=\"\",\"\",Schema!J47)","v":""},{"$f":"IF(Schema!K47=\"\",\"\",Schema!K47)","v":""},{"$f":"IF(Schema!L47=\"\",\"\",Schema!L47)","v":""},{"$f":"IF(Schema!N47=\"\",\"\",Schema!N47)","v":"O"}]
[{"$f":"Schema!A48&Schema!B48&Schema!C48&Schema!D48","v":"LWYZDAT"},"PP",{"$f":"IF(A35=\"\",\"\",IF(LEN(Schema!A48)=2,1,IF(LEN(Schema!B48)=2,10,IF(LEN(Schema!C48)=2,100,0))))","v":0},1,{"$f":"IF(A35=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C35=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_LWYZDAT"},{"$f":"IF(Schema!I48=\"\",\"\",Schema!I48)","v":""},{"$f":"IF(Schema!J48=\"\",\"\",Schema!J48)","v":""},{"$f":"IF(Schema!K48=\"\",\"\",Schema!K48)","v":""},{"$f":"IF(Schema!L48=\"\",\"\",Schema!L48)","v":""},{"$f":"IF(Schema!N48=\"\",\"\",Schema!N48)","v":"O"}]
[{"$f":"Schema!A49&Schema!B49&Schema!C49&Schema!D49","v":"MYAAND"},"PP",{"$f":"IF(A36=\"\",\"\",IF(LEN(Schema!A49)=2,1,IF(LEN(Schema!B49)=2,10,IF(LEN(Schema!C49)=2,100,0))))","v":0},1,{"$f":"IF(A36=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C36=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_MYAAND"},{"$f":"IF(Schema!I49=\"\",\"\",Schema!I49)","v":""},{"$f":"IF(Schema!J49=\"\",\"\",Schema!J49)","v":""},{"$f":"IF(Schema!K49=\"\",\"\",Schema!K49)","v":""},{"$f":"IF(Schema!L49=\"\",\"\",Schema!L49)","v":""},{"$f":"IF(Schema!N49=\"\",\"\",Schema!N49)","v":"V"}]
[{"$f":"Schema!A50&Schema!B50&Schema!C50&Schema!D50","v":"NJP"},"PP",{"$f":"IF(A37=\"\",\"\",IF(LEN(Schema!A50)=2,1,IF(LEN(Schema!B50)=2,10,IF(LEN(Schema!C50)=2,100,0))))","v":0},1,{"$f":"IF(A37=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C37=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_NJP"},{"$f":"IF(Schema!I50=\"\",\"\",Schema!I50)","v":""},{"$f":"IF(Schema!J50=\"\",\"\",Schema!J50)","v":""},{"$f":"IF(Schema!K50=\"\",\"\",Schema!K50)","v":""},{"$f":"IF(Schema!L50=\"\",\"\",Schema!L50)","v":""},{"$f":"IF(Schema!N50=\"\",\"\",Schema!N50)","v":"O"}]
[{"$f":"Schema!A51&Schema!B51&Schema!C51&Schema!D51","v":"NUMMER"},"PP",{"$f":"IF(A38=\"\",\"\",IF(LEN(Schema!A51)=2,1,IF(LEN(Schema!B51)=2,10,IF(LEN(Schema!C51)=2,100,0))))","v":0},1,{"$f":"IF(A38=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C38=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_NUMMER"},{"$f":"IF(Schema!I51=\"\",\"\",Schema!I51)","v":""},{"$f":"IF(Schema!J51=\"\",\"\",Schema!J51)","v":""},{"$f":"IF(Schema!K51=\"\",\"\",Schema!K51)","v":""},{"$f":"IF(Schema!L51=\"\",\"\",Schema!L51)","v":""},{"$f":"IF(Schema!N51=\"\",\"\",Schema!N51)","v":"V"}]
[{"$f":"Schema!A52&Schema!B52&Schema!C52&Schema!D52","v":"PRCTEKC"},"PP",{"$f":"IF(A39=\"\",\"\",IF(LEN(Schema!A52)=2,1,IF(LEN(Schema!B52)=2,10,IF(LEN(Schema!C52)=2,100,0))))","v":0},1,{"$f":"IF(A39=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C39=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_PRCTEKC"},{"$f":"IF(Schema!I52=\"\",\"\",Schema!I52)","v":""},{"$f":"IF(Schema!J52=\"\",\"\",Schema!J52)","v":""},{"$f":"IF(Schema!K52=\"\",\"\",Schema!K52)","v":""},{"$f":"IF(Schema!L52=\"\",\"\",Schema!L52)","v":""},{"$f":"IF(Schema!N52=\"\",\"\",Schema!N52)","v":"O"}]
[{"$f":"Schema!A53&Schema!B53&Schema!C53&Schema!D53","v":"PRODUCC"},"PP",{"$f":"IF(A40=\"\",\"\",IF(LEN(Schema!A53)=2,1,IF(LEN(Schema!B53)=2,10,IF(LEN(Schema!C53)=2,100,0))))","v":0},1,{"$f":"IF(A40=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C40=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_PRODUCC"},{"$f":"IF(Schema!I53=\"\",\"\",Schema!I53)","v":""},{"$f":"IF(Schema!J53=\"\",\"\",Schema!J53)","v":""},{"$f":"IF(Schema!K53=\"\",\"\",Schema!K53)","v":""},{"$f":"IF(Schema!L53=\"\",\"\",Schema!L53)","v":""},{"$f":"IF(Schema!N53=\"\",\"\",Schema!N53)","v":"V"}]
[{"$f":"Schema!A54&Schema!B54&Schema!C54&Schema!D54","v":"SCHDVRY"},"PP",{"$f":"IF(A41=\"\",\"\",IF(LEN(Schema!A54)=2,1,IF(LEN(Schema!B54)=2,10,IF(LEN(Schema!C54)=2,100,0))))","v":0},1,{"$f":"IF(A41=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C41=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_SCHDVRY"},{"$f":"IF(Schema!I54=\"\",\"\",Schema!I54)","v":""},{"$f":"IF(Schema!J54=\"\",\"\",Schema!J54)","v":""},{"$f":"IF(Schema!K54=\"\",\"\",Schema!K54)","v":""},{"$f":"IF(Schema!L54=\"\",\"\",Schema!L54)","v":""},{"$f":"IF(Schema!N54=\"\",\"\",Schema!N54)","v":"O"}]
[{"$f":"Schema!A55&Schema!B55&Schema!C55&Schema!D55","v":"SPECLIM"},"PP",{"$f":"IF(A42=\"\",\"\",IF(LEN(Schema!A55)=2,1,IF(LEN(Schema!B55)=2,10,IF(LEN(Schema!C55)=2,100,0))))","v":0},1,{"$f":"IF(A42=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C42=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_SPECLIM"},{"$f":"IF(Schema!I55=\"\",\"\",Schema!I55)","v":""},{"$f":"IF(Schema!J55=\"\",\"\",Schema!J55)","v":""},{"$f":"IF(Schema!K55=\"\",\"\",Schema!K55)","v":""},{"$f":"IF(Schema!L55=\"\",\"\",Schema!L55)","v":""},{"$f":"IF(Schema!N55=\"\",\"\",Schema!N55)","v":"V"}]
[{"$f":"Schema!A56&Schema!B56&Schema!C56&Schema!D56","v":"STATUS"},"PP",{"$f":"IF(A43=\"\",\"\",IF(LEN(Schema!A56)=2,1,IF(LEN(Schema!B56)=2,10,IF(LEN(Schema!C56)=2,100,0))))","v":0},1,{"$f":"IF(A43=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C43=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_STATUS"},{"$f":"IF(Schema!I56=\"\",\"\",Schema!I56)","v":""},{"$f":"IF(Schema!J56=\"\",\"\",Schema!J56)","v":""},{"$f":"IF(Schema!K56=\"\",\"\",Schema!K56)","v":""},{"$f":"IF(Schema!L56=\"\",\"\",Schema!L56)","v":""},{"$f":"IF(Schema!N56=\"\",\"\",Schema!N56)","v":"V"}]
[{"$f":"Schema!A57&Schema!B57&Schema!C57&Schema!D57","v":"TJRPO"},"PP",{"$f":"IF(A44=\"\",\"\",IF(LEN(Schema!A57)=2,1,IF(LEN(Schema!B57)=2,10,IF(LEN(Schema!C57)=2,100,0))))","v":0},1,{"$f":"IF(A44=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C44=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_TJRPO"},{"$f":"IF(Schema!I57=\"\",\"\",Schema!I57)","v":""},{"$f":"IF(Schema!J57=\"\",\"\",Schema!J57)","v":""},{"$f":"IF(Schema!K57=\"\",\"\",Schema!K57)","v":""},{"$f":"IF(Schema!L57=\"\",\"\",Schema!L57)","v":""},{"$f":"IF(Schema!N57=\"\",\"\",Schema!N57)","v":"O"}]
[{"$f":"Schema!A58&Schema!B58&Schema!C58&Schema!D58","v":"TJRPP"},"PP",{"$f":"IF(A45=\"\",\"\",IF(LEN(Schema!A58)=2,1,IF(LEN(Schema!B58)=2,10,IF(LEN(Schema!C58)=2,100,0))))","v":0},1,{"$f":"IF(A45=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C45=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_TJRPP"},{"$f":"IF(Schema!I58=\"\",\"\",Schema!I58)","v":""},{"$f":"IF(Schema!J58=\"\",\"\",Schema!J58)","v":""},{"$f":"IF(Schema!K58=\"\",\"\",Schema!K58)","v":""},{"$f":"IF(Schema!L58=\"\",\"\",Schema!L58)","v":""},{"$f":"IF(Schema!N58=\"\",\"\",Schema!N58)","v":"V"}]
[{"$f":"Schema!A59&Schema!B59&Schema!C59&Schema!D59","v":"TTEKC"},"PP",{"$f":"IF(A46=\"\",\"\",IF(LEN(Schema!A59)=2,1,IF(LEN(Schema!B59)=2,10,IF(LEN(Schema!C59)=2,100,0))))","v":0},1,{"$f":"IF(A46=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C46=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_TTEKC"},{"$f":"IF(Schema!I59=\"\",\"\",Schema!I59)","v":""},{"$f":"IF(Schema!J59=\"\",\"\",Schema!J59)","v":""},{"$f":"IF(Schema!K59=\"\",\"\",Schema!K59)","v":""},{"$f":"IF(Schema!L59=\"\",\"\",Schema!L59)","v":""},{"$f":"IF(Schema!N59=\"\",\"\",Schema!N59)","v":"O"}]
[{"$f":"Schema!A60&Schema!B60&Schema!C60&Schema!D60","v":"VGCODE"},"PP",{"$f":"IF(A47=\"\",\"\",IF(LEN(Schema!A60)=2,1,IF(LEN(Schema!B60)=2,10,IF(LEN(Schema!C60)=2,100,0))))","v":0},1,{"$f":"IF(A47=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C47=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_VGCODE"},{"$f":"IF(Schema!I60=\"\",\"\",Schema!I60)","v":""},{"$f":"IF(Schema!J60=\"\",\"\",Schema!J60)","v":""},{"$f":"IF(Schema!K60=\"\",\"\",Schema!K60)","v":""},{"$f":"IF(Schema!L60=\"\",\"\",Schema!L60)","v":""},{"$f":"IF(Schema!N60=\"\",\"\",Schema!N60)","v":"V"}]
[{"$f":"Schema!A61&Schema!B61&Schema!C61&Schema!D61","v":"VMPPRC"},"PP",{"$f":"IF(A48=\"\",\"\",IF(LEN(Schema!A61)=2,1,IF(LEN(Schema!B61)=2,10,IF(LEN(Schema!C61)=2,100,0))))","v":0},1,{"$f":"IF(A48=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C48=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_VMPPRC"},{"$f":"IF(Schema!I61=\"\",\"\",Schema!I61)","v":""},{"$f":"IF(Schema!J61=\"\",\"\",Schema!J61)","v":""},{"$f":"IF(Schema!K61=\"\",\"\",Schema!K61)","v":""},{"$f":"IF(Schema!L61=\"\",\"\",Schema!L61)","v":""},{"$f":"IF(Schema!N61=\"\",\"\",Schema!N61)","v":"O"}]
[{"$f":"Schema!A62&Schema!B62&Schema!C62&Schema!D62","v":"VMTPP"},"PP",{"$f":"IF(A49=\"\",\"\",IF(LEN(Schema!A62)=2,1,IF(LEN(Schema!B62)=2,10,IF(LEN(Schema!C62)=2,100,0))))","v":0},1,{"$f":"IF(A49=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"PP","","","PP",{"$f":"IF(C49=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"PP_VMTPP"},{"$f":"IF(Schema!I62=\"\",\"\",Schema!I62)","v":""},{"$f":"IF(Schema!J62=\"\",\"\",Schema!J62)","v":""},{"$f":"IF(Schema!K62=\"\",\"\",Schema!K62)","v":""},{"$f":"IF(Schema!L62=\"\",\"\",Schema!L62)","v":""},{"$f":"IF(Schema!N62=\"\",\"\",Schema!N62)","v":"O"}]
[{"$f":"Schema!#REF!&Schema!#REF!&Schema!#REF!&Schema!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(A50=\"\",\"\",IF(LEN(Schema!#REF!)=2,1,IF(LEN(Schema!#REF!)=2,10,IF(LEN(Schema!#REF!)=2,100,0))))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(A50=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(C50=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"Schema!A63&Schema!B63&Schema!C63&Schema!D63","v":"VVDAT"},{"$error":"#REF!"},{"$f":"IF(A51=\"\",\"\",IF(LEN(Schema!A63)=2,1,IF(LEN(Schema!B63)=2,10,IF(LEN(Schema!C63)=2,100,0))))","v":0},{"$error":"#REF!"},{"$f":"IF(A51=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(C51=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":{"$error":"#REF!"}},{"$f":"IF(Schema!I63=\"\",\"\",Schema!I63)","v":""},{"$f":"IF(Schema!J63=\"\",\"\",Schema!J63)","v":""},{"$f":"IF(Schema!K63=\"\",\"\",Schema!K63)","v":""},{"$f":"IF(Schema!L63=\"\",\"\",Schema!L63)","v":""},{"$f":"IF(Schema!N63=\"\",\"\",Schema!N63)","v":"O"}]
[{"$f":"Schema!A64&Schema!B64&Schema!C64&Schema!D64","v":"TP"},"TP",{"$f":"IF(A52=\"\",\"\",IF(LEN(Schema!A64)=2,1,IF(LEN(Schema!B64)=2,10,IF(LEN(Schema!C64)=2,100,0))))","v":10},10,{"$f":"IF(A52=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":20},{"$error":"#REF!"},"TP","",{"$error":"#REF!"},{"$f":"IF(C52=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":""},{"$f":"IF(Schema!I64=\"\",\"\",Schema!I64)","v":""},{"$f":"IF(Schema!J64=\"\",\"\",Schema!J64)","v":""},{"$f":"IF(Schema!K64=\"\",\"\",Schema!K64)","v":""},{"$f":"IF(Schema!L64=\"\",\"\",Schema!L64)","v":""},{"$f":"IF(Schema!N64=\"\",\"\",Schema!N64)","v":"O"}]
[{"$f":"Schema!A65&Schema!B65&Schema!C65&Schema!D65","v":"AFMVRGN"},"TP",{"$f":"IF(A53=\"\",\"\",IF(LEN(Schema!A65)=2,1,IF(LEN(Schema!B65)=2,10,IF(LEN(Schema!C65)=2,100,0))))","v":0},10,{"$f":"IF(A53=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"TP","",{"$error":"#REF!"},{"$f":"IF(C53=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"TP_AFMVRGN"},{"$f":"IF(Schema!I65=\"\",\"\",Schema!I65)","v":""},{"$f":"IF(Schema!J65=\"\",\"\",Schema!J65)","v":""},{"$f":"IF(Schema!K65=\"\",\"\",Schema!K65)","v":""},{"$f":"IF(Schema!L65=\"\",\"\",Schema!L65)","v":""},{"$f":"IF(Schema!N65=\"\",\"\",Schema!N65)","v":"O"}]
[{"$f":"Schema!A66&Schema!B66&Schema!C66&Schema!D66","v":"IDNR"},"TP",{"$f":"IF(A54=\"\",\"\",IF(LEN(Schema!A66)=2,1,IF(LEN(Schema!B66)=2,10,IF(LEN(Schema!C66)=2,100,0))))","v":0},10,{"$f":"IF(A54=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"TP","",{"$error":"#REF!"},{"$f":"IF(C54=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"TP_IDNR"},{"$f":"IF(Schema!I66=\"\",\"\",Schema!I66)","v":""},{"$f":"IF(Schema!J66=\"\",\"\",Schema!J66)","v":""},{"$f":"IF(Schema!K66=\"\",\"\",Schema!K66)","v":""},{"$f":"IF(Schema!L66=\"\",\"\",Schema!L66)","v":""},{"$f":"IF(Schema!N66=\"\",\"\",Schema!N66)","v":"O"}]
[{"$f":"Schema!A67&Schema!B67&Schema!C67&Schema!D67","v":"VE"},"VE",{"$f":"IF(A55=\"\",\"\",IF(LEN(Schema!A67)=2,1,IF(LEN(Schema!B67)=2,10,IF(LEN(Schema!C67)=2,100,0))))","v":10},10,{"$f":"IF(A55=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":20},{"$error":"#REF!"},"VE","",{"$error":"#REF!"},{"$f":"IF(C55=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":""},{"$f":"IF(Schema!I67=\"\",\"\",Schema!I67)","v":""},{"$f":"IF(Schema!J67=\"\",\"\",Schema!J67)","v":""},{"$f":"IF(Schema!K67=\"\",\"\",Schema!K67)","v":""},{"$f":"IF(Schema!L67=\"\",\"\",Schema!L67)","v":""},{"$f":"IF(Schema!N67=\"\",\"\",Schema!N67)","v":"V"}]
[{"$f":"Schema!A68&Schema!B68&Schema!C68&Schema!D68","v":"ANAAM"},"VE",{"$f":"IF(A56=\"\",\"\",IF(LEN(Schema!A68)=2,1,IF(LEN(Schema!B68)=2,10,IF(LEN(Schema!C68)=2,100,0))))","v":0},10,{"$f":"IF(A56=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"VE","",{"$error":"#REF!"},{"$f":"IF(C56=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"VE_ANAAM"},{"$f":"IF(Schema!I68=\"\",\"\",Schema!I68)","v":""},{"$f":"IF(Schema!J68=\"\",\"\",Schema!J68)","v":""},{"$f":"IF(Schema!K68=\"\",\"\",Schema!K68)","v":""},{"$f":"IF(Schema!L68=\"\",\"\",Schema!L68)","v":""},{"$f":"IF(Schema!N68=\"\",\"\",Schema!N68)","v":"V"}]
[{"$f":"Schema!A69&Schema!B69&Schema!C69&Schema!D69","v":"IDNR"},"VE",{"$f":"IF(A57=\"\",\"\",IF(LEN(Schema!A69)=2,1,IF(LEN(Schema!B69)=2,10,IF(LEN(Schema!C69)=2,100,0))))","v":0},10,{"$f":"IF(A57=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"VE","",{"$error":"#REF!"},{"$f":"IF(C57=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"VE_IDNR"},{"$f":"IF(Schema!I69=\"\",\"\",Schema!I69)","v":""},{"$f":"IF(Schema!J69=\"\",\"\",Schema!J69)","v":""},{"$f":"IF(Schema!K69=\"\",\"\",Schema!K69)","v":""},{"$f":"IF(Schema!L69=\"\",\"\",Schema!L69)","v":""},{"$f":"IF(Schema!N69=\"\",\"\",Schema!N69)","v":"O"}]
[{"$f":"Schema!A70&Schema!B70&Schema!C70&Schema!D70","v":"MYAAND"},"VE",{"$f":"IF(A58=\"\",\"\",IF(LEN(Schema!A70)=2,1,IF(LEN(Schema!B70)=2,10,IF(LEN(Schema!C70)=2,100,0))))","v":0},10,{"$f":"IF(A58=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"VE","",{"$error":"#REF!"},{"$f":"IF(C58=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"VE_MYAAND"},{"$f":"IF(Schema!I70=\"\",\"\",Schema!I70)","v":""},{"$f":"IF(Schema!J70=\"\",\"\",Schema!J70)","v":""},{"$f":"IF(Schema!K70=\"\",\"\",Schema!K70)","v":""},{"$f":"IF(Schema!L70=\"\",\"\",Schema!L70)","v":""},{"$f":"IF(Schema!N70=\"\",\"\",Schema!N70)","v":"O"}]
[{"$f":"Schema!A71&Schema!B71&Schema!C71&Schema!D71","v":"TELNUM"},"VE",{"$f":"IF(A59=\"\",\"\",IF(LEN(Schema!A71)=2,1,IF(LEN(Schema!B71)=2,10,IF(LEN(Schema!C71)=2,100,0))))","v":0},10,{"$f":"IF(A59=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"VE","",{"$error":"#REF!"},{"$f":"IF(C59=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"VE_TELNUM"},{"$f":"IF(Schema!I71=\"\",\"\",Schema!I71)","v":""},{"$f":"IF(Schema!J71=\"\",\"\",Schema!J71)","v":""},{"$f":"IF(Schema!K71=\"\",\"\",Schema!K71)","v":""},{"$f":"IF(Schema!L71=\"\",\"\",Schema!L71)","v":""},{"$f":"IF(Schema!N71=\"\",\"\",Schema!N71)","v":"V"}]
[{"$f":"Schema!A72&Schema!B72&Schema!C72&Schema!D72","v":"TWEEDED"},"VE",{"$f":"IF(A60=\"\",\"\",IF(LEN(Schema!A72)=2,1,IF(LEN(Schema!B72)=2,10,IF(LEN(Schema!C72)=2,100,0))))","v":0},10,{"$f":"IF(A60=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"VE","",{"$error":"#REF!"},{"$f":"IF(C60=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"VE_TWEEDED"},{"$f":"IF(Schema!I72=\"\",\"\",Schema!I72)","v":""},{"$f":"IF(Schema!J72=\"\",\"\",Schema!J72)","v":""},{"$f":"IF(Schema!K72=\"\",\"\",Schema!K72)","v":""},{"$f":"IF(Schema!L72=\"\",\"\",Schema!L72)","v":""},{"$f":"IF(Schema!N72=\"\",\"\",Schema!N72)","v":"O"}]
[{"$f":"Schema!A73&Schema!B73&Schema!C73&Schema!D73","v":"VL"},"VL",{"$f":"IF(A61=\"\",\"\",IF(LEN(Schema!A73)=2,1,IF(LEN(Schema!B73)=2,10,IF(LEN(Schema!C73)=2,100,0))))","v":10},10,{"$f":"IF(A61=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":20},{"$error":"#REF!"},"VL","",{"$error":"#REF!"},{"$f":"IF(C61=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":""},{"$f":"IF(Schema!I73=\"\",\"\",Schema!I73)","v":""},{"$f":"IF(Schema!J73=\"\",\"\",Schema!J73)","v":""},{"$f":"IF(Schema!K73=\"\",\"\",Schema!K73)","v":""},{"$f":"IF(Schema!L73=\"\",\"\",Schema!L73)","v":""},{"$f":"IF(Schema!N73=\"\",\"\",Schema!N73)","v":"V"}]
[{"$f":"Schema!A74&Schema!B74&Schema!C74&Schema!D74","v":"ANAAM"},"VL",{"$f":"IF(A62=\"\",\"\",IF(LEN(Schema!A74)=2,1,IF(LEN(Schema!B74)=2,10,IF(LEN(Schema!C74)=2,100,0))))","v":0},10,{"$f":"IF(A62=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"VL","",{"$error":"#REF!"},{"$f":"IF(C62=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"VL_ANAAM"},{"$f":"IF(Schema!I74=\"\",\"\",Schema!I74)","v":""},{"$f":"IF(Schema!J74=\"\",\"\",Schema!J74)","v":""},{"$f":"IF(Schema!K74=\"\",\"\",Schema!K74)","v":""},{"$f":"IF(Schema!L74=\"\",\"\",Schema!L74)","v":""},{"$f":"IF(Schema!N74=\"\",\"\",Schema!N74)","v":"V"}]
[{"$f":"Schema!A75&Schema!B75&Schema!C75&Schema!D75","v":"EMAIL"},"VL",{"$f":"IF(A63=\"\",\"\",IF(LEN(Schema!A75)=2,1,IF(LEN(Schema!B75)=2,10,IF(LEN(Schema!C75)=2,100,0))))","v":0},10,{"$f":"IF(A63=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"VL","",{"$error":"#REF!"},{"$f":"IF(C63=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"VL_EMAIL"},{"$f":"IF(Schema!I75=\"\",\"\",Schema!I75)","v":""},{"$f":"IF(Schema!J75=\"\",\"\",Schema!J75)","v":""},{"$f":"IF(Schema!K75=\"\",\"\",Schema!K75)","v":""},{"$f":"IF(Schema!L75=\"\",\"\",Schema!L75)","v":""},{"$f":"IF(Schema!N75=\"\",\"\",Schema!N75)","v":"O"}]
[{"$f":"Schema!A76&Schema!B76&Schema!C76&Schema!D76","v":"MYAAND"},"VL",{"$f":"IF(A64=\"\",\"\",IF(LEN(Schema!A76)=2,1,IF(LEN(Schema!B76)=2,10,IF(LEN(Schema!C76)=2,100,0))))","v":0},10,{"$f":"IF(A64=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"VL","",{"$error":"#REF!"},{"$f":"IF(C64=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"VL_MYAAND"},{"$f":"IF(Schema!I76=\"\",\"\",Schema!I76)","v":""},{"$f":"IF(Schema!J76=\"\",\"\",Schema!J76)","v":""},{"$f":"IF(Schema!K76=\"\",\"\",Schema!K76)","v":""},{"$f":"IF(Schema!L76=\"\",\"\",Schema!L76)","v":""},{"$f":"IF(Schema!N76=\"\",\"\",Schema!N76)","v":"V"}]
[{"$f":"Schema!A77&Schema!B77&Schema!C77&Schema!D77","v":"TELNUM"},"VL",{"$f":"IF(A65=\"\",\"\",IF(LEN(Schema!A77)=2,1,IF(LEN(Schema!B77)=2,10,IF(LEN(Schema!C77)=2,100,0))))","v":0},10,{"$f":"IF(A65=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"VL","",{"$error":"#REF!"},{"$f":"IF(C65=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"VL_TELNUM"},{"$f":"IF(Schema!I77=\"\",\"\",Schema!I77)","v":""},{"$f":"IF(Schema!J77=\"\",\"\",Schema!J77)","v":""},{"$f":"IF(Schema!K77=\"\",\"\",Schema!K77)","v":""},{"$f":"IF(Schema!L77=\"\",\"\",Schema!L77)","v":""},{"$f":"IF(Schema!N77=\"\",\"\",Schema!N77)","v":"O"}]
[{"$f":"Schema!A78&Schema!B78&Schema!C78&Schema!D78","v":"TWEEDED"},"VL",{"$f":"IF(A66=\"\",\"\",IF(LEN(Schema!A78)=2,1,IF(LEN(Schema!B78)=2,10,IF(LEN(Schema!C78)=2,100,0))))","v":0},10,{"$f":"IF(A66=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"VL","",{"$error":"#REF!"},{"$f":"IF(C66=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"VL_TWEEDED"},{"$f":"IF(Schema!I78=\"\",\"\",Schema!I78)","v":""},{"$f":"IF(Schema!J78=\"\",\"\",Schema!J78)","v":""},{"$f":"IF(Schema!K78=\"\",\"\",Schema!K78)","v":""},{"$f":"IF(Schema!L78=\"\",\"\",Schema!L78)","v":""},{"$f":"IF(Schema!N78=\"\",\"\",Schema!N78)","v":"O"}]
[{"$f":"Schema!A79&Schema!B79&Schema!C79&Schema!D79","v":"VEIDNR"},{"$f":"IF(LEN(A67)=2,A67,IF(A67=\"\",\"Leeg\",B66))","v":"VL"},{"$f":"IF(A67=\"\",\"\",IF(LEN(Schema!A79)=2,1,IF(LEN(Schema!B79)=2,10,IF(LEN(Schema!C79)=2,100,0))))","v":0},{"$f":"IF(C67=0,D66,C67)","v":10},{"$f":"IF(A67=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$f":"IF(A67=\"\",\"\",IF(C67=1,B67,F66))","v":{"$error":"#REF!"}},{"$f":"IF(C67=10,A67,IF(OR(C67=0,C67=100),G66,\"\"))","v":"VL"},{"$f":"IF(E67=200,B67,IF(C67=0,H66,\"\"))","v":""},{"$f":"IF(C67=\"\",\"\",IF(OR(E67=1,E67=10,E67=100),I66,IF(E67=2,F67,IF(E67=20,F67&\"/\"&G67,IF(E67=200,F67&\"/\"&G67&\"/\"&H67)))))","v":{"$error":"#REF!"}},{"$f":"IF(C67=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"VL_VEIDNR"},{"$f":"IF(Schema!I79=\"\",\"\",Schema!I79)","v":""},{"$f":"IF(Schema!J79=\"\",\"\",Schema!J79)","v":""},{"$f":"IF(Schema!K79=\"\",\"\",Schema!K79)","v":""},{"$f":"IF(Schema!L79=\"\",\"\",Schema!L79)","v":""},{"$f":"IF(Schema!N79=\"\",\"\",Schema!N79)","v":"O"}]
[{"$f":"Schema!A80&Schema!B80&Schema!C80&Schema!D80","v":"VOLGNUM"},"VL",{"$f":"IF(A68=\"\",\"\",IF(LEN(Schema!A80)=2,1,IF(LEN(Schema!B80)=2,10,IF(LEN(Schema!C80)=2,100,0))))","v":0},10,{"$f":"IF(A68=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"VL","",{"$error":"#REF!"},{"$f":"IF(C68=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"VL_VOLGNUM"},{"$f":"IF(Schema!I80=\"\",\"\",Schema!I80)","v":""},{"$f":"IF(Schema!J80=\"\",\"\",Schema!J80)","v":""},{"$f":"IF(Schema!K80=\"\",\"\",Schema!K80)","v":""},{"$f":"IF(Schema!L80=\"\",\"\",Schema!L80)","v":""},{"$f":"IF(Schema!N80=\"\",\"\",Schema!N80)","v":"LEEG"}]
[{"$f":"Schema!A81&Schema!B81&Schema!C81&Schema!D81","v":"WG"},"WG",{"$f":"IF(A69=\"\",\"\",IF(LEN(Schema!A81)=2,1,IF(LEN(Schema!B81)=2,10,IF(LEN(Schema!C81)=2,100,0))))","v":10},10,{"$f":"IF(A69=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":20},{"$error":"#REF!"},"WG","",{"$error":"#REF!"},{"$f":"IF(C69=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":""},{"$f":"IF(Schema!I81=\"\",\"\",Schema!I81)","v":""},{"$f":"IF(Schema!J81=\"\",\"\",Schema!J81)","v":""},{"$f":"IF(Schema!K81=\"\",\"\",Schema!K81)","v":""},{"$f":"IF(Schema!L81=\"\",\"\",Schema!L81)","v":""},{"$f":"IF(Schema!N81=\"\",\"\",Schema!N81)","v":"V"}]
[{"$f":"Schema!A82&Schema!B82&Schema!C82&Schema!D82","v":"ANAAM"},"WG",{"$f":"IF(A70=\"\",\"\",IF(LEN(Schema!A82)=2,1,IF(LEN(Schema!B82)=2,10,IF(LEN(Schema!C82)=2,100,0))))","v":0},10,{"$f":"IF(A70=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"WG","",{"$error":"#REF!"},{"$f":"IF(C70=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"WG_ANAAM"},{"$f":"IF(Schema!I82=\"\",\"\",Schema!I82)","v":""},{"$f":"IF(Schema!J82=\"\",\"\",Schema!J82)","v":""},{"$f":"IF(Schema!K82=\"\",\"\",Schema!K82)","v":""},{"$f":"IF(Schema!L82=\"\",\"\",Schema!L82)","v":""},{"$f":"IF(Schema!N82=\"\",\"\",Schema!N82)","v":"O"}]
[{"$f":"Schema!A83&Schema!B83&Schema!C83&Schema!D83","v":"PCODE"},"WG",{"$f":"IF(A71=\"\",\"\",IF(LEN(Schema!A83)=2,1,IF(LEN(Schema!B83)=2,10,IF(LEN(Schema!C83)=2,100,0))))","v":0},10,{"$f":"IF(A71=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"WG","",{"$error":"#REF!"},{"$f":"IF(C71=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"WG_PCODE"},{"$f":"IF(Schema!I83=\"\",\"\",Schema!I83)","v":""},{"$f":"IF(Schema!J83=\"\",\"\",Schema!J83)","v":""},{"$f":"IF(Schema!K83=\"\",\"\",Schema!K83)","v":""},{"$f":"IF(Schema!L83=\"\",\"\",Schema!L83)","v":""},{"$f":"IF(Schema!N83=\"\",\"\",Schema!N83)","v":"O"}]
[{"$f":"Schema!A84&Schema!B84&Schema!C84&Schema!D84","v":"VRWRKCD"},"WG",{"$f":"IF(A72=\"\",\"\",IF(LEN(Schema!A84)=2,1,IF(LEN(Schema!B84)=2,10,IF(LEN(Schema!C84)=2,100,0))))","v":0},10,{"$f":"IF(A72=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"WG","",{"$error":"#REF!"},{"$f":"IF(C72=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"WG_VRWRKCD"},{"$f":"IF(Schema!I84=\"\",\"\",Schema!I84)","v":""},{"$f":"IF(Schema!J84=\"\",\"\",Schema!J84)","v":""},{"$f":"IF(Schema!K84=\"\",\"\",Schema!K84)","v":""},{"$f":"IF(Schema!L84=\"\",\"\",Schema!L84)","v":""},{"$f":"IF(Schema!N84=\"\",\"\",Schema!N84)","v":"V"}]
[{"$f":"Schema!A85&Schema!B85&Schema!C85&Schema!D85","v":"WGNUM"},"WG",{"$f":"IF(A73=\"\",\"\",IF(LEN(Schema!A85)=2,1,IF(LEN(Schema!B85)=2,10,IF(LEN(Schema!C85)=2,100,0))))","v":0},10,{"$f":"IF(A73=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"WG","",{"$error":"#REF!"},{"$f":"IF(C73=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"WG_WGNUM"},{"$f":"IF(Schema!I85=\"\",\"\",Schema!I85)","v":""},{"$f":"IF(Schema!J85=\"\",\"\",Schema!J85)","v":""},{"$f":"IF(Schema!K85=\"\",\"\",Schema!K85)","v":""},{"$f":"IF(Schema!L85=\"\",\"\",Schema!L85)","v":""},{"$f":"IF(Schema!N85=\"\",\"\",Schema!N85)","v":"O"}]
[{"$f":"Schema!A86&Schema!B86&Schema!C86&Schema!D86","v":"AR"},"AR",{"$f":"IF(A74=\"\",\"\",IF(LEN(Schema!A86)=2,1,IF(LEN(Schema!B86)=2,10,IF(LEN(Schema!C86)=2,100,0))))","v":10},10,{"$f":"IF(A74=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":20},{"$error":"#REF!"},"AR","",{"$error":"#REF!"},{"$f":"IF(C74=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":""},{"$f":"IF(Schema!I86=\"\",\"\",Schema!I86)","v":""},{"$f":"IF(Schema!J86=\"\",\"\",Schema!J86)","v":""},{"$f":"IF(Schema!K86=\"\",\"\",Schema!K86)","v":""},{"$f":"IF(Schema!L86=\"\",\"\",Schema!L86)","v":""},{"$f":"IF(Schema!N86=\"\",\"\",Schema!N86)","v":"O"}]
[{"$f":"Schema!A87&Schema!B87&Schema!C87&Schema!D87","v":"ARBDNC"},"AR",{"$f":"IF(A75=\"\",\"\",IF(LEN(Schema!A87)=2,1,IF(LEN(Schema!B87)=2,10,IF(LEN(Schema!C87)=2,100,0))))","v":0},10,{"$f":"IF(A75=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AR","",{"$error":"#REF!"},{"$f":"IF(C75=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AR_ARBDNC"},{"$f":"IF(Schema!I87=\"\",\"\",Schema!I87)","v":""},{"$f":"IF(Schema!J87=\"\",\"\",Schema!J87)","v":""},{"$f":"IF(Schema!K87=\"\",\"\",Schema!K87)","v":""},{"$f":"IF(Schema!L87=\"\",\"\",Schema!L87)","v":""},{"$f":"IF(Schema!N87=\"\",\"\",Schema!N87)","v":"V"}]
[{"$f":"Schema!A88&Schema!B88&Schema!C88&Schema!D88","v":"VOLGNUM"},"AR",{"$f":"IF(A76=\"\",\"\",IF(LEN(Schema!A88)=2,1,IF(LEN(Schema!B88)=2,10,IF(LEN(Schema!C88)=2,100,0))))","v":0},10,{"$f":"IF(A76=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AR","",{"$error":"#REF!"},{"$f":"IF(C76=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AR_VOLGNUM"},{"$f":"IF(Schema!I88=\"\",\"\",Schema!I88)","v":" "},{"$f":"IF(Schema!J88=\"\",\"\",Schema!J88)","v":" "},{"$f":"IF(Schema!K88=\"\",\"\",Schema!K88)","v":""},{"$f":"IF(Schema!L88=\"\",\"\",Schema!L88)","v":""},{"$f":"IF(Schema!N88=\"\",\"\",Schema!N88)","v":"LEEG"}]
[{"$f":"Schema!A89&Schema!B89&Schema!C89&Schema!D89","v":"VRWRKCD"},"AR",{"$f":"IF(A77=\"\",\"\",IF(LEN(Schema!A89)=2,1,IF(LEN(Schema!B89)=2,10,IF(LEN(Schema!C89)=2,100,0))))","v":0},10,{"$f":"IF(A77=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AR","",{"$error":"#REF!"},{"$f":"IF(C77=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AR_VRWRKCD"},{"$f":"IF(Schema!I89=\"\",\"\",Schema!I89)","v":""},{"$f":"IF(Schema!J89=\"\",\"\",Schema!J89)","v":""},{"$f":"IF(Schema!K89=\"\",\"\",Schema!K89)","v":""},{"$f":"IF(Schema!L89=\"\",\"\",Schema!L89)","v":""},{"$f":"IF(Schema!N89=\"\",\"\",Schema!N89)","v":"V"}]
[{"$f":"Schema!A90&Schema!B90&Schema!C90&Schema!D90","v":"OG"},"OG",{"$f":"IF(A78=\"\",\"\",IF(LEN(Schema!A90)=2,1,IF(LEN(Schema!B90)=2,10,IF(LEN(Schema!C90)=2,100,0))))","v":10},10,{"$f":"IF(A78=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":20},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C78=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":""},{"$f":"IF(Schema!I90=\"\",\"\",Schema!I90)","v":""},{"$f":"IF(Schema!J90=\"\",\"\",Schema!J90)","v":""},{"$f":"IF(Schema!K90=\"\",\"\",Schema!K90)","v":""},{"$f":"IF(Schema!L90=\"\",\"\",Schema!L90)","v":""},{"$f":"IF(Schema!N90=\"\",\"\",Schema!N90)","v":"O"}]
[{"$f":"Schema!A91&Schema!B91&Schema!C91&Schema!D91","v":"AANTPLO"},"OG",{"$f":"IF(A79=\"\",\"\",IF(LEN(Schema!A91)=2,1,IF(LEN(Schema!B91)=2,10,IF(LEN(Schema!C91)=2,100,0))))","v":0},10,{"$f":"IF(A79=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C79=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"OG_AANTPLO"},{"$f":"IF(Schema!I91=\"\",\"\",Schema!I91)","v":""},{"$f":"IF(Schema!J91=\"\",\"\",Schema!J91)","v":""},{"$f":"IF(Schema!K91=\"\",\"\",Schema!K91)","v":""},{"$f":"IF(Schema!L91=\"\",\"\",Schema!L91)","v":""},{"$f":"IF(Schema!N91=\"\",\"\",Schema!N91)","v":"O"}]
[{"$f":"Schema!A92&Schema!B92&Schema!C92&Schema!D92","v":"BEDRTAK"},"OG",{"$f":"IF(A80=\"\",\"\",IF(LEN(Schema!A92)=2,1,IF(LEN(Schema!B92)=2,10,IF(LEN(Schema!C92)=2,100,0))))","v":0},10,{"$f":"IF(A80=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C80=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"OG_BEDRTAK"},{"$f":"IF(Schema!I92=\"\",\"\",Schema!I92)","v":""},{"$f":"IF(Schema!J92=\"\",\"\",Schema!J92)","v":""},{"$f":"IF(Schema!K92=\"\",\"\",Schema!K92)","v":""},{"$f":"IF(Schema!L92=\"\",\"\",Schema!L92)","v":""},{"$f":"IF(Schema!N92=\"\",\"\",Schema!N92)","v":"O"}]
[{"$f":"Schema!A93&Schema!B93&Schema!C93&Schema!D93","v":"HWIAI"},"OG",{"$f":"IF(A81=\"\",\"\",IF(LEN(Schema!A93)=2,1,IF(LEN(Schema!B93)=2,10,IF(LEN(Schema!C93)=2,100,0))))","v":0},10,{"$f":"IF(A81=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C81=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"OG_HWIAI"},{"$f":"IF(Schema!I93=\"\",\"\",Schema!I93)","v":""},{"$f":"IF(Schema!J93=\"\",\"\",Schema!J93)","v":""},{"$f":"IF(Schema!K93=\"\",\"\",Schema!K93)","v":""},{"$f":"IF(Schema!L93=\"\",\"\",Schema!L93)","v":""},{"$f":"IF(Schema!N93=\"\",\"\",Schema!N93)","v":"O"}]
[{"$f":"Schema!A94&Schema!B94&Schema!C94&Schema!D94","v":"HWIAI1"},"OG",{"$f":"IF(A82=\"\",\"\",IF(LEN(Schema!A94)=2,1,IF(LEN(Schema!B94)=2,10,IF(LEN(Schema!C94)=2,100,0))))","v":0},10,{"$f":"IF(A82=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C82=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"OG_HWIAI1"},{"$f":"IF(Schema!I94=\"\",\"\",Schema!I94)","v":""},{"$f":"IF(Schema!J94=\"\",\"\",Schema!J94)","v":""},{"$f":"IF(Schema!K94=\"\",\"\",Schema!K94)","v":""},{"$f":"IF(Schema!L94=\"\",\"\",Schema!L94)","v":""},{"$f":"IF(Schema!N94=\"\",\"\",Schema!N94)","v":"O"}]
[{"$f":"Schema!A95&Schema!B95&Schema!C95&Schema!D95","v":"HWIAI2"},"OG",{"$f":"IF(A83=\"\",\"\",IF(LEN(Schema!A95)=2,1,IF(LEN(Schema!B95)=2,10,IF(LEN(Schema!C95)=2,100,0))))","v":0},10,{"$f":"IF(A83=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C83=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"OG_HWIAI2"},{"$f":"IF(Schema!I95=\"\",\"\",Schema!I95)","v":""},{"$f":"IF(Schema!J95=\"\",\"\",Schema!J95)","v":""},{"$f":"IF(Schema!K95=\"\",\"\",Schema!K95)","v":""},{"$f":"IF(Schema!L95=\"\",\"\",Schema!L95)","v":""},{"$f":"IF(Schema!N95=\"\",\"\",Schema!N95)","v":"O"}]
[{"$f":"Schema!A96&Schema!B96&Schema!C96&Schema!D96","v":"HWIAI3"},"OG",{"$f":"IF(A84=\"\",\"\",IF(LEN(Schema!A96)=2,1,IF(LEN(Schema!B96)=2,10,IF(LEN(Schema!C96)=2,100,0))))","v":0},10,{"$f":"IF(A84=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C84=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"OG_HWIAI3"},{"$f":"IF(Schema!I96=\"\",\"\",Schema!I96)","v":""},{"$f":"IF(Schema!J96=\"\",\"\",Schema!J96)","v":""},{"$f":"IF(Schema!K96=\"\",\"\",Schema!K96)","v":""},{"$f":"IF(Schema!L96=\"\",\"\",Schema!L96)","v":""},{"$f":"IF(Schema!N96=\"\",\"\",Schema!N96)","v":"O"}]
[{"$f":"Schema!A97&Schema!B97&Schema!C97&Schema!D97","v":"HWIAI4"},"OG",{"$f":"IF(A85=\"\",\"\",IF(LEN(Schema!A97)=2,1,IF(LEN(Schema!B97)=2,10,IF(LEN(Schema!C97)=2,100,0))))","v":0},10,{"$f":"IF(A85=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C85=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"OG_HWIAI4"},{"$f":"IF(Schema!I97=\"\",\"\",Schema!I97)","v":""},{"$f":"IF(Schema!J97=\"\",\"\",Schema!J97)","v":""},{"$f":"IF(Schema!K97=\"\",\"\",Schema!K97)","v":""},{"$f":"IF(Schema!L97=\"\",\"\",Schema!L97)","v":""},{"$f":"IF(Schema!N97=\"\",\"\",Schema!N97)","v":"O"}]
[{"$f":"Schema!A98&Schema!B98&Schema!C98&Schema!D98","v":"IDNR"},"OG",{"$f":"IF(A86=\"\",\"\",IF(LEN(Schema!A98)=2,1,IF(LEN(Schema!B98)=2,10,IF(LEN(Schema!C98)=2,100,0))))","v":0},10,{"$f":"IF(A86=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C86=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"OG_IDNR"},{"$f":"IF(Schema!I98=\"\",\"\",Schema!I98)","v":""},{"$f":"IF(Schema!J98=\"\",\"\",Schema!J98)","v":""},{"$f":"IF(Schema!K98=\"\",\"\",Schema!K98)","v":""},{"$f":"IF(Schema!L98=\"\",\"\",Schema!L98)","v":""},{"$f":"IF(Schema!N98=\"\",\"\",Schema!N98)","v":"O"}]
[{"$f":"Schema!A99&Schema!B99&Schema!C99&Schema!D99","v":"JRLNFSV"},"OG",{"$f":"IF(A87=\"\",\"\",IF(LEN(Schema!A99)=2,1,IF(LEN(Schema!B99)=2,10,IF(LEN(Schema!C99)=2,100,0))))","v":0},10,{"$f":"IF(A87=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C87=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"OG_JRLNFSV"},{"$f":"IF(Schema!I99=\"\",\"\",Schema!I99)","v":""},{"$f":"IF(Schema!J99=\"\",\"\",Schema!J99)","v":""},{"$f":"IF(Schema!K99=\"\",\"\",Schema!K99)","v":""},{"$f":"IF(Schema!L99=\"\",\"\",Schema!L99)","v":""},{"$f":"IF(Schema!N99=\"\",\"\",Schema!N99)","v":"O"}]
[{"$f":"Schema!A100&Schema!B100&Schema!C100&Schema!D100","v":"NRHNDRG"},"OG",{"$f":"IF(A88=\"\",\"\",IF(LEN(Schema!A100)=2,1,IF(LEN(Schema!B100)=2,10,IF(LEN(Schema!C100)=2,100,0))))","v":0},10,{"$f":"IF(A88=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C88=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"OG_NRHNDRG"},{"$f":"IF(Schema!I100=\"\",\"\",Schema!I100)","v":""},{"$f":"IF(Schema!J100=\"\",\"\",Schema!J100)","v":""},{"$f":"IF(Schema!K100=\"\",\"\",Schema!K100)","v":""},{"$f":"IF(Schema!L100=\"\",\"\",Schema!L100)","v":""},{"$f":"IF(Schema!N100=\"\",\"\",Schema!N100)","v":"O"}]
[{"$f":"Schema!A101&Schema!B101&Schema!C101&Schema!D101","v":"OPRDAT"},"OG",{"$f":"IF(A89=\"\",\"\",IF(LEN(Schema!A101)=2,1,IF(LEN(Schema!B101)=2,10,IF(LEN(Schema!C101)=2,100,0))))","v":0},10,{"$f":"IF(A89=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C89=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"OG_OPRDAT"},{"$f":"IF(Schema!I101=\"\",\"\",Schema!I101)","v":""},{"$f":"IF(Schema!J101=\"\",\"\",Schema!J101)","v":""},{"$f":"IF(Schema!K101=\"\",\"\",Schema!K101)","v":""},{"$f":"IF(Schema!L101=\"\",\"\",Schema!L101)","v":""},{"$f":"IF(Schema!N101=\"\",\"\",Schema!N101)","v":"O"}]
[{"$f":"Schema!A106&Schema!B106&Schema!C106&Schema!D106","v":"P2JEJ"},"OG",{"$f":"IF(A90=\"\",\"\",IF(LEN(Schema!A106)=2,1,IF(LEN(Schema!B106)=2,10,IF(LEN(Schema!C106)=2,100,0))))","v":0},10,{"$f":"IF(A90=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C90=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"OG_P2JEJ"},{"$f":"IF(Schema!I106=\"\",\"\",Schema!I106)","v":""},{"$f":"IF(Schema!J106=\"\",\"\",Schema!J106)","v":""},{"$f":"IF(Schema!K106=\"\",\"\",Schema!K106)","v":""},{"$f":"IF(Schema!L106=\"\",\"\",Schema!L106)","v":""},{"$f":"IF(Schema!N106=\"\",\"\",Schema!N106)","v":"O"}]
[{"$f":"Schema!A107&Schema!B107&Schema!C107&Schema!D107","v":"P2JTJ"},"OG",{"$f":"IF(A91=\"\",\"\",IF(LEN(Schema!A107)=2,1,IF(LEN(Schema!B107)=2,10,IF(LEN(Schema!C107)=2,100,0))))","v":0},10,{"$f":"IF(A91=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C91=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"OG_P2JTJ"},{"$f":"IF(Schema!I107=\"\",\"\",Schema!I107)","v":""},{"$f":"IF(Schema!J107=\"\",\"\",Schema!J107)","v":""},{"$f":"IF(Schema!K107=\"\",\"\",Schema!K107)","v":""},{"$f":"IF(Schema!L107=\"\",\"\",Schema!L107)","v":""},{"$f":"IF(Schema!N107=\"\",\"\",Schema!N107)","v":"O"}]
[{"$f":"Schema!A108&Schema!B108&Schema!C108&Schema!D108","v":"P3JEJ"},"OG",{"$f":"IF(A92=\"\",\"\",IF(LEN(Schema!A108)=2,1,IF(LEN(Schema!B108)=2,10,IF(LEN(Schema!C108)=2,100,0))))","v":0},10,{"$f":"IF(A92=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C92=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"OG_P3JEJ"},{"$f":"IF(Schema!I108=\"\",\"\",Schema!I108)","v":""},{"$f":"IF(Schema!J108=\"\",\"\",Schema!J108)","v":""},{"$f":"IF(Schema!K108=\"\",\"\",Schema!K108)","v":""},{"$f":"IF(Schema!L108=\"\",\"\",Schema!L108)","v":""},{"$f":"IF(Schema!N108=\"\",\"\",Schema!N108)","v":"O"}]
[{"$f":"Schema!A109&Schema!B109&Schema!C109&Schema!D109","v":"P3JTJ"},"OG",{"$f":"IF(A93=\"\",\"\",IF(LEN(Schema!A109)=2,1,IF(LEN(Schema!B109)=2,10,IF(LEN(Schema!C109)=2,100,0))))","v":0},10,{"$f":"IF(A93=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C93=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"OG_P3JTJ"},{"$f":"IF(Schema!I109=\"\",\"\",Schema!I109)","v":""},{"$f":"IF(Schema!J109=\"\",\"\",Schema!J109)","v":""},{"$f":"IF(Schema!K109=\"\",\"\",Schema!K109)","v":""},{"$f":"IF(Schema!L109=\"\",\"\",Schema!L109)","v":""},{"$f":"IF(Schema!N109=\"\",\"\",Schema!N109)","v":"O"}]
[{"$f":"Schema!A110&Schema!B110&Schema!C110&Schema!D110","v":"PVJEJ"},"OG",{"$f":"IF(A94=\"\",\"\",IF(LEN(Schema!A110)=2,1,IF(LEN(Schema!B110)=2,10,IF(LEN(Schema!C110)=2,100,0))))","v":0},10,{"$f":"IF(A94=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C94=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"OG_PVJEJ"},{"$f":"IF(Schema!I110=\"\",\"\",Schema!I110)","v":""},{"$f":"IF(Schema!J110=\"\",\"\",Schema!J110)","v":""},{"$f":"IF(Schema!K110=\"\",\"\",Schema!K110)","v":""},{"$f":"IF(Schema!L110=\"\",\"\",Schema!L110)","v":""},{"$f":"IF(Schema!N110=\"\",\"\",Schema!N110)","v":"O"}]
[{"$f":"Schema!A111&Schema!B111&Schema!C111&Schema!D111","v":"PVJTJ"},"OG",{"$f":"IF(A95=\"\",\"\",IF(LEN(Schema!A111)=2,1,IF(LEN(Schema!B111)=2,10,IF(LEN(Schema!C111)=2,100,0))))","v":0},10,{"$f":"IF(A95=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C95=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"OG_PVJTJ"},{"$f":"IF(Schema!I111=\"\",\"\",Schema!I111)","v":""},{"$f":"IF(Schema!J111=\"\",\"\",Schema!J111)","v":""},{"$f":"IF(Schema!K111=\"\",\"\",Schema!K111)","v":""},{"$f":"IF(Schema!L111=\"\",\"\",Schema!L111)","v":""},{"$f":"IF(Schema!N111=\"\",\"\",Schema!N111)","v":"O"}]
[{"$f":"Schema!A112&Schema!B112&Schema!C112&Schema!D112","v":"RELNUM"},"OG",{"$f":"IF(A96=\"\",\"\",IF(LEN(Schema!A112)=2,1,IF(LEN(Schema!B112)=2,10,IF(LEN(Schema!C112)=2,100,0))))","v":0},10,{"$f":"IF(A96=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C96=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"OG_RELNUM"},{"$f":"IF(Schema!I112=\"\",\"\",Schema!I112)","v":""},{"$f":"IF(Schema!J112=\"\",\"\",Schema!J112)","v":""},{"$f":"IF(Schema!K112=\"\",\"\",Schema!K112)","v":""},{"$f":"IF(Schema!L112=\"\",\"\",Schema!L112)","v":""},{"$f":"IF(Schema!N112=\"\",\"\",Schema!N112)","v":"O"}]
[{"$f":"Schema!A113&Schema!B113&Schema!C113&Schema!D113","v":"SBIBEDR"},"OG",{"$f":"IF(A97=\"\",\"\",IF(LEN(Schema!A113)=2,1,IF(LEN(Schema!B113)=2,10,IF(LEN(Schema!C113)=2,100,0))))","v":0},10,{"$f":"IF(A97=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C97=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"OG_SBIBEDR"},{"$f":"IF(Schema!I113=\"\",\"\",Schema!I113)","v":""},{"$f":"IF(Schema!J113=\"\",\"\",Schema!J113)","v":""},{"$f":"IF(Schema!K113=\"\",\"\",Schema!K113)","v":""},{"$f":"IF(Schema!L113=\"\",\"\",Schema!L113)","v":""},{"$f":"IF(Schema!N113=\"\",\"\",Schema!N113)","v":"O"}]
[{"$f":"Schema!A114&Schema!B114&Schema!C114&Schema!D114","v":"SECNN"},"OG",{"$f":"IF(A98=\"\",\"\",IF(LEN(Schema!A114)=2,1,IF(LEN(Schema!B114)=2,10,IF(LEN(Schema!C114)=2,100,0))))","v":0},10,{"$f":"IF(A98=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"OG","",{"$error":"#REF!"},{"$f":"IF(C98=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"OG_SECNN"},{"$f":"IF(Schema!I114=\"\",\"\",Schema!I114)","v":""},{"$f":"IF(Schema!J114=\"\",\"\",Schema!J114)","v":""},{"$f":"IF(Schema!K114=\"\",\"\",Schema!K114)","v":""},{"$f":"IF(Schema!L114=\"\",\"\",Schema!L114)","v":""},{"$f":"IF(Schema!N114=\"\",\"\",Schema!N114)","v":"O"}]
[{"$f":"Schema!A115&Schema!B115&Schema!C115&Schema!D115","v":"AO"},"AO",{"$f":"IF(A99=\"\",\"\",IF(LEN(Schema!A115)=2,1,IF(LEN(Schema!B115)=2,10,IF(LEN(Schema!C115)=2,100,0))))","v":10},10,{"$f":"IF(A99=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":20},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C99=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":""},{"$f":"IF(Schema!I115=\"\",\"\",Schema!I115)","v":""},{"$f":"IF(Schema!J115=\"\",\"\",Schema!J115)","v":""},{"$f":"IF(Schema!K115=\"\",\"\",Schema!K115)","v":""},{"$f":"IF(Schema!L115=\"\",\"\",Schema!L115)","v":""},{"$f":"IF(Schema!N115=\"\",\"\",Schema!N115)","v":"O"}]
[{"$f":"Schema!A116&Schema!B116&Schema!C116&Schema!D116","v":"BAFWST"},"AO",{"$f":"IF(A100=\"\",\"\",IF(LEN(Schema!A116)=2,1,IF(LEN(Schema!B116)=2,10,IF(LEN(Schema!C116)=2,100,0))))","v":0},10,{"$f":"IF(A100=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C100=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_BAFWST"},{"$f":"IF(Schema!I116=\"\",\"\",Schema!I116)","v":""},{"$f":"IF(Schema!J116=\"\",\"\",Schema!J116)","v":""},{"$f":"IF(Schema!K116=\"\",\"\",Schema!K116)","v":""},{"$f":"IF(Schema!L116=\"\",\"\",Schema!L116)","v":""},{"$f":"IF(Schema!N116=\"\",\"\",Schema!N116)","v":"O"}]
[{"$f":"Schema!A117&Schema!B117&Schema!C117&Schema!D117","v":"BJP"},"AO",{"$f":"IF(A101=\"\",\"\",IF(LEN(Schema!A117)=2,1,IF(LEN(Schema!B117)=2,10,IF(LEN(Schema!C117)=2,100,0))))","v":0},10,{"$f":"IF(A101=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C101=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_BJP"},{"$f":"IF(Schema!I117=\"\",\"\",Schema!I117)","v":""},{"$f":"IF(Schema!J117=\"\",\"\",Schema!J117)","v":""},{"$f":"IF(Schema!K117=\"\",\"\",Schema!K117)","v":""},{"$f":"IF(Schema!L117=\"\",\"\",Schema!L117)","v":""},{"$f":"IF(Schema!N117=\"\",\"\",Schema!N117)","v":"O"}]
[{"$f":"Schema!A118&Schema!B118&Schema!C118&Schema!D118","v":"BRPRPW1"},"AO",{"$f":"IF(A102=\"\",\"\",IF(LEN(Schema!A118)=2,1,IF(LEN(Schema!B118)=2,10,IF(LEN(Schema!C118)=2,100,0))))","v":0},10,{"$f":"IF(A102=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C102=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_BRPRPW1"},{"$f":"IF(Schema!I118=\"\",\"\",Schema!I118)","v":""},{"$f":"IF(Schema!J118=\"\",\"\",Schema!J118)","v":""},{"$f":"IF(Schema!K118=\"\",\"\",Schema!K118)","v":""},{"$f":"IF(Schema!L118=\"\",\"\",Schema!L118)","v":""},{"$f":"IF(Schema!N118=\"\",\"\",Schema!N118)","v":"O"}]
[{"$f":"Schema!A119&Schema!B119&Schema!C119&Schema!D119","v":"BRPRPW2"},"AO",{"$f":"IF(A103=\"\",\"\",IF(LEN(Schema!A119)=2,1,IF(LEN(Schema!B119)=2,10,IF(LEN(Schema!C119)=2,100,0))))","v":0},10,{"$f":"IF(A103=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C103=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_BRPRPW2"},{"$f":"IF(Schema!I119=\"\",\"\",Schema!I119)","v":""},{"$f":"IF(Schema!J119=\"\",\"\",Schema!J119)","v":""},{"$f":"IF(Schema!K119=\"\",\"\",Schema!K119)","v":""},{"$f":"IF(Schema!L119=\"\",\"\",Schema!L119)","v":""},{"$f":"IF(Schema!N119=\"\",\"\",Schema!N119)","v":"O"}]
[{"$f":"Schema!A120&Schema!B120&Schema!C120&Schema!D120","v":"BTP"},"AO",{"$f":"IF(A104=\"\",\"\",IF(LEN(Schema!A120)=2,1,IF(LEN(Schema!B120)=2,10,IF(LEN(Schema!C120)=2,100,0))))","v":0},10,{"$f":"IF(A104=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C104=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_BTP"},{"$f":"IF(Schema!I120=\"\",\"\",Schema!I120)","v":""},{"$f":"IF(Schema!J120=\"\",\"\",Schema!J120)","v":""},{"$f":"IF(Schema!K120=\"\",\"\",Schema!K120)","v":""},{"$f":"IF(Schema!L120=\"\",\"\",Schema!L120)","v":""},{"$f":"IF(Schema!N120=\"\",\"\",Schema!N120)","v":"O"}]
[{"$f":"Schema!A121&Schema!B121&Schema!C121&Schema!D121","v":"CODE"},"AO",{"$f":"IF(A105=\"\",\"\",IF(LEN(Schema!A121)=2,1,IF(LEN(Schema!B121)=2,10,IF(LEN(Schema!C121)=2,100,0))))","v":0},10,{"$f":"IF(A105=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C105=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_CODE"},{"$f":"IF(Schema!I121=\"\",\"\",Schema!I121)","v":""},{"$f":"IF(Schema!J121=\"\",\"\",Schema!J121)","v":""},{"$f":"IF(Schema!K121=\"\",\"\",Schema!K121)","v":""},{"$f":"IF(Schema!L121=\"\",\"\",Schema!L121)","v":""},{"$f":"IF(Schema!N121=\"\",\"\",Schema!N121)","v":"V"}]
[{"$f":"Schema!A122&Schema!B122&Schema!C122&Schema!D122","v":"EINDLFT"},"AO",{"$f":"IF(A106=\"\",\"\",IF(LEN(Schema!A122)=2,1,IF(LEN(Schema!B122)=2,10,IF(LEN(Schema!C122)=2,100,0))))","v":0},10,{"$f":"IF(A106=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C106=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_EINDLFT"},{"$f":"IF(Schema!I122=\"\",\"\",Schema!I122)","v":""},{"$f":"IF(Schema!J122=\"\",\"\",Schema!J122)","v":""},{"$f":"IF(Schema!K122=\"\",\"\",Schema!K122)","v":""},{"$f":"IF(Schema!L122=\"\",\"\",Schema!L122)","v":""},{"$f":"IF(Schema!N122=\"\",\"\",Schema!N122)","v":"O"}]
[{"$f":"Schema!A125&Schema!B125&Schema!C125&Schema!D125","v":"INDREN"},"AO",{"$f":"IF(A107=\"\",\"\",IF(LEN(Schema!A125)=2,1,IF(LEN(Schema!B125)=2,10,IF(LEN(Schema!C125)=2,100,0))))","v":0},10,{"$f":"IF(A107=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C107=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_INDREN"},{"$f":"IF(Schema!I125=\"\",\"\",Schema!I125)","v":""},{"$f":"IF(Schema!J125=\"\",\"\",Schema!J125)","v":""},{"$f":"IF(Schema!K125=\"\",\"\",Schema!K125)","v":""},{"$f":"IF(Schema!L125=\"\",\"\",Schema!L125)","v":""},{"$f":"IF(Schema!N125=\"\",\"\",Schema!N125)","v":"V"}]
[{"$f":"Schema!A126&Schema!B126&Schema!C126&Schema!D126","v":"INDRENM"},"AO",{"$f":"IF(A108=\"\",\"\",IF(LEN(Schema!A126)=2,1,IF(LEN(Schema!B126)=2,10,IF(LEN(Schema!C126)=2,100,0))))","v":0},10,{"$f":"IF(A108=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C108=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_INDRENM"},{"$f":"IF(Schema!I126=\"\",\"\",Schema!I126)","v":""},{"$f":"IF(Schema!J126=\"\",\"\",Schema!J126)","v":""},{"$f":"IF(Schema!K126=\"\",\"\",Schema!K126)","v":""},{"$f":"IF(Schema!L126=\"\",\"\",Schema!L126)","v":""},{"$f":"IF(Schema!N126=\"\",\"\",Schema!N126)","v":"O"}]
[{"$f":"Schema!A127&Schema!B127&Schema!C127&Schema!D127","v":"INDRENP"},"AO",{"$f":"IF(A109=\"\",\"\",IF(LEN(Schema!A127)=2,1,IF(LEN(Schema!B127)=2,10,IF(LEN(Schema!C127)=2,100,0))))","v":0},10,{"$f":"IF(A109=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C109=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_INDRENP"},{"$f":"IF(Schema!I127=\"\",\"\",Schema!I127)","v":""},{"$f":"IF(Schema!J127=\"\",\"\",Schema!J127)","v":""},{"$f":"IF(Schema!K127=\"\",\"\",Schema!K127)","v":""},{"$f":"IF(Schema!L127=\"\",\"\",Schema!L127)","v":""},{"$f":"IF(Schema!N127=\"\",\"\",Schema!N127)","v":"O"}]
[{"$f":"Schema!A128&Schema!B128&Schema!C128&Schema!D128","v":"MAXVERZ"},"AO",{"$f":"IF(A110=\"\",\"\",IF(LEN(Schema!A128)=2,1,IF(LEN(Schema!B128)=2,10,IF(LEN(Schema!C128)=2,100,0))))","v":0},10,{"$f":"IF(A110=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C110=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_MAXVERZ"},{"$f":"IF(Schema!I128=\"\",\"\",Schema!I128)","v":""},{"$f":"IF(Schema!J128=\"\",\"\",Schema!J128)","v":""},{"$f":"IF(Schema!K128=\"\",\"\",Schema!K128)","v":""},{"$f":"IF(Schema!L128=\"\",\"\",Schema!L128)","v":""},{"$f":"IF(Schema!N128=\"\",\"\",Schema!N128)","v":"O"}]
[{"$f":"Schema!A129&Schema!B129&Schema!C129&Schema!D129","v":"MYCODE"},"AO",{"$f":"IF(A111=\"\",\"\",IF(LEN(Schema!A129)=2,1,IF(LEN(Schema!B129)=2,10,IF(LEN(Schema!C129)=2,100,0))))","v":0},10,{"$f":"IF(A111=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C111=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_MYCODE"},{"$f":"IF(Schema!I129=\"\",\"\",Schema!I129)","v":""},{"$f":"IF(Schema!J129=\"\",\"\",Schema!J129)","v":""},{"$f":"IF(Schema!K129=\"\",\"\",Schema!K129)","v":""},{"$f":"IF(Schema!L129=\"\",\"\",Schema!L129)","v":""},{"$f":"IF(Schema!N129=\"\",\"\",Schema!N129)","v":"O"}]
[{"$f":"Schema!A130&Schema!B130&Schema!C130&Schema!D130","v":"PAFWST"},"AO",{"$f":"IF(A112=\"\",\"\",IF(LEN(Schema!A130)=2,1,IF(LEN(Schema!B130)=2,10,IF(LEN(Schema!C130)=2,100,0))))","v":0},10,{"$f":"IF(A112=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C112=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_PAFWST"},{"$f":"IF(Schema!I130=\"\",\"\",Schema!I130)","v":""},{"$f":"IF(Schema!J130=\"\",\"\",Schema!J130)","v":""},{"$f":"IF(Schema!K130=\"\",\"\",Schema!K130)","v":""},{"$f":"IF(Schema!L130=\"\",\"\",Schema!L130)","v":""},{"$f":"IF(Schema!N130=\"\",\"\",Schema!N130)","v":"O"}]
[{"$f":"Schema!A131&Schema!B131&Schema!C131&Schema!D131","v":"PERCDEK"},"AO",{"$f":"IF(A113=\"\",\"\",IF(LEN(Schema!A131)=2,1,IF(LEN(Schema!B131)=2,10,IF(LEN(Schema!C131)=2,100,0))))","v":0},10,{"$f":"IF(A113=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C113=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_PERCDEK"},{"$f":"IF(Schema!I131=\"\",\"\",Schema!I131)","v":""},{"$f":"IF(Schema!J131=\"\",\"\",Schema!J131)","v":""},{"$f":"IF(Schema!K131=\"\",\"\",Schema!K131)","v":""},{"$f":"IF(Schema!L131=\"\",\"\",Schema!L131)","v":""},{"$f":"IF(Schema!N131=\"\",\"\",Schema!N131)","v":"O"}]
[{"$f":"Schema!A132&Schema!B132&Schema!C132&Schema!D132","v":"PRCTEKC"},"AO",{"$f":"IF(A114=\"\",\"\",IF(LEN(Schema!A132)=2,1,IF(LEN(Schema!B132)=2,10,IF(LEN(Schema!C132)=2,100,0))))","v":0},10,{"$f":"IF(A114=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C114=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_PRCTEKC"},{"$f":"IF(Schema!I132=\"\",\"\",Schema!I132)","v":""},{"$f":"IF(Schema!J132=\"\",\"\",Schema!J132)","v":""},{"$f":"IF(Schema!K132=\"\",\"\",Schema!K132)","v":""},{"$f":"IF(Schema!L132=\"\",\"\",Schema!L132)","v":""},{"$f":"IF(Schema!N132=\"\",\"\",Schema!N132)","v":"O"}]
[{"$f":"Schema!A133&Schema!B133&Schema!C133&Schema!D133","v":"PRCWKGL"},"AO",{"$f":"IF(A115=\"\",\"\",IF(LEN(Schema!A133)=2,1,IF(LEN(Schema!B133)=2,10,IF(LEN(Schema!C133)=2,100,0))))","v":0},10,{"$f":"IF(A115=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C115=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_PRCWKGL"},{"$f":"IF(Schema!I133=\"\",\"\",Schema!I133)","v":""},{"$f":"IF(Schema!J133=\"\",\"\",Schema!J133)","v":""},{"$f":"IF(Schema!K133=\"\",\"\",Schema!K133)","v":""},{"$f":"IF(Schema!L133=\"\",\"\",Schema!L133)","v":""},{"$f":"IF(Schema!N133=\"\",\"\",Schema!N133)","v":"O"}]
[{"$f":"Schema!A134&Schema!B134&Schema!C134&Schema!D134","v":"PRMPRCL"},"AO",{"$f":"IF(A116=\"\",\"\",IF(LEN(Schema!A134)=2,1,IF(LEN(Schema!B134)=2,10,IF(LEN(Schema!C134)=2,100,0))))","v":0},10,{"$f":"IF(A116=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C116=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_PRMPRCL"},{"$f":"IF(Schema!I134=\"\",\"\",Schema!I134)","v":""},{"$f":"IF(Schema!J134=\"\",\"\",Schema!J134)","v":""},{"$f":"IF(Schema!K134=\"\",\"\",Schema!K134)","v":""},{"$f":"IF(Schema!L134=\"\",\"\",Schema!L134)","v":""},{"$f":"IF(Schema!N134=\"\",\"\",Schema!N134)","v":"O"}]
[{"$f":"Schema!A135&Schema!B135&Schema!C135&Schema!D135","v":"RJRCOR"},"AO",{"$f":"IF(A117=\"\",\"\",IF(LEN(Schema!A135)=2,1,IF(LEN(Schema!B135)=2,10,IF(LEN(Schema!C135)=2,100,0))))","v":0},10,{"$f":"IF(A117=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C117=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_RJRCOR"},{"$f":"IF(Schema!I135=\"\",\"\",Schema!I135)","v":""},{"$f":"IF(Schema!J135=\"\",\"\",Schema!J135)","v":""},{"$f":"IF(Schema!K135=\"\",\"\",Schema!K135)","v":""},{"$f":"IF(Schema!L135=\"\",\"\",Schema!L135)","v":""},{"$f":"IF(Schema!N135=\"\",\"\",Schema!N135)","v":"O"}]
[{"$f":"Schema!A136&Schema!B136&Schema!C136&Schema!D136","v":"TCORBDR"},"AO",{"$f":"IF(A118=\"\",\"\",IF(LEN(Schema!A136)=2,1,IF(LEN(Schema!B136)=2,10,IF(LEN(Schema!C136)=2,100,0))))","v":0},10,{"$f":"IF(A118=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C118=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_TCORBDR"},{"$f":"IF(Schema!I136=\"\",\"\",Schema!I136)","v":""},{"$f":"IF(Schema!J136=\"\",\"\",Schema!J136)","v":""},{"$f":"IF(Schema!K136=\"\",\"\",Schema!K136)","v":""},{"$f":"IF(Schema!L136=\"\",\"\",Schema!L136)","v":""},{"$f":"IF(Schema!N136=\"\",\"\",Schema!N136)","v":"O"}]
[{"$f":"Schema!A137&Schema!B137&Schema!C137&Schema!D137","v":"TTEKC"},"AO",{"$f":"IF(A119=\"\",\"\",IF(LEN(Schema!A137)=2,1,IF(LEN(Schema!B137)=2,10,IF(LEN(Schema!C137)=2,100,0))))","v":0},10,{"$f":"IF(A119=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C119=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_TTEKC"},{"$f":"IF(Schema!I137=\"\",\"\",Schema!I137)","v":""},{"$f":"IF(Schema!J137=\"\",\"\",Schema!J137)","v":""},{"$f":"IF(Schema!K137=\"\",\"\",Schema!K137)","v":""},{"$f":"IF(Schema!L137=\"\",\"\",Schema!L137)","v":""},{"$f":"IF(Schema!N137=\"\",\"\",Schema!N137)","v":"O"}]
[{"$f":"Schema!A138&Schema!B138&Schema!C138&Schema!D138","v":"UITDUUR"},"AO",{"$f":"IF(A120=\"\",\"\",IF(LEN(Schema!A138)=2,1,IF(LEN(Schema!B138)=2,10,IF(LEN(Schema!C138)=2,100,0))))","v":0},10,{"$f":"IF(A120=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C120=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_UITDUUR"},{"$f":"IF(Schema!I138=\"\",\"\",Schema!I138)","v":""},{"$f":"IF(Schema!J138=\"\",\"\",Schema!J138)","v":""},{"$f":"IF(Schema!K138=\"\",\"\",Schema!K138)","v":""},{"$f":"IF(Schema!L138=\"\",\"\",Schema!L138)","v":""},{"$f":"IF(Schema!N138=\"\",\"\",Schema!N138)","v":"O"}]
[{"$f":"Schema!A139&Schema!B139&Schema!C139&Schema!D139","v":"VERZSOM"},"AO",{"$f":"IF(A121=\"\",\"\",IF(LEN(Schema!A139)=2,1,IF(LEN(Schema!B139)=2,10,IF(LEN(Schema!C139)=2,100,0))))","v":0},10,{"$f":"IF(A121=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C121=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_VERZSOM"},{"$f":"IF(Schema!I139=\"\",\"\",Schema!I139)","v":""},{"$f":"IF(Schema!J139=\"\",\"\",Schema!J139)","v":""},{"$f":"IF(Schema!K139=\"\",\"\",Schema!K139)","v":""},{"$f":"IF(Schema!L139=\"\",\"\",Schema!L139)","v":""},{"$f":"IF(Schema!N139=\"\",\"\",Schema!N139)","v":"V"}]
[{"$f":"Schema!A141&Schema!B141&Schema!C141&Schema!D141","v":"VMPPRC"},"AO",{"$f":"IF(A122=\"\",\"\",IF(LEN(Schema!A141)=2,1,IF(LEN(Schema!B141)=2,10,IF(LEN(Schema!C141)=2,100,0))))","v":0},10,{"$f":"IF(A122=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C122=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_VMPPRC"},{"$f":"IF(Schema!I141=\"\",\"\",Schema!I141)","v":""},{"$f":"IF(Schema!J141=\"\",\"\",Schema!J141)","v":""},{"$f":"IF(Schema!K141=\"\",\"\",Schema!K141)","v":""},{"$f":"IF(Schema!L141=\"\",\"\",Schema!L141)","v":""},{"$f":"IF(Schema!N141=\"\",\"\",Schema!N141)","v":"O"}]
[{"$f":"Schema!A142&Schema!B142&Schema!C142&Schema!D142","v":"VMTPP"},"AO",{"$f":"IF(A123=\"\",\"\",IF(LEN(Schema!A142)=2,1,IF(LEN(Schema!B142)=2,10,IF(LEN(Schema!C142)=2,100,0))))","v":0},10,{"$f":"IF(A123=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C123=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_VMTPP"},{"$f":"IF(Schema!I142=\"\",\"\",Schema!I142)","v":""},{"$f":"IF(Schema!J142=\"\",\"\",Schema!J142)","v":""},{"$f":"IF(Schema!K142=\"\",\"\",Schema!K142)","v":""},{"$f":"IF(Schema!L142=\"\",\"\",Schema!L142)","v":""},{"$f":"IF(Schema!N142=\"\",\"\",Schema!N142)","v":"O"}]
[{"$f":"Schema!A143&Schema!B143&Schema!C143&Schema!D143","v":"VOLGNUM"},"AO",{"$f":"IF(A124=\"\",\"\",IF(LEN(Schema!A143)=2,1,IF(LEN(Schema!B143)=2,10,IF(LEN(Schema!C143)=2,100,0))))","v":0},10,{"$f":"IF(A124=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C124=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_VOLGNUM"},{"$f":"IF(Schema!I143=\"\",\"\",Schema!I143)","v":""},{"$f":"IF(Schema!J143=\"\",\"\",Schema!J143)","v":""},{"$f":"IF(Schema!K143=\"\",\"\",Schema!K143)","v":""},{"$f":"IF(Schema!L143=\"\",\"\",Schema!L143)","v":""},{"$f":"IF(Schema!N143=\"\",\"\",Schema!N143)","v":"LEEG"}]
[{"$f":"Schema!A144&Schema!B144&Schema!C144&Schema!D144","v":"WACHTTY"},"AO",{"$f":"IF(A125=\"\",\"\",IF(LEN(Schema!A144)=2,1,IF(LEN(Schema!B144)=2,10,IF(LEN(Schema!C144)=2,100,0))))","v":0},10,{"$f":"IF(A125=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C125=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_WACHTTY"},{"$f":"IF(Schema!I144=\"\",\"\",Schema!I144)","v":""},{"$f":"IF(Schema!J144=\"\",\"\",Schema!J144)","v":""},{"$f":"IF(Schema!K144=\"\",\"\",Schema!K144)","v":""},{"$f":"IF(Schema!L144=\"\",\"\",Schema!L144)","v":""},{"$f":"IF(Schema!N144=\"\",\"\",Schema!N144)","v":"O"}]
[{"$f":"Schema!A145&Schema!B145&Schema!C145&Schema!D145","v":"WPREMBP"},"AO",{"$f":"IF(A126=\"\",\"\",IF(LEN(Schema!A145)=2,1,IF(LEN(Schema!B145)=2,10,IF(LEN(Schema!C145)=2,100,0))))","v":0},10,{"$f":"IF(A126=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"AO","",{"$error":"#REF!"},{"$f":"IF(C126=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"AO_WPREMBP"},{"$f":"IF(Schema!I145=\"\",\"\",Schema!I145)","v":""},{"$f":"IF(Schema!J145=\"\",\"\",Schema!J145)","v":""},{"$f":"IF(Schema!K145=\"\",\"\",Schema!K145)","v":""},{"$f":"IF(Schema!L145=\"\",\"\",Schema!L145)","v":""},{"$f":"IF(Schema!N145=\"\",\"\",Schema!N145)","v":"V"}]
[{"$f":"Schema!A146&Schema!B146&Schema!C146&Schema!D146","v":"DX"},"DX",{"$f":"IF(A127=\"\",\"\",IF(LEN(Schema!A146)=2,1,IF(LEN(Schema!B146)=2,10,IF(LEN(Schema!C146)=2,100,0))))","v":100},100,{"$f":"IF(A127=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":200},{"$error":"#REF!"},"AO","DX",{"$error":"#REF!"},{"$f":"IF(C127=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":""},{"$f":"IF(Schema!I146=\"\",\"\",Schema!I146)","v":""},{"$f":"IF(Schema!J146=\"\",\"\",Schema!J146)","v":""},{"$f":"IF(Schema!K146=\"\",\"\",Schema!K146)","v":""},{"$f":"IF(Schema!L146=\"\",\"\",Schema!L146)","v":""},{"$f":"IF(Schema!N146=\"\",\"\",Schema!N146)","v":"O"}]
[{"$f":"Schema!A147&Schema!B147&Schema!C147&Schema!D147","v":"PERCDEK"},"DX",{"$f":"IF(A128=\"\",\"\",IF(LEN(Schema!A147)=2,1,IF(LEN(Schema!B147)=2,10,IF(LEN(Schema!C147)=2,100,0))))","v":0},100,{"$f":"IF(A128=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":100},{"$error":"#REF!"},"AO","DX",{"$error":"#REF!"},{"$f":"IF(C128=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DX_PERCDEK"},{"$f":"IF(Schema!I147=\"\",\"\",Schema!I147)","v":""},{"$f":"IF(Schema!J147=\"\",\"\",Schema!J147)","v":""},{"$f":"IF(Schema!K147=\"\",\"\",Schema!K147)","v":""},{"$f":"IF(Schema!L147=\"\",\"\",Schema!L147)","v":""},{"$f":"IF(Schema!N147=\"\",\"\",Schema!N147)","v":"V"}]
[{"$f":"Schema!A148&Schema!B148&Schema!C148&Schema!D148","v":"PERIODE"},"DX",{"$f":"IF(A129=\"\",\"\",IF(LEN(Schema!A148)=2,1,IF(LEN(Schema!B148)=2,10,IF(LEN(Schema!C148)=2,100,0))))","v":0},100,{"$f":"IF(A129=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":100},{"$error":"#REF!"},"AO","DX",{"$error":"#REF!"},{"$f":"IF(C129=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DX_PERIODE"},{"$f":"IF(Schema!I148=\"\",\"\",Schema!I148)","v":""},{"$f":"IF(Schema!J148=\"\",\"\",Schema!J148)","v":""},{"$f":"IF(Schema!K148=\"\",\"\",Schema!K148)","v":""},{"$f":"IF(Schema!L148=\"\",\"\",Schema!L148)","v":""},{"$f":"IF(Schema!N148=\"\",\"\",Schema!N148)","v":"V"}]
[{"$f":"Schema!A149&Schema!B149&Schema!C149&Schema!D149","v":"TERMIJN"},"DX",{"$f":"IF(A130=\"\",\"\",IF(LEN(Schema!A149)=2,1,IF(LEN(Schema!B149)=2,10,IF(LEN(Schema!C149)=2,100,0))))","v":0},100,{"$f":"IF(A130=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":100},{"$error":"#REF!"},"AO","DX",{"$error":"#REF!"},{"$f":"IF(C130=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DX_TERMIJN"},{"$f":"IF(Schema!I149=\"\",\"\",Schema!I149)","v":""},{"$f":"IF(Schema!J149=\"\",\"\",Schema!J149)","v":""},{"$f":"IF(Schema!K149=\"\",\"\",Schema!K149)","v":""},{"$f":"IF(Schema!L149=\"\",\"\",Schema!L149)","v":""},{"$f":"IF(Schema!N149=\"\",\"\",Schema!N149)","v":"V"}]
[{"$f":"Schema!#REF!&Schema!#REF!&Schema!#REF!&Schema!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(LEN(A131)=2,A131,IF(A131=\"\",\"Leeg\",B130))","v":{"$error":"#REF!"}},{"$f":"IF(A131=\"\",\"\",IF(LEN(Schema!#REF!)=2,1,IF(LEN(Schema!#REF!)=2,10,IF(LEN(Schema!#REF!)=2,100,0))))","v":{"$error":"#REF!"}},{"$f":"IF(C131=0,D130,C131)","v":{"$error":"#REF!"}},{"$f":"IF(A131=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":{"$error":"#REF!"}},{"$f":"IF(A131=\"\",\"\",IF(C131=1,B131,F130))","v":{"$error":"#REF!"}},{"$f":"IF(C131=10,A131,IF(OR(C131=0,C131=100),G130,\"\"))","v":{"$error":"#REF!"}},{"$f":"IF(E131=200,B131,IF(C131=0,H130,\"\"))","v":{"$error":"#REF!"}},{"$f":"IF(C131=\"\",\"\",IF(OR(E131=1,E131=10,E131=100),I130,IF(E131=2,F131,IF(E131=20,F131&\"/\"&G131,IF(E131=200,F131&\"/\"&G131&\"/\"&H131)))))","v":{"$error":"#REF!"}},{"$f":"IF(C131=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"Schema!A150&Schema!B150&Schema!C150&Schema!D150","v":"MP"},"MP",{"$f":"IF(A132=\"\",\"\",IF(LEN(Schema!A150)=2,1,IF(LEN(Schema!B150)=2,10,IF(LEN(Schema!C150)=2,100,0))))","v":100},100,{"$f":"IF(A132=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":200},{"$error":"#REF!"},{"$error":"#REF!"},"MP",{"$error":"#REF!"},{"$f":"IF(C132=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":""},{"$f":"IF(Schema!I150=\"\",\"\",Schema!I150)","v":""},{"$f":"IF(Schema!J150=\"\",\"\",Schema!J150)","v":""},{"$f":"IF(Schema!K150=\"\",\"\",Schema!K150)","v":""},{"$f":"IF(Schema!L150=\"\",\"\",Schema!L150)","v":""},{"$f":"IF(Schema!N150=\"\",\"\",Schema!N150)","v":"O"}]
[{"$f":"Schema!A151&Schema!B151&Schema!C151&Schema!D151","v":"MYAAND"},"MP",{"$f":"IF(A133=\"\",\"\",IF(LEN(Schema!A151)=2,1,IF(LEN(Schema!B151)=2,10,IF(LEN(Schema!C151)=2,100,0))))","v":0},100,{"$f":"IF(A133=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":100},{"$error":"#REF!"},{"$error":"#REF!"},"MP",{"$error":"#REF!"},{"$f":"IF(C133=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"MP_MYAAND"},{"$f":"IF(Schema!I151=\"\",\"\",Schema!I151)","v":""},{"$f":"IF(Schema!J151=\"\",\"\",Schema!J151)","v":""},{"$f":"IF(Schema!K151=\"\",\"\",Schema!K151)","v":""},{"$f":"IF(Schema!L151=\"\",\"\",Schema!L151)","v":""},{"$f":"IF(Schema!N151=\"\",\"\",Schema!N151)","v":"O"}]
[{"$f":"Schema!A152&Schema!B152&Schema!C152&Schema!D152","v":"PLLEAD"},"MP",{"$f":"IF(A134=\"\",\"\",IF(LEN(Schema!A152)=2,1,IF(LEN(Schema!B152)=2,10,IF(LEN(Schema!C152)=2,100,0))))","v":0},100,{"$f":"IF(A134=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":100},{"$error":"#REF!"},{"$error":"#REF!"},"MP",{"$error":"#REF!"},{"$f":"IF(C134=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"MP_PLLEAD"},{"$f":"IF(Schema!I152=\"\",\"\",Schema!I152)","v":""},{"$f":"IF(Schema!J152=\"\",\"\",Schema!J152)","v":""},{"$f":"IF(Schema!K152=\"\",\"\",Schema!K152)","v":""},{"$f":"IF(Schema!L152=\"\",\"\",Schema!L152)","v":""},{"$f":"IF(Schema!N152=\"\",\"\",Schema!N152)","v":"O"}]
[{"$f":"Schema!A153&Schema!B153&Schema!C153&Schema!D153","v":"POOLNUM"},"MP",{"$f":"IF(A135=\"\",\"\",IF(LEN(Schema!A153)=2,1,IF(LEN(Schema!B153)=2,10,IF(LEN(Schema!C153)=2,100,0))))","v":0},100,{"$f":"IF(A135=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":100},{"$error":"#REF!"},{"$error":"#REF!"},"MP",{"$error":"#REF!"},{"$f":"IF(C135=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"MP_POOLNUM"},{"$f":"IF(Schema!I153=\"\",\"\",Schema!I153)","v":""},{"$f":"IF(Schema!J153=\"\",\"\",Schema!J153)","v":""},{"$f":"IF(Schema!K153=\"\",\"\",Schema!K153)","v":""},{"$f":"IF(Schema!L153=\"\",\"\",Schema!L153)","v":""},{"$f":"IF(Schema!N153=\"\",\"\",Schema!N153)","v":"V"}]
[{"$f":"Schema!A154&Schema!B154&Schema!C154&Schema!D154","v":"POOLPRC"},"MP",{"$f":"IF(A136=\"\",\"\",IF(LEN(Schema!A154)=2,1,IF(LEN(Schema!B154)=2,10,IF(LEN(Schema!C154)=2,100,0))))","v":0},100,{"$f":"IF(A136=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":100},{"$error":"#REF!"},{"$error":"#REF!"},"MP",{"$error":"#REF!"},{"$f":"IF(C136=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"MP_POOLPRC"},{"$f":"IF(Schema!I154=\"\",\"\",Schema!I154)","v":""},{"$f":"IF(Schema!J154=\"\",\"\",Schema!J154)","v":""},{"$f":"IF(Schema!K154=\"\",\"\",Schema!K154)","v":""},{"$f":"IF(Schema!L154=\"\",\"\",Schema!L154)","v":""},{"$f":"IF(Schema!N154=\"\",\"\",Schema!N154)","v":"V"}]
[{"$f":"Schema!#REF!&Schema!#REF!&Schema!#REF!&Schema!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(A137=\"\",\"\",IF(LEN(Schema!#REF!)=2,1,IF(LEN(Schema!#REF!)=2,10,IF(LEN(Schema!#REF!)=2,100,0))))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(A137=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(C137=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"Schema!A155&Schema!B155&Schema!C155&Schema!D155","v":"DL"},"DL",{"$f":"IF(A138=\"\",\"\",IF(LEN(Schema!A155)=2,1,IF(LEN(Schema!B155)=2,10,IF(LEN(Schema!C155)=2,100,0))))","v":10},10,{"$f":"IF(A138=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":20},{"$error":"#REF!"},"DL","",{"$error":"#REF!"},{"$f":"IF(C138=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":""},{"$f":"IF(Schema!I155=\"\",\"\",Schema!I155)","v":""},{"$f":"IF(Schema!J155=\"\",\"\",Schema!J155)","v":""},{"$f":"IF(Schema!K155=\"\",\"\",Schema!K155)","v":""},{"$f":"IF(Schema!L155=\"\",\"\",Schema!L155)","v":""},{"$f":"IF(Schema!N155=\"\",\"\",Schema!N155)","v":"O"}]
[{"$f":"Schema!A156&Schema!B156&Schema!C156&Schema!D156","v":"BAFWST"},"DL",{"$f":"IF(A139=\"\",\"\",IF(LEN(Schema!A156)=2,1,IF(LEN(Schema!B156)=2,10,IF(LEN(Schema!C156)=2,100,0))))","v":0},10,{"$f":"IF(A139=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"DL","",{"$error":"#REF!"},{"$f":"IF(C139=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DL_BAFWST"},{"$f":"IF(Schema!I156=\"\",\"\",Schema!I156)","v":""},{"$f":"IF(Schema!J156=\"\",\"\",Schema!J156)","v":""},{"$f":"IF(Schema!K156=\"\",\"\",Schema!K156)","v":""},{"$f":"IF(Schema!L156=\"\",\"\",Schema!L156)","v":""},{"$f":"IF(Schema!N156=\"\",\"\",Schema!N156)","v":"O"}]
[{"$f":"Schema!A157&Schema!B157&Schema!C157&Schema!D157","v":"BJP"},"DL",{"$f":"IF(A140=\"\",\"\",IF(LEN(Schema!A157)=2,1,IF(LEN(Schema!B157)=2,10,IF(LEN(Schema!C157)=2,100,0))))","v":0},10,{"$f":"IF(A140=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"DL","",{"$error":"#REF!"},{"$f":"IF(C140=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DL_BJP"},{"$f":"IF(Schema!I157=\"\",\"\",Schema!I157)","v":""},{"$f":"IF(Schema!J157=\"\",\"\",Schema!J157)","v":""},{"$f":"IF(Schema!K157=\"\",\"\",Schema!K157)","v":""},{"$f":"IF(Schema!L157=\"\",\"\",Schema!L157)","v":""},{"$f":"IF(Schema!N157=\"\",\"\",Schema!N157)","v":"O"}]
[{"$f":"Schema!A158&Schema!B158&Schema!C158&Schema!D158","v":"BTP"},"DL",{"$f":"IF(A141=\"\",\"\",IF(LEN(Schema!A158)=2,1,IF(LEN(Schema!B158)=2,10,IF(LEN(Schema!C158)=2,100,0))))","v":0},10,{"$f":"IF(A141=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"DL","",{"$error":"#REF!"},{"$f":"IF(C141=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DL_BTP"},{"$f":"IF(Schema!I158=\"\",\"\",Schema!I158)","v":""},{"$f":"IF(Schema!J158=\"\",\"\",Schema!J158)","v":""},{"$f":"IF(Schema!K158=\"\",\"\",Schema!K158)","v":""},{"$f":"IF(Schema!L158=\"\",\"\",Schema!L158)","v":""},{"$f":"IF(Schema!N158=\"\",\"\",Schema!N158)","v":"O"}]
[{"$f":"Schema!A159&Schema!B159&Schema!C159&Schema!D159","v":"CODE"},"DL",{"$f":"IF(A142=\"\",\"\",IF(LEN(Schema!A159)=2,1,IF(LEN(Schema!B159)=2,10,IF(LEN(Schema!C159)=2,100,0))))","v":0},10,{"$f":"IF(A142=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"DL","",{"$error":"#REF!"},{"$f":"IF(C142=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DL_CODE"},{"$f":"IF(Schema!I159=\"\",\"\",Schema!I159)","v":""},{"$f":"IF(Schema!J159=\"\",\"\",Schema!J159)","v":""},{"$f":"IF(Schema!K159=\"\",\"\",Schema!K159)","v":""},{"$f":"IF(Schema!L159=\"\",\"\",Schema!L159)","v":""},{"$f":"IF(Schema!N159=\"\",\"\",Schema!N159)","v":"V"}]
[{"$f":"Schema!A160&Schema!B160&Schema!C160&Schema!D160","v":"ENDLFTD"},"DL",{"$f":"IF(A143=\"\",\"\",IF(LEN(Schema!A160)=2,1,IF(LEN(Schema!B160)=2,10,IF(LEN(Schema!C160)=2,100,0))))","v":0},10,{"$f":"IF(A143=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"DL","",{"$error":"#REF!"},{"$f":"IF(C143=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DL_ENDLFTD"},{"$f":"IF(Schema!I160=\"\",\"\",Schema!I160)","v":""},{"$f":"IF(Schema!J160=\"\",\"\",Schema!J160)","v":""},{"$f":"IF(Schema!K160=\"\",\"\",Schema!K160)","v":""},{"$f":"IF(Schema!L160=\"\",\"\",Schema!L160)","v":""},{"$f":"IF(Schema!N160=\"\",\"\",Schema!N160)","v":"O"}]
[{"$f":"Schema!A161&Schema!B161&Schema!C161&Schema!D161","v":"ERPRCDL"},"DL",{"$f":"IF(A144=\"\",\"\",IF(LEN(Schema!A161)=2,1,IF(LEN(Schema!B161)=2,10,IF(LEN(Schema!C161)=2,100,0))))","v":0},10,{"$f":"IF(A144=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"DL","",{"$error":"#REF!"},{"$f":"IF(C144=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DL_ERPRCDL"},{"$f":"IF(Schema!I161=\"\",\"\",Schema!I161)","v":""},{"$f":"IF(Schema!J161=\"\",\"\",Schema!J161)","v":""},{"$f":"IF(Schema!K161=\"\",\"\",Schema!K161)","v":""},{"$f":"IF(Schema!L161=\"\",\"\",Schema!L161)","v":""},{"$f":"IF(Schema!N161=\"\",\"\",Schema!N161)","v":"O"}]
[{"$f":"Schema!A164&Schema!B164&Schema!C164&Schema!D164","v":"MAXDKEB"},"DL",{"$f":"IF(A145=\"\",\"\",IF(LEN(Schema!A164)=2,1,IF(LEN(Schema!B164)=2,10,IF(LEN(Schema!C164)=2,100,0))))","v":0},10,{"$f":"IF(A145=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"DL","",{"$error":"#REF!"},{"$f":"IF(C145=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DL_MAXDKEB"},{"$f":"IF(Schema!I164=\"\",\"\",Schema!I164)","v":""},{"$f":"IF(Schema!J164=\"\",\"\",Schema!J164)","v":""},{"$f":"IF(Schema!K164=\"\",\"\",Schema!K164)","v":""},{"$f":"IF(Schema!L164=\"\",\"\",Schema!L164)","v":""},{"$f":"IF(Schema!N164=\"\",\"\",Schema!N164)","v":"O"}]
[{"$f":"Schema!A165&Schema!B165&Schema!C165&Schema!D165","v":"MYCODE"},"DL",{"$f":"IF(A146=\"\",\"\",IF(LEN(Schema!A165)=2,1,IF(LEN(Schema!B165)=2,10,IF(LEN(Schema!C165)=2,100,0))))","v":0},10,{"$f":"IF(A146=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"DL","",{"$error":"#REF!"},{"$f":"IF(C146=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DL_MYCODE"},{"$f":"IF(Schema!I165=\"\",\"\",Schema!I165)","v":""},{"$f":"IF(Schema!J165=\"\",\"\",Schema!J165)","v":""},{"$f":"IF(Schema!K165=\"\",\"\",Schema!K165)","v":""},{"$f":"IF(Schema!L165=\"\",\"\",Schema!L165)","v":""},{"$f":"IF(Schema!N165=\"\",\"\",Schema!N165)","v":"O"}]
[{"$f":"Schema!A166&Schema!B166&Schema!C166&Schema!D166","v":"PAFWST"},"DL",{"$f":"IF(A147=\"\",\"\",IF(LEN(Schema!A166)=2,1,IF(LEN(Schema!B166)=2,10,IF(LEN(Schema!C166)=2,100,0))))","v":0},10,{"$f":"IF(A147=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"DL","",{"$error":"#REF!"},{"$f":"IF(C147=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DL_PAFWST"},{"$f":"IF(Schema!I166=\"\",\"\",Schema!I166)","v":""},{"$f":"IF(Schema!J166=\"\",\"\",Schema!J166)","v":""},{"$f":"IF(Schema!K166=\"\",\"\",Schema!K166)","v":""},{"$f":"IF(Schema!L166=\"\",\"\",Schema!L166)","v":""},{"$f":"IF(Schema!N166=\"\",\"\",Schema!N166)","v":"O"}]
[{"$f":"Schema!A167&Schema!B167&Schema!C167&Schema!D167","v":"PRCEB"},"DL",{"$f":"IF(A148=\"\",\"\",IF(LEN(Schema!A167)=2,1,IF(LEN(Schema!B167)=2,10,IF(LEN(Schema!C167)=2,100,0))))","v":0},10,{"$f":"IF(A148=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"DL","",{"$error":"#REF!"},{"$f":"IF(C148=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DL_PRCEB"},{"$f":"IF(Schema!I167=\"\",\"\",Schema!I167)","v":""},{"$f":"IF(Schema!J167=\"\",\"\",Schema!J167)","v":""},{"$f":"IF(Schema!K167=\"\",\"\",Schema!K167)","v":""},{"$f":"IF(Schema!L167=\"\",\"\",Schema!L167)","v":""},{"$f":"IF(Schema!N167=\"\",\"\",Schema!N167)","v":"O"}]
[{"$f":"Schema!A168&Schema!B168&Schema!C168&Schema!D168","v":"PRCTEKC"},"DL",{"$f":"IF(A149=\"\",\"\",IF(LEN(Schema!A168)=2,1,IF(LEN(Schema!B168)=2,10,IF(LEN(Schema!C168)=2,100,0))))","v":0},10,{"$f":"IF(A149=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"DL","",{"$error":"#REF!"},{"$f":"IF(C149=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DL_PRCTEKC"},{"$f":"IF(Schema!I168=\"\",\"\",Schema!I168)","v":""},{"$f":"IF(Schema!J168=\"\",\"\",Schema!J168)","v":""},{"$f":"IF(Schema!K168=\"\",\"\",Schema!K168)","v":""},{"$f":"IF(Schema!L168=\"\",\"\",Schema!L168)","v":""},{"$f":"IF(Schema!N168=\"\",\"\",Schema!N168)","v":"O"}]
[{"$f":"Schema!A169&Schema!B169&Schema!C169&Schema!D169","v":"PRCWKGL"},"DL",{"$f":"IF(A150=\"\",\"\",IF(LEN(Schema!A169)=2,1,IF(LEN(Schema!B169)=2,10,IF(LEN(Schema!C169)=2,100,0))))","v":0},10,{"$f":"IF(A150=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"DL","",{"$error":"#REF!"},{"$f":"IF(C150=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DL_PRCWKGL"},{"$f":"IF(Schema!I169=\"\",\"\",Schema!I169)","v":""},{"$f":"IF(Schema!J169=\"\",\"\",Schema!J169)","v":""},{"$f":"IF(Schema!K169=\"\",\"\",Schema!K169)","v":""},{"$f":"IF(Schema!L169=\"\",\"\",Schema!L169)","v":""},{"$f":"IF(Schema!N169=\"\",\"\",Schema!N169)","v":"O"}]
[{"$f":"Schema!A170&Schema!B170&Schema!C170&Schema!D170","v":"PRMPRCL"},"DL",{"$f":"IF(A151=\"\",\"\",IF(LEN(Schema!A170)=2,1,IF(LEN(Schema!B170)=2,10,IF(LEN(Schema!C170)=2,100,0))))","v":0},10,{"$f":"IF(A151=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"DL","",{"$error":"#REF!"},{"$f":"IF(C151=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DL_PRMPRCL"},{"$f":"IF(Schema!I170=\"\",\"\",Schema!I170)","v":""},{"$f":"IF(Schema!J170=\"\",\"\",Schema!J170)","v":""},{"$f":"IF(Schema!K170=\"\",\"\",Schema!K170)","v":""},{"$f":"IF(Schema!L170=\"\",\"\",Schema!L170)","v":""},{"$f":"IF(Schema!N170=\"\",\"\",Schema!N170)","v":"O"}]
[{"$f":"Schema!A171&Schema!B171&Schema!C171&Schema!D171","v":"RJRCOR"},"DL",{"$f":"IF(A152=\"\",\"\",IF(LEN(Schema!A171)=2,1,IF(LEN(Schema!B171)=2,10,IF(LEN(Schema!C171)=2,100,0))))","v":0},10,{"$f":"IF(A152=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"DL","",{"$error":"#REF!"},{"$f":"IF(C152=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DL_RJRCOR"},{"$f":"IF(Schema!I171=\"\",\"\",Schema!I171)","v":""},{"$f":"IF(Schema!J171=\"\",\"\",Schema!J171)","v":""},{"$f":"IF(Schema!K171=\"\",\"\",Schema!K171)","v":""},{"$f":"IF(Schema!L171=\"\",\"\",Schema!L171)","v":""},{"$f":"IF(Schema!N171=\"\",\"\",Schema!N171)","v":"O"}]
[{"$f":"Schema!A172&Schema!B172&Schema!C172&Schema!D172","v":"TCORBDR"},"DL",{"$f":"IF(A153=\"\",\"\",IF(LEN(Schema!A172)=2,1,IF(LEN(Schema!B172)=2,10,IF(LEN(Schema!C172)=2,100,0))))","v":0},10,{"$f":"IF(A153=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"DL","",{"$error":"#REF!"},{"$f":"IF(C153=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DL_TCORBDR"},{"$f":"IF(Schema!I172=\"\",\"\",Schema!I172)","v":""},{"$f":"IF(Schema!J172=\"\",\"\",Schema!J172)","v":""},{"$f":"IF(Schema!K172=\"\",\"\",Schema!K172)","v":""},{"$f":"IF(Schema!L172=\"\",\"\",Schema!L172)","v":""},{"$f":"IF(Schema!N172=\"\",\"\",Schema!N172)","v":"O"}]
[{"$f":"Schema!A173&Schema!B173&Schema!C173&Schema!D173","v":"TTEKC"},"DL",{"$f":"IF(A154=\"\",\"\",IF(LEN(Schema!A173)=2,1,IF(LEN(Schema!B173)=2,10,IF(LEN(Schema!C173)=2,100,0))))","v":0},10,{"$f":"IF(A154=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"DL","",{"$error":"#REF!"},{"$f":"IF(C154=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DL_TTEKC"},{"$f":"IF(Schema!I173=\"\",\"\",Schema!I173)","v":""},{"$f":"IF(Schema!J173=\"\",\"\",Schema!J173)","v":""},{"$f":"IF(Schema!K173=\"\",\"\",Schema!K173)","v":""},{"$f":"IF(Schema!L173=\"\",\"\",Schema!L173)","v":""},{"$f":"IF(Schema!N173=\"\",\"\",Schema!N173)","v":"O"}]
[{"$f":"Schema!#REF!&Schema!#REF!&Schema!#REF!&Schema!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(A155=\"\",\"\",IF(LEN(Schema!#REF!)=2,1,IF(LEN(Schema!#REF!)=2,10,IF(LEN(Schema!#REF!)=2,100,0))))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(A155=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(C155=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"Schema!A176&Schema!B176&Schema!C176&Schema!D176","v":"VMPPRC"},{"$error":"#REF!"},{"$f":"IF(A156=\"\",\"\",IF(LEN(Schema!A176)=2,1,IF(LEN(Schema!B176)=2,10,IF(LEN(Schema!C176)=2,100,0))))","v":0},{"$error":"#REF!"},{"$f":"IF(A156=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(C156=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":{"$error":"#REF!"}},{"$f":"IF(Schema!I176=\"\",\"\",Schema!I176)","v":""},{"$f":"IF(Schema!J176=\"\",\"\",Schema!J176)","v":""},{"$f":"IF(Schema!K176=\"\",\"\",Schema!K176)","v":""},{"$f":"IF(Schema!L176=\"\",\"\",Schema!L176)","v":""},{"$f":"IF(Schema!N176=\"\",\"\",Schema!N176)","v":"O"}]
[{"$f":"Schema!A177&Schema!B177&Schema!C177&Schema!D177","v":"VMTPP"},{"$error":"#REF!"},{"$f":"IF(A157=\"\",\"\",IF(LEN(Schema!A177)=2,1,IF(LEN(Schema!B177)=2,10,IF(LEN(Schema!C177)=2,100,0))))","v":0},{"$error":"#REF!"},{"$f":"IF(A157=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(C157=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":{"$error":"#REF!"}},{"$f":"IF(Schema!I177=\"\",\"\",Schema!I177)","v":""},{"$f":"IF(Schema!J177=\"\",\"\",Schema!J177)","v":""},{"$f":"IF(Schema!K177=\"\",\"\",Schema!K177)","v":""},{"$f":"IF(Schema!L177=\"\",\"\",Schema!L177)","v":""},{"$f":"IF(Schema!N177=\"\",\"\",Schema!N177)","v":"O"}]
[{"$f":"Schema!A178&Schema!B178&Schema!C178&Schema!D178","v":"VPRCLNS"},{"$error":"#REF!"},{"$f":"IF(A158=\"\",\"\",IF(LEN(Schema!A178)=2,1,IF(LEN(Schema!B178)=2,10,IF(LEN(Schema!C178)=2,100,0))))","v":0},{"$error":"#REF!"},{"$f":"IF(A158=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(C158=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":{"$error":"#REF!"}},{"$f":"IF(Schema!I178=\"\",\"\",Schema!I178)","v":""},{"$f":"IF(Schema!J178=\"\",\"\",Schema!J178)","v":""},{"$f":"IF(Schema!K178=\"\",\"\",Schema!K178)","v":""},{"$f":"IF(Schema!L178=\"\",\"\",Schema!L178)","v":""},{"$f":"IF(Schema!N178=\"\",\"\",Schema!N178)","v":"O"}]
[{"$f":"Schema!A179&Schema!B179&Schema!C179&Schema!D179","v":"WACHTTY"},{"$error":"#REF!"},{"$f":"IF(A159=\"\",\"\",IF(LEN(Schema!A179)=2,1,IF(LEN(Schema!B179)=2,10,IF(LEN(Schema!C179)=2,100,0))))","v":0},{"$error":"#REF!"},{"$f":"IF(A159=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(C159=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":{"$error":"#REF!"}},{"$f":"IF(Schema!I179=\"\",\"\",Schema!I179)","v":""},{"$f":"IF(Schema!J179=\"\",\"\",Schema!J179)","v":""},{"$f":"IF(Schema!K179=\"\",\"\",Schema!K179)","v":""},{"$f":"IF(Schema!L179=\"\",\"\",Schema!L179)","v":""},{"$f":"IF(Schema!N179=\"\",\"\",Schema!N179)","v":"O"}]
[{"$f":"Schema!A180&Schema!B180&Schema!C180&Schema!D180","v":"WPREMBP"},{"$error":"#REF!"},{"$f":"IF(A160=\"\",\"\",IF(LEN(Schema!A180)=2,1,IF(LEN(Schema!B180)=2,10,IF(LEN(Schema!C180)=2,100,0))))","v":0},{"$error":"#REF!"},{"$f":"IF(A160=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(C160=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":{"$error":"#REF!"}},{"$f":"IF(Schema!I180=\"\",\"\",Schema!I180)","v":""},{"$f":"IF(Schema!J180=\"\",\"\",Schema!J180)","v":""},{"$f":"IF(Schema!K180=\"\",\"\",Schema!K180)","v":""},{"$f":"IF(Schema!L180=\"\",\"\",Schema!L180)","v":""},{"$f":"IF(Schema!N180=\"\",\"\",Schema!N180)","v":"V"}]
[{"$f":"Schema!A181&Schema!B181&Schema!C181&Schema!D181","v":"DX"},"DX",{"$f":"IF(A161=\"\",\"\",IF(LEN(Schema!A181)=2,1,IF(LEN(Schema!B181)=2,10,IF(LEN(Schema!C181)=2,100,0))))","v":100},100,{"$f":"IF(A161=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":200},{"$error":"#REF!"},{"$error":"#REF!"},"DX",{"$error":"#REF!"},{"$f":"IF(C161=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":""},{"$f":"IF(Schema!I181=\"\",\"\",Schema!I181)","v":""},{"$f":"IF(Schema!J181=\"\",\"\",Schema!J181)","v":""},{"$f":"IF(Schema!K181=\"\",\"\",Schema!K181)","v":""},{"$f":"IF(Schema!L181=\"\",\"\",Schema!L181)","v":""},{"$f":"IF(Schema!N181=\"\",\"\",Schema!N181)","v":"O"}]
[{"$f":"Schema!A182&Schema!B182&Schema!C182&Schema!D182","v":"PERCDEK"},"DX",{"$f":"IF(A162=\"\",\"\",IF(LEN(Schema!A182)=2,1,IF(LEN(Schema!B182)=2,10,IF(LEN(Schema!C182)=2,100,0))))","v":0},100,{"$f":"IF(A162=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":100},{"$error":"#REF!"},{"$error":"#REF!"},"DX",{"$error":"#REF!"},{"$f":"IF(C162=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DX_PERCDEK"},{"$f":"IF(Schema!I182=\"\",\"\",Schema!I182)","v":""},{"$f":"IF(Schema!J182=\"\",\"\",Schema!J182)","v":""},{"$f":"IF(Schema!K182=\"\",\"\",Schema!K182)","v":""},{"$f":"IF(Schema!L182=\"\",\"\",Schema!L182)","v":""},{"$f":"IF(Schema!N182=\"\",\"\",Schema!N182)","v":"V"}]
[{"$f":"Schema!A183&Schema!B183&Schema!C183&Schema!D183","v":"PERIODE"},"DX",{"$f":"IF(A163=\"\",\"\",IF(LEN(Schema!A183)=2,1,IF(LEN(Schema!B183)=2,10,IF(LEN(Schema!C183)=2,100,0))))","v":0},100,{"$f":"IF(A163=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":100},{"$error":"#REF!"},{"$error":"#REF!"},"DX",{"$error":"#REF!"},{"$f":"IF(C163=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DX_PERIODE"},{"$f":"IF(Schema!I183=\"\",\"\",Schema!I183)","v":""},{"$f":"IF(Schema!J183=\"\",\"\",Schema!J183)","v":""},{"$f":"IF(Schema!K183=\"\",\"\",Schema!K183)","v":""},{"$f":"IF(Schema!L183=\"\",\"\",Schema!L183)","v":""},{"$f":"IF(Schema!N183=\"\",\"\",Schema!N183)","v":"V"}]
[{"$f":"Schema!A184&Schema!B184&Schema!C184&Schema!D184","v":"TERMIJN"},"DX",{"$f":"IF(A164=\"\",\"\",IF(LEN(Schema!A184)=2,1,IF(LEN(Schema!B184)=2,10,IF(LEN(Schema!C184)=2,100,0))))","v":0},100,{"$f":"IF(A164=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":100},{"$error":"#REF!"},{"$error":"#REF!"},"DX",{"$error":"#REF!"},{"$f":"IF(C164=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"DX_TERMIJN"},{"$f":"IF(Schema!I184=\"\",\"\",Schema!I184)","v":""},{"$f":"IF(Schema!J184=\"\",\"\",Schema!J184)","v":""},{"$f":"IF(Schema!K184=\"\",\"\",Schema!K184)","v":""},{"$f":"IF(Schema!L184=\"\",\"\",Schema!L184)","v":""},{"$f":"IF(Schema!N184=\"\",\"\",Schema!N184)","v":"V"}]
[{"$f":"Schema!#REF!&Schema!#REF!&Schema!#REF!&Schema!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(A165=\"\",\"\",IF(LEN(Schema!#REF!)=2,1,IF(LEN(Schema!#REF!)=2,10,IF(LEN(Schema!#REF!)=2,100,0))))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(A165=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(C165=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"Schema!A185&Schema!B185&Schema!C185&Schema!D185","v":"MP"},"MP",{"$f":"IF(A166=\"\",\"\",IF(LEN(Schema!A185)=2,1,IF(LEN(Schema!B185)=2,10,IF(LEN(Schema!C185)=2,100,0))))","v":100},100,{"$f":"IF(A166=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":200},{"$error":"#REF!"},{"$error":"#REF!"},"MP",{"$error":"#REF!"},{"$f":"IF(C166=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":""},{"$f":"IF(Schema!I185=\"\",\"\",Schema!I185)","v":""},{"$f":"IF(Schema!J185=\"\",\"\",Schema!J185)","v":""},{"$f":"IF(Schema!K185=\"\",\"\",Schema!K185)","v":""},{"$f":"IF(Schema!L185=\"\",\"\",Schema!L185)","v":""},{"$f":"IF(Schema!N185=\"\",\"\",Schema!N185)","v":"O"}]
[{"$f":"Schema!A186&Schema!B186&Schema!C186&Schema!D186","v":"MYAAND"},"MP",{"$f":"IF(A167=\"\",\"\",IF(LEN(Schema!A186)=2,1,IF(LEN(Schema!B186)=2,10,IF(LEN(Schema!C186)=2,100,0))))","v":0},100,{"$f":"IF(A167=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":100},{"$error":"#REF!"},{"$error":"#REF!"},"MP",{"$error":"#REF!"},{"$f":"IF(C167=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"MP_MYAAND"},{"$f":"IF(Schema!I186=\"\",\"\",Schema!I186)","v":""},{"$f":"IF(Schema!J186=\"\",\"\",Schema!J186)","v":""},{"$f":"IF(Schema!K186=\"\",\"\",Schema!K186)","v":""},{"$f":"IF(Schema!L186=\"\",\"\",Schema!L186)","v":""},{"$f":"IF(Schema!N186=\"\",\"\",Schema!N186)","v":"O"}]
[{"$f":"Schema!A187&Schema!B187&Schema!C187&Schema!D187","v":"PLLEAD"},"MP",{"$f":"IF(A168=\"\",\"\",IF(LEN(Schema!A187)=2,1,IF(LEN(Schema!B187)=2,10,IF(LEN(Schema!C187)=2,100,0))))","v":0},100,{"$f":"IF(A168=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":100},{"$error":"#REF!"},{"$error":"#REF!"},"MP",{"$error":"#REF!"},{"$f":"IF(C168=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"MP_PLLEAD"},{"$f":"IF(Schema!I187=\"\",\"\",Schema!I187)","v":""},{"$f":"IF(Schema!J187=\"\",\"\",Schema!J187)","v":""},{"$f":"IF(Schema!K187=\"\",\"\",Schema!K187)","v":""},{"$f":"IF(Schema!L187=\"\",\"\",Schema!L187)","v":""},{"$f":"IF(Schema!N187=\"\",\"\",Schema!N187)","v":"O"}]
[{"$f":"Schema!A188&Schema!B188&Schema!C188&Schema!D188","v":"POOLNUM"},"MP",{"$f":"IF(A169=\"\",\"\",IF(LEN(Schema!A188)=2,1,IF(LEN(Schema!B188)=2,10,IF(LEN(Schema!C188)=2,100,0))))","v":0},100,{"$f":"IF(A169=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":100},{"$error":"#REF!"},{"$error":"#REF!"},"MP",{"$error":"#REF!"},{"$f":"IF(C169=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"MP_POOLNUM"},{"$f":"IF(Schema!I188=\"\",\"\",Schema!I188)","v":""},{"$f":"IF(Schema!J188=\"\",\"\",Schema!J188)","v":""},{"$f":"IF(Schema!K188=\"\",\"\",Schema!K188)","v":""},{"$f":"IF(Schema!L188=\"\",\"\",Schema!L188)","v":""},{"$f":"IF(Schema!N188=\"\",\"\",Schema!N188)","v":"V"}]
[{"$f":"Schema!A189&Schema!B189&Schema!C189&Schema!D189","v":"POOLPRC"},"MP",{"$f":"IF(A170=\"\",\"\",IF(LEN(Schema!A189)=2,1,IF(LEN(Schema!B189)=2,10,IF(LEN(Schema!C189)=2,100,0))))","v":0},100,{"$f":"IF(A170=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":100},{"$error":"#REF!"},{"$error":"#REF!"},"MP",{"$error":"#REF!"},{"$f":"IF(C170=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"MP_POOLPRC"},{"$f":"IF(Schema!I189=\"\",\"\",Schema!I189)","v":""},{"$f":"IF(Schema!J189=\"\",\"\",Schema!J189)","v":""},{"$f":"IF(Schema!K189=\"\",\"\",Schema!K189)","v":""},{"$f":"IF(Schema!L189=\"\",\"\",Schema!L189)","v":""},{"$f":"IF(Schema!N189=\"\",\"\",Schema!N189)","v":"V"}]
[{"$f":"Schema!#REF!&Schema!#REF!&Schema!#REF!&Schema!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(A171=\"\",\"\",IF(LEN(Schema!#REF!)=2,1,IF(LEN(Schema!#REF!)=2,10,IF(LEN(Schema!#REF!)=2,100,0))))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(A171=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(C171=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(Schema!#REF!=\"\",\"\",Schema!#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"Schema!A190&Schema!B190&Schema!C190&Schema!D190","v":"CL"},"CL",{"$f":"IF(A172=\"\",\"\",IF(LEN(Schema!A190)=2,1,IF(LEN(Schema!B190)=2,10,IF(LEN(Schema!C190)=2,100,0))))","v":10},10,{"$f":"IF(A172=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":20},{"$error":"#REF!"},"CL","",{"$error":"#REF!"},{"$f":"IF(C172=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":""},{"$f":"IF(Schema!I190=\"\",\"\",Schema!I190)","v":""},{"$f":"IF(Schema!J190=\"\",\"\",Schema!J190)","v":""},{"$f":"IF(Schema!K190=\"\",\"\",Schema!K190)","v":""},{"$f":"IF(Schema!L190=\"\",\"\",Schema!L190)","v":""},{"$f":"IF(Schema!N190=\"\",\"\",Schema!N190)","v":"LEEG"}]
[{"$f":"Schema!A191&Schema!B191&Schema!C191&Schema!D191","v":"CLAUSNR"},"CL",{"$f":"IF(A173=\"\",\"\",IF(LEN(Schema!A191)=2,1,IF(LEN(Schema!B191)=2,10,IF(LEN(Schema!C191)=2,100,0))))","v":0},10,{"$f":"IF(A173=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"CL","",{"$error":"#REF!"},{"$f":"IF(C173=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"CL_CLAUSNR"},{"$f":"IF(Schema!I191=\"\",\"\",Schema!I191)","v":""},{"$f":"IF(Schema!J191=\"\",\"\",Schema!J191)","v":""},{"$f":"IF(Schema!K191=\"\",\"\",Schema!K191)","v":""},{"$f":"IF(Schema!L191=\"\",\"\",Schema!L191)","v":""},{"$f":"IF(Schema!N191=\"\",\"\",Schema!N191)","v":"LEEG"}]
[{"$f":"Schema!A192&Schema!B192&Schema!C192&Schema!D192","v":"CLAUSOM"},"CL",{"$f":"IF(A174=\"\",\"\",IF(LEN(Schema!A192)=2,1,IF(LEN(Schema!B192)=2,10,IF(LEN(Schema!C192)=2,100,0))))","v":0},10,{"$f":"IF(A174=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"CL","",{"$error":"#REF!"},{"$f":"IF(C174=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"CL_CLAUSOM"},{"$f":"IF(Schema!I192=\"\",\"\",Schema!I192)","v":""},{"$f":"IF(Schema!J192=\"\",\"\",Schema!J192)","v":""},{"$f":"IF(Schema!K192=\"\",\"\",Schema!K192)","v":""},{"$f":"IF(Schema!L192=\"\",\"\",Schema!L192)","v":""},{"$f":"IF(Schema!N192=\"\",\"\",Schema!N192)","v":"LEEG"}]
[{"$f":"Schema!A193&Schema!B193&Schema!C193&Schema!D193","v":"CLAUTXT"},"CL",{"$f":"IF(A175=\"\",\"\",IF(LEN(Schema!A193)=2,1,IF(LEN(Schema!B193)=2,10,IF(LEN(Schema!C193)=2,100,0))))","v":0},10,{"$f":"IF(A175=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"CL","",{"$error":"#REF!"},{"$f":"IF(C175=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"CL_CLAUTXT"},{"$f":"IF(Schema!I193=\"\",\"\",Schema!I193)","v":""},{"$f":"IF(Schema!J193=\"\",\"\",Schema!J193)","v":""},{"$f":"IF(Schema!K193=\"\",\"\",Schema!K193)","v":""},{"$f":"IF(Schema!L193=\"\",\"\",Schema!L193)","v":""},{"$f":"IF(Schema!N193=\"\",\"\",Schema!N193)","v":"LEEG"}]
[{"$f":"Schema!A194&Schema!B194&Schema!C194&Schema!D194","v":"VERSIEC"},"CL",{"$f":"IF(A176=\"\",\"\",IF(LEN(Schema!A194)=2,1,IF(LEN(Schema!B194)=2,10,IF(LEN(Schema!C194)=2,100,0))))","v":0},10,{"$f":"IF(A176=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"CL","",{"$error":"#REF!"},{"$f":"IF(C176=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"CL_VERSIEC"},{"$f":"IF(Schema!I194=\"\",\"\",Schema!I194)","v":""},{"$f":"IF(Schema!J194=\"\",\"\",Schema!J194)","v":""},{"$f":"IF(Schema!K194=\"\",\"\",Schema!K194)","v":""},{"$f":"IF(Schema!L194=\"\",\"\",Schema!L194)","v":""},{"$f":"IF(Schema!N194=\"\",\"\",Schema!N194)","v":"LEEG"}]
[{"$f":"Schema!A195&Schema!B195&Schema!C195&Schema!D195","v":"VOLGNUM"},"CL",{"$f":"IF(A177=\"\",\"\",IF(LEN(Schema!A195)=2,1,IF(LEN(Schema!B195)=2,10,IF(LEN(Schema!C195)=2,100,0))))","v":0},10,{"$f":"IF(A177=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"CL","",{"$error":"#REF!"},{"$f":"IF(C177=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"CL_VOLGNUM"},{"$f":"IF(Schema!I195=\"\",\"\",Schema!I195)","v":""},{"$f":"IF(Schema!J195=\"\",\"\",Schema!J195)","v":""},{"$f":"IF(Schema!K195=\"\",\"\",Schema!K195)","v":""},{"$f":"IF(Schema!L195=\"\",\"\",Schema!L195)","v":""},{"$f":"IF(Schema!N195=\"\",\"\",Schema!N195)","v":"LEEG"}]
[{"$f":"Schema!A196&Schema!B196&Schema!C196&Schema!D196","v":"VRWRKCD"},"CL",{"$f":"IF(A178=\"\",\"\",IF(LEN(Schema!A196)=2,1,IF(LEN(Schema!B196)=2,10,IF(LEN(Schema!C196)=2,100,0))))","v":0},10,{"$f":"IF(A178=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"CL","",{"$error":"#REF!"},{"$f":"IF(C178=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"CL_VRWRKCD"},{"$f":"IF(Schema!I196=\"\",\"\",Schema!I196)","v":""},{"$f":"IF(Schema!J196=\"\",\"\",Schema!J196)","v":""},{"$f":"IF(Schema!K196=\"\",\"\",Schema!K196)","v":""},{"$f":"IF(Schema!L196=\"\",\"\",Schema!L196)","v":""},{"$f":"IF(Schema!N196=\"\",\"\",Schema!N196)","v":"LEEG"}]
[{"$f":"Schema!A197&Schema!B197&Schema!C197&Schema!D197","v":"VW"},"VW",{"$f":"IF(A179=\"\",\"\",IF(LEN(Schema!A197)=2,1,IF(LEN(Schema!B197)=2,10,IF(LEN(Schema!C197)=2,100,0))))","v":10},10,{"$f":"IF(A179=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":20},{"$error":"#REF!"},"VW","",{"$error":"#REF!"},{"$f":"IF(C179=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":""},{"$f":"IF(Schema!I197=\"\",\"\",Schema!I197)","v":""},{"$f":"IF(Schema!J197=\"\",\"\",Schema!J197)","v":""},{"$f":"IF(Schema!K197=\"\",\"\",Schema!K197)","v":""},{"$f":"IF(Schema!L197=\"\",\"\",Schema!L197)","v":""},{"$f":"IF(Schema!N197=\"\",\"\",Schema!N197)","v":"LEEG"}]
[{"$f":"Schema!A198&Schema!B198&Schema!C198&Schema!D198","v":"VOLGNUM"},"VW",{"$f":"IF(A180=\"\",\"\",IF(LEN(Schema!A198)=2,1,IF(LEN(Schema!B198)=2,10,IF(LEN(Schema!C198)=2,100,0))))","v":0},10,{"$f":"IF(A180=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"VW","",{"$error":"#REF!"},{"$f":"IF(C180=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"VW_VOLGNUM"},{"$f":"IF(Schema!I198=\"\",\"\",Schema!I198)","v":""},{"$f":"IF(Schema!J198=\"\",\"\",Schema!J198)","v":""},{"$f":"IF(Schema!K198=\"\",\"\",Schema!K198)","v":""},{"$f":"IF(Schema!L198=\"\",\"\",Schema!L198)","v":""},{"$f":"IF(Schema!N198=\"\",\"\",Schema!N198)","v":"LEEG"}]
[{"$f":"Schema!A199&Schema!B199&Schema!C199&Schema!D199","v":"VRWNR"},"VW",{"$f":"IF(A181=\"\",\"\",IF(LEN(Schema!A199)=2,1,IF(LEN(Schema!B199)=2,10,IF(LEN(Schema!C199)=2,100,0))))","v":0},10,{"$f":"IF(A181=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"VW","",{"$error":"#REF!"},{"$f":"IF(C181=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"VW_VRWNR"},{"$f":"IF(Schema!I199=\"\",\"\",Schema!I199)","v":""},{"$f":"IF(Schema!J199=\"\",\"\",Schema!J199)","v":""},{"$f":"IF(Schema!K199=\"\",\"\",Schema!K199)","v":""},{"$f":"IF(Schema!L199=\"\",\"\",Schema!L199)","v":""},{"$f":"IF(Schema!N199=\"\",\"\",Schema!N199)","v":"LEEG"}]
[{"$f":"Schema!A200&Schema!B200&Schema!C200&Schema!D200","v":"VRWOM"},"VW",{"$f":"IF(A182=\"\",\"\",IF(LEN(Schema!A200)=2,1,IF(LEN(Schema!B200)=2,10,IF(LEN(Schema!C200)=2,100,0))))","v":0},10,{"$f":"IF(A182=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"VW","",{"$error":"#REF!"},{"$f":"IF(C182=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"VW_VRWOM"},{"$f":"IF(Schema!I200=\"\",\"\",Schema!I200)","v":""},{"$f":"IF(Schema!J200=\"\",\"\",Schema!J200)","v":""},{"$f":"IF(Schema!K200=\"\",\"\",Schema!K200)","v":""},{"$f":"IF(Schema!L200=\"\",\"\",Schema!L200)","v":""},{"$f":"IF(Schema!N200=\"\",\"\",Schema!N200)","v":"LEEG"}]
[{"$f":"Schema!A201&Schema!B201&Schema!C201&Schema!D201","v":"VRWRKCD"},"VW",{"$f":"IF(A183=\"\",\"\",IF(LEN(Schema!A201)=2,1,IF(LEN(Schema!B201)=2,10,IF(LEN(Schema!C201)=2,100,0))))","v":0},10,{"$f":"IF(A183=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"VW","",{"$error":"#REF!"},{"$f":"IF(C183=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"VW_VRWRKCD"},{"$f":"IF(Schema!I201=\"\",\"\",Schema!I201)","v":""},{"$f":"IF(Schema!J201=\"\",\"\",Schema!J201)","v":""},{"$f":"IF(Schema!K201=\"\",\"\",Schema!K201)","v":""},{"$f":"IF(Schema!L201=\"\",\"\",Schema!L201)","v":""},{"$f":"IF(Schema!N201=\"\",\"\",Schema!N201)","v":"LEEG"}]
[{"$f":"Schema!A202&Schema!B202&Schema!C202&Schema!D202","v":"VRWVERS"},"VW",{"$f":"IF(A184=\"\",\"\",IF(LEN(Schema!A202)=2,1,IF(LEN(Schema!B202)=2,10,IF(LEN(Schema!C202)=2,100,0))))","v":0},10,{"$f":"IF(A184=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},{"$error":"#REF!"},"VW","",{"$error":"#REF!"},{"$f":"IF(C184=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"VW_VRWVERS"},{"$f":"IF(Schema!I202=\"\",\"\",Schema!I202)","v":""},{"$f":"IF(Schema!J202=\"\",\"\",Schema!J202)","v":""},{"$f":"IF(Schema!K202=\"\",\"\",Schema!K202)","v":""},{"$f":"IF(Schema!L202=\"\",\"\",Schema!L202)","v":""},{"$f":"IF(Schema!N202=\"\",\"\",Schema!N202)","v":"LEEG"}]
[{"$f":"Schema!A203&Schema!B203&Schema!C203&Schema!D203","v":"XG"},"XG",{"$f":"IF(A185=\"\",\"\",IF(LEN(Schema!A203)=2,1,IF(LEN(Schema!B203)=2,10,IF(LEN(Schema!C203)=2,100,0))))","v":1},1,{"$f":"IF(A185=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":2},"XG","","","XG",{"$f":"IF(C185=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":""},{"$f":"IF(Schema!I203=\"\",\"\",Schema!I203)","v":""},{"$f":"IF(Schema!J203=\"\",\"\",Schema!J203)","v":""},{"$f":"IF(Schema!K203=\"\",\"\",Schema!K203)","v":""},{"$f":"IF(Schema!L203=\"\",\"\",Schema!L203)","v":""},{"$f":"IF(Schema!N203=\"\",\"\",Schema!N203)","v":"LEEG"}]
[{"$f":"Schema!A204&Schema!B204&Schema!C204&Schema!D204","v":"STATUS"},"XG",{"$f":"IF(A186=\"\",\"\",IF(LEN(Schema!A204)=2,1,IF(LEN(Schema!B204)=2,10,IF(LEN(Schema!C204)=2,100,0))))","v":0},1,{"$f":"IF(A186=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"XG","","","XG",{"$f":"IF(C186=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"XG_STATUS"},{"$f":"IF(Schema!I204=\"\",\"\",Schema!I204)","v":""},{"$f":"IF(Schema!J204=\"\",\"\",Schema!J204)","v":""},{"$f":"IF(Schema!K204=\"\",\"\",Schema!K204)","v":""},{"$f":"IF(Schema!L204=\"\",\"\",Schema!L204)","v":""},{"$f":"IF(Schema!N204=\"\",\"\",Schema!N204)","v":"LEEG"}]
[{"$f":"Schema!A205&Schema!B205&Schema!C205&Schema!D205","v":"STATUST"},"XG",{"$f":"IF(A187=\"\",\"\",IF(LEN(Schema!A205)=2,1,IF(LEN(Schema!B205)=2,10,IF(LEN(Schema!C205)=2,100,0))))","v":0},1,{"$f":"IF(A187=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"XG","","","XG",{"$f":"IF(C187=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"XG_STATUST"},{"$f":"IF(Schema!I205=\"\",\"\",Schema!I205)","v":""},{"$f":"IF(Schema!J205=\"\",\"\",Schema!J205)","v":""},{"$f":"IF(Schema!K205=\"\",\"\",Schema!K205)","v":""},{"$f":"IF(Schema!L205=\"\",\"\",Schema!L205)","v":""},{"$f":"IF(Schema!N205=\"\",\"\",Schema!N205)","v":"LEEG"}]
[{"$f":"Schema!A206&Schema!B206&Schema!C206&Schema!D206","v":"VRWRKCD"},"XG",{"$f":"IF(A188=\"\",\"\",IF(LEN(Schema!A206)=2,1,IF(LEN(Schema!B206)=2,10,IF(LEN(Schema!C206)=2,100,0))))","v":0},1,{"$f":"IF(A188=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":1},"XG","","","XG",{"$f":"IF(C188=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"XG_VRWRKCD"},{"$f":"IF(Schema!I206=\"\",\"\",Schema!I206)","v":""},{"$f":"IF(Schema!J206=\"\",\"\",Schema!J206)","v":""},{"$f":"IF(Schema!K206=\"\",\"\",Schema!K206)","v":""},{"$f":"IF(Schema!L206=\"\",\"\",Schema!L206)","v":""},{"$f":"IF(Schema!N206=\"\",\"\",Schema!N206)","v":"LEEG"}]
[{"$f":"Schema!A207&Schema!B207&Schema!C207&Schema!D207","v":"XM"},"XM",{"$f":"IF(A189=\"\",\"\",IF(LEN(Schema!A207)=2,1,IF(LEN(Schema!B207)=2,10,IF(LEN(Schema!C207)=2,100,0))))","v":10},10,{"$f":"IF(A189=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":20},"XG","XM","","XG/XM",{"$f":"IF(C189=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":""},{"$f":"IF(Schema!I207=\"\",\"\",Schema!I207)","v":""},{"$f":"IF(Schema!J207=\"\",\"\",Schema!J207)","v":""},{"$f":"IF(Schema!K207=\"\",\"\",Schema!K207)","v":""},{"$f":"IF(Schema!L207=\"\",\"\",Schema!L207)","v":""},{"$f":"IF(Schema!N207=\"\",\"\",Schema!N207)","v":"LEEG"}]
[{"$f":"Schema!A208&Schema!B208&Schema!C208&Schema!D208","v":"STATTXT"},"XM",{"$f":"IF(A190=\"\",\"\",IF(LEN(Schema!A208)=2,1,IF(LEN(Schema!B208)=2,10,IF(LEN(Schema!C208)=2,100,0))))","v":0},10,{"$f":"IF(A190=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},"XG","XM","","XG/XM",{"$f":"IF(C190=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"XM_STATTXT"},{"$f":"IF(Schema!I208=\"\",\"\",Schema!I208)","v":""},{"$f":"IF(Schema!J208=\"\",\"\",Schema!J208)","v":""},{"$f":"IF(Schema!K208=\"\",\"\",Schema!K208)","v":""},{"$f":"IF(Schema!L208=\"\",\"\",Schema!L208)","v":""},{"$f":"IF(Schema!N208=\"\",\"\",Schema!N208)","v":"LEEG"}]
[{"$f":"Schema!A209&Schema!B209&Schema!C209&Schema!D209","v":"VOLGNUM"},"XM",{"$f":"IF(A191=\"\",\"\",IF(LEN(Schema!A209)=2,1,IF(LEN(Schema!B209)=2,10,IF(LEN(Schema!C209)=2,100,0))))","v":0},10,{"$f":"IF(A191=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},"XG","XM","","XG/XM",{"$f":"IF(C191=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"XM_VOLGNUM"},{"$f":"IF(Schema!I209=\"\",\"\",Schema!I209)","v":""},{"$f":"IF(Schema!J209=\"\",\"\",Schema!J209)","v":""},{"$f":"IF(Schema!K209=\"\",\"\",Schema!K209)","v":""},{"$f":"IF(Schema!L209=\"\",\"\",Schema!L209)","v":""},{"$f":"IF(Schema!N209=\"\",\"\",Schema!N209)","v":"LEEG"}]
[{"$f":"Schema!A210&Schema!B210&Schema!C210&Schema!D210","v":"VRWRKCD"},"XM",{"$f":"IF(A192=\"\",\"\",IF(LEN(Schema!A210)=2,1,IF(LEN(Schema!B210)=2,10,IF(LEN(Schema!C210)=2,100,0))))","v":0},10,{"$f":"IF(A192=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},"XG","XM","","XG/XM",{"$f":"IF(C192=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"XM_VRWRKCD"},{"$f":"IF(Schema!I210=\"\",\"\",Schema!I210)","v":""},{"$f":"IF(Schema!J210=\"\",\"\",Schema!J210)","v":""},{"$f":"IF(Schema!K210=\"\",\"\",Schema!K210)","v":""},{"$f":"IF(Schema!L210=\"\",\"\",Schema!L210)","v":""},{"$f":"IF(Schema!N210=\"\",\"\",Schema!N210)","v":"LEEG"}]
[{"$f":"Schema!A211&Schema!B211&Schema!C211&Schema!D211","v":"XPATH"},"XM",{"$f":"IF(A193=\"\",\"\",IF(LEN(Schema!A211)=2,1,IF(LEN(Schema!B211)=2,10,IF(LEN(Schema!C211)=2,100,0))))","v":0},10,{"$f":"IF(A193=\"\",\"\",SUM(Tabel2[[#This Row],[I1]:[I2]]))","v":10},"XG","XM","","XG/XM",{"$f":"IF(C193=\"\",\"\",IF(LEN(Tabel2[[#This Row],[Entiteit of attribuut]])=2,\"\",Tabel2[[#This Row],[Entiteit]]&\"_\"&Tabel2[[#This Row],[Entiteit of attribuut]]))","v":"XM_XPATH"},{"$f":"IF(Schema!I211=\"\",\"\",Schema!I211)","v":""},{"$f":"IF(Schema!J211=\"\",\"\",Schema!J211)","v":""},{"$f":"IF(Schema!K211=\"\",\"\",Schema!K211)","v":""},{"$f":"IF(Schema!L211=\"\",\"\",Schema!L211)","v":""},{"$f":"IF(Schema!N211=\"\",\"\",Schema!N211)","v":"LEEG"}]

{"sheet":"Functielijst","index":6,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Kolom1"]
["Functielijst"]
["premieBerekening_aanroep"]
["premieBerekening_resultaat"]
["Acceptatie_aanroep"]
["Acceptatie_resultaat"]
["kunnenAanleveren"]