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

{"sheet":"费用预算","index":0,"n_rows":47,"n_cols":7,"rows_kept":47,"merged":[[0,1,0,4],[0,5,0,6],[16,1,16,6],[47,1,47,6]]}
[null,"费用预算",{"$nulls":3}," 康浦, 2013"]
[]
[]
[null,"  人事预算"]
{"$rows_empty":7}
[null,"状态","人员","预算","实际","差额（美元）","差额（百分比）"]
[null,{"$f":"IFERROR(tbl人事费用[[#This Row],[实际]]/tbl人事费用[[#This Row],[预算]],\"\")","v":{"v":1.13,"d":"!$1.13"}},"办公室",{"v":5000,"d":"¥5,000.00"},{"v":5650,"d":"¥5,650.00"},{"$f":"tbl人事费用[[#This Row],[预算]]-tbl人事费用[[#This Row],[实际]]","v":{"v":-650,"d":"!-¥650.00"}},{"$f":"IFERROR(tbl人事费用[差额（美元）]/tbl人事费用[预算],\"\")","v":{"v":-0.13,"d":"-13%"}}]
[null,{"$f":"IFERROR(tbl人事费用[[#This Row],[实际]]/tbl人事费用[[#This Row],[预算]],\"\")","v":{"v":1.2,"d":"!$1.20"}},"商场",{"v":1250,"d":"¥1,250.00"},{"v":1500,"d":"¥1,500.00"},{"$f":"tbl人事费用[[#This Row],[预算]]-tbl人事费用[[#This Row],[实际]]","v":{"v":-250,"d":"!-¥250.00"}},{"$f":"IFERROR(tbl人事费用[差额（美元）]/tbl人事费用[预算],\"\")","v":{"v":-0.2,"d":"-20%"}}]
[null,{"$f":"IFERROR(tbl人事费用[[#This Row],[实际]]/tbl人事费用[[#This Row],[预算]],\"\")","v":{"v":1,"d":"!$1.00"}},"售货员",{"v":1000,"d":"¥1,000.00"},{"v":1000,"d":"¥1,000.00"},{"$f":"tbl人事费用[[#This Row],[预算]]-tbl人事费用[[#This Row],[实际]]","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(tbl人事费用[差额（美元）]/tbl人事费用[预算],\"\")","v":{"v":0,"d":"0%"}}]
[null,{"$f":"IFERROR(tbl人事费用[[#This Row],[实际]]/tbl人事费用[[#This Row],[预算]],\"\")","v":{"v":0.9,"d":"!$0.90"}},"其他",{"v":1000,"d":"¥1,000.00"},{"v":900,"d":"¥900.00"},{"$f":"tbl人事费用[[#This Row],[预算]]-tbl人事费用[[#This Row],[实际]]","v":{"v":100,"d":"¥100.00"}},{"$f":"IFERROR(tbl人事费用[差额（美元）]/tbl人事费用[预算],\"\")","v":{"v":0.1,"d":"10%"}}]
[]
[]
[null,"运营预算"]
{"$rows_empty":7}
[null,"状态","运营","预算","实际","差额（美元）","差额（百分比）"]
[null,{"$f":"IFERROR(tbl_运营费用[[#This Row],[实际]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":{"v":0.98,"d":"!$0.98"}},"广告",{"v":2500,"d":"¥2,500.00"},{"v":2450,"d":"¥2,450.00"},{"$f":"tbl_运营费用[[#This Row],[预算]]-tbl_运营费用[[#This Row],[实际]]","v":{"v":50,"d":"¥50.00"}},{"$f":"IFERROR(tbl_运营费用[[#This Row],[差额（美元）]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":{"v":0.02,"d":"2%"}}]
[null,{"$f":"IFERROR(tbl_运营费用[[#This Row],[实际]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":{"v":1.2,"d":"!$1.20"}},"债务",{"v":1250,"d":"¥1,250.00"},{"v":1500,"d":"¥1,500.00"},{"$f":"tbl_运营费用[[#This Row],[预算]]-tbl_运营费用[[#This Row],[实际]]","v":{"v":-250,"d":"!-¥250.00"}},{"$f":"IFERROR(tbl_运营费用[[#This Row],[差额（美元）]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":{"v":-0.2,"d":"-20%"}}]
[null,{"$f":"IFERROR(tbl_运营费用[[#This Row],[实际]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":{"v":1,"d":"!$1.00"}},"福利",{"v":1000,"d":"¥1,000.00"},{"v":1000,"d":"¥1,000.00"},{"$f":"tbl_运营费用[[#This Row],[预算]]-tbl_运营费用[[#This Row],[实际]]","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(tbl_运营费用[[#This Row],[差额（美元）]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":{"v":0,"d":"0%"}}]
[null,{"$f":"IFERROR(tbl_运营费用[[#This Row],[实际]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":{"v":0.9,"d":"!$0.90"}},"用品",{"v":1000,"d":"¥1,000.00"},{"v":900,"d":"¥900.00"},{"$f":"tbl_运营费用[[#This Row],[预算]]-tbl_运营费用[[#This Row],[实际]]","v":{"v":100,"d":"¥100.00"}},{"$f":"IFERROR(tbl_运营费用[[#This Row],[差额（美元）]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":{"v":0.1,"d":"10%"}}]
[null,{"$f":"IFERROR(tbl_运营费用[[#This Row],[实际]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""},"邮资",null,null,{"$f":"tbl_运营费用[[#This Row],[预算]]-tbl_运营费用[[#This Row],[实际]]","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(tbl_运营费用[[#This Row],[差额（美元）]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tbl_运营费用[[#This Row],[实际]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""},"租金或抵押贷款",null,null,{"$f":"tbl_运营费用[[#This Row],[预算]]-tbl_运营费用[[#This Row],[实际]]","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(tbl_运营费用[[#This Row],[差额（美元）]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tbl_运营费用[[#This Row],[实际]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""},"销售费用",null,null,{"$f":"tbl_运营费用[[#This Row],[预算]]-tbl_运营费用[[#This Row],[实际]]","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(tbl_运营费用[[#This Row],[差额（美元）]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tbl_运营费用[[#This Row],[实际]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""},"税款",null,null,{"$f":"tbl_运营费用[[#This Row],[预算]]-tbl_运营费用[[#This Row],[实际]]","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(tbl_运营费用[[#This Row],[差额（美元）]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tbl_运营费用[[#This Row],[实际]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""},"水电费",null,null,{"$f":"tbl_运营费用[[#This Row],[预算]]-tbl_运营费用[[#This Row],[实际]]","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(tbl_运营费用[[#This Row],[差额（美元）]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tbl_运营费用[[#This Row],[实际]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""},"其他",null,null,{"$f":"tbl_运营费用[[#This Row],[预算]]-tbl_运营费用[[#This Row],[实际]]","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(tbl_运营费用[[#This Row],[差额（美元）]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tbl_运营费用[[#This Row],[实际]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""},"保险",null,null,{"$f":"tbl_运营费用[[#This Row],[预算]]-tbl_运营费用[[#This Row],[实际]]","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(tbl_运营费用[[#This Row],[差额（美元）]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tbl_运营费用[[#This Row],[实际]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""},"利息",null,null,{"$f":"tbl_运营费用[[#This Row],[预算]]-tbl_运营费用[[#This Row],[实际]]","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(tbl_运营费用[[#This Row],[差额（美元）]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tbl_运营费用[[#This Row],[实际]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""},"电话",null,null,{"$f":"tbl_运营费用[[#This Row],[预算]]-tbl_运营费用[[#This Row],[实际]]","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(tbl_运营费用[[#This Row],[差额（美元）]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tbl_运营费用[[#This Row],[实际]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""},"维护和修理",null,null,{"$f":"tbl_运营费用[[#This Row],[预算]]-tbl_运营费用[[#This Row],[实际]]","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(tbl_运营费用[[#This Row],[差额（美元）]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tbl_运营费用[[#This Row],[实际]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""},"法律费用",null,null,{"$f":"tbl_运营费用[[#This Row],[预算]]-tbl_运营费用[[#This Row],[实际]]","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(tbl_运营费用[[#This Row],[差额（美元）]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tbl_运营费用[[#This Row],[实际]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""},"折旧",null,null,{"$f":"tbl_运营费用[[#This Row],[预算]]-tbl_运营费用[[#This Row],[实际]]","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(tbl_运营费用[[#This Row],[差额（美元）]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tbl_运营费用[[#This Row],[实际]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""},"发货",null,null,{"$f":"tbl_运营费用[[#This Row],[预算]]-tbl_运营费用[[#This Row],[实际]]","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(tbl_运营费用[[#This Row],[差额（美元）]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tbl_运营费用[[#This Row],[实际]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""},"存储",null,null,{"$f":"tbl_运营费用[[#This Row],[预算]]-tbl_运营费用[[#This Row],[实际]]","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(tbl_运营费用[[#This Row],[差额（美元）]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tbl_运营费用[[#This Row],[实际]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""},"其他",null,null,{"$f":"tbl_运营费用[[#This Row],[预算]]-tbl_运营费用[[#This Row],[实际]]","v":{"v":0,"d":"¥0.00"}},{"$f":"IFERROR(tbl_运营费用[[#This Row],[差额（美元）]]/tbl_运营费用[[#This Row],[预算]],\"\")","v":""}]
[null,null,"费用总额",{"$f":"SUBTOTAL(109,tbl_运营费用[预算],tbl人事费用[预算])","v":{"v":14000,"d":"¥14,000.00"}},{"$f":"SUBTOTAL(109,tbl_运营费用[实际],tbl人事费用[实际])","v":{"v":14900,"d":"¥14,900.00"}},{"$f":"SUBTOTAL(109,tbl_运营费用[差额（美元）],tbl人事费用[差额（美元）])","v":{"v":-900,"d":"!-¥900.00"}},{"$f":"IFERROR(SUM(tbl_运营费用[[#Totals],[差额（美元）]]/tbl_运营费用[[#Totals],[预算]]),\"\")","v":{"v":-0.06428571428571428,"d":"-6%"}}]