I would like to know whether there are tools preferably add ins for excel for drawing
Ishikawa diagram, Pareto diagram, histogram,
pie chart, control chart and relationship diagram, to name a few

Views from others please

*** Dead Link Removed ***

Sometime ago I remember that I saw a tool for drawing pareto diagram and other charts, which is compatible with excel and the site is quantuminc.com. I think this tool is not available presently.

Can others help me please

Venkat

It is relatively simple to create Pareto charts in Excel using the normal chart function as it is simply a bar chart in descending order.

Also Visio has many quality related diagrams such as Ishikawas, mind maps, etc

Looks like Juran gave us a bum stear on that one and is now trying to back out.

Tuff loons Juran - the name sticks.

Bit like the Deming Plan, Do, Check, Act cycle, Shewhart would be turning in his grave !

Just to bump this oldie up, there are some very good FREE quality tools in the link in Post 2 above.

http://www.hanford.gov/safety/vpp/trend.htm

My page here at Hanford.

Good site. Thanks, Steve!

Xue,
Could you revise the link, because this does not work

Thanx
Thareja

Xue,
Could you revise the link, because this does not work

Thanx
Thareja

The link is nearly 4 years old. I found this via Google:

http://www.freequality.org/Default.aspx?page=27

Does anyone have any current sites to add?

strange name but business.balls dot com has some very useful information/templates etc.

Recently discovered BNET - lots of good information I think

Thank you Jim for the modification.

I too Thank you Jim for the modification, and to Xue too.
FreeQuality.org is a great help to beginners indeed.


P Thareja

Sometime ago I remember that I saw a tool for drawing pareto diagram and other charts, which is compatible with excel and the site is quantuminc.com. I think this tool is not available presently.

Can others help me please
Hai,
I think this For Profit site (www.spcforexcel.com) gives u a clear picture about ur doubts. I dont think i fully clear ur doubts.

In the Quality Journey,
Senthil

Hi folks,

Pareto can still be created in Excel.
here is the sample attached.

The steps to create the chart are:
1. Set the data up as in the attached ParetoSample.xls
2. Click chart wizard, select Custom, "Line-Column" type
3. For Source Data range select DefCode/Defect, QtyRejd and Cum%
4. select secondary Y axis in the Chart Options after going through the regular charting process
5. Finish chart in the chosen location/worksheet
6. Select primary Y axis and adjust the scale to the total rejected qty
7. Select the secondary Y axis and manipulate the scale

there you go:)

Sundar Arunachalam

Hello! I'm new to this area, but have learned a lot. As we all know by now, we have to keep up with changes in the quality field because Management is always waiting to replace you. I will try and attach a Pareto chart inexcel format that I found over the net some time ago. Hope it works.....Enjoy!

This is the first link that I refer on analytical problem solving tools

http://www.mindtools.com/pages/main/newMN_TMC.htm

Thanks Yew Jin for referring us to an excellent site.



Danny

Recently I find a very good site to download those quality tools presentation and material which can be used for training material. :yes:
http://www.ise.ufl.edu/esi4221c/Fall%20Schaub/fall/lectures/

