{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Start","Dashboard","Expenditures & income","Budget report","Data lists","Category PivotTable"],"not_rendered":{"charts":3,"defined_names":23,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"About the template"]
[null,"Use this template to create a semi-monthly home budget."]
[null,"The dashboard worksheet contains charts for monthly and annual totals and a table for fortnightly Income and expenses."]
[null,"Enter categories in data lists worksheet, and values in Income and expenditures worksheet."]
[null,"Refresh the PivotTable in the budget report worksheet."]
[null,"Note:"]
[null,"Additional instructions have been provided in column A in all worksheets. This text has been intentionally hidden. To remove text, select column A, then select DELETE. "]
[null,"To learn more about table, press SHIFT and then F10 within a table, select the TABLE option, and then select ALTERNATIVE TEXT. For PivotTables, press SHIFT and then F10 within a table, select PIVOTTABLE OPTIONS, and then select ALT TEXT tab."]

{"sheet":"Dashboard","index":1,"n_rows":12,"n_cols":15,"rows_kept":12,"merged":[[0,1,0,13],[1,2,1,7]]}
["Create a dashboard for Monthly and Annual Totals and fortnightly income and expenses in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Title of this workbook is in cell at right and worksheet title in cell O1.","Semi-monthly home budget",{"$nulls":12},"DASHBOARD"]
["Select slider in cell C2 to change month in cell at right and to change the year in cell I2, select the slider in cell J2.",{"$f":"CHOOSE(MonthNumber,\"JANUARY\",\"FEBRUARY\",\"MARCH\",\"APRIL\",\"MAY\",\"JUNE\",\"JULY\",\"AUGUST\",\"SEPTEMBER\",\"OCTOBER\",\"NOVEMBER\",\"DECEMBER\")","v":"DECEMBER"},12,{"$nulls":5},{"$f":"YEAR(TODAY())","v":2022}]
["Month Totals label is in cell at right and Annual Totals label in cell I3.","MONTH TOTALS",{"$nulls":6},"ANNUAL TOTALS"]
["Bar chart comparing Monthly Income totals to Monthly Expenditure totals is in cell C4 and bar chart comparing Annual Income totals to Annual Expenditure totals is in cell J4. Next instruction is in cell A8.","INCOME",null,{"$f":"MonthlyExpendituresTotals","v":{"v":0,"d":"$0"}},{"$nulls":4},"INCOME",null,null,{"$f":"AnnualExpendituresTotals","v":{"v":10742,"d":"$10,742"}}]
[null,"EXPENDITURES",null,{"$f":"MonthlyIncomeTotals","v":{"v":0,"d":"$0"}},{"$nulls":4},"EXPENDITURES",null,null,{"$f":"AnnualIncomeTotals","v":{"v":13200,"d":"$13,200"}}]
[]
[]
["Dashboard table starting in cell at right is auto updated.","Category","JANUARY","FEBRUARY","MARCH","APRIL","MAY","JUNE","JULY","AUGUST","SEPTEMBER","OCTOBER","NOVEMBER","DECEMBER","Sparkline"]
[null,"Income 1-15",{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtMiddle,Income[DATE],\">=\"&DtStart)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtMiddle,Income[DATE],\">=\"&DtStart)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtMiddle,Income[DATE],\">=\"&DtStart)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtMiddle,Income[DATE],\">=\"&DtStart)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtMiddle,Income[DATE],\">=\"&DtStart)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtMiddle,Income[DATE],\">=\"&DtStart)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtMiddle,Income[DATE],\">=\"&DtStart)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtMiddle,Income[DATE],\">=\"&DtStart)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtMiddle,Income[DATE],\">=\"&DtStart)","v":{"v":4400,"d":"$4,400.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtMiddle,Income[DATE],\">=\"&DtStart)","v":{"v":3100,"d":"$3,100.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtMiddle,Income[DATE],\">=\"&DtStart)","v":{"v":500,"d":"$500.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtMiddle,Income[DATE],\">=\"&DtStart)","v":{"v":0,"d":"$0.00"}}]
[null,"Income 16-EOM",{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtEnd,Income[DATE],\">=\"&DtMiddle+1)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtEnd,Income[DATE],\">=\"&DtMiddle+1)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtEnd,Income[DATE],\">=\"&DtMiddle+1)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtEnd,Income[DATE],\">=\"&DtMiddle+1)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtEnd,Income[DATE],\">=\"&DtMiddle+1)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtEnd,Income[DATE],\">=\"&DtMiddle+1)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtEnd,Income[DATE],\">=\"&DtMiddle+1)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtEnd,Income[DATE],\">=\"&DtMiddle+1)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtEnd,Income[DATE],\">=\"&DtMiddle+1)","v":{"v":2600,"d":"$2,600.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtEnd,Income[DATE],\">=\"&DtMiddle+1)","v":{"v":2600,"d":"$2,600.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtEnd,Income[DATE],\">=\"&DtMiddle+1)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Income[AMOUNT],Income[DATE],\"<=\"&DtEnd,Income[DATE],\">=\"&DtMiddle+1)","v":{"v":0,"d":"$0.00"}}]
[null,"Expenditures 1-15",{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtMiddle+1,Expenditures[DATE],\">=\"&DtStart)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtMiddle+1,Expenditures[DATE],\">=\"&DtStart)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtMiddle+1,Expenditures[DATE],\">=\"&DtStart)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtMiddle+1,Expenditures[DATE],\">=\"&DtStart)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtMiddle+1,Expenditures[DATE],\">=\"&DtStart)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtMiddle+1,Expenditures[DATE],\">=\"&DtStart)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtMiddle+1,Expenditures[DATE],\">=\"&DtStart)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtMiddle+1,Expenditures[DATE],\">=\"&DtStart)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtMiddle+1,Expenditures[DATE],\">=\"&DtStart)","v":{"v":150,"d":"$150.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtMiddle+1,Expenditures[DATE],\">=\"&DtStart)","v":{"v":775,"d":"$775.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtMiddle+1,Expenditures[DATE],\">=\"&DtStart)","v":{"v":2067,"d":"$2,067.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtMiddle+1,Expenditures[DATE],\">=\"&DtStart)","v":{"v":0,"d":"$0.00"}}]
[null,"Expenditures 16-EOM",{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtEnd,Expenditures[DATE],\">=\"&DtMiddle+1)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtEnd,Expenditures[DATE],\">=\"&DtMiddle+1)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtEnd,Expenditures[DATE],\">=\"&DtMiddle+1)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtEnd,Expenditures[DATE],\">=\"&DtMiddle+1)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtEnd,Expenditures[DATE],\">=\"&DtMiddle+1)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtEnd,Expenditures[DATE],\">=\"&DtMiddle+1)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtEnd,Expenditures[DATE],\">=\"&DtMiddle+1)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtEnd,Expenditures[DATE],\">=\"&DtMiddle+1)","v":{"v":1075,"d":"$1,075.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtEnd,Expenditures[DATE],\">=\"&DtMiddle+1)","v":{"v":5350,"d":"$5,350.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtEnd,Expenditures[DATE],\">=\"&DtMiddle+1)","v":{"v":2025,"d":"$2,025.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtEnd,Expenditures[DATE],\">=\"&DtMiddle+1)","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIFS(Expenditures[AMOUNT],Expenditures[DATE],\"<=\"&DtEnd,Expenditures[DATE],\">=\"&DtMiddle+1)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Expenditures & income","index":2,"n_rows":36,"n_cols":9,"rows_kept":36,"merged":[[0,1,0,6],[0,7,0,8]]}
["Create a list of Income & Expenditures in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Title of the workbook is in cell at right and worksheet title in cell H1.",{"$f":"Semi_Monthly_Home_Budget_Title","v":"Semi-monthly home budget"},{"$nulls":5},"INCOME  & EXPENDITURES"]
["Income label is in cell at right and Expenditures label in cell F2.","INCOME",{"$nulls":3},"EXPENDITURES"]
["Enter details in Income table starting in cell at right and in Expenditures table starting in cell F3.","DATE","DESCRIPTION","AMOUNT",null,"DATE","CATEGORY","DESCRIPTION","AMOUNT"]
[null,{"$f":"TODAY()","v":"2022-11-10"},"Bonus",{"v":500,"d":"$500.00"},null,{"$f":"TODAY()","v":"2022-11-10"},"Medical","Insurance",{"v":500,"d":"$500.00"}]
[null,{"$f":"TODAY()-14","v":"2022-10-27"},"David's paycheck",{"v":1300,"d":"$1,300.00"},null,{"$f":"TODAY()-7","v":"2022-11-03"},"Household","Mortgage",{"v":1000,"d":"$1,000.00"}]
[null,{"$f":"TODAY()-14","v":"2022-10-27"},"Pat's paycheck",{"v":1300,"d":"$1,300.00"},null,"2022-11-03","Household","Electricity",{"v":100,"d":"$100.00"}]
[null,{"$f":"TODAY()-28","v":"2022-10-13"},"David's paycheck",{"v":1500,"d":"$1,500.00"},null,"2022-11-03","Household","Water/sewer",{"v":50,"d":"$50.00"}]
[null,{"$f":"TODAY()-28","v":"2022-10-13"},"Pat's paycheck",{"v":1600,"d":"$1,600.00"},null,"2022-11-03","Household","Garbage",{"v":25,"d":"$25.00"}]
[null,{"$f":"TODAY()-42","v":"2022-09-29"},"David's paycheck",{"v":1300,"d":"$1,300.00"},null,"2022-11-03","Household","Cell phone",{"v":100,"d":"$100.00"}]
[null,{"$f":"TODAY()-42","v":"2022-09-29"},"Pat's paycheck",{"v":1300,"d":"$1,300.00"},null,"2022-11-03","Household","Cell phone",{"v":30,"d":"$30.00"}]
[null,{"$f":"TODAY()-56","v":"2022-09-15"},"David's paycheck",{"v":1500,"d":"$1,500.00"},null,"2022-11-03","Household","Mortgage",{"v":50,"d":"$50.00"}]
[null,{"$f":"TODAY()-56","v":"2022-09-15"},"Pat's paycheck",{"v":1600,"d":"$1,600.00"},null,"2022-11-03","Household","Cell phone",{"v":50,"d":"$50.00"}]
[null,{"$f":"TODAY()-70","v":"2022-09-01"},"David's paycheck",{"v":1300,"d":"$1,300.00"},null,{"$f":"TODAY()-7","v":"2022-11-03"},"Household","Cell phone",{"v":25,"d":"$25.00"}]
[{"$nulls":5},{"$f":"TODAY()-8","v":"2022-11-02"},"Household","Electricity",{"v":100,"d":"$100.00"}]
[{"$nulls":5},{"$f":"TODAY()-9","v":"2022-11-01"},"Entertainment","Movies",{"v":37,"d":"$37.00"}]
[{"$nulls":5},{"$f":"TODAY()-10","v":"2022-10-31"},"Food","Groceries",{"v":350,"d":"$350.00"}]
[{"$nulls":5},{"$f":"TODAY()-11","v":"2022-10-30"},"Food","Dining out",{"v":75,"d":"$75.00"}]
[{"$nulls":5},{"$f":"TODAY()-12","v":"2022-10-29"},"Children","Lunch money",{"v":150,"d":"$150.00"}]
[{"$nulls":5},{"$f":"TODAY()-13","v":"2022-10-28"},"Investment Accounts","Savings",{"v":250,"d":"$250.00"}]
[{"$nulls":5},{"$f":"TODAY()-14","v":"2022-10-27"},"Investment Accounts","Investment account",{"v":250,"d":"$250.00"}]
[{"$nulls":5},{"$f":"TODAY()-15","v":"2022-10-26"},"Personal","Health/Fitness club",{"v":100,"d":"$100.00"}]
[{"$nulls":5},{"$f":"TODAY()-16","v":"2022-10-25"},"Pets","Food",{"v":50,"d":"$50.00"}]
[{"$nulls":5},{"$f":"TODAY()-20","v":"2022-10-21"},"Pets","Grooming",{"v":50,"d":"$50.00"}]
[{"$nulls":5},{"$f":"TODAY()-20","v":"2022-10-21"},"Pets","Other",{"v":50,"d":"$50.00"}]
[{"$nulls":5},{"$f":"TODAY()-25","v":"2022-10-16"},"Transportation","Car 1 Payment ",{"v":300,"d":"$300.00"}]
[{"$nulls":5},{"$f":"TODAY()-25","v":"2022-10-16"},"Transportation","Car 2 Payment ",{"v":350,"d":"$350.00"}]
[{"$nulls":5},{"$f":"TODAY()-25","v":"2022-10-16"},"Transportation","Car Insurance",{"v":50,"d":"$50.00"}]
[{"$nulls":5},{"$f":"TODAY()-30","v":"2022-10-11"},"Transportation","Fuel",{"v":50,"d":"$50.00"}]
[{"$nulls":5},{"$f":"TODAY()-31","v":"2022-10-10"},"Transportation","Fuel",{"v":25,"d":"$25.00"}]
[{"$nulls":5},{"$f":"TODAY()-42","v":"2022-09-29"},"Transportation","Car 2 Payment ",{"v":150,"d":"$150.00"}]
[{"$nulls":5},{"$f":"TODAY()-45","v":"2022-09-26"},"Household","Mortgage",{"v":5000,"d":"$5,000.00"}]
[{"$nulls":5},{"$f":"TODAY()-50","v":"2022-09-21"},"Household","Electricity",{"v":200,"d":"$200.00"}]
[{"$nulls":5},{"$f":"TODAY()-65","v":"2022-09-06"},"Household","Cell phone",{"v":100,"d":"$100.00"}]
[{"$nulls":5},{"$f":"TODAY()-70","v":"2022-09-01"},"Household","Garbage",{"v":50,"d":"$50.00"}]
[{"$nulls":5},{"$f":"TODAY()-75","v":"2022-08-27"},"Household","Mortgage",{"v":1000,"d":"$1,000.00"}]
[{"$nulls":5},{"$f":"TODAY()-78","v":"2022-08-24"},"Entertainment","Movies",{"v":75,"d":"$75.00"}]

{"sheet":"Budget report","index":3,"n_rows":26,"n_cols":6,"rows_kept":26,"merged":[[0,1,0,4],[1,1,1,3],[4,3,4,5]]}
["Create a Budget Report in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Title of the workbook is in cell at right and worksheet title in cell F1.",{"$f":"Semi_Monthly_Home_Budget_Title","v":"Semi-monthly home budget"},{"$nulls":3},"BUDGET REPORT"]
["Select Years, Quarters, Months, or Days and use slider in cell at right to get the Expenditure PivotTable for the period selected. Category slicer to filter PivotTable data is in cell E2 and Description slicer in cell F2.","Timeline to filter is in this cell.",null,null,"Slicer to filter PivotTable data based on Category is in this cell.","Slicer to filter PivotTable data based on Description is in this cell."]
["Tip is in cell at right.","Press Shift+F10 in the Expenditures PivotTable and then select Refresh to update the data on this sheet, or select Refresh under Analyze tab."]
["Expenditures label is in cell at right.","EXPENDITURES"]
["PivotTable showing expenditures starts in cell at right. Category Totals label is in cell D4.","Row Labels","Sum of AMOUNT","CATEGORY TOTALS"]
["Pie chart comparing each category total is in cell D6.","Car 1 Payment ",{"v":300,"d":"$300.00"},"Pie chart comparing each category total is in this cell."]
[null,"Car 2 Payment ",{"v":500,"d":"$500.00"}]
[null,"Car Insurance",{"v":50,"d":"$50.00"}]
[null,"Cell phone",{"v":305,"d":"$305.00"}]
[null,"Dining out",{"v":75,"d":"$75.00"}]
[null,"Electricity",{"v":400,"d":"$400.00"}]
[null,"Food",{"v":50,"d":"$50.00"}]
[null,"Fuel",{"v":75,"d":"$75.00"}]
[null,"Garbage",{"v":75,"d":"$75.00"}]
[null,"Groceries",{"v":350,"d":"$350.00"}]
[null,"Grooming",{"v":50,"d":"$50.00"}]
[null,"Health/Fitness club",{"v":100,"d":"$100.00"}]
[null,"Insurance",{"v":500,"d":"$500.00"}]
[null,"Investment account",{"v":250,"d":"$250.00"}]
[null,"Lunch money",{"v":150,"d":"$150.00"}]
[null,"Mortgage",{"v":7050,"d":"$7,050.00"}]
[null,"Movies",{"v":112,"d":"$112.00"}]
[null,"Other",{"v":50,"d":"$50.00"}]
[null,"Savings",{"v":250,"d":"$250.00"}]
[null,"Water/sewer",{"v":50,"d":"$50.00"}]
[null,"Grand Total",{"v":10742,"d":"$10,742.00"}]

{"sheet":"Data lists","index":4,"n_rows":8,"n_cols":13,"rows_kept":8,"merged":[[0,1,0,11]]}
["Enter Category data in this worksheet to populate the drop-down lists in the Expenditures table on Expenditures & Income worksheet. Modify category names or descriptions below each category to update the lists. Helpful instructions on how to use this worksheet are in cells in this column. Title of the workbook is in cell at right and worksheet title in cell M1.",{"$f":"Semi_Monthly_Home_Budget_Title","v":"Semi-monthly home budget"},{"$nulls":10},"DATA LISTS"]
["Tip is in cell at right.","SETUP         The category data below populates the drop down lists in the expenditures table on the expenditures & income sheet. Modify the category names or the descriptions below each category to update the lists."]
["Enter or modify category names or descriptions below each category in the table starting in cell at right.","Household","Entertainment","Food","Gifts/Donations","Children","Investment accounts","Medical","Other","Personal","Pets","Taxes/Legal","Transportation"]
[null,"Mortgage","Movies","Groceries","Charity 1","Clothes","IRA","Doctor/Clinic","Other","Clothing","Food","Federal","Car 1 payment "]
[null,"Electricity","Video/Movies","Dining out","Charity 2","Toys/Games","Savings","Insurance","Organization dues","Hair/Nails","Supplies","State","Car 2 payment "]
[null,"Water/Sewer","Music",null,"Charity 3","Lunch money","Checking",null,null,"Dry cleaning","Medical","Local","Car insurance"]
[null,"Garbage","Concerts/Theater",null,"Gift","Dues/Fees","Retirement",null,null,"Health/Fitness club","Grooming","Other","Licensing/Registration"]
[null,"Cell phone","Sporting events",null,null,"School supplies","Investment account",null,null,"Shopping","Other","Attorney","Fuel"]

{"sheet":"Category PivotTable","index":5,"n_rows":13,"n_cols":13,"rows_kept":13,"hidden":true}
[null,"Semi-Monthly Home Budget",{"$nulls":10},"CATEGORY PIVOT"]
[null,"This PivotTable is the data source for the Category Totals PivotChart on the Budget Report. "]
[null,"Row Labels","Sum of AMOUNT"]
[null,"Children",{"v":150,"d":"$150"}]
[null,"Entertainment",{"v":112,"d":"$112"}]
[null,"Food",{"v":425,"d":"$425"}]
[null,"Household",{"v":7880,"d":"$7,880"}]
[null,"Investment Accounts",{"v":500,"d":"$500"}]
[null,"Medical",{"v":500,"d":"$500"}]
[null,"Personal",{"v":100,"d":"$100"}]
[null,"Pets",{"v":150,"d":"$150"}]
[null,"Transportation",{"v":925,"d":"$925"}]
[null,"Grand Total",{"v":10742,"d":"$10,742"}]