{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["說明","０比賽 ","０比賽 R5桌次","０比賽 R4桌次","０比賽 R3桌次","０比賽 R2桌次","０比賽 R1桌次"],"not_rendered":{"charts":0,"images":2,"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":"說明","index":0,"n_rows":32,"n_cols":1,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["本檔案為VBA寫成，請將巨集安全性調低，並重啓EXCEL後，程式才能作用，各版EXCEL設定方式如下網址"]
["http://oese.blogspot.tw/2012/10/office-200720102003.html"]
[]
["操作說明："]
["原始狀態（任意雙撃（滑鼠左鍵連點兩下）會回到原始狀態），會有下列按鈕"]
["算分按鈕（可計算排名）"]
["排序按鈕（可依籤號或名次排序）"]
[]
["雙擊瑞士制或單循環（可切換賽制），會出現下列按鈕"]
["抽籤按鈕（可打亂選手順序）"]
["重設按鈕（可清空並重設戰積表）"]
["　瑞士制時，依人數和輪數設定戰積表"]
["　單循環時，依人數計算所需輪數，賽程按Berger法編排"]
[]
["雙擊輪次編號（R1對手、R2對手..）（可對該輪抓對），會出現下列按鈕"]
["抓對按鈕（瑞士制才有，依瑞士制配對該輪對戰組合）"]
["　對手號碼藍色為開局方：開局數較少者優先開局，若相同則單數輪籤號小者開局，雙數輪籤號大者開局"]
["　若人有棄賽，雙擊姓名可加上刪除線（在第一輪抓對後才有反應），則抓對時會排除，排名也會墊底"]
["雙擊該輪計分欄可填入及修改該輪的分數，勝分決定每輪可得最高分數"]
[]
[]
["輔分說明："]
["輔分一：所遇對手之總分和"]
["輔分二：（所勝對手之總分）＋（所和對手之總分的一半）"]
["輔分三：彼此對戰之勝負"]
["輔分四：所遇對手之輔分一"]
["輔分五：所遇對手之輔分二"]
["輔分六：（所勝對手之輔分一）＋（所和對手之輔分一的一半）"]
["輔分七：（所勝對手之輔分二）＋（所和對手之輔分二的一半）"]
[]
["待解決："]
["輪高輪低"]

{"sheet":"０比賽 ","index":1,"n_rows":11,"n_cols":21,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["賽制","瑞士制","勝分",4]
["人數",8,"輪數",5]
["籤號","姓名","R1","對手","R2","對手","R3","對手","R4","對手","R5","對手","總分","輔一","輔二","輔三","輔四","輔五","輔六","輔七","名次"]
[1,"黃彥樺",4,2,0,4,4,6,0,5,4,3,{"$f":"+C4+E4+G4+I4+K4","v":12},{"$f":"+SUMIF(A:A,D4,$M$1)+SUMIF(A:A,F4,$M$1)+SUMIF(A:A,H4,$M$1)+SUMIF(A:A,J4,$M$1)+SUMIF(A:A,L4,$M$1)","v":36},{"$f":"(+C4*SUMIF(A:A,D4,$M$1)+E4*SUMIF(A:A,F4,$M$1)+G4*SUMIF(A:A,H4,$M$1)+I4*SUMIF(A:A,J4,$M$1)+K4*SUMIF(A:A,L4,$M$1))/4","v":12},0,{"$f":"+SUMIF(A:A,D4,$N$1)+SUMIF(A:A,F4,$N$1)+SUMIF(A:A,H4,$N$1)+SUMIF(A:A,J4,$N$1)+SUMIF(A:A,L4,$N$1)","v":220},{"$f":"+SUMIF(A:A,D4,$O$1)+SUMIF(A:A,F4,$O$1)+SUMIF(A:A,H4,$O$1)+SUMIF(A:A,J4,$O$1)+SUMIF(A:A,L4,$O$1)","v":60},{"$f":"(+C4*SUMIF(A:A,D4,$N$1)+E4*SUMIF(A:A,F4,$N$1)+G4*SUMIF(A:A,H4,$N$1)+I4*SUMIF(A:A,J4,$N$1)+K4*SUMIF(A:A,L4,$N$1))/4","v":128},{"$f":"(+C4*SUMIF(A:A,D4,$O$1)+E4*SUMIF(A:A,F4,$O$1)+G4*SUMIF(A:A,H4,$O$1)+I4*SUMIF(A:A,J4,$O$1)+K4*SUMIF(A:A,L4,$O$1))/4","v":8},4]
[2,"謝榮國",0,1,4,3,0,7,0,8,null,4,{"$f":"+C5+E5+G5+I5+K5","v":4},{"$f":"+SUMIF(A:A,D5,$M$1)+SUMIF(A:A,F5,$M$1)+SUMIF(A:A,H5,$M$1)+SUMIF(A:A,J5,$M$1)+SUMIF(A:A,L5,$M$1)","v":40},{"$f":"(+C5*SUMIF(A:A,D5,$M$1)+E5*SUMIF(A:A,F5,$M$1)+G5*SUMIF(A:A,H5,$M$1)+I5*SUMIF(A:A,J5,$M$1)+K5*SUMIF(A:A,L5,$M$1))/4","v":0},0,{"$f":"+SUMIF(A:A,D5,$N$1)+SUMIF(A:A,F5,$N$1)+SUMIF(A:A,H5,$N$1)+SUMIF(A:A,J5,$N$1)+SUMIF(A:A,L5,$N$1)","v":204},{"$f":"+SUMIF(A:A,D5,$O$1)+SUMIF(A:A,F5,$O$1)+SUMIF(A:A,H5,$O$1)+SUMIF(A:A,J5,$O$1)+SUMIF(A:A,L5,$O$1)","v":48},{"$f":"(+C5*SUMIF(A:A,D5,$N$1)+E5*SUMIF(A:A,F5,$N$1)+G5*SUMIF(A:A,H5,$N$1)+I5*SUMIF(A:A,J5,$N$1)+K5*SUMIF(A:A,L5,$N$1))/4","v":40},{"$f":"(+C5*SUMIF(A:A,D5,$O$1)+E5*SUMIF(A:A,F5,$O$1)+G5*SUMIF(A:A,H5,$O$1)+I5*SUMIF(A:A,J5,$O$1)+K5*SUMIF(A:A,L5,$O$1))/4","v":0},7]
[3,"李祖明",0,4,0,2,0,8,0,6,0,1,{"$f":"+C6+E6+G6+I6+K6","v":0},{"$f":"+SUMIF(A:A,D6,$M$1)+SUMIF(A:A,F6,$M$1)+SUMIF(A:A,H6,$M$1)+SUMIF(A:A,J6,$M$1)+SUMIF(A:A,L6,$M$1)","v":40},{"$f":"(+C6*SUMIF(A:A,D6,$M$1)+E6*SUMIF(A:A,F6,$M$1)+G6*SUMIF(A:A,H6,$M$1)+I6*SUMIF(A:A,J6,$M$1)+K6*SUMIF(A:A,L6,$M$1))/4","v":0},0,{"$f":"+SUMIF(A:A,D6,$N$1)+SUMIF(A:A,F6,$N$1)+SUMIF(A:A,H6,$N$1)+SUMIF(A:A,J6,$N$1)+SUMIF(A:A,L6,$N$1)","v":208},{"$f":"+SUMIF(A:A,D6,$O$1)+SUMIF(A:A,F6,$O$1)+SUMIF(A:A,H6,$O$1)+SUMIF(A:A,J6,$O$1)+SUMIF(A:A,L6,$O$1)","v":36},{"$f":"(+C6*SUMIF(A:A,D6,$N$1)+E6*SUMIF(A:A,F6,$N$1)+G6*SUMIF(A:A,H6,$N$1)+I6*SUMIF(A:A,J6,$N$1)+K6*SUMIF(A:A,L6,$N$1))/4","v":0},{"$f":"(+C6*SUMIF(A:A,D6,$O$1)+E6*SUMIF(A:A,F6,$O$1)+G6*SUMIF(A:A,H6,$O$1)+I6*SUMIF(A:A,J6,$O$1)+K6*SUMIF(A:A,L6,$O$1))/4","v":0},8]
[4,"廖仲彥",4,3,4,1,0,5,0,7,null,2,{"$f":"+C7+E7+G7+I7+K7","v":8},{"$f":"+SUMIF(A:A,D7,$M$1)+SUMIF(A:A,F7,$M$1)+SUMIF(A:A,H7,$M$1)+SUMIF(A:A,J7,$M$1)+SUMIF(A:A,L7,$M$1)","v":44},{"$f":"(+C7*SUMIF(A:A,D7,$M$1)+E7*SUMIF(A:A,F7,$M$1)+G7*SUMIF(A:A,H7,$M$1)+I7*SUMIF(A:A,J7,$M$1)+K7*SUMIF(A:A,L7,$M$1))/4","v":12},0,{"$f":"+SUMIF(A:A,D7,$N$1)+SUMIF(A:A,F7,$N$1)+SUMIF(A:A,H7,$N$1)+SUMIF(A:A,J7,$N$1)+SUMIF(A:A,L7,$N$1)","v":208},{"$f":"+SUMIF(A:A,D7,$O$1)+SUMIF(A:A,F7,$O$1)+SUMIF(A:A,H7,$O$1)+SUMIF(A:A,J7,$O$1)+SUMIF(A:A,L7,$O$1)","v":72},{"$f":"(+C7*SUMIF(A:A,D7,$N$1)+E7*SUMIF(A:A,F7,$N$1)+G7*SUMIF(A:A,H7,$N$1)+I7*SUMIF(A:A,J7,$N$1)+K7*SUMIF(A:A,L7,$N$1))/4","v":76},{"$f":"(+C7*SUMIF(A:A,D7,$O$1)+E7*SUMIF(A:A,F7,$O$1)+G7*SUMIF(A:A,H7,$O$1)+I7*SUMIF(A:A,J7,$O$1)+K7*SUMIF(A:A,L7,$O$1))/4","v":12},6]
[5,"林皇羽",4,6,4,7,4,4,4,1,null,8,{"$f":"+C8+E8+G8+I8+K8","v":16},{"$f":"+SUMIF(A:A,D8,$M$1)+SUMIF(A:A,F8,$M$1)+SUMIF(A:A,H8,$M$1)+SUMIF(A:A,J8,$M$1)+SUMIF(A:A,L8,$M$1)","v":48},{"$f":"(+C8*SUMIF(A:A,D8,$M$1)+E8*SUMIF(A:A,F8,$M$1)+G8*SUMIF(A:A,H8,$M$1)+I8*SUMIF(A:A,J8,$M$1)+K8*SUMIF(A:A,L8,$M$1))/4","v":40},0,{"$f":"+SUMIF(A:A,D8,$N$1)+SUMIF(A:A,F8,$N$1)+SUMIF(A:A,H8,$N$1)+SUMIF(A:A,J8,$N$1)+SUMIF(A:A,L8,$N$1)","v":212},{"$f":"+SUMIF(A:A,D8,$O$1)+SUMIF(A:A,F8,$O$1)+SUMIF(A:A,H8,$O$1)+SUMIF(A:A,J8,$O$1)+SUMIF(A:A,L8,$O$1)","v":56},{"$f":"(+C8*SUMIF(A:A,D8,$N$1)+E8*SUMIF(A:A,F8,$N$1)+G8*SUMIF(A:A,H8,$N$1)+I8*SUMIF(A:A,J8,$N$1)+K8*SUMIF(A:A,L8,$N$1))/4","v":172},{"$f":"(+C8*SUMIF(A:A,D8,$O$1)+E8*SUMIF(A:A,F8,$O$1)+G8*SUMIF(A:A,H8,$O$1)+I8*SUMIF(A:A,J8,$O$1)+K8*SUMIF(A:A,L8,$O$1))/4","v":52},1]
[6,"黃聖勳",0,5,4,8,0,1,4,3,null,7,{"$f":"+C9+E9+G9+I9+K9","v":8},{"$f":"+SUMIF(A:A,D9,$M$1)+SUMIF(A:A,F9,$M$1)+SUMIF(A:A,H9,$M$1)+SUMIF(A:A,J9,$M$1)+SUMIF(A:A,L9,$M$1)","v":48},{"$f":"(+C9*SUMIF(A:A,D9,$M$1)+E9*SUMIF(A:A,F9,$M$1)+G9*SUMIF(A:A,H9,$M$1)+I9*SUMIF(A:A,J9,$M$1)+K9*SUMIF(A:A,L9,$M$1))/4","v":8},0,{"$f":"+SUMIF(A:A,D9,$N$1)+SUMIF(A:A,F9,$N$1)+SUMIF(A:A,H9,$N$1)+SUMIF(A:A,J9,$N$1)+SUMIF(A:A,L9,$N$1)","v":208},{"$f":"+SUMIF(A:A,D9,$O$1)+SUMIF(A:A,F9,$O$1)+SUMIF(A:A,H9,$O$1)+SUMIF(A:A,J9,$O$1)+SUMIF(A:A,L9,$O$1)","v":76},{"$f":"(+C9*SUMIF(A:A,D9,$N$1)+E9*SUMIF(A:A,F9,$N$1)+G9*SUMIF(A:A,H9,$N$1)+I9*SUMIF(A:A,J9,$N$1)+K9*SUMIF(A:A,L9,$N$1))/4","v":80},{"$f":"(+C9*SUMIF(A:A,D9,$O$1)+E9*SUMIF(A:A,F9,$O$1)+G9*SUMIF(A:A,H9,$O$1)+I9*SUMIF(A:A,J9,$O$1)+K9*SUMIF(A:A,L9,$O$1))/4","v":4},5]
[7,"楊裕雄",4,8,0,5,4,2,4,4,null,6,{"$f":"+C10+E10+G10+I10+K10","v":12},{"$f":"+SUMIF(A:A,D10,$M$1)+SUMIF(A:A,F10,$M$1)+SUMIF(A:A,H10,$M$1)+SUMIF(A:A,J10,$M$1)+SUMIF(A:A,L10,$M$1)","v":44},{"$f":"(+C10*SUMIF(A:A,D10,$M$1)+E10*SUMIF(A:A,F10,$M$1)+G10*SUMIF(A:A,H10,$M$1)+I10*SUMIF(A:A,J10,$M$1)+K10*SUMIF(A:A,L10,$M$1))/4","v":20},0,{"$f":"+SUMIF(A:A,D10,$N$1)+SUMIF(A:A,F10,$N$1)+SUMIF(A:A,H10,$N$1)+SUMIF(A:A,J10,$N$1)+SUMIF(A:A,L10,$N$1)","v":220},{"$f":"+SUMIF(A:A,D10,$O$1)+SUMIF(A:A,F10,$O$1)+SUMIF(A:A,H10,$O$1)+SUMIF(A:A,J10,$O$1)+SUMIF(A:A,L10,$O$1)","v":64},{"$f":"(+C10*SUMIF(A:A,D10,$N$1)+E10*SUMIF(A:A,F10,$N$1)+G10*SUMIF(A:A,H10,$N$1)+I10*SUMIF(A:A,J10,$N$1)+K10*SUMIF(A:A,L10,$N$1))/4","v":124},{"$f":"(+C10*SUMIF(A:A,D10,$O$1)+E10*SUMIF(A:A,F10,$O$1)+G10*SUMIF(A:A,H10,$O$1)+I10*SUMIF(A:A,J10,$O$1)+K10*SUMIF(A:A,L10,$O$1))/4","v":16},2]
[8,"周黃有建",0,7,0,6,4,3,4,2,null,5,{"$f":"+C11+E11+G11+I11+K11","v":8},{"$f":"+SUMIF(A:A,D11,$M$1)+SUMIF(A:A,F11,$M$1)+SUMIF(A:A,H11,$M$1)+SUMIF(A:A,J11,$M$1)+SUMIF(A:A,L11,$M$1)","v":40},{"$f":"(+C11*SUMIF(A:A,D11,$M$1)+E11*SUMIF(A:A,F11,$M$1)+G11*SUMIF(A:A,H11,$M$1)+I11*SUMIF(A:A,J11,$M$1)+K11*SUMIF(A:A,L11,$M$1))/4","v":4},0,{"$f":"+SUMIF(A:A,D11,$N$1)+SUMIF(A:A,F11,$N$1)+SUMIF(A:A,H11,$N$1)+SUMIF(A:A,J11,$N$1)+SUMIF(A:A,L11,$N$1)","v":220},{"$f":"+SUMIF(A:A,D11,$O$1)+SUMIF(A:A,F11,$O$1)+SUMIF(A:A,H11,$O$1)+SUMIF(A:A,J11,$O$1)+SUMIF(A:A,L11,$O$1)","v":68},{"$f":"(+C11*SUMIF(A:A,D11,$N$1)+E11*SUMIF(A:A,F11,$N$1)+G11*SUMIF(A:A,H11,$N$1)+I11*SUMIF(A:A,J11,$N$1)+K11*SUMIF(A:A,L11,$N$1))/4","v":80},{"$f":"(+C11*SUMIF(A:A,D11,$O$1)+E11*SUMIF(A:A,F11,$O$1)+G11*SUMIF(A:A,H11,$O$1)+I11*SUMIF(A:A,J11,$O$1)+K11*SUMIF(A:A,L11,$O$1))/4","v":0},3]

{"sheet":"０比賽 R5桌次","index":2,"n_rows":9,"n_cols":22,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["桌號","籤號","姓名","R1","對手","R2","對手","R3","對手","R4","對手","R5","對手","總分","輔一","輔二","輔三","輔四","輔五","輔六","輔七","名次"]
[1,5,"林皇羽",4,6,4,7,4,4,4,1,null,8,16,36,36,0,140,48,140,48,1]
[1,8,"周黃有建",0,7,0,6,4,3,4,2,null,5,8,24,4,0,124,28,56,0,6]
[2,6,"黃聖勳",0,5,4,8,0,1,4,3,null,7,8,32,8,0,124,52,52,4,5]
[2,7,"楊裕雄",4,8,0,5,4,2,4,4,null,6,12,36,20,0,124,48,88,12,2]
[3,1,"黃彥樺",4,2,0,4,4,6,0,5,null,3,8,36,12,0,132,52,60,8,3]
[3,3,"李祖明",0,4,0,2,0,8,0,6,null,1,0,28,0,0,120,20,0,0,8]
[4,2,"謝榮國",0,1,4,3,0,7,0,8,null,4,4,28,0,0,124,36,28,0,7]
[4,4,"廖仲彥",4,3,4,1,0,5,0,7,null,2,8,36,8,0,136,68,64,12,4]

{"sheet":"０比賽 R4桌次","index":3,"n_rows":9,"n_cols":22,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["桌號","籤號","姓名","R1","對手","R2","對手","R3","對手","R4","對手","R5","對手","總分","輔一","輔二","輔三","輔四","輔五","輔六","輔七","名次"]
[1,5,"林皇羽",4,6,4,7,4,4,null,1,null,null,12,20,20,0,64,20,64,20,1]
[1,1,"黃彥樺",4,2,0,4,4,6,null,5,null,null,8,16,8,0,60,12,40,4,4]
[2,7,"楊裕雄",4,8,0,5,4,2,null,4,null,null,8,20,8,0,48,20,28,0,3]
[2,4,"廖仲彥",4,3,4,1,0,5,null,7,null,null,8,20,8,0,52,28,32,8,2]
[3,6,"黃聖勳",0,5,4,8,0,1,null,3,null,null,4,24,4,0,48,28,12,0,5]
[3,3,"李祖明",0,4,0,2,0,8,null,6,null,null,0,16,0,0,48,8,0,0,8]
[4,8,"周黃有建",0,7,0,6,4,3,null,2,null,null,4,12,0,0,60,12,16,0,7]
[4,2,"謝榮國",0,1,4,3,0,7,null,8,null,null,4,16,0,0,52,16,16,0,6]

{"sheet":"０比賽 R3桌次","index":4,"n_rows":9,"n_cols":22,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["桌號","籤號","姓名","R1","對手","R2","對手","R3","對手","R4","對手","R5","對手","總分","輔一","輔二","輔三","輔四","輔五","輔六","輔七","名次"]
[1,4,"廖仲彥",4,3,4,1,null,5,null,null,null,null,8,4,4,0,24,4,24,4,2]
[1,5,"林皇羽",4,6,4,7,null,4,null,null,null,null,8,8,8,0,16,0,16,0,1]
[2,6,"黃聖勳",0,5,4,8,null,1,null,null,null,null,4,8,0,0,16,8,8,0,4]
[2,1,"黃彥樺",4,2,0,4,null,6,null,null,null,null,4,12,4,0,8,4,4,0,3]
[3,2,"謝榮國",0,1,4,3,null,7,null,null,null,null,4,4,0,0,24,4,12,0,6]
[3,7,"楊裕雄",4,8,0,5,null,2,null,null,null,null,4,8,0,0,16,8,8,0,4]
[4,3,"李祖明",0,4,0,2,null,8,null,null,null,null,0,12,0,0,8,4,0,0,7]
[4,8,"周黃有建",0,7,0,6,null,3,null,null,null,null,0,8,0,0,16,0,0,0,8]

{"sheet":"０比賽 R2桌次","index":5,"n_rows":9,"n_cols":22,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["桌號","籤號","姓名","R1","對手","R2","對手","R3","對手","R4","對手","R5","對手","總分","輔一","輔二","輔三","輔四","輔五","輔六","輔七","名次"]
[1,4,"廖仲彥",4,3,null,1,null,null,null,null,null,null,4,0,0,0,4,0,4,0,1]
[1,1,"黃彥樺",4,2,null,4,null,null,null,null,null,null,4,0,0,0,4,0,4,0,1]
[2,7,"楊裕雄",4,8,null,5,null,null,null,null,null,null,4,0,0,0,4,0,4,0,1]
[2,5,"林皇羽",4,6,null,7,null,null,null,null,null,null,4,0,0,0,4,0,4,0,1]
[3,2,"謝榮國",0,1,null,3,null,null,null,null,null,null,0,4,0,0,0,0,0,0,5]
[3,3,"李祖明",0,4,null,2,null,null,null,null,null,null,0,4,0,0,0,0,0,0,5]
[4,8,"周黃有建",0,7,null,6,null,null,null,null,null,null,0,4,0,0,0,0,0,0,5]
[4,6,"黃聖勳",0,5,null,8,null,null,null,null,null,null,0,4,0,0,0,0,0,0,5]

{"sheet":"０比賽 R1桌次","index":6,"n_rows":9,"n_cols":22,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["桌號","籤號","姓名","R1","對手","R2","對手","R3","對手","R4","對手","R5","對手","總分","輔一","輔二","輔三","輔四","輔五","輔六","輔七","名次"]
[1,1,"黃彥樺",null,2,null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0]
[1,2,"謝榮國",null,1,null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0]
[2,3,"李祖明",null,4,null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0]
[2,4,"廖仲彥",null,3,null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0]
[3,5,"林皇羽",null,6,null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0]
[3,6,"黃聖勳",null,5,null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0]
[4,7,"楊裕雄",null,8,null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0]
[4,8,"周黃有健",null,7,null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0]