{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["表紙","表紙記入例","男子","女子","プロ用"],"not_rendered":{"charts":0,"images":0,"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":60,"n_cols":12,"rows_kept":60,"cut":false,"hidden":false,"merged":[[1,3,1,10],[2,7,2,10],[4,1,4,10],[14,5,14,8],[14,9,14,10],[26,10,26,12],[29,5,29,6],[29,7,29,8],[29,10,29,12],[15,10,15,11],[18,4,18,9],[19,4,19,9],[21,3,21,5],[21,8,21,9],[46,3,46,4],[46,5,46,8],[50,3,50,4],[56,3,56,4],[26,5,26,6],[26,7,26,8]]}
[]
[null,"第","５５","回　北海道中学校スキー大会アルペン競技　　　　《北海道大会参加申込書》",null,null,null,null,null,null,null,"ver.6.01"]
[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,"学校Ｆａｘ"]
[]
[]
[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,"alpenski_jh@yahoo.co.jp"]
[null,null,"なお、送信するメールの『件名』はファイル名と同じにし、『本文』の中に送信者の名前を記入してください。"]
[null,null,"また受信後、受け取ったことの返信を１２月６日までに送信されたアドレスにしますので、返信がない場合は"]
[null,null,"大会事務局まで連絡をください。"]
[]
[null,null,null,"提出期限は１２月６日（火）です。ご協力よろしくお願いします。"]
[]
[]
[null,"手順６","メールで送信したものと同じものをプリントアウトし、校長名を記入（パソコンでも可）し、職印を押印したものを、"]
[null,null,"参加料等と併せて地区中体連に提出し、参加申し込みをしてください。"]
[]
[null,null,null,"提出期限は１２月7日（水）です。ご協力よろしくお願いします。"]
[]
[null,"※不明の点がある場合には大会事務局（小樽市立銭函中学校）まで連絡ください。"]

{"sheet":"表紙記入例","index":1,"n_rows":60,"n_cols":12,"rows_kept":60,"cut":false,"hidden":false,"merged":[[1,3,1,10],[2,7,2,10],[4,1,4,10],[14,5,14,8],[14,9,14,10],[26,10,26,12],[29,5,29,6],[29,7,29,8],[29,10,29,12],[15,10,15,11],[18,4,18,9],[19,4,19,9],[21,3,21,5],[21,8,21,9],[46,3,46,4],[46,5,46,8],[50,3,50,4],[56,3,56,4],[26,5,26,6],[26,7,26,8]]}
[]
[null,"第",{"$f":"表紙!$C$2","v":"５５"},"回　北海道中学校スキー大会アルペン競技　　　　《北海道大会参加申込書》",null,null,null,null,null,null,null,{"$f":"表紙!$L$2","v":"ver.6.01"}]
[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,"手順２","下の□欄に、監督（緊急連絡先）、外部コーチ（いる場合）を入力する"]
[]
[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":"表紙!C46","v":"ファイルを北海道大会事務局（小樽市立銭函中学校）へメールで送付する"}]
[null,null,null,"メールアドレス： ",null,"alpenski_jh@yahoo.co.jp"]
[null,null,"なお、送信するメールの『件名』はファイル名と同じにし、『本文』の中に送信者の名前を記入してください。"]
[null,null,{"$f":"表紙!C49","v":"また受信後、受け取ったことの返信を１２月６日までに送信されたアドレスにしますので、返信がない場合は"}]
[null,null,{"$f":"表紙!C50","v":"大会事務局まで連絡をください。"}]
[]
[null,null,null,{"$f":"表紙!$D$52","v":"提出期限は１２月６日（火）です。ご協力よろしくお願いします。"}]
[]
[]
[null,"手順６","メールで送信したものと同じものをプリントアウトし、校長名を記入（パソコンでも可）し、職印を押印したものを"]
[null,null,"参加料等と併せて地区中体連に提出し、参加申し込みをしてください。"]
[]
[null,null,null,{"$f":"表紙!$D$58","v":"提出期限は１２月7日（水）です。ご協力よろしくお願いします。"}]
[]
[null,{"$f":"表紙!$B$60","v":"※不明の点がある場合には大会事務局（小樽市立銭函中学校）まで連絡ください。"}]

{"sheet":"男子","index":2,"n_rows":46,"n_cols":23,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,8,1,17],[1,18,1,21],[3,1,3,2],[3,5,3,10],[3,11,3,21],[5,0,5,3],[5,4,5,7],[5,9,5,12],[5,13,5,21],[7,1,7,3],[7,5,7,21],[9,1,9,3],[9,4,9,6],[9,10,9,13],[9,14,9,19],[11,1,11,3],[11,4,11,12],[11,14,11,16],[11,17,11,21],[13,1,13,3],[13,4,13,15],[15,12,15,15],[15,16,15,17],[15,18,15,19],[17,22,17,23],[18,1,18,3],[18,12,18,13],[18,14,18,15],[18,16,18,17],[18,18,18,19],[18,20,18,21],[18,22,18,23],[15,20,16,21],[15,22,16,23],[19,1,19,3],[19,12,19,13],[19,14,19,15],[19,16,19,17],[19,18,19,19],[19,20,19,21],[19,22,19,23],[20,1,20,3],[20,12,20,13],[20,14,20,15],[20,16,20,17],[20,18,20,19],[20,20,20,21],[20,22,20,23],[21,1,21,3],[21,12,21,13],[21,14,21,15],[21,16,21,17],[21,18,21,19],[21,20,21,21],[21,22,21,23],[22,1,22,3],[22,12,22,13],[22,14,22,15],[22,16,22,17],[22,18,22,19],[22,20,22,21],[22,22,22,23],[23,14,23,15],[23,16,23,17],[23,18,23,19],[23,20,23,21],[23,22,23,23],[24,1,24,3],[24,12,24,13],[24,14,24,15],[24,16,24,17],[24,18,24,19],[24,20,24,21],[24,22,24,23],[25,20,25,21],[25,22,25,23],[26,1,26,3],[26,12,26,13],[26,14,26,15],[26,16,26,17],[26,18,26,19],[26,20,26,21],[26,22,26,23],[29,20,29,21],[29,22,29,23],[30,16,30,19],[30,20,30,21],[33,0,33,2],[27,1,27,3],[27,12,27,13],[27,14,27,15],[27,16,27,17],[27,18,27,19],[27,20,27,21],[27,22,27,23],[28,12,28,13],[28,14,28,15],[28,16,28,17],[28,18,28,19],[28,20,28,21],[28,22,28,23],[15,0,17,0],[32,3,34,3],[15,4,17,4],[15,5,17,5],[16,18,17,18],[16,19,17,19],[32,4,34,5],[16,12,17,13],[16,14,17,15],[15,1,17,3],[15,6,17,11],[28,0,28,4],[28,6,28,11],[29,0,29,3],[29,6,29,11],[29,16,29,17],[29,18,29,19],[25,1,25,3],[25,12,25,13],[25,14,25,15],[25,16,25,17],[25,18,25,19],[23,1,23,3],[23,12,23,13]]}
["第",{"$f":"表紙!$C$2","v":"５５"},"回　北海道中学校スキー大会アルペン競技"]
[null,null,null,null,null,null,null,null,"学校別参加選手一覧",null,null,null,null,null,null,null,null,null,"【男子】"]
[]
[null,{"$f":"表紙!$D$13","v":0},null,"支庁",{"$f":"表紙!$I$13","v":0},"地区中体連",null,null,null,null,null,{"$f":"IF(ISBLANK(表紙!D15),CONCATENATE(表紙!F15,表紙!I15),CONCATENATE(表紙!D15,表紙!E15,\"　\",表紙!F15,表紙!I15))","v":""}]
[]
["プログラム等標記学校名",null,null,null,{"$f":"表紙!$L$15","v":0},null,null,null,null,"ふりがな",null,null,null,{"$f":"表紙!$K$16","v":0}]
[]
[null,"学校住所",null,null,{"$f":"CONCATENATE(\"〒\",表紙!E18,\"－\",表紙!G18)","v":"〒－"},{"$f":"CONCATENATE(表紙!$D$19,表紙!$E$19)","v":""}]
[]
[null,"学校Ｔｅｌ",null,null,{"$f":"表紙!$D$22","v":0},null,null,null,null,null,"学校Ｆａｘ",null,null,null,{"$f":"表紙!$I$22","v":0}]
[]
[null,"監　　督　：",null,null,{"$f":"CONCATENATE(表紙!$D$27,\"（\",表紙!$D$28,\"）\")","v":"（）"},null,null,null,null,null,null,null,null,null,"緊急連絡先",null,null,{"$f":"表紙!$H$27","v":0}]
[]
[null,"外部コーチ：",null,null,{"$f":"IF(表紙!$K$27=\"\",\"　な　し\",表紙!$K$27)","v":"　な　し"}]
[]
["番号","氏　　名",null,null,"ふりがな","学年","生年月日",null,null,null,null,null,"種目",null,null,null,"参加料",null,"ゼッケン代",null,"タイム計測\n機器使用料",null,"プログラム代"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ＧＳＬ",null,"ＳＬ",null,"1種目",2000,"1種目",2000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2種目",3000,null,null,"1種目",300,"1冊　1000"]
["例","北海　太郎",null,null,"ほっかい　たろう",3,"H",18,".",10,".",2,"○",null,"○",null,{"$f":"IF(COUNTA($M19:$P19)=2,$R$18,IF(COUNTA($M19:$P19)=1,$R$17,\"\"))","v":3000},null,{"$f":"IF(COUNTA($M19:$P19)=2,$T$17*2,IF(COUNTA($M19:$P19)=1,$T$17,\"\"))","v":4000},null,{"$f":"IF(COUNTA($M19:$P19)=2,$V$18*2,IF(COUNTA($M19:$P19)=1,$V$18,\"\"))","v":600},null,1000]
[1,null,null,null,null,null,"H",null,".",null,".",null,null,null,null,null,{"$f":"IF(COUNTA($M20:$P20)=2,$R$18,IF(COUNTA($M20:$P20)=1,$R$17,\"\"))","v":""},null,{"$f":"IF(COUNTA($M20:$P20)=2,$T$17*2,IF(COUNTA($M20:$P20)=1,$T$17,\"\"))","v":""},null,{"$f":"IF(COUNTA($M20:$P20)=2,$V$18*2,IF(COUNTA($M20:$P20)=1,$V$18,\"\"))","v":""}]
[2,null,null,null,null,null,"H",null,".",null,".",null,null,null,null,null,{"$f":"IF(COUNTA($M21:$P21)=2,$R$18,IF(COUNTA($M21:$P21)=1,$R$17,\"\"))","v":""},null,"",null,""]
[3,null,null,null,null,null,"H",null,".",null,".",null,null,null,null,null,"",null,"",null,""]
[4,null,null,null,null,null,"H",null,".",null,".",null,null,null,null,null,"",null,"",null,""]
[5,null,null,null,null,null,"H",null,".",null,".",null,null,null,null,null,"",null,"",null,""]
[6,null,null,null,null,null,"H",null,".",null,".",null,null,null,null,null,"",null,"",null,""]
[7,null,null,null,null,null,"H",null,".",null,".",null,null,null,null,null,"",null,"",null,""]
[8,null,null,null,null,null,"H",null,".",null,".",null,null,null,null,null,"",null,"",null,""]
[9,null,null,null,null,null,"H",null,".",null,".",null,null,null,null,null,"",null,"",null,""]
["10（監督、コーチ等のプログラム購入希望者）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,""]
["合計人数・金額",null,null,null,{"$f":"COUNTA(B20:C29)","v":0},"人",null,null,null,null,null,null,{"$f":"COUNTA(M20:M29)","v":0},"人",{"$f":"COUNTA(O20:O29)","v":0},"人",{"$f":"SUM(Q20:Q29)","v":0},null,{"$f":"SUM(S20:S29)","v":0},null,{"$f":"SUM(U20:U29)","v":0},null,{"$f":"SUM(W20:W29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q30:W30)","v":0},null,null,null,"円"]
["上記の通り、大会参加を承諾します。"]
[null,null,null,"校長"]
[null,null,null,null,null,null,null,"印"]
[]
[]
[]
["※出場種目が多い生徒から順に記入して下さい。"]
["※氏名は「姓」と「名」の間に、必ず全角スペースを１文字入れください。"]
["※ふりがなも「姓」と「名」の間に、必ず全角スペースを１文字入れてください。"]
["※出場する種目の欄に「○」を入力してください。　　ＧＳＬ～ジャイアントスラローム　　ＳＬ～スラローム"]
["※参加種目入力すると、金額は自動で表示されます。"]
["※プログラムを申し込む選手は、購入希望冊数分の代金を押してください。保護者等で申し込む場合は選手のところに合算してください。"]
["※監督やコーチでプログラムを申し込む場合は、番号10のプログラム代に購入希望冊数分の代金を押してください。"]
[]
["◎参加料等については、要項にある通り、事務局まで提出をお願いします。"]

{"sheet":"女子","index":3,"n_rows":46,"n_cols":23,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,8,1,17],[1,18,1,21],[3,1,3,2],[3,5,3,10],[3,11,3,21],[5,0,5,3],[5,4,5,7],[5,9,5,12],[5,13,5,21],[7,1,7,3],[7,5,7,21],[9,1,9,3],[9,4,9,6],[9,10,9,13],[9,14,9,19],[11,1,11,3],[11,4,11,12],[11,14,11,16],[11,17,11,21],[13,1,13,3],[13,4,13,15],[15,12,15,15],[15,16,15,17],[15,18,15,19],[18,1,18,3],[18,12,18,13],[18,14,18,15],[18,16,18,17],[18,18,18,19],[18,20,18,21],[19,1,19,3],[19,12,19,13],[19,14,19,15],[19,16,19,17],[19,18,19,19],[19,20,19,21],[20,1,20,3],[20,12,20,13],[20,14,20,15],[20,16,20,17],[20,18,20,19],[20,20,20,21],[21,1,21,3],[21,12,21,13],[21,14,21,15],[21,16,21,17],[21,18,21,19],[21,20,21,21],[22,1,22,3],[22,12,22,13],[22,14,22,15],[22,16,22,17],[22,18,22,19],[22,20,22,21],[23,1,23,3],[23,12,23,13],[23,14,23,15],[23,16,23,17],[23,18,23,19],[23,20,23,21],[24,1,24,3],[24,12,24,13],[24,14,24,15],[24,16,24,17],[24,18,24,19],[24,20,24,21],[25,1,25,3],[25,12,25,13],[25,14,25,15],[25,16,25,17],[25,18,25,19],[25,20,25,21],[26,1,26,3],[26,12,26,13],[26,14,26,15],[26,16,26,17],[26,18,26,19],[26,20,26,21],[27,14,27,15],[27,16,27,17],[27,18,27,19],[27,20,27,21],[28,12,28,13],[28,14,28,15],[28,16,28,17],[28,18,28,19],[28,20,28,21],[15,22,16,22],[15,20,16,21],[16,12,17,13],[16,14,17,15],[15,1,17,3],[15,6,17,11],[32,4,34,5],[28,0,28,4],[28,6,28,11],[29,0,29,3],[29,6,29,11],[29,16,29,17],[29,18,29,19],[29,20,29,21],[30,16,30,19],[30,20,30,21],[15,0,17,0],[32,3,34,3],[15,4,17,4],[15,5,17,5],[16,18,17,18],[16,19,17,19],[27,1,27,3],[27,12,27,13]]}
["第",{"$f":"表紙!$C$2","v":"５５"},"回　北海道中学校スキー大会アルペン競技"]
[null,null,null,null,null,null,null,null,"学校別参加選手一覧",null,null,null,null,null,null,null,null,null,"【女子】"]
[]
[null,{"$f":"表紙!$D$13","v":0},null,"支庁",{"$f":"表紙!$I$13","v":0},"地区中体連",null,null,null,null,null,{"$f":"IF(ISBLANK(表紙!D15),CONCATENATE(表紙!F15,表紙!I15),CONCATENATE(表紙!D15,表紙!E15,\"　\",表紙!F15,表紙!I15))","v":""}]
[]
["プログラム等標記学校名",null,null,null,{"$f":"表紙!$L$15","v":0},null,null,null,null,"ふりがな",null,null,null,{"$f":"表紙!$K$16","v":0}]
[]
[null,"学校住所",null,null,{"$f":"CONCATENATE(\"〒\",表紙!E18,\"－\",表紙!G18)","v":"〒－"},{"$f":"CONCATENATE(表紙!$D$19,表紙!$E$19)","v":""}]
[]
[null,"学校Ｔｅｌ",null,null,{"$f":"表紙!$D$22","v":0},null,null,null,null,null,"学校Ｆａｘ",null,null,null,{"$f":"表紙!$I$22","v":0}]
[]
[null,"監　　督　：",null,null,{"$f":"IF(表紙!$D$30=\"\",CONCATENATE(表紙!$D$27,\"（\",表紙!$D$28,\"）\"),CONCATENATE(表紙!$D$30,\"（\",表紙!$D$31,\"）\"))","v":"（）"},null,null,null,null,null,null,null,null,null,"緊急連絡先",null,null,{"$f":"IF(表紙!$H$30=\"\",表紙!$H$27,表紙!$H$30)","v":0}]
[]
[null,"外部コーチ：",null,null,{"$f":"IF(表紙!$K$30=\"\",\"　な　し\",表紙!$K$30)","v":"　な　し"}]
[]
["番号","氏　　名",null,null,"ふりがな","学年","生年月日",null,null,null,null,null,"種目",null,null,null,"参加料",null,"ゼッケン代",null,"タイム計測\n機器使用料",null,"プログラム代"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ＧＳＬ",null,"ＳＬ",null,"1種目",2000,"1種目",2000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2種目",3000,null,null,"1種目",300,"1冊　1000"]
["例","北海　花子",null,null,"ほっかい　はなこ",3,"H",18,".",10,".",2,"○",null,"○",null,{"$f":"IF(COUNTA($M19:$P19)=2,$R$18,IF(COUNTA($M19:$P19)=1,$R$17,\"\"))","v":3000},null,{"$f":"IF(COUNTA($M19:$P19)=2,$T$17*2,IF(COUNTA($M19:$P19)=1,$T$17,\"\"))","v":4000},null,{"$f":"IF(COUNTA($M19:$P19)=2,$V$18*2,IF(COUNTA($M19:$P19)=1,$V$18,\"\"))","v":600},null,1000]
[1,null,null,null,null,null,"H",null,".",null,".",null,null,null,null,null,{"$f":"IF(COUNTA($M20:$P20)=2,$R$18,IF(COUNTA($M20:$P20)=1,$R$17,\"\"))","v":""},null,{"$f":"IF(COUNTA($M20:$P20)=2,$T$17*2,IF(COUNTA($M20:$P20)=1,$T$17,\"\"))","v":""},null,{"$f":"IF(COUNTA($M20:$P20)=2,$V$18*2,IF(COUNTA($M20:$P20)=1,$V$18,\"\"))","v":""}]
[2,null,null,null,null,null,"H",null,".",null,".",null,null,null,null,null,"",null,"",null,""]
[3,null,null,null,null,null,"H",null,".",null,".",null,null,null,null,null,"",null,"",null,""]
[4,null,null,null,null,null,"H",null,".",null,".",null,null,null,null,null,"",null,"",null,""]
[5,null,null,null,null,null,"H",null,".",null,".",null,null,null,null,null,"",null,"",null,""]
[6,null,null,null,null,null,"H",null,".",null,".",null,null,null,null,null,"",null,"",null,""]
[7,null,null,null,null,null,"H",null,".",null,".",null,null,null,null,null,"",null,"",null,""]
[8,null,null,null,null,null,"H",null,".",null,".",null,null,null,null,null,"",null,"",null,""]
[9,null,null,null,null,null,"H",null,".",null,".",null,null,null,null,null,"",null,"",null,""]
["10（監督、コーチ等のプログラム購入希望者）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,""]
["合計人数・金額",null,null,null,{"$f":"COUNTA(B20:C29)","v":0},"人",null,null,null,null,null,null,{"$f":"COUNTA(M20:M29)","v":0},"人",{"$f":"COUNTA(O20:O29)","v":0},"人",{"$f":"SUM(Q20:Q29)","v":0},null,{"$f":"SUM(S20:S29)","v":0},null,{"$f":"SUM(U20:U29)","v":0},null,{"$f":"SUM(W20:W29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q30:W30)","v":0},null,null,null,"円"]
["上記の通り、大会参加を承諾します。"]
[null,null,null,"校長"]
[null,null,null,null,null,null,null,"印"]
[]
[]
[]
["※出場種目が多い生徒から順に記入して下さい。"]
["※氏名は「姓」と「名」の間に、必ず全角スペースを１文字入れください。"]
["※ふりがなも「姓」と「名」の間に、必ず全角スペースを１文字入れてください。"]
["※出場する種目の欄に「○」を入力してください。　　ＧＳＬ～ジャイアントスラローム　　ＳＬ～スラローム"]
["※参加種目入力すると、金額は自動で表示されます。"]
["※プログラムを申し込む選手は、購入希望冊数分の代金を押してください。保護者等で申し込む場合は選手のところに合算してください。"]
["※監督やコーチでプログラムを申し込む場合は、番号10のプログラム代に購入希望冊数分の代金を押してください。"]
[]
["◎参加料等については、要項にある通り、事務局まで提出をお願いします。"]

{"sheet":"プロ用","index":4,"n_rows":12,"n_cols":19,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,6,1,7],[1,8,1,9],[1,10,1,11],[9,4,9,5],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,17,2,17],[1,18,2,18],[1,12,2,12],[1,13,2,13],[1,14,2,14],[1,15,2,15],[1,16,2,16]]}
[]
["支庁","中体連","市町村","学校名","監督氏名","外部コーチ氏名","出場選手数",null,"男子",null,"女子",null,"参加選手数","正式学校名","参加費用\n合計","参加料","ゼッケン代","機器使用料","プログラム代"]
[null,null,null,null,null,null,"男子","女子","ＧＳＬ","ＳＬ","ＧＳＬ","ＳＬ"]
[{"$f":"表紙!$D$13","v":0},{"$f":"表紙!$I$13","v":0},{"$f":"表紙!$D$19","v":0},{"$f":"表紙!F15","v":0},{"$f":"IF(ISBLANK(表紙!D30),表紙!D27,CONCATENATE(表紙!D27,\"、\",表紙!D30))","v":0},{"$f":"IF(表紙!$K$27=\"\",IF(表紙!$K$30=\"\",\"\",表紙!$K$30),IF(表紙!$K$30=\"\",表紙!$K$27,IF(表紙!$K$27=表紙!$K$30,表紙!$K$27,CONCATENATE(表紙!$K$27,\"、\",表紙!$K$30))))","v":""},{"$f":"男子!E30","v":0},{"$f":"女子!E30","v":0},{"$f":"男子!M30","v":0},{"$f":"男子!O30","v":0},{"$f":"女子!M30","v":0},{"$f":"女子!O30","v":0},{"$f":"SUM(G4,H4)","v":0},{"$f":"IF(ISBLANK(表紙!D15),表紙!F15,CONCATENATE(表紙!D15,表紙!E15,表紙!F15))","v":0},{"$f":"SUM(男子!Q31,女子!Q31)","v":0},{"$f":"SUM(男子!Q30,女子!Q30)","v":0},{"$f":"SUM(男子!S30,女子!S30)","v":0},{"$f":"SUM(男子!U30,女子!U30)","v":0},{"$f":"SUM(男子!W30,女子!W30)","v":0}]
[]
[]
["※黄色のセルを選択しコピー → ファイル『プロ～監督等一覧.xlsm』の「監督等」のシートに、“形式を選択して貼り付け”→”値” で貼り付ける"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"引率身分"]
[null,null,null,null,"シート表示用パスワード",null,"alpenski_jh",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,"部活動指導員"]