{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Front page","General details"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":2,"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":"Front page","index":0,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[2,2,2,3],[4,2,4,3],[15,1,15,6],[11,1,11,6],[6,2,6,3],[8,2,8,3],[10,2,10,3],[12,2,12,3],[6,5,6,6],[14,1,14,6],[3,1,3,6],[5,1,5,6],[9,1,9,6],[29,4,29,5],[30,4,30,5],[23,4,23,6],[25,1,25,6],[26,1,26,6],[23,1,23,2],[27,1,27,2],[19,1,19,2],[20,1,20,2],[16,4,16,6],[17,4,17,6],[28,4,28,5],[17,1,17,2],[18,1,18,2],[21,1,21,2],[22,1,22,2],[19,4,19,6],[18,4,18,6],[39,1,39,6],[7,1,7,6],[13,1,13,6],[27,4,27,6],[35,4,35,5],[36,4,36,5],[37,4,37,5],[38,4,38,5],[31,4,31,5],[32,4,32,5],[33,4,33,5],[34,4,34,5],[16,1,16,2],[21,4,21,6],[22,4,22,6],[20,4,20,6]]}
["Contract Review Template\nFront page"]
[]
[null,"Part no.: ",null,null,null,"Supplier:"]
[]
[null,"Drawing no.: "]
[null,null,null,null,null,"Meeting date: "]
[null,"Drawing revision: "]
[]
[null,"Part description: ",null,null,null,"Revision / last update:"]
[]
[null,"Program / platform: "]
[]
[null,"Veoneer development site:"]
[]
[null,"Purpose: The Contract Review process must be finalized prior to the P.O. being issued to the supplier. Through this review process, we plan to review commercial items. Preliminary program timing and key milestone dates from TFC will be reviewed. "]
[]
[null,"Veoneer to bring",null,null,"Supplier to bring"]
[null,"Current drawings, samples and specifications",null,null,"Tooling & gauge list"]
[null,null,null,null,"Recommendations on cost & design"]
[null,null,null,null,"Supplier project plan"]
[null,null,null,null," "]
[null,null,null,null,"Process flow chart"]
[null,null,null,null,"Supplier APQP"]
[null,null,null,null,"Feasibility study"]
[]
[null,"After completing the contract review meeting, please list participants below:"]
[]
[null,"Veoneer",null,null,"Supplier"]
[null,"Name","Signature","Function","Name",null,"Signature"]
[null,null,null,"Purchase"]
[null,null,null,"Quality"]
[null,null,null,"Engineering"]
[null,null,null,"Sales"]
[null,null,null,"Logistics"]
[null,null,null,"Project Mgt."]
[null,null,null,"Tool maker"]

{"sheet":"General details","index":1,"n_rows":63,"n_cols":10,"rows_kept":63,"cut":false,"hidden":false,"merged":[[63,0,63,7],[43,2,43,6],[22,2,22,6],[4,2,4,6],[0,0,0,7],[2,0,2,7],[35,2,35,6],[29,2,29,6],[1,0,1,7]]}
["Contract Review Template - General"]
[{"$f":"IF('Front page'!C3=0,\"\",'Front page'!C3&\", \"&'Front page'!F4&\", \"&'Front page'!F7)","v":""}]
[]
[null,"Issue",null,"Select","Action item / comment","Responsible","Due date"]
[null,"1.0","Project"]
[null,"1.1","Have all TFC concerns been reviewed and closed?"]
[null,"1.2","Tool / purchase order date:"]
[null,"1.3","Serial drawing available?"]
[null,"1.4","Who has responsibility for drawing and 3D model?"]
[null,"1.5","3D model format:"]
[null,"1.6","Delivery date of first off tool parts (without adjustments):(As specified in TFC)"]
[null,"1.7","Delivery date of functional parts (see comments):",null," "]
[null,"1.8","How many parts?  Discrete PO Number"]
[null,"1.9","PPAP production trial run date:"]
[null,"1.10","Agreed PPAP submission date:"]
[null,"1.11","Supplier Run @ Rate date:",null," "]
[null,"1.12","Start of production date - Supplier:"]
[null,"1.13","Start of production date -  Veoneer:"]
[null,"1.14","End of production date:"]
[null,"1.15","Supplier project time plan available?                                         "]
[null,"1.16","Ramp up information available?"]
[null,"1.17","Other:"]
[null,"2.0","Tooling"]
[null,"2.1","List all unique tools, equipment and gauges required for the production of the listed part number(s) incl. respective lead times (attach list to this review):",null," ",null,null,null,null," "]
[null,"2.2","Tool manufacturer:",null," "]
[null,"2.3","Tool / asset ownership:",null," "]
[null,"2.4","Tool tag reference(s):",null," "]
[null,"2.5","Tool asset form submission date:",null," "]
[null,"2.6","Other:"]
[null,"3.0","Quality"]
[null,"3.1","SQP started ? ",null," "]
[null,"3.2","Launch / interim inspection plan requirements reviewed / defined ? ",null," "," "]
[null,"3.3","Process flow description available? ",null," "," "]
[null,"3.4","Have preventive actions been taken to avoid any defects / deformations in internal & external handling?",null," "," "]
[null,"3.5","Other:"]
[null,"4.0","Logistics"]
[null,"4.1","Supplier production location & shipping point(s):",null," "]
[null,"4.2","Veoneer production location(s):",null," "]
[null,"4.3","Packaging instructions understood and agreed to?",null," "]
[null,"4.4","Local logistics requirements confirmed?",null," "]
[null,"4.5","Are actions defined to prevent damaging of goods during transport & handling?",null," "]
[null,"4.6","Lead time serial delivery:",null," "]
[null,"4.7","Other:"]
[null,"5.0","Commercial"]
[null,"5.1","Request for quotation (RFQ) Esourcing RFQ #:",null," "]
[null,"5.2","Component price & currency:",null," "]
[null,"5.3","Year over year cost down:",null," "]
[null,"5.4","Terms of delivery:",null," "]
[null,"5.5","Packaging included in part price?",null,"   "]
[null,"5.6","Tool cost breakdown available?",null," "]
[null,"5.7","Tool prices (currency) acc. to 2.1 (chapter tooling):",null," "]
[null,"5.8","Terms of payment for tooling:",null," "]
[null,"5.9","Veoneer annual volume (estimate only):",null," "]
[null,"5.10","Veoneer peak daily volume (estimate only):",null," "]
[null,"5.11","Supplier maximum monthly tool capacity acc. to 2.1:",null," "]
[null,"5.12","Supplier regular weekly process capacity & \"work/shift pattern\":",null," "]
[null,"5.13","What are possible actions & lead times to increase this capacity short term?",null," "]
[null,"5.14","Tool Warranty "]
[null,"5.15","Guaranteed tooling lifetime acc. to 2.1:",null," "]
[null,"5.16","Is the continuous maintenance incl. tool spare parts per tool life secured?",null," "]
[null,"5.17","Additional VEVA proposals?",null," "]
[null,"5.18","Spare part (Service part) requirements acc. to VSM agreed?",null," "]
[null,"5.19","Other:"]