Sheets into a spreadsheet document control

qualprod

Trusted Information Resource
#1
Hello everyone

I have an issue about control of documents, Hope you can advise me.

I have a spreadsheet which have was numbered FOR-QUA-200, is a spreadsheet, now is in rev. 0, where are being registered non conformances.
Recently I had the need to separate different type of nonconformances, my first idea was to add a new sheet, named Cooper nonconformances, other new
sheet, plastic nonconformances and have the idea to add more; brass, stainless steel, etc.
But the existing code into the system for that electronic file is FOR-QUA-200, rev, 0, just one name.
But in that file there are sheets with different information.
Regarding the control of documents, how can I control changes into a sheet (e.g. cooper nonconformances) if this is not the name of main file?
Should I extract each sheet and create new files with names according to the QMS?
e.g. FOR-QUA-201 cooper nonconformances, FOR-QUA-202 Plastic Nonconformances, this controlling them individually?
Please share your thoughs.

Thanks
 
Elsmar Forum Sponsor

John Broomfield

Leader
Super Moderator
#2
Product Nonconformity Spreadsheet (not for system or process nonconformities)

Why create separate sheets for each type of material when this could be a column in a single sheet?

Is the spreadsheet available only to you or a number of users? Can these users make or use unauthorized copies?

Forms (sheets) specify the data to be recorded for later use, so if you are changing the spec how do you prevent use of the superseded form?

By answering these questions you may find you do not need a time consuming extension of your document coding scheme. It could quickly become very complicated.
 

qualprod

Trusted Information Resource
#3
Product Nonconformity Spreadsheet (not for system or process nonconformities)

Why create separate sheets for each type of material when this could be a column in a single sheet?

Is the spreadsheet available only to you or a number of users? Can these users make or use unauthorized copies?

Forms (sheets) specify the data to be recorded for later use, so if you are changing the spec how do you prevent use of the superseded form?

By answering these questions you may find you do not need a time consuming extension of your document coding scheme. It could quickly become very complicated.
Because is needed to have the sheets separated , the point is how to control the change in each, since is daughter of the main file name.
 

qualprod

Trusted Information Resource
#5
If you have a controlled workbook and one or more of the sheets in it changes such that revision control must be invoked, change the revision level of the workbook.
Thanks Jim, it sound ok, I Change the revision of workbook and describe the change of the sheet, yes, thanks
 
