{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["Aanwezigheden","Verslag","Bezoekers","Lijst","T1_T2_T3","Logboek_aanw","Logboek_verslag","Updates","Rekenblad_aanw","Rekenblad_verslag"],"not_rendered":{"images":11,"macros":1,"external_links":1,"defined_names":33,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Aanwezigheden","index":0,"n_rows":43,"n_cols":28,"rows_kept":43,"merged":[[0,1,0,2],[0,3,0,12],[1,3,3,3],[1,4,3,4],[1,5,3,5],[1,6,3,6],[1,7,3,7],[1,8,3,8],[1,9,3,9],[1,10,3,10],[1,11,3,11],[1,12,3,12],[1,13,3,13],[1,14,3,14],[3,1,3,2]]}
["Incident:",null,null,"Overleg (uur)",{"$nulls":12},"verslag:",{"$f":"IF(AND(R2>0,R4>0),\"OK\",\"NOK\")","v":"NOK"},{"$f":"IF(AND(S2>0,S4>0),\"OK\",\"NOK\")","v":"NOK"},{"$f":"IF(AND(T2>0,T4>0),\"OK\",\"NOK\")","v":"NOK"},"NOK","NOK","NOK","NOK","NOK","NOK","NOK"]
["Locatie overleg:",null,"   >>>>>>",{"$nulls":14},{"$f":"COUNTA(D2)","v":0},{"$f":"COUNTA(E2)","v":0},{"$f":"COUNTA(F2)","v":0},0,0,0,0,0,0,0]
["Soort overleg:","Maak een keuze",{"$nulls":14},"aanwezigen:",{"$f":"IF(R4>0,\"OK\",\"NOK\")","v":"NOK"},{"$f":"IF(S4>0,\"OK\",\"NOK\")","v":"NOK"},"NOK","NOK","NOK","NOK","NOK","NOK","NOK","NOK"]
["Volgend overleg:",{"$f":"IF(B3=\"Maak een keuze\",\"\",CONCATENATE(\"Overleg \",B3,\" gepland om \",OFFSET(C2,0,COUNTA(overleguren))))","v":""},{"$nulls":15},{"$f":"COUNTA(D6:D43)","v":0},0,0,0,0,0,0,0,0,0]
["Functie","Naam ","GSM-nummer",1,2,3,4,5,6,7,8,9,10,{"$nulls":14},{"$f":"COUNTA(N6:N43)","v":0}]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A1,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A1,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A1,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A1,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A1,1),\"\"))))),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(B6,naam_gsm,2,FALSE),\"\")","v":""}]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A2,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A2,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A2,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A2,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A2,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A3,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A3,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A3,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A3,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A3,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A4,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A4,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A4,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A4,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A4,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A5,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A5,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A5,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A5,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A5,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A6,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A6,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A6,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A6,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A6,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A7,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A7,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A7,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A7,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A7,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A8,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A8,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A8,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A8,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A8,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A9,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A9,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A9,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A9,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A9,1),\"\"))))),\"\")","v":""},"",""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A10,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A10,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A10,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A10,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A10,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A11,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A11,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A11,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A11,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A11,1),\"\"))))),\"\")","v":""},"",""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A12,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A12,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A12,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A12,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A12,1),\"\"))))),\"\")","v":""},"",""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A13,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A13,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A13,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A13,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A13,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A14,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A14,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A14,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A14,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A14,1),\"\"))))),\"\")","v":""},"",""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A15,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A15,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A15,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A15,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A15,1),\"\"))))),\"\")","v":""},"",""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A16,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A16,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A16,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A16,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A16,1),\"\"))))),\"\")","v":""},"",""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A17,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A17,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A17,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A17,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A17,1),\"\"))))),\"\")","v":""},"",""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A18,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A18,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A18,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A18,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A18,1),\"\"))))),\"\")","v":""},"",""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A19,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A19,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A19,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A19,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A19,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A20,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A20,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A20,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A20,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A20,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A21,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A21,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A21,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A21,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A21,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A22,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A22,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A22,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A22,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A22,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A23,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A23,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A23,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A23,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A23,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A24,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A24,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A24,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A24,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A24,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A25,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A25,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A25,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A25,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A25,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A26,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A26,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A26,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A26,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A26,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A27,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A27,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A27,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A27,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A27,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A28,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A28,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A28,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A28,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A28,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A29,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A29,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A29,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A29,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A29,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A30,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A30,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A30,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A30,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A30,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A31,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A31,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A31,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A31,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A31,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A32,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A32,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A32,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A32,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A32,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A33,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A33,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A33,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A33,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A33,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A34,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A34,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A34,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A34,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A34,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A35,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A35,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A35,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A35,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A35,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A36,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A36,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A36,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A36,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A36,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A37,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A37,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A37,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A37,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A37,1),\"\"))))),\"\")","v":""},null,""]
[{"$f":"IFERROR(IF($B$3=\"MKO\",INDEX(MKO,Rekenblad_aanw!A38,1),IF($B$3=\"CP-Ops\",INDEX(CP_Ops,Rekenblad_aanw!A38,1),IF($B$3=\"CCGem\",INDEX(CCGem,Rekenblad_aanw!A38,1),IF($B$3=\"CCProv\",INDEX(CCProv,Rekenblad_aanw!A38,1),IF($B$3=\"Operationele Cel\",INDEX(Operationele_cel,Rekenblad_aanw!A38,1),\"\"))))),\"\")","v":""},null,""]

