{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":35,"n_cols":52,"rows_kept":35,"cut":false,"hidden":false,"merged":[[8,3,9,3],[8,8,9,8],[8,1,9,1],[0,40,0,51],[0,28,0,39],[0,16,0,27],[0,12,0,15],[8,10,9,10],[8,28,8,39],[8,40,8,51],[8,11,9,11],[8,12,8,15],[3,4,3,11],[4,6,6,9],[8,2,9,2],[8,16,8,27],[8,9,9,9]]}
[null,"Название задачи","ед.изм","Объем","Продавец","Тип",null,null,"Стоимость ","Стоимость ","Стоимость ","Стоимость ",2020,null,null,null,2021,null,null,null,null,null,null,null,null,null,null,null,2022,null,null,null,null,null,null,null,null,null,null,null,2023]
[null,null,null,null,null,null,"Идикация периода","Дополнительный","предварительная","ост. на 2020 год","на 2021 год ","на 2022-23 год ","2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01","2022-01-01","2022-02-01","2022-03-01","2022-04-01","2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01","2023-01-01","2023-02-01","2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","2023-12-01"]
[]
[null,null,"2020-10-01","2021-12-30","<-- Сюда можно ввести период который необходим, УФ заливает яечейки попавшие указанный  в диапазон с троке 2. при нажатии кнопки \"Опразить период\" - они скроются. - кнопка отмена в верхнем левом углу уберет сокрытие"]
[null,null,null,null,"Заголовки","Заголовки","Задача: 1. Индикация периода, (Если в любой из строк таблицы есть  числовые значения в видимом диапазоне колонок, (после скрытия столбцов в диапазоне (M:AZ)) то в колонке G - указать \"Есть\", Если нет то \"Нет\".   2. Если это возможно, при всех тех же условиях если в диапазоне (I:L) отсутсвует сумма то вместо индикации \"есть\" или \"нет\" присваивать ему в в колонке \"H\" значение \"Заголовок\"."]
[null,null,null,null,"Заголовки","Заголовки"]
[null,null,null,null,"Заголовки","Заголовки"]
[null,null,null,null,"Заголовки","Заголовки"]
[null,"Название задачи","ед.изм","Объем",null,"Исполнитель","Идикация ","Так должно","Стоимость предварительная","Стоимость ост. на 2020 год","Стоимость на 2021 год предварительная ","Стоимость на 2022-23 год ",2020,null,null,null,2021,null,null,null,null,null,null,null,null,null,null,null,2022,null,null,null,null,null,null,null,null,null,null,null,2023]
[null,null,null,null,"Заголовки","Заголовки","периода","получиться в столбце 6  при периоде с 01.10.20 по 30.12.2021",null,null,null,null,"2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01","2022-01-01","2022-02-01","2022-03-01","2022-04-01","2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01","2023-01-01","2023-02-01","2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","2023-12-01"]
[null,"Столбец1","Столбец2","Столбец3","Столбец4","Столбец5","Столбец6","Столбец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,null,null,null,null,null,null,"Столбец48","Столбец49"]
[null,"Заголовок",null,null,null,null,{"$f":"IF(SUBTOTAL(2,M12:AZ12),\"Есть\",\"Нет\")","v":"Нет"},"Заголовок"]
[null,"Наименование Товара 1",null,null,null,"Ромашка","Есть","Есть",{"$f":"SUM(M13:AZ13)","v":2176},{"$f":"SUM(N13:P13)","v":2176},{"$f":"SUM(Q13:AB13)","v":0},{"$f":"SUM(AC13:AZ13)","v":0},null,1218,958,0,0,0,0,0]
[null,"Наименование Товара 2",null,null,null,"Тюльпан","Есть","Есть",{"$f":"SUM(M14:AZ14)","v":880},{"$f":"SUM(N14:P14)","v":880},{"$f":"SUM(Q14:AB14)","v":0},{"$f":"SUM(AC14:AZ14)","v":0},null,880]
[null,"Наименование Товара 3",null,null,null,"Тюльпан","Есть","Есть",6400,6400,0,0,null,4400,2000]
[null,"Наименование Товара 4",null,null,null,"Тюльпан","Есть","Есть",1500,1500,0,0,null,500,500,500,0,0,0,0]
[null,"Наименование Товара 5",null,null,null,"Тюльпан","Есть","Есть",45640,6520,39120,0,null,null,3260,3260,3260,3260,3260,3260,3260,3260,3260,3260,3260,3260,3260,3260]
[null,"Наименование Товара 6",null,null,null,"Тюльпан","Есть","Есть",160,160,0,0,null,160]
[null,"Наименование Товара 7",null,null,null,"Ромашка","Есть","Есть",3058,3058,0,0,null,2914,144]
[null,null,null,"Заголовки",null,null,"Нет","Заголовок",{"$f":"SUM(M20:O20)","v":0},{"$f":"SUM(P20:AA20)","v":0},{"$f":"SUM(Лист1!$AC20:$AZ20)","v":0}]
[null,"Наименование Товара 9",null,null,null,"Тюльпан","Есть","Есть",2400,0,1400,1000,null,null,null,null,null,null,null,null,null,200,200,200,200,200,200,200,200,200,200,200,200]
[null,"Наименование Товара 10",null,null,null,"Тюльпан","Есть","Есть",800,800,0,0,null,null,800]
[null,"Наименование Товара 11",null,null,null,"Тюльпан","Есть","Есть",9500,1000,6000,2500,null,null,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500]
[null,"Наименование Товара 12",null,null,null,"Тюльпан",{"$f":"IF(SUBTOTAL(2,M24:AZ24),\"Есть\",\"Нет\")","v":"Нет"},"Нет",0,0,0,0]
[null,"Наименование Товара 13",null,null,null,"Тюльпан","Есть","Нет",300,0,0,300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,100,100]
[null,"Наименование Товара 14",null,null,null,"Тюльпан","Есть","Нет",600,0,0,600,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,200,200]
[null,"Наименование Товара 15",null,null,null,"Тюльпан","Есть","Нет",900,0,0,900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,300,300]
[null,"Наименование Товара 16",null,null,null,"Тюльпан","Есть","Нет",2000,0,0,2000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400,400,400,400,400]
[null,"Наименование Товара 17",null,null,null,"Тюльпан","Есть","Нет",5500,0,0,5500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,500,500,500,500,500,500,500,500,500,500]
[null,"Наименование Товара 18",null,null,null,"Тюльпан","Есть","Нет",9800,0,0,9800,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,700,700,700,700,700,700,700,700,700,700,700,700,700,700]
[null,null,null,null,"Заголовки",null,"Нет","Заголовок",{"$f":"SUM(M31:AZ31)","v":0},{"$f":"SUM(N31:P31)","v":0},{"$f":"SUM(Q31:AB31)","v":0},{"$f":"SUM(Лист1!$AC31:$AZ31)","v":0}]
[null,"ИТОГО",null,null,"Заголовки","Заголовки","Нет",null,{"$f":"_xlfn.AGGREGATE(9,5,I12:I30)","v":91614},{"$f":"_xlfn.AGGREGATE(9,5,J12:J30)","v":22494},46520,22600,0,10072,8162,4260,3760,3760,3760,3760,3760,3960,3960,3960,3960,3960,3960,3960,700,700,800,1000,1300,900,700,400,900,900,1200,1200,1200,1200,1200,1200,1200,1200,1200,700,700,700,700,700]
[null,"ИТОГО Ромашка",null,null,"Заголовки СП","Заголовки СП","Есть",null,{"$f":"I19+I13","v":5234},{"$f":"J19+J13","v":5234},0,0,0,4132,1102,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"ИТОГО Тюльпан",null,null,"Заголовки СРМУ","Заголовки СРМУ","Есть",null,{"$f":"I30+I29+I28+I27+I26+I25+I24+I23+I22+I21+I20+I18+I17+I16+I15+I14","v":86380},{"$f":"J30+J29+J28+J27+J26+J25+J24+J23+J22+J21+J20+J18+J17+J16+J15+J14","v":17260},46520,22600,0,5940,7060,4260,3760,3760,3760,3760,3760,3960,3960,3960,3960,3960,3960,3960,700,700,800,1000,1300,900,700,400,900,900,1200,1200,1200,1200,1200,1200,1200,1200,1200,700,700,700,700,700]
[null,null,null,null,"Заголовки","Заголовки"]