{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["исходный","495","496","484","как должен выглядеть 495","Лист1"],"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":14,"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,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,"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":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"№ п/п","Номер ","Фактический ","Фактический","Количество часов","Дата начала","Время постановки ","№ Акта ","Вид","Дата выхода ","Время выхода ","№ Акта ","Кол-во ","Кол-во( суммарно)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Итого"]
[]
[null,"Всего",null,{"$f":"SUM(D15:D30)","v":0},{"$f":"SUM(E15:E30)","v":0},{"$f":"SUM(F15:F30)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(O15:O30)","v":0}]

{"sheet":"496","index":2,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"№ п/п","Номер ","Фактический ","Фактический","Количество часов","Дата начала","Время постановки ","№ Акта ","Вид","Дата выхода ","Время выхода ","№ Акта ","Кол-во "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Итого"]
[]
[null,"Итого часов в обычном",null,{"$f":"SUM(D15:D27)","v":0},{"$f":"SUM(E15:E27)","v":0},{"$f":"SUM(F15:F27)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(N15:N27)","v":0}]

{"sheet":"484","index":3,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"№ п/п","Номер ","Фактический ","Фактический","Количество часов","Дата начала","Время постановки ","№ Акта ","Вид","Дата выхода ","Время выхода ","№ Акта ","Кол-во "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Итого"]
[]
[null,"Итого часов в обычном",null,{"$f":"SUM(D15:D27)","v":0},{"$f":"SUM(E15:E27)","v":0},{"$f":"SUM(F15:F27)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(N15:N27)","v":0}]

{"sheet":"как должен выглядеть 495","index":4,"n_rows":29,"n_cols":15,"rows_kept":29,"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,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}]

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