{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["ホーム","個人の詳細","旅行の詳細","ホテルおよび活動","レンタカー","緊急連絡先の詳細"],"not_rendered":{"images":19,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"ホーム","index":0,"n_rows":34,"n_cols":22,"rows_kept":34,"merged":[[32,1,32,3],[32,6,32,8],[32,11,32,13],[32,16,32,18],[32,21,32,23],[33,1,33,3],[33,6,33,8],[33,11,33,13],[33,16,33,18],[33,21,33,23]]}
{"$rows_empty":32}
[null,{"$f":"個人エントリ/個人回数","v":{"v":1,"d":"100%"}},{"$nulls":4},{"$f":"旅行エントリ/旅行回数","v":{"v":0.65,"d":"65%"}},{"$nulls":4},{"$f":"ホテルエントリ/ホテル回数","v":{"v":0.5384615384615384,"d":"54%"}},{"$nulls":4},{"$f":"IF(レンタカー!D4=\"○\",レンタカーエントリ/レンタカー回数,1)","v":{"v":0.2857142857142857,"d":"29%"}},{"$nulls":4},{"$f":"緊急連絡先エントリ/緊急回数","v":{"v":0.625,"d":"63%"}}]
[null,{"$f":"TEXT(B33,\"0% \"\"完了\"\"\")","v":"100% 完了"},{"$nulls":4},{"$f":"TEXT(G33,\"0% \"\"完了\"\"\")","v":"65% 完了"},{"$nulls":4},{"$f":"TEXT(L33,\"0% \"\"完了\"\"\")","v":"54% 完了"},{"$nulls":4},{"$f":"TEXT(Q33,\"0% \"\"完了\"\"\")","v":"29% 完了"},{"$nulls":4},{"$f":"TEXT(V33,\"0% \"\"完了\"\"\")","v":"63% 完了"}]

{"sheet":"個人の詳細","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"merged":[[4,2,5,2],[4,3,5,3],[4,4,5,4],[7,2,8,2],[7,3,8,3],[7,4,8,4],[17,1,17,4]]}
[]
[]
[{"$f":"IF(COUNTA(B4:B8)<1,\"*\",\"\")","v":""},"氏名およびニックネーム",{"$f":"IF(E3=\"\",1,\"\")","v":""},"自宅の住所","神奈川県横浜市神奈川区青木町 987 "]
[null,"田本 哲也"]
[null,"田本 恭子",{"$f":"IF(E5=\"\",1,\"\")","v":""},"自宅の電話電話",3455550123]
[null,"田本 千賀"]
[]
[null,null,{"$f":"IF((E8=0)+(E8=\"\"),1,\"\")","v":""},"携帯電話",3455550124]
[]
[]
[{"$f":"個人エントリ","v":3},{"$f":"IF(A11<>個人回数,\"重要な詳細情報の入力が完了していません\",\"重要な詳細情報の入力が完了しました\")","v":"重要な詳細情報の入力が完了しました"}]

{"sheet":"旅行の詳細","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[23,1,23,5]]}
[]
[]
[null,"往路の詳細",null,null,"帰路の詳細"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"日付","2013-01-11",{"$f":"IF(F4=\"\",1,\"\")","v":""},"日付","2013-01-17"]
[{"$f":"IF(C5=\"\",1,\"\")","v":""},"航空会社","Blue Yonder Airlines","","航空会社","Blue Yonder Airlines"]
[{"$f":"IF(C6=\"\",1,\"\")","v":""},"フライト番号","WS192",1,"フライト番号"]
[{"$f":"IF(C7=\"\",1,\"\")","v":""},"出発地","コロンバス","","出発地","シアトル"]
[{"$f":"IF(C8=\"\",1,\"\")","v":""},"出発時刻","12:30:00",1,"出発時刻"]
[null,"出発ターミナル/ゲート",null,1,"出発ターミナル/ゲート"]
[{"$f":"IF(C10=\"\",1,\"\")","v":""},"到着地","シアトル",1,"到着地"]
[{"$f":"IF(C11=\"\",1,\"\")","v":""},"到着時刻","12:32:00",1,"到着時刻"]
[null,"フライト時間","6 時間",null,"フライト時間"]
[{"$f":"IF(C13=\"\",1,\"\")","v":""},"座席番号","A1、A2、A3",{"$f":"IF(F13=\"\",1,\"\")","v":1},"座席番号"]
[{"$f":"IF(C14=\"\",1,\"\")","v":""},"確認番号","同じ",{"$f":"IF(F14=\"\",1,\"\")","v":1},"確認番号"]
[{"$f":"IF(C15=\"\",1,\"\")","v":""},"食事","制限なし",null,"食事"]
[null,"航空会社の電話番号","(123) 555-0234",null,"航空会社の電話番号","(123) 555-0234"]
[]
[{"$f":"旅行エントリ","v":13},{"$f":"IF(A18<>旅行回数,\"重要な詳細情報の入力が完了していません\",\"重要な詳細情報の入力が完了しました\")","v":"重要な詳細情報の入力が完了していません"}]

{"sheet":"ホテルおよび活動","index":3,"n_rows":15,"n_cols":7,"rows_kept":15,"merged":[[21,1,21,6]]}
[]
[]
[null,"宿泊ホテル/施設の詳細",{"$nulls":3},"休暇の活動の詳細"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"予約日","2013-01-11",null,null,"活動 1","スキー"]
["","ホテル名","アルプス スキー ハウス",null,{"$f":"IF(AND($G$4<>\"\",G5=\"\"),1,\"\")","v":1},"日付/時刻"]
["","ホテルの住所","789 Main Street",null,{"$f":"IF(AND($G$4<>\"\",G6=\"\"),1,\"\")","v":1},"予約日"]
["","ホテルの電話番号","シアトル",null,{"$f":"IF(AND($G$4<>\"\",G7=\"\"),1,\"\")","v":1},"確認番号"]
["","チェックインの日時","2013-01-11T12:00:00",null,null,"活動 2","コーホーぶどう園/ワイナリー"]
["","チェックアウトの日時","2013-01-16T12:00:00",null,{"$f":"IF(AND($G$8<>\"\",G9=\"\"),1,\"\")","v":1},"日付/時刻"]
["","確認番号","CJ1234567",null,{"$f":"IF(AND($G$8<>\"\",G10=\"\"),1,\"\")","v":1},"予約日"]
[{"$nulls":4},{"$f":"IF(AND($G$8<>\"\",G11=\"\"),1,\"\")","v":1},"確認番号"]
[{"$f":"ホテルエントリ","v":7},{"$f":"IF(A12<>ホテル回数,\"重要な詳細情報の入力が完了していません\",\"重要な詳細情報の入力が完了しました\")","v":"重要な詳細情報の入力が完了していません"},{"$nulls":3},"活動 3"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G13=\"\"),1,\"\")","v":""},"日付/時刻"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G14=\"\"),1,\"\")","v":""},"予約日"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G15=\"\"),1,\"\")","v":""},"確認番号"]

