{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Nhật ký Tổng số dặm đã đi","Dữ liệu Nhật ký","các phép tính"],"not_rendered":{"charts":1,"defined_names":17},"read":"whole","date_system":"1900"}

{"sheet":"Nhật ký Tổng số dặm đã đi","index":0,"n_rows":29,"n_cols":5,"rows_kept":29,"merged":[[0,1,1,5]]}
[null,"     NHẬT KÝ TỔNG SỐ DẶM ĐÃ ĐI"]
{"$rows_empty":9}
[null,null,"CÓ THỂ THANH TOÁN LẠI",null,"TỔNG"]
[null,null,"DẶM",null,"THANH TOÁN LẠI"]
[]
[]
[]
[]
[null,null,"2012-05-01",null,"2012-05-10"]
[]
[null,null,"GIAI ĐOẠN",null,"GIAI ĐOẠN"]
[null,null,"BẮT ĐẦU",null,"KẾT THÚC"]
[]
[]
[]
[]
[]
[null,null,54,null,{"v":9800,"d":"9,800"}]
[]
[null,null,"THANH TOÁN LẠI",null,"ĐỒNG HỒ ĐO"]
[null,null,"¢/DẶM",null,"NHIÊN LIỆU TRƯỚC ĐÓ"]

{"sheet":"Dữ liệu Nhật ký","index":1,"n_rows":19,"n_cols":15,"rows_kept":19,"merged":[[0,1,1,5]]}
[null,"NHẬT KÝ TỔNG SỐ DẶM ĐÃ ĐI"]
[{"$nulls":14}," "]
[]
[]
[null,"NGÀY","HOẠT ĐỘNG","ĐỒNG HỒ ĐO. 1","VỊ TRÍ","ĐỒNG HỒ ĐO. 2","ĐIỂM ĐẾN","THANH TOÁN LẠI","GA-LÔNG","CHI PHÍ","DẶM","MPG","¢/DẶM","CHÚ THÍCH"]
[null,"2012-05-01","Chuyến đi",{"v":10123,"d":"10,123"},"Chevron - Main St",{"v":10130,"d":"10,130"},null,null,15.56,{"v":1333488,"d":"1,333,488.00 ₫"},{"$f":"miles","v":7},{"$f":"IF(OR(LEN(data[[#This Row],[ĐỒNG HỒ ĐO. 2]]),data[[#This Row],[ĐỒNG HỒ ĐO. 1]]=\"\"),\"\",IFERROR(data[[#This Row],[DẶM]]/data[[#This Row],[GA-LÔNG]],\"\"))","v":""},{"$f":"IF(data[[#This Row],[MPG]]=\"\",\"\",100*data[[#This Row],[CHI PHÍ]]/data[[#This Row],[DẶM]])","v":""}]
[null,"2012-05-01","Chuyến đi",{"v":10130,"d":"10,130"},"Văn phòng",{"v":10200,"d":"10,200"},"Cherry Street","Có",null,"",{"$f":"miles","v":70},{"$f":"IF(OR(LEN(data[[#This Row],[ĐỒNG HỒ ĐO. 2]]),data[[#This Row],[ĐỒNG HỒ ĐO. 1]]=\"\"),\"\",IFERROR(data[[#This Row],[DẶM]]/data[[#This Row],[GA-LÔNG]],\"\"))","v":""},{"$f":"IF(data[[#This Row],[MPG]]=\"\",\"\",100*data[[#This Row],[CHI PHÍ]]/data[[#This Row],[DẶM]])","v":""}]
[null,"2012-05-01","Chuyến đi",{"v":10200,"d":"10,200"},"Smithfields",{"v":10285,"d":"10,285"},"Văn phòng","Có",null,"",{"$f":"miles","v":85},{"$f":"IF(OR(LEN(data[[#This Row],[ĐỒNG HỒ ĐO. 2]]),data[[#This Row],[ĐỒNG HỒ ĐO. 1]]=\"\"),\"\",IFERROR(data[[#This Row],[DẶM]]/data[[#This Row],[GA-LÔNG]],\"\"))","v":""},{"$f":"IF(data[[#This Row],[MPG]]=\"\",\"\",100*data[[#This Row],[CHI PHÍ]]/data[[#This Row],[DẶM]])","v":""}]
[null,"2012-05-02","Chuyến đi",{"v":10285,"d":"10,285"},"Văn phòng",{"v":10450,"d":"10,450"},"Colo Vineyard","Có",null,"",{"$f":"miles","v":165},{"$f":"IF(OR(LEN(data[[#This Row],[ĐỒNG HỒ ĐO. 2]]),data[[#This Row],[ĐỒNG HỒ ĐO. 1]]=\"\"),\"\",IFERROR(data[[#This Row],[DẶM]]/data[[#This Row],[GA-LÔNG]],\"\"))","v":""},{"$f":"IF(data[[#This Row],[MPG]]=\"\",\"\",100*data[[#This Row],[CHI PHÍ]]/data[[#This Row],[DẶM]])","v":""}]
[null,"2012-05-02","Nhiên liệu",{"v":10450,"d":"10,450"},"Shell",{"$nulls":3},{"v":11.2,"d":"11.20"},{"v":1152736,"d":"1,152,736.00 ₫"},{"$f":"miles","v":650},{"$f":"IF(OR(LEN(data[[#This Row],[ĐỒNG HỒ ĐO. 2]]),data[[#This Row],[ĐỒNG HỒ ĐO. 1]]=\"\"),\"\",IFERROR(data[[#This Row],[DẶM]]/data[[#This Row],[GA-LÔNG]],\"\"))","v":{"v":58.03571428571429,"d":"58.0"}},{"$f":"IF(data[[#This Row],[MPG]]=\"\",\"\",100*data[[#This Row],[CHI PHÍ]]/data[[#This Row],[DẶM]])","v":{"v":177344,"d":"177344.0"}}]
[null,"2012-05-02","Chuyến đi",{"v":10500,"d":"10,500"},"Colo Vineyard",{"v":10518,"d":"10,518"},"Văn phòng","Có",null,"",{"$f":"miles","v":18},{"$f":"IF(OR(LEN(data[[#This Row],[ĐỒNG HỒ ĐO. 2]]),data[[#This Row],[ĐỒNG HỒ ĐO. 1]]=\"\"),\"\",IFERROR(data[[#This Row],[DẶM]]/data[[#This Row],[GA-LÔNG]],\"\"))","v":""},{"$f":"IF(data[[#This Row],[MPG]]=\"\",\"\",100*data[[#This Row],[CHI PHÍ]]/data[[#This Row],[DẶM]])","v":""}]
[null,"2012-05-03","Chuyến đi",{"v":10518,"d":"10,518"},"Văn phòng",{"v":10745,"d":"10,745"},"Văn phòng","Có",null,"",{"$f":"miles","v":227},{"$f":"IF(OR(LEN(data[[#This Row],[ĐỒNG HỒ ĐO. 2]]),data[[#This Row],[ĐỒNG HỒ ĐO. 1]]=\"\"),\"\",IFERROR(data[[#This Row],[DẶM]]/data[[#This Row],[GA-LÔNG]],\"\"))","v":""},{"$f":"IF(data[[#This Row],[MPG]]=\"\",\"\",100*data[[#This Row],[CHI PHÍ]]/data[[#This Row],[DẶM]])","v":""}]
[null,"2012-05-04","Nhiên liệu",{"v":10745,"d":"10,745"},"Chevron - Main St",{"$nulls":3},{"v":16.6,"d":"16.60"},{"v":1440192,"d":"1,440,192.00 ₫"},{"$f":"miles","v":295},{"$f":"IF(OR(LEN(data[[#This Row],[ĐỒNG HỒ ĐO. 2]]),data[[#This Row],[ĐỒNG HỒ ĐO. 1]]=\"\"),\"\",IFERROR(data[[#This Row],[DẶM]]/data[[#This Row],[GA-LÔNG]],\"\"))","v":{"v":17.771084337349397,"d":"17.8"}},{"$f":"IF(data[[#This Row],[MPG]]=\"\",\"\",100*data[[#This Row],[CHI PHÍ]]/data[[#This Row],[DẶM]])","v":{"v":488200.6779661017,"d":"488200.7"}}]
[null,"2012-05-04","Chuyến đi",{"v":10745,"d":"10,745"},"Văn phòng",{"v":10800,"d":"10,800"},"Porterville","Có",null,"",{"$f":"miles","v":55},{"$f":"IF(OR(LEN(data[[#This Row],[ĐỒNG HỒ ĐO. 2]]),data[[#This Row],[ĐỒNG HỒ ĐO. 1]]=\"\"),\"\",IFERROR(data[[#This Row],[DẶM]]/data[[#This Row],[GA-LÔNG]],\"\"))","v":""},{"$f":"IF(data[[#This Row],[MPG]]=\"\",\"\",100*data[[#This Row],[CHI PHÍ]]/data[[#This Row],[DẶM]])","v":""}]
[null,"2012-05-04","Chuyến đi",{"v":10800,"d":"10,800"},"Porterville",{"v":10875,"d":"10,875"},"Văn phòng","Có",null,"",{"$f":"miles","v":75},{"$f":"IF(OR(LEN(data[[#This Row],[ĐỒNG HỒ ĐO. 2]]),data[[#This Row],[ĐỒNG HỒ ĐO. 1]]=\"\"),\"\",IFERROR(data[[#This Row],[DẶM]]/data[[#This Row],[GA-LÔNG]],\"\"))","v":""},{"$f":"IF(data[[#This Row],[MPG]]=\"\",\"\",100*data[[#This Row],[CHI PHÍ]]/data[[#This Row],[DẶM]])","v":""}]
[null,"2012-05-07","Chuyến đi",{"v":10875,"d":"10,875"},"Văn phòng",{"v":10921,"d":"10,921"},"Cherry Street","Có",null,"",{"$f":"miles","v":46},{"$f":"IF(OR(LEN(data[[#This Row],[ĐỒNG HỒ ĐO. 2]]),data[[#This Row],[ĐỒNG HỒ ĐO. 1]]=\"\"),\"\",IFERROR(data[[#This Row],[DẶM]]/data[[#This Row],[GA-LÔNG]],\"\"))","v":""},{"$f":"IF(data[[#This Row],[MPG]]=\"\",\"\",100*data[[#This Row],[CHI PHÍ]]/data[[#This Row],[DẶM]])","v":""}]
[null,"2012-05-07","Chuyến đi",{"v":10921,"d":"10,921"},"Smithfields",{"v":10969,"d":"10,969"},"Văn phòng","Có",null,"",{"$f":"miles","v":48},{"$f":"IF(OR(LEN(data[[#This Row],[ĐỒNG HỒ ĐO. 2]]),data[[#This Row],[ĐỒNG HỒ ĐO. 1]]=\"\"),\"\",IFERROR(data[[#This Row],[DẶM]]/data[[#This Row],[GA-LÔNG]],\"\"))","v":""},{"$f":"IF(data[[#This Row],[MPG]]=\"\",\"\",100*data[[#This Row],[CHI PHÍ]]/data[[#This Row],[DẶM]])","v":""}]
[null,"2012-05-09","Chuyến đi",{"v":10969,"d":"10,969"},"Văn phòng",{"v":11000,"d":"11,000"},"Riverside","Có",null,"",{"$f":"miles","v":31},{"$f":"IF(OR(LEN(data[[#This Row],[ĐỒNG HỒ ĐO. 2]]),data[[#This Row],[ĐỒNG HỒ ĐO. 1]]=\"\"),\"\",IFERROR(data[[#This Row],[DẶM]]/data[[#This Row],[GA-LÔNG]],\"\"))","v":""},{"$f":"IF(data[[#This Row],[MPG]]=\"\",\"\",100*data[[#This Row],[CHI PHÍ]]/data[[#This Row],[DẶM]])","v":""}]
[null,"2012-05-09","Chuyến đi",{"v":11000,"d":"11,000"},"Riverside",{"v":11100,"d":"11,100"},"Ở nhà","Không",null,"",{"$f":"miles","v":100},{"$f":"IF(OR(LEN(data[[#This Row],[ĐỒNG HỒ ĐO. 2]]),data[[#This Row],[ĐỒNG HỒ ĐO. 1]]=\"\"),\"\",IFERROR(data[[#This Row],[DẶM]]/data[[#This Row],[GA-LÔNG]],\"\"))","v":""},{"$f":"IF(data[[#This Row],[MPG]]=\"\",\"\",100*data[[#This Row],[CHI PHÍ]]/data[[#This Row],[DẶM]])","v":""}]

{"sheet":"các phép tính","index":2,"n_rows":69,"n_cols":13,"rows_kept":69,"hidden":true}
["*** Trang này nên giữ ở chế độ ẩn***"]
[]
[]
[]
[]
[{"$nulls":8},{"$f":"OFFSET(I9,,secondAxis=\"chi phí nhiên liệu\")","v":"MPG"}]
[{"$nulls":12},1]
[{"$nulls":7},"Chuyến đi","Nhiên liệu","Nhiên liệu",null,"Second Axis:  ",{"$f":"REPT(\"MPG\",M7=1)&REPT(\"Chi phí Nhiên liệu\",M7=2)","v":"MPG"}]
[{"$nulls":7},"Số Dặm đã Đi","MPG","¢/DẶM"]
[null,null,"Số Dặm có thể Thanh toán lại:  ",{"$f":"SUMIFS(data[DẶM],data[THANH TOÁN LẠI],\"Có\",data[NGÀY],\">=\"&periodStart,data[NGÀY],\"<=\"&periodEnd)","v":820},null,1,{"$f":"periodStart","v":"2012-05-01"},{"$f":"SUMIFS(data[DẶM],data[NGÀY],G10,data[HOẠT ĐỘNG],$H$8)","v":162},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G10,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G10,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[null,null,"Tổng số Thanh toán lại  ",{"$f":"D10*ReimbursementPerMile/100","v":{"v":442.8,"d":"442.80 ₫"}},null,2,{"$f":"G10+1","v":"2012-05-02"},{"$f":"SUMIFS(data[DẶM],data[NGÀY],G11,data[HOẠT ĐỘNG],$H$8)","v":183},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G11,data[HOẠT ĐỘNG],$I$8),NA())","v":{"v":58.03571428571429,"d":"58.0"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G11,data[HOẠT ĐỘNG],$J$8),NA())","v":{"v":177344,"d":"177344.0"}}]
[{"$nulls":5},3,"2012-05-03",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G12,data[HOẠT ĐỘNG],$H$8)","v":227},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G12,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G12,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},4,"2012-05-04",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G13,data[HOẠT ĐỘNG],$H$8)","v":130},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G13,data[HOẠT ĐỘNG],$I$8),NA())","v":{"v":17.771084337349397,"d":"17.8"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G13,data[HOẠT ĐỘNG],$J$8),NA())","v":{"v":488200.6779661017,"d":"488200.7"}}]
[{"$nulls":5},5,"2012-05-05",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G14,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G14,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G14,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},6,"2012-05-06",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G15,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G15,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G15,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},7,"2012-05-07",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G16,data[HOẠT ĐỘNG],$H$8)","v":94},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G16,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G16,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},8,"2012-05-08",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G17,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G17,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G17,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},9,"2012-05-09",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G18,data[HOẠT ĐỘNG],$H$8)","v":131},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G18,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G18,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},10,"2012-05-10",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G19,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G19,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G19,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},11,"2012-05-11",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G20,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G20,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G20,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},12,"2012-05-12",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G21,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G21,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G21,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},13,"2012-05-13",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G22,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G22,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G22,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},14,"2012-05-14",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G23,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G23,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G23,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},15,"2012-05-15",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G24,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G24,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G24,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},16,"2012-05-16",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G25,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G25,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G25,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},17,"2012-05-17",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G26,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G26,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G26,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},18,"2012-05-18",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G27,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G27,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G27,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},19,"2012-05-19",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G28,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G28,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G28,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},20,"2012-05-20",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G29,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G29,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G29,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},21,"2012-05-21",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G30,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G30,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G30,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},22,"2012-05-22",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G31,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G31,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G31,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},23,"2012-05-23",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G32,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G32,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G32,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},24,"2012-05-24",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G33,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G33,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G33,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},25,"2012-05-25",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G34,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G34,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G34,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},26,"2012-05-26",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G35,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G35,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G35,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},27,"2012-05-27",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G36,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G36,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G36,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},28,"2012-05-28",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G37,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G37,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G37,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},29,"2012-05-29",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G38,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G38,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G38,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},30,"2012-05-30",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G39,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G39,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G39,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},31,"2012-05-31",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G40,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G40,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G40,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},32,"2012-06-01",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G41,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G41,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G41,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},33,"2012-06-02",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G42,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G42,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G42,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},34,{"$f":"G42+1","v":"2012-06-03"},{"$f":"SUMIFS(data[DẶM],data[NGÀY],G43,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G43,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G43,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},35,"2012-06-04",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G44,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G44,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G44,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},36,"2012-06-05",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G45,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G45,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G45,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},37,"2012-06-06",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G46,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G46,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G46,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},38,"2012-06-07",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G47,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G47,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G47,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},39,"2012-06-08",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G48,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G48,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G48,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},40,"2012-06-09",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G49,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G49,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G49,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},41,"2012-06-10",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G50,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G50,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G50,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},42,"2012-06-11",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G51,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G51,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G51,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},43,"2012-06-12",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G52,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G52,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G52,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},44,"2012-06-13",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G53,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G53,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G53,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},45,"2012-06-14",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G54,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G54,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G54,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},46,"2012-06-15",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G55,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G55,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G55,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},47,"2012-06-16",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G56,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G56,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G56,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},48,"2012-06-17",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G57,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G57,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G57,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},49,"2012-06-18",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G58,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G58,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G58,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},50,"2012-06-19",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G59,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G59,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G59,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},51,"2012-06-20",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G60,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G60,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G60,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},52,"2012-06-21",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G61,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G61,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G61,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},53,"2012-06-22",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G62,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G62,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G62,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},54,"2012-06-23",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G63,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G63,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G63,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},55,"2012-06-24",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G64,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G64,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G64,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},56,"2012-06-25",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G65,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G65,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G65,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},57,"2012-06-26",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G66,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G66,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G66,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},58,"2012-06-27",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G67,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G67,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G67,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},59,"2012-06-28",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G68,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G68,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G68,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]
[{"$nulls":5},60,"2012-06-29",{"$f":"SUMIFS(data[DẶM],data[NGÀY],G69,data[HOẠT ĐỘNG],$H$8)","v":0},{"$f":"IFERROR(AVERAGEIFS(data[MPG],data[NGÀY],G69,data[HOẠT ĐỘNG],$I$8),NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(AVERAGEIFS(data[¢/DẶM],data[NGÀY],G69,data[HOẠT ĐỘNG],$J$8),NA())","v":{"$error":"#N/A"}}]