{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["基本data","入力data"],"not_rendered":{"macros":1,"external_links":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"基本data","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"merged":[[4,5,7,12]]}
["オープンスクール申込2018"]
[null,"学校情報入力"]
[]
["都道府県",null,"←必ず入力",null,null,"学校情報入力後、データ入力ボタンを押下して生徒情報を入力してください"]
["中学校名",null,"←必ず入力",null,null,"データを入力後保存ボタンを押下すると、Cドライブ内へSaveフォルダを自動作成し中学校名をファイル名で自動保存します。修正についてはSaveフォルダ内のファイルを修正してください。このファイルをメール添付で送付してください"]
["住所",null,"←必ず入力"]
["ご担当者",null,"←必ず入力"]
["引率者",null,"←必ず入力"]
["郵便番号",null,"←必ず入力"]
["電話番号",null,"←必ず入力"]
["FAX",null,"←必ず入力"]
["Mail",null,"←必ず入力"]

{"sheet":"入力data","index":1,"n_rows":55,"n_cols":45,"rows_kept":55,"hidden":true,"merged":[[2,8,2,12]]}
[{"$nulls":31},"記号","項目","持参物","2018-09-15","2018-09-29","2018-10-20","生徒氏名","フリガナ","性別","生年月日","郵便番号","電話番号","住所","保護者名"]
[{"$nulls":31},"A:普通","普通科","---","実施","実施","実施",{"$nulls":3},"---","---","---","---","---"]
[null,"不要","参加日を選択","体験選択","不要","氏名の間を全角空けて","氏名の間を全角空けて","選択","色がついているセルは入力不要(部活動は保険加入のため以下入力)",{"$nulls":8},"保護者可",{"$nulls":13},"B:看護","看護科","---","実施","実施","実施",{"$nulls":3},"---","---","---","---","---"]
[null,"↓","↓","↓","↓","↓","↓","↓","2001-12-10",{"$nulls":3},"氏名の間を全角空けて",{"$nulls":18},"C:総合","総合学科","---","実施","実施","実施",{"$nulls":3},"---","---","---","---","---"]
[null,"No","実施日","体験記号","体験内容","生徒氏名","フリガナ","性別","生年月日","郵便番号","電話番号","住所","保護者名","都道府県","中学校名","住所","ご担当者","引率者","郵便番号","電話番号","FAX","Mail",{"$nulls":9},"G1:剣道","剣道","防具一式","---","実施","---"]
[{"$f":"LEFT(D6,2)","v":""},{"$f":"IF(C6=\"\",\"\",ROW()-5)","v":""},null,null,{"$f":"IF(ISERROR(VLOOKUP($D6,リスト,2,FALSE)),\"\",VLOOKUP($D6,リスト,2,FALSE))","v":""},{"$nulls":8},0,0,0,0,null,0,0,0,0,{"$nulls":9},"G2:野球","硬式野球","用具一式","実施","連絡","連絡"]
[{"$f":"LEFT(D7,2)","v":""},{"$f":"IF(C7=\"\",\"\",ROW()-5)","v":""},null,null,"",{"$nulls":26},"G3:バレー","女子バレーボール","用具一式","実施","実施","実施"]
["","",null,null,"",{"$nulls":26},"G5:テニス","女子ソフトテニス","用具一式","---","実施","実施"]
["","",null,null,"",{"$nulls":26},"G8:ゴルフ","ゴルフ","用具一式","実施","---","---"]
["","",null,null,""]
["","",null,null,"",{"$nulls":26},"第1回","第2回","第3回","男"]
["","",null,null,"",{"$nulls":26},"土曜日","土曜日","土曜日","女"]
["","",null,null,"",{"$nulls":26},"2018-09-15","2018-09-29","2018-10-20"]
["","",null,null,"",{"$nulls":26},"第1回9月15日土曜日","第2回9月29日土曜日","第3回10月20日土曜日"]
["","",null,null,"",{"$nulls":26},"A:普通","A:普通","A:普通"]
["","",null,null,"",{"$nulls":26},"B:看護","B:看護","B:看護"]
["","",null,null,"",{"$nulls":26},"C:総合","C:総合","C:総合"]
["","",null,null,"",{"$nulls":26},"G2:野球","G1:剣道","G3:バレー"]
["","",null,null,"",{"$nulls":26},"G3:バレー","G3:バレー","G5:テニス"]
["","",null,null,"",{"$nulls":26},"G8:ゴルフ","G5:テニス"]
["","",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":"IF(ISERROR(VLOOKUP($D38,リスト,2,FALSE)),\"\",VLOOKUP($D38,リスト,2,FALSE))","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,""]