{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ТР","Освещение"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":32,"n_cols":45,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,4,1,5],[3,17,3,20],[3,21,3,23],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,4,5,34]]}
[]
[null,null,null,null,"июнь",null,2017,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,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,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,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,null,null,null,null,null,null,"март",2017]
["№ п/п","  Оборудование","Инв.          номер","Время                                 вып.","Дни месяца",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,null,null,null,"апрель",2018]
[null,null,null,null,{"$f":"DATE($G$2,VLOOKUP($E$2,AR:AS,2,FALSE),1)","v":"2017-06-01"},{"$f":"IF(MONTH($E$7)=MONTH(E7+1),E7+1,\"\")","v":"2017-06-02"},{"$f":"IF(MONTH($E$7)=MONTH(F7+1),F7+1,\"\")","v":"2017-06-03"},"2017-06-04","2017-06-05","2017-06-06","2017-06-07","2017-06-08","2017-06-09","2017-06-10","2017-06-11","2017-06-12","2017-06-13","2017-06-14","2017-06-15","2017-06-16","2017-06-17","2017-06-18","2017-06-19","2017-06-20","2017-06-21","2017-06-22","2017-06-23","2017-06-24","2017-06-25","2017-06-26","2017-06-27","2017-06-28","2017-06-29","2017-06-30","",{"$f":"E2","v":"июнь"},null,"май",2019,null,null,null,null,"месяц","число"]
[null,null,null,null,{"$f":"TEXT(E7,\"ДДД\")","v":"Чт"},{"$f":"TEXT(F7,\"ДДД\")","v":"Пт"},"Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт",""]
[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,null,null,null,null,null,null,null,"июнь",2020,null,null,null,null,"январь",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,null,null,null,null,null,null,null,null,null,null,"июль",2021,null,null,null,null,"февраль",2]
[null,"Лампа 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,null,null,null,null,null,null,null,null,null,"август",2022,null,null,null,null,"март",3]
[1,"ГСП17-400-032У3 (90 шт)",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,null,null,null,null,{"$f":"INDEX(Освещение!$A$1:$P$27,MATCH(ТР!$B12,Освещение!$B$1:$B$27,0),MATCH(ТР!$E$2,Освещение!$A$4:$P$4,0))","v":"2ТО"},null,"сентябрь",2023,null,null,null,null,"апрель",4]
[2,"ЖСП01-400-032У3 (72 шт.)",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,null,null,null,null,"2ТО",null,"октябрь",2024,null,null,null,null,"май",5]
[null,"Лампа 2",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,null,null,null,null,null,null,"ноябрь",2025,null,null,null,null,"июнь",6]
[3,"ЖСП01-250-032У3 (8 шт.)",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,null,null,null,null,"2ТО",null,"декабрь",2026,null,null,null,null,"июль",7]
[null,"Лампа 3",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,null,null,null,null,null,null,null,2027,null,null,null,null,"август",8]
[4,"ФСП17-250-032УХЛ4 (36 шт.)",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,null,null,null,null,"1ТО+1ТР",null,null,2028,null,null,null,null,"сентябрь",9]
[5,"НСП03-60-003У3 (24 шт.)",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,null,null,null,null,"2ТО",null,null,2029,null,null,null,null,"октябрь",10]
[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,null,null,null,null,null,null,null,null,2030,null,null,null,null,"ноябрь",11]
[null,"Лампа 4",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,null,null,null,null,null,null,null,2031,null,null,null,null,"декабрь",12]
[6,"ГСП17-400-032У3  (46 шт.)",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,null,null,null,null,"1ТО+1ТР",null,null,2032]
[null,"Лампа 5",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,null,null,null,null,null,null,null,2033]
[7,"ЖСП01-400-032У3 (36 шт.)",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,null,null,null,null,"2ТО",null,null,2034]
[8,"ЖСП01-250-032У3 (5 шт.)",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,null,null,null,null,"2ТО",null,null,2035]
[null,"Лампа 6",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,null,null,null,null,null,null,null,2036]
[9,"ФСП17-250-032УХЛ4 (18 шт.)",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,null,null,null,null,"2ТО",null,null,2037]
[null,"Лампа 7",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,null,null,null,null,null,null,null,2038]
[10,"НСП03-60-003У3 (16 шт.)",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,null,null,null,null,"2ТР",null,null,2039]
[null,"Лампа 8",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,null,null,null,null,null,null,null,2040]
[11,"ГО04-400-001  (4 шт.)",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,null,null,null,null,"2ТО",null,null,2041]
[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,null,null,null,null,null,null,null,null,null,2042]
[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,null,null,null,null,null,null,null,null,null,2043]

{"sheet":"Освещение","index":1,"n_rows":27,"n_cols":16,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,10,2,12],[2,13,2,15],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,2,6],[2,7,2,9]]}
[]
[]
["№ п/п","  Оборудование","Инв.          номер","Время                                 вып.","1-й квартал",null,null,"2-й квартал ",null,null,"3-й квартал",null,null,"4-й квартал"]
[null,null,null,null,"январь","февраль","март","апрель","май","июнь","июль","август","сентябрь","октябрь","ноябрь","декабрь"]
[]
[null,"Электроосвещение"]
[null,"Верхний свет"]
[null,"Лампа 1"]
[1,"ГСП17-400-032У3 (90 шт)",null,null,"2ТО","2ТО","2ТО","1ТО+1ТР","2ТО","2ТО","2ТО","2ТО","2ТО","1ТО+1ТР","2ТО","2ТО"]
[2,"ЖСП01-400-032У3 (72 шт.)",null,null,"2ТО","2ТО","2ТО","2ТО","1ТО+1ТР","2ТО","2ТО","2ТО","2ТО","2ТО","1ТО+1ТР","2ТО"]
[null,"Лампа 2"]
[3,"ЖСП01-250-032У3 (8 шт.)",null,null,"2ТО","2ТО","2ТО","2ТО","2ТО","1ТО+1ТР","2ТО","2ТО","2ТО","2ТО","2ТО","1ТО+1ТР"]
[null,"Лампа 3"]
[4,"ФСП17-250-032УХЛ4 (36 шт.)",null,null,"1ТО+1ТР","2ТО","2ТО","5ТР","2ТО","2ТО","1ТО+1ТР","2ТО","2ТО","2ТО","2ТО","2ТО"]
[5,"НСП03-60-003У3 (24 шт.)",null,null,"2ТО","1ТО+1ТР","2ТО","2ТО","2ТО","2ТО","2ТО","1ТО+1ТР","2ТО","2ТО","2ТО","2ТО"]
[null,"Верхний свет"]
[null,"Лампа 4"]
[6,"ГСП17-400-032У3  (46 шт.)",null,null,"1ТО+1ТР","2ТО","2ТО","2ТО","2ТО","5ТР","1ТО+1ТР","2ТО","2ТО","2ТО","2ТО","2ТО"]
[null,"Лампа 5"]
[7,"ЖСП01-400-032У3 (36 шт.)",null,null,"2ТО","1ТО+1ТР","2ТО","2ТО","2ТО","2ТО","2ТО","1ТО+1ТР","2ТО","2ТО","2ТО","2ТО"]
[8,"ЖСП01-250-032У3 (5 шт.)",null,null,"2ТО","2ТО","1ТО+1ТР","2ТО","2ТО","2ТО","2ТО","2ТО","1ТО+1ТР","2ТО","2ТО","2ТО"]
[null,"Лампа 6"]
[9,"ФСП17-250-032УХЛ4 (18 шт.)",null,null,"2ТО","2ТО","2ТО","1ТО+1ТР","2ТО","2ТО","2ТО","2ТО","2ТО","1ТО+1ТР","2ТО","2ТО"]
[null,"Лампа 7"]
[10,"НСП03-60-003У3 (16 шт.)",null,null,"2ТР","2ТО","2ТО","2ТО","1ТО+1ТР","2ТО","2ТО","2ТО","2ТО","2ТО","1ТО+1ТР","2ТО"]
[null,"Лампа 8"]
[11,"ГО04-400-001  (4 шт.)",null,null,"2ТО","2ТО","2ТО","2ТО","2ТО","1ТО+1ТР","2ТО","2ТО","2ТО","2ТО","2ТО","1ТО+1ТР"]