{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Всеволожск (3)","label","data","idh_list","plant","delivery","Лист3"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":3,"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":"Всеволожск (3)","index":0,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":true,"merged":[[8,1,8,6],[9,1,9,9],[10,10,12,10],[11,6,12,9],[14,3,14,4],[14,7,15,10],[15,1,17,5],[0,1,0,3],[1,0,1,4],[1,5,1,9],[2,3,4,4],[5,1,7,2],[6,3,7,4],[7,5,7,6]]}
["SUPP(V)","Henkel Rus"]
[{"$f":"\"*V\"&F2&\"*\"","v":"*VGPZ0A*"},null,null,null,null,"GPZ0A"]
["QTY(Q)",null,null,532,null,"CONTAINER"]
[]
[null,null,null,null,null,"GROSS WGT"]
[null,{"$f":"\"*Q\"&D3&\"*\"","v":"*Q532*"},null,null,null,767.67600000000004,"KG"]
[null,null,null,"KG",null,"DATE"]
[null,null,null,null,null,"2015-12-07"]
[null,"WSKM4G334A3"]
["PART(P)",{"$f":"\"*P\"&B9&\"*\"","v":"*PWSKM4G334A3*"}]
["STR LOC1",null,null,null,null,null,"DELIVERY DOC/ASN NUMBER",null,null,null,{"$f":"\"*N\"&G12&\"*\"","v":"*N44444908*"}]
[null,null,null,null,null,null,44444908]
["NEW"]
["WSKM4G334A3 TEROSON PV 4220-26"]
["SERIAL NO(S)",null,null,"GPZ0A0001",null,null,null,"AVF7A"]
[null,{"$f":"\"*S\"&D15&\"*\"","v":"*SGPZ0A0001*"}]

{"sheet":"label","index":1,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[43,0,43,1],[44,6,44,8],[46,3,46,5],[47,10,48,12],[47,13,48,13],[48,5,49,8],[40,13,42,13],[41,9,42,12],[20,3,20,5],[17,0,17,1],[18,6,18,8],[21,10,22,12],[21,13,22,13],[26,6,27,11],[22,5,23,8],[28,3,32,5],[31,6,32,8],[34,5,35,5],[34,6,35,9],[36,0,37,9],[15,9,16,12],[14,13,16,13],[10,0,11,9],[8,5,9,5],[0,6,1,11],[5,6,6,8],[2,3,6,5],[8,6,9,9]]}
["SUPP(V)",null,null,null,{"$f":"\"V\"&G1&\"\"","v":"V123Ф"},null,"123Ф",null,null,null,null,null,"MASTER LABEL"]
[]
["QTY(Q)",null,null,1400,null,null,"CONTAINER",null,null,null,null,null,null,{"$f":"\"\"&M12&\"_\"&B7&\"_\"&K9&\"_\"&N20&\"_\"&E18&\"_\"&K6&\"_\"&G21&\"_\"\"\"","v":"Pmaterial8_Q1400_D160311_8VФАПР_SRR60690190_TRR60690190_15D190222_\""}]
[null,null,null,null,null,null,null,null,null,null,"LOT\\BATCH"]
[null,null,null,null,null,null,"GROSS WGT",null,null,null,"RR60690190"]
[null,null,null,null,null,null,{"$f":"VLOOKUP(A18,idh_list!A:H,8,0)*D3","v":1461.6000000000001},null,null,null,{"$f":"\"T\"&K5&\"\"","v":"TRR60690190"}]
[null,{"$f":"\"Q\"&D3&\"\"","v":"Q1400"},null,null,null,null,null,null,null,"KG"]
[null,null,null,null,null,null,"DATE"]
[null,null,null,null,null,"KG",{"$f":"TODAY()","v":"2016-03-21"},null,null,null,"D160311"]
[]
[{"$f":"VLOOKUP(A18,idh_list!A:H,4,0)","v":"material8"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"P\"&A11&\"\"","v":"Pmaterial8"}]
[]
["PART(P)"]
["STR LOC1",null,null,null,null,null,null,null,"DELIVERY DOC/ASN NUMBER"]
[]
[]
[1719051,null,null,null,{"$f":"\"S\"&D21&\"\"","v":"SRR60690190"},null,null,null,"EXP.DATE","TO",null,null,null,"DOCK CODE"]
[{"$f":"CONCATENATE(VLOOKUP(A18,idh_list!A:H,4,0),VLOOKUP(A18,idh_list!A:H,2,0))","v":"material8material8"},null,null,null,null,null,"2019-02-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"8V\"&K22&\"\"","v":"8VФАПР"}]
["SERIAL NO(S)",null,null,"RR60690190",null,null,"15D190222",null,null,null,null,"CUST"]
[null,null,null,null,null,null,null,null,null,null,"ФАПР",null,null,12]
[null,null,null,null,null,"MASTER LABEL"]
[]
[]
[]
["SUPP(V)",null,null,null,{"$f":"\"V\"&G27&\"\"","v":"V123Ф"},null,"123Ф",null,null,null,null,null,"MASTER LABEL"]
[]
["QTY(Q)",null,null,1400,null,null,"CONTAINER",null,null,null,null,null,null,{"$f":"\"\"&M38&\"_\"&B33&\"_\"&K35&\"_\"&N46&\"_\"&E44&\"_\"&K32&\"_\"&G47&\"_\"\"\"","v":"Pmaterial8_Q1400_D160311_8VФАПР_SRR60690190_TRR60690190_15D190222_\""}]
[null,null,null,null,null,null,null,null,null,null,"LOT\\BATCH"]
[null,null,null,null,null,null,"GROSS WGT",null,null,null,"RR60690190"]
[null,null,null,null,null,null,{"$f":"VLOOKUP(A18,idh_list!A:H,8,0)*D29","v":1461.6000000000001},null,null,null,{"$f":"\"T\"&K31&\"\"","v":"TRR60690190"}]
[null,{"$f":"\"Q\"&D29&\"\"","v":"Q1400"},null,null,null,null,null,null,null,"KG"]
[null,null,null,null,null,null,"DATE"]
[null,null,null,null,null,"KG",{"$f":"TODAY()","v":"2016-03-21"},null,null,null,"D160311"]
[]
[{"$f":"VLOOKUP(A44,idh_list!A:H,4,0)","v":"material8"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"P\"&A37&\"\"","v":"Pmaterial8"}]
[]
["PART(P)"]
["STR LOC1",null,null,null,null,null,null,null,"DELIVERY DOC/ASN NUMBER"]
[]
[]
[1719051,null,null,null,{"$f":"\"S\"&D47&\"\"","v":"SRR60690190"},null,null,null,"EXP.DATE","TO",null,null,null,"DOCK CODE"]
[{"$f":"CONCATENATE(VLOOKUP(A44,idh_list!A:H,4,0),VLOOKUP(A44,idh_list!A:H,2,0))","v":"material8material8"},null,null,null,null,null,"2019-02-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"8V\"&K48&\"\"","v":"8VФАПР"}]
["SERIAL NO(S)",null,null,"RR60690190",null,null,"15D190222",null,null,null,null,"CUST"]
[null,null,null,null,null,null,null,null,null,null,"ФАПР",null,null,12]
[null,null,null,null,null,"MASTER LABEL"]

