{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["工程①","工程②","申し込み一覧","エントリー","種目・部門コード"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":12,"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":108,"n_cols":11,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
["マイクロソフトのセキュリティが強化された事により"]
["ダウンロードしたファイルをそのまま使用すると"]
["マクロが正常に動作しない可能性があります"]
[]
["ダウンロードしたファイルを使用する前に必ず下記の手順で確認作業を行って下さい"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"①ダウンロードしたファイルの上で右クリック"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"②「プロパティ」をクリック"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"正常ですので「OK」をクリックで終了"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"「許可する」に"]
[null,null,null,null,null,null,"☑を入れて下さい"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"「適用」をクリック"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"「OK」クリックで終了です"]
[]
[]
[]
[]
[]
[null,"上記作業終了後にいつも通りに入力して下さい"]

{"sheet":"工程②","index":1,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"始めに・・・"]
[]
[null,"ダウンロードした入力用のExcelファイルは、事務局提出時には"]
[null,"ファイル名を、団体名に変更してから提出して下さい"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"起動時に セキュリティの警告（マクロの警告） が表示された場合、"]
[null,"クリックし必ず 有効 にしてから入力を開始して下さい"]
[null,"Excelのバージョンにより表示方法が異なる場合があります"]
[]
[]
[null,"『申込み一覧』の参加人数は"]
[null,"参加者リストを入力すると自動で反映されますので、"]
[null,"『申込み一覧』は最後にご入力下さい。"]
[]
[null,"全てのエクセルシートに保護をかけてあります。"]
[null,"保護部分を解除してのご入力は、絶対にしないで下さい。"]
[]
[]
[null,"＜締め切り＞"]
[]
[null,null,"2025年12月10日(水）必着"]
[]
[null,"＜データ送信先＞"]
[]
[null,null,"日本バトン協会九州支部　　batonkyushu.entry21@gmail.com"]

{"sheet":"申し込み一覧","index":2,"n_rows":40,"n_cols":26,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,0,2,2],[2,3,2,7],[7,1,7,2],[7,3,7,16],[9,0,9,2],[9,3,9,8],[12,3,12,16],[4,0,4,2],[4,3,4,7],[15,1,15,2],[15,3,15,7],[15,9,15,10],[15,11,15,15],[0,0,0,27],[1,0,1,27],[15,22,15,28],[26,0,26,3],[15,19,15,21],[4,18,4,20],[4,21,4,23],[6,1,6,2],[6,3,6,16],[24,0,24,3],[24,10,24,11],[25,10,25,11],[13,19,13,21],[19,0,19,3],[11,1,11,2],[11,3,11,5],[11,19,11,21],[28,0,28,3],[32,0,32,3],[39,14,39,17],[29,0,29,3],[31,0,31,3],[20,10,20,11],[20,14,20,17],[24,14,24,17],[25,0,25,3],[39,2,39,9],[27,0,27,3],[30,0,30,3],[25,14,25,17],[28,6,28,7],[12,1,12,2],[20,0,20,3],[19,10,19,11],[19,14,19,17],[39,10,39,11],[29,6,29,7],[30,6,30,7],[31,6,31,7],[32,6,32,7],[26,10,26,11],[27,10,27,11],[19,6,19,7],[20,6,20,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[33,6,33,7],[34,6,34,7],[35,6,35,7],[28,14,28,17],[29,14,29,17],[30,14,30,17],[28,10,28,11],[29,10,29,11],[30,10,30,11],[31,10,31,11],[32,10,32,11],[33,10,33,11],[17,13,17,17],[34,10,34,11],[35,10,35,11],[26,14,26,17],[27,14,27,17],[31,14,31,17],[32,14,32,17],[33,14,33,17],[34,14,34,17],[35,14,35,17],[36,6,36,7],[37,6,37,7],[36,10,36,11],[37,10,37,11],[36,14,36,17],[37,14,37,17],[21,0,21,3],[21,6,21,7],[21,10,21,11],[21,14,21,17],[22,0,22,3],[22,6,22,7],[22,10,22,11],[22,14,22,17]]}
["第５１回全日本バトントワーリング選手権九州大会"]
["＜申し込み一覧表＞"]
["登録支部",null,null,"九州支部"]
[]
["団体登録ＩＤ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false]
[]
[null,"団体名"]
[null,"フリガナ"]
[]
["申込責任者名"]
[]
[null,"〒",null,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":"LEFT(D13,MIN(FIND({0,1,2,3,4,5,6,7,8,9},ASC(D13)&1234567890))-1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"諸費用送金日",null,null,null,"月",null,"日"]
[null,null,null,{"$f":"SUBSTITUTE(D13,D14,\"\")","v":""}]
[null,"TEL",null,null,null,null,null,null,"／","FAX",null,null,null,null,null,null,null,null,null,"送金元口座名義"]
[]
["＜エントリー料＞",null,null,null,null,null,null,null,null,null,null,null,"諸費用合計",{"$f":"O20+O21+O40","v":104000},null,null,null,null,"円"]
[]
["＜入場券＞1日券",null,null,null,null,null,0,null,"円","×",0,null,"枚","　＝",{"$f":"$G20*$K20","v":0},null,null,null,"円"]
["＜入場券＞２日間通し券",null,null,null,null,null,0,null,"円","×",0,null,"枚","　＝",{"$f":"$G21*$K21","v":0},null,null,null,"円"]
["＜当日券＞1日券",null,null,null,null,null,0,null,"円","×",0,null,"枚","　＝",{"$f":"$G22*$K22","v":0},null,null,null,"円"]
["＜当日券＞２日間通し券",null,null,null,null,null,0,null,"円","×",0,null,"枚","　＝",{"$f":"$G23*$K23","v":0},null,null,null,"円"]
[]
["ソロトワール",null,null,null,null,null,6000,null,"円","×",{"$f":"COUNTA(エントリー!H16:H114)","v":9},null,"人","　＝",{"$f":"$G25*$K25","v":54000},null,null,null,"円"]
["トゥーバトン",null,null,null,null,null,6000,null,"円","×",0,null,"人","　＝",0,null,null,null,"円"]
["スリーバトン",null,null,null,null,null,6000,null,"円","×",0,null,"人","　＝",0,null,null,null,"円"]
["ソロストラット",null,null,null,null,null,6000,null,"円","×",0,null,"人","　＝",0,null,null,null,"円"]
["ダンストワール",null,null,null,null,null,6000,null,"円","×",0,null,"人","　＝",0,null,null,null,"円"]
["ペ　ア",null,null,null,null,null,10000,null,"円","×",{"$f":"COUNTA(エントリー!K16:K114)/2","v":3},null,"組","　＝",30000,null,null,null,"円"]
["フリースタイルソロ",null,null,null,null,null,10000,null,"円","×",0,null,"人","　＝",0,null,null,null,"円"]
["フリースタイルペア",null,null,null,null,null,15000,null,"円","×",0,null,"組","　＝",0,null,null,null,"円"]
["フリースタイルチーム",null,null,null,null,null,20000,null,"円","×",{"$f":"COUNTIF(エントリー!U16:U114,1)","v":1},null,"ﾁｰﾑ","　＝",20000,null,null,null,"円",{"$f":"COUNTA(エントリー!U16:U114)","v":9}]
["アーティスティックトワール",null,null,null,null,null,7000,null,"円","×",0,null,"人","　＝",0,null,null,null,"円"]
["アーティスティックペア",null,null,null,null,null,12000,null,"円","×",0,null,"組","　＝",0,null,null,null,"円"]
["アーティスティックチーム",null,null,null,null,null,20000,null,"円","×",0,null,"ﾁｰﾑ","　＝",0,null,null,null,"円",{"$f":"COUNTA(エントリー!#REF!)","v":1}]
["アーティスティックグループ",null,null,null,null,null,30000,null,"円","×",null,null,"ｸﾞﾙｰﾌﾟ","　＝",0,null,null,null,"円"]
[null,null,null,null,null,null,0,null,"円","×",null,null,null,"　＝",null,null,null,null,"円"]
[]
[null,null,"（のべ人数）",null,null,null,null,null,null,null,24,null,"人","合計",{"$f":"SUM($O$25:$R$38)","v":104000},null,null,null,"円"]

{"sheet":"エントリー","index":3,"n_rows":27,"n_cols":26,"rows_kept":27,"cut":false,"hidden":false,"merged":[[13,29,13,30],[13,7,13,9],[13,10,13,12],[13,19,13,20],[13,27,13,28],[13,15,13,17],[13,22,13,23],[13,24,13,25]]}
[]
[null,"良い例","悪い例"]
[null,33323,"00033323"]
[]
[]
[]
["良い例"]
[33323,"丑尾　丑芳","ウシオ　ウシヨシ",null,"男","2002-02-10",17,2,10,"男子シニア",3,14,"シニアⅠ"]
[]
["悪い例","同じ人を複数行入力しない！！"]
[33323,"丑尾　丑芳","ウシオ　ウシヨシ",null,"男","2002-02-10",17,2,10,"男子シニア"]
[33323,"丑尾　丑芳","ウシオ　ウシヨシ",null,"男","2002-02-10",null,null,null,null,3,14,"シニアⅠ"]
[]
[null,null,null,null,null,null,null,"個人種目",null,null,"ペア",null,null,null,null,"デュエット",null,null,null,"Fチーム",null,null,"Aグループ：20",null,"Aグループ：30"]
["会員番号","名前","フリガナ","学校名","性別","生年月日","年齢","通しNo","部門コード","部門名","通しNo","部門コード","部門名",null,"年齢2","通しNo","部門コード","部門名",null,"チーム区分","チーム別通しNo",null,"グループ区分","グループ別通しNo","グループ区分","グループ別通しNo"]
[30537,"子津　子実","ネズ　ネズミ",null,"女","2007-01-15",12,1,4,"女子ジュニアⅠ",4,12,"ジュニアⅠ",null,13]
[33323,"丑尾　丑芳","ウシオ　ウシヨシ",null,"男","2002-02-10",17,2,10,"男子シニア",3,14,"シニアⅠ",null,16,1,38,"シニア",null,"A",8]
[30923,"寅田　寅吉","トラダ　トラキチ",null,"男","1997-03-03",22,3,10,"男子シニア",null,null,null,null,21,null,null,null,null,"A",1]
[30927,"卯佐美ウサコ","ウサミ　ウサコ",null,"女","1998-04-20",21,4,7,"女子シニアⅡ",null,null,null,null,21,2,38,"シニア",null,"A",2]
[30930,"辰吉　巽","タツヨシ　タツミ",null,"男","2000-01-25",19,null,null,null,null,null,null,null,18,null,null,null,null,"A",3]
[30936,"巳吉　美巳","ミヨシ　ミミ",null,"女","2000-05-31",19,5,6,"女子シニアⅠ",null,null,null,null,19,3,38,"シニア",null,"A",4]
[30937,"午藤田一午","ゴトウダ　イチゴ",null,"男","2000-07-16",19,6,10,"男子シニア",null,null,null,null,19,7,37,"ジュニア",null,"A",5]
[30938,"未木　未来","ミキ　ミライ",null,"女","2000-11-22",19,null,null,null,5,6,"シニアⅠ",null,19,4,38,"シニア",null,"A",6]
[33532,"申田　申子","サルタ　シンコ",null,"女","2000-09-15",19,7,6,"女子シニアⅠ",6,6,"シニアⅠ",null,19]
[30928,"酉島　酉子","トリシマ　トリコ",null,"女","2003-08-15",16,null,null,null,2,5,"ジュニアⅡ",null,16,8,37,"ジュニア",null,"A",9]
["申請中","戌井　　狗　　","イヌタ　イヌ",null,"女","2002-06-30",17,8,6,"女子シニアⅠ",1,6,"シニアⅠ",null,17,6,37,"ジュニア"]
["申請中","亥田亥知朗","イダ　イチロウ",null,"男","2001-10-11",18,9,10,"男子シニア",null,null,null,null,18,5,37,"ジュニア",null,"A",7]

{"sheet":"種目・部門コード","index":4,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["種目コード","種目名","部門コード","部門名",null,"種目コード","種目名","部門コード","部門名"]
[6,"ソロトワール",1,"女子U-9",null,23,"フリースタイル個人",31,"女子ジュニア"]
[6,"ソロトワール",2,"女子U-12",null,23,"フリースタイル個人",32,"女子シニア"]
[6,"ソロトワール",3,"女子U-15",null,23,"フリースタイル個人",34,"男子ジュニア"]
[6,"ソロトワール",4,"女子U-18",null,23,"フリースタイル個人",35,"男子シニア"]
[6,"ソロトワール",5,"女子U-22",null,24,"フリースタイルペア",37,"ジュニア"]
[6,"ソロトワール",6,"女子O-23",null,24,"フリースタイルペア",38,"シニア"]
[6,"ソロトワール",7,"男子U-12",null,31,"アーティステックトワール",42,"女子ジュニア"]
[6,"ソロトワール",8,"男子U-15",null,31,"アーティステックトワール",43,"女子シニア"]
[6,"ソロトワール",9,"男子U-18",null,31,"アーティステックトワール",45,"男子ジュニア"]
[6,"ソロトワール",10,"男子O-19",null,31,"アーティステックトワール",46,"男子シニア"]
[7,"トゥーバトン",2,"女子U-12",null,32,"アーティステックペア",37,"ジュニア"]
[7,"トゥーバトン",3,"女子U-15",null,32,"アーティステックペア",38,"シニア"]
[7,"トゥーバトン",4,"女子U-18",null,33,"デュエット",37,"ジュニア"]
[7,"トゥーバトン",5,"女子U-22",null,33,"デュエット",38,"シニア"]
[7,"トゥーバトン",6,"女子O-23",null,34,"ソロ",42,"女子ジュニア"]
[7,"トゥーバトン",7,"男子U-12",null,34,"ソロ",43,"女子シニア"]
[7,"トゥーバトン",8,"男子U-15",null,34,"ソロ",45,"男子ジュニア"]
[7,"トゥーバトン",9,"男子U-18",null,34,"ソロ",46,"男子シニア"]
[7,"トゥーバトン",10,"男子O-19",null,35,"トゥーバトン",42,"女子ジュニア"]
[8,"スリーバトン",2,"女子U-12",null,35,"トゥーバトン",43,"女子シニア"]
[8,"スリーバトン",3,"女子U-15",null,35,"トゥーバトン",45,"男子ジュニア"]
[8,"スリーバトン",4,"女子U-18",null,35,"トゥーバトン",46,"男子シニア"]
[8,"スリーバトン",5,"女子U-22",null,36,"スリーバトン",42,"女子ジュニア"]
[8,"スリーバトン",6,"女子O-23",null,36,"スリーバトン",43,"女子シニア"]
[8,"スリーバトン",7,"男子U-12",null,36,"スリーバトン",45,"男子ジュニア"]
[8,"スリーバトン",8,"男子U-15",null,36,"スリーバトン",46,"男子シニア"]
[8,"スリーバトン",9,"男子U-18"]
[8,"スリーバトン",10,"男子O-19"]
[9,"ペア",11,"U-12"]
[9,"ペア",12,"U-15"]
[9,"ペア",13,"U-18"]
[9,"ペア",14,"U-22"]
[9,"ペア",15,"O-23"]
[10,"ソロストラット",11,"U-12"]
[10,"ソロストラット",12,"U-15"]
[10,"ソロストラット",13,"U-18"]
[10,"ソロストラット",14,"U-22"]
[10,"ソロストラット",15,"O-23"]
[11,"ダンストワール",11,"U-12"]
[11,"ダンストワール",12,"U-15"]
[11,"ダンストワール",13,"U-18"]
[11,"ダンストワール",14,"U-22"]
[11,"ダンストワール",15,"O-23"]