{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Spieler","Daten","Spielplan"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"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":"Spieler","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Team","Spieler_ID","Spieler_Name"]
[1,1,"Albert"]
[1,2,"Berta"]
[1,3,"Carlos"]
[2,4,"Daniel"]
[2,5,"Erna"]
[2,6,"Fritz"]
[3,7,"Georg"]
[3,8,"Hanna"]
[3,9,"Ignatz"]

{"sheet":"Daten","index":1,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Game_ID","HR_RR","Scheibe","SpielerA_ID","SpielerA_Name","SpielerA_Team","SpielerB_ID","SpielerB_Name","SpielerB_Team"]
[1,"HR",1,1,"Albert",1,4,"Daniel",2]
[2,"HR",2,1,"Albert",1,5,"Erna",2]
[3,"HR",1,1,"Albert",1,6,"Fritz",2]
[4,"HR",2,1,"Albert",1,7,"Georg",3]
[5,"HR",1,1,"Albert",1,8,"Hanna",3]
[6,"HR",2,1,"Albert",1,9,"Ignatz",3]
[7,"HR",1,2,"Berta",1,4,"Daniel",2]
[8,"HR",2,2,"Berta",1,5,"Erna",2]
[9,"HR",1,2,"Berta",1,6,"Fritz",2]
[10,"HR",2,2,"Berta",1,7,"Georg",3]
[11,"HR",1,2,"Berta",1,8,"Hanna",3]
[12,"HR",2,2,"Berta",1,9,"Ignatz",3]
[13,"HR",1,3,"Carlos",1,4,"Daniel",2]
[14,"HR",2,3,"Carlos",1,5,"Erna",2]
[15,"HR",1,3,"Carlos",1,6,"Fritz",2]
[16,"HR",2,3,"Carlos",1,7,"Georg",3]
[17,"HR",1,3,"Carlos",1,8,"Hanna",3]
[18,"HR",2,3,"Carlos",1,9,"Ignatz",3]
[19,"HR",1,4,"Daniel",2,7,"Georg",3]
[20,"HR",2,4,"Daniel",2,8,"Hanna",3]
[21,"HR",1,4,"Daniel",2,9,"Ignatz",3]
[22,"HR",2,5,"Erna",2,7,"Georg",3]
[23,"HR",1,5,"Erna",2,8,"Hanna",3]
[24,"HR",2,5,"Erna",2,9,"Ignatz",3]
[25,"HR",1,6,"Fritz",2,7,"Georg",3]
[26,"HR",2,6,"Fritz",2,8,"Hanna",3]
[27,"HR",1,6,"Fritz",2,9,"Ignatz",3]
[28,"RR",2,1,"Albert",1,4,"Daniel",2]
[29,"RR",1,1,"Albert",1,5,"Erna",2]
[30,"RR",2,1,"Albert",1,6,"Fritz",2]
[31,"RR",1,1,"Albert",1,7,"Georg",3]
[32,"RR",2,1,"Albert",1,8,"Hanna",3]
[33,"RR",1,1,"Albert",1,9,"Ignatz",3]
[34,"RR",2,2,"Berta",1,4,"Daniel",2]
[35,"RR",1,2,"Berta",1,5,"Erna",2]
[36,"RR",2,2,"Berta",1,6,"Fritz",2]
[37,"RR",1,2,"Berta",1,7,"Georg",3]
[38,"RR",2,2,"Berta",1,8,"Hanna",3]
[39,"RR",1,2,"Berta",1,9,"Ignatz",3]
[40,"RR",2,3,"Carlos",1,4,"Daniel",2]
[41,"RR",1,3,"Carlos",1,5,"Erna",2]
[42,"RR",2,3,"Carlos",1,6,"Fritz",2]
[43,"RR",1,3,"Carlos",1,7,"Georg",3]
[44,"RR",2,3,"Carlos",1,8,"Hanna",3]
[45,"RR",1,3,"Carlos",1,9,"Ignatz",3]
[46,"RR",2,4,"Daniel",2,7,"Georg",3]
[47,"RR",1,4,"Daniel",2,8,"Hanna",3]
[48,"RR",2,4,"Daniel",2,9,"Ignatz",3]
[49,"RR",1,5,"Erna",2,7,"Georg",3]
[50,"RR",2,5,"Erna",2,8,"Hanna",3]
[51,"RR",1,5,"Erna",2,9,"Ignatz",3]
[52,"RR",2,6,"Fritz",2,7,"Georg",3]
[53,"RR",1,6,"Fritz",2,8,"Hanna",3]
[54,"RR",2,6,"Fritz",2,9,"Ignatz",3]

{"sheet":"Spielplan","index":2,"n_rows":30,"n_cols":22,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,9,2,10],[1,1,1,10],[1,13,1,22],[2,21,2,22]]}
[]
[null,"Scheibe 1",null,null,null,null,null,null,null,null,null,null,null,"Scheibe 1"]
["Anlauf","Game ID","HR/RR","Spieler ID","Spieler Name","Team","Spieler ID","Spieler Name","Team","Ergebnis",null,null,"Anlauf","Game ID","HR/RR","Spieler ID","Spieler Name","Team","Spieler ID","Spieler Name","Team","Ergebnis"]
[{"$f":"_xlfn.SEQUENCE(ROWS(RawData[Game_ID])/2)","v":1},{"$f":"_xlfn.VSTACK(RandomGameIds(\"HR\",1),RandomGameIds(\"RR\",1))","v":27},{"$f":"_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($B$4),RawData[Game_ID],RawData[HR_RR])","v":"HR"},{"$f":"_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($B$4),RawData[Game_ID],RawData[SpielerA_ID])","v":6},{"$f":"_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($B$4),RawData[Game_ID],RawData[SpielerA_Name])","v":"Fritz"},{"$f":"_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($B$4),RawData[Game_ID],RawData[SpielerA_Team])","v":2},{"$f":"_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($B$4),RawData[Game_ID],RawData[SpielerB_ID])","v":9},{"$f":"_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($B$4),RawData[Game_ID],RawData[SpielerB_Name])","v":"Ignatz"},{"$f":"_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($B$4),RawData[Game_ID],RawData[SpielerB_Team])","v":3},null,null,null,{"$f":"_xlfn.SEQUENCE(ROWS(RawData[Game_ID])/2)","v":1},{"$f":"_xlfn.VSTACK(RandomGameIds(\"HR\",2),RandomGameIds(\"RR\",2))","v":14},{"$f":"_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($B$4),RawData[Game_ID],RawData[HR_RR])","v":"HR"},{"$f":"_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($B$4),RawData[Game_ID],RawData[SpielerA_ID])","v":6},{"$f":"_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($B$4),RawData[Game_ID],RawData[SpielerA_Name])","v":"Fritz"},{"$f":"_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($B$4),RawData[Game_ID],RawData[SpielerA_Team])","v":2},{"$f":"_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($B$4),RawData[Game_ID],RawData[SpielerB_ID])","v":9},{"$f":"_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($B$4),RawData[Game_ID],RawData[SpielerB_Name])","v":"Ignatz"},{"$f":"_xlfn.XLOOKUP(_xlfn.ANCHORARRAY($B$4),RawData[Game_ID],RawData[SpielerB_Team])","v":3}]
[2,15,"HR",3,"Carlos",1,6,"Fritz",2,null,null,null,2,6,"HR",3,"Carlos",1,6,"Fritz",2]
[3,3,"HR",1,"Albert",1,6,"Fritz",2,null,null,null,3,4,"HR",1,"Albert",1,6,"Fritz",2]
[4,17,"HR",3,"Carlos",1,8,"Hanna",3,null,null,null,4,2,"HR",3,"Carlos",1,8,"Hanna",3]
[5,1,"HR",1,"Albert",1,4,"Daniel",2,null,null,null,5,12,"HR",1,"Albert",1,4,"Daniel",2]
[6,13,"HR",3,"Carlos",1,4,"Daniel",2,null,null,null,6,10,"HR",3,"Carlos",1,4,"Daniel",2]
[7,19,"HR",4,"Daniel",2,7,"Georg",3,null,null,null,7,22,"HR",4,"Daniel",2,7,"Georg",3]
[8,7,"HR",2,"Berta",1,4,"Daniel",2,null,null,null,8,20,"HR",2,"Berta",1,4,"Daniel",2]
[9,9,"HR",2,"Berta",1,6,"Fritz",2,null,null,null,9,8,"HR",2,"Berta",1,6,"Fritz",2]
[10,23,"HR",5,"Erna",2,8,"Hanna",3,null,null,null,10,26,"HR",5,"Erna",2,8,"Hanna",3]
[11,11,"HR",2,"Berta",1,8,"Hanna",3,null,null,null,11,16,"HR",2,"Berta",1,8,"Hanna",3]
[12,25,"HR",6,"Fritz",2,7,"Georg",3,null,null,null,12,18,"HR",6,"Fritz",2,7,"Georg",3]
[13,21,"HR",4,"Daniel",2,9,"Ignatz",3,null,null,null,13,24,"HR",4,"Daniel",2,9,"Ignatz",3]
[14,5,"HR",1,"Albert",1,8,"Hanna",3,null,null,null,14,36,"HR",1,"Albert",1,8,"Hanna",3]
[15,35,"RR",2,"Berta",1,5,"Erna",2,null,null,null,15,28,"RR",2,"Berta",1,5,"Erna",2]
[16,33,"RR",1,"Albert",1,9,"Ignatz",3,null,null,null,16,50,"RR",1,"Albert",1,9,"Ignatz",3]
[17,39,"RR",2,"Berta",1,9,"Ignatz",3,null,null,null,17,46,"RR",2,"Berta",1,9,"Ignatz",3]
[18,31,"RR",1,"Albert",1,7,"Georg",3,null,null,null,18,32,"RR",1,"Albert",1,7,"Georg",3]
[19,41,"RR",3,"Carlos",1,5,"Erna",2,null,null,null,19,44,"RR",3,"Carlos",1,5,"Erna",2]
[20,29,"RR",1,"Albert",1,5,"Erna",2,null,null,null,20,40,"RR",1,"Albert",1,5,"Erna",2]
[21,47,"RR",4,"Daniel",2,8,"Hanna",3,null,null,null,21,42,"RR",4,"Daniel",2,8,"Hanna",3]
[22,37,"RR",2,"Berta",1,7,"Georg",3,null,null,null,22,52,"RR",2,"Berta",1,7,"Georg",3]
[23,51,"RR",5,"Erna",2,9,"Ignatz",3,null,null,null,23,30,"RR",5,"Erna",2,9,"Ignatz",3]
[24,49,"RR",5,"Erna",2,7,"Georg",3,null,null,null,24,54,"RR",5,"Erna",2,7,"Georg",3]
[25,45,"RR",3,"Carlos",1,9,"Ignatz",3,null,null,null,25,34,"RR",3,"Carlos",1,9,"Ignatz",3]
[26,53,"RR",6,"Fritz",2,8,"Hanna",3,null,null,null,26,38,"RR",6,"Fritz",2,8,"Hanna",3]
[27,43,"RR",3,"Carlos",1,7,"Georg",3,null,null,null,27,48,"RR",3,"Carlos",1,7,"Georg",3]