{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Expenses","Category"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Expenses","index":0,"n_rows":25,"n_cols":7,"rows_kept":25,"merged":[[0,1,0,5],[1,1,1,6]]}
[null,"EXPENSES BUDGET",{"$nulls":4},{"$f":"TODAY()","v":"2018-06-18"}]
[null,"Company name"]
[null,"Expense","Category","Budget","Actual","Difference ($)","Difference (%)"]
[null,"Advertising","Operating",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Debts","Operating",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Benefits","Operating",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Supplies","Operating",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Postage","Operating",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Rent or mortgage","Operating",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Sales expenses","Operating",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Taxes","Operating",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Utilities","Operating",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Other","Operating",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Insurance","Operating",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Interest","Operating",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Telephone No.","Operating",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Maintenance and repairs","Operating",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Legal fees","Operating",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Depreciation","Operating",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Shipping","Operating",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Storage","Operating",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Shop","Personal",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Salespeople","Personal",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Other","Personal",null,null,{"$f":"IFERROR(SUM(Expenses[Budget]-Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]/Expenses[Budget]),\"\")","v":""}]
[null,"Total expenses",null,{"$f":"IFERROR(SUM(Expenses[Budget]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Actual]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[Difference ($)]), \"\")","v":0},{"$f":"IFERROR(SUM(Expenses[[#Totals],[Difference ($)]]/Expenses[[#Totals],[Budget]]),\"\")","v":""}]

{"sheet":"Category","index":1,"n_rows":4,"n_cols":2,"rows_kept":4}
[null,"Category lookup"]
[null,"Category"]
[null,"Operating"]
[null,"Personal"]