{"sheet":"Verslag","index":1,"n_rows":38,"n_cols":3,"rows_kept":38}
["Discipline","Verslag","Verslag vorige vergadering"]
["D1"]
["D2"]
["Slachtoffers"]
["D3"]
["D4"]
["D5"]
{"$rows_empty":29}
["Algemeen"]
["Algemeen"]

{"sheet":"Bezoekers","index":2,"n_rows":17,"n_cols":13,"rows_kept":17,"hidden":true}
["DAG","Totaal","Max Terrein",null,"UUR","Totaal","Max Terrein",null,"Camping",null,null,"Rekenkolom","x"]
[{"$nulls":11},{"$f":"CONCATENATE(\n(IF(AND(B2<>\"\",C2=\"\"),CONCATENATE(\"Op \",A2,\" waren er in totaal \",B2,\" bezoekers op het event. \"),\"\")),\n(IF(AND(B2<>\"\",C2<>\"\"),CONCATENATE(\"Op \",A2,\" waren er in totaal \",B2,\" bezoekers op het event en maximaal \",C2,\" bezoekers tegelijk op het terrein. \"),\"\")),\n(IF(AND(B2=\"\",C2<>\"\"),CONCATENATE(\"Op \",A2,\" waren er maximaal \",C2,\" bezoekers tegelijk op het terrein. \"),\"\")),\n(IF(AND(F2<>\"\",G2=\"\"),CONCATENATE(\"Vandaag om \",E2,\" zijn er in totaal al \",F2,\" bezoekers op het event geweest. \"),\"\")),\n(IF(AND(F2<>\"\",G2<>\"\"),CONCATENATE(\"Vandaag om \",E2,\" zijn er in totaal al \",F2,\" bezoekers op het event geweest waarvan nu \",G2,\" bezoekers op het terrein zijn. \"),\"\")),\n(IF(AND(F2=\"\",G2<>\"\"),CONCATENATE(\"Nu zijn er \",G2,\" bezoekers op het terrein. \"),\"\")),\n(IF(I2<>\"\",CONCATENATE(\"Er zijn op het ogenblik \",I2,\" kampeerders ingeschreven op de camping.\"),\"\"))\n)","v":""}]
[{"$nulls":11},{"$f":"CONCATENATE(\n(IF(AND(B3<>\"\",C3=\"\"),CONCATENATE(\"Op \",A3,\" waren er in totaal \",B3,\" bezoekers op het event. \"),\"\")),\n(IF(AND(B3<>\"\",C3<>\"\"),CONCATENATE(\"Op \",A3,\" waren er in totaal \",B3,\" bezoekers op het event en maximaal \",C3,\" bezoekers tegelijk op het terrein. \"),\"\")),\n(IF(AND(B3=\"\",C3<>\"\"),CONCATENATE(\"Op \",A3,\" waren er maximaal \",C3,\" bezoekers tegelijk op het terrein. \"),\"\")),\n(IF(AND(F3<>\"\",G3=\"\"),CONCATENATE(\"Vandaag om \",E3,\" zijn er in totaal al \",F3,\" bezoekers op het event geweest. \"),\"\")),\n(IF(AND(F3<>\"\",G3<>\"\"),CONCATENATE(\"Vandaag om \",E3,\" zijn er in totaal al \",F3,\" bezoekers op het event geweest waarvan nu \",G3,\" bezoekers op het terrein zijn. \"),\"\")),\n(IF(AND(F3=\"\",G3<>\"\"),CONCATENATE(\"Nu zijn er \",G3,\" bezoekers op het terrein. \"),\"\")),\n(IF(I3<>\"\",CONCATENATE(\"Er zijn op het ogenblik \",I3,\" kampeerders ingeschreven op de camping.\"),\"\"))\n)","v":""}]
[{"$nulls":11},{"$f":"CONCATENATE(\n(IF(AND(B4<>\"\",C4=\"\"),CONCATENATE(\"Op \",A4,\" waren er in totaal \",B4,\" bezoekers op het event. \"),\"\")),\n(IF(AND(B4<>\"\",C4<>\"\"),CONCATENATE(\"Op \",A4,\" waren er in totaal \",B4,\" bezoekers op het event en maximaal \",C4,\" bezoekers tegelijk op het terrein. \"),\"\")),\n(IF(AND(B4=\"\",C4<>\"\"),CONCATENATE(\"Op \",A4,\" waren er maximaal \",C4,\" bezoekers tegelijk op het terrein. \"),\"\")),\n(IF(AND(F4<>\"\",G4=\"\"),CONCATENATE(\"Vandaag om \",E4,\" zijn er in totaal al \",F4,\" bezoekers op het event geweest. \"),\"\")),\n(IF(AND(F4<>\"\",G4<>\"\"),CONCATENATE(\"Vandaag om \",E4,\" zijn er in totaal al \",F4,\" bezoekers op het event geweest waarvan nu \",G4,\" bezoekers op het terrein zijn. \"),\"\")),\n(IF(AND(F4=\"\",G4<>\"\"),CONCATENATE(\"Nu zijn er \",G4,\" bezoekers op het terrein. \"),\"\")),\n(IF(I4<>\"\",CONCATENATE(\"Er zijn op het ogenblik \",I4,\" kampeerders ingeschreven op de camping.\"),\"\"))\n)","v":""}]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]

