{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Import","Transform","Welkom","Totals","Totaal Onkosten","Per Trainer","Per Groep","#Trainers","Eigen Opmaak","Data","Hoe Data Importeren","Werken Met Draaitabellen"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":6},"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":"Import","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Transform","index":1,"n_rows":2,"n_cols":27,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Statuut","Maand","Onkostenbericht","ExpenseCategory","FederationNumber","FirstName","LastName","IbanNumber","BirthDate","Email","ClubGroupID","GroupName","DayOfWeek","date","starthour","endhour","statute","logtimestamp","paid","hours","Hourrate","FixedAmount","total","OriginalAmount","Aangepast Bedrag","Replacement","AantalKm"]
[{"$f":"IF($L2=\"Expense\",\"Expense\",$Q2)","v":0},{"$f":"IFERROR(MONTH(N2),\"\")","v":""},{"$f":"IF($L2=\"Expense\",Import!V2,\"\")","v":""},{"$f":"IF($L2=\"Expense\",Import!W2,\"\")","v":""},{"$f":"Import!A2","v":0},{"$f":"TRIM(PROPER(Import!B2))","v":""},{"$f":"TRIM(PROPER(Import!C2))","v":""},{"$f":"TRIM(UPPER(IF(Import!D2=\"NULL\",\"\",Import!D2)))","v":""},{"$f":"TEXT(Import!E2,\"dd/mm/jjjj\")","v":"00/01/jjjj"},{"$f":"TRIM(LOWER(Import!F2))","v":""},{"$f":"Import!G2","v":0},{"$f":"TRIM(PROPER(Import!H2))","v":""},{"$f":"TRIM(PROPER(Import!I2))","v":""},{"$f":"TEXT(Import!J2,\"dd/mm/jjjj\")","v":"00/01/jjjj"},{"$f":"TEXT(Import!K2,\"uu:mm\")","v":"uu:01"},{"$f":"TEXT(Import!L2,\"uu:mm\")","v":"uu:01"},{"$f":"IF(L2=\"Expense\",\"\",Import!N2)","v":0},{"$f":"TRIM(Import!M2)","v":""},{"$f":"IF(Import!O2,\"Ja\",\"Nee\")","v":"Nee"},{"$f":"IFERROR(VALUE(SUBSTITUTE(Import!P2,\".\",\",\")),0)","v":0},{"$f":"IFERROR(VALUE(SUBSTITUTE(Import!Q2,\".\",\",\")),0)","v":0},{"$f":"IFERROR(VALUE(SUBSTITUTE(Import!R2,\".\",\",\")),0)","v":0},{"$f":"IFERROR(VALUE(SUBSTITUTE(Import!S2,\".\",\",\")),0)","v":0},{"$f":"IFERROR(VALUE(SUBSTITUTE(Import!T2,\".\",\",\")),0)","v":0},{"$f":"IF(X2=W2,\"Nee\",\"Ja\")","v":"Nee"},{"$f":"IF(Import!U2=\"NULL\",\"\",IF(Import!U2,\"Ja\",\"Nee\"))","v":"Nee"},{"$f":"IFERROR(VALUE(SUBSTITUTE(Import!X2,\".\",\",\")),0)","v":0}]

{"sheet":"Welkom","index":2,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Opmerking : Een nieuw veld \"Aangepast Bedrag\" is toegevoegd tot de rapporten."]
[]
[]
[]
[]
[null,null,"Verschillende Rapporten"]
[null,null,null,null,null,null,null,null,"Hier vind je een overzicht van de totalen per trainer",null,null,null,null,null,null,null,"Hier kan je zelf filteren en meerdere kolommen toevoegen of weghalen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* Raadpleeg hiervoor \"Werken met Draaitabellen\""]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Hier vind je gedetailleerde info per trainer",null,null,null,null,null,null,null,"Hier vind je het aantal trainers per training"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Hier vind je gedetailleerde info per groep"]
[]
[]
[]
[]
[]
[null,null,"Procedures"]

