{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Trang đầu","Chi tiết Cá nhân","Chi tiết Chuyến đi","Khách sạn và Hoạt động","Thuê Xe","Chi tiết Khẩn cấp"],"not_rendered":{"images":19,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Trang đầu","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('Thuê Xe'!D4=\"Yes\",CarRentalEntry/CarRentalCount,1)","v":{"v":1,"d":"100%"}},{"$nulls":4},{"$f":"EmergencyEntry/EmergencyCount","v":{"v":0.625,"d":"63%"}}]
[null,{"$f":"TEXT(B33,\"0% \"\"hoàn thành\"\"\")","v":"100% hoàn thành"},{"$nulls":4},{"$f":"TEXT(G33,\"0% \"\"hoàn thành\"\"\")","v":"65% hoàn thành"},{"$nulls":4},{"$f":"TEXT(L33,\"0% \"\"hoàn thành\"\"\")","v":"54% hoàn thành"},{"$nulls":4},{"$f":"TEXT(Q33,\"0% \"\"hoàn thành\"\"\")","v":"100% hoàn thành"},{"$nulls":4},{"$f":"TEXT(V33,\"0% \"\"hoàn thành\"\"\")","v":"63% hoàn thành"}]

{"sheet":"Chi tiết Cá nhân","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":""},"Tên đầy đủ & Biệt danh",{"$f":"IF(E3=\"\",1,\"\")","v":""},"Địa chỉ Nhà riêng","987 North Fifth Street Columbus, TN 01234"]
[null,"Michael Alexander"]
[null,"Michelle Alexander",{"$f":"IF(E5=\"\",1,\"\")","v":""},"Điện thoại Nhà riêng",3455550123]
[null,"Sean P. Alexander"]
[]
[null,null,{"$f":"IF((E8=0)+(E8=\"\"),1,\"\")","v":""},"Điện thoại Di động",3455550124]
[]
[]
[{"$f":"PersonalEntry","v":3},{"$f":"IF(A11<>PersonalCount,\"Thiếu chi tiết quan trọng\",\"Chi tiết quan trọng hoàn thành\")","v":"Chi tiết quan trọng hoàn thành"}]

{"sheet":"Chi tiết Chuyến đi","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[23,1,23,5]]}
[]
[]
[null,"Chi tiết Khởi hành",null,null,"Chi tiết Chiều về"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"Ngày",{"$f":"TODAY()+45","v":"2013-02-07"},{"$f":"IF(F4=\"\",1,\"\")","v":""},"Ngày",{"$f":"TODAY()+51","v":"2013-02-13"}]
[{"$f":"IF(C5=\"\",1,\"\")","v":""},"Hãng hàng không","Blue Yonder Airlines","","Hãng hàng không","Blue Yonder Airlines"]
[{"$f":"IF(C6=\"\",1,\"\")","v":""},"Số Chuyến bay","WS192",1,"Số Chuyến bay"]
[{"$f":"IF(C7=\"\",1,\"\")","v":""},"Từ","Columbus","","Từ","Seattle"]
[{"$f":"IF(C8=\"\",1,\"\")","v":""},"Thời gian Khởi hành","12:30:00",1,"Thời gian Khởi hành"]
[null,"Ga Khởi hành/Cổng",null,1,"Ga Khởi hành/Cổng"]
[{"$f":"IF(C10=\"\",1,\"\")","v":""},"Đến","Seattle",1,"Đến"]
[{"$f":"IF(C11=\"\",1,\"\")","v":""},"Thời gian Đến","12:32:00",1,"Thời gian Đến"]
[null,"Thời gian Chuyến bay","6 giờ",null,"Thời gian Chuyến bay"]
[{"$f":"IF(C13=\"\",1,\"\")","v":""},"Số Ghế","A1, A2,A3",{"$f":"IF(F13=\"\",1,\"\")","v":1},"Số Ghế"]
[{"$f":"IF(C14=\"\",1,\"\")","v":""},"Số Xác nhận","Như nhau",{"$f":"IF(F14=\"\",1,\"\")","v":1},"Số Xác nhận"]
[{"$f":"IF(C15=\"\",1,\"\")","v":""},"Bữa ăn","Không hạn chế",null,"Bữa ăn"]
[null,"Số Điện thoại Hãng hàng không",1235550234,null,"Số Điện thoại Hãng hàng không",1235550234]
[]
[{"$f":"TravelEntry","v":13},{"$f":"IF(A18<>TravelCount,\"Thiếu chi tiết quan trọng\",\"Chi tiết quan trọng hoàn thành\")","v":"Thiếu chi tiết quan trọng"}]

{"sheet":"Khách sạn và Hoạt động","index":3,"n_rows":15,"n_cols":7,"rows_kept":15,"merged":[[21,1,21,6]]}
[]
[]
[null,"Thông tin Khách sạn / Chỗ ở",{"$nulls":3},"Chi tiết Hoạt động Kỳ nghỉ"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"Ngày Đặt phòng",{"$f":"TODAY()+45","v":"2013-02-07"},null,null,"Hoạt động 1","Trượt tuyết"]
["","Tên Khách sạn","Alpine Ski House",null,{"$f":"IF(AND($G$4<>\"\",G5=\"\"),1,\"\")","v":1},"Ngày/Thời gian"]
["","Địa chỉ Khách sạn","789 Main Street",null,{"$f":"IF(AND($G$4<>\"\",G6=\"\"),1,\"\")","v":1},"Ngày Đặt phòng"]
["","Số điện thoại Khách sạn","Seattle",null,{"$f":"IF(AND($G$4<>\"\",G7=\"\"),1,\"\")","v":1},"Số Xác nhận"]
["","Ngày/Giờ Nhận phòng",{"$f":"TODAY()+45.5","v":"2013-02-07T12:00:00"},null,null,"Hoạt động 2","Coho Vineyard & Winery"]
["","Ngày/Giờ Trả phòng",{"$f":"TODAY()+50.5","v":"2013-02-12T12:00:00"},null,{"$f":"IF(AND($G$8<>\"\",G9=\"\"),1,\"\")","v":1},"Ngày/Thời gian"]
["","Số Xác nhận","CJ1234567",null,{"$f":"IF(AND($G$8<>\"\",G10=\"\"),1,\"\")","v":1},"Ngày Đặt phòng"]
[{"$nulls":4},{"$f":"IF(AND($G$8<>\"\",G11=\"\"),1,\"\")","v":1},"Số Xác nhận"]
[{"$f":"HotelEntry","v":7},{"$f":"IF(A12<>HotelCount,\"Thiếu chi tiết quan trọng\",\"Chi tiết quan trọng hoàn thành\")","v":"Thiếu chi tiết quan trọng"},{"$nulls":3},"Hoạt động 3"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G13=\"\"),1,\"\")","v":""},"Ngày/Thời gian"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G14=\"\"),1,\"\")","v":""},"Ngày Đặt phòng"]
[{"$nulls":4},{"$f":"IF(AND($G$12<>\"\",G15=\"\"),1,\"\")","v":""},"Số Xác nhận"]

