{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["预算规划表"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

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