{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["入力の手引き","①乗船者名簿（１・２号艇）","①乗船者名簿（３・４号艇）","①乗船者名簿（５・６号艇）","②指導依頼書"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,1,2,9]]}
["カッター研修に必要な書類の記入について　"]
[]
[0,"このエクセルファイルはマクロ設定がしてあります。ファイルを開くと右図のように"]
[null,"警告が出ますので、コンテンツの有効化をクリックし、マクロを有効にしてください。"]
[]
[null,"※ファイルを開いて右図の警告が表示されない場合"]
[null,"　ファイル → オプション → セキュリティーセンター → セキュリティーセンターの設定"]
[null,"　→ マクロの設定 → 上から2番目の「警告を表示してすべてのマクロを無効にする(D)」を選択"]
[null,"　→ OK"]
[]
[1,"①乗船者名簿（１・２号艇）の研修団体名を入力し，研修希望日時（プルダウン）を選択します。"]
[]
[2,"次に，乗船する研修生の名前を男性の身長の高い順に入力し，一番身長の低い男性に続いて女性の身長の高い順に入力していきます。"]
[null,"（一番最後が一番身長の低い女性になります。）"]
[null,"続いて，性別を選択します。（プルダウンで〇を入力）"]
[null,"①乗船者名簿（１・２号艇）の引率者名を入力し，性別と役割分担を選択（プルダウン）します。"]
[null,"最後に，「陸上で見学する研修生の名前」と「陸上で指導する引率者の名前及び役割分担（プルダウン）」を入力します。"]
[null,"＊人数の小計，合計は自動計算され，引率者名・役割分担と共に②指導依頼書へ反映されます。"]
[]
[3,"必要に応じて，２～６号艇についても研修生の名前から入力していきます。"]
[]
[4,"②指導依頼書の水色部（「記入日」，「総括責任者」，「研修目的」，「研修要望事項」，「希望漕艇コース（半日・１日），（コース）」，"]
[null,"「救助艇に乗船する引率者」，「その他」）を入力，または選択します。"]
[]
[5,"全ての入力が終わったら、黄色のボタンを押して未入力セルの色を消します。"]
[]
[6,"上書きをして終了する。"]
[]
[7,"データ（捺印無でも可）を1週間前までに電子メールかFAXで交流の家に送信。原本は当日捺印されたものをご提出ください。"]

{"sheet":"①乗船者名簿（１・２号艇）","index":1,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[35,9,35,10],[29,9,29,10],[32,1,32,2],[32,3,32,4],[32,7,32,8],[32,9,32,10],[34,0,35,1],[34,2,35,4],[34,5,35,5],[34,6,35,7],[34,8,34,10],[1,0,1,1],[3,0,32,0],[3,6,32,6],[27,1,27,2],[27,7,27,8],[29,3,29,4]]}
[null,"部は必ず入力してください。",null,null,"月","日","曜日","午前・午後・１日"]
["研修団体名",null,null,"研修希望日時",null,null,null,null,"　　　　　　※該当の区分に○を入れてください。"]
["号艇","No.","名前","※男性","※女性",null,"号艇","No.","名前","※男性","※女性"]
[1,1,null,null,null,null,2,1]
[null,2,null,null,null,null,null,2]
[null,3,null,null,null,null,null,3]
[null,4,null,null,null,null,null,4]
[null,5,null,null,null,null,null,5]
[null,6,null,null,null,null,null,6]
[null,7,null,null,null,null,null,7]
[null,8,null,null,null,null,null,8]
[null,9,null,null,null,null,null,9]
[null,10,null,null,null,null,null,10]
[null,11,null,null,null,null,null,11]
[null,12,null,null,null,null,null,12]
[null,13,null,null,null,null,null,13]
[null,14,null,null,null,null,null,14]
[null,15,null,null,null,null,null,15]
[null,16,null,null,null,null,null,16]
[null,17,null,null,null,null,null,17]
[null,18,null,null,null,null,null,18]
[null,19,null,null,null,null,null,19]
[null,20,null,null,null,null,null,20]
[null,21,null,null,null,null,null,21]
[null,22,null,null,null,null,null,22]
[null,23,null,null,null,null,null,23]
[null,24,null,null,null,null,null,24]
[null,"小     計",null,{"$f":"COUNTIF(D4:D27,\"〇\")","v":0},{"$f":"COUNTIF(E4:E27,\"〇\")","v":0},null,null,"小     計",null,{"$f":"COUNTIF(J4:J27,\"〇\")","v":0},{"$f":"COUNTIF(K4:K27,\"〇\")","v":0}]
[null,"引率者名 ",null,null,null,null,null,"引率者名 "]
[null,"役割分担",null,null,null,null,null,"役割分担"]
[null,"引率者名 ",null,null,null,null,null,"引率者名 "]
[null,"役割分担",null,null,{"$f":"COUNTIF(D29:E29,\"〇\")+COUNTIF(D31:E31,\"〇\")","v":0},null,null,"役割分担",null,null,{"$f":"COUNTIF(J29:K29,\"〇\")+COUNTIF(J31:K31,\"〇\")","v":0}]
[null,"合計人数",null,{"$f":"D28+E28+COUNTIF(D29:E29,\"〇\")+COUNTIF(D31:E31,\"〇\")","v":0},null,null,null,"合計人数",null,{"$f":"J28+K28+COUNTIF(J29:K29,\"〇\")+COUNTIF(J31:K31,\"〇\")","v":0}]
[]
["陸上で見学\nする研修生\nの名前",null,null,null,null,null,"陸上で指導\nする引率者\nの名前"]
[null,null,null,null,null,null,null,null,"役割分担（総　指　観　救）"]
["役割分担は該当するものを選択してください。（総：総括責任者　　指：指導担当者　　観：観察担当者　　救：救護担当者）"]