{"sheet":"Thuê Xe","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"merged":[[18,0,18,4]]}
[]
[]
[null,null,"Thông tin Thuê Xe"]
[null,null,"Bạn muốn thuê xe?","Có"]
[null,{"$f":"IF(AND($D$4=\"Có\",D5=\"\"),1,\"\")","v":""},"Ngày Đặt phòng",{"$f":"TODAY()+45","v":"2013-02-07"}]
[null,1,"Công ty Cho thuê"]
[null,1,"Ngày/Giờ Đón"]
[null,1,"Ngày/Giờ Thả xuống"]
[null,1,"Số Xác nhận"]
[null,"","Loại Phương tiện","Phổ thông"]
[null,1,"Số Điện thoại"]
[]
[null,{"$f":"CarRentalEntry","v":0},{"$f":"IF(B13<>CarRentalCount,\"Thiếu chi tiết quan trọng\",\"Chi tiết quan trọng hoàn thành\")","v":"Chi tiết quan trọng hoàn thành"}]

{"sheet":"Chi tiết Khẩn cấp","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,"Chi tiết Bảo hiểm",{"$nulls":3},"Chi tiết Liên hệ Khẩn cấp"]
[{"$f":"IF(C4=\"\",1,\"\")","v":""},"Công ty Bảo hiểm","Humongous Insurance",null,{"$f":"IF(G4=\"\",1,\"\")","v":1},"Tên / Mối quan hệ / Điện thoại"]
["","Số Điện thoại",1235550567]
["","Loại Bảo hiểm","1900-01-05",null,{"$f":"IF(G6=\"\",1,\"\")","v":1},"Tên / Mối quan hệ / Điện thoại"]
["","Số Xác nhận","1900-01-05"]
["","Ngày Mua",{"$f":"TODAY()","v":"2012-12-24"},null,null,"Tên / Mối quan hệ / Điện thoại"]
[1,"Ngày Bảo hiểm"]
[]
[{"$f":"EmergencyEntry","v":5},{"$f":"IF(A11<>EmergencyCount,\"Thiếu chi tiết quan trọng\",\"Chi tiết quan trọng hoàn thành\")","v":"Thiếu chi tiết quan trọng"}]