{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Anmeldeformular Schulen","Läuferdaten"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"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":"Anmeldeformular Schulen","index":0,"n_rows":51,"n_cols":21,"rows_kept":51,"cut":false,"hidden":false,"merged":[[7,4,7,9],[23,1,23,4],[11,4,11,9],[12,4,12,9],[6,4,6,9],[13,4,13,9]]}
[]
[null,null,null,"ANMELDUNG","42. Luzerner Stadtlauf - Samstag, 4. Mai 2019"]
[null,null,null,null,"www.luzernerstadtlauf.ch",null,null,null,null,null,null,null,"falls der Button \"als Mail Versenden!\" auf Grund der Einstellungen zur Makrosicherheit nicht funktioniert:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Speichern Sie das File auf ihrem Desktop und mailen Sie es anschliessend an schulen@luzernerstadtlauf.ch"]
[null,null,null,"Schüler-Mannschaftsläufe \"Generation M\"",null,null,null,null,null,null,null,"Datum:",{"$f":"TODAY()","v":"2018-10-10"}]
[]
[null,null,null,"Klasse:",null,null,null,null,null,null,null,"Schulhaus:"]
[null,null,null,"LehrerIn:",null,null,null,null,null,null,null,"Ort:"]
[null,null,null,null,null,null,null,null,null,null,null,"Kat:",{"$f":"LEFT(B24,FIND(\":\",B24)-1)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"Adresse Kontaktperson:",null,null,null,null,null,null,null,null,null,null,null,null,null,"2:  Mannschaftsläufe \"I'M fit\" für Schulen - 3. Schuljahr"]
[null,null,null,"Name:",null,null,null,null,null,null,null,"Vorname:",null,null,null,null,null,"4:  Mannschaftsläufe \"I'M fit\" für Schulen - 4. Schuljahr"]
[null,null,null,"Adresse:",null,null,null,null,null,null,null,"PLZ/Ort:",null,null,null,null,null,"11:  Mannschaftsläufe \"I'M fit\" für Schulen - 5./6. Schuljahr Mädchen"]
[null,null,null,"Mobile-NR:",null,null,null,null,null,null,null,"E-Mail:",null,null,null,null,null,"12:  Mannschaftsläufe \"I'M fit\" für Schulen - 5./6. Schuljahr Knaben/gemischte Gruppen"]
[]
["Startzeit","Kategorie"]
[14.51,2,null,"Schüler-Mannschaftsläufe \"Generation M\"",null,{"$f":"\"Kat.\" & B17 & \"   \" & G17","v":"Kat.2   3. Schuljahr"},"3. Schuljahr",null,null,null,null,"1,510 km (1 A-Runde)"]
[15.17,4,null,"Schüler-Mannschaftsläufe \"Generation M\"",null,{"$f":"\"Kat.\" & B18 & \"   \" & G18","v":"Kat.4   4. Schuljahr"},"4. Schuljahr",null,null,null,null,"1,510 km (1 A-Runde)",null,null,null,null,null,null,null,null,"ja"]
[16.32,11,null,"Schüler-Mannschaftsläufe \"Generation M\"",null,{"$f":"\"Kat.\" & B19 & \"   \" & G19","v":"Kat.11   5./6. Schuljahr Mädchen"},"5./6. Schuljahr Mädchen",null,null,null,null,"2,100 km (1 B-Runde)",null,null,null,null,null,null,null,null,"nein"]
[16.420000000000002,12,null,"Schüler-Mannschaftsläufe \"Generation M\"",null,{"$f":"\"Kat.\" & B20 & \"   \" & G20","v":"Kat.12   5./6. Schuljahr Knaben/gemischte Gruppen"},"5./6. Schuljahr Knaben/gemischte Gruppen",null,null,null,null,"2,100 km (1 B-Runde)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Die Anreise aus der ganzen Schweiz ist gratis!"]
["Eine Schüler-Mannschaft besteht aus mind. 5 und max. 30 Teilnehmerinnen und Teilnehmer."]
[]
["Kategorie:",null,null,null,null,"Tag","Monat","Jahr"]
["1. Vorname:",null,"Name:",null,"Geburtsdatum:",null,null,null,"m/w:",null,"Startgeld:",0,{"$f":"ROWS(B25)-COUNTIF(B25,\"\")","v":0},{"$f":"IF(M8=\"Luzern\",5,7)","v":7}]
["2. Vorname:",null,"Name:",null,"Geburtsdatum:",null,null,null,"m/w:",null,"Startgeld:",0,{"$f":"ROWS(B26)-COUNTIF(B26,\"\")","v":0},{"$f":"IF(M8=\"Luzern\",5,7)","v":7}]
["3. Vorname:",null,"Name:",null,"Geburtsdatum:",null,null,null,"m/w:",null,"Startgeld:",0,0,{"$f":"IF(M8=\"Luzern\",5,7)","v":7}]
["4. Vorname:",null,"Name:",null,"Geburtsdatum:",null,null,null,"m/w:",null,"Startgeld:",0,0,{"$f":"IF(M8=\"Luzern\",5,7)","v":7}]
["5. Vorname:",null,"Name:",null,"Geburtsdatum:",null,null,null,"m/w:",null,"Startgeld:",0,0,{"$f":"IF(M8=\"Luzern\",5,7)","v":7}]
["6. Vorname:",null,"Name:",null,"Geburtsdatum:",null,null,null,"m/w:",null,"Startgeld:",0,0,{"$f":"IF(M8=\"Luzern\",5,7)","v":7}]
["7. Vorname:",null,"Name:",null,"Geburtsdatum:",null,null,null,"m/w:",null,"Startgeld:",0,0,{"$f":"IF(M8=\"Luzern\",5,7)","v":7}]
["8. Vorname:",null,"Name:",null,"Geburtsdatum:",null,null,null,"m/w:",null,"Startgeld:",0,0,{"$f":"IF(M8=\"Luzern\",5,7)","v":7}]
["9. Vorname:",null,"Name:",null,"Geburtsdatum:",null,null,null,"m/w:",null,"Startgeld:",0,0,{"$f":"IF(M8=\"Luzern\",5,7)","v":7}]
["10. Vorname:",null,"Name:",null,"Geburtsdatum:",null,null,null,"m/w:",null,"Startgeld:",0,0,{"$f":"IF(M8=\"Luzern\",5,7)","v":7}]
["11. Vorname:",null,"Name:",null,"Geburtsdatum:",null,null,null,"m/w:",null,"Startgeld:",0,0,{"$f":"IF(M8=\"Luzern\",5,7)","v":7}]
["12. Vorname:",null,"Name:",null,"Geburtsdatum:",null,null,null,"m/w:",null,"Startgeld:",0,0,{"$f":"IF(M8=\"Luzern\",5,7)","v":7}]
["13. Vorname:",null,"Name:",null,"Geburtsdatum:",null,null,null,"m/w:",null,"Startgeld:",0,0,{"$f":"IF(M8=\"Luzern\",5,7)","v":7}]
["14. Vorname:",null,"Name:",null,"Geburtsdatum:",null,null,null,"m/w:",null,"Startgeld:",0,0,{"$f":"IF(M8=\"Luzern\",5,7)","v":7}]
["15. Vorname:",null,"Name:",null,"Geburtsdatum:",null,null,null,"m/w:",null,"Startgeld:",0,0,{"$f":"IF(M8=\"Luzern\",5,7)","v":7}]
[]
["Mit der Anmeldung wird das Veranstaltungsreglement des Luzerner Stadtlaufes akzeptiert (siehe www.luzernerstadtlauf.ch).",null,null,null,null,null,null,null,null,null,"Total:",{"$f":"SUM(L25:L39)","v":0}]
[]
["Startgelder:"]
["Dank der Migros gratis an den Start! Für die Veranstaltung 2019 übernimmt die Migros sämtliche Startgelder der gestarteten Schülerinnen und Schüler in den Kategorien 2, 4, 11 und 12. Angebot solange Vorrat."]
["Für die korrekte Anmeldung ist somit keine Einzahlung notwendig. Bei Nichterscheinen der Läufergruppe behalten wir uns vor, pro Schülerin und Schüler einen Unkostenbeitrag von CHF 20.-- zu verrechnen."]
[]
[null,null,"Anmeldeschluss:","Sonntag, 7.4.2019"]
[null,null,null,"Keine Nachmeldungen möglich! "]
[]
[null,null,"Excel-Anmeldungen senden an:","schulen@luzernerstadtlauf.ch"]
[null,null,"Auskünfte:","Geschäftsstelle Verein Luzerner Stadtlauf, Tel: 041 375 03 35"]

{"sheet":"Läuferdaten","index":1,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Anmeldeformular Mannschaftsläufe Generation M"]
["Nachname:","Vorname:","Geburtsdatum:","Geschlecht:","Strasse:","PLZ:","Ort:","Teamname:","Kategorie:","Medaille:"]
[{"$f":"'Anmeldeformular Schulen'!D25","v":0},{"$f":"'Anmeldeformular Schulen'!B25","v":0},{"$f":"'Anmeldeformular Schulen'!F25&\".\"&'Anmeldeformular Schulen'!G25&\".\"&'Anmeldeformular Schulen'!H25","v":".."},{"$f":"'Anmeldeformular Schulen'!J25","v":0},null,null,null,{"$f":"'Anmeldeformular Schulen'!M7&\", \"&'Anmeldeformular Schulen'!M8","v":", "},{"$f":"'Anmeldeformular Schulen'!M9","v":{"$error":"#VALUE!"}},"ja"]
[{"$f":"'Anmeldeformular Schulen'!D26","v":0},{"$f":"'Anmeldeformular Schulen'!B26","v":0},{"$f":"'Anmeldeformular Schulen'!F26&\".\"&'Anmeldeformular Schulen'!G26&\".\"&'Anmeldeformular Schulen'!H26","v":".."},{"$f":"'Anmeldeformular Schulen'!J26","v":0},null,null,null,{"$f":"'Anmeldeformular Schulen'!M7&\", \"&'Anmeldeformular Schulen'!M8","v":", "},{"$f":"'Anmeldeformular Schulen'!M9","v":{"$error":"#VALUE!"}},"ja"]
[{"$f":"'Anmeldeformular Schulen'!D27","v":0},{"$f":"'Anmeldeformular Schulen'!B27","v":0},{"$f":"'Anmeldeformular Schulen'!F27&\".\"&'Anmeldeformular Schulen'!G27&\".\"&'Anmeldeformular Schulen'!H27","v":".."},{"$f":"'Anmeldeformular Schulen'!J27","v":0},null,null,null,{"$f":"'Anmeldeformular Schulen'!M7&\", \"&'Anmeldeformular Schulen'!M8","v":", "},{"$f":"'Anmeldeformular Schulen'!M9","v":{"$error":"#VALUE!"}},"ja"]
[{"$f":"'Anmeldeformular Schulen'!D28","v":0},{"$f":"'Anmeldeformular Schulen'!B28","v":0},{"$f":"'Anmeldeformular Schulen'!F28&\".\"&'Anmeldeformular Schulen'!G28&\".\"&'Anmeldeformular Schulen'!H28","v":".."},{"$f":"'Anmeldeformular Schulen'!J28","v":0},null,null,null,{"$f":"'Anmeldeformular Schulen'!M7&\", \"&'Anmeldeformular Schulen'!M8","v":", "},{"$f":"'Anmeldeformular Schulen'!M9","v":{"$error":"#VALUE!"}},"ja"]
[{"$f":"'Anmeldeformular Schulen'!D29","v":0},{"$f":"'Anmeldeformular Schulen'!B29","v":0},{"$f":"'Anmeldeformular Schulen'!F29&\".\"&'Anmeldeformular Schulen'!G29&\".\"&'Anmeldeformular Schulen'!H29","v":".."},{"$f":"'Anmeldeformular Schulen'!J29","v":0},null,null,null,{"$f":"'Anmeldeformular Schulen'!M7&\", \"&'Anmeldeformular Schulen'!M8","v":", "},{"$f":"'Anmeldeformular Schulen'!M9","v":{"$error":"#VALUE!"}},"ja"]
[{"$f":"'Anmeldeformular Schulen'!D30","v":0},{"$f":"'Anmeldeformular Schulen'!B30","v":0},{"$f":"'Anmeldeformular Schulen'!F30&\".\"&'Anmeldeformular Schulen'!G30&\".\"&'Anmeldeformular Schulen'!H30","v":".."},{"$f":"'Anmeldeformular Schulen'!J30","v":0},null,null,null,{"$f":"'Anmeldeformular Schulen'!M7&\", \"&'Anmeldeformular Schulen'!M8","v":", "},{"$f":"'Anmeldeformular Schulen'!M9","v":{"$error":"#VALUE!"}},"ja"]
[{"$f":"'Anmeldeformular Schulen'!D31","v":0},{"$f":"'Anmeldeformular Schulen'!B31","v":0},{"$f":"'Anmeldeformular Schulen'!F31&\".\"&'Anmeldeformular Schulen'!G31&\".\"&'Anmeldeformular Schulen'!H31","v":".."},{"$f":"'Anmeldeformular Schulen'!J31","v":0},null,null,null,{"$f":"'Anmeldeformular Schulen'!M7&\", \"&'Anmeldeformular Schulen'!M8","v":", "},{"$f":"'Anmeldeformular Schulen'!M9","v":{"$error":"#VALUE!"}},"ja"]
[{"$f":"'Anmeldeformular Schulen'!D32","v":0},{"$f":"'Anmeldeformular Schulen'!B32","v":0},{"$f":"'Anmeldeformular Schulen'!F32&\".\"&'Anmeldeformular Schulen'!G32&\".\"&'Anmeldeformular Schulen'!H32","v":".."},{"$f":"'Anmeldeformular Schulen'!J32","v":0},null,null,null,{"$f":"'Anmeldeformular Schulen'!M7&\", \"&'Anmeldeformular Schulen'!M8","v":", "},{"$f":"'Anmeldeformular Schulen'!M9","v":{"$error":"#VALUE!"}},"ja"]
[{"$f":"'Anmeldeformular Schulen'!D33","v":0},{"$f":"'Anmeldeformular Schulen'!B33","v":0},{"$f":"'Anmeldeformular Schulen'!F33&\".\"&'Anmeldeformular Schulen'!G33&\".\"&'Anmeldeformular Schulen'!H33","v":".."},{"$f":"'Anmeldeformular Schulen'!J33","v":0},null,null,null,{"$f":"'Anmeldeformular Schulen'!M7&\", \"&'Anmeldeformular Schulen'!M8","v":", "},{"$f":"'Anmeldeformular Schulen'!M9","v":{"$error":"#VALUE!"}},"ja"]
[{"$f":"'Anmeldeformular Schulen'!D34","v":0},{"$f":"'Anmeldeformular Schulen'!B34","v":0},{"$f":"'Anmeldeformular Schulen'!F34&\".\"&'Anmeldeformular Schulen'!G34&\".\"&'Anmeldeformular Schulen'!H34","v":".."},{"$f":"'Anmeldeformular Schulen'!J34","v":0},null,null,null,{"$f":"'Anmeldeformular Schulen'!M7&\", \"&'Anmeldeformular Schulen'!M8","v":", "},{"$f":"'Anmeldeformular Schulen'!M9","v":{"$error":"#VALUE!"}},"ja"]
[{"$f":"'Anmeldeformular Schulen'!D35","v":0},{"$f":"'Anmeldeformular Schulen'!B35","v":0},{"$f":"'Anmeldeformular Schulen'!F35&\".\"&'Anmeldeformular Schulen'!G35&\".\"&'Anmeldeformular Schulen'!H35","v":".."},{"$f":"'Anmeldeformular Schulen'!J35","v":0},null,null,null,{"$f":"'Anmeldeformular Schulen'!M7&\", \"&'Anmeldeformular Schulen'!M8","v":", "},{"$f":"'Anmeldeformular Schulen'!M9","v":{"$error":"#VALUE!"}},"ja"]
[{"$f":"'Anmeldeformular Schulen'!D36","v":0},{"$f":"'Anmeldeformular Schulen'!B36","v":0},{"$f":"'Anmeldeformular Schulen'!F36&\".\"&'Anmeldeformular Schulen'!G36&\".\"&'Anmeldeformular Schulen'!H36","v":".."},{"$f":"'Anmeldeformular Schulen'!J36","v":0},null,null,null,{"$f":"'Anmeldeformular Schulen'!M7&\", \"&'Anmeldeformular Schulen'!M8","v":", "},{"$f":"'Anmeldeformular Schulen'!M9","v":{"$error":"#VALUE!"}},"ja"]
[{"$f":"'Anmeldeformular Schulen'!D37","v":0},{"$f":"'Anmeldeformular Schulen'!B37","v":0},{"$f":"'Anmeldeformular Schulen'!F37&\".\"&'Anmeldeformular Schulen'!G37&\".\"&'Anmeldeformular Schulen'!H37","v":".."},{"$f":"'Anmeldeformular Schulen'!J37","v":0},null,null,null,{"$f":"'Anmeldeformular Schulen'!M7&\", \"&'Anmeldeformular Schulen'!M8","v":", "},{"$f":"'Anmeldeformular Schulen'!M9","v":{"$error":"#VALUE!"}},"ja"]
[{"$f":"'Anmeldeformular Schulen'!D38","v":0},{"$f":"'Anmeldeformular Schulen'!B38","v":0},{"$f":"'Anmeldeformular Schulen'!F38&\".\"&'Anmeldeformular Schulen'!G38&\".\"&'Anmeldeformular Schulen'!H38","v":".."},{"$f":"'Anmeldeformular Schulen'!J38","v":0},null,null,null,{"$f":"'Anmeldeformular Schulen'!M7&\", \"&'Anmeldeformular Schulen'!M8","v":", "},{"$f":"'Anmeldeformular Schulen'!M9","v":{"$error":"#VALUE!"}},"ja"]
[{"$f":"'Anmeldeformular Schulen'!D39","v":0},{"$f":"'Anmeldeformular Schulen'!B39","v":0},{"$f":"'Anmeldeformular Schulen'!F39&\".\"&'Anmeldeformular Schulen'!G39&\".\"&'Anmeldeformular Schulen'!H39","v":".."},{"$f":"'Anmeldeformular Schulen'!J39","v":0},null,null,null,{"$f":"'Anmeldeformular Schulen'!M7&\", \"&'Anmeldeformular Schulen'!M8","v":", "},{"$f":"'Anmeldeformular Schulen'!M9","v":{"$error":"#VALUE!"}},"ja"]