{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Makro aktivieren","Trainerabrechnung","Ohne Lizenz","C-Lizenz","B-Lizenz","Markus Römer","Bernd Schneider","Hilfstabelle"],"not_rendered":{"images":3,"macros":1,"external_links":2,"defined_names":92},"read":"whole","date_system":"1900"}

{"sheet":"Makro aktivieren","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Trainerabrechnung","index":1,"n_rows":18,"n_cols":3,"rows_kept":18,"hidden":true,"merged":[[0,1,2,9],[5,1,5,4],[17,2,17,3]]}
[null,"Trainerabrechnung"]
[]
[]
[]
[]
[null,"1. Judo-Club Nieder-Roden/Rodgau e.V."]
{"$rows_empty":11}
[null,null,"Verfügbare Tabellen"]

{"sheet":"Ohne Lizenz","index":2,"n_rows":46,"n_cols":9,"rows_kept":46,"hidden":true,"merged":[[0,3,0,6],[2,3,2,6],[4,3,4,5],[6,0,6,1],[6,2,6,3],[6,4,6,5],[7,0,7,1],[7,2,7,3],[7,4,7,5],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[43,2,43,5],[44,2,44,5],[45,0,45,8]]}
["Abteilung :"]
[]
["ÜL / Trainer :"]
[]
["Abrechnungsmonat :",null,null,1,null,null,2017]
[]
["Tag",null,"        Trainingszeit",null,"Stunden",null,"Stunden",null,"Std.-Satz"]
["im Monat",null,"       von  -->  bis",null,"am Tag",null,"im Monat",null,{"v":7,"d":"7.00 €"}]
[]
[{"$f":"DATE($G$5,$D$5,1)","v":"2017-01-01"},null,null,"Uhr",null,"Std.",{"$f":"IF(E10=\"\",\"\",SUM(E10))","v":""},"Std.",{"$f":"IF(E10=\"\",\"\",SUM($I$8*E10))","v":""}]
[{"$f":"A10+1","v":"2017-01-02"},null,null,"Uhr",null,"Std.",{"$f":"IF(E11=\"\",\"\",SUM($E$10:E11))","v":""},"Std.",""]
["2017-01-03",null,null,"Uhr",null,"Std.",{"$f":"IF(E12=\"\",\"\",SUM($E$10:E12))","v":""},"Std.",""]
["2017-01-04",null,null,"Uhr",null,"Std.",{"$f":"IF(E13=\"\",\"\",SUM($E$10:E13))","v":""},"Std.",""]
["2017-01-05",null,null,"Uhr",null,"Std.",{"$f":"IF(E14=\"\",\"\",SUM($E$10:E14))","v":""},"Std.",""]
["2017-01-06",null,null,"Uhr",null,"Std.",{"$f":"IF(E15=\"\",\"\",SUM($E$10:E15))","v":""},"Std.",""]
["2017-01-07",null,null,"Uhr",null,"Std.",{"$f":"IF(E16=\"\",\"\",SUM($E$10:E16))","v":""},"Std.",""]
["2017-01-08",null,null,"Uhr",null,"Std.",{"$f":"IF(E17=\"\",\"\",SUM($E$10:E17))","v":""},"Std.",""]
["2017-01-09",null,null,"Uhr",null,"Std.",{"$f":"IF(E18=\"\",\"\",SUM($E$10:E18))","v":""},"Std.",""]
["2017-01-10",null,null,"Uhr",null,"Std.",{"$f":"IF(E19=\"\",\"\",SUM($E$10:E19))","v":""},"Std.",""]
["2017-01-11",null,null,"Uhr",null,"Std.",{"$f":"IF(E20=\"\",\"\",SUM($E$10:E20))","v":""},"Std.",""]
["2017-01-12",null,null,"Uhr",null,"Std.",{"$f":"IF(E21=\"\",\"\",SUM($E$10:E21))","v":""},"Std.",""]
["2017-01-13",null,null,"Uhr",null,"Std.",{"$f":"IF(E22=\"\",\"\",SUM($E$10:E22))","v":""},"Std.",""]
["2017-01-14",null,null,"Uhr",null,"Std.",{"$f":"IF(E23=\"\",\"\",SUM($E$10:E23))","v":""},"Std.",""]
["2017-01-15",null,null,"Uhr",null,"Std.",{"$f":"IF(E24=\"\",\"\",SUM($E$10:E24))","v":""},"Std.",""]
["2017-01-16",null,null,"Uhr",null,"Std.",{"$f":"IF(E25=\"\",\"\",SUM($E$10:E25))","v":""},"Std.",""]
["2017-01-17",null,null,"Uhr",null,"Std.",{"$f":"IF(E26=\"\",\"\",SUM($E$10:E26))","v":""},"Std.",""]
["2017-01-18",null,null,"Uhr",null,"Std.",{"$f":"IF(E27=\"\",\"\",SUM($E$10:E27))","v":""},"Std.",""]
["2017-01-19",null,null,"Uhr",null,"Std.",{"$f":"IF(E28=\"\",\"\",SUM($E$10:E28))","v":""},"Std.",""]
["2017-01-20",null,null,"Uhr",null,"Std.",{"$f":"IF(E29=\"\",\"\",SUM($E$10:E29))","v":""},"Std.",""]
["2017-01-21",null,null,"Uhr",null,"Std.",{"$f":"IF(E30=\"\",\"\",SUM($E$10:E30))","v":""},"Std.",""]
["2017-01-22",null,null,"Uhr",null,"Std.",{"$f":"IF(E31=\"\",\"\",SUM($E$10:E31))","v":""},"Std.",""]
["2017-01-23",null,null,"Uhr",null,"Std.",{"$f":"IF(E32=\"\",\"\",SUM($E$10:E32))","v":""},"Std.",""]
["2017-01-24",null,null,"Uhr",null,"Std.",{"$f":"IF(E33=\"\",\"\",SUM($E$10:E33))","v":""},"Std.",""]
["2017-01-25",null,null,"Uhr",null,"Std.",{"$f":"IF(E34=\"\",\"\",SUM($E$10:E34))","v":""},"Std.",""]
["2017-01-26",null,null,"Uhr",null,"Std.",{"$f":"IF(E35=\"\",\"\",SUM($E$10:E35))","v":""},"Std.",""]
["2017-01-27",null,null,"Uhr",null,"Std.",{"$f":"IF(E36=\"\",\"\",SUM($E$10:E36))","v":""},"Std.",""]
["2017-01-28",null,null,"Uhr",null,"Std.",{"$f":"IF(E37=\"\",\"\",SUM($E$10:E37))","v":""},"Std.",""]
["2017-01-29",null,null,"Uhr",null,"Std.",{"$f":"IF(E38=\"\",\"\",SUM($E$10:E38))","v":""},"Std.",""]
["2017-01-30",null,null,"Uhr",null,"Std.",{"$f":"IF(E39=\"\",\"\",SUM($E$10:E39))","v":""},"Std.",""]
["2017-01-31",null,null,"Uhr",null,"Std.",{"$f":"IF(E40=\"\",\"\",SUM($E$10:E40))","v":""},"Std.",""]
[]
[null,"Abrechnung geprüft:",{"$nulls":5},{"$f":"MAX(G10:G40)*$I$8","v":{"v":0,"d":"0.00 €"}},"Total"]
[]
[null,"Abt.-Leiter :",{"$nulls":5},{"$f":"TODAY()","v":"2017-03-13"}]
[null,"Kassenwart :"]
["1.Judo Club Nieder Roden / Rodgau e.V."]

{"sheet":"C-Lizenz","index":3,"n_rows":46,"n_cols":9,"rows_kept":46,"hidden":true,"merged":[[0,3,0,6],[2,3,2,6],[4,3,4,5],[6,0,6,1],[6,2,6,3],[6,4,6,5],[7,0,7,1],[7,2,7,3],[7,4,7,5],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[43,2,43,5],[44,2,44,5],[45,0,45,8]]}
["Abteilung :"]
[]
["ÜL / Trainer :"]
[]
["Abrechnungsmonat :",null,null,1,null,null,2017]
[]
["Tag",null,"        Trainingszeit",null,"Stunden",null,"Stunden",null,"Std.-Satz"]
["im Monat",null,"       von  -->  bis",null,"am Tag",null,"im Monat",null,{"v":8,"d":"8.00 €"}]
[]
[{"$f":"DATE($G$5,$D$5,1)","v":"2017-01-01"},null,null,"Uhr",null,"Std.",{"$f":"IF(E10=\"\",\"\",SUM(E10))","v":""},"Std.",{"$f":"IF(E10=\"\",\"\",SUM($I$8*E10))","v":""}]
[{"$f":"A10+1","v":"2017-01-02"},null,null,"Uhr",null,"Std.",{"$f":"IF(E11=\"\",\"\",SUM($E$10:E11))","v":""},"Std.",""]
["2017-01-03",null,null,"Uhr",null,"Std.",{"$f":"IF(E12=\"\",\"\",SUM($E$10:E12))","v":""},"Std.",""]
["2017-01-04",null,null,"Uhr",null,"Std.",{"$f":"IF(E13=\"\",\"\",SUM($E$10:E13))","v":""},"Std.",""]
["2017-01-05",null,null,"Uhr",null,"Std.",{"$f":"IF(E14=\"\",\"\",SUM($E$10:E14))","v":""},"Std.",""]
["2017-01-06",null,null,"Uhr",null,"Std.",{"$f":"IF(E15=\"\",\"\",SUM($E$10:E15))","v":""},"Std.",""]
["2017-01-07",null,null,"Uhr",null,"Std.",{"$f":"IF(E16=\"\",\"\",SUM($E$10:E16))","v":""},"Std.",""]
["2017-01-08",null,null,"Uhr",null,"Std.",{"$f":"IF(E17=\"\",\"\",SUM($E$10:E17))","v":""},"Std.",""]
["2017-01-09",null,null,"Uhr",null,"Std.",{"$f":"IF(E18=\"\",\"\",SUM($E$10:E18))","v":""},"Std.",""]
["2017-01-10",null,null,"Uhr",null,"Std.",{"$f":"IF(E19=\"\",\"\",SUM($E$10:E19))","v":""},"Std.",""]
["2017-01-11",null,null,"Uhr",null,"Std.",{"$f":"IF(E20=\"\",\"\",SUM($E$10:E20))","v":""},"Std.",""]
["2017-01-12",null,null,"Uhr",null,"Std.",{"$f":"IF(E21=\"\",\"\",SUM($E$10:E21))","v":""},"Std.",""]
["2017-01-13",null,null,"Uhr",null,"Std.",{"$f":"IF(E22=\"\",\"\",SUM($E$10:E22))","v":""},"Std.",""]
["2017-01-14",null,null,"Uhr",null,"Std.",{"$f":"IF(E23=\"\",\"\",SUM($E$10:E23))","v":""},"Std.",""]
["2017-01-15",null,null,"Uhr",null,"Std.",{"$f":"IF(E24=\"\",\"\",SUM($E$10:E24))","v":""},"Std.",""]
["2017-01-16",null,null,"Uhr",null,"Std.",{"$f":"IF(E25=\"\",\"\",SUM($E$10:E25))","v":""},"Std.",""]
["2017-01-17",null,null,"Uhr",null,"Std.",{"$f":"IF(E26=\"\",\"\",SUM($E$10:E26))","v":""},"Std.",""]
["2017-01-18",null,null,"Uhr",null,"Std.",{"$f":"IF(E27=\"\",\"\",SUM($E$10:E27))","v":""},"Std.",""]
["2017-01-19",null,null,"Uhr",null,"Std.",{"$f":"IF(E28=\"\",\"\",SUM($E$10:E28))","v":""},"Std.",""]
["2017-01-20",null,null,"Uhr",null,"Std.",{"$f":"IF(E29=\"\",\"\",SUM($E$10:E29))","v":""},"Std.",""]
["2017-01-21",null,null,"Uhr",null,"Std.",{"$f":"IF(E30=\"\",\"\",SUM($E$10:E30))","v":""},"Std.",""]
["2017-01-22",null,null,"Uhr",null,"Std.",{"$f":"IF(E31=\"\",\"\",SUM($E$10:E31))","v":""},"Std.",""]
["2017-01-23",null,null,"Uhr",null,"Std.",{"$f":"IF(E32=\"\",\"\",SUM($E$10:E32))","v":""},"Std.",""]
["2017-01-24",null,null,"Uhr",null,"Std.",{"$f":"IF(E33=\"\",\"\",SUM($E$10:E33))","v":""},"Std.",""]
["2017-01-25",null,null,"Uhr",null,"Std.",{"$f":"IF(E34=\"\",\"\",SUM($E$10:E34))","v":""},"Std.",""]
["2017-01-26",null,null,"Uhr",null,"Std.",{"$f":"IF(E35=\"\",\"\",SUM($E$10:E35))","v":""},"Std.",""]
["2017-01-27",null,null,"Uhr",null,"Std.",{"$f":"IF(E36=\"\",\"\",SUM($E$10:E36))","v":""},"Std.",""]
["2017-01-28",null,null,"Uhr",null,"Std.",{"$f":"IF(E37=\"\",\"\",SUM($E$10:E37))","v":""},"Std.",""]
["2017-01-29",null,null,"Uhr",null,"Std.",{"$f":"IF(E38=\"\",\"\",SUM($E$10:E38))","v":""},"Std.",""]
["2017-01-30",null,null,"Uhr",null,"Std.",{"$f":"IF(E39=\"\",\"\",SUM($E$10:E39))","v":""},"Std.",""]
["2017-01-31",null,null,"Uhr",null,"Std.",{"$f":"IF(E40=\"\",\"\",SUM($E$10:E40))","v":""},"Std.",""]
[]
[null,"Abrechnung geprüft:",{"$nulls":5},{"$f":"MAX(G10:G40)*$I$8","v":{"v":0,"d":"0.00 €"}},"Total"]
[]
[null,"Abt.-Leiter :",{"$nulls":5},{"$f":"TODAY()","v":"2017-03-13"}]
[null,"Kassenwart :"]
["1.Judo Club Nieder Roden / Rodgau e.V."]

{"sheet":"B-Lizenz","index":4,"n_rows":46,"n_cols":9,"rows_kept":46,"hidden":true,"merged":[[0,3,0,6],[2,3,2,6],[4,3,4,5],[6,0,6,1],[6,2,6,3],[6,4,6,5],[7,0,7,1],[7,2,7,3],[7,4,7,5],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[43,2,43,5],[44,2,44,5],[45,0,45,8]]}
["Abteilung :"]
[]
["ÜL / Trainer :"]
[]
["Abrechnungsmonat :",null,null,1,null,null,2017]
[]
["Tag",null,"        Trainingszeit",null,"Stunden",null,"Stunden",null,"Std.-Satz"]
["im Monat",null,"       von  -->  bis",null,"am Tag",null,"im Monat",null,{"v":12,"d":"12.00 €"}]
[]
[{"$f":"DATE($G$5,$D$5,1)","v":"2017-01-01"},null,null,"Uhr",null,"Std.",{"$f":"IF(E10=\"\",\"\",SUM(E10))","v":""},"Std.",{"$f":"IF(E10=\"\",\"\",SUM($I$8*E10))","v":""}]
[{"$f":"A10+1","v":"2017-01-02"},null,null,"Uhr",null,"Std.",{"$f":"IF(E11=\"\",\"\",SUM($E$10:E11))","v":""},"Std.",""]
["2017-01-03",null,null,"Uhr",null,"Std.",{"$f":"IF(E12=\"\",\"\",SUM($E$10:E12))","v":""},"Std.",""]
["2017-01-04",null,null,"Uhr",null,"Std.",{"$f":"IF(E13=\"\",\"\",SUM($E$10:E13))","v":""},"Std.",""]
["2017-01-05",null,null,"Uhr",null,"Std.",{"$f":"IF(E14=\"\",\"\",SUM($E$10:E14))","v":""},"Std.",""]
["2017-01-06",null,null,"Uhr",null,"Std.",{"$f":"IF(E15=\"\",\"\",SUM($E$10:E15))","v":""},"Std.",""]
["2017-01-07",null,null,"Uhr",null,"Std.",{"$f":"IF(E16=\"\",\"\",SUM($E$10:E16))","v":""},"Std.",""]
["2017-01-08",null,null,"Uhr",null,"Std.",{"$f":"IF(E17=\"\",\"\",SUM($E$10:E17))","v":""},"Std.",""]
["2017-01-09",null,null,"Uhr",null,"Std.",{"$f":"IF(E18=\"\",\"\",SUM($E$10:E18))","v":""},"Std.",""]
["2017-01-10",null,null,"Uhr",null,"Std.",{"$f":"IF(E19=\"\",\"\",SUM($E$10:E19))","v":""},"Std.",""]
["2017-01-11",null,null,"Uhr",null,"Std.",{"$f":"IF(E20=\"\",\"\",SUM($E$10:E20))","v":""},"Std.",""]
["2017-01-12",null,null,"Uhr",null,"Std.",{"$f":"IF(E21=\"\",\"\",SUM($E$10:E21))","v":""},"Std.",""]
["2017-01-13",null,null,"Uhr",null,"Std.",{"$f":"IF(E22=\"\",\"\",SUM($E$10:E22))","v":""},"Std.",""]
["2017-01-14",null,null,"Uhr",null,"Std.",{"$f":"IF(E23=\"\",\"\",SUM($E$10:E23))","v":""},"Std.",""]
["2017-01-15",null,null,"Uhr",null,"Std.",{"$f":"IF(E24=\"\",\"\",SUM($E$10:E24))","v":""},"Std.",""]
["2017-01-16",null,null,"Uhr",null,"Std.",{"$f":"IF(E25=\"\",\"\",SUM($E$10:E25))","v":""},"Std.",""]
["2017-01-17",null,null,"Uhr",null,"Std.",{"$f":"IF(E26=\"\",\"\",SUM($E$10:E26))","v":""},"Std.",""]
["2017-01-18",null,null,"Uhr",null,"Std.",{"$f":"IF(E27=\"\",\"\",SUM($E$10:E27))","v":""},"Std.",""]
["2017-01-19",null,null,"Uhr",null,"Std.",{"$f":"IF(E28=\"\",\"\",SUM($E$10:E28))","v":""},"Std.",""]
["2017-01-20",null,null,"Uhr",null,"Std.",{"$f":"IF(E29=\"\",\"\",SUM($E$10:E29))","v":""},"Std.",""]
["2017-01-21",null,null,"Uhr",null,"Std.",{"$f":"IF(E30=\"\",\"\",SUM($E$10:E30))","v":""},"Std.",""]
["2017-01-22",null,null,"Uhr",null,"Std.",{"$f":"IF(E31=\"\",\"\",SUM($E$10:E31))","v":""},"Std.",""]
["2017-01-23",null,null,"Uhr",null,"Std.",{"$f":"IF(E32=\"\",\"\",SUM($E$10:E32))","v":""},"Std.",""]
["2017-01-24",null,null,"Uhr",null,"Std.",{"$f":"IF(E33=\"\",\"\",SUM($E$10:E33))","v":""},"Std.",""]
["2017-01-25",null,null,"Uhr",null,"Std.",{"$f":"IF(E34=\"\",\"\",SUM($E$10:E34))","v":""},"Std.",""]
["2017-01-26",null,null,"Uhr",null,"Std.",{"$f":"IF(E35=\"\",\"\",SUM($E$10:E35))","v":""},"Std.",""]
["2017-01-27",null,null,"Uhr",null,"Std.",{"$f":"IF(E36=\"\",\"\",SUM($E$10:E36))","v":""},"Std.",""]
["2017-01-28",null,null,"Uhr",null,"Std.",{"$f":"IF(E37=\"\",\"\",SUM($E$10:E37))","v":""},"Std.",""]
["2017-01-29",null,null,"Uhr",null,"Std.",{"$f":"IF(E38=\"\",\"\",SUM($E$10:E38))","v":""},"Std.",""]
["2017-01-30",null,null,"Uhr",null,"Std.",{"$f":"IF(E39=\"\",\"\",SUM($E$10:E39))","v":""},"Std.",""]
["2017-01-31",null,null,"Uhr",null,"Std.",{"$f":"IF(E40=\"\",\"\",SUM($E$10:E40))","v":""},"Std.",""]
[]
[null,"Abrechnung geprüft:",{"$nulls":5},{"$f":"MAX(G10:G40)*$I$8","v":{"v":0,"d":"0.00 €"}},"Total"]
[]
[null,"Abt.-Leiter :",{"$nulls":5},{"$f":"TODAY()","v":"2017-03-13"}]
[null,"Kassenwart :"]
["1.Judo Club Nieder Roden / Rodgau e.V."]

{"sheet":"Markus Römer","index":5,"n_rows":46,"n_cols":9,"rows_kept":46,"hidden":true,"merged":[[0,3,0,6],[2,3,2,6],[4,3,4,5],[6,0,6,1],[6,2,6,3],[6,4,6,5],[7,0,7,1],[7,2,7,3],[7,4,7,5],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[43,2,43,5],[44,2,44,5],[45,0,45,8]]}
["Abteilung :",null,null,"Taekwondo"]
[]
["ÜL / Trainer :",null,null,"Markus Römer"]
[]
["Abrechnungsmonat :",null,null,1,null,null,2017]
[]
["Tag",null,"        Trainingszeit",null,"Stunden",null,"Stunden",null,"Std.-Satz"]
["im Monat",null,"       von  -->  bis",null,"am Tag",null,"im Monat",null,{"v":13,"d":"13.00 €"}]
[]
[{"$f":"DATE($G$5,$D$5,1)","v":"2017-01-01"},null,null,"Uhr",null,"Std.",{"$f":"IF(E10=\"\",\"\",SUM(E10))","v":""},"Std.",{"$f":"IF(E10=\"\",\"\",SUM($I$8*E10))","v":""}]
[{"$f":"A10+1","v":"2017-01-02"},null,null,"Uhr",null,"Std.",{"$f":"IF(E11=\"\",\"\",SUM($E$10:E11))","v":""},"Std.",""]
["2017-01-03",null,null,"Uhr",null,"Std.",{"$f":"IF(E12=\"\",\"\",SUM($E$10:E12))","v":""},"Std.",""]
["2017-01-04",null,null,"Uhr",null,"Std.",{"$f":"IF(E13=\"\",\"\",SUM($E$10:E13))","v":""},"Std.",""]
["2017-01-05",null,null,"Uhr",null,"Std.",{"$f":"IF(E14=\"\",\"\",SUM($E$10:E14))","v":""},"Std.",""]
["2017-01-06",null,null,"Uhr",null,"Std.",{"$f":"IF(E15=\"\",\"\",SUM($E$10:E15))","v":""},"Std.",""]
["2017-01-07",null,null,"Uhr",null,"Std.",{"$f":"IF(E16=\"\",\"\",SUM($E$10:E16))","v":""},"Std.",""]
["2017-01-08",null,null,"Uhr",null,"Std.",{"$f":"IF(E17=\"\",\"\",SUM($E$10:E17))","v":""},"Std.",""]
["2017-01-09",null,null,"Uhr",null,"Std.",{"$f":"IF(E18=\"\",\"\",SUM($E$10:E18))","v":""},"Std.",""]
["2017-01-10",null,null,"Uhr",null,"Std.",{"$f":"IF(E19=\"\",\"\",SUM($E$10:E19))","v":""},"Std.",""]
["2017-01-11",null,null,"Uhr",null,"Std.",{"$f":"IF(E20=\"\",\"\",SUM($E$10:E20))","v":""},"Std.",""]
["2017-01-12",null,null,"Uhr",null,"Std.",{"$f":"IF(E21=\"\",\"\",SUM($E$10:E21))","v":""},"Std.",""]
["2017-01-13",null,null,"Uhr",null,"Std.",{"$f":"IF(E22=\"\",\"\",SUM($E$10:E22))","v":""},"Std.",""]
["2017-01-14",null,null,"Uhr",null,"Std.",{"$f":"IF(E23=\"\",\"\",SUM($E$10:E23))","v":""},"Std.",""]
["2017-01-15",null,null,"Uhr",null,"Std.",{"$f":"IF(E24=\"\",\"\",SUM($E$10:E24))","v":""},"Std.",""]
["2017-01-16",null,null,"Uhr",null,"Std.",{"$f":"IF(E25=\"\",\"\",SUM($E$10:E25))","v":""},"Std.",""]
["2017-01-17",null,null,"Uhr",null,"Std.",{"$f":"IF(E26=\"\",\"\",SUM($E$10:E26))","v":""},"Std.",""]
["2017-01-18",null,null,"Uhr",null,"Std.",{"$f":"IF(E27=\"\",\"\",SUM($E$10:E27))","v":""},"Std.",""]
["2017-01-19",null,null,"Uhr",null,"Std.",{"$f":"IF(E28=\"\",\"\",SUM($E$10:E28))","v":""},"Std.",""]
["2017-01-20",null,null,"Uhr",null,"Std.",{"$f":"IF(E29=\"\",\"\",SUM($E$10:E29))","v":""},"Std.",""]
["2017-01-21",null,null,"Uhr",null,"Std.",{"$f":"IF(E30=\"\",\"\",SUM($E$10:E30))","v":""},"Std.",""]
["2017-01-22",null,null,"Uhr",null,"Std.",{"$f":"IF(E31=\"\",\"\",SUM($E$10:E31))","v":""},"Std.",""]
["2017-01-23",null,null,"Uhr",null,"Std.",{"$f":"IF(E32=\"\",\"\",SUM($E$10:E32))","v":""},"Std.",""]
["2017-01-24",null,null,"Uhr",null,"Std.",{"$f":"IF(E33=\"\",\"\",SUM($E$10:E33))","v":""},"Std.",""]
["2017-01-25",null,null,"Uhr",null,"Std.",{"$f":"IF(E34=\"\",\"\",SUM($E$10:E34))","v":""},"Std.",""]
["2017-01-26",null,null,"Uhr",null,"Std.",{"$f":"IF(E35=\"\",\"\",SUM($E$10:E35))","v":""},"Std.",""]
["2017-01-27",null,null,"Uhr",null,"Std.",{"$f":"IF(E36=\"\",\"\",SUM($E$10:E36))","v":""},"Std.",""]
["2017-01-28",null,null,"Uhr",null,"Std.",{"$f":"IF(E37=\"\",\"\",SUM($E$10:E37))","v":""},"Std.",""]
["2017-01-29",null,null,"Uhr",null,"Std.",{"$f":"IF(E38=\"\",\"\",SUM($E$10:E38))","v":""},"Std.",""]
["2017-01-30",null,null,"Uhr",null,"Std.",{"$f":"IF(E39=\"\",\"\",SUM($E$10:E39))","v":""},"Std.",""]
["2017-01-31",null,null,"Uhr",null,"Std.",{"$f":"IF(E40=\"\",\"\",SUM($E$10:E40))","v":""},"Std.",""]
[]
[null,"Abrechnung geprüft:",{"$nulls":5},{"$f":"MAX(G10:G40)*$I$8","v":{"v":0,"d":"0.00 €"}},"Total"]
[]
[null,"Abt.-Leiter :",{"$nulls":5},{"$f":"TODAY()","v":"2017-03-13"}]
[null,"Kassenwart :"]
["1.Judo Club Nieder Roden / Rodgau e.V."]

{"sheet":"Bernd Schneider","index":6,"n_rows":46,"n_cols":9,"rows_kept":46,"hidden":true,"merged":[[0,3,0,6],[2,3,2,6],[4,3,4,5],[6,0,6,1],[6,2,6,3],[6,4,6,5],[7,0,7,1],[7,2,7,3],[7,4,7,5],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[43,2,43,5],[44,2,44,5],[45,0,45,8]]}
["Abteilung :",null,null,"Aikido"]
[]
["ÜL / Trainer :",null,null,"Bernd Schneider"]
[]
["Abrechnungsmonat :",null,null,1,null,null,2017]
[]
["Tag",null,"        Trainingszeit",null,"Stunden",null,"Stunden",null,"Std.-Satz"]
["im Monat",null,"       von  -->  bis",null,"am Tag",null,"im Monat",null,{"v":17,"d":"17.00 €"}]
[]
[{"$f":"DATE($G$5,$D$5,1)","v":"2017-01-01"},null,null,"Uhr",null,"Std.",{"$f":"IF(E10=\"\",\"\",SUM(E10))","v":""},"Std.",{"$f":"IF(E10=\"\",\"\",SUM($I$8*E10))","v":""}]
[{"$f":"A10+1","v":"2017-01-02"},null,null,"Uhr",null,"Std.",{"$f":"IF(E11=\"\",\"\",SUM($E$10:E11))","v":""},"Std.",""]
["2017-01-03",null,null,"Uhr",null,"Std.",{"$f":"IF(E12=\"\",\"\",SUM($E$10:E12))","v":""},"Std.",""]
["2017-01-04",null,null,"Uhr",null,"Std.",{"$f":"IF(E13=\"\",\"\",SUM($E$10:E13))","v":""},"Std.",""]
["2017-01-05",null,null,"Uhr",null,"Std.",{"$f":"IF(E14=\"\",\"\",SUM($E$10:E14))","v":""},"Std.",""]
["2017-01-06",null,null,"Uhr",null,"Std.",{"$f":"IF(E15=\"\",\"\",SUM($E$10:E15))","v":""},"Std.",""]
["2017-01-07",null,null,"Uhr",null,"Std.",{"$f":"IF(E16=\"\",\"\",SUM($E$10:E16))","v":""},"Std.",""]
["2017-01-08",null,null,"Uhr",null,"Std.",{"$f":"IF(E17=\"\",\"\",SUM($E$10:E17))","v":""},"Std.",""]
["2017-01-09",null,null,"Uhr",null,"Std.",{"$f":"IF(E18=\"\",\"\",SUM($E$10:E18))","v":""},"Std.",""]
["2017-01-10",null,null,"Uhr",null,"Std.",{"$f":"IF(E19=\"\",\"\",SUM($E$10:E19))","v":""},"Std.",""]
["2017-01-11",null,null,"Uhr",null,"Std.",{"$f":"IF(E20=\"\",\"\",SUM($E$10:E20))","v":""},"Std.",""]
["2017-01-12",null,null,"Uhr",null,"Std.",{"$f":"IF(E21=\"\",\"\",SUM($E$10:E21))","v":""},"Std.",""]
["2017-01-13",null,null,"Uhr",null,"Std.",{"$f":"IF(E22=\"\",\"\",SUM($E$10:E22))","v":""},"Std.",""]
["2017-01-14",null,null,"Uhr",null,"Std.",{"$f":"IF(E23=\"\",\"\",SUM($E$10:E23))","v":""},"Std.",""]
["2017-01-15",null,null,"Uhr",null,"Std.",{"$f":"IF(E24=\"\",\"\",SUM($E$10:E24))","v":""},"Std.",""]
["2017-01-16",null,null,"Uhr",null,"Std.",{"$f":"IF(E25=\"\",\"\",SUM($E$10:E25))","v":""},"Std.",""]
["2017-01-17",null,null,"Uhr",null,"Std.",{"$f":"IF(E26=\"\",\"\",SUM($E$10:E26))","v":""},"Std.",""]
["2017-01-18",null,null,"Uhr",null,"Std.",{"$f":"IF(E27=\"\",\"\",SUM($E$10:E27))","v":""},"Std.",""]
["2017-01-19",null,null,"Uhr",null,"Std.",{"$f":"IF(E28=\"\",\"\",SUM($E$10:E28))","v":""},"Std.",""]
["2017-01-20",null,null,"Uhr",null,"Std.",{"$f":"IF(E29=\"\",\"\",SUM($E$10:E29))","v":""},"Std.",""]
["2017-01-21",null,null,"Uhr",null,"Std.",{"$f":"IF(E30=\"\",\"\",SUM($E$10:E30))","v":""},"Std.",""]
["2017-01-22",null,null,"Uhr",null,"Std.",{"$f":"IF(E31=\"\",\"\",SUM($E$10:E31))","v":""},"Std.",""]
["2017-01-23",null,null,"Uhr",null,"Std.",{"$f":"IF(E32=\"\",\"\",SUM($E$10:E32))","v":""},"Std.",""]
["2017-01-24",null,null,"Uhr",null,"Std.",{"$f":"IF(E33=\"\",\"\",SUM($E$10:E33))","v":""},"Std.",""]
["2017-01-25",null,null,"Uhr",null,"Std.",{"$f":"IF(E34=\"\",\"\",SUM($E$10:E34))","v":""},"Std.",""]
["2017-01-26",null,null,"Uhr",null,"Std.",{"$f":"IF(E35=\"\",\"\",SUM($E$10:E35))","v":""},"Std.",""]
["2017-01-27",null,null,"Uhr",null,"Std.",{"$f":"IF(E36=\"\",\"\",SUM($E$10:E36))","v":""},"Std.",""]
["2017-01-28",null,null,"Uhr",null,"Std.",{"$f":"IF(E37=\"\",\"\",SUM($E$10:E37))","v":""},"Std.",""]
["2017-01-29",null,null,"Uhr",null,"Std.",{"$f":"IF(E38=\"\",\"\",SUM($E$10:E38))","v":""},"Std.",""]
["2017-01-30",null,null,"Uhr",null,"Std.",{"$f":"IF(E39=\"\",\"\",SUM($E$10:E39))","v":""},"Std.",""]
["2017-01-31",null,null,"Uhr",null,"Std.",{"$f":"IF(E40=\"\",\"\",SUM($E$10:E40))","v":""},"Std.",""]
[]
[null,"Abrechnung geprüft:",{"$nulls":5},{"$f":"MAX(G10:G40)*$I$8","v":{"v":0,"d":"0.00 €"}},"Total"]
[]
[null,"Abt.-Leiter :",{"$nulls":5},{"$f":"TODAY()","v":"2017-03-13"}]
[null,"Kassenwart :"]
["1.Judo Club Nieder Roden / Rodgau e.V."]

{"sheet":"Hilfstabelle","index":7,"n_rows":24,"n_cols":9,"rows_kept":24,"hidden":true,"merged":[[0,1,2,10],[5,1,5,5]]}
[null,"Hilfstabelle"]
[]
[]
[]
[]
[null,"1. Judo-Club Nieder-Roden/Rodgau e.V."]
[]
[]
[]
[{"$nulls":4},"Monat",null,"Uhrzeit",null,"Abteilung"]
[{"$nulls":4},"Januar",null,"12:00 - 14:00",null,"Aikido"]
[{"$nulls":4},"Februar",null,"14:00 - 16:00",null,"Gymnastik"]
[{"$nulls":4},"März",null,"16:00 - 17:00",null,"Hapkido"]
[{"$nulls":4},"April",null,"16:15 - 17:15",null,"Judo"]
[{"$nulls":4},"Mai",null,"17:00 - 18:30",null,"Kickboxen"]
[{"$nulls":4},"Juni",null,"17:00 - 19:00",null,"Taekwondo"]
[{"$nulls":4},"Juli",null,"17:00 - 18:00",null,"Tai-Chi"]
[{"$nulls":4},"August",null,"18:00 - 19:00"]
[{"$nulls":4},"September",null,"18:00 - 19:30"]
[{"$nulls":4},"Oktober",null,"18:30 - 20:00"]
[{"$nulls":4},"November",null,"19:00 - 20:00"]
[{"$nulls":4},"Dezember",null,"19:30 - 21:00"]
[{"$nulls":6},"20:00 - 21:30"]
[{"$nulls":6},"20:15 - 21:30"]