{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["График инструктажа","№ программы","Лист1","Лист2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":61,"n_cols":21,"rows_kept":61,"cut":false,"hidden":false,"merged":[[57,11,59,11],[57,12,59,12],[57,13,59,13],[51,19,52,19],[51,20,52,20],[51,7,52,7],[51,8,52,8],[51,14,52,14],[51,15,52,15],[51,16,52,16],[51,12,52,12],[51,13,52,13],[53,0,53,20],[54,0,56,0],[54,1,56,1],[54,2,56,2],[54,7,56,7],[54,8,56,8],[54,9,56,9],[54,10,56,10],[54,11,56,11],[54,12,56,12],[54,13,56,13],[54,18,56,18],[0,0,0,20],[57,18,59,18],[57,19,59,19],[57,20,59,20],[58,14,59,14],[58,15,59,15],[58,16,59,16],[58,17,59,17],[55,14,56,14],[55,15,56,15],[55,16,56,16],[55,17,56,17],[57,0,59,0],[57,1,59,1],[57,2,59,2],[57,7,59,7],[57,8,59,8],[57,9,59,9],[57,10,59,10],[47,0,50,0],[47,1,50,1],[47,2,50,2],[47,7,50,7],[47,8,50,8],[54,19,56,19],[54,20,56,20],[51,0,52,0],[51,1,52,1],[51,2,52,2],[51,17,52,17],[51,18,52,18],[51,9,52,9],[51,10,52,10],[51,11,52,11],[47,20,50,20],[49,14,50,14],[49,15,50,15],[49,16,50,16],[49,17,50,17],[47,14,48,14],[47,15,48,15],[47,16,48,16],[47,17,48,17],[47,18,50,18],[47,19,50,19],[47,9,50,9],[47,10,50,10],[47,11,50,11],[47,12,50,12],[47,13,50,13],[44,11,46,11],[44,12,46,12],[44,18,46,18],[44,19,46,19],[44,20,46,20],[45,14,46,14],[45,15,46,15],[45,16,46,16],[45,17,46,17],[44,13,46,13],[38,20,40,20],[41,0,43,0],[41,1,43,1],[41,2,43,2],[41,7,43,7],[41,8,43,8],[41,9,43,9],[41,10,43,10],[41,11,43,11],[41,12,43,12],[41,13,43,13],[41,18,43,18],[41,19,43,19],[41,20,43,20],[42,14,43,14],[42,15,43,15],[42,16,43,16],[42,17,43,17],[44,0,46,0],[44,1,46,1],[44,2,46,2],[44,7,46,7],[44,8,46,8],[44,9,46,9],[44,10,46,10],[37,0,37,20],[38,0,40,0],[38,1,40,1],[38,2,40,2],[38,7,40,7],[38,8,40,8],[38,9,40,9],[38,10,40,10],[38,11,40,11],[38,12,40,12],[38,13,40,13],[38,14,40,14],[38,15,40,15],[38,16,40,16],[38,17,40,17],[38,18,40,18],[38,19,40,19],[32,19,36,19],[35,14,36,14],[35,15,36,15],[35,16,36,16],[32,10,36,10],[32,11,36,11],[32,12,36,12],[32,14,34,14],[32,15,34,15],[32,0,36,0],[32,1,36,1],[32,2,36,2],[32,7,36,7],[32,8,36,8],[29,10,31,10],[29,11,31,11],[29,12,31,12],[32,16,34,16],[29,19,31,19],[30,14,31,14],[30,15,31,15],[30,16,31,16],[29,0,31,0],[29,1,31,1],[29,2,31,2],[29,7,31,7],[29,8,31,8],[29,9,31,9],[29,13,31,13],[30,17,31,17],[26,19,28,19],[27,14,28,14],[27,15,28,15],[27,16,28,16],[23,14,25,14],[23,15,25,15],[23,16,25,16],[23,17,25,17],[23,18,25,18],[26,0,28,0],[26,1,28,1],[26,2,28,2],[26,7,28,7],[26,8,28,8],[26,9,28,9],[26,10,28,10],[26,11,28,11],[26,12,28,12],[23,13,25,13],[23,0,25,0],[23,1,25,1],[23,2,25,2],[23,7,25,7],[23,8,25,8],[18,18,22,18],[18,19,22,19],[18,20,22,20],[21,14,22,14],[21,15,22,15],[21,16,22,16],[21,17,22,17],[23,19,25,19],[23,20,25,20],[23,9,25,9],[23,10,25,10],[23,11,25,11],[23,12,25,12],[15,19,17,19],[15,20,17,20],[18,0,22,0],[18,1,22,1],[18,2,22,2],[18,7,22,7],[18,8,22,8],[18,9,22,9],[18,10,22,10],[18,11,22,11],[18,12,22,12],[18,13,22,13],[18,14,20,14],[18,15,20,15],[18,16,20,16],[18,17,20,17],[15,14,17,14],[15,15,17,15],[15,16,17,16],[15,17,17,17],[15,18,17,18],[15,9,17,9],[15,10,17,10],[15,11,17,11],[15,12,17,12],[15,13,17,13],[15,0,17,0],[15,1,17,1],[15,2,17,2],[15,7,17,7],[15,8,17,8],[11,14,12,14],[11,15,12,15],[8,15,9,15],[8,16,9,16],[8,17,9,17],[5,0,7,0],[5,2,7,2],[11,16,12,16],[11,17,12,17],[14,0,14,20],[8,18,9,18],[8,19,9,19],[8,20,9,20],[10,0,13,0],[10,1,13,1],[10,2,13,2],[10,7,13,7],[10,8,13,8],[10,9,13,9],[10,10,13,10],[10,11,13,11],[10,12,13,12],[10,13,13,13],[10,18,13,18],[10,19,13,19],[10,20,13,20],[1,0,3,0],[1,1,2,1],[1,2,3,2],[1,3,1,6],[1,7,1,9],[1,10,1,13],[26,20,28,20],[26,18,28,18],[26,13,28,13],[1,14,1,17],[5,7,7,7],[5,8,7,8],[5,9,7,9],[5,10,7,10],[5,11,7,11],[5,12,7,12],[5,13,7,13],[2,10,3,10],[2,11,3,11],[2,12,2,13],[5,14,7,14],[5,15,7,15],[5,16,7,16],[5,17,7,17],[4,0,4,20],[29,20,31,20],[32,20,36,20],[32,17,34,17],[32,13,36,13],[32,9,36,9],[35,17,36,17],[32,18,36,18],[29,18,31,18],[5,18,7,18],[5,19,7,19],[5,20,7,20],[5,1,7,1],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,7,9,7],[8,8,9,8],[8,9,9,9],[8,10,9,10],[8,11,9,11],[8,12,9,12],[8,13,9,13],[8,14,9,14],[1,18,1,20],[2,3,3,3],[2,4,3,4],[2,5,2,6],[2,7,3,7],[2,8,2,9],[2,14,3,14],[2,15,3,15],[2,16,2,17],[2,18,3,18],[2,19,2,20]]}
["Здравствуйте, уважаемые Екселисты!!! Помогите сделать Всплывающую подсказку, в которой будут  отражаться даты, выделенные красным цветом (используем  столбец G J N R U). "]
["№ п/п","Фамилия, Имя, Отчество","Профессия/ должность","Проверка знаний требований ОТ",null,null,null,"Проверка знаний ПТМ",null,null,"Проверка знаний по электробезопасности",null,null,null,"Повторный инструктаж по ОТ",null,null,null,"Повторный инструктаж по ПБ"]
[null,null,null,"Наименование правил,                      № программы","Периодич. проверки, лет","Дата проверки",null,"Периодич. проверки, лет","Дата проверки",null,"Наименование правил,             № программы","Периодич. проверки, лет","Дата проверки",null,"№      программы","Периодич. проверки, мес.","Дата проведения",null,"Периодич. проверки, мес.","Дата проведения"]
[null,{"$f":"TODAY()","v":"2022-09-10"},null,null,null,"Предыдущая","Следующая",null,"Предыдущая","Следующая",null,null,"Предыдущая","Следующая",null,null,"Предыдущая","Следующая",null,"Предыдущая","Следующая"]
["Административно-технический персонал с IV квалификационной группой до 1000 В"]
[1,"Петров Петр Петрович","Начальник участка","УПЦ 143.15; ЕСУОТи ПБ; Первая помощь",1,"2021-09-09",{"$f":"DATE(YEAR(F6)+E6,MONTH(F6),DAY(F6))","v":"2022-09-09"},1,"2021-11-26",{"$f":"DATE(YEAR(I6)+H6,MONTH(I6),DAY(I6))","v":"2022-11-26"},"ЭБ 151.16",1,"2022-05-11",{"$f":"DATE(YEAR(M6)+L6,MONTH(M6),DAY(M6))","v":"2023-05-11"},14,6,"2022-07-15",{"$f":"DATE(YEAR(Q6),MONTH(Q6)+P6,DAY(Q6))","v":"2023-01-15"},6,"2022-07-15",{"$f":"DATE(YEAR(T6),MONTH(T6)+S6,DAY(T6))","v":"2023-01-15"}]
[null,null,null,"Высота 3 гр.",1,"2021-08-20",{"$f":"DATE(YEAR(F7)+E7,MONTH(F7),DAY(F7))","v":"2022-08-20"}]
[null,null,null,"ЧЭК УС",3,"2021-11-15","2024-11-15"]
[2,"Сидоров Сидор Сидорович","Инженер II категории","УПЦ (пр. №2), Первая помощь",3,"2020-09-18","2023-09-18",1,"2021-10-15",{"$f":"DATE(YEAR(I9)+H9,MONTH(I9),DAY(I9))","v":"2022-10-15"},"ЭБ 151.16",1,"2022-06-09",{"$f":"DATE(YEAR(M9)+L9,MONTH(M9),DAY(M9))","v":"2023-06-09"},7,6,"2022-07-15",{"$f":"DATE(YEAR(Q9),MONTH(Q9)+P9,DAY(Q9))","v":"2023-01-15"},6,"2022-07-15",{"$f":"DATE(YEAR(T9),MONTH(T9)+S9,DAY(T9))","v":"2023-01-15"}]
[null,null,null,"3 ИТР",3,"2020-04-30","2023-04-30"]
[3,"Вириоров Сидор Сидорович","Инженер","УПЦ (пр. №2), Первая помощь",3,"2020-04-10","2023-04-10",1,"2022-02-02",{"$f":"DATE(YEAR(I11)+H11,MONTH(I11),DAY(I11))","v":"2023-02-02"},"ЭБ 151.16",1,"2022-06-10",{"$f":"DATE(YEAR(M11)+L11,MONTH(M11),DAY(M11))","v":"2023-06-10"},7,6,"2022-08-15",{"$f":"DATE(YEAR(Q11),MONTH(Q11)+P11,DAY(Q11))","v":"2023-02-15"},6,"2022-08-15",{"$f":"DATE(YEAR(T11),MONTH(T11)+S11,DAY(T11))","v":"2023-02-15"}]
[null,null,null,8,1,"2021-08-18","2022-08-18",null,null,null,null,null,null,null,11,3,"2022-08-15",{"$f":"DATE(YEAR(Q12),MONTH(Q12)+P12,DAY(Q12))","v":"2022-11-15"}]
[null,null,null,"Высота 3 гр.",1,"2021-12-14","2022-12-14"]
[null,null,null,7,1,"2022-02-02","2023-02-02",null,null,null,null,null,null,null,10,3,"2022-08-15",{"$f":"DATE(YEAR(Q14),MONTH(Q14)+P14,DAY(Q14))","v":"2022-11-15"}]
["Оперативный персонал с III квалификационной группой до 1000 В"]
[4,"Иванов","Электромеханик связи","3 ИТР",3,"2022-01-13",{"$f":"DATE(YEAR(F16)+E16,MONTH(F16),DAY(F16))","v":"2025-01-13"},1,"2021-12-15",{"$f":"DATE(YEAR(I16)+H16,MONTH(I16),DAY(I16))","v":"2022-12-15"},"ЭБ 303.2",1,"2022-06-29",{"$f":"DATE(YEAR(M16)+L16,MONTH(M16),DAY(M16))","v":"2023-06-29"},8,6,"2022-04-23",{"$f":"DATE(YEAR(Q16),MONTH(Q16)+P16,DAY(Q16))","v":"2022-10-23"},6,"2022-05-01",{"$f":"DATE(YEAR(T16),MONTH(T16)+S16,DAY(T16))","v":"2022-11-01"}]
[null,null,null,"Высота 2 гр.",1,"2022-07-04",{"$f":"DATE(YEAR(F17)+E17,MONTH(F17),DAY(F17))","v":"2023-07-04"}]
[null,null,null,"Первая помощь",3,"2021-07-02","2024-07-02"]
[5,"Петров ИванПетрович","Электромеханик связи","3 ИТР",3,"2021-10-08",{"$f":"DATE(YEAR(F19)+E19,MONTH(F19),DAY(F19))","v":"2024-10-08"},1,"2021-10-08",{"$f":"DATE(YEAR(I19)+H19,MONTH(I19),DAY(I19))","v":"2022-10-08"},"ЭБ 303.2",1,"2022-06-10",{"$f":"DATE(YEAR(M19)+L19,MONTH(M19),DAY(M19))","v":"2023-06-10"},8,6,"2022-07-15",{"$f":"DATE(YEAR(Q19),MONTH(Q19)+P19,DAY(Q19))","v":"2023-01-15"},6,"2022-07-15",{"$f":"DATE(YEAR(T19),MONTH(T19)+S19,DAY(T19))","v":"2023-01-15"}]
[null,null,null,8,1,"2021-10-08",{"$f":"DATE(YEAR(F20)+E20,MONTH(F20),DAY(F20))","v":"2022-10-08"}]
[null,null,null,"Высота 2 гр.",1,"2021-10-08","2022-10-08"]
[null,null,null,7,1,"2022-01-17","2023-01-17",null,null,null,null,null,null,null,10,3,"2022-08-15","2022-11-15"]
[null,null,null,"Первая помощь",3,"2021-02-05","2024-02-05"]
[6,"Менова  Светлана Васильевна","Электромеханик связи","3 ИТР",3,"2020-02-07",{"$f":"DATE(YEAR(F24)+E24,MONTH(F24),DAY(F24))","v":"2023-02-07"},1,"2022-02-28",{"$f":"DATE(YEAR(I24)+H24,MONTH(I24),DAY(I24))","v":"2023-02-28"},"ЭБ 303.2",1,"2022-06-29",{"$f":"DATE(YEAR(M24)+L24,MONTH(M24),DAY(M24))","v":"2023-06-29"},8,6,"2022-09-01",{"$f":"DATE(YEAR(Q24),MONTH(Q24)+P24,DAY(Q24))","v":"2023-03-01"},6,"2022-05-01","2022-11-01"]
[null,null,null,"УПЦ (пр. №6)",3,"2020-02-14","2023-02-14"]
[null,null,null,"Первая помощь",3,"2021-07-09","2024-07-09"]
[7,"Хмельницкий Богдан Николаевич","Электромеханик связи","3 ИТР",3,"2020-10-13","2023-10-13",1,"2021-10-08","2022-10-08","ЭБ 303.2",1,"2022-06-10","2023-06-10",8,6,"2022-06-11","2022-12-11",6,"2022-07-15","2023-01-15"]
[null,null,null,7,1,"2021-10-22","2022-10-22",null,null,null,null,null,null,null,10,3,"2022-05-15","2022-08-15"]
[null,null,null,"Первая помощь",3,"2021-01-15","2024-01-15"]
[8,"Головина","Электромеханик связи","3 ИТР",3,"2022-03-30","2025-03-30",1,"2021-12-15","2022-12-15","ЭБ 303.2",1,"2022-07-15","2023-07-15",8,6,"2022-07-15","2023-01-15",6,"2022-07-15","2023-01-15"]
[null,null,null,6,1,"2022-01-27","2023-01-27",null,null,null,null,null,null,null,6,3,"2022-07-15","2022-10-15"]
[null,null,null,"Первая помощь",3,"2021-01-15","2024-01-15"]
[9,"Павленко Павел Павлович","Электромеханик связи","№ 3 ИТР",3,"2022-03-14","2025-03-14",1,"2022-02-14",{"$f":"DATE(YEAR(I33)+H33,MONTH(I33),DAY(I33))","v":"2023-02-14"},"ЭБ 303.2",1,"2022-05-11",{"$f":"DATE(YEAR(M33)+L33,MONTH(M33),DAY(M33))","v":"2023-05-11"},8,6,"2022-08-15","2023-02-15",6,"2022-08-15","2023-02-15"]
[null,null,null,7,1,"2022-02-14","2023-02-14"]
[null,null,null,"УПЦ пр. №2",3,"2019-04-12","2022-04-12"]
[null,null,null,"УПЦ пр. №6",3,"2022-02-18","2025-02-18",null,null,null,null,null,null,null,10,3,"2022-08-15",{"$f":"DATE(YEAR(Q36),MONTH(Q36)+P36,DAY(Q36))","v":"2022-11-15"}]
[null,null,null,"Первая помощь",3,"2021-07-02","2024-07-02"]
["Оперативно-ремонтный персонал с III квалификационной группой до 1000 В"]
[10,"Тихонов Андрей Владимирович","Эл.монтер ЛСТСиР 6 р.",2,1,"2022-06-20","2023-06-20",1,"2022-06-20",{"$f":"DATE(YEAR(I39)+H39,MONTH(I39),DAY(I39))","v":"2023-06-20"},"ЭБ 303.2",1,"2022-06-20",{"$f":"DATE(YEAR(M39)+L39,MONTH(M39),DAY(M39))","v":"2023-06-20"},2,3,"2022-06-15","2022-09-15",6,"2022-06-15",{"$f":"DATE(YEAR(T39),MONTH(T39)+S39,DAY(T39))","v":"2022-12-15"}]
[null,null,null,"Высота 2 гр."]
[null,null,null,"Первая помощь",1,"2022-06-24","2023-06-24"]
[11,"ФИО_03","Эл.монтер по обслуж.                ЭУ 6 р.",3,1,"2022-08-13","2023-08-13",1,"2021-12-15",{"$f":"DATE(YEAR(I42)+H42,MONTH(I42),DAY(I42))","v":"2022-12-15"},"ЭБ 303.2",1,"2022-07-15",{"$f":"DATE(YEAR(M42)+L42,MONTH(M42),DAY(M42))","v":"2023-07-15"},3,3,"2022-07-15",{"$f":"DATE(YEAR(Q42),MONTH(Q42)+P42,DAY(Q42))","v":"2022-10-15"},6,"2022-07-15",{"$f":"DATE(YEAR(T42),MONTH(T42)+S42,DAY(T42))","v":"2023-01-15"}]
[null,null,null,7,1,"2022-08-13",{"$f":"DATE(YEAR(F43)+E43,MONTH(F43),DAY(F43))","v":"2023-08-13"},null,null,null,null,null,null,null,10,3,"2022-07-15",{"$f":"DATE(YEAR(Q43),MONTH(Q43)+P43,DAY(Q43))","v":"2022-10-15"}]
[null,null,null,"Первая помощь",1,"2021-12-15",{"$f":"DATE(YEAR(F44)+E44,MONTH(F44),DAY(F44))","v":"2022-12-15"}]
[12,"Конва Светлана Ивановна","Электромонтер СРО 4 р.",1,1,"2021-10-08","2022-10-08",1,"2022-01-15",{"$f":"DATE(YEAR(I45)+H45,MONTH(I45),DAY(I45))","v":"2023-01-15"},"ЭБ 303.2",1,"2022-06-10",{"$f":"DATE(YEAR(M45)+L45,MONTH(M45),DAY(M45))","v":"2023-06-10"},1,3,"2022-06-15","2022-09-15",6,"2022-01-15",{"$f":"DATE(YEAR(T45),MONTH(T45)+S45,DAY(T45))","v":"2022-07-15"}]
[null,null,null,7,1,"2021-10-08","2022-10-08",null,null,null,null,null,null,null,10,3,"2022-06-15","2022-09-15"]
[null,null,null,"Первая помощь",1,"2021-12-15","2022-12-15"]
[13,"ФИО_01","Электромонтер СРО 4 р.",1,1,"2021-11-09","2022-11-09",1,"2021-11-09",{"$f":"DATE(YEAR(I48)+H48,MONTH(I48),DAY(I48))","v":"2022-11-09"},"ЭБ 303.2",1,"2022-06-29",{"$f":"DATE(YEAR(M48)+L48,MONTH(M48),DAY(M48))","v":"2023-06-29"},1,3,"2022-06-15",{"$f":"DATE(YEAR(Q48),MONTH(Q48)+P48,DAY(Q48))","v":"2022-09-15"},6,"2022-06-15",{"$f":"DATE(YEAR(T48),MONTH(T48)+S48,DAY(T48))","v":"2022-12-15"}]
[null,null,null,"Высота 2 гр.",1,"2022-07-04","2023-07-04"]
[null,null,null,4,1,"2022-01-13","2023-01-13",null,null,null,null,null,null,null,4,3,"2022-06-15",{"$f":"DATE(YEAR(Q50),MONTH(Q50)+P50,DAY(Q50))","v":"2022-09-15"}]
[null,null,null,"Первая помощь",1,"2022-02-25","2023-02-25"]
[14,"ФИО_02","Электромонтер СРО 4 р.",1,1,"2021-11-12","2022-11-12",1,"2021-11-12",{"$f":"DATE(YEAR(I52)+H52,MONTH(I52),DAY(I52))","v":"2022-11-12"},"ЭБ 303.2",1,"2022-06-29",{"$f":"DATE(YEAR(M52)+L52,MONTH(M52),DAY(M52))","v":"2023-06-29"},1,3,"2022-07-15","2022-10-15",6,"2022-06-15",{"$f":"DATE(YEAR(T52),MONTH(T52)+S52,DAY(T52))","v":"2022-12-15"}]
[null,null,null,"Первая помощь",1,"2022-02-25","2023-02-25"]
["Электротехнологический персонал с I квалификационной группой до 1000 В"]
[15,"Концова АлисаАндреевна","Телефонист 3 р.",5,1,"2022-06-28","2023-06-28",1,"2022-06-28",{"$f":"DATE(YEAR(I55)+H55,MONTH(I55),DAY(I55))","v":"2023-06-28"},"Инструктаж",1,"2022-06-28",{"$f":"DATE(YEAR(M55)+L55,MONTH(M55),DAY(M55))","v":"2023-06-28"},5,3,"2022-06-15","2022-09-15",6,"2022-06-15",{"$f":"DATE(YEAR(T55),MONTH(T55)+S55,DAY(T55))","v":"2022-12-15"}]
[null,null,null,6,1,"2022-02-21","2023-02-21",null,null,null,null,null,null,null,6,3,"2022-07-15",{"$f":"DATE(YEAR(Q56),MONTH(Q56)+P56,DAY(Q56))","v":"2022-10-15"}]
[null,null,null,"Первая помощь",1,"2022-06-24","2023-06-24"]
[16,"Панова Дарья Станиславовна","Телефонист 3 р.",5,1,"2022-07-28","2023-07-28",1,"2022-07-28",{"$f":"DATE(YEAR(I58)+H58,MONTH(I58),DAY(I58))","v":"2023-07-28"},"Инструктаж",1,"2022-04-15",{"$f":"DATE(YEAR(M58)+L58,MONTH(M58),DAY(M58))","v":"2023-04-15"},5,3,"2022-06-15",{"$f":"DATE(YEAR(Q58),MONTH(Q58)+P58,DAY(Q58))","v":"2022-09-15"},6,"2022-08-01",{"$f":"DATE(YEAR(T58),MONTH(T58)+S58,DAY(T58))","v":"2023-02-01"}]
[null,null,null,6,1,"2022-07-28","2023-07-28",null,null,null,null,null,null,null,6,3,"2022-06-15",{"$f":"DATE(YEAR(Q59),MONTH(Q59)+P59,DAY(Q59))","v":"2022-09-15"}]
[null,null,null,"Первая помощь",1,"2021-12-15","2022-12-15"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21]