{"sheet":"Lijst","index":3,"n_rows":39,"n_cols":18,"rows_kept":39,"merged":[[1,9,3,11]]}
["Soort overleg:","MKO:","CP-Ops:","CCGem:","CCProv:",null,"naam","GSMnummer",{"$nulls":5},"Status","Uitvoerder",null,"Operationele Cel (KB Terro)"," "]
["Maak een keuze","BW","DIR CP-Ops","BGM","GOUV",{"$nulls":4},"telkens bij het invullen van een naam dien je de kolom te sorteren van A naar Z",{"$nulls":3},"niet OK",null,null,"gouverneur of haar vertegenwoordiger"," "]
["MKO","MED","NPC","NPC-gem","NPC-prov",{"$nulls":8},"OK","Algemeen",null,"federaal magistraat"," "]
["CP-Ops","POL","DIR BW","DIR D1","BGM",{"$nulls":8},"Aandachtspunt",{"$f":"Aanwezigheden!A6","v":""},null,"afdelingsprocureur/magistraat openbare orde"," "]
["CCGem","LOG","DIR MED","DIR D2","NPC-gem",{"$nulls":9},{"$f":"Aanwezigheden!A7","v":""},null,"ambtenaar belast met de noodplanning van de federale diensten van de gouverneur"," "]
["CCProv","INFO","DIR POL","DIR D3","DIR D1",{"$nulls":8},"JaNee",{"$f":"Aanwezigheden!A8","v":""},null,"territoriaal bevoegde burgemeester"," "]
[null,"BEDRIJF","DIR LOG","DIR D4","DIR D2",{"$nulls":8},"Maak een keuze",{"$f":"Aanwezigheden!A9","v":""},null,"stedelijke/gemeentelijke ambtenaar noodplanning"," "]
[null,"ORG","DIR INFO","DIR D5","DIR D3",{"$nulls":8},"Ja",{"$f":"Aanwezigheden!A10","v":""},null,"zonecommandant van de hulpverleningszone die territoriaal bevoegd is – D1"," "]
[null,"EXPERT","PARKET","BEDRIJF","DIR D4",{"$nulls":8},"Neen",{"$f":"Aanwezigheden!A11","v":""},null,"federaal gezondheidsinspecteur – D2"," "]
[null,null,"BEDRIJF","ORG","DIR D5",{"$nulls":8},"Niet gekend",{"$f":"Aanwezigheden!A12","v":""},null,"korpschef van de lokale politie die territoriaal bevoegd is –D3"," "]
[null,null,"ORGANISATIE","EXPERT","BEDRIJF",{"$nulls":8},"nvt",{"$f":"Aanwezigheden!A13","v":""},null,"directeur-coördinator (DirCo) van de federale politie – D3"," "]
[null,null,"EIGENAAR",null,"ORG",{"$nulls":9},{"$f":"Aanwezigheden!A14","v":""},null,"gerechtelijk directeur (DirJud) van de federale politie – D3"," "]
[null,null,"EXPERT(EN)",null,"EXPERT",{"$nulls":9},{"$f":"Aanwezigheden!A15","v":""},null,"bevelhebber van de 6de operationele eenheid van de Civiele bescherming – D4"," "]
[{"$nulls":14},{"$f":"Aanwezigheden!A16","v":""},null,"militair commandant van de provincie Antwerpen – D4"," "]
[{"$nulls":14},{"$f":"Aanwezigheden!A17","v":""},null,"provinciaal communicatie verantwoordelijke D5"," "]
[{"$nulls":14},{"$f":"Aanwezigheden!A18","v":""},null,"officier van DSU – (Speciale eenheden federale politie)"," "]
[{"$nulls":14},{"$f":"Aanwezigheden!A19","v":""},null,"officier van DJO"," "]
[{"$nulls":14},{"$f":"Aanwezigheden!A20","v":""},null,"officier van DGJ/DJSOC/Terrorisme"," "]
[{"$nulls":14},{"$f":"Aanwezigheden!A21","v":""},null,"vertegenwoordiger van de Veiligheid van de Staat"," "]
[{"$nulls":14},{"$f":"Aanwezigheden!A22","v":""},null,"vertegenwoordiger van de Militaire Veiligheid - ADIV"," "]
[{"$nulls":14},{"$f":"Aanwezigheden!A23","v":""}]
[{"$nulls":14},{"$f":"Aanwezigheden!A24","v":""}]
[{"$nulls":14},{"$f":"Aanwezigheden!A25","v":""}]
[{"$nulls":14},{"$f":"Aanwezigheden!A26","v":""}]
[{"$nulls":14},{"$f":"Aanwezigheden!A27","v":""}]
[{"$nulls":14},{"$f":"Aanwezigheden!A28","v":""}]
[{"$nulls":14},{"$f":"Aanwezigheden!A29","v":""}]
[{"$nulls":14},{"$f":"Aanwezigheden!A30","v":""}]
[{"$nulls":14},{"$f":"Aanwezigheden!A31","v":""}]
[{"$nulls":14},{"$f":"Aanwezigheden!A32","v":""}]
[{"$nulls":14},{"$f":"Aanwezigheden!A33","v":""}]
[{"$nulls":14},{"$f":"Aanwezigheden!A34","v":""}]
[{"$nulls":14},{"$f":"Aanwezigheden!A35","v":""}]
[{"$nulls":14},{"$f":"Aanwezigheden!A36","v":""}]
[{"$nulls":14},{"$f":"Aanwezigheden!A37","v":""}]
[{"$nulls":14},{"$f":"Aanwezigheden!A38","v":""}]
[{"$nulls":14},{"$f":"Aanwezigheden!A39","v":""}]
[{"$nulls":14},{"$f":"Aanwezigheden!A40","v":""}]
[{"$nulls":14},{"$f":"Aanwezigheden!A42","v":""}]

