{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Start","Budget wheel","Data"],"not_rendered":{"charts":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"merged":[[0,1,0,6],[1,1,1,6],[2,1,2,6],[3,1,3,6],[4,1,4,6],[5,2,5,6],[7,2,7,6],[9,2,9,6]]}
[null,"About this template"]
[null,"Keep track of your monthly expenses and savings using this template."]
[]
[null,"Enter expense details and monthly income in table to calculate savings. Donut chart showing expenses and savings is auto updated."]
[null,"Note:  Additional instructions have been provided in column A in BUDGET WHEEL worksheet. This text has been intentionally hidden. "]
[null,null,"To remove text, select column A, then select DELETE. "]
[]
[null,null,"To unhide text, select column A, then change font color."]
[]
[null,null,"To learn more about table, press SHIFT and then F10 within the table, select the TABLE option, and then select ALTERNATIVE TEXT."]

{"sheet":"Budget wheel","index":1,"n_rows":25,"n_cols":7,"rows_kept":25,"merged":[[0,1,0,2],[0,3,0,6]]}
[null,"BUDGET WHEEL"]
[null,"Monthly \nincome",{"$nulls":4},"Savings \namount"]
[null,{"v":5738,"d":"$5,738"},{"$nulls":4},{"$f":"Savings","v":{"v":2577,"d":"$2,577"}}]
[]
[{"$nulls":6},"Value calculated \nautomatically"]
[]
[]
[null,"Expenses","Category","Amount","Frequency","Monthly Amount","% of Total"]
[null,"Insurance","Transportation",{"v":300,"d":"$300"},"Every 6 months",{"$f":"IF(Expenses[[#This Row],[Amount]]>0,IF(Expenses[[#This Row],[Frequency]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequency]]=\"Monthly\",Expenses[Amount],IF(Expenses[[#This Row],[Frequency]]=\"Weekly\",Expenses[[#This Row],[Amount]]*4,IF(Expenses[[#This Row],[Frequency]]=\"Quarterly\",Expenses[[#This Row],[Amount]]/3,IF(Expenses[[#This Row],[Frequency]]=\"Every 6 months\",Expenses[[#This Row],[Amount]]/6,IF(Expenses[[#This Row],[Frequency]]=\"Yearly\",Expenses[[#This Row],[Amount]]/12,IF(Expenses[[#This Row],[Frequency]]=\"Every other week\",Expenses[[#This Row],[Amount]]*2,IF(Expenses[[#This Row],[Frequency]]=\"Every other month\",Expenses[[#This Row],[Amount]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":50,"d":"$50"}},{"$f":"IF(Expenses[[#This Row],[Monthly Amount]]<>\"\",Expenses[[#This Row],[Monthly Amount]]/Income,\"\")","v":{"v":0.00871383757406762,"d":"1%"}}]
[null,"Gas","Transportation",{"v":50,"d":"$50"},"Weekly",{"$f":"IF(Expenses[[#This Row],[Amount]]>0,IF(Expenses[[#This Row],[Frequency]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequency]]=\"Monthly\",Expenses[Amount],IF(Expenses[[#This Row],[Frequency]]=\"Weekly\",Expenses[[#This Row],[Amount]]*4,IF(Expenses[[#This Row],[Frequency]]=\"Quarterly\",Expenses[[#This Row],[Amount]]/3,IF(Expenses[[#This Row],[Frequency]]=\"Every 6 months\",Expenses[[#This Row],[Amount]]/6,IF(Expenses[[#This Row],[Frequency]]=\"Yearly\",Expenses[[#This Row],[Amount]]/12,IF(Expenses[[#This Row],[Frequency]]=\"Every other week\",Expenses[[#This Row],[Amount]]*2,IF(Expenses[[#This Row],[Frequency]]=\"Every other month\",Expenses[[#This Row],[Amount]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":200,"d":"$200"}},{"$f":"IF(Expenses[[#This Row],[Monthly Amount]]<>\"\",Expenses[[#This Row],[Monthly Amount]]/Income,\"\")","v":{"v":0.03485535029627048,"d":"3%"}}]
[null,"Car payment","Transportation",{"v":200,"d":"$200"},"Monthly",{"$f":"IF(Expenses[[#This Row],[Amount]]>0,IF(Expenses[[#This Row],[Frequency]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequency]]=\"Monthly\",Expenses[Amount],IF(Expenses[[#This Row],[Frequency]]=\"Weekly\",Expenses[[#This Row],[Amount]]*4,IF(Expenses[[#This Row],[Frequency]]=\"Quarterly\",Expenses[[#This Row],[Amount]]/3,IF(Expenses[[#This Row],[Frequency]]=\"Every 6 months\",Expenses[[#This Row],[Amount]]/6,IF(Expenses[[#This Row],[Frequency]]=\"Yearly\",Expenses[[#This Row],[Amount]]/12,IF(Expenses[[#This Row],[Frequency]]=\"Every other week\",Expenses[[#This Row],[Amount]]*2,IF(Expenses[[#This Row],[Frequency]]=\"Every other month\",Expenses[[#This Row],[Amount]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":200,"d":"$200"}},{"$f":"IF(Expenses[[#This Row],[Monthly Amount]]<>\"\",Expenses[[#This Row],[Monthly Amount]]/Income,\"\")","v":{"v":0.03485535029627048,"d":"3%"}}]
[null,"Mortgage","Home",{"v":1600,"d":"$1,600"},"Monthly",{"$f":"IF(Expenses[[#This Row],[Amount]]>0,IF(Expenses[[#This Row],[Frequency]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequency]]=\"Monthly\",Expenses[Amount],IF(Expenses[[#This Row],[Frequency]]=\"Weekly\",Expenses[[#This Row],[Amount]]*4,IF(Expenses[[#This Row],[Frequency]]=\"Quarterly\",Expenses[[#This Row],[Amount]]/3,IF(Expenses[[#This Row],[Frequency]]=\"Every 6 months\",Expenses[[#This Row],[Amount]]/6,IF(Expenses[[#This Row],[Frequency]]=\"Yearly\",Expenses[[#This Row],[Amount]]/12,IF(Expenses[[#This Row],[Frequency]]=\"Every other week\",Expenses[[#This Row],[Amount]]*2,IF(Expenses[[#This Row],[Frequency]]=\"Every other month\",Expenses[[#This Row],[Amount]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":1600,"d":"$1,600"}},{"$f":"IF(Expenses[[#This Row],[Monthly Amount]]<>\"\",Expenses[[#This Row],[Monthly Amount]]/Income,\"\")","v":{"v":0.27884280237016384,"d":"28%"}}]
[null,"Cable","Home",{"v":60,"d":"$60"},"Monthly",{"$f":"IF(Expenses[[#This Row],[Amount]]>0,IF(Expenses[[#This Row],[Frequency]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequency]]=\"Monthly\",Expenses[Amount],IF(Expenses[[#This Row],[Frequency]]=\"Weekly\",Expenses[[#This Row],[Amount]]*4,IF(Expenses[[#This Row],[Frequency]]=\"Quarterly\",Expenses[[#This Row],[Amount]]/3,IF(Expenses[[#This Row],[Frequency]]=\"Every 6 months\",Expenses[[#This Row],[Amount]]/6,IF(Expenses[[#This Row],[Frequency]]=\"Yearly\",Expenses[[#This Row],[Amount]]/12,IF(Expenses[[#This Row],[Frequency]]=\"Every other week\",Expenses[[#This Row],[Amount]]*2,IF(Expenses[[#This Row],[Frequency]]=\"Every other month\",Expenses[[#This Row],[Amount]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":60,"d":"$60"}},{"$f":"IF(Expenses[[#This Row],[Monthly Amount]]<>\"\",Expenses[[#This Row],[Monthly Amount]]/Income,\"\")","v":{"v":0.010456605088881143,"d":"1%"}}]
[null,"Movie night","Entertainment",{"v":70,"d":"$70"},"Monthly",{"$f":"IF(Expenses[[#This Row],[Amount]]>0,IF(Expenses[[#This Row],[Frequency]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequency]]=\"Monthly\",Expenses[Amount],IF(Expenses[[#This Row],[Frequency]]=\"Weekly\",Expenses[[#This Row],[Amount]]*4,IF(Expenses[[#This Row],[Frequency]]=\"Quarterly\",Expenses[[#This Row],[Amount]]/3,IF(Expenses[[#This Row],[Frequency]]=\"Every 6 months\",Expenses[[#This Row],[Amount]]/6,IF(Expenses[[#This Row],[Frequency]]=\"Yearly\",Expenses[[#This Row],[Amount]]/12,IF(Expenses[[#This Row],[Frequency]]=\"Every other week\",Expenses[[#This Row],[Amount]]*2,IF(Expenses[[#This Row],[Frequency]]=\"Every other month\",Expenses[[#This Row],[Amount]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":70,"d":"$70"}},{"$f":"IF(Expenses[[#This Row],[Monthly Amount]]<>\"\",Expenses[[#This Row],[Monthly Amount]]/Income,\"\")","v":{"v":0.012199372603694667,"d":"1%"}}]
[null,"Sneakers","Misc.",{"v":300,"d":"$300"},"Yearly",{"$f":"IF(Expenses[[#This Row],[Amount]]>0,IF(Expenses[[#This Row],[Frequency]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequency]]=\"Monthly\",Expenses[Amount],IF(Expenses[[#This Row],[Frequency]]=\"Weekly\",Expenses[[#This Row],[Amount]]*4,IF(Expenses[[#This Row],[Frequency]]=\"Quarterly\",Expenses[[#This Row],[Amount]]/3,IF(Expenses[[#This Row],[Frequency]]=\"Every 6 months\",Expenses[[#This Row],[Amount]]/6,IF(Expenses[[#This Row],[Frequency]]=\"Yearly\",Expenses[[#This Row],[Amount]]/12,IF(Expenses[[#This Row],[Frequency]]=\"Every other week\",Expenses[[#This Row],[Amount]]*2,IF(Expenses[[#This Row],[Frequency]]=\"Every other month\",Expenses[[#This Row],[Amount]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":25,"d":"$25"}},{"$f":"IF(Expenses[[#This Row],[Monthly Amount]]<>\"\",Expenses[[#This Row],[Monthly Amount]]/Income,\"\")","v":{"v":0.00435691878703381,"d":"0%"}}]
[null,"Dog food","Misc.",{"v":60,"d":"$60"},"Monthly",{"$f":"IF(Expenses[[#This Row],[Amount]]>0,IF(Expenses[[#This Row],[Frequency]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequency]]=\"Monthly\",Expenses[Amount],IF(Expenses[[#This Row],[Frequency]]=\"Weekly\",Expenses[[#This Row],[Amount]]*4,IF(Expenses[[#This Row],[Frequency]]=\"Quarterly\",Expenses[[#This Row],[Amount]]/3,IF(Expenses[[#This Row],[Frequency]]=\"Every 6 months\",Expenses[[#This Row],[Amount]]/6,IF(Expenses[[#This Row],[Frequency]]=\"Yearly\",Expenses[[#This Row],[Amount]]/12,IF(Expenses[[#This Row],[Frequency]]=\"Every other week\",Expenses[[#This Row],[Amount]]*2,IF(Expenses[[#This Row],[Frequency]]=\"Every other month\",Expenses[[#This Row],[Amount]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":60,"d":"$60"}},{"$f":"IF(Expenses[[#This Row],[Monthly Amount]]<>\"\",Expenses[[#This Row],[Monthly Amount]]/Income,\"\")","v":{"v":0.010456605088881143,"d":"1%"}}]
[null,"Pet insurance","Misc.",{"v":70,"d":"$70"},"Yearly",{"$f":"IF(Expenses[[#This Row],[Amount]]>0,IF(Expenses[[#This Row],[Frequency]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequency]]=\"Monthly\",Expenses[Amount],IF(Expenses[[#This Row],[Frequency]]=\"Weekly\",Expenses[[#This Row],[Amount]]*4,IF(Expenses[[#This Row],[Frequency]]=\"Quarterly\",Expenses[[#This Row],[Amount]]/3,IF(Expenses[[#This Row],[Frequency]]=\"Every 6 months\",Expenses[[#This Row],[Amount]]/6,IF(Expenses[[#This Row],[Frequency]]=\"Yearly\",Expenses[[#This Row],[Amount]]/12,IF(Expenses[[#This Row],[Frequency]]=\"Every other week\",Expenses[[#This Row],[Amount]]*2,IF(Expenses[[#This Row],[Frequency]]=\"Every other month\",Expenses[[#This Row],[Amount]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":6,"d":"$6"}},{"$f":"IF(Expenses[[#This Row],[Monthly Amount]]<>\"\",Expenses[[#This Row],[Monthly Amount]]/Income,\"\")","v":{"v":1.0456605088881143E-3,"d":"0%"}}]
[null,"Groceries","Food",{"v":100,"d":"$100"},"Weekly",{"$f":"IF(Expenses[[#This Row],[Amount]]>0,IF(Expenses[[#This Row],[Frequency]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequency]]=\"Monthly\",Expenses[Amount],IF(Expenses[[#This Row],[Frequency]]=\"Weekly\",Expenses[[#This Row],[Amount]]*4,IF(Expenses[[#This Row],[Frequency]]=\"Quarterly\",Expenses[[#This Row],[Amount]]/3,IF(Expenses[[#This Row],[Frequency]]=\"Every 6 months\",Expenses[[#This Row],[Amount]]/6,IF(Expenses[[#This Row],[Frequency]]=\"Yearly\",Expenses[[#This Row],[Amount]]/12,IF(Expenses[[#This Row],[Frequency]]=\"Every other week\",Expenses[[#This Row],[Amount]]*2,IF(Expenses[[#This Row],[Frequency]]=\"Every other month\",Expenses[[#This Row],[Amount]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":400,"d":"$400"}},{"$f":"IF(Expenses[[#This Row],[Monthly Amount]]<>\"\",Expenses[[#This Row],[Monthly Amount]]/Income,\"\")","v":{"v":0.06971070059254096,"d":"7%"}}]
[null,"Coffee","Food",{"v":25,"d":"$25"},"Weekly",{"$f":"IF(Expenses[[#This Row],[Amount]]>0,IF(Expenses[[#This Row],[Frequency]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequency]]=\"Monthly\",Expenses[Amount],IF(Expenses[[#This Row],[Frequency]]=\"Weekly\",Expenses[[#This Row],[Amount]]*4,IF(Expenses[[#This Row],[Frequency]]=\"Quarterly\",Expenses[[#This Row],[Amount]]/3,IF(Expenses[[#This Row],[Frequency]]=\"Every 6 months\",Expenses[[#This Row],[Amount]]/6,IF(Expenses[[#This Row],[Frequency]]=\"Yearly\",Expenses[[#This Row],[Amount]]/12,IF(Expenses[[#This Row],[Frequency]]=\"Every other week\",Expenses[[#This Row],[Amount]]*2,IF(Expenses[[#This Row],[Frequency]]=\"Every other month\",Expenses[[#This Row],[Amount]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":100,"d":"$100"}},{"$f":"IF(Expenses[[#This Row],[Monthly Amount]]<>\"\",Expenses[[#This Row],[Monthly Amount]]/Income,\"\")","v":{"v":0.01742767514813524,"d":"2%"}}]
[null,"Climbing gear","Entertainment",{"v":170,"d":"$170"},"Yearly",{"$f":"IF(Expenses[[#This Row],[Amount]]>0,IF(Expenses[[#This Row],[Frequency]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequency]]=\"Monthly\",Expenses[Amount],IF(Expenses[[#This Row],[Frequency]]=\"Weekly\",Expenses[[#This Row],[Amount]]*4,IF(Expenses[[#This Row],[Frequency]]=\"Quarterly\",Expenses[[#This Row],[Amount]]/3,IF(Expenses[[#This Row],[Frequency]]=\"Every 6 months\",Expenses[[#This Row],[Amount]]/6,IF(Expenses[[#This Row],[Frequency]]=\"Yearly\",Expenses[[#This Row],[Amount]]/12,IF(Expenses[[#This Row],[Frequency]]=\"Every other week\",Expenses[[#This Row],[Amount]]*2,IF(Expenses[[#This Row],[Frequency]]=\"Every other month\",Expenses[[#This Row],[Amount]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":14,"d":"$14"}},{"$f":"IF(Expenses[[#This Row],[Monthly Amount]]<>\"\",Expenses[[#This Row],[Monthly Amount]]/Income,\"\")","v":{"v":2.4398745207389336E-3,"d":"0%"}}]
[null,"Gym membership","Misc.",{"v":60,"d":"$60"},"Monthly",{"$f":"IF(Expenses[[#This Row],[Amount]]>0,IF(Expenses[[#This Row],[Frequency]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequency]]=\"Monthly\",Expenses[Amount],IF(Expenses[[#This Row],[Frequency]]=\"Weekly\",Expenses[[#This Row],[Amount]]*4,IF(Expenses[[#This Row],[Frequency]]=\"Quarterly\",Expenses[[#This Row],[Amount]]/3,IF(Expenses[[#This Row],[Frequency]]=\"Every 6 months\",Expenses[[#This Row],[Amount]]/6,IF(Expenses[[#This Row],[Frequency]]=\"Yearly\",Expenses[[#This Row],[Amount]]/12,IF(Expenses[[#This Row],[Frequency]]=\"Every other week\",Expenses[[#This Row],[Amount]]*2,IF(Expenses[[#This Row],[Frequency]]=\"Every other month\",Expenses[[#This Row],[Amount]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":60,"d":"$60"}},{"$f":"IF(Expenses[[#This Row],[Monthly Amount]]<>\"\",Expenses[[#This Row],[Monthly Amount]]/Income,\"\")","v":{"v":0.010456605088881143,"d":"1%"}}]
[null,"Headphones","Entertainment",{"v":50,"d":"$50"},"Yearly",{"$f":"IF(Expenses[[#This Row],[Amount]]>0,IF(Expenses[[#This Row],[Frequency]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequency]]=\"Monthly\",Expenses[Amount],IF(Expenses[[#This Row],[Frequency]]=\"Weekly\",Expenses[[#This Row],[Amount]]*4,IF(Expenses[[#This Row],[Frequency]]=\"Quarterly\",Expenses[[#This Row],[Amount]]/3,IF(Expenses[[#This Row],[Frequency]]=\"Every 6 months\",Expenses[[#This Row],[Amount]]/6,IF(Expenses[[#This Row],[Frequency]]=\"Yearly\",Expenses[[#This Row],[Amount]]/12,IF(Expenses[[#This Row],[Frequency]]=\"Every other week\",Expenses[[#This Row],[Amount]]*2,IF(Expenses[[#This Row],[Frequency]]=\"Every other month\",Expenses[[#This Row],[Amount]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":4,"d":"$4"}},{"$f":"IF(Expenses[[#This Row],[Monthly Amount]]<>\"\",Expenses[[#This Row],[Monthly Amount]]/Income,\"\")","v":{"v":6.9710700592540956E-4,"d":"0%"}}]
[null,"Haircut","Misc.",{"v":70,"d":"$70"},"Monthly",{"$f":"IF(Expenses[[#This Row],[Amount]]>0,IF(Expenses[[#This Row],[Frequency]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequency]]=\"Monthly\",Expenses[Amount],IF(Expenses[[#This Row],[Frequency]]=\"Weekly\",Expenses[[#This Row],[Amount]]*4,IF(Expenses[[#This Row],[Frequency]]=\"Quarterly\",Expenses[[#This Row],[Amount]]/3,IF(Expenses[[#This Row],[Frequency]]=\"Every 6 months\",Expenses[[#This Row],[Amount]]/6,IF(Expenses[[#This Row],[Frequency]]=\"Yearly\",Expenses[[#This Row],[Amount]]/12,IF(Expenses[[#This Row],[Frequency]]=\"Every other week\",Expenses[[#This Row],[Amount]]*2,IF(Expenses[[#This Row],[Frequency]]=\"Every other month\",Expenses[[#This Row],[Amount]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":70,"d":"$70"}},{"$f":"IF(Expenses[[#This Row],[Monthly Amount]]<>\"\",Expenses[[#This Row],[Monthly Amount]]/Income,\"\")","v":{"v":0.012199372603694667,"d":"1%"}}]
[null,"Video games","Entertainment",{"v":200,"d":"$200"},"Monthly",{"$f":"IF(Expenses[[#This Row],[Amount]]>0,IF(Expenses[[#This Row],[Frequency]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequency]]=\"Monthly\",Expenses[Amount],IF(Expenses[[#This Row],[Frequency]]=\"Weekly\",Expenses[[#This Row],[Amount]]*4,IF(Expenses[[#This Row],[Frequency]]=\"Quarterly\",Expenses[[#This Row],[Amount]]/3,IF(Expenses[[#This Row],[Frequency]]=\"Every 6 months\",Expenses[[#This Row],[Amount]]/6,IF(Expenses[[#This Row],[Frequency]]=\"Yearly\",Expenses[[#This Row],[Amount]]/12,IF(Expenses[[#This Row],[Frequency]]=\"Every other week\",Expenses[[#This Row],[Amount]]*2,IF(Expenses[[#This Row],[Frequency]]=\"Every other month\",Expenses[[#This Row],[Amount]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":200,"d":"$200"}},{"$f":"IF(Expenses[[#This Row],[Monthly Amount]]<>\"\",Expenses[[#This Row],[Monthly Amount]]/Income,\"\")","v":{"v":0.03485535029627048,"d":"3%"}}]
[null,"Clothes","Misc.",{"v":500,"d":"$500"},"Yearly",{"$f":"IF(Expenses[[#This Row],[Amount]]>0,IF(Expenses[[#This Row],[Frequency]]<>\"\",ROUND(IF(Expenses[[#This Row],[Frequency]]=\"Monthly\",Expenses[Amount],IF(Expenses[[#This Row],[Frequency]]=\"Weekly\",Expenses[[#This Row],[Amount]]*4,IF(Expenses[[#This Row],[Frequency]]=\"Quarterly\",Expenses[[#This Row],[Amount]]/3,IF(Expenses[[#This Row],[Frequency]]=\"Every 6 months\",Expenses[[#This Row],[Amount]]/6,IF(Expenses[[#This Row],[Frequency]]=\"Yearly\",Expenses[[#This Row],[Amount]]/12,IF(Expenses[[#This Row],[Frequency]]=\"Every other week\",Expenses[[#This Row],[Amount]]*2,IF(Expenses[[#This Row],[Frequency]]=\"Every other month\",Expenses[[#This Row],[Amount]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":42,"d":"$42"}},{"$f":"IF(Expenses[[#This Row],[Monthly Amount]]<>\"\",Expenses[[#This Row],[Monthly Amount]]/Income,\"\")","v":{"v":7.3196235622168E-3,"d":"1%"}}]

