{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Your Information","Monthly Dashboard","Chart Data","Income & Expenses","Budget & Planning"],"not_rendered":{"charts":4,"images":1,"macros":1,"defined_names":16,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":38,"n_cols":2,"rows_kept":38,"merged":[[1,2,2,2]]}
[]
[]
[]
[]
[]
[null,"Thank you for downloading this template. We hope that it can help you manage your money, take control of your financial life, and follow your own detours. Your budget is one of the best tools that you have. It's not about earning more money, but rather, it's about controlling the money you already earn that will set you on the path to financial freedom."]
[]
[]
[]
[null,"INSTRUCTIONS"]
[null,"The goal of this template is to provide a quick and easy way for you to plan your monthly budget and expenses and then track your progress over the month."]
[]
[null,"Definitions:"]
[null,"1.) Total Income - The total amount of money that you earn each month before any expenses."]
[null,"2.) Total Fixed Expenses - Fixed expenses are your bills. They are things that you must pay such as your mortgage or rent, utilities, insurance, credit card payments etc. For most people, these don't vary too much from month to month."]
[null,"3. ) Disposable Income - The money that is left over once you take your total income and subtract all of your fixed expenses. This is the money that you have each month to spend on groceries, entertainment, clothes, etc."]
[null,"4. ) Cash Balance - The amount left once all of your expenses have been subtracted from your income. Often called net income."]
[null,"5.) Budget Category - This term is used to describe the \"buckets\" that you will budget for. These buckets are common purchase items such as groceries, gas, entertainment, special occasions etc."]
[]
[]
[]
[]
[null,"HOW TO USE THIS TEMPLATE"]
[null,"1.) Enter all of your monthly earnings on the Income & Expenses Sheet."]
[null,"2.) Enter all of your monthly bills on the Income & Expense Sheet. You can put payment date information as well as payment status in this section. PRO TIP: Always make sure to pay yourself something each month - include the amount you want to save in the Fixed Expenses section so that you treat savings just like you would your car payment."]
[null,"3.) Have a budget meeting. On the Budget & Planning Sheet, allocate money to the budget categories that make sense for you. Choose your categories and enter the budgeted amount. That's all you need to do. All of the other information will automatically update throughout the month. Try to budget until you have $0 left remaining. This means that you have accounted for every dollar for the month and will ensure you that you can meet all of your obligations and goals."]
[null,"4.) Enter your monthly purchases in the right section on the Income & Expenses sheet. Be sure to specify the budget category that is appropriate. IMPORTANT: make sure that the budget category you specify for your purchase is accounted for on the Budget & Planning Sheet. For example, don't specify a budget category of Home Repair for a purchase if you don't have Home Repair as one of the budget categories on the Budget & Planning Worksheet."]
[]
[null,"HOW TO UPDATE THE BUDGET CATEGORIES"]
[null,"Here are the steps to edit the budget categories used throughout this template."]
[null,"1.) Right Click on the Instructions tab at the bottom of the screen."]
[null,"2.) Choose Unhide"]
[null,"3.) Select Your Information"]
[null,"4.) Edit the categories that are listed"]
[null,"5.) Once finished, click the Sort button at the top to automatically alphabatize from A-Z"]
[null,"6.) If desired, right click on the Your Information tab and select Hide to make the sheet invisible"]
[]
[null,"If you have questions about this and would like to see a video tutorial, click Here"]

{"sheet":"Your Information","index":1,"n_rows":33,"n_cols":3,"rows_kept":33,"hidden":true}
["Spend Categories","Payment Methods","Budget Categories"]
["Art / Craft Project","Cash","Alimony"]
["Charitable Donation","Check","Allowance"]
["Clothes - Personal","Checking Account","Charitable Giving"]
["Clothes - Work","Credit Card 1","Child Care"]
["Cosmetics/Personal Items","Credit Card 2","Child Support"]
["Dog Expense - Vet, food, etc.","Debit Card 1","Clothes"]
["Electronics",null,"Cosmetics / Personal Items"]
["Entertainment - Alcohol Home",null,"Entertainment"]
["Entertainment - General",null,"Gas"]
["Family Event",null,"Gift"]
["Food - Groceries",null,"Groceries"]
["Food - Restaurant",null,"Holiday / Special Occasion"]
["Gas - Vehicle 1",null,"Home Repair"]
["Gas - Vehicle 2",null,"Laundry"]
["Gift",null,"Medical Expense"]
["Gym/Fitness Expense",null,"Medications"]
["Health",null,"Miscellaneous"]
["Home Repair",null,"Pet Expense"]
["Household Items",null,"Repair / Maintenance"]
["Household Items - Yard/Outside",null,"Restaurants (Dining Out)"]
["Laundry",null,"RV Lodging / Parking"]
["Medical",null,"RV Membership"]
["Misc.",null,"Savings"]
["Moving Expense",null,"Special Occasion"]
["N/A Beverage (coffee, smoothies etc.)",null,"Subscriptions"]
["Personal Appearance (Hair cuts, manicures, pedicures)",null,"Transportation"]
["Shoes",null,"Travel Expense"]
["Souvenir",null,"Tuition"]
["Special Occasion (Birthday, holiday, etc.)",null,"Vacation"]
["Travel Expense",null,"Vehicle Expense"]
[null,null,"Vehicle Registration (plates and taxes)"]
[null,null,"Work Expense"]

