{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["SC-FORM-231","Action Plan","Revisions"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"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":"SC-FORM-231","index":0,"n_rows":48,"n_cols":19,"rows_kept":48,"cut":false,"hidden":false,"merged":[[33,2,35,14],[30,10,31,14],[15,6,15,13],[20,1,20,4],[21,1,21,4],[21,6,21,13],[26,10,27,14],[28,10,29,14],[37,2,39,14],[40,2,40,4],[40,8,40,9],[40,10,40,12],[40,5,40,7],[30,3,30,9],[12,1,12,14],[13,6,13,13],[3,12,3,13],[3,3,3,5],[26,3,26,9],[8,6,8,13],[20,6,20,13],[9,6,9,13],[4,1,4,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[7,1,7,4],[19,6,19,13],[6,1,6,4],[10,6,10,13],[17,6,17,13],[18,6,18,13],[19,1,19,4],[16,6,16,13],[11,6,11,13],[0,0,0,14],[4,6,4,13],[5,1,5,14],[7,6,7,13],[6,6,6,13],[1,1,1,2],[2,1,2,2],[3,1,3,2],[3,6,3,7],[3,9,3,10],[2,3,2,5],[1,3,1,5],[41,10,41,12],[42,10,42,12],[43,10,43,12],[48,1,49,14],[11,1,11,4],[23,1,24,14],[22,1,22,4],[22,6,22,13],[18,1,18,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[14,6,14,13],[13,1,13,4],[14,1,14,4],[28,3,28,9],[44,10,44,12],[45,10,45,12],[42,8,42,9],[47,1,47,14],[41,2,41,4],[43,2,43,4],[44,2,44,4],[41,5,41,7],[43,5,43,7],[44,5,44,7],[45,2,45,4],[45,5,45,7],[41,8,41,9],[44,8,44,9],[45,8,45,9],[43,8,43,9]]}
["Supplier Design for Manufacturing Commitment                       "]
[null,"Supplier"]
[null,"Program"]
[null,"Part Number",null,null,null,null,"Part Revision",null,null,"Drawing Revision",null,null,"Part Name"]
[null,"Question",null,null,null,"Reply","Notes",null,null,null,null,null,null,null,"Response",null,"Distribution","Yes"]
[null,"Manufacturing Details",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contract","No"]
[1,"Will the end product be produced in your facility, contract manufactured or provided through distribution?",null,null,null,"Manufacturer",null,null,null,null,null,null,null,null,{"$f":"IF(OR(F7=\"Manufacturer\"),\"\",IF(OR(F7=\"Distribution\"),S8,IF(OR(F7=\"Contract\"),S8,\"Reply Required\")))","v":""},{"$f":"IF(OR(F7=\"Manufacturer\"),1,IF(OR(F7=\"Distribution\"),2,IF(OR(F7=\"Contract\"),1,3)))","v":1},"Manufacturer","Unknown","Identify outsourced components, processes, include supplier names and geographical location. Are these current production suppliers to you?"]
[2,"Does the design require components to be purchased from a sub supplier. Raw materials should not be considered.",null,null,null,"Yes",null,null,null,null,null,null,null,null,{"$f":"IF(OR(F8=\"Yes\"),S7,IF(OR(F8=\"Unknown\"),\"EXPLAIN\",IF(OR(F8=\"No\"),\"\",\"Reply Required\")))","v":"Identify outsourced components, processes, include supplier names and geographical location. Are these current production suppliers to you?"},{"$f":"IF(OR(F8=\"Yes\"),1,IF(OR(F8=\"Unknown\"),3,IF(OR(F8=\"No\"),1,3)))","v":1},null,"N/A","Who will be the manufacturer and where is their geographical location? Is this a new supplier to you? If not, how long have you been purchasing from them?"]
[3,"Are there any aspects of the design that are unfamiliar or not currently done in your manufacturing processes?",null,null,null,"No",null,null,null,null,null,null,null,null,{"$f":"IF(OR(F9=\"Yes\"),\"EXPLAIN\",IF(OR(F9=\"Unknown\"),\"EXPLAIN\",IF(OR(F9=\"No\"),\"\",\"Reply Required\")))","v":""},{"$f":"IF(OR(F9=\"Yes\"),2,IF(OR(F9=\"Unknown\"),3,IF(OR(F9=\"No\"),1,3)))","v":1},null,null,"What type of equipment will need to be purchased? What is the lead time for this equipment?"]
[4,"Does the design require the purchase of new and unfamiliar equipment to manufacturer or validate?",null,null,null,"No",null,null,null,null,null,null,null,null,{"$f":"IF(OR(F10=\"Yes\"),S9,IF(OR(F10=\"Unknown\"),\"EXPLAIN\",IF(OR(F10=\"No\"),\"\",\"Reply Required\")))","v":""},{"$f":"IF(OR(F10=\"Yes\"),2,IF(OR(F10=\"Unknown\"),3,IF(OR(F10=\"No\"),1,3)))","v":1},null,null,"How much capacity is available?"]
[5,"Does the manufacturing process require any unique manufacturing methods or new technology?",null,null,null,"No",null,null,null,null,null,null,null,null,{"$f":"IF(OR(F11=\"Yes\"),\"Please be prepared to provide details on similar parts or processes.\",IF(OR(F11=\"Unknown\"),\"EXPLAIN\",IF(OR(F11=\"No\"),\"\",\"Reply Required\")))","v":""},{"$f":"IF(OR(F11=\"Yes\"),1,IF(OR(F11=\"Unknown\"),3,IF(OR(F11=\"No\"),1,3)))","v":1},null,null,"What is the plan to increase capacity?"]
[6,"Is there adequate capacity to produce product?",null,null,null,"Yes",null,null,null,null,null,null,null,null,{"$f":"IF(OR(F12=\"Yes\"),S10,IF(OR(F12=\"Unknown\"),\"EXPLAIN\",IF(OR(F12=\"No\"),S11,\"Reply Required\")))","v":"How much capacity is available?"},{"$f":"IF(OR(F12=\"Yes\"),1,IF(OR(F12=\"Unknown\"),3,IF(OR(F12=\"No\"),2,3)))","v":1},null,null,"Please request information from your GHSP team contacts."]
[null,"Design Requirements and Understanding"]
[7,"Is the drawing in a released state, with clearly defined expectations?",null,null,null,"Yes",null,null,null,null,null,null,null,null,{"$f":"IF(OR(F14=\"Yes\"),\"\",IF(OR(F14=\"Unknown\"),\"EXPLAIN\",IF(OR(F14=\"No\"),\"Please note what state the drawing is in and/ or what is not clearly defined.\",\"Reply Required\")))","v":""},{"$f":"IF(OR(F14=\"Yes\"),1,IF(OR(F14=\"Unknown\"),3,IF(OR(F14=\"No\"),3,3)))","v":1}]
[8,"Are any additional specifications listed on the drawing in a released state and have they been reviewed and fully understood?",null,null,null,"Yes",null,null,null,null,null,null,null,null,{"$f":"IF(OR(F15=\"Yes\"),\"\",IF(OR(F15=\"Unknown\"),\"EXPLAIN\",IF(OR(F15=\"No\"),\"Please contact your GHSP Supply Chain team with any questions or for missing specifications.\",\"Reply Required\")))","v":""},{"$f":"IF(OR(F15=\"Yes\"),1,IF(OR(F15=\"Unknown\"),3,IF(OR(F15=\"No\"),3,3)))","v":1}]
[9,"Have all of the raw materials required to manufacture the product been defined? All sub components to be considered.",null,null,null,"Yes",null,null,null,null,null,null,null,null,{"$f":"IF(OR(F16=\"Yes\"),\"\",IF(OR(F16=\"Unknown\"),\"EXPLAIN\",IF(OR(F16=\"No\"),\"Changes will likely occur.\",\"Reply Required\")))","v":""},{"$f":"IF(OR(F16=\"Yes\"),1,IF(OR(F16=\"Unknown\"),3,IF(OR(F16=\"No\"),2,3)))","v":1}]
[10,"Are there any OEM requirements for an approved material/ supplier list that needs to be followed?",null,null,null,"No",null,null,null,null,null,null,null,null,{"$f":"IF(OR(F17=\"Yes\"),\"Do you understand the requirement and have you selected an approved source?\",IF(OR(F17=\"Unknown\"),\"EXPLAIN\",IF(OR(F17=\"No\"),\"Please follow up with GHSP SCM or Engineering.\",\"Reply Required\")))","v":"Please follow up with GHSP SCM or Engineering."},{"$f":"IF(OR(F17=\"Yes\"),1,IF(OR(F17=\"Unknown\"),3,IF(OR(F17=\"No\"),1,3)))","v":1}]
[11,"Can the product be manufactured with the material specified on the design record?",null,null,null,"Yes",null,null,null,null,null,null,null,null,{"$f":"IF(OR(F18=\"Yes\"),\"\",IF(OR(F18=\"Unknown\"),\"EXPLAIN\",IF(OR(F18=\"No\"),\"What manufacturing issues may exist with the specified material?\",\"Reply Required\")))","v":""},{"$f":"IF(OR(F18=\"Yes\"),1,IF(OR(F18=\"Unknown\"),3,IF(OR(F18=\"No\"),3,3)))","v":1}]
[12,"Would you like to propose an alternate material?",null,null,null,"No",null,null,null,null,null,null,null,null,{"$f":"IF(OR(F19=\"Yes\"),#REF!,IF(OR(F19=\"Unknown\"),\"EXPLAIN\",IF(OR(F19=\"No\"),\"\",\"Reply Required\")))","v":""},{"$f":"IF(OR(F19=\"Yes\"),1,IF(OR(F19=\"Unknown\"),3,IF(OR(F19=\"No\"),1,3)))","v":1}]
[13,"Are all of the tolerances listed on the design record feasible for the proposed process?",null,null,null,"Yes",null,null,null,null,null,null,null,null,{"$f":"IF(OR(F20=\"Yes\"),\"No further discussion on tolerance is required.\",IF(OR(F20=\"Unknown\"),\"EXPLAIN\",IF(OR(F20=\"No\"),\"Provide a marked up drawing with evidence of why additional tolerance is required. This may include similar products or industry standards.\",\"Reply Required\")))","v":"No further discussion on tolerance is required."},{"$f":"IF(OR(F20=\"Yes\"),1,IF(OR(F20=\"Unknown\"),2,IF(OR(F20=\"No\"),2,3)))","v":1}]
[14,"Are special characteristics defined on the drawing? ",null,null,null,"Yes",null,null,null,null,null,null,null,null,{"$f":"IF(OR(F21=\"Yes\"),S21,IF(OR(F21=\"Unknown\"),\"EXPLAIN\",IF(OR(F21=\"No\"),\"\",\"Reply Required\")))","v":"Special characteristics have requirements for capability, along with documentation requirements within the PPAP. For more details see the GHSP Supplier Manual on the GHSP website."},{"$f":"IF(OR(F21=\"Yes\"),1,IF(OR(F21=\"Unknown\"),3,IF(OR(F21=\"No\"),1,3)))","v":1},null,null,"Special characteristics have requirements for capability, along with documentation requirements within the PPAP. For more details see the GHSP Supplier Manual on the GHSP website."]
[15,"Can product be manufactured with process capability that meet requirements?",null,null,null,"Yes",null,null,null,null,null,null,null,null,{"$f":"IF(OR(F22=\"Yes\"),S22,IF(OR(F22=\"Unknown\"),\"EXPLAIN\",IF(OR(F22=\"No\"),\"What is required of the product or process to meet capability requirements?\",\"Reply Required\")))","v":"1.67Ppk with a minimum of 125 parts in subgroups of 5."},{"$f":"IF(OR(F22=\"Yes\"),1,IF(OR(F22=\"Unknown\"),3,IF(OR(F22=\"No\"),2,3)))","v":1},null,null,"1.67Ppk with a minimum of 125 parts in subgroups of 5."]
[16,"Is there a specified cleanliness code for this component?",null,null,null,"No",null,null,null,null,null,null,null,null,{"$f":"IF(OR(F23=\"Yes\"),S23,IF(OR(F23=\"Unknown\"),\"EXPLAIN\",IF(OR(F23=\"No\"),\"\",\"Reply Required\")))","v":""},{"$f":"IF(OR(F23=\"Yes\"),1,IF(OR(F23=\"Unknown\"),3,IF(OR(F23=\"No\"),1,3)))","v":1},null,null,"30 piece capability, blank test and efficiency study will be required for PPAP."]
[null,"STATUS",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(P7:P23)","v":1}]
[]
[]
[null,null,{"$f":"IF($P$24=1,1,\"\")","v":1},"Low Risk",null,null,null,null,null,null,{"$f":"IF(OR(C27=1),\"Design and/ or tolerance will not require changes. All aspects of the part and process are understood and there is no concern.\",IF(OR(C27=\"\"),\"\"))","v":"Design and/ or tolerance will not require changes. All aspects of the part and process are understood and there is no concern."}]
[]
[null,null,{"$f":"IF($P$24=2,2,\"\")","v":""},"Medium Risk",null,null,null,null,null,null,{"$f":"IF(OR(C29=2),\"Design/ tolerance changes may be required. Action plan must be created and process development closely monitored.\",IF(OR(C29=\"\"),\"\"))","v":""}]
[]
[null,null,{"$f":"IF($P$24=3,3,\"\")","v":""},"High Risk",null,null,null,null,null,null,{"$f":"IF(OR(C31=3),\"High probability of design/ tolerance changes, PPAP and production delays.  Action plan must be created and process development closely monitored\",IF(OR(C31=\"\"),\"\"))","v":""}]
[]
[null,null,"Additional Supplier Notes:"]
[]
[]
[]
[null,null,"Additional GHSP Notes:"]
[]
[]
[]
[null,null,"Supplier Title",null,null,"Supplier Signature:",null,null,"GHSP Title",null,"GHSP Signatures:",null,null,"Risk"]
[null,null,null,null,null,null,null,null,"SDE",null,null,null,null,"Meduim"]
[null,null,null,null,null,null,null,null,"Principal Engineer",null,null,null,null,"Meduim"]
[null,null,null,null,null,null,null,null,"Engineering Manager",null,null,null,null,"High"]
[null,null,null,null,null,null,null,null,"SDE Manager",null,null,null,null,"High"]
[null,null,null,null,null,null,null,null,"Purchasing",null,null,null,null,"High"]
[]
[null,"Please print to PDF before submitting to GHSP."]

{"sheet":"Action Plan","index":1,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,5],[2,0,2,1],[9,0,9,1]]}
["Action Plan"]
["Item","Action","Resp.","Start Date","Complete","Status"]
["Manufacturing Details"]
[1," "," "," "," "]
[2," "," "," "," "]
[3]
[4]
[5]
[6]
["Design Requirements and Understanding"]
[7," "," "," "," "]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
["Owner:",null,"Updated:  "]
[]
[null,"Protect Sheet Pass Code: 36555"]

{"sheet":"Revisions","index":2,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Date ","Changes"]
["2018-05-08","Added under Specifications:  (List all OEM and GHSP specifications listed on drawing)"]
[null,"Added under #2 - Have we reviewed all supplemental drawings?"]
[null,"Added under #3 - (specifications include OEM specifications, GHSP specifications, material specifications, and drawing note requirements).  If no, comments required."]
[null,"Added #4 - Do any specifications or requirements  listed on the drawing require the purchase of equipment/tooling in order to verify compliance?\nIf yes, list equipment/tooling required."]
[null,"Added #9 - Have you outsourced any critical components or processes? Identify these components, processes, and supplier names in the comments."]
[]
["2020-08-14","Added to #13 If yes, add similar requirements for similar features/materials/processes"]
[null,"Added to GHSP Final Approvals - only required as acceptance to supplier's exceptions"]
[]
["2021-01-21","Revamped the entire form"]
[null,"Password Protect: 36555"]
[]
["2023-01-16","Added \"Item\" column to form"]
[null,"Added \"Action Plan may be created\" for Medium Risk"]
[null,"Added \"Action Plan must be created\" for High Risk"]
[null,"Added GHSP Notes section"]
[null,"Modified signature section to include titles and requirements"]
[null,"Added Action Plan worksheet for item tracking "]
[null,"Removed Item 7 PD-FORM-ENG-255"]
[]
["2024-01-22","Updated GHSP logo"]