{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Import","Transform","Welkom","Bezetting Zaal","Eigen Opmaak","Data","Hoe Data Importeren","Werken Met Draaitabellen"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":1,"defined_names":10,"comments":0,"pivot_tables":3},"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":49,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["FederationNumber","FirstName","LastName","BirthDate","Email","ClubGroupID","GroupName","DayOfWeek","date","starthour","endhour","logtimestamp","attendance","attendancedetail","Role","Location","Maand","Week","Aanwezig","Uren","08:00:00","08:30:00","09:00:00","09:30:00","10:00:00","10:30:00","11:00:00","11:30:00","12:00:00","12:30:00","13:00:00","13:30:00","14:00:00","14:30:00","15:00:00","15:30:00","16:00:00","16:30:00","17:00:00","17:30:00","18:00:00","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00"]
[{"$f":"TRIM(PROPER(Import!A2))","v":""},{"$f":"TRIM(PROPER(Import!B2))","v":""},{"$f":"TRIM(PROPER(Import!C2))","v":""},{"$f":"TEXT(Import!D2,\"dd/mm/jjjj\")","v":"00/01/jjjj"},{"$f":"TRIM(LOWER(Import!E2))","v":""},{"$f":"TRIM(TEXT(Import!F2,0))","v":"0"},{"$f":"TRIM(PROPER(Import!G2))","v":""},{"$f":"TRIM(PROPER(Import!H2))","v":""},{"$f":"TEXT(Import!I2,\"dd/mm/jjjj\")","v":"00/01/jjjj"},{"$f":"Import!J2","v":"00:00:00"},{"$f":"Import!K2","v":"00:00:00"},{"$f":"TRIM(Import!L2)","v":""},{"$f":"TRIM(PROPER(Import!M2))","v":""},{"$f":"TRIM(PROPER(Import!N2))","v":""},{"$f":"TRIM(PROPER(Import!O2))","v":""},{"$f":"TRIM(PROPER(Import!P2))","v":""},{"$f":"IFERROR(MONTH(Import!I2),\"\")","v":1},{"$f":"IFERROR(WEEKNUM(Import!I2,11),\"\")","v":1},{"$f":"IF(M2,1,0)","v":{"$error":"#VALUE!"}},{"$f":"CONVERT((+K2-J2),\"day\",\"hr\")","v":0},{"$f":"IF(AND(U$1>=$J2,U$1<$K2),$S2,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]

{"sheet":"Welkom","index":2,"n_rows":17,"n_cols":17,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"OPMERKING : Er zijn twee nieuwe velden toegevoegd tot het rapport"]
[null,null,null,null,"Location"]
[null,null,null,null,"Reden van Afwezigheid"]
[]
[]
[]
[null,null,"Verschillende Rapporten"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hier kan je zelf uw draaitabel samen stellen."]
[null,null,null,null,null,null,null,"Hier vind je de effectieve bezetting van de zaal per uur",null,null,null,null,null,null,null,null,"* zie hiervoor werken met draaitabellen"]
[]
[]
[]
[null,null,"Procedures"]

{"sheet":"Bezetting Zaal","index":3,"n_rows":38,"n_cols":20,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,null,null,10,"Geef aan vanaf hoeveel sporters het aantal te hoog zit"]
[]
[]
[]
[]
[]
[null,null,null,"Effectieve Aanwezigheid",null,null,null,null,null,null,null,null,null,null,"Aantal als iedereen aanwezig is"]
[null,null,null,null,"DayOfWeek",null,null,null,null,null,null,null,null,null,null,"DayOfWeek"]
[null,null,null,"Values","Maandag","Dinsdag","Woensdag","Donderdag","Vrijdag",null,null,null,null,null,"Values","Maandag","Dinsdag","Woensdag","Donderdag","Vrijdag"]
[null,null,null," 08h00",0,0,0,0,0,null,null,null,null,null," 08h00",0,0,0,0,0]
[null,null,null," 08h30",0,0,0,0,0,null,null,null,null,null," 08h30",0,0,0,0,0]
[null,null,null," 09h00",0,0,0,1,0,null,null,null,null,null," 09h00",0,0,1,1,0]
[null,null,null," 09h30",0,0,0,1,0,null,null,null,null,null," 09h30",0,0,1,1,0]
[null,null,null," 10h00",0,0,0,1,0,null,null,null,null,null," 10h00",0,0,1,1,0]
[null,null,null," 10h30",0,0,0,1,0,null,null,null,null,null," 10h30",0,0,1,1,0]
[null,null,null," 11h00",0,0,0,1,0,null,null,null,null,null," 11h00",0,0,1,1,0]
[null,null,null," 11h30",0,0,0,1,0,null,null,null,null,null," 11h30",0,0,1,1,0]
[null,null,null," 12h00",0,0,0,1,0,null,null,null,null,null," 12h00",0,0,1,1,0]
[null,null,null," 12h30",0,0,0,0,0,null,null,null,null,null," 12h30",0,0,0,0,0]
[null,null,null," 13h00",0,1,0,0,0,null,null,null,null,null," 13h00",1,1,0,0,0]
[null,null,null," 13h30",0,1,0,0,0,null,null,null,null,null," 13h30",1,1,0,0,0]
[null,null,null," 14h00",0,1,0,0,0,null,null,null,null,null," 14h00",1,1,0,0,0]
[null,null,null," 14h30",0,1,0,0,0,null,null,null,null,null," 14h30",1,1,0,0,0]
[null,null,null," 15h00",0,1,0,0,0,null,null,null,null,null," 15h00",1,1,0,0,0]
[null,null,null," 15h30",0,1,0,0,0,null,null,null,null,null," 15h30",1,1,0,0,0]
[null,null,null," 16h00",0,1,0,0,0,null,null,null,null,null," 16h00",1,1,0,0,0]
[null,null,null," 16h30",1,0,0,0,0,null,null,null,null,null," 16h30",1,0,0,0,0]
[null,null,null," 17h00",1,1,1,1,1,null,null,null,null,null," 17h00",1,1,1,1,2]
[null,null,null," 17h30",1,1,1,1,1,null,null,null,null,null," 17h30",1,1,1,1,2]
[null,null,null," 18h00",1,1,1,1,1,null,null,null,null,null," 18h00",1,1,1,1,2]
[null,null,null," 18h30",1,1,1,1,1,null,null,null,null,null," 18h30",1,1,1,1,2]
[null,null,null," 19h00",1,1,1,1,1,null,null,null,null,null," 19h00",1,1,1,1,2]
[null,null,null," 19h30",0,0,0,0,0,null,null,null,null,null," 19h30",0,0,0,0,0]
[null,null,null," 20h00",0,0,0,0,0,null,null,null,null,null," 20h00",0,0,0,0,0]
[null,null,null," 20h30",0,0,0,0,0,null,null,null,null,null," 20h30",0,0,0,0,0]
[null,null,null," 21h00",0,0,0,0,0,null,null,null,null,null," 21h00",0,0,0,0,0]
[null,null,null," 21h30",0,0,0,0,0,null,null,null,null,null," 21h30",0,0,0,0,0]
[null,null,null," 22h00",0,0,0,0,0,null,null,null,null,null," 22h00",0,0,0,0,0]

{"sheet":"Eigen Opmaak","index":4,"n_rows":15,"n_cols":20,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,"attendance","(All)"]
[]
[null,null,null,"Sum of Aanwezig",null,null,null,"Maand","Week","DayOfWeek"]
[null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,33,null,null,null,35,null,null,null,34]
[null,null,null,"GroupName","Role","FirstName","LastName","Dinsdag","Maandag","Woensdag","Donderdag","Dinsdag","Zondag","Maandag","Woensdag","Dinsdag","Maandag","Woensdag","Donderdag","Vrijdag"]
[null,null,null,"A10/A11/A12","Gymnast","voornaam2","Naam2",0,0,0,0,1,1,1,1,0,0,0,0,1]
[null,null,null,null,"Gymnast Total",null,null,0,0,0,0,1,1,1,1,0,0,0,0,1]
[null,null,null,null,"Trainer","voornaam1","Naam1",1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Trainer Total",null,null,1,1,1,1,1,1,1,1,1,1,1,1,1]

{"sheet":"Data","index":5,"n_rows":27,"n_cols":49,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["FederationNumber","FirstName","LastName","BirthDate","Email","ClubGroupID","GroupName","DayOfWeek","date","starthour","endhour","logtimestamp","attendance","Reden van Afwezigheid","Role","Location","Maand","Week","Aanwezig","Uren","08:00","08:30","09:00","09:30","10:00","10:30","11:00","11:30","12:00","12:30","13:00","13:30","14:00","14:30","15:00","15:30","16:00","16:30","17:00","17:30","18:00","18:30","19:00","19:30","20:00","20:30","21:00","21:30","22:00"]
["200614992","voornaam1","Naam1","10/09/1992","naam1@gmail.com","3882327","A10/A11/A12","Maandag","10/08/2020","17:00:00","19:30:00","2020-08-20T11:31:11.211Z","True","Null","Trainer","Turnhal Nazareth",8,33,1,2.4999999999999991,"","","","","","","","","","","","","","","","","","",0,0,0,0,0,"","","","","",""]
["200614992","voornaam1","Naam1","10/09/1992","naam1@gmail.com","3882327","A10/A11/A12","Dinsdag","11/08/2020","17:00:00","19:30:00","2020-08-20T11:32:02.665Z","True","Null","Trainer","Turnhal Nazareth",8,33,1,2.4999999999999991,"","","","","","","","","","","","","","","","","","",1,1,1,1,1,"","","","","",""]
["200614992","voornaam1","Naam1","10/09/1992","naam1@gmail.com","3882327","A10/A11/A12","Woensdag","12/08/2020","13:00:00","16:30:00","2020-08-20T11:32:50.304Z","True","Null","Trainer","Turnhal Nazareth",8,33,1,3.5000000000000009,"","","","","","","","","","","","","","","","","","",0,0,0,0,0,"","","","","",""]
["200614992","voornaam1","Naam1","10/09/1992","naam1@gmail.com","3882327","A10/A11/A12","Donderdag","13/08/2020","08:45:00","12:15:00","2020-08-20T11:33:59.121Z","True","Null","Trainer","Null",8,33,1,3.4999999999999996,"","","","","","","","","","","","","","","","","","",1,1,1,1,1,"","","","","",""]
["200614992","voornaam1","Naam1","10/09/1992","naam1@gmail.com","3882327","A10/A11/A12","Maandag","17/08/2020","17:00:00","19:30:00","2020-08-20T11:34:38.135Z","True","Null","Trainer","Turnhal Nazareth",8,34,1,2.4999999999999991,"","","","","","","","","","",0,0,0,0,0,0,0,"","","","","","","","","","","",""]
["200614992","voornaam1","Naam1","10/09/1992","naam1@gmail.com","3882327","A10/A11/A12","Dinsdag","18/08/2020","17:00:00","19:30:00","2020-08-20T11:35:12.424Z","True","Null","Trainer","Turnhal Nazareth",8,34,1,2.4999999999999991,"","","","","","","","","","",1,1,1,1,1,1,1,"","","","","","","","","","","",""]
["200614992","voornaam1","Naam1","10/09/1992","naam1@gmail.com","3882327","A10/A11/A12","Woensdag","19/08/2020","13:00:00","16:30:00","2020-08-20T11:36:01.569Z","True","Null","Trainer","Turnhal Nazareth",8,34,1,3.5000000000000009,"","",0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","","","",""]
["200614992","voornaam1","Naam1","10/09/1992","naam1@gmail.com","3882327","A10/A11/A12","Donderdag","20/08/2020","15:30:00","19:00:00","2020-08-24T06:03:03.856Z","True","Null","Trainer","Null",8,34,1,3.4999999999999978,"","",1,1,1,1,1,1,1,"","","","","","","","","","","","","","","","","","","",""]
["200614992","voornaam1","Naam1","10/09/1992","naam1@gmail.com","3882327","A10/A11/A12","Vrijdag","21/08/2020","16:15:00","19:15:00","2020-08-24T06:02:31.237Z","True","Null","Trainer","Turnhal Nazareth",8,34,1,3,"","","","","","","","","","","","","","","","","","",0,0,0,0,0,"","","","","",""]
["200614992","voornaam1","Naam1","10/09/1992","naam1@gmail.com","3882327","A10/A11/A12","Maandag","24/08/2020","17:00:00","19:30:00","2020-08-26T19:44:01.007Z","True","Null","Trainer","Sporthal Nazareth",8,35,1,2.4999999999999991,"","","","","","","","","","","","","","","","","","",1,1,1,1,1,"","","","","",""]
["200614992","voornaam1","Naam1","10/09/1992","naam1@gmail.com","3882327","A10/A11/A12","Dinsdag","25/08/2020","17:00:00","19:30:00","2020-08-26T19:43:04.783Z","True","Null","Trainer","Turnhal Nazareth",8,35,1,2.4999999999999991,"","","","","","","","","","","","","","","","","","",0,0,0,0,0,"","","","","",""]
["200614992","voornaam1","Naam1","10/09/1992","naam1@gmail.com","3882327","A10/A11/A12","Woensdag","26/08/2020","13:00:00","16:30:00","2020-08-31T12:06:00.411Z","True","Null","Trainer","Turnhal Nazareth",8,35,1,3.5000000000000009,"","","","","","","","","","","","","","","","","","",1,1,1,1,1,"","","","","",""]
["200614992","voornaam1","Naam1","10/09/1992","naam1@gmail.com","3882327","A10/A11/A12","Zondag","30/08/2020","16:00:00","19:00:00","2020-08-31T12:05:25.204Z","True","Null","Trainer","Sporthal Nazareth",8,35,1,3,"","","","","","","","","","",0,0,0,0,0,0,0,"","","","","","","","","","","",""]
["201321974","voornaam2","Naam2","06/01/2011","Naam2@telenet.be","3882327","A10/A11/A12","Maandag","10/08/2020","17:00:00","19:30:00","2020-08-20T11:31:11.211Z","False","Aanwezig","Gymnast","Turnhal Nazareth",8,33,0,2.4999999999999991,"","","","","","","","","","",1,1,1,1,1,1,1,"","","","","","","","","","","",""]
["201321974","voornaam2","Naam2","06/01/2011","Naam2@telenet.be","3882327","A10/A11/A12","Dinsdag","11/08/2020","17:00:00","19:30:00","2020-08-20T11:32:02.665Z","False","Aanwezig","Gymnast","Turnhal Nazareth",8,33,0,2.4999999999999991,"","","","","","","","","","","","","","","",0,0,0,0,0,0,0,"","","","","","",""]
["201321974","voornaam2","Naam2","06/01/2011","Naam2@telenet.be","3882327","A10/A11/A12","Woensdag","12/08/2020","13:00:00","16:30:00","2020-08-20T11:32:50.304Z","False","Aanwezig","Gymnast","Turnhal Nazareth",8,33,0,3.5000000000000009,"","","","","","","","","","","","","","","",1,1,1,1,1,1,1,"","","","","","",""]
["201321974","voornaam2","Naam2","06/01/2011","Naam2@telenet.be","3882327","A10/A11/A12","Donderdag","13/08/2020","08:45:00","12:15:00","2020-08-20T11:33:59.121Z","False","Aanwezig","Gymnast","Null",8,33,0,3.4999999999999996,"","","","","","","","","","","","","","","","","",1,1,1,1,1,1,"","","","","",""]
["201321974","voornaam2","Naam2","06/01/2011","Naam2@telenet.be","3882327","A10/A11/A12","Maandag","17/08/2020","17:00:00","19:30:00","2020-08-20T11:34:38.135Z","False","Aanwezig","Gymnast","Turnhal Nazareth",8,34,0,2.4999999999999991,"","","","","","","","","","","","","","","","","",1,1,1,1,1,1,"","","","","",""]
["201321974","voornaam2","Naam2","06/01/2011","Naam2@telenet.be","3882327","A10/A11/A12","Dinsdag","18/08/2020","17:00:00","19:30:00","2020-08-20T11:35:12.424Z","False","Aanwezig","Gymnast","Turnhal Nazareth",8,34,0,2.4999999999999991,"","","","","","","","","","","","","","","","","","",1,1,1,1,1,"","","","","",""]
["201321974","voornaam2","Naam2","06/01/2011","Naam2@telenet.be","3882327","A10/A11/A12","Woensdag","19/08/2020","13:00:00","16:30:00","2020-08-20T11:36:01.569Z","False","Aanwezig","Gymnast","Turnhal Nazareth",8,34,0,3.5000000000000009,"","","","","","","","","","","","","","","","","","",1,1,1,1,1,"","","","","",""]
["201321974","voornaam2","Naam2","06/01/2011","Naam2@telenet.be","3882327","A10/A11/A12","Donderdag","20/08/2020","15:30:00","19:00:00","2020-08-24T06:03:03.856Z","False","Aanwezig","Gymnast","Null",8,34,0,3.4999999999999978,"","","","","","","","","","","","","","","","","","",1,1,1,1,1,"","","","","",""]
["201321974","voornaam2","Naam2","06/01/2011","Naam2@telenet.be","3882327","A10/A11/A12","Vrijdag","21/08/2020","16:15:00","19:15:00","2020-08-24T06:02:31.237Z","True","Aanwezig","Gymnast","Turnhal Nazareth",8,34,1,3,"","","","","","","","","","","","","","","","","","",1,1,1,1,1,"","","","","",""]
["201321974","voornaam2","Naam2","06/01/2011","Naam2@telenet.be","3882327","A10/A11/A12","Maandag","24/08/2020","17:00:00","19:30:00","2020-08-26T19:44:01.007Z","True","Aanwezig","Gymnast","Sporthal Nazareth",8,35,1,2.4999999999999991,"","","","","","","","","","",1,1,1,1,1,1,1,"","","","","","","","","","","",""]
["201321974","voornaam2","Naam2","06/01/2011","Naam2@telenet.be","3882327","A10/A11/A12","Dinsdag","25/08/2020","17:00:00","19:30:00","2020-08-26T19:43:04.783Z","True","Aanwezig","Gymnast","Turnhal Nazareth",8,35,1,2.4999999999999991,"","","","","","","","","","",1,1,1,1,1,1,1,"","","","","","","","","","","",""]
["201321974","voornaam2","Naam2","06/01/2011","Naam2@telenet.be","3882327","A10/A11/A12","Woensdag","26/08/2020","13:00:00","16:30:00","2020-08-31T12:06:00.411Z","True","Aanwezig","Gymnast","Turnhal Nazareth",8,35,1,3.5000000000000009,"","","","","","","","","","","","","","","","",1,1,1,1,1,1,"","","","","","",""]
["201321974","voornaam2","Naam2","06/01/2011","Naam2@telenet.be","3882327","A10/A11/A12","Zondag","30/08/2020","16:00:00","19:00:00","2020-08-31T12:05:25.204Z","True","Aanwezig","Gymnast","Sporthal Nazareth",8,35,1,3,"","","","","","","","","","","","","","","","",1,1,1,1,1,1,"","","","","","",""]

{"sheet":"Hoe Data Importeren","index":6,"n_rows":34,"n_cols":9,"rows_kept":34,"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 Aanwezigheidsrapport \"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"]
[]
[]
[]
[]
["Importeer de Data"]
[]
[null,null,"Click op \"Data Importeren\" in de welcome sheet"]
[null,null,null,null,null,null,null,null,"Dit kan eventjes duren"]
[null,null,null,null,null,null,null,null,"Wacht tot je terug op de Welkom sheet terecht komt"]
[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":7,"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 selecteren"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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"]