{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","Step 1","Step 2","Step 3","Step 4","Step 5","Approval Form FINAL","Plants","Manual Approval Form","Contact","Lookup"],"not_rendered":{"charts":0,"images":137,"macros":1,"external_links":1,"defined_names":10,"comments":4,"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":"Instructions","index":0,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[[12,12,12,37],[13,12,13,37],[1,1,3,48],[8,34,8,39],[8,40,8,45],[8,1,8,3],[10,12,10,37],[8,4,8,9],[8,10,8,15],[8,16,8,21],[8,22,8,27],[8,28,8,33],[27,1,27,48],[20,12,20,37],[19,12,19,37],[14,12,14,37],[15,12,15,37],[16,12,16,37],[17,12,17,37],[18,12,18,37],[21,12,21,37]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Instructions"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Information"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"The packaging data sheet is the official document containing all packaging"]
[null,null,null,null,null,null,null,null,null,null,null,null,"information for every material number. Packaging data sheet is signed by Pierburg"]
[null,null,null,null,null,null,null,null,null,null,null,null,"responsible and supplier responsible before start of serial deliveries. Supplier is not"]
[null,null,null,null,null,null,null,null,null,null,null,null,"allowed to send parts without Pierburg packaging data sheet being approved or"]
[null,null,null,null,null,null,null,null,null,null,null,null,"released by a written form by our Logistics Dept. This document simplifies the"]
[null,null,null,null,null,null,null,null,null,null,null,null,"completion of the packaging data sheet. Follow the next 5 Steps to generate an "]
[null,null,null,null,null,null,null,null,null,null,null,null,"packaging data sheet. As a result, you will receive the print-ready packaging data"]
[null,null,null,null,null,null,null,null,null,null,null,null,"sheet. Please use the Windows operating system to ensure correct functioning."]
[null,null,null,null,null,null,null,null,null,null,null,null,"If technical problems occur with the configurator, please use the manual input file"]
[null,null,null,null,null,null,null,null,null,null,null,null,"at the end of this document."]
[]
[]
[]
[]
[]
[null,"© Pierburg GmbH 2019"]

{"sheet":"Step 1","index":1,"n_rows":28,"n_cols":18,"rows_kept":28,"cut":false,"hidden":false,"merged":[[25,1,26,48],[27,1,27,48],[8,22,8,27],[8,28,8,33],[8,34,8,39],[8,40,8,45],[8,46,8,48],[10,12,10,37],[12,27,12,37],[1,1,3,48],[12,12,12,24],[8,1,8,3],[8,10,8,15],[8,16,8,21]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Pierburg"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Pierburg Contact Details"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Pierburg Plant:"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Step 1'!$AB$13,Plants!A2:F16,2,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Step 1'!$AB$13,Plants!A2:F16,3,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Step 1'!$AB$13,Plants!A2:F16,4,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Step 1'!$AB$13,Plants!A2:F16,5,0),0)","v":0}]
[]
[]
[]
[]
[]
[]
[null,"© Pierburg GmbH 2019"]

{"sheet":"Step 2","index":2,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,3,48],[8,1,8,3],[8,4,8,9],[8,10,8,15],[8,16,8,21],[8,22,8,27],[8,28,8,33],[8,34,8,39],[29,1,30,48],[31,1,31,48],[19,27,19,37],[21,27,21,37],[23,27,23,37],[25,27,25,29],[25,31,25,37],[19,12,19,24],[21,12,21,24],[23,12,23,24],[25,12,25,24],[12,27,12,37],[14,27,14,37],[17,27,17,37],[18,27,18,37],[10,12,10,37],[12,12,12,24],[14,12,14,24],[16,12,16,24],[17,12,17,24],[18,12,18,24]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supplier"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Supplier Contact Details"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Company Name:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Supplier ID:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Supplier - adress:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Street name, House number"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Postcode"]
[null,null,null,null,null,null,null,null,null,null,null,null,"City, Country"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Contact Person:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"E-Mail:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Phone:"]
[]
[]
[]
[]
[]
[null,"© Pierburg GmbH 2019"]

