{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Межсервисная МЭЛ","Отчет за сервис"],"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":"Межсервисная МЭЛ","index":0,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Дата",null,"2016-07-02","2016-07-03","2016-07-04","2016-07-05","2016-07-06","2016-07-07","2016-07-08","2016-07-09"]
[null,null,"сб","вс","пн","вт","ср","чт","пт","сб"]
["Иванов",null,0.85,0.87,0.92,0.82,0.94,0.94,0.84,0.88]
["петров",null,0,0,0,0,0,0,0,1]
["сидоров",null,0.88,0.87,0.8,0.81,0.75,0.76,0.88,0.79]
["кукушкин пилоткин",null,0.89,0.93,0.87,0.89,0.86,0.8,0.89,0.82]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["фио"]
["кукушкин пилоткин"]
["Дата начала"]
["2016-07-02"]
["Дата окончания"]
["2016-07-09"]
["Среднее "]
[{"$f":"IFERROR(SUMPRODUCT((C1:J1>=A29)*(C1:J1<=A31)*(A3:A24=A27)*(C3:J24))/SUMPRODUCT((C1:J1>=A29)*(C1:J1<=A31)*(A3:A24=A27)*(C3:J24>0)),\" \")","v":0.86875000000000002}]

{"sheet":"Отчет за сервис","index":1,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,1,0,10],[3,1,3,11],[4,0,5,0],[6,0,7,0],[8,0,9,0],[10,0,11,0],[12,0,13,0],[14,0,15,0],[16,0,17,0],[18,0,19,0],[20,0,21,0],[22,0,23,0],[24,0,25,0],[26,0,27,0],[28,0,29,0],[40,0,41,0],[42,0,43,0],[44,0,45,0],[30,0,31,0],[32,0,33,0],[34,0,35,0],[36,0,37,0],[38,0,39,0]]}
[null,"Отчет о проведении 1000-часового сервисного обслуживания "]
[]
["Линия","Сервис по плану","Сроки проведения сервиса","Ответственный за проведение","Замена ротационных узлов","Дата начала коммерческого производства после сервиса","Средняя МЭЛ в межсервисный период","МЭЛв послесервисную неделю","% выполнения","Межсервисный период","Коэффициент МЭ","Оплата"]
[null,"сентябрь 2016"]
[1,null,null,null,null,null,null,null,{"$f":"IF(H5-G5,H5-G5,\" \")","v":" "}]
[]
[2,14000,"с 4.08 по 8.08","Новиков В.Н.",null,"2016-08-10",0.88,0.78,{"$f":"IF(H7-G7,H7-G7,\" \")","v":-9.9999999999999978E-2},null,0.5,"ок"]
[null,"5 дн","5 дн"]
["3.1",null,null,null,null,null,null,null,{"$f":"IF(H9-G9,H9-G9,\" \")","v":" "}]
[]
["3.2",null,null,null,null,null,null,null,{"$f":"IF(H11-G11,H11-G11,\" \")","v":" "}]
[]
["4",14000,"с 4.08 по 8.08","Новиков В.Н.",null,"2016-08-10",0.83199999999999996,0.85099999999999998,{"$f":"IF(H13-G13,H13-G13,\" \")","v":1.9000000000000017E-2}]
[null,"5 дн","5 дн"]
["5",null,null,null,null,null,null,null,{"$f":"IF(H15-G15,H15-G15,\" \")","v":" "}]
[]
["6.1",null,null,null,null,null,null,null,{"$f":"IF(H17-G17,H17-G17,\" \")","v":" "}]
[]
["6.2",null,null,null,null,null,null,null,{"$f":"IF(H19-G19,H19-G19,\" \")","v":" "}]
[]
["7",null,null,null,null,null,null,null,{"$f":"IF(H21-G21,H21-G21,\" \")","v":" "}]
[]
["8.1",null,null,null,null,null,null,null,{"$f":"IF(H23-G23,H23-G23,\" \")","v":" "}]
[]
["8.2",null,null,null,null,null,null,null,{"$f":"IF(H25-G25,H25-G25,\" \")","v":" "}]
[]
["8.3",null,null,null,null,null,null,null,{"$f":"IF(H27-G27,H27-G27,\" \")","v":" "}]
[]
["9",null,null,null,null,null,null,null,{"$f":"IF(H29-G29,H29-G29,\" \")","v":" "}]
[]
["10",null,null,null,null,null,null,null,{"$f":"IF(H31-G31,H31-G31,\" \")","v":" "}]
[]
["11.1",null,null,null,null,null,null,null,{"$f":"IF(H33-G33,H33-G33,\" \")","v":" "}]
[]
["11.2",null,null,null,null,null,null,null,{"$f":"IF(H35-G35,H35-G35,\" \")","v":" "}]
[]
["12",null,null,null,null,null,null,null,{"$f":"IF(H37-G37,H37-G37,\" \")","v":" "}]
[]
["14",null,null,null,null,null,null,null,{"$f":"IF(H39-G39,H39-G39,\" \")","v":" "}]
[]
["15",null,null,null,null,null,null,null,{"$f":"IF(H41-G41,H41-G41,\" \")","v":" "}]
[]
["16",null,null,null,null,null,null,null,{"$f":"IF(H43-G43,H43-G43,\" \")","v":" "}]
[]
["17",null,null,null,null,null,null,null,{"$f":"IF(H45-G45,H45-G45,\" \")","v":" "}]