{"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":14,"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":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Naam","Waarde aanslagjaar","Toelichting"]
["STANDAARD",1000]

{"sheet":"Groepen","index":2,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Naam","Condities","Opcentiem","Toelichting"]
["REST","GEEN","STANDAARD"]

{"sheet":"Triggers","index":3,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Naam","Perceelgegeven","Test","Waarde1","Waarde2","Toelichting"]

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

{"sheet":"Lijsten_Perceel","index":5,"n_rows":1,"n_cols":10,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Set0","Set1","Set2","Set3","Set4","Set5","Set6","Set7","Set8","Set9"]

{"sheet":"Werkdata","index":6,"n_rows":26,"n_cols":18,"rows_kept":26,"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,"Recht_belast_rechtspersoon","H","CMP","waarde",null,null,"≠",1,0]
[null,"Recht_belast_natuurlijkpersoon","H","CMP","waarde",null,null,"<",1,0,null,null,null,null,null,null,null,"Type recht"]
[null,"Perceel","H","EQ_IN","lijst",null,null,">",1,0,null,null,null,null,null,null,null,"Volle eigenaar"]
[null,null,null,null,null,null,null,"≤",1,0,null,null,null,null,null,null,null,"Vruchtgebruik"]
[null,null,null,null,null,null,null,"≥",1,0,null,null,null,null,null,null,null,"Opstal"]
[null,null,null,null,null,null,null,"TUSSEN",1,1,null,null,null,null,null,null,null,"Erfpacht"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blote eigenaar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bezwaard met opstal"]
[null,null,null,null,null,null,null,"LOG","waarde1","waarde2",null,null,null,null,null,null,null,"Bezwaard met erfpacht"]
[null,null,null,null,null,null,null,"WAAR",0,0]
[null,null,null,null,null,null,null,"ONWAAR",0,0,null,null,null,null,null,null,null,"Type aard"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Natuurlijk persoon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Onderneming"]

{"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","Test1","Test2","Test3","Test4"]
["Afdeling"]
["Sectie"]
["Grondnummer"]
["Exponentletter"]
["Exponentnummer"]
["BIS-nummer"]
["Partitienummer"]
["Aard"]
["Oppervlakte (m2)"]
["Bouwjaar"]
["KI-1","verplicht","verplicht","verplicht","verplicht"]
["     niet-index waarde"]
["     fiscaal statuut"]
["     aard"]
["KI-2","optioneel","optioneel","optioneel","optioneel"]
["     niet-index waarde"]
["     fiscaal statuut"]
["     aard"]
["EIG-1","verplicht","verplicht","verplicht","verplicht"]
["     aard"]
["     zakelijk recht 1","verplicht","verplicht","verplicht","verplicht"]
["          Type recht"]
["          Aandeel"]
["     zakelijk recht 2","optioneel","optioneel","optioneel","optioneel"]
["          Type recht"]
["          Aandeel"]
["EIG-2","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"]
["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"]
[]
[]
[]
[]
[]
[]
["Verwachte Groep","REST","REST","REST","REST"]
["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":""},{"$f":"IF(ISBLANK(C$13),\"\",INDIRECT(ADDRESS(MATCH(TRUE,C110:C129,0)+109,1)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",INDIRECT(ADDRESS(MATCH(TRUE,D110:D129,0)+109,1)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",INDIRECT(ADDRESS(MATCH(TRUE,E110:E129,0)+109,1)))","v":""}]
["Opcentiem",{"$f":"IF(ISBLANK(B$13),\"\",VLOOKUP(B54,Groepen!$A:$C,3,FALSE))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",VLOOKUP(C54,Groepen!$A:$C,3,FALSE))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",VLOOKUP(D54,Groepen!$A:$C,3,FALSE))","v":""},{"$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":""},{"$f":"IF(ISBLANK(C$13),\"\",VLOOKUP(C55,Opcentiemen!$A:$B,2,FALSE))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",VLOOKUP(D55,Opcentiemen!$A:$B,2,FALSE))","v":""},{"$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$16,B$23=Werkdata!$R$17,B$23=Werkdata!$R$18,B$23=Werkdata!$R$20,B$26=Werkdata!$R$16,B$26=Werkdata!$R$17,B$26=Werkdata!$R$18,B$26=Werkdata!$R$20),\"B\",\"V\")))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",CONCATENATE(IF(OR(C$23=Werkdata!$R$16,C$23=Werkdata!$R$17,C$23=Werkdata!$R$18,C$23=Werkdata!$R$20,C$26=Werkdata!$R$16,C$26=Werkdata!$R$17,C$26=Werkdata!$R$18,C$26=Werkdata!$R$20),\"B\",\"V\")))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",CONCATENATE(IF(OR(D$23=Werkdata!$R$16,D$23=Werkdata!$R$17,D$23=Werkdata!$R$18,D$23=Werkdata!$R$20,D$26=Werkdata!$R$16,D$26=Werkdata!$R$17,D$26=Werkdata!$R$18,D$26=Werkdata!$R$20),\"B\",\"V\")))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",CONCATENATE(IF(OR(E$23=Werkdata!$R$16,E$23=Werkdata!$R$17,E$23=Werkdata!$R$18,E$23=Werkdata!$R$20,E$26=Werkdata!$R$16,E$26=Werkdata!$R$17,E$26=Werkdata!$R$18,E$26=Werkdata!$R$20),\"B\",\"V\")))","v":""}]
["eig2",{"$f":"IF(ISBLANK(B$13),\"\",IF(ISBLANK(B$29),\"\",CONCATENATE(IF(OR(B$31=Werkdata!$R$16,B$31=Werkdata!$R$17,B$31=Werkdata!$R$18,B$31=Werkdata!$R$20,B$34=Werkdata!$R$16,B$34=Werkdata!$R$17,B$34=Werkdata!$R$18,B$34=Werkdata!$R$20),\"B\",\"V\"))))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(ISBLANK(C$29),\"\",CONCATENATE(IF(OR(C$31=Werkdata!$R$16,C$31=Werkdata!$R$17,C$31=Werkdata!$R$18,C$31=Werkdata!$R$20,C$34=Werkdata!$R$16,C$34=Werkdata!$R$17,C$34=Werkdata!$R$18,C$34=Werkdata!$R$20),\"B\",\"V\"))))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(ISBLANK(D$29),\"\",CONCATENATE(IF(OR(D$31=Werkdata!$R$16,D$31=Werkdata!$R$17,D$31=Werkdata!$R$18,D$31=Werkdata!$R$20,D$34=Werkdata!$R$16,D$34=Werkdata!$R$17,D$34=Werkdata!$R$18,D$34=Werkdata!$R$20),\"B\",\"V\"))))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF(ISBLANK(E$29),\"\",CONCATENATE(IF(OR(E$31=Werkdata!$R$16,E$31=Werkdata!$R$17,E$31=Werkdata!$R$18,E$31=Werkdata!$R$20,E$34=Werkdata!$R$16,E$34=Werkdata!$R$17,E$34=Werkdata!$R$18,E$34=Werkdata!$R$20),\"B\",\"V\"))))","v":""}]
["eig3",{"$f":"IF(ISBLANK(B$13),\"\",IF(ISBLANK(B$37),\"\",CONCATENATE(IF(OR(B$39=Werkdata!$R$16,B$39=Werkdata!$R$17,B$39=Werkdata!$R$18,B$39=Werkdata!$R$20,B$42=Werkdata!$R$16,B$42=Werkdata!$R$17,B$42=Werkdata!$R$18,B$42=Werkdata!$R$20),\"B\",\"V\"))))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(ISBLANK(C$37),\"\",CONCATENATE(IF(OR(C$39=Werkdata!$R$16,C$39=Werkdata!$R$17,C$39=Werkdata!$R$18,C$39=Werkdata!$R$20,C$42=Werkdata!$R$16,C$42=Werkdata!$R$17,C$42=Werkdata!$R$18,C$42=Werkdata!$R$20),\"B\",\"V\"))))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(ISBLANK(D$37),\"\",CONCATENATE(IF(OR(D$39=Werkdata!$R$16,D$39=Werkdata!$R$17,D$39=Werkdata!$R$18,D$39=Werkdata!$R$20,D$42=Werkdata!$R$16,D$42=Werkdata!$R$17,D$42=Werkdata!$R$18,D$42=Werkdata!$R$20),\"B\",\"V\"))))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF(ISBLANK(E$37),\"\",CONCATENATE(IF(OR(E$39=Werkdata!$R$16,E$39=Werkdata!$R$17,E$39=Werkdata!$R$18,E$39=Werkdata!$R$20,E$42=Werkdata!$R$16,E$42=Werkdata!$R$17,E$42=Werkdata!$R$18,E$42=Werkdata!$R$20),\"B\",\"V\"))))","v":""}]
["eigenaars",{"$f":"IF(ISBLANK(B$13),\"\",CONCATENATE(RIGHT(B62,1),IF(B$63=\"\",\"\",\"\"),,IF(B$64=\"\",\"\",\"\")))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",CONCATENATE(RIGHT(C62,1),IF(C$63=\"\",\"\",\"\"),,IF(C$64=\"\",\"\",\"\")))","v":""},"",""]
["belast_eign",{"$f":"IF(ISBLANK(B$13),\"\",CONCATENATE(IF(LEFT(B62,1)=\"B\",\"\",\"\"),IF(LEFT(B63,1)=\"V\",\"\",\"\"),IF(LEFT(B64,1)=\"V\",\"\",\"\")))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",CONCATENATE(IF(LEFT(C62,1)=\"B\",\"\",\"\"),IF(LEFT(C63,1)=\"V\",\"\",\"\"),IF(LEFT(C64,1)=\"V\",\"\",\"\")))","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":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(ISBLANK(C$2),\"\",C$2))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(ISBLANK(D$2),\"\",D$2))","v":""},{"$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":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR(ISBLANK(C$2),ISBLANK(C$3)),\"\",CONCATENATE(C$2,\"_\",C$3)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR(ISBLANK(D$2),ISBLANK(D$3)),\"\",CONCATENATE(D$2,\"_\",D$3)))","v":""},{"$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":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR(C70=\"\",ISBLANK(C$4),C$4<=0),\"\",CONCATENATE(C70,\"_\",TEXT(C$4,\"0000\"))))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR(D70=\"\",ISBLANK(D$4),D$4<=0),\"\",CONCATENATE(D70,\"_\",TEXT(D$4,\"0000\"))))","v":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(ISBLANK(C$9),\"GROND\",C$9))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(ISBLANK(D$9),\"GROND\",D$9))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF(ISBLANK(E$9),\"GROND\",E$9))","v":""}]
["Oppervlakte",{"$f":"IF(ISBLANK(B$13),\"\",B$10)","v":""},{"$f":"IF(ISBLANK(C$13),\"\",C$10)","v":""},{"$f":"IF(ISBLANK(D$13),\"\",D$10)","v":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$f":"IF(ISBLANK(C$13),\"\",C$13+C$17)","v":""},{"$f":"IF(ISBLANK(D$13),\"\",D$13+D$17)","v":""},{"$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":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(C$14=Werkdata!$R$2,C$13,0)+IF(C$18=Werkdata!$R$2,C$17,0))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(D$14=Werkdata!$R$2,D$13,0)+IF(D$18=Werkdata!$R$2,D$17,0))","v":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""}]
["Recht_belast_rechtspersoon",{"$f":"SUM(IF(AND((B21=Werkdata!R26), SUMPRODUCT(--(B23=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!B24 * 100,0),\nIF(AND((B21=Werkdata!R26), SUMPRODUCT(--(B26=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!B27 * 100,0),\nIF(AND((B29=Werkdata!R26), SUMPRODUCT(--(B31=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!B32 * 100,0),\nIF(AND((B29=Werkdata!R26), SUMPRODUCT(--(B34=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!B35 * 100,0),\nIF(AND((B37=Werkdata!R26), SUMPRODUCT(--(B39=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!B40 * 100,0),\nIF(AND((B37=Werkdata!R26), SUMPRODUCT(--(B42=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!B43 * 100,0))","v":0},{"$f":"SUM(IF(AND((C21=Werkdata!R26), SUMPRODUCT(--(C23=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!C24 * 100,0),\nIF(AND((C21=Werkdata!R26), SUMPRODUCT(--(C26=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!C27 * 100,0),\nIF(AND((C29=Werkdata!R26), SUMPRODUCT(--(C31=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!C32 * 100,0),\nIF(AND((C29=Werkdata!R26), SUMPRODUCT(--(C34=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!C35 * 100,0),\nIF(AND((C37=Werkdata!R26), SUMPRODUCT(--(C39=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!C40 * 100,0),\nIF(AND((C37=Werkdata!R26), SUMPRODUCT(--(C42=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!C43 * 100,0))","v":0},{"$f":"SUM(IF(AND((D21=Werkdata!R26), SUMPRODUCT(--(D23=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!D24 * 100,0),\nIF(AND((D21=Werkdata!R26), SUMPRODUCT(--(D26=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!D27 * 100,0),\nIF(AND((D29=Werkdata!R26), SUMPRODUCT(--(D31=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!D32 * 100,0),\nIF(AND((D29=Werkdata!R26), SUMPRODUCT(--(D34=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!D35 * 100,0),\nIF(AND((D37=Werkdata!R26), SUMPRODUCT(--(D39=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!D40 * 100,0),\nIF(AND((D37=Werkdata!R26), SUMPRODUCT(--(D42=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!D43 * 100,0))","v":0},{"$f":"SUM(IF(AND((E21=Werkdata!R26), SUMPRODUCT(--(E23=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!E24 * 100,0),\nIF(AND((E21=Werkdata!R26), SUMPRODUCT(--(E26=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!E27 * 100,0),\nIF(AND((E29=Werkdata!R26), SUMPRODUCT(--(E31=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!E32 * 100,0),\nIF(AND((E29=Werkdata!R26), SUMPRODUCT(--(E34=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!E35 * 100,0),\nIF(AND((E37=Werkdata!R26), SUMPRODUCT(--(E39=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!E40 * 100,0),\nIF(AND((E37=Werkdata!R26), SUMPRODUCT(--(E42=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!E43 * 100,0))","v":0}]
["Recht_belast_natuurlijkpersoon",{"$f":"SUM(IF(AND((B21=Werkdata!R25), SUMPRODUCT(--(B23=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!B24 * 100,0),\nIF(AND((B21=Werkdata!R25), SUMPRODUCT(--(B26=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!B27 * 100,0),\nIF(AND((B29=Werkdata!R25), SUMPRODUCT(--(B31=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!B32 * 100,0),\nIF(AND((B29=Werkdata!R25), SUMPRODUCT(--(B34=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!B35 * 100,0),\nIF(AND((B37=Werkdata!R25), SUMPRODUCT(--(B39=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!B40 * 100,0),\nIF(AND((B37=Werkdata!R25), SUMPRODUCT(--(B42=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!B43 * 100,0))","v":0},{"$f":"SUM(IF(AND((C21=Werkdata!R25), SUMPRODUCT(--(C23=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!C24 * 100,0),\nIF(AND((C21=Werkdata!R25), SUMPRODUCT(--(C26=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!C27 * 100,0),\nIF(AND((C29=Werkdata!R25), SUMPRODUCT(--(C31=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!C32 * 100,0),\nIF(AND((C29=Werkdata!R25), SUMPRODUCT(--(C34=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!C35 * 100,0),\nIF(AND((C37=Werkdata!R25), SUMPRODUCT(--(C39=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!C40 * 100,0),\nIF(AND((C37=Werkdata!R25), SUMPRODUCT(--(C42=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!C43 * 100,0))","v":0},{"$f":"SUM(IF(AND((D21=Werkdata!R25), SUMPRODUCT(--(D23=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!D24 * 100,0),\nIF(AND((D21=Werkdata!R25), SUMPRODUCT(--(D26=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!D27 * 100,0),\nIF(AND((D29=Werkdata!R25), SUMPRODUCT(--(D31=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!D32 * 100,0),\nIF(AND((D29=Werkdata!R25), SUMPRODUCT(--(D34=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!D35 * 100,0),\nIF(AND((D37=Werkdata!R25), SUMPRODUCT(--(D39=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!D40 * 100,0),\nIF(AND((D37=Werkdata!R25), SUMPRODUCT(--(D42=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!D43 * 100,0))","v":0},{"$f":"SUM(IF(AND((E21=Werkdata!R25), SUMPRODUCT(--(E23=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!E24 * 100,0),\nIF(AND((E21=Werkdata!R25), SUMPRODUCT(--(E26=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!E27 * 100,0),\nIF(AND((E29=Werkdata!R25), SUMPRODUCT(--(E31=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!E32 * 100,0),\nIF(AND((E29=Werkdata!R25), SUMPRODUCT(--(E34=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!E35 * 100,0),\nIF(AND((E37=Werkdata!R25), SUMPRODUCT(--(E39=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!E40 * 100,0),\nIF(AND((E37=Werkdata!R25), SUMPRODUCT(--(E42=Werkdata!R16:'Werkdata'!R19)) > 0),Testsheet!E43 * 100,0))","v":0}]
["Bouwjaar",{"$f":"B11","v":0},{"$f":"C11","v":0},{"$f":"D11","v":0},{"$f":"E11","v":0}]
[]
[]
[]
[]
["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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":""},{"$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":"REST"},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A110=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B2,B$88)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A110=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B2,C$88)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A110=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B2,D$88)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF(OR($A110=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B2,E$88)))","v":""}]
[{"$f":"IF(Groepen!A$3=\"\",\"\",Groepen!A$3)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A111=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B3,B$88)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A111=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B3,C$88)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A111=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B3,D$88)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF(OR($A111=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B3,E$88)))","v":""}]
[{"$f":"IF(Groepen!A$4=\"\",\"\",Groepen!A$4)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A112=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B4,B$88)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A112=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B4,C$88)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A112=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B4,D$88)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF(OR($A112=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B4,E$88)))","v":""}]
[{"$f":"IF(Groepen!A$5=\"\",\"\",Groepen!A$5)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A113=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B5,B$88)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A113=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B5,C$88)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A113=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B5,D$88)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A113=\"\",\"\",groeplogic(Groepen!$B$5,E88)))","v":""}]
[{"$f":"IF(Groepen!A$6=\"\",\"\",Groepen!A$6)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A114=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B6,B$88)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A114=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B6,C$88)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A114=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B6,D$88)))","v":""},{"$f":"IF(ISBLANK(E$13),\"\",IF($A114=\"\",\"\",groeplogic(Groepen!$B$6,E88)))","v":""}]
[{"$f":"IF(Groepen!A$7=\"\",\"\",Groepen!A$7)","v":""},{"$f":"IF(ISBLANK(B$13),\"\",IF(OR($A115=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B7,B$88)))","v":""},{"$f":"IF(ISBLANK(C$13),\"\",IF(OR($A115=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B7,C$88)))","v":""},{"$f":"IF(ISBLANK(D$13),\"\",IF(OR($A115=\"\",COUNTA(TestTriggers)=0),\"\",groeplogic(Groepen!$B7,D$88)))","v":""},{"$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":""}]