{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Guide","Annual Cash Flow","Monthly Cash Flow","Daily Cash Flow"],"not_rendered":{"charts":4,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Guide","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[4,1,5,5]]}
[]
[]
[]
[null,"PERSONAL CASH FLOW"]
[null,"This workbook has annual, monthly and daily cash flow worksheets.  Choose the cash flow type that works best for you or use them all to help gain insight on your personal cash flow."]
[]
[]
[]
[null,"Annual Cash Flow",null,"Monthly Cash Flow",null,"Daily Cash Flow"]
[]
[null,"Enter an annual cash flow amount over various areas. See the monthly break down and how everything compares, and most importantly what your bottom line is in both annual and monthly figures.",null,"Enter the monthly cash flow you experience monthly or estimate the remaining months to see the projected cash flow for the year for each month.",null,"Enter an estimated amount of cash flow you experience daily and review the estimated monthly and annual totals.  Use this to get a sense of what your daily spending habits will look like over the course of a month or year."]

{"sheet":"Annual Cash Flow","index":1,"n_rows":48,"n_cols":16,"rows_kept":48,"merged":[[1,1,1,5],[1,7,1,15],[5,2,5,3],[5,6,5,7],[5,10,5,11],[5,14,5,15],[16,1,16,3],[25,2,25,3],[25,6,25,7],[25,10,25,11],[25,14,25,15]]}
[null,"PERSONAL CASH FLOW"]
[null,{"$f":"AnnualCashFlowToDate","v":{"v":39750,"d":"$39,750.00"}},{"$nulls":5},"This is an annual estimation.  Use this worksheet if you wish to view annual amounts with estimated monthly values\nIf you wish to add daily items to the Tables, estimate their annual amount/value and place value in the Annual column."]
[]
[]
[null,"INCOME SUMMARY",{"$nulls":3},"EXPENSES SUMMARY",{"$nulls":3},"DISCRETIONARY SUMMARY",{"$nulls":3},"SAVINGS SUMMARY"]
[null,"Total Annual:",{"$f":"tblIncome[[#Totals],[Annual  ]]","v":{"v":125000,"d":"$125,000.00"}},null,null,"Total Annual:",{"$f":"tblExpenses[[#Totals],[Annual  ]]","v":{"v":49000,"d":"$49,000.00"}},null,null,"Total Annual:",{"$f":"tblDiscretionary[[#Totals],[Annual  ]]","v":{"v":13250,"d":"$13,250.00"}},null,null,"Total Annual:",{"$f":"tblSavings[[#Totals],[Annual  ]]","v":{"v":23000,"d":"$23,000.00"}}]
{"$rows_empty":19}
[null,"Total Monthly:",{"$f":"tblIncome[[#Totals],[Monthly ]]","v":{"v":10416.666666666668,"d":"$10,416.67"}},null,null,"Total Monthly:",{"$f":"tblExpenses[[#Totals],[Monthly ]]","v":{"v":4083.333333333333,"d":"$4,083.33"}},null,null,"Total Monthly:",{"$f":"tblDiscretionary[[#Totals],[Monthly ]]","v":{"v":1104.1666666666665,"d":"$1,104.17"}},null,null,"Total Monthly:",{"$f":"tblSavings[[#Totals],[Monthly ]]","v":{"v":1916.6666666666667,"d":"$1,916.67"}}]
[]
[]
[null,"Income","Annual  ","Monthly ",null,"Expenses","Annual  ","Monthly ",null,"Discretionary Expenses","Annual  ","Monthly ",null,"Savings","Annual  ","Monthly "]
[null,"Salary",{"v":90000,"d":"$90,000.00"},{"$f":"tblIncome[[#This Row],[Annual  ]]/12","v":{"v":7500,"d":"$7,500.00"}},null,"Federal/SS/Medicare",{"v":15000,"d":"$15,000.00"},{"$f":"tblExpenses[[#This Row],[Annual  ]]/12","v":{"v":1250,"d":"$1,250.00"}},null,"Dining",{"v":1200,"d":"$1,200.00"},{"$f":"tblDiscretionary[[#This Row],[Annual  ]]/12","v":{"v":100,"d":"$100.00"}},null,"Cash Reserves",{"v":5000,"d":"$5,000.00"},{"$f":"tblSavings[[#This Row],[Annual  ]]/12","v":{"v":416.6666666666667,"d":"$416.67"}}]
[null,"Commissions/bonus",{"v":5000,"d":"$5,000.00"},{"$f":"tblIncome[[#This Row],[Annual  ]]/12","v":{"v":416.6666666666667,"d":"$416.67"}},null,"State Income Tax",{"v":2500,"d":"$2,500.00"},{"$f":"tblExpenses[[#This Row],[Annual  ]]/12","v":{"v":208.33333333333334,"d":"$208.33"}},null,"Gifts",{"v":600,"d":"$600.00"},{"$f":"tblDiscretionary[[#This Row],[Annual  ]]/12","v":{"v":50,"d":"$50.00"}},null,"401(k)/Etc",{"v":12000,"d":"$12,000.00"},{"$f":"tblSavings[[#This Row],[Annual  ]]/12","v":{"v":1000,"d":"$1,000.00"}}]
[null,"Other 1",{"v":30000,"d":"$30,000.00"},{"$f":"tblIncome[[#This Row],[Annual  ]]/12","v":{"v":2500,"d":"$2,500.00"}},null,"Vehicle Tax/Fees",{"v":200,"d":"$200.00"},{"$f":"tblExpenses[[#This Row],[Annual  ]]/12","v":{"v":16.666666666666668,"d":"$16.67"}},null,"Travel",{"v":2250,"d":"$2,250.00"},{"$f":"tblDiscretionary[[#This Row],[Annual  ]]/12","v":{"v":187.5,"d":"$187.50"}},null,"Savings/Investment",{"v":6000,"d":"$6,000.00"},{"$f":"tblSavings[[#This Row],[Annual  ]]/12","v":{"v":500,"d":"$500.00"}}]
[null,"Other 2",null,{"$f":"tblIncome[[#This Row],[Annual  ]]/12","v":{"v":0,"d":"$0.00"}},null,"Vehicle Payments",{"v":4000,"d":"$4,000.00"},{"$f":"tblExpenses[[#This Row],[Annual  ]]/12","v":{"v":333.3333333333333,"d":"$333.33"}},null,"Entertainment",{"v":1200,"d":"$1,200.00"},{"$f":"tblDiscretionary[[#This Row],[Annual  ]]/12","v":{"v":100,"d":"$100.00"}},null,"Other 1",null,{"$f":"tblSavings[[#This Row],[Annual  ]]/12","v":{"v":0,"d":"$0.00"}}]
[null,"Other 3",null,{"$f":"tblIncome[[#This Row],[Annual  ]]/12","v":{"v":0,"d":"$0.00"}},null,"Mortgage/Rent",{"v":15000,"d":"$15,000.00"},{"$f":"tblExpenses[[#This Row],[Annual  ]]/12","v":{"v":1250,"d":"$1,250.00"}},null,"Personal Care",{"v":300,"d":"$300.00"},{"$f":"tblDiscretionary[[#This Row],[Annual  ]]/12","v":{"v":25,"d":"$25.00"}},null,"Other 2",null,{"$f":"tblSavings[[#This Row],[Annual  ]]/12","v":{"v":0,"d":"$0.00"}}]
[null,"Other 4",null,{"$f":"tblIncome[[#This Row],[Annual  ]]/12","v":{"v":0,"d":"$0.00"}},null,"Insurance",{"v":250,"d":"$250.00"},{"$f":"tblExpenses[[#This Row],[Annual  ]]/12","v":{"v":20.833333333333332,"d":"$20.83"}},null,"Shopping",{"v":2000,"d":"$2,000.00"},{"$f":"tblDiscretionary[[#This Row],[Annual  ]]/12","v":{"v":166.66666666666666,"d":"$166.67"}},null,"Total",{"$f":"SUBTOTAL(109,tblSavings[[Annual  ]])","v":{"v":23000,"d":"$23,000.00"}},{"$f":"SUBTOTAL(109,tblSavings[[Monthly ]])","v":{"v":1916.6666666666667,"d":"$1,916.67"}}]
[null,"Total",{"$f":"SUBTOTAL(109,tblIncome[[Annual  ]])","v":{"v":125000,"d":"$125,000.00"}},{"$f":"SUBTOTAL(109,tblIncome[[Monthly ]])","v":{"v":10416.666666666668,"d":"$10,416.67"}},null,"Electricity",{"v":1200,"d":"$1,200.00"},{"$f":"tblExpenses[[#This Row],[Annual  ]]/12","v":{"v":100,"d":"$100.00"}},null,"Charity",{"v":600,"d":"$600.00"},{"$f":"tblDiscretionary[[#This Row],[Annual  ]]/12","v":{"v":50,"d":"$50.00"}}]
[{"$nulls":5},"Gas",{"v":600,"d":"$600.00"},{"$f":"tblExpenses[[#This Row],[Annual  ]]/12","v":{"v":50,"d":"$50.00"}},null,"Club/Memberships",{"v":300,"d":"$300.00"},{"$f":"tblDiscretionary[[#This Row],[Annual  ]]/12","v":{"v":25,"d":"$25.00"}}]
[{"$nulls":5},"Water/Sewer",{"v":600,"d":"$600.00"},{"$f":"tblExpenses[[#This Row],[Annual  ]]/12","v":{"v":50,"d":"$50.00"}},null,"Home Improvements",{"v":4800,"d":"$4,800.00"},{"$f":"tblDiscretionary[[#This Row],[Annual  ]]/12","v":{"v":400,"d":"$400.00"}}]
[{"$nulls":5},"Garbage",{"v":150,"d":"$150.00"},{"$f":"tblExpenses[[#This Row],[Annual  ]]/12","v":{"v":12.5,"d":"$12.50"}},null,"Other 1",null,{"$f":"tblDiscretionary[[#This Row],[Annual  ]]/12","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},"Phone",{"v":600,"d":"$600.00"},{"$f":"tblExpenses[[#This Row],[Annual  ]]/12","v":{"v":50,"d":"$50.00"}},null,"Other 2",null,{"$f":"tblDiscretionary[[#This Row],[Annual  ]]/12","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},"Internet",{"v":600,"d":"$600.00"},{"$f":"tblExpenses[[#This Row],[Annual  ]]/12","v":{"v":50,"d":"$50.00"}},null,"Total",{"$f":"SUBTOTAL(109,tblDiscretionary[[Annual  ]])","v":{"v":13250,"d":"$13,250.00"}},{"$f":"SUBTOTAL(109,tblDiscretionary[[Monthly ]])","v":{"v":1104.1666666666665,"d":"$1,104.17"}}]
[{"$nulls":5},"Life/Disability Premiums",{"v":1500,"d":"$1,500.00"},{"$f":"tblExpenses[[#This Row],[Annual  ]]/12","v":{"v":125,"d":"$125.00"}}]
[{"$nulls":5},"Food",{"v":5000,"d":"$5,000.00"},{"$f":"tblExpenses[[#This Row],[Annual  ]]/12","v":{"v":416.6666666666667,"d":"$416.67"}}]
[{"$nulls":5},"Clothing",{"v":1200,"d":"$1,200.00"},{"$f":"tblExpenses[[#This Row],[Annual  ]]/12","v":{"v":100,"d":"$100.00"}}]
[{"$nulls":5},"Medical/Dental/Rx",{"v":600,"d":"$600.00"},{"$f":"tblExpenses[[#This Row],[Annual  ]]/12","v":{"v":50,"d":"$50.00"}}]
[{"$nulls":5},"Other 1",null,{"$f":"tblExpenses[[#This Row],[Annual  ]]/12","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},"Other 2",null,{"$f":"tblExpenses[[#This Row],[Annual  ]]/12","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},"Total",{"$f":"SUBTOTAL(109,tblExpenses[[Annual  ]])","v":{"v":49000,"d":"$49,000.00"}},{"$f":"SUBTOTAL(109,tblExpenses[[Monthly ]])","v":{"v":4083.333333333333,"d":"$4,083.33"}}]

{"sheet":"Monthly Cash Flow","index":2,"n_rows":49,"n_cols":16,"rows_kept":49,"merged":[[1,1,1,5],[1,7,1,16],[49,1,49,15]]}
[null,"PERSONAL CASH FLOW"]
[null,{"$f":"MonthlyCashFlowToDate","v":{"v":18380,"d":"$18,380.00"}},{"$nulls":5},"NOTE: For daily items, estimate the monthly amount/value and place that value in the appropriate month column."]
[]
[]
[null,"Type","Description","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Total"]
[null,"Income","Salary",{"v":7500,"d":"$7,500.00"},{"v":7500,"d":"$7,500.00"},{"v":7500,"d":"$7,500.00"},{"v":7500,"d":"$7,500.00"},{"v":7500,"d":"$7,500.00"},{"v":7500,"d":"$7,500.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":45000,"d":"$45,000.00"}}]
[null,"Income","Commissions/bonus",{"v":400,"d":"$400.00"},{"v":400,"d":"$400.00"},{"v":500,"d":"$500.00"},{"v":200,"d":"$200.00"},{"v":0,"d":"$0.00"},{"v":600,"d":"$600.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":2100,"d":"$2,100.00"}}]
[null,"Income","Other 1",{"v":2500,"d":"$2,500.00"},{"v":2500,"d":"$2,500.00"},{"v":2500,"d":"$2,500.00"},{"v":2500,"d":"$2,500.00"},{"v":2500,"d":"$2,500.00"},{"v":2500,"d":"$2,500.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":15000,"d":"$15,000.00"}}]
[null,"Income","Other 2",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"$0.00"}}]
[null,"Income","Other 3",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"$0.00"}}]
[null,"Income","Other 4",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"$0.00"}}]
[null,"Expenses","Federal/SS/Medicare",{"v":1250,"d":"$1,250.00"},{"v":1250,"d":"$1,250.00"},{"v":1250,"d":"$1,250.00"},{"v":1250,"d":"$1,250.00"},{"v":1250,"d":"$1,250.00"},{"v":1250,"d":"$1,250.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":7500,"d":"$7,500.00"}}]
[null,"Expenses","State Income Tax",{"v":208.33333333333334,"d":"$208.33"},{"v":208.33333333333334,"d":"$208.33"},{"v":208.33333333333334,"d":"$208.33"},{"v":208.33333333333334,"d":"$208.33"},{"v":208.33333333333334,"d":"$208.33"},{"v":208.33333333333334,"d":"$208.33"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":1250,"d":"$1,250.00"}}]
[null,"Expenses","Vehicle Tax/Fees",{"v":16.666666666666668,"d":"$16.67"},{"v":16.666666666666668,"d":"$16.67"},{"v":16.666666666666668,"d":"$16.67"},{"v":16.666666666666668,"d":"$16.67"},{"v":16.666666666666668,"d":"$16.67"},{"v":16.666666666666668,"d":"$16.67"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":100.00000000000001,"d":"$100.00"}}]
[null,"Expenses","Vehicle Payments",{"v":333.3333333333333,"d":"$333.33"},{"v":333.3333333333333,"d":"$333.33"},{"v":333.3333333333333,"d":"$333.33"},{"v":333.3333333333333,"d":"$333.33"},{"v":333.3333333333333,"d":"$333.33"},{"v":333.3333333333333,"d":"$333.33"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":1999.9999999999998,"d":"$2,000.00"}}]
[null,"Expenses","Mortgage/Rent",{"v":1250,"d":"$1,250.00"},{"v":1250,"d":"$1,250.00"},{"v":1250,"d":"$1,250.00"},{"v":1250,"d":"$1,250.00"},{"v":1250,"d":"$1,250.00"},{"v":1250,"d":"$1,250.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":7500,"d":"$7,500.00"}}]
[null,"Expenses","Insurance",{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"$150.00"}}]
[null,"Expenses","Electricity",{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":600,"d":"$600.00"}}]
[null,"Expenses","Gas",{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"$300.00"}}]
[null,"Expenses","Water",{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"$300.00"}}]
[null,"Expenses","Sewer",{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"$150.00"}}]
[null,"Expenses","Garbage",{"v":12.5,"d":"$12.50"},{"v":12.5,"d":"$12.50"},{"v":12.5,"d":"$12.50"},{"v":12.5,"d":"$12.50"},{"v":12.5,"d":"$12.50"},{"v":12.5,"d":"$12.50"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":75,"d":"$75.00"}}]
[null,"Expenses","Phone",{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"$300.00"}}]
[null,"Expenses","Internet",{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"$300.00"}}]
[null,"Expenses","Life/Disability Premiums",{"v":125,"d":"$125.00"},{"v":125,"d":"$125.00"},{"v":125,"d":"$125.00"},{"v":125,"d":"$125.00"},{"v":125,"d":"$125.00"},{"v":125,"d":"$125.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":750,"d":"$750.00"}}]
[null,"Expenses","Food",{"v":400,"d":"$400.00"},{"v":500,"d":"$500.00"},{"v":450,"d":"$450.00"},{"v":400,"d":"$400.00"},{"v":450,"d":"$450.00"},{"v":425,"d":"$425.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":2625,"d":"$2,625.00"}}]
[null,"Expenses","Clothing",{"v":50,"d":"$50.00"},{"v":75,"d":"$75.00"},{"v":100,"d":"$100.00"},{"v":75,"d":"$75.00"},{"v":125,"d":"$125.00"},{"v":75,"d":"$75.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":500,"d":"$500.00"}}]
[null,"Expenses","Medical/Dental/Rx",{"v":50,"d":"$50.00"},{"v":10,"d":"$10.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":20,"d":"$20.00"},{"v":70,"d":"$70.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":200,"d":"$200.00"}}]
[null,"Expenses","Bus",{"v":30,"d":"$30.00"},{"v":30,"d":"$30.00"},{"v":30,"d":"$30.00"},{"v":20,"d":"$20.00"},{"v":30,"d":"$30.00"},{"v":30,"d":"$30.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":170,"d":"$170.00"}}]
[null,"Expenses","Other 2",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"$0.00"}}]
[null,"Expenses","Other 3",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"$0.00"}}]
[null,"Expenses","Other 4",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"$0.00"}}]
[null,"Discretionary","Dining",{"v":50,"d":"$50.00"},{"v":150,"d":"$150.00"},{"v":100,"d":"$100.00"},{"v":50,"d":"$50.00"},{"v":150,"d":"$150.00"},{"v":100,"d":"$100.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":600,"d":"$600.00"}}]
[null,"Discretionary","Gifts",{"v":25,"d":"$25.00"},{"v":75,"d":"$75.00"},{"v":50,"d":"$50.00"},{"v":25,"d":"$25.00"},{"v":75,"d":"$75.00"},{"v":50,"d":"$50.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"$300.00"}}]
[null,"Discretionary","Travel",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":1000,"d":"$1,000.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":1000,"d":"$1,000.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":2000,"d":"$2,000.00"}}]
[null,"Discretionary","Entertainment",{"v":50,"d":"$50.00"},{"v":150,"d":"$150.00"},{"v":100,"d":"$100.00"},{"v":50,"d":"$50.00"},{"v":150,"d":"$150.00"},{"v":100,"d":"$100.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":600,"d":"$600.00"}}]
[null,"Discretionary","Personal Care",{"v":15,"d":"$15.00"},{"v":25,"d":"$25.00"},{"v":35,"d":"$35.00"},{"v":15,"d":"$15.00"},{"v":25,"d":"$25.00"},{"v":35,"d":"$35.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"$150.00"}}]
[null,"Discretionary","Shopping",{"v":100,"d":"$100.00"},{"v":200,"d":"$200.00"},{"v":150,"d":"$150.00"},{"v":175,"d":"$175.00"},{"v":150,"d":"$150.00"},{"v":175,"d":"$175.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":950,"d":"$950.00"}}]
[null,"Discretionary","Charity",{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"$300.00"}}]
[null,"Discretionary","Club/Memberships",{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"$150.00"}}]
[null,"Discretionary","Home Improvements",{"v":400,"d":"$400.00"},{"v":400,"d":"$400.00"},{"v":400,"d":"$400.00"},{"v":400,"d":"$400.00"},{"v":400,"d":"$400.00"},{"v":400,"d":"$400.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":2400,"d":"$2,400.00"}}]
[null,"Discretionary","Other 1",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"$0.00"}}]
[null,"Discretionary","Other 2",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"$0.00"}}]
[null,"Savings","Cash Reserves",{"v":416.6666666666667,"d":"$416.67"},{"v":416.6666666666667,"d":"$416.67"},{"v":416.6666666666667,"d":"$416.67"},{"v":416.6666666666667,"d":"$416.67"},{"v":416.6666666666667,"d":"$416.67"},{"v":416.6666666666667,"d":"$416.67"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":2500,"d":"$2,500.00"}}]
[null,"Savings","401(k)/Etc",{"v":1000,"d":"$1,000.00"},{"v":1000,"d":"$1,000.00"},{"v":1000,"d":"$1,000.00"},{"v":1000,"d":"$1,000.00"},{"v":1000,"d":"$1,000.00"},{"v":1000,"d":"$1,000.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":6000,"d":"$6,000.00"}}]
[null,"Savings","Savings/Investment Account",{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":3000,"d":"$3,000.00"}}]
[null,"Savings","Other 1",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"$0.00"}}]
[null,"Savings","Other 2",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"$0.00"}}]
[null,"Total",null,{"$f":"SUMIF(tblMontly[Type],\"Income\",tblMontly[Jan])-SUMIF(tblMontly[Type],\"<>Income\",tblMontly[Jan])","v":{"v":3692.5,"d":"$3,692.50"}},{"$f":"SUMIF(tblMontly[Type],\"Income\",tblMontly[Feb])-SUMIF(tblMontly[Type],\"<>Income\",tblMontly[Feb])","v":{"v":3247.5,"d":"$3,247.50"}},{"$f":"SUMIF(tblMontly[Type],\"Income\",tblMontly[Mar])-SUMIF(tblMontly[Type],\"<>Income\",tblMontly[Mar])","v":{"v":2522.5,"d":"$2,522.50"}},{"$f":"SUMIF(tblMontly[Type],\"Income\",tblMontly[Apr])-SUMIF(tblMontly[Type],\"<>Income\",tblMontly[Apr])","v":{"v":3427.5,"d":"$3,427.50"}},{"$f":"SUMIF(tblMontly[Type],\"Income\",tblMontly[May])-SUMIF(tblMontly[Type],\"<>Income\",tblMontly[May])","v":{"v":2887.5,"d":"$2,887.50"}},{"$f":"SUMIF(tblMontly[Type],\"Income\",tblMontly[Jun])-SUMIF(tblMontly[Type],\"<>Income\",tblMontly[Jun])","v":{"v":2602.5,"d":"$2,602.50"}},{"$f":"SUMIF(tblMontly[Type],\"Income\",tblMontly[Jul])-SUMIF(tblMontly[Type],\"<>Income\",tblMontly[Jul])","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF(tblMontly[Type],\"Income\",tblMontly[Aug])-SUMIF(tblMontly[Type],\"<>Income\",tblMontly[Aug])","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF(tblMontly[Type],\"Income\",tblMontly[Sep])-SUMIF(tblMontly[Type],\"<>Income\",tblMontly[Sep])","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF(tblMontly[Type],\"Income\",tblMontly[Oct])-SUMIF(tblMontly[Type],\"<>Income\",tblMontly[Oct])","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF(tblMontly[Type],\"Income\",tblMontly[Nov])-SUMIF(tblMontly[Type],\"<>Income\",tblMontly[Nov])","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF(tblMontly[Type],\"Income\",tblMontly[Dec])-SUMIF(tblMontly[Type],\"<>Income\",tblMontly[Dec])","v":{"v":0,"d":"$0.00"}},{"$f":"SUMIF(tblMontly[Type],\"Income\",tblMontly[Total])-SUMIF(tblMontly[Type],\"<>Income\",tblMontly[Total])","v":{"v":18380,"d":"$18,380.00"}}]

