{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Page1","Page2","Page3","Final_Layout","Aux","How to fill"],"not_rendered":{"charts":0,"images":34,"macros":1,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Page1","index":0,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[25,6,26,6],[29,5,33,6]]}
[]
["Packaging Specification Form"]
[]
[]
[]
[null,"Material Information"]
[]
[null,null," Project name:",null,null," Production lot size:"]
[]
[null,null," Material No:",null,null," Material Description:"]
[]
[null,null," Dimension mm (lxwxh):",null,null," Weight of one part (kg):",1]
[]
[null,null," Transportation method:",null,null," Incoterm:"]
[]
[]
[null,"Protection Requirements"]
[]
[null,null,"Mechanical & Cosmetic Protection",null,null,"Corrosion & Moister Protection"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(Aux!$O$5=TRUE,\"Please indicate the protection requirement\",\"\")","v":""}]
[]
[]
[null,null,null,null,null,"Notes:"]
[]
[]
[]
[]
[null,null,null,{"$f":"IF(Aux!$K$9=TRUE,\"Please indicate the protection requirement\",\"\")","v":""}]

{"sheet":"Page2","index":1,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[28,2,31,6]]}
[]
["Packaging Specification Form"]
[]
[]
[]
[null,"Packaging Definition"]
[]
[null,null," Box type:","Fefco 201"]
[]
[null,null," Box dimension mm (l):",600]
[]
[null,null," Box dimension mm (w):",400]
[]
[null,null," Box dimension mm (h):",300]
[]
[null,null," Inlay type:","Carton Inlay"]
[]
[null,"Logistics"]
[]
[null,null," Pallet dimension mm (l):",1200]
[]
[null,null," Pallet dimension mm (w):",800]
[]
[null,null," Max stackability of pallets with same Mat.No.","Ground level +1"]
[]
[null,null," Max additional weight on upmost level (kg)","Please do not fill. Automatically calculated on report page"]
[]
[null,null,"Notes:"]
[]
[]
[]
[]
[null,null,null,{"$f":"IF(K8=TRUE,\"Please indicate the protection requirement\",\"\")","v":""}]

{"sheet":"Page3","index":2,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[24,2,30,6]]}
[]
["Packaging Specification Form"]
[]
[]
[]
[null,"Packaging Proposal",null,null,null,"Units Forecast"]
[]
[null,null," Parts per box:",15,null," 1st Year:"]
[]
[null,null," Weight of full box (kg):",{"$f":"D8*Page1!G12","v":15},null," 2nd Year:"]
[]
[null,null," Layers per box:",1,null," 3rd Year:"]
[]
[null,null," Parts per layer:",15]
[]
[null,null," Boxes per pallet:",30]
[]
[null,null," Pcs per pallet:",45]
[]
[null,null," Pallet load weight (kg):",{"$f":"(D16*D10)+20","v":470}]
[]
[]
[null,"Additional Notes"]