{"sheet":"T1_T2_T3","index":4,"n_rows":17,"n_cols":14,"rows_kept":17}
["T1","T2","T3","T ?",null,"Evacuaties","Evacuees in OC",null,"Overleden","Vermist",null,"Rekenkolom","x","Samenvatting voor verslag"]
[{"$nulls":10},{"$f":"timestamp(M2)","v":""},{"$f":"CONCATENATE(IF(A2<>\"\",\"T1: \",\"\"),A2,IF(A2<>\"\",\" - \",\"\"),IF(B2<>\"\",\"T2: \",\"\"),B2,IF(B2<>\"\",\" - \",\"\"),IF(C2<>\"\",\"T3: \",\"\"),C2,IF(C2<>\"\",\" - \",\"\"),IF(D2<>\"\",\"Ernst onbekend: \",\"\"),D2,IF(D2<>\"\",\" - \",\"\"),IF(J2<>\"\",\"Vermist: \",\"\"),J2,IF(J2<>\"\",\" - \",\"\"),IF(I2<>\"\",\"Overleden: \",\"\"),I2,IF(I2<>\"\",\" - \",\"\"),IF(F2<>\"\",\"Evacuaties: \",\"\"),F2,IF(F2<>\"\",\" - \",\"\"),IF(G2<>\"\",\"Evacuees in opvang: \",\"\"),G2,IF(G2<>\"\",\" - \",\"\"))","v":""},null,{"$f":"IFERROR(LEFT(L2,LEN(L2)-2),\"\")","v":""}]
[{"$nulls":10},{"$f":"timestamp(M3)","v":""},{"$f":"CONCATENATE(IF(A3<>\"\",\"T1: \",\"\"),A3,IF(A3<>\"\",\" - \",\"\"),IF(B3<>\"\",\"T2: \",\"\"),B3,IF(B3<>\"\",\" - \",\"\"),IF(C3<>\"\",\"T3: \",\"\"),C3,IF(C3<>\"\",\" - \",\"\"),IF(D3<>\"\",\"Ernst onbekend: \",\"\"),D3,IF(D3<>\"\",\" - \",\"\"),IF(J3<>\"\",\"Vermist: \",\"\"),J3,IF(J3<>\"\",\" - \",\"\"),IF(I3<>\"\",\"Overleden: \",\"\"),I3,IF(I3<>\"\",\" - \",\"\"),IF(F3<>\"\",\"Evacuaties: \",\"\"),F3,IF(F3<>\"\",\" - \",\"\"),IF(G3<>\"\",\"Evacuees in opvang: \",\"\"),G3,IF(G3<>\"\",\" - \",\"\"))","v":""},null,{"$f":"IFERROR(LEFT(L3,LEN(L3)-2),\"\")","v":""}]
[{"$nulls":10},"","",null,""]
[{"$nulls":10},"","",null,""]
[{"$nulls":10},"","",null,""]
[{"$nulls":10},"","",null,""]
[{"$nulls":10},"","",null,""]
[{"$nulls":10},"","",null,""]
[{"$nulls":10},"","",null,""]
[{"$nulls":10},"","",null,""]
[{"$nulls":10},"","",null,""]
[{"$nulls":10},"","",null,""]
[{"$nulls":10},"","",null,""]
[{"$nulls":10},"","",null,""]
[{"$nulls":10},"","",null,""]
[{"$nulls":10},"","",null,""]

