{"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 North Fifth Street Columbus, TN 01234"]
[null,"Michael Alexander"]
[null,"Michelle Alexander",{"$f":"IF(E5=\"\",1,\"\")","v":""},"固定电话",3455550123]
[null,"Sean P. Alexander"]
[]
[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":""},"日期",{"$f":"TODAY()+45","v":"2013-02-23"},{"$f":"IF(F4=\"\",1,\"\")","v":""},"日期",{"$f":"TODAY()+51","v":"2013-03-01"}]
[{"$f":"IF(C5=\"\",1,\"\")","v":""},"航空公司","Blue Yonder 航空公司","","航空公司","Blue Yonder 航空公司"]
[{"$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":"旅游条目","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":""},"预订日期",{"$f":"TODAY()+45","v":"2013-02-23"},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-23T12:00:00"},null,null,"活动 2","Coho Vineyard & Winery"]
["","退房日期/时间",{"$f":"TODAY()+50.5","v":"2013-02-28T12: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":""},"预订日期",{"$f":"TODAY()+45","v":"2013-02-23"}]
[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},"姓名/关系/电话"]
["","电话号码",1235550567]
["","覆盖类型","1900-01-05",null,{"$f":"IF(G6=\"\",1,\"\")","v":1},"姓名/关系/电话"]
["","确认号码","1900-01-05"]
["","购买日期",{"$f":"TODAY()","v":"2013-01-09"},null,null,"姓名/关系/电话"]
[1,"有效日期"]
[]
[{"$f":"紧急条目","v":5},{"$f":"IF(A11<>紧急计数,\"缺失重要详细信息\",\"重要的详细信息完成度\")","v":"缺失重要详细信息"}]