Simple Statistical Study - Excel

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

Simple Statistical Study - Excel

Post by CrashN8 » Fri Jun 19, 2020 2:10 pm

We frequently offer two solutions for users that need to perform simple Statistical studies. Neither solution is perfect as QC-Calc (or other 3rd party software) must be purchased or DDE can be time consuming to set up. Today I found a solution that can be set up using only included DataPage output and MS Excel as described below:

1) Create you CMM-Manager Program / Report and set Report Properties as follows so that DataPage file is saved using append option. Note that adding Customer Data field with Serial Number or other unique identifier can be used for filtering later in Excel.

data_page_1.jpg


2) Create a new Excel document and import DataPage file using External Data Source (as Text) then set Properties for External Source as shown.

data_page_2.jpg


3) Add filters and formulas in Excel sheet that allows drilling down to specific Serial Number, Date, Dimension, etc.

data_page_3.jpg


See attached Excel and DataPage files.
You do not have the required permissions to view the files attached to this post.

Post Reply