{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Expense Budget"],"not_rendered":{"charts":2,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Expense Budget","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,"Expense Budget",{"$nulls":3},"CONTOSO, 2013"]
[]
[]
[null," PERSONNEL BUDGET"]
{"$rows_empty":7}
[null,"STATUS","PERSONNEL","BUDGET","ACTUAL","DIFFERENCE ($)","DIFFERENCE (%)"]
[null,{"$f":"IFERROR(tblPersonnelExpenses[[#This Row],[ACTUAL]]/tblPersonnelExpenses[[#This Row],[BUDGET]],\"\")","v":{"v":1.13,"d":"$1.13"}},"Office",{"v":500,"d":"$500.00"},{"v":565,"d":"$565.00"},{"$f":"tblPersonnelExpenses[[#This Row],[BUDGET]]-tblPersonnelExpenses[[#This Row],[ACTUAL]]","v":{"v":-65,"d":"-$65.00"}},{"$f":"IFERROR(tblPersonnelExpenses[DIFFERENCE ($)]/tblPersonnelExpenses[BUDGET],\"\")","v":{"v":-0.13,"d":"-13%"}}]
[null,{"$f":"IFERROR(tblPersonnelExpenses[[#This Row],[ACTUAL]]/tblPersonnelExpenses[[#This Row],[BUDGET]],\"\")","v":{"v":1.2,"d":"$1.20"}},"Store",{"v":125,"d":"$125.00"},{"v":150,"d":"$150.00"},{"$f":"tblPersonnelExpenses[[#This Row],[BUDGET]]-tblPersonnelExpenses[[#This Row],[ACTUAL]]","v":{"v":-25,"d":"-$25.00"}},{"$f":"IFERROR(tblPersonnelExpenses[DIFFERENCE ($)]/tblPersonnelExpenses[BUDGET],\"\")","v":{"v":-0.2,"d":"-20%"}}]
[null,{"$f":"IFERROR(tblPersonnelExpenses[[#This Row],[ACTUAL]]/tblPersonnelExpenses[[#This Row],[BUDGET]],\"\")","v":{"v":1,"d":"$1.00"}},"Salespeople",{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"$f":"tblPersonnelExpenses[[#This Row],[BUDGET]]-tblPersonnelExpenses[[#This Row],[ACTUAL]]","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(tblPersonnelExpenses[DIFFERENCE ($)]/tblPersonnelExpenses[BUDGET],\"\")","v":{"v":0,"d":"0%"}}]
[null,{"$f":"IFERROR(tblPersonnelExpenses[[#This Row],[ACTUAL]]/tblPersonnelExpenses[[#This Row],[BUDGET]],\"\")","v":{"v":0.9,"d":"$0.90"}},"Other",{"v":100,"d":"$100.00"},{"v":90,"d":"$90.00"},{"$f":"tblPersonnelExpenses[[#This Row],[BUDGET]]-tblPersonnelExpenses[[#This Row],[ACTUAL]]","v":{"v":10,"d":"$10.00"}},{"$f":"IFERROR(tblPersonnelExpenses[DIFFERENCE ($)]/tblPersonnelExpenses[BUDGET],\"\")","v":{"v":0.1,"d":"10%"}}]
[]
[]
[null," OPERATING BUDGET"]
{"$rows_empty":7}
[null,"STATUS","OPERATING","BUDGET","ACTUAL","DIFFERENCE ($)","DIFFERENCE (%)"]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[ACTUAL]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":{"v":0.98,"d":"$0.98"}},"Advertising",{"v":250,"d":"$250.00"},{"v":245,"d":"$245.00"},{"$f":"tblOperatingExpenses[[#This Row],[BUDGET]]-tblOperatingExpenses[[#This Row],[ACTUAL]]","v":{"v":5,"d":"$5.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[DIFFERENCE ($)]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":{"v":0.02,"d":"2%"}}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[ACTUAL]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":{"v":1.2,"d":"$1.20"}},"Debts",{"v":125,"d":"$125.00"},{"v":150,"d":"$150.00"},{"$f":"tblOperatingExpenses[[#This Row],[BUDGET]]-tblOperatingExpenses[[#This Row],[ACTUAL]]","v":{"v":-25,"d":"-$25.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[DIFFERENCE ($)]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":{"v":-0.2,"d":"-20%"}}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[ACTUAL]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":{"v":1,"d":"$1.00"}},"Benefits",{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"$f":"tblOperatingExpenses[[#This Row],[BUDGET]]-tblOperatingExpenses[[#This Row],[ACTUAL]]","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[DIFFERENCE ($)]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":{"v":0,"d":"0%"}}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[ACTUAL]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":{"v":0.9,"d":"$0.90"}},"Supplies",{"v":100,"d":"$100.00"},{"v":90,"d":"$90.00"},{"$f":"tblOperatingExpenses[[#This Row],[BUDGET]]-tblOperatingExpenses[[#This Row],[ACTUAL]]","v":{"v":10,"d":"$10.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[DIFFERENCE ($)]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":{"v":0.1,"d":"10%"}}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[ACTUAL]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""},"Postage",null,null,{"$f":"tblOperatingExpenses[[#This Row],[BUDGET]]-tblOperatingExpenses[[#This Row],[ACTUAL]]","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[DIFFERENCE ($)]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[ACTUAL]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""},"Rent or mortgage",null,null,{"$f":"tblOperatingExpenses[[#This Row],[BUDGET]]-tblOperatingExpenses[[#This Row],[ACTUAL]]","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[DIFFERENCE ($)]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[ACTUAL]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""},"Sales expenses",null,null,{"$f":"tblOperatingExpenses[[#This Row],[BUDGET]]-tblOperatingExpenses[[#This Row],[ACTUAL]]","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[DIFFERENCE ($)]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[ACTUAL]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""},"Taxes",null,null,{"$f":"tblOperatingExpenses[[#This Row],[BUDGET]]-tblOperatingExpenses[[#This Row],[ACTUAL]]","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[DIFFERENCE ($)]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[ACTUAL]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""},"Utilities",null,null,{"$f":"tblOperatingExpenses[[#This Row],[BUDGET]]-tblOperatingExpenses[[#This Row],[ACTUAL]]","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[DIFFERENCE ($)]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[ACTUAL]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""},"Other",null,null,{"$f":"tblOperatingExpenses[[#This Row],[BUDGET]]-tblOperatingExpenses[[#This Row],[ACTUAL]]","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[DIFFERENCE ($)]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[ACTUAL]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""},"Insurance",null,null,{"$f":"tblOperatingExpenses[[#This Row],[BUDGET]]-tblOperatingExpenses[[#This Row],[ACTUAL]]","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[DIFFERENCE ($)]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[ACTUAL]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""},"Interest",null,null,{"$f":"tblOperatingExpenses[[#This Row],[BUDGET]]-tblOperatingExpenses[[#This Row],[ACTUAL]]","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[DIFFERENCE ($)]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[ACTUAL]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""},"Telephone",null,null,{"$f":"tblOperatingExpenses[[#This Row],[BUDGET]]-tblOperatingExpenses[[#This Row],[ACTUAL]]","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[DIFFERENCE ($)]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[ACTUAL]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""},"Maintenance and repairs",null,null,{"$f":"tblOperatingExpenses[[#This Row],[BUDGET]]-tblOperatingExpenses[[#This Row],[ACTUAL]]","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[DIFFERENCE ($)]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[ACTUAL]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""},"Legal fees",null,null,{"$f":"tblOperatingExpenses[[#This Row],[BUDGET]]-tblOperatingExpenses[[#This Row],[ACTUAL]]","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[DIFFERENCE ($)]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[ACTUAL]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""},"Depreciation",null,null,{"$f":"tblOperatingExpenses[[#This Row],[BUDGET]]-tblOperatingExpenses[[#This Row],[ACTUAL]]","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[DIFFERENCE ($)]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[ACTUAL]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""},"Shipping",null,null,{"$f":"tblOperatingExpenses[[#This Row],[BUDGET]]-tblOperatingExpenses[[#This Row],[ACTUAL]]","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[DIFFERENCE ($)]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[ACTUAL]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""},"Storage",null,null,{"$f":"tblOperatingExpenses[[#This Row],[BUDGET]]-tblOperatingExpenses[[#This Row],[ACTUAL]]","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[DIFFERENCE ($)]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[ACTUAL]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""},"Other",null,null,{"$f":"tblOperatingExpenses[[#This Row],[BUDGET]]-tblOperatingExpenses[[#This Row],[ACTUAL]]","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[DIFFERENCE ($)]]/tblOperatingExpenses[[#This Row],[BUDGET]],\"\")","v":""}]
[null,null,"Total Expenses",{"$f":"SUBTOTAL(109,tblOperatingExpenses[BUDGET],tblPersonnelExpenses[BUDGET])","v":{"v":1400,"d":"$1,400.00"}},{"$f":"SUBTOTAL(109,tblOperatingExpenses[ACTUAL],tblPersonnelExpenses[ACTUAL])","v":{"v":1490,"d":"$1,490.00"}},{"$f":"SUBTOTAL(109,tblOperatingExpenses[DIFFERENCE ($)],tblPersonnelExpenses[DIFFERENCE ($)])","v":{"v":-90,"d":"-$90.00"}},{"$f":"IFERROR(SUM(tblOperatingExpenses[[#Totals],[DIFFERENCE ($)]]/tblOperatingExpenses[[#Totals],[BUDGET]]),\"\")","v":{"v":-0.06428571428571428,"d":"-6%"}}]