{"sheet":"Monthly Dashboard","index":2,"n_rows":5,"n_cols":9,"rows_kept":5,"merged":[[0,1,1,9]]}
[null,"Monthly Summary"]
[]
[]
[null,null,"Total Income",null,"Total Fixed Expenses (Bills)",null,"Monthly Purchases",null," Cash Balance"]
[null,null,{"$f":"SUM(TBL_Total_Income[[#All],[Amount]])","v":{"v":3000,"d":"$3,000.00"}},null,{"$f":"SUM(TBL_Fixed_Expenses[[#All],[Amount]])","v":{"v":1643.3400000000001,"d":"$1,643.34"}},null,{"$f":"SUM(TBL_monthly_purchases[[#All],[AMOUNT]])","v":{"v":213,"d":"$213.00"}},null,{"$f":"(dshbrd_tot_income-dshbrd_fixedexpenses-Total_envelope_spend)","v":{"v":1143.6599999999999,"d":"$1,143.66"}}]

{"sheet":"Chart Data","index":3,"n_rows":26,"n_cols":19,"rows_kept":26,"hidden":true,"merged":[[0,0,0,1]]}
["Disposable Income (Envelope Spend) Burndown",{"$nulls":4},"Montly Income vs Expenses",{"$nulls":4},"Not Paid",null,null,{"$f":"'Budget & Planning'!C9","v":"Category"},{"$f":"'Budget & Planning'!D9","v":"Budget"},{"$f":"'Budget & Planning'!E9","v":"Actual"},null,null,"For SUM IF"]
["Disposable Income Remaining",{"$f":"MIN(1,1-B3)","v":{"v":0.8429967714829065,"d":"84%"}},{"$nulls":3},"Total Income",{"$f":"dshbrd_tot_income","v":3000},{"$nulls":3},"Paid",null,null,{"$f":"'Budget & Planning'!C10","v":"Gas"},{"$f":"'Budget & Planning'!D10","v":200},{"$f":"'Budget & Planning'!E10","v":45},null,null,{"$f":"'Budget & Planning'!C10","v":"Gas"}]
["Disposable Income Spent",{"$f":"MIN(Total_envelope_spend/total_disosable_income,1)","v":{"v":0.15700322851709347,"d":"16%"}},{"$nulls":3},"Total Expense",{"$f":"dshbrd_fixedexpenses+Total_envelope_spend","v":1856.3400000000001},{"$nulls":6},{"$f":"'Budget & Planning'!C11","v":"Holiday / Special Occasion"},{"$f":"'Budget & Planning'!D11","v":200},{"$f":"'Budget & Planning'!E11","v":100},null,null,{"$f":"'Budget & Planning'!C11","v":"Holiday / Special Occasion"}]
[{"$f":"(Total_envelope_spend+dshbrd_fixedexpenses)/dshbrd_tot_income>1","v":false},{"$nulls":12},{"$f":"'Budget & Planning'!C12","v":"Restaurants (Dining Out)"},{"$f":"'Budget & Planning'!D12","v":200},{"$f":"'Budget & Planning'!E12","v":35},null,null,{"$f":"'Budget & Planning'!C12","v":"Restaurants (Dining Out)"}]
[{"$f":"(Total_envelope_spend+dshbrd_fixedexpenses)/dshbrd_tot_income<1","v":true},{"$nulls":12},{"$f":"'Budget & Planning'!C13","v":0},{"$f":"'Budget & Planning'!D13","v":0},{"$f":"'Budget & Planning'!E13","v":0},null,null,{"$f":"'Budget & Planning'!C13","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C14","v":0},{"$f":"'Budget & Planning'!D14","v":0},{"$f":"'Budget & Planning'!E14","v":0},null,null,{"$f":"'Budget & Planning'!C14","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C15","v":0},{"$f":"'Budget & Planning'!D15","v":0},{"$f":"'Budget & Planning'!E15","v":0},null,null,{"$f":"'Budget & Planning'!C15","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C16","v":0},{"$f":"'Budget & Planning'!D16","v":0},{"$f":"'Budget & Planning'!E16","v":0},null,null,{"$f":"'Budget & Planning'!C16","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C17","v":0},{"$f":"'Budget & Planning'!D17","v":0},{"$f":"'Budget & Planning'!E17","v":0},null,null,{"$f":"'Budget & Planning'!C17","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C18","v":0},{"$f":"'Budget & Planning'!D18","v":0},{"$f":"'Budget & Planning'!E18","v":0},null,null,{"$f":"'Budget & Planning'!C18","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C19","v":0},{"$f":"'Budget & Planning'!D19","v":0},{"$f":"'Budget & Planning'!E19","v":0},null,null,{"$f":"'Budget & Planning'!C19","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C20","v":0},{"$f":"'Budget & Planning'!D20","v":0},{"$f":"'Budget & Planning'!E20","v":0},null,null,{"$f":"'Budget & Planning'!C20","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C21","v":0},{"$f":"'Budget & Planning'!D21","v":0},{"$f":"'Budget & Planning'!E21","v":0},null,null,{"$f":"'Budget & Planning'!C21","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C22","v":0},{"$f":"'Budget & Planning'!D22","v":0},{"$f":"'Budget & Planning'!E22","v":0},null,null,{"$f":"'Budget & Planning'!C22","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C23","v":0},{"$f":"'Budget & Planning'!D23","v":0},{"$f":"'Budget & Planning'!E23","v":0},null,null,{"$f":"'Budget & Planning'!C23","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C24","v":0},{"$f":"'Budget & Planning'!D24","v":0},{"$f":"'Budget & Planning'!E24","v":0},null,null,{"$f":"'Budget & Planning'!C24","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C25","v":0},{"$f":"'Budget & Planning'!D25","v":0},{"$f":"'Budget & Planning'!E25","v":0},null,null,{"$f":"'Budget & Planning'!C25","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C26","v":0},{"$f":"'Budget & Planning'!D26","v":0},{"$f":"'Budget & Planning'!E26","v":0},null,null,{"$f":"'Budget & Planning'!C26","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C27","v":0},{"$f":"'Budget & Planning'!D27","v":0},{"$f":"'Budget & Planning'!E27","v":0},null,null,{"$f":"'Budget & Planning'!C27","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C28","v":0},{"$f":"'Budget & Planning'!D28","v":0},{"$f":"'Budget & Planning'!E28","v":0},null,null,{"$f":"'Budget & Planning'!C28","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C29","v":0},{"$f":"'Budget & Planning'!D29","v":0},{"$f":"'Budget & Planning'!E29","v":0},null,null,{"$f":"'Budget & Planning'!C29","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C30","v":0},{"$f":"'Budget & Planning'!D30","v":0},{"$f":"'Budget & Planning'!E30","v":0},null,null,{"$f":"'Budget & Planning'!C30","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C31","v":0},{"$f":"'Budget & Planning'!D31","v":0},{"$f":"'Budget & Planning'!E31","v":0},null,null,{"$f":"'Budget & Planning'!C31","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C32","v":0},{"$f":"'Budget & Planning'!D32","v":0},{"$f":"'Budget & Planning'!E32","v":0},null,null,{"$f":"'Budget & Planning'!C32","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C33","v":0},{"$f":"'Budget & Planning'!D33","v":0},{"$f":"'Budget & Planning'!E33","v":0},null,null,{"$f":"'Budget & Planning'!C33","v":0}]
[{"$nulls":13},{"$f":"'Budget & Planning'!C34","v":0},{"$f":"'Budget & Planning'!D34","v":0},{"$f":"'Budget & Planning'!E34","v":0},null,null,{"$f":"'Budget & Planning'!C34","v":0}]

