{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Сводный бюджет","Ежемесячный доход","Ежемесячные расходы","Расходы на семестр"],"not_rendered":{"charts":1,"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"Сводный бюджет","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,"Мой студенческий бюджет"]
[null,"Затрачиваемый процент от дохода",null,null,"В этой ячейке представлена гистограмма с группировкой для сравнения ежемесячных доходов и расходов."]
[null,{"$f":"NetMonthlyExpenses/NetMonthlyIncome","v":{"v":0.6436363636363637,"d":"64%"}}]
[null,{"$f":"NetMonthlyExpenses","v":1770}]
[null,"Чистый ежемесячный доход"]
[null,{"$f":"Total_MonthlyIncome","v":{"v":2750,"d":"2,750 ₽"}}]
[null,"Чистые ежемесячные расходы"]
[null,{"$f":"Total_MonthlyExpenses+Total_SemesterExpenses","v":{"v":1770,"d":"1,770 ₽"}}]
[null,"остаток"]
[null,{"$f":"NetMonthlyIncome-NetMonthlyExpenses","v":{"v":980,"d":"980 ₽"}}]

{"sheet":"Ежемесячный доход","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"merged":[[0,1,0,4]]}
[null,{"$f":"Workbook_Title","v":"Мой студенческий бюджет"}]
[null,"Ежемесячный доход"]
[null,"Статья","Сумма"]
[null,"Фиксированный доход",{"v":1500,"d":"1,500 ₽"}]
[null,"Финансовая помощь",{"v":500,"d":"500 ₽"}]
[null,"Кредиты",{"v":500,"d":"500 ₽"}]
[null,"Прочие поступления",{"v":250,"d":"250 ₽"}]
[null,"Итог",{"$f":"SUBTOTAL(109,MonthlyIncome[Сумма])","v":{"v":2750,"d":"2,750 ₽"}}]

{"sheet":"Ежемесячные расходы","index":2,"n_rows":15,"n_cols":3,"rows_kept":15,"merged":[[0,1,0,4]]}
[null,{"$f":"Workbook_Title","v":"Мой студенческий бюджет"}]
[null,"Ежемесячные расходы"]
[null,"Статья","Сумма"]
[null,"Аренда",{"v":20,"d":"20 ₽"}]
[null,"Коммунальные услуги",{"v":50,"d":"50 ₽"}]
[null,"Сотовый телефон",{"v":75,"d":"75 ₽"}]
[null,"Продовольственные товары",{"v":250,"d":"250 ₽"}]
[null,"Расходы на авто",{"v":50,"d":"50 ₽"}]
[null,"Студенческие кредиты",{"v":500,"d":"500 ₽"}]
[null,"Кредитные карты",{"v":275,"d":"275 ₽"}]
[null,"Страхование",{"v":125,"d":"125 ₽"}]
[null,"Стрижка",{"v":50,"d":"50 ₽"}]
[null,"Развлечения",{"v":0,"d":"0 ₽"}]
[null,"Прочее",{"v":0,"d":"0 ₽"}]
[null,"Итог",{"$f":"SUBTOTAL(109,MonthlyExpenses[Сумма])","v":{"v":1395,"d":"1,395 ₽"}}]

{"sheet":"Расходы на семестр","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"merged":[[0,1,0,5],[10,1,10,2]]}
[null,{"$f":"Workbook_Title","v":"Мой студенческий бюджет"}]
[null,"Расходы на семестр*"]
[null,"Позиция","Сумма","В месяц"]
[null,"Обучение",{"v":750,"d":"750 ₽"},{"$f":"IFERROR(SemesterExpenses[[#This Row],[Сумма]]/4, \"\")","v":{"v":187.5,"d":"188 ₽"}}]
[null,"Стоимость лабораторного оборудования",{"v":250,"d":"250 ₽"},{"$f":"IFERROR(SemesterExpenses[[#This Row],[Сумма]]/4, \"\")","v":{"v":62.5,"d":"63 ₽"}}]
[null,"Книги",{"v":500,"d":"500 ₽"},{"$f":"IFERROR(SemesterExpenses[[#This Row],[Сумма]]/4, \"\")","v":{"v":125,"d":"125 ₽"}}]
[null,"Залоги",{"v":0,"d":"0 ₽"},{"$f":"IFERROR(SemesterExpenses[[#This Row],[Сумма]]/4, \"\")","v":{"v":0,"d":"0 ₽"}}]
[null,"Транспорт",{"v":0,"d":"0 ₽"},{"$f":"IFERROR(SemesterExpenses[[#This Row],[Сумма]]/4, \"\")","v":{"v":0,"d":"0 ₽"}}]
[null,"Другие расходы",{"v":0,"d":"0 ₽"},{"$f":"IFERROR(SemesterExpenses[[#This Row],[Сумма]]/4, \"\")","v":{"v":0,"d":"0 ₽"}}]
[null,"Итог",{"$f":"SUBTOTAL(109,SemesterExpenses[Сумма])","v":{"v":1500,"d":"1,500 ₽"}},{"$f":"SUBTOTAL(109,SemesterExpenses[В месяц])","v":{"v":375,"d":"375 ₽"}}]
[null,"* Для 4-месячного семестра"]