{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Business Budget - Goods","Business Budget - Services"],"not_rendered":{"charts":2,"images":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Business Budget - Goods","index":0,"n_rows":75,"n_cols":5,"rows_kept":75,"merged":[[8,5,16,5],[20,5,33,5],[35,5,38,5],[40,5,47,5],[49,5,53,5],[55,5,61,5],[63,5,69,5],[74,1,74,5]]}
[null,"BUSINESS BUDGET"]
[]
[null,"SUMMARY","BUDGET","ACTUAL","UNDER/OVER"]
[null,"Total Income",{"$f":"C18","v":{"v":7270,"d":"$7,270.00"}},{"$f":"D18","v":{"v":7020,"d":"$7,020.00"}},{"$f":"C4-D4","v":{"v":250,"d":"$250.00"}}]
[null,"Total Expenses",{"$f":"SUM(C34,C39,C48,C54+C62,C70)","v":{"v":5023,"d":"$5,023.00"}},{"$f":"SUM(D34,D39,D48,D54+D62,D70)","v":{"v":5450,"d":"$5,450.00"}},{"$f":"C5-D5","v":{"v":-427,"d":"$(427.00)"}}]
[]
[]
[null,"INCOME","BUDGET","ACTUAL","UNDER/OVER"]
[null,"OPERATING INCOME"]
[null,"Category 1",{"v":6000,"d":"$6,000.00"},{"v":6000,"d":"$6,000.00"},{"$f":"D10-C10","v":0}]
[null,"Category 2",{"v":200,"d":"$200.00"},{"v":150,"d":"$150.00"},{"$f":"D11-C11","v":{"v":-50,"d":"$(50.00)"}}]
[null,"Category 3",{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},0]
[null,"Category 4",{"v":55,"d":"$55.00"},{"v":20,"d":"$20.00"},{"v":-35,"d":"$(35.00)"}]
[null,"Category 5",{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},0]
[null,"Category 6",{"v":300,"d":"$300.00"},{"v":200,"d":"$200.00"},{"v":-100,"d":"$(100.00)"}]
[null,"Category 7",{"v":115,"d":"$115.00"},{"v":50,"d":"$50.00"},{"v":-65,"d":"$(65.00)"}]
[]
[null,"TOTAL",{"$f":"SUM(C10:C16)","v":{"v":7270,"d":"$7,270.00"}},{"$f":"SUM(D10:D16)","v":{"v":7020,"d":"$7,020.00"}}]
[]
[null,"EXPENSES","BUDGET","ACTUAL","UNDER/OVER"]
[null,"OPERATING EXPENSE"]
[null,"Accounting and Legal",{"v":2250,"d":"$2,250.00"},{"v":2250,"d":"$2,250.00"},{"$f":"D22-C22","v":0}]
[null,"Advertising",{"v":25,"d":"$25.00"},null,{"$f":"D23-C23","v":{"v":-25,"d":"$(25.00)"}}]
[null,"Depreciation",{"v":40,"d":"$40.00"},null,{"v":-40,"d":"$(40.00)"}]
[null,"Dues and Subscriptions",{"v":44,"d":"$44.00"},null,{"v":-44,"d":"$(44.00)"}]
[null,"Insurance",{"v":20,"d":"$20.00"},null,{"v":-20,"d":"$(20.00)"}]
[null,"Interest Expense",{"v":15,"d":"$15.00"},null,{"v":-15,"d":"$(15.00)"}]
[null,"Maintenance/Improvements",null,null,0]
[null,"Taxes and Licenses",{"v":29,"d":"$29.00"},null,{"v":-29,"d":"$(29.00)"}]
[null,"Telephone",null,null,0]
[null,"Travel",null,null,0]
[null,"Utilities",null,null,0]
[null,"Web Hosting and Domains"]
[null,null,{"$f":"SUM(C22:C33)","v":{"v":2423,"d":"$2,423.00"}},{"$f":"SUM(D22:D33)","v":{"v":2250,"d":"$2,250.00"}}]
[null,"PAYROLL"]
[null,"Payroll Expenses",{"v":2600,"d":"$2,600.00"},{"v":3200,"d":"$3,200.00"},{"$f":"D36-C36","v":{"v":600,"d":"$600.00"}}]
[null,"Salaries and Wages",null,null,0]
[null,"Contractor Wages",null,null,0]
[null,null,{"$f":"SUM(C36:C38)","v":{"v":2600,"d":"$2,600.00"}},{"$f":"SUM(D36:D38)","v":{"v":3200,"d":"$3,200.00"}}]
[null,"OFFICE"]
[null,"Office Supplies",null,null,{"$f":"D41-C41","v":0}]
[null,"Space Rental",null,null,{"$f":"D42-C42","v":0}]
[null,"Décor",null,null,0]
[null,"Machine Rental",null,null,0]
[null,"Equipment",null,null,{"$f":"D45-C45","v":0}]
[null,"Postage",null,null,0]
[null,"Other",null,null,0]
[null,null,{"$f":"SUM(C41:C47)","v":0},{"$f":"SUM(D41:D47)","v":0}]
[null,"ENTERTAINMENT"]
[null,"Video/DVD/Movies",null,null,{"$f":"D50-C50","v":0}]
[null,"Concerts/Plays",null,null,{"$f":"D51-C51","v":0}]
[null,"Sports",null,null,{"$f":"D52-C52","v":0}]
[null,"Outdoor Recreation",null,null,{"$f":"D53-C53","v":0}]
[null,null,{"$f":"SUM(C50:C53)","v":0}]
[null,"HEALTH"]
[null,"Health Insurance",null,null,{"$f":"D56-C56","v":0}]
[null,"Gym Membership",null,null,0]
[null,"Doctors/Dentist Visits",null,null,0]
[null,"Medicine/Prescriptions",null,null,0]
[null,"Veterinarian",null,null,0]
[null,"Life Insurance",null,null,0]
[null,null,{"$f":"SUM(C56:C61)","v":0},{"$f":"SUM(D56:D61)","v":0}]
[null,"VACATION/HOLIDAY"]
[null,"Airfare",null,null,{"$f":"D64-C64","v":0}]
[null,"Accommodations",null,null,0]
[null,"Food",null,null,0]
[null,"Souvenirs",null,null,0]
[null,"Pet Boarding",null,null,0]
[null,"Rental Car",null,null,0]
[null,null,{"$f":"SUM(C64:C69)","v":0},{"$f":"SUM(D64:D69)","v":0}]
[]
[null,"TOTAL",{"$f":"C70+C62+C54+C48+C39+C34","v":{"v":5023,"d":"$5,023.00"}},{"$f":"D70+D62+D54+D48+D39+D34","v":{"v":5450,"d":"$5,450.00"}}]
[]
[]
[null,"CLICK HERE TO CREATE BUSINESS BUDGET TEMPLATES IN SMARTSHEET"]

