Creating a system to capture Quality related issues for design department

S

sushant

#1
Hi everyone

I am working as a manufacturing engineer in a company. I have been asked by design dept. of my company to develop a system in the form of a excel spread sheet or a database which can capture information about the quality issues affecting production due to the improper design. These quality related issues could be arising due to ergonomics, design itself, material or vendor etc.......

What kind of aspects should i consider when creating this sort of a system so that enough information can be passed to design dept.


Can anyone help me on this plz?

Thanks a lot.

Sushant
 
Last edited by a moderator:
Elsmar Forum Sponsor

Helmut Jilling

Auditor / Consultant
#2
Re: Creating a excel spreadsheet to capture non-conforming issues for design departme

Hi everyone

I am working as a manufacturing engineer in a company. I have been asked by design dept. of my company of my company to develop a system in the form of a excel spread sheet or a database which can capture information about the non-conforming issues related to design of the current products. What kind of aspects should i consider when creating this sort of a system so that enough information can be passed to design dept.

At the moment my company doesnt have very robust change management system in place.
Can anyone help me on this plz?

Sushant

Many companies use an Excel spreadsheet to keep a record of "Lessons Learned" during the design activities. You can put anything in there, since it is a searchable document.
 

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#3
Re: Creating a excel spreadsheet to capture non-conforming issues for design departme

Welcome to The Cove!

Here are a couple of threads with some attachments you can look at and use if they suit you.

Does anyone have examples of a Corrective and Preventive action log?

When and when not to write up minor internal audit findings?

I used two methods to find these threads. First, I used the key words "tracking log" in the Search function (Yellow font in the blue tool bar)

Second thing I did was use the key word "tracking" in the "key word" field of the Post Attachments List (see the green button at the top of the page)

I hope this helps!
 

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#4
Re: Creating a excel spreadsheet to capture non-conforming issues for design departme

Helmut is right, that the nonconformance tracking logs may look complex. But you can take our or change any column as you see fit.
 
S

sushant

#5
Re: Creating a excel spreadsheet to capture non-conforming issues for design departme

Thanks for the replies guys..........:thanx:

Does anyone has any example on how the spreadsheet should look like.....
 
P

Pazuzu - 2009

#6
Re: Creating a excel spreadsheet to capture non-conforming issues for design departme

The spreadsheet should be however you want it to look like provided it fits the function you want it to. There is no "best format". What we use vs. what they use vs. what you will use are going to be entirely different things.

Not to sound crass, but rather than asking for a quick fix sample perhaps build what you think you need and then post it in here for the covers to critique. There's far more pride and satisfaction in building one than using someone else's. :cool:
 
S

sushant

#7
Re: Creating a excel spreadsheet to capture non-conforming issues for design departme

Hi there covers

thanks for all ur suggestions.........i have put together a spreadsheet.....i know that it should reflect the fucntions according to the needs of my company......but, can you guyz critique it and see if i have covered the basics aspects here.......

:thanks: again...........
 

Attachments

P

Phil Fields

#8
Re: Creating a excel spreadsheet to capture non-conforming issues for design departme

Hi everyone

I am working as a manufacturing engineer in a company. I have been asked by design dept. of my company to develop a system in the form of a excel spread sheet or a database which can capture information about the quality issues affecting production due to the improper design. These quality related issues could be arising due to ergonomics, design itself, material or vendor etc.......

What kind of aspects should i consider when creating this sort of a system so that enough information can be passed to design dept.


Can anyone help me on this plz?

Thanks a lot.


Sushant
Hello,
I am assuming that you are talking about design work that is released for production. Does your company already have a system to collect data for quality nonconformances? If yes can you modify the method to include the design information? Our company uses an Access database to collect the data. From the data collected we can run many different reports depending on who needs the information.

Phil
 
S

sushant

#9
Re: Creating a excel spreadsheet to capture non-conforming issues for design departme

Hi Phil.........

At present my company doesn't have any system to collect data for quality non-conformances......Thats what I have to work on.............I have attached a spreadsheet....can you plz look at it and let me know whether i am going in right direction or not.........

thanks a lot

sushant
 

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#10
Re: Creating a excel spreadsheet to capture non-conforming issues for design departme

Nice job sushant, from experience I would suggest adding a column for the date the NC was entered, so you can track and manage closure cycle times--especially as they may vary among people and groups.

I would further suggest separating the verification element into its own column. If there would be more than one person doing this, I would add a column for recording who it was.

Lastly, if the design change resulted in something like an FMEA change or a change to other similar products, I would consider capturing that as well.

The idea is to address the "what then?" question, along with the who-what-where-when aspect of a generic NC log; make the information something that can teach people things and leave a useful information trail for research and system integrity purposes.
 
