{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Identificatie","Opcentiemen","Groepen","Triggers","Lijsten_Aard","Lijsten_Perceel","Werkdata","Testsheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"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":"Identificatie","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[7,4,8,4],[10,4,11,4]]}
[]
[null,"Naam van de indienende gemeente:",null,null,"Officiele naam van de gemeente"]
[]
[null,"Opcentiemen voor aanslagjaar:",null,null,"Jaartal van het aanslagjaar waarvoor de gegevens bedoeld zijn"]
[]
[null,"Versiebeheer"]
[null,"Versienummer:",null,null,"Geheel getal waarbij een grotere waarde wijst op een latere versie"]
[null,"of datum doorsturen naar Vlabel:",null,null,"Datum waarop de versie is doorgestuurd. Hierbij is de assumptie dat er maar één versie per dag wordt doorgestuurd."]
[]
[]
[null,"Voorstel of finale versie:",null,"Voorstel","Geef hier aan of deze versie een voorstel voor advies is dan wel de finale versie die is goedgekeurd bij de gemeente."]

{"sheet":"Opcentiemen","index":1,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Naam","Waarde aanslagjaar","Toelichting"]
["Starters",0,"Beslissing gemeenteraad 15 jan 2019"]
["Voetafdruk",1500,"Beslissing gemeenteraad 15 jan 2019"]
["Groenzone",1200,"Beslissing gemeenteraad 22 jan 2019"]
["Gewoon",900,"Beslissing gemeenteraad 22 jan 2019"]

{"sheet":"Groepen","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Naam","Condities","Opcentiem","Toelichting"]
["Starters","Nieuw_Industrie","Starters","Klaar"]
["Villas","Villas","Groenzone","Klaar"]
["Industrie","Vervuiler EN NIET Ambacht","Voetafdruk","Klaar"]
["Grote_huizen","Ook_Huis OF (Is_Huis EN Grote_Grond)","Voetafdruk","Klaar"]
["Groenzone","(In_Groen EN NIET Niet_Groen) EN Niet_laag_KI EN Recente_bouw","Groenzone","Klaar"]
["Overige","GEEN","Gewoon","Klaar"]

{"sheet":"Triggers","index":3,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Naam","Perceelgegeven","Test","Waarde1","Waarde2","Toelichting"]
["Nieuw_Industrie","Perceel","IN","#Nieuwkomer",null,"Conform lijst van 31 jan 2019"]
["Villas","Perceel","IN","#Villas",null,"Conform lijst van 4 feb 2019"]
["Ook_Huis","Perceel","IN","#Toch_Huizen",null,"Conform bericht raad van 7 feb 2019"]
["Is_Huis","Aard","IN","#Huizen",null,"Conform bericht raad van 7 feb 2019"]
["Grote_Grond","Oppervlakte",">",1100,null,"Conform bericht raad van 7 feb 2019"]
["Vervuiler","Aard","IN","#Vervuilers",null,"Mail technische dienst van 12 feb 2019"]
["Ambacht","Perceel","IN","#Perceel",null,"Mail technische dienst van 12 feb 2019"]
["In_Groen","Perceel","IN","#Groen"]
["Niet_Groen","Perceel","IN","#Niet_Groen"]
["Niet_laag_KI","Belastbaar_KI","≥",50]
["Recente_bouw","Bouwjaar",">",2010]
["Laag_KI","Belastbaar_KI","<",50]

{"sheet":"Lijsten_Aard","index":4,"n_rows":259,"n_cols":11,"rows_kept":259,"cut":false,"hidden":false,"merged":[]}
["Perceelaard","Huizen","Vervuilers","Aard2","Aard3","Aard4","Aard5","Aard6","Aard7","Aard8","Aard9"]
["AANSPOELING"]
["AARDEW.FABRIEK",null,"J"]
["ADMIN.GEBOUW"]
["AFDAK"]
["AFVALVERWERKING",null,"J"]
["ALG.GEM.DELEN GEB"]
["ALG.GEM.DELEN ONG"]
["ALG.GEM.DELEN. (BAT)"]
["APPARTEMENT #"]
["ANDERE GEBOUWD"]
["ANDERE ONGEBWD"]
["ANDERE ONGEBWD"]
["BADINRICHTING"]
["BAKKERIJ"]
["BANK"]
["BASSIN GEWOON"]
["BASSIN M&O"]
["BASSIN NIJV.",null,"J"]
["BEB.OPP.A"]
["BEB.OPP.APP."]
["BEB.OPP.GEWOON"]
["BEB.OPP.NIJVER."]
["BEB.OPP.UITZ."]
["BEDRIJFSCOMPL#"]
["BEDRIJFSCOMPL# (geb)"]
["BERGPLAATS"]
["BESCHER.WERKPL."]
["BEURS"]
["BIBLIOTHEEK"]
["BIOSCOOP"]
["BISDOM"]
["BOOMGAARD HOOG"]
["BOOMGAARD LAAG"]
["BOOMKWEKERIJ"]
["BOS"]
["BOUWGROND"]
["BOUWLAND"]
["BOUWMAT.FABRIEK",null,"J"]
["BROUWERIJ",null,"J"]
["BUILDING"]
["CABINE"]
["CABINE #"]
["CASINO"]
["CEMENTFABRIEK",null,"J"]
["CHEMISCH.FABRIEK",null,"J"]
["COKESFABRIEK",null,"J"]
["CONSTR.WERKPL."]
["CULTUR.CENTRUM"]
["D.PARKING#"]
["DIERENGEBOUW"]
["DIJK"]
["DIV.PRIV.DEEL #"]
["DOK"]
["DRANKFABRIEK",null,"J"]
["DRANKHUIS"]
["DROOGINSTALL."]
["DRUKKERIJ"]
["DUIN"]
["DUIVENTIL"]
["ELEK.MAT.FAB.",null,"J"]
["ELEKTR.CABINE"]
["ELEKTR.CENTRALE"]
["ETALAGE #"]
["FEESTZAAL"]
["GARAGE"]
["GARAGEBOX #"]
["GARAGESTELPL."]
["GARAGEWERKPL."]
["GASCABINE"]
["GASFABRIEK",null,"J"]
["GAZOMETER"]
["GEBOUW ERED."]
["GEBRUIKSART.FAB."]
["GEMEENTEHUIS"]
["GERECHTSHOF"]
["GEZANTSCH.GEB."]
["GLASFABRIEK",null,"J"]
["GOUVER.GEBOUW"]
["GR.VEETEELT"]
["GRACHT"]
["GRAFHEUVEL"]
["GROEVE"]
["GROND"]
["GROOTWARENHUIS"]
["HANDELSHUIS"]
["HANDELSPAND #"]
["HANGAR"]
["HEIDE"]
["HISTOR. GEBOUW"]
["HOEVE"]
["HOOGOVEN",null,"J"]
["HOOILAND"]
["HOTEL"]
["HUIS","J"]
["HUIS#","J"]
["IJSFABRIEK"]
["JEUGDHEEM"]
["KONINKL.PALEIS"]
["KL.VEETEELT"]
["KAAI"]
["KALKOVEN",null,"J"]
["KAMER #"]
["KAMPEERTERREIN"]
["KANAAL"]
["KANTOOR #"]
["KANTOORGEBOUW"]
["KAPEL"]
["KASTEEL"]
["KELDER #"]
["KERK"]
["KERKHOF"]
["KERSTBOMEN"]
["KINDERBEWARING"]
["KIOSK"]
["KLAARPAN"]
["KLEDINGFABRIEK"]
["KLOOSTER"]
["KOELINRICHTING"]
["KOER"]
["KOFFIEFABRIEK",null,"J"]
["KOLENMIJN"]
["KROTWONING","J"]
["KUURINRICHTING"]
["LANDGEBOUW"]
["LAVATORY"]
["LEDERWAR.FAB."]
["LIJKENHUIS"]
["LUCHTHAVEN"]
["M.D.AP.GEB"]
["MAALDERIJ",null,"J"]
["MAGAZIJN"]
["MAT.& OUT. GEB."]
["MAT.& OUT. GEB.  (M&O)"]
["MAT.& OUT. GEB. (bat)"]
["MAT.& OUT. ONG."]
["MEER"]
["MERKSTEEN"]
["METAALNIJV.",null,"J"]
["MEUBELFABRIEK",null,"J"]
["MIJN"]
["MILIT.GEBOUW"]
["MILIT.TERREIN"]
["MOERAS"]
["MONUMENT"]
["MOSKEE"]
["MUSEUM"]
["NIJV.GEBOUW"]
["NIJV.GROND"]
["NOODWONING","J"]
["NT.OVERD.PARK. #"]
["ONDERGR.RUIMTE"]
["ONDERZOEKSCENT."]
["OPP.& G.D."]
["OPSTAL/ERFPACHT"]
["OVERD.PARKING #"]
["OVERDEKTE MARKT"]
["PAARDESTAL"]
["PADDEST.KWEK."]
["PAPIERFABRIEK",null,"J"]
["PARK"]
["PARKEERGEBOUW"]
["PARKING"]
["PASTORIE"]
["PAVILJOEN"]
["PETROL.RAFF.",null,"J"]
["PLAST.FABRIEK",null,"J"]
["PLEIN"]
["POEL"]
["POLITIEGEBOUW"]
["PRIVAT. DELEN"]
["PRIVATIEF DEEL #"]
["PRIVATIEF DEEL#"]
["PUIN"]
["PYLOON"]
["RENBAAN"]
["RESERVE #"]
["RESERVOIR"]
["RESTAURANT"]
["ROOTPUT",null,"J"]
["ROTS"]
["RUBBERFABRIEK",null,"J"]
["RUSTHUIS"]
["SCH. HOOILAND"]
["SCHAAPSWEI"]
["SCHOOLGEBOUW"]
["SCHRIJNWERKERIJ"]
["SEMINARIE"]
["SERRE"]
["SERVICESTATION"]
["SILO"]
["SLACHTERIJ"]
["SLOOT"]
["SMIDSE"]
["SPEC.GEM.DELEN (BAT)"]
["SPEC.GEM.DELEN GEB"]
["SPEC.GEM.DELEN ONG"]
["SPEELG.FABRIEK"]
["SPEELTERREIN"]
["SPEKTAKELZAAL"]
["SPOORWEG"]
["SPORTGEBOUW"]
["SPORTTERREIN"]
["STATION"]
["STEENBAKKERIJ",null,"J"]
["STEENBERG EXP."]
["STEENBERG WGR."]
["STORT.EXP.",null,"J"]
["STORT.WGR.",null,"J"]
["STRAFINRICHTING"]
["STUDIO #"]
["SYNAGOGE"]
["TABAKFABRIEK",null,"J"]
["TELEFOONCEL"]
["TELECOM.GEBOUW"]
["TEMPEL"]
["TEXTIELFABRIEK",null,"J"]
["THEATER"]
["TOONZAAL"]
["TUIN"]
["TURFGROND"]
["UITBATINGSEENH. #"]
["UITKIJK"]
["UNIVERSITEIT"]
["VAKAN.TEHUIS"]
["VAKANTIE VERBL."]
["VEEN"]
["VEEVOE.FABRIEK",null,"J"]
["VERFFABRIEK",null,"J"]
["VERPLEEGINR."]
["VETWEIDE"]
["VIJVER"]
["VISKWEKERIJ",null,"J"]
["VLEESW.FABRIEK"]
["VLIEGVELD"]
["VOEDINGSFABRIEK",null,"J"]
["WACHTHUIS"]
["WAL"]
["WARMOESGR."]
["WASSERIJ"]
["WATERMOLEN"]
["WATERTOREN"]
["WATERWINNING"]
["WEESHUIS"]
["WEG"]
["WEG"]
["WEILAND"]
["WELWATER"]
["WELZIJNSGEBOUW"]
["WERF"]
["WERKPLAATS"]
["WIJMLAND"]
["WIJNGAARD"]
["WINDMOLEN"]
["WOESTE GROND"]
["ZAGERIJ"]
["ZUIVELFABRIEK",null,"J"]
["ZUIVERINGSINST."]
["ZWEMBAD"]

{"sheet":"Lijsten_Perceel","index":5,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Nieuwkomer","Villas","Toch_Huis","Ambacht","Groen","Niet_Groen","Set6","Set7","Set8","Set9"]
["38305_A_0012_B_002_00_P0001","38312_C_0012_B_000_00_P0000","38305_B_0028_C_000_00_P000","38305_B_0104_000_00_P0000","38305_D","38312_D_0010"]
["38305_A_0012_B_003_00_P0000","38312_C_0014_A_000_00_P0000","38305_C_0123_A_000_00_P0000","38305_B_0106_000_00_P0000","38312_E","38312_D_0012_C_000_00_P0000"]
["38305_A_0134_C_000_00_P0000","38312_C_0028_A_000_00_P0000","38312_A_0088_B_002_00_P0000","38305_C_0091_002_00_P0000","38312_D","38305_B_0023_C_000_00_P0000"]
["38312_B_0232","38312_C_0028_C_000_00_P0000",null,"38312_B_0301_002_00_P0000","38305_A_0100","38305_B_0023_ _002_00_P0000"]
["38312_B_0237_A_000_00_P0000",null,null,null,"38305_A_0213"]
["38312_B_0239_C_002_02_P0001",null,null,null,"38305_B_0106"]
["38312_B_1321_1_000_00_P0000",null,null,null,"38305_A_0101_A_000_00_P0000"]
[null,null,null,null,"38305_A_0101_C_000_00_P0000"]

{"sheet":"Werkdata","index":6,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,"Perceelgegevens","Kwaliteit","oper","param",null,null,"EQ_IN","waarde1","waarde2",null,null,"Item","Max","Min",null,null,"Fiscaal statuut"]
[null,"Afdeling","H","EQ_IN","lijst",null,null,"=",1,0,null,null,"Opcentiem",9999,0,null,null,"belastbaar"]
[null,"Afdeling_sectie","H","EQ_IN","lijst",null,null,"≠",1,0,null,null,"Oppervlakte",100000,1,null,null,"vrijgesteld"]
[null,"Afdeling_sectie_grondnr","H","EQ_IN","lijst",null,null,"IN",2,0]
[null,"Totaal_KI","H","CMP","waarde"]
[null,"Gewoon_KI","H","CMP","waarde",null,null,null,null,null,null,null,null,null,null,null,null,"inkomensaard"]
[null,"Industrie_KI","H","CMP","waarde",null,null,"EQ","waarde1","waarde2",null,null,null,null,null,null,null,"gewoon-onbebouwd"]
[null,"MAT_OUT_KI","H","CMP","waarde",null,null,"=",1,0,null,null,null,null,null,null,null,"gewoon-bebouwd"]
[null,"Belastbaar_KI","H","CMP","waarde",null,null,"≠",1,0,null,null,null,null,null,null,null,"industrie-onbebouwd"]
[null,"Aard","M","EQ_IN","lijst",null,null,null,null,null,null,null,null,null,null,null,null,"industrie-bebouwd"]
[null,"Bebouwd","M","LOG","J/N",null,null,null,null,null,null,null,null,null,null,null,null,"Mat&Out-onbebouwd"]
[null,"Oppervlakte","L","CMP","waarde",null,null,"CMP","waarde1","waarde2",null,null,null,null,null,null,null,"Mat&Out-bebouwd"]
[null,"Bouwjaar","L","CMP","waarde",null,null,"=",1,0]
[null,"Eigenaar_type","M","EQ","code",null,null,"≠",1,0]
[null,"Belast_eigenaar_type","M","EQ","code",null,null,"<",1,0,null,null,null,null,null,null,null,"Eigenaar - aard"]
[null,"Perceel","H","EQ_IN","lijst",null,null,">",1,0,null,null,null,null,null,null,null,"Natuurlijk persoon"]
[null,null,null,null,null,null,null,"≤",1,0,null,null,null,null,null,null,null,"Onderneming"]
[null,null,null,null,null,null,null,"≥",1,0,null,null,null,null,null,null,null,"Gemengd"]
[null,null,null,null,null,null,null,"TUSSEN",1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type recht"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Volle eigenaar"]
[null,null,null,null,null,null,null,"LOG","waarde1","waarde2",null,null,null,null,null,null,null,"Vruchtgebruik"]
[null,null,null,null,null,null,null,"WAAR",0,0,null,null,null,null,null,null,null,"Blote eigenaar"]
[null,null,null,null,null,null,null,"ONWAAR",0,0,null,null,null,null,null,null,null,"Bezwaard met opstal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opstal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bezwaard met erfpacht"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Erfpacht"]

{"sheet":"Testsheet","index":7,"n_rows":129,"n_cols":5,"rows_kept":129,"cut":false,"hidden":false,"merged":[[44,1,50,1],[44,2,50,2],[44,3,50,3],[44,4,50,4],[108,0,108,16383],[129,0,129,16383],[52,0,52,16383],[60,0,60,16383],[59,0,59,16383],[67,0,67,16383],[88,0,88,16383]]}
["Basisdata","Starter positief 1","Villas positief 1","Industrie positief 1","Industrie negatief 1"]
["Afdeling",38312,38312,38312]
["Sectie","B","C","E"]
["Grondnummer",232,14,1987]
["Exponentletter","L","A","C"]
["Exponentnummer",0,0,0]
["BIS-nummer",0,0,0]
["Partitienummer",1,0,0]
["Aard","MEUBELFABRIEK","HOTEL","MEUBELFABRIEK"]
["Oppervlakte (m2)",6500,2750,13000]
["Bouwjaar",2016,1987,2011]
["KI-1","verplicht","verplicht","verplicht","verplicht"]
["     niet-index waarde",17255,1875,15500]
["     fiscaal statuut","belastbaar","belastbaar","belastbaar"]
["     aard","industrie-bebouwd","gewoon-bebouwd","industrie-bebouwd"]
["KI-2","optioneel","optioneel","optioneel","optioneel"]
["     niet-index waarde",null,null,35000]
["     fiscaal statuut",null,null,"vrijgesteld"]
["     aard",null,null,"Mat&Out-bebouwd"]
["EIG-1","verplicht","verplicht","verplicht","verplicht"]
["     aard","Onderneming","Natuurlijk persoon","Natuurlijk persoon"]
["     zakelijk recht 1","verplicht","verplicht","verplicht","verplicht"]
["          Type recht","Volle eigenaar","Volle eigenaar","Blote eigenaar"]
["          Aandeel",{"$f":"1/2","v":0.5},0.3,0.35]
["     zakelijk recht 2","optioneel","optioneel","optioneel","optioneel"]
["          Type recht","Opstal","Blote eigenaar"]
["          Aandeel",0.5,0.7]
["EIG-2","optioneel","optioneel","optioneel","optioneel"]
["     aard","Natuurlijk persoon","Onderneming","Onderneming"]
["     zakelijk recht 1","verplicht","verplicht","verplicht","verplicht"]
["          Type recht","Bezwaard met opstal","Vruchtgebruik","Volle eigenaar"]
["          Aandeel",0.5,0.7,0.65]
["     zakelijk recht 2","optioneel","optioneel","optioneel","optioneel"]
["          Type recht",null,null,"Vruchtgebruik"]
["          Aandeel",null,null,0.35]
["EIG-3","optioneel","optioneel","optioneel","optioneel"]
["     aard"]
["     zakelijk recht 1","verplicht","verplicht","verplicht","verplicht"]
["          Type recht"]
["          Aandeel"]
["     zakelijk recht 2","optioneel","optioneel","optioneel","optioneel"]
["          Type recht"]
["          Aandeel"]
[]
["Toelichting","Perceel uit de lijst voor bedrijven die genieten van tijdelijke vrijstelling. Door keuze aard wordt ook getest dat de voorrang op industrie/vervuilers goed werkt. En door oppervlakte wordt detectie grote_gronden getest.","Perceel uit de lijst voor villas die onder de regeling Groenzone vallen. ","perceelaard uit de lijst voor Vervuilers. Er werd ook een sectie genomen uit de Groenzone om te testen dat dit wordt gedetecteerd maar dat Industrie wel prioriteit krijgt op Groenzone."]
[]
[]
[]
[]
[]
[]
["Verwachte Groep","Starters","Starters","Industrie"]
["Hieronder zijn de resultaten opgenomen voor de bepaling van de opcentiemen voor het perceel"]
["Groep",{"$f":"IF(ISBLANK(B$13),\"\",INDIRECT(ADDRESS(MATCH(TRUE,B110:B129,0)+109,1)))","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(C$13),\"\",INDIRECT(ADDRESS(MATCH(TRUE,C110:C129,0)+109,1)))","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(D$13),\"\",INDIRECT(ADDRESS(MATCH(TRUE,D110:D129,0)+109,1)))","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(E$13),\"\",INDIRECT(ADDRESS(MATCH(TRUE,E110:E129,0)+107,1)))","v":""}]
["Opcentiem",{"$f":"IF(ISBLANK(B$13),\"\",VLOOKUP(B54,Groepen!$A:$C,3,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(C$13),\"\",VLOOKUP(C54,Groepen!$A:$C,3,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(D$13),\"\",VLOOKUP(D54,Groepen!$A:$C,3,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(E$13),\"\",VLOOKUP(E54,Groepen!$A:$C,3,FALSE))","v":""}]
["Opcentiem-waarde",{"$f":"IF(ISBLANK(B$13),\"\",VLOOKUP(B55,Opcentiemen!$A:$B,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(C$13),\"\",VLOOKUP(C55,Opcentiemen!$A:$B,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(D$13),\"\",VLOOKUP(D55,Opcentiemen!$A:$B,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(E$13),\"\",VLOOKUP(E55,Opcentiemen!$A:$B,2,FALSE))","v":""}]
[]
[]
[]
["Hieronder volgen de tussenresultaten van de verwerking -- deze zijn informatief en kunnen helpen bij het opsporen van fouten"]
["De eerste tussenresultaten zijn interne omzettingen en zijn daarom bewust moeilijk leesbaar gemaakt."]
["eig1",{"$f":"IF(ISBLANK(B$13),\"\",CONCATENATE(IF(OR(B$23=Werkdata!$R$21,B$23=Werkdata!$R$22,B$23=Werkdata!$R$25,B$23=Werkdata!$R$27,B$26=Werkdata!$R$21,B$26=Werkdata!$R$22,B$26=Werkdata!$R$25,B$26=Werkdata!$R$27),\"B\",\"V\"),IF(B$21=Werkdata!$R$17,\"O\",\"P\")))","v":"BO"},{"$f":"IF(ISBLANK(C$13),\"\",CONCATENATE(IF(OR(C$23=Werkdata!$R$21,C$23=Werkdata!$R$22,C$23=Werkdata!$R$25,C$23=Werkdata!$R$27,C$26=Werkdata!$R$21,C$26=Werkdata!$R$22,C$26=Werkdata!$R$25,C$26=Werkdata!$R$27),\"B\",\"V\"),IF(C$21=Werkdata!$R$17,\"O\",\"P\")))","v":"BP"},{"$f":"IF(ISBLANK(D$13),\"\",CONCATENATE(IF(OR(D$23=Werkdata!$R$21,D$23=Werkdata!$R$22,D$23=Werkdata!$R$25,D$23=Werkdata!$R$27,D$26=Werkdata!$R$21,D$26=Werkdata!$R$22,D$26=Werkdata!$R$25,D$26=Werkdata!$R$27),\"B\",\"V\"),IF(D$21=Werkdata!$R$17,\"O\",\"P\")))","v":"VP"},{"$f":"IF(ISBLANK(E$13),\"\",CONCATENATE(IF(OR(E$23=Werkdata!$R$21,E$23=Werkdata!$R$22,E$23=Werkdata!$R$25,E$23=Werkdata!$R$27,E$26=Werkdata!$R$21,E$26=Werkdata!$R$22,E$26=Werkdata!$R$25,E$26=Werkdata!$R$27),\"B\",\"V\"),IF(E$21=Werkdata!$R$17,\"O\",\"P\")))","v":""}]
["eig2",{"$f":"IF(ISBLANK(B$13),\"\",IF(ISBLANK(B$29),\"\",CONCATENATE(IF(OR(B$31=Werkdata!$R$21,B$31=Werkdata!$R$22,B$31=Werkdata!$R$25,B$31=Werkdata!$R$27,B$34=Werkdata!$R$21,B$34=Werkdata!$R$22,B$34=Werkdata!$R$25,B$34=Werkdata!$R$27),\"B\",\"V\"),IF(B$29=Werkdata!$R$17,\"O\",\"P\"))))","v":"VP"},{"$f":"IF(ISBLANK(C$13),\"\",IF(ISBLANK(C$29),\"\",CONCATENATE(IF(OR(C$31=Werkdata!$R$21,C$31=Werkdata!$R$22,C$31=Werkdata!$R$25,C$31=Werkdata!$R$27,C$34=Werkdata!$R$21,C$34=Werkdata!$R$22,C$34=Werkdata!$R$25,C$34=Werkdata!$R$27),\"B\",\"V\"),IF(C$29=Werkdata!$R$17,\"O\",\"P\"))))","v":"BO"},{"$f":"IF(ISBLANK(D$13),\"\",IF(ISBLANK(D$29),\"\",CONCATENATE(IF(OR(D$31=Werkdata!$R$21,D$31=Werkdata!$R$22,D$31=Werkdata!$R$25,D$31=Werkdata!$R$27,D$34=Werkdata!$R$21,D$34=Werkdata!$R$22,D$34=Werkdata!$R$25,D$34=Werkdata!$R$27),\"B\",\"V\"),IF(D$29=Werkdata!$R$17,\"O\",\"P\"))))","v":"BO"},{"$f":"IF(ISBLANK(E$13),\"\",IF(ISBLANK(E$29),\"\",CONCATENATE(IF(OR(E$31=Werkdata!$R$21,E$31=Werkdata!$R$22,E$31=Werkdata!$R$25,E$31=Werkdata!$R$27,E$34=Werkdata!$R$21,E$34=Werkdata!$R$22,E$34=Werkdata!$R$25,E$34=Werkdata!$R$27),\"B\",\"V\"),IF(E$29=Werkdata!$R$17,\"O\",\"P\"))))","v":""}]
["eig3",{"$f":"IF(ISBLANK(B$13),\"\",IF(ISBLANK(B$37),\"\",CONCATENATE(IF(OR(B$39=Werkdata!$R$21,B$39=Werkdata!$R$22,B$39=Werkdata!$R$25,B$39=Werkdata!$R$27,B$42=Werkdata!$R$21,B$42=Werkdata!$R$22,B$42=Werkdata!$R$25,B$42=Werkdata!$R$27),\"B\",\"V\"),IF(B$37=Werkdata!$R$17,\"O\",\"P\"))))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(ISBLANK(C$37),\"\",CONCATENATE(IF(OR(C$39=Werkdata!$R$21,C$39=Werkdata!$R$22,C$39=Werkdata!$R$25,C$39=Werkdata!$R$27,C$42=Werkdata!$R$21,C$42=Werkdata!$R$22,C$42=Werkdata!$R$25,C$42=Werkdata!$R$27),\"B\",\"V\"),IF(C$37=Werkdata!$R$17,\"O\",\"P\"))))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(ISBLANK(D$37),\"\",CONCATENATE(IF(OR(D$39=Werkdata!$R$21,D$39=Werkdata!$R$22,D$39=Werkdata!$R$25,D$39=Werkdata!$R$27,D$42=Werkdata!$R$21,D$42=Werkdata!$R$22,D$42=Werkdata!$R$25,D$42=Werkdata!$R$27),\"B\",\"V\"),IF(D$37=Werkdata!$R$17,\"O\",\"P\"))))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF(ISBLANK(E$37),\"\",CONCATENATE(IF(OR(E$39=Werkdata!$R$21,E$39=Werkdata!$R$22,E$39=Werkdata!$R$25,E$39=Werkdata!$R$27,E$42=Werkdata!$R$21,E$42=Werkdata!$R$22,E$42=Werkdata!$R$25,E$42=Werkdata!$R$27),\"B\",\"V\"),IF(E$37=Werkdata!$R$17,\"O\",\"P\"))))","v":""}]
["eigenaars",{"$f":"IF(ISBLANK(B$13),\"\",CONCATENATE(RIGHT(B62,1),IF(B$63=\"\",\"\",RIGHT(B$63,1)),,IF(B$64=\"\",\"\",RIGHT(B$64,1))))","v":"OP"},{"$f":"IF(ISBLANK(C$13),\"\",CONCATENATE(RIGHT(C62,1),IF(C$63=\"\",\"\",RIGHT(C$63,1)),,IF(C$64=\"\",\"\",RIGHT(C$64,1))))","v":"PO"},{"$f":"IF(ISBLANK(D$13),\"\",CONCATENATE(RIGHT(D62,1),IF(D$63=\"\",\"\",RIGHT(D$63,1)),,IF(D$64=\"\",\"\",RIGHT(D$64,1))))","v":"PO"},{"$f":"IF(ISBLANK(E$13),\"\",CONCATENATE(RIGHT(E62,1),IF(E$63=\"\",\"\",RIGHT(E$63,1)),,IF(E$64=\"\",\"\",RIGHT(E$64,1))))","v":""}]
["belast_eign",{"$f":"IF(ISBLANK(B$13),\"\",CONCATENATE(IF(LEFT(B62,1)=\"B\",RIGHT(B62,1),\"\"),IF(LEFT(B63,1)=\"V\",\"\",RIGHT(B63,1)),IF(LEFT(B64,1)=\"V\",\"\",RIGHT(B64,1))))","v":"O"},{"$f":"IF(ISBLANK(C$13),\"\",CONCATENATE(IF(LEFT(C62,1)=\"B\",RIGHT(C62,1),\"\"),IF(LEFT(C63,1)=\"V\",\"\",RIGHT(C63,1)),IF(LEFT(C64,1)=\"V\",\"\",RIGHT(C64,1))))","v":"PO"},{"$f":"IF(ISBLANK(D$13),\"\",CONCATENATE(IF(LEFT(D62,1)=\"B\",RIGHT(D62,1),\"\"),IF(LEFT(D63,1)=\"V\",\"\",RIGHT(D63,1)),IF(LEFT(D64,1)=\"V\",\"\",RIGHT(D64,1))))","v":"O"},{"$f":"IF(ISBLANK(E$13),\"\",CONCATENATE(IF(LEFT(E62,1)=\"B\",RIGHT(E62,1),\"\"),IF(LEFT(E63,1)=\"V\",\"\",RIGHT(E63,1)),IF(LEFT(E64,1)=\"V\",\"\",RIGHT(E64,1))))","v":""}]
[]
["Hieronder zijn de kenmerken van het perceel opgenomen die worden gebruikt in de evaluatie van de triggers."]
["Afdeling",{"$f":"IF(ISBLANK(B$13),\"\",IF(ISBLANK(B$2),\"\",B$2))","v":38312},{"$f":"IF(ISBLANK(C$13),\"\",IF(ISBLANK(C$2),\"\",C$2))","v":38312},{"$f":"IF(ISBLANK(D$13),\"\",IF(ISBLANK(D$2),\"\",D$2))","v":38312},{"$f":"IF(ISBLANK(E$13),\"\",IF(ISBLANK(E$2),\"\",E$2))","v":""}]
["Afdeling_sectie",{"$f":"IF(ISBLANK(B$13),\"\",IF(OR(ISBLANK(B$2),ISBLANK(B$3)),\"\",CONCATENATE(B$2,\"_\",B$3)))","v":"38312_B"},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR(ISBLANK(C$2),ISBLANK(C$3)),\"\",CONCATENATE(C$2,\"_\",C$3)))","v":"38312_C"},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR(ISBLANK(D$2),ISBLANK(D$3)),\"\",CONCATENATE(D$2,\"_\",D$3)))","v":"38312_E"},{"$f":"IF(ISBLANK(E$13),\"\",IF(OR(ISBLANK(E$2),ISBLANK(E$3)),\"\",CONCATENATE(E$2,\"_\",E$3)))","v":""}]
["Afdl_sectie_grondnr",{"$f":"IF(ISBLANK(B$13),\"\",IF(OR(B70=\"\",ISBLANK(B$4),B$4<=0),\"\",CONCATENATE(B70,\"_\",TEXT(B$4,\"0000\"))))","v":"38312_B_0232"},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR(C70=\"\",ISBLANK(C$4),C$4<=0),\"\",CONCATENATE(C70,\"_\",TEXT(C$4,\"0000\"))))","v":"38312_C_0014"},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR(D70=\"\",ISBLANK(D$4),D$4<=0),\"\",CONCATENATE(D70,\"_\",TEXT(D$4,\"0000\"))))","v":"38312_E_1987"},{"$f":"IF(ISBLANK(E$13),\"\",IF(OR(E70=\"\",ISBLANK(E$4),E$4<=0),\"\",CONCATENATE(E70,\"_\",TEXT(E$4,\"0000\"))))","v":""}]
["Perceel",{"$f":"IF(ISBLANK(B$13),\"\",IF(B71=\"\",\"\",CONCATENATE(B71,\"_\",B$5,\"_\",TEXT(B$6,\"000\"),\"_\",TEXT(B$7,\"00\"),\"_P\",TEXT(B$8,\"0000\"))))","v":"38312_B_0232_L_000_00_P0001"},{"$f":"IF(ISBLANK(C$13),\"\",IF(C71=\"\",\"\",CONCATENATE(C71,\"_\",C$5,\"_\",TEXT(C$6,\"000\"),\"_\",TEXT(C$7,\"00\"),\"_P\",TEXT(C$8,\"0000\"))))","v":"38312_C_0014_A_000_00_P0000"},{"$f":"IF(ISBLANK(D$13),\"\",IF(D71=\"\",\"\",CONCATENATE(D71,\"_\",D$5,\"_\",TEXT(D$6,\"000\"),\"_\",TEXT(D$7,\"00\"),\"_P\",TEXT(D$8,\"0000\"))))","v":"38312_E_1987_C_000_00_P0000"},{"$f":"IF(ISBLANK(E$13),\"\",IF(E71=\"\",\"\",CONCATENATE(E71,\"_\",E$5,\"_\",TEXT(E$6,\"000\"),\"_\",TEXT(E$7,\"00\"),\"_P\",TEXT(E$8,\"0000\"))))","v":""}]
["Aard",{"$f":"IF(ISBLANK(B$13),\"\",IF(ISBLANK(B$9),\"GROND\",B$9))","v":"MEUBELFABRIEK"},{"$f":"IF(ISBLANK(C$13),\"\",IF(ISBLANK(C$9),\"GROND\",C$9))","v":"HOTEL"},{"$f":"IF(ISBLANK(D$13),\"\",IF(ISBLANK(D$9),\"GROND\",D$9))","v":"MEUBELFABRIEK"},{"$f":"IF(ISBLANK(E$13),\"\",IF(ISBLANK(E$9),\"GROND\",E$9))","v":""}]
["Oppervlakte",{"$f":"IF(ISBLANK(B$13),\"\",B$10)","v":6500},{"$f":"IF(ISBLANK(C$13),\"\",C$10)","v":2750},{"$f":"IF(ISBLANK(D$13),\"\",D$10)","v":13000},{"$f":"IF(ISBLANK(E$13),\"\",E$10)","v":""}]
["Bebouwd",{"$f":"IF(ISBLANK(B$13),\"\",IF(OR(B$15=Werkdata!$R$8,B$15=Werkdata!$R$10,B$15=Werkdata!$R$12,B$19=Werkdata!$R$8,B$19=Werkdata!$R$10,B$19=Werkdata!$R$12),\"J\",\"N\"))","v":"J"},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR(C$15=Werkdata!$R$8,C$15=Werkdata!$R$10,C$15=Werkdata!$R$12,C$19=Werkdata!$R$8,C$19=Werkdata!$R$10,C$19=Werkdata!$R$12),\"J\",\"N\"))","v":"J"},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR(D$15=Werkdata!$R$8,D$15=Werkdata!$R$10,D$15=Werkdata!$R$12,D$19=Werkdata!$R$8,D$19=Werkdata!$R$10,D$19=Werkdata!$R$12),\"J\",\"N\"))","v":"J"},{"$f":"IF(ISBLANK(E$13),\"\",IF(OR(E$15=Werkdata!$R$8,E$15=Werkdata!$R$10,E$15=Werkdata!$R$12,E$19=Werkdata!$R$8,E$19=Werkdata!$R$10,E$19=Werkdata!$R$12),\"J\",\"N\"))","v":""}]
["Totaal_KI",{"$f":"IF(ISBLANK(B$13),\"\",B$13+B$17)","v":17255},{"$f":"IF(ISBLANK(C$13),\"\",C$13+C$17)","v":1875},{"$f":"IF(ISBLANK(D$13),\"\",D$13+D$17)","v":50500},{"$f":"IF(ISBLANK(E$13),\"\",E$13+E$17)","v":""}]
["Belastbaar_KI",{"$f":"IF(ISBLANK(B$13),\"\",IF(B$14=Werkdata!$R$2,B$13,0)+IF(B$18=Werkdata!$R$2,B$17,0))","v":17255},{"$f":"IF(ISBLANK(C$13),\"\",IF(C$14=Werkdata!$R$2,C$13,0)+IF(C$18=Werkdata!$R$2,C$17,0))","v":1875},{"$f":"IF(ISBLANK(D$13),\"\",IF(D$14=Werkdata!$R$2,D$13,0)+IF(D$18=Werkdata!$R$2,D$17,0))","v":15500},{"$f":"IF(ISBLANK(E$13),\"\",IF(E$14=Werkdata!$R$2,E$13,0)+IF(E$18=Werkdata!$R$2,E$17,0))","v":""}]
["Gewoon_KI",{"$f":"IF(ISBLANK(B$13),\"\",IF(OR(B$15=Werkdata!$R$7,B$15=Werkdata!$R$8),B$13,0)+IF(OR(B$19=Werkdata!$R$7,B$19=Werkdata!$R$8),B$17,0))","v":0},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR(C$15=Werkdata!$R$7,C$15=Werkdata!$R$8),C$13,0)+IF(OR(C$19=Werkdata!$R$7,C$19=Werkdata!$R$8),C$17,0))","v":1875},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR(D$15=Werkdata!$R$7,D$15=Werkdata!$R$8),D$13,0)+IF(OR(D$19=Werkdata!$R$7,D$19=Werkdata!$R$8),D$17,0))","v":0},{"$f":"IF(ISBLANK(E$13),\"\",IF(OR(E$15=Werkdata!$R$7,E$15=Werkdata!$R$8),E$13,0)+IF(OR(E$19=Werkdata!$R$7,E$19=Werkdata!$R$8),E$17,0))","v":""}]
["Industrie_KI",{"$f":"IF(ISBLANK(B$13),\"\",IF(OR(B$15=Werkdata!$R$9,B$15=Werkdata!$R$10),B$13,0)+IF(OR(B$19=Werkdata!$R$9,B$19=Werkdata!$R$10),B$17,0))","v":17255},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR(C$15=Werkdata!$R$9,C$15=Werkdata!$R$10),C$13,0)+IF(OR(C$19=Werkdata!$R$9,C$19=Werkdata!$R$10),C$17,0))","v":0},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR(D$15=Werkdata!$R$9,D$15=Werkdata!$R$10),D$13,0)+IF(OR(D$19=Werkdata!$R$9,D$19=Werkdata!$R$10),D$17,0))","v":15500},{"$f":"IF(ISBLANK(E$13),\"\",IF(OR(E$15=Werkdata!$R$9,E$15=Werkdata!$R$10),E$13,0)+IF(OR(E$19=Werkdata!$R$9,E$19=Werkdata!$R$10),E$17,0))","v":""}]
["MAT_OUT_KI",{"$f":"IF(ISBLANK(B$13),\"\",IF(OR(B$15=Werkdata!$R$11,B$15=Werkdata!$R$12),B$13,0)+IF(OR(B$19=Werkdata!$R$11,B$19=Werkdata!$R$12),B$17,0))","v":0},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR(C$15=Werkdata!$R$11,C$15=Werkdata!$R$12),C$13,0)+IF(OR(C$19=Werkdata!$R$11,C$19=Werkdata!$R$12),C$17,0))","v":0},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR(D$15=Werkdata!$R$11,D$15=Werkdata!$R$12),D$13,0)+IF(OR(D$19=Werkdata!$R$11,D$19=Werkdata!$R$12),D$17,0))","v":35000},{"$f":"IF(ISBLANK(E$13),\"\",IF(OR(E$15=Werkdata!$R$11,E$15=Werkdata!$R$12),E$13,0)+IF(OR(E$19=Werkdata!$R$11,E$19=Werkdata!$R$12),E$17,0))","v":""}]
["Eigenaar_type",{"$f":"IF(ISBLANK(B$13),\"\",IF(OR(B65=\"P\",B65=\"PP\",B65=\"PPP\"),\"Natuurlijk persoon\",IF(OR(B65=\"O\",B65=\"OO\",B65=\"OOO\"),\"Onderneming\",\"Gemengd\")))","v":"Gemengd"},"Gemengd","Gemengd",""]
["Belast_eign_type","Onderneming","Gemengd","Onderneming",""]
["Bouwjaar",{"$f":"B11","v":2016},{"$f":"C11","v":1987},{"$f":"D11","v":2011}]
[]
[]
[]
[]
["Parameters -->",2,{"$f":"B88+1","v":3},{"$f":"C88+1","v":4},{"$f":"D88+1","v":5}]
["Hieronder vind je de resultaten van de evaluatie van de triggers. Deze worden gebruikt bij de evaluatie van de groepen."]
[{"$f":"UPPER(Triggers!A$2)","v":"NIEUW_INDUSTRIE"},{"$f":"IF(ISBLANK(B$13),\"\",IF($A90=\"\",\"\",Tested(VLOOKUP(Triggers!$B$2,Testsheet!$69:$87,Testsheet!B$88,FALSE),Triggers!$C$2,Triggers!$D$2,Triggers!$E$2)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(C$13),\"\",IF($A90=\"\",\"\",Tested(VLOOKUP(Triggers!$B$2,Testsheet!$69:$87,Testsheet!C$88,FALSE),Triggers!$C$2,Triggers!$D$2,Triggers!$E$2)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(D$13),\"\",IF($A90=\"\",\"\",Tested(VLOOKUP(Triggers!$B$2,Testsheet!$69:$87,Testsheet!D$88,FALSE),Triggers!$C$2,Triggers!$D$2,Triggers!$E$2)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(E$13),\"\",IF($A90=\"\",\"\",Tested(VLOOKUP(Triggers!$B$2,Testsheet!$69:$87,Testsheet!E$88,FALSE),Triggers!$C$2,Triggers!$D$2,Triggers!$E$2)))","v":""}]
[{"$f":"UPPER(Triggers!A$3)","v":"VILLAS"},{"$f":"IF(ISBLANK(B$13),\"\",IF($A91=\"\",\"\",Tested(VLOOKUP(Triggers!$B$3,Testsheet!$69:$87,Testsheet!B$88,FALSE),Triggers!$C$3,Triggers!$D$3,Triggers!$E$3)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(C$13),\"\",IF($A91=\"\",\"\",Tested(VLOOKUP(Triggers!$B$3,Testsheet!$69:$87,Testsheet!C$88,FALSE),Triggers!$C$3,Triggers!$D$3,Triggers!$E$3)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(D$13),\"\",IF($A91=\"\",\"\",Tested(VLOOKUP(Triggers!$B$3,Testsheet!$69:$87,Testsheet!D$88,FALSE),Triggers!$C$3,Triggers!$D$3,Triggers!$E$3)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(E$13),\"\",IF($A91=\"\",\"\",Tested(VLOOKUP(Triggers!$B$3,Testsheet!$69:$87,Testsheet!E$88,FALSE),Triggers!$C$3,Triggers!$D$3,Triggers!$E$3)))","v":""}]
[{"$f":"UPPER(Triggers!A$4)","v":"OOK_HUIS"},{"$f":"IF(ISBLANK(B$13),\"\",IF($A92=\"\",\"\",Tested(VLOOKUP(Triggers!$B$4,Testsheet!$69:$87,Testsheet!B$88,FALSE),Triggers!$C$4,Triggers!$D$4,Triggers!$E$4)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(C$13),\"\",IF($A92=\"\",\"\",Tested(VLOOKUP(Triggers!$B$4,Testsheet!$69:$87,Testsheet!C$88,FALSE),Triggers!$C$4,Triggers!$D$4,Triggers!$E$4)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(D$13),\"\",IF($A92=\"\",\"\",Tested(VLOOKUP(Triggers!$B$4,Testsheet!$69:$87,Testsheet!D$88,FALSE),Triggers!$C$4,Triggers!$D$4,Triggers!$E$4)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(E$13),\"\",IF($A92=\"\",\"\",Tested(VLOOKUP(Triggers!$B$4,Testsheet!$69:$87,Testsheet!E$88,FALSE),Triggers!$C$4,Triggers!$D$4,Triggers!$E$4)))","v":""}]
[{"$f":"UPPER(Triggers!A$5)","v":"IS_HUIS"},{"$f":"IF(ISBLANK(B$13),\"\",IF($A93=\"\",\"\",Tested(VLOOKUP(Triggers!$B$5,Testsheet!$69:$87,Testsheet!B$88,FALSE),Triggers!$C$5,Triggers!$D$5,Triggers!$E$5)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(C$13),\"\",IF($A93=\"\",\"\",Tested(VLOOKUP(Triggers!$B$5,Testsheet!$69:$87,Testsheet!C$88,FALSE),Triggers!$C$5,Triggers!$D$5,Triggers!$E$5)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(D$13),\"\",IF($A93=\"\",\"\",Tested(VLOOKUP(Triggers!$B$5,Testsheet!$69:$87,Testsheet!D$88,FALSE),Triggers!$C$5,Triggers!$D$5,Triggers!$E$5)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(E$13),\"\",IF($A93=\"\",\"\",Tested(VLOOKUP(Triggers!$B$5,Testsheet!$69:$87,Testsheet!E$88,FALSE),Triggers!$C$5,Triggers!$D$5,Triggers!$E$5)))","v":""}]
[{"$f":"UPPER(Triggers!A$6)","v":"GROTE_GROND"},{"$f":"IF(ISBLANK(B$13),\"\",IF($A94=\"\",\"\",Tested(VLOOKUP(Triggers!$B$6,Testsheet!$69:$87,Testsheet!B$88,FALSE),Triggers!$C$6,Triggers!$D$6,Triggers!$E$6)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(C$13),\"\",IF($A94=\"\",\"\",Tested(VLOOKUP(Triggers!$B$6,Testsheet!$69:$87,Testsheet!C$88,FALSE),Triggers!$C$6,Triggers!$D$6,Triggers!$E$6)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(D$13),\"\",IF($A94=\"\",\"\",Tested(VLOOKUP(Triggers!$B$6,Testsheet!$69:$87,Testsheet!D$88,FALSE),Triggers!$C$6,Triggers!$D$6,Triggers!$E$6)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(E$13),\"\",IF($A94=\"\",\"\",Tested(VLOOKUP(Triggers!$B$6,Testsheet!$69:$87,Testsheet!E$88,FALSE),Triggers!$C$6,Triggers!$D$6,Triggers!$E$6)))","v":""}]
[{"$f":"UPPER(Triggers!A$7)","v":"VERVUILER"},{"$f":"IF(ISBLANK(B$13),\"\",IF($A95=\"\",\"\",Tested(VLOOKUP(Triggers!$B$7,Testsheet!$69:$87,Testsheet!B$88,FALSE),Triggers!$C$7,Triggers!$D$7,Triggers!$E$7)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(C$13),\"\",IF($A95=\"\",\"\",Tested(VLOOKUP(Triggers!$B$7,Testsheet!$69:$87,Testsheet!C$88,FALSE),Triggers!$C$7,Triggers!$D$7,Triggers!$E$7)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(D$13),\"\",IF($A95=\"\",\"\",Tested(VLOOKUP(Triggers!$B$7,Testsheet!$69:$87,Testsheet!D$88,FALSE),Triggers!$C$7,Triggers!$D$7,Triggers!$E$7)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(E$13),\"\",IF($A95=\"\",\"\",Tested(VLOOKUP(Triggers!$B$7,Testsheet!$69:$87,Testsheet!E$88,FALSE),Triggers!$C$7,Triggers!$D$7,Triggers!$E$7)))","v":""}]
[{"$f":"UPPER(Triggers!A$8)","v":"AMBACHT"},{"$f":"IF(ISBLANK(B$13),\"\",IF($A96=\"\",\"\",Tested(VLOOKUP(Triggers!$B$8,Testsheet!$69:$87,Testsheet!B$88,FALSE),Triggers!$C$8,Triggers!$D$8,Triggers!$E$8)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(C$13),\"\",IF($A96=\"\",\"\",Tested(VLOOKUP(Triggers!$B$8,Testsheet!$69:$87,Testsheet!C$88,FALSE),Triggers!$C$8,Triggers!$D$8,Triggers!$E$8)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(D$13),\"\",IF($A96=\"\",\"\",Tested(VLOOKUP(Triggers!$B$8,Testsheet!$69:$87,Testsheet!D$88,FALSE),Triggers!$C$8,Triggers!$D$8,Triggers!$E$8)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(E$13),\"\",IF($A96=\"\",\"\",Tested(VLOOKUP(Triggers!$B$8,Testsheet!$69:$87,Testsheet!E$88,FALSE),Triggers!$C$8,Triggers!$D$8,Triggers!$E$8)))","v":""}]
[{"$f":"UPPER(Triggers!A$9)","v":"IN_GROEN"},{"$f":"IF(ISBLANK(B$13),\"\",IF($A97=\"\",\"\",Tested(VLOOKUP(Triggers!$B$9,Testsheet!$69:$87,Testsheet!B$88,FALSE),Triggers!$C$9,Triggers!$D$9,Triggers!$E$9)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(C$13),\"\",IF($A97=\"\",\"\",Tested(VLOOKUP(Triggers!$B$9,Testsheet!$69:$87,Testsheet!C$88,FALSE),Triggers!$C$9,Triggers!$D$9,Triggers!$E$9)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(D$13),\"\",IF($A97=\"\",\"\",Tested(VLOOKUP(Triggers!$B$9,Testsheet!$69:$87,Testsheet!D$88,FALSE),Triggers!$C$9,Triggers!$D$9,Triggers!$E$9)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(E$13),\"\",IF($A97=\"\",\"\",Tested(VLOOKUP(Triggers!$B$9,Testsheet!$69:$87,Testsheet!E$88,FALSE),Triggers!$C$9,Triggers!$D$9,Triggers!$E$9)))","v":""}]
[{"$f":"UPPER(Triggers!A$10)","v":"NIET_GROEN"},{"$f":"IF(ISBLANK(B$13),\"\",IF($A98=\"\",\"\",Tested(VLOOKUP(Triggers!$B$10,Testsheet!$69:$87,Testsheet!B$88,FALSE),Triggers!$C$10,Triggers!$D$10,Triggers!$E$10)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(C$13),\"\",IF($A98=\"\",\"\",Tested(VLOOKUP(Triggers!$B$10,Testsheet!$69:$87,Testsheet!C$88,FALSE),Triggers!$C$10,Triggers!$D$10,Triggers!$E$10)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(D$13),\"\",IF($A98=\"\",\"\",Tested(VLOOKUP(Triggers!$B$10,Testsheet!$69:$87,Testsheet!D$88,FALSE),Triggers!$C$10,Triggers!$D$10,Triggers!$E$10)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(E$13),\"\",IF($A98=\"\",\"\",Tested(VLOOKUP(Triggers!$B$10,Testsheet!$69:$87,Testsheet!E$88,FALSE),Triggers!$C$10,Triggers!$D$10,Triggers!$E$10)))","v":""}]
[{"$f":"UPPER(Triggers!A$11)","v":"NIET_LAAG_KI"},{"$f":"IF(ISBLANK(B$13),\"\",IF($A99=\"\",\"\",Tested(VLOOKUP(Triggers!$B$11,Testsheet!$69:$87,Testsheet!B$88,FALSE),Triggers!$C$11,Triggers!$D$11,Triggers!$E$11)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(C$13),\"\",IF($A99=\"\",\"\",Tested(VLOOKUP(Triggers!$B$11,Testsheet!$69:$87,Testsheet!C$88,FALSE),Triggers!$C$11,Triggers!$D$11,Triggers!$E$11)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(D$13),\"\",IF($A99=\"\",\"\",Tested(VLOOKUP(Triggers!$B$11,Testsheet!$69:$87,Testsheet!D$88,FALSE),Triggers!$C$11,Triggers!$D$11,Triggers!$E$11)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(E$13),\"\",IF($A99=\"\",\"\",Tested(VLOOKUP(Triggers!$B$11,Testsheet!$69:$87,Testsheet!E$88,FALSE),Triggers!$C$11,Triggers!$D$11,Triggers!$E$11)))","v":""}]
[{"$f":"UPPER(Triggers!A$12)","v":"RECENTE_BOUW"},{"$f":"IF(ISBLANK(B$13),\"\",IF($A100=\"\",\"\",Tested(VLOOKUP(Triggers!$B$12,Testsheet!$69:$87,Testsheet!B$88,FALSE),Triggers!$C$12,Triggers!$D$12,Triggers!$E$12)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(C$13),\"\",IF($A100=\"\",\"\",Tested(VLOOKUP(Triggers!$B$12,Testsheet!$69:$87,Testsheet!C$88,FALSE),Triggers!$C$12,Triggers!$D$12,Triggers!$E$12)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(D$13),\"\",IF($A100=\"\",\"\",Tested(VLOOKUP(Triggers!$B$12,Testsheet!$69:$87,Testsheet!D$88,FALSE),Triggers!$C$12,Triggers!$D$12,Triggers!$E$12)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(E$13),\"\",IF($A100=\"\",\"\",Tested(VLOOKUP(Triggers!$B$12,Testsheet!$69:$87,Testsheet!E$88,FALSE),Triggers!$C$12,Triggers!$D$12,Triggers!$E$12)))","v":""}]
[{"$f":"UPPER(Triggers!A$13)","v":"LAAG_KI"},{"$f":"IF(ISBLANK(B$13),\"\",IF($A101=\"\",\"\",Tested(VLOOKUP(Triggers!$B$13,Testsheet!$69:$87,Testsheet!B$88,FALSE),Triggers!$C$13,Triggers!$D$13,Triggers!$E$13)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(C$13),\"\",IF($A101=\"\",\"\",Tested(VLOOKUP(Triggers!$B$13,Testsheet!$69:$87,Testsheet!C$88,FALSE),Triggers!$C$13,Triggers!$D$13,Triggers!$E$13)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(D$13),\"\",IF($A101=\"\",\"\",Tested(VLOOKUP(Triggers!$B$13,Testsheet!$69:$87,Testsheet!D$88,FALSE),Triggers!$C$13,Triggers!$D$13,Triggers!$E$13)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(E$13),\"\",IF($A101=\"\",\"\",Tested(VLOOKUP(Triggers!$B$13,Testsheet!$69:$87,Testsheet!E$88,FALSE),Triggers!$C$13,Triggers!$D$13,Triggers!$E$13)))","v":""}]
[{"$f":"UPPER(Triggers!A$14)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF($A102=\"\",\"\",Tested(VLOOKUP(Triggers!$B$14,Testsheet!$69:$87,Testsheet!B$88,FALSE),Triggers!$C$14,Triggers!$D$14,Triggers!$E$14)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF($A102=\"\",\"\",Tested(VLOOKUP(Triggers!$B$14,Testsheet!$69:$87,Testsheet!C$88,FALSE),Triggers!$C$14,Triggers!$D$14,Triggers!$E$14)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF($A102=\"\",\"\",Tested(VLOOKUP(Triggers!$B$14,Testsheet!$69:$87,Testsheet!D$88,FALSE),Triggers!$C$14,Triggers!$D$14,Triggers!$E$14)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A102=\"\",\"\",Tested(VLOOKUP(Triggers!$B$14,Testsheet!$69:$87,Testsheet!E$88,FALSE),Triggers!$C$14,Triggers!$D$14,Triggers!$E$14)))","v":""}]
[{"$f":"UPPER(Triggers!A$15)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF($A103=\"\",\"\",Tested(VLOOKUP(Triggers!$B$15,Testsheet!$69:$87,Testsheet!B$88,FALSE),Triggers!$C$15,Triggers!$D$15,Triggers!$E$15)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF($A103=\"\",\"\",Tested(VLOOKUP(Triggers!$B$15,Testsheet!$69:$87,Testsheet!C$88,FALSE),Triggers!$C$15,Triggers!$D$15,Triggers!$E$15)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF($A103=\"\",\"\",Tested(VLOOKUP(Triggers!$B$15,Testsheet!$69:$87,Testsheet!D$88,FALSE),Triggers!$C$15,Triggers!$D$15,Triggers!$E$15)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A103=\"\",\"\",Tested(VLOOKUP(Triggers!$B$15,Testsheet!$69:$87,Testsheet!E$88,FALSE),Triggers!$C$15,Triggers!$D$15,Triggers!$E$15)))","v":""}]
[{"$f":"UPPER(Triggers!A$16)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF($A104=\"\",\"\",Tested(VLOOKUP(Triggers!$B$16,Testsheet!$69:$87,Testsheet!B$88,FALSE),Triggers!$C$16,Triggers!$D$16,Triggers!$E$16)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF($A104=\"\",\"\",Tested(VLOOKUP(Triggers!$B$16,Testsheet!$69:$87,Testsheet!C$88,FALSE),Triggers!$C$16,Triggers!$D$16,Triggers!$E$16)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF($A104=\"\",\"\",Tested(VLOOKUP(Triggers!$B$16,Testsheet!$69:$87,Testsheet!D$88,FALSE),Triggers!$C$16,Triggers!$D$16,Triggers!$E$16)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A104=\"\",\"\",Tested(VLOOKUP(Triggers!$B$16,Testsheet!$69:$87,Testsheet!E$88,FALSE),Triggers!$C$16,Triggers!$D$16,Triggers!$E$16)))","v":""}]
[{"$f":"UPPER(Triggers!A$17)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF($A105=\"\",\"\",Tested(VLOOKUP(Triggers!$B$17,Testsheet!$69:$87,Testsheet!B$88,FALSE),Triggers!$C$17,Triggers!$D$17,Triggers!$E$17)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF($A105=\"\",\"\",Tested(VLOOKUP(Triggers!$B$17,Testsheet!$69:$87,Testsheet!C$88,FALSE),Triggers!$C$17,Triggers!$D$17,Triggers!$E$17)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF($A105=\"\",\"\",Tested(VLOOKUP(Triggers!$B$17,Testsheet!$69:$87,Testsheet!D$88,FALSE),Triggers!$C$17,Triggers!$D$17,Triggers!$E$17)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A105=\"\",\"\",Tested(VLOOKUP(Triggers!$B$17,Testsheet!$69:$87,Testsheet!E$88,FALSE),Triggers!$C$17,Triggers!$D$17,Triggers!$E$17)))","v":""}]
[{"$f":"UPPER(Triggers!A$18)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF($A106=\"\",\"\",Tested(VLOOKUP(Triggers!$B$18,Testsheet!$69:$87,Testsheet!B$88,FALSE),Triggers!$C$18,Triggers!$D$18,Triggers!$E$18)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF($A106=\"\",\"\",Tested(VLOOKUP(Triggers!$B$18,Testsheet!$69:$87,Testsheet!C$88,FALSE),Triggers!$C$18,Triggers!$D$18,Triggers!$E$18)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF($A106=\"\",\"\",Tested(VLOOKUP(Triggers!$B$18,Testsheet!$69:$87,Testsheet!D$88,FALSE),Triggers!$C$18,Triggers!$D$18,Triggers!$E$18)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A106=\"\",\"\",Tested(VLOOKUP(Triggers!$B$18,Testsheet!$69:$87,Testsheet!E$88,FALSE),Triggers!$C$18,Triggers!$D$18,Triggers!$E$18)))","v":""}]
[{"$f":"UPPER(Triggers!A$19)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF($A107=\"\",\"\",Tested(VLOOKUP(Triggers!$B$19,Testsheet!$69:$87,Testsheet!B$88,FALSE),Triggers!$C$19,Triggers!$D$19,Triggers!$E$19)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF($A107=\"\",\"\",Tested(VLOOKUP(Triggers!$B$19,Testsheet!$69:$87,Testsheet!C$88,FALSE),Triggers!$C$19,Triggers!$D$19,Triggers!$E$19)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF($A107=\"\",\"\",Tested(VLOOKUP(Triggers!$B$19,Testsheet!$69:$87,Testsheet!D$88,FALSE),Triggers!$C$19,Triggers!$D$19,Triggers!$E$19)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A107=\"\",\"\",Tested(VLOOKUP(Triggers!$B$19,Testsheet!$69:$87,Testsheet!E$88,FALSE),Triggers!$C$19,Triggers!$D$19,Triggers!$E$19)))","v":""}]
[{"$f":"UPPER(Triggers!A$20)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF($A108=\"\",\"\",Tested(VLOOKUP(Triggers!$B$20,Testsheet!$69:$87,Testsheet!B$88,FALSE),Triggers!$C$20,Triggers!$D$20,Triggers!$E$20)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF($A108=\"\",\"\",Tested(VLOOKUP(Triggers!$B$20,Testsheet!$69:$87,Testsheet!C$88,FALSE),Triggers!$C$20,Triggers!$D$20,Triggers!$E$20)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF($A108=\"\",\"\",Tested(VLOOKUP(Triggers!$B$20,Testsheet!$69:$87,Testsheet!D$88,FALSE),Triggers!$C$20,Triggers!$D$20,Triggers!$E$20)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A108=\"\",\"\",Tested(VLOOKUP(Triggers!$B$20,Testsheet!$69:$87,Testsheet!E$88,FALSE),Triggers!$C$20,Triggers!$D$20,Triggers!$E$20)))","v":""}]
["Hieronder vind je de resultaten van de evaluatie van de groepen. Deze worden gebruikt voor de bepaling van de opcentiemen"]
[{"$f":"IF(Groepen!A$2=\"\",\"\",Groepen!A$2)","v":"Starters"},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A110=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B2,B$88)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A110=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B2,C$88)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A110=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B2,D$88)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(E$13),\"\",IF($A110=\"\",\"\",groeplogic(Groepen!$B$2,E88)))","v":""}]
[{"$f":"IF(Groepen!A$3=\"\",\"\",Groepen!A$3)","v":"Villas"},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A111=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B3,B$88)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A111=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B3,C$88)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A111=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B3,D$88)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(E$13),\"\",IF($A111=\"\",\"\",groeplogic(Groepen!$B$3,E88)))","v":""}]
[{"$f":"IF(Groepen!A$4=\"\",\"\",Groepen!A$4)","v":"Industrie"},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A112=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B4,B$88)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A112=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B4,C$88)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A112=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B4,D$88)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(E$13),\"\",IF($A112=\"\",\"\",groeplogic(Groepen!$B$4,E88)))","v":""}]
[{"$f":"IF(Groepen!A$5=\"\",\"\",Groepen!A$5)","v":"Grote_huizen"},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A113=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B5,B$88)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A113=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B5,C$88)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A113=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B5,D$88)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(E$13),\"\",IF($A113=\"\",\"\",groeplogic(Groepen!$B$5,E88)))","v":""}]
[{"$f":"IF(Groepen!A$6=\"\",\"\",Groepen!A$6)","v":"Groenzone"},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A114=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B6,B$88)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A114=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B6,C$88)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A114=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B6,D$88)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(E$13),\"\",IF($A114=\"\",\"\",groeplogic(Groepen!$B$6,E88)))","v":""}]
[{"$f":"IF(Groepen!A$7=\"\",\"\",Groepen!A$7)","v":"Overige"},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A115=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B7,B$88)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A115=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B7,C$88)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A115=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B7,D$88)))","v":{"$error":"#NAME?"}},{"$f":"IF(ISBLANK(E$13),\"\",IF($A115=\"\",\"\",groeplogic(Groepen!$B$7,E88)))","v":""}]
[{"$f":"IF(Groepen!A$8=\"\",\"\",Groepen!A$8)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A116=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B8,B$88)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A116=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B8,C$88)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A116=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B8,D$88)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A116=\"\",\"\",groeplogic(Groepen!$B$8,E88)))","v":""}]
[{"$f":"IF(Groepen!A$9=\"\",\"\",Groepen!A$9)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A117=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B9,B$88)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A117=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B9,C$88)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A117=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B9,D$88)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A117=\"\",\"\",groeplogic(Groepen!$B$9,E88)))","v":""}]
[{"$f":"IF(Groepen!A$10=\"\",\"\",Groepen!A$10)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A118=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B10,B$88)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A118=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B10,C$88)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A118=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B10,D$88)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A118=\"\",\"\",groeplogic(Groepen!$B$10,E88)))","v":""}]
[{"$f":"IF(Groepen!A$11=\"\",\"\",Groepen!A$11)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A119=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B11,B$88)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A119=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B11,C$88)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A119=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B11,D$88)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A119=\"\",\"\",groeplogic(Groepen!$B$11,E88)))","v":""}]
[{"$f":"IF(Groepen!A$12=\"\",\"\",Groepen!A$12)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A120=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B12,B$88)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A120=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B12,C$88)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A120=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B12,D$88)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A120=\"\",\"\",groeplogic(Groepen!$B$12,E88)))","v":""}]
[{"$f":"IF(Groepen!A$13=\"\",\"\",Groepen!A$13)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A121=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B13,B$88)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A121=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B13,C$88)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A121=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B13,D$88)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A121=\"\",\"\",groeplogic(Groepen!$B$13,E88)))","v":""}]
[{"$f":"IF(Groepen!A$14=\"\",\"\",Groepen!A$14)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A122=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B14,B$88)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A122=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B14,C$88)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A122=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B14,D$88)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A122=\"\",\"\",groeplogic(Groepen!$B$14,E88)))","v":""}]
[{"$f":"IF(Groepen!A$15=\"\",\"\",Groepen!A$15)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A123=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B15,B$88)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A123=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B15,C$88)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A123=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B15,D$88)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A123=\"\",\"\",groeplogic(Groepen!$B$15,E88)))","v":""}]
[{"$f":"IF(Groepen!A$16=\"\",\"\",Groepen!A$16)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A124=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B16,B$88)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A124=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B16,C$88)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A124=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B16,D$88)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A124=\"\",\"\",groeplogic(Groepen!$B$16,E88)))","v":""}]
[{"$f":"IF(Groepen!A$17=\"\",\"\",Groepen!A$17)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A125=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B17,B$88)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A125=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B17,C$88)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A125=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B17,D$88)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A125=\"\",\"\",groeplogic(Groepen!$B$17,E88)))","v":""}]
[{"$f":"IF(Groepen!A$18=\"\",\"\",Groepen!A$18)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A126=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B18,B$88)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A126=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B18,C$88)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A126=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B18,D$88)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A126=\"\",\"\",groeplogic(Groepen!$B$18,E88)))","v":""}]
[{"$f":"IF(Groepen!A$19=\"\",\"\",Groepen!A$19)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A127=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B19,B$88)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A127=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B19,C$88)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A127=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B19,D$88)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A127=\"\",\"\",groeplogic(Groepen!$B$19,E88)))","v":""}]
[{"$f":"IF(Groepen!A$20=\"\",\"\",Groepen!A$20)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A128=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B20,B$88)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A128=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B20,C$88)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A128=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B20,D$88)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A128=\"\",\"\",groeplogic(Groepen!$B$20,E88)))","v":""}]
[{"$f":"IF(Groepen!A$21=\"\",\"\",Groepen!A$21)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A129=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B21,B$88)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A129=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B21,C$88)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A129=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B21,D$88)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A129=\"\",\"\",groeplogic(Groepen!$B$21,E88)))","v":""}]