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.
1 post • Page 1 of 1