{"sheet":"Step 3","index":3,"n_rows":39,"n_cols":37,"rows_kept":39,"cut":false,"hidden":false,"merged":[[8,34,8,39],[8,40,8,45],[8,22,8,27],[8,28,8,33],[38,1,38,48],[36,1,37,48],[24,12,24,24],[14,27,14,37],[16,27,16,37],[18,27,18,37],[20,27,20,28],[20,30,20,31],[1,1,3,48],[20,33,20,34],[22,27,22,34],[30,27,30,37],[32,27,32,37],[10,12,10,37],[12,27,12,37],[30,12,30,24],[32,12,32,24],[28,12,28,37],[12,12,12,24],[14,12,14,24],[16,12,16,24],[18,12,18,24],[20,12,20,24],[22,12,22,24]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Product Details"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Part Name (Description):"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Pierburg Part Number:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Supplier Part Number:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Version number:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Part Dimensions: (L x W x H)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,"x",null,null,null,"mm"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Part Weight:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"g"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Part Photo:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Further delivery information"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Shipment Mode:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Validity:"]
[]
[]
[]
[]
[]
[null,"© Pierburg GmbH 2019"]

{"sheet":"Step 4","index":4,"n_rows":109,"n_cols":37,"rows_kept":109,"cut":false,"hidden":false,"merged":[[34,27,34,37],[57,27,57,37],[53,27,53,37],[55,27,55,37],[56,27,56,37],[51,12,51,37],[45,12,45,24],[47,12,47,24],[39,12,39,24],[41,12,41,24],[43,12,43,24],[83,27,83,37],[60,27,60,37],[67,27,67,37],[64,27,64,37],[62,27,62,37],[63,27,63,37],[70,27,70,37],[76,27,76,37],[77,27,77,37],[27,27,27,34],[30,27,30,37],[32,27,32,37],[29,12,29,24],[30,12,30,24],[31,12,31,24],[32,12,32,24],[26,27,26,34],[12,27,12,37],[19,27,19,28],[19,30,19,31],[19,33,19,34],[21,27,21,37],[14,27,14,37],[16,27,16,37],[18,27,18,28],[18,30,18,31],[18,33,18,34],[10,12,10,37],[85,27,85,37],[87,27,87,37],[95,27,95,37],[91,12,91,37],[37,27,37,37],[39,27,39,37],[41,27,41,37],[43,27,43,37],[45,27,45,37],[71,27,71,37],[78,27,78,37],[84,27,84,37],[74,27,74,37],[81,27,81,37],[69,27,69,37],[1,1,3,48],[8,4,8,9],[8,10,8,15],[8,16,8,21],[8,22,8,27],[8,28,8,33],[8,34,8,39],[8,40,8,45],[108,1,108,48],[106,1,107,48],[12,12,12,24],[14,12,14,24],[21,12,21,24],[23,12,23,24],[27,12,27,24],[93,27,93,37],[94,27,94,37],[96,27,96,37],[98,27,98,37],[100,27,100,37],[23,27,23,37],[36,27,36,37],[31,27,31,37],[25,27,25,34]]}
[]
[]
[]
[]
[]
[]
[]
[]
[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,"Packing Unit"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Packing Unit Details"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Property?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Container Material:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Type of Container:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Outer Container Dimension: (L x W x H)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Lookup!R21:R36,MATCH(AB17,Lookup!P21:P36,0)),\"\")","v":""},null,"x",{"$f":"IFERROR(INDEX(Lookup!S21:S36,MATCH(AB17,Lookup!P21:P36,0)),\"\")","v":""},null,"x",{"$f":"IFERROR(INDEX(Lookup!T21:T36,MATCH(AB17,Lookup!P21:P36,0)),\"\")","v":""},null,null,"mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Outer Container Dimension:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,"x",null,null,null,"mm"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Returnable?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Board construction:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Container Tare Weight:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kg"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Container Tare Weight:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Lookup!U21:U36,MATCH(AB17,Lookup!P21:P36,0)),0)","v":0},null,null,null,null,null,null,null,null,"kg"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Container est Gross Weight:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AB26=\"\",AB27+(('Step 3'!AB23/1000)*AB33)+IF(AB35=\"Yes\",INDEX(Lookup!AA21:AA37,MATCH('Step 4'!AB37,Lookup!W21:W37,0)),0),AB26+(('Step 3'!AB23/1000)*AB33))","v":0},null,null,null,null,null,null,null,null,"kg"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Inner Pack"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Parts per Layer:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Layers Per Container:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Parts density per packed Unit:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB31*AB32","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Container Cover?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Type of Cover:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Lookup!W20:W36,MATCH(AB17,Lookup!P20:P36,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Type of Cover:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Pack Unit Corrosion Protection:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Bulk Material?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Part orientation required?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"ESD protection required?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Part Photo:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Packing Unit Accessories"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Insert?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Quantity in 1 PU:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Owner?"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Returnable?"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cross pc.?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Quantity in 1 PU:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Owner?"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Returnable?"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Bag?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Quantity in 1 PU:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Owner?"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Returnable?"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Tray?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Quantity in 1 PU:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Owner?"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Returnable?"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Other?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Quantity in 1 PU:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Owner?"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Returnable?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Further description of accessorries:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Information on Packaging Label"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"PB Part Number:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"P\"&'Step 3'!AB15","v":"P"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Eng. Change:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"E\" & 'Step 3'!AB16","v":"E"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Vendor Number:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"V\"&'Step 2'!AB15","v":"V"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Quantity:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Q\"&AB33","v":"Q0"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Manufacturing Lot Number:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Manufacture Date:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Packaging Label Photo:"]
[]
[]
[]
[]
[]
[null,"© Pierburg GmbH 2019"]

