{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["必要点数計算","注意点"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[" 必要得点計算"]
[]
["勝抜き","積み棒(本)","供託(本)","親","自分",null,{"$f":"A14","v":"ツモ"},{"$f":"A24","v":"Aロン"},{"$f":"A34","v":"Bロン"},{"$f":"A44","v":"Cロン"}]
["2人抜け",0,0,"A","D",null,{"$f":"B14","v":"300/500"},{"$f":"B24","v":1000},{"$f":"B34","v":1000},{"$f":"B44","v":1000}]
[]
[null,"現在の\n持ち点","これまでの\n総ポイント","素点\nポイント","順位\nポイント","最終\nポイント",{"$f":"\"自分との\"&CHAR(10)&\"最終ﾎﾟｲﾝﾄ差\"","v":"自分との\n最終ﾎﾟｲﾝﾄ差"},{"$f":"\"自分との\"&CHAR(10)&\"持ち点差\"","v":"自分との\n持ち点差"},"順位点DOWN\n最小点数","順位点UP\n最小点数"]
["A",25000,0,{"$f":"(B7-30000)/1000","v":-5},5,{"$f":"C7+D7+E7","v":0},{"$f":"IF($E$4=$A7,\"---\",F7-OFFSET($F$7,CODE($E$4)-65,0))","v":0},{"$f":"IF($E$4=$A7,\"---\",B7-OFFSET($B$7,CODE($E$4)-65,0))","v":0},{"$f":"IF(MAX(IF(B8<=B7,B8,-999999),IF(B9<=B7,B9,-999999),IF(B10<=B7,B10,-999999))=B7,-1,IF(MAX(IF(B8<B7,B8,-999999),IF(B9<B7,B9,-999999),IF(B10<B7,B10,-999999))=-999999,\"---\",MAX(IF(B8<B7,B8,-999999),IF(B9<B7,B9,-999999),IF(B10<B7,B10,-999999))-B7))","v":-1},{"$f":"IF(MIN(IF(B8>=B7,B8,999999),IF(B9>=B7,B9,999999),IF(B10>=B7,B10,999999))=B7,1,IF(MIN(IF(B8>B7,B8,999999),IF(B9>B7,B9,999999),IF(B10>B7,B10,999999))=999999,\"---\",MIN(IF(B8>B7,B8,999999),IF(B9>B7,B9,999999),IF(B10>B7,B10,999999))-B7))","v":1}]
["B",25000,0,{"$f":"(B8-30000)/1000","v":-5},5,{"$f":"C8+D8+E8","v":0},{"$f":"IF($E$4=$A8,\"---\",F8-OFFSET($F$7,CODE($E$4)-65,0))","v":0},{"$f":"IF($E$4=$A8,\"---\",B8-OFFSET($B$7,CODE($E$4)-65,0))","v":0},{"$f":"IF(MAX(IF(B7<=B8,B7,-999999),IF(B9<=B8,B9,-999999),IF(B10<=B8,B10,-999999))=B8,-1,IF(MAX(IF(B7<B8,B7,-999999),IF(B9<B8,B9,-999999),IF(B10<B8,B10,-999999))=-999999,\"---\",MAX(IF(B7<B8,B7,-999999),IF(B9<B8,B9,-999999),IF(B10<B8,B10,-999999))-B8))","v":-1},{"$f":"IF(MIN(IF(B7>=B8,B7,999999),IF(B9>=B8,B9,999999),IF(B10>=B8,B10,999999))=B8,1,IF(MIN(IF(B7>B8,B7,999999),IF(B9>B8,B9,999999),IF(B10>B8,B10,999999))=999999,\"---\",MIN(IF(B7>B8,B7,999999),IF(B9>B8,B9,999999),IF(B10>B8,B10,999999))-B8))","v":1}]
["C",25000,0,{"$f":"(B9-30000)/1000","v":-5},5,0,0,0,{"$f":"IF(MAX(IF(B7<=B9,B7,-999999),IF(B8<=B9,B8,-999999),IF(B10<=B9,B10,-999999))=B9,-1,IF(MAX(IF(B7<B9,B7,-999999),IF(B8<B9,B8,-999999),IF(B10<B9,B10,-999999))=-999999,\"---\",MAX(IF(B7<B9,B7,-999999),IF(B8<B9,B8,-999999),IF(B10<B9,B10,-999999))-B9))","v":-1},{"$f":"IF(MIN(IF(B7>=B9,B7,999999),IF(B8>=B9,B8,999999),IF(B10>=B9,B10,999999))=B9,1,IF(MIN(IF(B7>B9,B7,999999),IF(B8>B9,B8,999999),IF(B10>B9,B10,999999))=999999,\"---\",MIN(IF(B7>B9,B7,999999),IF(B8>B9,B8,999999),IF(B10>B9,B10,999999))-B9))","v":1}]
["D",25000,0,{"$f":"(B10-30000)/1000","v":-5},5,0,"---","---",{"$f":"IF(MAX(IF(B7<=B10,B7,-999999),IF(B8<=B10,B8,-999999),IF(B9<=B10,B9,-999999))=B10,-1,IF(MAX(IF(B7<B10,B7,-999999),IF(B8<B10,B8,-999999),IF(B9<B10,B9,-999999))=-999999,\"---\",MAX(IF(B7<B10,B7,-999999),IF(B8<B10,B8,-999999),IF(B9<B10,B9,-999999))-B10))","v":-1},{"$f":"IF(MIN(IF(B7>=B10,B7,999999),IF(B8>=B10,B8,999999),IF(B9>=B10,B9,999999))=B10,1,IF(MIN(IF(B7>B10,B7,999999),IF(B8>B10,B8,999999),IF(B9>B10,B9,999999))=999999,\"---\",MIN(IF(B7>B10,B7,999999),IF(B8>B10,B8,999999),IF(B9>B10,B9,999999))-B10))","v":1}]
[]
["計",{"$f":"SUM(B7:B10)","v":100000},{"$f":"SUM(C7:C10)","v":0},{"$f":"SUM(D7:D10)","v":-20},{"$f":"SUM(E7:E10)","v":20},{"$f":"SUM(F7:F10)","v":0}]
[]
["ツモ","300/500"]
[null,"現在の\n持ち点","これまでの\n総ポイント","素点\nポイント","順位\nポイント","最終\nポイント"]
["A",24500,0,-5.5,-30,-35.5]
["B",24700,0,-5.3,0,-5.3]
["C",24700,0,-5.3,0,-5.3]
["D",26100,0,-3.9,50,46.1]
[]
["計",100000,0,-20,20,0]
[]
[]
["Aロン",1000]
[null,"現在の\n持ち点","これまでの\n総ポイント","素点\nポイント","順位\nポイント","最終\nポイント"]
["A",24000,0,-6,-30,-36]
["B",25000,0,-5,0,-5]
["C",25000,0,-5,0,-5]
["D",26000,0,-4,50,46]
[]
["計",100000,0,-20,20,0]
[]
[]
["Bロン",1000]
[null,"現在の\n持ち点","これまでの\n総ポイント","素点\nポイント","順位\nポイント","最終\nポイント"]
["A",25000,0,-5,0,-5]
["B",24000,0,-6,-30,-36]
["C",25000,0,-5,0,-5]
["D",26000,0,-4,50,46]
[]
["計",100000,0,-20,20,0]
[]
[]
["Cロン",1000]
[null,"現在の\n持ち点","これまでの\n総ポイント","素点\nポイント","順位\nポイント","最終\nポイント"]
["A",25000,0,-5,0,-5]
["B",25000,0,-5,0,-5]
["C",24000,0,-6,-30,-36]
["D",26000,0,-4,50,46]
[]
["計",100000,0,-20,20,0]
[]
["※順位点+50,+10,△10,△30 ※同着順位点は、順位点の合計を人数で除する。"]

{"sheet":"注意点","index":1,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["※最大持ち点数99999999点未満"]
["※最小持ち点数-99999998点以上"]
["※順位点+50,+10,△10,△30"]
["※同着順位点は、順位点の合計を人数で除する"]
["※四倍役満まで計算"]
["※EXCEL2013動作確認"]