{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Как время рассчитывается","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,0,2,6],[19,0,19,6],[3,5,3,6],[20,5,20,6],[19,7,19,9]]}
[null,null,null,null,null,null,null,"Падение было"]
[null,null,null,null,null,null,null,"Было повышение"]
["Реальные данные, которые я получил",null,null,null,null,null,null,"что пропущено"]
["Время от","Время  до","v","s","формула Roman777","ф-ции K-SerJC"]
["2017-01-24T23:41:00","2017-01-25T10:49:00",47,8,false]
["2017-01-25T18:56:00","2017-01-25T21:28:00",39,8,{"$f":"IF(D6=D5,TRUE,C5=(D6+C6)-10*(D6-D5))","v":true},{"$f":"sUp(C6)","v":8},{"$f":"vDown(C6)","v":true},{"$f":"IF(D6=F6,\"\",\"!!!\")","v":""},"10:49:00","18:56:00"]
["2017-01-27T10:06:50","2017-01-27T10:06:50",41,9,false,{"$f":"sUp(C7)","v":8},{"$f":"vDown(C7)","v":false},{"$f":"IF(D7=F7,\"\",\"!!!\")","v":"!!!"}]
["2017-01-27T12:34:29","2017-01-27T12:34:29",32,9,true,{"$f":"sUp(C8)","v":9},true,"","10:06:50","12:34:29"]
["2017-01-27T13:53:15","2017-01-28T07:04:42",42,10,false,10,false,""]
["2017-01-28T13:52:26","2017-01-28T13:52:26",32,10,true,10,true,"","07:04:42","13:52:26"]
["2017-01-28T14:40:42","2017-01-29T10:47:18",42,11,false,11,false,""]
["2017-01-29T12:44:48","2017-01-29T12:44:48",31,11,true,11,true,"","10:47:18","12:44:48"]
["2017-01-29T14:58:16","2017-01-29T15:39:34",41,12,false,12,false,""]
["2017-01-29T17:33:55","2017-01-29T21:41:55",51,13,false,13,false,""]
["2017-01-30T19:26:14","2017-01-30T20:24:21",48,14,false,13,true,"!!!"]
["2017-01-31T19:30:26","2017-02-01T07:37:50",54,16,false,{"$f":"sUp(C16)","v":14},false,"!!!"]
["2017-02-01T12:01:48","2017-02-01T12:01:48",38,16,true,16,true,"","07:37:50","12:01:48"]
["2017-02-01T19:15:39","2017-02-01T19:31:54",48,17,false,17,false,""]
[null,null,null,null,null,null,null,"v падает в интервал времени:",{"$f":"MAX(I6:I17)","v":"10:49:00"},{"$f":"MIN(J6:J18)","v":"12:01:48"}]
["Так я их расшифровал в ручную",null,null,null,null,null,null,"Время вычислил тоже вручную:"]
["Время от","Время  до","v","s","формула Roman777","ф-ции K-SerJC"]
["2017-01-24T23:41:00","2017-01-25T10:49:00",47,8]
["2017-01-25T18:56:00","2017-01-25T21:28:00",39,8,{"$f":"IF(D23=D22,TRUE,C22=(D23+C23)-10*(D23-D22))","v":true},{"$f":"sUp(C23)","v":8},{"$f":"vDown(C23)","v":true},null,"10:49:00","18:56:00"]
["?","?",31,8,true,{"$f":"sUp(C24)","v":8},{"$f":"vDown(C24)","v":true},null,"21:28:00","?"]
["2017-01-27T10:06:50","2017-01-27T10:06:50",41,9,false,9,false]
["2017-01-27T12:34:29","2017-01-27T12:34:29",32,9,true,9,true,null,"10:06:50","12:34:29"]
["2017-01-27T13:53:15","2017-01-28T07:04:42",42,10,false,10,false]
["2017-01-28T13:52:26","2017-01-28T13:52:26",32,10,true,10,true,null,"07:04:42","13:52:26"]
["2017-01-28T14:40:42","2017-01-29T10:47:18",42,11,false,11,false]
["2017-01-29T12:44:48","2017-01-29T12:44:48",31,11,true,11,true,null,"10:47:18","12:44:48"]
["2017-01-29T14:58:16","2017-01-29T15:39:34",41,12,false,12,false]
["2017-01-29T17:33:55","2017-01-29T21:41:55",51,13,false,13,false]
["?","?",38,13,true,13,true,null,"21:41:55","?"]
["2017-01-30T19:26:14","2017-01-30T20:24:21",48,14,false,14,false]
["?","?",34,14,true,14,true,null,"20:24:21","?"]
["2017-01-31T19:30:26","2017-02-01T07:37:50",54,16,false,16,false]
["2017-02-01T12:01:48","2017-02-01T12:01:48",38,16,true,16,true,null,"07:37:50","12:01:48"]
["2017-02-01T19:15:39","2017-02-01T19:31:54",48,17,false,17,false]
[null,null,null,null,null,null,null,"v падает в интервал времени:","10:49:00","12:01:48"]

