{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Budget Summary","Monthly Income","Monthly Expenses","Semester Expenses"],"not_rendered":{"charts":1,"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"Budget Summary","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"merged":[[0,1,0,4],[1,1,1,2],[1,4,9,4],[3,1,3,2]]}
[null,"my university budget"]
[null,"percentage of income spent",null,null,"Clustered column chart comparing Monthly Income and Expenses is in this cell."]
[null,{"$f":"NetMonthlyExpenses/NetMonthlyIncome","v":{"v":0.6436363636363637,"d":"64%"}}]
[null,{"$f":"NetMonthlyExpenses","v":1770}]
[null,"net monthly income"]
[null,{"$f":"Total_MonthlyIncome","v":{"v":2750,"d":"£2,750"}}]
[null,"net monthly expenses"]
[null,{"$f":"Total_MonthlyExpenses+Total_SemesterExpenses","v":{"v":1770,"d":"£1,770"}}]
[null,"balance"]
[null,{"$f":"NetMonthlyIncome-NetMonthlyExpenses","v":{"v":980,"d":"£980"}}]

{"sheet":"Monthly Income","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"merged":[[0,1,0,5]]}
[null,{"$f":"Workbook_Title","v":"my university budget"}]
[null,"monthly income"]
[null,"Item","Amount"]
[null,"Fixed income",{"v":1500,"d":"£1,500"}]
[null,"Financial support",{"v":500,"d":"£500"}]
[null,"Loans",{"v":500,"d":"£500"}]
[null,"Other income",{"v":250,"d":"£250"}]
[null,"Total",{"$f":"SUBTOTAL(109,MonthlyIncome[Amount])","v":{"v":2750,"d":"£2,750"}}]

{"sheet":"Monthly Expenses","index":2,"n_rows":15,"n_cols":3,"rows_kept":15,"merged":[[0,1,0,5]]}
[null,{"$f":"Workbook_Title","v":"my university budget"}]
[null,"monthly expenses"]
[null,"Item","Amount"]
[null,"Rent",{"v":20,"d":"£20"}]
[null,"Utilities",{"v":50,"d":"£50"}]
[null,"Mobile phone",{"v":75,"d":"£75"}]
[null,"Food and household supplies",{"v":250,"d":"£250"}]
[null,"Car expenses",{"v":50,"d":"£50"}]
[null,"Student loans",{"v":500,"d":"£500"}]
[null,"Credit cards",{"v":275,"d":"£275"}]
[null,"Insurance",{"v":125,"d":"£125"}]
[null,"Haircuts",{"v":50,"d":"£50"}]
[null,"Entertainment",{"v":0,"d":"£0"}]
[null,"Miscellaneous",{"v":0,"d":"£0"}]
[null,"Total",{"$f":"SUBTOTAL(109,MonthlyExpenses[Amount])","v":{"v":1395,"d":"£1,395"}}]

{"sheet":"Semester Expenses","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"merged":[[0,1,0,6],[10,1,10,2]]}
[null,{"$f":"Workbook_Title","v":"my university budget"}]
[null,"semester expenses *"]
[null,"Item","Amount","Per Month"]
[null,"Tuition",{"v":750,"d":"£750"},{"$f":"IFERROR(SemesterExpenses[[#This Row],[Amount]]/4, \"\")","v":{"v":187.5,"d":"£188"}}]
[null,"Parking",{"v":250,"d":"£250"},{"$f":"IFERROR(SemesterExpenses[[#This Row],[Amount]]/4, \"\")","v":{"v":62.5,"d":"£63"}}]
[null,"Books",{"v":500,"d":"£500"},{"$f":"IFERROR(SemesterExpenses[[#This Row],[Amount]]/4, \"\")","v":{"v":125,"d":"£125"}}]
[null,"Deposits",{"v":0,"d":"£0"},{"$f":"IFERROR(SemesterExpenses[[#This Row],[Amount]]/4, \"\")","v":{"v":0,"d":"£0"}}]
[null,"Transport",{"v":0,"d":"£0"},{"$f":"IFERROR(SemesterExpenses[[#This Row],[Amount]]/4, \"\")","v":{"v":0,"d":"£0"}}]
[null,"Other fees",{"v":0,"d":"£0"},{"$f":"IFERROR(SemesterExpenses[[#This Row],[Amount]]/4, \"\")","v":{"v":0,"d":"£0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,SemesterExpenses[Amount])","v":{"v":1500,"d":"£1,500"}},{"$f":"SUBTOTAL(109,SemesterExpenses[Per Month])","v":{"v":375,"d":"£375"}}]
[null,"* based on a 4-month semester"]