{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Summary","Transactions","GUIDE","A-Expense (1-15)","B-Expense (16-31)","C-Analysis %","Item Analysis"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":44,"n_cols":12,"rows_kept":44,"hidden":true,"merged":[[1,1,1,7],[1,8,1,11],[2,1,3,6],[2,8,2,11],[3,8,4,12],[4,1,5,6],[7,1,8,4],[7,9,7,10],[11,3,14,3],[11,4,14,4],[12,8,12,10],[13,8,13,10],[14,8,14,10],[15,8,15,10],[16,8,16,10],[19,1,19,5],[20,3,20,5],[20,9,20,11],[21,3,21,5],[21,9,21,11],[22,3,22,5],[22,9,22,11],[23,1,23,2],[26,1,26,2],[26,7,26,8],[27,1,27,2],[27,7,27,8],[28,1,28,2],[28,7,28,8],[29,1,29,2],[29,7,29,8],[30,1,30,2],[30,7,30,8],[31,1,31,2],[31,7,31,8],[32,1,32,2],[32,7,32,8],[33,1,33,2],[33,7,33,8],[34,1,34,2],[34,7,34,8],[35,1,35,2],[35,7,35,8],[36,1,36,2],[36,7,36,8],[37,1,37,2],[37,7,37,8],[38,1,38,2],[38,7,38,8],[39,1,39,2],[39,7,39,8],[40,1,40,2],[40,7,40,8],[43,1,43,2],[43,7,43,8]]}
[]
[null,"GET STARTED",{"$nulls":6},"NOTE"]
[null,"Set your starting balance in cell L8, then customize your categories and planned spending amounts in the 'Income' and 'Expenses' tables below.",{"$nulls":6},"Only edit highlighted cells."]
[{"$nulls":8},"Try not to alter cells that contain a formula. "]
[null,"As you enter data in the 'Transactions' tab, this sheet will automatically update to show a summary of your spending for the month."]
[]
[]
[null,"Monthly Budget",{"$nulls":7},"Starting balance: ",null,{"v":1000,"d":"$1,000"}]
[]
[]
[]
[{"$nulls":3},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"SPARKLINE(D17,{\"\"charttype\"\",\"\"column\"\";\"\"ymin\"\", 0; \"\"ymax\"\",MAX(D17:E17);\"\"firstcolor\"\",\"\"#334960\"\"})\"),\"\")","v":""},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"SPARKLINE(E17,{\"\"charttype\"\",\"\"column\"\";\"\"ymin\"\", 0; \"\"ymax\"\",max(D17:E17);\"\"firstcolor\"\",\"\"#f46524\"\"})\"),\"\")","v":""}]
[{"$nulls":8},{"$f":"IFERROR(E17/D17-1, \"\")","v":{"v":0.5,"d":"+50%"}}]
[{"$nulls":8},{"$f":"IF(I13 < 0, \"Decrease in total savings\", \"Increase in total savings\")","v":"Increase in total savings"}]
[{"$nulls":8},{"$f":"IFERROR(E17-D17, 0)","v":{"v":500,"d":"$500"}}]
[{"$nulls":3},"START BALANCE "," END BALANCE",{"$nulls":3},{"$f":"IF(J15<0, \"Spent this month\", \"Saved this month\")","v":"Saved this month"}]
[{"$nulls":3},{"$f":"IF(ISBLANK(L8),0,L8)","v":{"v":1000,"d":"$1,000"}},{"$f":"D17+(I22-C22)","v":{"v":1500,"d":"$1,500"}}]
[]
[]
[null,"Expenses",{"$nulls":5},"Income"]
[null,"Planned",{"$f":"D26","v":{"v":950,"d":"$950"}},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"SPARKLINE(C21,{\"\"charttype\"\",\"\"bar\"\";\"\"max\"\",max(C21:C22);\"\"color1\"\",\"\"#AEB7C0\"\"})\"),\"\")","v":""},{"$nulls":3},"Planned",{"$f":"J26","v":{"v":1450,"d":"$1,450"}},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"SPARKLINE(I21,{\"\"charttype\"\",\"\"bar\"\";\"\"max\"\",max(I21:I22);\"\"color1\"\",\"\"#AEB7C0\"\"})\"),\"\")","v":""}]
[null,"Actual",{"$f":"E26","v":{"v":1000,"d":"$1,000"}},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"SPARKLINE(C22,{\"\"charttype\"\",\"\"bar\"\";\"\"max\"\",max(C21:C22);\"\"color1\"\",\"\"#334960\"\"})\"),\"\")","v":""},{"$nulls":3},"Actual",{"$f":"K26","v":{"v":1500,"d":"$1,500"}},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"SPARKLINE(I22,{\"\"charttype\"\",\"\"bar\"\";\"\"max\"\",max(I21:I22);\"\"color1\"\",\"\"#334960\"\"})\"),\"\")","v":""}]
[]
[null,"Expenses",{"$nulls":5},"Income"]
[{"$nulls":3},"Planned","Actual","Diff.",{"$nulls":3},"Planned","Actual","Diff."]
[null,"Totals",null,{"$f":"SUM(D27:D44)","v":{"v":950,"d":"$950"}},{"v":1000,"d":"$1,000"},{"v":-50,"d":"-$50"},null,"Totals",null,{"$f":"SUM(J27:J44)","v":{"v":1450,"d":"$1,450"}},{"v":1500,"d":"$1,500"},{"v":50,"d":"+$50"}]
[{"$nulls":4},{"$f":"IF(ISBLANK($B27), \"\", SUMIF(Transactions!$E:$E,$B27,Transactions!$C:$C))","v":""},{"$f":"IF(ISBLANK($B27), \"\", D27-E27)","v":""},{"$nulls":4},{"$f":"IF(ISBLANK($H27), \"\", SUMIF(Transactions!$J:$J,$H27,Transactions!$H:$H))","v":""},{"$f":"IF(ISBLANK($H27), \"\", K27-J27)","v":""}]
[null,"Food",null,{"v":0,"d":"$0"},{"$f":"IF(ISBLANK($B28), \"\", SUMIF(Transactions!$E:$E,$B28,Transactions!$C:$C))","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},null,"Savings",null,{"v":0,"d":"$0"},{"$f":"IF(ISBLANK($H28), \"\", SUMIF(Transactions!$J:$J,$H28,Transactions!$H:$H))","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
[null,"Gifts",null,{"v":0,"d":"$0"},{"$f":"IF(ISBLANK($B29), \"\", SUMIF(Transactions!$E:$E,$B29,Transactions!$C:$C))","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},null,"Paycheck",null,{"v":1450,"d":"$1,450"},{"$f":"IF(ISBLANK($H29), \"\", SUMIF(Transactions!$J:$J,$H29,Transactions!$H:$H))","v":{"v":1500,"d":"$1,500"}},{"v":50,"d":"+$50"}]
[null,"Health/medical",null,{"v":0,"d":"$0"},{"$f":"IF(ISBLANK($B30), \"\", SUMIF(Transactions!$E:$E,$B30,Transactions!$C:$C))","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},null,"Bonus",null,{"v":0,"d":"$0"},{"$f":"IF(ISBLANK($H30), \"\", SUMIF(Transactions!$J:$J,$H30,Transactions!$H:$H))","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
[null,"Home",null,{"v":950,"d":"$950"},{"$f":"IF(ISBLANK($B31), \"\", SUMIF(Transactions!$E:$E,$B31,Transactions!$C:$C))","v":{"v":1000,"d":"$1,000"}},{"v":-50,"d":"-$50"},null,"Interest",null,{"v":0,"d":"$0"},{"$f":"IF(ISBLANK($H31), \"\", SUMIF(Transactions!$J:$J,$H31,Transactions!$H:$H))","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
[null,"Transportation",null,{"v":0,"d":"$0"},{"$f":"IF(ISBLANK($B32), \"\", SUMIF(Transactions!$E:$E,$B32,Transactions!$C:$C))","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},null,"Other",null,{"v":0,"d":"$0"},{"$f":"IF(ISBLANK($H32), \"\", SUMIF(Transactions!$J:$J,$H32,Transactions!$H:$H))","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
[null,"Personal",null,{"v":0,"d":"$0"},{"$f":"IF(ISBLANK($B33), \"\", SUMIF(Transactions!$E:$E,$B33,Transactions!$C:$C))","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},null,"Custom category ",null,{"v":0,"d":"$0"},{"$f":"IF(ISBLANK($H33), \"\", SUMIF(Transactions!$J:$J,$H33,Transactions!$H:$H))","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"}]
[null,"Pets",null,{"v":0,"d":"$0"},{"$f":"IF(ISBLANK($B34), \"\", SUMIF(Transactions!$E:$E,$B34,Transactions!$C:$C))","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$nulls":4},{"$f":"IF(ISBLANK($H34), \"\", SUMIF(Transactions!$J:$J,$H34,Transactions!$H:$H))","v":""},""]
[null,"Utilities",null,{"v":0,"d":"$0"},{"$f":"IF(ISBLANK($B35), \"\", SUMIF(Transactions!$E:$E,$B35,Transactions!$C:$C))","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$nulls":4},{"$f":"IF(ISBLANK($H35), \"\", SUMIF(Transactions!$J:$J,$H35,Transactions!$H:$H))","v":""},""]
[null,"Travel",null,{"v":0,"d":"$0"},{"$f":"IF(ISBLANK($B36), \"\", SUMIF(Transactions!$E:$E,$B36,Transactions!$C:$C))","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$nulls":4},{"$f":"IF(ISBLANK($H36), \"\", SUMIF(Transactions!$J:$J,$H36,Transactions!$H:$H))","v":""},""]
[null,"Debt",null,{"v":0,"d":"$0"},{"$f":"IF(ISBLANK($B37), \"\", SUMIF(Transactions!$E:$E,$B37,Transactions!$C:$C))","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$nulls":4},{"$f":"IF(ISBLANK($H37), \"\", SUMIF(Transactions!$J:$J,$H37,Transactions!$H:$H))","v":""},""]
[null,"Other",null,{"v":0,"d":"$0"},{"$f":"IF(ISBLANK($B38), \"\", SUMIF(Transactions!$E:$E,$B38,Transactions!$C:$C))","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$nulls":4},{"$f":"IF(ISBLANK($H38), \"\", SUMIF(Transactions!$J:$J,$H38,Transactions!$H:$H))","v":""},""]
[null,"Custom category 1",null,{"v":0,"d":"$0"},{"$f":"IF(ISBLANK($B39), \"\", SUMIF(Transactions!$E:$E,$B39,Transactions!$C:$C))","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$nulls":4},{"$f":"IF(ISBLANK($H39), \"\", SUMIF(Transactions!$J:$J,$H39,Transactions!$H:$H))","v":""},""]
[null,"Custom category 2",null,{"v":0,"d":"$0"},{"$f":"IF(ISBLANK($B40), \"\", SUMIF(Transactions!$E:$E,$B40,Transactions!$C:$C))","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$nulls":4},{"$f":"IF(ISBLANK($H40), \"\", SUMIF(Transactions!$J:$J,$H40,Transactions!$H:$H))","v":""},""]
[null,"Custom category 3",null,{"v":0,"d":"$0"},{"$f":"IF(ISBLANK($B41), \"\", SUMIF(Transactions!$E:$E,$B41,Transactions!$C:$C))","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"$nulls":4},{"$f":"IF(ISBLANK($H41), \"\", SUMIF(Transactions!$J:$J,$H41,Transactions!$H:$H))","v":""},""]
[]
[]
[{"$nulls":4},{"$f":"IF(ISBLANK($B44), \"\", SUMIF(Transactions!$E:$E,$B44,Transactions!$C:$C))","v":""},{"$f":"IF(ISBLANK($B44), \"\", D44-E44)","v":""},{"$nulls":4},{"$f":"IF(ISBLANK($H44), \"\", SUMIF(Transactions!$J:$J,$H44,Transactions!$H:$H))","v":""},{"$f":"IF(ISBLANK($H44), \"\", K44-J44)","v":""}]

{"sheet":"Transactions","index":1,"n_rows":5,"n_cols":10,"rows_kept":5,"hidden":true,"merged":[[0,1,0,9]]}
[null,"Change or add categories by updating the Expenses and Income tables in the Summary sheet."]
[null,"Expenses",{"$nulls":4},"Income"]
[]
[null,"Date","Amount","Description","Category",null,"Date","Amount","Description","Category"]
[null,"2000-12-08",{"v":1000,"d":"$1,000.00"},"Rent","Home",null,"2000-12-08",{"v":1500,"d":"$1,500.00"},"Paycheck","Paycheck"]

{"sheet":"GUIDE","index":2,"n_rows":8,"n_cols":2,"rows_kept":8,"merged":[[2,1,2,8],[5,1,5,8]]}
[]
[]
[null,"How To use this template ?"]
[]
[]
[null,"1- Fill update your expenses based on the calendar date in workshit A or B"]
[]
[null,"2 - "]

{"sheet":"A-Expense (1-15)","index":3,"n_rows":20,"n_cols":13,"rows_kept":20,"merged":[[1,1,1,11],[3,0,18,0]]}
[]
[null,"Monthly Expenses / Spending Record"]
["Exps","Date","Food $","Grocery","Utility","EZ link","Medical","Entertainment"]
["Record spendings in the respective exps",1]
[null,2,240]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8,240]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[]
[null,"TOTAL",{"$f":"SUM(C4:C19)","v":480},{"$f":"SUM(D4:D19)","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"B-Expense (16-31)","index":4,"n_rows":21,"n_cols":13,"rows_kept":21,"merged":[[1,1,1,11],[4,0,19,0]]}
[]
[null,"Monthly Expenses / Spending Record"]
["Exps","Date","Food $","Grocery","Utility","Dining out",null,"Entertainment"]
[null,null,{"$f":"'A-Expense (1-15)'!C20","v":480},{"$f":"'A-Expense (1-15)'!D20","v":0},{"$f":"'A-Expense (1-15)'!E20","v":0},{"$f":"'A-Expense (1-15)'!F20","v":0},{"$f":"'A-Expense (1-15)'!G20","v":0},{"$f":"'A-Expense (1-15)'!H20","v":0},{"$f":"'A-Expense (1-15)'!I20","v":0},{"$f":"'A-Expense (1-15)'!J20","v":0},{"$f":"'A-Expense (1-15)'!K20","v":0},{"$f":"'A-Expense (1-15)'!L20","v":0},{"$f":"'A-Expense (1-15)'!M20","v":0}]
["Record spendings in the respective exps",16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22,240]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27,240]
[null,28]
[null,29]
[null,30]
[null,31]
[null,"TOTAL",{"$f":"SUM(C4:C20)","v":960},{"$f":"SUM(D4:D20)","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"C-Analysis %","index":5,"n_rows":23,"n_cols":7,"rows_kept":23,"merged":[[2,1,2,3],[4,0,15,0],[20,6,21,6]]}
[]
[]
[null,"Monthly Expenses / Spending Analysis",{"$nulls":3},"Salary/Income ",{"v":1,"d":"100%"}]
[null,"Need$ (Essential)","%","Want$ (non-essential)","%","$avings","%"]
["List  expenses in respective category","Food",{"v":40,"d":"40.00"},null,32,null,{"v":23,"d":"23.00"}]
{"$rows_empty":11}
[null,"Total Current % spent",{"$f":"SUM(C5:C16)","v":{"v":40,"d":"40.00"}},"Total Current % spent",null,"Current %"]
[null,"Total target % to be spent",null,"Total target % to be spent",null,"Target %"]
[null,"Increase/(decrease) %",null,"Increase/(decrease) %",null,"Incr / (decr) %"]
[]
[null,"Formula: Expenses/Net Salary x100",null,null,"Food",{"$f":"'B-Expense (16-31)'!C21","v":960},"x100"]
[{"$nulls":5},{"$f":"C23","v":{"v":2400,"d":"2,400"}}]
[null,"Assuming Net Salary =",{"v":2400,"d":"2,400"},null,null,{"$f":"'B-Expense (16-31)'!C21/C23*100","v":40},"%"]

{"sheet":"Item Analysis","index":6,"n_rows":54,"n_cols":6,"rows_kept":54,"hidden":true,"merged":[[0,2,2,2],[0,3,2,3],[0,4,2,4],[0,5,2,5],[20,1,21,1],[33,1,35,1],[49,1,51,1]]}
[null,null,"Enter current actual %","Desirable %  to be achieved","Expected reduction %, if any","Each Exps item reduction %"]
["Monthly Expenses / Spending Analysis "]
[]
["Salary / Income","Don't Change >>",100,100,{"$f":"C4-D4","v":0},"Don't <<Change"]
["Need$ Category (Essentials)"]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},2]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},3]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},0]
[{"$error":"#REF!"},{"$nulls":4},0]
[{"$error":"#REF!"},{"$nulls":4},0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},"1. Enter % spent for this Cat>>>",{"$nulls":3},0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,55,50,{"$f":"C22-D22","v":5},{"$f":"SUM(F6:F21)","v":5}]
[]
["$avings Goal "]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},-2]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},-3]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},0]
[{"$error":"#REF!"},{"$nulls":4},0]
[{"$error":"#REF!"},{"$nulls":4},0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},"2. Enter % of savings goals>>>",{"$nulls":3},0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,25,30,{"$f":"C36-D36","v":-5},{"$f":"SUM(F25:F35)","v":-5}]
[]
["Want$ Category (Non-essentials)"]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":4},10]
[{"$error":"#REF!"},{"$nulls":4},5]
[{"$error":"#REF!"},{"$nulls":4},0]
[{"$error":"#REF!"},{"$nulls":4},0]
[{"$error":"#REF!"},{"$nulls":4},0]
[{"$error":"#REF!"},{"$nulls":4},0]
[{"$error":"#REF!"},{"$nulls":4},0]
[{"$error":"#REF!"},{"$nulls":4},0]
[{"$error":"#REF!"},{"$nulls":4},0]
[{"$error":"#REF!"},{"$nulls":4},0]
[{"$error":"#REF!"},{"$nulls":4},0]
[{"$error":"#REF!"},"3. Enter % spent for this Cat>>>",{"$nulls":3},0]
[{"$error":"#REF!"},{"$nulls":4},0]
[{"$error":"#REF!"},null,35,20,{"$f":"C52-D52","v":15},{"$f":"SUM(F39:F51)","v":15}]
[null,null,{"$f":"C22+C36+C52","v":115},100,15]
["Excess ($pending) / Fund$ available",null,{"$f":"C4-C53","v":{"v":-15,"d":"(15)"}},0,{"v":-15,"d":"(15)"}]