{"sheet":"①乗船者名簿（３・４号艇）","index":2,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[29,9,29,10],[32,1,32,2],[32,3,32,4],[32,7,32,8],[32,9,32,10],[1,0,1,1],[3,0,32,0],[3,6,32,6],[27,1,27,2],[27,7,27,8],[29,3,29,4]]}
[null,"部は必ず入力してください。"]
["研修団体名",null,{"$f":"②指導依頼書!F5","v":0},"研修希望日時",{"$f":"'①乗船者名簿（１・２号艇）'!E2","v":0},{"$f":"'①乗船者名簿（１・２号艇）'!F2","v":0},{"$f":"'①乗船者名簿（１・２号艇）'!G2","v":0},{"$f":"'①乗船者名簿（１・２号艇）'!H2","v":0},"　　　　　　※該当の区分に○を入れてください。"]
["号艇","No.","名前","※男性","※女性",null,"号艇","No.","名前","※男性","※女性"]
[3,1,null,null,null,null,4,1]
[null,2,null,null,null,null,null,2]
[null,3,null,null,null,null,null,3]
[null,4,null,null,null,null,null,4]
[null,5,null,null,null,null,null,5]
[null,6,null,null,null,null,null,6]
[null,7,null,null,null,null,null,7]
[null,8,null,null,null,null,null,8]
[null,9,null,null,null,null,null,9]
[null,10,null,null,null,null,null,10]
[null,11,null,null,null,null,null,11]
[null,12,null,null,null,null,null,12]
[null,13,null,null,null,null,null,13]
[null,14,null,null,null,null,null,14]
[null,15,null,null,null,null,null,15]
[null,16,null,null,null,null,null,16]
[null,17,null,null,null,null,null,17]
[null,18,null,null,null,null,null,18]
[null,19,null,null,null,null,null,19]
[null,20,null,null,null,null,null,20]
[null,21,null,null,null,null,null,21]
[null,22,null,null,null,null,null,22]
[null,23,null,null,null,null,null,23]
[null,24,null,null,null,null,null,24]
[null,"小     計",null,{"$f":"COUNTIF(D4:D27,\"〇\")","v":0},{"$f":"COUNTIF(E4:E27,\"〇\")","v":0},null,null,"小     計",null,{"$f":"COUNTIF(J4:J27,\"〇\")","v":0},{"$f":"COUNTIF(K4:K27,\"〇\")","v":0}]
[null,"引率者名 ",null,null,null,null,null,"引率者名 "]
[null,"役割分担",null,null,null,null,null,"役割分担"]
[null,"引率者名 ",null,null,null,null,null,"引率者名 "]
[null,"役割分担",null,null,{"$f":"COUNTIF(D29:E29,\"〇\")+COUNTIF(D31:E31,\"〇\")","v":0},null,null,"役割分担",null,null,{"$f":"COUNTIF(J29:K29,\"〇\")+COUNTIF(J31:K31,\"〇\")","v":0}]
[null,"合計人数",null,{"$f":"D28+E28+COUNTIF(D29:E29,\"〇\")+COUNTIF(D31:E31,\"〇\")","v":0},null,null,null,"合計人数",null,{"$f":"J28+K28+COUNTIF(J29:K29,\"〇\")+COUNTIF(J31:K31,\"〇\")","v":0}]
["役割分担は該当するものを選択してください。（総：総括責任者　　指：指導担当者　　観：観察担当者）"]

