{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Anmeldung Allgemein","Einzel_Vormittag","Einzel_Nachmittag","Mannschaft","Jubiläumsstaffel"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"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":"Anmeldung Allgemein","index":0,"n_rows":101,"n_cols":13,"rows_kept":101,"cut":false,"hidden":false,"merged":[[59,1,59,6],[59,7,59,8],[59,9,59,10],[60,1,60,6],[60,7,60,8],[60,9,60,10],[0,0,0,11],[3,0,3,11],[4,0,4,10],[5,1,5,4],[5,5,5,7],[5,8,5,10],[6,0,6,10],[7,1,7,4],[7,6,7,7],[7,8,7,10],[1,0,1,11],[33,0,33,4],[33,5,33,6],[18,0,18,2],[14,0,14,10],[15,1,15,4],[15,6,15,7],[15,8,15,10],[27,2,27,7],[8,0,8,10],[9,1,9,4],[9,6,9,7],[9,8,9,10],[29,2,29,7],[17,0,17,3],[10,0,10,10],[11,1,11,4],[11,6,11,7],[11,8,11,10],[12,0,12,10],[13,1,13,4],[13,6,13,7],[13,8,13,10],[41,0,41,1],[41,2,41,3],[42,0,42,1],[42,2,42,3],[36,0,36,10],[37,0,37,3],[39,0,39,1],[39,2,39,3],[40,0,40,1],[40,2,40,3],[39,6,39,7],[40,6,40,7],[44,0,44,2],[45,0,45,9],[46,0,46,9],[47,0,47,9],[49,0,49,10],[51,1,52,6],[51,7,52,8],[51,9,51,10],[52,9,52,10],[62,1,62,6],[62,7,62,8],[62,9,62,10],[63,1,63,6],[63,7,63,8],[63,9,63,10],[53,1,53,6],[53,7,53,8],[53,9,53,10],[54,1,54,6],[54,7,54,8],[54,9,54,10],[55,1,55,6],[55,7,55,8],[55,9,55,10],[56,1,56,6],[56,7,56,8],[56,9,56,10],[57,1,57,6],[57,7,57,8],[57,9,57,10],[58,1,58,6],[58,7,58,8],[58,9,58,10],[20,2,20,7],[22,2,22,7],[24,0,24,4],[25,0,25,2],[25,4,25,5],[78,4,78,6],[70,0,70,11],[71,0,71,11],[79,4,79,6],[74,0,74,3],[72,0,72,11],[66,9,66,10],[67,1,67,6],[67,7,67,8],[67,9,67,10],[64,1,64,6],[64,7,64,8],[64,9,64,10],[65,1,65,6],[65,7,65,8],[65,9,65,10],[61,1,61,6],[61,7,61,8],[61,9,61,10],[89,0,89,3],[77,4,77,6],[76,4,76,6],[75,4,75,6],[74,4,74,6],[66,1,66,6],[66,7,66,8],[99,0,99,3],[100,0,100,6],[81,3,81,6],[92,0,93,3],[95,0,96,4],[84,0,84,1],[87,0,87,3]]}
["Anmeldebogen 20. Bauna-Eder-Pokal 2017 am 1. Advent 2017"]
["Tabellenblätter: Anmeldung Allgemein, Einzel Vormittag, Einzel Nachmittag, Mannschaft & Jubiläumsstaffel"]
[]
["Bitte alle blau eingefärbten Felder ausfüllen!!!"]
[]
["OV/OG:",null,null,null,null,"Ansprechpartner:",null,null,null,null,null,null,"Links zu den Tabellenblättern:"]
[]
["Straße:",null,null,null,null,null,"PLZ/Ort:",null,null,null,null,null,"Einzel Vormittag"]
[]
["Telefon:",null,null,null,null,null,"Email:",null,null,null,null,null,"Einzel Nachmittag"]
[]
["Fax:",null,null,null,null,null,"Mobil:",null,null,null,null,null,"Mannschaft"]
[]
["Bank:",null,null,null,null,null,"BIC:",null,null,null,null,null,"Jubiläumsstaffel"]
[]
["IBAN:"]
[]
["Sportler, Betreuer & Trainer"]
["Anzahl die Übernachten",null,null,"unter 16:",null,null,null,"über 16:"]
[]
["Anzahl:",null,"Übernachtung incl. Frühstück am So. á € 8,- p.P. =",null,null,null,null,null,{"$f":"B21*8","v":0}]
[]
["Anzahl:",null,"Abendessen am Sa. Mit oder ohne Fleisch a' € 8,- p.P.  =",null,null,null,null,null,{"$f":"B23*8","v":0}]
[]
["Kampfrichter & Helfer"]
["Anzahl die Übernachten",null,null,"unter 16:",0,null,null,"über 16:",0]
[]
["Anzahl:",0,"Übernachtung incl. Frühstück am So. á € 0,- p.P. =",null,null,null,null,null,{"$f":"B28*0","v":0}]
[]
["Anzahl:",0,"Abendessen am Sa. Mit oder ohne Fleisch a' € 0,- p.P.  =",null,null,null,null,null,{"$f":"B30*0","v":0}]
[]
["Essen"]
[]
["Anzahl der Essen:          vegetarisch:",null,null,null,null,0,null,"normal:",0]
[]
["Wettkampf:"]
[]
["EINZEL: Samstag",null,null,null,null,null,null,"MANNSCHAFT: Sonntag"]
[]
["TN Vormittags:",null,{"$f":"COUNTA(Einzel_Vormittag!A4:A102)","v":0},null,null,null,"Mannschaften:",null,{"$f":"COUNTA(Mannschaft!A4:A22)","v":0},"x € 14,-"]
["TN Nachmittags:",null,{"$f":"COUNTA(Einzel_Nachmittag!A4:A102)","v":0},null,null,null,"Jubiläumsstaffeln:",null,{"$f":"COUNTA(Jubiläumsstaffel!A4:A6)","v":0}]
["Gesamtzahl:",null,{"$f":"SUM(C40:D41)","v":0},null,"x € 7,-"]
["Gesamtbetrag:",null,{"$f":"C42*7","v":0},null,null,null,null,"Gesamtbetrag:",{"$f":"I40*14","v":0}]
[]
["Kampfrichter:"]
["Für den Einzel WK (Sa.) müssen wir folgende Anzahl an Kampfrichter o. Helfern melden :",null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(C42/10,0)","v":0}]
["Für den Mannschafts WK (So.) müssen wir folgende Anzahl an Kampfrichter o. Helfern melden :",null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(I40/2,0)","v":0}]
["Die Kaution gibt es wieder wenn alle gemeldeten Kampfrichter Anwesend sind!"]
[]
["Kampfrichter oder Helfer für beide Tage bitte zweimal eintragen !!!"]
[]
[null,"Name,Vorname",null,null,null,null,null,"Stufe",null,"Tag"]
[null,null,null,null,null,null,null,null,null,"Sa. o. So."]
["1."]
["2."]
["3."]
["4."]
["5."]
["6."]
["7."]
["8."]
["9."]
["10."]
["11."]
["12."]
["13."]
["14."]
["15."]
[]
[]
["Bitte schickt uns die Anmeldung bis zum 16. November an rettungssport@baunatal.dlrg.de"]
["Vielen Dank für Eure Anmeldung! "]
["Eure DLRG Baunatal"]
[]
["Kostenzusammenstellung",null,null,null,"Einzelwettkampf :",null,null,{"$f":"C43","v":0}]
[null,null,null,null,"Mannschaftswettkampf :",null,null,{"$f":"I43","v":0}]
[null,null,null,null,"Übernachtung :",null,null,{"$f":"I21","v":0}]
[null,null,null,null,"Abendessen :",null,null,{"$f":"I23","v":0}]
[null,null,null,null,"Kampfrichterkaution :",null,null,{"$f":"(K46+K47)*15","v":0}]
[null,null,null,null,"Kaution Schule :",null,null,{"$f":"IF((B21+B28)>0,75,0)","v":0}]
[]
[null,null,null,"Überweisungsbetrag :",null,null,null,{"$f":"SUM(H75:H80)","v":0}]
[]
["Kontrolle Ansprechpartner:"]
["Alles ausgefüllt :",null,null,null,null,null,null,{"$f":"IF(COUNTBLANK(A6:K12)=61,\"alles OK\",\"Fehler\")","v":"Fehler"}]
[]
["Kontrolle Übernachtung:"]
["Anzahl Pers. = unter 16, über 16 / Karis :",null,null,null,null,null,null,{"$f":"IF((G19+I19+E26+I26)=B28,\"OK\",\"Fehler\")","v":"OK"}]
[]
["Anzahl Pers. = Essen :",null,null,null,null,null,null,{"$f":"IF((F34+I34)=B30,\"OK\",\"Fehler\")","v":"OK"}]
[]
["Kontrolle Wettkampf:"]
["Anzahl Einzel AK Übersicht =  Anzahl Namentlicher Meldungen Einzel :",null,null,null,null,null,null,{"$f":"IF(C42=COUNTA(#REF!),\"OK\",\"Fehler\")","v":"Fehler"}]
[]
[]
["Anzahl Mannschafts AK Übersicht =  Anzahl Namentlicher Meldungen Mannschaft :",null,null,null,null,null,null,{"$f":"IF(I42=COUNTA(#REF!),\"OK\",\"Fehler\")","v":"Fehler"}]
[]
[]
["Kontrolle Kampfrichter:",null,null,null,null,null,null,{"$f":"IF(K46<=COUNTIF(J54:K68,\"Sa.\"),\"OK\",\"Zuwenig Kampfrichter Sa.\")","v":"OK"}]
["Anzahl Kampfrichter Einzel WK(Sa.) :"]
["Anzahl Kampfrichter Mannschaft WK(So.) :",null,null,null,null,null,null,{"$f":"IF(K47<=COUNTIF(J54:K68,\"So.\"),\"OK\",\"Zuwenig Kampfrichter So.\")","v":"OK"}]

{"sheet":"Einzel_Vormittag","index":1,"n_rows":3,"n_cols":12,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Meldebogen 20. Bauna-Eder-Pokal 2017 Einzel Vormittag",null,null,null,null,null,null,null,null,"Zurück zur Anmeldung Allgemein"]
["Nachname","Vorname","Jg","Gliederung","Altersklasse","Geschlecht","50m Hindernis","50m k. Schwimmen","50m Flossen","100m Hindernis","50m Retten","100m Flossenschwimmen"]
["Mustermann","Maxi","","Musterstadt","AK bis 10","w","0:00,00","0:00,00","0:00,00","","",""]

{"sheet":"Einzel_Nachmittag","index":2,"n_rows":3,"n_cols":14,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Meldebogen 20. Bauna-Eder-Pokal 2017 Einzel Nachmittag",null,null,null,null,null,null,null,null,"Zurück zur Anmeldung Allgemein"]
["Nachname","Vorname","Jg","Gliederung","Altersklasse","Geschlecht","100m Hindernis","50m Retten","100m Flossenschwimmen","100m Retten m. Fl.","50m Retten m. Fl.","50m Freistil","50m k. Schwimmen","25m Schleppen e. P."]
["Mustermann","Maxi","","Musterstadt","AK offen","m","0:00,00","0:00,00","0:00,00","","","","",""]

{"sheet":"Mannschaft","index":3,"n_rows":3,"n_cols":34,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Meldebogen 20. Bauna-Eder-Pokal 2017 Mannschaft",null,null,null,null,null,null,null,null,null,"Zurück zur Anmeldung Allgemein"]
["Name","Nachname 1","Vorname 1","Jahrgang 1","Geschlecht 1","Nachname 2","Vorname 2","Jahrgang 2","Geschlecht 2","Nachname 3","Vorname 3","Jahrgang 3","Geschlecht 3","Nachname 4","Vorname 4","Jahrgang 4","Geschlecht 4","Nachname 5","Vorname 5","Jahrgang 5","Geschlecht 5","Gliederung","Altersklasse","Geschlecht","4*25m Hindernis","4*25m Rettungsst.","4*25m Flossenstaffel","4*50m Hindernis","4*50m Gurtretterst.","4*50m Flossenstaffel","4*25m Puppenst.","4*50m Rettungsst.","4*50m Freistilst.","4*25m Rücken"]
["Musterstadt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Musterstadt","AK bis10","m","00:01:12.250","00:01:50.600","00:01:00.900"]

{"sheet":"Jubiläumsstaffel","index":4,"n_rows":3,"n_cols":28,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Meldebogen 20. Bauna-Eder-Pokal 2017 Jubiläumsstaffel",null,null,null,null,null,null,null,null,null,"Zurück zur Anmeldung Allgemein"]
["Name","Nachname 1","Vorname 1","Jahrgang 1","Geschlecht 1","Nachname 2","Vorname 2","Jahrgang 2","Geschlecht 2","Nachname 3","Vorname 3","Jahrgang 3","Geschlecht 3","Nachname 4","Vorname 4","Jahrgang 4","Geschlecht 4","Nachname 5","Vorname 5","Jahrgang 5","Geschlecht 5","Nachname 6","Vorname 6","Jahrgang 6","Geschlecht 6","Gliederung","Altersklasse","8*50m Jubiläumsstaffel"]
["Musterstadt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Musterortsgruppe","20.BEP2017","00:10:00.500"]