{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["読んでね","全県個人戦","全県個人地区順","全県順位順","全県ベンチ入り指導者","新潟","下越","中越","上越","佐渡","校名抽出"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"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":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["個人戦作業手順"]
[]
[1,"大会名…年度と「男子」または「女子」を入力する。"]
[null,"年度→",27,"男女→","男子","自動→",{"$f":"\"平成\"&DBCS(C4)&\"年度\"&E4&\"県総体\"","v":"平成２７年度男子県総体"}]
[]
[2,"各校から送られてきた個人戦のデータ（選手及びベンチ入り指導者）を、地区名シート（新潟～佐渡）のグレーのセルに到着順に値複写します。"]
[]
[]
[]
[]
[null,"※全県団体戦シートは各地区シートのデータをコピーしていますので氏名やポイントなどの修正は各地区シートで行って下さい。"]
[]
["3-1","地区ごとの個人申込データを全県データにまとめます。下記の「全県個人」ボタンをクリックして下さい。"]
[]
[]
[]
["3-2","地区順位ごとの全県個人一覧表を作成します。下記の「全県地区順位順」ボタンをクリックして下さい。"]
[]
[]
[]
["3-3","県順位ごとの全県個人一覧表を作成します。下記の「全県順位順」ボタンをクリックして下さい。"]
[]
[]
[]
[]
[4,"地区ごとのベンチ入り指導者データを全県データにします。下記の「ベンチ入り指導者」ボタンをクリックして下さい。"]

{"sheet":"全県個人戦","index":1,"n_rows":4,"n_cols":18,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,15,3,15],[2,9,2,10],[2,11,2,12],[2,13,2,14],[1,9,1,14]]}
[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,"選手A","選手B","選手A","選手B","選手A","選手B",null,"順","順"]

{"sheet":"全県個人地区順","index":2,"n_rows":20,"n_cols":18,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,9,1,14],[1,15,3,15],[2,9,2,10],[2,11,2,12],[2,13,2,14]]}
[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,"選手A","選手B","選手A","選手B","選手A","選手B",null,null,"順"]
[null,1,"新潟","燕中等","男子",1,"廣川　陸","・","竹内　裕哉",null,null,null,null,"有(16)","有(16)",0,1,14]
[null,2,"新潟","燕中等","男子",2,"藤﨑　岳史","・","五十嵐　匠",null,null,null,null,"有(16)","有(16)",0,1,14]
[null,3,"新潟","燕中等","男子",3,"豊田　善和","・","市川　雄",null,null,null,null,null,null,0,3,16]
[null,4,"下越","新発田","男子",1,"西澤　諒","・","鈴木　健人",15,15,20,20,null,null,70,1,1]
[null,5,"下越","新発田","男子",2,"斎藤　謙史朗","・","島峯　直也",null,null,10,10,null,null,20,2,5]
[null,6,"下越","新発田","男子",3,"椎谷　賢","・","椎谷　大",null,null,5,5,null,null,10,3,9]
[null,7,"下越","新発田","男子",4,"佐藤　隼人","・","工藤　航平",null,null,3,3,null,null,6,4,13]
[null,8,"中越","三条","男子",1,"西澤　諒","・","鈴木　健人",15,15,20,20,null,null,70,1,1]
[null,9,"中越","長岡","男子",2,"斎藤　謙史朗","・","島峯　直也",null,null,10,10,null,null,20,2,5]
[null,10,"中越","小千谷","男子",3,"椎谷　賢","・","椎谷　大",null,null,5,5,null,null,10,3,9]
[null,11,"上越","高田","男子",1,"西澤　諒","・","鈴木　健人",15,15,20,20,null,null,70,1,1]
[null,12,"上越","高田","男子",2,"斎藤　謙史朗","・","島峯　直也",null,null,10,10,null,null,20,2,5]
[null,13,"上越","直江津","男子",3,"椎谷　賢","・","椎谷　大",null,null,5,5,null,null,10,3,9]
[null,14,"佐渡","羽茂","男子",1,"西澤　諒","・","鈴木　健人",15,15,20,20,null,null,70,1,1]
[null,15,"佐渡","両津","男子",2,"斎藤　謙史朗","・","島峯　直也",null,null,10,10,null,null,20,2,5]
[null,16,"佐渡","佐渡","男子",3,"椎谷　賢","・","椎谷　大",null,null,5,5,null,null,10,3,9]