{"sheet":"Logboek_aanw","index":5,"n_rows":12,"n_cols":5,"rows_kept":12}
["Overleg",1,":",{"$f":"CONCATENATE(\"Aanwezigen overleg \",Aanwezigheden!B3,\" \",INDEX(overleguren,1,B1),\" = \",Rekenblad_aanw!F1,Rekenblad_aanw!F2,Rekenblad_aanw!F3,Rekenblad_aanw!F4,Rekenblad_aanw!F5,Rekenblad_aanw!F6,Rekenblad_aanw!F7,Rekenblad_aanw!F8,Rekenblad_aanw!F9,Rekenblad_aanw!F10,Rekenblad_aanw!F11,Rekenblad_aanw!F12,Rekenblad_aanw!F13,Rekenblad_aanw!F14,Rekenblad_aanw!F15,Rekenblad_aanw!F16,Rekenblad_aanw!F17,Rekenblad_aanw!F18,Rekenblad_aanw!F19,Rekenblad_aanw!F20,Rekenblad_aanw!F21,Rekenblad_aanw!F22,Rekenblad_aanw!F23,Rekenblad_aanw!F24,Rekenblad_aanw!F25,Rekenblad_aanw!F26,Rekenblad_aanw!F27,Rekenblad_aanw!F28,Rekenblad_aanw!F29,Rekenblad_aanw!F30,Rekenblad_aanw!F31,Rekenblad_aanw!F32,Rekenblad_aanw!F33,Rekenblad_aanw!F34,Rekenblad_aanw!F35,Rekenblad_aanw!F36)","v":"Aanwezigen overleg Maak een keuze  = "}]
[{"$nulls":3},"GELIEVE AAN DEZE PAGINA NIETS TE WIJZIGEN !!!"]
[null,1,null,null,{"$f":"LEN(D3)","v":0}]
[null,2,null,null,{"$f":"LEN(D4)","v":0}]
[null,3,null,null,0]
[null,4,null,null,0]
[null,5,null,null,0]
[null,6,null,null,0]
[null,7,null,null,0]
[null,8,null,null,0]
[null,9,null,null,0]
[null,10,null,null,0]

{"sheet":"Logboek_verslag","index":6,"n_rows":12,"n_cols":5,"rows_kept":12}
["Overleg",1,":",{"$f":"CONCATENATE(\"Verslag overleg \",Aanwezigheden!B3,\" \",INDEX(overleguren,1,10-COUNTIF(OK,\"NOK\")),\" = \",Rekenblad_verslag!F1,Rekenblad_verslag!F2,Rekenblad_verslag!F3,Rekenblad_verslag!F4,Rekenblad_verslag!F5,Rekenblad_verslag!F6,Rekenblad_verslag!F7,Rekenblad_verslag!F8,Rekenblad_verslag!F9,Rekenblad_verslag!F10,Rekenblad_verslag!F11,Rekenblad_verslag!F12,Rekenblad_verslag!F13,Rekenblad_verslag!F14,Rekenblad_verslag!F15,Rekenblad_verslag!F16,Rekenblad_verslag!F17,Rekenblad_verslag!F18,Rekenblad_verslag!F19,Rekenblad_verslag!F20,Rekenblad_verslag!F21,Rekenblad_verslag!F22,Rekenblad_verslag!F23,Rekenblad_verslag!F24,Rekenblad_verslag!F25,Rekenblad_verslag!F26,Rekenblad_verslag!F27,Rekenblad_verslag!F28,Rekenblad_verslag!F29,Rekenblad_verslag!F30,Rekenblad_verslag!F31,Rekenblad_verslag!F32,Rekenblad_verslag!F33,Rekenblad_verslag!F34,Rekenblad_verslag!F35,Rekenblad_verslag!F36)","v":"Verslag overleg Maak een keuze  = "}]
[{"$nulls":3},"GELIEVE AAN DEZE PAGINA NIETS TE WIJZIGEN !!!"]
[null,1,null,null,{"$f":"LEN(D3)","v":0}]
[null,2,null,null,{"$f":"LEN(D4)","v":0}]
[null,3,null,null,0]
[null,4,null,null,0]
[null,5,null,null,0]
[null,6,null,null,0]
[null,7,null,null,0]
[null,8,null,null,0]
[null,9,null,null,0]
[null,10,null,null,0]

