{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":9,"n_cols":32,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,6,8,7],[8,8,8,9],[8,10,8,11],[8,12,8,15],[8,17,8,25],[6,6,6,7],[6,8,6,9],[6,10,6,11],[6,12,6,15],[6,17,6,25],[7,6,7,7],[7,8,7,9],[7,10,7,11],[7,12,7,15],[7,17,7,25],[4,6,4,7],[4,8,4,9],[4,10,4,11],[4,12,4,15],[4,17,4,25],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,15],[5,17,5,25],[2,6,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,15],[2,17,2,25],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,15],[3,17,3,25],[0,6,0,7],[0,8,0,9],[0,10,0,11],[0,12,0,15],[0,17,0,25],[1,6,1,7],[1,8,1,9],[1,10,1,11],[1,12,1,15],[1,17,1,25]]}
["Рейс №",null,"Дата","начало","оконч",null,"Начало операции\n[час:мин]",null,"Оконч. операции\n[час:мин]",null,"Затраты времени\n[час:мин]",null," операция",null,null,null,"Баланс\n[час]","описание"]
[" Рейс4","2017-09-11",null,null,null,{"$f":"IF(E2=\"\",\"\",E2-D2)","v":""},"00:00:00",null,"04:50:00",null,{"$f":"IF(I2=\"\",\"\",IF(G2>I2,I2,I2-G2))","v":"04:50:00"},null,null,null,null,null,{"$f":"IF(K2=\"\",\"\",((ROUND(MINUTE(K2)*10/6/100,2))+HOUR(K2)))","v":4.83}]
[" Рейс5","2017-09-11",null,null,null,"",{"$f":"IF(I2=\"\",\"\",IF(I2=\"Оконч. работ[час:мин]\",\"0:00\",I2))","v":"04:50:00"},null,"10:40:00",null,"05:50:00",null,"xnfyjdnssgn",null,null,null,5.83,"fwzfzretgfzvzxdrv"]
[" Рейс6","2017-09-11",null,null,null,"","10:40:00",null,"11:50:00",null,"01:10:00",null," nvbjdrud",null,null,null,1.17,"gylh jeu6rikvghd45uydshfnf",null,null,null,null,null,null,null,null,null,null,null,null,null,"drjr"]
[" Рейс7","2017-09-11",null,null,null,"","11:50:00",null,"14:50:00",null,"03:00:00",null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"xnfyjdnssgn"]
[" Рейс8","2017-09-11",null,null,null,"","14:50:00",null,"16:00:00",null,"01:10:00",null,null,null,null,null,1.17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"xcghtdejstdyjxfh"]
[" Рейс9","2017-09-11",null,null,null,"","16:00:00",null,"18:45:00",null,"02:45:00",null,null,null,null,null,2.75,null,null,null,null,null,null,null,null,null,null,null,null,null,null," nvbjdrud"]
[" Рейс5","2017-09-11",null,null,null,"","18:45:00",null,1,null,"05:15:00",null,null,null,null,null,5.25]
[" Рейс5","2017-09-12",null,null,null,"",1,null,"02:20:00",null,"02:20:00",null,null,null,null,null,2.33]

{"sheet":"Лист2","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Сентябрь"]
["2017-09-11"]
["04:50:00"]
["10:40:00","xnfyjdnssgn","fwzfzretgfzvzxdrv"]
["11:50:00"," nvbjdrud","gylh jeu6rikvghd45uydshfnf"]
["14:50:00"]
["16:00:00"]
["18:45:00"]
[1]

{"sheet":"Лист3","index":2,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Январь","Февраль","Март","Апрель","Май","Июнь","Июль","Август","Сентябрь","Октябрь","Ноябрь","Декабрь"]
["2017-01-01","2017-02-01","2017-03-01","2017-04-01","2017-05-01","2017-06-01","2017-07-01","2017-08-01","2017-09-01","2017-10-01","2017-11-01","2017-12-01"]
["2017-01-02","2017-02-02","2017-03-02","2017-04-02","2017-05-02","2017-06-02","2017-07-02","2017-08-02","2017-09-02","2017-10-02","2017-11-02","2017-12-02"]
["2017-01-03","2017-02-03","2017-03-03","2017-04-03","2017-05-03","2017-06-03","2017-07-03","2017-08-03","2017-09-03","2017-10-03","2017-11-03","2017-12-03"]
["2017-01-04","2017-02-04","2017-03-04","2017-04-04","2017-05-04","2017-06-04","2017-07-04","2017-08-04","2017-09-04","2017-10-04","2017-11-04","2017-12-04"]
["2017-01-05","2017-02-05","2017-03-05","2017-04-05","2017-05-05","2017-06-05","2017-07-05","2017-08-05","2017-09-05","2017-10-05","2017-11-05","2017-12-05"]
["2017-01-06","2017-02-06","2017-03-06","2017-04-06","2017-05-06","2017-06-06","2017-07-06","2017-08-06","2017-09-06","2017-10-06","2017-11-06","2017-12-06"]
["2017-01-07","2017-02-07","2017-03-07","2017-04-07","2017-05-07","2017-06-07","2017-07-07","2017-08-07","2017-09-07","2017-10-07","2017-11-07","2017-12-07"]
["2017-01-08","2017-02-08","2017-03-08","2017-04-08","2017-05-08","2017-06-08","2017-07-08","2017-08-08","2017-09-08","2017-10-08","2017-11-08","2017-12-08"]
["2017-01-09","2017-02-09","2017-03-09","2017-04-09","2017-05-09","2017-06-09","2017-07-09","2017-08-09","2017-09-09","2017-10-09","2017-11-09","2017-12-09"]
["2017-01-10","2017-02-10","2017-03-10","2017-04-10","2017-05-10","2017-06-10","2017-07-10","2017-08-10","2017-09-10","2017-10-10","2017-11-10","2017-12-10"]
["2017-01-11","2017-02-11","2017-03-11","2017-04-11","2017-05-11","2017-06-11","2017-07-11","2017-08-11","2017-09-11","2017-10-11","2017-11-11","2017-12-11"]
["2017-01-12","2017-02-12","2017-03-12","2017-04-12","2017-05-12","2017-06-12","2017-07-12","2017-08-12","2017-09-12","2017-10-12","2017-11-12","2017-12-12",null,null,null,{"$f":"MATCH(Лист2!$A$1,Лист3!$A$1:$L$1,0)","v":9}]
["2017-01-13","2017-02-13","2017-03-13","2017-04-13","2017-05-13","2017-06-13","2017-07-13","2017-08-13","2017-09-13","2017-10-13","2017-11-13","2017-12-13"]
["2017-01-14","2017-02-14","2017-03-14","2017-04-14","2017-05-14","2017-06-14","2017-07-14","2017-08-14","2017-09-14","2017-10-14","2017-11-14","2017-12-14"]
["2017-01-15","2017-02-15","2017-03-15","2017-04-15","2017-05-15","2017-06-15","2017-07-15","2017-08-15","2017-09-15","2017-10-15","2017-11-15","2017-12-15"]
["2017-01-16","2017-02-16","2017-03-16","2017-04-16","2017-05-16","2017-06-16","2017-07-16","2017-08-16","2017-09-16","2017-10-16","2017-11-16","2017-12-16"]
["2017-01-17","2017-02-17","2017-03-17","2017-04-17","2017-05-17","2017-06-17","2017-07-17","2017-08-17","2017-09-17","2017-10-17","2017-11-17","2017-12-17",null,null,null,{"$f":"OFFSET($A$2,,MATCH(Лист2!$A$1,Лист3!$A$1:$L$1,0)-1,31,)","v":42995}]
["2017-01-18","2017-02-18","2017-03-18","2017-04-18","2017-05-18","2017-06-18","2017-07-18","2017-08-18","2017-09-18","2017-10-18","2017-11-18","2017-12-18"]
["2017-01-19","2017-02-19","2017-03-19","2017-04-19","2017-05-19","2017-06-19","2017-07-19","2017-08-19","2017-09-19","2017-10-19","2017-11-19","2017-12-19"]
["2017-01-20","2017-02-20","2017-03-20","2017-04-20","2017-05-20","2017-06-20","2017-07-20","2017-08-20","2017-09-20","2017-10-20","2017-11-20","2017-12-20"]
["2017-01-21","2017-02-21","2017-03-21","2017-04-21","2017-05-21","2017-06-21","2017-07-21","2017-08-21","2017-09-21","2017-10-21","2017-11-21","2017-12-21"]
["2017-01-22","2017-02-22","2017-03-22","2017-04-22","2017-05-22","2017-06-22","2017-07-22","2017-08-22","2017-09-22","2017-10-22","2017-11-22","2017-12-22"]
["2017-01-23","2017-02-23","2017-03-23","2017-04-23","2017-05-23","2017-06-23","2017-07-23","2017-08-23","2017-09-23","2017-10-23","2017-11-23","2017-12-23"]
["2017-01-24","2017-02-24","2017-03-24","2017-04-24","2017-05-24","2017-06-24","2017-07-24","2017-08-24","2017-09-24","2017-10-24","2017-11-24","2017-12-24"]
["2017-01-25","2017-02-25","2017-03-25","2017-04-25","2017-05-25","2017-06-25","2017-07-25","2017-08-25","2017-09-25","2017-10-25","2017-11-25","2017-12-25"]
["2017-01-26","2017-02-26","2017-03-26","2017-04-26","2017-05-26","2017-06-26","2017-07-26","2017-08-26","2017-09-26","2017-10-26","2017-11-26","2017-12-26"]
["2017-01-27","2017-02-27","2017-03-27","2017-04-27","2017-05-27","2017-06-27","2017-07-27","2017-08-27","2017-09-27","2017-10-27","2017-11-27","2017-12-27"]
["2017-01-28","2017-02-28","2017-03-28","2017-04-28","2017-05-28","2017-06-28","2017-07-28","2017-08-28","2017-09-28","2017-10-28","2017-11-28","2017-12-28"]
["2017-01-29",null,"2017-03-29","2017-04-29","2017-05-29","2017-06-29","2017-07-29","2017-08-29","2017-09-29","2017-10-29","2017-11-29","2017-12-29"]
["2017-01-30",null,"2017-03-30","2017-04-30","2017-05-30","2017-06-30","2017-07-30","2017-08-30","2017-09-30","2017-10-30","2017-11-30","2017-12-30"]
["2017-01-31",null,"2017-03-31",null,"2017-05-31",null,"2017-07-31","2017-08-31",null,"2017-10-31",null,"2017-12-31"]