{"sheet":"№ программы","index":1,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["№ программы обучения / инструктажа","Наименование программы"]
["№ 1 /1","для электромонтера СРО"]
["№ 2 /2","для электромонтера ЛСТСиР"]
["№ 3 /3","для электромонтера по обслуживанию ЭУ"]
["№ 4 /4","для антенщика - мачтовика"]
["№ 5 /5","для телефониста"]
["№ 6 /6","для уборщика служебных помещений"]
["№  / 7","для инженера участка связи"]
["№  / 8","для электромеханика"]
["№ 1 /9"]
["№ 7 /10","для допущенных к ПТЗЦ \"ОРМАТ\""]
["№ 8 /11","для рабочих люльки"]
["№ 9/12","для стропальщика НЦС"]
["№   /13","для работников подрядных (сторонних) организаций"]
["№  /14","для начальника участка"]

{"sheet":"Лист1","index":2,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["от: Участка связи №5"]
["кому: НЦС"]
[]
["от: Участка связи №5"]
["кому: НЦС"]

{"sheet":"Лист2","index":3,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"[color=black][l]Private Sub Workbook_Open() 'Всплывающая подсказка"]
[null,"Dim sh As Worksheet ', FIO$,"]
[null,"Dim Dat As Date, lrow&, i&, s$"]
[null,"Set sh = ThisWorkbook.Worksheets(\"График инструктажа\")"]
[null,"Dim DateBegin As Date"]
[null,"Dim DateEnd As Date"]
[null,"DateBegin = DateSerial(Year(Date), Month(Date), 1)            'первый день текущего месяца"]
[null,"DateEnd = DateSerial(Year(Date), Month(Date) + 1, 1) - 1      'последний день текущего месяца"]
[null,"'    Dat = Date + 30"]
[null,"        With sh"]
[null,"        lrow = .Cells(.Rows.Count, \"A\").End(xlUp).Row"]
[null,"            For i = 4 To lrow"]
[null,"            If .Cells(i, 2).Value <> \"\" Then"]
[null,"                If .Cells(i, 7).Value >= DateBegin And .Cells(i, 7).Value <= DateEnd Then"]
[null,"                s = s & Chr(10) & .Cells(i, 2).Value & vbTab & vbTab & vbTab & vbTab & .Cells(i, 7).Value"]
[null,"                End If"]
[null,"            End If"]
[null,"            Next i"]
[null,"        End With"]
[null,"    UserForm1.Show 0"]
[null,"    UserForm1.Label1.Caption = s"]
[null,"    UserForm1.ScrollHeight = UserForm1.Label1.Height + 20"]
[null,"    UserForm1.Height = Application.Min(UserForm1.Label1.Height + 40, 500)"]
[null,"    'MsgBox s"]
[null,"End Sub"]