{"sheet":"Updates","index":7,"n_rows":40,"n_cols":12,"rows_kept":40,"hidden":true}
["Tabblad","Type","beschrijving","OK?","in versie",{"$nulls":4},"Tabblad","Type","OK?"]
["Beslissingen_Taken","opmerking","beslissingen up of down sorteren","nok",{"$nulls":5},"Algemeen","ToDo","nok"]
["Afgewerkte_taken","opmerking","tijdsstempel op tabblad Beslissingen_taken plaatsen ipv op tabblad Afgewerkte_taken?","nok",{"$nulls":5},"Feiten","opmerking","ok"]
["Algemeen","ToDo","Handleiding schrijven","nok",{"$nulls":5},"Aanwezigheden","update"]
["Algemeen","ToDo","belangrijkste knop het grootste maken","ok",{"$nulls":5},"ICMS_aanw"]
["ICMS_verslag","ToDo","bij de knop Sheets leegmaken, ook copy laten maken van Aanwezigheden","ok",{"$nulls":5},"Verslag"]
["Aanwezigheden","ToDo","automatisch aanvullen van de naam ifv van gsm-nummer: nazien of dat mogelijk is","ok","V3",{"$nulls":4},"ICMS_verslag"]
["Feiten","opmerking","Enkel vaste feiten in deze kolommen, de rest aanvullen in Statusbord","ok","V6",{"$nulls":4},"Beslissingen_Taken"]
["Beslissingen_Taken","update","voorwaardelijke opmaak terug op \"normaal\" gezet omdat deze niet werkte zoals voorzien = bij taak aan externe zou cel Uitvoerder op rood moeten springen en dat deed hij niet zoals verwacht","ok",6,{"$nulls":4},"Statusbord"]
["Beslissingen_Taken","ToDo","voorwaardelijke opmaak voor externe taken: cel Uitvoerder op rood laten komen","nok",{"$nulls":5},"Afgewerkte_taken"]
["Lijst","opmerking","is het mogelijk om de namen uit een anders bestand te laten komen = niet meer te kopieren dan","ok","V3",{"$nulls":4},"Lijst"]
["Feiten","opmerking","opdeling \"vaste feiten\" en \"variabele feiten\" in dropdown","nok",{"$nulls":5},"T1_T2_T3"]
["Algemeen","opmerking","5 zaken in ICMS:\n- aanwezigen;\n- verslag;\n- statusbord;\n- volgende vergadering;\n- taken voor andere coordinatiecel","nok",{"$nulls":5},"Verslag_Beslissingen_Taken"]
["Beslissingen_Taken","opmerking","Taken en vragen die door een andere coordinatiecel moeten behandeld worden: hoe door te geven aan die specifieke cel?","nok"]
["Beslissingen_Taken","opmerking","Is dit tabblad te integreren in tabblad Verslag ifv van minder te moeten schakelen? (tabblad Verslag_Beslissingen_Taken)","ok"]
["Feiten","opmerking","knop Opslaan als onder aan de lijst zetten zodat duidelijk is dat je deze lijst eerst moet invullen en dan pas op de knopdrukken (geel zou ik laten staan voor als je geen tijd hebt)(Zijn dit alle \"vaste\" feiten?)","ok",6]
["Verslag_Beslissingen_Taken","opmerking","automatisch het uur van het volgende overleg mee opnemen in het verslag en ineens op tabblad Aanwezigen plaatsen. ","ok","V1"]
["Algemeen","ToDo","ICMS vervangen door Logboek","ok","V3"]
["ICMS_verslag","update","programmeerfoutje om het juiste uur weer te geven","ok","V2"]
["Verslag_Beslissingen_Taken","update","Ook kolom A wordt leegegemaakt op de eerste 5 na","ok","V3"]
["Verslag_Beslissingen_Taken","opmerking","Disciplines automatisch overnemen van Aanwezigen of zo behouden?","nok"]
["T1_T2_T3","update","aantal afvoeren ziekenhuis bij event","nok"]
["ICMS_aanw","update","tabblad niet meer laten zien en tekst knop aanpassen zodat geweten is wat er gebeurd (crtl_v), desnoods popup laten verschijnen?","ok","V6"]
["Verslag","update","bij knop \"ingave statusbord' nog knop Feiten toevoegen en definieren","ok","V6"]
["Verslag","update","geen volgende vergadering bij knop Verslag kopieren voor logboek","ok","V6"]
["Verslag","update","Cancel bij knop Ingeve statusbord","ok","V6"]
["Verslag","update","FAN/CAN/ … aanduiden bij knop Ingave statusbord","ok","V6"]
["Algemeen","update","benamingen FAN/CAN/… overal afstemmen op elkaar","ok"]
["Aanwezigheden","update","nadat het 10e uur ingevuld werd, bij 11e uur invullen sheets autoamtisch leegmaken en opslaan in pdf","ok"]
[{"$nulls":3},"nok"]
[{"$nulls":3},"nok"]
[{"$nulls":3},"nok"]
[{"$nulls":3},"nok"]
[{"$nulls":3},"nok"]
[{"$nulls":3},"nok"]
[{"$nulls":3},"nok"]
[{"$nulls":3},"nok"]
[{"$nulls":3},"nok"]
[{"$nulls":3},"nok"]
[{"$nulls":3},"nok"]

