{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Import","Transform","Welkom","Totals","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":9,"comments":0,"pivot_tables":5},"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":23,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Statuut","Maand","Onkostenbericht","FederationNumber","FirstName","LastName","IbanNumber","BirthDate","Email","ClubGroupID","GroupName","DayOfWeek","date","starthour","endhour","statute","logtimestamp","paid","hours","Hourrate","FixedAmount","total","Replacement"]
[{"$f":"IF($K2=\"Expense\",\"Expense\",$P2)","v":0},{"$f":"IFERROR(MONTH(M2),\"\")","v":""},{"$f":"IF($K2=\"Expense\",Import!U2,\"\")","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/1900"},{"$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/1900"},{"$f":"TEXT(Import!K2,\"u:mm\")","v":"0:00"},{"$f":"TEXT(Import!L2,\"u:mm\")","v":"0:00"},{"$f":"IF(K2=\"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":"IF(Import!T2=\"NULL\",\"\",IF(Import!T2,\"Ja\",\"Nee\"))","v":"Nee"}]

{"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 \"Vervanging\" is toegevoegd tot de rapporten. Voor de ingaven vanaf 23/10/2019 en later zal aangegeven worden of het om een vervanging gaat of niet."]
[]
[]
[]
[]
[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":12,"n_cols":13,"rows_kept":12,"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":4},{"$f":"GETPIVOTDATA(\"Sum of Totaal\",$D$8)","v":20}]
[]
[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"]
[null,null,null,20191019,"BE00 0000 0000 0000","Voornaam","Naam","Trainer","",0,5,2,10]
[null,null,null,null,null,null,null,"Hulptrainer","",0,5,2,10]
[null,null,null,"Grand Total",null,null,null,null,null,null,null,4,20]

{"sheet":"Per Trainer","index":4,"n_rows":17,"n_cols":18,"rows_kept":17,"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,"Values"]
[null,"Federatie Nummer","Naam","Voornaam","Maand","Datum","Weekdag","Start uur","Eind uur","Groep Naam","Statuut","Vervanging","Afgesloten","Vaste Kost","Uur Tarief","Onkostenbericht","Sum of Uren","Sum of Totaal"]
[null,20191019,"Naam","Voornaam",10,"02/10/2019","Woensdag","14:00","16:00","Basisgroep 1","Trainer","","Nee",0,5,null,2,10]
[null,null,null,null,6,"19/06/2019","Woensdag","14:00","16:00","Basisgroep 1","Hulptrainer","","Nee",0,5,null,2,10]
[null,null,null,"Voornaam Total",null,null,null,null,null,null,null,null,null,null,null,null,4,20]
[null,"Grand Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,20]

{"sheet":"Per Groep","index":5,"n_rows":14,"n_cols":11,"rows_kept":14,"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,20190001,"Basisgroep 1","Naam","Voornaam","Trainer","",0,5,2,10]
[null,null,null,null,null,"Hulptrainer","",0,5,2,10]
[null,null,"Basisgroep 1 Total",null,null,null,null,null,null,4,20]
[null,"Grand Total",null,null,null,null,null,null,null,4,20]

{"sheet":"#Trainers","index":6,"n_rows":12,"n_cols":15,"rows_kept":12,"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,20190001,"Basisgroep 1",10,"02/10/2019","Woensdag",null,null,null,null,null,null,1]
[null,null,null,null,null,6,"19/06/2019","Woensdag",null,null,null,null,null,null,1]
[null,null,null,"Grand Total",null,null,null,null,null,null,null,null,null,null,2]

{"sheet":"Eigen Opmaak","index":7,"n_rows":23,"n_cols":9,"rows_kept":23,"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,"Onkostenbericht","(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,"Statuut","(All)"]
[null,null,null,"Weekdag","(All)"]
[null,null,null,"Datum","(All)"]
[null,null,null,"Vervanging","(All)"]
[null,null,null,"Afgesloten","(All)"]
[]
[null,null,null,null,null,null,null,"Values"]
[null,null,null,"Voornaam","Naam","Vaste Kost","Uur Tarief","Sum of Uren","Sum of Totaal"]
[null,null,null,"Voornaam","Naam",0,5,4,20]
[null,null,null,"Grand Total",null,null,null,4,20]

{"sheet":"Data","index":8,"n_rows":3,"n_cols":23,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Statuut","Maand","Onkostenbericht","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","Vervanging"]
["Hulptrainer",6,"",20191019,"Voornaam","Naam","BE00 0000 0000 0000","03/10/2000","Sporter@email.com",20190001,"Basisgroep 1","Woensdag","19/06/2019","14:00","16:00","Hulptrainer","2019-08-23T11:14:37.880Z","Nee",2,5,0,10,""]
["Trainer",10,"",20191019,"Voornaam","Naam","BE00 0000 0000 0000","03/10/2000","Sporter@email.com",20190001,"Basisgroep 1","Woensdag","02/10/2019","14:00","16:00","Hulptrainer","2019-10-01T18:16:37.728Z","Nee",2,5,0,10,""]

{"sheet":"Hoe Data Importeren","index":9,"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":10,"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"]