{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Macro","Simple udf","round-robin tournament","Double round-robin tournament"],"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":"Macro","index":0,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Teams/Players",null,null,"Instructions"]
["Player 1",null,null,"1. Add team or player names to column A",null,null,null,null,null,null,"Website:","Get Digital Help"]
["Player 2",null,null,"2. Click button below to generate schedule",null,null,null,null,null,null,"Webpage:","How to generate a round-robin tournament"]
["Player 3"]
["Player 4"]
["Player 5"]
["Player 6"]
["Player 7"]
["Player 8"]
["Player 9"]
["Player 10"]

{"sheet":"Simple udf","index":1,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Teams",null,"Home","Away",null,"Teams"]
["Team A",null,{"$f":"RoundRobin(A2:A7)","v":"Team A"},"Team B",null,"Team A",null,"Website:","Get Digital Help"]
["Team B",null,"Team A","Team C",null,"Team B",null,"Webpage:","How to generate a round-robin tournament"]
["Team C",null,"Team A","Team D",null,"Team C"]
["Team D",null,"Team A","Team E",null,"Team D"]
["Team E",null,"Team A","Team F",null,"Team E"]
["Team F",null,"Team B","Team C",null,"Team F"]
[null,null,"Team B","Team D"]
[null,null,"Team B","Team E"]
[null,null,"Team B","Team F"]
[null,null,"Team C","Team D"]
[null,null,"Team C","Team E"]
[null,null,"Team C","Team F"]
[null,null,"Team D","Team E"]
[null,null,"Team D","Team F"]
[null,null,"Team E","Team F"]

{"sheet":"round-robin tournament","index":2,"n_rows":16,"n_cols":17,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Teams",null,"Round","Home","Away",null,null,null,null,null,"Team","Home","Away"]
["Team A",null,{"$f":"RoundRobin2(A2:A7)","v":1},"Team A","Team E",null,null,null,null,null,"Team A",{"$f":"COUNTIF($D$2:$D$16,K2)","v":3},{"$f":"COUNTIF($E$2:$E$16,K2)","v":2},null,null,"Website:","Get Digital Help"]
["Team B",null,1,"Team C","Team F",null,null,null,null,null,"Team B",{"$f":"COUNTIF($D$2:$D$16,K3)","v":2},{"$f":"COUNTIF($E$2:$E$16,K3)","v":3},null,null,"Webpage:","How to generate a round-robin tournament"]
["Team C",null,1,"Team B","Team D",null,null,null,null,null,"Team C",4,1]
["Team D",null,2,"Team C","Team A",null,null,null,null,null,"Team D",2,3]
["Team E",null,2,"Team E","Team B",null,null,null,null,null,"Team E",2,3]
["Team F",null,2,"Team F","Team D",null,null,null,null,null,"Team F",2,3]
[null,null,3,"Team A","Team B"]
[null,null,3,"Team D","Team C"]
[null,null,3,"Team F","Team E"]
[null,null,4,"Team D","Team A"]
[null,null,4,"Team B","Team F"]
[null,null,4,"Team C","Team E"]
[null,null,5,"Team A","Team F"]
[null,null,5,"Team E","Team D"]
[null,null,5,"Team C","Team B"]

{"sheet":"Double round-robin tournament","index":3,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Teams",null,"Round","Home","Away",null,"Team","Home","Away"]
["Team A",null,{"$f":"DoubleRoundRobin(A2:A7)","v":1},"Team B","Team D",null,"Team A",{"$f":"COUNTIF($D$2:$D$31,G2)","v":5},{"$f":"COUNTIF($E$2:$E$31,G2)","v":5},null,"Website:","Get Digital Help"]
["Team B",null,1,"Team C","Team A",null,"Team B",{"$f":"COUNTIF($D$2:$D$31,G3)","v":5},{"$f":"COUNTIF($E$2:$E$31,G3)","v":5},null,"Webpage:","How to generate a round-robin tournament"]
["Team C",null,1,"Team E","Team F",null,"Team C",5,5]
["Team D",null,2,"Team C","Team B",null,"Team D",5,5]
["Team E",null,2,"Team D","Team E",null,"Team E",5,5]
["Team F",null,2,"Team A","Team F",null,"Team F",5,5]
[null,null,3,"Team B","Team E"]
[null,null,3,"Team F","Team C"]
[null,null,3,"Team A","Team D"]
[null,null,4,"Team F","Team B"]
[null,null,4,"Team E","Team A"]
[null,null,4,"Team C","Team D"]
[null,null,5,"Team B","Team A"]
[null,null,5,"Team D","Team F"]
[null,null,5,"Team C","Team E"]
[null,null,6,"Team D","Team B"]
[null,null,6,"Team A","Team C"]
[null,null,6,"Team F","Team E"]
[null,null,7,"Team B","Team C"]
[null,null,7,"Team E","Team D"]
[null,null,7,"Team F","Team A"]
[null,null,8,"Team E","Team B"]
[null,null,8,"Team C","Team F"]
[null,null,8,"Team D","Team A"]
[null,null,9,"Team B","Team F"]
[null,null,9,"Team A","Team E"]
[null,null,9,"Team D","Team C"]
[null,null,10,"Team A","Team B"]
[null,null,10,"Team F","Team D"]
[null,null,10,"Team E","Team C"]
[null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]