{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["成績管理ファイル設定","HOW TO USE","TOTAL","DATA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["開始日"]
["終了日\n（開始日と同一であれば記載不要）"]
["場所"]
["参加者名"]
["参加時間(h)"]
["飯代（プラスで記載)"]
["立替え額(プラスで記載)"]
["シート名","ヨンマ"]
["仮想レート（千点あたりの金額）",50]
["仮想チップ単価",200]
["負け上限\n(マイナスの金額で記載）",-9999999]
["場代"]
["麻雀要員名","妖怪","マゾイ","仏","hsmt","パンダ","UMD","オヤジ","ING","おざる","K林","W会","ksk","他の要員はこの列の左に追加"]

{"sheet":"HOW TO USE","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"TOTAL","index":2,"n_rows":22,"n_cols":27,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["名前","SUM","名無し"]
["成績（場代、立替え等除く）",{"$f":"SUM(C2:AA2)","v":0},{"$f":"SUM(C3:C4)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["DATA",{"$f":"SUM(C3:AA3)","v":0},{"$f":"INDIRECT($A3 &\"!C2\")","v":0},{"$f":"INDIRECT($A3 &\"!D2\")","v":0},{"$f":"INDIRECT($A3 &\"!E2\")","v":0},{"$f":"INDIRECT($A3 &\"!F2\")","v":0},{"$f":"INDIRECT($A3 &\"!G2\")","v":0},{"$f":"INDIRECT($A3 &\"!H2\")","v":0},{"$f":"INDIRECT($A3 &\"!I2\")","v":0},{"$f":"INDIRECT($A3 &\"!J2\")","v":0},{"$f":"INDIRECT($A3 &\"!K2\")","v":0},{"$f":"INDIRECT($A3 &\"!L2\")","v":0},{"$f":"INDIRECT($A3 &\"!M2\")","v":0},{"$f":"INDIRECT($A3 &\"!N2\")","v":0},{"$f":"INDIRECT($A3 &\"!O2\")","v":0},{"$f":"INDIRECT($A3 &\"!P2\")","v":0},{"$f":"INDIRECT($A3 &\"!Q2\")","v":0},{"$f":"INDIRECT($A3 &\"!R2\")","v":0},{"$f":"INDIRECT($A3 &\"!S2\")","v":0},{"$f":"INDIRECT($A3 &\"!T2\")","v":0},{"$f":"INDIRECT($A3 &\"!U2\")","v":0},{"$f":"INDIRECT($A3 &\"!V2\")","v":0},{"$f":"INDIRECT($A3 &\"!W2\")","v":0},{"$f":"INDIRECT($A3 &\"!X2\")","v":0},{"$f":"INDIRECT($A3 &\"!Y2\")","v":0},{"$f":"INDIRECT($A3 &\"!Z2\")","v":0},{"$f":"INDIRECT($A3 &\"!AA2\")","v":0}]
["空行"]
["上限負け額　マイナスで記載",0]
["上限負け額を超えた額",0,{"$f":"IF(C2<$C$5,C2-$C$5,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["勝ち額",0,{"$f":"IF(C2>0,C2,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["勝ち分控除額",0,{"$f":"IF(C2>0,SUM($C6:$AA6)*(C7/SUM($C$7:$AA$7)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["調整後の額",0,{"$f":"IF(C2>0,C2+C8,C2-C6)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["場代（合計）プラスで記載",0]
["参加者数",1,{"$f":"25-COUNTIF(C1:AA1,\"\")","v":1}]
["参加時間",{"$f":"SUM(C12:AA12)","v":0}]
["合計参加時間",{"$f":"SUM(C13:AA13)","v":0},{"$f":"SUM(C12:AA12)","v":0}]
["場代（一人当たり）プラスで記載",{"$error":"#DIV/0!"},{"$f":"IF(C1<>\"\",$C$10*C$12/$C$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(D1<>\"\",$C$10*D$12/$C$13,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["飯代　プラスで記載",0]
["立替え　プラスで記載",0]
["負け分控除　プラスで記載",0]
["システム開発寄付　プラスで記載",0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
["合計",{"$error":"#DIV/0!"},{"$f":"C9-C14-C15+C16+C17-C18","v":{"$error":"#DIV/0!"}},{"$f":"D9-D14-D15+D16+D17-D18","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["システム開発寄付合計",0,{"$f":"SUM(C18:AA18)","v":0}]
["精算額++",{"$error":"#DIV/0!"},{"$f":"C19+C20","v":{"$error":"#DIV/0!"}},{"$f":"D19","v":0},{"$f":"E19","v":0},{"$f":"F19","v":0},{"$f":"G19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["精算額(精算額++の欄の数値を手入力すること）",0]

{"sheet":"DATA","index":3,"n_rows":59,"n_cols":27,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["名前","CHECK",{"$f":"TOTAL!C1","v":"名無し"},{"$f":"TOTAL!D1","v":0},{"$f":"TOTAL!E1","v":0},{"$f":"TOTAL!F1","v":0},{"$f":"TOTAL!G1","v":0},{"$f":"TOTAL!H1","v":0},{"$f":"TOTAL!I1","v":0},{"$f":"TOTAL!J1","v":0},{"$f":"TOTAL!K1","v":0},{"$f":"TOTAL!L1","v":0},{"$f":"TOTAL!M1","v":0},{"$f":"TOTAL!N1","v":0},{"$f":"TOTAL!O1","v":0},{"$f":"TOTAL!P1","v":0},{"$f":"TOTAL!Q1","v":0},{"$f":"TOTAL!R1","v":0},{"$f":"TOTAL!S1","v":0},{"$f":"TOTAL!T1","v":0},{"$f":"TOTAL!U1","v":0},{"$f":"TOTAL!V1","v":0},{"$f":"TOTAL!W1","v":0},{"$f":"TOTAL!X1","v":0},{"$f":"TOTAL!Y1","v":0},{"$f":"TOTAL!Z1","v":0},{"$f":"TOTAL!AA1","v":0}]
["本日の成績",{"$f":"SUM(C2:AA2)","v":0},{"$f":"SUM(C3:C5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["賞金",{"$f":"SUM(C3:AA3)","v":0}]
["点数",0,{"$f":"SUMPRODUCT($A9:$A59,C9:C59)","v":0},{"$f":"SUMPRODUCT($A9:$A59,D9:D59)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["チップ",0,{"$f":"$C$6*C7","v":0},{"$f":"$C$6*D7","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["仮想チップ単価",0]
["チップ枚数",0]
["RATE",0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]
[100,0]