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

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.

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? (http://elsmar.com/Forums/showthread.php?t=14933&highlight=corrective+action+log)

When and when not to write up minor internal audit findings? (http://elsmar.com/Forums/showthread.php?t=19789)

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!

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

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

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

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:

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...........

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

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

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.

Hi,
if I can suggest something even if I am late:
I will not to use excel or access.
(to me excel is very easy to use but You can not add too many lines and after one year it will be quite useless as it will be to heavy,
second it is difficult to manage when You are looking for something like grouping etc)
(access. You have to learn it and pay for it. I had a very bad experience once. We have bought a program access based. There was a new release of access and the program was not compatible)
I'm using Mysql. It is free. I can see inside the database. I can have a connection to the free OpenOffice suite (very similar to Excel/Access). I write my program in PHP so I can drive people to write down into a systematic way using the same conventions, and I can make any search I wont.
to me if you are lokking for something very urgently excel may be ok but if you wont something to work for some year and You know You will develop or change something MySQL in connection with OpenOffice or PHP it is a better solution.