{"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":1,"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":27,"n_cols":17,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,3],[15,0,15,3]]}
["Исходные данные",null,null,null,null,null,null,null,null,null,null,null,"Порядок рассчета:"]
["Т1","Т2","V","S",null,null,null,null,null,null,null,null,"Значение V падает раз в сутки на значение S"]
["2017-01-01T12:00:00","2017-01-01T13:00:00",100,10,null,null,null,null,null,null,null,null,"Например сегодня было V=100, S=10. Тогда через сутки будет V=V-S=100-10=90, S=10"]
["2017-01-01T19:00:00","2017-01-01T20:00:00",90,10,{"$f":"C4=(C3-D3+(D4-D3)*10)","v":true},null,null,null,null,null,null,null,"Значение V может повыситься в любое время на кратное 10 значение, и за каждые V=V+10, значение S=S+1(если V=V+30, то значение S=S+3)"]
["2017-01-01T21:00:00","2017-01-02T06:00:00",100,11,{"$f":"C5=(C4-D4+(D5-D4)*10)","v":false}]
["2017-01-02T07:00:00","2017-01-02T17:00:00",89,11,{"$f":"C6=(C5-D5+(D6-D5)*10)","v":true},null,null,null,null,null,null,null,"Вопрос:"]
["2017-01-03T16:00:00","2017-01-03T17:00:00",78,11,true,null,null,null,null,null,null,null,"Как во второй таблице выяснить, понижалось ли значение v?"]
["2017-01-03T18:00:00","2017-01-03T19:00:00",98,13,false]
["2017-01-04T16:00:00","2017-01-05T11:00:00",85,13,true]
["2017-01-05T17:00:00","2017-01-05T19:00:00",72,13,true]
["2017-01-06T16:00:00","2017-01-07T10:00:00",59,13,true]
["2017-01-07T13:00:00","2017-01-07T14:00:00",79,15,false]
["2017-01-07T16:00:00","2017-01-07T21:00:00",64,15,true]
["2017-01-08T22:00:00","2017-01-09T01:00:00",49,15,true]
["2017-01-09T13:00:00","2017-01-09T14:00:00",99,20,false]
[]
["Т1","Т2","V","S"]
["2017-01-01T12:00:00","2017-01-01T13:00:00",100,10]
["2017-01-01T19:00:00","2017-01-01T20:00:00",90,10,true,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D19=D18,TRUE,C18=(D19+C19)-10*(D19-D18))","v":true}]
["2017-01-02T07:00:00","2017-01-02T17:00:00",89,11,false,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D20=D19,TRUE,C19=(D20+C20)-10*(D20-D19))","v":true}]
["2017-01-03T16:00:00","2017-01-03T17:00:00",78,11,true,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D21=D20,TRUE,C20=(D21+C21)-10*(D21-D20))","v":true}]
["2017-01-04T16:00:00","2017-01-05T11:00:00",85,13,false,null,null,null,null,null,null,null,null,null,null,null,true]
["2017-01-05T17:00:00","2017-01-05T19:00:00",72,13,true,null,null,null,null,null,null,null,null,null,null,null,true]
["2017-01-06T16:00:00","2017-01-07T10:00:00",59,13,{"$f":"C24=(C23-D23+(D24-D23)*10)","v":true},null,null,null,null,null,null,null,null,null,null,null,true]
["2017-01-07T16:00:00","2017-01-07T21:00:00",64,15,false,null,null,null,null,null,null,null,null,null,null,null,true]
["2017-01-08T22:00:00","2017-01-09T01:00:00",49,15,true,null,null,null,null,null,null,null,null,null,null,null,true]
["2017-01-09T13:00:00","2017-01-09T14:00:00",99,20,false,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D27=D26,TRUE,C26=(D27+C27)-10*(D27-D26))","v":false}]

{"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":[]}