{"sheet":"Income & Expenses","index":4,"n_rows":25,"n_cols":13,"rows_kept":25,"merged":[[0,1,0,2],[0,4,0,7],[0,9,0,12]]}
[null,"Income",null,null,"Fixed Expenses",{"$nulls":4},"Monthly Purchases"]
[]
[null,"Income","Amount",null,"Fixed Monthly Expense Item","Amount","Due Date","Payment Status",null,"PURCHASE/PAYEE","DATE","AMOUNT","CATEGORY"]
[null,"Job 1 Paycheck 1",{"v":1500,"d":"$1,500.00"},null,"Savings",{"v":500,"d":"$500.00"},"[date]",null,null,"Best Buy","2017-09-02",{"v":100,"d":"$100.00"},"Holiday / Special Occasion"]
[null,"Job 1 Paycheck 2",{"v":1500,"d":"$1,500.00"},null,"Health Insurance",{"v":177,"d":"$177.00"},"[date]",null,null,"Gas Station","2017-09-03",{"v":45,"d":"$45.00"},"Gas"]
[{"$nulls":4},"Cell Phone",{"v":90,"d":"$90.00"},"[date]",null,null,"Chili's","2017-09-04",{"v":35,"d":"$35.00"},"Restaurants (Dining Out)"]
[{"$nulls":4},"Netflix",{"v":9,"d":"$9.00"},"[date]",null,null,"Home Depot","2017-09-05",{"v":33,"d":"$33.00"},"Home Repair"]
[{"$nulls":4},"Cable / Satellite Bill",{"v":100,"d":"$100.00"},"[date]"]
[{"$nulls":4},"Car Payment 1",{"v":500,"d":"$500.00"},"[date]"]
[{"$nulls":4},"Car Payment 2",0,"[date]"]
[{"$nulls":4},"Cloud Storage",{"v":10,"d":"$10.00"},"[date]"]
[{"$nulls":4},"Life Insurance",{"v":20,"d":"$20.00"},"[date]"]
[{"$nulls":4},"Car Insurance",{"v":150,"d":"$150.00"},"[date]"]
[{"$nulls":4},"Storage Unit",{"v":12,"d":"$12.00"},"[date]"]
[{"$nulls":4},"RV Insurance",0,"[date]"]
[{"$nulls":4},"Gym Membership",{"v":45,"d":"$45.00"},"[date]"]
[{"$nulls":4},"Spotify",{"v":17.44,"d":"$17.44"},"[date]"]
[{"$nulls":4},"ID Theft Insurance",{"v":12.9,"d":"$12.90"},"[date]"]
[{"$nulls":4},"Credit Card 1",0,"[date]"]
[{"$nulls":4},"Credit Card 2",0,"[date]"]
[{"$nulls":4},"Retail Credit 1",0,"[date]"]
[{"$nulls":4},"Audible",0,"[date]"]
[{"$nulls":4},"RV Membership",0,"[date]"]
[{"$nulls":4},"Internet",0,"[date]"]
[{"$nulls":4},"Utilities",0,"[date]"]