{"sheet":"Step 5","index":5,"n_rows":87,"n_cols":40,"rows_kept":87,"cut":false,"hidden":false,"merged":[[64,27,64,37],[66,27,66,37],[46,27,46,37],[53,27,53,37],[12,27,12,37],[28,27,28,34],[14,27,14,37],[22,27,22,37],[48,27,48,37],[49,27,49,37],[55,27,55,37],[25,27,25,37],[27,27,27,34],[8,34,8,39],[8,40,8,45],[1,1,3,48],[33,27,33,37],[29,27,29,34],[32,27,32,37],[16,27,16,28],[16,30,16,31],[16,33,16,34],[18,27,18,28],[18,30,18,31],[18,33,18,34],[10,12,10,37],[20,27,20,37],[8,4,8,9],[24,27,24,37],[8,10,8,15],[8,16,8,21],[8,22,8,27],[8,28,8,33],[72,27,72,37],[70,12,70,37],[34,27,34,37],[50,27,50,37],[57,27,57,37],[63,27,63,37],[60,27,60,37],[56,27,56,37],[62,27,62,37],[44,12,44,37],[36,27,36,37],[38,27,38,37],[74,27,74,37],[76,27,76,37],[78,27,78,37],[86,1,86,48],[73,27,73,37]]}
[]
[]
[]
[]
[]
[]
[]
[]
[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,"Handling Unit"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Handling Unit Details"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Property?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Type of Handling Unit:",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":"IF(AB15=\"Container Only\",\"NOT ACCEPTABLE!\",\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Handling Unit Dimensions: (L x W x H)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AB15=\"\",\"\",INDEX(Lookup!B3:'Lookup'!B15,MATCH(AB15,Lookup!A3:A15,0)))","v":""},null,"x",{"$f":"IF(AB15=\"\",\"\",INDEX(Lookup!C3:C14,MATCH(AB15,Lookup!A3:A15,0)))","v":""},null,"x",null,null,null,"mm"]
[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":"IF(AB15=\"Container Only\",\"NOT ACCEPTABLE\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Handling Unit Dimensions:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,null,"mm"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Returnable?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Pallet Materials:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Static stackability factor:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Transit stackability factor:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gross Weight:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Step 4'!AB28*(AB33*AB34)+AB30+IF(OR(AB49=\"Cover 1208-1\",AB49=\"Cover 1210\"),6,0)","v":0},null,null,null,null,null,null,null,null,"kg"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Net Weight:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB35*('Step 3'!AB23/1000)","v":0},null,null,null,null,null,null,null,null,"kg"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Tare Weight: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Step 5'!AB15=\"\",0,INDEX(Lookup!H3:H15,MATCH('Step 5'!AB15,Lookup!A3:A15,0)))","v":0},null,null,null,null,null,null,null,null,"kg"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Inner pallet"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Container per layer:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Container layers per pallet:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Parts density per shipped Unit:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB34*AB33*'Step 4'!AB33","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Handling Unit Corrosion Protection:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mixed loading valid?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Part Photo:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Handling Unit Accessories"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cover?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Material Nr./ Type:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Owner?"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Returnable?"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fixation band?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Material Nr./ Type:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Owner?"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Returnable?"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Other?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Material Nr./ Type:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Owner?"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Returnable?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Further description of accessorries:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Information on Master Label"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"PB Part Number:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"P\"&'Step 3'!AB15","v":"P"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Vendor Number:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"V\"&'Step 2'!AB15","v":"V"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Quantity:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Q\"&AB35","v":"Q0"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Shipping Lot Number:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ship Date:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Master Label Photo:"]
[]
[]
[]
[]
[]
[null,"© Pierburg GmbH 2019"]