{"sheet":"Как время рассчитывается","index":1,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["2017-01-24T23:41:00","2017-01-25T10:49:00",47,8,false,null,null,null,{"$f":"IF(E1=TRUE,#REF!-INT(#REF!),\"\")","v":""},null,null,"Если было падение v, тогда мы можем выяснить, в какой промежуток времени это произошло."]
["2017-01-25T18:56:00","2017-01-25T21:28:00",39,8,true,8,true,"",{"$f":"IF(E2=TRUE,B1-INT(B1),\"\")","v":"10:49:00"},{"$f":"IF(E2=TRUE,A2-INT(A2),\"\")","v":"18:56:00"}]
["2017-01-27T10:06:50","2017-01-27T10:06:50",41,9,false,8,false,"!!!","",{"$f":"IF(E3=TRUE,A3-INT(A3),\"\")","v":""}]
["2017-01-27T12:34:29","2017-01-27T12:34:29",32,9,true,9,true,"","10:06:50","12:34:29",null,"В данный момент, с 10:06:50 по 12:34:29 было замечено понижение v"]
["2017-01-27T13:53:15","2017-01-28T07:04:42",42,10,false,10,false,"","",""]
["2017-01-28T13:52:26","2017-01-28T13:52:26",32,10,true,10,true,"","07:04:42","13:52:26"]
["2017-01-28T14:40:42","2017-01-29T10:47:18",42,11,false,11,false,"","",""]
["2017-01-29T12:44:48","2017-01-29T12:44:48",31,11,true,11,true,"","10:47:18","12:44:48"]
["2017-01-29T14:58:16","2017-01-29T15:39:34",41,12,false,12,false,"","",""]
["2017-01-29T17:33:55","2017-01-29T21:41:55",51,13,false,13,false,"","",""]
["2017-01-30T19:26:14","2017-01-30T20:24:21",48,14,false,13,true,"!!!","",""]
["2017-01-31T19:30:26","2017-02-01T07:37:50",54,16,false,14,false,"!!!","",""]
["2017-02-01T12:01:48","2017-02-01T12:01:48",38,16,true,16,true,"","07:37:50","12:01:48"]
["2017-02-01T19:15:39","2017-02-01T19:31:54",48,17,false,17,false,"","",""]
[null,null,null,null,null,null,null,"v падает в интервал времени:","10:49:00","12:01:48",null,"После этого, нужно найти минимальный интервал времени, когда было падение v"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Если мы имеем единственный лог(больше пока не замечено изменений v), "]
["2017-01-24T23:41:00","2017-01-25T10:49:00",47,8,false,null,null,null,"10:49:00","23:41:00",null,"тогда это значит, что v поменяется вне этого диапазона, в данном случае - с 10:49 до 23:41"]
[]
[]
["2017-01-24T23:41:00","2017-01-25T10:49:00",47,8,false,null,null,null,null,null,null,"В случае, если есть 2 лога, но не замечено понижение v"]
["2017-01-25T11:49:00","2017-01-25T11:50:00",57,9,false,null,null,null,"11:50:00","23:41:00",null,"Берем самый первый лог и самый последний"]

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