{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Доход-расход","Итоги года","Реализация бюджета","рабочий","А-П","Финансовые цели","Инвестиции","Инвестиционный портфель"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Доход-расход","index":0,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":false,"merged":[[13,11,13,12],[1,14,1,15],[26,2,26,3],[26,5,26,6],[26,8,26,9],[26,11,26,12],[1,2,3,7],[1,8,3,12],[4,2,4,3],[4,5,4,7],[5,5,5,6],[4,10,4,12],[5,10,5,12],[6,10,6,12],[39,2,39,3],[39,5,39,6],[39,8,39,9],[6,5,6,6],[7,5,7,6],[13,2,13,3],[13,5,13,6],[13,8,13,9]]}
[]
[null,null,"Апрель",null,null,null,null,null,2016,null,null,null,null,null,"Сбережения"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Общие",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Текущие",{"$f":"K7","v":0}]
[null,null,"Плановые показатели",null,null,"Фактические показатели",null,null,null,null,"Сумма сбережений в этом месяце"]
[null,null,"Доход за месяц",null,null,"Доход за месяц",null,null,null,"Введите % от остатка"]
[null,null,"Расход за месяц",null,null,"Расход за месяц",null,888,null,"Сумма",{"$f":"K6*H8","v":0}]
[null,null,"Остаток",{"$f":"D6-D7","v":0},null,"Остаток",null,{"$f":"H6-H7","v":-888}]
[]
[]
[]
[]
[]
[null,null,"Коммунальные услуги",null,null,"Развлечения",null,null,"Транспорт",null,null,"Питание"]
[null,null,null,888]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Итого",{"$f":"D15+D16+D17+D18+D19+D20+D21+D22+D23+D24","v":888},null,"Итого",{"$f":"G15+G16+G17+G18+G19+G20+G21+G22+G23+G24","v":0},null,"Итого",{"$f":"J15+J16+J17+J18+J19+J20+J21+J22+J23+J24","v":0},null,"Итого",{"$f":"M15+M16+M17+M18+M19+M20+M21+M22+M23+M24","v":0}]
[]
[null,null,"Хозяйственные расходы"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Итого",{"$f":"D28+D29+D30+D31+D32+D33+D34+D35+D36+D37","v":0},null,"Итого",{"$f":"G28+G29+G30+G31+G32+G33+G34+G35+G36+G37","v":0},null,"Итого",{"$f":"J28+J29+J30+J31+J32+J33+J34+J35+J36+J37","v":0},null,"Итого",{"$f":"M28+M29+M30+M31+M32+M33+M34+M35+M36+M37","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Итого",{"$f":"D41+D42+D43+D44+D45+D46+D47+D48+D49+D50","v":0},null,"Итого",{"$f":"G41+G42+G43+G44+G45+G46+G47+G48+G49+G50","v":0},null,"Итого",{"$f":"J41+J42+J43+J44+J45+J46+J47+J48+J49+J50","v":0}]

{"sheet":"Итоги года","index":1,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,2,3,12],[4,2,4,12]]}
[]
[]
[null,null,"Затраты"]
[]
[null,null,2016]
[null,"Месяц","Коммунальные услуги","Развлечения","Транспорт","Кредиты","Питание","Дети","Хозяйственные расходы","Забота о себе","Прочее","Категория1","Категория2","Итого"]
[null,"Январь",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C7:M7)","v":0}]
[null,"Февраль",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C8:M8)","v":0}]
[null,"Март",null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Апрель",888,0,0,null,0,null,0,null,null,null,null,888]
[null,"Май",null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Июнь",null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Июль",null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Август",null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Сентябрь",null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Октябрь",null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Ноябрь",null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Декабрь",null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Итого за год:",888,0,0,0,0,0,0,0,0,0,0,888]

{"sheet":"Реализация бюджета","index":2,"n_rows":150,"n_cols":9,"rows_kept":150,"cut":false,"hidden":false,"merged":[[1,3,3,8]]}
[]
[null,null,null,"Январь"]
[]
[]
[]
[null,null,null,"Доход/Расход","План","Факт","Исполнение","% исполнения","Комментарии"]
[null,null,null,"Доходы",0,0,{"$f":"F7-E7","v":0},{"$f":"IF(F7=E7,1,((F7-E7)/F7)*1)","v":1}]
[null,null,null,"в том числе:",null,null,{"$f":"F8-E8","v":0},{"$f":"IF(F8=E8,1,((F8-E8)/F8)*1)","v":1}]
[null,null,null,null,null,null,0,{"$f":"IF(F9=E9,1,((F9-E9)/F9)*1)","v":1}]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,"Расходы:",{"$f":"E15+E36+E47+E58+E69+E80+E91+E102+E113+E124+E135","v":801},0,{"$f":"E14-F14","v":801},{"$f":"IF(F14=E14,1,((E14-F14)/E14)*1)","v":1}]
[null,null,null,"     Коммунальные услуги",{"$f":"E26+E27+E28+E29+E30+E31+E32+E33+E34+E35","v":801},0,{"$f":"E15-F15","v":801},{"$f":"IF(F15=E15,1,((E15-F15)/E15)*1)","v":1}]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,456,null,456,1]
[null,null,null,null,345,null,345,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,"     Развлечения",{"$f":"E37+E38+E39+E40+E41+E42+E43+E44+E45+E46","v":0},0,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,"     Транспорт",{"$f":"E48+E49+E50+E51+E52+E53+E54+E55+E56+E57","v":0},0,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,"     Кредиты",{"$f":"E59+E60+E61+E62+E63+E64+E65+E66+E67+E68","v":0},0,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,"     Питание",{"$f":"E70+E71+E72+E73+E74+E75+E76+E77+E78+E79","v":0},0,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,{"$f":"E79-F79","v":0},{"$f":"IF(F79=E79,1,((E79-F79)/E79)*1)","v":1}]
[null,null,null,"     Дети",{"$f":"E81+E82+E83+E84+E85+E86+E87+E88+E89+E90","v":0},0,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,"     Хозяйственные расходы",{"$f":"E92+E93+E94+E95+E96+E97+E98+E99+E100+E101","v":0},0,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,"     Забота о себе",{"$f":"E103+E104+E105+E106+E107+E108+E109+E110+E111+E112","v":0},0,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,"     Прочее",{"$f":"E114+E115+E116+E117+E118+E119+E120+E121+E122+E123","v":0},0,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,{"$f":"E125+E126+E127+E128+E129+E130+E132+E131+E133+E134","v":0},0,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,{"$f":"E136+E137+E138+E139+E140+E141+E142+E143+E144+E145","v":0},0,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,{"$f":"E143-F143","v":0},{"$f":"IF(F143=E143,1,((E143-F143)/E143)*1)","v":1}]
[null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,0,1]
[null,null,null,"Итого доходов",{"$f":"E7","v":0},{"$f":"F7","v":0},{"$f":"F146-E146","v":0},{"$f":"IF(F146=E146,1,((F146-E146)/F146)*1)","v":1}]
[null,null,null,"Итого расходов",{"$f":"E14","v":801},{"$f":"F14","v":0},{"$f":"E147-F147","v":801},{"$f":"IF(F147=E147,1,((E147-F147)/E147)*1)","v":1}]
[null,null,null,"Итого сбережений",10000,0,{"$f":"F148-E148","v":-10000},{"$f":"IF(F148=E148,1,((E148-F148)/E148)*1)","v":1}]
[null,null,null,"Реализация целей",2000,7664,{"$f":"F149-E149","v":5664},{"$f":"IF(F149=E149,1,((F149-E149)/F149)*1)","v":0.73903966597077242}]
[null,null,null,"Финансовый результат",{"$f":"(E146-E147)-(E148-E149)","v":-8801},{"$f":"(F146-F147)-(F148-F149)","v":7664},{"$f":"F150-E150","v":16465},{"$f":"IF(F150=E150,1,((F150-E150)/F150)*1)","v":2.148355949895616}]

