{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Department Budget"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"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":"Department Budget","index":0,"n_rows":73,"n_cols":5,"rows_kept":73,"cut":false,"hidden":false,"merged":[[59,6,62,6],[64,6,68,6],[72,1,72,4],[8,6,16,6],[20,6,33,6],[35,6,42,6],[49,6,52,6],[54,6,57,6]]}
[null,"DEPARTMENT BUDGET TEMPLATE"]
[]
[null,null,"CURRENT BUDGET","PREVIOUS YEAR BUDGET","% OF CHANGE"]
[null,"Total Income",{"$f":"C18","v":100000},{"$f":"D18","v":111000},{"$f":"((D4-C4)/C4)","v":0.11}]
[null,"Total Expenses",{"$f":"C71","v":50000},{"$f":"D71","v":45000},{"$f":"((D5-C5)/C5)","v":-0.1}]
[null,"NET Income",{"$f":"C4-C5","v":50000},{"$f":"D4-D5","v":66000},{"$f":"((D6-C6)/C6)","v":0.32}]
[]
[null,"INCOME","CURRENT BUDGET","PREVIOUS YEAR BUDGET","% OF CHANGE"]
[]
[null,"Salary/Wages",100000,111000,{"$f":"((D10-C10)/C10)","v":0.11}]
[null,"Interest Income",0,0,{"$f":"((D11-C11)/C11)","v":{"$error":"#DIV/0!"}}]
[null,"Dividends",0,0,{"$f":"((D12-C12)/C12)","v":{"$error":"#DIV/0!"}}]
[null,"Refunds/Reimbursements",0,0,{"$error":"#DIV/0!"}]
[null,"Business",0,0,{"$error":"#DIV/0!"}]
[null,"Pension",0,0,{"$error":"#DIV/0!"}]
[null,"Miscellaneous",0,0,{"$error":"#DIV/0!"}]
[]
[null,"TOTAL",{"$f":"SUM(C10:C16)","v":100000},{"$f":"SUM(D10:D16)","v":111000}]
[]
[null,"EXPENSES","CURRENT BUDGET","PREVIOUS YEAR BUDGET","% OF CHANGE"]
[null,"GENERAL & ADMIN"]
[null,"Wages & Salaries",50000,45000,{"$f":"((D22-C22)/C22)","v":-0.1}]
[null,"Outside Services",0,0,{"$f":"((D23-C23)/C23)","v":{"$error":"#DIV/0!"}}]
[null,"Supplies",0,0,{"$f":"((D24-C24)/C24)","v":{"$error":"#DIV/0!"}}]
[null,"Meals & Entertainment",0,0,{"$error":"#DIV/0!"}]
[null,"Rent",0,0,{"$error":"#DIV/0!"}]
[null,"Telephone",0,0,{"$error":"#DIV/0!"}]
[null,"Utilities",0,0,{"$error":"#DIV/0!"}]
[null,"Depreciation",0,0,{"$error":"#DIV/0!"}]
[null,"Insurance",0,0,{"$error":"#DIV/0!"}]
[null,"Repairs/Maintenance",0,0,{"$error":"#DIV/0!"}]
[null,"Maintenance/Improvements",0,0,{"$error":"#DIV/0!"}]
[null,"Other",0,0,{"$error":"#DIV/0!"}]
[null,null,{"$f":"SUM(C22:C33)","v":50000},{"$f":"SUM(D22:D33)","v":45000},{"$f":"SUM(E22:E33)","v":{"$error":"#DIV/0!"}}]
[null,"SALES & MARKETING"]
[null,"Advertising",0,0,{"$f":"((D36-C36)/C36)","v":{"$error":"#DIV/0!"}}]
[null,"Direct Marketing",0,0,{"$f":"((D37-C37)/C37)","v":{"$error":"#DIV/0!"}}]
[null,"Print Advertising",0,0,{"$error":"#DIV/0!"}]
[null,"Events/Tradeshows/Sponsorships",0,0,{"$error":"#DIV/0!"}]
[null,"Marketing Collateral",0,0,{"$error":"#DIV/0!"}]
[null,"Prospects Lists",0,0,{"$error":"#DIV/0!"}]
[null,"Other",0,0,{"$error":"#DIV/0!"}]
[null,null,{"$f":"SUM(C36:C42)","v":0},{"$f":"SUM(D36:D42)","v":0},{"$f":"SUM(E36:E42)","v":{"$error":"#DIV/0!"}}]
[null,"PUBLIC RELATIONS"]
[null,"Press Releases & Media Relations",0,0,{"$f":"((D45-C45)/C45)","v":{"$error":"#DIV/0!"}}]
[null,"Wire Fees",0,0,{"$error":"#DIV/0!"}]
[null,"Press Kits",0,0,{"$error":"#DIV/0!"}]
[null,null,{"$f":"SUM(C45:C47)","v":0},{"$f":"SUM(D45:D47)","v":0},{"$f":"SUM(E45:E47)","v":{"$error":"#DIV/0!"}}]
[null,"RESEARCH & DEVELOPMENT"]
[null,"Technology Licenses",0,0,{"$f":"((D50-C50)/C50)","v":{"$error":"#DIV/0!"}}]
[null,"Patents",0,0,{"$error":"#DIV/0!"}]
[null,"Other",0,0,{"$error":"#DIV/0!"}]
[null,null,{"$f":"SUM(C50:C52)","v":0},{"$f":"SUM(D50:D52)","v":0},{"$f":"SUM(E50:E52)","v":{"$error":"#DIV/0!"}}]
[null,"WEBSITE"]
[null,"Web Hosting",0,0,{"$f":"((D55-C55)/C55)","v":{"$error":"#DIV/0!"}}]
[null,"Web Design & Development",0,0,{"$f":"((D56-C56)/C56)","v":{"$error":"#DIV/0!"}}]
[null,"CDN",0,0,{"$error":"#DIV/0!"}]
[null,null,{"$f":"SUM(C55:C57)","v":0},{"$f":"SUM(D55:D57)","v":0},{"$f":"SUM(E55:E57)","v":{"$error":"#DIV/0!"}}]
[null,"SOFTWARE "]
[null,"CRM",0,0,{"$f":"((D60-C60)/C60)","v":{"$error":"#DIV/0!"}}]
[null,"Social Media",0,0,{"$error":"#DIV/0!"}]
[null,"Marketing Automation",0,0,{"$error":"#DIV/0!"}]
[null,null,{"$f":"SUM(C60:C62)","v":0},{"$f":"SUM(D60:D62)","v":0},{"$f":"SUM(E60:E62)","v":{"$error":"#DIV/0!"}}]
[null,"TRAVEL"]
[null,"Airfare",0,0,{"$f":"((D65-C65)/C65)","v":{"$error":"#DIV/0!"}}]
[null,"Accommodations",0,0,{"$error":"#DIV/0!"}]
[null,"Food",0,0,{"$error":"#DIV/0!"}]
[null,"Entertainment",0,0,{"$error":"#DIV/0!"}]
[null,null,{"$f":"SUM(C65:C68)","v":0},{"$f":"SUM(D65:D68)","v":0},{"$f":"SUM(E65:E68)","v":{"$error":"#DIV/0!"}}]
[]
[null,"TOTAL",{"$f":"C69+C63+C58+C53+C43+C34","v":50000},{"$f":"D69+D63+D58+D53+D43+D34","v":45000}]
[]
[null,"CLICK HERE TO CREATE YOUR DEPARTMENT BUDGET TEMPLATES WITH SMARTSHEET"]