{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sitzplan"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Sitzplan","index":0,"n_rows":31,"n_cols":14,"rows_kept":31,"merged":[[0,0,0,7],[2,1,2,3],[2,5,2,7],[3,1,3,3],[3,5,3,7],[25,0,25,7],[29,0,29,7],[30,0,33,7]]}
["Sitzplan"]
[]
["Veranstaltung","Team-Workshop Q1",null,null,"Datum","2026-03-05",{"$nulls":3},"Name","Gruppe","Abteilung/Firma","Besonderheiten","Status"]
["Raum","Konferenzraum A",null,null,"Notizen","Gruppen möglichst zusammen setzen. Allergien beachten.",{"$nulls":3},"Max Müller","A","Marketing"]
[{"$nulls":9},"Anna Schmidt","A","Marketing","VIP"]
[null,"Reihe 1","Reihe 2","Reihe 3","Reihe 4","Reihe 5","Reihe 6","Reihe 7",null,"Tom Weber","A","Marketing"]
["Platz 1","Anna Schmidt","Max Müller","Tom Weber",{"$nulls":5},"Lisa Fischer","B","Sales","Vegetarisch"]
["Platz 2","Lisa Fischer","Paul Wagner","Eva Becker",{"$nulls":5},"Paul Wagner","B","Sales"]
["Platz 3","Jonas Klein","Mia Hoffmann","Noah Richter",{"$nulls":5},"Eva Becker","B","Sales","Glutenfrei"]
["Platz 4","Sophie König","Leon Braun","Lena Schneider",{"$nulls":5},"Jonas Klein","C","IT"]
["Platz 5",{"$nulls":8},"Mia Hoffmann","C","IT"]
["Platz 6",{"$nulls":8},"Noah Richter","C","IT","Allergie: Nüsse"]
["Platz 7",{"$nulls":8},"Sophie König","D","HR"]
["Platz 8",{"$nulls":8},"Leon Braun","D","HR"]
["Platz 9",{"$nulls":8},"Lena Schneider","D","HR"]
["Platz 10"]
["Platz 11"]
["Platz 12"]
["Platz 13"]
["Platz 14"]
["Platz 15"]
["Platz 16"]
["Platz 17"]
["Platz 18"]
["Platz 19"]
["Übersicht"]
["Sitzplätze gesamt",{"$f":"ROWS(SeatRange)*COLUMNS(SeatRange)","v":133},"Sitze zugewiesen",{"$f":"COUNTA(SeatRange)","v":12},"Sitze frei",{"$f":"B27-D27","v":121}]
["Gäste in Liste",{"$f":"COUNTA(tblGuests[Name])","v":12},"Gäste nicht zugewiesen"]
[]
["So funktioniert’s"]
["1) Rechts die Gästeliste ausfüllen (Name, Gruppe, Besonderheiten).\n2) In der Sitzmatrix einen Platz anklicken und einen Namen aus dem Dropdown wählen.\n3) Doppelte Zuweisungen werden rot markiert; freie Plätze sind grau."]