{"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":"PersonalEntry/PersonalCount","v":{"v":1,"d":"100%"}},{"$nulls":4},{"$f":"TravelEntry/TravelCount","v":{"v":0.65,"d":"65%"}},{"$nulls":4},{"$f":"HotelEntry/HotelCount","v":{"v":0.5384615384615384,"d":"54%"}},{"$nulls":4},{"$f":"IF(租車!D4=\"是\",CarRentalEntry/CarRentalCount,1)","v":{"v":0.2857142857142857,"d":"29%"}},{"$nulls":4},{"$f":"EmergencyEntry/EmergencyCount","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":""},"住家地址","7754 台灣桃園縣富國路 42 號"]
[null,"陳國明"]
[null,"陳珍菲",{"$f":"IF(E5=\"\",1,\"\")","v":""},"住家電話",3455550123]
[null,"徐彼得"]
[]
[null,null,{"$f":"IF((E8=0)+(E8=\"\"),1,\"\")","v":""},"行動電話",3455550124]
[]
[]
[{"$f":"PersonalEntry","v":3},{"$f":"IF(A11<>PersonalCount,\"缺少重要詳細資料\",\"重要詳細資料已填妥\")","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":""},"日期",{"$f":"TODAY()+45","v":"2013-02-21"},{"$f":"IF(F4=\"\",1,\"\")","v":""},"日期",{"$f":"TODAY()+51","v":"2013-02-27"}]
[{"$f":"IF(C5=\"\",1,\"\")","v":""},"航空公司","萬海航空","","航空公司","萬海航空"]
[{"$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,"航空公司電話號碼",1235550234,null,"航空公司電話號碼",1235550234]
[]
[{"$f":"TravelEntry","v":13},{"$f":"IF(A18<>TravelCount,\"缺少重要詳細資料\",\"重要詳細資料已填妥\")","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":""},"預訂日期",{"$f":"TODAY()+45","v":"2013-02-21"},null,null,"活動 1","滑雪"]
["","飯店名稱","Alpine Ski House",null,{"$f":"IF(AND($G$4<>\"\",G5=\"\"),1,\"\")","v":1},"日期/時間"]
["","飯店地址","主街 789 號",null,{"$f":"IF(AND($G$4<>\"\",G6=\"\"),1,\"\")","v":1},"預訂日期"]
["","飯店電話號碼","西雅圖",null,{"$f":"IF(AND($G$4<>\"\",G7=\"\"),1,\"\")","v":1},"確認號碼"]
["","住房日期/時間",{"$f":"TODAY()+45.5","v":"2013-02-21T12:00:00"},null,null,"活動 2","紅陽葡萄園與釀酒廠"]
["","退房日期/時間",{"$f":"TODAY()+50.5","v":"2013-02-26T12: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":"HotelEntry","v":7},{"$f":"IF(A12<>HotelCount,\"缺少重要詳細資料\",\"重要詳細資料已填妥\")","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":""},"預訂日期",{"$f":"TODAY()+45","v":"2013-02-21"}]
[null,1,"租車公司"]
[null,1,"取車日期/時間"]
[null,1,"還車日期/時間"]
[null,1,"確認號碼"]
[null,"","車型","經濟型"]
[null,1,"電話號碼"]
[]
[null,{"$f":"CarRentalEntry","v":2},{"$f":"IF(B13<>CarRentalCount,\"缺少重要詳細資料\",\"重要詳細資料已填妥\")","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},"姓名 / 關係 / 電話"]
["","電話號碼",1235550567]
["","承保類型","1900-01-05",null,{"$f":"IF(G6=\"\",1,\"\")","v":1},"姓名 / 關係 / 電話"]
["","確認號碼","1900-01-05"]
["","購買日期",{"$f":"TODAY()","v":"2013-01-07"},null,null,"姓名 / 關係 / 電話"]
[1,"承保日期"]
[]
[{"$f":"EmergencyEntry","v":5},{"$f":"IF(A11<>EmergencyCount,\"缺少重要詳細資料\",\"重要詳細資料已填妥\")","v":"缺少重要詳細資料"}]