{"sheet":"全県順位順","index":3,"n_rows":20,"n_cols":18,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,9,1,14],[1,15,3,15],[2,9,2,10],[2,11,2,12],[2,13,2,14]]}
[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,"選手A","選手B","選手A","選手B","選手A","選手B",null,null,"順"]
[null,1,"下越","新発田","男子",1,"西澤　諒","・","鈴木　健人",15,15,20,20,null,null,70,1,1]
[null,2,"中越","三条","男子",1,"西澤　諒","・","鈴木　健人",15,15,20,20,null,null,70,1,1]
[null,3,"上越","高田","男子",1,"西澤　諒","・","鈴木　健人",15,15,20,20,null,null,70,1,1]
[null,4,"佐渡","羽茂","男子",1,"西澤　諒","・","鈴木　健人",15,15,20,20,null,null,70,1,1]
[null,5,"下越","新発田","男子",2,"斎藤　謙史朗","・","島峯　直也",null,null,10,10,null,null,20,2,5]
[null,6,"中越","長岡","男子",2,"斎藤　謙史朗","・","島峯　直也",null,null,10,10,null,null,20,2,5]
[null,7,"上越","高田","男子",2,"斎藤　謙史朗","・","島峯　直也",null,null,10,10,null,null,20,2,5]
[null,8,"佐渡","両津","男子",2,"斎藤　謙史朗","・","島峯　直也",null,null,10,10,null,null,20,2,5]
[null,9,"下越","新発田","男子",3,"椎谷　賢","・","椎谷　大",null,null,5,5,null,null,10,3,9]
[null,10,"中越","小千谷","男子",3,"椎谷　賢","・","椎谷　大",null,null,5,5,null,null,10,3,9]
[null,11,"上越","直江津","男子",3,"椎谷　賢","・","椎谷　大",null,null,5,5,null,null,10,3,9]
[null,12,"佐渡","佐渡","男子",3,"椎谷　賢","・","椎谷　大",null,null,5,5,null,null,10,3,9]
[null,13,"下越","新発田","男子",4,"佐藤　隼人","・","工藤　航平",null,null,3,3,null,null,6,4,13]
[null,14,"新潟","燕中等","男子",1,"廣川　陸","・","竹内　裕哉",null,null,null,null,"有(16)","有(16)",0,1,14]
[null,15,"新潟","燕中等","男子",2,"藤﨑　岳史","・","五十嵐　匠",null,null,null,null,"有(16)","有(16)",0,1,14]
[null,16,"新潟","燕中等","男子",3,"豊田　善和","・","市川　雄",null,null,null,null,null,null,0,3,16]

{"sheet":"全県ベンチ入り指導者","index":4,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"ベンチ入り指導者一覧"]
["No","地区","学校名","ﾍﾞﾝﾁ入り指導者①","当外","ﾍﾞﾝﾁ入り指導者②","当外","ﾍﾞﾝﾁ入り指導者③","当外","ﾍﾞﾝﾁ入り指導者④","当外"]
[1,"新潟","巻","国島孝志","当","玉木栄一","外","橋本紀洋","外"]
[2,"下越","新発田","新発田太郎","当","玉木栄一","外","橋本紀洋","外"]
[3,"中越","三条","三条孝志","当","玉木栄一","外","橋本紀洋","外"]
[4,"中越","長岡","長岡孝志","当"]
[5,"上越","高田","上越孝志","当","玉木栄一","外","橋本紀洋","外"]
[6,"佐渡","羽茂","佐渡孝志","当","玉木栄一","外","橋本紀洋","外"]

