{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ГРАФИК","1-14","15-31"],"not_rendered":{"charts":0,"images":2,"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":24,"n_cols":34,"rows_kept":24,"cut":false,"hidden":false,"merged":[[22,0,22,33],[23,0,23,33],[24,0,24,33]]}
["шаблон"]
["8/6"]
[]
[null,null,null,"2026-02-01","2026-02-02","2026-02-03","2026-02-04","2026-02-05","2026-02-06","2026-02-07","2026-02-08","2026-02-09","2026-02-10","2026-02-11","2026-02-12","2026-02-13","2026-02-14","2026-02-15","2026-02-16","2026-02-17","2026-02-18","2026-02-19","2026-02-20","2026-02-21","2026-02-22","2026-02-23","2026-02-24","2026-02-25","2026-02-26","2026-02-27","2026-02-28","2026-03-01","2026-03-02","2026-03-03"]
[null,null,"Иванов1",null,"16/2","8/6",null,"16/2","8/6",null,null,"16/2","8/6","16/2","8/6","16/2","8/6",null,"16/2","8/6",null,"16/2","8/6",null,null,null,null,"16/2","8/6","16/2","8/6"]
[null,null,"Иванов2",null,null,"16/2","8/6",null,null,"16/2","8/6",null,"16/2","8/6",null,"16/2","8/6",null,null,"16/2","8/6",null,null,"16/2","8/6",null,null,"16/2","8/6"]
[null,null,"Иванов3","16/2","8/6",null,null,null,null,"16/2","8/6",null,null,"16/2","8/6",null,null,null,null,"16/2","8/6",null,null,null,null,null,null,null,null,"16/2","8/6"]
[null,null,"Иванов4",null,null,null,"8",null,null,"12",null,null,"16/2","8/6",null,null,null,null,"12",null,null,null,"16/2","8/6",null,null,null,"16/2","8/6"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Нашёл макрос выборки по цвету,но необходимо подвязаться к фамилии и дате должно получиться (как на листах 1-14 и 15-31)"]
["На них и должна производиться выборка всех цветных ячеек 1-14 и 15-31"]

{"sheet":"1-14","index":1,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,4,5,7]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16/2","с08:00до24:00"]
[null,null,null,null,"с 1-14",null,null,null,null,null,null,null,null,null,null,"8/6","с00:00до08:00"]
[null,null,null,null,"Иванов1","2026-02-06","8/6",{"$f":"VLOOKUP(G7,$P$5:$Q$7,2,0)","v":"с00:00до08:00"},null,null,null,null,null,null,null,"12","с08:00до20:00"]
[null,null,null,null,"Иванов1","2026-02-10","8/6",{"$f":"VLOOKUP(G8,$P$5:$Q$7,2,0)","v":"с00:00до08:00"}]
[null,null,null,null,"Иванов2","2026-02-04","8/6","с00:00до08:00"]
[null,null,null,null,"Иванов2","2026-02-10","16/2","с08:00до24:00"]
[null,null,null,null,"Иванов2","2026-02-11","8/6","с00:00до08:00"]
[null,null,null,null,"Иванов3","2026-02-02","8/6","с00:00до08:00"]
[null,null,null,null,"Иванов3","2026-02-08","8/6","с00:00до08:00"]
[null,null,null,null,"Иванов3","2026-02-12","8/6","с00:00до08:00"]
[null,null,null,null,"Иванов4","2026-02-07","12","с08:00до20:00"]
[null,null,null,null,"Иванов4","2026-02-11","8/6","с00:00до08:00"]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(G30,$P$5:$Q$7,2,0)","v":{"$error":"#N/A"}}]

{"sheet":"15-31","index":2,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,4,5,7]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16/2","с08:00до24:00"]
[null,null,null,null,"с 15-31",null,null,null,null,null,null,null,null,null,null,"8/6","с00:00до08:00"]
[null,null,null,null,"Иванов1","2026-02-20","8/6",{"$f":"VLOOKUP(G7,$P$5:$Q$7,2,0)","v":"с00:00до08:00"},null,null,null,null,null,null,null,"12","с08:00до20:00"]
[null,null,null,null,"Иванов1","2026-02-26","8/6",{"$f":"VLOOKUP(G8,$P$5:$Q$7,2,0)","v":"с00:00до08:00"}]
[null,null,null,null,"Иванов2","2026-02-22","8/6","с00:00до08:00"]
[null,null,null,null,"Иванов3","2026-02-17","16/2","с08:00до24:00"]
[null,null,null,null,"Иванов3","2026-02-18","8/6","с00:00до08:00"]
[null,null,null,null,"Иванов3","2026-02-28","8/6","с00:00до08:00"]
[null,null,null,null,"Иванов4","2026-02-16","12","с08:00до20:00"]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(G29,$P$5:$Q$7,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(G30,$P$5:$Q$7,2,0)","v":{"$error":"#N/A"}}]