{"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":7,"n_cols":2,"rows_kept":7}
[null,"About The Template"]
[null,"Keep track of your monthly expenses and savings using this template."]
[null,"Enter Expense details in the table and Monthly Income to calculate Savings."]
[null,"Doughnut chart showing expenses and savings is auto updated."]
[null,"Note:"]
[null,"Additional instructions have been provided in column A in BUDGET WHEEL worksheet. This text has been intentionally hidden. To remove text, select column A, then select DELETE. To unhide text, select column A, then change font colour."]
[null,"To learn more about the table, press SHIFT and then F10 within the table, select the TABLE option, then select ALTERNATIVE TEXT."]

{"sheet":"Budget Wheel","index":1,"n_rows":23,"n_cols":7,"rows_kept":23,"merged":[[0,1,0,2],[0,3,0,6],[1,2,4,4]]}
["Create a Budget Wheel in this worksheet. The title of the worksheet is in the cell at right and tip in cell D1. Other helpful instructions on how to use this worksheet are in the cells in this column. Arrow down to get started.","Budget Wheel",null,"Fill out the table in this template. The graph will chart your monthly spending in relation to your monthly income. It will also calculate the percentages to show you how much you will save/have saved."]
["Monthly Income label is in the cell at right, the doughnut chart showing expenses and savings in cell C2, and the Savings Amount label in cell G2.","Monthly \nIncome","Doughnut chart showing the expenses and savings proportion is in this cell.",{"$nulls":3},"Savings Amount"]
["Enter Monthly Income in cell on right. Saving Amount is auto calculated in cell G3. Next instruction is in cell A6.",{"v":5738,"d":"£5,738"},{"$nulls":4},{"$f":"Savings","v":{"v":2777,"d":"£2,777"}}]
[{"$nulls":6},"Value calculated automatically"]
[]
["Enter details in Expenses table starting in cell on right.","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":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,"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":100,"d":"£100"},"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":100,"d":"£100"}},{"$f":"IF(Expenses[[#This Row],[Monthly Amount]]<>\"\",Expenses[[#This Row],[Monthly Amount]]/Income,\"\")","v":{"v":0.01742767514813524,"d":"2%"}}]
[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":2777,"d":"£2,777"}}]
["Entertainment",{"$f":"IF(SUMIF(Expenses[Category],\"Entertainment\",Expenses[Monthly Amount])>0,SUMIF(Expenses[Category],\"Entertainment\",Expenses[Monthly Amount]),NA())","v":{"v":188,"d":"£188"}},{"v":0.03276402927849425,"d":"3%"},"Monthly"]
["Transportation",{"$f":"IF(SUMIF(Expenses[Category],\"Transportation\",Expenses[Monthly Amount])>0,SUMIF(Expenses[Category],\"Transportation\",Expenses[Monthly Amount]),NA())","v":{"v":350,"d":"£350"}},{"v":0.06099686301847333,"d":"6%"},"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":2777,"d":"£2,777"}},{"v":0.4839665388637156,"d":"48%"},"Every other week"]
[{"$nulls":3},"Every other month"]
[null,"TOTAL:",{"$f":"SUM(C3:C8)","v":{"v":1,"d":"100%"}}]