{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Инструкция","Расходы","Динамика расходов"],"not_rendered":{"charts":1,"defined_names":5,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Инструкция","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Расходы","index":1,"n_rows":59,"n_cols":6,"rows_kept":59}
["статьи обязательных расходов","доход","расход","остаток","потрачено"]
["доход1",30000]
["доход2",11000]
["доход3",2000]
["расход1",null,0,null,0]
["расход2",null,1500,null,1500]
["расход3",null,5300,null,5300]
["расход4",null,850,null,850]
["расход5",null,150,null,150]
["расход6",null,150,null,150]
["расход7",null,0,null,0]
["расход8",null,200,null,0]
["расход9",null,1100,null,0]
["расход10",null,200,null,0]
["расход11",null,200,null,0]
["расход12",null,1000,null,0]
["расход13",null,0,null,0]
["расход14",null,0,null,0]
[]
[]
["итого",{"$f":"SUM(B2:B20)","v":43000},{"$f":"SUM(C5:C20)","v":10650},{"$f":"B21-C21","v":32350},{"$f":"SUM(E2:E20)","v":7950}]
[]
["дней в месяце",30,"получ.в день",{"$f":"D21/B23","v":1078.3333333333333}]
["допустимый лимит в день",1000]
["итого по лимиту",{"$f":"B24*B23","v":30000}]
["своб. средства",{"$f":"D21-B25","v":2350}]
[]
[null,"наличие","потрачено","скор. расхода","закончатся","рекомендация"]
["остаток",{"v":32350,"d":"32,350.00р."}]
[1,{"v":24000,"d":"24,000.00р."},{"$f":"ostatok-B30","v":{"v":8350,"d":"8,350.00р."}},{"$f":"C30/A30","v":{"v":8350,"d":"8,350.00р."}},{"$f":"ostatok/D30","v":{"v":3.874251497005988,"d":"4"}},{"$f":"B30/(daymonth-A30)","v":{"v":827.5862068965517,"d":"827.59р."}}]
[2,{"v":23500,"d":"23,500.00р."},{"v":8850,"d":"8,850.00р."},{"v":4425,"d":"4,425.00р."},{"v":7.3107344632768365,"d":"7"},{"v":839.2857142857143,"d":"839.29р."}]
[3,{"v":17000,"d":"17,000.00р."},{"v":15350,"d":"15,350.00р."},{"v":5116.666666666667,"d":"5,116.67р."},{"v":6.322475570032573,"d":"6"},{"v":629.6296296296297,"d":"629.63р."}]
[4,{"v":15000,"d":"15,000.00р."},{"v":17350,"d":"17,350.00р."},{"v":4337.5,"d":"4,337.50р."},{"v":7.45821325648415,"d":"7"},{"v":576.9230769230769,"d":"576.92р."}]
[5,{"v":12500,"d":"12,500.00р."},{"v":19850,"d":"19,850.00р."},{"v":3970,"d":"3,970.00р."},{"v":8.148614609571789,"d":"8"},{"v":500,"d":"500.00р."}]
[6,{"v":11000,"d":"11,000.00р."},{"v":21350,"d":"21,350.00р."},{"v":3558.3333333333335,"d":"3,558.33р."},{"v":9.091334894613583,"d":"9"},{"v":458.3333333333333,"d":"458.33р."}]
[7,{"v":9500,"d":"9,500.00р."},{"v":22850,"d":"22,850.00р."},{"v":3264.285714285714,"d":"3,264.29р."},{"v":9.910284463894968,"d":"10"},{"v":413.04347826086956,"d":"413.04р."}]
[8,{"v":9000,"d":"9,000.00р."},{"v":23350,"d":"23,350.00р."},{"v":2918.75,"d":"2,918.75р."},{"v":11.083511777301927,"d":"11"},{"v":409.09090909090907,"d":"409.09р."}]
[9,{"v":8000,"d":"8,000.00р."},{"v":24350,"d":"24,350.00р."},{"v":2705.5555555555557,"d":"2,705.56р."},{"v":11.956878850102669,"d":"12"},{"v":380.95238095238096,"d":"380.95р."}]
[10,{"v":7500,"d":"7,500.00р."},{"v":24850,"d":"24,850.00р."},{"v":2485,"d":"2,485.00р."},{"v":13.018108651911469,"d":"13"},{"v":375,"d":"375.00р."}]
[11,{"v":6500,"d":"6,500.00р."},{"v":25850,"d":"25,850.00р."},{"v":2350,"d":"2,350.00р."},{"v":13.76595744680851,"d":"14"},{"v":342.10526315789474,"d":"342.11р."}]
[12,{"v":6000,"d":"6,000.00р."},{"v":26350,"d":"26,350.00р."},{"v":2195.8333333333335,"d":"2,195.83р."},{"v":14.73244781783681,"d":"15"},{"v":333.3333333333333,"d":"333.33р."}]
[13,{"v":6000,"d":"6,000.00р."},{"v":26350,"d":"26,350.00р."},{"v":2026.923076923077,"d":"2,026.92р."},{"v":15.960151802656547,"d":"16"},{"v":352.94117647058823,"d":"352.94р."}]
[14,{"v":5500,"d":"5,500.00р."},{"v":26850,"d":"26,850.00р."},{"v":1917.857142857143,"d":"1,917.86р."},{"v":16.86778398510242,"d":"17"},{"v":343.75,"d":"343.75р."}]
[15,{"v":5000,"d":"5,000.00р."},{"v":27350,"d":"27,350.00р."},{"v":1823.3333333333333,"d":"1,823.33р."},{"v":17.742230347349178,"d":"18"},{"v":333.3333333333333,"d":"333.33р."}]
[16,{"v":4500,"d":"4,500.00р."},{"v":27850,"d":"27,850.00р."},{"v":1740.625,"d":"1,740.63р."},{"v":18.585278276481148,"d":"19"},{"v":321.42857142857144,"d":"321.43р."}]
[17,{"v":4000,"d":"4,000.00р."},{"v":28350,"d":"28,350.00р."},{"v":1667.6470588235295,"d":"1,667.65р."},{"v":19.39858906525573,"d":"19"},{"v":307.6923076923077,"d":"307.69р."}]
[18,{"v":4000,"d":"4,000.00р."},{"v":28350,"d":"28,350.00р."},{"v":1575,"d":"1,575.00р."},{"v":20.53968253968254,"d":"21"},{"v":333.3333333333333,"d":"333.33р."}]
[19,{"v":4000,"d":"4,000.00р."},{"v":28350,"d":"28,350.00р."},{"v":1492.1052631578948,"d":"1,492.11р."},{"v":21.680776014109348,"d":"22"},{"v":363.6363636363636,"d":"363.64р."}]
[20,{"v":4000,"d":"4,000.00р."},{"v":28350,"d":"28,350.00р."},{"v":1417.5,"d":"1,417.50р."},{"v":22.821869488536155,"d":"23"},{"v":400,"d":"400.00р."}]
[21,{"v":4000,"d":"4,000.00р."},{"v":28350,"d":"28,350.00р."},{"v":1350,"d":"1,350.00р."},{"v":23.962962962962962,"d":"24"},{"v":444.44444444444446,"d":"444.44р."}]
[22,{"v":2200,"d":"2,200.00р."},{"v":30150,"d":"30,150.00р."},{"v":1370.4545454545455,"d":"1,370.45р."},{"v":23.60530679933665,"d":"24"},{"v":275,"d":"275.00р."}]
[23,{"v":2000,"d":"2,000.00р."},{"v":30350,"d":"30,350.00р."},{"v":1319.5652173913043,"d":"1,319.57р."},{"v":24.515650741350907,"d":"25"},{"v":285.7142857142857,"d":"285.71р."}]
[24,{"v":1500,"d":"1,500.00р."},{"v":30850,"d":"30,850.00р."},{"v":1285.4166666666667,"d":"1,285.42р."},{"v":25.166936790923824,"d":"25"},{"v":250,"d":"250.00р."}]
[25,{"v":1100,"d":"1,100.00р."},{"v":31250,"d":"31,250.00р."},{"v":1250,"d":"1,250.00р."},{"v":25.88,"d":"26"},{"v":220,"d":"220.00р."}]
[26,{"v":600,"d":"600.00р."},{"v":31750,"d":"31,750.00р."},{"v":1221.1538461538462,"d":"1,221.15р."},{"v":26.491338582677166,"d":"26"},{"v":150,"d":"150.00р."}]
[27,{"v":600,"d":"600.00р."},{"v":31750,"d":"31,750.00р."},{"v":1175.9259259259259,"d":"1,175.93р."},{"v":27.510236220472443,"d":"28"},{"v":200,"d":"200.00р."}]
[28,{"v":600,"d":"600.00р."},{"v":31750,"d":"31,750.00р."},{"v":1133.9285714285713,"d":"1,133.93р."},{"v":28.52913385826772,"d":"29"},{"v":300,"d":"300.00р."}]
[29,{"v":600,"d":"600.00р."},{"v":31750,"d":"31,750.00р."},{"v":1094.8275862068965,"d":"1,094.83р."},{"v":29.548031496062993,"d":"30"},{"v":600,"d":"600.00р."}]
[30,{"v":600,"d":"600.00р."},{"v":31750,"d":"31,750.00р."},{"v":1058.3333333333333,"d":"1,058.33р."},{"v":30.56692913385827,"d":"31"},{"$error":"#DIV/0!"}]

{"sheet":"Динамика расходов","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}