{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["大会申込書","リレー申込書","メール","団体","所属1","選手","エントリー","チーム"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":62,"n_cols":39,"rows_kept":62,"cut":false,"hidden":false,"merged":[[3,4,3,14],[0,0,0,29],[43,0,43,29],[22,24,22,29],[12,0,12,5],[13,0,13,5],[12,24,12,29],[13,24,13,29],[34,0,34,5],[34,6,34,8],[38,0,38,29],[39,0,39,29],[6,3,6,11],[6,15,6,22],[6,23,6,29],[41,0,42,2],[35,21,35,27],[9,0,9,2],[10,0,10,2],[10,15,10,29],[9,3,9,14],[10,3,10,14],[9,15,9,29],[33,0,33,5],[33,11,33,15],[35,0,35,5],[35,6,35,8],[34,11,34,13],[35,11,35,13],[16,24,16,29],[18,20,18,23],[15,23,15,26],[16,6,16,12],[16,13,16,19],[18,6,18,12],[18,13,18,19],[16,20,16,23],[34,28,34,29],[35,28,35,29],[35,19,35,20],[35,14,35,15],[35,9,35,10],[33,16,33,20],[35,16,35,18],[34,16,34,20],[19,18,19,20],[19,21,19,22],[34,9,34,10],[6,0,6,2],[8,0,8,2],[8,15,8,17],[8,18,8,29],[7,8,7,29],[7,4,7,7],[7,0,7,2],[8,3,8,14],[15,6,15,12],[15,13,15,15],[15,16,15,17],[15,18,15,20],[15,21,15,22],[15,27,15,29],[15,0,18,0],[15,1,15,5],[16,1,16,5],[18,1,18,5],[18,24,18,29],[6,12,6,14],[13,6,13,18],[12,6,12,18],[12,19,12,23],[13,19,13,23],[34,14,34,15],[34,21,34,27],[33,21,33,29],[20,20,20,23],[20,24,20,29],[22,1,22,5],[22,20,22,23],[20,6,20,12],[30,1,30,5],[30,20,30,23],[30,24,30,29],[27,21,27,22],[27,23,27,26],[27,27,27,29],[28,24,28,29],[23,21,23,22],[23,23,23,26],[23,27,23,29],[24,24,24,29],[26,24,26,29],[33,6,33,10],[23,1,23,5],[23,6,23,12],[23,13,23,15],[23,16,23,17],[24,6,24,12],[24,13,24,19],[26,6,26,12],[26,13,26,19],[23,18,23,20],[24,1,24,5],[24,20,24,23],[26,1,26,5],[26,20,26,23],[19,23,19,26],[19,27,19,29],[20,1,20,5],[27,0,30,0],[27,1,27,5],[27,6,27,12],[27,13,27,15],[27,16,27,17],[28,6,28,12],[28,13,28,19],[30,6,30,12],[30,13,30,19],[27,18,27,20],[28,1,28,5],[28,20,28,23],[19,0,22,0],[19,1,19,5],[19,6,19,12],[19,13,19,15],[19,16,19,17],[20,13,20,19],[22,6,22,12],[22,13,22,19],[23,0,26,0]]}
[{"$f":"AH1&\"　申込書\"","v":"AQUATICS JAPANCUP CHAMPIONSHIP 2023 OPEN フリーリレー　申込書"},{"$nulls":30},"Ver1.0",null,"AQUATICS JAPANCUP CHAMPIONSHIP 2023 OPEN フリーリレー"]
[]
["※出場日ごとに申し込んでください",{"$nulls":33},"最初に出場日を選択してください"]
[null,null,null,"大会日：","2023-12-24",{"$nulls":17},"を記載してください",{"$nulls":11},"2023-12-24",null,"2023-11-20"]
[]
["申込情報"]
["チーム\n略称",null,null,{"$f":"G19&G23&G27&G31","v":""},{"$nulls":8},"略称\nカナ",null,null,{"$f":"G17&G21&G25&G29","v":""},{"$nulls":17},{"$f":"IF(AND(Y17=Y21,Y17=Y25,Y17=Y29),Y17,AO4)","v":0}]
[" 住　所",null,null,"〒"]
["ＴＥＬ",{"$nulls":14},"ＦＡＸ"]
["携帯電話",{"$nulls":14},"大会当日緊急時の連絡先"]
["申込者名"]
[]
[{"$nulls":6},"種　　目",{"$nulls":12},"区分",{"$nulls":4},"エントリータイム",{"$nulls":8},"金額","性別","種目No","距離",null,"プロNo"]
["種　目",{"$nulls":18},{"$f":"IFERROR(AK33,\"\")","v":""},{"$nulls":13},{"$f":"IF(G14=\"\",\"\",VLOOKUP(G14,AH46:AM51,5,0))","v":""},{"$f":"IF(G14=\"\",\"\",VLOOKUP(G14,AH46:AM51,2,0))","v":""},{"$f":"IF(G14=\"\",\"\",VLOOKUP(G14,AH46:AM51,3,0))","v":""},{"$f":"IF(G14=\"\",\"\",VLOOKUP(G14,AH46:AM51,4,0))","v":""},{"$f":"IF(Y14=\"\",\"999:99.99\",\" \"&LEFT(RIGHT(\"  \"&TEXT(Y14,\"0.00\"),7),2)&\":\"&RIGHT(TEXT(Y14,\"0.00\"),5))","v":"999:99.99"},{"$f":"IF(G14=\"\",\"\",VLOOKUP(G14,AH46:AM51,6,0))","v":""}]
[]
["第一泳者","生年月日",{"$nulls":11},"性別",{"$nulls":4},"暦年齢",null,null,{"$f":"IF(G16=\"\",\"\",YEAR($E$4)-YEAR(G16))","v":""},null,"個人種目",{"$nulls":9},"氏名","性別","年齢","生年月日","チームID","個人ID"]
[null,"フリガナ",{"$nulls":18},"チーム名",{"$nulls":12},{"$f":"ASC(TRIM(G17))&\" \"&ASC(TRIM(N17))","v":" "},{"$f":"IF(Q16=\"男子\",0,IF(Q16=\"女子\",5,9))","v":9},{"$f":"V16","v":""},{"$f":"G16","v":"00:00:00"},{"$f":"IF(Y17=\"\",\"\",Y17)","v":""},{"$f":"IF(Y19=\"\",\"\",Y19)","v":""}]
[]
[null,"氏　　名",{"$nulls":31},{"$f":"ASC(TRIM(G19))&\"　\"&ASC(TRIM(N19))","v":"　"}]
["第二泳者","生年月日",{"$nulls":11},"性別",{"$nulls":4},"暦年齢",null,null,{"$f":"IF(G20=\"\",\"\",YEAR($E$4)-YEAR(G20))","v":""},null,"個人種目",{"$nulls":9},"氏名",null,"年齢","生年月日","チームID","個人ID"]
[null,"フリガナ",{"$nulls":18},"チーム名",{"$nulls":12},{"$f":"ASC(TRIM(G21))&\" \"&ASC(TRIM(N21))","v":" "},{"$f":"IF(Q20=\"男子\",0,IF(Q20=\"女子\",5,9))","v":9},{"$f":"V20","v":""},{"$f":"G20","v":"00:00:00"},{"$f":"IF(Y21=\"\",\"\",Y21)","v":""},{"$f":"IF(Y23=\"\",\"\",Y23)","v":""}]
[]
[null,"氏　　名",{"$nulls":31},{"$f":"ASC(TRIM(G23))&\"　\"&ASC(TRIM(N23))","v":"　"}]
["第三泳者","生年月日",{"$nulls":11},"性別",{"$nulls":4},"暦年齢",null,null,{"$f":"IF(G24=\"\",\"\",YEAR($E$4)-YEAR(G24))","v":""},null,"個人種目",{"$nulls":9},"氏名",null,"年齢","生年月日","チームID","個人ID"]
[null,"フリガナ",{"$nulls":18},"チーム名",{"$nulls":12},{"$f":"ASC(TRIM(G25))&\" \"&ASC(TRIM(N25))","v":" "},{"$f":"IF(Q24=\"男子\",0,IF(Q24=\"女子\",5,9))","v":9},{"$f":"V24","v":""},{"$f":"G24","v":"00:00:00"},{"$f":"IF(Y25=\"\",\"\",Y25)","v":""},{"$f":"IF(Y27=\"\",\"\",Y27)","v":""}]
[]
[null,"氏　　名",{"$nulls":31},{"$f":"ASC(TRIM(G27))&\"　\"&ASC(TRIM(N27))","v":"　"}]
["第四泳者","生年月日",{"$nulls":11},"性別",{"$nulls":4},"暦年齢",null,null,{"$f":"IF(G28=\"\",\"\",YEAR($E$4)-YEAR(G28))","v":""},null,"個人種目",{"$nulls":9},"氏名",null,"年齢","生年月日","チームID","個人ID"]
[null,"フリガナ",{"$nulls":18},"チーム名",{"$nulls":12},{"$f":"ASC(TRIM(G29))&\" \"&ASC(TRIM(N29))","v":" "},{"$f":"IF(Q28=\"男子\",0,IF(Q28=\"女子\",5,9))","v":9},{"$f":"V28","v":""},{"$f":"G28","v":"00:00:00"},{"$f":"IF(Y29=\"\",\"\",Y29)","v":""},{"$f":"IF(Y31=\"\",\"\",Y31)","v":""}]
[]
[null,"氏　　名",{"$nulls":31},{"$f":"ASC(TRIM(G31))&\"　\"&ASC(TRIM(N31))","v":"　"}]
[]
["申込数・申込金額",{"$nulls":34},{"$f":"AJ17+AJ21+AJ25+AJ29","v":{"$error":"#VALUE!"}},{"$f":"IF(AJ33<80,79,AJ33-MOD(AJ33,40))","v":{"$error":"#VALUE!"}}]
[{"$nulls":6},"女　子",{"$nulls":4},"男　子",{"$nulls":4},"混　合",{"$nulls":4},"合　計"]
["参　加　者　数",{"$nulls":5},{"$f":"COUNTIF(AI17:AI29,5)","v":0},null,null,"名",null,{"$f":"COUNTIF(AI17:AI29,0)","v":0},null,null,"名",{"$nulls":6},{"$f":"G35+L35","v":0},{"$nulls":6},"名"]
["参加種目数",{"$nulls":5},{"$f":"IF(AI14=5,1,0)","v":0},null,null,"種目",null,{"$f":"IF(AI14=0,1,0)","v":0},null,null,"種目",null,{"$f":"IF(AI14=9,1,0)","v":0},null,null,"種目",null,{"$f":"AH14","v":""},{"$nulls":6},"円"]
[]
["振込明細"]
["　※個人種目参加者いずれか１名の大会申込書【申込金額】リレー種目欄に申込数を入力下さい。"]
["　※振り込みは個人種目とまとめて行ってください。"]
[]
["備考　"]
[]
[]
[{"$nulls":38},"プロNo"]
[{"$nulls":33},"女子 4× 25mフリーリレー",5,16,200,2000,76]
[{"$nulls":33},"男子 4× 25mフリーリレー",0,16,200,2000,77]
[{"$nulls":33},"混合 4× 25mフリーリレー",9,6,200,2000,39]
[{"$nulls":33},"混合 4× 25mフリーリレー（性別オープン）",9,6,400,2000]
[]
[]
[]
[]
[]
[{"$nulls":33},"50m　自由形"]
[{"$nulls":33},"50m　背泳ぎ"]
[{"$nulls":33},"50m　平泳ぎ"]
[{"$nulls":33},"50m　バタフライ"]
[{"$nulls":33},"25m　自由形"]
[{"$nulls":33},"25m　背泳ぎ"]
[{"$nulls":33},"25m　平泳ぎ"]
[{"$nulls":33},"25m　バタフライ"]

{"sheet":"リレー申込書","index":1,"n_rows":14,"n_cols":22,"rows_kept":14,"cut":false,"hidden":true,"merged":[[11,1,11,3],[11,5,11,20],[11,21,11,22],[0,0,0,23],[2,9,2,23],[10,21,10,22],[6,2,6,13],[6,14,6,21],[7,10,7,21],[7,2,7,9],[10,5,10,20],[10,1,10,3],[13,1,13,3],[13,21,13,22],[13,5,13,20],[12,1,12,3],[12,5,12,20],[12,21,12,22]]}
["AQUATICS JAPANCUP CHAMPIONSHIP 2023 OPEN フリーリレー種目申込書"]
[]
[{"$nulls":9},{"$f":"大会申込書!D7","v":""}]
[]
[]
[]
[null,null,{"$f":"大会申込書!AI4","v":"2023-12-24"},{"$nulls":11},{"$f":"IF(大会申込書!G14=\"\",\"\",LEFT(大会申込書!G14,2))","v":""}]
[null,null,{"$f":"IF(大会申込書!G14=\"\",\"\",MID(大会申込書!G14,3,7))","v":""},{"$nulls":7},{"$f":"IF(大会申込書!G14=\"\",\"\",MID(大会申込書!G14,10,20))","v":""}]
[]
[]
[null,"①",null,null,null,{"$f":"大会申込書!AH19","v":"　"},{"$nulls":15},"様"]
[null,"②",null,null,null,{"$f":"大会申込書!AH23","v":"　"},{"$nulls":15},"様"]
[null,"③",null,null,null,{"$f":"大会申込書!AH27","v":"　"},{"$nulls":15},"様"]
[null,"④",null,null,null,{"$f":"大会申込書!AH31","v":"　"},{"$nulls":15},"様"]

{"sheet":"メール","index":2,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["大会名","訂正締切日","返信宛先"]
[{"$f":"大会申込書!AH1","v":"AQUATICS JAPANCUP CHAMPIONSHIP 2023 OPEN フリーリレー"},"2022-10-01","namihaya2022@tdsystem.co.jp"]

{"sheet":"団体","index":3,"n_rows":3,"n_cols":24,"rows_kept":3,"cut":false,"hidden":true,"merged":[[0,3,0,5],[0,9,0,11],[0,6,0,8]]}
[null,null,null,"参加人数",null,null,"個人種目",null,null,"リレー種目数"]
["No","チームID","チーム略称","女子","男子","合計","女子","男子","合計","女子","男子","混合","合計","入金金額","連絡責任者名","郵便番号","住所１","電話番号","ＦＡＸ番号","携帯電話番号","緊急連絡先","振込日","振込名義名","備考"]
[null,{"$f":"大会申込書!AO4","v":0},{"$f":"大会申込書!D7","v":""},{"$f":"大会申込書!G35","v":0},{"$f":"大会申込書!L35","v":0},{"$f":"D3+E3","v":0},0,0,0,{"$f":"大会申込書!G36","v":0},{"$f":"大会申込書!L36","v":0},{"$f":"大会申込書!Q36","v":0},{"$f":"SUM(J3:L3)","v":0},{"$f":"VALUE(ASC(大会申込書!V36))","v":{"$error":"#VALUE!"}},{"$f":"大会申込書!D11","v":0},{"$f":"大会申込書!E8","v":0},{"$f":"大会申込書!I8","v":0},{"$f":"IF(大会申込書!D9=\"\",\"\",大会申込書!D9)","v":""},{"$f":"IF(大会申込書!S9=\"\",\"\",大会申込書!S9)","v":""},{"$f":"IF(大会申込書!D10=\"\",\"\",大会申込書!D10)","v":""},{"$f":"IF(大会申込書!P11=\"\",\"\",大会申込書!P11)","v":""},null,null,{"$f":"IF(大会申込書!A44=\"\",\"\",大会申込書!A44)","v":""}]

{"sheet":"所属1","index":4,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["所属番号","所属名","所属略称","所属名カナ","所属略称カナ"]
[{"$f":"団体!B3","v":0},{"$f":"大会申込書!D7","v":""},{"$f":"B2","v":""},{"$f":"大会申込書!P7","v":""},{"$f":"D2","v":""}]

{"sheet":"選手","index":5,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["選手No","性別","氏名2","暦年齢","区分No","JASF","団体番号","生年月日","氏名カナ"]
[1,{"$f":"大会申込書!AI17","v":9},{"$f":"大会申込書!AH19","v":"　"},{"$f":"大会申込書!AJ17","v":""},{"$f":"IF(D2=\"\",\"\",IF(D2<25,18,D2-MOD(D2,5)))","v":""},{"$f":"大会申込書!AM17","v":""},{"$f":"団体!$B$3","v":0},{"$f":"大会申込書!AK17","v":"00:00:00"},{"$f":"大会申込書!AH17","v":" "}]
[2,{"$f":"大会申込書!AI21","v":9},{"$f":"大会申込書!AH23","v":"　"},{"$f":"大会申込書!AJ21","v":""},{"$f":"IF(D3=\"\",\"\",IF(D3<25,18,D3-MOD(D3,5)))","v":""},{"$f":"大会申込書!AM21","v":""},{"$f":"団体!$B$3","v":0},{"$f":"大会申込書!AK21","v":"00:00:00"},{"$f":"大会申込書!AH21","v":" "}]
[3,{"$f":"大会申込書!AI25","v":9},{"$f":"大会申込書!AH27","v":"　"},{"$f":"大会申込書!AJ25","v":""},"",{"$f":"大会申込書!AM25","v":""},{"$f":"団体!$B$3","v":0},{"$f":"大会申込書!AK25","v":"00:00:00"},{"$f":"大会申込書!AH25","v":" "}]
[4,{"$f":"大会申込書!AI29","v":9},{"$f":"大会申込書!AH31","v":"　"},{"$f":"大会申込書!AJ29","v":""},"",{"$f":"大会申込書!AM29","v":""},{"$f":"団体!$B$3","v":0},{"$f":"大会申込書!AK29","v":"00:00:00"},{"$f":"大会申込書!AH29","v":" "}]

{"sheet":"エントリー","index":6,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["選手No","種目No","距離","区分No","オープン","性別","エントリータイム"]
[{"$nulls":11},{"$f":"COUNTIF(C2:C3,400)","v":0}]

{"sheet":"チーム","index":7,"n_rows":61,"n_cols":14,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
["性別","チーム名","チーム名カナ","学種","区分No","エントリータイム","団体番号","オープン","種目No","距離","泳者1No","泳者2No","泳者3No","泳者4No"]
[{"$f":"大会申込書!AI14","v":""},{"$f":"所属1!C2","v":""},{"$f":"所属1!D2","v":""},5,{"$f":"大会申込書!AK33","v":{"$error":"#VALUE!"}},{"$f":"大会申込書!AL14","v":"999:99.99"},{"$f":"所属1!A2","v":0},0,{"$f":"大会申込書!AJ14","v":""},{"$f":"大会申込書!AK14","v":""},1,2,3,4]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]
[null,null,null,5,null,null,null,0]