{"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":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":66,"n_cols":10,"rows_kept":66,"cut":false,"hidden":false,"merged":[[53,0,53,6],[53,7,53,9],[54,5,54,6],[32,0,32,6],[32,7,32,9],[33,5,33,6],[45,0,45,6],[46,5,46,6],[11,7,11,9],[12,5,12,6],[11,0,11,6],[24,0,24,6],[25,5,25,6],[3,0,3,6],[4,5,4,6]]}
[null,null,null,null,null,null,null,"Падение было"]
[null,null,null,null,null,null,null,"Было повышение"]
[null,null,null,null,null,null,null,"что пропущено(значения не попали в лог)"]
["Реальные данные, которые я получил пример 1"]
["Время от","Время  до","v","s","формула Roman777","ф-ции K-SerJC"]
["2017-01-27T09:32:33","2017-01-27T21:40:52",52,19]
["2017-01-28T07:19:22","2017-01-28T21:31:14",53,21,{"$f":"IF(D7=D6,TRUE,C6=(D7+C7)-10*(D7-D6))","v":false},{"$f":"sUp(C7)","v":19},{"$f":"vDown(C7)","v":false},{"$f":"IF(D7=F7,\"\",\"!!!\")","v":"!!!"}]
["2017-01-29T09:27:16","2017-01-29T21:50:04",62,24,{"$f":"IF(D8=D7,TRUE,C7=(D8+C8)-10*(D8-D7))","v":false},{"$f":"sUp(C8)","v":21},{"$f":"vDown(C8)","v":false},{"$f":"IF(D8=F8,\"\",\"!!!\")","v":"!!!"}]
["2017-01-30T19:35:42","2017-01-30T20:34:17",57.999999999999993,26,{"$f":"IF(D9=D8,TRUE,C8=(D9+C9)-10*(D9-D8))","v":false},{"$f":"sUp(C9)","v":24},{"$f":"vDown(C9)","v":true},{"$f":"IF(D9=F9,\"\",\"!!!\")","v":"!!!"}]
["2017-01-31T19:38:23","2017-01-31T20:18:39",62,29,{"$f":"IF(D10=D9,TRUE,C9=(D10+C10)-10*(D10-D9))","v":false},{"$f":"sUp(C10)","v":26},{"$f":"vDown(C10)","v":false},{"$f":"IF(D10=F10,\"\",\"!!!\")","v":"!!!"}]
[null,null,null,null,null,null,null,"v падает в интервал времени:",{"$f":"MAX(I7:I10)","v":"00:00:00"},{"$f":"MIN(J7:J10)","v":"00:00:00"}]
["Так я их расшифровал в ручную",null,null,null,null,null,null,"Время вычислил тоже вручную:"]
["Время от","Время  до","v","s","формула Roman777","ф-ции K-SerJC"]
["2017-01-27T09:32:33","2017-01-27T21:40:52",52,19]
[null,null,{"$f":"C14-D14","v":33},19,{"$f":"IF(D15=D14,TRUE,C14=(D15+C15)-10*(D15-D14))","v":true},{"$f":"sUp(C15)","v":19},{"$f":"vDown(C15)","v":true}]
["2017-01-28T07:19:22","2017-01-28T21:31:14",53,21,{"$f":"IF(D16=D15,TRUE,C15=(D16+C16)-10*(D16-D15))","v":false},{"$f":"sUp(C16)","v":21},{"$f":"vDown(C16)","v":false},null,"21:40:52","07:19:22"]
[null,null,31,21,{"$f":"IF(D17=D16,TRUE,C16=(D17+C17)-10*(D17-D16))","v":true},{"$f":"sUp(C17)","v":21},{"$f":"vDown(C17)","v":true}]
["2017-01-29T09:27:16","2017-01-29T21:50:04",62,24,{"$f":"IF(D18=D17,TRUE,C17=(D18+C18)-10*(D18-D17))","v":false},{"$f":"sUp(C18)","v":24},{"$f":"vDown(C18)","v":false},null,"21:31:14","09:27:16"]
[null,null,38,24,{"$f":"IF(D19=D18,TRUE,C18=(D19+C19)-10*(D19-D18))","v":true},{"$f":"sUp(C19)","v":24},{"$f":"vDown(C19)","v":true}]
["2017-01-30T19:35:42","2017-01-30T20:34:17",57.999999999999993,26,{"$f":"IF(D20=D19,TRUE,C19=(D20+C20)-10*(D20-D19))","v":false},{"$f":"sUp(C20)","v":25},{"$f":"vDown(C20)","v":false},null,"21:50:04","19:35:42"]
[null,null,32,26,{"$f":"IF(D21=D20,TRUE,C20=(D21+C21)-10*(D21-D20))","v":true},{"$f":"sUp(C21)","v":26},{"$f":"vDown(C21)","v":true}]
["2017-01-31T19:38:23","2017-01-31T20:18:39",62,29,{"$f":"IF(D22=D21,TRUE,C21=(D22+C22)-10*(D22-D21))","v":false},{"$f":"sUp(C22)","v":29},{"$f":"vDown(C22)","v":false},null,"20:34:17","19:38:23"]
[null,null,null,null,{"$f":"IF(D23=D22,TRUE,C22=(D23+C23)-10*(D23-D22))","v":false},{"$f":"sUp(C23)","v":29},{"$f":"vDown(C23)","v":true},"v падает в интервал времени:","21:50:04","07:19:22"]
[]
["Реальные данные, которые я получил пример 2"]
["Время от","Время  до","v","s","формула Roman777","ф-ции K-SerJC"]
["2017-01-27T09:46:59","2017-01-27T21:49:31",57.999999999999993,22]
["2017-01-28T06:27:48","2017-01-28T15:03:14",56.000000000000007,24,{"$f":"IF(D28=D27,TRUE,C27=(D28+C28)-10*(D28-D27))","v":false},{"$f":"sUp(C28)","v":22},{"$f":"vDown(C28)","v":true},{"$f":"IF(D28=F28,\"\",\"!!!\")","v":"!!!"}]
["2017-01-28T20:38:03","2017-01-28T21:28:26",66,25,{"$f":"IF(D29=D28,TRUE,C28=(D29+C29)-10*(D29-D28))","v":false},{"$f":"sUp(C29)","v":24},{"$f":"vDown(C29)","v":false},{"$f":"IF(D29=F29,\"\",\"!!!\")","v":"!!!"}]
["2017-01-29T09:20:31","2017-01-29T15:03:56",51,26,false,25,true,{"$f":"IF(D30=F30,\"\",\"!!!\")","v":"!!!"}]
["2017-01-29T17:40:18","2017-01-29T21:47:19",61,27,false,27,false,{"$f":"IF(D31=F31,\"\",\"!!!\")","v":""}]
["2017-01-30T19:32:51","2017-01-30T20:30:58",54,29,false,27,true,"v падает в интервал времени:",{"$f":"MAX(I28:I31)","v":"00:00:00"},{"$f":"MIN(J28:J31)","v":"00:00:00"}]
["Так я их расшифровал в ручную",null,null,null,null,null,null,"Время вычислил тоже вручную:"]
["Время от","Время  до","v","s","формула Roman777","ф-ции K-SerJC"]
["2017-01-27T09:46:59","2017-01-27T21:49:31",57.999999999999993,22]
[null,null,{"$f":"C35-D35","v":35.999999999999993},{"$f":"D35","v":22},{"$f":"IF(D36=D35,TRUE,C35=(D36+C36)-10*(D36-D35))","v":true},{"$f":"sUp(C36)","v":22},{"$f":"vDown(C36)","v":true}]
["2017-01-28T06:27:48","2017-01-28T15:03:14",56.000000000000007,24,false,24,false,null,{"$f":"B35-INT(B35)","v":"21:49:31"},{"$f":"A37-INT(A37)","v":"06:27:48"}]
["2017-01-28T20:38:03","2017-01-28T21:28:26",66,25,{"$f":"IF(D38=D37,TRUE,C37=(D38+C38)-10*(D38-D37))","v":false},{"$f":"sUp(C38)","v":24},{"$f":"vDown(C38)","v":false}]
[null,null,{"$f":"C38-D38","v":41},{"$f":"D38","v":25},{"$f":"IF(D39=D38,TRUE,C38=(D39+C39)-10*(D39-D38))","v":true},{"$f":"sUp(C39)","v":25},{"$f":"vDown(C39)","v":true}]
["2017-01-29T09:20:31","2017-01-29T15:03:56",51,26,false,26,false,null,{"$f":"B38-INT(B38)","v":"21:28:26"},{"$f":"A40-INT(A40)","v":"09:20:31"}]
["2017-01-29T17:40:18","2017-01-29T21:47:19",61,27,false,27,false]
[null,null,{"$f":"C41-D41","v":34},{"$f":"D41","v":27},true,27,true]
["2017-01-30T19:32:51","2017-01-30T20:30:58",54,29,false,29,false,null,{"$f":"B41-INT(B41)","v":"21:47:19"},{"$f":"A43-INT(A43)","v":"19:32:51"}]
[null,null,null,null,null,null,null,"v падает в интервал времени:","21:49:31","06:27:48"]
[]
["Реальные данные, которые я получил пример 3"]
["Время от","Время  до","v","s","формула Roman777","ф-ции K-SerJC"]
["2017-01-27T10:03:42","2017-01-27T17:00:20",52,16]
["2017-01-27T21:12:58","2017-01-28T16:32:46",56.000000000000007,18,{"$f":"IF(D49=D48,TRUE,C48=(D49+C49)-10*(D49-D48))","v":false},{"$f":"sUp(C49)","v":16},{"$f":"vDown(C49)","v":false},{"$f":"IF(D49=F49,\"\",\"!!!\")","v":"!!!"}]
["2017-01-28T21:05:42","2017-01-29T18:07:45",57.999999999999993,20,{"$f":"IF(D50=D49,TRUE,C49=(D50+C50)-10*(D50-D49))","v":false},{"$f":"sUp(C50)","v":18},{"$f":"vDown(C50)","v":false},{"$f":"IF(D50=F50,\"\",\"!!!\")","v":"!!!"}]
["2017-01-29T19:16:26","2017-01-29T21:32:52",57.999999999999993,22,false,20,false,{"$f":"IF(D51=F51,\"\",\"!!!\")","v":"!!!"}]
["2017-01-30T19:16:12","2017-01-30T21:02:48",56.000000000000007,24,false,22,true,{"$f":"IF(D52=F52,\"\",\"!!!\")","v":"!!!"}]
["2017-01-31T20:01:52","2017-02-01T07:29:16",62,27,false,24,false,"v падает в интервал времени:",{"$f":"MAX(I49:I52)","v":"00:00:00"},{"$f":"MIN(J49:J52)","v":"00:00:00"}]
["Так я их расшифровал в ручную",null,null,null,null,null,null,"Время вычислил тоже вручную:"]
["Время от","Время  до","v","s","формула Roman777","ф-ции K-SerJC"]
["2017-01-27T10:03:42","2017-01-27T17:00:20",52,16]
[null,null,{"$f":"C56-D56","v":36},{"$f":"D56","v":16},{"$f":"IF(D57=D56,TRUE,C56=(D57+C57)-10*(D57-D56))","v":true},{"$f":"sUp(C57)","v":16},{"$f":"vDown(C57)","v":true}]
["2017-01-27T21:12:58","2017-01-28T16:32:46",56.000000000000007,18,false,18,false,null,{"$f":"B56-INT(B56)","v":"17:00:20"},{"$f":"A58-INT(A58)","v":"21:12:58"}]
[null,null,{"$f":"C58-D58","v":38.000000000000007},{"$f":"D58","v":18},true,18,true]
["2017-01-28T21:05:42","2017-01-29T18:07:45",57.999999999999993,20,false,19,false,null,{"$f":"B58-INT(B58)","v":"16:32:46"},{"$f":"A60-INT(A60)","v":"21:05:42"}]
["2017-01-29T19:16:26","2017-01-29T21:32:52",57.999999999999993,22,{"$f":"IF(D61=D60,TRUE,C60=(D61+C61)-10*(D61-D60))","v":false},{"$f":"sUp(C61)","v":20},{"$f":"vDown(C61)","v":false}]
[null,null,{"$f":"C61-D61","v":35.999999999999993},{"$f":"D61","v":22},{"$f":"IF(D62=D61,TRUE,C61=(D62+C62)-10*(D62-D61))","v":true},{"$f":"sUp(C62)","v":22},{"$f":"vDown(C62)","v":true}]
["2017-01-30T19:16:12","2017-01-30T21:02:48",56.000000000000007,24,false,24,false,null,{"$f":"B61-INT(B61)","v":"21:32:52"},{"$f":"A63-INT(A63)","v":"19:16:12"}]
[null,null,{"$f":"C63-D63","v":32.000000000000007},{"$f":"D63","v":24},true,24,true]
["2017-01-31T20:01:52","2017-02-01T07:29:16",62,27,false,26,false,null,{"$f":"B63-INT(B63)","v":"21:02:48"},{"$f":"A65-INT(A65)","v":"20:01:52"}]
[null,null,null,null,null,null,null,"v падает в интервал времени:","17:00:20","19:16:12"]

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