{"sheet":"Data","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"hidden":true}
["This sheet should remain hidden"]
["Categories","Amount per Category","Percentage of Total","Frequency","Savings"]
["Home",{"$f":"IF(SUMIF(Expenses[Category],\"Home\",Expenses[Monthly Amount])>0,SUMIF(Expenses[Category],\"Home\",Expenses[Monthly Amount]),NA())","v":{"v":1660,"d":"$1,660"}},{"$f":"IF(B3>0,B3/Income,\"\")","v":{"v":0.289299407459045,"d":"29%"}},"Weekly",{"$f":"Income-SUM(Expenses[Monthly Amount])","v":{"v":2577,"d":"$2,577"}}]
["Entertainment",{"$f":"IF(SUMIF(Expenses[Category],\"Entertainment\",Expenses[Monthly Amount])>0,SUMIF(Expenses[Category],\"Entertainment\",Expenses[Monthly Amount]),NA())","v":{"v":288,"d":"$288"}},{"v":0.050191704426629485,"d":"5%"},"Monthly"]
["Transportation",{"$f":"IF(SUMIF(Expenses[Category],\"Transportation\",Expenses[Monthly Amount])>0,SUMIF(Expenses[Category],\"Transportation\",Expenses[Monthly Amount]),NA())","v":{"v":450,"d":"$450"}},{"v":0.07842453816660858,"d":"8%"},"Quarterly"]
["Food",{"$f":"IF(SUMIF(Expenses[Category],\"Food\",Expenses[Monthly Amount])>0,SUMIF(Expenses[Category],\"Food\",Expenses[Monthly Amount]),NA())","v":{"v":500,"d":"$500"}},{"v":0.08713837574067619,"d":"9%"},"Every 6 months"]
["Misc.",{"$f":"IF(SUMIF(Expenses[Category],\"Misc.\",Expenses[Monthly Amount])>0,SUMIF(Expenses[Category],\"Misc.\",Expenses[Monthly Amount]),NA())","v":{"v":263,"d":"$263"}},{"v":0.04583478563959568,"d":"5%"},"Yearly"]
["Savings",{"$f":"IF(E3>0,E3,NA())","v":{"v":2577,"d":"$2,577"}},{"v":0.4491111885674451,"d":"45%"},"Every other week"]
[{"$nulls":3},"Every other month"]
[null,"TOTAL:",{"$f":"SUM(C3:C8)","v":{"v":1,"d":"100%"}}]