Another site where you could find lecture notes/slides is at MIT OpenCourseWare (http://ocw.mit.edu/OcwWeb/Global/all-courses.htm). This is a service provided by the Massachusetts Institute of Technology.

Practically all topics, not just quality.

Wayne

A free flowcharter is available from our Q-Skills site.

This flowcharter is specifically designed for quality improvement teams. It adheres to ISO9004 symbols and does not allow special shapes or drawing anything other than flowcharts.

The flowcharter is unique with it's automatic flow logic checking and validation. This allows reliable charting by unskilled users.

It has been designed to be very easy to use by almost anyone with automatic line drawing and automatic line re-routing.

It includes: 99 levels of subprocesses; Horizontal and vertical "swimlanes" ; An ability to record times, costs and user defined data for each step; Automatic calculation of overall process times and costs.

Another unique feature is automatic process documentation generation - files are saved in a form accessible by other programs to allow manipulation of data associated with the flowchart.

A free flowcharter is available from our Q-Skills site.

This flowcharter is specifically designed for quality improvement teams. It adheres to ISO9004 symbols and does not allow special shapes or drawing anything other than flowcharts.

The flowcharter is unique with it's automatic flow logic checking and validation. This allows reliable charting by unskilled users.

It has been designed to be very easy to use by almost anyone with automatic line drawing and automatic line re-routing.

It includes: 99 levels of subprocesses; Horizontal and vertical "swimlanes" ; An ability to record times, costs and user defined data for each step; Automatic calculation of overall process times and costs.

Another unique feature is automatic process documentation generation - files are saved in a form accessible by other programs to allow manipulation of data associated with the flowchart.


Which site is this, please?

See the web site in artichoke's profile.

A free flowcharter is available from our Q-Skills site.


It's a nice program, and I'm glad to see the emphasis on controlling logic flow. One thing--the "Download" button on the page doesn't seem to work in Firefox.

It's a nice program, and I'm glad to see the emphasis on controlling logic flow. One thing--the "Download" button on the page doesn't seem to work in Firefox.Even so, a remarkable free tool from an organization of only 3 people!

Even so, a remarkable free tool from an organization of only 3 people!
Thank you Wes and Jim.

It is difficult for a small company like ours to be "visible" in the marketplace with our main product, the Q-Skills self paced training. We have hundreds of major clients like Microsoft and Florida Power & Light using the training but have found the free flowcharter is the best way to attract more business. We have found that being a small company has enabled us to be more flexible and responsive.

The flowcharting tool actually evolved from the e-learning. Our clients told us that their staff had learnt how to flowchart but their existing flowcharters were too complex for the average user ... and could we recommend something. Quality managers also told us that a major problem with teams building flowcharts was that they had to check everything the teams built ... hence the automatic logic checker. At times people, including myself, can be fooled by this ... I have seen very complex flowcharts that produce errors ... of course on thorough checking endless loops or whatever are found to be present.

You might also notice some word macros that are not setup in the installer. These macros are intended as examples of how you can automatically process the flowcharter output to generate ISO or other forms of process documentation. You might like to play with these.

Of course I should also mention, that if you can refer any Q-Skills training prospects to us, it would be most appreciated. :)

Here is one - Free converter for Engineering Guys

http://joshmadison.net/software/convert

Sathish :bigwave:

Just a quick note to say that, even though I'm new to quality systems in general and I've only been using artichoke's qsflow software for a couple of days, it defintely seems well thought out - restricting choices in the software leads to clearer thinking when trying to get processes "nailed down" :)
Thank you Q-Skills, I'd definitely recommend you guys.

Just a quick note to say that, even though I'm new to quality systems in general and I've only been using artichoke's qsflow software for a couple of days, it defintely seems well thought out - restricting choices in the software leads to clearer thinking when trying to get processes "nailed down" :)
Thank you Q-Skills, I'd definitely recommend you guys.

Thank you for your kind words and support.

I too Thank you Jim for the modification, and to Xue too.
FreeQuality.org is a great help to beginners indeed.


P Thareja
I found some very useful charts here. Thank you!

Good Site !!

Just to remind you all that there are articles, tools etc available from the horses mouth

ISO resources (http://www.iso.org/iso/en/iso9000-14000/addresources/articles/index.html)

Just to remind you all that there are articles, tools etc available from the horses mouth

ISO resources (http://www.iso.org/iso/en/iso9000-14000/addresources/articles/index.html)

I couldn't see that they actually provide tools do they ? ... and certainly not free ones.

Forgive me for getting side-tracked, but it was interesting to see "ISO 14064 for greenhouse gas accounting and verification" on this site ... I wonder if this standard includes accounting for the earth's major greenhouse gas by far, water vapour ? (Over 300 times man's CO2 contribution). It is sad to see ISO getting mixed up in the greenhouse gas nonsense.

Here is a more precise URL
http://www.iso.org/iso/en/iso9000-14000/addresources/articles/tools.html

Here is a more precise URL
http://www.iso.org/iso/en/iso9000-14000/addresources/articles/tools.html
Thanks. I saw that. They are just general articles.