{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["просчет","В работе","Суперы","инф"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"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":103,"n_cols":24,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
["2016-02-08","макрос, при выполнении которого, ячейки, выделенные желтым цветом, перемещались на первую свободную строку в лист \"в работе\""]
["Тираж, шт",null,"стоимость ПНД, руб","стоимость ПВД, руб","курс $, руб","курс €, руб"]
[20000,null,109.6,103.1,80]
[]
[]
["ВИД","цвет","кол-во цветов","материал","толщина, мкм"]
["МАЙКА","ЗЕЛЕНЫЙ","1+0","ПНД",25]
[]
[]
["ширина, см","бок, см","высота, см","дно, см",null,null,null,"Вес 1 пакета, гр"]
[30,16,60,0,null,null,null,{"$f":"IF(A7=\"рукав\",1000,SUM(IF(A7=\"ВУР\",\"3\",\"0\"),(PRODUCT(SUM(A11,B11),SUM(C11,D11),E7,SUM(IF(D7=\"ПНД\",\"0,95\",\"0\"),IF(D7=\"ПВД\",\"0,93\",\"0\"),IF(D7=\"ПСД\",\"0,94\",\"0\")),2)/10000)))","v":13.11}]
[]
[]
["Цена за кг, руб",null,"Стоимость за 1шт, руб",null,null,"Стоимость тиража, руб",null,"Вес тиража, кг"]
[{"$f":"[1]инф!G92","v":169.67},null,{"$f":"IF(A7=\"рукав\",0,ROUND((A15*H11/1000),2))","v":2.2200000000000002},"нет",null,{"$f":"IF(A7=\"рукав\",PRODUCT(A3,A15),PRODUCT(A3,C15))","v":44400.000000000007},null,{"$f":"A3*H11/1000","v":262.2}]
[]
["МЕНЕЕ 60 КГ ТИРАЖ РАСЧИТЫВАЕТСЯ ПО МАКМСИМАЛЬНО ВЫСОКОЙ ЦЕНЕ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"намотка не более 30 см"]

{"sheet":"В работе","index":1,"n_rows":135,"n_cols":30,"rows_kept":135,"cut":false,"hidden":false,"merged":[]}
["Дата","Заказчик","Название","Тип пакета","цвет супера","Цветность","шир","бок","выс","дон","усил","П/Э","толщ","Вес","За 1кг"," ","Кол-во","Цена","Сумма",null,"Счет","колво","чистый вес"]
["2016-02-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20000]
["2017-01-11",null,null,"Майка","белый","2+2",20,null,55,null,null,"ПНД",32,{"$f":"IF(D3=\"рукав\",1000,SUM(IF(K3=\"усил\",\"3\",\"0\"),(PRODUCT(SUM(G3,H3),SUM(I3,J3),M3,SUM(IF(L3=\"ПНД\",\"0,95\",\"0\"),IF(L3=\"ПВД\",\"0,93\",\"0\"),IF(L3=\"ПСД\",\"0,94\",\"0\")),2)/10000)))","v":6.6879999999999997},{"$f":"PRODUCT(1000,R3)/N3","v":149.52153110047848},{"$f":"IF(D3=\"рукав\",1000,SUM(IF(K3=\"усил\",\"0\",\"0\"),(PRODUCT(SUM(G3,H3),SUM(I3,J3),M3,SUM(IF(L3=\"ПНД\",\"0,95\",\"0\"),IF(L3=\"ПВД\",\"0,93\",\"0\"),IF(N3=\"ПСД\",\"0,94\",\"0\")),2)/10000)))","v":6.6879999999999997},150000]
["2017-01-15",null,null,"ВНУР","белый","2+2",40,null,50,null,null,"ПВД",45,16.739999999999998,59.737156511350065,{"$f":"IF(D4=\"рукав\",1000,SUM(IF(K4=\"усил\",\"0\",\"0\"),(PRODUCT(SUM(G4,H4),SUM(I4,J4),M4,SUM(IF(L4=\"ПНД\",\"0,95\",\"0\"),IF(L4=\"ПВД\",\"0,93\",\"0\"),IF(L4=\"ПСД\",\"0,94\",\"0\")),2)/10000)))","v":16.739999999999998},30000]
["2017-01-15",null,null,"ВНУР","белый","2+2",40,8,50,null,null,"ПВД",45,20.088000000000001,49.78096375945838,20.088000000000001,30000]
["2017-01-15",null,null,"ВНУР","белый","2+2",50,12,58,null,null,"ПВД",45,30.098520000000001,33.224224978503926,30.098520000000001,15000]
["2012-01-20",null,null,"фасовка","прозрачный","2+0",42,20,54,null,null,"ПНД",13,8.2695599999999985,120.92541803917018,8.2695599999999985,19000]
["2012-01-20",null,null,"фасовка","прозрачный","2+0",25,null,45,null,null,"ПНД",13,2.7787500000000001,359.87404408457041,2.7787500000000001,29000]
["2012-01-20",null,null,"фасовка","прозрачный","1+0",30,null,40,null,null,"ПСД",30,6.7679999999999998,147.75413711583926,6.7679999999999998,100000]
["2012-01-20",null,null,"фасовка","прозрачный","1+0",30,null,40,null,null,"ПСД",30,6.7679999999999998,147.75413711583926,6.7679999999999998,150000]
["2012-01-20",null,null,"ВУР","белый","2+0",38,null,50,4,"усил","ПВД",70,29.717040000000001,33.650726990305898,26.717040000000001,5000]
["2012-01-20",null,null,"ВУР","белый","2+0",60,null,50,4,"усил","ПВД",80,51.211199999999998,19.526978473458932,48.211199999999998,5000]
["2012-01-20",null,null,"ВУР","белый","2+0",38,null,50,4,"усил","ПВД",70,29.717040000000001,33.650726990305898,26.717040000000001,5000]
["2012-01-20",null,null,"ВУР","белый","2+0",60,null,50,4,"усил","ПВД",80,51.211199999999998,19.526978473458932,48.211199999999998,5000]
["2012-01-20",null,null,"Майка","салатовый","1+0",30,14,60,null,null,"ПНД",15,7.524,132.90802764486975,7.524,50000]
["2012-01-20",null,null,"Майка","салатовый","1+0",30,14,60,null,null,"ПНД",15,7.524,132.90802764486975,7.524,50000]
["2012-01-21",null,null,"Фасовка","голубой","без печати",50,null,105,null,null,"ПНД",50,49.875,20.050125313283207,49.875,60000]
["2012-01-22",null,null,"Майка","белый","1+1",32,24,60,null,null,"ПНД",14,8.9375999999999998,111.88686000716076,8.9375999999999998,20000]
["2012-01-22",null,null,"Майка","прозрачный","без печати",32,24,60,null,null,"ПНД",14,8.9375999999999998,111.88686000716076,8.9375999999999998,20000]
["2012-01-22",null,null,"Майка","белый","1+1",24,18,50,null,null,"ПНД",14,5.5860000000000003,179.0189760114572,5.5860000000000003,20000]
["2012-01-22",null,null,"Майка","белый","2+0",30,15,50,null,null,"ПНД",13,5.5575000000000001,179.93702204228521,5.5575000000000001,50000]
["2012-01-22",null,null,"Майка","белый","1+0",40,20,70,null,null,"ПНД",20,15.96,62.656641604010019,15.96,16000]
["2012-01-22",null,null,"Майка","белый","1+0",30,16,58,null,null,"ПНД",18,9.1245599999999989,109.59432564419546,9.1245599999999989,10000]
["2012-01-22",null,null,"Майка","белый","1+1",20,null,65,null,null,"ПНД",30,7.41,134.95276653171391,7.41,14000]
["2016-01-25",null,null,"фасовка","белый","1+0",20,null,25,null,null,"ПВД",50,4.6500000000000004,215.05376344086019,4.6500000000000004,25000]
["2016-01-25",null,null,"ВНУР","белый","2+2",39,19,50,null,null,"ПНД",50,27.55,36.297640653357533,27.55,5000]
["2016-01-25",null,null,"Майка","белый","1+1",40,20,70,null,null,"ПНД",30,23.94,41.771094402673349,23.94,40000]
["2016-01-25",null,null,"ВУР","белый","1+0",40,null,50,3,"усил","ПВД",70,30.602399999999999,32.677175646354534,27.602399999999999,5000]
["2016-01-25",null,null,"ВУР","белый","1+0",40,null,50,3,"усил","ПВД",70,30.602399999999999,32.677175646354534,27.602399999999999,5000]
["2016-01-26",null,null,"ВНУР","белый","1+0",30,null,40,null,null,"ПВД",70,15.624000000000001,64.004096262160772,15.624000000000001,5000]
["2016-01-26",null,null,"Майка","черный","2+0",28,16,54,null,null,"ПНД",18,8.1259199999999989,123.0629885600646,8.1259199999999989,30000]
["2016-01-26",null,null,"Майка","белый","1+0",30,15,60,null,null,"ПНД",23,11.798999999999999,155.94541910331384,11.798999999999999,10000]
["2016-01-26",null,null,"фасовка","прозрачный","3+0",15,8,30,null,null,"ПНД",15,1.9664999999999999,{"$f":"PRODUCT(1000,R33)/N33","v":508.51767098906691},1.9664999999999999,200000]
["2016-01-27",null,null,"ВУР","красный","1+1",30,null,40,4,"усил","ПСД",65,19.130400000000002,52.272822314222388,16.130400000000002,20000]
["2016-01-27",null,null,"Майка","белый","1+0",25,14,45,null,null,"ПНД",15,5.0017500000000004,199.93002449142799,5.0017500000000004,15000]
["2016-01-27",null,null,"Майка","белый","2+0",28,14,50,null,null,"ПНД",20,7.98,125.31328320802004,7.98,5000]
["2016-01-27",null,null,"Майка","белый","2+0",38,18,60,null,null,"ПНД",18,11.491199999999999,87.023113338902817,11.491199999999999,10000]
["2016-01-27",null,null,"ВНУР","желтый","Аптека",25,null,30,null,null,"ПНД",20,2.85,350.87719298245611,2.85,10000]
["2016-01-27",null,null,"Майка","белый","2+0",30,15,60,null,null,"ПНД",17,8.7210000000000001,114.66574934067194,8.7210000000000001,80000]
["2016-01-27",null,null,"Майка","белый","2+0",30,16,54,null,null,"ПНД",20,9.4391999999999996,105.9411814560556,9.4391999999999996,4000]
["2016-01-27",null,null,"Майка","белый","2+0",30,16,54,null,null,"ПНД",20,9.4391999999999996,105.9411814560556,9.4391999999999996,4000]
["2016-01-27",null,null,"Майка","белый","2+0",30,16,54,null,null,"ПНД",20,9.4391999999999996,105.9411814560556,9.4391999999999996,4000]
["2016-01-28",null,null,"Майка","белый","1+0",30,15,60,null,null,"ПНД",16,8.2080000000000002,121.83235867446393,8.2080000000000002,10000]
["2016-01-28",null,null,"Майка","прозрачный","без печати",32,24,60,null,null,"ПНД",20,12.768000000000001,78.320802005012524,12.768000000000001,50000]
["2016-01-28",null,null,"ВУР","красный","1+0",58,null,50,null,"усил","ПВД",60,35.363999999999997,28.277344191833507,32.363999999999997,5000]
["2016-01-28",null,null,"ВУР","красный","1+0",30,null,40,null,"усил","ПВД",60,16.391999999999999,61.005368472425573,13.391999999999999,10000]
["2016-01-28",null,null,"ВУР","прозрачный","без печати",60,null,50,5,"усил","ПВД",70,45.966000000000001,21.755210372884306,42.966000000000001,5000]
["2016-01-28",null,null,"Майка","белый","1+0",35,17,60,null,null,"ПНД",25,14.82,67.476383265856953,14.82,10000]
["2016-01-29",null,null,"Майка","белый","1+0",30,15,54,null,null,"ПНД",15,6.9255000000000004,144.39390657714245,6.9255000000000004,10000]
["2016-01-29",null,null,"Рукав","прозрачный","1+1",12,null,null,null,null,"ПВД",60,1000,1,1000,500]
["2016-01-29",null,null,"фасовка","прозрачный","без печати",25,null,55,null,null,"ПНД",16,4.18,239.23444976076556,4.18,30000]
["2016-01-29",null,null,"фасовка","прозрачный","без печати",17,null,13,null,null,"ПВД",50,2.0552999999999999,486.54697611054348,2.0552999999999999,120000]
["2016-01-29",null,null,"ВНУР","белый","без печати",38,null,50,null,null,"ПНД",40,14.44,69.252077562326875,14.44,10000]
["2016-01-29",null,null,"Майка","белый",null,28,14,50,null,null,"ПНД",17,6.7830000000000004,147.42739200943535,6.7830000000000004,20000]
["2016-01-29",null,null,"ВНУР","розовый","1+1",20,null,30,null,null,"ПНД",30,3.42,292.39766081871346,3.42,50000]
["2016-01-29",null,null,"ВУР","розовый","1+0",30,null,40,3,"усил","ПВД",60,17.3964,57.483157434871586,14.3964,10000]
["2016-01-29",null,null,"фасовка","оранжевый","без печати",47,null,50,null,null,"ПСД",28,12.3704,80.838129729030584,12.3704,40000]
["2016-01-29",null,null,"фасовка","прозрачный","без печати",65,null,95,null,null,"ПСД",38,44.114199999999997,22.668437827275572,44.114199999999997,40000]
["2016-01-29",null,null,"Майка","белый","2+0",55,25,80,null,null,"ПНД",23,27.968,35.755148741418765,27.968,60000]
["2016-01-29",null,null,"фасовка","прозрачный","1+0",55,30,92,null,null,"ПНД",30,44.573999999999998,22.434603131870599,44.573999999999998,12000]
["2016-02-01",null,null,"Майка","белый","2+0",30,16,58,null,null,"ПНД",18,9.1245599999999989,109.59432564419546,9.1245599999999989,50000]
["2016-02-01",null,null,"Майка","белый","1+0",40,20,70,null,null,"ПНД",19,15.162000000000001,65.95435958316844,15.162000000000001,5000]
["2016-02-01",null,null,"фасовка","прозрачный","без печати",16,null,24,null,null,"ПВД",40,2.8569600000000004,350.0224014336917,2.8569600000000004,100000]
["2016-02-01",null,null,"фасовка","белый","без печати",40,null,60,null,null,"ПВД",50,22.32,44.802867383512542,22.32,5000]
["2016-02-01",null,null,"Майка","белый","2+0",58,28,80,null,null,"ПНД",35,45.752000000000002,21.856968001398844,45.752000000000002,3000]
["2016-02-01",null,null,"ВУР","белый","2+0",50,null,58,6,"усил","ПВД",80,50.616,19.756598703967125,47.616,5000]
["2016-02-01",null,null,"ВУР","белый","без печати",40,null,50,3,"усил","ПВД",50,{"$f":"IF(D67=\"рукав\",1000,SUM(IF(K67=\"усил\",\"3\",\"0\"),(PRODUCT(SUM(G67,H67),SUM(I67,J67),M67,SUM(IF(L67=\"ПНД\",\"0,95\",\"0\"),IF(L67=\"ПВД\",\"0,93\",\"0\"),IF(L67=\"ПСД\",\"0,94\",\"0\")),2)/10000)))","v":22.716000000000001},44.021834830075719,19.716000000000001,10000]
["2016-02-01",null,null,"ВУР","белый","без печати",60,null,60,4,"усил","ПВД",50,38.712000000000003,25.83178342632775,{"$f":"IF(D68=\"рукав\",1000,SUM(IF(K68=\"усил\",\"0\",\"0\"),(PRODUCT(SUM(G68,H68),SUM(I68,J68),M68,SUM(IF(L68=\"ПНД\",\"0,95\",\"0\"),IF(L68=\"ПВД\",\"0,93\",\"0\"),IF(L68=\"ПСД\",\"0,94\",\"0\")),2)/10000)))","v":35.712000000000003},5000]
["2016-02-01",null,null,"ВУР","белый","1+1",60,null,50,5,"усил","ПВД",60,39.828000000000003,25.107964246258913,36.828000000000003,4000]
["2015-11-09",null,null,"Майка","белый","2+0",34,16,54,null,null,"ПНД",20,10.26,97.465886939571149,10.26,15000]
["2016-02-02",null,null,"ВУР","желтый","2+0",38,null,48,3,"усил","ПНД",50,21.411000000000001,46.704964737751617,18.411000000000001,5000]
["2016-02-02",null,null,"ВУР","черный","1+0",38,null,48,3,"усил","ПНД",50,21.411000000000001,46.704964737751617,18.411000000000001,5000]
["2016-02-02",null,null,"ВНУР","оранжевый","1+1",40,null,50,null,null,"ПНД",60,22.8,43.859649122807014,22.8,6000]
["2016-02-02",null,null,"Майка","белый","без печати",20,null,55,null,null,"ПНД",32,6.6879999999999997,149.52153110047848,6.6879999999999997,20000]
["2016-02-02",null,null,"ВУР","белый","1+0",30,null,40,null,"усил","ПСД",40,12.023999999999999,83.166999334664013,9.0239999999999991,15000]
["2016-02-02",null,null,"Майка","белый",null,40,20,65,null,null,"ПНД",20,14.82,67.476383265856953,14.82,30000]
["2016-02-02",null,null,"ВУР","белый","1+1",40,null,50,4,"усил","ПВД",70,31.123200000000001,32.130372198231541,28.123200000000001,5000]
["2016-02-02",null,null,"фасовка","прозрачный","1+0",25,10,40,null,null,"ПНД",15,3.99,250.62656641604008,3.99,25000]
["2016-02-02",null,null,"фасовка","прозрачный","1+0",37,16,70,null,null,"ПНД",15,10.573499999999999,94.576062798505703,10.573499999999999,15000]
["2016-02-02",null,null,"фасовка","прозрачный","1+0",34,15,54,null,null,"ПНД",15,7.5411000000000001,132.60664889737572,7.5411000000000001,15000]
["2016-02-02",null,null,"ВУР","белый","1+0",40,null,50,4,"усил","ПВД",70,31.123200000000001,32.130372198231541,28.123200000000001,25000]
["2016-02-02",null,null,"ВУР","белый","1+1",30,null,40,null,"усил","ПВД",70,18.624000000000002,53.694158075601365,15.624000000000001,15000]
["2016-02-02",null,null,"Майка","белый","1+0"," ",14,50,null,null,"ПНД",20,2.66,375.93984962406012,2.66,17000]
["2016-02-02",null,null,"ВНУР","белый","2+0",20,null,30,3,null,"ПСД",30,3.7223999999999999,268.64388566516226,3.7223999999999999,30000]
["2016-02-03",null,null,"фасовка","прозрачный","без печати",50,18,80,null,null,"ПНД",30,{"$f":"IF(D85=\"рукав\",1000,SUM(IF(K85=\"усил\",\"3\",\"0\"),(PRODUCT(SUM(G85,H85),SUM(I85,J85),M85,SUM(IF(L85=\"ПНД\",\"0,95\",\"0\"),IF(L85=\"ПВД\",\"0,93\",\"0\"),IF(L85=\"ПСД\",\"0,94\",\"0\")),2)/10000)))","v":31.007999999999999},{"$f":"PRODUCT(1000,R85)/N85","v":32.249742002063982},31.007999999999999,10000]
["2016-02-03",null,null,"фасовка","прозрачный","без печати",50,20,110,null,null,"ПНД",20,{"$f":"IF(D86=\"рукав\",1000,SUM(IF(K86=\"усил\",\"3\",\"0\"),(PRODUCT(SUM(G86,H86),SUM(I86,J86),M86,SUM(IF(L86=\"ПНД\",\"0,95\",\"0\"),IF(L86=\"ПВД\",\"0,93\",\"0\"),IF(L86=\"ПСД\",\"0,94\",\"0\")),2)/10000)))","v":29.26},{"$f":"PRODUCT(1000,R86)/N86","v":34.176349965823647},29.26,10000]
["2016-02-04",null,null,"ВУР","красный","без печати",40,null,50,3,"усил","ПВД",50,{"$f":"IF(D87=\"рукав\",1000,SUM(IF(K87=\"усил\",\"3\",\"0\"),(PRODUCT(SUM(G87,H87),SUM(I87,J87),M87,SUM(IF(L87=\"ПНД\",\"0,95\",\"0\"),IF(L87=\"ПВД\",\"0,93\",\"0\"),IF(L87=\"ПСД\",\"0,94\",\"0\")),2)/10000)))","v":22.716000000000001},{"$f":"PRODUCT(1000,R87)/N87","v":44.021834830075719},19.716000000000001,3000]
["2016-02-04",null,null,"ВУР","белый","без печати",40,null,50,3,"усил","ПВД",50,22.716000000000001,44.021834830075719,19.716000000000001,3000]
["2016-02-04",null,null,"Майка","белый","1+0",28,14,50,null,null,"ПНД",15,5.9850000000000003,167.08437761069339,5.9850000000000003,10000]
["2016-02-04",null,null,"Майка","белый","2+0",30,15,60,null,null,"ПНД",18,9.234,108.29542993285683,9.234,5000]
["2016-02-04",null,null,"ВУР","белый","1+0",20,null,30,3,"усил","ПВД",50,9.1379999999999999,109.4331363536879,6.1379999999999999,5000]
["2016-02-04",null,null,"Фасовка","прозрачный","2+0",40,null,75,null,null,"ПВД",50,27.9,35.842293906810035,27.9,5000]
["2016-02-04",null,null,"Майка","белый","1+0",20,10,40,null,null,"ПНД",18,4.1040000000000001,243.66471734892787,4.1040000000000001,25000]
["2016-02-04",null,null,"Майка","белый","1+0",40,20,60,null,null,"ПНД",18,12.311999999999999,81.221572449642636,12.311999999999999,20000]
["2016-02-04",null,null,"Рукав","прозрачный","без печати",9,null,null,null,null,"ПНД",20,1000,1,1000,100]
["2016-02-04",null,null,"Майка","белый","4+0",28,14,50,null,null,"ПНД",15,{"$f":"IF(D96=\"рукав\",1000,SUM(IF(K96=\"усил\",\"3\",\"0\"),(PRODUCT(SUM(G96,H96),SUM(I96,J96),M96,SUM(IF(L96=\"ПНД\",\"0,95\",\"0\"),IF(L96=\"ПВД\",\"0,93\",\"0\"),IF(L96=\"ПСД\",\"0,94\",\"0\")),2)/10000)))","v":5.9850000000000003},{"$f":"PRODUCT(1000,R96)/N96","v":167.08437761069339},5.9850000000000003,20000]
["2016-02-04",null,null,"Майка","белый","1+0",30,16,58,null,null,"ПНД",18,{"$f":"IF(D97=\"рукав\",1000,SUM(IF(K97=\"усил\",\"3\",\"0\"),(PRODUCT(SUM(G97,H97),SUM(I97,J97),M97,SUM(IF(L97=\"ПНД\",\"0,95\",\"0\"),IF(L97=\"ПВД\",\"0,93\",\"0\"),IF(L97=\"ПСД\",\"0,94\",\"0\")),2)/10000)))","v":9.1245599999999989},{"$f":"PRODUCT(1000,R97)/N97","v":109.59432564419546},9.1245599999999989,10000]
["2016-02-04",null,null,"Майка","светло- желтый","3+0",30,16,54,null,null,"ПНД",16,{"$f":"IF(D98=\"рукав\",1000,SUM(IF(K98=\"усил\",\"3\",\"0\"),(PRODUCT(SUM(G98,H98),SUM(I98,J98),M98,SUM(IF(L98=\"ПНД\",\"0,95\",\"0\"),IF(L98=\"ПВД\",\"0,93\",\"0\"),IF(L98=\"ПСД\",\"0,94\",\"0\")),2)/10000)))","v":7.551359999999999},{"$f":"PRODUCT(1000,R98)/N98","v":132.42647682006952},7.551359999999999,10000]
["2016-02-04",null,null,"фасовка","белый","1+0",22,null,48,null,null,"ПСД",30,{"$f":"IF(D99=\"рукав\",1000,SUM(IF(K99=\"усил\",\"3\",\"0\"),(PRODUCT(SUM(G99,H99),SUM(I99,J99),M99,SUM(IF(L99=\"ПНД\",\"0,95\",\"0\"),IF(L99=\"ПВД\",\"0,93\",\"0\"),IF(L99=\"ПСД\",\"0,94\",\"0\")),2)/10000)))","v":5.9558399999999994},{"$f":"PRODUCT(1000,R99)/N99","v":167.90242854072642},5.9558399999999994,7000,null,null,null,null,null,null,null,null,null,null,"уп",null,1.23]
["2016-02-04",null,null,"фасовка","белый","2+0",30,null,50,null,null,"ПСД",30,8.4600000000000009,118.20330969267138,8.4600000000000009,15000,null,null,null,null,null,null,null,null,null,null,"шт.",null,0.86]
["2016-02-04",null,null,"фасовка","белый","2+0",31,null,48,null,null,"ПСД",30,8.3923199999999998,119.15656219019294,8.3923199999999998,15000,null,null,null,null,null,null,null,null,null,null,"уп",null,1.22]
["2016-02-04",null,null,"ВУР","белый","1+0",30,null,40,3,"усил","ПВД",50,14.997,66.680002667200114,11.997,7000]
["2016-02-04",null,null,"Майка","белый","2+0",44,18,70,null,null,"ПНД",18,14.8428,67.372732907537653,14.8428,10000]
["2016-02-04",null,null,"Майка","белый","без печати",30,16,58,null,null,"ПНД",18,9.1245599999999989,109.59432564419546,9.1245599999999989,5000]
["2016-02-04",null,null,"Фасовка","прозрачный","без печати",42,null,58,null,null,"ПНД",25,11.571,86.422953936565548,11.571,12000]
["2016-02-04",null,null,"Майка","белый","3+0",38,18,70,null,null,"ПНД",18,13.4064,74.591240004773837,13.4064,10000]
["2016-02-04",null,null,"Майка","белый","2+0",38,18,70,null,null,"ПНД",18,13.4064,74.591240004773837,13.4064,10000]
["2016-02-05",null,null,"ВУР","белый","1+1",40,null,50,3.5,"усил","ПВД",50,22.902000000000001,43.664308793991786,19.902000000000001,5000]
["2016-02-05",null,null,"Майка","белый","3+0",40,20,70,null,null,"ПНД",20,15.96,62.656641604010019,15.96,10000]
["2016-02-05",null,null,"ВУР","белый","1+1",38,null,50,3,"усил","ПСД",50,21.9316,45.596308522861989,18.9316,5000]
["2016-02-05",null,null,"ВУР","белый","1+1",30,null,40,3,"усил","ПСД",50,15.125999999999999,66.111331482216059,12.125999999999999,7000]
["2016-02-05",null,null,"фасовка","прозрачный","2+0",26,null,40,null,null,"ПВД",50,9.6720000000000006,103.39123242349048,9.6720000000000006,20000]
["2016-02-05",null,null,"ВУР","белый","1+0",30,null,40,3,"усил","ПВД",80,22.1952,45.054786620530564,19.1952,5000]
["2016-02-05",null,null,"Майка","оранжевый","1+1",30,16,60,null,null,"ПСД",25,12.971999999999998,77.089115016959624,12.971999999999998,10000]
["2016-02-05",null,null,"ВУР","белый","1+0",38,null,50,3,"усил","ПВД",50,21.7302,46.018904565995712,18.7302,1500]
["2015-07-24",null,null,"Фасовка","белый","3+0",29,null,48,null,null,"ПСД",30,{"$f":"SUM(IF(K116=\"усил\",\"3\",\"0\"),(PRODUCT(SUM(G116,H116),SUM(I116,J116),M116,SUM(IF(L116=\"ПНД\",\"0,95\",\"0\"),IF(L116=\"ПВД\",\"0,93\",\"0\"),IF(L116=\"ПСД\",\"0,94\",\"0\")),2)/10000))","v":7.8508799999999992},{"$f":"PRODUCT(1000,R116)/N116","v":127.37425613434419},7.8508799999999992,15000]
[]
[]
[]
[]
[]
[]
[]
["2016-02-05","производство пакетов","Китчен","Майка","белый","2+2",30,15,60,null,null,"ПНД",16,8.2080000000000002,121.83235867446393,null,15000]
["2016-02-05","Истрапласт","Спорт","Майка","белый","1+0",32,16,60,null,null,"ПНД",15,{"$f":"IF(D125=\"рукав\",1000,SUM(IF(K125=\"усил\",\"3\",\"0\"),(PRODUCT(SUM(G125,H125),SUM(I125,J125),M125,SUM(IF(L125=\"ПНД\",\"0,95\",\"0\"),IF(L125=\"ПВД\",\"0,93\",\"0\"),IF(L125=\"ПСД\",\"0,94\",\"0\")),2)/10000)))","v":8.2080000000000002},121.83235867446393,null,10000]
["2016-02-05","тд полимеров","\"майка\" 30+15*60 ПНД 14мкм п/э белый 1+0 тираж 20 000шт - 1.16р/шт","Майка","белый","1+0",30,15,60,null,null,"ПНД",14,{"$f":"IF(D126=\"рукав\",1000,SUM(IF(K126=\"усил\",\"3\",\"0\"),(PRODUCT(SUM(G126,H126),SUM(I126,J126),M126,SUM(IF(L126=\"ПНД\",\"0,95\",\"0\"),IF(L126=\"ПВД\",\"0,93\",\"0\"),IF(L126=\"ПСД\",\"0,94\",\"0\")),2)/10000)))","v":7.1820000000000004},139.23698134224449,null,20000]
["2016-02-05","тд полимеров"," \"майка\" 44+18*70 ПНД 18мкм п/э белый 1+0 тираж 20 000шт - 2.30р/шт","Майка","белый","1+0",44,18,70,null,null,"ПНД",18,14.8428,67.372732907537653,null,20000]
["2016-02-05","тд полимеров"," \"40*50+4 ПВД ВУР 55мкм п/э синий 1+0 тираж 10 000шт - 4.11р/шт","ВУР","синий","1+0",40,null,50,4,"усил","ПВД",55,25.096800000000002,39.845717382295746,null,10000]
["2016-02-05"]
["2016-02-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["2016-02-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["2016-02-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["2016-02-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,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":"#REF!-#REF!*0.09","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-9000]

{"sheet":"Суперы","index":2,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[null,"Цена в $"]
["Зеленый PE 92307",6.1,{"$f":"(B2*инф!$K$10-инф!$K$14)*5%","v":{"$error":"#REF!"}},{"$f":"C2-4.5","v":{"$error":"#REF!"}}]
["Зеленый 27045",4.59,{"$f":"(B3*инф!$K$10-инф!$K$14)*5%","v":{"$error":"#REF!"}},{"$f":"C3-4.5","v":{"$error":"#REF!"}}]
["Голубой МВ 26095 BLUE (Кимовский)",4.9000000000000004,{"$f":"(B4*инф!$K$10-инф!$K$14)*5%","v":{"$error":"#REF!"}},{"$f":"C4-4.5","v":{"$error":"#REF!"}}]
["Синий РЕ 82393",5.85,{"$f":"(B5*инф!$K$10-инф!$K$14)*5%","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Фиолетовый РЕ 72075",4.68,{"$f":"(B6*инф!$K$10-инф!$K$14)*5%","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Красный PE 62375",4.87,{"$f":"(B7*инф!$K$10-инф!$K$14)*5%","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Желтый МВ205A YELLOW PE 3499/NEW",4.2,{"$f":"(B8*инф!$K$10-инф!$K$14)*5%","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Оранжевый МВ 023156",4.3600000000000003,{"$f":"(B9*инф!$K$10-инф!$K$14)*5%","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Черный N/B 2100 BLACK",2.62,{"$f":"(B10*инф!$K$10-инф!$K$14)*5%","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Серебро МВ РЕ 8223 SILVER",4,{"$f":"(B11*инф!$K$10-инф!$K$14)*5%","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Синий МВ 7111 BLUE Кимовский",3.58,{"$f":"(B12*инф!$K$10-инф!$K$14)*5%","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Белый МВ 81852",2.6,{"$f":"(B13*инф!$K$10-инф!$K$14)*5%","v":{"$error":"#REF!"}}]
["Оранжевый МВ 023156",7.8,{"$f":"(B14*инф!$K$10-инф!$K$14)*5%","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Салатовый МВ 27 226",3.9,{"$f":"(B15*инф!$K$10-инф!$K$14)*5%","v":{"$error":"#REF!"}},{"$f":"C15-4.5","v":{"$error":"#REF!"}}]
["Черный ЕН 9201V",1.55,{"$f":"(B16*инф!$K$10-инф!$K$14)*5%","v":{"$error":"#REF!"}}]
["Скользячка PE: 0045 EFIUKAMIDE SLIP",3.73,{"$f":"(B17*инф!$K$10-инф!$K$14)*5%","v":{"$error":"#REF!"}}]
["Скользячка SLIP Антиблок 0074/SE",4.09,{"$f":"(B18*инф!$K$10-инф!$K$14)*5%","v":{"$error":"#REF!"}}]
["Скользячка SL1207 SLIP",3.74,{"$f":"(B19*инф!$K$10-инф!$K$14)*5%","v":{"$error":"#REF!"}}]

{"sheet":"инф","index":3,"n_rows":92,"n_cols":14,"rows_kept":92,"cut":false,"hidden":true,"merged":[[15,9,16,9]]}
["ключ"]
[{"$f":"B2&C2","v":"майкабез печати"},"майка","без печати",37]
["майка1+0","майка","1+0",42]
["майка2+0","майка","2+0",47]
["майка3+0","майка","3+0",52]
["майка1+1","майка","1+1",47]
["майка2+1","майка","2+1",52,null,null,null,null,"БЕЗ ПЕЧАТИ"]
["майка2+2","майка","2+2",57,null,null,null,null,"1+0"]
["майка3+1","майка","3+1",57,null,null,null,null,"2+0",null,"Доллар","Евро","клиент"]
["майка4+0","майка","4+0",57,null,null,null,"РУКАВ","3+0",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},10]
["фасовкабез печати","фасовка","без печати",38,null,null,null,"МАЙКА","1+1",null,"ПВД","ПНД","ПСД"]
["фасовка1+0","фасовка","1+0",45,null,null,null,"ФАСОВКА","2+1",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"(K12+L12)/2","v":{"$error":"#REF!"}}]
["фасовка2+0","фасовка","2+0",50,null,null,null,"ВУР","2+2"]
["фасовка3+0","фасовка","3+0",55,null,null,{"$f":"H16&I16","v":{"$error":"#REF!"}},"ВнУР","3+1",null,{"$f":"SUM(IF(H17=\"ПВД\",K12,0)+IF(H17=\"ПНД\",L12,0)+IF(H17=\"ПСД\",M12,0))","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(G14,A1:D55,4,0)","v":{"$error":"#REF!"}},{"$f":"ROUND((SUM(IF(I17=\"белый\",Суперы!C13,0)+IF(I17=\"зеленый\",Суперы!C2,0)+IF(I17=\"салатовый\",Суперы!C15,0)+IF(I17=\"красный\",Суперы!C7,0)+IF(I17=\"оранжевый\",Суперы!C9,0)+IF(I17=\"голубой\",Суперы!C12,0)+IF(I17=\"черный\",Суперы!C10,0)+IF(I17=\"желтый\",Суперы!C8,0)+IF(I17=\"серебро\",Суперы!C11,0)+IF(I17=\"прозрачный\",0,0)+IF(I17=\"фиолетовый\",Суперы!C6,0)+IF(I17=\"бежевый\",14,0))+IF(I17=\"СИНИЙ\",Суперы!C5,0)),2)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Да\",M10,0)","v":{"$error":"#REF!"}}]
["фасовка1+1","фасовка","1+1",50,null,null,null,"НАРЕЗКА","4+0"]
["фасовка2+1","фасовка","2+1",55,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"K14+L14+M14+N14","v":{"$error":"#REF!"}}]
["фасовка2+2","фасовка","2+2",60,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["фасовка3+1","фасовка","3+1",60,null,null,null,"ПНД","БЕЛЫЙ",null,null,null,null,"да"]
["фасовка4+0","фасовка","4+0",60,null,null,null,"ПВД","ПРОЗРАЧНЫЙ",null,null,null,null,"нет"]
["Рукавбез печати","Рукав","без печати",28,null,null,null,"ПСД","КРАСНЫЙ"]
["Рукав1+0","Рукав","1+0",35,null,null,null,null,"ЗЕЛЕНЫЙ"]
["Рукав2+0","Рукав","2+0",40,null,null,null,null,"ЧЕРНЫЙ"]
["Рукав3+0","Рукав","3+0",45,null,null,null,null,"ЖЕЛТЫЙ"]
["Рукав1+1","Рукав","1+1",40,null,null,null,null,"ОРАНЖЕВЫЙ"]
["Рукав2+1","Рукав","2+1",45,null,null,null,null,"СЕРЕБРО"]
["Рукав2+2","Рукав","2+2",50,null,null,null,null,"ГОЛУБОЙ"]
["Рукав3+1","Рукав","3+1",50,null,null,null,null,"ФИОЛЕТОВЫЙ"]
["Рукав4+0","Рукав","4+0",50,null,null,null,null,"БЕЖЕВЫЙ"]
["ВНУРбез печати","ВНУР","без печати",38,null,null,null,null,"СИНИЙ"]
["ВНУР1+0","ВНУР","1+0",45,null,null,null,null,"САЛАТОВЫЙ"]
["ВНУР2+0","ВНУР","2+0",50]
["ВНУР3+0","ВНУР","3+0",55]
["ВНУР1+1","ВНУР","1+1",50]
[{"$f":"B34&C34","v":"ВНУР2+1"},"ВНУР","2+1",55]
["ВНУР2+2","ВНУР","2+2",60]
["ВНУР3+1","ВНУР","3+1",60]
["ВНУР4+0","ВНУР","4+0",60]
["ВУРбез печати","ВУР","без печати",38]
["ВУР1+0","ВУР","1+0",45]
["ВУР2+0","ВУР","2+0",50]
["ВУР3+0","ВУР","3+0",55]
["ВУР1+1","ВУР","1+1",50]
["ВУР2+1","ВУР","2+1",55]
["ВУР2+2","ВУР","2+2",60]
["ВУР3+1","ВУР","3+1",60]
["ВУР4+0","ВУР","4+0",60]
["НАРЕЗКАбез печати","НАРЕЗКА","без печати",38]
["НАРЕЗКА1+0","НАРЕЗКА","1+0",45]
["НАРЕЗКА2+0","НАРЕЗКА","2+0",50]
["НАРЕЗКА3+0","НАРЕЗКА","3+0",55]
["НАРЕЗКА1+1","НАРЕЗКА","1+1",50]
["НАРЕЗКА2+1","НАРЕЗКА","2+1",55]
["НАРЕЗКА2+2","НАРЕЗКА","2+2",60]
["НАРЕЗКА3+1","НАРЕЗКА","3+1",60]
["НАРЕЗКА4+0","НАРЕЗКА","4+0",60]
[]
[]
[null,null,"№коэфф",{"$f":"MATCH($I$58,E59:E69,1)","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,1,1,1.4,{"$f":"F59*$J$16","v":{"$error":"#REF!"}}]
[null,null,null,2,60,1.3,{"$error":"#REF!"}]
[null,null,null,3,75,1.2,{"$error":"#REF!"}]
[null,null,null,4,83,1.1399999999999999,{"$error":"#REF!"}]
[null,null,null,5,91,1.07,{"$error":"#REF!"}]
[null,null,null,6,100,1,{"$error":"#REF!"}]
[null,null,null,7,200,0.995,{"$error":"#REF!"}]
[null,null,null,8,300,0.98850000000000005,{"$error":"#REF!"}]
[null,null,null,9,500,0.98,{"$error":"#REF!"}]
[null,null,null,10,1000,0.97,{"$error":"#REF!"}]
[null,null,null,11,5000,0.96,{"$error":"#REF!"}]
[null,null,null,null,null,null,{"$f":"ROUND((SUM(IF(D58=D59,G59,0)+IF(D58=D60,G60,0)+IF(D58=D61,G61,0)+IF(D58=D62,G62,0)+IF(D58=D63,G63,0)+IF(D58=D64,G64,0)+IF(D58=D65,G65,0)+IF(D58=D66,G66,0)+IF(D58=D67,G67,0)+IF(D58=D68,G68,0)+IF(D58=D69,G69,0))),2)","v":{"$error":"#REF!"}},null,{"$f":"INDEX(D59:G69,D58,4)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,"№поз",{"$f":"MATCH($I$71,E73:E89,-1)","v":{"$error":"#REF!"}},"гр"]
[null,null,null,1,1500000,1,{"$f":"F73*$G$70","v":{"$error":"#REF!"}}]
[null,null,null,2,200,1,{"$error":"#REF!"}]
[null,null,null,3,100,1,{"$error":"#REF!"}]
[null,null,null,4,50,1,{"$error":"#REF!"}]
[null,null,null,5,30,1,{"$error":"#REF!"}]
[null,null,null,6,20,1,{"$error":"#REF!"}]
[null,null,null,7,10,1.01,{"$error":"#REF!"}]
[null,null,null,8,8,1.04,{"$error":"#REF!"}]
[null,null,null,9,6,1.075,{"$error":"#REF!"}]
[null,null,null,10,4,1.1000000000000001,{"$error":"#REF!"}]
[null,null,null,11,3.5,1.2,{"$error":"#REF!"}]
[null,null,null,12,3,1.3,{"$error":"#REF!"}]
[null,null,null,13,2.5,1.6,{"$error":"#REF!"}]
[null,null,null,14,2,1.7,{"$error":"#REF!"}]
[null,null,null,15,1.5,1.8,{"$error":"#REF!"}]
[null,null,null,16,1,1.95,{"$error":"#REF!"}]
[null,null,null,17,0.4,2.56,{"$error":"#REF!"}]
[]
[]
[null,null,null,null,null,null,{"$f":"ROUND((SUM(IF(D72=D73,G73,0)+IF(D72=D76,G76,0)+IF(D72=D75,G75,0)+IF(D72=D74,G74,0)+IF(D72=D79,G79,0)+IF(D72=D80,G80,0)+IF(D72=D78,G78,0)+IF(D72=D77,G77,0)+IF(D72=D81,G81,0)+IF(D72=D82,G82,0)+IF(D72=D83,G83,0)+IF(D72=D84,G84,0)+IF(D72=D85,G85,0)+IF(D72=D86,G86,0)+IF(D72=D87,G87,0)+IF(D72=D88,G88,0)+IF(D72=D89,G89,0))),2)","v":{"$error":"#REF!"}},null,{"$f":"INDEX(D73:G89,D72,4)","v":{"$error":"#REF!"}}]