{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["В работе","Pantone","для бланка","бланк"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":10,"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":13,"n_cols":23,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Дата","Заказчик","Название","Тип пакета","цвет супера","Цветность","шир","бок","выс","дон","усил","П/Э","толщ","Вес","За 1кг",null,"Кол-во","Цена","Сумма",1,2,3,4]
["2017-01-24","Крокус ","Верон","Рукав","белый","1+1",60,null,60,3,"усил","ПВД",50,15,160,null,5000,6.21,{"$f":"Q2*R2","v":31050},103,104,105,104]
["2017-01-24","Крокус ","Спектр","майка","белый","1+0",40,18,70,null,null,"ПНД",18,15,160,null,10000,2.0499999999999998,20500,152,151,153,154]
["2017-01-24","Крокус ","Декор и цветы","ВУР","белый","1+1",60,null,50,2,"усил","ПНД",45,15,160,null,30000,4.6100000000000003,138300,200,201,null,0]
[]
[]
[]
[null,"Макрос копипаст выполняется захватом мышью строки в диапазоен А-W, на лист \"для бланка\""]
[null,"Хотелось бы одновременно этой же командой выполнить вывод на принтер листа \"бланк\". Самостоятельно не смог."]
[]
[]
[]
[null,"Спасибо."]

{"sheet":"Pantone","index":1,"n_rows":189,"n_cols":19,"rows_kept":189,"cut":false,"hidden":false,"merged":[]}
["Pantone","R","G","B","Trans.Wt","Black","Yellow","Warm Red","Rub. Red","Or. 021","Red 032","Rhod. Red","Purple","Pro. Blue","Violet","Ref. Blue","Blue 072","Green",877]
["Or. 021",237,110,0,null,null,null,null,null,100]
["Rub. Red",207,3,92,null,null,null,null,100]
[" Rhod. Red",230,0,148,null,null,null,null,null,null,null,100]
["Purple",186,31,181,null,null,null,null,null,null,null,null,100]
["Violet",102,0,161,null,null,null,null,null,null,null,null,null,null,100]
["Blue 072",41,5,161,null,null,null,null,null,null,null,null,null,null,null,null,100]
["Ref. Blue",23,23,150,null,null,null,null,null,null,null,null,null,null,null,100]
["Pro. Blue",0,140,204,null,null,null,null,null,null,null,null,null,100]
[100,242,237,130,96.9,null,3.1]
[101,245,237,89,87.5,null,12.5]
[102,245,232,20,50,null,50]
["Yellow",247,224,23,null,null,100]
[103,196,173,15,null,1.5,98.5]
[104,168,150,10,null,5.9,94.1]
[105,128,115,15,null,20,80]
[106,245,232,92,87.3,null,12.5,0.2]
[107,245,227,38,74.7,null,24.9,0.4]
[108,247,219,23,49.6,null,49.6,0.8]
[109,247,212,23,null,null,98.5,1.5]
[110,212,176,18,null,1.5,97,1.5]
[111,168,143,10,null,5.8,92.8,1.4]
[112,148,130,10,null,11,87.6,1.4]
[113,247,227,84,87.2,null,12.4,0.4]
[114,247,227,74,74.400000000000006,null,24.8,0.8]
[115,250,224,66,49.2,null,49.2,1.6]
[116,247,209,23,null,null,97,3]
[117,196,158,13,null,2.9,94.2,2.9]
[118,171,142,10,null,5.7,91.4,2.9]
[119,135,117,20,null,19.5,78.099999999999994,2.4]
[120,250,224,115,87.5,null,11.7,0.8]
[121,250,222,105,75,null,23.4,1.6]
[122,252,214,71,50,null,46.9,3.1]
[123,252,201,23,null,null,93.8,6.2]
[124,224,173,18,null,1.5,92.3,6.2]
[125,179,140,10,null,5.9,88.2,5.9]
[126,158,125,10,null,11.1,83.3,5.6]
[1205,245,227,158,93.7,null,5.7,0.6]
[1215,245,222,140,91.6,null,7.6,0.8]
[1225,250,201,61,50,null,45.3,4.7]
[1235,247,181,18,null,null,90.6,9.4]
[1245,191,148,13,null,5.9,85.3,8.8000000000000007]
[1255,166,130,0,null,11.1,80.599999999999994,8.3000000000000007]
[1265,130,102,13,null,20,72.5,7.5]
[127,240,224,125,93.7,null,5.9,null,0.4]
[128,237,217,89,87.5,null,11.7,null,0.8]
[129,237,207,61,50,null,46.9,null,3.1]
[130,230,176,18,null,null,93.8,null,6.2]
[131,199,148,13,null,1.5,92.3,null,6.2]
[132,161,125,10,null,5.9,88.2,null,5.9]
[133,112,89,15,null,20,75,null,5]
[134,247,214,125,93.7,null,5.5,0.8]
[135,252,201,84,75,null,21.9,3.1]
[136,252,189,48,50,null,43.8,6.2]
[137,247,163,10,null,null,87.5,12.5]
[138,212,133,0,null,1.5,86.2,12.3]
[139,171,115,5,null,5.9,82.3,11.8]
[140,120,87,10,null,20,70,10]
[1345,250,209,133,90.9,null,7.4,1.7]
[1355,252,201,117,81.8,null,14.8,3.4]
[1365,252,184,82,60,null,32.5,7.5]
[1375,250,158,13,null,null,81.3,18.7]
[1385,201,122,0,null,3,78.8,18.2]
[1395,153,99,8,null,11.1,72.2,16.7]
[1405,107,71,15,null,23.8,61.9,14.3]
[141,237,204,97,87.5,null,10.9,null,1.6]
[142,237,189,61,75,null,21.9,null,3.1]
[143,235,173,20,50,null,43.8,null,6.2]
[144,222,135,3,null,null,87.5,null,12.5]
[145,194,125,5,null,1.5,86.2,null,12.3]
[146,150,99,5,null,5.9,82.3,null,11.8]
[147,112,89,28,null,27.3,63.6,null,9.1]
[148,252,209,148,93.7,null,4.7,1.6]
[149,255,199,130,87.5,null,9.4,3.1]
[150,252,171,79,50,null,37.5,12.5]
[151,242,125,0,null,null,75,25]
[152,217,115,0,null,1.5,73.900000000000006,24.6]
[153,184,105,5,null,5.9,70.599999999999994,23.5]
[154,150,87,0,null,11.1,66.7,22.2]
[1485,252,181,122,87.5,null,null,null,null,12.5]
[1495,255,153,59,75,null,null,null,null,25]
[1505,242,128,0,50,null,null,null,null,50]
[1525,186,87,0,null,3,null,null,null,97]
[1535,140,66,0,null,11.1,null,null,null,88.9]
[1545,79,38,8,null,27.3,null,null,null,72.7]
[155,240,214,168,96.9,null,2.2999999999999998,null,0.8]
[156,237,194,130,87.5,null,9.4,null,3.1]
[157,232,158,71,50,null,37.5,null,12.5]
[158,222,112,8,null,null,75,null,25]
[159,194,94,3,null,1.5,73.900000000000006,null,24.6]
[160,158,82,5,null,5.9,70.599999999999994,null,23.5]
[161,94,56,18,null,20,60,null,20]
[1555,250,191,158,87.5,null,7,5.5]
[1565,250,168,120,75,null,14.1,10.9]
[1575,250,135,61,50,null,28.1,21.9]
[1585,245,112,0,null,null,56.2,43.8]
[1595,209,97,3,null,3,54.5,42.5]
[1605,158,77,10,null,11.1,50,38.9]
[1615,130,61,10,null,15.8,47.4,36.799999999999997]
[162,255,194,163,93.8,null,3.1,3.1]
[163,250,156,110,75,null,12.5,12.5]
[164,250,128,61,50,null,25,25]
[165,245,102,0,null,null,50,50]
[166,217,89,0,null,1.6,49.2,49.2]
[167,1886,82,5,null,5.8,47.1,47.1]
[168,107,48,13,null,20,40,40]
[1625,250,163,135,87.5,null,4.7,7.8]
[1635,250,143,107,75,null,9.4,15.6]
[1645,250,110,54,50,null,18.7,31.3]
[1655,242,89,0,null,null,37.5,62.5]
[1665,217,79,0,null,1.5,36.9,61.6]
[1675,163,61,5,null,8.6,34.299999999999997,57.1]
[1685,133,54,15,null,15.8,31.6,52.6]
[169,250,181,171,93.7,null,1.6,4.7]
[170,250,138,117,75,null,6.3,18.7]
[171,250,99,59,50,null,12.5,37.5]
[172,242,79,0,null,null,25,75]
[173,212,71,15,null,3,24.3,72.7]
[174,150,51,15,null,11.1,22.2,66.7]
[175,112,51,31,null,27.3,18.2,54.5]
[176,250,171,176,93.7,null,null,6.3]
[177,250,128,133,75,null,null,25]
[178,250,92,89,50,null,null,50]
["Warm Red",245,64,41,null,null,null,100]
[179,222,59,33,null,1.5,null,98.5]
[180,189,56,38,null,5.9,null,94.1]
[181,120,41,28,null,20,null,80]
[1765,250,156,166,87.5,null,null,10.9,1.6]
[1775,250,130,143,75,null,null,21.9,3.1]
[1785,247,69,82,50,null,null,43.8,6.2]
[1788,235,38,41,null,null,null,87.5,12.5]
[1795,209,36,33,null,1.5,null,86.2,12.3]
[1805,173,38,36,null,5.9,null,82.3,11.8]
[1815,120,31,28,null,15.8,null,73.7,10.5]
[1767,252,176,186,93.8,null,null,null,null,null,6.2]
[1777,250,99,120,75,null,null,null,null,null,25]
[1787,245,66,87,50,null,null,null,null,null,50]
["Red 032",237,46,56,null,null,null,null,null,null,100]
[1797,204,41,43,null,1.5,null,null,null,null,98.5]
[1807,158,41,43,null,5.9,null,null,null,null,94.1]
[1817,92,38,36,null,27.3,null,null,null,null,72.7]
[182,252,184,196,93.7,null,null,4.7,1.6]
[183,252,140,161,75,null,null,18.8,6.2]
[184,247,92,117,50,null,null,37.5,12.5]
[185,230,13,46,null,null,null,75,25]
[186,207,20,43,null,1.5,null,73.900000000000006,24.6]
[187,176,28,46,null,5.9,null,70.599999999999994,23.5]
[188,125,33,43,null,20,null,60,20]
[189,250,161,181,87.5,null,null,7.8,4.7]
[190,247,117,148,75,null,null,15.6,9.4]
[191,240,61,105,50,null,null,31.3,18.7]
[192,227,13,64,null,null,null,62.5,37.5]
[193,191,18,56,null,3,null,60.6,36.4]
[194,153,31,54,null,11.1,null,55.6,33.299999999999997]
[195,117,41,54,null,27.3,null,45.4,27.3]
[1895,250,189,204,93.8,null,null,3.1,3.1]
[1905,247,153,181,87.4,null,null,6.3,6.3]
[1915,242,84,130,75,null,null,12.5,12.5]
[1925,224,0,71,null,null,null,50,50]
[1935,199,5,64,null,1.6,null,49.2,49.2]
[1945,166,15,56,null,5.8,null,47.1,47.1]
[1955,143,23,54,null,11.2,null,44.4,44.4]
[196,240,199,201,96.9,null,0.8,null,2.2999999999999998]
[197,235,156,168,87.5,null,3.1,null,9.4]
[198,224,79,102,50,null,12.5,null,37.5]
[199,214,28,56,null,null,25,null,75]
[200,186,18,43,null,1.5,24.6,null,73.900000000000006]
[201,156,31,46,null,5.9,23.5,null,70.599999999999994]
[202,135,33,46,null,11.1,22.2,null,66.7]
[203,237,171,194,93.7,null,0.8,null,5.5]
[204,232,122,163,75,null,3.1,null,21.9]
[205,224,69,122,50,null,6.2,null,43.8]
[206,207,5,69,null,null,12.5,null,87.5]
[207,173,3,59,null,3,12.1,null,84.9]
[208,143,33,64,null,11.1,11.1,null,77.8]
[209,117,38,59,null,20,10,null,70]
[210,255,158,194,87.5,null,null,3.1,null,null,null,9.4]
[211,252,122,176,75,null,null,6.3,null,null,null,18.7]
[212,245,74,145,50,null,null,12.5,null,null,null,37.5]
[213,230,8,110,null,null,null,25,null,null,null,75]
[214,204,3,92,null,1.5,null,24.6,null,null,null,73.900000000000006]
[215,168,8,77,null,5.9,null,23.5,null,null,null,70.599999999999994]
[216,122,28,61,null,20,null,20,null,null,null,60]
[217,240,186,212,96.9,null,null,null,3.1]
[218,232,110,173,75,null,null,null,25]
[219,222,31,130,50,null,null,null,50]
[220,168,3,79,null,3,null,null,97]
[221,145,0,69,null,5.9,null,null,94.1]
[222,107,23,59,null,20,null,null,80]

{"sheet":"для бланка","index":2,"n_rows":56,"n_cols":25,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Дата","Заказчик","Название","Тип пакета","цвет супера","Цветность","шир","бок","выс","дон","усил","П/Э","толщ","Вес","За 1кг"," ","Кол-во","Цена","Сумма",null,null,"колво","чистый вес"]
["2017-01-24","Крокус ","Верон","Рукав","белый","1+1",60,null,60,3,"усил","ПВД",50,15,160,null,5000,6.21,{"$f":"Q21*R21","v":31050},103,104,105,104,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2016-03-16","Абак",null,"ВУР","серебро","без печати",40,null,50,4,"усил","ПВД",90,{"$f":"IF(D56=\"рукав\",1000,SUM(IF(K56=\"усил\",\"3\",\"0\"),(PRODUCT(SUM(G56,H56),SUM(I56,J56),M56,SUM(IF(L56=\"ПНД\",\"0,95\",\"0\"),IF(L56=\"ПВД\",\"0,93\",\"0\"),IF(L56=\"ПСД\",\"0,94\",\"0\")),2)/10000)))","v":39.1584},{"$f":"PRODUCT(1000,R56)/N56","v":151.94696412519409},null,3000,5.95,{"$f":"PRODUCT(Q56,R56)","v":17850}]

{"sheet":"бланк","index":3,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Дата",{"$f":"'для бланка'!A21","v":"2017-01-24"},null,null,null,"Заказчик",null,null,null,{"$f":"'для бланка'!B21","v":"Крокус "}]
[null,null,null,null,null,"Название",null,null,null,{"$f":"'для бланка'!C21","v":"Верон"}]
[]
[null,"ширина","бок","высота","дно","количество"]
[{"$f":"'для бланка'!D21","v":"Рукав"},{"$f":"'для бланка'!G21","v":60},{"$f":"'для бланка'!H21","v":0},{"$f":"'для бланка'!I21","v":60},{"$f":"'для бланка'!J21","v":3},{"$f":"'для бланка'!Q21","v":5000},null,null,"вес пакета",{"$f":"'для бланка'!N21","v":15}]
[]
[]
[null,null,null,"экструзия",null,null,null,null,"машинист"]
[]
["р.вес","сырье","мкм",null,"размер",null,null,{"$f":"'для бланка'!E21","v":"белый"}]
[{"$f":"'для бланка'!W21","v":104},{"$f":"'для бланка'!L21","v":"ПВД"},{"$f":"'для бланка'!M21","v":50}]
[null,null,null,null,null,{"$f":"IF(J12=\"без печати\",\"БЕЗ АКТИВАЦИИ\",\"АКТИВАЦИЯ\")","v":"АКТИВАЦИЯ"},null,null,"для",{"$f":"'для бланка'!F21","v":"1+1"}]
[{"$f":"'для бланка'!T21","v":103},null,null,{"$f":"'для бланка'!U21","v":104},null,null,{"$f":"'для бланка'!V21","v":105},null,null,{"$f":"'для бланка'!W21","v":104}]
[]
["Black",1.5,null,"Black",5.9,null,"Black",20,null,"Black",5.9]
["Yellow",98.5,null,"Yellow",94.1,null,"Yellow",80,null,"Yellow",94.1]
[]
[]
[null,null,null,null,null,null,null,null,"печатник"]
[]
[]
[{"$f":"'для бланка'!F21","v":"1+1"}]
[null,null,null,"рубка",null,null,null,null,"рубщик"]
[]
["тип",null,"дно",null,"рубить на ",null,"ДОПОЛНИТЕЛЬНО!!"]
[{"$f":"'для бланка'!D21","v":"Рукав"},null,{"$f":"'для бланка'!J21","v":3}]