{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Лист1","Лист2","Лист3","Лист4"],"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":17,"n_cols":20,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Исходная таблица",1,1,1,1,"Шаг 2",1,1,1,1,"Шаг 3",10,10,10,10,"Шаг 4",10,10,10,10]
[null,2,2,2,2,"изменяются плановые",2,2,2,2,"новая",9,9,9,9,"накладывается на",9,9,9,9]
[null,3,3,3,3,"данные на",3,3,100,3,"таблица плановых",8,8,8,8,"таблицу из Шага 2",8,8,100,8]
[null,4,4,4,4,"фактические",4,4,4,4,"данных",7,7,7,7,null,7,7,7,7]
[null,5,5,5,5,"(ячейки окрашиваются",5,5,5,5,"путем копирования",6,6,6,6,null,6,6,6,6]
[null,6,6,6,6,"в любой цвет)",6,100,6,6,null,5,5,5,5,null,5,100,5,5]
[null,7,7,7,7,null,7,7,7,7,null,4,4,4,4,null,4,4,4,4]
[null,8,8,8,8,null,8,8,8,8,null,3,3,3,3,null,3,3,3,3]
[null,9,9,9,9,null,9,9,9,9,null,2,2,2,2,null,2,2,2,2]
[null,10,10,10,10,null,10,10,10,10,null,1,1,1,1,null,1,1,1,1]
[]
[null,"Плановые данные",null,null,null,null,"Произведена замена",null,null,null,null,null,null,null,null,null,"Должно получится"]
[null,null,null,null,null,null,"ячейки выделяются цветом"]
[null,null,null,null,null,null,"(вручную)"]
[]
["На листах 2, 3, 4 фрагменты реальной таблицы, и желаемые результаты…"]
["Если закрашиваемые ячейки удасться \"прикрепить\" к ФИО это будет для меня приятным бонусом, т.к нумерация (порядок) сотрудников меняется…"]

{"sheet":"Лист2","index":1,"n_rows":5,"n_cols":43,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["Александров Иван Александрович",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17:00:00",null,"17:00:00",null,"17:00:00",null,"17:00:00",null,"17:00:00",null,"17:00:00",null,"Х"]
[null,null,null,null,null,null,null,null,null,null,null,null,"17:00:00",null,"17:00:00",null,"17:00:00",null,"17:00:00",null,"17:00:00",null,"17:00:00",null,"17:00:00",null,"17:00:00",null,"В",null,"17:00:00",null,"17:00:00",null,"17:00:00",null,"17:00:00",null,"17:00:00",null,"17:00:00",null,"Х"]
["Андриенко Денис Викторович",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10:00:00",null,"10:00:00",null,"10:00:00",null,"10:00:00",null,"10:00:00",null,"В",null,"В",null,"10:00:00",null,"10:00:00",null,"10:00:00",null,"10:00:00",null,"10:00:00",null,"В",null,"Х"]
[null,null,null,null,null,null,null,null,null,null,null,null,"В",null,"10:00:00",null,"10:00:00",null,"10:00:00",null,"10:00:00",null,"10:00:00",null,"10:00:00",null,"10:00:00",null,"10:00:00",null,"10:00:00",null,"10:00:00",null,"10:00:00",null,"10:00:00",null,"В",null,"В",null,"Х"]

{"sheet":"Лист3","index":2,"n_rows":5,"n_cols":43,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["Александров Иван Александрович",null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["Андриенко Денис Викторович",null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]

{"sheet":"Лист4","index":3,"n_rows":5,"n_cols":43,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["Александров Иван Александрович",null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["Андриенко Денис Викторович",null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]