Thread starter Similar threads Forum Replies Date
M Informational Creating a post market surveillance (PMS) system for medical devices – Part 1 Medical Device and FDA Regulations and Standards News 7
B Creating an Audit Mechanism (System/Plan) General Auditing Discussions 3
R Creating Quality System and using it before it is complete ISO 13485:2016 - Medical Device Quality Management Systems 8
P Creating a New QMS (Quality Management System) from Old AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
W Safe and Sound Software: Creating an Efficient and Effective Quality System for Softw Book, Video, Blog and Web Site Reviews and Recommendations 1
L Creating a Global Document Control System Document Control Systems, Procedures, Forms and Templates 4
J Creating a filing system for control of blueprint copies Document Control Systems, Procedures, Forms and Templates 1
R Accelerated Aging - Creating test samples - Implantable medical device Question Other Medical Device Related Standards 4
L Hazardous Waste - Tips for creating standardized training Miscellaneous Environmental Standards and EMS Related Discussions 2
J Sample size for creating a data base as a reference to a tested variable Other Medical Device and Orthopedic Related Topics 6
8 Creating Flow and Pull Game Lean in Manufacturing and Service Industries 1
B Main responsibility for Control Plans - creating and maintaining FMEA and Control Plans 15
shimonv Creating a new commercial product based on a modification to an existing product Other US Medical Device Regulations 4
R Creating WIs for a Heavy Civil Engineering Services company Document Control Systems, Procedures, Forms and Templates 19
M Creating a Plant Level Value Stream Map Process Maps, Process Mapping and Turtle Diagrams 1
T IMDS - Creating an MDS out of material and a made item? RoHS, REACH, ELV, IMDS and Restricted Substances 4
D How do I go about creating document logs and registers with the MS Excel Excel .xls Spreadsheet Templates and Tools 2
W ISO9001:2015 - Clause 7.5.2 - Requirements for Creating & Updating Documents ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
K Creating together Standard Definition for Prevention and Detection FMEA FMEA and Control Plans 1
Marc Creating an Internal Audit Program That Works for Your Organization Internal Auditing 0
M Creating change / Forcing change within a Company Lean in Manufacturing and Service Industries 7
A Creating a policy to evaluate the Third Party Security IEC 27001 - Information Security Management Systems (ISMS) 4
S Creating goals and objectives with targets and measurables for self-evaluations Management Review Meetings and related Processes 2
L Creating a xlsx Customer Complaint file to track Complaints Excel .xls Spreadsheet Templates and Tools 2
S When creating a 510k, which Guidance Document Wins? Other US Medical Device Regulations 9
P GS1 NHRN AIs - Creating Barcodes for Human Product Other ISO and International Standards and European Regulations 4
O Creating a Tool to Track & Verify Mistake Proofing Devices Document Control Systems, Procedures, Forms and Templates 5
B Any suggestion on creating the best paper plane that can hit a target perfectly? Coffee Break and Water Cooler Discussions 2
P Creating a PPAP document for my Suppliers APQP and PPAP 1
L Any recommendations on software for creating hierarchical workflows ? Misc. Quality Assurance and Business Systems Related Topics 2
AnaMariaVR2 Creating Global Giants from a Culture of Israeli Start-Ups Coffee Break and Water Cooler Discussions 0
R Creating a c-chart spreadsheet to use in my department Excel .xls Spreadsheet Templates and Tools 5
R Inspection Database Picker - Creating an Inspection Report Document Control Systems, Procedures, Forms and Templates 1
P Problem with creating VSM current map Lean in Manufacturing and Service Industries 3
G Creating an Organization Chart - AS9100 AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
L Creating DHF (Design History File) for Medical Device Systems Design and Development of Products and Processes 8
Q Recommendations for criteria on creating a CAPA (Corrective and Preventive Action) ISO 13485:2016 - Medical Device Quality Management Systems 8
C Creating a Multiple Table SQL (Structured Query Language) Query in Minitab Using Minitab Software 10
C Resources for creating Process Validation Procedures Qualification and Validation (including 21 CFR Part 11) 5
A Customer Profiles - Creating a Customer 'Profile' for our Top 10 Customers Document Control Systems, Procedures, Forms and Templates 2
M Creating an Index for our Documents - Imaging Millions of Paper Records Document Control Systems, Procedures, Forms and Templates 13
N ISO 9001 based Audit Schedules: Creating and Maintaining - Template wanted General Auditing Discussions 5
P Creating a Traceability Database with Microsoft Access Document Control Systems, Procedures, Forms and Templates 7
V Creating a Cosmetic Inspection Specification for Powder Coated Painted Finished Parts Manufacturing and Related Processes 7
I Difficulty in creating a Quality Manual Quality Management System (QMS) Manuals 4
J Creating an Audit Schedule & Revamping QMS Internal Auditing 18
L How can you capture many positions held without creating a lengthy resume Career and Occupation Discussions 4
Miner Intro to MSA of Continuous Data - Part 10: Creating gauge families Imported Legacy Blogs 10
E Manufacturing Planning - Creating Improvements Misc. Quality Assurance and Business Systems Related Topics 7
G Creating a "Records Policy" - Control of Quality Records Records and Data - Quality, Legal and Other Evidence 13

Similar threads

Top Bottom