Thread starter Similar threads Forum Replies Date
R Medical Device Inspection Sheets - Excel Spreadsheet Validation US Food and Drug Administration (FDA) 2
D ISO 14001 Finding - Missing Safety Data Sheets ISO 14001:2015 Specific Discussions 2
D Safety data sheets software REACH and RoHS Conversations 6
bryan willemot Looking for a good CoC to put with my certification sheets when we send parts Document Control Systems, Procedures, Forms and Templates 1
M Medical Device News New guidance sheets for the MDR/IVDR published EU Medical Device Regulations 0
G ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 24
P Controlled Setup Sheets for a production line Document Control Systems, Procedures, Forms and Templates 2
S Document Control Guidelines in Engineering Projects - Excel sheets with VBA coding Document Control Systems, Procedures, Forms and Templates 3
Q Incomplete Process Sheets Closure - DHR - Doc Control Document Control Systems, Procedures, Forms and Templates 3
D Definition Resquared Sheets of Steel - Definition Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 3
M More than canned audit check-sheets? Auditing the Engineering Department Process Audits and Layered Process Audits 5
E Cosmetic Standard for Sheets of Extruded Plastic Manufacturing and Related Processes 1
G SDS (Safety Data Sheets) Records - When and how long? Occupational Health & Safety Management Standards 8
A MIL STD 105 D or ISO 2859-2? Receiving Metal Sheets Quality Tools, Improvement and Analysis 6
T Machine Parameter Record Sheets Records and Data - Quality, Legal and Other Evidence 7
M Old MSDS Sheets vs new HCS Standard - Format Requirements Manufacturing and Related Processes 18
S Excel format for cataloging MSDS Sheets Occupational Health & Safety Management Standards 2
N What to do about very old MSDS Sheets Occupational Health & Safety Management Standards 24
M Improving Purchases and Sales Sheets Manufacturing and Related Processes 1
L Automated Calculators like EXCEL sheets for different processes Quality Assurance and Compliance Software Tools and Solutions 2
A Tool and Die Manufacturing Job Progress Tracking Tools / Spread Sheets Manufacturing and Related Processes 7
P Capability Analysis for Limited Resolution (thickness of sheets) Capability, Accuracy and Stability - Processes, Machines, etc. 6
T Packaging Approval Form for Steel Coils and Sheets Document Control Systems, Procedures, Forms and Templates 4
J MSDS Sheets on Purchased Steel - Do we need them? Occupational Health & Safety Management Standards 18
S Control Plan Details vs. Operator Instruction Sheets - Document Contents IATF 16949 - Automotive Quality Systems Standard 9
R MSDS Sheets for Products - How much is too much - Or is there ever too much? Occupational Health & Safety Management Standards 12
J Fixed asset transfer forms, equipment run off check sheets, TPDS, MCN Document Control Systems, Procedures, Forms and Templates 2
M Shop Travelers and Operation Sheets AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 7
H Quality Systems Manual Content and QSP Sheets ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
somashekar Requirements for Patient Gowning & other Hospital Clothes, sheets wrt. static charge? Other Medical Device Related Standards 2
W Aluminum Riveting - Process specification for joining aluminium sheets AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 18
L ISO 14644 Result Sheets for Particle monitoring and related monitoring? Other ISO and International Standards and European Regulations 2
DanteCaspian Dry Erase: Custom documents with laminate sheets Lean in Manufacturing and Service Industries 7
Q Control of MSDS (Material Safety Data Sheets) - Document Control required? Miscellaneous Environmental Standards and EMS Related Discussions 8
S Company Name on IMDS Sheets - using ours instead of our distributor? RoHS, REACH, ELV, IMDS and Restricted Substances 4
N SPC charts, simple xls sheets and free software - Need newbie information Statistical Analysis Tools, Techniques and SPC 5
Q FMEA 4th Edition Blank P and D FMEA sheets in Excel .xls spreadsheets FMEA and Control Plans 42
S Should we Retain MSDS Sheets for chemicals not in use? Miscellaneous Environmental Standards and EMS Related Discussions 5
K Inspection Dimensional Check Sheets - Over 500 part numbers Document Control Systems, Procedures, Forms and Templates 2
T Monthly SPC original data sheets - What should be done with the reports? AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 9
S How to get chemical technical data sheets Inspection, Prints (Drawings), Testing, Sampling and Related Topics 5
J ISO 9001 Auditing Issues - Even overtime sheets are auditable ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 18
T DFT - Demand Flow Technology - Operational Sheets (WI) Document Control Systems, Procedures, Forms and Templates 4
E Machine Set-Up Sheets for More Than One Kind of Equipment FMEA and Control Plans 15
Anerol C Who is Approving your Manufacturing Visual Aids / Process Sheets? Document Control Systems, Procedures, Forms and Templates 6
Anerol C Retention Period of Dead Time Sheets Records and Data - Quality, Legal and Other Evidence 8
R Are MSDS sheets or books a part of ISO9001 or QSI audits? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 14
M Stacked Tolerances on Cutting Smaller Sheets from a Large Sheet Inspection, Prints (Drawings), Testing, Sampling and Related Topics 5
A Need Information - FDA Silver or Gray Sheets - August or September '06 ISO 13485:2016 - Medical Device Quality Management Systems 1
A TPM Template Sheets and Counter Measure Sheets - Robot Welding Systems Preventive Action and Continuous Improvement 1

Similar threads

Top Bottom