{"sheet":"data","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"idh_list","index":3,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["idh"]
["4445222","material1",null,"material1",null,null,null,1.4430000000000001]
["123462","material2",null,"material2",null,null,null,1.083]
[1245633,"material3",null,"material3",null,null,null,1.05]
["1855622","material4",null,"material4",null,null,null,1.046]
["56632","material5",null,"material5",null,null,null,1.0640000000000001]
[26633,"material6",null,"material6",null,null,null,1.0429999999999999]
["2666","material7",null,"material7",null,null,null,1.0289999999999999]
[1719051,"material8",null,"material8",null,null,null,1.044]

{"sheet":"plant","index":4,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["plant"]
["ФАПР1"]
["ФАПР2"]
["ВАПр5"]

{"sheet":"delivery","index":5,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Delivery","Ship-to party","Description","Material","Batch","Delivery quantity",null,"кол-во этикеток",null,null,null,"Name of the ship-to party"]
["8006304106","815854","Терозон PV 4220-26/11 DR266KG RU",1605736,"RR60250021",6384,{"$f":"VLOOKUP(D2,idh_list!A:H,7,0)","v":{"$error":"#N/A"}},{"$f":"F2/G2","v":{"$error":"#N/A"}},{"$f":"INT(H2)","v":{"$error":"#N/A"}},{"$f":"MOD(H2,SIGN(H2))","v":{"$error":"#N/A"}},{"$f":"J2*G2","v":{"$error":"#N/A"}},"OOO BASF Vostok"]
["8006304106","815854","Терозон PV 4220-26 DR266KG RU",761601,"RR60140015",5320,{"$f":"VLOOKUP(D3,idh_list!A:H,7,0)","v":{"$error":"#N/A"}},{"$f":"F3/G3","v":{"$error":"#N/A"}},{"$f":"INT(H3)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"J3*G3","v":{"$error":"#N/A"}},"OOO BASF Vostok"]
["8006304106","815854","Терозон PV 4220-26 DR266KG RU",761601,"RR60430033",2394,{"$f":"VLOOKUP(D4,idh_list!A:H,7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"OOO BASF Vostok"]
["8006304106","815854","Терозон PV 4220-26/11 DR266KG RU",1605736,"RR60490038",1330,{"$f":"VLOOKUP(D5,idh_list!A:H,7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"OOO BASF Vostok"]
["8006304106","815854","Терозон PV 4220-26 DR266KG RU",761601,"RR52880215",266,{"$f":"VLOOKUP(D6,idh_list!A:H,7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"MOD(H6,SIGN(H6))","v":{"$error":"#N/A"}},{"$error":"#N/A"},"OOO BASF Vostok"]

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