{"sheet":"新潟","index":5,"n_rows":3,"n_cols":30,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,18,2,18],[1,10,1,11],[1,12,1,13],[1,14,1,15],[1,16,1,17],[0,10,0,17]]}
[null,null,null,null,null,null,null,null,null,null,"ﾎﾟｲﾝﾄ",null,null,null,null,null,null,null,"合計"]
[null,null,null,"地区","学校名","男女","申込順","選手Ａ","・","選手Ｂ","県ｲﾝﾄﾞｱ",null,"ＨＪＳ",null,"春地区"]
["個人AID","個人BID","No","地区",null,null,null,null,null,null,"選手A","選手B","選手A","選手B","選手A","選手B",null,null,null,null,"地区","学校名","ﾍﾞﾝﾁ入り指導者①","当外","ﾍﾞﾝﾁ入り指導者②","当外","ﾍﾞﾝﾁ入り指導者③","当外","ﾍﾞﾝﾁ入り指導者④","当外"]

{"sheet":"下越","index":6,"n_rows":3,"n_cols":30,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,8,2,8],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,9,2,9],[0,10,0,17],[0,18,2,18],[1,10,1,11],[1,12,1,13],[1,14,1,15],[1,16,1,17]]}
[null,null,null,"地区","学校名","男女","申込順","選手Ａ","・","選手Ｂ","ﾎﾟｲﾝﾄ",null,null,null,null,null,null,null,"合計"]
[null,null,null,null,null,null,null,null,null,null,"県ｲﾝﾄﾞｱ",null,"ＨＪＳ",null,"春地区"]
["個人AID","個人BID","No",null,null,null,null,null,null,null,"選手A","選手B","選手A","選手B","選手A","選手B",null,null,null,null,"地区","学校名","ﾍﾞﾝﾁ入り指導者①","当外","ﾍﾞﾝﾁ入り指導者②","当外","ﾍﾞﾝﾁ入り指導者③","当外","ﾍﾞﾝﾁ入り指導者④","当外"]

{"sheet":"中越","index":7,"n_rows":3,"n_cols":30,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,8,2,8],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,9,2,9],[0,10,0,17],[0,18,2,18],[1,10,1,11],[1,12,1,13],[1,14,1,15],[1,16,1,17]]}
[null,null,null,"地区","学校名","男女","申込順","選手Ａ","・","選手Ｂ","ﾎﾟｲﾝﾄ",null,null,null,null,null,null,null,"合計"]
[null,null,null,null,null,null,null,null,null,null,"県ｲﾝﾄﾞｱ",null,"ＨＪＳ",null,"春地区"]
["個人AID","個人BID","No",null,null,null,null,null,null,null,"選手A","選手B","選手A","選手B","選手A","選手B",null,null,null,null,"地区","学校名","ﾍﾞﾝﾁ入り指導者①","当外","ﾍﾞﾝﾁ入り指導者②","当外","ﾍﾞﾝﾁ入り指導者③","当外","ﾍﾞﾝﾁ入り指導者④","当外"]

{"sheet":"上越","index":8,"n_rows":3,"n_cols":30,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,8,2,8],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,9,2,9],[0,10,0,17],[0,18,2,18],[1,10,1,11],[1,12,1,13],[1,14,1,15],[1,16,1,17]]}
[null,null,null,"地区","学校名","男女","申込順","選手Ａ","・","選手Ｂ","ﾎﾟｲﾝﾄ",null,null,null,null,null,null,null,"合計"]
[null,null,null,null,null,null,null,null,null,null,"県ｲﾝﾄﾞｱ",null,"ＨＪＳ",null,"春地区"]
["個人AID","個人BID","No",null,null,null,null,null,null,null,"選手A","選手B","選手A","選手B","選手A","選手B",null,null,null,null,"地区","学校名","ﾍﾞﾝﾁ入り指導者①","当外","ﾍﾞﾝﾁ入り指導者②","当外","ﾍﾞﾝﾁ入り指導者③","当外","ﾍﾞﾝﾁ入り指導者④","当外"]