{"sheet":"Rekenblad_aanw","index":8,"n_rows":36,"n_cols":6,"rows_kept":36,"hidden":true}
[1,{"$f":"INDEX(Functie_naam,A1,1)","v":""},{"$f":"INDEX(Functie_naam,A1,2)","v":0},{"$f":"UPPER(IF(INDEX(overlegmomenten,A1,Logboek_aanw!$B$1)<>\"\",B1,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A1,Logboek_aanw!$B$1)<>\"\",IF(C1=0,\"\",C1),\"\")","v":""},{"$f":"CONCATENATE(D1,IF(E1<>\"\",\": \",\"\"),E1,IF(D1<>\"\",\" | \",\"\"))","v":""}]
[2,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A2,Logboek_aanw!$B$1)<>\"\",B2,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A2,Logboek_aanw!$B$1)<>\"\",IF(C2=0,\"\",C2),\"\")","v":""},{"$f":"CONCATENATE(D2,IF(E2<>\"\",\": \",\"\"),E2,IF(D2<>\"\",\" | \",\"\"))","v":""}]
[3,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A3,Logboek_aanw!$B$1)<>\"\",B3,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A3,Logboek_aanw!$B$1)<>\"\",IF(C3=0,\"\",C3),\"\")","v":""},""]
[4,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A4,Logboek_aanw!$B$1)<>\"\",B4,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A4,Logboek_aanw!$B$1)<>\"\",IF(C4=0,\"\",C4),\"\")","v":""},""]
[5,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A5,Logboek_aanw!$B$1)<>\"\",B5,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A5,Logboek_aanw!$B$1)<>\"\",IF(C5=0,\"\",C5),\"\")","v":""},""]
[6,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A6,Logboek_aanw!$B$1)<>\"\",B6,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A6,Logboek_aanw!$B$1)<>\"\",IF(C6=0,\"\",C6),\"\")","v":""},""]
[7,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A7,Logboek_aanw!$B$1)<>\"\",B7,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A7,Logboek_aanw!$B$1)<>\"\",IF(C7=0,\"\",C7),\"\")","v":""},""]
[8,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A8,Logboek_aanw!$B$1)<>\"\",B8,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A8,Logboek_aanw!$B$1)<>\"\",IF(C8=0,\"\",C8),\"\")","v":""},""]
[9,"","",{"$f":"UPPER(IF(INDEX(overlegmomenten,A9,Logboek_aanw!$B$1)<>\"\",B9,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A9,Logboek_aanw!$B$1)<>\"\",IF(C9=0,\"\",C9),\"\")","v":""},""]
[10,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A10,Logboek_aanw!$B$1)<>\"\",B10,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A10,Logboek_aanw!$B$1)<>\"\",IF(C10=0,\"\",C10),\"\")","v":""},""]
[11,"","",{"$f":"UPPER(IF(INDEX(overlegmomenten,A11,Logboek_aanw!$B$1)<>\"\",B11,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A11,Logboek_aanw!$B$1)<>\"\",IF(C11=0,\"\",C11),\"\")","v":""},""]
[12,"","",{"$f":"UPPER(IF(INDEX(overlegmomenten,A12,Logboek_aanw!$B$1)<>\"\",B12,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A12,Logboek_aanw!$B$1)<>\"\",IF(C12=0,\"\",C12),\"\")","v":""},""]
[13,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A13,Logboek_aanw!$B$1)<>\"\",B13,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A13,Logboek_aanw!$B$1)<>\"\",IF(C13=0,\"\",C13),\"\")","v":""},""]
[14,"","",{"$f":"UPPER(IF(INDEX(overlegmomenten,A14,Logboek_aanw!$B$1)<>\"\",B14,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A14,Logboek_aanw!$B$1)<>\"\",IF(C14=0,\"\",C14),\"\")","v":""},""]
[15,"","",{"$f":"UPPER(IF(INDEX(overlegmomenten,A15,Logboek_aanw!$B$1)<>\"\",B15,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A15,Logboek_aanw!$B$1)<>\"\",IF(C15=0,\"\",C15),\"\")","v":""},""]
[16,"","",{"$f":"UPPER(IF(INDEX(overlegmomenten,A16,Logboek_aanw!$B$1)<>\"\",B16,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A16,Logboek_aanw!$B$1)<>\"\",IF(C16=0,\"\",C16),\"\")","v":""},""]
[17,"","",{"$f":"UPPER(IF(INDEX(overlegmomenten,A17,Logboek_aanw!$B$1)<>\"\",B17,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A17,Logboek_aanw!$B$1)<>\"\",IF(C17=0,\"\",C17),\"\")","v":""},""]
[18,"","",{"$f":"UPPER(IF(INDEX(overlegmomenten,A18,Logboek_aanw!$B$1)<>\"\",B18,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A18,Logboek_aanw!$B$1)<>\"\",IF(C18=0,\"\",C18),\"\")","v":""},""]
[19,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A19,Logboek_aanw!$B$1)<>\"\",B19,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A19,Logboek_aanw!$B$1)<>\"\",IF(C19=0,\"\",C19),\"\")","v":""},""]
[20,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A20,Logboek_aanw!$B$1)<>\"\",B20,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A20,Logboek_aanw!$B$1)<>\"\",IF(C20=0,\"\",C20),\"\")","v":""},""]
[21,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A21,Logboek_aanw!$B$1)<>\"\",B21,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A21,Logboek_aanw!$B$1)<>\"\",IF(C21=0,\"\",C21),\"\")","v":""},""]
[22,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A22,Logboek_aanw!$B$1)<>\"\",B22,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A22,Logboek_aanw!$B$1)<>\"\",IF(C22=0,\"\",C22),\"\")","v":""},""]
[23,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A23,Logboek_aanw!$B$1)<>\"\",B23,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A23,Logboek_aanw!$B$1)<>\"\",IF(C23=0,\"\",C23),\"\")","v":""},""]
[24,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A24,Logboek_aanw!$B$1)<>\"\",B24,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A24,Logboek_aanw!$B$1)<>\"\",IF(C24=0,\"\",C24),\"\")","v":""},""]
[25,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A25,Logboek_aanw!$B$1)<>\"\",B25,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A25,Logboek_aanw!$B$1)<>\"\",IF(C25=0,\"\",C25),\"\")","v":""},""]
[26,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A26,Logboek_aanw!$B$1)<>\"\",B26,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A26,Logboek_aanw!$B$1)<>\"\",IF(C26=0,\"\",C26),\"\")","v":""},""]
[27,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A27,Logboek_aanw!$B$1)<>\"\",B27,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A27,Logboek_aanw!$B$1)<>\"\",IF(C27=0,\"\",C27),\"\")","v":""},""]
[28,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A28,Logboek_aanw!$B$1)<>\"\",B28,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A28,Logboek_aanw!$B$1)<>\"\",IF(C28=0,\"\",C28),\"\")","v":""},""]
[29,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A29,Logboek_aanw!$B$1)<>\"\",B29,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A29,Logboek_aanw!$B$1)<>\"\",IF(C29=0,\"\",C29),\"\")","v":""},""]
[30,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A30,Logboek_aanw!$B$1)<>\"\",B30,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A30,Logboek_aanw!$B$1)<>\"\",IF(C30=0,\"\",C30),\"\")","v":""},""]
[31,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A31,Logboek_aanw!$B$1)<>\"\",B31,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A31,Logboek_aanw!$B$1)<>\"\",IF(C31=0,\"\",C31),\"\")","v":""},""]
[32,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A32,Logboek_aanw!$B$1)<>\"\",B32,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A32,Logboek_aanw!$B$1)<>\"\",IF(C32=0,\"\",C32),\"\")","v":""},""]
[33,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A33,Logboek_aanw!$B$1)<>\"\",B33,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A33,Logboek_aanw!$B$1)<>\"\",IF(C33=0,\"\",C33),\"\")","v":""},""]
[34,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A34,Logboek_aanw!$B$1)<>\"\",B34,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A34,Logboek_aanw!$B$1)<>\"\",IF(C34=0,\"\",C34),\"\")","v":""},""]
[35,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A35,Logboek_aanw!$B$1)<>\"\",B35,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A35,Logboek_aanw!$B$1)<>\"\",IF(C35=0,\"\",C35),\"\")","v":""},""]
[36,"",0,{"$f":"UPPER(IF(INDEX(overlegmomenten,A36,Logboek_aanw!$B$1)<>\"\",B36,\"\"))","v":""},{"$f":"IF(INDEX(overlegmomenten,A36,Logboek_aanw!$B$1)<>\"\",IF(C36=0,\"\",C36),\"\")","v":""},""]

