{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["费用报表"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"费用报表","index":0,"n_rows":45,"n_cols":10,"rows_kept":45,"merged":[[18,1,18,9],[27,1,27,9],[35,1,35,9],[40,1,43,4]]}
["公司名称"]
["费用报表"]
[]
[null,"员工：","Kim Abercrombie",{"$nulls":3},"签发方："]
[null,"部门：","销售"]
[null,"周末：","2013-03-07",{"$nulls":3},"日期："]
[null,"里程运价率：",{"v":6.7,"d":"¥6.70"}]
[]
[null,null,{"$f":"UPPER(TEXT(C10,\"aaaa\"))","v":"星期五"},"星期六","星期日","星期一","星期二","星期三","星期四"]
[null,"交通",{"$f":"周末-6","v":"2013-03-01"},{"$f":"周末-5","v":"2013-03-02"},{"$f":"周末-4","v":"2013-03-03"},{"$f":"周末-3","v":"2013-03-04"},{"$f":"周末-2","v":"2013-03-05"},{"$f":"周末-1","v":"2013-03-06"},{"$f":"周末","v":"2013-03-07"},"总计"]
[null,"行驶里程",{"v":145,"d":"145 "},{"$nulls":6},{"$f":"SUM(交通[[#This Row],[Day 1]:[Day 7]])","v":{"v":145,"d":"145 "}}]
[null,"英里报销",{"$f":"C11*里程运价率","v":{"v":971.5,"d":"¥971.50"}},{"$f":"D11*里程运价率","v":{"v":0,"d":"¥0.00"}},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"$f":"SUM(交通[[#This Row],[Day 1]:[Day 7]])","v":{"v":971.5,"d":"¥971.50"}}]
[null,"停车收费",{"$nulls":3},{"v":170,"d":"¥170.00"},{"$nulls":3},{"$f":"SUM(交通[[#This Row],[Day 1]:[Day 7]])","v":{"v":170,"d":"¥170.00"}}]
[null,"汽车租赁",{"v":790,"d":"¥790.00"},null,null,{"v":790,"d":"¥790.00"},{"$nulls":3},{"$f":"SUM(交通[[#This Row],[Day 1]:[Day 7]])","v":{"v":1580,"d":"¥1,580.00"}}]
[null,"出租车/轿车",{"$nulls":7},{"$f":"SUM(交通[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"¥0.00"}}]
[null,"其他（火车或公共汽车）",{"$nulls":7},{"$f":"SUM(交通[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"¥0.00"}}]
[null,"机票",{"$nulls":3},{"v":2350,"d":"¥2,350.00"},{"$nulls":3},{"$f":"SUM(交通[[#This Row],[Day 1]:[Day 7]])","v":{"v":2350,"d":"¥2,350.00"}}]
[null,"总计",{"$f":"SUBTOTAL(109,C12:C17)","v":{"v":1761.5,"d":"¥1,761.50"}},{"$f":"SUBTOTAL(109,D12:D17)","v":{"v":0,"d":"¥0.00"}},null,{"$f":"SUBTOTAL(109,F12:F17)","v":{"v":3310,"d":"¥3,310.00"}},{"$f":"SUBTOTAL(109,G12:G17)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,H12:H17)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,I12:I17)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(J12:J17)","v":{"v":5071.5,"d":"¥5,071.50"}}]
[]
[null,"住宿和餐饮"]
[null,"住宿",{"v":1450,"d":"¥1,450.00"},{"$nulls":6},{"$f":"SUM(住宿餐饮[[#This Row],[Day 1]:[Day 7]])","v":{"v":1450,"d":"¥1,450.00"}}]
[null,"早餐",{"v":114.9,"d":"¥114.90"},{"$nulls":6},{"$f":"SUM(住宿餐饮[[#This Row],[Day 1]:[Day 7]])","v":{"v":114.9,"d":"¥114.90"}}]
[null,"午餐",{"v":120,"d":"¥120.00"},{"$nulls":6},{"$f":"SUM(住宿餐饮[[#This Row],[Day 1]:[Day 7]])","v":{"v":120,"d":"¥120.00"}}]
[null,"晚餐",{"v":170,"d":"¥170.00"},{"$nulls":6},{"$f":"SUM(住宿餐饮[[#This Row],[Day 1]:[Day 7]])","v":{"v":170,"d":"¥170.00"}}]
[null,"零食",{"$f":"C24*里程运价率","v":{"v":1139,"d":"¥1,139.00"}},{"$nulls":6},{"$f":"SUM(住宿餐饮[[#This Row],[Day 1]:[Day 7]])","v":{"v":1139,"d":"¥1,139.00"}}]
[null,"餐费小计",{"$f":"SUM(C22:C24)","v":{"v":404.9,"d":"¥404.90"}},{"$f":"SUM(D22:D24)","v":{"v":0,"d":"¥0.00"}},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"$f":"SUM(住宿餐饮[[#This Row],[Day 1]:[Day 7]])","v":{"v":404.9,"d":"¥404.90"}}]
[null,"总计",{"$f":"SUBTOTAL(109,C21,C26)","v":{"v":1854.9,"d":"¥1,854.90"}},{"$f":"SUBTOTAL(109,D21,D26)","v":{"v":0,"d":"¥0.00"}},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"$f":"SUBTOTAL(109,J21,J26)","v":{"v":1854.9,"d":"¥1,854.90"}}]
[]
[null,"杂项"]
[null,"用品",{"$nulls":7},{"$f":"SUM(杂项[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"¥0.00"}}]
[null,"设备",{"$nulls":7},{"$f":"SUM(杂项[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"¥0.00"}}]
[null,"电话、传真、网络",{"$nulls":7},{"$f":"SUM(杂项[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"¥0.00"}}]
[null,"其他*",{"$nulls":7},{"$f":"SUM(杂项[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"¥0.00"}}]
[null,"娱乐*",{"$nulls":3},{"v":1990,"d":"¥1,990.00"},{"$nulls":3},{"$f":"SUM(杂项[[#This Row],[Day 1]:[Day 7]])","v":{"v":1990,"d":"¥1,990.00"}}]
[null,"总计",{"$f":"SUBTOTAL(109,杂项[Day 1])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,杂项[Day 2])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,杂项[Day 3])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,杂项[Day 4])","v":{"v":1990,"d":"¥1,990.00"}},{"$f":"SUBTOTAL(109,杂项[Day 5])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,杂项[Day 6])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,杂项[Day 7])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,杂项[Total])","v":{"v":1990,"d":"¥1,990.00"}}]
[]
[null,"总计",{"$f":"SUM(杂项[[#Totals],[Day 1]],住宿餐饮[[#Totals],[Day 1]],交通[[#Totals],[Day 1]])","v":{"v":3616.4,"d":"¥3,616.40"}},{"$f":"SUM(杂项[[#Totals],[Day 2]],住宿餐饮[[#Totals],[Day 2]],交通[[#Totals],[Day 2]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(杂项[[#Totals],[Day 3]],住宿餐饮[[#Totals],[Day 3]],交通[[#Totals],[Day 3]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(杂项[[#Totals],[Day 4]],住宿餐饮[[#Totals],[Day 4]],交通[[#Totals],[Day 4]])","v":{"v":5300,"d":"¥5,300.00"}},{"$f":"SUM(杂项[[#Totals],[Day 5]],住宿餐饮[[#Totals],[Day 5]],交通[[#Totals],[Day 5]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(杂项[[#Totals],[Day 6]],住宿餐饮[[#Totals],[Day 6]],交通[[#Totals],[Day 6]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(杂项[[#Totals],[Day 7]],住宿餐饮[[#Totals],[Day 7]],交通[[#Totals],[Day 7]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(杂项[[#Totals],[Total]],住宿餐饮[[#Totals],[Total]],交通[[#Totals],[Total]])","v":{"v":8916.4,"d":"¥8,916.40"}}]
[]
[{"$nulls":9},"总支出"]
[null,"*商业目的“娱乐支出”和其他项目：",{"$nulls":7},{"$f":"SUM(J18,J27,J35)","v":{"v":8916.4,"d":"¥8,916.40"}}]
[{"$nulls":9},"预付"]
[]
[{"$nulls":9},"总报销"]
[{"$nulls":9},{"$f":"J40-J42","v":{"v":8916.4,"d":"¥8,916.40"}}]
[{"$nulls":9},"请附上所有收据。"]