{"sheet":"Final_Layout","index":3,"n_rows":91,"n_cols":20,"rows_kept":91,"cut":false,"hidden":false,"merged":[[17,0,17,6],[17,8,17,14],[18,12,18,14],[12,0,12,4],[13,0,13,4],[13,5,13,9],[18,8,18,11],[13,10,14,19],[14,0,14,5],[11,15,11,19],[12,15,12,19],[7,0,7,4],[8,0,8,4],[9,0,9,4],[10,0,10,4],[11,0,11,4],[7,5,7,9],[8,5,8,9],[11,10,11,14],[12,10,12,14],[9,5,9,9],[10,5,10,9],[11,5,11,9],[12,5,12,9],[6,10,6,19],[7,10,7,14],[8,10,8,14],[9,10,9,14],[10,10,10,14],[7,15,7,19],[8,15,8,19],[10,15,10,19],[9,15,9,19],[24,3,29,6],[28,8,29,19],[21,8,24,11],[25,8,27,11],[21,12,24,14],[25,12,27,14],[23,0,23,6],[19,0,21,2],[19,8,20,14],[32,0,32,6],[33,5,33,6],[33,0,33,4],[34,0,34,4],[34,5,34,6],[90,0,102,19],[35,0,35,4],[35,5,35,6],[36,0,36,4],[36,5,36,6],[37,0,37,4],[37,5,37,6],[85,0,89,19],[38,0,38,4],[38,5,38,6],[39,0,39,4],[39,5,39,6]]}
[]
["Packaging Specification Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1 | 2"]
[{"$f":"IF(Page1!D8=\"\",\"\",Page1!D8)","v":""}]
[]
[]
[]
["Material Information",null,null,null,null,null,null,null,null,null,"Protection Requirements"]
[" Material No:",null,null,null,null,{"$f":"IF(Page1!D10=\"\",\"\",Page1!D10)","v":""},null,null,null,null,"Mechanical & Cosmetic Protection",null,null,null,null,"Corrosion & Moister Protection"]
[" Material Description:",null,null,null,null,{"$f":"IF(Page1!G10=\"\",\"\",Page1!G10)","v":""},null,null,null,null,{"$f":"IF(Aux!M2=\"\",\"\",Aux!M2)","v":""},null,null,null,null,{"$f":"IF(Aux!Q2=\"\",\"\",Aux!Q2)","v":""}]
[" Dimension (LxWxH):",null,null,null,null,{"$f":"IF(Page1!D12=\"\",\"\",Page1!D12)","v":""},null,null,null,null,{"$f":"IF(Aux!M3=\"\",\"\",Aux!M3)","v":""},null,null,null,null,{"$f":"IF(Aux!Q3=\"\",\"\",Aux!Q3)","v":""}]
[" Weight of one part (kg):",null,null,null,null,{"$f":"IF(Page1!G12=\"\",\"\",Page1!G12)","v":1},null,null,null,null,{"$f":"IF(Aux!M4=\"\",\"\",Aux!M4)","v":""},null,null,null,null,{"$f":"IF(Aux!Q4=\"\",\"\",Aux!Q4)","v":""}]
[" Production lot size:",null,null,null,null,{"$f":"IF(Page1!G8=\"\",\"\",Page1!G8)","v":""},null,null,null,null,{"$f":"IF(Aux!M5=\"\",\"\",Aux!M5)","v":""},null,null,null,null,{"$f":"IF(Aux!Q5=\"\",\"\",Aux!Q5)","v":""}]
[" Incoterm:",null,null,null,null,{"$f":"IF(Page1!G14=\"\",\"\",Page1!G14)","v":""},null,null,null,null,{"$f":"IF(Aux!M6=\"\",\"\",Aux!M6)","v":""},null,null,null,null,{"$f":"IF(Aux!Q6=\"\",\"\",Aux!Q6)","v":""}]
[" Transportation method:",null,null,null,null,{"$f":"IF(Page1!D14=\"\",\"\",Page1!D14)","v":""},null,null,null,null,{"$f":"\"Notes: \"&Page1!F30","v":"Notes: "}]
[" Units Forecast (1st|2nd|3rd Y):",null,null,null,null,null,{"$f":"IF(Page3!G8=\"\",\"\",Page3!G8)","v":""},{"$f":"IF(Page3!G10=\"\",\"\",Page3!G10)","v":""},{"$f":"IF(Page3!G12=\"\",\"\",Page3!G12)","v":""}]
[]
[]
["Packaging Definition",null,null,null,null,null,null,null,"Logistics"]
[null,null,null,null,null,null,null,null,"Pallet Dimensions",null,null,null,{"$f":"IF(OR(Page2!D20=\"\",Page2!D22=\"\"),\"\",Page2!D20&\"L \"&Page2!D22&\"W\")","v":"1200L 800W"}]
[{"$f":"IF(Page2!D8=\"\",\"\",Page2!D8)","v":"Fefco 201"},null,null,{"$f":"IF(Page2!D10=\"\",\"\",Page2!D10&\"L\")","v":"600L"},null,null,null,null,"Stacking"]
[null,null,null,{"$f":"IF(Page2!D12=\"\",\"\",Page2!D12&\"W\")","v":"400W"}]
[null,null,null,{"$f":"IF(Page2!D14=\"\",\"\",Page2!D14&\"H\")","v":"300H"},null,null,null,null,"Max stackability of pallets with same Mat.No.",null,null,null,{"$f":"IF(Page2!D24=\"\",\"\",Page2!D24)","v":"Ground level +1"}]
[]
["Inlay Concept"]
[null,null,null,{"$f":"IF(Page2!D16=\"\",\"\",Page2!D16)","v":"Carton Inlay"}]
[null,null,null,null,null,null,null,null,"Max additional weight on upmost level(kg)",null,null,null,{"$f":"IF(Page3!D20=0,\"\",Page3!D20)","v":470}]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"\"Notes: \"&Page2!C29","v":"Notes: "}]
[]
[]
[]
["Packaging Proposal",null,null,null,null,null,null,"Fefco 201","Carton Inlay","Ground level +1"]
[" Parts per box:",null,null,null,null,{"$f":"IF(Page3!D8=\"\",\"\",Page3!D8)","v":15}]
[" Weight of full box (kg):",null,null,null,null,{"$f":"IF(Page3!D10=\"\",\"\",Page3!D10)","v":15}]
[" Layers per box:",null,null,null,null,{"$f":"IF(Page3!D12=\"\",\"\",Page3!D12)","v":1}]
[" Parts per layer:",null,null,null,null,{"$f":"IF(Page3!D14=\"\",\"\",Page3!D14)","v":15}]
[" Boxes per pallet:",null,null,null,null,{"$f":"IF(Page3!D16=\"\",\"\",Page3!D16)","v":30}]
[" Pcs per pallet:",null,null,null,null,{"$f":"IF(Page3!D18=\"\",\"\",Page3!D18)","v":45}]
[" Pallet load weight (kg):",null,null,null,null,{"$f":"IF(Page3!D20=\"\",\"\",Page3!D20)","v":470}]
[]
[]
[]
[]
[]
[]
[]
[]
["Packaging Specification Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 2 | 2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Notes: \"&Page3!C25","v":"Notes: "}]
[]
[]
[]
[]
["Statement:\nThe purpose of this document is to help packaging development.\nBosch approval does not exempt supplier from their responsibility to deliver parts free of damage and corrosion. According to QAA is under the supplier responsibility to\nensure a suitable packaging to avoid damage and quality impairments during transportation.\nThis document and packaging proposal should be considered as a requirement after Supplier and Bosch agreement.\n\nMinimum quality requirement is protection against dust/moisture.\nBTPD-06046 packaging restrictions to be obliged, exceptions with special agreement.\nPallets must be marked permanently and legibly according IPPC- Standard ISPM15.\nPallet shall consist of solid wood. Never reuse damaged pallets.\nThe greatest possible height and maximum payload of a loaded pallet depends on the way of transportation and the used service provider. Optimum pallet height is\n1100mm or 2200mm (including pallet).\nThe stack factor is defined as follows: Stack of 2 (1+1)\nAir freight: The maximum pallet height is 1600mm/1700mm (including pallet)."]