{"sheet":"Totals","index":3,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,3,0,10]]}
[null,null,null,"Totalen Per Trainer"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"GETPIVOTDATA(\"Sum of Uren\",$D$8)","v":48},{"$f":"GETPIVOTDATA(\"Sum of Totaal\",$D$8)","v":865.07000000000016}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Values"]
[null,null,null,"Federatie Nummer","Iban Nummer","Voornaam","Naam","Statuut","Vervanging","Vaste Kost","Uur Tarief","Sum of Uren","Sum of Totaal","Sum of Origineel Bedrag"]
[null,null,null,201400001,"","Gaetan","Bracke","Trainer","Nee",0,10,3,20,30]
[null,null,null,201020447,"","Caroline","D'Haenens","Trainer","Nee",0,5,3,15,15]
[null,null,null,201835590,"BE59-3770-1844-8326","Delphine","De Jaeger","Hulptrainer","Nee",0,10,4,40,40]
[null,null,null,202001047,"","Jorre","Deschuyteneer","Trainer","Nee",0,10,9,90,90]
[null,null,null,null,null,null,null,"Expense","",0,0,0,103.17000000000002,103.17000000000002]
[null,null,null,200516862,"BE38-2900-4810-7472","Inge","Doens","Trainer","Nee",0,11,25,275,275]
[null,null,null,null,null,null,null,"Expense","",0,0,0,321.90000000000009,321.90000000000009]
[null,null,null,202037886,"","Cedric","Lenaers","Trainer","Nee",0,0,4,0,0]
[null,null,null,"Grand Total",null,null,null,null,null,null,null,48,865.07000000000016,875.07000000000016]

{"sheet":"Totaal Onkosten","index":4,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,3,0,10]]}
[null,null,null,"Totaal Onkosten Per Trainer"]
[]
[]
[]
[]
[null,null,null,"Statuut","Expense"]
[]
[null,null,null,null,null,null,null,"Values"]
[null,null,null,"Federatie Nummer","Voornaam","Naam","Onkostenbericht","Sum of Totaal","Sum of Origineel Bedrag","Sum of Aantal_KM"]
[null,null,null,202001047,"Jorre","Deschuyteneer","Kilometervergoeding training",32.799999999999997,32.799999999999997,80]
[null,null,null,null,null,null,"sdfsf",10.37,10.37,0]
[null,null,null,null,null,null,"sdkjfhsfjk",60,60,0]
[null,null,null,200516862,"Inge","Doens","Aankoop micro (test)",75,75,0]
[null,null,null,null,null,null,"Kilometervergoeding training",143.49999999999997,143.49999999999997,350]
[null,null,null,null,null,null,"test",83.4,83.4,0]
[null,null,null,null,null,null,"Test upload zip.file",20,20,0]
[null,null,null,"Grand Total",null,null,null,425.06999999999994,425.06999999999994,430]

