{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["расчет"],"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":34,"n_cols":23,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Имя мерч. группы","Канал сбыта","Имя планограммы","Полка","PLU","Наименование","Стиль выкладки","ТЗ 3 месяца","Запас на полке","Ориентация","Высота шт","Ширина шт","Ширина коробки",false,"true (СТМ)","Общий итог","Ширина ПЛЮ на полке","Свободная ширина","проверить фейс","Можно расширить","Макрос проверить фейс","Макрос расширить"]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","2B0Sh4 - 27131",3501231,"Вино БРОЯН.ВРАНАЦ ст.кр.сух.0.75л",0,115.57,12,0,31,7,16.5,2,null,2,7,7,{"$f":"IF(AND(COUNTIFS($C:$C,$C2,$D:$D,$D2,$N:$N,\">1\",$B:$B,$B2),$O2=1),\"проверить фейс\",\"\")","v":""},{"$f":"IF(AND(S2=\"проверить фейс\",OR(COUNTIFS($B:$B,$B2,$D:$D,$D2,$Q:$Q,\">=\"&$Q2,$C:$C,$C2,$N:$N,\">=2\")>0,SUMIFS($R:$R,$B:$B,$B2,$D:$D,$D2,$C:$C,$C2,$Q:$Q,\"<\"&$Q2)>=$Q2)),\"можно расширить\",\"\")","v":""}]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","2B0Sh4 - 27131",3411541,"Вино ТЕР.ДЕ АЛМАС ТЕМПР.DOC кр.сух 0.75л",0,50.55,6,0,30,7,16,null,1,1,7,0,"проверить фейс","можно расширить",null,"можно расширить"]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","2B0Sh4 - 27131",3430225,"Вино БРОЯН.КАДАРКА ст.кр.п/сл.0.75л",0,56.42,6,0,31,7,17,1,null,1,7,0,"",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","2B0Sh4 - 27131",3691130,"Вино МВ МАЛЬБЕК РЕЗЕРВ кр.сух.0.75л",0,46.98,5,0,29.9,8.1199999999999992,"~X~",null,1,1,8.1199999999999992,0,"проверить фейс",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","2B0Sh4 - 27131",4018759,"Вино СМИТ ВУДХ.РУБИ ПОР.лик.кр.сл.0.75л",0,46.52,5,0,31,8,16.399999999999999,null,1,1,8,0,"проверить фейс",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","2B0Sh4 - 27131",3668090,"Вино СОЛАНО ВЕРДЕХО бел.сух.0.75л",0,99.03,12,0,30.5,7.43,15.7,null,2,2,7.43,0,"",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","2B0Sh4 - 27131",3659409,"Вино СОЛАНО МОНАСТР.ХУМИЛЬЯ кр.сух.0.75л",0,57.61,6,0,30.5,7.43,15.7,null,1,1,7.43,0,"проверить фейс",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","2B0Sh4 - 27131",3448732,"Вино МОНАСТ.ДЕ ЛАС ВИН.КР.кр.сух.0.75л",0,51.26,6,0,30.5,7.5,0,null,1,1,7.5,0,"проверить фейс",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","2B0Sh4 - 27131",4105923,"Вино БАГОЭЙРА белое сухое 0.75л",0,57.15,6,0,31.5,7,15,null,1,1,7,0,"проверить фейс","можно расширить",null,"можно расширить"]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","2B0Sh4 - 27131",3697875,"Вино КОНФИДЕНСИАЛ РЕЗЕРВА кр.сух.0.75л",0,57.13,6,0,32,7,29,null,1,1,7,0,"проверить фейс","можно расширить",null,"можно расширить"]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","2B0Sh4 - 27131",3969427,"Вино ЛИНДЕЗА ГРАНДЕ ЭСК.бел.п/сух.0.75л",0,116.1,12,0,31.6,7.4,15,null,2,2,7.4,0,"",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","2B0Sh4 - 27131",3680933,"Вино МАДША кр.п/сух 0.75л",0,46.94,5,0,29.5,8.0500000000000007,17.3,null,1,1,8.0500000000000007,0,"проверить фейс",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","2B0Sh4 - 27131",2112500,"Вино С.ВАЛЕНТИН кр.сух.0.75л",0,47.17,5,0,29.5,8,19,1,null,1,8,0,"",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","2B0Sh4 - 27131",3680932,"Вино МАДША бел.п/сух.0.75л",0,42.1,5,0,29.5,8.0500000000000007,17.3,null,1,1,8.0500000000000007,0,"проверить фейс","",null,null,{"$f":"IF(AND(T15=\"проверить фейс\",OR(COUNTIFS($B:$B,$B15,$D:$D,$D15,$Q:$Q,\">=\"&$Q15,$C:$C,$C15,$N:$N,\">=2\")>0,SUMIFS($R:$R,$B:$B,$B15,$D:$D,$D15,$C:$C,$C15,$Q:$Q,\"<\"&$Q15)>=$Q15)),\"можно расширить\",\"\")","v":""}]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","1B0Sh1 - 1311",4049118,"Вино КРАС.ЯГОДА РЯБИН.фр.ст.п/сл 0.5л",0,134.16999999999999,16,0,26,7,23,2,null,2,7,7,"",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","1B0Sh1 - 1311",3338479,"Вино ФР.САН.КЛАС.10-12% пл.стол.п/сл 1л",0,100.29,12,0,31,8.3000000000000007,26.5,null,2,2,8.3000000000000007,0,"",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","1B0Sh1 - 1311",4073500,"Вино ВАЛЬДЕР.ТЕМПР.КРИАНЦА кр.сух.1.5л",0,47.09,5,0,36.5,10,"~X~",null,1,1,10,0,"проверить фейс","можно расширить",null,"можно расширить"]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","1B0Sh1 - 1311",3966538,"Вино АСПЕТИ гранатовое фр.кр.п/сл.0.75л",0,65.569999999999993,7,0,30,8,17,null,1,1,8,0,"проверить фейс","можно расширить",null,"можно расширить"]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","1B0Sh1 - 1311",4049975,"Вино КРАС.ЯГОДА КЛЮК.фр.ст.п/сл 0.5л",0,153.07,16,0,26,7,23,2,null,2,7,7,"",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","1B0Sh1 - 1311",3448491,"Вино ФРУКТ.САНГРИЯ.КЛАССИЧ.п/сл11% 1.75л",0,33.75,4,0,31.5,12.4,25.5,null,1,1,12.4,0,"проверить фейс","можно расширить",null,"можно расширить"]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","1B0Sh1 - 1311",4108389,"Вино СТ.БОЦ.ДОЛГ.77,7 фр.ст.п/сл.0.7л",0,170.78,16,0,28.2,6.8,20,2,null,2,6.8,6.8,"",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","1B0Sh1 - 1311",4108285,"Вино СТ.БОЦМ.ДОЛГ.77,7° фр.ст.п/сл.1.5л",0,49.9,5,0,28.8,9.8000000000000007,20,1,null,1,9.8000000000000007,0,"",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","1B0Sh1 - 1311",4074509,"Вино КАБЕРНЕ ВИНОГОР кр.п/сл.0.7л",0,155.01,16,0,32,7,22.8,null,2,2,7,0,"",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","1B0Sh1 - 1311",4113092,"Вино ВИОРИКА CASTELLO DE VINO б.п/сл.1л",0,999999999,6,0,28,9.3000000000000007,"~X~",null,1,1,9.3000000000000007,0,"проверить фейс","можно расширить",null,"можно расширить"]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","1B0Sh1 - 1311",4113091,"Вино КАБЕРНЕ CASTELLO DE VINO кр.п/сл.1л",0,999999999,6,0,28,9.3000000000000007,"~X~",null,1,1,9.3000000000000007,0,"проверить фейс","можно расширить",null,"можно расширить"]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","3B0Sh1 - 1511",4007659,"Вино ТАМАНСКАЯ УСАДЬБА крас.сух.1.0л",0,148.77000000000001,16,0,25,7.5,16.8,null,2,2,7.5,0,"",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","3B0Sh1 - 1511",3429447,"Вино РИСЛИНГ столовое бел.сух.1.0л",0,148.66,18,0,20.5,9,20,null,2,2,9,0,"",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","3B0Sh1 - 1511",3429446,"Вино ВРАНАЦ столовое кр.сух.1.0л",0,75.59,9,0,20.5,9,20,null,1,1,9,0,"",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","3B0Sh1 - 1511",4036443,"Вино САН ВЕЙ ВИШНЯ фр.п/сл.1.0л",0,153.22999999999999,18,0,20,9,20,null,2,2,9,0,"",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","3B0Sh1 - 1511",4072282,"Вино ТАМАНСКАЯ УСАДЬБА бел.п/сл.1.0л",0,174.66,18,0,24,7,16.3,null,2,2,7,0,"",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","3B0Sh1 - 1511",4007658,"Вино ТАМАНСКАЯ УСАДЬБА бел.сух.1.0л",0,149.22,16,0,25,7.5,16.8,null,2,2,7.5,0,"",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","3B0Sh1 - 1511",4072281,"Вино ТАМАНСКАЯ УСАДЬБА кр.п/сл.1.0л",0,150.75,18,0,24,7,16.3,null,2,2,7,0,"",""]
["Вино","Эконом","ДСК АЛЕ Вино_15_New 4,5","3B0Sh1 - 1511",4036444,"Вино САН ВЕЙ СЛИВА фр.п/сл.1.0л",0,170.45,18,0,20,9,20,null,2,2,9,0,"",""]