Basic SPC Charts in Excel - DDE

Post Reply
User avatar
CrashN8
Site Admin
Site Admin
Posts: 568
Joined: Thu Feb 09, 2017 4:07 pm

Basic SPC Charts in Excel - DDE

Post by CrashN8 » Fri Nov 15, 2019 12:52 pm

Create basic multi piece inspection reports with Excel and DDE. Just populate the Blue portion of the attached Excel sheet and set the Upper / Lower Limits in Green cells, then let pre-configured Excel formulas and Charts do the work for you. In this example I've calculated Average, Standard Deviation, and CPK. This could be expanded as needed... If time allows I plan to create dynamic Charts - i.e. maybe a drop-down list that allows user to choose characteristic for charting. As it is now, you need to copy and then manually assign data source for each graph.

Excel_SPC.jpg
You do not have the required permissions to view the files attached to this post.

Post Reply