{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tabelle1","Tabelle2"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Tabelle1","index":0,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Datum","Henri","Andre","Jürgen","Richi","Thomas","Albert","Heimo","Alex","Spieler"]
[null,{"$f":"COUNTA(B3:B40)","v":13},{"$f":"COUNTA(C3:C40)","v":13},13,11,10,9,6,5,null,null,13,"Henri"]
["2026-05-28","X","X","X",null,null,null,"X",null,{"$f":"COUNTA(B3:I3)","v":4},null,13,"Andre"]
["2026-06-04","X",null,null,null,"X","X",null,"X",{"$f":"COUNTA(B4:I4)","v":4},null,13,"Jürgen"]
["2026-06-11",null,"X","X",null,null,"X","X",null,4,null,11,"Richi"]
["2026-06-18","X",null,"X","X","X",null,null,null,4,null,10,"Thomas"]
["2026-06-25",null,"X",null,null,"X",null,"X","X",4,null,9,"Albert"]
["2026-07-02","X","X","X","X",null,null,null,null,4,null,6,"Heimo"]
["2026-07-09","X",null,"X","X",null,"X",null,null,4,null,5,"Alex"]
["2026-07-16",null,"X","X","X","X",null,null,null,4]
["2026-07-23",null,"X",null,null,"X","X",null,"X",4]
["2026-07-30","X","X",null,"X",null,"X",null,null,4]
["2026-08-06","X",null,null,"X","X",null,"X",null,4]
["2026-08-13","X","X","X",null,null,"X",null,null,4]
["2026-08-20",null,null,"X","X",null,"X",null,"X",4]
["2026-08-27","X","X","X",null,"X",null,null,null,4]
["2026-09-03","X","X",null,null,"X",null,"X",null,4]
["2026-09-10","X",null,"X","X",null,"X",null,null,4]
["2026-09-17",null,"X","X",null,"X",null,null,"X",4]
["2026-09-24","X",null,"X","X",null,null,"X",null,4]
["2026-10-01","X","X",null,"X","X",null,null,null,4]
["2026-10-08",null,"X","X","X",null,"X",null,null,4]
[]
[{"$f":"A22+7","v":"2026-10-15"}]
[{"$f":"A24+7","v":"2026-10-22"}]
[{"$f":"A25+7","v":"2026-10-29"}]
[{"$f":"A26+7","v":"2026-11-05"}]
[{"$f":"A27+7","v":"2026-11-12"}]
[{"$f":"A28+7","v":"2026-11-19"}]
[{"$f":"A29+7","v":"2026-11-26"}]
[{"$f":"A30+7","v":"2026-12-03"}]
[{"$f":"A31+7","v":"2026-12-10"}]
[{"$f":"A32+7","v":"2026-12-17"}]
[{"$f":"A33+7","v":"2026-12-24"}]
[{"$f":"A34+7","v":"2026-12-31"}]

{"sheet":"Tabelle2","index":1,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Hallo, ich würde gerne für unseren Verein einen Trainingsplan für 8 Leute erstellen. Von diesen 8 Leuten sollen immer 4 an einem Tag anwesend sein. Problem dabei ist nur, dass die Häufigkeit bzw Spielbereitschaft variiert. Im Endeffekt sollte mir Excel einen balancierten Spielplan wie im angehängten Bild ausgeben. Würde auch gern im Vorfeld die maximale Anzahl der Spieltage je Person eintragen können (Person A 13 max Mal, C max 8 Mal, D max 5 Mal,....) vielleicht hat ja jmd einen unkomplizierte Idee wie man das einfach umsetzen kann. Besten Dank im Vorraus!"]