{"sheet":"①乗船者名簿（５・６号艇）","index":3,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[29,9,29,10],[32,1,32,2],[32,3,32,4],[32,7,32,8],[32,9,32,10],[1,0,1,1],[3,0,32,0],[3,6,32,6],[27,1,27,2],[27,7,27,8],[29,3,29,4]]}
[null,"部は必ず入力してください。"]
["研修団体名",null,{"$f":"②指導依頼書!F5","v":0},"研修希望日時",{"$f":"'①乗船者名簿（１・２号艇）'!E2","v":0},{"$f":"'①乗船者名簿（１・２号艇）'!F2","v":0},{"$f":"'①乗船者名簿（１・２号艇）'!G2","v":0},{"$f":"'①乗船者名簿（１・２号艇）'!H2","v":0},"　　　　　　※該当の区分に○を入れてください。"]
["号艇","No.","名前","※男性","※女性",null,"号艇","No.","名前","※男性","※女性"]
[5,1,null,null,null,null,6,1]
[null,2,null,null,null,null,null,2]
[null,3,null,null,null,null,null,3]
[null,4,null,null,null,null,null,4]
[null,5,null,null,null,null,null,5]
[null,6,null,null,null,null,null,6]
[null,7,null,null,null,null,null,7]
[null,8,null,null,null,null,null,8]
[null,9,null,null,null,null,null,9]
[null,10,null,null,null,null,null,10]
[null,11,null,null,null,null,null,11]
[null,12,null,null,null,null,null,12]
[null,13,null,null,null,null,null,13]
[null,14,null,null,null,null,null,14]
[null,15,null,null,null,null,null,15]
[null,16,null,null,null,null,null,16]
[null,17,null,null,null,null,null,17]
[null,18,null,null,null,null,null,18]
[null,19,null,null,null,null,null,19]
[null,20,null,null,null,null,null,20]
[null,21,null,null,null,null,null,21]
[null,22,null,null,null,null,null,22]
[null,23,null,null,null,null,null,23]
[null,24,null,null,null,null,null,24]
[null,"小     計",null,{"$f":"COUNTIF(D4:D27,\"〇\")","v":0},{"$f":"COUNTIF(E4:E27,\"〇\")","v":0},null,null,"小     計",null,{"$f":"COUNTIF(J4:J27,\"〇\")","v":0},{"$f":"COUNTIF(K4:K27,\"〇\")","v":0}]
[null,"引率者名 ",null,null,null,null,null,"引率者名 "]
[null,"役割分担",null,null,null,null,null,"役割分担"]
[null,"引率者名 ",null,null,null,null,null,"引率者名 "]
[null,"役割分担",null,null,{"$f":"COUNTIF(D29:E29,\"〇\")+COUNTIF(D31:E31,\"〇\")","v":0},null,null,"役割分担",null,null,{"$f":"COUNTIF(J29:K29,\"〇\")+COUNTIF(J31:K31,\"〇\")","v":0}]
[null,"合計人数",null,{"$f":"D28+E28+COUNTIF(D29:E29,\"〇\")+COUNTIF(D31:E31,\"〇\")","v":0},null,null,null,"合計人数",null,{"$f":"J28+K28+COUNTIF(J29:K29,\"〇\")+COUNTIF(J31:K31,\"〇\")","v":0}]
["役割分担は該当するものを選択してください。（総：総括責任者　　指：指導担当者　　観：観察担当者）"]