{"sheet":"Approval Form FINAL","index":6,"n_rows":68,"n_cols":17,"rows_kept":68,"cut":false,"hidden":false,"merged":[[8,9,8,11],[13,0,13,2],[9,9,9,11],[17,9,33,14],[16,0,16,6],[20,2,20,4],[20,5,20,6],[21,0,21,1],[33,0,33,6],[13,3,13,6],[13,9,14,11],[14,0,14,2],[14,3,14,6],[21,2,21,4],[21,5,21,6],[23,2,23,4],[23,5,23,6],[17,0,17,4],[19,5,19,6],[20,0,20,1],[16,9,16,14],[22,0,22,1],[22,2,22,4],[5,9,6,11],[0,0,0,14],[2,0,2,6],[2,9,3,9],[2,10,3,11],[2,12,3,13],[2,14,3,14],[3,0,3,2],[3,3,3,6],[4,0,4,2],[4,9,4,11],[4,12,4,14],[5,0,5,2],[5,12,14,14],[6,0,6,1],[7,0,7,1],[8,0,8,6],[10,3,10,6],[10,9,11,11],[11,3,11,6],[7,9,7,11],[10,0,11,2],[12,9,12,11],[7,3,7,6],[35,9,35,14],[36,0,36,4],[37,0,37,2],[38,0,38,1],[38,2,38,4],[30,1,30,2],[30,3,30,4],[18,0,18,2],[19,0,19,1],[19,2,19,4],[35,0,35,6],[32,0,32,4],[32,5,32,6],[52,0,52,6],[38,5,38,6],[39,0,39,1],[39,2,39,4],[52,9,52,14],[53,9,60,14],[4,3,4,6],[5,3,5,6],[6,3,6,6],[24,2,24,4],[25,0,25,2],[25,3,25,4],[26,1,26,2],[29,3,29,4],[22,5,22,6],[23,0,23,1],[9,0,9,2],[9,3,9,6],[26,3,26,4],[27,1,27,2],[28,1,28,2],[29,1,29,2],[12,0,12,2],[12,3,12,6],[44,0,44,1],[44,2,44,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[36,9,50,14],[42,0,42,1],[42,2,42,4],[42,5,42,6],[43,0,43,1],[43,2,43,4],[50,0,50,6],[43,5,43,6],[39,5,39,6],[40,0,40,1],[40,2,40,4],[40,5,40,6],[41,0,41,1],[41,2,41,4],[41,5,41,6],[49,0,49,6],[53,0,53,6],[54,0,54,6],[55,0,55,6],[56,0,56,6],[57,0,57,6],[58,0,58,6],[59,0,59,6],[60,0,60,6],[67,9,67,12],[62,0,62,6],[62,9,62,14],[63,5,63,6],[63,9,65,14],[64,5,64,6]]}
["              Supplier Packaging Approval Form"]
[]
["RECIPIENT- address",null,null,null,null,null,null,null,null,"version:",{"$f":"'Step 3'!AB19","v":0},null,"issue date:",null,{"$f":"TODAY()","v":"2019-04-09"}]
["company name:",null,null,{"$f":"IFERROR(VLOOKUP('Step 1'!$AB$13,Plants!A2:F16,2,0),0)","v":0}]
["company responsible:",null,null,{"$f":"IFERROR(VLOOKUP('Step 1'!$AB$13,Plants!A2:F16,3,0),0)","v":0},null,null,null,null,null,"Pierburg part number",null,null,"Part photo"]
["company address:",null,null,{"$f":"IFERROR(VLOOKUP('Step 1'!$AB$13,Plants!A3:F16,4,0),0)","v":0},null,null,null,null,null,{"$f":"'Step 3'!AB15","v":0}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Step 1'!$AB$13,Plants!A2:F16,5,0),0)","v":0}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('Step 1'!$AB$13,Plants!A2:F16,6,0),0)","v":0},null,null,null,null,null,"Supplier part number"]
["SUPPLIER - address",null,null,null,null,null,null,null,null,{"$f":"'Step 3'!AB17","v":0}]
["company name:",null,null,{"$f":"'Step 2'!AB13","v":0},null,null,null,null,null,"Part name"]
["company address:",null,null,{"$f":"'Step 2'!AB18","v":0},null,null,null,null,null,{"$f":"'Step 3'!AB13","v":0}]
[null,null,null,{"$f":"'Step 2'!AB19&\" \"&'Step 2'!AB20","v":" "}]
["company responsible:",null,null,{"$f":"IF('Step 2'!AB22=\"\",\"\",('Step 2'!AB22&\" \"&\"(\"&\"Phone:\"&'Step 2'!AB26&'Step 2'!AF26&\")\"))","v":""},null,null,null,null,null,"weight (kg)"]
["company contact:",null,null,{"$f":"HYPERLINK(\"mailto:\" & 'Step 2'!AB24 & \"?subject=Supplier Packaging Form For \" & J6 & \" @ \" &D10 & \"&body=\" & D13 & \",%0A%0A\",\"Email: \" & 'Step 2'!AB24)","v":"Email: "},null,null,null,null,null,{"$f":"'Step 3'!AB23/1000","v":0}]
["supplier code:",null,null,{"$f":"'Step 2'!AB15","v":0}]
[]
["Packing unit (PU)",null,null,null,null,null,null,null,null,"Photos / sketches of packaging unit"]
["Packing type",null,null,null,null,"Returnable","Owner"]
[{"$f":"IF('Step 4'!AB15=\"Plastic\",'Step 4'!AB15&\" - \"&'Step 4'!AB17,'Step 4'!AB15)","v":0},null,null,"PG Nr.:",{"$f":"IF('Step 4'!AB17=\"\",\"\",INDEX(Lookup!Y21:Y36,MATCH('Step 4'!AB17,Lookup!P21:P36,0)))","v":""}]
["Size of PU\nL x W x H (mm)\n",null,"Net Weight (Kg)",null,null,"Gross Weight (Kg)"]
[{"$f":"IF('Step 4'!AB15=\"Cardboard\",'Step 4'!AB20&\"x\"&'Step 4'!AE20&\"x\"&'Step 4'!AH20,'Step 4'!AB19&\"x\"&'Step 4'!AE19&\"x\"&'Step 4'!AH19)","v":"xx"},null,{"$f":"'Step 3'!AB23*'Step 4'!AB33/1000","v":0},null,null,{"$f":"'Step 4'!AB28","v":0},null,null,null,null,null,null,null,null,null,null,0]
["Qty of products \nin 1 PU ",null,"Qty of products\nin 1 layer",null,null,"Qty of layers\nin 1 PU"]
[{"$f":"'Step 4'!AB33","v":0},null,{"$f":"'Step 4'!AB31","v":0},null,null,{"$f":"'Step 4'!AB32","v":0}]
["Bulk Material",null,"Part orientation required",null,null,"ESD protection required"]
[]
["Packing accesorries",null,null,"Owner",null,"Returnable","Qty in 1 PU:"]
["insert",null,null,null,null,null,{"$f":"'Step 4'!AB56","v":0}]
["cross pc. insert",null,null,null,null,null,{"$f":"'Step 4'!AB63","v":0}]
["bag",null,null,null,null,null,{"$f":"'Step 4'!AB70","v":0}]
["Tray",null,null,null,null,null,{"$f":"'Step 4'!AB77","v":0}]
["Other",null,null,null,null,null,{"$f":"'Step 4'!AB84","v":0}]
["Comments to packaging unit: (e.g. description of accessorries)"]
[{"$f":"IF('Step 4'!AB40=\"\",\"\",\"Pack Unit Corrosion Protection:\"&\" \"&'Step 4'!AB40)","v":""},null,null,null,null,{"$f":"IF('Step 4'!AB37=\"\",'Step 4'!AB38,'Step 4'!AB37)&\" \"&INDEX(Lookup!Z21:Z36,MATCH('Step 4'!AB37,Lookup!W21:W36,0))","v":{"$error":"#N/A"}}]
[{"$f":"'Step 4'!AB88","v":0}]
[]
["Handling unit (HU) ",null,null,null,null,null,null,null,null,"Photos / sketches of handling unit"]
["Shipping Unit Type:",null,null,null,null,"Returnable","Owner",null,null,"."]
[{"$f":"'Step 5'!AB15&\" \"&\"(\"&'Step 5'!AB23&\")\"","v":" ()"},null,null,"PG Nr.:",{"$f":"IF('Step 5'!AB15=\"\",\"\",INDEX(Lookup!Z39:Z51,MATCH('Step 5'!AB15,Lookup!P39:P51,0)))","v":""}]
["Size of SU\nL x W x H (mm)\n",null,"Net Weight (Kg)",null,null,"Gross Weight (Kg)"]
[{"$f":"IF(OR('Step 5'!AB15=\"Returnable Skid\",'Step 5'!AB15=\"Wooden Crate\",'Step 5'!AB15=\"Non-Standard\"),'Step 5'!AB19&\"x\"&'Step 5'!AE19&\"x\"&'Step 5'!AH19,'Step 5'!AB17&\"x\"&'Step 5'!AE17&\"x\"&'Step 5'!AH17)","v":"xx"},null,{"$f":"'Step 5'!AB29","v":0},null,null,{"$f":"'Step 5'!AB28","v":0}]
["Qty of products \nin 1 HU ",null,"Qty of products\nin 1 layer",null,null,"Max. qty of PU layers\nin 1HU"]
[{"$f":"'Step 5'!AB35","v":0},null,{"$f":"'Step 5'!$AB$33*'Approval Form FINAL'!A23","v":0},null,null,{"$f":"'Step 5'!AB34","v":0}]
["Mixed loading valid",null,"Up load weight (kg)",null,null,"Stackability factor"]
[null,null,{"$f":"F40*F44","v":0},null,null,{"$f":"'Step 5'!AB26","v":0}]
["Packing accessories",null,"Material Nr./ Type",null,null,"Owner","Returnable"]
["cover",null,{"$f":"IF('Step 5'!AB49=\"1208-1\",'Step 5'!AB49&\"99999\",'Step 5'!AB49)","v":0}]
["fixation band",null,{"$f":"'Step 5'!AB56","v":0}]
["Other",null,{"$f":"'Step 5'!AB63","v":0}]
["Comments to packaging unit: (e.g. description of accessorries)"]
[{"$f":"IF('Step 5'!AB37=\"\",\"\",\"Shipping Unit Corrosion Protection:\"&\" \"&'Step 5'!AB37)","v":""}]
[{"$f":"'Step 5'!AB67","v":0}]
[]
["Additional Agreements (e.g. incoterms)",null,null,null,null,null,null,null,null,"Photo of Labels"]
[{"$f":"IF('Step 3'!AB31=\"\",\"\",\"Shipment Mode:\" & \" \" & 'Step 3'!AB31)","v":""}]
[{"$f":"IF('Step 3'!AB33=\"\",\"\",\"Validity:\" & \" \" & 'Step 3'!AB33)","v":""}]
[{"$f":"IF('Step 5'!AB77&'Step 5'!AB79=\"\",\"\",\"Shipping Lot Number:\"&\" \"&'Step 5'!AB77&\"     \"&\"Ship Date\"&\" \"&'Step 5'!AB79)","v":""}]
[{"$f":"IF('Step 4'!AB99&'Step 4'!AB101=\"\",\"\",\"Manufacturing Lot Number:\"&\" \"&'Step 4'!AB99&\"     \"&\"Manufacture Date\"&\" \"&'Step 4'!AB101)","v":""}]
[]
[]
[]
[]
[]
["PIERBURG ACCEPTANCE",null,null,null,null,null,null,null,null,"SUPPLIER ACCEPTANCE"]
[{"$f":"IF('Step 1'!AB13=\"US - Fountain Inn\",\"SQD signature:\",\"Company Stamp:\")","v":"Company Stamp:"},null,null,{"$f":"IF('Step 1'!AB13=\"US - Fountain Inn\",\"PE signature:\",\"\")","v":""},null,{"$f":"IF('Step 1'!AB13=\"US - Fountain Inn\",\"PS signature:\",\"\")","v":""},null,null,null,"Company Stamp:"]
[]
[]
[]
[null,{"$f":"IF('Step 1'!AB13=\"US - Fountain Inn\",\"Company Stamp:\",\"signature:\")","v":"signature:"},null,null,null,"Date:",null,null,null,"signature",null,null,null,null,"date"]

{"sheet":"Plants","index":7,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":true,"merged":[[0,3,0,5]]}
["Plant","Company","Responsible","Adress"]
[]
["DE - Niederrhein","Pierburg GmbH","Mr. Olaf Settels","Industriestr. 43","DE - 41460 Neuss"]
["DE - Berlin","Pierburg GmbH","Ms. Andrea Senst","Scheringstr. 2","DE - 13355 Berlin"]
["DE - Hartha","Pierburg Pump Technology GmbH","Mr. Lars Bauer","Sonnenstraße 29","DE - 04746 Hartha"]
["CZ - Ùsti nad Labem","Pierburg s.r.o.","Mr. Milan Boháček","K Pierburgu 1","CZ - 40001 ÚSTI nad Labem"]
["FR - Thionville","Pierburg Pump Technology France S.à.r.l. ","Ms. Sophie Martin","1 rue Denis Papin","FR - 57970 Basse-Ham","Thionville"]
["ES - Abadiano","Pierburg S.A.","Mr. Juan Mari Gallano","Barrio de Matiena","ES -  48220 Abadiano","Vizcaya"]
["IT - Livorno","Pierburg Pump Technology Italy S.p.A.","Mr. Salvatore D' Amico ","Via Salvatore Orlando, 12","IT - 57123 Livorno"]
["US - Fountain Inn","Pierburg US, LLC","Mr. Nicholas Eubanks","5 Southchase Court","US - 29644 Fountain Inn","South Carolina"]
["MX - Celaya","Pierburg Pump Technology México S.A.","Ms. Adriana Cortes","Av Aeropuerto 61","MX - 38110  Guanajuato","Celaya"]
["BR - Nova Odessa","KSPG Automotive Brazil Ltda. - PPT","Mr. André Andreoti","Rod. Arnaldo Júlio Mauerberg 4000","BR - 13460-000 Bairro da Lagoa","Nova Odessa - SP"]
["CN - Pierburg Huayu Co. Ltd.","Pierburg Huayu Pump Technology Co. Ltd .","Mr. Henry Lu","No.689 Jinhong Rd., Yuepu Indust. Park","CN - 200941 Shanghai","Baoshan District"]
["CN - Kunshan","Pierburg China Ltd.","Mr. Junming Wang","Building F, No. 299 Yuyang Road","CN - 215300 Kunshan","Jiangsu Province"]
["CN - Pierburg Mikuni Corp.","Pierburg Mikuni Pump Technology Corp.","Mr. Crespo Hu","No. 393 Wangqiao Road","CN - 201203 Shanghai","Pudong new area"]
["IN - Pune","KSPG Automotive India Private Ltd. - PG ","Mr. Harshal Bhide","Gat. No. 380, Village Takwe Budruk","IN - 412106 Pune - Maharashtra","Taluka Vadgoan Maval"]

{"sheet":"Manual Approval Form","index":8,"n_rows":68,"n_cols":17,"rows_kept":68,"cut":false,"hidden":false,"merged":[[7,9,7,11],[4,3,4,6],[4,9,4,11],[4,12,4,14],[5,0,5,2],[5,3,5,6],[5,9,6,11],[4,0,4,2],[0,0,0,14],[2,0,2,6],[2,9,3,9],[2,10,3,11],[2,12,3,13],[2,14,3,14],[3,0,3,2],[3,3,3,6],[13,0,13,2],[13,3,13,6],[13,9,14,11],[14,0,14,2],[14,3,14,6],[16,0,16,6],[16,9,16,14],[10,0,11,2],[10,3,10,6],[10,9,11,11],[11,3,11,6],[12,0,12,2],[12,3,12,6],[12,9,12,11],[5,12,14,14],[6,0,6,1],[6,3,6,6],[8,0,8,6],[8,9,8,11],[9,0,9,2],[9,3,9,6],[9,9,9,11],[7,0,7,1],[7,3,7,6],[21,2,21,4],[21,5,21,6],[22,0,22,1],[22,2,22,4],[22,5,22,6],[23,0,23,1],[23,2,23,4],[23,5,23,6],[17,0,17,4],[18,0,18,2],[19,0,19,1],[19,2,19,4],[19,5,19,6],[20,0,20,1],[20,2,20,4],[20,5,20,6],[21,0,21,1],[28,1,28,2],[29,1,29,2],[29,3,29,4],[30,1,30,2],[30,3,30,4],[32,0,32,4],[24,2,24,4],[25,0,25,2],[25,3,25,4],[26,1,26,2],[26,3,26,4],[27,1,27,2],[32,5,32,6],[33,0,33,6],[35,0,35,6],[35,9,35,14],[36,0,36,4],[36,9,50,14],[37,0,37,2],[38,0,38,1],[38,2,38,4],[38,5,38,6],[17,9,33,14],[41,0,41,1],[41,2,41,4],[41,5,41,6],[42,0,42,1],[42,2,42,4],[42,5,42,6],[39,0,39,1],[39,2,39,4],[39,5,39,6],[40,0,40,1],[40,2,40,4],[40,5,40,6],[46,2,46,4],[47,2,47,4],[49,0,49,6],[50,0,50,6],[52,0,52,6],[52,9,52,14],[43,0,43,1],[43,2,43,4],[43,5,43,6],[44,0,44,1],[44,2,44,4],[45,2,45,4],[62,0,62,6],[62,9,62,14],[63,5,63,6],[63,9,65,14],[67,9,67,12],[53,0,53,6],[53,9,60,14],[54,0,54,6],[55,0,55,6],[56,0,56,6],[57,0,57,6],[58,0,58,6],[59,0,59,6],[60,0,60,6]]}
["              Supplier Packaging Approval Form"]
[]
["RECIPIENT- address",null,null,null,null,null,null,null,null,"version:",null,null,"issue date:",null,{"$f":"TODAY()","v":"2019-04-09"}]
["company name:"]
["company responsible:",null,null,null,null,null,null,null,null,"Pierburg part number",null,null,"Part photo"]
["company address:"]
[]
[null,null,null,null,null,null,null,null,null,"Supplier part number"]
["SUPPLIER - address"]
["company name:",null,null,null,null,null,null,null,null,"Part name"]
["company address:"]
[]
["company responsible:",null,null,null,null,null,null,null,null,"weight (kg)"]
["company contact:"]
["supplier code:"]
[]
["Packing unit (PU)",null,null,null,null,null,null,null,null,"Photos / sketches of packaging unit"]
["Packing type",null,null,null,null,"Returnable","Owner"]
[null,null,null,"PG Nr.:"]
["Size of PU\nL x W x H (mm)\n",null,"Net Weight (Kg)",null,null,"Gross Weight (Kg)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Qty of products \nin 1 PU ",null,"Qty of products\nin 1 layer",null,null,"Qty of layers\nin 1 PU"]
[]
["Bulk Material",null,"Part orientation required",null,null,"ESD protection required"]
[]
["Packing accesorries",null,null,"Owner",null,"Returnable","Qty in 1 PU:"]
["insert",null,null,null,null,null,0]
["cross pc. insert",null,null,null,null,null,0]
["bag",null,null,null,null,null,0]
["Tray",null,null,null,null,null,0]
["Other",null,null,null,null,null,0]
["Comments to packaging unit: (e.g. description of accessorries)"]
[]
[]
[]
["Handling unit (HU) ",null,null,null,null,null,null,null,null,"Photos / sketches of handling unit"]
["Shipping Unit Type:",null,null,null,null,"Returnable","Owner"]
[null,null,null,"PG Nr.:"]
["Size of SU\nL x W x H (mm)\n",null,"Net Weight (Kg)",null,null,"Gross Weight (Kg)"]
[]
["Qty of products \nin 1 HU ",null,"Qty of products\nin 1 layer",null,null,"Max. qty of PU layers\nin 1HU"]
[]
["Mixed loading valid",null,"Up load weight (kg)",null,null,"Stackability factor"]
[]
["Packing accessories",null,"Material Nr./ Type",null,null,"Owner","Returnable"]
["cover"]
["fixation band"]
["Other"]
["Comments to packaging unit: (e.g. description of accessorries)"]
[]
[]
[]
["Additional Agreements (e.g. incoterms)",null,null,null,null,null,null,null,null,"Photo of Labels"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PIERBURG ACCEPTANCE",null,null,null,null,null,null,null,null,"SUPPLIER ACCEPTANCE"]
["Company Stamp:",null,null,null,null,null,null,null,null,"Company Stamp:"]
[]
[]
[]
[null,"signature:",null,null,null,"Date:",null,null,null,"signature",null,null,null,null,"date"]

{"sheet":"Contact","index":9,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[[10,12,10,37],[1,1,3,48],[8,1,8,3],[8,4,8,9],[8,10,8,15],[8,16,8,21],[8,22,8,27],[8,28,8,33],[8,34,8,39],[8,40,8,45],[15,12,15,37],[16,12,16,37],[19,12,19,37],[21,12,21,37],[28,1,28,48]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Contact Central Logistics Department"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Stephan Kohlbaum"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Director Central Logistics"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Division Mechatronics"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fon: +49 (0)2131 520 3409"]
[null,null,null,null,null,null,null,null,null,null,null,null,"E-mail: stephan.kohlbaum@de.rheinmetall.com"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Stefan Kosiedowski"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Senior Manager Central Logistics Processes"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Division Mechatronics"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fon: +49 (0)2131 520 2342  "]
[null,null,null,null,null,null,null,null,null,null,null,null,"E-mail: stefan.kosiedowski@de.rheinmetall.com "]
[]
[]
[]
[]
[]
[null,"© Pierburg GmbH 2019"]

{"sheet":"Lookup","index":10,"n_rows":51,"n_cols":27,"rows_kept":51,"cut":false,"hidden":true,"merged":[[0,3,0,4],[0,5,0,6]]}
["Pallet:",null,null,"MM",null,"IN",null,"wgt(kg)",null,"Shipping Unit"]
[null,null,null,1140,980,{"$f":"ROUND(D2/25.4,2)","v":44.88},{"$f":"ROUND(E2/25.4,2)","v":38.58},null,null,"Container Only",null,null,"Plastic",{"$f":"M2","v":"Plastic"}]
["IMCk160/980STD",{"$f":"D2","v":1140},980,1220,{"$f":"ROUND(G3*25.4,0)","v":1016},48,40,9,null,"Pallet",null,null,"Cardboard","ISPM-15 Wood"]
["GMA",{"$f":"D3","v":1220},1016,1220,{"$f":"G4*25.4","v":1143},48,45,8,null,"Crate"]
["Export",{"$f":"D4","v":1220},1143,1200,1000,null,null,12,null,"Other"]
["Industrial",1200,1000,1200,800,{"$f":"ROUND(D6/25.4,2)","v":47.24},{"$f":"ROUND(E6/25.4,2)","v":31.5},35]
["Euro",{"$f":"D6","v":1200},800,600,800,{"$f":"ROUND(D7/25.4,2)","v":23.62},{"$f":"ROUND(E7/25.4,2)","v":31.5},28]
["1/2 Euro",{"$f":"D7","v":600},800,null,null,null,null,14]
["KTP Box Euro",1175,776,null,null,null,null,45]
["KTP Box 1/2 Euro",745,546,null,null,null,null,17,"No protection"]
["Returnable Skid","ENTER DIMENSIONS BELOW",null,"ISPM-15 SoftWood","Wooden Crate",null,null,null,"VCI bag",null,"Standard Single Wall","32ECT",40,"200#","B"]
["Wooden Crate","ENTER DIMENSIONS BELOW",null,"ISPM-15 HardWood","Plastic Knockdown",null,null,null,"VCI Emitter",null,"Medium Duty Single Wall","42ECT",55,"200#","C"]
["Non-Standard","ENTER DIMENSIONS BELOW",null,"ISPM-15 Mixed Materials","Metal Rack",null,null,null,"VCI paper",null,"Heavy Duty Single Wall","44ECT",65,"275#","C"]
["Grid Box",1240,835,"Plywood","Container Only",null,null,85,"VCI Film",null,"Heavy Duty Double Wall","48ECT",80,"275#","CB"]
["Container Only","NOT APPLICABLE",null,"Plastic","Pallet",null,null,null,"Desiccants"]
[null,null,null,"Metal"]
[]
["Monthly",30,null,null,null,null,null,null,null,null,null,null,null,null,null,"KLT"]
["3 / Month",{"$f":"30/1.333","v":22.50562640660165},null,null,null,null,null,null,null,null,"HU Cover","Weight","Fixaton band",null,null,null,null,null,null,null,null,null,null,null,"PB KLT Nr.","PB Deckel Nr.","Cover "]
["Bi-Weekly",10,null,null,null,null,"NOT",{"$f":"'Step 5'!AB19&\"x\"&'Step 5'!AE19&\"x\"&'Step 5'!AH19","v":"xx"},null,null,null,null,null,null,null,"---European Standard Container---",null,null,null,null,null,null,null,null,null,null,"weight"]
["Weekly",5,null,null,null,null,"STAND",{"$f":"'Step 5'!AB17&\"x\"&'Step 5'!AE17&\"x\"&'Step 5'!AH17","v":"xx"},null,null,"Cover 1208-1",6,"Textile",null,null,"VDA RL-KLT 3147",null,300,200,147,0.56999999999999995,null,"Cover D35",null,"9.00908.17.0","9.00155.77.0",0.2]
["2 / week",{"$f":"5/2","v":2.5},null,null,null,null,null,null,null,null,"Cover 1210",6,"Steel",null,null,"VDA RL-KLT 4147",null,400,300,147,1.08,null,"Cover D45 (D41)",null,"9.00908.14.0","9.00151.35.0",0.4]
["3 / week",{"$f":"5/3","v":1.6666666666666667},null,null,null,null,null,null,null,null,null,null,"Plastic (PP, PET)",null,null,"VDA RL-KLT 4280",null,400,300,280,1.7,null,"Cover D45 (D41)",null,"9.00908.15.0","9.00151.35.0",0.4]
["4 / week",{"$f":"5/4","v":1.25},null,null,14.7,null,null,null,null,null,null,null,null,null,null,"VDA RL-KLT 6147",null,600,400,147,1.82,null,"Cover D65 (D61)",null,"9.00908.15.0",null,0.7]
["Daily",1,null,null,14.7,null,null,null,null,null,null,null,null,null,null,"VDA RL-KLT 6280",null,600,400,280,2.67,null,"Cover D65 (D61)",null,"9.00908.13.0",null,0.7]
[null,null,null,null,680,null,null,null,null,null,null,null,null,null,null,"VDA C-KLT 3214",null,300,200,147,0.7,null,"Cover D32",null,"9.00908.07.0",null,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VDA C-KLT 4314",null,400,300,147,1.63,null,"Cover D43",null,"9.00908.06.0",null,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VDA C-KLT 6414",null,600,400,147,2.8,null,"Cover D64",null,"9.00908.04.0","9.00903.08.0",0.6]
["Supplier","Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,"Galia 3212",null,300,200,114,0.6,null,"Cover 32",null,null,null,0.1]
["Pierburg","No",null,null,null,null,null,null,null,null,null,null,null,null,null,"Galia 4312",null,400,300,114,0.9,null,"Cover 43",null,"9.00142.77.0",null,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Galia 4322",null,400,300,214,1.54,null,"Cover 43",null,"9.00402.01.0",null,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Galia 6422",null,600,400,214,2.4,null,"Cover 64",null,"9.00330.03.0",null,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Galia 6432",null,600,400,314,3,null,"Cover 64",null,null,null,0.6]
["Sea","Standard",null,null,null,null,null,null,null,null,null,null,null,null,null,"Galia P 6432",null,600,400,314,2.95,null,"Cover 64",null,null,null,0.6]
["Road ","Alternative",null,null,null,null,null,null,null,null,null,null,null,null,null,"Galia P 6423",null,600,400,214,2.4,null,"Cover 64",null,null,null,0.6]
["Railway","Temporary",null,null,null,null,null,null,null,null,null,null,null,null,null,"Galia P 4323",null,400,300,214,1.55,null,"Cover 43",null,null,null,0.2]
["Air",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",null,null,null,null,null,null,"Other"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IMCk160/980STD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GMA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Export"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrial"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2 Euro","9.00903.03.0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KTP Box Euro",null,null,null,null,null,null,null,null,null,"9.00155.41.0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KTP Box 1/2 Euro",null,null,null,null,null,null,null,null,null,"9.00165.41.0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Returnable Skid"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wooden Crate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-Standard"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grid Box"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Container Only"]