{"sheet":"Budget & Planning","index":5,"n_rows":35,"n_cols":7,"rows_kept":35,"merged":[[0,1,1,7]]}
[null,"Planning Worksheet"]
[]
[]
[null,null," Budgeting Amount (Disposable Income)",null,"Total Amount Budgeted",null,"Amount Remaining to Budget"]
[null,null,{"$f":"(SUM(TBL_Total_Income[[#All],[Amount]]))-(SUM(TBL_Fixed_Expenses[[#All],[Amount]]))","v":{"v":1356.6599999999999,"d":"$1,356.66"}},null,{"$f":"TBL_budget_categories[[#Totals],[Budget]]","v":{"v":600,"d":"$600.00"}},null,{"$f":"(SUM(TBL_Total_Income[[#All],[Amount]]))-(SUM(TBL_Fixed_Expenses[[#All],[Amount]]))-(TBL_budget_categories[[#Totals],[Budget]])","v":{"v":756.6599999999999,"d":"$756.66"}}]
[]
[]
[]
[null,null,"Category","Budget","Actual","Amount Remaining","% Spent"]
[null,null,"Gas",{"v":200,"d":"$200.00"},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S2,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":{"v":45,"d":"$45.00"}},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":{"v":155,"d":"$155.00"}},{"$f":"E10/D10","v":{"v":0.225,"d":"23%"}}]
[null,null,"Holiday / Special Occasion",{"v":200,"d":"$200.00"},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S3,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":{"v":100,"d":"$100.00"}},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":{"v":100,"d":"$100.00"}},{"$f":"E11/D11","v":{"v":0.5,"d":"50%"}}]
[null,null,"Restaurants (Dining Out)",{"v":200,"d":"$200.00"},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S4,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":{"v":35,"d":"$35.00"}},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":{"v":165,"d":"$165.00"}},{"v":0.175,"d":"18%"}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S5,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S6,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S7,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S8,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S9,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S10,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S11,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S12,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$f":"E20/D20","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S13,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S14,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S15,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S16,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S17,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S18,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$f":"E26/D26","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S19,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S20,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S21,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S22,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S23,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S24,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S25,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"SUMIF(TBL_monthly_purchases[[#Data],[CATEGORY]],'Chart Data'!S26,TBL_monthly_purchases[[#Data],[AMOUNT]])","v":0},{"$f":"TBL_budget_categories[[#This Row],[Budget]]-TBL_budget_categories[[#This Row],[Actual]]","v":0},{"$error":"#DIV/0!"}]
[null,null,"Total",{"$f":"SUBTOTAL(109,TBL_budget_categories[Budget])","v":{"v":600,"d":"$600.00"}},{"$f":"SUBTOTAL(109,TBL_budget_categories[Actual])","v":{"v":180,"d":"$180.00"}}]