{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["出差预算"],"not_rendered":{"charts":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"出差预算","index":0,"n_rows":16,"n_cols":7,"rows_kept":16,"merged":[[0,1,0,6],[1,1,1,2],[1,3,1,4],[1,5,2,5],[2,1,2,2],[2,3,2,4],[3,1,3,2],[3,3,3,4]]}
[null,"出差预算"]
[null,"出差预算目标额",null,{"v":2500,"d":"¥2,500.00"},null,null,{"$f":"D3","v":{"v":2369.3599999999997,"d":"¥2,369.36"}}]
[null,"出差总费用",null,{"$f":"SUBTOTAL(9,数据[金额])","v":{"v":2369.3599999999997,"d":"¥2,369.36"}},null,null,{"$f":"D2","v":{"v":2500,"d":"¥2,500.00"}}]
[null,{"$f":"IF(D2>D3,\"在以下日期前你在预算之内\",\"在以下日期前你超出预算\")","v":"在以下日期前你在预算之内"},null,{"$f":"(D2-D3)","v":{"v":130.64000000000033,"d":"¥130.64"}}]
[null,"项目​​","说明","费用","数量","金额","备注"]
[null,"机票","门票",{"v":300,"d":"¥300.00"},1,{"$f":"数据[[#This Row],[数量]]*数据[[#This Row],[费用]]","v":{"v":300,"d":"¥300.00"}}]
[null,"机票","门票",{"v":350,"d":"¥350.00"},1,{"$f":"数据[[#This Row],[数量]]*数据[[#This Row],[费用]]","v":{"v":350,"d":"¥350.00"}}]
[null,"住宿","会议室",{"v":125,"d":"¥125.00"},3,{"$f":"数据[[#This Row],[数量]]*数据[[#This Row],[费用]]","v":{"v":375,"d":"¥375.00"}}]
[null,"住宿","会议室",{"v":150,"d":"¥150.00"},3,{"$f":"数据[[#This Row],[数量]]*数据[[#This Row],[费用]]","v":{"v":450,"d":"¥450.00"}}]
[null,"租车","每天的费用",{"v":52,"d":"¥52.00"},6,{"$f":"数据[[#This Row],[数量]]*数据[[#This Row],[费用]]","v":{"v":312,"d":"¥312.00"}}]
[null,"燃气","每加仑的费用",{"v":1.74,"d":"¥1.74"},14,{"$f":"数据[[#This Row],[数量]]*数据[[#This Row],[费用]]","v":{"v":24.36,"d":"¥24.36"}}]
[null,"娱乐","金额",{"v":130,"d":"¥130.00"},1,{"$f":"数据[[#This Row],[数量]]*数据[[#This Row],[费用]]","v":{"v":130,"d":"¥130.00"}}]
[null,"礼品","数量",{"v":85,"d":"¥85.00"},1,{"$f":"数据[[#This Row],[数量]]*数据[[#This Row],[费用]]","v":{"v":85,"d":"¥85.00"}}]
[null,"杂项","金额",{"v":55,"d":"¥55.00"},1,{"$f":"数据[[#This Row],[数量]]*数据[[#This Row],[费用]]","v":{"v":55,"d":"¥55.00"}}]
[null,"食物","每天的费用",{"v":48,"d":"¥48.00"},6,{"$f":"数据[[#This Row],[数量]]*数据[[#This Row],[费用]]","v":{"v":288,"d":"¥288.00"}}]
[null,"汇总",{"$nulls":3},{"$f":"SUBTOTAL(109,数据[金额])","v":{"v":2369.3599999999997,"d":"¥2,369.36"}}]