When you extract Max and Min values from your CMM data they will be placed in a single "Results" column. Here's how you can use a little Excel magic to separate these values into different columns!
Ideagen Quality Control Professional can be set to take multiple measured values for a single characteristic and only report the MIN / MAX values. Like this:
You can set the Min / Max values to be extracted from a characteristic's multiple measured results using the settings in the "Measurement" section of the Options window:
In this example, we'll extract the Min and Max values from column C and place them in column A and B using some Excel formulas
1) Insert the following formula into column A. This will extract out the Minimum value from column C:
=MIN(VALUE(LEFT(C2, FIND("|", C2) - 1)), VALUE(MID(C2, FIND("|", C2) + 1, LEN(C2))))
2) Insert this formula in column B. This will extract out the Maximum value from column C:
=MAX(VALUE(LEFT(C2,FIND("|",C2)-1)),VALUE(MID(C2,FIND("|",C2)+1,LEN(C2))))
You can modify this formula to fit your circumstances. Don't forget to change the Cell references to match your template, as well as to extend the formula down the entire column.
Download this example template to see how it works: