{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["集計表","シングルス","ダブルス","県推薦"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":4,"comments":3,"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":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":false,"merged":[[16,7,17,19],[39,5,40,18],[30,14,31,18],[36,7,37,14],[31,0,32,3],[33,0,34,3],[36,0,37,3],[30,7,31,12],[36,5,37,6],[36,16,37,17],[33,5,34,17],[41,8,42,18],[38,0,39,2],[38,3,39,3],[33,18,34,18],[23,1,24,1],[23,2,24,5],[23,6,24,6],[23,7,24,19],[25,1,25,6],[25,14,25,16],[25,17,25,19],[19,7,20,19],[21,1,22,1],[21,2,21,5],[21,6,22,6],[21,7,22,7],[21,8,22,19],[22,2,22,5],[16,1,17,1],[16,2,17,5],[16,6,17,6],[18,1,20,1],[18,2,20,5],[18,6,20,6],[18,8,18,14],[18,15,18,19],[11,1,12,10],[11,11,12,15],[11,16,12,18],[11,19,12,19],[14,1,15,1],[14,2,15,5],[14,6,15,6],[14,7,15,14],[14,15,15,15],[14,16,15,19],[10,2,10,7],[10,8,10,9],[10,10,10,11],[10,12,10,13],[10,14,10,15],[10,16,10,18],[9,2,9,7],[9,8,9,9],[9,10,9,11],[9,12,9,13],[9,14,9,15],[9,16,9,18],[8,2,8,7],[8,8,8,9],[8,10,8,11],[8,12,8,13],[8,14,8,15],[8,16,8,18],[7,2,7,7],[7,8,7,9],[7,10,7,11],[7,12,7,13],[7,14,7,15],[7,16,7,18],[5,2,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[5,16,5,18],[4,2,4,7],[4,8,4,9],[4,10,4,11],[4,12,4,13],[4,14,4,15],[4,16,4,18],[0,0,0,19],[2,1,2,19],[3,1,3,7],[3,8,3,11],[3,12,3,15],[3,16,3,19],[45,7,46,12],[46,0,47,3],[48,0,49,3],[48,5,49,17],[48,18,49,18],[45,13,46,18],[56,8,57,18],[30,5,31,6],[45,5,46,6],[51,0,52,3],[51,5,52,6],[51,7,52,14],[51,16,52,17],[53,0,54,2],[53,3,54,3],[54,5,55,18],[6,2,6,7],[6,8,6,9],[6,10,6,11],[6,12,6,13],[6,14,6,15],[6,16,6,18]]}
["令和7年度 全日本地区予選　参加申込み"]
[]
[null,"集　計　表　　（選手を入力すると自動計算します）"]
[null,"種　　目",null,null,null,null,null,null,"参加料",null,null,null,"人　数",null,null,null,"金　額"]
[null,"①","ジュニア男子シングルス",null,null,null,null,null,800,null,"円×",null,{"$f":"COUNTIF(シングルス!B:B,B5&C5)","v":0},null,"人＝",null,{"$f":"M5*I5","v":0},null,null,"円"]
[null,"②","ジュニア女子シングルス",null,null,null,null,null,800,null,"円×",null,{"$f":"COUNTIF(シングルス!B:B,B6&C6)","v":0},null,"人＝",null,{"$f":"M6*I6","v":0},null,null,"円"]
[null,"③","混合ダブルス",null,null,null,null,null,1400,null,"円×",null,{"$f":"COUNTIF(ダブルス!B:B,B7&C7)","v":0},null,"組＝",null,0,null,null,"円"]
[null,"④","一般男子シングルス",null,null,null,null,null,1000,null,"円×",null,{"$f":"COUNTIF(シングルス!B:B,B8&C8)","v":0},null,"人＝",null,0,null,null,"円"]
[null,"⑤","一般女子シングルス",null,null,null,null,null,1000,null,"円×",null,{"$f":"COUNTIF(シングルス!B:B,B9&C9)","v":0},null,"人＝",null,0,null,null,"円"]
[null,"⑥","男子ダブルス",null,null,null,null,null,1400,null,"円×",null,{"$f":"COUNTIF(ダブルス!B:B,B10&C10)","v":0},null,"組＝",null,0,null,null,"円"]
[null,"⑦","女子ダブルス",null,null,null,null,null,1400,null,"円×",null,{"$f":"COUNTIF(ダブルス!B:B,B11&C11)","v":0},null,"組＝",null,0,null,null,"円"]
[null,"集計表は１枚にまとめて下さい",null,null,null,null,null,null,null,null,null,"申込み総額",null,null,null,null,{"$f":"SUM(Q5:S11)","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,"管理No."]
[]
[]
[]
[]
[null,null,null,null,null,"県大会用",null,"領　収　書",null,null,null,null,null,null,"令和　７年　　月　　日"]
["チーム名"]
[]
[{"$f":"F34","v":0},null,null,null,null,{"$f":"H15","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,"令和　７年　８月　　　日"]
["チーム名"]
[]
[{"$f":"F49","v":0},null,null,null,null,{"$f":"H15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"様"]
[]
[]
["領収金額",null,null,null,null,"金額",null,{"$f":"Q12","v":0},null,null,null,null,null,null,null,null,"円也"]
[]
[{"$f":"H52","v":0},null,null,"円"]
[null,null,null,null,null,"令和７年度 全日本地区予選参加料として"]
[]
[null,null,null,null,null,null,null,null,"置賜地区卓球協会　事務局　松本　治"]

{"sheet":"シングルス","index":1,"n_rows":85,"n_cols":26,"rows_kept":85,"cut":false,"hidden":false,"merged":[[3,12,3,21],[62,11,63,15],[62,18,63,19],[62,21,63,21],[64,6,65,10],[64,18,65,19],[64,21,65,21],[62,6,63,10],[62,20,63,20],[64,20,65,20],[58,6,59,10],[58,11,59,15],[58,18,59,19],[58,21,59,21],[60,6,61,10],[60,11,61,15],[60,18,61,19],[60,21,61,21],[58,20,59,20],[60,20,61,20],[54,11,55,15],[54,18,55,19],[54,21,55,21],[56,6,57,10],[56,11,57,15],[56,18,57,19],[56,21,57,21],[54,20,55,20],[56,20,57,20],[50,11,51,15],[50,18,51,19],[50,21,51,21],[52,6,53,10],[52,11,53,15],[52,18,53,19],[52,21,53,21],[50,20,51,20],[52,20,53,20],[46,6,47,10],[46,11,47,15],[46,18,47,19],[46,21,47,21],[48,6,49,10],[48,11,49,15],[48,18,49,19],[48,21,49,21],[46,20,47,20],[48,20,49,20],[42,11,43,15],[42,18,43,19],[42,21,43,21],[44,6,45,10],[44,11,45,15],[44,18,45,19],[44,21,45,21],[42,20,43,20],[44,20,45,20],[38,11,39,15],[38,18,39,19],[38,21,39,21],[40,6,41,10],[40,11,41,15],[40,18,41,19],[40,21,41,21],[38,20,39,20],[40,20,41,20],[34,6,35,10],[34,11,35,15],[34,18,35,19],[34,21,35,21],[36,6,37,10],[36,11,37,15],[36,18,37,19],[36,21,37,21],[34,20,35,20],[36,20,37,20],[30,11,31,15],[30,18,31,19],[30,21,31,21],[32,6,33,10],[32,11,33,15],[32,18,33,19],[32,21,33,21],[30,20,31,20],[32,20,33,20],[26,18,27,19],[26,21,27,21],[28,6,29,10],[28,11,29,15],[28,18,29,19],[28,21,29,21],[26,20,27,20],[28,20,29,20],[26,16,27,17],[28,16,29,17],[22,18,23,19],[22,21,23,21],[24,6,25,10],[24,11,25,15],[24,18,25,19],[24,21,25,21],[22,20,23,20],[24,20,25,20],[22,16,23,17],[24,16,25,17],[20,18,21,19],[20,21,21,21],[20,20,21,20],[18,16,19,17],[20,16,21,17],[18,20,19,20],[16,11,17,15],[16,18,17,19],[16,21,17,21],[14,20,15,20],[16,20,17,20],[18,21,19,21],[10,21,11,21],[12,6,13,10],[12,11,13,15],[12,18,13,19],[12,21,13,21],[14,6,15,10],[14,11,15,15],[14,18,15,19],[14,21,15,21],[6,21,7,21],[8,0,9,0],[8,6,9,10],[8,11,9,15],[8,18,9,19],[8,21,9,21],[6,0,7,0],[6,1,7,5],[6,16,7,17],[6,6,7,10],[64,0,65,0],[62,0,63,0],[60,0,61,0],[60,16,61,17],[62,16,63,17],[64,16,65,17],[60,1,61,5],[62,1,63,5],[64,1,65,5],[64,11,65,15],[58,0,59,0],[56,0,57,0],[54,0,55,0],[54,16,55,17],[56,16,57,17],[58,16,59,17],[54,1,55,5],[56,1,57,5],[58,1,59,5],[54,6,55,10],[52,0,53,0],[50,0,51,0],[48,0,49,0],[48,16,49,17],[50,16,51,17],[52,16,53,17],[48,1,49,5],[50,1,51,5],[52,1,53,5],[50,6,51,10],[46,0,47,0],[44,0,45,0],[42,0,43,0],[42,16,43,17],[44,16,45,17],[46,16,47,17],[42,1,43,5],[44,1,45,5],[46,1,47,5],[42,6,43,10],[40,0,41,0],[38,0,39,0],[36,0,37,0],[36,16,37,17],[38,16,39,17],[40,16,41,17],[36,1,37,5],[38,1,39,5],[40,1,41,5],[38,6,39,10],[34,0,35,0],[32,0,33,0],[30,0,31,0],[30,16,31,17],[32,16,33,17],[34,16,35,17],[30,1,31,5],[32,1,33,5],[34,1,35,5],[30,6,31,10],[26,1,27,5],[28,1,29,5],[26,6,27,10],[26,11,27,15],[18,6,19,10],[18,11,19,15],[22,6,23,10],[22,11,23,15],[20,6,21,10],[20,11,21,15],[26,0,27,0],[24,0,25,0],[14,0,15,0],[12,0,13,0],[8,16,9,17],[10,16,11,17],[12,16,13,17],[8,1,9,5],[10,1,11,5],[24,1,25,5],[12,1,13,5],[14,1,15,5],[10,0,11,0],[6,11,7,15],[14,16,15,17],[16,16,17,17],[16,1,17,5],[10,6,11,10],[10,11,11,15],[16,6,17,10],[6,20,7,20],[8,20,9,20],[10,20,11,20],[12,20,13,20],[6,18,7,19],[18,18,19,19],[10,18,11,19],[66,0,67,0],[66,1,67,5],[22,0,23,0],[20,0,21,0],[18,0,19,0],[16,0,17,0],[18,1,19,5],[20,1,21,5],[22,1,23,5],[28,0,29,0],[66,6,67,10],[66,11,67,15],[66,16,67,17],[66,18,67,19],[70,21,71,21],[66,20,67,20],[66,21,67,21],[68,20,69,20],[68,0,69,0],[68,1,69,5],[68,6,69,10],[68,11,69,15],[68,16,69,17],[68,18,69,19],[72,20,73,20],[72,21,73,21],[68,21,69,21],[70,0,71,0],[70,1,71,5],[70,6,71,10],[70,11,71,15],[70,16,71,17],[70,18,71,19],[70,20,71,20],[72,0,73,0],[72,1,73,5],[72,6,73,10],[72,11,73,15],[72,16,73,17],[72,18,73,19],[74,0,75,0],[74,1,75,5],[74,6,75,10],[74,11,75,15],[74,16,75,17],[74,18,75,19],[78,21,79,21],[74,20,75,20],[74,21,75,21],[76,0,77,0],[76,1,77,5],[76,6,77,10],[76,11,77,15],[76,16,77,17],[76,18,77,19],[76,20,77,20],[80,20,81,20],[80,21,81,21],[76,21,77,21],[78,0,79,0],[78,1,79,5],[78,6,79,10],[78,11,79,15],[78,16,79,17],[78,18,79,19],[78,20,79,20],[80,0,81,0],[80,1,81,5],[80,6,81,10],[80,11,81,15],[80,16,81,17],[80,18,81,19],[84,20,85,20],[82,0,83,0],[82,1,83,5],[82,6,83,10],[82,11,83,15],[82,16,83,17],[82,18,83,19],[84,21,85,21],[84,22,85,26],[82,20,83,20],[82,21,83,21],[84,0,85,0],[84,1,85,5],[84,6,85,10],[84,11,85,15],[84,16,85,17],[84,18,85,19],[4,20,5,20],[4,21,5,21],[4,0,5,0],[4,1,5,5],[4,6,5,10],[4,11,5,15],[5,16,5,17],[5,18,5,19],[4,16,4,19]]}
["項目の行でカーソルを停止すると説明が表示されます。"]
["このシートに４つのシングルス種目の参加者を全て入力してください。※種目毎にシートを複製しないでください。"]
["各種目かためて強い順に記入ください。組み合わせに反映いたします。"]
[{"$f":"\"シングルス申込書\"","v":"シングルス申込書"},null,null,null,null,null,null,null,null,null,null,"チーム名:",{"$f":"集計表!H15","v":0}]
["項目","①種目",null,null,null,null,"②氏名",null,null,null,null,"③所属名",null,null,null,null,"自動入力",null,null,null,"⑥生年月日\n（西暦）","⑦戦績・備考\n※学生がクラブから出る場合は学校名を記載",null,null,null,"県大会開催日"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"④年齢",null,"⑤学年"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G7=\"\",U7=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U7)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U7)*100+DAY(U7), 1, 0))","v":""},null,{"$f":"IF(OR(G7=\"\",U7=\"\"),\"\",IF(OR(DATEDIF(U7,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U7,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U7,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""},null,null,null,null,null,null,"2024-10-12"]
[]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G9=\"\",U9=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U9)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U9)*100+DAY(U9), 1, 0))","v":""},null,{"$f":"IF(OR(G9=\"\",U9=\"\"),\"\",IF(OR(DATEDIF(U9,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U9,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U9,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","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,"種目"]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G11=\"\",U11=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U11)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U11)*100+DAY(U11), 1, 0))","v":""},null,{"$f":"IF(OR(G11=\"\",U11=\"\"),\"\",IF(OR(DATEDIF(U11,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U11,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U11,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","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,"②ジュニア女子シングルス"]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G13=\"\",U13=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U13)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U13)*100+DAY(U13), 1, 0))","v":""},null,{"$f":"IF(OR(G13=\"\",U13=\"\"),\"\",IF(OR(DATEDIF(U13,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U13,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U13,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","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,"⑤一般女子シングルス"]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G15=\"\",U15=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U15)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U15)*100+DAY(U15), 1, 0))","v":""},null,{"$f":"IF(OR(G15=\"\",U15=\"\"),\"\",IF(OR(DATEDIF(U15,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U15,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U15,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G17=\"\",U17=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U17)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U17)*100+DAY(U17), 1, 0))","v":""},null,{"$f":"IF(OR(G17=\"\",U17=\"\"),\"\",IF(OR(DATEDIF(U17,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U17,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U17,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G19=\"\",U19=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U19)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U19)*100+DAY(U19), 1, 0))","v":""},null,{"$f":"IF(OR(G19=\"\",U19=\"\"),\"\",IF(OR(DATEDIF(U19,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U19,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U19,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G21=\"\",U21=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U21)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U21)*100+DAY(U21), 1, 0))","v":""},null,{"$f":"IF(OR(G21=\"\",U21=\"\"),\"\",IF(OR(DATEDIF(U21,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U21,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U21,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G23=\"\",U23=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U23)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U23)*100+DAY(U23), 1, 0))","v":""},null,{"$f":"IF(OR(G23=\"\",U23=\"\"),\"\",IF(OR(DATEDIF(U23,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U23,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U23,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G25=\"\",U25=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U25)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U25)*100+DAY(U25), 1, 0))","v":""},null,{"$f":"IF(OR(G25=\"\",U25=\"\"),\"\",IF(OR(DATEDIF(U25,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U25,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U25,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G27=\"\",U27=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U27)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U27)*100+DAY(U27), 1, 0))","v":""},null,{"$f":"IF(OR(G27=\"\",U27=\"\"),\"\",IF(OR(DATEDIF(U27,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U27,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U27,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G29=\"\",U29=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U29)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U29)*100+DAY(U29), 1, 0))","v":""},null,{"$f":"IF(OR(G29=\"\",U29=\"\"),\"\",IF(OR(DATEDIF(U29,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U29,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U29,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[13,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G31=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G31=\"\",U31=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U31)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U31)*100+DAY(U31), 1, 0))","v":""},null,{"$f":"IF(OR(G31=\"\",U31=\"\"),\"\",IF(OR(DATEDIF(U31,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U31,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U31,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[14,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G33=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G33=\"\",U33=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U33)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U33)*100+DAY(U33), 1, 0))","v":""},null,{"$f":"IF(OR(G33=\"\",U33=\"\"),\"\",IF(OR(DATEDIF(U33,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U33,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U33,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[15,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G35=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G35=\"\",U35=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U35)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U35)*100+DAY(U35), 1, 0))","v":""},null,{"$f":"IF(OR(G35=\"\",U35=\"\"),\"\",IF(OR(DATEDIF(U35,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U35,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U35,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[16,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G37=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G37=\"\",U37=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U37)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U37)*100+DAY(U37), 1, 0))","v":""},null,{"$f":"IF(OR(G37=\"\",U37=\"\"),\"\",IF(OR(DATEDIF(U37,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U37,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U37,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[17,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G39=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G39=\"\",U39=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U39)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U39)*100+DAY(U39), 1, 0))","v":""},null,{"$f":"IF(OR(G39=\"\",U39=\"\"),\"\",IF(OR(DATEDIF(U39,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U39,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U39,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[18,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G41=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G41=\"\",U41=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U41)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U41)*100+DAY(U41), 1, 0))","v":""},null,{"$f":"IF(OR(G41=\"\",U41=\"\"),\"\",IF(OR(DATEDIF(U41,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U41,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U41,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[19,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G43=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G43=\"\",U43=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U43)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U43)*100+DAY(U43), 1, 0))","v":""},null,{"$f":"IF(OR(G43=\"\",U43=\"\"),\"\",IF(OR(DATEDIF(U43,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U43,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U43,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[20,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G45=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G45=\"\",U45=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U45)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U45)*100+DAY(U45), 1, 0))","v":""},null,{"$f":"IF(OR(G45=\"\",U45=\"\"),\"\",IF(OR(DATEDIF(U45,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U45,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U45,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[21,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G47=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G47=\"\",U47=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U47)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U47)*100+DAY(U47), 1, 0))","v":""},null,{"$f":"IF(OR(G47=\"\",U47=\"\"),\"\",IF(OR(DATEDIF(U47,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U47,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U47,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[22,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G49=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G49=\"\",U49=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U49)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U49)*100+DAY(U49), 1, 0))","v":""},null,{"$f":"IF(OR(G49=\"\",U49=\"\"),\"\",IF(OR(DATEDIF(U49,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U49,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U49,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[23,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G51=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G51=\"\",U51=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U51)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U51)*100+DAY(U51), 1, 0))","v":""},null,{"$f":"IF(OR(G51=\"\",U51=\"\"),\"\",IF(OR(DATEDIF(U51,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U51,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U51,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[24,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G53=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G53=\"\",U53=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U53)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U53)*100+DAY(U53), 1, 0))","v":""},null,{"$f":"IF(OR(G53=\"\",U53=\"\"),\"\",IF(OR(DATEDIF(U53,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U53,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U53,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[25,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G55=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G55=\"\",U55=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U55)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U55)*100+DAY(U55), 1, 0))","v":""},null,{"$f":"IF(OR(G55=\"\",U55=\"\"),\"\",IF(OR(DATEDIF(U55,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U55,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U55,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[26,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G57=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G57=\"\",U57=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U57)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U57)*100+DAY(U57), 1, 0))","v":""},null,{"$f":"IF(OR(G57=\"\",U57=\"\"),\"\",IF(OR(DATEDIF(U57,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U57,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U57,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[27,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G59=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G59=\"\",U59=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U59)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U59)*100+DAY(U59), 1, 0))","v":""},null,{"$f":"IF(OR(G59=\"\",U59=\"\"),\"\",IF(OR(DATEDIF(U59,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U59,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U59,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[28,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G61=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G61=\"\",U61=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U61)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U61)*100+DAY(U61), 1, 0))","v":""},null,{"$f":"IF(OR(G61=\"\",U61=\"\"),\"\",IF(OR(DATEDIF(U61,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U61,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U61,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[29,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G63=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G63=\"\",U63=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U63)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U63)*100+DAY(U63), 1, 0))","v":""},null,{"$f":"IF(OR(G63=\"\",U63=\"\"),\"\",IF(OR(DATEDIF(U63,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U63,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U63,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[30,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G65=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G65=\"\",U65=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U65)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U65)*100+DAY(U65), 1, 0))","v":""},null,{"$f":"IF(OR(G65=\"\",U65=\"\"),\"\",IF(OR(DATEDIF(U65,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U65,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U65,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[31,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G67=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G67=\"\",U67=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U67)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U67)*100+DAY(U67), 1, 0))","v":""},null,{"$f":"IF(OR(G67=\"\",U67=\"\"),\"\",IF(OR(DATEDIF(U67,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U67,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U67,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[32,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G69=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G69=\"\",U69=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U69)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U69)*100+DAY(U69), 1, 0))","v":""},null,{"$f":"IF(OR(G69=\"\",U69=\"\"),\"\",IF(OR(DATEDIF(U69,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U69,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U69,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[33,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G71=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G71=\"\",U71=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U71)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U71)*100+DAY(U71), 1, 0))","v":""},null,{"$f":"IF(OR(G71=\"\",U71=\"\"),\"\",IF(OR(DATEDIF(U71,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U71,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U71,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[34,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G73=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G73=\"\",U73=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U73)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U73)*100+DAY(U73), 1, 0))","v":""},null,{"$f":"IF(OR(G73=\"\",U73=\"\"),\"\",IF(OR(DATEDIF(U73,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U73,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U73,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[35,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G75=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G75=\"\",U75=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U75)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U75)*100+DAY(U75), 1, 0))","v":""},null,{"$f":"IF(OR(G75=\"\",U75=\"\"),\"\",IF(OR(DATEDIF(U75,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U75,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U75,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[36,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G77=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G77=\"\",U77=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U77)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U77)*100+DAY(U77), 1, 0))","v":""},null,{"$f":"IF(OR(G77=\"\",U77=\"\"),\"\",IF(OR(DATEDIF(U77,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U77,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U77,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[37,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G79=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G79=\"\",U79=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U79)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U79)*100+DAY(U79), 1, 0))","v":""},null,{"$f":"IF(OR(G79=\"\",U79=\"\"),\"\",IF(OR(DATEDIF(U79,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U79,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U79,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[38,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G81=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G81=\"\",U81=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U81)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U81)*100+DAY(U81), 1, 0))","v":""},null,{"$f":"IF(OR(G81=\"\",U81=\"\"),\"\",IF(OR(DATEDIF(U81,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U81,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U81,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[39,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G83=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G83=\"\",U83=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U83)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U83)*100+DAY(U83), 1, 0))","v":""},null,{"$f":"IF(OR(G83=\"\",U83=\"\"),\"\",IF(OR(DATEDIF(U83,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U83,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U83,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[]
[40,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G85=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G85=\"\",U85=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U85)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U85)*100+DAY(U85), 1, 0))","v":""},null,{"$f":"IF(OR(G85=\"\",U85=\"\"),\"\",IF(OR(DATEDIF(U85,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U85,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U85,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""},null,null,null,"↓足りない場合はシートの保護の解除をして下に増やしてください"]

{"sheet":"ダブルス","index":2,"n_rows":36,"n_cols":26,"rows_kept":36,"cut":false,"hidden":false,"merged":[[34,16,34,17],[35,16,35,17],[28,16,28,17],[29,16,29,17],[30,16,30,17],[31,16,31,17],[32,16,32,17],[33,16,33,17],[21,16,21,17],[22,16,22,17],[24,16,24,17],[25,16,25,17],[26,16,26,17],[27,16,27,17],[23,16,23,17],[15,16,15,17],[16,16,16,17],[17,16,17,17],[18,16,18,17],[19,16,19,17],[20,16,20,17],[35,18,35,19],[6,16,6,17],[7,16,7,17],[8,16,8,17],[9,16,9,17],[10,16,10,17],[11,16,11,17],[12,16,12,17],[13,16,13,17],[14,16,14,17],[29,18,29,19],[30,18,30,19],[31,18,31,19],[32,18,32,19],[33,18,33,19],[34,18,34,19],[23,18,23,19],[24,18,24,19],[25,18,25,19],[26,18,26,19],[27,18,27,19],[28,18,28,19],[17,18,17,19],[18,18,18,19],[19,18,19,19],[20,18,20,19],[21,18,21,19],[22,18,22,19],[12,18,12,19],[11,18,11,19],[13,18,13,19],[14,18,14,19],[15,18,15,19],[16,18,16,19],[9,11,9,15],[11,11,11,15],[13,11,13,15],[15,11,15,15],[24,11,24,15],[6,18,6,19],[7,18,7,19],[8,18,8,19],[9,18,9,19],[10,18,10,19],[34,0,35,0],[34,1,35,5],[34,6,34,10],[34,11,34,15],[35,11,35,15],[7,6,7,10],[27,6,27,10],[29,6,29,10],[32,6,32,10],[35,6,35,10],[30,11,30,15],[31,6,31,10],[31,11,31,15],[32,1,33,5],[32,0,33,0],[30,1,31,5],[30,6,30,10],[33,6,33,10],[33,11,33,15],[32,11,32,15],[26,6,26,10],[26,11,26,15],[27,11,27,15],[28,0,29,0],[28,1,29,5],[28,6,28,10],[28,11,28,15],[29,11,29,15],[34,22,35,26],[22,0,23,0],[24,0,25,0],[24,1,25,5],[24,6,24,10],[30,0,31,0],[25,6,25,10],[25,11,25,15],[26,0,27,0],[26,1,27,5],[3,12,3,21],[22,1,23,5],[22,6,22,10],[22,11,22,15],[23,6,23,10],[23,11,23,15],[17,11,17,15],[19,11,19,15],[21,11,21,15],[4,21,5,21],[10,0,11,0],[10,1,11,5],[10,6,10,10],[10,11,10,15],[11,6,11,10],[6,0,7,0],[6,1,7,5],[6,6,6,10],[6,11,6,15],[7,11,7,15],[14,0,15,0],[14,1,15,5],[14,6,14,10],[14,11,14,15],[15,6,15,10],[8,0,9,0],[8,1,9,5],[8,6,8,10],[8,11,8,15],[9,6,9,10],[18,0,19,0],[18,1,19,5],[18,6,18,10],[18,11,18,15],[19,6,19,10],[12,0,13,0],[12,1,13,5],[12,6,12,10],[12,11,12,15],[13,6,13,10],[20,0,21,0],[20,1,21,5],[20,6,20,10],[20,11,20,15],[21,6,21,10],[16,0,17,0],[16,1,17,5],[16,6,16,10],[16,11,16,15],[17,6,17,10],[4,20,5,20],[5,16,5,17],[5,18,5,19],[4,0,5,0],[4,1,5,5],[4,6,5,10],[4,11,5,15],[4,16,4,19]]}
["項目の行でカーソルを停止すると説明が表示されます。"]
["このシートに３つのダブルス種目の参加者を全て入力してください。※種目毎にシートを複製しないでください。"]
["各種目かためて強い順に記入ください。組み合わせに反映いたします。"]
[{"$f":"\"ダブルス申込書\"","v":"ダブルス申込書"},null,null,null,null,null,null,null,null,null,null,"チーム名:",{"$f":"集計表!H15","v":0}]
["項目","①種目",null,null,null,null,"②氏名",null,null,null,null,"③所属名",null,null,null,null,"自動入力",null,null,null,"⑥生年月日\n（西暦）","⑦戦績・備考\n※学生がクラブから出る場合は学校名を記載"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"④年齢",null,"⑤学年"]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G7=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,{"$f":"IF(OR(G7=\"\",U7=\"\"),\"\",YEAR(県大会開催日+1)-YEAR(U7)-IF(MONTH(県大会開催日+1)*100+DAY(県大会開催日+1) < MONTH(U7)*100+DAY(U7), 1, 0))","v":""},null,{"$f":"IF(OR(G7=\"\",U7=\"\"),\"\",IF(OR(DATEDIF(U7,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U7,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U7,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G8=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,{"$f":"IF(OR(G8=\"\",U8=\"\"),\"\",IF(OR(DATEDIF(U8,DATE(YEAR(TODAY()),3,31),\"Y\")-5<1,DATEDIF(U8,DATE(YEAR(TODAY()),3,31),\"Y\")-5>12),\"ー\",CHOOSE(DATEDIF(U8,DATE(YEAR(TODAY()),3,31),\"Y\")-5,\"小1\",\"小2\",\"小3\",\"小4\",\"小5\",\"小6\",\"中1\",\"中2\",\"中3\",\"高1\",\"高2\",\"高3\")))","v":""}]
[2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G9=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G10=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,"",null,null,null,null,null,null,"種目"]
[3,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G11=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,"",null,null,null,null,null,null,"⑥男子ダブルス"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G12=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,"",null,null,null,null,null,null,"⑦女子ダブルス"]
[4,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G13=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,"",null,null,null,null,null,null,"③混合ダブルス"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G14=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[5,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G15=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G16=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[6,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G17=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G18=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[7,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G19=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G20=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[8,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G21=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G22=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[9,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G23=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G24=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[10,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G25=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G26=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[11,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G27=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G28=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[12,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G29=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G30=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[13,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G31=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G32=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[14,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G33=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G34=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]
[15,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G35=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,"",null,null,null,"↓足りない場合はシートの保護の解除をして下に増やしてください"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G36=\"\",\"\",集計表!$Q$15)","v":""},null,null,null,null,"",null,""]

{"sheet":"県推薦","index":3,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,0,24,0],[15,1,16,1],[17,1,18,1],[19,1,20,1],[21,1,22,1],[23,1,24,1],[2,5,3,5],[2,1,3,1],[2,0,3,0],[24,7,24,9],[1,0,1,1],[14,0,14,1],[15,0,16,0],[17,0,18,0],[19,0,20,0],[21,0,22,0],[21,7,21,9],[22,7,22,9],[23,7,23,9],[0,0,0,9],[2,2,3,2],[2,3,3,3],[2,6,3,6],[4,7,4,9],[5,7,5,9],[2,4,3,4],[7,7,7,9],[8,7,8,9],[9,7,9,9],[10,7,10,9],[11,7,11,9],[20,7,20,9],[2,7,3,9],[1,3,1,9],[16,7,16,9],[17,7,17,9],[18,7,18,9],[19,7,19,9],[12,7,12,9],[13,7,13,9],[15,7,15,9],[6,7,6,9]]}
["令和７年度 山形県卓球選手権大会  県推薦者記入用紙 "]
["シングルス",null,null,"※大会当日まで県大会の参加料を納入ください"]
[null,"種目","氏名","所属名","年齢","学年","生年月日","備考（推薦条件）"]
[]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
["ダブルス"]
[1]
[]
[2]
[]
[3]
[]
[4]
[]
[5]