{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Лист1","index":0,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Остаток ",125,null,null,null,null,null,"Остаток",125]
[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,null,null,null,"сумма","сумма","итого",null,null,"меняли цвет ,если формула в одной ячейке отличается от формулы другойячейки, либо в ней отсутствует формула"]
["2013-01-01",23,14,{"$f":"SUM(B6:C6)","v":37},null,null,null,"2013-01-01",23,327,{"$f":"SUM(I6:J6)","v":350}]
["2013-01-02",12,null,{"$f":"SUM(B7:C7)","v":12},null,null,null,"2013-01-02",12,null,{"$f":"SUM(I7:J7)","v":12},null,"2.","Ячейка ЛОЖЬ - правильность применения функции и  правила усл. Форматирования"]
["2013-01-03",17,17,34,null,null,null,"2013-01-03",17,17,34]
["2013-01-04",103,1024,1127,null,null,null,"2013-01-04",103,1024,1127,null,"3.","Результат остатка на конец  при ошибках в K13 и K25 тоже менял цвет"]
["2013-01-05",223,null,223,null,null,null,"2013-01-05",223,null,223]
["2013-01-06",745,null,745,null,null,null,"2013-01-06",745,null,745]
["2013-01-07",142,254,396,null,null,null,"2013-01-07",142,254,396]
["Итого",{"$f":"SUM(B6:B12)","v":1265},{"$f":"SUM(C6:C12)","v":1309},{"$f":"IF(SUM(D6:D12)=SUM(B13:C13),SUM(D6:D12))","v":2574},null,null,null,"Итого",{"$f":"SUM(I6:I12)","v":1265},{"$f":"SUM(J6:J11)","v":1368},{"$f":"IF(SUM(K6:K12)=SUM(I13:J13),SUM(K6:K12))","v":false}]
[]
[null,"Расход",null,null,null,null,null,null,"Расход"]
[]
[null,"сумма","сумма",null,null,null,null,null,"сумма","сумма"]
["2013-01-01",17,3,{"$f":"SUM(B18:C18)","v":20},null,null,null,"2013-01-01",17,3,{"$f":"SUM(I18:J18)","v":20}]
["2013-01-02",105,null,{"$f":"SUM(B19:C19)","v":105},null,null,null,"2013-01-02",105,null,{"$f":"SUM(I16:J19)","v":125}]
["2013-01-03",null,25,25,null,null,null,"2013-01-03",null,25,{"$f":"SUM(I20:J20)","v":25}]
["2013-01-04",97,null,97,null,null,null,"2013-01-04",97,null,97]
["2013-01-05",null,null,0,null,null,null,"2013-01-05",null,null,0]
["2013-01-06",null,8,8,null,null,null,"2013-01-06",null,8,8]
["2013-01-07",null,400,400,null,null,null,"2013-01-07",null,400,400]
["Итого",{"$f":"SUM(B18:B24)","v":219},{"$f":"SUM(C18:C24)","v":436},{"$f":"IF(SUM(D18:D24)=SUM(B25:C25),SUM(D18:D24))","v":655},null,null,null,"Итого",{"$f":"SUM(I18:I24)","v":219},{"$f":"SUM(J18:J24)","v":436},{"$f":"IF(SUM(K18:K24)=SUM(I25:J25),SUM(K18:K24))","v":false}]
[]
["Остаток",{"$f":"B1+D13-D25","v":2044},null,null,null,null,null,"Остаток",{"$f":"I1+K13-K25","v":125}]
[null,null,null,null,null,null,null,"на конец"]
["Пример правильной таблицы",null,null,null,null,null,null,"Пример с ошибками "]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}