{"sheet":"рабочий","index":3,"n_rows":675,"n_cols":77,"rows_kept":675,"cut":false,"hidden":true,"merged":[[426,8,426,10],[427,8,427,10],[428,8,428,10],[473,8,473,10],[474,8,474,10],[475,8,475,10],[520,8,520,10],[521,8,521,10],[522,8,522,10],[238,8,238,10],[239,8,239,10],[240,8,240,10],[285,8,285,10],[286,8,286,10],[287,8,287,10],[332,8,332,10],[333,8,333,10],[334,8,334,10],[48,8,48,10],[49,8,49,10],[50,8,50,10],[144,8,144,10],[145,8,145,10],[146,8,146,10],[191,8,191,10],[192,8,192,10],[193,8,193,10],[1,15,3,20],[0,0,0,1],[0,3,0,5],[1,3,1,4],[2,3,2,4],[22,6,22,7],[22,9,22,10],[35,0,35,1],[35,3,35,4],[35,6,35,7],[3,3,3,4],[9,0,9,1],[9,3,9,4],[9,6,9,7],[9,9,9,10],[0,8,0,10],[1,8,1,10],[2,8,2,10],[48,0,48,1],[48,3,48,5],[49,3,49,4],[50,3,50,4],[51,3,51,4],[57,0,57,1],[57,3,57,4],[22,0,22,1],[22,3,22,4],[83,0,83,1],[83,3,83,4],[83,6,83,7],[97,0,97,1],[97,3,97,5],[98,3,98,4],[57,6,57,7],[57,9,57,10],[70,0,70,1],[70,3,70,4],[70,6,70,7],[70,9,70,10],[97,8,97,10],[98,8,98,10],[119,6,119,7],[119,9,119,10],[132,0,132,1],[132,3,132,4],[132,6,132,7],[99,3,99,4],[100,3,100,4],[106,0,106,1],[106,3,106,4],[106,6,106,7],[106,9,106,10],[99,8,99,10],[144,0,144,1],[144,3,144,5],[145,3,145,4],[146,3,146,4],[147,3,147,4],[153,0,153,1],[153,3,153,4],[119,0,119,1],[119,3,119,4],[179,0,179,1],[179,3,179,4],[179,6,179,7],[191,0,191,1],[191,3,191,5],[192,3,192,4],[153,6,153,7],[153,9,153,10],[166,0,166,1],[166,3,166,4],[166,6,166,7],[166,9,166,10],[213,6,213,7],[213,9,213,10],[226,0,226,1],[226,3,226,4],[226,6,226,7],[193,3,193,4],[194,3,194,4],[200,0,200,1],[200,3,200,4],[200,6,200,7],[200,9,200,10],[238,0,238,1],[238,3,238,5],[239,3,239,4],[240,3,240,4],[241,3,241,4],[247,0,247,1],[247,3,247,4],[213,0,213,1],[213,3,213,4],[273,0,273,1],[273,3,273,4],[273,6,273,7],[285,0,285,1],[285,3,285,5],[286,3,286,4],[247,6,247,7],[247,9,247,10],[260,0,260,1],[260,3,260,4],[260,6,260,7],[260,9,260,10],[307,6,307,7],[307,9,307,10],[320,0,320,1],[320,3,320,4],[320,6,320,7],[287,3,287,4],[288,3,288,4],[294,0,294,1],[294,3,294,4],[294,6,294,7],[294,9,294,10],[332,0,332,1],[332,3,332,5],[333,3,333,4],[334,3,334,4],[335,3,335,4],[341,0,341,1],[341,3,341,4],[307,0,307,1],[307,3,307,4],[367,0,367,1],[367,3,367,4],[367,6,367,7],[379,0,379,1],[379,3,379,5],[380,3,380,4],[341,6,341,7],[341,9,341,10],[354,0,354,1],[354,3,354,4],[354,6,354,7],[354,9,354,10],[379,8,379,10],[380,8,380,10],[401,6,401,7],[401,9,401,10],[414,0,414,1],[414,3,414,4],[414,6,414,7],[381,3,381,4],[382,3,382,4],[388,0,388,1],[388,3,388,4],[388,6,388,7],[388,9,388,10],[381,8,381,10],[426,0,426,1],[426,3,426,5],[427,3,427,4],[428,3,428,4],[429,3,429,4],[435,0,435,1],[435,3,435,4],[401,0,401,1],[401,3,401,4],[461,0,461,1],[461,3,461,4],[461,6,461,7],[473,0,473,1],[473,3,473,5],[474,3,474,4],[435,6,435,7],[435,9,435,10],[448,0,448,1],[448,3,448,4],[448,6,448,7],[448,9,448,10],[495,6,495,7],[495,9,495,10],[508,0,508,1],[508,3,508,4],[508,6,508,7],[475,3,475,4],[476,3,476,4],[482,0,482,1],[482,3,482,4],[482,6,482,7],[482,9,482,10],[520,0,520,1],[520,3,520,5],[521,3,521,4],[522,3,522,4],[523,3,523,4],[529,0,529,1],[529,3,529,4],[495,0,495,1],[495,3,495,4],[646,2,646,3],[646,4,646,5],[555,0,555,1],[555,3,555,4],[555,6,555,7],[529,6,529,7],[529,9,529,10],[542,0,542,1],[542,3,542,4],[542,6,542,7],[542,9,542,10],[619,8,619,14],[628,8,628,15],[637,8,637,13],[646,8,646,14]]}
["Плановые показатели",null,null,"Фактические показатели",null,null,null,null,"Сумма сбережений в этом месяце",null,null,null,null,null,null,null,null,null,null,null,null,null,"Плановые показатели",null,null,"Фактические показатели",null,null,null,null,"Сумма сбережений в этом месяце"]
["Доход за месяц",null,null,"Доход за месяц",null,null,null,"Введите % от остатка",null,null,null,null,null,null,null,"Январь",null,null,null,null,null,null,"Доход за месяц",null,null,"Доход за месяц",null,null,null,"Введите % от остатка"]
["Расход за месяц",null,null,"Расход за месяц",null,0,null,"Сумма",{"$f":"I2*F4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Расход за месяц",null,null,"Расход за месяц",null,11736,null,"Сумма",0]
["Остаток",{"$f":"B2-B3","v":0},null,"Остаток",null,{"$f":"F2-F3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Остаток",0,null,"Остаток",null,-11736]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"январь","Февраль","март","апрель","май","июнь","июль","август","сентябрь","октябрь","ноябрь","декабрь",null,null,"январь","февраль","март","апрель","май","июнь","июль","август","сентябрь","октябрь","ноябрь","декабрь"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Доход/Расход","План","Факт","Исполнение","% исполнения","Комментарии",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"План","План","План","План","План","План","План","План","План","План","План","План",null,null,"Комментарии","Комментарии","Комментарии","Комментарии","Комментарии","Комментарии","Комментарии","Комментарии","Комментарии","Комментарии","Комментарии","Комментарии",null,null,"Доход/Расход","январь","февраль","март","апрель","май","июнь","июль","август","сентябрь","октябрь","ноябрь","декабрь"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Доходы",null,null,{"$f":"R7-Q7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Доходы",{"$f":"B2","v":0},{"$f":"B50","v":0},{"$f":"B99","v":0},{"$f":"B146","v":0},{"$f":"B193","v":0},{"$f":"B240","v":0},{"$f":"B287","v":0},{"$f":"B334","v":0},{"$f":"B381","v":0},{"$f":"B428","v":0},null,{"$f":"B522","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Доходы",{"$f":"D649","v":0},{"$f":"D650","v":0},{"$f":"D651","v":0},{"$f":"D652","v":0},{"$f":"D653","v":0},{"$f":"D654","v":0},{"$f":"D655","v":0},{"$f":"D656","v":0},{"$f":"D657","v":0},{"$f":"D658","v":0},{"$f":"D659","v":0},{"$f":"D660","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"в том числе:",null,{"$f":"SUM(R9:R13)","v":0},{"$f":"R8-Q8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"в том числе:",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"в том числе:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Расходы:",{"$f":"Q15+Q36+Q47+Q58+Q69+Q80+Q91+Q102+Q113+Q124+Q135","v":0},{"$f":"R15+R36+R47+R58+R69+R80+R91+R102+R113+R124+R135","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Расходы:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Коммунальные услуги",null,{"$f":"SUM(R16:R35)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Коммунальные услуги",{"$f":"SUM(AK16:AK35)","v":0},{"$f":"SUM(AL16:AL35)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Итого",{"$f":"B11+B12+B13+B14+B15+B16+B17+B18+B19+B20","v":0},null,"Итого",{"$f":"E11+E12+E13+E14+E15+E16+E17+E18+E19+E20","v":0},null,"Итого",{"$f":"H11+H12+H13+H14+H15+H16+H17+H18+H19+H20","v":0},null,"Итого",{"$f":"K11+K12+K13+K14+K15+K16+K17+K18+K19+K20","v":0},null,null,null,null,null,null,null,0,null,null,null,"Итого",0,null,"Итого",0,null,"Итого",0,null,"Итого",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M15+M16+M17+M18+M19+M20+M21+M22+M23+M24","v":0},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Итого",{"$f":"B24+B25+B26+B27+B28+B29+B30+B31+B32+B33","v":0},null,"Итого",{"$f":"E24+E25+E26+E27+E28+E29+E30+E31+E32+E33","v":0},null,"Итого",{"$f":"H24+H25+H26+H27+H28+H29+H30+H31+H32+H33","v":0},null,"Итого",{"$f":"K24+K25+K26+K27+K28+K29+K30+K31+K32+K33","v":0},null,null,null,null,null,null,null,0,null,null,null,"Итого",0,null,"Итого",0,null,"Итого",0,null,"Итого",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Развлечения",null,{"$f":"SUM(R37:R46)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Развлечения",{"$f":"SUM(AK37:AK46)","v":0},{"$f":"SUM(AL37:AL46)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M28+M29+M30+M31+M32+M33+M34+M35+M36+M37","v":0},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Итого",{"$f":"B37+B38+B39+B40+B41+B42+B43+B44+B45+B46","v":0},null,"Итого",{"$f":"E37+E38+E39+E40+E41+E42+E43+E44+E45+E46","v":0},null,"Итого",{"$f":"H37+H38+H39+H40+H41+H42+H43+H44+H45+H46","v":0},null,null,null,null,null,null,null,"     Транспорт",null,{"$f":"SUM(R48:R57)","v":0},0,null,null,null,"Итого",0,null,"Итого",0,null,"Итого",0,null,null,null,null,null,"     Транспорт",{"$f":"SUM(AK48:AK57)","v":0},{"$f":"SUM(AL48:AL57)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Плановые показатели",null,null,"Фактические показатели",null,null,null,null,"Сумма сбережений в этом месяце",null,null,null,null,null,null,null,null,null,0]
["Доход за месяц",null,null,"Доход за месяц",null,null,null,"Введите % от остатка",null,null,null,null,null,null,null,null,null,null,0]
["Расход за месяц",null,null,"Расход за месяц",null,0,null,"Сумма",{"$f":"I50*F52","v":0},null,null,null,null,null,null,null,null,null,0]
["Остаток",{"$f":"B50-B51","v":0},null,"Остаток",null,{"$f":"F50-F51","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Кредиты",null,{"$f":"SUM(R59:R68)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Кредиты",{"$f":"SUM(AK59:AK68)","v":0},{"$f":"SUM(AL59:AL68)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Итого",{"$f":"B59+B60+B61+B62+B63+B64+B65+B66+B67+B68","v":0},null,"Итого",{"$f":"E59+E60+E61+E62+E63+E64+E65+E66+E67+E68","v":0},null,"Итого",{"$f":"H59+H60+H61+H62+H63+H64+H65+H66+H67+H68","v":0},null,"Итого",{"$f":"K59+K60+K61+K62+K63+K64+K65+K66+K67+K68","v":0},null,null,null,null,"     Питание",null,{"$f":"SUM(R70:R79)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Питание",{"$f":"SUM(AK70:AK79)","v":0},{"$f":"SUM(AL70:AL79)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Дети",null,{"$f":"SUM(R81:R90)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Дети",{"$f":"SUM(AK81:AK90)","v":0},{"$f":"SUM(AL81:AL90)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Итого",{"$f":"B72+B73+B74+B75+B76+B77+B78+B79+B80+B81","v":0},null,"Итого",{"$f":"E72+E73+E74+E75+E76+E77+E78+E79+E80+E81","v":0},null,"Итого",{"$f":"H72+H73+H74+H75+H76+H77+H78+H79+H80+H81","v":0},null,"Итого",{"$f":"K72+K73+K74+K75+K76+K77+K78+K79+K80+K81","v":0},null,null,null,null,null,null,null,{"$f":"R82-Q82","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Хозяйственные расходы",null,{"$f":"SUM(R92:R101)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Хозяйственные расходы",{"$f":"SUM(AK92:AK101)","v":0},{"$f":"SUM(AL92:AL101)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Итого",{"$f":"B85+B86+B87+B88+B89+B90+B91+B92+B93+B94","v":0},null,"Итого",{"$f":"E85+E86+E87+E88+E89+E90+E91+E92+E93+E94","v":0},null,"Итого",{"$f":"H85+H86+H87+H88+H89+H90+H91+H92+H93+H94","v":0},null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Плановые показатели",null,null,"Фактические показатели",null,null,null,null,"Сумма сбережений в этом месяце",null,null,null,null,null,null,null,null,null,0]
["Доход за месяц",null,null,"Доход за месяц",null,null,null,"Введите % от остатка",null,null,null,null,null,null,null,null,null,null,0]
["Расход за месяц",null,null,"Расход за месяц",null,0,null,"Сумма",{"$f":"I99*F101","v":0},null,null,null,null,null,null,null,null,null,0]
["Остаток",{"$f":"B99-B100","v":0},null,"Остаток",null,{"$f":"F99-F100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Забота о себе",null,{"$f":"SUM(R103:R112)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Забота о себе",{"$f":"SUM(AK103:AK112)","v":0},{"$f":"SUM(AL103:AL112)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Прочее",null,{"$f":"SUM(R114:R123)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Прочее",{"$f":"SUM(AK114:AK123)","v":0},{"$f":"SUM(AL114:AL123)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Итого",{"$f":"B108+B109+B110+B111+B112+B113+B114+B115+B116+B117","v":0},null,"Итого",{"$f":"E108+E109+E110+E111+E112+E113+E114+E115+E116+E117","v":0},null,"Итого",{"$f":"H108+H109+H110+H111+H112+H113+H114+H115+H116+H117","v":0},null,"Итого",{"$f":"K108+K109+K110+K111+K112+K113+K114+K115+K116+K117","v":0},null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R125:R134)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Книги",{"$f":"SUM(AK125:AK134)","v":0},{"$f":"SUM(AL125:AL134)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Итого",{"$f":"B121+B122+B123+B124+B125+B126+B127+B128+B129+B130","v":0},null,"Итого",{"$f":"E121+E122+E123+E124+E125+E126+E127+E128+E129+E130","v":0},null,"Итого",{"$f":"H121+H122+H123+H124+H125+H126+H127+H128+H129+H130","v":0},null,"Итого",{"$f":"K121+K122+K123+K124+K125+K126+K127+K128+K129+K130","v":0},null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R136:R145)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AK136:AK145)","v":0},{"$f":"SUM(AL136:AL145)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Итого",{"$f":"B134+B135+B136+B137+B138+B139+B140+B141+B142+B143","v":0},null,"Итого",{"$f":"E134+E135+E136+E137+E138+E139+E140+E141+E142+E143","v":0},null,"Итого",{"$f":"H134+H135+H136+H137+H138+H139+H140+H141+H142+H143","v":0},null,null,null,null,null,null,null,null,null,null,0]
["Плановые показатели",null,null,"Фактические показатели",null,null,null,null,"Сумма сбережений в этом месяце",null,null,null,null,null,null,null,null,null,0]
["Доход за месяц",null,null,"Доход за месяц",null,null,null,"Введите % от остатка"]
["Расход за месяц",null,null,"Расход за месяц",null,888,null,"Сумма",{"$f":"I146*F148","v":0}]
["Остаток",{"$f":"B146-B147","v":0},null,"Остаток",null,{"$f":"F146-F147","v":-888}]
[]
[]
[]
[]
[]
["Коммунальные услуги",null,null,"Развлечения",null,null,"Транспорт",null,null,"Питание"]
[null,888]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B155+B156+B157+B158+B159+B160+B161+B162+B163+B164","v":888},null,"Итого",{"$f":"E155+E156+E157+E158+E159+E160+E161+E162+E163+E164","v":0},null,"Итого",{"$f":"H155+H156+H157+H158+H159+H160+H161+H162+H163+H164","v":0},null,"Итого",{"$f":"K155+K156+K157+K158+K159+K160+K161+K162+K163+K164","v":0}]
[]
["Хозяйственные расходы"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B168+B169+B170+B171+B172+B173+B174+B175+B176+B177","v":0},null,"Итого",{"$f":"E168+E169+E170+E171+E172+E173+E174+E175+E176+E177","v":0},null,"Итого",{"$f":"H168+H169+H170+H171+H172+H173+H174+H175+H176+H177","v":0},null,"Итого",{"$f":"K168+K169+K170+K171+K172+K173+K174+K175+K176+K177","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B181+B182+B183+B184+B185+B186+B187+B188+B189+B190","v":0},null,"Итого",{"$f":"E181+E182+E183+E184+E185+E186+E187+E188+E189+E190","v":0},null,"Итого",{"$f":"H181+H182+H183+H184+H185+H186+H187+H188+H189+H190","v":0}]
["Плановые показатели",null,null,"Фактические показатели",null,null,null,null,"Сумма сбережений в этом месяце"]
["Доход за месяц",null,null,"Доход за месяц",null,null,null,"Введите % от остатка"]
["Расход за месяц",null,null,"Расход за месяц",null,0,null,"Сумма",{"$f":"I193*F195","v":0}]
["Остаток",{"$f":"B193-B194","v":0},null,"Остаток",null,{"$f":"F193-F194","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B202+B203+B204+B205+B206+B207+B208+B209+B210+B211","v":0},null,"Итого",{"$f":"E202+E203+E204+E205+E206+E207+E208+E209+E210+E211","v":0},null,"Итого",{"$f":"H202+H203+H204+H205+H206+H207+H208+H209+H210+H211","v":0},null,"Итого",{"$f":"K202+K203+K204+K205+K206+K207+K208+K209+K210+K211","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B215+B216+B217+B218+B219+B220+B221+B222+B223+B224","v":0},null,"Итого",{"$f":"E215+E216+E217+E218+E219+E220+E221+E222+E223+E224","v":0},null,"Итого",{"$f":"H215+H216+H217+H218+H219+H220+H221+H222+H223+H224","v":0},null,"Итого",{"$f":"K215+K216+K217+K218+K219+K220+K221+K222+K223+K224","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B228+B229+B230+B231+B232+B233+B234+B235+B236+B237","v":0},null,"Итого",{"$f":"E228+E229+E230+E231+E232+E233+E234+E235+E236+E237","v":0},null,"Итого",{"$f":"H228+H229+H230+H231+H232+H233+H234+H235+H236+H237","v":0}]
["Плановые показатели",null,null,"Фактические показатели",null,null,null,null,"Сумма сбережений в этом месяце"]
["Доход за месяц",null,null,"Доход за месяц",null,null,null,"Введите % от остатка"]
["Расход за месяц",null,null,"Расход за месяц",null,0,null,"Сумма",{"$f":"I240*F242","v":0}]
["Остаток",{"$f":"B240-B241","v":0},null,"Остаток",null,{"$f":"F240-F241","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B249+B250+B251+B252+B253+B254+B255+B256+B257+B258","v":0},null,"Итого",{"$f":"E249+E250+E251+E252+E253+E254+E255+E256+E257+E258","v":0},null,"Итого",{"$f":"H249+H250+H251+H252+H253+H254+H255+H256+H257+H258","v":0},null,"Итого",{"$f":"K249+K250+K251+K252+K253+K254+K255+K256+K257+K258","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B262+B263+B264+B265+B266+B267+B268+B269+B270+B271","v":0},null,"Итого",{"$f":"E262+E263+E264+E265+E266+E267+E268+E269+E270+E271","v":0},null,"Итого",{"$f":"H262+H263+H264+H265+H266+H267+H268+H269+H270+H271","v":0},null,"Итого",{"$f":"K262+K263+K264+K265+K266+K267+K268+K269+K270+K271","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B275+B276+B277+B278+B279+B280+B281+B282+B283+B284","v":0},null,"Итого",{"$f":"E275+E276+E277+E278+E279+E280+E281+E282+E283+E284","v":0},null,"Итого",{"$f":"H275+H276+H277+H278+H279+H280+H281+H282+H283+H284","v":0}]
["Плановые показатели",null,null,"Фактические показатели",null,null,null,null,"Сумма сбережений в этом месяце"]
["Доход за месяц",null,null,"Доход за месяц",null,null,null,"Введите % от остатка"]
["Расход за месяц",null,null,"Расход за месяц",null,null,null,"Сумма",{"$f":"I287*F289","v":0}]
["Остаток",{"$f":"B287-B288","v":0},null,"Остаток",null,{"$f":"F287-F288","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B296+B297+B298+B299+B300+B301+B302+B303+B304+B305","v":0},null,"Итого",{"$f":"E296+E297+E298+E299+E300+E301+E302+E303+E304+E305","v":0},null,"Итого",{"$f":"H296+H297+H298+H299+H300+H301+H302+H303+H304+H305","v":0},null,"Итого",{"$f":"K296+K297+K298+K299+K300+K301+K302+K303+K304+K305","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B309+B310+B311+B312+B313+B314+B315+B316+B317+B318","v":0},null,"Итого",{"$f":"E309+E310+E311+E312+E313+E314+E315+E316+E317+E318","v":0},null,"Итого",{"$f":"H309+H310+H311+H312+H313+H314+H315+H316+H317+H318","v":0},null,"Итого",{"$f":"K309+K310+K311+K312+K313+K314+K315+K316+K317+K318","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B322+B323+B324+B325+B326+B327+B328+B329+B330+B331","v":0},null,"Итого",{"$f":"E322+E323+E324+E325+E326+E327+E328+E329+E330+E331","v":0},null,"Итого",{"$f":"H322+H323+H324+H325+H326+H327+H328+H329+H330+H331","v":0}]
["Плановые показатели",null,null,"Фактические показатели",null,null,null,null,"Сумма сбережений в этом месяце"]
["Доход за месяц",null,null,"Доход за месяц",null,null,null,"Введите % от остатка"]
["Расход за месяц",null,null,"Расход за месяц",null,0,null,"Сумма",{"$f":"I334*F336","v":0}]
["Остаток",{"$f":"B334-B335","v":0},null,"Остаток",null,{"$f":"F334-F335","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B343+B344+B345+B346+B347+B348+B349+B350+B351+B352","v":0},null,"Итого",{"$f":"E343+E344+E345+E346+E347+E348+E349+E350+E351+E352","v":0},null,"Итого",{"$f":"H343+H344+H345+H346+H347+H348+H349+H350+H351+H352","v":0},null,"Итого",{"$f":"K343+K344+K345+K346+K347+K348+K349+K350+K351+K352","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B356+B357+B358+B359+B360+B361+B362+B363+B364+B365","v":0},null,"Итого",{"$f":"E356+E357+E358+E359+E360+E361+E362+E363+E364+E365","v":0},null,"Итого",{"$f":"H356+H357+H358+H359+H360+H361+H362+H363+H364+H365","v":0},null,"Итого",{"$f":"K356+K357+K358+K359+K360+K361+K362+K363+K364+K365","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B369+B370+B371+B372+B373+B374+B375+B376+B377+B378","v":0},null,"Итого",{"$f":"E369+E370+E371+E372+E373+E374+E375+E376+E377+E378","v":0},null,"Итого",{"$f":"H369+H370+H371+H372+H373+H374+H375+H376+H377+H378","v":0}]
["Плановые показатели",null,null,"Фактические показатели",null,null,null,null,"Сумма сбережений в этом месяце"]
["Доход за месяц",null,null,"Доход за месяц",null,null,null,"Введите % от остатка"]
["Расход за месяц",null,null,"Расход за месяц",null,0,null,"Сумма",{"$f":"I381*F383","v":0}]
["Остаток",{"$f":"B381-B382","v":0},null,"Остаток",null,{"$f":"F381-F382","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B390+B391+B392+B393+B394+B395+B396+B397+B398+B399","v":0},null,"Итого",{"$f":"E390+E391+E392+E393+E394+E395+E396+E397+E398+E399","v":0},null,"Итого",{"$f":"H390+H391+H392+H393+H394+H395+H396+H397+H398+H399","v":0},null,"Итого",{"$f":"K390+K391+K392+K393+K394+K395+K396+K397+K398+K399","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B403+B404+B405+B406+B407+B408+B409+B410+B411+B412","v":0},null,"Итого",{"$f":"E403+E404+E405+E406+E407+E408+E409+E410+E411+E412","v":0},null,"Итого",{"$f":"H403+H404+H405+H406+H407+H408+H409+H410+H411+H412","v":0},null,"Итого",{"$f":"K403+K404+K405+K406+K407+K408+K409+K410+K411+K412","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B416+B417+B418+B419+B420+B421+B422+B423+B424+B425","v":0},null,"Итого",{"$f":"E416+E417+E418+E419+E420+E421+E422+E423+E424+E425","v":0},null,"Итого",{"$f":"H416+H417+H418+H419+H420+H421+H422+H423+H424+H425","v":0}]
["Плановые показатели",null,null,"Фактические показатели",null,null,null,null,"Сумма сбережений в этом месяце"]
["Доход за месяц",null,null,"Доход за месяц",null,null,null,"Введите % от остатка"]
["Расход за месяц",null,null,"Расход за месяц",null,0,null,"Сумма",{"$f":"I428*F430","v":0}]
["Остаток",{"$f":"B428-B429","v":0},null,"Остаток",null,{"$f":"F428-F429","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B437+B438+B439+B440+B441+B442+B443+B444+B445+B446","v":0},null,"Итого",{"$f":"E437+E438+E439+E440+E441+E442+E443+E444+E445+E446","v":0},null,"Итого",{"$f":"H437+H438+H439+H440+H441+H442+H443+H444+H445+H446","v":0},null,"Итого",{"$f":"K437+K438+K439+K440+K441+K442+K443+K444+K445+K446","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B450+B451+B452+B453+B454+B455+B456+B457+B458+B459","v":0},null,"Итого",{"$f":"E450+E451+E452+E453+E454+E455+E456+E457+E458+E459","v":0},null,"Итого",{"$f":"H450+H451+H452+H453+H454+H455+H456+H457+H458+H459","v":0},null,"Итого",{"$f":"K450+K451+K452+K453+K454+K455+K456+K457+K458+K459","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B463+B464+B465+B466+B467+B468+B469+B470+B471+B472","v":0},null,"Итого",{"$f":"E463+E464+E465+E466+E467+E468+E469+E470+E471+E472","v":0},null,"Итого",{"$f":"H463+H464+H465+H466+H467+H468+H469+H470+H471+H472","v":0}]
["Плановые показатели",null,null,"Фактические показатели",null,null,null,null,"Сумма сбережений в этом месяце"]
["Доход за месяц",null,null,"Доход за месяц",null,null,null,"Введите % от остатка"]
["Расход за месяц",null,null,"Расход за месяц",null,0,null,"Сумма",{"$f":"I475*F477","v":0}]
["Остаток",{"$f":"B475-B476","v":0},null,"Остаток",null,{"$f":"F475-F476","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B484+B485+B486+B487+B488+B489+B490+B491+B492+B493","v":0},null,"Итого",{"$f":"E484+E485+E486+E487+E488+E489+E490+E491+E492+E493","v":0},null,"Итого",{"$f":"H484+H485+H486+H487+H488+H489+H490+H491+H492+H493","v":0},null,"Итого",{"$f":"K484+K485+K486+K487+K488+K489+K490+K491+K492+K493","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B497+B498+B499+B500+B501+B502+B503+B504+B505+B506","v":0},null,"Итого",{"$f":"E497+E498+E499+E500+E501+E502+E503+E504+E505+E506","v":0},null,"Итого",{"$f":"H497+H498+H499+H500+H501+H502+H503+H504+H505+H506","v":0},null,"Итого",{"$f":"K497+K498+K499+K500+K501+K502+K503+K504+K505+K506","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B510+B511+B512+B513+B514+B515+B516+B517+B518+B519","v":0},null,"Итого",{"$f":"E510+E511+E512+E513+E514+E515+E516+E517+E518+E519","v":0},null,"Итого",{"$f":"H510+H511+H512+H513+H514+H515+H516+H517+H518+H519","v":0}]
["Плановые показатели",null,null,"Фактические показатели",null,null,null,null,"Сумма сбережений в этом месяце"]
["Доход за месяц",null,null,"Доход за месяц",null,null,null,"Введите % от остатка"]
["Расход за месяц",null,null,"Расход за месяц",null,0,null,"Сумма",{"$f":"I522*F524","v":0}]
["Остаток",{"$f":"B522-B523","v":0},null,"Остаток",null,{"$f":"F522-F523","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B531+B532+B533+B534+B535+B536+B537+B538+B539+B540","v":0},null,"Итого",{"$f":"E531+E532+E533+E534+E535+E536+E537+E538+E539+E540","v":0},null,"Итого",{"$f":"H531+H532+H533+H534+H535+H536+H537+H538+H539+H540","v":0},null,"Итого",{"$f":"K531+K532+K533+K534+K535+K536+K537+K538+K539+K540","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B544+B545+B546+B547+B548+B549+B550+B551+B552+B553","v":0},null,"Итого",{"$f":"E544+E545+E546+E547+E548+E549+E550+E551+E552+E553","v":0},null,"Итого",{"$f":"H544+H545+H546+H547+H548+H549+H550+H551+H552+H553","v":0},null,"Итого",{"$f":"K544+K545+K546+K547+K548+K549+K550+K551+K552+K553","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Итого",{"$f":"B557+B558+B559+B560+B561+B562+B563+B564+B565+B566","v":0},null,"Итого",{"$f":"E557+E558+E559+E560+E561+E562+E563+E564+E565+E566","v":0},null,"Итого",{"$f":"H557+H558+H559+H560+H561+H562+H563+H564+H565+H566","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Месяц","Коммунальные услуги","Развлечения","Транспорт","Кредиты","Питание","Дети","Хозяйственные расходы","Забота о себе","Прочее","Категория1","Категория2"]
["Январь",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B602:L602)","v":0}]
["Февраль",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B603:L603)","v":0}]
["Март",null,null,null,null,null,null,null,null,null,null,null,0]
["Апрель",888,0,0,null,0,null,0,null,null,null,null,888]
["Май",null,null,null,null,null,null,null,null,null,null,null,0]
["Июнь",null,null,null,null,null,null,null,null,null,null,null,0]
["Июль",null,null,null,null,null,null,null,null,null,null,null,0]
["Август",null,null,null,null,null,null,null,null,null,null,null,0]
["Сентябрь",null,null,null,null,null,null,null,null,null,null,null,0]
["Октябрь",null,null,null,null,null,null,null,null,null,null,null,0]
["Ноябрь",null,null,null,null,null,null,null,null,null,null,null,0]
["Декабрь",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B613:L613)","v":0}]
["Итого за год:",{"$f":"SUM(B602:B613)","v":888},{"$f":"SUM(C602:C613)","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[null,"Месяц","Сумма",null,"план",null,null,null,"Валюта"]
[null,"Январь",{"$f":"I3","v":0},{"$f":"I2","v":0},null,null,"Сумма","Сумма","Дата","Вид валюты","Сумма","Курс сделки/покупки","Стоимость","Текущий курс","Текущая стоимость"]
[null,"Февраль",{"$f":"I51","v":0},{"$f":"I50","v":0},null,null,null,null,null,{"$f":"Инвестиции!C11","v":0},{"$f":"Инвестиции!D11","v":0},{"$f":"Инвестиции!E11","v":0},{"$f":"K622*L622","v":0},{"$f":"Инвестиции!G11","v":0},{"$f":"K622*N622","v":0}]
[null,"Март",{"$f":"I100","v":0},{"$f":"I99","v":0},null,null,null,null,null,{"$f":"Инвестиции!C12","v":0},{"$f":"Инвестиции!D12","v":0},{"$f":"Инвестиции!E12","v":0},{"$f":"K623*L623","v":0},{"$f":"Инвестиции!G12","v":0},{"$f":"K623*N623","v":0}]
[null,"Апрель",{"$f":"I147","v":0},{"$f":"I146","v":0},null,null,null,null,null,{"$f":"Инвестиции!C13","v":0},{"$f":"Инвестиции!D13","v":0},{"$f":"Инвестиции!E13","v":0},{"$f":"K624*L624","v":0},{"$f":"Инвестиции!G13","v":0},{"$f":"K624*N624","v":0}]
[null,"Май",{"$f":"I194","v":0},{"$f":"I193","v":0},null,null,null,null,null,{"$f":"Инвестиции!C14","v":0},{"$f":"Инвестиции!D14","v":0},{"$f":"Инвестиции!E14","v":0},{"$f":"K625*L625","v":0},{"$f":"Инвестиции!G14","v":0},{"$f":"K625*N625","v":0}]
[null,"Июнь",{"$f":"I241","v":0},{"$f":"I240","v":0},null,null,null,null,null,{"$f":"Инвестиции!C15","v":0},{"$f":"Инвестиции!D15","v":0},{"$f":"Инвестиции!E15","v":0},{"$f":"K626*L626","v":0},{"$f":"Инвестиции!G15","v":0},{"$f":"K626*N626","v":0}]
[null,"Июль",{"$f":"I288","v":0},{"$f":"I287","v":0},null,null,{"$f":"SUM(G622:G626)","v":0},{"$f":"SUM(H622:H626)","v":0},"Затраты",null,null,null,{"$f":"SUM(M622:M626)","v":0}]
[null,"Август",{"$f":"I335","v":0},{"$f":"I334","v":0}]
[null,"Сентябрь",{"$f":"I382","v":0},{"$f":"I381","v":0},null,null,null,null,"Акции/Облигации"]
[null,"Октябрь",{"$f":"I429","v":0},{"$f":"I428","v":0},null,null,"Сумма","Сумма","Дата","Актив","Количество","Курс сделки","Сумма затрат","Дивиденды/%-ты(руб.)","Текущая цена","Доход"]
[null,"Ноябрь",{"$f":"I476","v":0},{"$f":"I475","v":0},null,null,null,null,null,{"$f":"Инвестиции!C20","v":0},{"$f":"Инвестиции!D20","v":0},{"$f":"Инвестиции!E20","v":0},{"$f":"K631*L631","v":0},{"$f":"Инвестиции!G20","v":0},{"$f":"Инвестиции!H20","v":0},{"$f":"K631*O631+N631","v":0}]
[null,"Декабрь",{"$f":"I523","v":0},{"$f":"I522","v":0},null,null,null,null,null,{"$f":"Инвестиции!C21","v":0},{"$f":"Инвестиции!D21","v":0},{"$f":"Инвестиции!E21","v":0},{"$f":"K632*L632","v":0},{"$f":"Инвестиции!G21","v":0},{"$f":"Инвестиции!H21","v":0},{"$f":"K632*O632+N632","v":0}]
[null,"Итог",{"$f":"SUM(C621:C632)","v":0},null,null,null,null,null,null,{"$f":"Инвестиции!C22","v":0},{"$f":"Инвестиции!D22","v":0},{"$f":"Инвестиции!E22","v":0},0,{"$f":"Инвестиции!G22","v":0},{"$f":"Инвестиции!H22","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"Инвестиции!C23","v":0},{"$f":"Инвестиции!D23","v":0},{"$f":"Инвестиции!E23","v":0},0,{"$f":"Инвестиции!G23","v":0},{"$f":"Инвестиции!H23","v":0},0]
[null,"Сбережения",0,null,null,null,null,null,null,{"$f":"Инвестиции!C24","v":0},{"$f":"Инвестиции!D24","v":0},{"$f":"Инвестиции!E24","v":0},0,{"$f":"Инвестиции!G24","v":0},{"$f":"Инвестиции!H24","v":0},0]
[null,"Цели",null,null,null,null,{"$f":"SUM(G631:G635)","v":0},{"$f":"SUM(H631:H635)","v":0},"Затраты",null,null,null,{"$f":"SUM(M631:M635)","v":0}]
[null,"Итог",{"$f":"C635-C636","v":0}]
[null,"Инвестиции(-)",{"$f":"G627+G636+G645+G651","v":0},null,null,null,null,null,"Депозит"]
[null,"Итог1",{"$f":"C637-C638","v":0},null,null,null,"Сумма","Сумма","Дата","Сумма","%-т","Срок","m","Сумма"]
[null,"Инвестиции(+)",{"$f":"H627+H636+H645+H651","v":0},null,null,null,null,null,null,{"$f":"Инвестиции!C29","v":0},{"$f":"Инвестиции!D29","v":0},{"$f":"Инвестиции!E29","v":0},{"$f":"Инвестиции!F29","v":0},{"$f":"J640*(1+K640/M640)^M640*L640","v":{"$error":"#DIV/0!"}}]
[null,"Итог2",{"$f":"C639+C640","v":0},null,null,null,null,null,null,{"$f":"Инвестиции!C30","v":0},{"$f":"Инвестиции!D30","v":0},{"$f":"Инвестиции!E30","v":0},{"$f":"Инвестиции!F30","v":0},{"$f":"J641*(1+K641/M641)^M641*L641","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"Инвестиции!C31","v":0},{"$f":"Инвестиции!D31","v":0},{"$f":"Инвестиции!E31","v":0},{"$f":"Инвестиции!F31","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,{"$f":"Инвестиции!C32","v":0},{"$f":"Инвестиции!D32","v":0},{"$f":"Инвестиции!E32","v":0},{"$f":"Инвестиции!F32","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,{"$f":"Инвестиции!C33","v":0},{"$f":"Инвестиции!D33","v":0},{"$f":"Инвестиции!E33","v":0},{"$f":"Инвестиции!F33","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,{"$f":"SUM(G640:G644)","v":0},{"$f":"SUM(H640:H644)","v":0},"Затраты",{"$f":"SUM(J640:J644)","v":0}]
[]
[null,null,"Доход",null,"Расход",null,null,null,"Депозит(2)"]
[null,null,"план","факт","план","факт","Сумма","Сумма","сумма 1 вклада","сумма пополнений","%","срок","m","p","Сумма"]
[null,"январь",{"$f":"B2","v":0},{"$f":"F2","v":0},{"$f":"B3","v":0},{"$f":"M602","v":0},null,null,{"$f":"Инвестиции!C36","v":0},{"$f":"Инвестиции!D36","v":0},{"$f":"Инвестиции!E36","v":0},{"$f":"Инвестиции!F36","v":0},{"$f":"Инвестиции!G36","v":0},{"$f":"Инвестиции!H36","v":0},{"$f":"Инвестиции!I36","v":{"$error":"#DIV/0!"}}]
[null,"февраль",{"$f":"B50","v":0},{"$f":"F50","v":0},{"$f":"B51","v":0},0,null,null,{"$f":"Инвестиции!C37","v":0},{"$f":"Инвестиции!D37","v":0},{"$f":"Инвестиции!E37","v":0},{"$f":"Инвестиции!F37","v":0},{"$f":"Инвестиции!G37","v":0},{"$f":"Инвестиции!H37","v":0},{"$f":"Инвестиции!I37","v":{"$error":"#DIV/0!"}}]
[null,"март",{"$f":"B99","v":0},{"$f":"F99","v":0},{"$f":"B100","v":0},0,{"$f":"SUM(G649:G650)","v":0},{"$f":"SUM(H649:H650)","v":0}]
[null,"апрель",{"$f":"B146","v":0},{"$f":"F146","v":0},{"$f":"B147","v":0},888]
[null,"май",{"$f":"B193","v":0},{"$f":"F193","v":0},{"$f":"B194","v":0},0]
[null,"июнь",{"$f":"B240","v":0},{"$f":"F240","v":0},{"$f":"B241","v":0},0]
[null,"июль",{"$f":"B287","v":0},{"$f":"F287","v":0},{"$f":"B288","v":0},0]
[null,"август",{"$f":"B334","v":0},{"$f":"F334","v":0},{"$f":"B335","v":0},0]
[null,"сентябрь",{"$f":"B381","v":0},{"$f":"F381","v":0},{"$f":"B382","v":0},0]
[null,"октябрь",{"$f":"B428","v":0},{"$f":"F428","v":0},{"$f":"B429","v":0},0]
[null,"ноябрь",{"$f":"B475","v":0},{"$f":"F475","v":0},{"$f":"B476","v":0},0]
[null,"декабрь",{"$f":"B522","v":0},{"$f":"F522","v":0},{"$f":"B523","v":0},0]
[]
[]
[null,null,null,null,"Фин цели","план"]
[null,null,null,"январь"]
[null,null,null,"февраль"]
[null,null,null,"март"]
[null,null,null,"апрель"]
[null,null,null,"май"]
[null,null,null,"июнь"]
[null,null,null,"июль"]
[null,null,null,"август"]
[null,null,null,"сентябрь"]
[null,null,null,"октябрь"]
[null,null,null,"ноябрь"]
[null,null,null,"декабрь"]

{"sheet":"А-П","index":4,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[[13,15,13,16],[12,15,12,16],[11,15,11,16],[9,15,9,16],[8,15,8,16],[8,8,8,9],[13,8,13,9],[12,8,12,9],[11,8,11,9],[10,8,10,9],[9,8,9,9],[23,4,23,7],[23,8,23,9],[23,11,23,14],[23,15,23,16],[14,8,14,9],[20,8,20,9],[19,8,19,9],[18,8,18,9],[15,8,15,9],[18,4,18,7],[17,8,17,9],[16,8,16,9],[8,11,8,14],[22,15,22,16],[21,15,21,16],[20,15,20,16],[19,15,19,16],[18,15,18,16],[17,15,17,16],[16,15,16,16],[15,15,15,16],[14,15,14,16],[14,11,14,14],[13,11,13,14],[12,11,12,14],[10,15,10,16],[10,11,10,14],[11,11,11,14],[7,11,7,14],[9,11,9,14],[16,4,16,7],[22,11,22,14],[21,11,21,14],[20,11,20,14],[19,11,19,14],[18,11,18,14],[17,11,17,14],[16,11,16,14],[22,8,22,9],[21,8,21,9],[22,4,22,7],[21,4,21,7],[20,4,20,7],[19,4,19,7],[1,3,2,16],[6,3,6,9],[6,10,6,16],[7,15,7,16],[17,4,17,7],[8,4,8,7],[9,4,9,7],[10,4,10,7],[11,4,11,7],[15,4,15,7],[14,4,14,7],[13,4,13,7],[12,4,12,7],[15,11,15,14],[7,4,7,7],[7,8,7,9]]}
[]
[null,null,null,"Активы/Пассивы"]
[]
[]
[]
[]
[null,null,null,"Активы",null,null,null,null,null,null,"Пассивы"]
[null,null,null,"Наименование актива","Комментарий",null,null,null,"Стоимость",null,"Наименование пассива","Комментарий",null,null,null,"Сумма"]
[null,null,null,"Квартира"]
[null,null,null,"Машина"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Итого активов",null,null,null,{"$f":"SUM(I9:J23)","v":0},null,null,"Итого пассивов",null,null,null,{"$f":"SUM(P9:Q23)","v":0}]

{"sheet":"Финансовые цели","index":5,"n_rows":33,"n_cols":18,"rows_kept":33,"cut":false,"hidden":false,"merged":[[7,2,7,3],[8,2,8,3],[30,14,32,16],[30,17,32,19],[22,14,24,16],[19,14,21,16],[19,17,21,19],[22,17,24,19],[27,14,29,16],[27,17,29,19],[12,4,12,11],[11,14,13,16],[14,14,16,16],[14,17,16,19],[11,17,13,19],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[13,4,13,11],[14,4,14,11],[15,4,15,11],[16,4,16,11],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[27,2,27,12],[29,4,29,11],[30,4,30,11],[31,4,31,11],[28,2,28,3],[28,4,28,11],[32,4,32,11],[2,17,5,18],[6,17,7,18],[2,2,5,15],[12,2,12,3],[24,2,24,3],[21,4,21,11],[22,4,22,11],[23,4,23,11],[24,4,24,11],[20,2,20,3],[20,4,20,11],[21,2,21,3],[22,2,22,3],[23,2,23,3],[11,2,11,12],[19,2,19,12]]}
[]
[]
[null,null,"Финансовые Цели",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ваши сбережения"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Текущий месяц"]
[null,null,"Апрель"]
[]
[]
[null,null,"Краткосрочные цели",null,null,null,null,null,null,null,null,null,null,null,"Фото",null,null,"Фото"]
[null,null,"Номер",null,"Название",null,null,null,null,null,null,null,"Цена"]
[null,null,"1."]
[null,null,"2.",null,null,null,null,null,null,null,null,null,null,null,"Фото",null,null,"Фото"]
[null,null,"3."]
[null,null,"4."]
[]
[]
[null,null,"Среднесрочные цели",null,null,null,null,null,null,null,null,null,null,null,"Фото",null,null,"Фото"]
[null,null,"Номер",null,"Название",null,null,null,null,null,null,null,"Цена"]
[null,null,"1."]
[null,null,"2.",null,null,null,null,null,null,null,null,null,null,null,"Фото",null,null,"Фото"]
[null,null,"3."]
[null,null,"4."]
[]
[]
[null,null,"Долгосрочные цели",null,null,null,null,null,null,null,null,null,null,null,"Фото",null,null,"Фото"]
[null,null,"Номер",null,"Название",null,null,null,null,null,null,null,"Цена"]
[null,null,"1."]
[null,null,"2.",null,null,null,null,null,null,null,null,null,null,null,"Фото",null,null,"Фото"]
[null,null,"3."]
[null,null,"4."]

{"sheet":"Инвестиции","index":6,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,13,2,14],[3,13,3,14],[6,9,7,9],[1,1,3,9],[26,1,26,6],[1,11,2,12],[3,11,4,12],[24,2,25,4],[24,1,25,1],[5,1,7,1],[8,1,8,7],[17,1,17,8],[8,12,10,13],[12,12,16,13],[18,12,19,13],[21,12,22,13],[33,1,33,8],[3,16,3,17],[5,2,7,3],[24,11,24,13],[26,11,26,13],[25,11,25,13]]}
[]
[null,"Инвестиции и накопления",null,null,null,null,null,null,null,null,null,"Ваши сбережения"]
[]
[null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,"Валюта",null,null,null,null,null,null,null,null,null,null,"Инвестиции приносят доход"]
[null,"Дата","Вид валюты","Сумма","Курс сделки/покупки","Стоимость","Текущий курс","Текущая стоимость"]
["1.",null,null,null,null,{"$f":"D11*E11","v":0},null,{"$f":"D11*G11","v":0}]
["2.",null,null,null,null,{"$f":"D12*E12","v":0},null,{"$f":"D12*G12","v":0}]
["3.",null,null,null,null,{"$f":"D13*E13","v":0},null,{"$f":"D13*G13","v":0},null,null,null,null,"Инвестиции не приносят доход, возможно следует избавиться от инвестиции"]
["4.",null,null,null,null,{"$f":"D14*E14","v":0},null,{"$f":"D14*G14","v":0}]
["5.",null,null,null,null,{"$f":"D15*E15","v":0},null,{"$f":"D15*G15","v":0}]
[]
[]
[null,"Акции/Облигации"]
[null,"Дата","Актив","Количество","Курс сделки","Сумма затрат","Дивиденды/%-ты(руб.)","Текущая цена","Доход",null,null,null,"Инвестировать"]
["1.",null,null,null,null,{"$f":"D20*E20","v":0},null,null,{"$f":"D20*H20+G20","v":0}]
["2.",null,null,null,null,{"$f":"D21*E21","v":0},null,null,{"$f":"D21*H21+G21","v":0}]
["3.",null,null,null,null,0,null,null,0,null,null,null,"Продать/забрать деньги"]
["4.",null,null,null,null,0,null,null,0]
["5.",null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"Ячейки, выделенные цветом:"]
[]
[null,"Депозит",null,null,null,null,null,null,null,null,null,"заполняются вручную"]
[null,"Дата","Сумма","%-т","Срок","m","Сумма"]
["1.",null,null,null,null,null,{"$f":"C29*(1+D29/F29)^F29*E29","v":{"$error":"#DIV/0!"}}]
["2.",null,null,null,null,null,{"$f":"C30*(1+D30/F30)^F30*E30","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"Депозит (с одинаковой суммой пополнения)"]
[null,"Дата","Сумма 1 вклада","Сумма пополнений","%","срок","m","p","Сумма"]
["1.",null,null,null,null,null,null,null,{"$f":"C36+(D36*((((1+E36/G36)^(G36*F36))-1)/(E36/G36))/((((1+E36/G36)^(G36/H36))-1)/(E36/G36)))","v":{"$error":"#DIV/0!"}}]
["2.",null,null,null,null,null,null,null,{"$f":"C37+D37*((((((1+E37/G37)^G37*F37)-1)/(E37/G37))/((((1+E37/G37)^(G37/H37))-1)/(E37/G37))))","v":{"$error":"#DIV/0!"}}]

{"sheet":"Инвестиционный портфель","index":7,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":false,"merged":[[14,1,14,4],[1,13,1,14],[2,13,5,13],[2,14,5,14],[7,16,7,18],[9,16,10,18],[11,17,11,18],[12,17,12,18],[1,0,1,6],[3,1,3,5],[1,16,2,18],[3,16,3,18],[4,16,4,18],[5,16,5,18],[6,16,6,18],[24,13,24,14],[25,13,25,14],[26,13,26,14],[13,17,13,18],[14,17,14,18],[15,17,15,18],[21,13,23,14]]}
[]
["Определение типа инвестора",null,null,null,null,null,null,null,null,null,null,null,null,"Возможные инвестиционные активы",null,null,"Идеальный* инвестиционный портфель для умеренного инвестора"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Название","Минимальный размер капитала, необходимый для инвестирования (тыс.руб.)"]
[null,"Результаты опроса",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Банковский депозит"]
["№","Агрессивный","Умеренный","Мечтатель","Консервативный","Трейдер",null,null,null,null,null,null,null,null,null,null,"Монеты"]
[1,0,0.7,0,0.92,0,null,null,null,null,null,null,null,null,null,null,"Опционы"]
[2,1,1,0,0,0,null,null,null,null,null,null,null,"Банковский депозит",10,null,"Акции"]
[3,1,1,0,1,1,null,null,null,null,null,null,null,"Монеты",3,null,"Еврооблигации"]
[4,0,5,0,0,5,null,null,null,null,null,null,null,"Акции",30]
[5,1,1,0,1,0,null,null,null,null,null,null,null,"Опционы",10,null,"Возможное распределение введенного размера капитала по инструментам:"]
[6,0,0.83,0,0.93,0,null,null,null,null,null,null,null,"Депозитарные расписки",100]
["Сумма:",{"$f":"SUM(B6:B11)","v":3},{"$f":"SUM(C6:C11)","v":9.5299999999999994},0,3.85,6,null,null,null,null,null,null,null,"Еврооблигации",100,null,"Банковский депозит",0.5]
[{"$f":"SUM(B12:F12)","v":22.38},{"$f":"B12/A13","v":0.13404825737265416},{"$f":"C12/A13","v":0.42582663092046469},{"$f":"D12/A13","v":0},{"$f":"E12/A13","v":0.17202859696157285},{"$f":"F12/A13","v":0.26809651474530832},null,null,null,null,null,null,null,"Доверительное управление",100,null,"Монеты",5.3333330899477005E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Опционы",0.12333333492279053]
[null,"Процентное соотношение типов инвестора",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Акции",0.32333335280418396]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ваш размер капитала",100,"тыс. руб."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Рекомендуем вкладывать средства в инструменты, подверженные наименьшим рискам. К таким относятся:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ОМС"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Облигации государственные"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Облигации корпоративные"]