{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["登録更新個人票（1号様式）","登録者一覧（2号様式）"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"登録更新個人票（1号様式）","index":0,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[[19,1,19,3],[26,2,26,3],[25,10,25,14],[22,1,22,14],[21,0,21,14],[23,2,23,3],[23,10,23,14],[25,2,25,3],[14,3,14,14],[15,1,15,14],[17,6,17,14],[24,4,24,9],[25,4,25,9],[16,1,16,14],[17,1,17,4],[18,1,18,14],[23,0,24,1],[25,0,26,1],[24,2,24,3],[23,4,23,9],[26,4,26,9],[26,10,26,14],[19,5,19,7],[24,10,24,14],[7,0,7,6],[12,7,12,14],[13,9,13,14],[11,1,11,6],[11,7,11,14],[8,0,8,14],[9,11,9,14],[10,11,10,14],[12,1,12,6],[9,8,9,10],[10,8,10,10],[9,1,9,7],[10,1,10,7]]}
["※ 必ず、マクロを有効にして入力して下さい。"]
["※ 認定番号は、更新者のみ記入して下さい。"]
["※ 境界線が2重線のセルは、リスト入力です。"]
["※ 背景色がグレーのセルは、他の必要事項が入力されれば自動的に表示されます。"]
[]
["様式第1号 　※各山岳連盟で取りまとめる場合は、この登録/更新届に加え、第2号様式（登録者一覧）を添えてください。"]
[null,null,null,null,null,null,null,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,null,{"$f":"IF(AND(F14=\"J\",RIGHT(B12,4)=\"セッター\"),\"入力エラー\",IF(AND(F14=\"S\",RIGHT(B12,4)<>\"セッター\"),\"入力エラー\",IF(AND(LEFT(B12,2)=\"公認\",B13<>\"O\"),\"入力エラー\",\"\")))","v":""}]
["等　　　　級",null,null,null,null,null,null,{"$f":"IF(F14=\"J\",IF(B13=\"O\",\"入力エラー\",\"\"),\"\")","v":""}]
["認定番号\n（更新の\n場合のみ）",null,null,"-Ｃ-","","","－",null,"－"]
["〒",null,"－"]
["住　所"]
["電話番号"]
["Ｅ-Mail",null,null,null,null,"＠"]
["所属山岳\n連盟（協会）"]
["登録/更新料",null,null,null,null,"郵便振替入金日",null,null,"平成",null,"年",null,"月","　","日"]
[]
["認定番号説明：０９-Ｃ-BS-１３-○○○\n０９：西暦2桁 - Ｃ：クライミング競技 　-  資格種類と等級　- １３：都道府県番号 - ○○○：都道府県毎の年毎通し番号"]
["等級略号","O:セッターで公認のみの場合、　それ以外は審判（S、A、B、C）、競技ルートセッター（A、B、C）"]
["更新の場合は、過去３年間の実績を右に記入",null,"年　度",null,"実績内容",null,null,null,null,null,"備　　　考"]
[null,null,"平成２４年\n（２０１２）"]
["国体：NA\nﾌﾞﾛｯｸ大会：BN\n都道府県大会等：PA\n公認大会：EA",null,"平成２５年\n（２０１３）"]
[null,null,"平成２６年\n（２０１４）"]

{"sheet":"登録者一覧（2号様式）","index":1,"n_rows":117,"n_cols":72,"rows_kept":117,"cut":false,"hidden":false,"merged":[[88,18,88,21],[89,18,89,21],[90,18,90,21],[91,18,91,21],[92,18,92,21],[93,18,93,21],[94,18,94,21],[95,18,95,21],[96,18,96,21],[79,18,79,21],[80,18,80,21],[81,18,81,21],[82,18,82,21],[83,18,83,21],[84,18,84,21],[85,18,85,21],[86,18,86,21],[87,18,87,21],[70,18,70,21],[71,18,71,21],[72,18,72,21],[73,18,73,21],[74,18,74,21],[75,18,75,21],[76,18,76,21],[77,18,77,21],[78,18,78,21],[61,18,61,21],[62,18,62,21],[63,18,63,21],[64,18,64,21],[65,18,65,21],[66,18,66,21],[67,18,67,21],[68,18,68,21],[69,18,69,21],[52,18,52,21],[53,18,53,21],[54,18,54,21],[55,18,55,21],[56,18,56,21],[57,18,57,21],[58,18,58,21],[59,18,59,21],[60,18,60,21],[43,18,43,21],[44,18,44,21],[45,18,45,21],[46,18,46,21],[47,18,47,21],[48,18,48,21],[49,18,49,21],[50,18,50,21],[51,18,51,21],[34,18,34,21],[35,18,35,21],[36,18,36,21],[37,18,37,21],[38,18,38,21],[39,18,39,21],[40,18,40,21],[41,18,41,21],[42,18,42,21],[16,18,16,21],[17,18,17,21],[18,18,18,21],[19,18,19,21],[29,18,29,21],[30,18,30,21],[31,18,31,21],[32,18,32,21],[33,18,33,21],[20,18,20,21],[21,18,21,21],[22,18,22,21],[23,18,23,21],[24,18,24,21],[25,18,25,21],[26,18,26,21],[27,18,27,21],[28,18,28,21],[6,1,6,21],[7,17,7,21],[7,3,7,4],[8,17,8,21],[8,11,8,13],[13,2,15,2],[13,3,15,13],[11,13,11,14],[11,3,11,9],[13,18,15,21],[7,1,7,2],[11,1,11,2],[13,1,15,1],[13,14,13,17],[14,14,14,15],[14,16,14,17],[97,18,97,21],[98,18,98,21],[99,18,99,21],[100,18,100,21],[101,18,101,21],[102,18,102,21],[103,18,103,21],[104,18,104,21],[105,18,105,21],[106,18,106,21],[107,18,107,21],[108,18,108,21],[109,18,109,21],[110,18,110,21],[111,18,111,21],[112,18,112,21],[113,18,113,21],[114,18,114,21],[115,18,115,21],[116,18,116,21],[11,18,11,21],[16,12,16,13],[11,10,11,12],[17,12,17,13],[18,12,18,13],[19,12,19,13],[20,12,20,13],[21,12,21,13],[22,12,22,13],[23,12,23,13],[24,12,24,13],[25,12,25,13],[26,12,26,13],[27,12,27,13],[28,12,28,13],[29,12,29,13],[30,12,30,13],[31,12,31,13],[32,12,32,13],[33,12,33,13],[34,12,34,13],[35,12,35,13],[36,12,36,13],[37,12,37,13],[38,12,38,13],[39,12,39,13],[40,12,40,13],[41,12,41,13],[42,12,42,13],[43,12,43,13],[44,12,44,13],[45,12,45,13],[46,12,46,13],[47,12,47,13],[48,12,48,13],[49,12,49,13],[50,12,50,13],[51,12,51,13],[52,12,52,13],[53,12,53,13],[54,12,54,13],[55,12,55,13],[56,12,56,13],[57,12,57,13],[58,12,58,13],[59,12,59,13],[60,12,60,13],[61,12,61,13],[62,12,62,13],[63,12,63,13],[64,12,64,13],[65,12,65,13],[66,12,66,13],[67,12,67,13],[68,12,68,13],[69,12,69,13],[70,12,70,13],[71,12,71,13],[72,12,72,13],[73,12,73,13],[74,12,74,13],[75,12,75,13],[76,12,76,13],[77,12,77,13],[78,12,78,13],[79,12,79,13],[80,12,80,13],[81,12,81,13],[82,12,82,13],[83,12,83,13],[84,12,84,13],[85,12,85,13],[86,12,86,13],[87,12,87,13],[88,12,88,13],[89,12,89,13],[90,12,90,13],[91,12,91,13],[92,12,92,13],[93,12,93,13],[94,12,94,13],[95,12,95,13],[96,12,96,13],[97,12,97,13],[98,12,98,13],[99,12,99,13],[100,12,100,13],[101,12,101,13],[102,12,102,13],[103,12,103,13],[104,12,104,13],[105,12,105,13],[106,12,106,13],[107,12,107,13],[108,12,108,13],[109,12,109,13],[110,12,110,13],[111,12,111,13],[112,12,112,13],[113,12,113,13],[114,12,114,13],[115,12,115,13],[116,12,116,13]]}
["※ 境界線が2重線のセルは、リスト入力です。"]
["※ 背景色がグレーのセルは、他の必要事項が入力されれば自動的に表示されます。このセルには数式が入っていますので、削除しないで下さい。"]
[]
[null,"様式第2号",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"　","月","　","日"]
[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":"Z6&\"山岳連盟\"","v":"北海道山岳連盟"},{"$f":"AA6&\"山岳連盟\"","v":"青森県山岳連盟"},{"$f":"AB6&\"山岳協会\"","v":"岩手県山岳協会"},"宮城県山岳連盟","秋田県山岳連盟","山形県山岳連盟","福島県山岳連盟","茨城県山岳連盟","栃木県山岳連盟","群馬県山岳連盟","埼玉県山岳連盟","千葉県山岳連盟","東京都山岳連盟","神奈川県山岳連盟","山梨県山岳連盟",{"$f":"AO6&\"山岳協会\"","v":"新潟県山岳協会"},{"$f":"AP6&\"山岳協会\"","v":"長野県山岳協会"},"富山県山岳連盟",{"$f":"AR6&\"山岳協会\"","v":"石川県山岳協会"},"福井県山岳連盟","静岡県山岳連盟","愛知県山岳連盟","三重県山岳連盟","岐阜県山岳連盟","滋賀県山岳連盟","京都府山岳連盟","大阪府山岳連盟","兵庫県山岳連盟","奈良県山岳連盟","和歌山県山岳連盟",{"$f":"BD6&\"山岳協会\"","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47"]
[null,"都道府県番号№　　　",null,{"$f":"IF(LEN(R6)>0,HLOOKUP(R6,Z6:BT7,2,0),\"00\")","v":"00"},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,"電話番号または\nメールアドレス"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"郵便振替入金日",27,null,"月",null,"日"]
[]
[null,"登録/更新料",null,"審判員　3,000円×",null,null,null,null,null,null,{"$f":"COUNTIF(I18:I117,\"J\")","v":0},null,null,"ルートセッター　5,000円×",null,{"$f":"COUNTIF(I18:I117,\"S\")","v":0},"合計",{"$f":"P12*5000+K12*3000","v":0},{"$f":"IF(SUM(K12,P12)<>COUNTA(O18:O117),\"入力エラー\",\"\")","v":""}]
[]
[null,"新規登録/\n更新の別","審判員/\nセッターの別","認定番号",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,"更新","審判員","09","-","C","-","B","J","-","13","-","○○○",null,"山岳","太郎","サンガク","タロウ"]
[1,null,null,null,"-","C","-",null,{"$f":"IF(C18=\"審判\",\"J\",IF(C18=\"セッター\",\"S\",\"\"))","v":""},"-",{"$f":"IF(LEN(B18)>1,$D$8,\"\")","v":""},"-"]
[2,null,null,null,"-","Ｃ","-",null,{"$f":"IF(C19=\"審判\",\"J\",IF(C19=\"セッター\",\"S\",\"\"))","v":""},"-",{"$f":"IF(LEN(B19)>1,$D$8,\"\")","v":""},"-"]
[3,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[4,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[5,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[6,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[7,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[8,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[9,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[10,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[11,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[12,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[13,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[14,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[15,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[16,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[17,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[18,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[19,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[20,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[21,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[22,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[23,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[24,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[25,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[26,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[27,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[28,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[29,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[30,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[31,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[32,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[33,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[34,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[35,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[36,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[37,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[38,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[39,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[40,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[41,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[42,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[43,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[44,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[45,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[46,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[47,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[48,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[49,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[50,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[51,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[52,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[53,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[54,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[55,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[56,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[57,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[58,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[59,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[60,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[61,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[62,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[63,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[64,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[65,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[66,null,null,null,"-","Ｃ","-",null,{"$f":"IF(C83=\"審判\",\"J\",IF(C83=\"セッター\",\"S\",\"\"))","v":""},"-",{"$f":"IF(LEN(B83)>1,$D$8,\"\")","v":""},"-"]
[67,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[68,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[69,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[70,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[71,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[72,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[73,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[74,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[75,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[76,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[77,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[78,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[79,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[80,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[81,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[82,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[83,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[84,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[85,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[86,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[87,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[88,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[89,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[90,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[91,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[92,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[93,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[94,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[95,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[96,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[97,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[98,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[99,null,null,null,"-","Ｃ","-",null,"","-","","-"]
[100,null,null,null,"-","Ｃ","-",null,"","-","","-"]