{"sheet":"Daily Cash Flow","index":3,"n_rows":56,"n_cols":8,"rows_kept":56,"merged":[[1,1,1,5],[1,7,1,16],[9,1,9,5]]}
[null,"PERSONAL CASH FLOW"]
[null,{"$f":"DailyCashFlow","v":{"v":577.8399999999999,"d":"$577.84"}},{"$nulls":5},"NOTE: If you wish to add daily items to the Table, estimate their monthly amount/value and place value in the appropriate month column."]
[]
[null,"DAILY SUMMARY"]
[null,"TOTALS"," ","Daily","Monthly","Annual "]
[null,"Income",null,{"$f":"SUMIF(tblDaily[Type],tblDailyTotals[[#This Row],[TOTALS]],tblDaily[Daily])","v":{"v":342.47,"d":"$342.47"}},{"$f":"SUMIF(tblDaily[Type],tblDailyTotals[[#This Row],[TOTALS]],tblDaily[Monthly])","v":{"v":10416.795833333334,"d":"$10,416.80"}},{"$f":"SUMIF(tblDaily[Type],tblDailyTotals[[#This Row],[TOTALS]],tblDaily[Annual])","v":{"v":125001.55000000002,"d":"$125,001.55"}}]
[null,"Expenses",null,{"$f":"SUMIF(tblDaily[Type],tblDailyTotals[[#This Row],[TOTALS]],tblDaily[Daily])","v":{"v":136.05999999999997,"d":"$136.06"}},{"$f":"SUMIF(tblDaily[Type],tblDailyTotals[[#This Row],[TOTALS]],tblDaily[Monthly])","v":{"v":4138.491666666667,"d":"$4,138.49"}},{"$f":"SUMIF(tblDaily[Type],tblDailyTotals[[#This Row],[TOTALS]],tblDaily[Annual])","v":{"v":49661.899999999994,"d":"$49,661.90"}}]
[null,"Discretionary",null,{"$f":"SUMIF(tblDaily[Type],tblDailyTotals[[#This Row],[TOTALS]],tblDaily[Daily])","v":{"v":36.29,"d":"$36.29"}},{"$f":"SUMIF(tblDaily[Type],tblDailyTotals[[#This Row],[TOTALS]],tblDaily[Monthly])","v":{"v":1103.8208333333334,"d":"$1,103.82"}},{"$f":"SUMIF(tblDaily[Type],tblDailyTotals[[#This Row],[TOTALS]],tblDaily[Annual])","v":{"v":13245.849999999999,"d":"$13,245.85"}}]
[null,"Savings",null,{"$f":"SUMIF(tblDaily[Type],tblDailyTotals[[#This Row],[TOTALS]],tblDaily[Daily])","v":{"v":63.019999999999996,"d":"$63.02"}},{"$f":"SUMIF(tblDaily[Type],tblDailyTotals[[#This Row],[TOTALS]],tblDaily[Monthly])","v":{"v":1916.8583333333333,"d":"$1,916.86"}},{"$f":"SUMIF(tblDaily[Type],tblDailyTotals[[#This Row],[TOTALS]],tblDaily[Annual])","v":{"v":23002.300000000003,"d":"$23,002.30"}}]
[]
[]
[null,"Type","Description","Daily","Monthly","Annual"]
[null,"Income","Salary",{"v":246.58,"d":"$246.58"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":7500.141666666667,"d":"$7,500.14"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":90001.70000000001,"d":"$90,001.70"}}]
[null,"Income","Commissions/bonus",{"v":13.7,"d":"$13.70"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":416.7083333333333,"d":"$416.71"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":5000.5,"d":"$5,000.50"}}]
[null,"Income","Other 1",{"v":82.19,"d":"$82.19"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":2499.945833333333,"d":"$2,499.95"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":29999.35,"d":"$29,999.35"}}]
[null,"Income","Other 2",{"v":0,"d":"$0.00"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":0,"d":"$0.00"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":0,"d":"$0.00"}}]
[null,"Income","Other 3",{"v":0,"d":"$0.00"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":0,"d":"$0.00"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":0,"d":"$0.00"}}]
[null,"Income","Other 4",{"v":0,"d":"$0.00"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":0,"d":"$0.00"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":0,"d":"$0.00"}}]
[null,"Expenses","Federal/SS/Medicare",{"v":41.1,"d":"$41.10"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":1250.125,"d":"$1,250.13"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":15001.5,"d":"$15,001.50"}}]
[null,"Expenses","State Income Tax",{"v":6.85,"d":"$6.85"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":208.35416666666666,"d":"$208.35"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":2500.25,"d":"$2,500.25"}}]
[null,"Expenses","Vehicle Tax/Fees",{"v":0.55,"d":"$0.55"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":16.729166666666668,"d":"$16.73"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":200.75000000000003,"d":"$200.75"}}]
[null,"Expenses","Vehicle Payments",{"v":10.96,"d":"$10.96"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":333.3666666666667,"d":"$333.37"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":4000.4,"d":"$4,000.40"}}]
[null,"Expenses","Mortgage/Rent",{"v":41.1,"d":"$41.10"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":1250.125,"d":"$1,250.13"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":15001.5,"d":"$15,001.50"}}]
[null,"Expenses","Insurance",{"v":0.68,"d":"$0.68"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":20.683333333333334,"d":"$20.68"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":248.20000000000002,"d":"$248.20"}}]
[null,"Expenses","Electricity",{"v":3.29,"d":"$3.29"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":100.07083333333333,"d":"$100.07"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":1200.85,"d":"$1,200.85"}}]
[null,"Expenses","Gas",{"v":1.64,"d":"$1.64"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":49.883333333333326,"d":"$49.88"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":598.5999999999999,"d":"$598.60"}}]
[null,"Expenses","Water",{"v":1.64,"d":"$1.64"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":49.883333333333326,"d":"$49.88"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":598.5999999999999,"d":"$598.60"}}]
[null,"Expenses","Sewer",{"v":0.82,"d":"$0.82"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":24.941666666666663,"d":"$24.94"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":299.29999999999995,"d":"$299.30"}}]
[null,"Expenses","Garbage",{"v":0.41,"d":"$0.41"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":12.470833333333331,"d":"$12.47"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":149.64999999999998,"d":"$149.65"}}]
[null,"Expenses","Phone",{"v":1.64,"d":"$1.64"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":49.883333333333326,"d":"$49.88"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":598.5999999999999,"d":"$598.60"}}]
[null,"Expenses","Internet",{"v":1.64,"d":"$1.64"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":49.883333333333326,"d":"$49.88"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":598.5999999999999,"d":"$598.60"}}]
[null,"Expenses","Life/Disability Premiums",{"v":4.11,"d":"$4.11"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":125.0125,"d":"$125.01"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":1500.15,"d":"$1,500.15"}}]
[null,"Expenses","Food",{"v":13.7,"d":"$13.70"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":416.7083333333333,"d":"$416.71"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":5000.5,"d":"$5,000.50"}}]
[null,"Expenses","Clothing",{"v":3.29,"d":"$3.29"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":100.07083333333333,"d":"$100.07"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":1200.85,"d":"$1,200.85"}}]
[null,"Expenses","Medical/Dental/Rx",{"v":1.64,"d":"$1.64"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":49.883333333333326,"d":"$49.88"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":598.5999999999999,"d":"$598.60"}}]
[null,"Expenses","Bus",{"v":1,"d":"$1.00"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":30.416666666666668,"d":"$30.42"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":365,"d":"$365.00"}}]
[null,"Expenses","Other 2",{"v":0,"d":"$0.00"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":0,"d":"$0.00"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":0,"d":"$0.00"}}]
[null,"Expenses","Other 3",{"v":0,"d":"$0.00"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":0,"d":"$0.00"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":0,"d":"$0.00"}}]
[null,"Expenses","Other 4",{"v":0,"d":"$0.00"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":0,"d":"$0.00"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":0,"d":"$0.00"}}]
[null,"Discretionary","Dining",{"v":3.29,"d":"$3.29"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":100.07083333333333,"d":"$100.07"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":1200.85,"d":"$1,200.85"}}]
[null,"Discretionary","Gifts",{"v":1.64,"d":"$1.64"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":49.883333333333326,"d":"$49.88"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":598.5999999999999,"d":"$598.60"}}]
[null,"Discretionary","Travel",{"v":6.16,"d":"$6.16"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":187.36666666666667,"d":"$187.37"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":2248.4,"d":"$2,248.40"}}]
[null,"Discretionary","Entertainment",{"v":3.29,"d":"$3.29"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":100.07083333333333,"d":"$100.07"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":1200.85,"d":"$1,200.85"}}]
[null,"Discretionary","Personal Care",{"v":0.82,"d":"$0.82"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":24.941666666666663,"d":"$24.94"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":299.29999999999995,"d":"$299.30"}}]
[null,"Discretionary","Shopping",{"v":5.48,"d":"$5.48"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":166.68333333333334,"d":"$166.68"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":2000.2,"d":"$2,000.20"}}]
[null,"Discretionary","Charity",{"v":1.64,"d":"$1.64"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":49.883333333333326,"d":"$49.88"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":598.5999999999999,"d":"$598.60"}}]
[null,"Discretionary","Club/Memberships",{"v":0.82,"d":"$0.82"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":24.941666666666663,"d":"$24.94"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":299.29999999999995,"d":"$299.30"}}]
[null,"Discretionary","Home Improvements",{"v":13.15,"d":"$13.15"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":399.9791666666667,"d":"$399.98"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":4799.75,"d":"$4,799.75"}}]
[null,"Discretionary","Other 1",{"v":0,"d":"$0.00"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":0,"d":"$0.00"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":0,"d":"$0.00"}}]
[null,"Discretionary","Other 2",{"v":0,"d":"$0.00"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":0,"d":"$0.00"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":0,"d":"$0.00"}}]
[null,"Savings","Cash Reserves",{"v":13.7,"d":"$13.70"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":416.7083333333333,"d":"$416.71"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":5000.5,"d":"$5,000.50"}}]
[null,"Savings","401(k)/Etc",{"v":32.88,"d":"$32.88"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":1000.1,"d":"$1,000.10"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":12001.2,"d":"$12,001.20"}}]
[null,"Savings","Savings/Investment Account",{"v":16.44,"d":"$16.44"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":500.05,"d":"$500.05"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":6000.6,"d":"$6,000.60"}}]
[null,"Savings","Other 1",{"v":0,"d":"$0.00"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":0,"d":"$0.00"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":0,"d":"$0.00"}}]
[null,"Savings","Other 2",{"v":0,"d":"$0.00"},{"$f":"tblDaily[[#This Row],[Annual]]/12","v":{"v":0,"d":"$0.00"}},{"$f":"tblDaily[[#This Row],[Daily]]*365","v":{"v":0,"d":"$0.00"}}]
[null,"Total",null,{"$f":"SUMIF(tblDaily[Type],\"Income\",tblDaily[Daily])-SUMIF(tblDaily[Type],\"<>Income\",tblDaily[Daily])","v":{"v":107.10000000000014,"d":"$107.10"}},{"$f":"SUMIF(tblDaily[Type],\"Income\",tblDaily[Monthly])-SUMIF(tblDaily[Type],\"<>Income\",tblDaily[Monthly])","v":{"v":3257.625,"d":"$3,257.63"}},{"$f":"SUMIF(tblDaily[Type],\"Income\",tblDaily[Annual])-SUMIF(tblDaily[Type],\"<>Income\",tblDaily[Annual])","v":{"v":39091.500000000015,"d":"$39,091.50"}}]