{"sheet":"Aux","index":4,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[9,2,11,4],[14,2,19,5],[22,2,25,4],[10,7,10,11],[11,7,11,11],[12,7,12,11],[13,7,13,11],[14,7,14,11],[15,7,15,11],[16,7,16,11]]}
["Transportation method",null,"Incoterm",null,"Box type",null,"Inlay type",null,"Stackability",null,"Result #1","Mechanical & Cosmetic Protection","Final Result #1",null,"Result #2","Corrosion & Moister Protection","Final Result #2"]
["Airline",null,"FCA",null,"Fefco 201",null,"Foam Inserts",null,"Non stackable",null,false,"Dust and moister (default)",{"$f":"IFERROR(INDEX(K:L,SMALL(IF(K:K=TRUE,ROW(K:K)),ROW(1:1)),2),\"\")","v":""},null,false,"Shelf life expiration",{"$f":"IFERROR(INDEX(O:P,SMALL(IF(O:O=TRUE,ROW(O:O)),ROW(1:1)),2),\"\")","v":""}]
["Truck",null,"DAP",null,"Fefco 427",null,"Carton Inlay",null,"Ground level +1",null,false,"Direct shock (default)",{"$f":"IFERROR(INDEX(K:L,SMALL(IF(K:K=TRUE,ROW(K:K)),ROW(2:2)),2),\"\")","v":""},null,false,"Required conditions",{"$f":"IFERROR(INDEX(O:P,SMALL(IF(O:O=TRUE,ROW(O:O)),ROW(2:2)),2),\"\")","v":""}]
["Sea",null,null,null,"Returnable (KLT)",null,"Thermoformed Tray",null,null,null,false,"Heat or sun light",{"$f":"IFERROR(INDEX(K:L,SMALL(IF(K:K=TRUE,ROW(K:K)),ROW(3:3)),2),\"\")","v":""},null,false,"Active protection",{"$f":"IFERROR(INDEX(O:P,SMALL(IF(O:O=TRUE,ROW(O:O)),ROW(3:3)),2),\"\")","v":""}]
[null,null,null,null,"Other",null,"Other",null,null,null,false,"Bending and pressure",{"$f":"IFERROR(INDEX(K:L,SMALL(IF(K:K=TRUE,ROW(K:K)),ROW(4:4)),2),\"\")","v":""},null,false,{"$f":"\"Others - \"&Page1!$G$26","v":"Others - "},{"$f":"IFERROR(INDEX(O:P,SMALL(IF(O:O=TRUE,ROW(O:O)),ROW(4:4)),2),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,false,"Static electricity",{"$f":"IFERROR(INDEX(K:L,SMALL(IF(K:K=TRUE,ROW(K:K)),ROW(5:5)),2),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,false,"Scratches",{"$f":"IFERROR(INDEX(K:L,SMALL(IF(K:K=TRUE,ROW(K:K)),ROW(6:6)),2),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,false,"Abrasion (contact)",{"$f":"IFERROR(INDEX(K:L,SMALL(IF(K:K=TRUE,ROW(K:K)),ROW(7:7)),2),\"\")","v":""}]
[null,null,"box",null,null,null,null,null,null,null,false,{"$f":"\"Others - \"&Page1!$D$34","v":"Others - "},{"$f":"IFERROR(INDEX(K:L,SMALL(IF(K:K=TRUE,ROW(K:K)),ROW(8:8)),2),\"\")","v":""}]
[null,null,"box"]
[null,null,null,null,null,null,null," Parts per box:"]
[null,null,null,null,null,null,null," Weight of full box (kg):"]
[null,null,null,null,null,null,null," Layers per box:"]
[null,null,"inlay",null,null,null,null," Parts per layer:"]
[null,null,{"$f":"IF(Page2!D16=\"\",\"\",Page2!D16)","v":"Carton Inlay"},null,null,null,null," Boxes per pallet:"]
[null,null,null,null,null,null,null," Pcs per pallet:"]
[null,null,null,null,null,null,null," Pallet load weight (kg):"]
[]
[]
[]
[]
[null,null,"stackability"]
[null,null,{"$f":"IF(Page2!D24=\"\",\"\",Page2!D24)","v":"Ground level +1"}]

{"sheet":"How to fill","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}