{"sheet":"Per Trainer","index":5,"n_rows":63,"n_cols":22,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,1,0,14]]}
[null,"Details Per Trainer"]
[]
[]
[]
[]
[]
[null,"ClubGroupID","(All)"]
[null,"e-Mail","(All)"]
[null,"Iban Nummer","(All)"]
[null,"Geboortedatum","(All)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Values"]
[null,"Federatie Nummer","Naam","Voornaam","Maand","Datum","Weekdag","Start uur","Eind uur","Groep Naam","Statuut","Onkosten Category","Onkosten bericht","Vervanging","Afgesloten","Aangepast Bedrag","Vaste Kost","Uur Tarief","Sum of Aantal_KM","Sum of Uren","Sum of Totaal","Origineel_Bedrag"]
[null,201400001,"Bracke","Gaetan",8,"01/08/2022","Maandag","18:00","21:00","Basisgroep 1","Trainer","","","Nee","Nee","Ja",0,10,0,3,20,30]
[null,null,null,"Gaetan Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,3,20,30]
[null,201020447,"D'Haenens","Caroline",8,"14/08/2022","Zondag","13:00","16:00","Acro 2020-2021","Trainer","","","Nee","Nee","Nee",0,5,0,3,15,15]
[null,null,null,"Caroline Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,3,15,15]
[null,201835590,"De Jaeger","Delphine",8,"09/08/2022","Dinsdag","18:00","20:00","Acro 2020-2021","Hulptrainer","","","Nee","Nee","Nee",0,10,0,2,20,20]
[null,null,null,null,null,null,null,"17:00","19:00","Acro 2020-2021","Hulptrainer","","","Nee","Nee","Nee",0,10,0,2,20,20]
[null,null,null,"Delphine Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,4,40,40]
[null,202001047,"Deschuyteneer","Jorre",8,"01/08/2022","Maandag","9:00","10:30","Acro 2020-2021","Trainer","","","Nee","Nee","Nee",0,10,0,1.5,15,15]
[null,null,null,null,null,null,null,null,"9:00","Expense","Expense","Kilometervergoeding","Kilometervergoeding training","","Nee","Nee",0,0,20,0,8.1999999999999993,8.1999999999999993]
[null,null,null,null,null,"09/08/2022","Dinsdag","18:00","20:00","Acro 2020-2021","Trainer","","","Nee","Nee","Nee",0,10,0,2,20,20]
[null,null,null,null,null,null,null,"17:00","19:00","Acro 2020-2021","Trainer","","","Nee","Nee","Nee",0,10,0,2,20,20]
[null,null,null,null,null,null,null,null,"17:00","Expense","Expense","Kilometervergoeding","Kilometervergoeding training","","Nee","Nee",0,0,20,0,8.1999999999999993,8.1999999999999993]
[null,null,null,null,null,"02/08/2022","Dinsdag","18:00","20:00","Acro 2020-2021","Trainer","","","Nee","Nee","Nee",0,10,0,2,20,20]
[null,null,null,null,null,null,null,null,"18:00","Expense","Expense","Kilometervergoeding","Kilometervergoeding training","","Nee","Nee",0,0,20,0,8.1999999999999993,8.1999999999999993]
[null,null,null,null,null,"15/08/2022","Maandag","9:00","10:30","Acro 2020-2021","Trainer","","","Nee","Nee","Nee",0,10,0,1.5,15,15]
[null,null,null,null,null,null,null,null,"9:00","Expense","Expense","Kilometervergoeding","Kilometervergoeding training","","Nee","Nee",0,0,20,0,8.1999999999999993,8.1999999999999993]
[null,null,null,null,null,"16/08/2022","Dinsdag","2:00","2:00","Expense","Expense","Aanwezigheid op wedstrijd","sdkjfhsfjk","","Nee","Nee",0,0,0,0,60,60]
[null,null,null,null,null,"21/08/2022","Zondag","2:00","2:00","Expense","Expense","Aanwezigheid Jury","sdfsf","","Nee","Nee",0,0,0,0,10,10]
[null,null,null,null,null,null,null,null,null,null,null,"Aankopen","sdfsf","","Nee","Nee",0,0,0,0,0.37,0.37]
[null,null,null,"Jorre Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,9,193.17000000000002,193.17000000000002]
[null,200516862,"Doens","Inge",8,"01/08/2022","Maandag","9:00","11:00","Acro 2020-2021","Trainer","","","Nee","Nee","Nee",0,11,0,2,22,22]
[null,null,null,null,null,null,null,null,"9:00","Expense","Expense","Kilometervergoeding","Kilometervergoeding training","","Nee","Nee",0,0,35,0,14.35,14.35]
[null,null,null,null,null,"09/08/2022","Dinsdag","17:00","19:00","Acro 2020-2021","Trainer","","","Nee","Nee","Nee",0,11,0,2,22,22]
[null,null,null,null,null,null,null,null,"17:00","Expense","Expense","Kilometervergoeding","Kilometervergoeding training","","Nee","Nee",0,0,35,0,14.35,14.35]
[null,null,null,null,null,"02/08/2022","Dinsdag","10:00","12:00","Acro 2020-2021","Trainer","","","Nee","Nee","Nee",0,11,0,2,22,22]
[null,null,null,null,null,null,null,null,"10:00","Expense","Expense","Kilometervergoeding","Kilometervergoeding training","","Nee","Nee",0,0,35,0,14.35,14.35]
[null,null,null,null,null,null,null,"17:00","19:00","Acro 2020-2021","Trainer","","","Nee","Nee","Nee",0,11,0,2,22,22]
[null,null,null,null,null,null,null,"2:00","2:00","Expense","Expense","Andere","test","","Nee","Nee",0,0,0,0,73.400000000000006,73.400000000000006]
[null,null,null,null,null,"07/08/2022","Zondag","13:00","16:00","Acro 2020-2021","Trainer","","","Nee","Nee","Nee",0,11,0,3,33,33]
[null,null,null,null,null,null,null,null,"13:00","Expense","Expense","Kilometervergoeding","Kilometervergoeding training","","Nee","Nee",0,0,35,0,14.35,14.35]
[null,null,null,null,null,"08/08/2022","Maandag","18:00","21:00","Basisgroep 1","Trainer","","","Nee","Nee","Nee",0,11,0,3,33,33]
[null,null,null,null,null,null,null,null,"18:00","Expense","Expense","Kilometervergoeding","Kilometervergoeding training","","Nee","Nee",0,0,35,0,14.35,14.35]
[null,null,null,null,null,"10/08/2022","Woensdag","14:00","16:00","Basisgroep 1","Trainer","","","Nee","Nee","Nee",0,11,0,2,22,22]
[null,null,null,null,null,null,null,null,"14:00","Expense","Expense","Kilometervergoeding","Kilometervergoeding training","","Nee","Nee",0,0,35,0,14.35,14.35]
[null,null,null,null,null,"03/08/2022","Woensdag","2:00","2:00","Expense","Expense","Andere","Test upload zip.file","","Nee","Nee",0,0,0,0,20,20]
[null,null,null,null,null,"23/08/2022","Dinsdag","2:00","2:00","Expense","Expense","Andere","test","","Nee","Nee",0,0,0,0,10,10]
[null,null,null,null,7,"04/07/2022","Maandag","18:00","21:00","Basisgroep 1","Trainer","","","Nee","Ja","Nee",0,11,0,3,33,33]
[null,null,null,null,null,null,null,null,"18:00","Expense","Expense","Kilometervergoeding","Kilometervergoeding training","","Ja","Nee",0,0,35,0,14.35,14.35]
[null,null,null,null,null,"06/07/2022","Woensdag","14:00","15:00","Basisgroep 1","Trainer","","","Nee","Ja","Nee",0,11,0,1,11,11]
[null,null,null,null,null,null,null,null,"14:00","Expense","Expense","Kilometervergoeding","Kilometervergoeding training","","Ja","Nee",0,0,35,0,14.35,14.35]
[null,null,null,null,null,"10/07/2022","Zondag","10:00","12:00","Basisgroep 1","Trainer","","","Nee","Ja","Nee",0,11,0,2,22,22]
[null,null,null,null,null,null,null,null,"10:00","Expense","Expense","Kilometervergoeding","Kilometervergoeding training","","Ja","Nee",0,0,35,0,14.35,14.35]
[null,null,null,null,null,"11/07/2022","Maandag","18:00","21:00","Basisgroep 1","Trainer","","","Nee","Ja","Nee",0,11,0,3,33,33]
[null,null,null,null,null,null,null,null,"18:00","Expense","Expense","Kilometervergoeding","Kilometervergoeding training","","Ja","Nee",0,0,35,0,14.35,14.35]
[null,null,null,null,null,"14/07/2022","Donderdag","2:00","2:00","Expense","Expense","Aankopen","Aankoop micro (test)","","Ja","Nee",0,0,0,0,75,75]
[null,null,null,"Inge Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,350,25,596.90000000000009,596.90000000000009]
[null,202037886,"Lenaers","Cedric",8,"09/08/2022","Dinsdag","18:00","20:00","Acro 2020-2021","Trainer","","","Nee","Nee","Nee",0,0,0,2,0,0]
[null,null,null,null,null,null,null,"17:00","19:00","Acro 2020-2021","Trainer","","","Nee","Nee","Nee",0,0,0,2,0,0]
[null,null,null,"Cedric Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,4,0,0]
[null,"Grand Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,430,48,865.07000000000016,875.07000000000016]

{"sheet":"Per Groep","index":6,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,14]]}
[null,"Details Per Groep"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Values"]
[null,"ClubGroupID","Groep Naam","Naam","Voornaam","Statuut","Vervanging","Vaste Kost","Uur Tarief","#Uren","Totale kost"]
[null,0,"Expense","Deschuyteneer","Jorre","Expense","",0,0,0,103.17000000000002]
[null,null,null,"Doens","Inge","Expense","",0,0,0,321.90000000000009]
[null,null,"Expense Total",null,null,null,null,null,null,0,425.07000000000011]
[null,2801275,"Acro 2020-2021","De Jaeger","Delphine","Hulptrainer","Nee",0,10,4,40]
[null,null,null,"Deschuyteneer","Jorre","Trainer","Nee",0,10,9,90]
[null,null,null,"D'Haenens","Caroline","Trainer","Nee",0,5,3,15]
[null,null,null,"Doens","Inge","Trainer","Nee",0,11,11,121]
[null,null,null,"Lenaers","Cedric","Trainer","Nee",0,0,4,0]
[null,null,"Acro 2020-2021 Total",null,null,null,null,null,null,31,266]
[null,3885212,"Basisgroep 1","Bracke","Gaetan","Trainer","Nee",0,10,3,20]
[null,null,null,"Doens","Inge","Trainer","Nee",0,11,14,154]
[null,null,"Basisgroep 1 Total",null,null,null,null,null,null,17,174]
[null,"Grand Total",null,null,null,null,null,null,null,48,865.07000000000016]

{"sheet":"#Trainers","index":7,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Aantal"]
[null,null,null,"ClubGroupID","Groep Naam","Maand","Datum","Weekdag","Start uur","Eind uur","Voornaam","Naam","Statuut","Vervanging","Total"]
[null,null,null,3885212,"Basisgroep 1",8,"01/08/2022","Maandag",null,null,null,null,null,null,1]
[null,null,null,null,null,null,"08/08/2022","Maandag",null,null,null,null,null,null,1]
[null,null,null,null,null,null,"10/08/2022","Woensdag",null,null,null,null,null,null,1]
[null,null,null,null,null,7,"04/07/2022","Maandag",null,null,null,null,null,null,1]
[null,null,null,null,null,null,"06/07/2022","Woensdag",null,null,null,null,null,null,1]
[null,null,null,null,null,null,"10/07/2022","Zondag",null,null,null,null,null,null,1]
[null,null,null,null,null,null,"11/07/2022","Maandag",null,null,null,null,null,null,1]
[null,null,null,2801275,"Acro 2020-2021",8,"01/08/2022","Maandag",null,null,null,null,null,null,2]
[null,null,null,null,null,null,"02/08/2022","Dinsdag",null,null,null,null,null,null,3]
[null,null,null,null,null,null,"07/08/2022","Zondag",null,null,null,null,null,null,1]
[null,null,null,null,null,null,"09/08/2022","Dinsdag",null,null,null,null,null,null,7]
[null,null,null,null,null,null,"14/08/2022","Zondag",null,null,null,null,null,null,1]
[null,null,null,null,null,null,"15/08/2022","Maandag",null,null,null,null,null,null,1]
[null,null,null,"Grand Total",null,null,null,null,null,null,null,null,null,null,22]

{"sheet":"Eigen Opmaak","index":8,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"Iban Nummer","(All)"]
[null,null,null,"e-Mail","(All)"]
[null,null,null,"ClubGroupID","(All)"]
[null,null,null,"Maand","(All)"]
[null,null,null,"Geboortedatum","(All)"]
[null,null,null,"Start uur","(All)"]
[null,null,null,"Federatie Nummer","(All)"]
[null,null,null,"Eind uur","(All)"]
[null,null,null,"Groep Naam","(All)"]
[null,null,null,"Weekdag","(All)"]
[null,null,null,"Datum","(All)"]
[null,null,null,"Vervanging","(All)"]
[null,null,null,"Afgesloten","(All)"]
[null,null,null,"Statuut","(All)"]
[null,null,null,"Aangepast Bedrag","(All)"]
[]
[null,null,null,null,null,null,null,null,null,"Values"]
[null,null,null,"Voornaam","Naam","Onkosten Category","Onkosten bericht","Vaste Kost","Uur Tarief","Sum of Aantal_KM","Sum of Uren","Sum of Totaal","Sum of Origineel Bedrag"]
[null,null,null,"Gaetan","Bracke","","",0,10,0,3,20,30]
[null,null,null,"Caroline","D'Haenens","","",0,5,0,3,15,15]
[null,null,null,"Delphine","De Jaeger","","",0,10,0,4,40,40]
[null,null,null,"Jorre","Deschuyteneer","","",0,10,0,9,90,90]
[null,null,null,null,null,"Aanwezigheid op wedstrijd","sdkjfhsfjk",0,0,0,0,60,60]
[null,null,null,null,null,"Aanwezigheid Jury","sdfsf",0,0,0,0,10,10]
[null,null,null,null,null,"Aankopen","sdfsf",0,0,0,0,0.37,0.37]
[null,null,null,null,null,"Kilometervergoeding","Kilometervergoeding training",0,0,80,0,32.799999999999997,32.799999999999997]
[null,null,null,"Inge","Doens","","",0,11,0,25,275,275]
[null,null,null,null,null,"Aankopen","Aankoop micro (test)",0,0,0,0,75,75]
[null,null,null,null,null,"Kilometervergoeding","Kilometervergoeding training",0,0,350,0,143.49999999999997,143.49999999999997]
[null,null,null,null,null,"Andere","test",0,0,0,0,83.4,83.4]
[null,null,null,null,null,null,"Test upload zip.file",0,0,0,0,20,20]
[null,null,null,"Cedric","Lenaers","","",0,0,0,4,0,0]
[null,null,null,"Grand Total",null,null,null,null,null,430,48,865.07,875.07]

{"sheet":"Data","index":9,"n_rows":9,"n_cols":27,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Statuut","Maand","Onkostenbericht","Onkosten Category","Federatie Nummer","Voornaam","Naam","Iban Nummer","Geboortedatum","e-Mail","ClubGroupID","Groep Naam","Weekdag","Datum","Start uur","Eind uur","Statute","LogStamp","Afgesloten","Uren","Uur Tarief","Vaste Kost","Totaal","Origineel Bedrag","Aangepast Bedrag","Vervanging","Aantal_KM"]
["Trainer",8,"","",202200001,"Voornaam1","Achternaam1","","22/06/1981","naam@gymfed.be",123456,"Basisgroep 1","Maandag","01/08/2022","18:00","21:00","Trainer","2022-08-01T18:02:05.467Z","Nee",3,10,0,20,30,"Ja","Nee",0]
["Expense",8,"sdkjfhsfjk","Aanwezigheid op wedstrijd",202200002,"Voornaam2","Achternaam2","","12/06/1997","naam2@gmail.com",0,"Expense","Dinsdag","16/08/2022","2:00","2:00","","2022-08-16T00:00:00.000Z","Nee",0,0,0,60,60,"Nee","",0]
["Expense",8,"sdfsf","Aanwezigheid Jury",202200003,"Voornaam2","Achternaam2","","12/06/1997","naam2@gmail.com",0,"Expense","Zondag","21/08/2022","2:00","2:00","","2022-08-21T00:00:00.000Z","Nee",0,0,0,10,10,"Nee","",0]
["Expense",8,"sdfsf","Aankopen",202200004,"Voornaam2","Achternaam2","","12/06/1997","naam2@gmail.com",0,"Expense","Zondag","21/08/2022","2:00","2:00","","2022-08-21T00:00:00.000Z","Nee",0,0,0,0.37,0.37,"Nee","",0]
["Expense",8,"Kilometervergoeding training","Kilometervergoeding",202200005,"Voornaam2","Achternaam2","","12/06/1997","naam2@gmail.com",0,"Expense","Maandag","01/08/2022","9:00","9:00","","2022-08-01T07:00:00.000Z","Nee",0,0,0,8.1999999999999993,8.1999999999999993,"Nee","",20]
["Expense",8,"Kilometervergoeding training","Kilometervergoeding",202200006,"Voornaam2","Achternaam2","","12/06/1997","naam2@gmail.com",0,"Expense","Dinsdag","02/08/2022","18:00","18:00","","2022-08-02T16:00:00.000Z","Nee",0,0,0,8.1999999999999993,8.1999999999999993,"Nee","",20]
["Expense",8,"Kilometervergoeding training","Kilometervergoeding",202200007,"Voornaam2","Achternaam2","","12/06/1997","naam2@gmail.com",0,"Expense","Dinsdag","09/08/2022","17:00","17:00","","2022-08-09T15:00:00.000Z","Nee",0,0,0,8.1999999999999993,8.1999999999999993,"Nee","",20]
["Expense",8,"Kilometervergoeding training","Kilometervergoeding",202200008,"Voornaam2","Achternaam2","","12/06/1997","naam2@gmail.com",0,"Expense","Maandag","15/08/2022","9:00","9:00","","2022-08-15T07:00:00.000Z","Nee",0,0,0,8.1999999999999993,8.1999999999999993,"Nee","",20]

{"sheet":"Hoe Data Importeren","index":10,"n_rows":57,"n_cols":3,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
["Exporteer Data"]
[null,null,"Ga in de WebTool naar Rapporten"]
[]
[null,"Selecteer"]
[null,null,"Een Specifieke Maand of Alle Maanden"]
[]
[null,"Vink aan "]
[null,null,"Vink onder Betalingsrapport \"Downloaden\" aan"]
[]
[null,"Download de file via"]
[null,null," \"Bevestig Selectie\""]
[]
[null,"Opgepast"]
[null,null,"Open de file niet. "]
[null,null,"Copieer hem naar de plaats waar je hem wil opslaan zonder hem te openen"]
[]
[]
["Duid aan als Betaald ",null,"Ga in de WebTool naar Rapporten"]
[]
[null,"Selecteer"]
[null,null,"De Maand die je als betaald wil registreren"]
[]
[null,"Vink aan "]
[null,null,"\"Duid aan als betaald\""]
[]
[null,"\"Bevestig Selectie\""]
[null,null,"Zal alle reeds ingegeven onkosten van die maand als bedaald registreren "]
[]
[null,null,"OPGEPAST : Dit is niet omkeerbaar"]
[]
[]
[]
[]
[]
["Importeer de Data"]
[]
[null,null,"Click op \"Data Importeren\" in het tabblad 'Welkom'"]
[]
[]
[null,null,"Selecteer de file die je gedownload hebt"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Refresh Draaitabellen"]
[null,null,"Selecteer toolbar \"Data\" "]
[]
[null,null,"\"Refresh All\""]

{"sheet":"Werken Met Draaitabellen","index":11,"n_rows":46,"n_cols":3,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Draaitabellen"]
[]
[null,"Filter Gegevens"]
[]
[null,null,"Klik op de pijltjes om een of meerdere items te slecteren"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Kolommen Toevoegen"]
[]
[null,null,"Sleep Items van de filter sectie naar de plaats waar je deze wil zien."]
[]
[]
[null,"Kolommen Weghalen "]
[]
[null,null,"Sleep de items naar de filter sectie"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Selecteren via Slicers"]
[]
[null,null,"Selecteer 1 item door erop te klikken"]
[]
[null,null,"Selecteer meerdere items door de CTRL toets in te houden"]
[]
[null,null,"Maak de selectie ongedaan door op het rode kruisje te klikken"]