{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["ChangeLog","Setup","Players","Statistics","Round1","Round2","Round3","Round4","Round5","Round6","Round7","Round8","Round9","Original Description"],"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":"ChangeLog","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"This spreadsheet is based on one by Kaper on an Excel forum: http://www.excelforum.com/excel-programming-vba-macros/1105569-swiss-pairing-algorithm-in-excel-to-organize-a-chess-tournament.html"]
[null,"Massive thanks due to him!"]
[null,"The original was used for Chess, and it has been adapted to work for Blood Bowl by sann0638 (Mike Davies)"]
[]
[]
["1.0","Multi-sheet version of the chess"]
[1.1000000000000001,"Remove Black and White stuff"]
[1.2,"Change to TDs to generate points"]
[null,"Got the Swiss working properly"]

{"sheet":"Setup","index":1,"n_rows":5,"n_cols":14,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Headings","Home","Away","Home Points","Away Points","Home TD","Away TD"]
[null,null,null,{"$f":"IF(F2>G2,10+F2,IF(F2=G2,5+F2,F2))","v":{"$error":"#VALUE!"}},{"$f":"IF(F2<G2,10+G2,IF(F2=G2,5+G2,G2))","v":{"$error":"#VALUE!"}},"Enter","Enter"]
[]
[]
[null,null,null,null,null,null,null,null,"Main buttons",null,null,null,null,"Extra buttons"]

{"sheet":"Players","index":2,"n_rows":51,"n_cols":2,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Ord","Name"]
[{"$f":"IF(B2=\"\",\"\",MAX(A$1:A1)+1)","v":1},"Player1"]
[{"$f":"IF(B3=\"\",\"\",MAX(A$1:A2)+1)","v":2},"Player2"]
[{"$f":"IF(B4=\"\",\"\",MAX(A$1:A3)+1)","v":3},"Player3"]
[{"$f":"IF(B5=\"\",\"\",MAX(A$1:A4)+1)","v":4},"Player4"]
[{"$f":"IF(B6=\"\",\"\",MAX(A$1:A5)+1)","v":5},"Player5"]
[{"$f":"IF(B7=\"\",\"\",MAX(A$1:A6)+1)","v":6},"Player6"]
[{"$f":"IF(B8=\"\",\"\",MAX(A$1:A7)+1)","v":7},"Player7"]
[{"$f":"IF(B9=\"\",\"\",MAX(A$1:A8)+1)","v":8},"Player8"]
[{"$f":"IF(B10=\"\",\"\",MAX(A$1:A9)+1)","v":9},"Player9"]
[{"$f":"IF(B11=\"\",\"\",MAX(A$1:A10)+1)","v":10},"Player10"]
[{"$f":"IF(B12=\"\",\"\",MAX(A$1:A11)+1)","v":11},"Player11"]
[{"$f":"IF(B13=\"\",\"\",MAX(A$1:A12)+1)","v":12},"Player12"]
[{"$f":"IF(B14=\"\",\"\",MAX(A$1:A13)+1)","v":13},"Player13"]
[{"$f":"IF(B15=\"\",\"\",MAX(A$1:A14)+1)","v":14},"Player14"]
[{"$f":"IF(B16=\"\",\"\",MAX(A$1:A15)+1)","v":15},"Player15"]
[{"$f":"IF(B17=\"\",\"\",MAX(A$1:A16)+1)","v":16},"Player16"]
[{"$f":"IF(B18=\"\",\"\",MAX(A$1:A17)+1)","v":17},"Player17"]
[{"$f":"IF(B19=\"\",\"\",MAX(A$1:A18)+1)","v":18},"Player18"]
[{"$f":"IF(B20=\"\",\"\",MAX(A$1:A19)+1)","v":19},"Player19"]
[{"$f":"IF(B21=\"\",\"\",MAX(A$1:A20)+1)","v":20},"Player20"]
[{"$f":"IF(B22=\"\",\"\",MAX(A$1:A21)+1)","v":21},"Player21"]
[{"$f":"IF(B23=\"\",\"\",MAX(A$1:A22)+1)","v":22},"Player22"]
[{"$f":"IF(B24=\"\",\"\",MAX(A$1:A23)+1)","v":23},"Player23"]
[{"$f":"IF(B25=\"\",\"\",MAX(A$1:A24)+1)","v":24},"Player24"]
[{"$f":"IF(B26=\"\",\"\",MAX(A$1:A25)+1)","v":25},"Player25"]
[{"$f":"IF(B27=\"\",\"\",MAX(A$1:A26)+1)","v":26},"Player26"]
[{"$f":"IF(B28=\"\",\"\",MAX(A$1:A27)+1)","v":27},"Player27"]
[{"$f":"IF(B29=\"\",\"\",MAX(A$1:A28)+1)","v":28},"Player28"]
[{"$f":"IF(B30=\"\",\"\",MAX(A$1:A29)+1)","v":29},"Player29"]
[{"$f":"IF(B31=\"\",\"\",MAX(A$1:A30)+1)","v":30},"Player30"]
[{"$f":"IF(B32=\"\",\"\",MAX(A$1:A31)+1)","v":31},"Player31"]
[{"$f":"IF(B33=\"\",\"\",MAX(A$1:A32)+1)","v":32},"Player32"]
[{"$f":"IF(B34=\"\",\"\",MAX(A$1:A33)+1)","v":33},"Player33"]
[{"$f":"IF(B35=\"\",\"\",MAX(A$1:A34)+1)","v":34},"Player34"]
[{"$f":"IF(B36=\"\",\"\",MAX(A$1:A35)+1)","v":35},"Player35"]
[{"$f":"IF(B37=\"\",\"\",MAX(A$1:A36)+1)","v":36},"Player36"]
[{"$f":"IF(B38=\"\",\"\",MAX(A$1:A37)+1)","v":37},"Player37"]
[{"$f":"IF(B39=\"\",\"\",MAX(A$1:A38)+1)","v":38},"Player38"]
[{"$f":"IF(B40=\"\",\"\",MAX(A$1:A39)+1)","v":39},"Player39"]
[{"$f":"IF(B41=\"\",\"\",MAX(A$1:A40)+1)","v":40},"Player40"]
[{"$f":"IF(B42=\"\",\"\",MAX(A$1:A41)+1)","v":""}]
[{"$f":"IF(B43=\"\",\"\",MAX(A$1:A42)+1)","v":""}]
[{"$f":"IF(B44=\"\",\"\",MAX(A$1:A43)+1)","v":""}]
[{"$f":"IF(B45=\"\",\"\",MAX(A$1:A44)+1)","v":""}]
[{"$f":"IF(B46=\"\",\"\",MAX(A$1:A45)+1)","v":""}]
[{"$f":"IF(B47=\"\",\"\",MAX(A$1:A46)+1)","v":""}]
[{"$f":"IF(B48=\"\",\"\",MAX(A$1:A47)+1)","v":""}]
[{"$f":"IF(B49=\"\",\"\",MAX(A$1:A48)+1)","v":""}]
[{"$f":"IF(B50=\"\",\"\",MAX(A$1:A49)+1)","v":""}]
[{"$f":"IF(B51=\"\",\"\",MAX(A$1:A50)+1)","v":""}]

{"sheet":"Statistics","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Round1","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Round2","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Round3","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Round4","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Round5","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Round6","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Round7","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Round8","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Round9","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Original Description","index":13,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["From:"]
["http://www.excelforum.com/excel-programming-vba-macros/1105569-swiss-pairing-algorithm-in-excel-to-organize-a-chess-tournament.html"]
[]
[]
["For now I try to figure out but maybe someone has already the answer; I want to use excel to pair chess players using swiss system for tournament, in my case it will be maximum 30 players(player1, player2...), in first round they will be randomly paired, then rules are as below:"]
["Winner : +1 point",null,"Draw: 0.5 points both",null,null,"Loose: 0 point"]
["More than 30 will also be OK."]
[]
["a","The number of rounds to be played is declared beforehand: In our case \"5\" rounds is OK."]
["Can be more. Every Round is generated on the basis of existing history. User has to just stop after 5 rounds."]
[]
["b","Two players shall not play each other more than once"]
["Tested during new Round generation"]
[]
["c","Should the total number of players be (or become) odd, one player is unpaired. He receives a bye: no color and as many points as are rewarded for a win"]
["Only \"be\" It is assumed all players are available in all Rounds"]
[]
["d","A player who, for whatever reason, has received any number of points without playing, shall not receive a bye."]
["Only situation where player receives points without playing in this spreadsheet is a bye"]
[]
["e","In general, players are paired to others with the same score, if it is impossible they should pair with scores as close as possible, meaning for example at the final round (5th round) the strongest player can not match the player at 10th place or further, it must be someone around 3rd-6th place."]
["It normally is a player only with the same result so far (could happen that let's say 10 players share the same result) or just next worse"]
[]
["f","For each player the difference of the number of black and the number of white games shall not be greater than 2 or less than –2."]
[null,"Each system may have exceptions to this rule in the last round of a tournament."]
["Tested, but as rule g. is tested, and with alternating color rule (h2) it would rather not happen"]
[]
["g","No player will receive the same color three times in a row."]
[null,"Each system may have exceptions to this rule in the last round of a tournament."]
["Tested"]
[]
["h","1.In general, a player is given a color as many times as he is given the other color."]
["see h2 and f"]
[null,"2.In general, a player is given the color other than that he was given the previous round."]
["Tested"]