{"sheet":"Business Budget - Services","index":1,"n_rows":30,"n_cols":10,"rows_kept":30,"merged":[[5,2,5,3],[5,4,5,5],[5,6,6,6]]}
[null,"BUSINESS BUDGET"]
[]
[{"$nulls":7},"BUDGET","ACTUAL","UNDER/OVER"]
[{"$nulls":7},{"$f":"H30","v":{"v":850,"d":"$850.00"}},{"$f":"I30","v":{"v":800,"d":"$800.00"}},{"$f":"H4-I4","v":{"v":50,"d":"$50.00"}}]
[]
[null,null,"LABOR",null,"MATERIALS",null,"FIXED COST"]
[null,"TASK","HOURS","RATE","UNITS","$/UNIT",null,"BUDGET","ACTUAL","UNDER/OVER"]
[null,"CATEGORY"]
[null,"Task",10,{"v":15,"d":"$15.00"},50,{"v":10,"d":"$10.00"},{"v":200,"d":"$200.00"},{"$f":"C9*D9+E9*F9+G9","v":{"v":850,"d":"$850.00"}},{"v":800,"d":"$800.00"},{"$f":"I9-H9","v":{"v":-50,"d":"$(50.00)"}}]
[null,"Task",{"$nulls":5},{"$f":"C10*D10+E10*F10+G10","v":0},null,{"$f":"I10-H10","v":0}]
[null,"Task",{"$nulls":5},0,null,{"$f":"I11-H11","v":0}]
[null,"Task",{"$nulls":5},0,null,{"$f":"I12-H12","v":0}]
[null,"Task",{"$nulls":5},0,null,{"$f":"I13-H13","v":0}]
[{"$nulls":7},{"$f":"SUM(H9:H13)","v":{"v":850,"d":"$850.00"}},{"$f":"SUM(I9:I13)","v":{"v":800,"d":"$800.00"}}]
[null,"CATEGORY"]
[null,"Task",{"$nulls":5},{"$f":"C16*D16+E16*F16+G16","v":0},null,{"$f":"I16-H16","v":0}]
[null,"Task",{"$nulls":5},{"$f":"C17*D17+E17*F17+G17","v":0},null,{"$f":"I17-H17","v":0}]
[null,"Task",{"$nulls":5},0,null,{"$f":"I18-H18","v":0}]
[null,"Task",{"$nulls":5},0,null,{"$f":"I19-H19","v":0}]
[null,"Task",{"$nulls":5},{"$f":"C20*D20+E20*F20+G20","v":0},null,{"$f":"I20-H20","v":0}]
[{"$nulls":7},{"$f":"SUM(H16:H20)","v":0},{"$f":"SUM(I16:I20)","v":0}]
[null,"CATEGORY"]
[null,"Task",{"$nulls":5},{"$f":"C23*D23+E23*F23+G23","v":0},null,{"$f":"I23-H23","v":0}]
[null,"Task",{"$nulls":5},{"$f":"C24*D24+E24*F24+G24","v":0},null,{"$f":"I24-H24","v":0}]
[null,"Task",{"$nulls":5},0,null,{"$f":"I25-H25","v":0}]
[null,"Task",{"$nulls":5},0,null,0]
[{"$nulls":7},0,null,0]
[{"$nulls":7},{"$f":"SUM(H24:H26)","v":0},{"$f":"SUM(I24:I26)","v":0}]
[]
[null,"TOTAL",{"$nulls":5},{"$f":"SUM(H14,H21,H28)","v":{"v":850,"d":"$850.00"}},{"$f":"SUM(I14,I21,I28)","v":{"v":800,"d":"$800.00"}}]