{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["исходный","495","496","484","как должен выглядеть 495"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":47,"n_cols":19,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"№ п/п","Номер ","Фактический ","Фактический","Количество часов","Дата начала","Время постановки ","№ Акта ","Вид","Дата выхода ","Время выхода ","№ Акта ","Кол-во "]
[null,1,"495А",null,null,null,"2018-04-30","22:20:00","прарывраы","ТР","2018-05-01","00:20:00","ыаапрап",2.0000000000582077,null,null,null,null,495]
[null,2,"495А",null,null,null,"2018-05-04","05:25:00","ыпрапр","ТП","2018-05-04","06:45:00","ыапрапр",1.3333333333139308,null,null,null,null,496]
[null,3,"495А",null,null,null,"2018-05-06","00:30:00","ыапрпа","ТЧ","2018-05-06","02:00:00","ыпар",1.5,null,null,null,null,484]
[null,4,"495А",null,null,null,"2018-05-09","02:15:00","аыпраырп","ТП","2018-05-09","04:15:00","ыпарыапр",2.0000000000582077]
[null,5,"495А",null,null,null,"2018-05-12","02:55:00","аыпрпа","ТР","2018-05-12","04:55:00","ыапрп",1.9999999998835847]
[null,6,"495А",null,null,null,"2018-05-15","04:35:00","апырпа","ТР","2018-05-15","06:35:00","ыпрыы",2.0000000000582077]
[null,"Итого по хозяйственному",null,null,null,null,null,null,null,null,null,null,null,1.3333333333139308]
[null,"Итого по обычному",null,2342,2342,256]
[null,1,"495Б",null,null,null,"2018-04-30","22:20:00","прарывраы","ТР","2018-05-01","00:20:00","ыаапрап",2.0000000000582077]
[null,2,"495Б",null,null,null,"2018-05-04","05:25:00","ыпрапр","ТП","2018-05-04","06:45:00","ыапрапр",1.3333333333139308]
[null,3,"495Б",null,null,null,"2018-05-06","00:30:00","ыапрпа","ТЧ","2018-05-06","02:00:00","ыпар",1.5]
[null,4,"495Б",null,null,null,"2018-05-09","02:15:00","аыпраырп","ТП","2018-05-09","04:15:00","ыпарыапр",2.0000000000582077]
[null,5,"495Б",null,null,null,"2018-05-12","02:55:00","аыпрпа","ТР","2018-05-12","04:55:00","ыапрп",1.9999999998835847]
[null,6,"495Б",null,null,null,"2018-05-15","04:35:00","апырпа","ТР","2018-05-15","06:35:00","ыпрыы",2.0000000000582077]
[null,"Итого по хозяйственному",null,null,null,null,null,null,null,null,null,null,null,1.3333333333139308]
[null,"Итого по обычному",null,2342,2342,256]
[null,1,"496А",null,null,null,"2018-04-30","22:20:00","апрпо","ТР","2018-05-01","00:20:00","ваапа",2.0000000000582077]
[null,2,"496А",null,null,null,"2018-05-04","05:25:00","ммавв","ТП","2018-05-04","06:45:00","апров",2.5]
[null,3,"496А",null,null,null,"2018-05-06","00:30:00","вывпи","ТЧ","2018-05-06","02:00:00","апровапр",1.5]
[null,"Итого по хозяйственному"]
[null,"Итого по обычному",null,456,456,150]
[null,1,"496Б",null,null,null,"2018-04-30","22:20:00","апрпо","ТР","2018-05-01","00:20:00","ваапа",2.0000000000582077]
[null,2,"496Б",null,null,null,"2018-05-04","05:25:00","ммавв","ТП","2018-05-04","06:45:00","апров",2.5]
[null,3,"496Б",null,null,null,"2018-05-06","00:30:00","вывпи","ТЧ","2018-05-06","02:00:00","апровапр",1.5]
[null,"Итого по хозяйственному"]
[null,"Итого по обычному",null,456,456,150]
[null,1,484,null,null,null,"2018-04-14","22:20:00","ирррар","ТР","2018-05-01","00:20:00","пароь",2.0000000000582077]
[null,2,484,null,null,null,"2018-05-04","05:25:00","ппппппп","ТР","2018-05-04","06:45:00","рпрпа",2.5]
[null,3,484,null,null,null,"2018-05-06","00:30:00","впарпр","ТЧ","2018-05-06","02:00:00","апро",1.5]
[null,"Итого по хозяйственному"]
[null,"Итого по обычному",null,1200,1200,200]
[]
[null,"Всего",null,{"$f":"SUM(D15:D45)","v":6796},{"$f":"SUM(E15:E45)","v":6796},{"$f":"SUM(F15:F45)","v":1012},null,null,null,null,null,null,null,{"$f":"SUM(N15:N46)","v":42.333333333546761}]

{"sheet":"495","index":1,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"№ п/п","Номер ","Фактический ","Фактический","Количество часов","Дата начала","Время постановки ","№ Акта ","Вид","Дата выхода ","Время выхода ","№ Акта ","Кол-во "]
[null,1,"495А",null,null,null,"2018-04-30","22:20:00","прарывраы","ТР","2018-05-01","00:20:00","ыаапрап",2.0000000000582077]
[null,2,"495А",null,null,null,"2018-05-04","05:25:00","ыпрапр","ТП","2018-05-04","06:45:00","ыапрапр",1.3333333333139308]
[null,3,"495А",null,null,null,"2018-05-06","00:30:00","ыапрпа","ТЧ","2018-05-06","02:00:00","ыпар",1.5]
[null,4,"495А",null,null,null,"2018-05-09","02:15:00","аыпраырп","ТП","2018-05-09","04:15:00","ыпарыапр",2.0000000000582077]
[null,5,"495А",null,null,null,"2018-05-12","02:55:00","аыпрпа","ТР","2018-05-12","04:55:00","ыапрп",1.9999999998835847]
[null,6,"495А",null,null,null,"2018-05-15","04:35:00","апырпа","ТР","2018-05-15","06:35:00","ыпрыы",2.0000000000582077]
[null,1,"495Б",null,null,null,"2018-04-30","22:20:00","прарывраы","ТР","2018-05-01","00:20:00","ыаапрап",2.0000000000582077]
[null,2,"495Б",null,null,null,"2018-05-04","05:25:00","ыпрапр","ТП","2018-05-04","06:45:00","ыапрапр",1.3333333333139308]
[null,3,"495Б",null,null,null,"2018-05-06","00:30:00","ыапрпа","ТЧ","2018-05-06","02:00:00","ыпар",1.5]
[null,4,"495Б",null,null,null,"2018-05-09","02:15:00","аыпраырп","ТП","2018-05-09","04:15:00","ыпарыапр",2.0000000000582077]
[null,5,"495Б",null,null,null,"2018-05-12","02:55:00","аыпрпа","ТР","2018-05-12","04:55:00","ыапрп",1.9999999998835847]
[null,6,"495Б",null,null,null,"2018-05-15","04:35:00","апырпа","ТР","2018-05-15","06:35:00","ыпрыы",2.0000000000582077]
[null,"Всего",null,4684,4684,512,null,null,null,null,null,null,null,24.333333333372138]

{"sheet":"496","index":2,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"№ п/п","Номер ","Фактический ","Фактический","Количество часов","Дата начала","Время постановки ","№ Акта ","Вид","Дата выхода ","Время выхода ","№ Акта ","Кол-во "]
[null,1,"496А",null,null,null,"2018-04-30","22:20:00","апрпо","ТР","2018-05-01","00:20:00","ваапа",2.0000000000582077]
[null,2,"496А",null,null,null,"2018-05-04","05:25:00","ммавв","ТП","2018-05-04","06:45:00","апров",2.5]
[null,3,"496А",null,null,null,"2018-05-06","00:30:00","вывпи","ТЧ","2018-05-06","02:00:00","апровапр",1.5]
[null,1,"496Б",null,null,null,"2018-04-30","22:20:00","апрпо","ТР","2018-05-01","00:20:00","ваапа",2.0000000000582077]
[null,2,"496Б",null,null,null,"2018-05-04","05:25:00","ммавв","ТП","2018-05-04","06:45:00","апров",2.5]
[null,3,"496Б",null,null,null,"2018-05-06","00:30:00","вывпи","ТЧ","2018-05-06","02:00:00","апровапр",1.5]
[null,"Всего",null,912,912,300,null,null,null,null,null,null,null,12.000000000116415]

{"sheet":"484","index":3,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"№ п/п","Номер ","Фактический ","Фактический","Количество часов","Дата начала","Время постановки ","№ Акта ","Вид","Дата выхода ","Время выхода ","№ Акта ","Кол-во "]
[null,1,484,null,null,null,"2018-04-14","22:20:00","ирррар","ТР","2018-05-01","00:20:00","пароь",2.0000000000582077]
[null,2,484,null,null,null,"2018-05-04","05:25:00","ппппппп","ТР","2018-05-04","06:45:00","рпрпа",2.5]
[null,3,484,null,null,null,"2018-05-06","00:30:00","впарпр","ТЧ","2018-05-06","02:00:00","апро",1.5]
[null,"Всего",null,1200,1200,200,null,null,null,null,null,null,null,6.0000000000582077]

{"sheet":"как должен выглядеть 495","index":4,"n_rows":44,"n_cols":15,"rows_kept":44,"cut":false,"hidden":false,"merged":[[40,10,40,11],[41,10,41,11],[42,10,42,11],[43,3,43,4],[43,9,43,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"№ п/п","Номер ","Фактический ","Фактический","Количество часов","Дата начала","Время постановки ","№ Акта ","Вид","Дата выхода ","Время выхода ","№ Акта ","Кол-во ","Кол-во( суммарно)"]
[null,1,"495А",null,null,null,"2018-04-30","22:20:00","прарывраы","ТР","2018-05-01","00:20:00","ыаапрап",2.0000000000582077]
[null,2,"495А",null,null,null,"2018-05-04","05:25:00","ыпрапр","ТП","2018-05-04","06:45:00","ыапрапр",1.3333333333139308]
[null,3,"495А",null,null,null,"2018-05-06","00:30:00","ыапрпа","ТЧ","2018-05-06","02:00:00","ыпар",1.5]
[null,4,"495А",null,null,null,"2018-05-09","02:15:00","аыпраырп","ТП","2018-05-09","04:15:00","ыпарыапр",2.0000000000582077]
[null,5,"495А",null,null,null,"2018-05-12","02:55:00","аыпрпа","ТР","2018-05-12","04:55:00","ыапрп",1.9999999998835847]
[null,6,"495А",null,null,null,"2018-05-15","04:35:00","апырпа","ТР","2018-05-15","06:35:00","ыпрыы",2.0000000000582077]
[null,7,"495Б",null,null,null,"2018-04-30","22:20:00","прарывраы","ТР","2018-05-01","00:20:00","ыаапрап",2.0000000000582077]
[null,8,"495Б",null,null,null,"2018-05-04","05:25:00","ыпрапр","ТП","2018-05-04","06:45:00","ыапрапр",1.3333333333139308]
[null,9,"495Б",null,null,null,"2018-05-06","00:30:00","ыапрпа","ТЧ","2018-05-06","02:00:00","ыпар",1.5]
[null,10,"495Б",null,null,null,"2018-05-09","02:15:00","аыпраырп","ТП","2018-05-09","04:15:00","ыпарыапр",2.0000000000582077]
[null,11,"495Б",null,null,null,"2018-05-12","02:55:00","аыпрпа","ТР","2018-05-12","04:55:00","ыапрп",1.9999999998835847]
[null,12,"495Б",null,null,null,"2018-05-15","04:35:00","апырпа","ТР","2018-05-15","06:35:00","ыпрыы",2.0000000000582077]
[null,"Итого по обычному",null,4684,4684,512]
[]
[null,"ВСЕГО",null,{"$f":"SUM(D15:D27)","v":4684},{"$f":"SUM(E15:E27)","v":4684},{"$f":"SUM(F15:F27)","v":512},null,null,null,null,null,null,null,null,{"$f":"SUM(O15:O27)","v":0}]
[]
[null,"Пробеги локомотива заполняются только в итоговой строке по этому локомотиву."]
[null,"Количество км.пробега подлежащего оплате составил: ",null,null,null,null,{"$f":"D29","v":4684}]
[]
[null,"Количество часов нахождения в работоспособном состоянии:",null,null,null,null,null,0]
[null,"Количество часов нахождения на Обслуживании:",null,null,null,null,0]
[null,"Количество часов нахождения на Обслуживании непредвиденном :",null,null,null,null,null,0]
[null,"Количество часов нахождения на Обслуживании гарантийном:",null,null,null,null,null,0]
[null,"КТГф составил:",null,0.45600000000000002]
[]
[]
[null,"Исполнитель",null,null,null,"П.П. Иванов",null,null,"Заказчик",null,null,null,"А.А. Сидоров"]
[]
[null,"№ доверенности",null,null,null,null,null,null,"№ доверенности"]
[null,null,null,"м.п.",null,null,null,null,null,"м.п."]