{"sheet":"Rekenblad_verslag","index":9,"n_rows":36,"n_cols":6,"rows_kept":36,"hidden":true}
[1,{"$f":"INDEX(Verslag,A1,1)","v":"D1"},{"$f":"INDEX(Verslag,A1,2)","v":0},{"$f":"UPPER(IF(C1<>0,IF(B1=0,\"\",B1),\"\"))","v":""},{"$f":"IF(C1<>0,IF(C1=0,\"\",C1),\"\")","v":""},{"$f":"CONCATENATE(D1,IF(D1<>\"\",\": \",\"\"),E1,IF(E1<>\"\",\" | \",\"\"))","v":""}]
[2,"D2",0,{"$f":"UPPER(IF(C2<>0,IF(B2=0,\"\",B2),\"\"))","v":""},"",{"$f":"CONCATENATE(D2,IF(D2<>\"\",\": \",\"\"),E2,IF(E2<>\"\",\" | \",\"\"))","v":""}]
[3,"Slachtoffers",0,"","",""]
[4,"D3",0,"","",""]
[5,"D4",0,"","",""]
[6,"D5",0,"","",""]
[7,0,0,"","",""]
[8,0,0,"","",""]
[9,0,0,"","",""]
[10,0,0,"","",""]
[11,0,0,"","",""]
[12,0,0,"","",""]
[13,0,0,"","",""]
[14,0,0,"","",""]
[15,0,0,"","",""]
[16,0,0,"","",""]
[17,0,0,"","",""]
[18,0,0,"","",""]
[19,0,0,"","",""]
[20,0,0,"","",""]
[21,0,0,"","",""]
[22,0,0,"","",""]
[23,0,0,"","",""]
[24,0,0,"","",""]
[25,0,0,"","",""]
[26,0,0,"","",""]
[27,0,0,"","",""]
[28,0,0,"","",""]
[29,0,0,"","",""]
[30,0,0,"","",""]
[31,0,0,"","",""]
[32,0,0,"","",""]
[33,0,0,"","",""]
[34,0,0,"","",""]
[35,0,0,"","",""]
[36,"Algemeen",0,"","",""]