{"sheet":"佐渡","index":9,"n_rows":3,"n_cols":30,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,8,2,8],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,9,2,9],[0,10,0,17],[0,18,2,18],[1,10,1,11],[1,12,1,13],[1,14,1,15],[1,16,1,17]]}
[null,null,null,"地区","学校名","男女","申込順","選手Ａ","・","選手Ｂ","ﾎﾟｲﾝﾄ",null,null,null,null,null,null,null,"合計"]
[null,null,null,null,null,null,null,null,null,null,"県ｲﾝﾄﾞｱ",null,"ＨＪＳ",null,"春地区"]
["個人AID","個人BID","No",null,null,null,null,null,null,null,"選手A","選手B","選手A","選手B","選手A","選手B",null,null,null,null,"地区","学校名","ﾍﾞﾝﾁ入り指導者①","当外","ﾍﾞﾝﾁ入り指導者②","当外","ﾍﾞﾝﾁ入り指導者③","当外","ﾍﾞﾝﾁ入り指導者④","当外"]

{"sheet":"校名抽出","index":10,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
["No","地区","学校名","男女","出場ﾍﾟｱ数"]
[1,"新潟","燕中等","男子",4]
[2,"新潟","巻","男子",7]
[3,"新潟","巻総合","男子",3]
[4,"新潟","市立高志","男子",2]
[5,"新潟","新潟","男子",4]
[6,"新潟","新潟工","男子",6]
[7,"新潟","新潟商","男子",3]
[8,"新潟","新潟西","男子",5]
[9,"新潟","新潟南","男子",2]
[10,"新潟","新潟北","男子",2]
[11,"新潟","西川竹園","男子",1]
[12,"新潟","白根","男子",3]
[13,"新潟","分水","男子",2]
[14,"新潟","北越","男子",5]
[15,"新潟","万代","男子",2]
[16,"下越","新津南","男子",2]
[17,"下越","新発田","男子",2]
[18,"下越","新発田商","男子",4]
[19,"下越","新発田中央","男子",6]
[20,"下越","新発田南","男子",6]
[21,"下越","新発田農","男子",2]
[22,"下越","村上","男子",3]
[23,"下越","村上桜ヶ丘","男子",5]
[24,"下越","中条","男子",2]
[25,"下越","豊栄","男子",3]
[26,"中越","塩沢商工","男子",2]
[27,"中越","見附","男子",1]
[28,"中越","三条","男子",2]
[29,"中越","三条商　","男子",2]
[30,"中越","三条東","男子",3]
[31,"中越","十日町","男子",5]
[32,"中越","十日町総合","男子",2]
[33,"中越","小千谷","男子",7]
[34,"中越","小千谷西","男子",2]
[35,"中越","新潟県央工","男子",2]
[36,"中越","長岡工","男子",3]
[37,"中越","長岡","男子",4]
[38,"中越","長岡商","男子",3]
[39,"中越","帝京長岡","男子",2]
[40,"上越","関根学園","男子",4]
[41,"上越","高田","男子",9]
[42,"上越","糸魚川","男子",2]
[43,"上越","糸魚川白嶺","男子",2]
[44,"上越","上越総合技術","男子",5]
[45,"上越","新潟産業大附","男子",2]
[46,"上越","柏崎","男子",5]
[47,"上越","柏崎常盤","男子",3]
[48,"上越","柏崎総合","男子",2]
[49,"上越","柏崎翔洋中等","男子",2]
[50,"佐渡","羽茂","男子",4]
[51,"佐渡","佐渡","男子",6]
[52,"佐渡","佐渡総合","男子",3]
[53,"佐渡","佐渡中等","男子",2]