{"sheet":"②指導依頼書","index":4,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[25,3,26,3],[27,3,28,3],[33,2,34,2],[37,2,37,3],[37,5,37,6],[29,3,30,3],[36,2,36,3],[23,0,24,0],[27,0,28,0],[21,0,22,0],[23,2,24,2],[21,1,22,1],[23,1,24,1],[25,1,26,1],[27,1,28,1],[25,0,26,0],[27,2,28,2],[25,2,26,2],[14,0,14,10],[19,0,20,0],[19,7,20,7],[19,8,20,8],[15,8,15,10],[16,8,16,10],[17,8,17,10],[18,8,18,10],[19,9,20,10],[16,4,16,7],[16,0,16,2],[19,1,19,3],[19,4,19,6],[20,4,20,6],[31,9,32,10],[31,2,32,2],[31,7,32,7],[31,8,32,8],[31,3,32,3],[27,9,28,10],[25,9,26,10],[1,0,1,10],[3,0,3,10],[4,3,4,4],[5,3,5,4],[5,5,5,7],[21,9,22,10],[23,9,24,10],[21,2,22,2],[21,7,22,7],[21,8,22,8],[23,8,24,8],[23,7,24,7],[21,3,22,3],[23,3,24,3],[25,7,26,7],[27,7,28,7],[29,7,30,7],[25,8,26,8],[27,8,28,8],[29,8,30,8],[52,0,52,1],[33,7,34,7],[33,8,34,8],[50,4,50,5],[39,5,39,6],[39,2,39,3],[46,6,46,10],[46,0,46,5],[47,4,47,10],[33,9,34,10],[48,0,48,10],[35,0,35,10],[36,0,39,0],[33,0,34,0],[36,7,37,10],[38,7,39,10],[0,8,0,10],[0,6,0,7],[9,0,9,10],[12,0,12,10],[38,2,38,3],[36,5,36,6],[38,5,38,6],[33,1,34,1],[33,3,34,3],[33,4,34,6],[29,1,30,1],[31,0,32,0],[31,1,32,1],[29,0,30,0],[29,2,30,2],[29,9,30,10]]}
[null,null,null,null,null,null,"記入日（年/月/日）"]
["   カッター研修指導依頼書"]
[]
["国立江田島青少年交流の家所長　様"]
["                              　　　",null,null,"研修団体名",null,{"$f":"'①乗船者名簿（１・２号艇）'!C2","v":0}]
[null,null,null,"総括責任者",null,null,null,null,"印"]
[null,null,"月","日","曜日","午前・午後・１日"]
["１.  研修希望日時　　　　　",null,{"$f":"'①乗船者名簿（１・２号艇）'!E2","v":0},{"$f":"'①乗船者名簿（１・２号艇）'!F2","v":0},{"$f":"'①乗船者名簿（１・２号艇）'!G2","v":0},{"$f":"'①乗船者名簿（１・２号艇）'!H2","v":0}]
["２.  研修目的（以下に記入）　　　"]
[]
["３．研修要望事項（規律・体験重視のどちらかを選択し、要望を以下に記入）　"]
[null,"規律を重視した指導　",null,null,"体験を重視した指導　"]
[]
["４．希望漕艇コース及び研修参加者数"]
["希望漕艇コース（選択してください）"]
["【半日・１日】",null,null,null,"【コース】"]
[]
["※旧コースの三高沖（７Km）・安渡島（８Km）については，打合せ時に相談"]
[]
["使用艇","カッターに乗船する研修生の人数",null,null,"カッターに乗船する引率者名及び\n役割分担",null,null,"小 計","各艇合計","指導員"]
[null,"男性","女性","小計","※役割分担を選択してください"]
["１号艇",{"$f":"'①乗船者名簿（１・２号艇）'!D28","v":0},{"$f":"'①乗船者名簿（１・２号艇）'!E28","v":0},{"$f":"SUM(B22:C23)","v":0},"名前",{"$f":"'①乗船者名簿（１・２号艇）'!C29","v":0},{"$f":"'①乗船者名簿（１・２号艇）'!C31","v":0},{"$f":"'①乗船者名簿（１・２号艇）'!E32","v":0},{"$f":"D22+H22","v":0}]
[null,null,null,null,"役割分担",{"$f":"'①乗船者名簿（１・２号艇）'!C30","v":0},{"$f":"'①乗船者名簿（１・２号艇）'!C32","v":0}]
["２号艇",{"$f":"'①乗船者名簿（１・２号艇）'!J28","v":0},{"$f":"'①乗船者名簿（１・２号艇）'!K28","v":0},{"$f":"SUM(B24:C25)","v":0},"名前",{"$f":"'①乗船者名簿（１・２号艇）'!I29","v":0},{"$f":"'①乗船者名簿（１・２号艇）'!I31","v":0},{"$f":"'①乗船者名簿（１・２号艇）'!K32","v":0},{"$f":"D24+H24","v":0}]
[null,null,null,null,"役割分担",{"$f":"'①乗船者名簿（１・２号艇）'!I30","v":0},{"$f":"'①乗船者名簿（１・２号艇）'!I32","v":0}]
["３号艇",{"$f":"'①乗船者名簿（３・４号艇）'!D28","v":0},{"$f":"'①乗船者名簿（３・４号艇）'!E28","v":0},{"$f":"SUM(B26:C27)","v":0},"名前",{"$f":"'①乗船者名簿（３・４号艇）'!C29","v":0},{"$f":"'①乗船者名簿（３・４号艇）'!C31","v":0},{"$f":"'①乗船者名簿（３・４号艇）'!E32","v":0},{"$f":"D26+H26","v":0}]
[null,null,null,null,"役割分担",{"$f":"'①乗船者名簿（３・４号艇）'!C30","v":0},{"$f":"'①乗船者名簿（３・４号艇）'!C32","v":0}]
["４号艇",{"$f":"'①乗船者名簿（３・４号艇）'!J28","v":0},{"$f":"'①乗船者名簿（３・４号艇）'!K28","v":0},{"$f":"SUM(B28:C29)","v":0},"名前",{"$f":"'①乗船者名簿（３・４号艇）'!I29","v":0},{"$f":"'①乗船者名簿（３・４号艇）'!I31","v":0},{"$f":"'①乗船者名簿（３・４号艇）'!K32","v":0},{"$f":"D28+H28","v":0}]
[null,null,null,null,"役割分担",{"$f":"'①乗船者名簿（３・４号艇）'!I30","v":0},{"$f":"'①乗船者名簿（３・４号艇）'!I32","v":0}]
["５号艇",{"$f":"'①乗船者名簿（５・６号艇）'!D28","v":0},{"$f":"'①乗船者名簿（５・６号艇）'!E28","v":0},{"$f":"SUM(B30:C31)","v":0},"名前",{"$f":"'①乗船者名簿（５・６号艇）'!C29","v":0},{"$f":"'①乗船者名簿（５・６号艇）'!C31","v":0},{"$f":"'①乗船者名簿（５・６号艇）'!E32","v":0},{"$f":"D30+H30","v":0}]
[null,null,null,null,"役割分担",{"$f":"'①乗船者名簿（５・６号艇）'!C30","v":0},{"$f":"'①乗船者名簿（５・６号艇）'!C32","v":0}]
["６号艇",{"$f":"'①乗船者名簿（５・６号艇）'!J28","v":0},{"$f":"'①乗船者名簿（５・６号艇）'!K28","v":0},{"$f":"SUM(B32:C33)","v":0},"名前",{"$f":"'①乗船者名簿（５・６号艇）'!I29","v":0},{"$f":"'①乗船者名簿（５・６号艇）'!I31","v":0},{"$f":"'①乗船者名簿（５・６号艇）'!K32","v":0},{"$f":"D32+H32","v":0}]
[null,null,null,null,"役割分担",{"$f":"'①乗船者名簿（５・６号艇）'!I30","v":0},{"$f":"'①乗船者名簿（５・６号艇）'!I32","v":0}]
["合計",{"$f":"SUM(B22:B33)","v":0},{"$f":"SUM(C22:C33)","v":0},{"$f":"SUM(D22:E33)","v":0},null,null,null,{"$f":"SUM(H22:H33)","v":0},0]
[]
[]
["救助艇に乗船する\n引率者","名前",null,null,"名前",null,null,"カメラマン"]
[null,"役割分担",null,null,"役割分担"]
[null,"名前",null,null,"名前",null,null,"救助艇操船者・操船補助者"]
[null,"役割分担",null,null,"役割分担"]
[]
["※役割分担　総括責任者　指導担当者　観察担当者　救護担当者　※救助艇に乗艇する引率者は，全員，救護担当者となります。"]
["※艇ごとに乗艇する引率者は，全員，観察担当者となります。　※総括責任者と指導担当者を１名ずつ配置してください。役割は兼ねることができます。"]
[null,"部は必ず入力してください。"]
["５．その他"]
["①陸上で見学する研修生        　（男性",null,null,null," ，  女性",null,"②陸上で指導する引率者"]
[{"$f":"'①乗船者名簿（１・２号艇）'!C35","v":0},null,null,null,null,null,{"$f":"'①乗船者名簿（１・２号艇）'!I35","v":0}]
["③乗船者で配慮を要する研修生の有無",null,null,null,"←「有」の場合，詳細は「カッター研修」打合せ時に職員が聞き取りいたします。"]
["以下は記入の必要はありません"]
["上記活動を　実施　することを許可（ する　　しない ）※どちらかに○をつける",null,null,null,null,null,null,"（人数確認チェック欄）"]
["所長","次長","主任企画指導専門職","事業推進係長","企画指導専門職",null,null,"乗艇時の\n人数変更","艇庫前での\n人数確認","指導担当者からの人数聴取"]
[null,null,null,null,"指導担当","事前打合せ"]