Hello Brad,
Thank you very much for the offer, however, I have been able to hack together the functionality I required. With regards to your question on my data formatting - our data format only has one measurement per test per file (ie: I didn't delete any of the file). This makes it necessary to concatentate data from 100s of files before applying statistics. I won't go into the concatenation process now, but I believe there's an example out there of how to do it that I used.
I'll show how I tackled the statistics calculations below for the sake of someone else new to DIAdem & VB who needs to do something similar.
To recap - the task is to perform a statistics operation on every channel in the data portal. In this case, I needed to perform "Process Capability" aka Cp/Cpk. I had already concatenated all of my data files, and the test limits have been imported into two Channel Properties "Limit_LT" and Limit_GT". The following code will add a bunch of custom properties to each channel, pertaining to the Process Capability measurement.
The Calc is performed as follows:
DIM j
FOR j = 1 to ChnNoMax
Call CalcSPC(ChnName(j),j)
NEXT ' j
With the following sub defined:
sub CalcSPC(sChnName,index)
' IF statements only take Limit_LT/Limit_GT if they are defined. Otherwise choose some arbitrarily large/small number.
IF (ChnPropGet(index, "Limit_LT") <> "") THEN
SPCUSL = 1.0*ChnPropValGet(sChnName, "Limit_LT")
ELSE
SPCUSL = +100000000000000000
END IF
IF (ChnPropGet(index, "Limit_GT") <> "") THEN
SPCLSL = 1.0*ChnPropValGet(sChnName, "Limit_GT")
ELSE
SPCLSL = -100000000000000000
END IF
SPCSigmaType = "From StdDev"
SPCSigmaMult = 3
SPCMovingRangeNo = 2
SPCSigmaTol = 6
' Execute calculation
Call SPCProcessCapab(sChnName,SPCUSL,SPCLSL,SPCSigmaType,SPCSigmaMult,SPCMovingRangeNo,SPCSigmaTol)
'... ChnNoStr,SPCUSL,SPCLSL,SPCSigmaType,SPCSigmaMult,SPCMovingRangeNo,SPCSigmaTol
end sub
Hope this helps someone. I based the SPC call on an example in the DIAdem library (the "Long Measurement" example).
