{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Cover sheet","Supplier Packaging Information","ReturnableCalc","LogDataSheet","Container Rightsizing Tool","Change History","Supplier Packaging Info Old"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":13,"defined_names":189,"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":"Cover sheet","index":0,"n_rows":52,"n_cols":6,"rows_kept":52,"cut":false,"hidden":false,"merged":[[34,0,34,7],[35,0,35,7],[39,0,39,7],[50,0,50,7],[51,0,51,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Annex 1-2:"]
["Supplier Packaging Information"]
[]
[]
[]
["Revision 1.0"]
[]
[]
[]
["Publisher:"]
[]
["Christian Matzanke",null,null,null,null,"Gian Franco Buscemi"]
["Global Logistics Director",null,null,null,null,"Vice President Purchasing"]
[]
[]
[]
["This document is the property of TriStone Flowtech. Its reproduction or transfer to third parties is strictly prohibited, as is its partial "]
["or total use, in any way, for purposes other than those for which it was drafted. Failure to comply with the above may lead to prosecution."]

{"sheet":"Supplier Packaging Information","index":1,"n_rows":89,"n_cols":92,"rows_kept":89,"cut":false,"hidden":false,"merged":[[0,0,0,2],[4,0,4,18],[77,3,77,11],[78,7,78,18],[78,0,78,5],[77,12,77,18],[76,12,76,18],[70,16,70,17],[22,0,22,18],[29,5,29,6],[29,16,29,17],[25,0,25,2],[28,16,28,17],[26,3,26,4],[23,11,24,12],[27,16,27,17],[27,9,27,10],[27,0,27,2],[23,13,24,13],[23,3,24,4],[23,5,24,6],[75,16,75,17],[74,16,74,17],[74,11,74,12],[28,5,28,6],[23,16,24,17],[28,0,28,2],[82,0,82,6],[83,0,84,6],[76,3,76,11],[79,0,79,6],[79,7,79,13],[79,14,79,18],[76,0,77,2],[23,7,23,10],[23,14,24,14],[26,1,26,2],[23,1,23,2],[24,1,24,2],[29,0,29,2],[29,3,29,4],[40,7,42,10],[40,3,40,6],[29,11,29,12],[29,9,29,10],[73,0,73,14],[70,0,70,2],[72,3,72,6],[72,9,72,10],[72,11,72,12],[72,16,72,17],[70,3,70,6],[73,15,73,17],[71,0,71,2],[71,3,71,6],[71,9,71,10],[71,11,71,12],[71,16,71,17],[72,0,72,2],[69,3,69,6],[69,0,69,2],[89,0,91,6],[89,7,91,13],[89,14,91,18],[74,7,74,10],[86,0,87,6],[82,7,82,13],[85,7,85,13],[80,14,81,18],[82,14,82,18],[83,14,84,18],[85,14,85,18],[86,14,87,18],[80,7,81,13],[83,7,84,13],[85,0,85,6],[80,0,81,6],[75,7,75,10],[74,1,74,2],[74,3,74,6],[88,16,88,18],[75,11,75,12],[75,3,75,6],[30,5,30,6],[30,11,30,12],[30,16,30,17],[30,0,30,2],[30,9,30,10],[32,5,32,6],[31,0,31,2],[33,0,33,2],[31,11,31,12],[31,5,31,6],[32,16,32,17],[32,3,32,4],[31,9,31,10],[36,9,36,10],[35,3,35,6],[38,11,38,12],[38,3,38,6],[47,6,47,13],[52,12,52,18],[48,14,48,18],[43,11,43,12],[47,14,47,18],[44,3,44,11],[45,3,45,11],[43,7,43,10],[41,3,41,6],[35,9,35,10],[35,16,35,17],[39,0,39,14],[39,15,39,17],[57,1,57,2],[58,1,58,2],[45,12,45,18],[40,18,42,18],[46,0,46,18],[40,13,42,13],[40,11,42,12],[37,0,37,2],[38,0,38,2],[55,4,55,11],[47,0,47,5],[51,0,51,2],[51,4,51,11],[52,0,52,2],[52,4,52,11],[40,16,42,17],[40,15,42,15],[40,14,42,14],[48,6,48,13],[49,0,49,2],[49,3,49,5],[48,0,48,5],[50,0,50,18],[44,12,44,18],[26,11,26,12],[36,0,36,2],[43,16,43,17],[32,11,32,12],[36,3,36,6],[38,9,38,10],[37,3,37,6],[37,9,37,10],[34,0,34,18],[33,3,33,4],[33,5,33,6],[35,0,35,2],[36,11,36,12],[35,11,35,12],[30,3,30,4],[31,16,31,17],[33,16,33,17],[33,11,33,12],[31,3,31,4],[33,9,33,10],[32,9,32,10],[37,11,37,12],[36,16,36,17],[32,1,32,2],[13,0,13,18],[15,17,15,18],[16,9,16,11],[14,11,14,13],[14,7,14,10],[26,5,26,6],[25,3,25,4],[28,3,28,4],[27,3,27,4],[27,5,27,6],[18,15,20,18],[28,11,28,12],[26,9,26,10],[25,5,25,6],[25,11,25,12],[25,9,25,10],[28,9,28,10],[27,11,27,12],[25,16,25,17],[26,16,26,17],[21,3,21,18],[23,18,24,18],[21,0,21,2],[23,15,24,15],[24,9,24,10],[6,17,6,18],[7,0,7,2],[7,3,7,9],[7,10,7,13],[7,14,7,18],[12,14,12,18],[10,3,10,9],[11,3,11,9],[12,3,12,9],[10,0,10,2],[11,0,11,2],[8,10,8,13],[8,14,8,18],[8,0,8,2],[8,3,8,9],[9,0,9,18],[10,14,10,18],[11,14,11,18],[14,0,14,2],[19,13,19,14],[20,13,20,14],[14,14,14,15],[15,0,15,2],[19,3,19,4],[15,15,15,16],[15,13,15,14],[15,3,15,4],[15,5,15,8],[15,9,15,12],[18,0,18,2],[20,3,20,4],[18,3,18,14],[17,0,17,18],[20,5,20,9],[20,10,20,12],[19,5,19,9],[19,10,19,12],[14,16,14,18],[14,3,14,6],[16,3,16,8],[16,12,16,13],[19,0,19,2],[20,0,20,2],[16,16,16,17],[88,0,88,15],[86,7,87,13],[49,14,49,18],[57,18,58,18],[57,16,58,17],[62,0,62,2],[61,9,61,10],[66,16,66,17],[63,9,63,10],[63,11,63,12],[62,16,62,17],[60,16,60,17],[49,6,49,13],[64,9,64,10],[64,16,64,17],[70,11,70,12],[70,9,70,10],[54,0,54,2],[37,16,37,17],[38,16,38,17],[51,12,51,18],[59,3,59,4],[40,1,42,2],[44,0,45,2],[43,3,43,6],[42,3,42,6],[57,7,57,10],[59,0,59,2],[57,11,58,12],[59,9,59,10],[58,9,58,10],[59,11,59,12],[59,5,59,6],[53,0,53,2],[53,4,53,11],[54,12,54,18],[57,3,58,4],[57,13,58,13],[55,0,55,2],[54,4,54,11],[53,12,53,18],[61,0,61,2],[55,12,55,18],[57,5,58,6],[59,16,59,17],[57,15,58,15],[57,14,58,14],[60,1,60,2],[62,11,62,12],[64,5,64,6],[61,16,61,17],[61,3,61,4],[62,3,62,4],[63,5,63,6],[60,3,60,4],[63,3,63,4],[62,9,62,10],[60,5,60,6],[61,5,61,6],[60,9,60,10],[60,11,60,12],[63,0,63,2],[62,5,62,6],[61,11,61,12],[64,0,64,2],[63,16,63,17],[66,3,66,4],[66,5,66,6],[67,9,67,10],[67,16,67,17],[65,16,65,17],[69,11,69,12],[69,9,69,10],[66,11,66,12],[67,3,67,4],[67,5,67,6],[64,3,64,4],[65,9,65,10],[65,11,65,12],[67,11,67,12],[65,5,65,6],[66,9,66,10],[64,11,64,12],[65,3,65,4],[68,0,68,18],[65,0,65,2],[67,0,67,2],[66,1,66,2],[69,16,69,17]]}
["Cell Partition",null,null,null,null,null,null,"Document Owner:",null,null,null,null,null,"Document ID: ","TFO_F_13_SPI_Supplier Packaging Info"]
[null,null,null,null,null,null,null,"Global Log. Dir. / VP Purchasing",null,null,null,null,null,"Revision: ","001"]
[null,null,null,null,null,null,null,"Document Title:",null,null,null,null,null,"Release Date:","2024-11-01"]
[null,null,null,null,null,null,null,"Supplier Packaging Information",null,null,null,null,null,"Funct. Area: ","Operations - Logistics"]
["SUPPLIER PACKAGING INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select","Adrian, MI - USA","Amsterdam - Netherlands","Bangalore - India","Birmingham - United Kingdom","Brownsville, TX - USA","Changchun - China","Chengdu - China","Cordeiropolis - Brazil","Cottondale, AL - USA","Daegu - South Korea","Dietzenbach - Germany","Esson - France","Gadsden, AL - USA","Gifhorn - Germany","Guanajuato - Mexico","Gyor - Hungary","Lozorno - Slovakia","Matamoros Plant 1 - Mexico","Matamoros Plant 2 - Mexico","Juarez - Mexico","North Kansas City, MO - USA","Oradea - Romania","Oshawa - Canada","Puebla - Mexico","Pune - India","Rychnov - Czech Republic","Saint Die - France","Salonta - Romania","SAMAP - Chian","SDADS - China","Shanghai - China","Seoul - South Korea","Solingen - Germany","Sully sur Loire - France","Tianjin - China","Troy, MI - USA","Vandalia, OH - USA","Waigaoqiao - China","Worth - Germany","Wuhan - China","Yantai - China","Yokohama - Japan","Zhenjiang - China"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select","in","mm","N/A"]
["Please fill all \"ORANGE\" highlighted cells that apply! Click \"Select\" for drop down boxes.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",null,null,null,null,null,null,null,"Select","lbs","Kg","N/A"]
["TRISTONE Plant: ",null,null,"Select",null,null,null,null,null,null,"TRISTONE Contact Email:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select","USD","EUR","AUD","BRL","CAD","CNY","CZK","GBP","INR","JPY","KRW","MXN","PLN","RON","SEK","ZAR"]
["TRISTONE Contact Name:",null,null,null,null,null,null,null,null,null,"TRISTONE Contact Phone:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select","E","R"]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select","No Alternative Packaging","Box - Single Wall","Box - Double Wall","Box - Triple Wall","Pallet Box","Foldable Plastic Box","EPP/FOAM","Tote / KLT  ","Tote / KLT - Collapsible","Rack","Box with Bottles","Bucket","Crate","Other"]
["Supplier: [Ship From]",null,null,null,null,null,null,null,null,null,"Contact Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select","Corrugated","Plastic","Plastic  ESD","Steel","Wood","Other"]
["Zip, City & Country:",null,null,null,null,null,null,null,null,null,"Contact Phone:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select","Pieces","Milliliters","Litres","Fluid Ounces","Gallons","Pounds","Kilograms","Feet","Inches","Meters","Centimeters","Other"]
["Duns Number:",null,null,null,null,null,null,null,null,null,"Contact Email:",null,null,null,null,null,null,null,null,null,null,null,null,"Select","No","Tray","Cell Partition","Paper Sheet","Divider","Bag","Inlay","Other","N/A"]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select","N/A","Corrugated ","Chipboard ","Ethafoam","Crosslinked Foam","Styro Foam","Foam","Paper","Plastic ","Electro Static Bag (ESD) Bag","Bubble Wrap","Molded Tray","Air Bags","Volatile Corrosion Inhibitor (VCI) Bags","Liner Bag","Desiccants","Coated Dividers","Inlay","Wood Posts","Corner Posts","Other"]
["TRISTONE Program:",null,null,null,null,null,null,"Annual Volume:",null,null,null,null,null,null,"TARIC / HS- Code:",null,null,null,null,null,null,null,null,null,"Select","None - Shipping individual PUs","Pallet","Pallet with Lid","Euro Pallet","Euro Pallet with Lid"]
["TRISTONE Part Number(s):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select","Wood","Plastic","Pressed Board","Corrugated","Steel","Aluminum","Other"]
["Part Description:",null,null,null,null,null,null,null,null,"Part Dim:",null,null,null,null,"Select","Part Wt:",null,null,"Select",null,null,null,null,null,"Select","No","Plastic Strapping","Polyester","Corrugated","Angle Board","Stretch Film","Wood Post"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select","No","Pieces","Feet","Meters","Inches","Centimeters","Millimeters"]
["TRISTONE Container:",null,null,"Select",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($N$20=\"R\"),\"ALTERNATIVE PACKAGING MUST BE COMPLETED AT THE BOTTOM OF THE FORM\",\" \")","v":" "},null,null,null,null,null,null,null,null,"Select","No","1 on 1 (Double)","2 on 1 (Triple)","3+ on 1"]
["Size Units:",null,null,"Select",null,{"$f":"IF(O17<>D20,\"<--SAME UNITS AS PART DIM\",\"\")","v":""},null,null,null,null,"Expendable (E) or\nReturnable (R)?",null,null,"Select",null,null,null,null,null,null,null,null,null,null,"Select","Not Specified","Expendable System / One Way","Returnable System / Round Trip","Expendable with a Returnable Estimate"]
["Weight Units:",null,null,"Select",null,{"$f":"IF(S17<>D21,\"<--SAME UNITS AS PART WEIGHT\",\"\")","v":""},null,null,null,null,"Currency:",null,null,"Select",null,null,null,null,null,null,null,null,null,null,"Select","North American Expendable Standards","22224725 - RSC - 9 x 9 x 4 in.","22224726 - RSC - 9 x 9 x 6 in.","22224727 - RSC - 12 x 7.5 x 3.75 in.","22224728 - RSC - 12 x 15 x 3.75 in.","22224729 - RSC - 12 x 15 x 7.5 in.","22224730 - RSC - 24 x 15 x 3.75 in.","22224731 - RSC - 24 x 15 x 7.5 in.","22224732 - RSC - 24 x 15 x 11.25 in.","22224733 - RSC - 24 x 15 x 14.5 in.","22224734 - RSC - 24 x 22.5 x 7.5 in.","22224735 - RSC - 24 x 22.5 x 11.25 in.","22224736 - RSC - 24 x 22.5 x 14.5 in.","22224737 - HSC - 11-11/16 x 7-7/16 x 3-11/16 in.","22224738 - HSC - 11-11/16 x 14-7/8 x 3-11/16 in.","22224739 - HSC - 11-11/16 x 14-7/8 x 7-3/8 in.","22224740 - HSC - 23-7/16 x 14-7/8 x 3-11/16 in.","22224741 - HSC - 23-7/16 x 14-7/8 x 7-3/8 in.","22224742 - HSC - 23-7/16 x 14-7/8 x 11-1/16 in.","22224743 - HSC - 23-7/16 x 14-7/8 x 14-3/8 in.","22224744 - HSC - 23-7/16 x 22-5/8 x 7-3/8 in.","22224745 - HSC - 23-7/16 x 22-5/8 x 11-1/16 in.","22224746 - HSC - 23-7/16 x 22-5/8 x 14-3/4 in. ",null,"North American Returnable Standards",null,"D120804 (XL) - Tote - 12 x 7.5 x 4 in.","D121504 (XL) - Tote - 12 x 15 x 4 in.","D121504 (XL) - Tote - 12 x 15 x 4 in.","D241504 (X) - Tote - 24 x 15 x 4 in.","D241508 (X) - Tote - 24 x 15 x 7.5 in.","D241515 (X) - Tote - 24 x 15 x 14.5 in.","D242308 (X) - Tote - 24 x 22.5 x 7.5 in.","D242311 (X) - Tote - 24 x 22.5 x 11 in.","D242315 (X) - Tote - 24 x 22.5 x 14.5 in.","D323025 - Pallet Container - 32 x 30 x 25  in.","D323034 - Pallet Container - 32 x 30 x 34  in.","D484525 - Pallet Container - 48 x 45 x 25  in.","D484534 - Pallet Container - 48 x 45 x 34  in.",null,"International Expendable Standards",null,"22224752 - 300 x 200 x 150 mm.","22224753 - 300 x 200 x 200 mm.","22224754 - 400 x 300 x 150 mm.","22224755 - 400 x 300 x 200 mm. ","22224756 - 400 x 300 x 300 mm. ","22224757 - 600 x 400 x 200 mm.","22224758 - 600 x 400 x 300 mm. ",null,"International Returnable Standards",null,"ID201514 - 200 x 150 x 140","ID291914 - 297 x 198 x 148 VDA","ID302011 - 300 x 200 x 114 Gallia","ID302021 - 300 x 200 x 214 Gallia","ID392914 - 396 x 297 x 148 VDA","ID403011 - 400 x 300 x 114 Gallia","ID392928 - 396 x 297 x 280 VDA","ID403021 - 400 x 300 x 214 Gallia","ID403028 - 400 x 300 x 280 Gallia","ID593928 - 594 x 396 x 280 VDA","ID604021 - 600 x 400 x 214 Gallia","ID604031 - 600 x 400 x 314 Gallia","ID806046 - 800 x 600 x 465 mm.","ID121086 - 1200 x 1000 x 860 mm.","ID121097 - 1200 x 1000 x 975 mm. "]
["Special Requirements:"]
[]
[null,"Package Unit",null,"Material",null,"ECT\nBurst",null,"Dimensions",null,null,null,"Parts Per [PU]",null,"Units","Tare Wt. [PU]","Gross Wt. [PU]","Cost Per \n[PU]",null,"Pkg Cost Per Piece",null,null,null,null,null,"Select","Box - Single Wall","Box - Double Wall","Box - Triple Wall","Pallet Box","Foldable Plastic Box","EPP/FOAM","Tote / KLT  ","Tote / KLT - Collapsible","Rack","Box with Bottles","Bucket","Crate","Other"]
[null,"[PU]",null,null,null,null,null,"L","W","H"]
["Select",null,null,"Select",null,null,null,null,null,null,null,null,null,"Select",null,{"$f":"IFERROR((IF(L26=\"\",\"\",(L26*Q17)+IFERROR((O26),0)+IFERROR((F28*O28),0)+IFERROR((F29*O29),0)+IFERROR((F30*O30),0)+IFERROR((F31*O31),0)+IFERROR((F32*O32),0))),\"\")","v":""},null,null,{"$f":"IF($D26=\"Select\",\"\",IF($D26=\"N/A\",\"\",IF($Q26=\"\",\"\",$Q26/$L$26)))","v":""}]
[null,"Dunnage  / Protection",null,"Material",null,"Tare Wt.",null,"L","W","H",null,"Pieces Per \nLayer",null,"Layers Per \n[PU]","Total Qty","Cost Per \nPiece","Extended Cost\n[Cost * Qty]",null,"Pkg Cost per Piece",null,null,null,null,null,"Select","Select","Select","Select","Select","Select"]
["Select",null,null,"Select",null,null,null,null,null,null,null,null,null,null,{"$f":"L28*N28","v":0},null,{"$f":"IF($D28=\"Select\",\"\",IF($D28=\"N/A\",\"\",IF($L28=\"\",\"\",IF(P28=\"\",\"\",$L28*$P28))))","v":""},null,{"$f":"IF($D28=\"Select\",\"\",IF($D28=\"N/A\",\"\",IF($Q28=\"\",\"\",$Q28/$L$26)))","v":""},null,null,null,null,null,"N/A","Corrugated","No","No","N/A","None - Shipping individual PUs"]
["Select",null,null,"Select",null,null,null,null,null,null,null,null,null,null,{"$f":"L29*N29","v":0},null,{"$f":"IF($D29=\"Select\",\"\",IF($D29=\"N/A\",\"\",IF($L29=\"\",\"\",IF(P29=\"\",\"\",$L29*$P29))))","v":""},null,{"$f":"IF($D29=\"Select\",\"\",IF($D29=\"N/A\",\"\",IF($Q29=\"\",\"\",$Q29/$L$26)))","v":""},null,null,null,null,null,"Corrugated ","Plastic","Stretch Film","Plastic","Wood","Euro Pallet"]
["Select",null,null,"Select",null,null,null,null,null,null,null,null,null,null,{"$f":"L30*N30","v":0},null,"",null,"",null,null,null,null,null,"Plastic ","Wood",null,"Polyester","Plastic","Euro Pallet with Lid"]
["Select",null,null,"Select",null,null,null,null,null,null,null,null,null,null,{"$f":"L31*N31","v":0},null,"",null,"",null," ",null,null,null,"Styro Foam","Styro Foam",null,null,"Pressed Board","Pallet"]
["Select",null,null,"Select",null,null,null,null,null,null,null,null,null,null,{"$f":"L32*N32","v":0},null,"",null,"",null,null,null,null,null,"Foam","No",null,null,"Corrugated","Pallet with Lid"]
[null,"Pallet",null,"Material",null,"Tare Wt.",null,"L","W","H",null,"[PU] Per \nLayer",null,"Layers Per Pallet","[PU] Per Pallet","Cost of Pallet & Lid","Extended Cost\n[Cost * Qty]",null,"Pkg Cost Per Piece",null,null,null,null,null,"Paper",null,null,null,"Steel"]
["Select",null,null,"Select",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((IF(OR(L34=\" \",L34=0),\" \",(N34*L34))),\"\")","v":" "},null,{"$f":"IF(P34=0,\"\",P34)","v":""},null,{"$f":"IF($Q34=\"\",\"\",$Q34/$Q44)","v":""},null,null,null,null,null,"Coated Dividers",null,null,null,"Aluminum"]
["Please choose securement method:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bubble Wrap",null,null,null,"Other"]
["Securement",null,null,"Material",null,null,null,"L","W","H",null,"Qty Per Pallet",null,"Units","Total Qty","Cost per \nUnit","Cost Per Pallet",null,"Pkg Cost Per Piece",null,null,null,null,null,"Molded Tray"]
["Corner Posts",null,null,"Select",null,null,null,null,null,null,null,null,null,"Select",{"$f":"IF(L37>0,L37,\"\")","v":""},null,{"$f":"IF($D37=\"Select\",\"\",IF($D37=\"no\",\"\",IF($L37=\"\",\"\",$L37*$P37)))","v":""},null,{"$f":"IF($D37=\"Select\",\"\",IF($D37=\"no\",\"\",IF($Q37=\"\",\"\",$Q37/$Q$44)))","v":""},null,null,null,null,null,"Air Bags"]
["Stretch Wrap",null,null,"Select",null,null,null,null,null,null,null,null,null,"Select",{"$f":"IF(L38>0,L38,\"\")","v":""},null,{"$f":"IF($D38=\"Select\",\"\",IF($D38=\"no\",\"\",IF($L38=\"\",\"\",$L38*$P38)))","v":""},null,{"$f":"IF($D38=\"Select\",\"\",IF($D38=\"no\",\"\",IF($Q38=\"\",\"\",$Q38/$Q$44)))","v":""},null,null,null,null,null,"Electro Static Bag (ESD)"]
["Banding",null,null,"Select",null,null,null,null,null,null,null,null,null,"Select",{"$f":"IF(L39>0,L39,\"\")","v":""},null,{"$f":"IF($D39=\"Select\",\"\",IF($D39=\"no\",\"\",IF($L39=\"\",\"\",$L39*$P39)))","v":""},null,{"$f":"IF($D39=\"Select\",\"\",IF($D39=\"no\",\"\",IF($Q39=\"\",\"\",$Q39/$Q$44)))","v":""},null,null,null,null,null,"Liner Bag"]
[{"$f":"IFERROR((IF(AND(OR(N26=\"Pieces\",N26=\"Each\"),S40>3),\"PLEASE CHECK COST PER PIECE COLUMN AND FIX  THE COST -  Pkg Cost Per Part is too HIGH\",\"\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Packaging Cost Per Piece:",null,null,{"$f":"SUM(S26,S28,S29,S30,S31,S32,S34,S37,S38,S39)","v":0}," ",null,null,null,null,"Volatile Corrosion Inhibitor (VCI) Bags"]
[null,"Shipping Unit\n[SU]",null,"Static Stackability:",null,null,null,"Shipping Unit \nDimensions",null,null,null,"Shipping Unit \nWeight",null,"Packaging Units Per \nLayer","Layers Per Shipping Unit","Packaging Units  Per Shipping Unit","Parts Per Shipping Unit",null,"Tare Weight Empty [SU] [Returnable]",null,null,null,null,null,"Desiccants"]
[null,null,null,"Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wood"]
[null,null,null,"Dynamic Stackability:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chipboard "]
["Volume:",{"$f":"IFERROR((IF(D20=\"in\",(IF(OR(H34=\" \",H34=0),\" \",(H34*I34*((O34*J26)+J34))))/1728,IF(D20=\"mm\",(IF(OR(H34=\" \",H34=0),\" \",(H34*I34*((N34*J26)+J34))))/1000000000,\"\"))),\"\")","v":""},{"$f":"IFERROR((IF(D20=\"mm\",\"cbm\",IF(D20=\"in\",\"cbft\",\"\"))),0)","v":""},"Select",null,null,null,{"$f":"IFERROR((CONCATENATE((IF(OR(H34=\" \",H34=0),\" \",H34&\" x \"&I34&\" x \"&IF((J26*N34)>J34,(J34+(J26*N34)),J34)&\"   \"&D20)))),\"\")","v":" "},null,null,null,{"$f":"IFERROR((CONCATENATE(ROUND(IF(F34>0,((P26*O34)+F34),((P26*1))),0)&\"   \",D21)),\"\")","v":""},null,{"$f":"L34","v":0},{"$f":"N34","v":0},{"$f":"IFERROR((IF(OR(N44=\" \",N44=0),\" \",(O44*N44))),\"\")","v":" "},{"$f":"IFERROR((IF(OR($L$26=\" \",$L$26=0),\" \",(O34*$L$26))),\"\")","v":" "},null,{"$f":" IFERROR((CONCATENATE((IF(AND(N20=\"R\",O26>0),(((IFERROR((F28*0)+O26,0)+IFERROR((F29*0),0)+IFERROR((F30*0),0)+IFERROR((F31*0),0)+IFERROR((F32*0),0))*O34)+F34),0)),\"  \",D21)),\"\")","v":"0  Select"},null,null,null,null,null,"Other"]
[{"$f":"IFERROR((IF(OR(D45<>\"\",D46<>\"\",M45<>\"\"),\"IF YOU SEE COMMENTS IN RED THIS FORM WILL BE REJECTED\",\"\")),\"\")","v":""},null,null,{"$f":"IFERROR((IF(AND(D20=\"in\",((J26*N34)+J34)>52),\"SU height must be below 52 inches\",IF(AND(D20=\"mm\",((J26*N34)+J34)>1500),\"SU height must be below 1500 mm\",\"\"))),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR((IF(AND(P26<>\"\",P26>12,D21=\"Kg\"),\"The Gross weight is max. 12 Kg/PU (for exception ask the affected plant packaging engineer)\",IF(AND(P26<>\"\",P26>26.4,D21=\"lbs\"),\"The Gross weight is max. 26.4 lbs/PU (for exception ask the affected plant packaging engineer)\",\"\"))),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR((IF(AND(I34>0,(H26*I26*L34)>(H34*I34)),\"Boxes must not overhang off the pallet\",IF(AND(I34>0,(((H34*I34)-(H26*I26*L34))/(H34*I34))>0.067),\"Boxes must fit pallet - too much underhang\",\"\"))),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR((IF(AND(D26=\"Corrugated\",F26<44,D21=\"lbs\"),\"ECT must be 44 lbs or greater\",IF(AND(D26=\"Corrugated\",F26<7.7,D21=\"kg\"),\"ECT must be 7.7 kN/M or greater\",\"\"))),\"\")","v":""}]
["PICTURES / DRAWINGS"]
["Part",null,null,null,null,null,"Part Orientation in Packaging Unit",null,null,null,null,null,null,null,"Shipping Unit"]
[]
["Part Dimensions:",null,null,{"$f":"IFERROR((CONCATENATE($M$17, \"   \", $O$17)),\"\")","v":"   Select"},null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Shipping Unit Dim: \",H44,\"     \", \"/   \",L44)","v":"Shipping Unit Dim:       /   "}]
[]
["Working Days Per Year",null,null,{"$f":"IF(ReturnableCalc!C21=0,\"\",ReturnableCalc!C21)","v":""},"Days",null,null,null,null,null,null,null,"General calculation please use \"ReturnableCalc\" worksheet"]
["Days of Packaging",null,null,{"$f":"IF(ReturnableCalc!C25=\"Select\",\"\",ReturnableCalc!C25)","v":""},"Days",null,null,null,null,null,null,null,"Logistics returnable packaging loop days between CIE Roof Systems plant and supplier"]
["Packaging in the loop",null,null,{"$f":"IF(ReturnableCalc!C21=0,\"\",ReturnableCalc!C33/ReturnableCalc!K16)","v":""},"Shipping units",null,null,null,null,null,null,null,"Automatically calculated in \"ReturnableCalc\" sheet"]
["Delivery frequency",null,null,{"$f":"IF(LogDataSheet!F35=\"Select\",\"\",LogDataSheet!F35)","v":""},{"$f":"IF(LogDataSheet!J35=\"Select\",\"\",LogDataSheet!J35)","v":""},null,null,null,null,null,null,null,"Please choose in \"LogDataSheet\""]
["Incoterms",null,null,null,{"$f":"IF(LogDataSheet!F34=\"Select\",\"\",LogDataSheet!F34)","v":""},null,null,null,null,null,null,null,"Please choose in \"LogDataSheet\""]
["ALTERNATIVE PACKAGING"]
[null,"Package Unit",null,"Material",null,"ECT\nBurst",null,"Dimensions",null,null,null,"Parts Per [PU]",null,"Units","Tare Wt. [PU]","Gross Wt. [PU]","Cost Per \n[PU]",null,"Pkg Cost Per Piece"]
[null,"[PU]",null,null,null,null,null,"L","W","H"]
["Select",null,null,"Select",null,null,null,null,null,null,null,null,null,"Select",null,{"$f":"IFERROR((IF(L60=\"\",\"\",(L60*Q17)+IFERROR((O60),0)+IFERROR((F62*O62),0)+IFERROR((F63*O63),0)+IFERROR((F64*O64),0)+IFERROR((F65*O65),0)+IFERROR((F66*O66),0))),\"\")","v":""},null,null,{"$f":"IFERROR((IF(OR(L60=0,L60=\" \"),\"\",IF(N54<>\"E\",(Q60/L60),\"\"))),\"\")","v":""}]
[null,"Dunnage  / Protection",null,"Material",null,"Tare Wt.",null,"L","W","H",null,"Pieces Per \nLayer",null,"Layers Per \n[PU]","Total Qty","Cost Per \nPiece","Extended Cost\n[Cost * Qty]",null,"Pkg Cost per Piece"]
["Select",null,null,"Select",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L62=\"\",\"\",L62*N62)","v":""},null,{"$f":"IF($D62=\"Select\",\"\",IF($D62=\"N/A\",\"\",IF($L62=\"\",\"\",IF(P62=\"\",\"\",$L62*$P62))))","v":""},null,{"$f":"IF($D62=\"Select\",\"\",IF($D62=\"N/A\",\"\",IF($Q62=\"\",\"\",$Q62/$L$60)))","v":""},{"$f":"IFERROR((IF(OR(L60=0,L60=\" \"),\"\",IF(N54<>\"E\",(Q60/L60),\"\"))),\"\")","v":""}]
["Select",null,null,"Select",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L63=\"\",\"\",L63*N63)","v":""},null,{"$f":"IF($D63=\"Select\",\"\",IF($D63=\"N/A\",\"\",IF($L63=\"\",\"\",IF(P63=\"\",\"\",$L63*$P63))))","v":""},null,{"$f":"IF($D63=\"Select\",\"\",IF($D63=\"N/A\",\"\",IF($Q63=\"\",\"\",$Q63/$L$60)))","v":""}]
["Select",null,null,"Select",null,null,null,null,null,null,null,null,null,null,"",null,"",null,""]
["Select",null,null,"Select",null,null,null,null,null,null,null,null,null,null,"",null,"",null,""]
["Select",null,null,"Select",null,null,null,null,null,null,null,null,null,null,"",null,"",null,""]
[null,"Pallet",null,"Material",null,"Tare Wt.",null,"L","W","H",null,"[PU] Per \nLayer",null,"Layers Per Pallet","[PU] Per Pallet","Cost of Pallet & Lid","Extended Cost\n[Cost * Qty]",null,"Pkg Cost Per Piece"]
["Select",null,null,"Select",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((IF(OR(L68=\" \",L68=0),\" \",(N68*L68))),\"\")","v":" "},null,{"$f":"IF(P68=0,\"\",P68)","v":""},null,{"$f":"IF($Q68=\"\",\"\",$Q68/$Q76)","v":""}]
["Please choose securement method:"]
["Securement",null,null,"Material",null,null,null,"L","W","H",null,"Qty Per Pallet",null,"Units","Total Qty","Cost per \nUnit","Cost Per Pallet",null,"Pkg Cost Per Piece"]
["Corner Posts",null,null,"Select",null,null,null,null,null,null,null,null,null,"Select",{"$f":"IF(L71>0,L71,\"\")","v":""},null,{"$f":"IF($D71=\"Select\",\"\",IF($D71=\"no\",\"\",IF($L71=\"\",\"\",$L71*$P71)))","v":""},null,{"$f":"IF($D71=\"Select\",\"\",IF($D71=\"no\",\"\",IF($Q71=\"\",\"\",$Q71/$Q$76)))","v":""}]
["Stretch Wrap",null,null,"Select",null,null,null,null,null,null,null,null,null,"Select",{"$f":"IF(L72>0,L72,\"\")","v":""},null,{"$f":"IF($D72=\"Select\",\"\",IF($D72=\"no\",\"\",IF($L72=\"\",\"\",$L72*$P72)))","v":""},null,{"$f":"IF($D72=\"Select\",\"\",IF($D72=\"no\",\"\",IF($Q72=\"\",\"\",$Q72/$Q$76)))","v":""}]
["Banding",null,null,"Select",null,null,null,null,null,null,null,null,null,"Select",{"$f":"IF(L73>0,L73,\"\")","v":""},null,{"$f":"IF($D73=\"Select\",\"\",IF($D73=\"no\",\"\",IF($L73=\"\",\"\",$L73*$P73)))","v":""},null,{"$f":"IF($D73=\"Select\",\"\",IF($D73=\"no\",\"\",IF($Q73=\"\",\"\",$Q73/$Q$76)))","v":""}]
[{"$f":"IFERROR((IF(AND(OR(N60=\"Pieces\",N60=\"Each\"),S74>3),\"PLEASE CHECK COST PER PIECE COLUMN AND FIX  THE COST -  Pkg Cost Per Part is too HIGH\",\"\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Packaging Cost Per Piece:",null,null,{"$f":"SUM(S60,S62,S63,S64,S65,S66,S68,S71,S72,S73)","v":0}]
[null,"Shipping Unit\n[SU]",null,"Is the Shipping Unit Capable of Stacking:",null,null,null,"Shipping Unit \nDimensions",null,null,null,"Shipping Unit \nWeight",null,"Packaging Units Per \nLayer","Layers Per Shipping Unit","Packaging Units Per Shipping Unit","Parts Per Shipping Unit",null,"Tare Weight Empty [SU] [Returnable]"]
["Volume:",{"$f":"IFERROR((IF(D20=\"in\",(IF(OR(H68=\" \",H68=0),\" \",(H68*I68*((O68*J60)+J68))))/1728,IF(D20=\"mm\",(IF(OR(H68=\" \",H68=0),\" \",(H68*I68*((N68*J60)+J68))))/1000000000,\"\"))),\"\")","v":""},{"$f":"IFERROR((IF(D20=\"mm\",\"cbm\",IF(D20=\"in\",\"cbft\",\"\"))),0)","v":""},"Select",null,null,null,{"$f":"IFERROR((CONCATENATE((IF(OR(H68=\" \",H68=0),\" \",H68&\" x \"&I68&\" x \"&IF((J60*N68)>J68,(J68+(J60*N68)),J68)&\"   \"&D20)))),\"\")","v":" "},null,null,null,{"$f":"IFERROR((CONCATENATE(ROUND(IF(F68>0,((P60*O68)+F68),((P60*1))),0)&\"   \",D21)),\"\")","v":""},null,{"$f":"L68","v":0},{"$f":"N68","v":0},{"$f":"IFERROR((IF(OR(N76=\" \",N76=0),\" \",(O76*N76))),\"\")","v":" "},{"$f":"IFERROR((IF(OR($L$60=\" \",$L$60=0),\" \",(O68*$L$60))),\"\")","v":" "},null,{"$f":" IFERROR((CONCATENATE((IF(AND(N20<>\"R\",O60>0),(((IFERROR((F62*0)+O60,0)+IFERROR((F63*0),0)+IFERROR((F64*0),0)+IFERROR((F65*0),0)+IFERROR((F66*0),0))*O68)+F68),0)),\"  \",D21)),\"\")","v":"0  Select"}]
[{"$f":"IFERROR((IF(OR(D77<>\"\",D78<>\"\",M77<>\"\"),\"IF YOU SEE COMMENTS IN RED THIS FORM WILL BE REJECTED\",\"\")),\"\")","v":""},null,null,{"$f":"IFERROR((IF(AND(D20=\"in\",((J60*N68)+J68)>52),\"SU height must be below 52 inches\",IF(AND(D20=\"mm\",((J60*N68)+J68)>1500),\"SU height must be below 1500 mm\",\"\"))),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR((IF(AND(P60<>\"\",P60>14,D21=\"Kg\"),\"The Gross weight should be LESS than 14 Kg for PU\",IF(AND(P60<>\"\",P60>33,D21=\"lbs\"),\"The Gross weight should be LESS than 33 lbs for PU\",\"\"))),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR((IF(AND(I68>0,(H60*I60*L68)>(H68*I68)),\"Boxes must not overhang off the pallet\",IF(AND(I68>0,(((H68*I68)-(H60*I60*L68))/(H68*I68))>0.067),\"Boxes must fit pallet - too much underhang\",\"\"))),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR((IF(AND(D60=\"Corrugated\",F60<44,D21=\"lbs\"),\"ECT must be 44 lbs or greater\",IF(AND(D60=\"Corrugated\",F60<7.7,D21=\"kg\"),\"ECT must be 7.7 kN/M or greater\",\"\"))),\"\")","v":""}]
["PACKAGING APPROVAL"]
["TRISTONE Packaging Engineer:",null,null,null,null,null,null,"Supplier Packaging Engineer:",null,null,null,null,null,null,"Other Approval:"]
[]
[]
["TRISTONE Engineering:",null,null,null,null,null,null,"Supplier Quality Engineer:",null,null,null,null,null,null,"Other Approval:"]
[]
[]
["TRISTONE Quality Engineer:",null,null,null,null,null,null,"TRISTONE Logistics:",null,null,null,null,null,null,"Other Approval:"]
[]
[]
["Please Date Sign and Print Name in Packaging Approval Section."]

{"sheet":"ReturnableCalc","index":2,"n_rows":58,"n_cols":33,"rows_kept":58,"cut":false,"hidden":false,"merged":[[3,6,3,8],[45,5,45,10],[46,5,57,10],[3,9,3,10],[13,1,13,10],[14,7,14,8],[16,4,21,10],[7,1,7,10],[10,1,12,1],[9,2,9,3],[11,7,12,10],[43,7,43,8],[37,9,37,10],[35,4,35,6],[43,4,43,6],[41,4,41,6],[8,1,8,10],[9,4,10,6],[9,7,10,10],[42,4,42,6],[39,4,39,6],[36,4,36,6],[35,7,35,8],[35,9,35,10],[36,9,36,10],[36,7,36,8],[42,9,42,10],[41,9,41,10],[40,9,40,10],[39,9,39,10],[38,9,38,10],[24,4,24,10],[1,4,1,5],[2,4,2,5],[3,4,3,5],[4,4,4,5],[23,1,23,10],[11,4,12,6],[15,2,15,3],[21,2,21,3],[20,2,20,3],[19,2,19,3],[18,2,18,3],[17,2,17,3],[16,2,16,3],[14,4,14,5],[5,1,5,10],[2,7,2,8],[52,2,52,3],[51,2,51,3],[50,2,50,3],[41,2,41,3],[40,2,40,3],[45,2,45,3],[43,2,43,3],[42,2,42,3],[49,1,49,3],[24,2,24,3],[33,1,33,10],[57,2,57,3],[56,2,56,3],[55,2,55,3],[54,2,54,3],[53,2,53,3],[25,4,26,10],[37,4,37,6],[38,4,38,6],[32,2,32,3],[26,2,26,3],[31,1,31,3],[31,4,32,10],[34,1,34,10],[25,2,25,3],[24,12,24,14],[36,2,36,3],[47,2,47,3],[46,2,46,3],[39,2,39,3],[38,2,38,3],[37,2,37,3],[40,4,40,6],[43,9,43,10],[41,7,41,8],[42,7,42,8],[37,7,37,8],[38,7,38,8],[39,7,39,8],[40,7,40,8],[35,2,35,3]]}
[]
[null,null,"Document Owner:",null,"Document ID: ",null,"TFO_F_13_SPI_Supplier Packaging Info",null,null,null,null,null,null,null,null,null,null,null,"Select","Select"]
[null,null,"Global Log. Dir. / VP Purchasing",null,"Revision: ",null,"001",null,null,null,null,null,null,null,null,null,null,null,8,0]
[null,null,"Document Title:",null,"Release Date:",null,"2024-11-01",null,null,null,null,null,null,null,null,null,null,null,9,1]
[null,null,"Supplier Packaging Information",null,"Funct. Area: ",null,"Operations - Logistics",null,null,null,null,null,null,null,null,null,null,null,10,2]
[null,"RETURNABLE PACKAGING AMORTIZATION CALCULATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,3]
[null,"Supplier fills in \"ORANGE\" fields",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,4,null,null,null,null,null,null,null,null,{"$f":"D11","v":0},{"$f":"C12","v":0},{"$f":"D12","v":0},{"$f":"C13","v":0},{"$f":"D13","v":0}]
[null,"Please fill the \"ORANGE\" highlighted cells! Do NOT AMEND, DELETE and/or ADD any FORMATS, LINES and/or COLUMNS!!!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,5,null,null,null,null,null,null,null,null,{"$f":"IF(AC7>0,'Supplier Packaging Information'!L15)","v":false},{"$f":"IF(AD7>0,'Supplier Packaging Information'!L15)","v":false},{"$f":"IF(AE7>0,'Supplier Packaging Information'!L15)","v":false},{"$f":"IF(AF7>0,'Supplier Packaging Information'!L15)","v":false},{"$f":"IF(AG7>0,'Supplier Packaging Information'!L15)","v":false}]
[null,"General Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,6]
[null,"Part name",{"$f":"'Supplier Packaging Information'!D17","v":0},null,"Supplier",null,null,{"$f":"'Supplier Packaging Information'!D11","v":0},null,null,null,null,null,null,null,null,null,null,15,7]
[null,"Part No.",{"$f":"'Supplier Packaging Information'!D16","v":0},{"$f":"'Supplier Packaging Information'!F16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,8]
[null,null,{"$f":"'Supplier Packaging Information'!J16","v":0},{"$f":"'Supplier Packaging Information'!N16","v":0},"Date",null,null,{"$f":"'Supplier Packaging Information'!R7","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,17,9]
[null,null,{"$f":"'Supplier Packaging Information'!P16","v":0},{"$f":"'Supplier Packaging Information'!R16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,11]
[null,null,"Parts/PU in:",{"$f":"'Supplier Packaging Information'!N26","v":"Select"},"PU dimensions in:",null,{"$f":"'Supplier Packaging Information'!D20","v":"Select"},"SU dimensions in:",null,{"$f":"G15","v":"Select"},"PU/SU",null,null,null,null,null,null,null,20,12]
[null,"Packaging unit (PU)",{"$f":"'Supplier Packaging Information'!L26","v":0},null,{"$f":"'Supplier Packaging Information'!H26","v":0},{"$f":"'Supplier Packaging Information'!I26","v":0},{"$f":"'Supplier Packaging Information'!J26","v":0},{"$f":"'Supplier Packaging Information'!H34","v":0},{"$f":"'Supplier Packaging Information'!I34","v":0},{"$f":"'Supplier Packaging Information'!J26*'Supplier Packaging Information'!N34+'Supplier Packaging Information'!J34","v":0},{"$f":"'Supplier Packaging Information'!O34","v":" "},null,null,null,null,null,null,null,21,13]
[null,"TRISTONE - production plant   (customer)",{"$f":"'Supplier Packaging Information'!D8","v":"Select"},null,"PU - packaging unit\nSU - shipping unit",null,null,null,null,null,null,null,null,null,null,null,null,null,22,14]
[null,"Demands per year",{"$f":"'Supplier Packaging Information'!L15+AC8+AD8+AE8+AF8+AG8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,15]
[null,"Parts per one Finished Good",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"calcu",24,16]
[null,"Demands parts per year",{"$f":"C18*C19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E37","v":0},25,17]
[null,"Working days per year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E38","v":0},26,18]
[null,"Demand per day",{"$f":"IF(C21=0,0,ROUNDDOWN(C20/C21,0))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E39","v":0},27,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,28,20]
[null,"Packaging demand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,29,21]
[null,"Days of packaging for delivery","Select",null,"Depends on transportation times & on delivery frequency\n1.  Delivery location  < 750 km (470 mi) & daily shipments - 8 days\n2.  Delivery location over 750 km (470 mi) & daily shipments - 12 days\n3.  Delivery location  < 750 (470 mi) km & weekly shipments - 15 days \n4.  Delivery location over 750 km (470 mi) & weekly shipment - 20 days",null,null,null,null,null,null,null,null,null,null,null,null,0,30,22]
[null,"Internal demand of packaging - supplier","Select",null,"Packaging for suppliers internal demand (transports between supplier and subsupplier, bank-builds,  etc.) will not be paid by TRISTONE",null,null,null,null,null,null,null,null,null,null,null,null,0,31,23]
[null,"Aditional demand - supplier",{"$f":"IF(C26=\"Select\",0,(D28*K16))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,32,24]
[null,null,null,{"$f":"ROUNDUP(D29/K16,0)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,25]
[null,null,null,{"$f":"ROUNDUP(C22/C16*C26,0)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,26]
[null,null,null,{"$f":"ROUNDUP(C22/C16*C25,0)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,27]
[null,null,null,{"$f":"ROUNDUP(D30/K16,0)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,28]
[null,null,null,null,"Comments and remarks:",null,null,null,null,null,null,null,null,null,null,null,null,null,37,29]
[null,"Needed qty. of  PU TRISTONE",{"$f":"IF(C25=\"Select\",0,D31*K16)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,31]
[null,"Packaging details",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,32]
[null,"Description of the packaging type","Packaging type description",null,{"$f":"\"Cost per 1 pc. of packaging type in \"&'Supplier Packaging Information'!N21","v":"Cost per 1 pc. of packaging type in Select"},null,null,"Needed qty. of packaging type\n",null,{"$f":"\"Total costs per packaging type in \"&'Supplier Packaging Information'!N21","v":"Total costs per packaging type in Select"},null,null,null,null,null,null,null,null,null,33]
[null,"add type of packaging unit (KLT, Vario Box, GIBO etc)",null,null,null,null,null,{"$f":"IF(C25=\"Select\",0,(D31*K16)+IF(R20,0,-C33))","v":0},null,{"$f":"E37*H37","v":0},null,null,null,null,null,null,null,null,null,34]
[null,"add type of inserts (inlayers, foam/rubber carriers etc.)",null,null,null,null,null,{"$f":"IF(C25=\"Select\",0,(D31*K16)+IF(R21,0,-C33))","v":0},null,{"$f":"E38*H38","v":0},null,null,null,null,null,null,null,null,null,35]
[null,"add type of other packaging (pallet)",null,null,null,null,null,{"$f":"IF(C25=\"Select\",0,(D31)+IF(R22,0,-D31))","v":0},null,0,null,null,null,null,null,null,null,null,null,36]
[null,"add type of other packaging (cover)",null,null,null,null,null,{"$f":"IF(C25=\"Select\",0,(D31)+IF(R23,0,-D31))","v":0},null,0,null,null,null,null,null,null,null,null,null,37]
[null,"Internal demand of packaging - supplier: PU (KLT, Vario Box, GIBO etc)",null,null,null,null,null,{"$f":"IF(C26=\"Select\",0,(D28*K16)+IF(R24,0,-(D28*K16)))","v":0},null,0,null,null,null,null,null,null,null,null,null,38]
[null,"Internal demand of packaging - supplier: add type of inserts (inlayers, foam/rubber carriers etc.)",null,null,null,null,null,{"$f":"IF(C26=\"Select\",0,(D28*K16)+IF(R25,0,-(D28*K16)))","v":0},null,0,null,null,null,null,null,null,null,null,null,39]
[null,"Internal demand of packaging - supplier:add type of other packaging (pallet)",null,null,null,null,null,{"$f":"IF(C26=\"Select\",0,ROUNDUP(D29/K16,0)+IF(R26,0,-D28))","v":0},null,0,null,null,null,null,null,null,null,null,null,40]
[null,"Internal demand of packaging - supplier: add type of other packaging (cover)",null,null,null,null,null,{"$f":"IF(C26=\"Select\",0,ROUNDUP(D29/K16,0)+IF(R27,0,-D28))","v":0},null,0]
[]
[null,{"$f":"\"Total investment in \"&'Supplier Packaging Information'!N21","v":"Total investment in Select"},{"$f":"SUM(J37:J44)","v":0},null,null," Additional comments and remarks:"]
[null,{"$f":"\"Investment of supplier in \"&'Supplier Packaging Information'!N21","v":"Investment of supplier in Select"},{"$f":"SUM(J41:J44)","v":0}]
[null,{"$f":"\"Investment of TRISTONE in \"&'Supplier Packaging Information'!N21","v":"Investment of TRISTONE in Select"},{"$f":"SUM(J37:J40)","v":0}]
[]
[null,"Costs of amortization"]
[null,"Aromatization time (years)"]
[null,"Amortization quantity (parts)",{"$f":"C51*C18","v":0}]
[null,"Interest rate"]
[null,{"$f":"\"Amortization in \"&'Supplier Packaging Information'!N21","v":"Amortization in Select"},{"$f":"IF(C51=0,0,C48/C52)","v":0}]
[null,{"$f":"\"Financing in \"&'Supplier Packaging Information'!N21","v":"Financing in Select"},{"$f":"IF(C51=0,0,C48/C51*C53/C20)","v":0}]
[null,{"$f":"\"Packaging cost per part in \"&'Supplier Packaging Information'!N21&\" until the packaging is amortized: \n(After the packaging costs are amortized, TRISTONE becomes the owner of the packaging loop)\"","v":"Packaging cost per part in Select until the packaging is amortized: \n(After the packaging costs are amortized, TRISTONE becomes the owner of the packaging loop)"},{"$f":"C54+C55","v":0}]
[null,"Percentage of investment per year for supplier for replacement and repair:"]
[null,{"$f":"\"Packaging costs after amortization in \"&'Supplier Packaging Information'!N21&\":\"","v":"Packaging costs after amortization in Select:"},{"$f":"IF(C20=0,0,C48*C57/C20)","v":0}]

{"sheet":"LogDataSheet","index":3,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,7,0,8],[1,7,1,8],[2,7,2,8],[3,7,3,8],[0,9,0,12],[2,9,2,10],[3,9,3,12],[46,0,46,12],[4,0,4,12],[36,1,36,4],[36,5,36,12],[37,0,37,12],[32,0,32,12],[33,5,33,12],[35,5,35,7],[35,8,35,9],[35,10,35,12],[34,5,34,8],[34,9,34,12],[35,0,35,4],[34,0,34,4],[33,0,33,4],[23,0,26,6],[20,7,20,8],[20,11,20,12],[20,9,20,10],[47,0,49,12],[39,9,39,12],[40,1,40,4],[41,1,41,4],[42,1,42,4],[43,1,43,4],[44,1,44,4],[38,0,45,0],[38,1,39,4],[38,5,38,8],[38,9,38,12],[39,5,39,8],[45,1,45,4],[20,1,20,2],[19,1,19,2],[20,3,20,4],[19,3,19,4],[20,5,20,6],[27,7,27,12],[28,7,31,12],[28,0,31,6],[23,7,26,12],[21,0,21,12],[22,0,22,6],[22,7,22,12],[27,0,27,6],[8,4,8,5],[8,7,8,12],[13,0,13,12],[8,1,8,2],[11,0,11,1],[11,2,11,12],[9,0,9,12],[10,0,10,1],[10,2,10,8],[10,9,10,10],[10,11,10,12],[12,1,12,4],[12,6,12,8],[12,10,12,12],[5,0,5,12],[6,0,6,1],[6,2,6,12],[7,0,7,1],[7,2,7,12],[16,1,16,12],[17,1,17,12],[18,1,18,12],[19,9,19,10],[19,5,19,6],[19,7,19,8],[19,11,19,12],[14,1,14,12],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,3,15,4],[15,11,15,12],[15,1,15,2]]}
[null,null,null,"Document Owner:",null,null,null,"Document ID: ",null,"TFO_F_13_SPI_Supplier Packaging Info"]
[null,null,null,"Global Log. Dir. / VP Purchasing",null,null,null,"Revision: ",null,"001"]
[null,null,null,"Document Title:",null,null,null,"Release Date:",null,"2024-08-01"]
[null,null,null,"Supplier Packaging Information",null,null,null,"Funct. Area: ",null,"Operations - Logistics"]
["LOGISTICS DATA SHEET"]
["Please fill the \"ORANGE\" highlighted cells! Do NOT AMEND, DELETE and/or ADD any FORMATS, LINES and/or COLUMNS!!!"]
["TRISTONE Plant: ",null,{"$f":"'Supplier Packaging Information'!D8","v":"Select"}]
["Address :      "]
["Country:",null,null,"ZIP-Code:",null,null,"City:"]
["Supplier"]
["Supplier’s Name :      ",null,{"$f":"'Supplier Packaging Information'!D11","v":0},null,null,null,null,null,null,"DUNS Number :      ",null,{"$f":"'Supplier Packaging Information'!D13","v":0}]
["Address :     ",null,{"$f":"'Supplier Packaging Information'!D12","v":0}]
["Contact name:",{"$f":"'Supplier Packaging Information'!O11","v":0},null,null,null,"Contact phone:",{"$f":"'Supplier Packaging Information'!O12","v":0},null,null,"Contact email:",{"$f":"'Supplier Packaging Information'!O13","v":0}]
["General Information"]
["OEM:","Select"]
["Part No:       ",{"$f":"'Supplier Packaging Information'!D16","v":0},null,{"$f":"'Supplier Packaging Information'!F16","v":0},null,{"$f":"'Supplier Packaging Information'!J16","v":0},null,{"$f":"'Supplier Packaging Information'!N16","v":0},null,{"$f":"'Supplier Packaging Information'!P16","v":0},null,{"$f":"'Supplier Packaging Information'!R16","v":0}]
["Project:      ",{"$f":"'Supplier Packaging Information'!D15","v":0}]
["SOP:       "]
["\nDays/Year\n ",{"$f":"ReturnableCalc!C21","v":0}]
["Parts per day:      ",{"$f":"IF(ReturnableCalc!C20=0,0,ReturnableCalc!C20/ReturnableCalc!C21)","v":0},null,{"$f":"IF(D16=0,\"N/A\",IF(D16>0,B20))","v":"N/A"},null,{"$f":"IF(F16=0,\"N/A\",IF(F16>0,D20))","v":"N/A"},null,{"$f":"IF(H16=0,\"N/A\",IF(H16>0,F20))","v":"N/A"},null,{"$f":"IF(J16=0,\"N/A\",IF(J16>0,H20))","v":"N/A"},null,{"$f":"IF(L16=0,\"N/A\",IF(L16>0,J20))","v":"N/A"}]
["Max. parts/day",{"$f":"ROUNDUP(B20*1.15,0)","v":0},null,{"$f":"IF(D20=\"N/A\",\"N/A\",IF(D20>1,ROUNDUP(D20*1.15,0)))","v":"N/A"},null,{"$f":"IF(F20=\"N/A\",\"N/A\",IF(F20>1,ROUNDUP(F20*1.15,0)))","v":"N/A"},null,{"$f":"IF(H20=\"N/A\",\"N/A\",IF(H20>1,ROUNDUP(H20*1.15,0)))","v":"N/A"},null,{"$f":"IF(J20=\"N/A\",\"N/A\",IF(J20>1,ROUNDUP(J20*1.15,0)))","v":"N/A"},null,{"$f":"IF(L20=\"N/A\",\"N/A\",IF(L20>1,ROUNDUP(L20*1.15,0)))","v":"N/A"}]
["Delivery Information"]
["Location of loading (e.g. supplier, ext. Warehouse etc.):",null,null,null,null,null,null,"Final Destination (e.g. TRISTONE Location, ext. Warehouse etc.):"]
[]
[]
[]
[]
["Address of the supplier’s production plant:",null,null,null,null,null,null,"Address for empties to be delivered to:"]
[]
[]
[]
[]
["Transport"]
["Delivery Terms (Incoterms):      ",null,null,null,null,"Select"]
["Delivery frequency:      ",null,null,null,null,"Select",null,null,null,"Select"]
["Kanban Delivery :  ",null,null,null,null,"Select",null,null,"JIT Delivery :  ",null,"Select"]
[null,"Quantity per Delivery:      "]
["Time Window"]
[null,null,null,null,null,"TRISTONE",null,null,null,"Supplier "]
[null,null,null,null,null,"Time",null,null,null,"Time"]
[null,"Monday               ",null,null,null,"from","Select","to","Select","from","Select","to","Select"]
[null,"Tuesday              ",null,null,null,"from","Select","to","Select","from","Select","to","Select"]
[null,"Wednesday         ",null,null,null,"from","Select","to","Select","from","Select","to","Select"]
[null,"Thursday",null,null,null,"from","Select","to","Select","from","Select","to","Select"]
[null,"Friday",null,null,null,"from","Select","to","Select","from","Select","to","Select"]
[null,"Saturday",null,null,null,"from","Select","to","Select","from","Select","to","Select"]
["Comments"]

{"sheet":"Container Rightsizing Tool","index":4,"n_rows":108,"n_cols":2,"rows_kept":108,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Decision Process for Container Right-Sizing and Material Movement Standards for Packaging"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["A","Review part presentation requirements from operator's perspective.  If parts are to be fed into a "]
[null,"machine, consider material handler interface with machine"]
[]
["B","Determine weight of part being handled.  Part weight is a major factor when determining standard"]
[null,"pack quantities.  In general, if the part weight is two pounds (one Kilogram) or less, a manually"]
[null,"handled container should be of primary consideration"]
[]
["C","Choose a container from the INTEVA Standard Container List.  Deviations from the Standard Container"]
[null,"list should occur only when parts do not fit in a standard container."]
[]
["D","If a part weighs more than two pounds (one Kilogram) or if the number of containers per eight hour"]
[null,"shift is greater than fifty (50), determine whether part should be bulk packed or if mechanical"]
[null,"assistance is required."]
[]
["E","The goal is to present parts to the operator in the supplier container where possible to avoid double-"]
[null,"handling of parts.  Only when significant reductions in operator cycle time outweigh the non-value-added"]
[null,"work of unpacking each part should parts be removed from containers by a material handler"]
[]
["F","Again the goal is to present the parts to the operator in the supplier container.  Consideration should"]
[null,"be given to designing the errorproofing system to include part presentation in the supplied container."]
[]
["G","Container will be part of the parts presentation device to the operator."]
[]
["H","While container may not be delivered directly to the point-of-use, container handling must still be"]
[null,"considered.  Ergonomics must also be considered."]
[]
["I","Use common lot strategy to develop standard container quantity.  Refer to Figure MM-4-F Strategy"]
[null,"for Determining Standard Container Quantities - Common Lots in DMS MM Manual attachments"]
[null,"for a discussion on common lot strategy.  Reference container recommendations for common purchased"]
[null,"parts if developed.  Once established, this standard pack or multiples of the standard pack must be"]
[null,"used in every shipment of that part."]
[]
["J","Fifty container moves per shift is a guideline for the maximum number of containers an operator"]
[" ","should handle in order to minimize non-value-added work content"]
[]
["K","Analyze the manufacturing process to determine if special material handling requirements are needed"]
[null,"for the containers being selected.  Obtain technical support from appropriate functional areas."]
[]
["L","Determine amount of material to be located at each workstation, which is dependent upon the frequency"]
[null,"of deliveries to the workstation.  Ensure adequate floor space is available when developing"]
[null,"a material handling plan."]
[]
["M","The use of returnables is based on an economic analysis of the total system. Expendable containers"]
[null,"should be used when the economic analysis does not support returnable containers."]
[]
["N","After the initial container selection is made, present the proposal to the operators and/or material"]
[null,"handlers for approval and feedback.  Feedback from areas using containers may disclose concerns"]
[null,"that were not known previously."]

{"sheet":"Change History","index":5,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"REVISION / APPROVAL HISTORY"]
[null,"Revision\nDate","Revision Level","Revision Comments","Document\nOwner / Title","Document\nApprover / Title","Signature","Approval Date"]
[null,"2024-08-01","1","First Edition","Christian Matzanke\n(Global Log. Director)\nGian Franco Buscemi\n(VP Purchasing)","Christian Matzanke\n(Global Log. Director)\nGian Franco Buscemi\n(VP Purchasing)","N/A","2024-11-01"]

{"sheet":"Supplier Packaging Info Old","index":6,"n_rows":516,"n_cols":21,"rows_kept":516,"cut":false,"hidden":true,"merged":[[57,2,57,3],[57,4,57,20],[46,5,46,7],[41,2,41,15],[36,5,36,8],[19,2,19,4],[32,9,33,9],[25,10,26,10],[27,9,27,12],[29,9,29,12],[23,9,23,12],[25,11,26,12],[23,13,24,15],[32,18,33,19],[32,17,33,17],[32,16,33,16],[32,11,33,12],[32,10,33,10],[27,20,31,20],[27,18,31,19],[27,17,31,17],[27,16,31,16],[32,13,33,15],[28,9,28,12],[21,16,21,19],[21,10,22,15],[20,5,20,11],[17,19,17,20],[17,2,17,4],[15,9,16,20],[12,2,12,4],[34,18,35,19],[18,5,18,11],[19,16,19,20],[18,19,18,20],[24,11,24,12],[20,2,20,4],[25,18,26,19],[25,17,26,17],[34,13,35,15],[30,9,30,12],[13,5,13,11],[12,5,12,11],[25,9,26,9],[20,12,20,15],[25,5,25,8],[25,2,26,4],[16,2,16,6],[10,2,10,11],[11,2,11,4],[13,2,13,4],[14,2,14,20],[18,12,18,15],[20,16,20,20],[18,2,18,4],[18,16,18,18],[17,15,17,16],[19,12,19,15],[17,5,17,7],[17,17,17,18],[19,5,19,11],[17,11,17,14],[17,8,17,10],[53,9,54,9],[37,5,37,8],[32,5,32,8],[27,5,27,8],[28,5,28,8],[26,5,26,6],[24,2,24,3],[23,5,24,8],[36,2,36,4],[26,7,26,8],[43,7,43,20],[37,2,37,3],[23,17,24,17],[23,16,24,16],[25,13,25,15],[26,13,26,14],[25,20,26,20],[23,18,24,19],[23,2,23,3],[23,20,24,20],[32,20,33,20],[45,16,45,20],[46,16,46,20],[45,8,46,15],[56,5,56,8],[49,5,50,8],[50,2,50,3],[49,2,49,3],[51,2,52,4],[51,5,52,8],[47,2,47,20],[49,17,50,17],[55,2,56,4],[56,14,56,15],[51,10,52,10],[51,11,52,12],[51,13,52,15],[56,16,56,17],[55,14,55,15],[55,11,55,13],[48,9,48,20],[55,9,55,10],[56,18,56,20],[56,9,56,10],[56,11,56,13],[49,18,50,19],[49,20,50,20],[49,13,50,15],[1,6,2,20],[13,12,13,15],[12,12,12,15],[11,12,11,15],[4,2,4,17],[3,2,3,20],[12,16,12,20],[13,16,13,20],[51,18,52,19],[51,20,52,20],[49,9,49,12],[51,9,52,9],[46,2,46,4],[50,11,50,12],[36,9,36,10],[30,5,30,8],[29,5,29,8],[31,5,31,8],[45,2,45,7],[38,2,38,4],[44,8,44,15],[38,5,38,19],[39,4,40,19],[44,2,44,7],[4,19,4,20],[9,2,9,20],[11,16,11,20],[8,2,8,4],[11,5,11,11],[5,12,5,15],[7,16,7,20],[55,18,55,20],[55,16,55,17],[53,2,54,4],[53,5,54,8],[53,17,54,17],[53,18,54,19],[55,5,55,8],[53,20,54,20],[53,10,54,10],[53,11,54,12],[51,17,52,17],[53,13,54,15],[21,2,22,9],[32,2,33,4],[27,2,31,4],[33,7,33,8],[33,5,33,6],[5,2,5,4],[6,2,6,4],[6,5,6,11],[7,2,7,4],[7,5,7,11],[8,5,8,20],[6,16,6,20],[5,16,5,20],[5,5,5,11],[7,12,7,15],[6,12,6,15],[42,2,42,9],[42,10,42,20],[41,16,41,20],[44,16,44,20],[34,2,35,4],[34,5,35,8],[34,9,35,9],[34,10,35,10],[34,11,35,12],[39,20,40,20],[39,2,40,3],[34,20,35,20],[36,18,36,19],[37,18,37,19],[37,14,37,15],[34,17,35,17],[37,11,37,13],[36,11,36,13],[37,9,37,10],[36,14,36,15]]}
[]
[null,null,null,null,null,null,"SUPPLIER PACKAGING INFORMATION"]
["Select"]
["No",null,"Please fill all\"BLUE\" highlighted cells that apply! Click \"Select\" for drop down boxes"]
["Barrel / Drum",null,"INTEVA PROVIDED INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
["Box - Single Wall",null,"Inteva Plant: ",null,null,"Select",null,null,null,null,null,null,"Contact Name:"]
["Box - Double Wall",null,"Packaging Type:",null,null,"Not Specified",null,null,null,null,null,null,"Contact Phone:"]
["Box - Triple Wall",null,"Inteva Container:",null,null,"22224740 - HSC - 23-7/16 x 14-7/8 x 3-11/16 in.",null,null,null,null,null,null,"Contact Email:"]
["Box with Bottles",null,"Special Requirements:"]
["Bucket",null,{"$f":"IF(F9=\"Expendable with a Returnable Estimate\",\"Use the Alternative Packaging section at the bottom to enter in a returnable packaging (round trip) cost estimate.\",\" \")","v":" "}]
["Can",null,"SUPPLIER PROVIDED INFORMATION"]
["Crate",null,"Supplier:",null,null,null,null,null,null,null,null,null,"Contact Name:"]
["Gaylord",null,"City & Country:",null,null,null,null,null,null,null,null,null,"Contact Phone:"]
["HSC - Single Wall",null,"Duns Number:",null,null,null,null,null,null,null,null,null,"Contact Email:"]
["HSC - Double Wall",null,"   I agree that I have read and will follow the requirements of the Inteva Products LLC Global Packaging and Shipping Manual:"]
["Pail",null,null,null,null,null,null,null,null,{"$f":"IF(I18>0,\"Mulitple parts are only allowed if they have the exact same annual volume, dimensions, and packaging. If this is not TRUE, then separate SPI forms must be completed.\",\" \")","v":" "}]
["Tote / KLT",null,"PART INFORMATION"]
["Tote / KLT with Bottles",null,"Inteva Part Number(s):"]
["Tote / KLT - Collapsible",null,"Part Description:",null,null,null,null,null,null,null,null,null,"Part Weight:",null,null,null,null,null,null,"Select Units"]
["Tote / KLT - Nestable",null,"Inteva Program:",null,null,null,null,null,null,null,null,null,"Part Fragility:",null,null,null,"Select"]
["Rack",null,"Annual Volume:",null,null,null,null,null,null,null,null,null,"TARIC / HS- Code:"]
["RSC - Single Wall ",null,"PACKAGING INFORMATION",null,null,null,null,null,null,null,{"$f":"IF(U22=\"R\",\"Alternative packaging must also be completed at bottom of form.\",IF(AND(F9=\"Expendable System with a Returnable Estimate\",U22=\"E\"),\"Returnable estimate required in the Alternative Packaging section.\",\" \"))","v":" "},null,null,null,null,null,"Expendable or Returnable?",null,null,null,"Select"]
["RSC - Double Wall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Currency:","Select"]
["Other-Note in Comments",null,"Size Units:",null,"Select","Package Type",null,null,null,"Dimensions",null,null,null,"Material",null,null,{"$f":"IF(F26=\"no\",\"Quantity Per SU\", \"Quantity Per PU\")","v":"Quantity Per PU"},"Tare\nWeight","Gross\nWeight",null,"Cost"]
[null,null,"Weight Units:",null,"Select",null,null,null,null,"L","W","H"]
[null,null,"Packaging Unit\n(PU)",null,null,"Select",null,null,null,null,null,null,null,"Select",null,null,50,null,{"$f":"IF(Q26=0,0,IF($Q$19=0,IF(OR(Q27=\"pounds\",Q27=\"kilograms\"),Q26+R26+$S$28+$S$33,0),IF(OR(Q27=\"Pieces\",Q27=\"Each\",Q27=\"Select\"),($Q$19*Q26)+R26+$S$28+$S$33,IF(OR(Q27=\"pounds\",Q27=\"kilograms\"),Q26+R26+$S$28+$S$33,0))))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR(F26=A19,F26=A20),\"Collapsible Ratio:\",IF(F26=\"HSC - Single Wall\",\"Full Layer Covers?\",IF(OR(F26=A9,F26=A18),\"Bottles Per PU:\",\" \")))","v":" "},null,null,null,null,null,null,null,{"$f":"IF(N26=\"Corrugated Board\",\"ECT/Burst:\",\" \")","v":" "},null,null,"Select"]
[null,null,"Dunnage/Protection",null,null,"Select",null,null,null,null,null,null,null,"Select",null,null,null,null,0]
[null,null,null,null,null,"Select"]
[]
[]
[null,null,null,null,null,{"$f":"IF(OR(F28=\"Partition\",F28=\"Dividers\",F28=\"Coated Dividers\",F28=\"Coated Partition\"),\"Number of Cells:\",\" \")","v":" "}]
["Select",null,"Dunnage/Protection",null,null,"Select",null,null,null,null,null,null,null,"Select",null,null,null,null,{"$f":"Q33*R33","v":0}]
["No",null,null,null,null,{"$f":"IF(OR(F33=\"Partition\",F33=\"Dividers\",F33=\"Coated Dividers\",F33=\"Coated Partition\"),\"Number of Cells:\",\" \")","v":" "}]
["Bags",null,"Pallet Container\nor Pallet",null,null,"Select",null,null,null,null,null,null,null,"Select",null,null,null,null,{"$f":"IF(Q35=0,R35,IF($Q$19=0,IF(OR(Q36=\"pounds\",Q36=\"kilograms\"),Q35+R35+$S$28+$S$33,0),IF(OR(Q36=\"Pieces\",Q36=\"Each\",Q36=\"Select\"),($Q$19*Q35)+R35+$S$28+$S$33,IF(OR(Q36=\"pounds\",Q36=\"kilograms\"),Q35+R35+$S$28+$S$33,0))))","v":0}]
["Moisture Barrier Bags",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select"]
["Electrostatic Discharge (ESD) Bags",null,"Shipping Unit",null,null,"Securement\nMethod",null,null,null,"Capable of\nStacking?",null,"PU/Layer",null,null,"Layers/SU",null,"QuantityPer SU",{"$f":"IF(E24=A33,\"Cubic Volume\",IF(E24=A75,\"Cubic Meters\",\"Cubic Feet\"))","v":"Cubic Volume"},"Gross\nWeight",null,"Cost per\nPart"]
["Volatile Corrosion Inhibitor (VCI) Bags",null,{"$f":"IF(J35=0,\" \",J35&\" x \"&K35&\" x \"&IF((L26*O38)>L35,(L35+(L26*O38)),L35))","v":" "},null,"(SU)","Select",null,null,null,"Select",null,5,null,null,4,null,{"$f":"IF(L38=0,IF(Q35=0,Q26,Q35),IF(Q35=0,Q26*L38*O38,Q35))","v":1000},{"$f":"IF(E24=\"Select\",\"Specify Units\",IF(AND(J35=0,Q35=0),IF(E24=\"mm.\",A352,A350),IF(AND(J26=0,Q26=0),IF(E24=\"mm.\",A348,A346),IF(E24=\"mm.\",A342,A344))))","v":"Specify Units"},{"$f":"IF(Q26=0,S35,IF(L38=0,S26+S35,(S26*L38*O38)+R35))","v":0}]
["Air Bags",null,"Package Validation:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% Complete"]
["Liner Bag",null,"Comments:\nMixed Load?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A491","v":0.14705882352941177}]
["Bubble Wrap"]
["Desiccants",null,{"$f":"IF(J38=\"No\",\"Packaging designs must be capable of stacking. Redesign the packaging to be capable of stacking.\",IF(OR(F35=A65,F35=A67,F35=A69),\"If the \"&F35&\" is collapsible, then specify the ratio in the comments.\",IF(OR(F33=\"Select\",F33=\"No\"),\" \",\"If there is additional dunnage, then specify type, material, and cost/part in the comments section.\")))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K35>0,IF(L38=0,IF((J26*K26)>(J35*K35),\"Boxes must not overhang off of the pallet.\",\" \"),IF((J26*K26*L38)>(J35*K35),\"Boxes must not overhang off of the pallet.\",\" \")),\" \")","v":" "}]
["Dividers",null,{"$f":"IF(F35=A58,\" \",IF(AND(E24=A74,OR(F35=A61,F35=A62,F35=A63,F35=A64)),IF(((L26*O38)+L35)>52,\"SU height must be below 52 in/1320 mm in USA.\",\" \"),IF(AND(E24=A75,OR(F35=A61,F35=A62,F35=A63,F35=A64)),IF(((L26*O38)+L35)>1500,\"SU height must be below 1500 mm Europe/Asia, 1320 mm USA.\",\" \"),\" \")))","v":" "},null,null,null,null,null,null,null,{"$f":"IF(E25=\"lbs.\",IF(E24=\"in.\",IF(S26>(410/((0.5*K26)+8)),\"The PU is not safe to handle manually. Refer to the ergonomics section in the manual.\",\" \"),IF(S26>(10414/((0.5*K26)+203.2)),\"The PU is not safe to handle manually. Refer to the ergonomics section in the manual.\",\" \")),IF(E24=\"in.\",IF(S26>(186/((0.5*K26)+8)),\"The PU is not safe to handle manually. Refer to the ergonomics section in the manual.\",\" \"),IF(S26>(4723/((0.5*K26)+203.2)),\"The PU is not safe to handle manually. Refer to the ergonomics section in the manual.\",\" \")))","v":" "}]
["Coated Dividers",null,"Pictures or Drawings",null,null,null,null,"To add pictures: Save them to your computer, then select Insert -> Picture from the toolbar above.  Select the pictures from your computer, then re-size and drag them to the appropriate cells below."]
["Inlay",null,"Part",null,null,null,null,null,"Part Orientation in Packaging Unit",null,null,null,null,null,null,null,"Shipping Unit"]
["Pad"]
["Paper",null,"Part Dimensions:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J35=0,\" \",\"Shipping Unit Dimensions: \"&J35&\"x\"&K35&\"x\"&IF((L26*O38)>L35,(L35+(L26*O38)),L35)&\" \"&IF(OR(E24=\"in.\",E24=\"mm.\"),E24,\" \"))","v":" "}]
["Partition"]
["Coated Partition",null,"ALTERNATIVE PACKAGING",null,null,null,null,null,null,"*Supplier is responsible for designing a backup expendable system if a returnable system is used. "]
["Pouch",null,"Size Units:",null,"Select","Package Type",null,null,null,"Dimensions",null,null,null,"Material",null,null,"Quantity","Tare\nWeight","PU Gross\nWeight",null,"Cost per\nPart"]
["Reel ",null,"Weight Units:",null,"Select",null,null,null,null,"L","W","H",null,null,null,null,"Pcs./PU"]
["Sheet",null,"Packaging Unit\n(PU)",null,null,"Select",null,null,null,null,null,null,null,"Select",null,null,null,null,{"$f":"IF(Q52=0,0,IF($Q$19=0,IF(OR(Q53=\"pounds\",Q53=\"kilograms\"),Q52+R52,0),IF(OR(Q53=\"Pieces\",Q53=\"Each\",Q53=\"Select\"),($Q$19*Q52)+R52,IF(OR(Q53=\"pounds\",Q53=\"kilograms\"),Q52+R52,0))))","v":0}]
["Tray",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select"]
["Tray - Nested",null," Pallet Container or \nPallet",null,null,"Select",null,null,null,null,null,null,null,"Select",null,null,null,null,{"$f":"IF(Q54=0,R54,IF($Q$19=0,IF(OR(Q55=\"pounds\",Q55=\"kilograms\"),Q54+R54,0),IF(OR(Q55=\"Pieces\",Q55=\"Each\",Q55=\"Select\"),($Q$19*Q54)+R54,IF(OR(Q55=\"pounds\",Q55=\"kilograms\"),Q54+R54,0))))","v":0}]
["Tray - Molded",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select"]
["Other",null,"Shipping Unit\n(SU)",null,null,"Securement Method",null,null,null,"PU/Layer",null,"Layers/SU",null,null,"Quantity/SU",null,"Gross Weight",null," Total Cost per Part"]
[null,null,null,null,null,"Select",null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q52>0,J57>0),Q52*J57*L57,IF(Q54>0,Q54,Q52))","v":0},null,{"$f":"IF(J57=0,S52+S54,IF(Q54=0,((S52*J57*L57)+S54),S54))","v":0}]
["Select",null,"Comments:"]
["No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPI Form October 1, 2015"]
["None - Shipping individual PUs"]
["Pallet"]
["Pallet with Lid"]
["Euro Pallet"]
["Euro Pallet with Lid"]
["Pallet + Shipping Container"]
["Pallet + Gaylord"]
["Bulk Container"]
["Rack"]
["Gitter Box"]
["Crate"]
["Other - Specify in Comments"]
["Currency"]
["Select"]
["in."]
["mm."]
["Select Units"]
["lbs."]
["kg."]
["Does Not Apply"]
[]
[]
[]
["Select"]
["Class A Surface"]
["High"]
["Medium"]
["Low"]
["Select"]
["E"]
["R"]
[]
["Select"]
["No"]
["Stretch Wrap"]
["Banding"]
["Both Stretch Wrap and Bands"]
["Corner Guards and Stretch Wrap"]
["Corner Guards and Bands"]
["Lid or Top Cap"]
["Other - Specify in Comments"]
[]
["Select"]
["Plastic"]
["Plastic - ESD"]
["Corrugated Board"]
["Corrugated Board - ESD"]
["Wood"]
["Metal"]
[]
["Select"]
[]
["Chipboard"]
["Chipboard - Coated"]
["Corrugated Board"]
["Corrugated Board - Coated"]
["Foam"]
["Foam - Open Cell"]
["Foam - Closed Cell"]
["Foam - Styrofoam"]
["Foil"]
["Foil - Mylar"]
["Foil - Tyvek"]
["Kraft"]
["Kraft - Coated"]
["Paper"]
["Paper - Coated"]
["Paperboard"]
["Paperboard - Coated"]
["Plastic"]
["Plastic - PE"]
["Plastic - PET"]
["Plastic - LDPE"]
["Plastic - HDPE"]
["Plastic - PP"]
["Plastic - PS"]
["Plastic - PVC"]
["SBS"]
["SBS - Coated"]
["Volatile Corrosion Inhibitor (VCI)"]
["Other - Specify in Comments"]
[]
[]
[]
[]
["Select"]
["Wood"]
["Heat Treated Wood"]
["Plastic"]
["Corrugated Board"]
["Metal"]
["Corrugated Box & Wood Pallet"]
[]
["Select"]
["Yes"]
["No"]
["Select"]
["lbs."]
["kg."]
["Select",null,"Select"]
["No",null,"No"]
["1 on 1  (Double)",null,"1 on 1  (Double)"]
["2 on 1 (Triple)",null,"2 on 1 (Triple)"]
["3 on 1",null,"3 on 1"]
["3+ on 1",null,"4 on 1"]
["Select",null,"5 on 1"]
["Pieces",null,"6 on 1"]
["Each",null,"6+ on 1"]
["Pounds"]
["Kilograms"]
["Milliliters"]
["Litres"]
["Fluid Ounces"]
["Gallons"]
["Feet"]
["Inches"]
["Meters"]
["Centimeters"]
[]
[]
[]
[]
["Select"]
[]
["Not Specified"]
[]
["Tristone Returnable Standards"]
["VDA-RL-KLT 3147-300x200x147mm"]
["VDA-RL-KLT 4147-400x300x147mm"]
["VDA-RL-KLT 4213-400x300x213mm"]
["VDA-RL-KLT 4280-400x300x280mm"]
["VDA-RL-KLT 6147-600x400x147mm"]
["VDA-RL-KLT 6213-600x400x213mm"]
["VDA-RL-KLT 6280-600x400x280mm"]
["VDA-R-KLT 3215-300x200x147mm"]
["VDA-R-KLT 4315-400x300x147mm"]
["VDA-R-KLT 4322-400x300x213mm"]
["VDA-R-KLT 4329-400x300x280mm"]
["VDA-R-KLT 6415-600x400x147mm"]
["VDA-R-KLT 6422-600x400x213mm"]
["VDA-R-KLT 6429-600x400x280mm"]
["Eurobox-Euro2145-200x150x145mm"]
["Eurobox-Euro 3212-300x200x120mm"]
["Eurobox-Euro 3215-300x200x145mm"]
["Eurobox-Euro 4375-400x300x75mm"]
["Eurobox-Euro 4312-400x300x120mm"]
["Eurobox-Euro 4317-400x300x175mm"]
["Eurobox-Euro 4323-400x300x235mm"]
["Eurobox-Euro 6475-600x400x75mm"]
["Eurobox-Euro 6412-600x400x120mm"]
["Eurobox-Euro 6417-600x400x175mm"]
["Eurobox-Euro 6423-600x400x235mm"]
["Eurobox-Euro 6432-600x400x320mm"]
["Eurobox-Euro 6441-600x400x410mm"]
["Eurobox-Euro 8420-800x400x200mm"]
["Eurobox-Euro 8620-800x600x200mm"]
["Eurobox-Euro 1042-1000x400x214mm"]
["ESD RL-KLT-3215-300x200x150mm"]
["ESD RL-KLT-4315-400x300x150mm"]
["ESD RL-KLT-4328-400x300x290mm"]
["ESD RL-KLT-6415-600x400x150mm"]
["ESD RL-KLT-6428-600x400x290mm"]
["ESD RL-KLT-8622-800x600x220mm"]
["ESD R-KLT-3215-300x200x150mm"]
["ESD R-KLT-4315-400x300x150mm"]
["ESD R-KLT-4329-400x300x290mm"]
["ESD R-KLT-6415-600x400x150mm"]
["ESD R-KLT-6429-600x400x290mm"]
["Foldable Magnum box-MO 595-1200x1000x595mm"]
["Foldable Magnum box-MO 750-1200x1000x750mm"]
["Foldable Magnum box-SH 835 HD-800x600x835mm"]
["Foldable Magnum box-MO 870-1200x1000x870mm"]
["Foldable Magnum box-CE 950 S-1200x800x950mm"]
["Foldable Magnum box-OI 975 S-1200x1000x975mm"]
["Foldable Magnum box-MO 1000-1200x1000x1000mm"]
["Foldable sleeve box-800x600x710mm"]
["Foldable sleeve box-800x600x750mm"]
["Foldable sleeve box-1200x1000x990mm"]
["Foldable sleeve box-1230x830x945mm"]
["Foldable sleeve box-1600x1200x750mm"]
["Foldable sleeve box-1600x1200x980mm"]
["Foldable sleeve quad box-1230x830x955mm"]
["Foldable sleeve quad box-1230x1020x990mm"]
["Foldable sleeve quad box-1230x1230x985mm"]
[]
["Tristone Expendable Standards"]
["SW Cardboard box - 200 x 200 x 150 mm"]
["SW Cardboard box - 300 x 200 x 100 mm"]
["SW Cardboard box - 300 x 200 x 150 mm"]
["SW Cardboard box - 300 x 200 x 200 mm"]
["SW Cardboard box - 400 x 200 x 100 mm"]
["SW Cardboard box - 400 x 300 x 100 mm"]
["SW Cardboard box - 400 x 300 x 150 mm"]
["SW Cardboard box - 400 x 300 x 200 mm"]
["SW Cardboard box - 400 x 300 x 300 mm"]
["SW Cardboard box - 500 x 300 x 200 mm"]
["SW Cardboard box - 500 x 400 x 200 mm"]
["SW Cardboard box - 500 x 400 x 300 mm"]
["SW Cardboard box - 600 x 400 x 150 mm"]
["SW Cardboard box - 600 x 400 x 200 mm"]
["SW Cardboard box - 600 x 400 x 300 mm"]
["SW Cardboard box - 600 x 400 x 400 mm"]
[]
["DW Cardboard box - 300 x 200 x 150 mm"]
["DW Cardboard box - 300 x 200 x 200 mm"]
["DW Cardboard box - 400 x 300 x 200 mm"]
["DW Cardboard box - 400 x 300 x 300 mm"]
["DW Cardboard box - 600 x 400 x 200 mm"]
["DW Cardboard box - 600 x 400 x 300 mm"]
["DW Cardboard box - 600 x 400 x 400 mm"]
["DW Cardboard box - 600 x 500 x 400 mm"]
["DW Cardboard box - 800 x 400 x 400 mm"]
["DW Cardboard box - 800 x 600 x 400 mm"]
["DW Cardboard box - 800 x 600 x 600 mm"]
["DW Cardboard box - 1200 x 800 x 800 mm"]
[]
["North American Returnable Standards"]
["Tote - 12 x 7.5 x 4 in."]
["Tote - 12 x 15 x 4 in."]
["Tote - 12 x 15 x 4 in."]
["Tote - 24 x 15 x 4 in."]
["Tote - 24 x 15 x 7.5 in."]
["Tote - 24 x 15 x 11 in."]
["Tote - 24 x 15 x 14.5 in."]
["Tote - 24 x 22.5 x 7.5 in."]
["Tote - 24 x 22.5 x 11 in."]
["Tote - 24 x 22.5 x 14.5 in."]
["Pallet Container - 32 x 30 x 25  in."]
["Pallet Container - 32 x 30 x 34  in."]
["Pallet Container - 48 x 45 x 25  in."]
["Pallet Container - 48 x 45 x 34  in."]
[]
["North American Expendable Standards"]
["RSC - 9 x 9 x 4 in."]
["RSC - 9 x 9 x 6 in."]
["RSC - 12 x 7.5 x 3.75 in."]
["RSC - 12 x 15 x 3.75 in."]
["RSC - 12 x 15 x 7.5 in."]
["RSC - 24 x 15 x 3.75 in."]
["RSC - 24 x 15 x 7.5 in."]
["RSC - 24 x 15 x 11.25 in."]
["RSC - 24 x 15 x 14.5 in."]
["RSC - 24 x 22.5 x 7.5 in."]
["RSC - 24 x 22.5 x 11.25 in."]
["RSC - 24 x 22.5 x 14.5 in."]
["HSC - 11-11/16 x 7-7/16 x 3-11/16 in."]
["HSC - 11-11/16 x 14-7/8 x 3-11/16 in."]
["HSC - 11-11/16 x 14-7/8 x 7-3/8 in."]
["HSC - 23-7/16 x 14-7/8 x 3-11/16 in."]
["HSC - 23-7/16 x 14-7/8 x 7-3/8 in."]
["HSC - 23-7/16 x 14-7/8 x 11-1/16 in."]
["HSC - 23-7/16 x 14-7/8 x 14-3/8 in."]
["HSC - 23-7/16 x 22-5/8 x 7-3/8 in."]
["HSC - 23-7/16 x 22-5/8 x 11-1/16 in."]
["HSC - 23-7/16 x 22-5/8 x 14-3/4 in. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Select"]
[null,null,null,null,null,null,"/"]
[null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,"00:30:00"]
[null,null,null,null,null,null,"01:00:00"]
[null,null,null,null,null,null,"01:30:00"]
[null,null,null,null,null,null,"02:00:00"]
[null,null,null,null,null,null,"02:30:00"]
[null,null,null,null,null,null,"03:00:00"]
[null,null,null,null,null,null,"03:30:00"]
[null,null,null,null,null,null,"04:00:00"]
["Not Specified",null,null,null,null,null,"04:30:00"]
["Expendable System / One Way",null,null,null,null,null,"05:00:00"]
["Returnable System / Round Trip",null,null,null,null,null,"05:30:00"]
["Expendable with a Returnable Estimate",null,null,null,null,null,"06:00:00"]
[null,null,null,null,null,null,"06:30:00"]
["Cubic Meters: Pallet and Boxes",null,null,null,null,null,"07:00:00"]
[{"$f":"ROUNDUP((((J35*K35*((O38*L26)+L35)))*0.000000001),2)","v":0},null,null,null,null,null,"07:30:00"]
["Cubic Feet: Pallet and Boxes",null,null,null,null,null,"08:00:00"]
[{"$f":"ROUNDUP((((J35*K35*((O38*L26)+L35)))*0.0005787),2)","v":0},null,null,null,null,null,"08:30:00"]
["Cubic Feet: Just Pallet",null,null,null,null,null,"09:00:00"]
[{"$f":"ROUNDUP(((J35*K35*L35)*0.0005787),2)","v":0},null,null,null,null,null,"09:30:00"]
["Cubic Meters Just Pallet",null,null,null,null,null,"10:00:00"]
[{"$f":"ROUNDUP(((J35*K35*L35)/1000000000),2)","v":0},null,null,null,null,null,"10:30:00"]
["Cubic Feet: Just Boxes",null,null,null,null,null,"11:00:00"]
[{"$f":"ROUNDUP(((J26*K26*L26)*0.0005787),2)","v":0},null,null,null,null,null,"11:30:00"]
["Cubic Meters: Just Boxes",null,null,null,null,null,"12:00:00"]
[{"$f":"ROUNDUP(((J26*K26*L26)*0.000000001),2)","v":0},null,null,null,null,null,"12:30:00"]
[null,null,null,null,null,null,"13:00:00"]
[null,null,null,null,null,null,"13:30:00"]
["Select",null,null,null,null,null,"14:00:00"]
["Tristone Cerkezkoey [Turkey]",null,null,null,null,null,"14:30:00"]
["Tristone Chihuahua [Mexico]",null,null,null,null,null,"15:00:00"]
["Tristone Cirie [Italy]",null,null,null,null,null,"15:30:00"]
["Tristone Delicias [Mexico]",null,null,null,null,null,"16:00:00"]
["Tristone Hradek [Czech Rep.]",null,null,null,null,null,"16:30:00"]
["Tristone Nantes [France]",null,null,null,null,null,"17:00:00"]
["Tristone Ninguo [China]",null,null,null,null,null,"17:30:00"]
["Tristone Nova Bana [Slovakia]",null,null,null,null,null,"18:00:00"]
["Tristone Pune [India]",null,null,null,null,null,"18:30:00"]
["Tristone Tarazona [Spain]",null,null,null,null,null,"19:00:00"]
["Tristone Walbrzych [Poland]",null,null,null,null,null,"19:30:00"]
["Tristone Wuxi [China]",null,null,null,null,null,"20:00:00"]
["…",null,null,null,null,null,"20:30:00"]
["…",null,null,null,null,null,"21:00:00"]
[null,null,null,null,null,null,"21:30:00"]
["Select",null,null,null,null,null,"22:00:00"]
["Audi",null,null,null,null,null,"22:30:00"]
["BMW",null,null,null,null,null,"23:00:00"]
["BYD",null,null,null,null,null,"23:30:00"]
["Dacia"]
["FCA"]
["Ford"]
["GM"]
["JLR"]
["Li Auto"]
["Mercedes"]
["Nissan"]
["Opel"]
["Renault"]
["Seat"]
["Skoda"]
["Stellantis"]
["Suzuki"]
["Volvo"]
["VW"]
["Other"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Select","Select"]
["Select",null,null,"Select",null,null,null,null,null,null,null,null,"1x","per week"]
["EXW (Ex Works)",null,null,"YES",null,null,null,null,null,null,null,null,"2x","per month"]
["FCA (Free Carrier)",null,null,"NO",null,null,null,null,null,null,null,null,"3x"]
["FAS (Free Alongside Ship)",null,null,null,null,null,null,null,null,null,null,null,"4x"]
["FOB (Free On Board)",null,null,null,null,null,null,null,null,null,null,null,"5x"]
["CFR (Costs & Freight)"]
["CIF (Costs, Insurance & Freight)"]
["CPT (Carriage Paid To)"]
["CIP (Carriage & Insurance Paid to)"]
["DAP (Delivered At Place)"]
["DPU ( Delivered at Place Unloaded)"]
["DDP (Delivery Duty Paid)"]
["Other - Specify in Comments"]
[]
[]
[]
[]
[]
[]
[]
[]
["Collapsible\nRatio"]
[]
[]
["Exp or Ret"]
[{"$f":"IF(U22<>\"Select\",1,0)","v":0}]
["Currency"]
[{"$f":"IF(U23<>\"Select\",1,0)","v":0}]
["Size Units"]
[{"$f":"IF(E24<>\"Select\",1,0)","v":0}]
["Weight Units"]
[{"$f":"IF(E25<>\"Select\",1,0)","v":0}]
["PU Package Type"]
[{"$f":"IF(RSC<>\"Select\",1,0)","v":0}]
["PU Dimension - L"]
[{"$f":"IF(OR(F26=\"No\",J26>0),1,0)","v":0}]
["PU Dimension - W"]
[{"$f":"IF(OR(F26=\"No\",K26>0),1,0)","v":0}]
["PU Dimension - H"]
[{"$f":"IF(OR(F26=\"No\",L26>0),1,0)","v":0}]
["PU Material"]
[{"$f":"IF(OR(F26=\"No\",Corrugated_Board<>\"Select\"),1,0)","v":0}]
["PU ECT"]
[{"$f":"IF(OR(F26=\"No\",N26=\"Plastic\",N26=\"Metal\",N26=\"Wood\",AND(N26=\"Corrugated Board\",P27<>0)),1,0)","v":0}]
["PU Quantity"]
[{"$f":"IF(OR(F26=\"No\",Q26>0),1,0)","v":1}]
["PU Quantity Unit"]
[{"$f":"IF(OR(F26=\"No\",Q27<>\"Select\"),1,0)","v":0}]
["PU Tare Weight"]
[{"$f":"IF(OR(F26=\"No\",R26>0),1,0)","v":0}]
["PU Cost"]
[{"$f":"IF(OR(F26=\"No\",U26<>0),1,0)","v":0}]
["Dun 1 Package Type"]
[{"$f":"IF(F28<>\"Select\",1,0)","v":0}]
["Dun 1 Material"]
[{"$f":"IF(OR(F28=\"NO\",N28<>\"Select\"),1,0)","v":0}]
["Dun 1 Quantity"]
[{"$f":"IF(OR(F28=\"NO\",Q28>0),1,0)","v":0}]
["Dun 1 Cost"]
[{"$f":"IF(OR(F28=\"NO\",U28<>0),1,0)","v":0}]
["Dun 2 Package Type"]
[{"$f":"IF(F33<>\"Select\",1,0)","v":0}]
["Dun 2 Material"]
[{"$f":"IF(OR($F$33=\"No\",N33<>\"Select\"),1,0)","v":0}]
["Dun 2 Quantity"]
[{"$f":"IF(OR($F$33=\"No\",Q$33>0),1,0)","v":0}]
["Dun 2 Cost"]
[{"$f":"IF(OR($F$33=\"No\",U$33<>0),1,0)","v":0}]
["Pallet Package Type"]
[{"$f":"IF(F35<>\"Select\",1,0)","v":0}]
["Pallet Material"]
[{"$f":"IF(OR($F$35=\"NO\",F35 = \"none - Shipping Individual PUs\",$N$35<>\"Select\"),1,0)","v":0}]
["Pallet Quantity"]
[{"$f":"IF(OR($F$35=\"NO\",F35 = \"none - Shipping Individual PUs\",$J$35>0,Q26>0),1,0)","v":1}]
["Pallet Quantity Unit"]
[{"$f":"IF(OR(F35 = \"none - Shipping Individual PUs\",$F$35=\"NO\",Q26>0,AND($Q$35>0,Q36<>\"Select\")),1,0)","v":1}]
["Pallet Tare Weight"]
[{"$f":"IF(OR($F$35=\"NO\",F35 = \"none - Shipping Individual PUs\",$R$35>0),1,0)","v":0}]
["Pallet Cost"]
[{"$f":"IF(OR(F35 = \"none - Shipping Individual PUs\",$F$35=\"NO\",$U$35<>0),1,0)","v":0}]
["Securement"]
[{"$f":"IF(OR(F35 = \"no\", F35 = \"none - Shipping Individual PUs\",F38<>\"Select\"),1,0)","v":0}]
["Stacking"]
[{"$f":"IF(OR(J38<>\"Select\",F35=\"No\",F35=\"None - Shipping Individual PUs\"),1,0)","v":0}]
["PU/Layer"]
[{"$f":"IF(OR($F$26=\"No\",$F$35=\"No\",$F$35 = \"none - Shipping Individual PUs\",L$38>0),1,0)","v":1}]
["Layer/SU"]
[{"$f":"IF(OR($F$26=\"No\",$F$35=\"No\",$F$35 = \"none - Shipping Individual PUs\",O$38>0),1,0)","v":1}]
["Cubic Volume"]
[{"$f":"IF(R38=\"Specify Units\",0,1)","v":0}]
["SU Cost"]
[{"$f":"IF(U38<>0,1,0)","v":0}]
["Total Cells"]
[{"$f":"COUNT(A418:A485)","v":34}]
["Total Filled"]
[{"$f":"SUM(A418:A485)","v":5}]
["Percent Complete"]
[{"$f":"A489/A487","v":0.14705882352941177}]
[0.25]
[0.4]
[0.55000000000000004]
[0.7]
[0.8]
[0.9]
[0.95]
[]
["Select"]
["USD"]
["EUR"]
["AUD"]
["BRL"]
["CAD"]
["CNY"]
["CZK"]
["GBP"]
["INR"]
["JPY"]
["KRW"]
["MXN"]
["PLN"]
["RON"]
["SEK"]
["ZAR"]