{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Working","ChangeLog","Setup","Players","Matrix","Table","Round1","Round2","Round3","Round4","Round5","Round6","Round7","Round8","Round9"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Working","index":0,"n_rows":3,"n_cols":27,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Latest Rd:",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Players:",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stats:",7]

{"sheet":"ChangeLog","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"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)"]
[]
["Version","Summary","Date","Notes"]
["1.0","Multi-sheet version of the chess","2016-06-19"]
[1.1000000000000001,"Remove Black and White stuff","2016-06-19"]
[1.2,"Change to TDs to generate points","2016-06-19"]
[null,"Got the Swiss working properly",null,"Published."]
[1.3,"More help information.","2016-06-20"]
[null,"Added Table"]
[null,"Added Opponent Score"]
[2.1,"Big overhaul to where info stored","2016-06-21"]
[2.2000000000000002,"Putting in the Score formula","2016-06-21","Published."]

{"sheet":"Setup","index":2,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Name of Bonus1","Name of Bonus2"]
["Headings:","Player","Points","TD","Cas","Bonus1","Bonus2","Opponent Score"]
[]
[]
["SCORING SETUP"]
[]
["Points for…"]
["Win by at least 2 TD",9]
["Win by 1 TD",6]
["Draw",3,null,null,null,null,null,null,null,"Buttons for running a tournament:"]
["Lose by 1 TD",1]
["Lose by at least 2 TD",0]
[]
["Assume 1 Point per TD/Cas/Etc up to…"]
["Max TD Bonus Pts",3]
["Max Cas Bonus Pts",3]
["Max Bonus1 Bonus Pts",2]
["Max Bonus2 Bonus Pts",2]
[]
["Test Scoring System Here"]
["Your Score (required)",2]
["Opponent Score (required)",4]
["Your Cas (optional)",3]
["Your Bonus 1 (optional)"]
["Your Bonus 2 (optional)"]
[]
["Your Points",{"$f":"fctScore(B21,B22,B23,B24,B25)","v":5}]

{"sheet":"Players","index":3,"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":"Matrix","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

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

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

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

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

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

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

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

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

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

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