{"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":26,"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"]
[{"$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/yyyy\")","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/yyyy\")","v":"00/01/1900"},{"$f":"TEXT(Import!K2,\"h:mm\")","v":"0:00"},{"$f":"TEXT(Import!L2,\"h:mm\")","v":"0:00"},{"$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"}]

{"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":15,"n_cols":14,"rows_kept":15,"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":5},{"$f":"GETPIVOTDATA(\"Sum of Totaal\",$D$8)","v":43}]
[]
[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,199900001,"BE32-0001-0001-0001","Voornaam1","Naam1","Expense","Nee",0,8,1,0,8]
[null,null,null,201800001,"BE59-0002-0002-0002","Voornaam2","Naam2","Trainer","Nee",0,10,1,10,10]
[null,null,null,201100001,"BE77-0003-0003-0003","Voornaam3","Naam3","Expense","Nee",0,12,1,12,12]
[null,null,null,200500001,"BE38-0004-0004-0004","Voornaam4","Naam4","Trainer","Nee",0,11,1,11,11]
[null,null,null,199900002,"BE28-0005-0005-0005","Voornaam5","Naam5","Trainer","Nee",0,10,1,10,10]
[null,null,null,"Grand Total",null,null,null,null,null,null,null,5,43,51]

{"sheet":"Per Trainer","index":4,"n_rows":24,"n_cols":21,"rows_kept":24,"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","Vervanging","Afgesloten","Aangepast Bedrag","Vaste Kost","Uur Tarief","Onkosten Category","Onkosten bericht","Sum of Uren","Sum of Totaal","Origineel_Bedrag"]
[null,199900001,"Naam1","Voornaam1",1,"03/01/2021","Zondag","10:00","11:00","Expense","Expense","Nee","Ja","Ja",0,8,"expcat1","expmsg1",1,0,8]
[null,null,null,"Voornaam1 Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,8]
[null,201800001,"Naam2","Voornaam2",1,"03/01/2021","Zondag","10:00","11:00","Basisgroep 1","Trainer","Nee","Ja","Nee",0,10,"",null,1,10,10]
[null,null,null,"Voornaam2 Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,10,10]
[null,201100001,"Naam3","Voornaam3",1,"03/01/2021","Zondag","10:00","11:00","Expense","Expense","Nee","Ja","Nee",0,12,"excat3","expmsg",1,12,12]
[null,null,null,"Voornaam3 Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,12,12]
[null,200500001,"Naam4","Voornaam4",1,"03/01/2021","Zondag","10:00","11:00","Basisgroep 1","Trainer","Nee","Ja","Nee",0,11,"",null,1,11,11]
[null,null,null,"Voornaam4 Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,11,11]
[null,199900002,"Naam5","Voornaam5",1,"03/01/2021","Zondag","10:00","11:00","Basisgroep 1","Trainer","Nee","Ja","Nee",0,10,"",null,1,10,10]
[null,null,null,"Voornaam5 Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,10,10]
[null,"Grand Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,43,51]

{"sheet":"Per Groep","index":5,"n_rows":18,"n_cols":11,"rows_kept":18,"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,1234567,"Basisgroep 1","Naam2","Voornaam2","Trainer","Nee",0,10,1,10]
[null,null,null,"Naam4","Voornaam4","Trainer","Nee",0,11,1,11]
[null,null,null,"Naam5","Voornaam5","Trainer","Nee",0,10,1,10]
[null,null,"Basisgroep 1 Total",null,null,null,null,null,null,3,31]
[null,null,"Expense","Naam1","Voornaam1","Expense","Nee",0,8,1,0]
[null,null,null,"Naam3","Voornaam3","Expense","Nee",0,12,1,12]
[null,null,"Expense Total",null,null,null,null,null,null,2,12]
[null,"Grand Total",null,null,null,null,null,null,null,5,43]

{"sheet":"#Trainers","index":6,"n_rows":15,"n_cols":15,"rows_kept":15,"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,1234567,"Expense",1,"03/01/2021","Zondag","10:00","11:00","Voornaam1","Naam1","Expense","Nee",1]
[null,null,null,null,null,null,null,null,null,null,"Voornaam3","Naam3","Expense","Nee",1]
[null,null,null,null,"Basisgroep 1",1,"03/01/2021","Zondag","10:00","11:00","Voornaam2","Naam2","Trainer","Nee",1]
[null,null,null,null,null,null,null,null,null,null,"Voornaam4","Naam4","Trainer","Nee",1]
[null,null,null,null,null,null,null,null,null,null,"Voornaam5","Naam5","Trainer","Nee",1]
[null,null,null,"Grand Total",null,null,null,null,null,null,null,null,null,null,5]

{"sheet":"Eigen Opmaak","index":7,"n_rows":27,"n_cols":12,"rows_kept":27,"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",1]
[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 Uren","Sum of Totaal","Sum of Origineel Bedrag"]
[null,null,null,"Voornaam1","Naam1","expcat1","expmsg1",0,8,1,0,8]
[null,null,null,"Voornaam2","Naam2","","",0,10,1,10,10]
[null,null,null,"Voornaam3","Naam3","excat3","expmsg",0,12,1,12,12]
[null,null,null,"Voornaam4","Naam4","","",0,11,1,11,11]
[null,null,null,"Voornaam5","Naam5","","",0,10,1,10,10]
[null,null,null,"Grand Total",null,null,null,null,null,5,43,51]

{"sheet":"Data","index":8,"n_rows":6,"n_cols":26,"rows_kept":6,"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"]
["Expense",1,"expmsg1","expcat1",199900001,"Voornaam1","Naam1","BE32-0001-0001-0001","07/10/1982","email1@gymfed.be",1234567,"Expense","Zondag","03/01/2021","10:00","11:00","","2021-01-03T10:18:54.679Z","Ja",1,8,0,0,8,"Ja","Nee"]
["Trainer",1,"","",201800001,"Voornaam2","Naam2","BE59-0002-0002-0002","04/04/1985","email2@gymfed.be",1234567,"Basisgroep 1","Zondag","03/01/2021","10:00","11:00","Trainer","2021-01-03T10:18:54.679Z","Ja",1,10,0,10,10,"Nee","Nee"]
["Expense",1,"expmsg","excat3",201100001,"Voornaam3","Naam3","BE77-0003-0003-0003","27/10/1957","email3@gymfed.be",1234567,"Expense","Zondag","03/01/2021","10:00","11:00","","2021-01-03T10:18:54.679Z","Ja",1,12,0,12,12,"Nee","Nee"]
["Trainer",1,"","",200500001,"Voornaam4","Naam4","BE38-0004-0004-0004","23/02/1967","email4@gymfed.be",1234567,"Basisgroep 1","Zondag","03/01/2021","10:00","11:00","Trainer","2021-01-03T10:19:19.770Z","Ja",1,11,0,11,11,"Nee","Nee"]
["Trainer",1,"","",199900002,"Voornaam5","Naam5","BE28-0005-0005-0005","13/03/1981","email5@gymfed.be",1234567,"Basisgroep 1","Zondag","03/01/2021","10:00","11:00","Trainer","2021-01-03T10:18:54.680Z","Ja",1,10,0,10,10,"Nee","Nee"]

{"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"]