{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Startseite","Kursübersicht","KW-Auswertung","Anwesenheitsübersicht","Kursteilnahmen","Kursvorlagen","Teilnehmer","Einstellungen"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":7},"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":"Startseite","index":0,"n_rows":67,"n_cols":5,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[]
["Stattgefundene Kurse nach Wochentage",null,null,null,"Stattgefundene Kurse nach Wochentage"]
[]
["Hilfsspalte Anzahl Teilnehmer","(Mehrere Elemente)"]
[]
["Teilnehmer","Kurse","Teilnehmer"]
["1900-01-02",1,4]
["1900-01-04",1,2]
["1900-01-05",1,1]
["Gesamtergebnis",3,7]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ausgefallene Kurse nach Wochentage",null,null,null,"Ausgefallene Kurse nach Wochentage"]
[]
["Hilfsspalte Anzahl Teilnehmer",1]
[]
["Teilnehmer","Kurse"]
["1900-01-04",1]
["Gesamtergebnis",1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Stattgefundene Kurse nach Kalenderwochen",null,null,null,"Stattgefundene Kurse nach Kalenderwochen"]
[]
["Hilfsspalte Anzahl Teilnehmer","(Mehrere Elemente)"]
[]
["Teilnehmer","Kurse","Teilnehmer"]
["31. KW (31.07.2017 bis 06.08.2017)",1,1]
["35. KW (28.08.2017 bis 03.09.2017)",2,6]
["Gesamtergebnis",3,7]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Stattgefundene Kurse - Chronologisch",null,null,null,"Stattgefundene Kurse - Chronologisch"]
[]
["Hilfsspalte Anzahl Teilnehmer","(Mehrere Elemente)"]
[]
["Teilnehmer","Kurse","Teilnehmer"]
["03.08.2017",1,1]
["28.08.2017",1,4]
["30.08.2017",1,2]
["Gesamtergebnis",3,7]

{"sheet":"Kursübersicht","index":1,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Hilfsspalte Anzahl Teilnehmer","(Alle)"]
[]
["Teilnehmer","Kursleiter","Ort","Datum","Beginn","Zeit Kategorie","Bemerkung Kurs","Teilnehmer","Kurse"]
[0,null,null,null,null,null,null,0,1]
["Zirkeltraining",null,null,null,null,null,null,0,1]
[3,"Kam Dengler","Turnhalle II","30.08.2017","19:00:00","(Leer)","Kurs aufgefallen, da kein Teilnehmer da.",0,1]
[]
[1,null,null,null,null,null,null,1,1]
["Yoga",null,null,null,null,null,null,1,1]
[2,"Veda Hersey","Outdoor","03.08.2017","18:15:00","(Leer)","(Leer)",1,1]
[]
[2,null,null,null,null,null,null,2,1]
["Yoga",null,null,null,null,null,null,2,1]
[4,"Veda Hersey","Outdoor","30.08.2017","18:15:00","(Leer)","(Leer)",2,1]
[]
[4,null,null,null,null,null,null,4,1]
["Laufen",null,null,null,null,null,null,4,1]
[1,"Joesph Paulos","Outdoor","28.08.2017","09:00:00","(Leer)","Erster Laufkurs zum Kennenlernen",4,1]
[]
["Gesamtergebnis",null,null,null,null,null,null,7,4]

{"sheet":"KW-Auswertung","index":2,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Kurs","Teilnehmeranzahl"]
["31. KW (31.07.2017 bis 06.08.2017)",1]
["Yoga",1]
["18:15:00",1]
["35. KW (28.08.2017 bis 03.09.2017)",6]
["Yoga",2]
["18:15:00",2]
["Zirkeltraining",0]
["19:00:00",0]
["Laufen",4]
["09:00:00",4]
["Gesamtergebnis",7]

{"sheet":"Anwesenheitsübersicht","index":3,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Zeilenbeschriftungen","Kursleiter","Ort","Datum","Beginn","Zeit Kategorie","Bemerkung Kurs","Besuchte Kurse"]
["Amee Indelicato",null,null,null,null,null,null,1]
["Laufen",null,null,null,null,null,null,1]
[1,"Joesph Paulos","Outdoor","28.08.2017","09:00:00","(Leer)","Erster Laufkurs zum Kennenlernen",1]
[]
["Annabell Colyer",null,null,null,null,null,null,2]
["Yoga",null,null,null,null,null,null,1]
[4,"Veda Hersey","Outdoor","30.08.2017","18:15:00","(Leer)","(Leer)",1]
[]
["Laufen",null,null,null,null,null,null,1]
[1,"Joesph Paulos","Outdoor","28.08.2017","09:00:00","(Leer)","Erster Laufkurs zum Kennenlernen",1]
[]
["Cassidy Zeiler",null,null,null,null,null,null,1]
["Laufen",null,null,null,null,null,null,1]
[1,"Joesph Paulos","Outdoor","28.08.2017","09:00:00","(Leer)","Erster Laufkurs zum Kennenlernen",1]
[]
["Precious Mcnemar",null,null,null,null,null,null,3]
["Yoga",null,null,null,null,null,null,2]
[2,"Veda Hersey","Outdoor","03.08.2017","18:15:00","(Leer)","(Leer)",1]
[4,"Veda Hersey","Outdoor","30.08.2017","18:15:00","(Leer)","(Leer)",1]
[]
["Laufen",null,null,null,null,null,null,1]
[1,"Joesph Paulos","Outdoor","28.08.2017","09:00:00","(Leer)","Erster Laufkurs zum Kennenlernen",1]
[]
["Roderick Whitesel ",null,null,null,null,null,null,2]
["Yoga",null,null,null,null,null,null,1]
[2,"Veda Hersey","Outdoor","03.08.2017","18:15:00","(Leer)","(Leer)",1]
[]
["Laufen",null,null,null,null,null,null,1]
[1,"Joesph Paulos","Outdoor","28.08.2017","09:00:00","(Leer)","Erster Laufkurs zum Kennenlernen",1]
[]
["Veda Hersey",null,null,null,null,null,null,2]
["Yoga",null,null,null,null,null,null,1]
[4,"Veda Hersey","Outdoor","30.08.2017","18:15:00","(Leer)","(Leer)",1]
[]
["Zirkeltraining",null,null,null,null,null,null,1]
[3,"Kam Dengler","Turnhalle II","30.08.2017","19:00:00","(Leer)","Kurs aufgefallen, da kein Teilnehmer da.",1]
[]
["Gesamtergebnis",null,null,null,null,null,null,11]

{"sheet":"Kursteilnahmen","index":4,"n_rows":12,"n_cols":27,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["ID","Name","Teilnehmertyp","Geschlecht","Alters-\nkategorie","Leistungs-\nlevel","lfd. Nr. \ndes Kurses","Kurs","Kurs Kategorie","Kursleiter","Ort","Datum","Beginn","Dauer (Min)","Zeit Kategorie","Bemerkung Kurs","Hilfsspalte Count if 1 Teilnehmer","Hilfsspalte Anzahl Teilnehmer","Hilfsspalte Anzahl -1 Teilnehmer","Wochentag","Jahr","Monat","KW","KW-Datum-Start","KW-Datum-Ende","KW-Datum","Hilfsspalte Count Teilnehmer"]
[1,"Cassidy Zeiler","Mitglied","männlich","20-29",8,1,"Laufen","Ausdauer","Joesph Paulos","Outdoor","28.08.2017","09:00:00",45,null,"Erster Laufkurs zum Kennenlernen",{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count Teilnehmer]]=1,1)","v":1},{"$f":"COUNTIF(Tabelle1[lfd. Nr. \ndes Kurses],Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])","v":5},{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count if 1 Teilnehmer]]=1,Tabelle1[[#This Row],[Hilfsspalte Anzahl Teilnehmer]]-1)","v":4},{"$f":"WEEKDAY(Tabelle1[[#This Row],[Datum]])","v":"1900-01-02"},{"$f":"YEAR(Tabelle1[[#This Row],[Datum]])","v":2017},{"$f":"MONTH(Tabelle1[[#This Row],[Datum]])","v":8},{"$f":"WEEKNUM(Tabelle1[[#This Row],[Datum]],)","v":35},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))","v":"2017-08-28"},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))+6","v":"2017-09-03"},{"$f":"IF(Tabelle1[[#This Row],[KW]]<10,\"0\",\"\")&Tabelle1[[#This Row],[KW]]&\". KW (\"&TEXT(X2,\"TT.MM.JJJJ\")&\" bis \"&TEXT(Y2,\"TT.MM.JJJJ\")&\")\"","v":"35. KW (28.08.2017 bis 03.09.2017)"},{"$f":"COUNTIF($G1:G$1, Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])+1","v":1}]
[2,"Amee Indelicato","Gast","weiblich","20-29",6,1,"Laufen","Ausdauer","Joesph Paulos","Outdoor","28.08.2017","09:00:00",45,null,"Erster Laufkurs zum Kennenlernen",{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count Teilnehmer]]=1,1)","v":false},{"$f":"COUNTIF(Tabelle1[lfd. Nr. \ndes Kurses],Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])","v":5},{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count if 1 Teilnehmer]]=1,Tabelle1[[#This Row],[Hilfsspalte Anzahl Teilnehmer]]-1)","v":false},{"$f":"WEEKDAY(Tabelle1[[#This Row],[Datum]])","v":"1900-01-02"},{"$f":"YEAR(Tabelle1[[#This Row],[Datum]])","v":2017},{"$f":"MONTH(Tabelle1[[#This Row],[Datum]])","v":8},{"$f":"WEEKNUM(Tabelle1[[#This Row],[Datum]],)","v":35},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))","v":"2017-08-28"},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))+6","v":"2017-09-03"},{"$f":"IF(Tabelle1[[#This Row],[KW]]<10,\"0\",\"\")&Tabelle1[[#This Row],[KW]]&\". KW (\"&TEXT(X3,\"TT.MM.JJJJ\")&\" bis \"&TEXT(Y3,\"TT.MM.JJJJ\")&\")\"","v":"35. KW (28.08.2017 bis 03.09.2017)"},{"$f":"COUNTIF($G$2:G2, Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])+1","v":2}]
[3,"Precious Mcnemar","Mitglied","weiblich","unter 20",5,1,"Laufen","Ausdauer","Joesph Paulos","Outdoor","28.08.2017","09:00:00",45,null,"Erster Laufkurs zum Kennenlernen",{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count Teilnehmer]]=1,1)","v":false},{"$f":"COUNTIF(Tabelle1[lfd. Nr. \ndes Kurses],Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])","v":5},{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count if 1 Teilnehmer]]=1,Tabelle1[[#This Row],[Hilfsspalte Anzahl Teilnehmer]]-1)","v":false},{"$f":"WEEKDAY(Tabelle1[[#This Row],[Datum]])","v":"1900-01-02"},{"$f":"YEAR(Tabelle1[[#This Row],[Datum]])","v":2017},{"$f":"MONTH(Tabelle1[[#This Row],[Datum]])","v":8},{"$f":"WEEKNUM(Tabelle1[[#This Row],[Datum]],)","v":35},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))","v":"2017-08-28"},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))+6","v":"2017-09-03"},{"$f":"IF(Tabelle1[[#This Row],[KW]]<10,\"0\",\"\")&Tabelle1[[#This Row],[KW]]&\". KW (\"&TEXT(X4,\"TT.MM.JJJJ\")&\" bis \"&TEXT(Y4,\"TT.MM.JJJJ\")&\")\"","v":"35. KW (28.08.2017 bis 03.09.2017)"},{"$f":"COUNTIF($G$2:G3, Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])+1","v":3}]
[4,"Annabell Colyer","Mitglied","weiblich","20-29",4,1,"Laufen","Ausdauer","Joesph Paulos","Outdoor","28.08.2017","09:00:00",45,null,"Erster Laufkurs zum Kennenlernen",{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count Teilnehmer]]=1,1)","v":false},{"$f":"COUNTIF(Tabelle1[lfd. Nr. \ndes Kurses],Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])","v":5},{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count if 1 Teilnehmer]]=1,Tabelle1[[#This Row],[Hilfsspalte Anzahl Teilnehmer]]-1)","v":false},{"$f":"WEEKDAY(Tabelle1[[#This Row],[Datum]])","v":"1900-01-02"},{"$f":"YEAR(Tabelle1[[#This Row],[Datum]])","v":2017},{"$f":"MONTH(Tabelle1[[#This Row],[Datum]])","v":8},{"$f":"WEEKNUM(Tabelle1[[#This Row],[Datum]],)","v":35},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))","v":"2017-08-28"},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))+6","v":"2017-09-03"},{"$f":"IF(Tabelle1[[#This Row],[KW]]<10,\"0\",\"\")&Tabelle1[[#This Row],[KW]]&\". KW (\"&TEXT(X5,\"TT.MM.JJJJ\")&\" bis \"&TEXT(Y5,\"TT.MM.JJJJ\")&\")\"","v":"35. KW (28.08.2017 bis 03.09.2017)"},{"$f":"COUNTIF($G$2:G4, Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])+1","v":4}]
[5,"Roderick Whitesel ","Zehnerkarte","männlich","unter 20",2,1,"Laufen","Ausdauer","Joesph Paulos","Outdoor","28.08.2017","09:00:00",45,null,"Erster Laufkurs zum Kennenlernen",{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count Teilnehmer]]=1,1)","v":false},{"$f":"COUNTIF(Tabelle1[lfd. Nr. \ndes Kurses],Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])","v":5},{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count if 1 Teilnehmer]]=1,Tabelle1[[#This Row],[Hilfsspalte Anzahl Teilnehmer]]-1)","v":false},{"$f":"WEEKDAY(Tabelle1[[#This Row],[Datum]])","v":"1900-01-02"},{"$f":"YEAR(Tabelle1[[#This Row],[Datum]])","v":2017},{"$f":"MONTH(Tabelle1[[#This Row],[Datum]])","v":8},{"$f":"WEEKNUM(Tabelle1[[#This Row],[Datum]],)","v":35},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))","v":"2017-08-28"},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))+6","v":"2017-09-03"},{"$f":"IF(Tabelle1[[#This Row],[KW]]<10,\"0\",\"\")&Tabelle1[[#This Row],[KW]]&\". KW (\"&TEXT(X6,\"TT.MM.JJJJ\")&\" bis \"&TEXT(Y6,\"TT.MM.JJJJ\")&\")\"","v":"35. KW (28.08.2017 bis 03.09.2017)"},{"$f":"COUNTIF($G$2:G5, Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])+1","v":5}]
[6,"Precious Mcnemar","Mitglied","weiblich","unter 20",5,2,"Yoga","Fitness","Veda Hersey","Outdoor","03.08.2017","18:15:00",45,null,null,{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count Teilnehmer]]=1,1)","v":1},{"$f":"COUNTIF(Tabelle1[lfd. Nr. \ndes Kurses],Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])","v":2},{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count if 1 Teilnehmer]]=1,Tabelle1[[#This Row],[Hilfsspalte Anzahl Teilnehmer]]-1)","v":1},{"$f":"WEEKDAY(Tabelle1[[#This Row],[Datum]])","v":"1900-01-05"},{"$f":"YEAR(Tabelle1[[#This Row],[Datum]])","v":2017},{"$f":"MONTH(Tabelle1[[#This Row],[Datum]])","v":8},{"$f":"WEEKNUM(Tabelle1[[#This Row],[Datum]],)","v":31},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))","v":"2017-07-31"},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))+6","v":"2017-08-06"},{"$f":"IF(Tabelle1[[#This Row],[KW]]<10,\"0\",\"\")&Tabelle1[[#This Row],[KW]]&\". KW (\"&TEXT(X7,\"TT.MM.JJJJ\")&\" bis \"&TEXT(Y7,\"TT.MM.JJJJ\")&\")\"","v":"31. KW (31.07.2017 bis 06.08.2017)"},{"$f":"COUNTIF($G$2:G6, Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])+1","v":1}]
[7,"Roderick Whitesel ","Zehnerkarte","männlich","unter 20",2,2,"Yoga","Fitness","Veda Hersey","Outdoor","03.08.2017","18:15:00",45,null,null,{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count Teilnehmer]]=1,1)","v":false},{"$f":"COUNTIF(Tabelle1[lfd. Nr. \ndes Kurses],Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])","v":2},{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count if 1 Teilnehmer]]=1,Tabelle1[[#This Row],[Hilfsspalte Anzahl Teilnehmer]]-1)","v":false},{"$f":"WEEKDAY(Tabelle1[[#This Row],[Datum]])","v":"1900-01-05"},{"$f":"YEAR(Tabelle1[[#This Row],[Datum]])","v":2017},{"$f":"MONTH(Tabelle1[[#This Row],[Datum]])","v":8},{"$f":"WEEKNUM(Tabelle1[[#This Row],[Datum]],)","v":31},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))","v":"2017-07-31"},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))+6","v":"2017-08-06"},{"$f":"IF(Tabelle1[[#This Row],[KW]]<10,\"0\",\"\")&Tabelle1[[#This Row],[KW]]&\". KW (\"&TEXT(X8,\"TT.MM.JJJJ\")&\" bis \"&TEXT(Y8,\"TT.MM.JJJJ\")&\")\"","v":"31. KW (31.07.2017 bis 06.08.2017)"},{"$f":"COUNTIF($G$2:G7, Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])+1","v":2}]
[8,"Veda Hersey","Kursleiter","weiblich","30-39",10,3,"Zirkeltraining","Fitness","Kam Dengler","Turnhalle II","30.08.2017","19:00:00",60,null,"Kurs aufgefallen, da kein Teilnehmer da.",{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count Teilnehmer]]=1,1)","v":1},{"$f":"COUNTIF(Tabelle1[lfd. Nr. \ndes Kurses],Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])","v":1},{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count if 1 Teilnehmer]]=1,Tabelle1[[#This Row],[Hilfsspalte Anzahl Teilnehmer]]-1)","v":0},{"$f":"WEEKDAY(Tabelle1[[#This Row],[Datum]])","v":"1900-01-04"},{"$f":"YEAR(Tabelle1[[#This Row],[Datum]])","v":2017},{"$f":"MONTH(Tabelle1[[#This Row],[Datum]])","v":8},{"$f":"WEEKNUM(Tabelle1[[#This Row],[Datum]],)","v":35},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))","v":"2017-08-28"},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))+6","v":"2017-09-03"},{"$f":"IF(Tabelle1[[#This Row],[KW]]<10,\"0\",\"\")&Tabelle1[[#This Row],[KW]]&\". KW (\"&TEXT(X9,\"TT.MM.JJJJ\")&\" bis \"&TEXT(Y9,\"TT.MM.JJJJ\")&\")\"","v":"35. KW (28.08.2017 bis 03.09.2017)"},{"$f":"COUNTIF($G$2:G8, Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])+1","v":1}]
[9,"Veda Hersey","Kursleiter","weiblich","30-39",10,4,"Yoga","Fitness","Veda Hersey","Outdoor","30.08.2017","18:15:00",45,null,null,{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count Teilnehmer]]=1,1)","v":1},{"$f":"COUNTIF(Tabelle1[lfd. Nr. \ndes Kurses],Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])","v":3},{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count if 1 Teilnehmer]]=1,Tabelle1[[#This Row],[Hilfsspalte Anzahl Teilnehmer]]-1)","v":2},{"$f":"WEEKDAY(Tabelle1[[#This Row],[Datum]])","v":"1900-01-04"},{"$f":"YEAR(Tabelle1[[#This Row],[Datum]])","v":2017},{"$f":"MONTH(Tabelle1[[#This Row],[Datum]])","v":8},{"$f":"WEEKNUM(Tabelle1[[#This Row],[Datum]],)","v":35},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))","v":"2017-08-28"},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))+6","v":"2017-09-03"},{"$f":"IF(Tabelle1[[#This Row],[KW]]<10,\"0\",\"\")&Tabelle1[[#This Row],[KW]]&\". KW (\"&TEXT(X10,\"TT.MM.JJJJ\")&\" bis \"&TEXT(Y10,\"TT.MM.JJJJ\")&\")\"","v":"35. KW (28.08.2017 bis 03.09.2017)"},{"$f":"COUNTIF($G$2:G9, Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])+1","v":1}]
[10,"Annabell Colyer","Mitglied","weiblich","20-29",4,4,"Yoga","Fitness","Veda Hersey","Outdoor","30.08.2017","18:15:00",45,null,null,{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count Teilnehmer]]=1,1)","v":false},{"$f":"COUNTIF(Tabelle1[lfd. Nr. \ndes Kurses],Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])","v":3},{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count if 1 Teilnehmer]]=1,Tabelle1[[#This Row],[Hilfsspalte Anzahl Teilnehmer]]-1)","v":false},{"$f":"WEEKDAY(Tabelle1[[#This Row],[Datum]])","v":"1900-01-04"},{"$f":"YEAR(Tabelle1[[#This Row],[Datum]])","v":2017},{"$f":"MONTH(Tabelle1[[#This Row],[Datum]])","v":8},{"$f":"WEEKNUM(Tabelle1[[#This Row],[Datum]],)","v":35},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))","v":"2017-08-28"},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))+6","v":"2017-09-03"},{"$f":"IF(Tabelle1[[#This Row],[KW]]<10,\"0\",\"\")&Tabelle1[[#This Row],[KW]]&\". KW (\"&TEXT(X11,\"TT.MM.JJJJ\")&\" bis \"&TEXT(Y11,\"TT.MM.JJJJ\")&\")\"","v":"35. KW (28.08.2017 bis 03.09.2017)"},{"$f":"COUNTIF($G$2:G10, Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])+1","v":2}]
[11,"Precious Mcnemar","Mitglied","weiblich","unter 20",5,4,"Yoga","Fitness","Veda Hersey","Outdoor","30.08.2017","18:15:00",45,null,null,{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count Teilnehmer]]=1,1)","v":false},{"$f":"COUNTIF(Tabelle1[lfd. Nr. \ndes Kurses],Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])","v":3},{"$f":"IF(Tabelle1[[#This Row],[Hilfsspalte Count if 1 Teilnehmer]]=1,Tabelle1[[#This Row],[Hilfsspalte Anzahl Teilnehmer]]-1)","v":false},{"$f":"WEEKDAY(Tabelle1[[#This Row],[Datum]])","v":"1900-01-04"},{"$f":"YEAR(Tabelle1[[#This Row],[Datum]])","v":2017},{"$f":"MONTH(Tabelle1[[#This Row],[Datum]])","v":8},{"$f":"WEEKNUM(Tabelle1[[#This Row],[Datum]],)","v":35},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))","v":"2017-08-28"},{"$f":"DATE(Tabelle1[[#This Row],[Jahr]],1,7*Tabelle1[[#This Row],[KW]]-3-WEEKDAY(DATE(Tabelle1[[#This Row],[Jahr]],,),3))+6","v":"2017-09-03"},{"$f":"IF(Tabelle1[[#This Row],[KW]]<10,\"0\",\"\")&Tabelle1[[#This Row],[KW]]&\". KW (\"&TEXT(X12,\"TT.MM.JJJJ\")&\" bis \"&TEXT(Y12,\"TT.MM.JJJJ\")&\")\"","v":"35. KW (28.08.2017 bis 03.09.2017)"},{"$f":"COUNTIF($G$2:G11, Tabelle1[[#This Row],[lfd. Nr. \ndes Kurses]])+1","v":3}]

{"sheet":"Kursvorlagen","index":5,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["ID","Kursname","Kategorie","Kursleiter","Kursort","Tag","Beginn","Dauer","Bemerkung"]
[1,"Aktive Mittagspause","Health","Joesph Paulos","Büro in Essen","Dienstag","00:00:00",30]
[2,"Bodypower","Fitness","Kam Dengler","Turnhalle II","Donnerstag","14:00:00",45]
[3,"Box-Workout","Fitness","Kam Dengler","Turnhalle II","Mittwoch","14:00:00",45]
[4,"Martial Arts","Fitness","Carmen Uecker","Turnhalle I","Dienstag","13:00:00",90]
[5,"Indoor-Cycling","Ausdauer","Corrinne Zoller","Turnhalle I","Mittwoch","09:00:00",60]
[6,"Laufen","Ausdauer","Joesph Paulos","Outdoor","Montag","09:00:00",60]
[7,"Yoga","Fitness","Veda Hersey","Outdoor","Donnerstag","18:15:00",45]
[8,"Pilates","Fitness","Corrinne Zoller","Turnhalle I","Donnerstag","11:00:00",45]
[9,"Zirkeltraining","Fitness","Kam Dengler","Turnhalle II","Mittwoch","19:00:00",60]
[10,"Gesunde Ernährung","Health","Joesph Paulos","Büro in Essen","Sonntag","19:00:00",60]

{"sheet":"Teilnehmer","index":6,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["ID","Name","Typ","Geschlecht","Alterskategorie","Leistungslevel","Bemerkung"]
[1,"Cassidy Zeiler","Mitglied","männlich","20-29",8,"Engagiert"]
[2,"Amee Indelicato","Gast","weiblich","20-29",6]
[3,"Precious Mcnemar","Mitglied","weiblich","unter 20",5]
[4,"Annabell Colyer","Mitglied","weiblich","20-29",4]
[5,"Roderick Whitesel ","Zehnerkarte","männlich","unter 20",2]
[6,"Joesph Paulos","Kursleiter","männlich","20-29",10,"Zertifikat B-Lizenz"]
[7,"Veda Hersey","Kursleiter","weiblich","30-39",10]

{"sheet":"Einstellungen","index":7,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Teilnehmertyp",null,"Alter",null,"Wochentage",null,"Leistungelevel"]
[null,"Schnuppertraining",null,"unter 20",null,"Montag",null,1]
[null,"Mitglied",null,"20-29",null,"Dienstag",null,2]
[null,"Zehnerkarte",null,"30-39",null,"Mittwoch",null,3]
[null,"Gast",null,"40-49",null,"Donnerstag",null,4]
[null,"Kursleiter",null,"50-60",null,"Freitag",null,5]
[null,null,null,"über 60",null,"Samstag",null,6]
[null,null,null,null,null,"Sonntag",null,7]
[null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,10]