{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Задания","Массив","Лист1"],"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":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,2,0,4]]}
["Отчет 1"]
[]
["Используя массив на листе \"Массив\", сделать отчет"]
["Месяц","(здесь фильтром нужно выбрать месяц)"]
["Ед измерения","(здесь фильтром нужно выбрать ед измерения)"]
["Дивизион","(здесь фильтром нужно выбрать продукцию)"]
[]
["Продукция","План","Факт","% выполнения плана (Факт/План)","План (% от общей суммы)","Факт  (% от общей суммы)"]
[]
[]
[]
[]
[]
[]
["Отчет 2"]
[]
["Нужно построить отчет, используя массив  данных на листе \"Массив\"."]
["Дивизион","(здесь фильтром нужно выбрать дивизион)"]
["Ед измерения","(здесь фильтром нужно выбрать ед измерения)"]
["Продукция","(здесь фильтром нужно выбрать продукцию)"]
[]
[]
[null,"Январь","Февраль","Март"]
["План"]
["Факт"]
["% выполнения плана"]
[]
["Ниже нужно построить помесячный график % выполнения плана, который должен ориентироваться на выбранные в отчете параметры "]

{"sheet":"Массив","index":1,"n_rows":149,"n_cols":14,"rows_kept":149,"cut":false,"hidden":false,"merged":[]}
[null,null,"Январь","Январь","Январь","Январь","Февраль","Февраль","Февраль","Февраль","Март","Март","Март","Март"]
["Дивизион","Продукция","Факт (т)","Факт (тыс шт)","План (т)","План (тыс шт)","Факт (т)","Факт (тыс шт)","План (т)","План (тыс шт)","Факт (т)","Факт (тыс шт)","План (т)","План (тыс шт)"]
["СПБФ_ПРГ","ДП МАЛЫШАМ",51.787970000000001,299.75599999999997,83.204890599999999,455.16956520000002,89.11,488.44,111.1,592.91999999999996,88.361496000000002,519.69299999999998,94.361496000000002,525.69299999999998]
["СПБФ_ПРГ","ДП ФРУТОНЯНЯ без ФНВ",357.68660299999999,1182.673,450.73501290000002,1453.5236339999999,484.64,1450.17,487.19,1538.18,674,2066,718,2055]
["СПБФ_ПРГ","ДП без ФНВ",409.47457300000002,1482.4290000000001,533.93990350000001,1908.693199,573.74,1938.61,598.29999999999995,2131.09,763,2585,800,2568]
["СПБФ_ПРГ","ВОДА",401.98882400000002,280.12200000000001,476.16934429999998,324.38648760000001,406.26,281.64,541.01,380.61,656,399,657,437]
["СПБФ_ПРГ","ДП",490.19859100000002,1548.444,580.6513764,1960.8029979999999,663,2016.27,650.9,2189.2600000000002,889,2687,880,2825]
["СПБФ_ПРГ","БЮВЕТ",12.581988000000001,22.11,9.7951508999999994,10.6238128,7.2,12.77,16.66,19.34,7,9,7,9]
["СПБФ_ПРГ","ЛИПЕЦБЮВЕТ",389.406836,258.012,466.37419340000002,313.76267480000001,399.06,268.86,524.35,361.27,649.03270799999996,390.34699999999998,710.03270799999996,424.34699999999998]
["СПБФ_ПРГ","МАЛЫШАМ",46.580398000000002,264.37200000000001,75.425539499999999,401.1495425,82.78,446,100.78,521.32000000000005,81,468,81,498]
["СПБФ_ПРГ","МАЛЫШАМК",0.1143,0.45,7.6170399999999999E-2,0.30590539999999999,0.05,0.19,0,0,0,0,0,0]
["СПБФ_ПРГ","МАЛЫШАМП",5.0932719999999998,34.933999999999997,7.7031806999999999,53.714117299999998,6.28,42.25,10.32,71.599999999999994,7,52,7,54]
["СПБФ_ПРГ","ФРУТОНЯНЯ",247.24456000000001,817.95299999999997,297.63787170000001,976.81449889999999,307.04000000000002,895.11,318.67,1008.84,463,1382,464,1518]
["СПБФ_ПРГ","ФРУТОНЯНЯВ",80.724018000000001,66.015000000000001,46.711472899999997,52.109799299999999,89.25,77.66,52.6,58.16,126.649404,101.79600000000001,136.649404,99.796000000000006]
["СПБФ_ПРГ","ФРУТОНЯНЯД",8.405856,59.912999999999997,1.1259882000000001,7.9857319999999996,12.31,87.72,1.36,9.66,19.496456999999999,138.99600000000001,19.496456999999999,136.99600000000001]
["СПБФ_ПРГ","ФРУТОНЯНЯК",10.435162999999999,36.634,19.001024999999998,64.574131399999999,12.64,43.34,22.22,75.900000000000006,16.393519000000001,54.768000000000001,17.393519000000001,57.768000000000001]
["СПБФ_ПРГ","ФРУТОНЯНЯМ",2.2795559999999999,21.106999999999999,5.1223261999999998,47.428944899999998,3.47,32.130000000000003,5.8,53.75,3.2611080000000001,30.183,3.2611080000000001,33.183]
["СПБФ_ПРГ","ФРУТОНЯНЯО",3.0057,13.98,2.5592074,11.9032901,3.92,18.22,2.61,12.12,5.2318100000000003,24.334,5.2318100000000003,23.334]
["СПБФ_ПРГ","ФРУТОНЯНЯП",86.315768000000006,233.08600000000001,125.28859439999999,344.81703659999999,133.43,356.4,136.53,377.91,161.601732,428.12200000000001,166.601732,433.12200000000001]
["СПБФ_ПРГ","ФРУТОНЯНЯН",null,null,null,null,11.83,17.25,0,0,4.801768,7,4.801768,7]
["СПБФ_ПРГ","Вода БЮВЕТ 0.500 ПЭТ",10.175844,19.236000000000001,1.4446958999999999,2.7309942,5.28,9.9700000000000006,3.61,6.82,1,3,1,3]
["СПБФ_ПРГ","Вода БЮВЕТ 1.500 ПЭТ",1.3316159999999999,0.85799999999999998,6.3109326000000001,4.0663225000000001,0.66,0.43,9.7200000000000006,6.26,3,2,3,2]
["СПБФ_ПРГ","Вода фруктовая БЮВЕТ 0.500 ПЭТ",1.0745279999999999,2.016,2.0395224000000001,3.8264961,1.27,2.38,3.34,6.26,2,4,2,4]
["СПБФ_ПРГ","Вода ЛБЮВЕТ 0.330 ПЭТ",0.989784,2.7959999999999998,0.7507933,2.1208852,0.51,1.45,2.65,7.48,2,5,2,5]
["СПБФ_ПРГ","Вода ЛБЮВЕТ 0.500 ПЭТ",10.848732,20.507999999999999,14.9423707,28.2464485,17.2,32.51,20.09,37.97,21,39,20,38]
["СПБФ_ПРГ","Вода ЛБЮВЕТ 1.500 ПЭТ",358.48095999999998,230.98,435.10944610000001,280.35401619999999,357.27,230.2,485.17,312.61,498,321,493,317]
["СПБФ_ПРГ","Вода ЛБЮВЕТ 5.000 ПЭТ",19.08736,3.7280000000000002,15.5715833,3.0413249000000002,24.08,4.7,16.45,3.21,129,25,138,24]
["СПБФ_ПРГ","Сок МАЛЫШАМ 0.125 Тетра Пак",20.518242999999998,146.65199999999999,23.270150900000001,166.21536269999999,27.48,196.41,25.53,182.33,38.9998,278.73200000000003,39.9998,287.73200000000003]
["СПБФ_ПРГ","Сок МАЛЫШАМ 0.200 Тетра Пак",26.062155000000001,117.72,52.155388600000002,234.93417980000001,55.3,249.59,75.25,338.99,42,189,43,192]
["СПБФ_ПРГ","Сухие каши МАЛЫШАМК 0.200 Картон",0.1143,0.45,7.6170399999999999E-2,0.30590539999999999,0.05,0.19,0,0,0,0,0,0]
["СПБФ_ПРГ","Пюре МАЛЫШАМП 0.100 Стекло",0.69055200000000005,3.7530000000000001,0.55409649999999999,3.0113937000000002,1.34,7.26,0.98,5.31,1,4,1,4]
["СПБФ_ПРГ","Пюре МАЛЫШАМП 0.125 Тетра Пак",4.4027200000000004,31.181000000000001,7.1490841999999999,50.702723599999999,4.9400000000000004,34.99,9.35,66.290000000000006,7,48,7,48]
["СПБФ_ПРГ","Сок восстановленный ФРУТОНЯНЯ 0.170 Стекло",2.87656,8.77,3.8720379,11.8049932,3.83,11.67,4.63,14.13,5,14,5,15]
["СПБФ_ПРГ","Сок для беременных ФРУТОНЯНЯ 0.500 Тетра Пак",6.0927720000000001,11.154,8.3743523999999994,15.3376416,5.98,10.94,9.14,16.75,6,11,6,12]
["СПБФ_ПРГ","Сок ФРУТОНЯНЯ 0.170 Стекло",6.7759E-2,0.20799999999999999,0,0,0.04,0.11,0,0,1.954E-3,6.0000000000000001E-3,1.954E-3,6.0000000000000001E-3]
["СПБФ_ПРГ","Сок ФРУТОНЯНЯ 0.200 Тетра Пак",130.47868700000001,589.33900000000006,149.184168,672.00074789999996,117.7,531.61,153.13,689.75,191,865,205,887]
["СПБФ_ПРГ","Сок ФРУТОНЯНЯ 0.330 Тетра Пак",13.068841000000001,35.845999999999997,31.057503199999999,85.089047600000001,12.8,35.11,11.29,30.93,15,40,16,40]
["СПБФ_ПРГ","Сок ФРУТОНЯНЯ 0.500 Тетра Пак",94.659941000000003,172.636,105.1498102,192.58206860000001,166.7,305.67,140.47999999999999,257.27999999999997,247,452,270,454]
["СПБФ_ПРГ","Вода ФРУТОНЯНЯВ 0.330 ПЭТ",11.212242,31.672999999999998,10.7930853,30.488941199999999,14.38,40.64,11.93,33.700000000000003,16.818539999999999,47.51,16.818539999999999,51.51]
["СПБФ_ПРГ","Вода ФРУТОНЯНЯВ 1.500 ПЭТ",46.246496,29.797999999999998,32.527801199999999,20.958634199999999,49.89,32.15,36.79,23.7,73,47,73,50]
["СПБФ_ПРГ","Вода ФРУТОНЯНЯВ 5.000 ПЭТ",23.265280000000001,4.5439999999999996,3.3905864000000001,0.66222389999999998,24.98,4.88,3.89,0.76,37,7,37,7]
["СПБФ_ПРГ","Десерт ФРУТОНЯНЯД 0.125 Тетра Пак",8.405856,59.912999999999997,1.1259882000000001,7.9857319999999996,12.31,87.72,1.36,9.66,19,139,20,147]
["СПБФ_ПРГ","Густые каши ФРУТОНЯНЯК 0.250 Стекло",4.2143759999999997,9.6660000000000004,8.9417351000000007,20.5085671,5.68,13.03,10.18,23.34,8,18,8,19]
["СПБФ_ПРГ","Жидкие каши ФРУТОНЯНЯК 0.200 Тетра Пак",4.2389409999999996,19.169,7.5901012999999997,34.344349700000002,4.97,22.46,8.7799999999999994,39.74,6,26,6,28]
["СПБФ_ПРГ","Сухие каши ФРУТОНЯНЯК 0.200 Картон",1.981846,7.7990000000000004,2.4691885999999998,9.7212145999999997,1.99,7.85,3.23,12.72,3,11,3,12]
["СПБФ_ПРГ","Мясо ФРУТОНЯНЯМ 0.095 Мет банка",2.2795559999999999,21.106999999999999,5.1223261999999998,47.428944899999998,3.47,32.130000000000003,5.8,53.75,3,30,3,30]
["СПБФ_ПРГ","Пюре ФРУТОНЯНЯО 0.105 Стекло",3.0057,13.98,2.5592074,11.9032901,3.92,18.22,2.61,12.12,5,24,5,24]
["СПБФ_ПРГ","Пюре ФРУТОНЯНЯП 0.110 Стекло",15.777072,71.3,25.750746599999999,116.5192151,22.6,102.21,29.03,131.35,26,117,25,116]
["СПБФ_ПРГ","Пюре ФРУТОНЯНЯП 0.250 Стекло",70.538696000000002,161.786,99.537847799999994,228.2978215,110.83,254.19,107.5,246.56,136,311,142,302]
["СПБФ_ПРГ","Сухие каши ФРУТОНЯНЯК 0.250 Картон",null,null,null,null,0,0,0.03,0.1,null,null,0,0]
["СПБФ_ПРГ","Промо-наборы ДП",null,null,null,null,11.83,17.25,0,0,5,7,5,7]
["ДО СПБ ПРГ","ДП МАЛЫШАМ",51.787970000000001,299.75599999999997,83.204890599999999,455.16956520000002,89.11,488.44,111.1,592.91999999999996,88,520,96,556]
["ДО СПБ ПРГ","ДП ФРУТОНЯНЯ без ФНВ",357.68660299999999,1182.673,450.73501290000002,1453.5236339999999,484.64,1450.17,487.19,1538.18,674,2066,662,2257]
["ДО СПБ ПРГ","ДП без ФНВ",409.47457300000002,1482.4290000000001,533.93990350000001,1908.693199,573.74,1938.61,598.29999999999995,2131.09,763,2585,781,2761]
["ДО СПБ ПРГ","ВОДА",401.98882400000002,280.12200000000001,476.16934429999998,324.38648760000001,406.26,281.64,541.01,380.61,656,399,685,404]
["ДО СПБ ПРГ","ДП",490.19859100000002,1548.444,580.6513764,1960.8029979999999,663,2016.27,650.9,2189.2600000000002,889,2687,906,2588]
["ДО СПБ ПРГ","БЮВЕТ",12.581988000000001,22.11,9.7951508999999994,10.6238128,7.2,12.77,16.66,19.34,7,9,7,9]
["ДО СПБ ПРГ","ЛИПЕЦБЮВЕТ",389.406836,258.012,466.37419340000002,313.76267480000001,399.06,268.86,524.35,361.27,649.03270799999996,390.34699999999998,709.03270799999996,390.34699999999998]
["ДО СПБ ПРГ","МАЛЫШАМ",46.580398000000002,264.37200000000001,75.425539499999999,401.1495425,82.78,446,100.78,521.32000000000005,80.852391999999995,467.786,77.852391999999995,479.786]
["ДО СПБ ПРГ","МАЛЫШАМК",0.1143,0.45,7.6170399999999999E-2,0.30590539999999999,0.05,0.19,0,0,1.1684E-2,4.5999999999999999E-2,1.1684E-2,4.5999999999999999E-2]
["ДО СПБ ПРГ","МАЛЫШАМП",5.0932719999999998,34.933999999999997,7.7031806999999999,53.714117299999998,6.28,42.25,10.32,71.599999999999994,7.49742,51.860999999999997,7.49742,56.860999999999997]
["ДО СПБ ПРГ","ФРУТОНЯНЯ",247.24456000000001,817.95299999999997,297.63787170000001,976.81449889999999,307.04000000000002,895.11,318.67,1008.84,463.45430399999998,1382.3710000000001,460.45430399999998,1339.3710000000001]
["ДО СПБ ПРГ","ФРУТОНЯНЯВ",80.724018000000001,66.015000000000001,46.711472899999997,52.109799299999999,89.25,77.66,52.6,58.16,126.649404,101.79600000000001,138.649404,98.796000000000006]
["ДО СПБ ПРГ","ФРУТОНЯНЯД",8.405856,59.912999999999997,1.1259882000000001,7.9857319999999996,12.31,87.72,1.36,9.66,19.496456999999999,138.99600000000001,20.496456999999999,140.99600000000001]
["ДО СПБ ПРГ","ФРУТОНЯНЯК",10.435162999999999,36.634,19.001024999999998,64.574131399999999,12.64,43.34,22.22,75.900000000000006,16,55,17,59]
["ДО СПБ ПРГ","ФРУТОНЯНЯМ",2.2795559999999999,21.106999999999999,5.1223261999999998,47.428944899999998,3.47,32.130000000000003,5.8,53.75,3,30,3,29]
["ДО СПБ ПРГ","ФРУТОНЯНЯО",3.0057,13.98,2.5592074,11.9032901,3.92,18.22,2.61,12.12,5,24,5,26]
["ДО СПБ ПРГ","ФРУТОНЯНЯП",86.315768000000006,233.08600000000001,125.28859439999999,344.81703659999999,133.43,356.4,136.53,377.91,162,428,159,467]
["ДО СПБ ПРГ","ФРУТОНЯНЯН",null,null,null,null,11.83,17.25,0,0,5,7,5,7]
["ДО СПБ ПРГ","Вода БЮВЕТ 0.500 ПЭТ",10.175844,19.236000000000001,1.4446958999999999,2.7309942,5.28,9.9700000000000006,3.61,6.82,1,3,1,3]
["ДО СПБ ПРГ","Вода БЮВЕТ 1.500 ПЭТ",1.3316159999999999,0.85799999999999998,6.3109326000000001,4.0663225000000001,0.66,0.43,9.7200000000000006,6.26,3,2,3,2]
["ДО СПБ ПРГ","Вода фруктовая БЮВЕТ 0.500 ПЭТ",1.0745279999999999,2.016,2.0395224000000001,3.8264961,1.27,2.38,3.34,6.26,2.2258079999999998,4.1760000000000002,2.2258079999999998,4.1760000000000002]
["ДО СПБ ПРГ","Вода ЛБЮВЕТ 0.330 ПЭТ",0.989784,2.7959999999999998,0.7507933,2.1208852,0.51,1.45,2.65,7.48,2,5,2,5]
["ДО СПБ ПРГ","Вода ЛБЮВЕТ 0.500 ПЭТ",10.848732,20.507999999999999,14.9423707,28.2464485,17.2,32.51,20.09,37.97,21,39,23,38]
["ДО СПБ ПРГ","Вода ЛБЮВЕТ 1.500 ПЭТ",358.48095999999998,230.98,435.10944610000001,280.35401619999999,357.27,230.2,485.17,312.61,498,321,478,349]
["ДО СПБ ПРГ","Вода ЛБЮВЕТ 5.000 ПЭТ",19.08736,3.7280000000000002,15.5715833,3.0413249000000002,24.08,4.7,16.45,3.21,129,25,132,24]
["ДО СПБ ПРГ","Сок МАЛЫШАМ 0.125 Тетра Пак",20.518242999999998,146.65199999999999,23.270150900000001,166.21536269999999,27.48,196.41,25.53,182.33,39,279,41,279]
["ДО СПБ ПРГ","Сок МАЛЫШАМ 0.200 Тетра Пак",26.062155000000001,117.72,52.155388600000002,234.93417980000001,55.3,249.59,75.25,338.99,42,189,40,203]
["ДО СПБ ПРГ","Сухие каши МАЛЫШАМК 0.200 Картон",0.1143,0.45,7.6170399999999999E-2,0.30590539999999999,0.05,0.19,0,0,1.1684E-2,4.5999999999999999E-2,1.1684E-2,4.5999999999999999E-2]
["ДО СПБ ПРГ","Пюре МАЛЫШАМП 0.100 Стекло",0.69055200000000005,3.7530000000000001,0.55409649999999999,3.0113937000000002,1.34,7.26,0.98,5.31,1,4,1,4]
["ДО СПБ ПРГ","Пюре МАЛЫШАМП 0.125 Тетра Пак",4.4027200000000004,31.181000000000001,7.1490841999999999,50.702723599999999,4.9400000000000004,34.99,9.35,66.290000000000006,7,48,7,46]
["ДО СПБ ПРГ","Сок восстановленный ФРУТОНЯНЯ 0.170 Стекло",2.87656,8.77,3.8720379,11.8049932,3.83,11.67,4.63,14.13,5,14,5,14]
["ДО СПБ ПРГ","Сок для беременных ФРУТОНЯНЯ 0.500 Тетра Пак",6.0927720000000001,11.154,8.3743523999999994,15.3376416,5.98,10.94,9.14,16.75,5.9931580000000002,10.964,5.9931580000000002,11.964]
["ДО СПБ ПРГ","Сок ФРУТОНЯНЯ 0.170 Стекло",6.7759E-2,0.20799999999999999,0,0,0.04,0.11,0,0,0,0,0,0]
["ДО СПБ ПРГ","Сок ФРУТОНЯНЯ 0.200 Тетра Пак",130.47868700000001,589.33900000000006,149.184168,672.00074789999996,117.7,531.61,153.13,689.75,191,865,208,846]
["ДО СПБ ПРГ","Сок ФРУТОНЯНЯ 0.330 Тетра Пак",13.068841000000001,35.845999999999997,31.057503199999999,85.089047600000001,12.8,35.11,11.29,30.93,15,40,16,41]
["ДО СПБ ПРГ","Сок ФРУТОНЯНЯ 0.500 Тетра Пак",94.659941000000003,172.636,105.1498102,192.58206860000001,166.7,305.67,140.47999999999999,257.27999999999997,247,452,268,463]
["ДО СПБ ПРГ","Вода ФРУТОНЯНЯВ 0.330 ПЭТ",11.212242,31.672999999999998,10.7930853,30.488941199999999,14.38,40.64,11.93,33.700000000000003,16.818539999999999,47.51,17.818539999999999,50.51]
["ДО СПБ ПРГ","Вода ФРУТОНЯНЯВ 1.500 ПЭТ",46.246496,29.797999999999998,32.527801199999999,20.958634199999999,49.89,32.15,36.79,23.7,73.125584000000003,47.116999999999997,80.125584000000003,47.116999999999997]
["ДО СПБ ПРГ","Вода ФРУТОНЯНЯВ 5.000 ПЭТ",23.265280000000001,4.5439999999999996,3.3905864000000001,0.66222389999999998,24.98,4.88,3.89,0.76,36.705280000000002,7.1689999999999996,36.705280000000002,7.1689999999999996]
["ДО СПБ ПРГ","Десерт ФРУТОНЯНЯД 0.125 Тетра Пак",8.405856,59.912999999999997,1.1259882000000001,7.9857319999999996,12.31,87.72,1.36,9.66,19.496456999999999,138.99600000000001,20.496456999999999,143.99600000000001]
["ДО СПБ ПРГ","Густые каши ФРУТОНЯНЯК 0.250 Стекло",4.2143759999999997,9.6660000000000004,8.9417351000000007,20.5085671,5.68,13.03,10.18,23.34,7.9587440000000003,18.254000000000001,7.9587440000000003,18.254000000000001]
["ДО СПБ ПРГ","Жидкие каши ФРУТОНЯНЯК 0.200 Тетра Пак",4.2389409999999996,19.169,7.5901012999999997,34.344349700000002,4.97,22.46,8.7799999999999994,39.74,5.6593169999999997,25.587,5.6593169999999997,25.587]
["ДО СПБ ПРГ","Сухие каши ФРУТОНЯНЯК 0.200 Картон",1.981846,7.7990000000000004,2.4691885999999998,9.7212145999999997,1.99,7.85,3.23,12.72,2.775458,10.927,2.775458,11.927]
["ДО СПБ ПРГ","Мясо ФРУТОНЯНЯМ 0.095 Мет банка",2.2795559999999999,21.106999999999999,5.1223261999999998,47.428944899999998,3.47,32.130000000000003,5.8,53.75,3.2611080000000001,30.183,3.2611080000000001,31.183]
["ДО СПБ ПРГ","Пюре ФРУТОНЯНЯО 0.105 Стекло",3.0057,13.98,2.5592074,11.9032901,3.92,18.22,2.61,12.12,5.2318100000000003,24.334,5.2318100000000003,24.334]
["ДО СПБ ПРГ","Пюре ФРУТОНЯНЯП 0.110 Стекло",15.777072,71.3,25.750746599999999,116.5192151,22.6,102.21,29.03,131.35,25.799939999999999,116.65,26.799939999999999,122.65]
["ДО СПБ ПРГ","Пюре ФРУТОНЯНЯП 0.250 Стекло",70.538696000000002,161.786,99.537847799999994,228.2978215,110.83,254.19,107.5,246.56,135.80179200000001,311.47199999999998,139.80179200000001,327.47199999999998]
["ДО СПБ ПРГ","Сухие каши ФРУТОНЯНЯК 0.250 Картон",null,null,null,null,0,0,0.03,0.1,null,null,0,0]
["ДО СПБ ПРГ","Промо-наборы ДП",null,null,null,null,11.83,17.25,0,0,4.801768,7,4.801768,7]
["ЮЦЧРР_ПРГ","ДП МАЛЫШАМ",292.02848699999998,1804.5440000000001,361.242796,2173.2108750000002,343.39,2089.12,363.92,2183.37,395,2376,421,2384]
["ЮЦЧРР_ПРГ","ДП ФРУТОНЯНЯ без ФНВ",863.63415199999997,2910.08,986.80309480000005,3446.5152670000002,917.51,3076,1036.73,3536.1,1235,4130,1321,4066]
["ЮЦЧРР_ПРГ","ДП без ФНВ",1155.6626389999999,4714.6239999999998,1348.045891,5619.7261420000004,1260.9000000000001,5165.13,1400.65,5719.47,1631,6506,1702,6923]
["ЮЦЧРР_ПРГ","ВОДА",1798.116072,1136.9459999999999,1836.9475829999999,1241.3710490000001,1774.05,1198.81,1968.6,1316.81,2372.3586610000002,1700.7139999999999,2400.3586610000002,1835.7139999999999]
["ЮЦЧРР_ПРГ","ДП",1366.3015869999999,4854.8739999999998,1508.034555,5757.4057380000004,1504.71,5311.19,1585.24,5857.37,1931,6737,2056,7406]
["ЮЦЧРР_ПРГ","БЮВЕТ",61.172471999999999,76.77,92.350922499999996,95.313997299999997,58.09,63.85,83.78,81.55,62,59,68,57]
["ЮЦЧРР_ПРГ","ЛИПЕЦБЮВЕТ",1736.9436000000001,1060.1759999999999,1744.596661,1146.0570520000001,1715.96,1134.96,1884.82,1235.26,2310,1642,2457,1681]
["ЮЦЧРР_ПРГ","МАЛЫШАМ",223.21425500000001,1322.3610000000001,289.38304110000001,1671.8032800000001,275.45999999999998,1611.11,280.94,1601.01,352,2073,382,2141]
["ЮЦЧРР_ПРГ","МАЛЫШАМК",0.46024799999999999,1.8120000000000001,1.2355556000000001,4.9620708999999996,0.18,0.72,0,0,0,1,0,1]
["ЮЦЧРР_ПРГ","МАЛЫШАМП",68.353983999999997,480.37099999999998,70.624199300000001,496.44552429999999,67.75,477.29,82.98,582.35,43,303,41,308]
["ЮЦЧРР_ПРГ","ФРУТОНЯНЯ",499.18733200000003,1611.1,645.52104850000001,2225.9530989999998,526.30999999999995,1737.48,638,2175.9299999999998,745.93954599999995,2466.0729999999999,756.93954599999995,2613.0729999999999]
["ЮЦЧРР_ПРГ","ФРУТОНЯНЯВ",210.638948,140.25,159.98866380000001,137.6795955,243.81,146.06,184.58,137.91,300,231,327,241]
["ЮЦЧРР_ПРГ","ФРУТОНЯНЯД",16.792784999999999,119.7,7.8287931999999998,55.523356,24.59,175.47,7.65,54.25,36,258,35,259]
["ЮЦЧРР_ПРГ","ФРУТОНЯНЯК",40.767867000000003,152.78899999999999,52.466019099999997,191.64918019999999,36.53,134.21,51.27,180.95,47,171,47,176]
["ЮЦЧРР_ПРГ","ФРУТОНЯНЯМ",4.0965480000000003,37.930999999999997,7.2134840000000002,66.791515899999993,5.77,53.42,6.85,63.39,6,52,6,50]
["ЮЦЧРР_ПРГ","ФРУТОНЯНЯО",24.614059999999998,114.48399999999999,5.1348244999999997,23.882904499999999,14.06,65.42,5.56,25.84,18.18384,84.575999999999993,19.18384,91.575999999999993]
["ЮЦЧРР_ПРГ","ФРУТОНЯНЯП",278.17556000000002,874.07600000000002,268.63892550000003,882.71521210000003,310.24,910.01,327.41000000000003,1035.73,363.36991999999998,1071.261,367.36991999999998,1093.261]
["ЮЦЧРР_ПРГ","ФРУТОНЯНЯН",null,null,null,null,null,null,null,null,18.966528,27.648,18.966528,29.648]
["ЮЦЧРР_ПРГ","Вода БЮВЕТ 0.500 ПЭТ",24.471540000000001,46.26,12.1856557,23.0352666,11.87,22.44,10.26,19.399999999999999,6.3411229999999996,11.987,6.3411229999999996,12.987]
["ЮЦЧРР_ПРГ","Вода БЮВЕТ 1.500 ПЭТ",31.130016000000001,20.058,63.421365000000002,40.864280399999998,36.78,23.7,61.51,39.630000000000003,47.283231999999998,30.466000000000001,45.283231999999998,33.466000000000001]
["ЮЦЧРР_ПРГ","Вода фруктовая БЮВЕТ 0.500 ПЭТ",5.5709160000000004,10.452,16.7439018,31.414450299999999,9.44,17.71,12,22.51,8.6154119999999992,16.164000000000001,8.6154119999999992,17.164000000000001]
["ЮЦЧРР_ПРГ","Вода ЛБЮВЕТ 0.330 ПЭТ",1.2361679999999999,3.492,9.0572037000000005,25.585320800000002,4.8099999999999996,13.6,8,22.6,13.805999999999999,39,13.805999999999999,41]
["ЮЦЧРР_ПРГ","Вода ЛБЮВЕТ 0.500 ПЭТ",66.768264000000002,126.21599999999999,96.250489900000005,181.9480015,106.37,201.08,106.68,201.66,200,379,200,372]
["ЮЦЧРР_ПРГ","Вода ЛБЮВЕТ 0.500 Стекло",2.0448000000000001E-2,2.4E-2,0,0,null,null,null,null,null,null,0,0]
["ЮЦЧРР_ПРГ","Вода ЛБЮВЕТ 1.500 ПЭТ",1346.2358400000001,867.42,1377.11842,887.31854320000002,1351.51,870.82,1481.6,954.64,1815,1169,1936,1256]
["ЮЦЧРР_ПРГ","Вода ЛБЮВЕТ 5.000 ПЭТ",322.68288000000001,63.024000000000001,262.17054739999998,51.205186300000001,253.27,49.47,288.54000000000002,56.36,281,55,300,56]
["ЮЦЧРР_ПРГ","Сок МАЛЫШАМ 0.125 Тетра Пак",119.494512,853.77599999999995,139.5856168,997.04011609999998,139.66,997.78,127.17,908.36,184,1312,199,1258]
["ЮЦЧРР_ПРГ","Сок МАЛЫШАМ 0.200 Тетра Пак",103.71974299999999,468.58499999999998,149.79742429999999,674.76316380000003,135.80000000000001,613.33000000000004,153.77000000000001,692.65,168,761,165,750]
["ЮЦЧРР_ПРГ","Сухие каши МАЛЫШАМК 0.200 Картон",0.46024799999999999,1.8120000000000001,1.2355556000000001,4.9620708999999996,0.18,0.72,0,0,0,1,0,1]
["ЮЦЧРР_ПРГ","Пюре МАЛЫШАМП 0.100 Стекло",3.3009599999999999,17.940000000000001,2.6760405,14.5436984,2.5299999999999998,13.74,3.71,20.14,1.839264,9.9960000000000004,1.839264,9.9960000000000004]
["ЮЦЧРР_ПРГ","Пюре МАЛЫШАМП 0.125 Тетра Пак",65.053023999999994,462.43099999999998,67.948158800000002,481.90182590000001,65.22,463.55,79.27,562.22,41,293,45,316]
["ЮЦЧРР_ПРГ","Сок восстановленный ФРУТОНЯНЯ 0.170 Стекло",8.9160240000000002,27.183,7.3292994,22.345424399999999,7.05,21.5,8.5500000000000007,26.08,9,29,9,30]
["ЮЦЧРР_ПРГ","Сок для беременных ФРУТОНЯНЯ 0.500 Тетра Пак",7.2422930000000001,13.259,13.093556299999999,23.980872000000002,6.47,11.85,9.9600000000000009,18.239999999999998,4,8,4,8]
["ЮЦЧРР_ПРГ","Сок ФРУТОНЯНЯ 0.170 Стекло",0.19367100000000001,0.59399999999999997,0,0,0.02,0.06,0,0,0,0,0,0]
["ЮЦЧРР_ПРГ","Сок ФРУТОНЯНЯ 0.200 Тетра Пак",245.95365200000001,1110.9059999999999,380.98319859999998,1716.1405119999999,272.56,1231.1300000000001,365.87,1648.08,394,1779,408,1888]
["ЮЦЧРР_ПРГ","Сок ФРУТОНЯНЯ 0.330 Тетра Пак",27.234484999999999,74.730999999999995,18.045362900000001,49.439349399999998,35.590000000000003,97.66,20.96,57.42,33,92,32,96]
["ЮЦЧРР_ПРГ","Сок ФРУТОНЯНЯ 0.500 Тетра Пак",209.64720700000001,384.42700000000002,226.0696313,414.04694060000003,204.62,375.27,232.65,426.11,304.71064699999999,558.80700000000002,291.71064699999999,547.80700000000002]
["ЮЦЧРР_ПРГ","Вода ФРУТОНЯНЯВ 0.330 ПЭТ",15.4521,43.65,18.561345599999999,52.433179199999998,14.97,42.28,13.85,39.119999999999997,37,104,40,108]
["ЮЦЧРР_ПРГ","Вода ФРУТОНЯНЯВ 1.500 ПЭТ",130.23452800000001,83.914000000000001,128.33332540000001,82.688995800000001,131.59,84.79,145.74,93.9,169,109,161,117]
["ЮЦЧРР_ПРГ","Вода ФРУТОНЯНЯВ 5.000 ПЭТ",64.95232,12.686,13.093992800000001,2.5574205000000001,97.25,18.989999999999998,25,4.88,94,18,93,19]
["ЮЦЧРР_ПРГ","Десерт ФРУТОНЯНЯД 0.125 Тетра Пак",16.792784999999999,119.7,7.8287931999999998,55.523356,24.59,175.47,7.65,54.25,36.129753000000001,257.553,37.129753000000001,268.553]
["ЮЦЧРР_ПРГ","Густые каши ФРУТОНЯНЯК 0.250 Стекло",10.334944,23.704000000000001,16.1875231,37.127347299999997,11.55,26.48,18.920000000000002,43.4,15,34,16,33]
["ЮЦЧРР_ПРГ","Жидкие каши ФРУТОНЯНЯК 0.200 Тетра Пак",15.881771000000001,71.796999999999997,19.890336600000001,90.001522899999998,16.05,72.58,17.37,78.58,16,71,17,69]
["ЮЦЧРР_ПРГ","Сухие каши ФРУТОНЯНЯК 0.200 Картон",14.551152,57.287999999999997,16.388159399999999,64.520309999999995,8.93,35.15,14.98,58.97,17,65,18,66]
["ЮЦЧРР_ПРГ","Мясо ФРУТОНЯНЯМ 0.095 Мет банка",4.0965480000000003,37.930999999999997,7.2134840000000002,66.791515899999993,5.77,53.42,6.85,63.39,6,52,6,51]
["ЮЦЧРР_ПРГ","Пюре ФРУТОНЯНЯО 0.105 Стекло",24.614059999999998,114.48399999999999,5.1348244999999997,23.882904499999999,14.06,65.42,5.56,25.84,18,85,18,89]
["ЮЦЧРР_ПРГ","Пюре ФРУТОНЯНЯП 0.110 Стекло",105.90324,478.95600000000002,119.4683898,540.58094789999996,89.01,402.61,127.63,577.52,107,482,106,520]
["ЮЦЧРР_ПРГ","Пюре ФРУТОНЯНЯП 0.250 Стекло",172.27232000000001,395.12,149.17053569999999,342.13426420000002,221.23,507.41,199.78,458.21,257,589,245,580]
["ЮЦЧРР_ПРГ","Сухие каши ФРУТОНЯНЯК 0.250 Картон",null,null,null,null,null,null,null,null,0,0,0,0]

{"sheet":"Лист1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}