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

{"sheet":"预算规划表","index":0,"n_rows":21,"n_cols":6,"rows_kept":21}
[null,"假期预算规划表"]
[]
[null,"各类别预算"]
[null,"类别","计划的预算","详细预算","剩余/（超出）"]
[null,"交通",{"v":750,"d":"¥750"},{"$f":"SUMIF(表2[类别],表1[[#This Row],[类别]],表2[金额])","v":{"v":720,"d":"¥720"}},{"$f":"IFERROR(表1[[#This Row],[计划的预算]]-表1[[#This Row],[详细预算]],\"\")","v":{"v":30,"d":"¥30"}}]
[null,"住宿",{"v":250,"d":"¥250"},{"$f":"SUMIF(表2[类别],表1[[#This Row],[类别]],表2[金额])","v":{"v":300,"d":"¥300"}},{"$f":"IFERROR(表1[[#This Row],[计划的预算]]-表1[[#This Row],[详细预算]],\"\")","v":{"v":-50,"d":"(¥50)"}}]
[null,"餐饮",{"v":100,"d":"¥100"},{"$f":"SUMIF(表2[类别],表1[[#This Row],[类别]],表2[金额])","v":{"v":80,"d":"¥80"}},{"$f":"IFERROR(表1[[#This Row],[计划的预算]]-表1[[#This Row],[详细预算]],\"\")","v":{"v":20,"d":"¥20"}}]
[null,"活动",{"v":500,"d":"¥500"},{"$f":"SUMIF(表2[类别],表1[[#This Row],[类别]],表2[金额])","v":{"v":500,"d":"¥500"}},{"$f":"IFERROR(表1[[#This Row],[计划的预算]]-表1[[#This Row],[详细预算]],\"\")","v":{"v":0,"d":"¥0"}}]
[null,"纪念品",{"v":50,"d":"¥50"},{"$f":"SUMIF(表2[类别],表1[[#This Row],[类别]],表2[金额])","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(表1[[#This Row],[计划的预算]]-表1[[#This Row],[详细预算]],\"\")","v":{"v":50,"d":"¥50"}}]
[null,"其他",{"v":50,"d":"¥50"},{"$f":"SUMIF(表2[类别],表1[[#This Row],[类别]],表2[金额])","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(表1[[#This Row],[计划的预算]]-表1[[#This Row],[详细预算]],\"\")","v":{"v":50,"d":"¥50"}}]
[null,"应急资金",{"v":200,"d":"¥200"},{"$f":"SUMIF(表2[类别],表1[[#This Row],[类别]],表2[金额])","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(表1[[#This Row],[计划的预算]]-表1[[#This Row],[详细预算]],\"\")","v":{"v":200,"d":"¥200"}}]
[null,"总预算",{"$f":"SUBTOTAL(109,表1[计划的预算])","v":{"v":1900,"d":"¥1,900"}},{"$f":"SUBTOTAL(109,表1[详细预算])","v":{"v":1600,"d":"¥1,600"}},{"$f":"SUBTOTAL(109,表1[剩余/（超出）])","v":{"v":300,"d":"¥300"}}]
[]
[null,"费用详细信息"]
[null,"说明","类别","数量","单价","金额"]
[null,"机票","交通",2,{"v":300,"d":"¥300"},{"$f":"IFERROR(表2[[#This Row],[数量]]*表2[[#This Row],[单价]],\"\")","v":{"v":600,"d":"¥600"}}]
[null,"公共汽车和出租车，2 天","交通",4,{"v":30,"d":"¥30"},{"$f":"IFERROR(表2[[#This Row],[数量]]*表2[[#This Row],[单价]],\"\")","v":{"v":120,"d":"¥120"}}]
[null,"酒店，2 晚","住宿",2,{"v":150,"d":"¥150"},{"$f":"IFERROR(表2[[#This Row],[数量]]*表2[[#This Row],[单价]],\"\")","v":{"v":300,"d":"¥300"}}]
[null,"餐饮，2 天","餐饮",2,{"v":40,"d":"¥40"},{"$f":"IFERROR(表2[[#This Row],[数量]]*表2[[#This Row],[单价]],\"\")","v":{"v":80,"d":"¥80"}}]
[null,"第 1 天，音乐会门票","活动",2,{"v":250,"d":"¥250"},{"$f":"IFERROR(表2[[#This Row],[数量]]*表2[[#This Row],[单价]],\"\")","v":{"v":500,"d":"¥500"}}]
[null,"输入其他费用项",{"$nulls":3},{"$f":"IFERROR(表2[[#This Row],[数量]]*表2[[#This Row],[单价]],\"\")","v":{"v":0,"d":"¥0"}}]