{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["集計用紙 ","選択データ","説明"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":18,"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":"集計用紙 ","index":0,"n_rows":40,"n_cols":71,"rows_kept":40,"cut":false,"hidden":false,"merged":[[14,7,14,9],[11,11,11,18],[11,20,11,27],[14,16,14,18],[14,25,14,27],[11,2,11,9],[12,20,12,21],[12,2,12,3],[12,4,12,9],[8,7,8,13],[8,14,8,21],[13,2,13,9],[11,1,13,1],[13,11,13,18],[13,20,13,27],[12,40,12,45],[6,38,6,45],[6,1,6,6],[8,22,8,29],[8,30,8,37],[8,38,8,45],[8,1,8,6],[11,29,11,36],[11,38,11,45],[12,22,12,27],[14,34,14,36],[12,11,12,12],[12,13,12,18],[18,56,18,70],[12,29,12,30],[12,31,12,36],[12,38,12,39],[14,43,14,45],[13,29,13,36],[13,38,13,45]]}
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"auto_open有効化"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false]
[]
[]
[null,"大会名\n"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2015-12-01T10:21:33.830"}]
[null,"Point\n ",null,null,null,null,null,"Class\n",null,null,null,null,null,null,"Round\n ",null,null,null,null,null,null,null,"Heat No.\n",null,null,null,null,null,null,null,"集計者\n",null,null,null,null,null,null,null,"集計チェック\n"]
[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,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,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,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,null,null,null,null,null,null,2,null,null,null,"欠場とノーライドの扱いが違う場合はここを変更する"]
[null,null,"欠場",false,"ノーライド",false,"出場",false,null,null,null,"欠場",false,"ノーライド",false,"出場",false,null,null,null,"欠場",false,"ノーライド",false,"出場",false,null,null,null,"欠場",false,"ノーライド",false,"出場",false,null,null,null,"欠場",false,"ノーライド",false,"出場",false,null,null,null,null,null,null,"出場人数","欠場","ノーライド","失格","順位(得点)","合計点数","有効点数","実質順位"]
[null,"　\n選手名\n支部\n","Red",null,null,null,null,null,null,null,null,"White",null,null,null,null,null,null,null,null,"Yellow",null,null,null,null,null,null,null,null,"Blue",null,null,null,null,null,null,null,null,"Green",null,null,null,null,null,null,null,null,null,null,"red",{"$f":"H11","v":false},{"$f":"IF(AY12,D11,FALSE)","v":false},{"$f":"IF(AY12,F11,FALSE)","v":false},{"$f":"IF(AY12,IF(K15<$BB$10,FALSE(),TRUE()),FALSE)","v":false},{"$f":"IF(BD12=\"\",\"\",BC21)","v":""},{"$f":"H15","v":""},{"$f":"IF(COUNTIF(AZ12:BB12,\"TRUE\"),\"\",BD12)","v":""},{"$f":"IF(AY12,IF(AZ12,\"-\",IF(OR(BB12,BA12),$AY$18,BC12)),\"\")","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"White",{"$f":"Q11","v":false},{"$f":"IF(AY13,M11,FALSE)","v":false},{"$f":"IF(AY13,O11,FALSE)","v":false},{"$f":"IF(AY13,IF(T15<$BB$10,FALSE(),TRUE()),FALSE)","v":false},{"$f":"IF(BD13=\"\",\"\",BC22)","v":""},{"$f":"Q15","v":""},{"$f":"IF(COUNTIF(AZ13:BB13,\"TRUE\"),\"\",BD13)","v":""},{"$f":"IF(AY13,IF(AZ13,\"-\",IF(OR(BB13,BA13),$AY$18,BC13)),\"\")","v":""}]
[null,null,{"$f":"BF12 & \"位\"","v":"位"},null,null,null,null,null,null,null,"妨害カウント",{"$f":"BF13 & \"位\"","v":"位"},null,null,null,null,null,null,null,"妨害カウント",{"$f":"BF14 & \"位\"","v":"位"},null,null,null,null,null,null,null,"妨害カウント",{"$f":"BF15 & \"位\"","v":"位"},null,null,null,null,null,null,null,"妨害カウント",{"$f":"BF16 & \"位\"","v":"位"},null,null,null,null,null,null,null,null,"妨害カウント",null,"Yellow",{"$f":"Z11","v":false},{"$f":"IF(AY14,V11,FALSE)","v":false},{"$f":"IF(AY14,X11,FALSE)","v":false},{"$f":"IF(AY14,IF(AC15<$BB$10,FALSE(),TRUE()),FALSE)","v":false},{"$f":"IF(BD14=\"\",\"\",BC23)","v":""},{"$f":"Z15","v":""},{"$f":"IF(COUNTIF(AZ14:BB14,\"TRUE\"),\"\",BD14)","v":""},{"$f":"IF(AY14,IF(AZ14,\"-\",IF(OR(BB14,BA14),$AY$18,BC14)),\"\")","v":""}]
[null,"得点","BEST\nWAVE",{"$f":"IF(AY12,IF(COUNT(J18:J29),IF(AND(K15<2,K15<COUNT(J18:J29)),LARGE(J18:J29,1),ROUND(LARGE(J18:J29,1)/2,2)),\"\"),\"\")","v":""},"+",{"$f":"IF(AY12,IF(COUNT(J18:J29)>1,IF(K15=0,LARGE(J18:J29,2),LARGE(J18:J29,2)/2),\"\"),\"\")","v":""},"合計",{"$f":"IF(H11,IF(OR(D11,F11),\"\",IF(D15<>\"\",SUM(D15,F15),\"\")),\"\")","v":""},null,null,{"$f":"COUNTIF(H18:H29,\"△\") +COUNTIF(H18:H29,\"▲\") + (COUNTIF(H18:H29,\"▲△\")*2)","v":0},"BEST\nWAVE",{"$f":"IF(AY13,IF(COUNT(S18:S29),IF(AND(T15<2,T15<COUNT(S18:S29)),LARGE(S18:S29,1),ROUND(LARGE(S18:S29,1)/2,2)),\"\"),\"\")","v":""},"+",{"$f":"IF(AY13,IF(COUNT(S18:S29)>1,IF(COUNTA(Q18:Q29)=0,LARGE(S18:S29,2),LARGE(S18:S29,2)/2),\"\"),\"\")","v":""},"合計",{"$f":"IF(Q11,IF(OR(M11,O11),\"\",IF(M15<>\"\",SUM(M15,O15),\"\")),\"\")","v":""},null,null,{"$f":"COUNTIF(Q18:Q29,\"△\") +COUNTIF(Q18:Q29,\"▲\") + (COUNTIF(Q18:Q29,\"▲△\")*2)","v":0},"BEST\nWAVE",{"$f":"IF(AY14,IF(COUNT(AB18:AB29),IF(AND(AC15<2,AC15<COUNT(AB18:AB29)),LARGE(AB18:AB29,1),ROUND(LARGE(AB18:AB29,1)/2,2)),\"\"),\"\")","v":""},"+",{"$f":"IF(AY14,IF(COUNT(AB18:AB29)>1,IF(COUNTA(Z18:Z29)=0,LARGE(AB18:AB29,2),LARGE(AB18:AB29,2)/2),\"\"),\"\")","v":""},"合計",{"$f":"IF(Z11,IF(OR(V11,X11),\"\",IF(V15<>\"\",SUM(V15,X15),\"\")),\"\")","v":""},null,null,{"$f":"COUNTIF(Z18:Z29,\"△\") +COUNTIF(Z18:Z29,\"▲\") + (COUNTIF(Z18:Z29,\"▲△\")*2)","v":0},"BEST\nWAVE",{"$f":"IF(AY15,IF(COUNT(AK18:AK29),IF(AND(AL15<2,AL15<COUNT(AK18:AK29)),LARGE(AK18:AK29,1),ROUND(LARGE(AK18:AK29,1)/2,2)),\"\"),\"\")","v":""},"+",{"$f":"IF(AY15,IF(COUNT(AK18:AK29)>1,IF(COUNTA(AI18:AI29)=0,LARGE(AK18:AK29,2),LARGE(AK18:AK29,2)/2),\"\"),\"\")","v":""},"合計",{"$f":"IF(AI11,IF(OR(AE11,AG11),\"\",IF(AE15<>\"\",SUM(AE15,AG15),\"\")),\"\")","v":""},null,null,{"$f":"COUNTIF(AI18:AI29,\"△\") +COUNTIF(AI18:AI29,\"▲\") + (COUNTIF(AI18:AI29,\"▲△\")*2)","v":0},"BEST\nWAVE",{"$f":"IF(AY16,IF(COUNT(AT18:AT29),IF(AND(AV15<2,AV15<COUNT(AT18:AT29)),LARGE(AT18:AT29,1),ROUND(LARGE(AT18:AT29,1)/2,2)),\"\"),\"\")","v":""},"+",{"$f":"IF(AY16,IF(COUNT(AT18:AT29)>1,IF(COUNTA(AR18:AR29)=0,LARGE(AT18:AT29,2),LARGE(AT18:AT29,2)/2),\"\"),\"\")","v":""},"合計",{"$f":"IF(AR11,IF(OR(AN11,AP11),\"\",IF(AN15<>\"\",SUM(AN15,AP15),\"\")),\"\")","v":""},null,null,null,{"$f":"COUNTIF(AR18:AR29,\"△\") +COUNTIF(AR18:AR29,\"▲\") + (COUNTIF(AR18:AR29,\"▲△\")*2)","v":0},null,"Blue",{"$f":"AI11","v":false},{"$f":"IF(AY15,AE11,FALSE)","v":false},{"$f":"IF(AY15,AG11,FALSE)","v":false},{"$f":"IF(AY15,IF(AL15<$BB$10,FALSE(),TRUE()),FALSE)","v":false},{"$f":"IF(BD15=\"\",\"\",BC24)","v":""},{"$f":"AI15","v":""},{"$f":"IF(COUNTIF(AZ15:BB15,\"TRUE\"),\"\",BD15)","v":""},{"$f":"IF(AY15,IF(AZ15,\"-\",IF(OR(BB15,BA15),$AY$18,BC15)),\"\")","v":""}]
[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,null,"ジャッジカウント",null,null,null,null,null,null,null,null,"ジャッジカウント",null,null,null,null,null,null,null,null,null,"ジャッジカウント",null,"Green",{"$f":"AR11","v":false},{"$f":"IF(AY16,AN11,FALSE)","v":false},{"$f":"IF(AY16,AP11,FALSE)","v":false},{"$f":"IF(AY16,IF(AV15<$BB$10,FALSE(),TRUE()),FALSE)","v":false},{"$f":"IF(BD16=\"\",\"\",BC25)","v":""},{"$f":"AR15","v":""},{"$f":"IF(COUNTIF(AZ16:BB16,\"TRUE\"),\"\",BD16)","v":""},{"$f":"IF(AY16,IF(AZ16,\"-\",IF(OR(BB16,BA16),$AY$18,BC16)),\"\")","v":""}]
[null,"WAVE/ジャッジ",1,20,8,21,4,"妨害","Ave","Ave",{"$f":"COUNTA(C17:G17)","v":5},{"$f":"IF(C17=\"\",\"\",C17)","v":1},{"$f":"IF(D17=\"\",\"\",D17)","v":20},{"$f":"IF(E17=\"\",\"\",E17)","v":8},{"$f":"IF(F17=\"\",\"\",F17)","v":21},{"$f":"IF(G17=\"\",\"\",G17)","v":4},"妨害","Ave","Ave",{"$f":"K17","v":5},{"$f":"IF(C17=\"\",\"\",C17)","v":1},{"$f":"IF(D17=\"\",\"\",D17)","v":20},{"$f":"IF(E17=\"\",\"\",E17)","v":8},{"$f":"IF(F17=\"\",\"\",F17)","v":21},{"$f":"IF(G17=\"\",\"\",G17)","v":4},"妨害","Ave","Ave",{"$f":"K17","v":5},{"$f":"IF(C17=\"\",\"\",C17)","v":1},{"$f":"IF(D17=\"\",\"\",D17)","v":20},{"$f":"IF(E17=\"\",\"\",E17)","v":8},{"$f":"IF(F17=\"\",\"\",F17)","v":21},{"$f":"IF(G17=\"\",\"\",G17)","v":4},"妨害","Ave","Ave",{"$f":"K17","v":5},{"$f":"IF(C17=\"\",\"\",C17)","v":1},{"$f":"IF(D17=\"\",\"\",D17)","v":20},{"$f":"IF(E17=\"\",\"\",E17)","v":8},{"$f":"IF(F17=\"\",\"\",F17)","v":21},{"$f":"IF(G17=\"\",\"\",G17)","v":4},"妨害","Ave","Ave",null,{"$f":"K17","v":5},null,null,{"$f":"COUNTIF(AY12:AY16,\"TRUE\")","v":0},{"$f":"COUNTIF(AZ12:AZ16,\"TRUE\")","v":0},{"$f":"COUNTIF(BA12:BA16,\"TRUE\")","v":0},{"$f":"COUNTIF(BB12:BB16,\"TRUE\")","v":0}]
[null,1,null,null,null,null,null,null,{"$f":"IF(AND(K18=\"○\",COUNT(C18:G18)=$K$17),IF(OR(K$17=5,K$17=4),ROUND((SUM(C18:G18)-MAX(C18:G18)-MIN(C18:G18))/(K$17-2),2),ROUND(AVERAGE(C18:G18),2)),\"\")","v":""},{"$f":"IF(AND(K18=\"○\",H18<>\"△\",H18<>\"▲△\",COUNT(C18:G18)=$K$17),IF(OR(K$17=5,K$17=4),ROUND((SUM(C18:G18)-MAX(C18:G18)-MIN(C18:G18))/(K$17-2),2),ROUND(AVERAGE(C18:G18),2)),IF(COUNTIF(K$18:K$29,\"○\")=1,I18,\"\"))","v":""},{"$f":"IF(COUNTA(C18:G18),\"○\",\"×\")","v":"×"},null,null,null,null,null,null,{"$f":"IF(AND(T18=\"○\",COUNT(L18:P18)=$T$17),IF(OR(T$17=5,T$17=4),ROUND((SUM(L18:P18)-MAX(L18:P18)-MIN(L18:P18))/(T$17-2),2),ROUND(AVERAGE(L18:P18),2)),\"\")","v":""},{"$f":"IF(AND(T18=\"○\",Q18<>\"△\",Q18<>\"▲△\",COUNT(L18:P18)=$T$17),IF(OR(T$17=5,T$17=4),ROUND((SUM(L18:P18)-MAX(L18:P18)-MIN(L18:P18))/(T$17-2),2),ROUND(AVERAGE(L18:P18),2)),IF(COUNTIF(T$18:T$29,\"○\")=1,R18,\"\"))","v":""},{"$f":"IF(COUNTA(L18:P18),\"○\",\"×\")","v":"×"},null,null,null,null,null,null,{"$f":"IF(AND(AC18=\"○\",COUNT(U18:Y18)=$AC$17),IF(OR(AC$17=5,AC$17=4),ROUND((SUM(U18:Y18)-MAX(U18:Y18)-MIN(U18:Y18))/(AC$17-2),2),ROUND(AVERAGE(U18:Y18),2)),\"\")","v":""},{"$f":"IF(AND(AC18=\"○\",Z18<>\"△\",Z18<>\"▲△\",COUNT(U18:Y18)=$AC$17),IF(OR(AC$17=5,AC$17=4),ROUND((SUM(U18:Y18)-MAX(U18:Y18)-MIN(U18:Y18))/(AC$17-2),2),ROUND(AVERAGE(U18:Y18),2)),IF(COUNTIF(AC$18:AC$29,\"○\")=1,AA18,\"\"))","v":""},{"$f":"IF(COUNTA(U18:Y18),\"○\",\"×\")","v":"×"},null,null,null,null,null,null,{"$f":"IF(AND(AL18=\"○\",COUNT(AD18:AH18)=$AL$17),IF(OR(AL$17=5,AL$17=4),ROUND((SUM(AD18:AH18)-MAX(AD18:AH18)-MIN(AD18:AH18))/(AL$17-2),2),ROUND(AVERAGE(AD18:AH18),2)),\"\")","v":""},{"$f":"IF(AND(AL18=\"○\",AI18<>\"△\",AI18<>\"▲△\",COUNT(AD18:AH18)=$AL$17),IF(OR(AL$17=5,AL$17=4),ROUND((SUM(AD18:AH18)-MAX(AD18:AH18)-MIN(AD18:AH18))/(AL$17-2),2),ROUND(AVERAGE(AD18:AH18),2)),IF(COUNTIF(AL$18:AL$29,\"○\")=1,AJ18,\"\"))","v":""},{"$f":"IF(COUNTA(AD18:AH18),\"○\",\"×\")","v":"×"},null,null,null,null,null,null,{"$f":"IF(AND(AV18=\"○\",COUNT(AM18:AQ18)=$AV$17),IF(OR(AV$17=5,AV$17=4),ROUND((SUM(AM18:AQ18)-MAX(AM18:AQ18)-MIN(AM18:AQ18))/(AV$17-2),2),ROUND(AVERAGE(AM18:AQ18),2)),\"\")","v":""},{"$f":"IF(AND(AV18=\"○\",AR18<>\"△\",AR18<>\"▲△\",COUNT(AM18:AQ18)=$AV$17),IF(OR(AV$17=5,AV$17=4),ROUND((SUM(AM18:AQ18)-MAX(AM18:AQ18)-MIN(AM18:AQ18))/(AV$17-2),2),ROUND(AVERAGE(AM18:AQ18),2)),IF(COUNTIF(AV$18:AV$29,\"○\")=1,AS18,\"\"))","v":""},null,{"$f":"IF(COUNTA(AM18:AQ18),\"○\",\"×\")","v":"×"},null,null,{"$f":"AY17-AZ17","v":0}]
[null,2,null,null,null,null,null,null,{"$f":"IF(AND(K19=\"○\",COUNT(C19:G19)=$K$17),IF(OR(K$17=5,K$17=4),ROUND((SUM(C19:G19)-MAX(C19:G19)-MIN(C19:G19))/(K$17-2),2),ROUND(AVERAGE(C19:G19),2)),\"\")","v":""},{"$f":"IF(AND(K19=\"○\",H19<>\"△\",H19<>\"▲△\",COUNT(C19:G19)=$K$17),IF(OR(K$17=5,K$17=4),ROUND((SUM(C19:G19)-MAX(C19:G19)-MIN(C19:G19))/(K$17-2),2),ROUND(AVERAGE(C19:G19),2)),IF(COUNTIF(K$18:K$29,\"○\")=1,I19,\"\"))","v":""},"×",null,null,null,null,null,null,{"$f":"IF(AND(T19=\"○\",COUNT(L19:P19)=$T$17),IF(OR(T$17=5,T$17=4),ROUND((SUM(L19:P19)-MAX(L19:P19)-MIN(L19:P19))/(T$17-2),2),ROUND(AVERAGE(L19:P19),2)),\"\")","v":""},{"$f":"IF(AND(T19=\"○\",Q19<>\"△\",Q19<>\"▲△\",COUNT(L19:P19)=$T$17),IF(OR(T$17=5,T$17=4),ROUND((SUM(L19:P19)-MAX(L19:P19)-MIN(L19:P19))/(T$17-2),2),ROUND(AVERAGE(L19:P19),2)),IF(COUNTIF(T$18:T$29,\"○\")=1,R19,\"\"))","v":""},"×",null,null,null,null,null,null,{"$f":"IF(AND(AC19=\"○\",COUNT(U19:Y19)=$AC$17),IF(OR(AC$17=5,AC$17=4),ROUND((SUM(U19:Y19)-MAX(U19:Y19)-MIN(U19:Y19))/(AC$17-2),2),ROUND(AVERAGE(U19:Y19),2)),\"\")","v":""},{"$f":"IF(AND(AC19=\"○\",Z19<>\"△\",Z19<>\"▲△\",COUNT(U19:Y19)=$AC$17),IF(OR(AC$17=5,AC$17=4),ROUND((SUM(U19:Y19)-MAX(U19:Y19)-MIN(U19:Y19))/(AC$17-2),2),ROUND(AVERAGE(U19:Y19),2)),IF(COUNTIF(AC$18:AC$29,\"○\")=1,AA19,\"\"))","v":""},"×",null,null,null,null,null,null,{"$f":"IF(AND(AL19=\"○\",COUNT(AD19:AH19)=$AL$17),IF(OR(AL$17=5,AL$17=4),ROUND((SUM(AD19:AH19)-MAX(AD19:AH19)-MIN(AD19:AH19))/(AL$17-2),2),ROUND(AVERAGE(AD19:AH19),2)),\"\")","v":""},{"$f":"IF(AND(AL19=\"○\",AI19<>\"△\",AI19<>\"▲△\",COUNT(AD19:AH19)=$AL$17),IF(OR(AL$17=5,AL$17=4),ROUND((SUM(AD19:AH19)-MAX(AD19:AH19)-MIN(AD19:AH19))/(AL$17-2),2),ROUND(AVERAGE(AD19:AH19),2)),IF(COUNTIF(AL$18:AL$29,\"○\")=1,AJ19,\"\"))","v":""},"×",null,null,null,null,null,null,{"$f":"IF(AND(AV19=\"○\",COUNT(AM19:AQ19)=$AV$17),IF(OR(AV$17=5,AV$17=4),ROUND((SUM(AM19:AQ19)-MAX(AM19:AQ19)-MIN(AM19:AQ19))/(AV$17-2),2),ROUND(AVERAGE(AM19:AQ19),2)),\"\")","v":""},{"$f":"IF(AND(AV19=\"○\",AR19<>\"△\",AR19<>\"▲△\",COUNT(AM19:AQ19)=$AV$17),IF(OR(AV$17=5,AV$17=4),ROUND((SUM(AM19:AQ19)-MAX(AM19:AQ19)-MIN(AM19:AQ19))/(AV$17-2),2),ROUND(AVERAGE(AM19:AQ19),2)),IF(COUNTIF(AV$18:AV$29,\"○\")=1,AS19,\"\"))","v":""},null,"×",null,null,null,null,null,"順位計算用",null,null,"全ての点数を足した値で順位を判断する。"]
[null,3,null,null,null,null,null,null,"","","×",null,null,null,null,null,null,"","","×",null,null,null,null,null,null,"","","×",null,null,null,null,null,null,{"$f":"IF(AND(AL20=\"○\",COUNT(AD20:AH20)=$AL$17),IF(OR(AL$17=5,AL$17=4),ROUND((SUM(AD20:AH20)-MAX(AD20:AH20)-MIN(AD20:AH20))/(AL$17-2),2),ROUND(AVERAGE(AD20:AH20),2)),\"\")","v":""},"","×",null,null,null,null,null,null,"","",null,"×",null,null,null,null,null,null,"順位(点数)",null,"best1","best2","best3",null,"best4","best5","best6","best7",null,"best8","best9","best10","best11",null,"best12"]
[null,4,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,null,null,null,null,null,"","",null,"×",null,null,null,null,null,"red",{"$f":"IFERROR(BS21,\"\")","v":1},null,{"$f":"IF(BE28=\"\",\"\",_xlfn.RANK.EQ(BE28,BE$28:BE$32))","v":1},1,1,null,1,1,1,1,null,1,1,1,1,null,1]
[null,5,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,null,null,null,null,null,"","",null,"×",null,null,null,null,null,"white",{"$f":"IFERROR(BS22,\"\")","v":1},null,{"$f":"IF(BE29=\"\",\"\",_xlfn.RANK.EQ(BE29,BE$28:BE$32))","v":1},1,1,null,1,1,1,1,null,1,1,1,1,null,1]
[null,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,null,null,null,null,null,"","",null,"×",null,null,null,null,null,"yellow",{"$f":"IFERROR(BS23,\"\")","v":1},null,{"$f":"IF(BE30=\"\",\"\",_xlfn.RANK.EQ(BE30,BE$28:BE$32))","v":1},1,1,null,1,1,1,1,null,1,1,1,1,null,1]
[null,7,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,null,null,null,null,null,"","",null,"×",null,null,null,null,null,"blue",{"$f":"IFERROR(BS24,\"\")","v":1},null,{"$f":"IF(BE31=\"\",\"\",_xlfn.RANK.EQ(BE31,BE$28:BE$32))","v":1},1,1,null,1,1,1,1,null,1,1,1,1,null,1]
[null,8,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,null,null,null,null,null,"","",null,"×",null,null,null,null,null,"green",{"$f":"IFERROR(BS25,\"\")","v":1},null,{"$f":"IF(BE32=\"\",\"\",_xlfn.RANK.EQ(BE32,BE$28:BE$32))","v":1},1,1,null,1,1,1,1,null,1,1,1,1,null,1]
[null,9,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,null,null,null,null,null,"","",null,"×",null,null,null,null,null,null,null,null,"上位点数×１０００に下位点数を足す",null,null,"15桁以上にならないように途中でrank関数を挟む"]
[null,10,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,null,null,null,null,null,"","",null,"×",null,null,null,null,null,null,null,"有効得点","best1","best2","best3",null,"best4","best5","best6","best7",null,"best8","best9","best10","best11",null,"best12"]
[null,11,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,null,null,null,null,null,"","",null,"×",null,null,null,null,null,"red",null,{"$f":"H15","v":""},{"$f":"IF(BD28=\"\",0,BD28*1000+BE36)","v":0},{"$f":"BE28*1000+BF36","v":0},0,{"$f":"_xlfn.RANK.EQ(BG28,$BG$28:$BG$32,1)","v":1},{"$f":"BH28*100+BI36","v":100},{"$f":"BI28*1000+BJ36","v":100000},100000000,100000000000,{"$f":"_xlfn.RANK.EQ(BL28,$BL$28:$BL$32,1)","v":1},{"$f":"BM28*100+BN36","v":100},100000,100000000,100000000000,{"$f":"_xlfn.RANK.EQ(BQ28,$BQ$28:$BQ$32,1)","v":1},{"$f":"BQ28*1000+BS36","v":100000000000000}]
[null,12,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,null,null,null,null,null,"",{"$f":"IF(AND(AV29=\"○\",AR29<>\"△\",AR29<>\"▲△\",COUNT(AM29:AQ29)=$AV$17),IF(OR(AV$17=5,AV$17=4),ROUND((SUM(AM29:AQ29)-MAX(AM29:AQ29)-MIN(AM29:AQ29))/(AV$17-2),2),ROUND(AVERAGE(AM29:AQ29),2)),IF(COUNTIF(AV$18:AV$29,\"○\")=1,AS29,\"\"))","v":""},null,"×",null,null,null,null,null,"white",null,{"$f":"Q15","v":""},{"$f":"IF(BD29=\"\",0,BD29*1000+BE37)","v":0},{"$f":"BE29*1000+BF37","v":0},0,{"$f":"_xlfn.RANK.EQ(BG29,$BG$28:$BG$32,1)","v":1},{"$f":"BH29*100+BI37","v":100},{"$f":"BI29*1000+BJ37","v":100000},100000000,100000000000,{"$f":"_xlfn.RANK.EQ(BL29,$BL$28:$BL$32,1)","v":1},{"$f":"BM29*100+BN37","v":100},100000,100000000,100000000000,{"$f":"_xlfn.RANK.EQ(BQ29,$BQ$28:$BQ$32,1)","v":1},{"$f":"BQ29*1000+BS37","v":100000000000000}]
[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,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,null,null,null,"yellow",null,{"$f":"Z15","v":""},{"$f":"IF(BD30=\"\",0,BD30*1000+BE38)","v":0},0,0,{"$f":"_xlfn.RANK.EQ(BG30,$BG$28:$BG$32,1)","v":1},{"$f":"BH30*100+BI38","v":100},{"$f":"BI30*1000+BJ38","v":100000},100000000,100000000000,{"$f":"_xlfn.RANK.EQ(BL30,$BL$28:$BL$32,1)","v":1},{"$f":"BM30*100+BN38","v":100},100000,100000000,100000000000,{"$f":"_xlfn.RANK.EQ(BQ30,$BQ$28:$BQ$32,1)","v":1},{"$f":"BQ30*1000+BS38","v":100000000000000}]
[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,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,null,null,"blue",null,{"$f":"AI15","v":""},{"$f":"IF(BD31=\"\",0,BD31*1000+BE39)","v":0},0,0,{"$f":"_xlfn.RANK.EQ(BG31,$BG$28:$BG$32,1)","v":1},{"$f":"BH31*100+BI39","v":100},{"$f":"BI31*1000+BJ39","v":100000},100000000,100000000000,{"$f":"_xlfn.RANK.EQ(BL31,$BL$28:$BL$32,1)","v":1},{"$f":"BM31*100+BN39","v":100},100000,100000000,100000000000,{"$f":"_xlfn.RANK.EQ(BQ31,$BQ$28:$BQ$32,1)","v":1},{"$f":"BQ31*1000+BS39","v":100000000000000}]
[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,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,null,null,null,"green",null,{"$f":"AR15","v":""},{"$f":"IF(BD32=\"\",0,BD32*1000+BE40)","v":0},0,0,{"$f":"_xlfn.RANK.EQ(BG32,$BG$28:$BG$32,1)","v":1},{"$f":"BH32*100+BI40","v":100},{"$f":"BI32*1000+BJ40","v":100000},100000000,100000000000,{"$f":"_xlfn.RANK.EQ(BL32,$BL$28:$BL$32,1)","v":1},{"$f":"BM32*100+BN40","v":100},100000,100000000,100000000000,{"$f":"_xlfn.RANK.EQ(BQ32,$BQ$28:$BQ$32,1)","v":1},{"$f":"BQ32*1000+BS40","v":100000000000000}]
[]
[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,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,null,null,null,null,null,null,"ベストスコア順に平均点（AVE）を整列"]
[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,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,null,null,null,null,null,"WAVEカウント","best1","best2","best3",null,"best4","best5","best6","best7",null,"best8","best9","best10","best11",null,"best12"]
[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,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,null,null,null,"red",null,{"$f":"COUNT(J18:J29)","v":0},{"$f":"IF(D15=\"\",0,D15)","v":0},{"$f":"IF(F15=\"\",0,F15)","v":0},{"$f":"IF(BD36>=3,LARGE($J$18:$J$29,3),0)","v":0},null,{"$f":"IF(BD36>=4,LARGE($J$18:$J$29,4),0)","v":0},{"$f":"IF(BD36>=5,LARGE($J$18:$J$29,5),0)","v":0},{"$f":"IF(BD36>=6,LARGE($J$18:$J$29,6),0)","v":0},{"$f":"IF(BD36>=7,LARGE($J$18:$J$29,7),0)","v":0},null,{"$f":"IF(BD36>=8,LARGE($J$18:$J$29,8),0)","v":0},{"$f":"IF(BD36>=9,LARGE($J$18:$J$29,9),0)","v":0},{"$f":"IF(BD36>=10,LARGE($J$18:$J$29,10),0)","v":0},{"$f":"IF(BD36>=11,LARGE($J$18:$J$29,11),0)","v":0},null,{"$f":"IF(BD36>=12,LARGE($J$18:$J$29,12),0)","v":0}]
[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,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,null,null,null,"white",null,{"$f":"COUNT(S18:S29)","v":0},{"$f":"IF(M15=\"\",0,M15)","v":0},{"$f":"IF(O15=\"\",0,O15)","v":0},{"$f":"IF(BD37>=3,LARGE($S$18:$S$29,3),0)","v":0},null,{"$f":"IF(BD37>=4,LARGE($S$18:$S$29,4),0)","v":0},{"$f":"IF(BD37>=5,LARGE($S$18:$S$29,5),0)","v":0},{"$f":"IF(BD37>=6,LARGE($S$18:$S$29,6),0)","v":0},{"$f":"IF(BD37>=7,LARGE($S$18:$S$29,7),0)","v":0},null,{"$f":"IF(BD37>=8,LARGE($S$18:$S$29,8),0)","v":0},{"$f":"IF(BD37>=9,LARGE($S$18:$S$29,9),0)","v":0},{"$f":"IF(BD37>=10,LARGE($S$18:$S$29,10),0)","v":0},{"$f":"IF(BD37>=11,LARGE($S$18:$S$29,11),0)","v":0},null,{"$f":"IF(BD37>=12,LARGE($S$18:$S$29,12),0)","v":0}]
[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,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,null,null,null,"yellow",null,{"$f":"COUNT(AB18:AB29)","v":0},{"$f":"IF(V15=\"\",0,V15)","v":0},{"$f":"IF(X15=\"\",0,X15)","v":0},{"$f":"IF(BD38>=3,LARGE($AB$18:$AB$29,3),0)","v":0},null,{"$f":"IF(BD38>=4,LARGE($AB$18:$AB$29,4),0)","v":0},{"$f":"IF(BD38>=5,LARGE($AB$18:$AB$29,5),0)","v":0},{"$f":"IF(BD38>=6,LARGE($AB$18:$AB$29,6),0)","v":0},{"$f":"IF(BD38>=7,LARGE($AB$18:$AB$29,7),0)","v":0},null,{"$f":"IF(BD38>=8,LARGE($AB$18:$AB$29,8),0)","v":0},{"$f":"IF(BD38>=9,LARGE($AB$18:$AB$29,9),0)","v":0},{"$f":"IF(BD38>=10,LARGE($AB$18:$AB$29,10),0)","v":0},{"$f":"IF(BD38>=11,LARGE($AB$18:$AB$29,11),0)","v":0},null,{"$f":"IF(BD38>=12,LARGE($AB$18:$AB$29,12),0)","v":0}]
[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,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,null,null,null,"blue",null,{"$f":"COUNT(AK18:AK29)","v":0},{"$f":"IF(AE15=\"\",0,AE15)","v":0},{"$f":"IF(AG15=\"\",0,AG15)","v":0},{"$f":"IF(BD39>=3,LARGE($AK$18:$AK$29,3),0)","v":0},null,{"$f":"IF(BD39>=4,LARGE($AK$18:$AK$29,4),0)","v":0},{"$f":"IF(BD39>=5,LARGE($AK$18:$AK$29,5),0)","v":0},{"$f":"IF(BD39>=6,LARGE($AK$18:$AK$29,6),0)","v":0},{"$f":"IF(BD39>=7,LARGE($AK$18:$AK$29,7),0)","v":0},null,{"$f":"IF(BD39>=8,LARGE($AK$18:$AK$29,8),0)","v":0},{"$f":"IF(BD39>=9,LARGE($AK$18:$AK$29,9),0)","v":0},{"$f":"IF(BD39>=10,LARGE($AK$18:$AK$29,10),0)","v":0},{"$f":"IF(BD39>=11,LARGE($AK$18:$AK$29,11),0)","v":0},null,{"$f":"IF(BD39>=12,LARGE($AK$18:$AK$29,12),0)","v":0}]
[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,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,null,null,null,"green",null,{"$f":"COUNT(AT18:AT29)","v":0},{"$f":"IF(AN15=\"\",0,AN15)","v":0},{"$f":"IF(AP15=\"\",0,AP15)","v":0},{"$f":"IF(BD40>=3,LARGE($AT$18:$AT$29,3),0)","v":0},null,{"$f":"IF(BD40>=4,LARGE($AT$18:$AT$29,4),0)","v":0},{"$f":"IF(BD40>=5,LARGE($AT$18:$AT$29,5),0)","v":0},{"$f":"IF(BD40>=6,LARGE($AT$18:$AT$29,6),0)","v":0},{"$f":"IF(BD40>=7,LARGE($AT$18:$AT$29,7),0)","v":0},null,{"$f":"IF(BD40>=8,LARGE($AT$18:$AT$29,8),0)","v":0},{"$f":"IF(BD40>=9,LARGE($AT$18:$AT$29,9),0)","v":0},{"$f":"IF(BD40>=10,LARGE($AT$18:$AT$29,10),0)","v":0},{"$f":"IF(BD40>=11,LARGE($AT$18:$AT$29,11),0)","v":0},null,{"$f":"IF(BD40>=12,LARGE($AT$18:$AT$29,12),0)","v":0}]

{"sheet":"選択データ","index":1,"n_rows":75,"n_cols":10,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["ジャッジ名","大会名","ポイント名","クラス名","支部名","Round","妨害","Heat No.","集計者","集計チェック"]
[{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,{"$f":"\"\"","v":""}]
[1,"全日本大会","A","キッズ","北海道",1,"△",1,"テスト集計者","テストチェック者"]
[2,"東日本大会","B","ボーイズ","青森",2,"▲",2]
[3,"西日本大会","C","ジュニア","岩手",3,"▲△",3]
[4,"級別",null,"メン","宮城仙台",4,null,4]
[5,"ジュニア",null,"シニア","宮城北","SEMI FINAL",null,5]
[6,null,null,"マスター","秋田","FINAL",null,6]
[7,null,null,"グランドマスター","山形",null,null,7]
[8,null,null,"ガールズ","福島１区",null,null,8]
[9,null,null,"ウィメン","福島２区",null,null,9]
[10,null,null,"LBメン","茨城南",null,null,10]
[11,null,null,"LBマスター","茨城北",null,null,11]
[12,null,null,"LBウィメン","茨城波崎",null,null,12]
[13,null,null,"BBメン","栃木",null,null,13]
[14,null,null,"BBウィメン","群馬",null,null,14]
[15,null,null,null,"埼玉１区",null,null,15]
[16,null,null,null,"埼玉２区",null,null,16]
[17,null,null,null,"埼玉３区",null,null,17]
[18,null,null,null,"埼玉４区",null,null,18]
[19,null,null,null,"千葉銚子",null,null,19]
[20,null,null,null,"千葉西",null,null,20]
[21,null,null,null,"千葉東",null,null,21]
[22,null,null,null,"千葉南",null,null,22]
[23,null,null,null,"東京",null,null,23]
[24,null,null,null,"東京多摩",null,null,24]
[25,null,null,null,"東京大島",null,null,25]
[null,null,null,null,"東京新島",null,null,26]
[null,null,null,null,"東京神津島",null,null,27]
[null,null,null,null,"川崎",null,null,28]
[null,null,null,null,"横浜",null,null,29]
[null,null,null,null,"湘南鎌倉",null,null,30]
[null,null,null,null,"湘南藤沢",null,null,31]
[null,null,null,null,"湘南茅ケ崎",null,null,32]
[null,null,null,null,"湘南西",null,null,33]
[null,null,null,null,"相模原",null,null,34]
[null,null,null,null,"山梨",null,null,35]
[null,null,null,null,"長野",null,null,36]
[null,null,null,null,"新潟１区",null,null,37]
[null,null,null,null,"新潟２区",null,null,38]
[null,null,null,null,"富山",null,null,39]
[null,null,null,null,"石川",null,null,40]
[null,null,null,null,"福井",null,null,41]
[null,null,null,null,"岐阜",null,null,42]
[null,null,null,null,"静岡伊豆",null,null,43]
[null,null,null,null,"静岡１区",null,null,44]
[null,null,null,null,"静岡２区",null,null,45]
[null,null,null,null,"静岡３区",null,null,46]
[null,null,null,null,"愛知",null,null,47]
[null,null,null,null,"三重",null,null,48]
[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,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,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,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,"デフ西"]

{"sheet":"説明","index":2,"n_rows":149,"n_cols":6,"rows_kept":149,"cut":false,"hidden":false,"merged":[]}
["集計表Excelの使用手引き"]
[]
[]
["１．","採点入力"]
[null,"採点結果の入力は以下のHeat集計表シートで行います。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"①大会名"]
[null,null,"大会名を選択します。(例：東日本大会)"]
[]
[]
[null,"②競技ポイント"]
[null,null,"ポイント名を選択します。(例：A)"]
[]
[null,"③クラス"]
[null,null,"クラスを選択します。(例：シニア)"]
[]
[null,"④ラウンド"]
[null,null,"ラウンドを選択します。(例：Final)"]
[]
[null,"⑤Heat No."]
[null,null,"Heat Noを選択します。(例：１)"]
[]
[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,"⑫得点入力欄"]
[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,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,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,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,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,null,"５人:最高点・最低点をカットし、残り３人の平均点"]
[]
[null,"⑮ベストウェーブ"]
[null,null,"平均点の上位２つが表示されます。妨害があった場合は、減点された得点が表示されます。"]
[]
[null,"⑯順位"]
[null,null,"合計点を元に順位を算出し表示します。"]
[null,null,"合計点が同じ場合はベストウェーブの１番高い点数で順位を決定します。"]
[null,null,"ベストウェーブの１番高い点数も同じ場合は２番目の点数を比較し、２番目も同じ場合は平均点の３番目に高い点数を比較します。さらに同点の場合は４番目、５番目と繰り下がります。"]
[]
[null,"⑰合計点"]
[null,null,"ベストウェーブの合計点が表示されます。"]
[]
[null,"⑱集計表初期化ボタン"]
[null,null,"現ヒートの集計表への入力が終わり、次のヒートに移る際に押下します。"]
[null,null,"以下の処理が行われます。"]
[null,null,1,"初期化実行確認メッセージの表示。Noの場合は処理を中止します。"]
[null,null,2,"ファイル（ファイル名：大会名＋競技ポイント＋クラス＋ラウンド＋Heat No＋\".xls\")の保存"]
[null,null,3,"各入力欄のクリア（大会名、競技ポイント、クラス、ラウンド、Heat Noはクリアしません。）"]
[]
[null,"選択データ"]
[null,null,"選択データ(ジャッジ名、大会名、ポイント名、クラス名、支部名、ラウンド名、HeatNo、集計者、集計チェック)"]
[null,null,"に変更又は追加をする場合は、該当行のセルに入力してください。集計用紙の選択肢で選択できるようになります。"]
[null,null,"変更する場合は該当セルを変更"]
[null,null,"追加する場合は該当行の末行に入力"]