{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["рабочий лист"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":99,"n_cols":9,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"остаток денег в день"]
["Названия строк","Сумма по полю Кредит",70582.799999999988]
["2014-01-01",327,{"$f":"C3+B4","v":70909.799999999988}]
["2014-01-02",null,{"$f":"C4+B5","v":70909.799999999988}]
["2014-01-03",null,70909.799999999988]
["2014-01-04",null,70909.799999999988,null,null,"С январем как ЭТО СДЕЛАЛА Я. Вставила недостающие даты, протянуда формулу и нашла среднее."]
["2014-01-05",null,70909.799999999988,null,null,"Может с другими месяцами можно сделать по-другому?"]
["2014-01-06",null,70909.799999999988]
["2014-01-07",null,70909.799999999988,null,"Дата","Сумма","Остаток",null,"Средний остаток"]
["2014-01-08",null,70909.799999999988,null,"2014-01-01",327,70909.799999999988,null,{"$f":"Average_Remains(E11:E20,G11:G20)","v":74090.414838709694}]
["2014-01-09",68,70977.799999999988,null,"2014-01-09",68,70977.799999999988]
["2014-01-10",null,70977.799999999988,null,"2014-01-16",7131.5,78109.299999999988]
["2014-01-11",null,70977.799999999988,null,"2014-01-20",-2038.96,76070.339999999982]
["2014-01-12",null,70977.799999999988,null,"2014-01-23",68,76138.339999999982]
["2014-01-13",null,70977.799999999988,null,"2014-01-24",-4506,71632.339999999982]
["2014-01-14",null,70977.799999999988,null,"2014-01-27",5087.1000000000004,76719.439999999988]
["2014-01-15",null,70977.799999999988,null,"2014-01-29",10463.36,87182.799999999988]
["2014-01-16",7131.5,78109.299999999988,null,"2014-01-30",-7029.5,80153.299999999988]
["2014-01-17",null,78109.299999999988,null,"2014-01-31",68,80221.299999999988]
["2014-01-18",null,78109.299999999988]
["2014-01-19",null,78109.299999999988]
["2014-01-20",-2038.96,76070.339999999982]
["2014-01-21",null,76070.339999999982]
["2014-01-22",null,76070.339999999982]
["2014-01-23",68,76138.339999999982]
["2014-01-24",-4506,71632.339999999982]
["2014-01-25",null,71632.339999999982]
["2014-01-26",null,71632.339999999982]
["2014-01-27",5087.1000000000004,76719.439999999988]
["2014-01-28",null,76719.439999999988]
["2014-01-29",10463.36,87182.799999999988]
["2014-01-30",-7029.5,80153.299999999988]
["2014-01-31",68,80221.299999999988,{"$f":"AVERAGE(C4:C34)","v":74090.414838709694}]
["2014-02-04",10022.5]
["2014-02-06",1226]
["2014-02-07",68]
["2014-02-12",68]
["2014-02-19",-15120.6]
["2014-02-20",-500]
["2014-02-21",8591.5]
["2014-02-24",-18692.900000000001]
["2014-02-25",-2260]
["2014-02-26",1404]
["2014-03-01",1916]
["2014-03-04",102]
["2014-03-11",68]
["2014-03-13",-12165]
["2014-03-18",-272]
["2014-03-19",-4793]
["2014-03-20",7256.01]
["2014-03-25",68]
["2014-03-26",68]
["2014-03-28",0]
["2014-03-31",6]
["2014-04-01",-30040.61]
["2014-04-08",-11031.25]
["2014-04-16",6182.0000000000009]
["2014-04-17",10731.970000000001]
["2014-04-18",276]
["2014-04-22",143]
["2014-04-24",7168]
["2014-04-28",496.5]
["2014-04-30",96]
["2014-05-01",110.5]
["2014-05-09",68]
["2014-05-13",136]
["2014-05-14",-20607.75]
["2014-05-15",-4879.0300000000007]
["2014-05-16",68]
["2014-05-20",8620.0400000000009]
["2014-05-23",2579]
["2014-05-24",68]
["2014-06-01",-2]
["2014-06-04",-8552.0400000000009]
["2014-06-12",68]
["2014-06-13",-2919]
["2014-06-16",10649.5]
["2014-06-18",-5692.54]
["2014-07-01",204]
["2014-07-02",-10649.5]
["2014-07-04",1442]
["2014-07-10",10455.200000000001]
["2014-07-19",68]
["2014-07-22",969.06999999999994]
["2014-07-24",-10309]
["2014-07-25",7967.8099999999995]
["2014-07-29",12474.4]
["2014-07-31",192]
["2014-08-01",33772.520000000004]
["2014-08-05",-1781.18]
["2014-08-06",68]
["2014-08-11",990.08]
["2014-08-12",68]
["2014-08-15",28.5]
["2014-08-18",-8364.5399999999991]
["2014-08-19",68]
["2014-08-20",68]
["2014-08-25",990.08]