Hello everyone
Documenting specifications and tolerances is a monotonous task. Usually when a PPAP submission or Initial Sample Inspection Report is required by a customer, we have to label the specifications on the blueprint and list them on an ISIR form.
I have seen several spreadsheets that somewhat automate this task, nearly eliminating the waste of doing the data entry more than once. The Quality Manager would label the blueprint and enter the data into the spreadsheet. The data would link to the entire body of documentation needed for the part. The various sheets would be different tabs in the Microsoft Excel workbook.
The company I'm working for doesn't have such an elegant spreadsheet solution. We would like to create and utilize a solution like this.
There are a couple of issues that are unresolved with the basic spreadsheet PPAP/CP/FMEA/ISIR/Inspection Sheet package that I've seen people build. I think the majority of the difficulty rides on the array of specification and tolerance types that must be dealt with.
A "requirement" cell in one of these worksheets can have a lot of different types of data in it. Radius, angle, basic, linear dimension, range based on linear dimension, etc. This is not databasable, and that is the real goal.
I'm asking The Cove for help naming all the types of specifications and tolerances common to mechanical products.
I'll list them as I see it and attach a spreadsheet with the same.
Specifications:
Linear
Basic
Angle
Radius
Roughness
Standard
Custom
Tolerances:
Bilateral
Unilateral
Range
Minimum
Maximum
Geometric
Standard
Has anyone got ideas about how best to categorize, list, or otherwise handle the array of specifications and tolerances applied to mechanical product?
Documenting specifications and tolerances is a monotonous task. Usually when a PPAP submission or Initial Sample Inspection Report is required by a customer, we have to label the specifications on the blueprint and list them on an ISIR form.
I have seen several spreadsheets that somewhat automate this task, nearly eliminating the waste of doing the data entry more than once. The Quality Manager would label the blueprint and enter the data into the spreadsheet. The data would link to the entire body of documentation needed for the part. The various sheets would be different tabs in the Microsoft Excel workbook.
The company I'm working for doesn't have such an elegant spreadsheet solution. We would like to create and utilize a solution like this.
There are a couple of issues that are unresolved with the basic spreadsheet PPAP/CP/FMEA/ISIR/Inspection Sheet package that I've seen people build. I think the majority of the difficulty rides on the array of specification and tolerance types that must be dealt with.
A "requirement" cell in one of these worksheets can have a lot of different types of data in it. Radius, angle, basic, linear dimension, range based on linear dimension, etc. This is not databasable, and that is the real goal.
I'm asking The Cove for help naming all the types of specifications and tolerances common to mechanical products.
I'll list them as I see it and attach a spreadsheet with the same.
Specifications:
Linear
Basic
Angle
Radius
Roughness
Standard
Custom
Tolerances:
Bilateral
Unilateral
Range
Minimum
Maximum
Geometric
Standard
Has anyone got ideas about how best to categorize, list, or otherwise handle the array of specifications and tolerances applied to mechanical product?
Attachments
-
14 KB Views: 305