{"sheet":"レンタカー","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"merged":[[18,0,18,4]]}
[]
[]
[null,null,"レンタカーの情報"]
[null,null,"レンタカー使用の有無","○"]
[null,{"$f":"IF(AND($D$4=\"○\",D5=\"\"),1,\"\")","v":""},"予約日","2013-01-11"]
[null,1,"レンタカー会社"]
[null,1,"配車日時"]
[null,1,"返車日時"]
[null,1,"確認番号"]
[null,"","車種","エコノミー"]
[null,1,"電話番号"]
[]
[null,{"$f":"レンタカーエントリ","v":2},{"$f":"IF(B13<>レンタカー回数,\"重要な詳細情報の入力が完了していません\",\"重要な詳細情報の入力が完了しました\")","v":"重要な詳細情報の入力が完了していません"}]

{"sheet":"緊急連絡先の詳細","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[3,4,4,4],[3,5,4,5],[3,6,4,6],[5,4,6,4],[5,5,6,5],[5,6,6,6],[7,5,8,5],[7,6,8,6],[16,1,16,6]]}
[]
[]
[null,"保険の詳細",{"$nulls":3},"緊急連絡先の詳細"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"保険会社","ヒューモンガス保険会社",null,{"$f":"IF(G4=\"\",1,\"\")","v":1},"名前/関係/電話"]
["","電話番号","(123) 555-0567"]
["","保証の種類","治療 (傷害)",null,{"$f":"IF(G6=\"\",1,\"\")","v":1},"名前/関係/電話"]
["","確認番号",123456]
["","契約日","2012-01-27",null,null,"名前/関係/電話"]
[1,"保証期間"]
[]
[{"$f":"緊急連絡先エントリ","v":5},{"$f":"IF(A11<>緊急回数,\"重要な詳細情報の入力が完了していません\",\"重要な詳細情報の入力が完了しました\")","v":"重要な詳細情報の入力が完了していません"}]