{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Gruppenmeldeschein"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Gruppenmeldeschein","index":0,"n_rows":90,"n_cols":12,"rows_kept":90,"cut":false,"hidden":false,"merged":[[0,0,0,4],[0,6,0,9]]}
["Verwenden Sie diese Vorlag für die Teilnehmerliste.\n\nDiese wird für die Gästetaxen, den GlarnerlandPass und für die behördliche Ablage benötigt.\n",null,null,null,null,null,"Hauptperson in der ersten Zeile erfassen\n\nEs müssen nur die orangen Felder ausgefüllt werden"]
[]
["Name","Vorname","Strasse","Nummer","PLZ","Wohnort","E-Mail","Geburtsdatum","Anreise","Abreise","Kategorie","CHF"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H4=\"\",\"\",IF(DATEDIF(H4,TODAY(),\"y\")<5,\"Kind <5\",IF(DATEDIF(H4,TODAY(),\"y\")<16,\"Kind 5-15\",\"Erwachsen\")))","v":""},{"$f":"IF(AND(K4<>\"\",I4<>\"\",J4<>\"\"),IF(K4=\"Erwachsen\", (J4-I4)*3, IF(K4=\"Kind 5-15\", (J4-I4)*1.5, 0)), \"\")","v":""}]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,{"$f":"IF(H36=\"\",\"\",IF(DATEDIF(H36,TODAY(),\"y\")<5,\"Kind <5\",IF(DATEDIF(H36,TODAY(),\"y\")<16,\"Kind 5-15\",\"Erwachsen\")))","v":""},{"$f":"IF(AND(K36<>\"\",I36<>\"\",J36<>\"\"),IF(K36=\"Erwachsen\", (J36-I36)*3, IF(K36=\"Kind 5-15\", (J36-I36)*1.5, 0)), \"\")","v":""}]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,{"$f":"IF(H68=\"\",\"\",IF(DATEDIF(H68,TODAY(),\"y\")<5,\"Kind <5\",IF(DATEDIF(H68,TODAY(),\"y\")<16,\"Kind 5-15\",\"Erwachsen\")))","v":""},{"$f":"IF(AND(K68<>\"\",I68<>\"\",J68<>\"\"),IF(K68=\"Erwachsen\", (J68-I68)*3, IF(K68=\"Kind 5-15\", (J68-I68)*1.5, 0)), \"\")","v":""}]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,"X","X","X","X","X",null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"Gästetaxen","Total",{"$f":"SUM(L4:L85)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Total Erwachsen",{"$f":"COUNTIF(K4:K85,\"Erwachsen\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Total Kind 5-15",{"$f":"COUNTIF(K4:K85,\"Kind 5-15\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Total Kind <5",{"$f":"COUNTIF(K4:K85,\"Kind <5\")","v":0}]