PQDM4 Interface Definition

Interfaces

This section lists the classes exposed by PQDM4. For each class, the methods and events are listed.

PQAuxLine {A43E0821-A3A3-4511-B092-ACE6242CC575}

Methods

Property Get bDrawLine() As Boolean

Property Let bDrawLine(RHS As Boolean)

Property Get bExtendLine() As Boolean

Property Let bExtendLine(RHS As Boolean)

Property Get bIsDynamic() As Boolean

Property Let bIsDynamic(RHS As Boolean)

Property Get sSortOrderColumn() As String

Property Let sSortOrderColumn(RHS As String)

Property Get lApplyFrom() As Long

Property Let lApplyFrom(RHS As Long)

Property Get lApplyTo() As Long

Property Let lApplyTo(RHS As Long)

Property Get sErrMsg() As String

Property Let sErrMsg(RHS As String)

Property Get EventHelper() As _PQDataEvent

Property Set EventHelper() As _PQDataEvent

Property Get sActualCalcFrom() As String

Property Get sActualCalcTo() As String

Function lCalcFirst() As Long

Property Get lCalcFrom() As Long

Property Get sCalcFrom() As String

Property Let sCalcFrom(RHS As String)

Function lCalcLast() As Long

Property Get lCalcTo() As Long

Property Get sCalcTo() As String

Property Let sCalcTo(RHS As String)

Property Set oData() As _PQData

Property Get sDecimalCharacter() As String

Function bError() As Boolean

Function GetVal(ByVal value As Variant) As Double

Function bIsMissing(ByVal value As Double) As Boolean

Property Get sListSeparator() As String

Property Get sName() As String

Property Let sName(RHS As String)

Sub SetSubgroupRange

Property Get SmartData() As IPQSD4

Property Get sTitle() As String

Property Get eType() As pqEnumStatistic

Property Let eType(RHS As pqEnumStatistic)

Property Get UID() As Long

Property Let UID(RHS As Long)

Property Get value(Optional ByVal dSG As Double=0) As Double

Events

No Events.

PQCategoryData {FCF34336-42EB-4459-8AE8-1D1FE7431F40}

Methods

Property Get bTotalCountsCompositeEntryName() As Boolean

Property Let bTotalCountsCompositeEntryName(RHS As Boolean)

Function ApplyDecimalChar(ByVal sText As String) As String

Function dBlankCategoryValue(Optional ByVal index As Integer=0) As Double

Function bCanDoDrillDown() As Boolean

Sub CategoryColumn(ByVal sField As String, Optional ByVal sData As String=, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get nCategoryColumnCount() As Integer

Function sCategoryColumnName(ByVal index As Integer) As String

Property Get sCellCategory(ByVal Cell As Integer, Optional ByVal Control As Integer=0) As String

Function sCellCost(ByVal iCost As Integer, Optional ByVal Cell As Integer=0, Optional ByVal Control As Integer=0) As String

Property Get iCellCount(Optional ByVal Control As Integer=0) As Integer

Function dCellValue(Optional ByVal Cell As Integer=0, Optional ByVal Control As Integer=0) As Double

Function sCellLabel(Optional ByVal Cell As Integer=0, Optional ByVal Control As Integer=0) As String

Function dChartTotal(Optional ByVal Control As Integer=0) As Double

Function nChosenColumns() As Integer

Function iChosenEntries() As Integer

Property Get sColumnHeading(ByVal iCol As Integer) As String

Property Get sColumnName(ByVal iSeq As Integer) As String

Property Get eColumnType(ByVal iSeq As Integer) As pqEnumMapType

Property Get bConsiderBlankCategories() As Boolean

Property Let bConsiderBlankCategories(RHS As Boolean)

Sub ControlColumn(ByVal sField As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get nControlColumnCount() As Integer

Property Get sControlValue(ByVal index As Integer) As String

Property Get iControlValueCount() As Integer

Sub CostColumn(ByVal sField As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get nCostColumnCount() As Integer

Sub CostFactor(ByVal sName As String, ByVal dValue As Double)

Property Get dCostValue(Optional ByVal index As Integer=1) As Double

Sub DataColumn(ByVal sField As String, Optional ByVal eData As pqEnumWhatToUse=1, Optional ByVal sFormula As String=, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get nDataColumnCount() As Integer

Property Get sDecimalCharacter() As String

Property Get iDecimalDigits(ByVal eType As pqEnumStatistic) As Integer

Property Let iDecimalDigits(ByVal eType As pqEnumStatistic, RHS As Integer)

Function DrillDown(ByVal sCategory As String, ByVal sColumn As String) As Boolean

Function nDrillDownChoices() As Integer

Sub DrillDownColumn(ByVal sField As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Function sDrillDownColumn(ByVal index As Integer) As String

Property Get nDrillDownColumnCount() As Integer

Function sDrillDownExpression() As String

Function sDrillDownFilter() As String

Function sDrillDownTitle() As String

Property Get iEntryCount() As Integer

Property Get sEntryName(ByVal entry As Integer) As String

Property Get sErrMsg() As String

Property Let sErrMsg(RHS As String)

Property Get bError() As Boolean

Sub EstablishEntriesToChart

Property Get EventHelper() As _PQDataEvent

Property Set EventHelper() As _PQDataEvent

Property Get sFilter() As String

Property Let sFilter(RHS As String)

Property Get sFirstRecord() As String

Property Let sFirstRecord(RHS As String)

Function sFormat(ByVal vValue As Variant, ByVal eType As pqEnumStatistic) As String

Property Let sGrouping(RHS As String)

Property Get iID() As Integer

Property Let iID(RHS As Integer)

Function bIsMissing(ByVal value As Double) As Boolean

Function bIsTypeNumeric(ByVal sName As String) As Boolean

Property Get sLastRecord() As String

Property Let sLastRecord(RHS As String)

Property Get sListSeparator() As String

Function iMinorEntries(ByVal iMajor As Integer, ByVal bSelMajor As Boolean, ByVal bSelMinor As Boolean) As Integer

Function iMinorEntryIndex(ByVal iMajor As Integer, ByVal iMinor As Integer, ByVal bSelMajor As Boolean, ByVal bSelMinor As Boolean) As Integer

Property Get MissingValue() As Double

Property Let MissingValue(RHS As Double)

Property Get sName() As String

Property Let sName(RHS As String)

Property Get bNeedData() As Boolean

Property Get bNeedSetup() As Boolean

Property Let bNeedSetup(RHS As Boolean)

Property Get NumberOfColumns() As Integer

Property Get NumberOfIDs() As Integer

Sub NumberOfResultRowsAndColumns(ByVal iRows As Integer, ByVal iColumns As Integer)

Property Get eOrderBy() As pqEnumOrderBy

How to order the results of my Categories (by Counts, Totals or Means)

Property Let eOrderBy(RHS As pqEnumOrderBy)

How to order the results of my Categories (by Counts, Totals or Means)

Function PopUp() As Boolean

Property Get sPQRS() As String

Property Let sPQRS(RHS As String)

Function Refresh(Optional ByVal bRequery As Boolean=True) As Boolean

Property Get bReportInPercentages() As Boolean

Property Let bReportInPercentages(RHS As Boolean)

Property Get bReportOnBlankCategories() As Boolean

Property Let bReportOnBlankCategories(RHS As Boolean)

Property Get bReportOnOther() As Boolean

Property Let bReportOnOther(RHS As Boolean)

Sub Reset

Property Get sRestrictReporting() As String

How to restrict the number of cells reported on. (n cells or nn%). (Empty = no restriction)

Property Let sRestrictReporting(RHS As String)

How to restrict the number of cells reported on. (n cells or nn%). (Empty = no restriction)

Property Get eResultRecordsToInclude() As pqEnumUseRows

Property Let eResultRecordsToInclude(RHS As pqEnumUseRows)

Property Get lResultRecordsToInclude() As Long

Property Let lResultRecordsToInclude(RHS As Long)

Property Get bReverseOrder() As Boolean

Whether to reverse the order of the results.

Property Let bReverseOrder(RHS As Boolean)

Whether to reverse the order of the results.

Sub SelectData(Optional ByVal sExtra As String=)

Function SetResultChoices(ByVal iRows As Integer, ByVal iColumns As Integer, ByVal iChoices() As Integer) As Boolean

Property Get bTotalsEntry(ByVal index As Integer) As Boolean

Property Get UID() As Long

Property Let UID(RHS As Long)

Property Get eWhatToReport() As pqEnumReportOn

Property Let eWhatToReport(RHS As pqEnumReportOn)

Events

Public Event ResultChoices(ByVal sRowHeadings() As String, ByVal sColumnHeadings() As String, ByVal iChoices() As Integer)

PQCollection {6E5E7ABF-053C-4029-9054-CBDF4476CBE7}

Methods

Sub Add(ByVal oObj As Object, Optional ByVal vKey As Variant)

Add an element to the PQCollection

Property Get c() As _Collection

Sub Clear

Clear the PQCollection of all elements

Property Get Count() As Long

Return the number of elements in the PQCollection

Property Get CurrentElement() As Object

Return or set the current element in the PQCollection

Property Set CurrentElement() As Object

Return or set the current element in the PQCollection

Function Item(ByVal index As Variant) As Object

Return a reference to the element at the given index (1-n).

Property Get NextElement() As Object

Return the element that follows the CurrentElement in the PQCollection

Property Get PreviousElement() As Object

Return the element that precedes the CurrentElement in the PQCollection

Sub Remove(ByVal vKey As Variant)

Remove an element from the PQCollection

Events

Public Event ObjectToAdd(ByVal o As Object, ByVal b As Boolean)

Event fired prior to adding a new element

Public Event ObjectToRemove(ByVal o As Object, ByVal b As Boolean)

Event fired prior to removing an element

Public Event ObjectToAccess(ByVal o As Object, ByVal b As Boolean)

Event fired prior to allowing access to an element

Public Event AttemptToCount(ByVal Count As Integer)

PQCorrelationData {57544AAF-730E-4C06-AC96-ECF3028FA8BF}

Methods

Property Get sSubset() As String

Property Let sSubset(RHS As String)

Property Get sPrimaryUpperSpec() As String

Property Let sPrimaryUpperSpec(RHS As String)

Property Get sPrimaryTargetSpec() As String

Property Let sPrimaryTargetSpec(RHS As String)

Property Get sPrimaryLowerSpec() As String

Property Let sPrimaryLowerSpec(RHS As String)

Property Get sSecondaryUpperSpec() As String

Property Let sSecondaryUpperSpec(RHS As String)

Property Get sSecondaryTargetSpec() As String

Property Let sSecondaryTargetSpec(RHS As String)

Property Get sSecondaryLowerSpec() As String

Property Let sSecondaryLowerSpec(RHS As String)

Function ApplyDecimalChar(ByVal sText As String) As String

Property Get dCoefficientDetermination() As Double

Property Get dCoefficientT() As Double

Property Get sColumnName(ByVal iSeq As Integer) As String

Property Get eColumnType(ByVal iSeq As Integer) As pqEnumMapType

Property Get dCorrelationCoefficient() As Double

Function CurrentRow() As Long

Function DataEnumToStatEnum(ByVal eData As pqEnumDataType) As pqEnumStatistic

Sub DateIDColumn(ByVal sDate As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Sub DateTimeIDColumn(ByVal sDateTime As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get sDecimalCharacter() As String

Property Get iDecimalDigits(ByVal index As pqEnumStatistic) As Integer

Property Let iDecimalDigits(ByVal index As pqEnumStatistic, RHS As Integer)

Property Get sDisplayName() As String

Property Let sDisplayName(RHS As String)

Property Get sErrMsg() As String

Property Let sErrMsg(RHS As String)

Property Get bError() As Boolean

Property Get EventHelper() As _PQDataEvent

Property Set EventHelper() As _PQDataEvent

Property Get sFirstRecord() As String

Property Let sFirstRecord(RHS As String)

Function sFormat(ByVal vValue As Variant, ByVal eType As pqEnumStatistic, Optional ByVal bClip As Boolean=False) As String

Function GetVal(ByVal value As Variant) As Double

Function GoToFirst() As Boolean

Function GoToNext() As Boolean

Function GoToRow(ByVal lRow As Long) As Boolean

Sub IDColumn(ByVal sID As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Function SetIdentifier(ByVal lRow As Long, ByVal index As Integer, ByVal sID As String) As Boolean

Function IDMap(ByVal vKey As Variant) As _PQMap

Property Get sIDName(ByVal iSeq As Integer, ByVal eType As pqEnumNameType) As String

Property Get eIDType(ByVal vKey As Variant) As pqEnumMapType

Function bIsMissing(ByVal value As Double) As Boolean

Function bIsTypeNumeric(ByVal sName As String) As Boolean

Property Get sLastRecord() As String

Property Let sLastRecord(RHS As String)

Property Get sLineOfBestFit(ByVal iLine As Integer) As String

Property Get dLineOfBestFitIntercept() As Double

Property Get dLineOfBestFitSlope() As Double

Property Get sListSeparator() As String

Property Get MissingValue() As Double

Property Let MissingValue(RHS As Double)

Property Get sName() As String

Property Let sName(RHS As String)

Property Get NumberOfColumns() As Integer

Property Get NumberOfIDs() As Integer

Property Get NumberOfPairs() As Long

Property Get NumberOfRows() As Long

Sub NumericIDColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Sub PrimaryDataColumn(ByVal sField As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get nPrimaryDataColumnCount() As Integer

Property Get PrimaryDataValue() As Double

Property Get PrimaryMaximum() As Double

Property Get PrimaryMean() As Double

Property Get PrimaryMedian() As Double

Property Get PrimaryMinimum() As Double

Property Get PrimaryMode(Optional ByVal index As Integer=1) As Double

Property Get PrimaryModes() As Integer

Property Get sPrimaryName() As String

Property Get PrimarySigma() As Double

Property Get PrimaryWithinSigma(ByVal nSigma As Single) As Double

Property Get RCoefficient() As Double

Function Refresh(Optional ByVal bRequery As Boolean=True) As Boolean

Sub Reset

Property Get eResultRecordsToInclude() As pqEnumUseRows

Property Let eResultRecordsToInclude(RHS As pqEnumUseRows)

Property Get lResultRecordsToInclude() As Long

Property Let lResultRecordsToInclude(RHS As Long)

Property Get RowID(ByVal index As Integer) As String

Sub SecondaryDataColumn(ByVal sField As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get nSecondaryDataColumnCount() As Integer

Property Get SecondaryDataValue() As Double

Property Get SecondaryMaximum() As Double

Property Get SecondaryMean() As Double

Property Get SecondaryMedian() As Double

Property Get SecondaryMinimum() As Double

Property Get SecondaryMode(Optional ByVal index As Integer=1) As Double

Property Get SecondaryModes() As Integer

Property Get sSecondaryName() As String

Property Get SecondarySigma() As Double

Property Get SecondaryWithinSigma(ByVal nSigma As Single) As Double

Sub SelectData(ByVal sColumn As String)

Property Get sSubsetOptions() As String

Sub TimeIDColumn(ByVal sTime As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get UID() As Long

Property Let UID(RHS As Long)

Property Get WithinSigma(ByVal nSigma As Single) As Double

Events

No Events.

PQCountData {00B39E9C-28D9-4D21-A610-CD398CDBB815}

Methods

Property Get sConstantNumberInspected() As String

Property Let sConstantNumberInspected(RHS As String)

Property Get eHowToTreatGrossData() As pqEnumGrossData

Property Let eHowToTreatGrossData(RHS As pqEnumGrossData)

Property Get dGrossDataMinimum() As Double

Property Let dGrossDataMinimum(RHS As Double)

Property Get dGrossDataMaximum() As Double

Property Let dGrossDataMaximum(RHS As Double)

Property Get bTreatBlankEntryAsZero() As Boolean

Property Let bTreatBlankEntryAsZero(RHS As Boolean)

Function ApplyDecimalChar(ByVal sText As String) As String

Sub CauseColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get bCauseColumn() As Variant

Property Get nCauseColumnCount() As Integer

Property Let CauseCondition(RHS As String)

Property Get CBar() As Double

Sub ClearLimits

Property Get CMaximum() As Double

Property Get CMinimum() As Double

Property Get sColumnName(ByVal iSeq As Integer) As String

Property Get eColumnType(ByVal iSeq As Integer) As pqEnumMapType

Property Get bConstantNumberInspected() As Boolean

Property Get dConstantNumberInspected() As Double

Function nCountDecimalDigits() As Integer

Property Get CountLimits(ByVal vKey As Variant) As _PQCountLimits

Property Set CountLimits(ByVal vKey As Variant) As _PQCountLimits

Property Get sCountName(Optional ByVal eType As pqEnumNameType=1) As String

Sub CountOfEventsColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Function nCountOfEventsColumnCount() As Integer

Sub CountOfItemsColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Function nCountOfItemsColumnCount() As Integer

Function CurrentRow() As Long

Function CurrentSubgroup() As Long

Function DataEnumToStatEnum(ByVal eData As pqEnumDataType) As pqEnumStatistic

Property Get sDateFormat() As String

Property Let sDateFormat(RHS As String)

Sub DateIDColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Sub DateTimeIDColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get sDecimalCharacter() As String

Property Get iDecimalDigits(ByVal index As pqEnumStatistic) As Integer

Property Let iDecimalDigits(ByVal index As pqEnumStatistic, RHS As Integer)

Property Get bDisplayCount() As Boolean

Property Let bDisplayCount(RHS As Boolean)

Property Get bDisplayData(Optional ByVal index As Integer=0) As Boolean

Property Let bDisplayData(Optional ByVal index As Integer=0, RHS As Boolean)

Property Get bDisplayID(Optional ByVal index As Integer=0) As Boolean

Property Get bDisplayInspected() As Boolean

Property Let bDisplayInspected(RHS As Boolean)

Property Get sDisplayName() As String

Property Let sDisplayName(RHS As String)

Property Get sErrMsg() As String

Property Let sErrMsg(RHS As String)

Property Get bError() As Boolean

Property Get EventCountMaximum() As Double

Property Get EventCountMean() As Double

Property Get EventCountMinimum() As Double

Property Get sEventCountName(ByVal eType As pqEnumNameType) As String

Property Get EventHelper() As _PQDataEvent

Property Set EventHelper() As _PQDataEvent

Function FailedTestNumber(ByVal eType As pqEnumDataType, ByVal SG As Long) As Integer

Property Get sFirstRecord() As String

Property Let sFirstRecord(RHS As String)

Function sFormat(ByVal vValue As Variant, ByVal eType As pqEnumStatistic) As String

Sub GetLimits(ByVal UCL As String, ByVal CTL As String, ByVal LCL As String, Optional ByVal SG As Long=0)

Function GetVal(ByVal value As Variant) As Double

Function GoToFirst() As Boolean

Function GoToFirstGrouping() As Boolean

Function GoToNext() As Boolean

Function GoToNextGrouping() As Boolean

Function GoToRow(ByVal lRow As Long) As Boolean

Function GoToSubgroup(ByVal lSG As Long) As Boolean

Property Let sGrouping(RHS As String)

Sub IDColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Function IDMap(ByVal vKey As Variant) As _PQMap

Property Get sIDName(ByVal iSeq As Integer, Optional ByVal eType As pqEnumNameType=1) As String

Property Get eIDType(ByVal vKey As Variant) As pqEnumMapType

Sub InspectedColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get nInspectedColumnCount() As Integer

Function nInspectedDecimalDigits() As Integer

Property Get InspectedMaximum() As Double

Property Get InspectedMean() As Double

Property Get InspectedMinimum() As Double

Property Get sInspectedName(Optional ByVal eType As pqEnumNameType=1) As String

Function bIsMissing(ByVal value As Double) As Boolean

Property Get bIsOOC(ByVal nTest As Integer, ByVal eType As pqEnumDataType) As Boolean

Function bIsOOCTestValid(ByVal sTest As String) As Boolean

Property Get bIsPrimaryOOC(ByVal nTest As Integer, ByVal eType As pqEnumDataType) As Boolean

Property Get bIsSecondaryOOC(ByVal nTest As Integer, ByVal eType As pqEnumDataType) As Boolean

Property Get bIsSubgroupCaused(Optional ByVal lSG As Long=0) As Boolean

Function bIsTypeNumeric(ByVal sName As String) As Boolean

Function bIsTypeSubgroupNumber(ByVal sName As String) As Boolean

Property Get bIsWithinOOC(ByVal nTest As Integer, ByVal eType As pqEnumDataType) As Boolean

Property Get ItemCountMaximum() As Double

Property Get ItemCountMean() As Double

Property Get ItemCountMinimum() As Double

Property Get sItemCountName(Optional ByVal eType As pqEnumNameType=1) As String

Property Get sLastRecord() As String

Property Let sLastRecord(RHS As String)

Property Get cLimits() As _Collection

Property Get sListSeparator() As String

Property Get LongestOOCRun(ByVal eType As pqEnumDataType) As Variant

Property Get Maximum(Optional ByVal eType As pqEnumDataType=0) As Double

Property Get iMaximumSubgroupsToKeep() As Integer

Property Let iMaximumSubgroupsToKeep(RHS As Integer)

Property Get Mean(Optional ByVal eType As pqEnumDataType=0) As Double

Property Get Minimum(Optional ByVal eType As pqEnumDataType=0) As Double

Function MinimumRow() As Long

Property Get MissingValue() As Double

Property Let MissingValue(RHS As Double)

Property Get sName() As String

Property Let sName(RHS As String)

Property Get bNeedData() As Boolean

Property Get NewCountLimits(ByVal sName As String) As _PQCountLimits

Property Get NewLimits(ByVal sName As String) As _PQLimits

Sub NoteColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get bNoteColumn() As Variant

Property Get nNoteColumnCount() As Integer

Property Get NPBar() As Double

Property Get NPMaximum() As Double

Property Get NPMinimum() As Double

Property Get NumberOfColumns() As Integer

Property Get NumberOfDataPoints() As Long

Property Get NumberOfGroupings() As Integer

Property Get NumberOfIDs() As Integer

Property Get NumberOfOOCTests() As Integer

Property Get NumberOfSubgroups() As Long

Sub NumericIDColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get OOCRun(ByVal iTest As Integer, ByVal eType As pqEnumDataType) As Variant

Property Get OOCRunLimit(ByVal iTest As Integer, ByVal eType As pqEnumDataType) As Variant

Property Get sOOCTest(ByVal index As Integer) As String

Property Let sOOCTest(ByVal index As Integer, RHS As String)

Property Get sOOCText(ByVal index As Integer, Optional ByVal bExpanded As Boolean=False) As String

Property Get sOrderBy() As String

Property Let sOrderBy(RHS As String)

Property Get bOrderData() As Boolean

Property Let bOrderData(RHS As Boolean)

Property Get PBar() As Double

Sub PercentColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Function nPercentColumnCount() As Integer

Property Get sPercentName(Optional ByVal bInternal As Boolean=False) As String

Property Get PMaximum() As Double

Property Get PercentWithinSigma(ByVal fSigma As Single, ByVal eType As pqEnumDataType) As Double

Property Get PMinimum() As Double

Sub ProportionColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Function nProportionColumnCount() As Integer

Property Get sProportionName(Optional ByVal bInternal As Boolean=False) As String

Sub RatioColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Function nRatioColumnCount() As Integer

Property Get sRatioName(Optional ByVal bInternal As Boolean=False) As String

Function Refresh(Optional ByVal bRequery As Boolean=True) As Boolean

Sub Reset

Property Get bResetOOCUponFailure() As Boolean

Property Let bResetOOCUponFailure(RHS As Boolean)

Sub ResetTestResults

Property Get eResultRecordsToInclude() As pqEnumUseRows

Property Let eResultRecordsToInclude(RHS As pqEnumUseRows)

Property Get lResultRecordsToInclude() As Long

Property Let lResultRecordsToInclude(RHS As Long)

Sub SelectData(Optional ByVal sExtra As String=)

Sub SetLimits(ByVal UCL As String, ByVal CTL As String, ByVal LCL As String)

Function Sigma(ByVal eType As pqEnumDataType) As Double

Function SubgroupAdd() As Boolean

Property Get SubgroupC(Optional ByVal lSG As Long=0) As Double

Property Get SubgroupCause(Optional ByVal iCharCount As Integer=0, Optional ByVal lSG As Long=0) As String

Property Get SubgroupEnd() As Long

Property Get SubgroupEventCount(Optional ByVal lSG As Long=0) As Double

Property Let SubgroupEventCount(Optional ByVal lSG As Long=0, RHS As Double)

Property Get SubgroupFirst() As Long

Property Get SubgroupID(ByVal index As Variant, Optional ByVal lSG As Long=0) As String

Function SetSubgroupID(ByVal lSG As Long, ByVal index As Integer, ByVal sID As String) As Boolean

Property Get SubgroupInspected(Optional ByVal lSG As Long=0) As Double

Property Let SubgroupInspected(Optional ByVal lSG As Long=0, RHS As Double)

Property Get SubgroupItemCount(Optional ByVal lSG As Long=0) As Double

Property Let SubgroupItemCount(Optional ByVal lSG As Long=0, RHS As Double)

Property Get SubgroupLabel(ByVal iLabel As Integer) As String

Property Get SubgroupLast() As Long

Property Get SubgroupNote(Optional ByVal iCharCount As Integer=0, Optional ByVal lSG As Long=0) As String

Property Get SubgroupNP(Optional ByVal lSG As Long=0) As Double

Function SubgroupNumber(ByVal sColumn As String, ByVal sText As String, ByVal iProximity As Integer) As Long

Property Let SubgroupNumberColumn(RHS As String)

Property Get SubgroupP(Optional ByVal lSG As Long=0) As Double

Property Get SubgroupStart() As Long

Property Get SubgroupStatistic(ByVal eType As pqEnumDataType, Optional ByVal lSG As Long=0) As Double

Property Get SubgroupU(Optional ByVal dMultiplier As Double=1, Optional ByVal lSG As Long=0) As Double

Property Get sSubset() As String

Property Let sSubset(RHS As String)

Property Get sTimeFormat() As String

Property Let sTimeFormat(RHS As String)

Sub TimeIDColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get UBar() As Double

Property Get UMaximum() As Double

Property Get UMinimum() As Double

Property Get sUniqueIDColumn() As String

Property Let sUniqueIDColumn(RHS As String)

Events

No Events.

PQCountLimits {D03639F9-1726-4624-9317-82B9C43A6B16}

Methods

Property Get sActualCalcFrom() As String

Property Get sActualCalcTo() As String

Property Get lApplyFrom() As Long

Property Let lApplyFrom(RHS As Long)

Sub ApplyLimits(ByVal eType As pqEnumDataType, ByVal UCL As Double, ByVal CTL As Double, ByVal LCL As Double, ByVal NMean As Variant, ByVal dNSigma As Double)

Property Get lApplyTo() As Long

Property Let lApplyTo(RHS As Long)

Function lCalcFirst() As Long

Property Get lCalcFrom() As Long

Property Get sCalcFrom() As String

Property Let sCalcFrom(RHS As String)

Function lCalcLast() As Long

Property Get lCalcTo() As Long

Property Get sCalcTo() As String

Property Let sCalcTo(RHS As String)

Function Calculate() As Boolean

Sub ClearLimits

Property Get C_CTL() As Variant

Property Let C_CTL(RHS As Variant)

Property Get C_LCL() As Variant

Property Let C_LCL(RHS As Variant)

Property Get C_UCL() As Variant

Property Let C_UCL(RHS As Variant)

Property Get CountData() As _PQCountData

Property Set CountData() As _PQCountData

Property Get dCountsMean() As Variant

Property Let dCountsMean(RHS As Variant)

Property Get CTL(Optional ByVal eType As pqEnumDataType=0) As Double

Property Get oData() As _PQData

Property Set oData() As _PQData

Property Get sDecimalCharacter() As String

Sub EstablishLimits(ByVal eType As pqEnumDataType)

Property Get EventHelper() As _PQDataEvent

Property Set EventHelper() As _PQDataEvent

Property Get bExtendLimits() As Boolean

Property Let bExtendLimits(RHS As Boolean)

Function sFormat(ByVal vValue As Variant, ByVal eType As pqEnumStatistic) As String

Property Get eHowCalculated() As pqEnumCalcLimits

Property Let eHowCalculated(RHS As pqEnumCalcLimits)

Property Get eHowToCalculate() As pqEnumCalcLimits

Property Let eHowToCalculate(RHS As pqEnumCalcLimits)

Property Get dInspectedMean() As Variant

Property Let dInspectedMean(RHS As Variant)

Property Get bIsDynamic() As Boolean

Property Let bIsDynamic(RHS As Boolean)

Function bIsMissing(ByVal dValue As Double) As Boolean

Property Get LCL(Optional ByVal eType As pqEnumDataType=0) As Double

Property Get eLimitsType() As pqEnumDataType

Property Let eLimitsType(RHS As pqEnumDataType)

Property Get sListSeparator() As String

Property Get iMinimumVariationBeforeChange() As Integer

Property Let iMinimumVariationBeforeChange(RHS As Integer)

Function MissingValue() As Double

Property Get sName() As String

Property Let sName(RHS As String)

Function bNotMissing(ByVal dValue As Double) As Boolean

Property Get NP_CTL() As Variant

Property Let NP_CTL(RHS As Variant)

Property Get NP_LCL() As Variant

Property Let NP_LCL(RHS As Variant)

Property Get NP_UCL() As Variant

Property Let NP_UCL(RHS As Variant)

Property Get dNumberOfSigma() As Double

Property Let dNumberOfSigma(RHS As Double)

Property Get P_CTL() As Variant

Property Let P_CTL(RHS As Variant)

Property Get P_LCL() As Variant

Property Let P_LCL(RHS As Variant)

Property Get P_UCL() As Variant

Property Let P_UCL(RHS As Variant)

Sub Reset

Sub SetSubgroupRange

Property Get bShowNegativeLimits() As Boolean

Property Let bShowNegativeLimits(RHS As Boolean)

Property Get sSortOrderColumn() As String

Property Let sSortOrderColumn(RHS As String)

Sub SubgroupLimits(ByVal SG As Long, ByVal dUCL As Double, ByVal dCTL As Double, ByVal dLCL As Double, ByVal bCalc As Boolean)

Property Get SubTitle(ByVal iType As Integer, ByVal eType As pqEnumDataType) As String

Property Get Title(ByVal eType As pqEnumDataType, ByVal dMultiplier As Double) As String

Property Get U_CTL() As Variant

Property Let U_CTL(RHS As Variant)

Property Get U_LCL() As Variant

Property Let U_LCL(RHS As Variant)

Property Get U_UCL() As Variant

Property Let U_UCL(RHS As Variant)

Property Get UCL(Optional ByVal eType As pqEnumDataType=0) As Double

Property Get UID() As Long

Property Let UID(RHS As Long)

Property Get bUseLimits() As Boolean

Property Let bUseLimits(RHS As Boolean)

Property Get bVaryingLimits() As Boolean

Function bWithinSigma(ByVal dSigma As Double, ByVal dValue As Double) As Boolean

Sub Defaults

Property Get PQLimits_CTL(Optional ByVal eType As pqEnumDataType=0) As Double

Property Set PQLimits_oData() As _PQData

Property Get PQLimits_LCL(Optional ByVal eType As pqEnumDataType=0) As Double

Events

No Events.

PQData {ADF93758-22B4-4B6F-9CB3-716C6A3F4AB8}

Methods

Property Get sName() As String

Name of this Chart object.

Property Let sName(RHS As String)

Name of this Chart object.

Property Get iID() As Integer

Property Let iID(RHS As Integer)

Property Get sPQRS() As String

Property Let sPQRS(RHS As String)

Property Get bRowSelection() As Boolean

Property Let bRowSelection(RHS As Boolean)

Property Get bNewRow() As Boolean

Property Let bNewRow(RHS As Boolean)

Property Get bSaveValue() As Boolean

Property Let bSaveValue(RHS As Boolean)

Property Get eResultRecordsToInclude() As pqEnumUseRows

Property Let eResultRecordsToInclude(RHS As pqEnumUseRows)

Property Get lResultRecordsToInclude() As Long

Property Let lResultRecordsToInclude(RHS As Long)

Property Get sFirstRecord() As String

Property Let sFirstRecord(RHS As String)

Property Get sLastRecord() As String

Property Let sLastRecord(RHS As String)

Property Get bOrderData() As Boolean

Property Let bOrderData(RHS As Boolean)

Property Get EventHelper() As _PQDataEvent

Property Set EventHelper() As _PQDataEvent

Property Get cMaps() As _Collection

Property Set cMaps() As _Collection

Function ActivityCount(ByVal bResults As Boolean) As Long

Sub AddData(Optional ByVal bEOF As Boolean=False)

Request to add data from the current row to my fields.

Function ApplyDecimalChar(ByVal sText As String) As String

Sub CheckRowSelectionLastN

Sub ClearLimits

Property Get sColumnName(ByVal iSeq As Integer) As String

Property Get eColumnType(ByVal iSeq As Integer) As pqEnumMapType

Property Get sColumnValue(ByVal iSeq As Integer, Optional ByVal lRow As Long=0) As String

Function CurrentRow() As Long

Function CurrentSubgroup() As Long

Function DataEnumToStatEnum(ByVal eData As pqEnumDataType) As pqEnumStatistic

Sub DataIsAvailable(ByVal bYesNo As Boolean)

Notification that all the data for my fields is available from the data source.

Property Get sDateFormat() As String

Property Let sDateFormat(RHS As String)

Property Get sDecimalCharacter() As String

Property Get iDecimalDigits(ByVal eType As pqEnumStatistic) As Integer

Property Let iDecimalDigits(ByVal eType As pqEnumStatistic, RHS As Integer)

Property Get bDisplayData(Optional ByVal index As Integer=0) As Boolean

Property Let bDisplayData(Optional ByVal index As Integer=0, RHS As Boolean)

Property Get bDisplayID(Optional ByVal index As Integer=0) As Boolean

Property Let bDisplayID(Optional ByVal index As Integer=0, RHS As Boolean)

Property Get sDisplayName() As String

Property Let sDisplayName(RHS As String)

Function DoSetup() As Boolean

Request to perform what is necessary to complete my setup (in preparation for receiving values from the data source).

Property Get sErrMsg() As String

Property Let sErrMsg(RHS As String)

Function bError() As Boolean

Whether there is an outstanding error condition.

Function FailedTestNumber(ByVal eType As pqEnumDataType, ByVal SG As Long, Optional ByVal Obs As Integer=0) As Integer

Property Get sFilter() As String

Property Let sFilter(RHS As String)

Sub ForgetData

Function sFormat(ByVal vValue As Variant, ByVal eType As pqEnumStatistic, Optional ByVal bClip As Boolean=False) As String

Function GetVal(ByVal value As Variant) As Double

Function GoToFirst() As Boolean

Function GoToFirstGrouping() As Boolean

Function GoToNext() As Boolean

Function GoToNextGrouping() As Boolean

Function GoToRow(ByVal lRow As Long) As Boolean

Function GoToSubgroup(ByVal lSG As Long) As Boolean

Property Get sGrouping() As String

Property Let sGrouping(RHS As String)

Function IDMap(ByVal vKey As Variant) As _PQMap

Property Get sIDName(ByVal iSeq As Integer, Optional ByVal eType As pqEnumNameType=1) As String

Property Get eIDType(ByVal vKey As Variant) As pqEnumMapType

Function bIsMissing(ByVal value As Double) As Boolean

Property Get bIsOOC(ByVal nTest As Integer, ByVal eType As pqEnumDataType, Optional ByVal lSG As Long=0, Optional ByVal Obs As Integer=0) As Boolean

Function bIsOOCTestValid(ByVal sTest As String) As Boolean

Property Get bIsPrimaryOOC(ByVal nTest As Integer, ByVal eType As pqEnumDataType, Optional ByVal Obs As Integer=0) As Boolean

Property Get bIsSecondaryOOC(ByVal nTest As Integer, ByVal eType As pqEnumDataType, Optional ByVal Obs As Integer=0) As Boolean

Property Get bIsSubgroupCaused(Optional ByVal lSG As Long=0) As Boolean

Function bIsTypeNumeric(ByVal sName As String) As Boolean

Function bIsTypeSubgroupNumber(ByVal sName As String) As Boolean

Property Get bIsWithinOOC(ByVal nTest As Integer, ByVal eType As pqEnumDataType, Optional ByVal Obs As Integer=0) As Boolean

Property Set Limits(Optional ByVal vName As String=) As _PQLimits

Property Get cLimits() As _Collection

Property Get sListSeparator() As String

Property Get LongestOOCRun(ByVal eType As pqEnumDataType) As Variant

Property Get sLowerSpec() As String

Property Let sLowerSpec(RHS As String)

Property Get Maximum(Optional ByVal eType As pqEnumDataType=0) As Double

Property Get iMaximumSubgroupsToKeep() As Integer

Property Let iMaximumSubgroupsToKeep(RHS As Integer)

Property Get Mean(Optional ByVal eType As pqEnumDataType=0) As Double

Property Get Median(Optional ByVal eType As pqEnumDataType=0) As Double

Property Get Minimum(Optional ByVal eType As pqEnumDataType=0) As Double

Function MinimumRow() As Long

Property Get MissingValue() As Double

Property Let MissingValue(RHS As Double)

Property Get bNeedData() As Boolean

Whether the values for my fields are not available.

Property Get bNeedSetup() As Boolean

Whether my setup is not complete.

Property Let bNeedSetup(RHS As Boolean)

Whether my setup is not complete.

Function NewLimits(ByVal sName As String) As _PQLimits

Property Get NumberOfColumns() As Integer

Property Get NumberOfDataPoints() As Long

Property Get NumberOfGroupings() As Integer

Property Get NumberOfIDs() As Integer

Property Get NumberOfOOCTests() As Integer

Property Get NumberOfPointsCaused(ByVal eType As pqEnumDataType) As Long

Property Get NumberOfPointsWithNotes(ByVal eType As pqEnumDataType) As Long

Property Get NumberOfPointsOutOfControl(ByVal eType As pqEnumDataType) As Long

Property Get NumberOfProducts() As Integer

Property Get NumberOfRecords() As Long

Property Get NumberOfSubgroups() As Long

Property Get OOCRun(ByVal iTest As Integer, ByVal eType As pqEnumDataType) As Variant

Property Get OOCRunLimit(ByVal iTest As Integer, ByVal eType As pqEnumDataType) As Variant

Property Get sOOCTest(ByVal index As Integer) As String

Property Let sOOCTest(ByVal index As Integer, RHS As String)

Property Get sOOCText(ByVal index As Integer, Optional ByVal bExpanded As Boolean=False) As String

Property Get sOrderBy() As String

Property Let sOrderBy(RHS As String)

Property Get PercentAboveSpec() As Double

Property Get PercentBelowSpec() As Double

Property Get PercentOutOfSpec() As Double

Sub PostSetup

Property Get Range() As Double

Function Refresh(Optional ByVal bRequery As Boolean=True) As Boolean

Sub Reset

Sub ResetTestResults

Sub SelectData(Optional ByVal sExtra As String=)

Property Get Sigma() As Double

Property Get SmartData() As IPQSD4

Function SubgroupAdd() As Boolean

Property Get SubgroupCause(Optional ByVal iCharCount As Integer=0, Optional ByVal lSG As Long=0) As String

Property Get SubgroupEnd() As Long

Property Get SubgroupFirst() As Long

Property Get SubgroupID(ByVal index As Variant) As String

Function SetSubgroupID(ByVal lSG As Long, ByVal index As Integer, ByVal sID As String) As Boolean

Property Get SubgroupLabel(ByVal iLabel As Integer) As String

Property Get SubgroupLast() As Long

Property Get SubgroupMax(Optional ByVal lSG As Long=0) As Double

Property Get SubgroupMean(Optional ByVal lSG As Long=0) As Double

Property Get SubgroupMedian(Optional ByVal lSG As Long=0) As Double

Property Get SubgroupMin(Optional ByVal lSG As Long=0) As Double

Property Get SubgroupNote(Optional ByVal iCharCount As Integer=0, Optional ByVal lSG As Long=0) As String

Function SubgroupNumber(ByVal sColumn As String, ByVal sText As String, ByVal iProximity As Integer) As Long

Property Get SubgroupRange(Optional ByVal lSG As Long=0) As Double

Property Get SubgroupSigma(Optional ByVal lSG As Long=0) As Double

Property Get SubgroupSize(Optional ByVal lSG As Long=0) As Integer

Property Get SubgroupStart() As Long

Property Get SubgroupStatistic(ByVal eType As pqEnumDataType, Optional ByVal lSG As Long=0) As Double

Property Get SubgroupStatisticName(ByVal eType As pqEnumDataType) As String

Property Get sSubset() As String

Property Let sSubset(RHS As String)

Property Get TabularConstant(ByVal eType As pqEnumTabularConstant, ByVal value As Single) As Double

Property Get sTargetSpec() As String

Property Let sTargetSpec(RHS As String)

Property Get UID() As Long

Property Let UID(RHS As Long)

Property Get sUniqueIDColumn() As String

Property Let sUniqueIDColumn(RHS As String)

Property Get sUpperSpec() As String

Property Let sUpperSpec(RHS As String)

Function bValidField(ByVal sField As String) As Boolean

Events

No Events.

PQDataEvent {6F4C4A84-D2F1-4A45-95DA-E62D40B7B5EC}

Methods

Sub DataIsNeeded(ByVal sRS As String, ByVal sField As String, ByVal bNeeded As Boolean)

Function DoSetup() As Boolean

Property Get sErrMsg() As String

Sub ExportText(ByVal sText As String)

Property Get FieldValue(ByVal sRS As String, ByVal sField As String) As Variant

Property Let FieldValue(ByVal sRS As String, ByVal sField As String, RHS As Variant)

Property Get FieldWidth(ByVal sRS As String, ByVal sField As String) As Integer

Function ForeignText(ByVal sNative As String) As String

Sub GetData

Function GetRecordset(ByVal sName As String) As _PQRS

Function GetVal(ByVal vValue As Variant) As Double

Function IsDataNeeded(ByVal sRS As String, ByVal sField As String) As Boolean

Function SmartData() As IPQSD4

Function ValidateField(ByVal sRS As String, ByVal sField As String) As Boolean

Events

Public Event DataIsNeeded(ByVal sRS As String, ByVal sField As String, ByVal bNeeded As Boolean)

Public Event DoSetup(ByVal bSuccess As Boolean, ByVal sErrMsg As String)

Public Event GetError(ByVal sErrMsg As String)

Public Event ExportText(ByVal sText As String)

Public Event GetForeignText(ByVal sNative As String)

Public Event GetData(ByVal sErrMsg As String)

Public Event GetFieldValue(ByVal sRS As String, ByVal sField As String, ByVal vValue As Variant)

Public Event GetFieldWidth(ByVal sRS As String, ByVal sField As String, ByVal iWidth As Integer)

Public Event GetRecordset(ByVal sName As String, ByVal oPQRS As _PQRS)

Public Event GetSmartData(ByVal oSD As IPQSD4)

Public Event IsDataNeeded(ByVal sRS As String, ByVal sField As String, ByVal bNeeded As Boolean)

Public Event SetFieldValue(ByVal sRS As String, ByVal sField As String, ByVal vValue As Variant)

Public Event ValidateField(ByVal sRS As String, ByVal sField As String, ByVal bValid As Boolean)

PQDataMgr {76DE5AE1-64A6-462E-91D9-BC6FE034B8BA}

Methods

Property Get UID() As Long

Property Let UID(RHS As Long)

Property Get bOpenReadonly() As Boolean

Whether to consider the data source as read-only.

Property Let bOpenReadonly(RHS As Boolean)

Whether to consider the data source as read-only.

Property Get sName() As String

Property Let sName(RHS As String)

Property Get oEventMgr() As _PQDataMgrEvent

Property Set oEventMgr() As _PQDataMgrEvent

Sub AddPQRS(ByVal oPQRS As _PQRS)

Function DeclareCalculatedField(ByVal sName As String, Optional ByVal vIndex As Variant=1) As Boolean

Declare a new field, which is based on a formula using other fields and/or constants.

Function DeclareMemoryField(ByVal sName As String, Optional ByVal vIndex As Variant=1) As Boolean

Declare a new field in the data source. This assumes that all fields will be provided by the application. It is mutually-exclusive with external data sources.

Property Get sErrMsg() As String

Property Let sErrMsg(RHS As String)

Property Get bError() As Boolean

Sub ExportNativeText

Property Get MissingValue() As Double

Property Let MissingValue(RHS As Double)

Function NewCategoryData(ByVal sName As String, Optional ByVal vIndex As Variant=1) As _PQCategoryData

Declare Category data that will get its values from the data source.

Function NewCorrelationData(ByVal sName As String, Optional ByVal vIndex As Variant=1) As _PQCorrelationData

Function NewCountData(ByVal sName As String, Optional ByVal vIndex As Variant=1) As _PQCountData

Function NewMeasurementData(ByVal sName As String, Optional ByVal vIndex As Variant=1) As _PQMeasurementData

Declare Measurement data that will get its values from the data source.

Function NewShortRunData(ByVal sName As String, Optional ByVal vIndex As Variant=1) As _PQShortRunData

Function NewTextData(ByVal sName As String, Optional ByVal vIndex As Variant=1) As _PQTextData

Declare Text data that will get its values from the data source.

Function Refresh(Optional ByVal bRequery As Boolean=True) As Boolean

Sub Reset

Place this object in a state comparable to its initial state.

Function SetCalculatedFieldFormula(ByVal sName As String, ByVal sFormula As String, Optional ByVal vIndex As Variant=1) As Boolean

Property Get bShowProgress() As Boolean

Property Let bShowProgress(RHS As Boolean)

Sub AddNew(Optional ByVal vIndex As Variant=1)

Property Get BOF(Optional ByVal vIndex As Variant=1) As Boolean

Property Get Bookmark(Optional ByVal vIndex As Variant=1) As Variant

Property Let Bookmark(Optional ByVal vIndex As Variant=1, RHS As Variant)

Property Get Bookmarkable(Optional ByVal vIndex As Variant=1) As Boolean

Property Get cColumns(Optional ByVal vKey As Variant=1) As _Collection

Sub Delete(Optional ByVal vIndex As Variant=1)

Sub Edit(Optional ByVal vIndex As Variant=1)

Property Get EOF(Optional ByVal vIndex As Variant=1) As Boolean

Property Get Fields(Optional ByVal vIndex As Variant=1) As _Collection

Property Get Flds() As _Collection

Sub MoveFirst(Optional ByVal vIndex As Variant=1)

Sub MoveLast(Optional ByVal vIndex As Variant=1)

Sub MoveNext(Optional ByVal vIndex As Variant=1)

Sub MovePrevious(Optional ByVal vIndex As Variant=1)

Property Get RecordCount(Optional ByVal vIndex As Variant=1) As Long

Property Get oRecordset(Optional ByVal vIndex As Variant=1) As _PQRS

Property Get cRecordsets() As _Collection

Sub Update(Optional ByVal lUpdateType As Long=1, Optional ByVal bForce As Boolean=False, Optional ByVal vIndex As Variant=1)

Property Get Updatable(Optional ByVal vIndex As Variant=1) As Boolean

Function ValueOf(ByVal sText As String) As Double

Events

No Events.

PQDataMgrEvent {7C19FBF4-6454-46B0-B464-426250A7FABE}

Methods

Sub ExportNativeText(ByVal sText As String)

Sub ShowProgressBar(ByVal bCancel As Boolean)

Sub ForeignText(ByVal sText As String)

Sub GiveInformation(ByVal sTitle As String, ByVal sText As String)

Events

Public Event DataProgress(ByVal bCancel As Boolean)

Public Event ExportText(ByVal sText As String)

Public Event GetForeignText(ByVal sText As String)

Public Event InformationText(ByVal sTitle As String, ByVal sText As String)

PQDMEnums {7193E614-59BD-4B85-98B6-8922E48C9978}

Methods

None

Events

No Events.

PQField {733CD2A6-2821-4D42-80C4-5A130A6CBBF1}

Methods

Property Get bReadonly() As Boolean

Whether the field is treated as read-only.

Property Let bReadonly(RHS As Boolean)

Whether the field is treated as read-only.

Property Get iID() As Integer

Unique ID of my parent object.

Property Let iID(RHS As Integer)

Unique ID of my parent object.

Property Get sErrMsg() As String

Description of the current outstanding error.

Property Let sErrMsg(RHS As String)

Description of the current outstanding error.

Property Get EventHelper() As _PQDataEvent

Reference to an object that provides high-level event support.

Property Set EventHelper() As _PQDataEvent

Reference to an object that provides high-level event support.

Property Get bCalculated() As Boolean

Whether my field is a calculated field.

Sub Clear

Clear the value of the field.

Property Let eErrMsg(RHS As pqEnumFldErrs)

Property Set Field() As Object

Reference to a Field object that is compatible with my parent object.

Property Let sFormula(RHS As String)

Formula which describes how my parent object's value is determined.

Property Get bError() As Boolean

Whether there is an outstand error.

Property Get sName() As String

My name.

Property Let sName(RHS As String)

My name.

Property Get bNeeded() As Boolean

Whether the data for my field has not been provided, yet.

Property Let bNeeded(RHS As Boolean)

Whether the data for my field has not been provided, yet.

Property Get value() As Variant

The value of my parent object.

Property Let value(RHS As Variant)

The value of my parent object.

Property Get Width() As Integer

Events

No Events.

PQFieldCalc {8D3D8005-E9B9-4666-86E3-C019420A8A29}

Methods

Property Get EventHelper() As _PQDataEvent

Property Set EventHelper() As _PQDataEvent

Property Set FieldCalculator() As _PQFldCalc

Events

No Events.

PQFieldMem {AFB5967E-E588-48B3-82CC-B67E7C6D3A17}

Methods

Property Get oParent() As _PQRSMem

Property Set oParent() As _PQRSMem

Property Get EventHelper() As _PQDataEvent

Property Set EventHelper() As _PQDataEvent

Events

No Events.

PQFldCalc {1D49B5E2-284C-49EC-90FB-E02483B1B5E7}

Methods

Property Get sErrMsg() As String

Current error message.

Property Let sErrMsg(RHS As String)

Current error message.

Property Get EventHelper() As _PQDataEvent

Property Set EventHelper() As _PQDataEvent

Function ClearField(ByVal vID As Variant) As Boolean

Clear a field, using the integer that was provided when the field was declared, or by using its name. Returns T/F.

Function DeclareField(ByVal sName As String, Optional ByVal sFormula As String=) As Integer

Tell about a field that is to participate in field storage and retrieval or in calculations. Returns an integer that can be used to reference the field (0 = error declaring the field).

Function FieldFormula(ByVal sName As String, Optional ByVal sFormula As String=) As Integer

Function GetField(ByVal vID As Variant) As Variant

Provide the current value of a given field, using the integer that was provided when the field was declared.

Property Get FieldPosition(ByVal vID As Variant) As Variant

Return the order of a field (1-n), using the integer that was provided when the field was declared, or by using its name.

Function FreeField(ByVal vID As Variant) As Boolean

Free a field from further access, using the integer that was provided when the field was declared, or by using its name. Returns T/F.

Function bError() As Boolean

Whether there is an outstanding error.

Function SetField(ByVal vID As Variant, ByVal vVal As Variant) As Boolean

Store a value in a field, using the integer that was provided when the field was declared, or by using its name. Returns T/F.

Function ValidateFormula(ByVal sFormula As String) As Integer

Function GetVal(ByVal value As Variant) As Double

Events

No Events.

PQLimits {D1F6698C-5B7C-4B3D-B04B-25ABEB4B972D}

Methods

Property Get sName() As String

My name.

Property Let sName(RHS As String)

My name.

Property Get bUseLimits() As Boolean

Property Let bUseLimits(RHS As Boolean)

Property Get bExtendLimits() As Boolean

Property Let bExtendLimits(RHS As Boolean)

Property Get bShowNegativeLimits() As Boolean

Property Let bShowNegativeLimits(RHS As Boolean)

Property Get bIsDynamic() As Boolean

Property Let bIsDynamic(RHS As Boolean)

Property Get lApplyFrom() As Long

Property Let lApplyFrom(RHS As Long)

Property Get lApplyTo() As Long

Property Let lApplyTo(RHS As Long)

Property Get iOrder() As Integer

Property Let iOrder(RHS As Integer)

Property Get sErrMsg() As String

Contents of the current error message.

Property Let sErrMsg(RHS As String)

Contents of the current error message.

Property Get EventHelper() As _PQDataEvent

Property Set EventHelper() As _PQDataEvent

Property Get sActualCalcFrom() As String

Property Get sActualCalcTo() As String

Sub ApplyLimits(ByVal eType As pqEnumDataType, ByVal UCL As Double, ByVal CTL As Double, ByVal LCL As Double, ByVal n As Variant, ByVal dNSigma As Double)

Function lCalcFirst() As Long

Property Get lCalcFrom() As Long

Property Get sCalcFrom() As String

Property Let sCalcFrom(RHS As String)

Function lCalcLast() As Long

Property Get lCalcTo() As Long

Property Get sCalcTo() As String

Property Let sCalcTo(RHS As String)

Function Calculate() As Boolean

Sub ClearLimits

Property Get CTL(Optional ByVal eType As pqEnumDataType=0) As Double

Property Get oData() As _PQData

Property Set oData() As _PQData

Property Get sDecimalCharacter() As String

Function bError() As Boolean

Sub EstablishLimits(ByVal eType As pqEnumDataType)

Function GetVal(ByVal value As Variant) As Double

Property Get eHowCalculated() As pqEnumCalcLimits

How were the Limits calculated.

Property Let eHowCalculated(RHS As pqEnumCalcLimits)

How were the Limits calculated.

Property Get eHowToCalculate() As pqEnumCalcLimits

How the Limits will be calculated.

Property Let eHowToCalculate(RHS As pqEnumCalcLimits)

How the Limits will be calculated.

Property Get dInspectedMean() As Variant

Property Let dInspectedMean(RHS As Variant)

Function bIsMissing(ByVal value As Double) As Boolean

Property Get LCL(Optional ByVal eType As pqEnumDataType=0) As Double

Property Get eLimitsType() As pqEnumDataType

Property Let eLimitsType(RHS As pqEnumDataType)

Property Get sListSeparator() As String

Property Get MissingValue() As Double

Function bNotMissing(ByVal value As Double) As Boolean

Property Get dNumberOfSigma() As Double

Number of sigma to use when calculating Limits.

Property Let dNumberOfSigma(RHS As Double)

Number of sigma to use when calculating Limits.

Property Get SmartData() As IPQSD4

Property Get sSortOrderColumn() As String

Property Let sSortOrderColumn(RHS As String)

Sub SubgroupLimits(ByVal SG As Long, ByVal UCL As Double, ByVal CTL As Double, ByVal LCL As Double, ByVal bCalc As Boolean)

Property Get SubTitle(ByVal iType As Integer, ByVal eType As pqEnumDataType) As String

Property Get Title(ByVal eType As pqEnumDataType, Optional ByVal eType2 As pqEnumDataType=0, ByVal dMultiplier As Double) As String

Property Get UCL(Optional ByVal eType As pqEnumDataType=0) As Double

Property Get UID() As Long

Property Let UID(RHS As Long)

Property Get bVaryingLimits() As Boolean

Function bWithinSigma(ByVal dSigma As Double, ByVal dValue As Double) As Boolean

Property Get iWtAvg() As Integer

Property Let iWtAvg(RHS As Integer)

Property Get iWtRange(Optional ByVal bMR As Boolean=False) As Integer

Property Let iWtRange(Optional ByVal bMR As Boolean=False, RHS As Integer)

Events

No Events.

PQMap {4D7BFD39-9AE0-47A4-9114-6EDE60B3590C}

Methods

Property Get sName() As String

Property Let sName(RHS As String)

Property Get sGroup() As String

Property Let sGroup(RHS As String)

Property Get sMapTo() As String

Property Let sMapTo(RHS As String)

Property Get sData() As String

Property Let sData(RHS As String)

Property Get bDisplay() As Boolean

Property Let bDisplay(RHS As Boolean)

Property Get sDisplayName() As String

Property Let sDisplayName(RHS As String)

Property Get sInternalName() As String

Property Let sInternalName(RHS As String)

Property Get eType() As pqEnumMapType

Property Let eType(RHS As pqEnumMapType)

Property Get iSeq() As Integer

Property Let iSeq(RHS As Integer)

Property Get iID() As Integer

Property Let iID(RHS As Integer)

Property Get vValue() As Variant

Property Let vValue(RHS As Variant)

Property Set vValue() As Variant

Property Get EventHelper() As _PQDataEvent

Property Set EventHelper() As _PQDataEvent

Property Get sType() As String

Property Let sType(RHS As String)

Events

No Events.

PQMeasurementData {D09B2BFD-1777-4F30-929F-8F4B16088CBF}

Methods

Property Get eHowToTreatGrossData() As pqEnumGrossData

Property Let eHowToTreatGrossData(RHS As pqEnumGrossData)

Property Get dGrossDataMinimum() As Double

Property Let dGrossDataMinimum(RHS As Double)

Property Get dGrossDataMaximum() As Double

Property Let dGrossDataMaximum(RHS As Double)

Property Get bAllowUnlimitedSubgroupSize() As Boolean

Property Let bAllowUnlimitedSubgroupSize(RHS As Boolean)

Function ApplyDecimalChar(ByVal sText As String) As String

Property Get BasicCellCount(ByVal Cell As Integer) As Long

Property Get BasicCellFirst() As Integer

Property Get BasicCellLast() As Integer

Property Get BasicCellLeft(ByVal Cell As Integer) As Double

Property Get BasicCellRight(ByVal Cell As Integer) As Double

Property Get eCapabilityMidpoint() As pqEnumCapabilityMidpoint

Property Let eCapabilityMidpoint(RHS As pqEnumCapabilityMidpoint)

Sub CauseColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get bCauseColumn() As Variant

Property Get nCauseColumnCount() As Integer

Property Let CauseCondition(RHS As String)

Condition that determines a 'Caused' subgroup.

Property Get ChiSquare() As Double

Property Get ChiSquareConfidence() As String

The confidence level to use when calculating Chi Square (0.nn or nn%)

Property Let ChiSquareConfidence(RHS As String)

The confidence level to use when calculating Chi Square (0.nn or nn%)

Property Get ChiSquareSignificance() As Double

Provide the significance of Chi Square.

Property Get ChiSquareStatusMsg() As String

Sub ClearLimits

Property Get CoefficientOfVariation() As Double

Provide Coefficient of Variance of the population.

Property Get sColumnName(ByVal iSeq As Integer) As String

Property Get eColumnType(ByVal iSeq As Integer) As pqEnumMapType

Property Get bConstantSubgroupSize() As Boolean

Property Get Cp() As Double

Provide the Capability index: Cp

Property Get Cpk() As Double

Provide the Capability index: Cpk

Property Get CpkFor6Sigma() As Double

Property Get Cpl() As Double

Provide the Capability index: Cpl

Property Get Cpm() As Double

Provide the Capability index: Cpm

Property Get Cpu() As Double

Provide the Capability index: Cpu

Property Get Cr() As Double

Provide the Capability index: Cr

Function CurrentRow() As Long

Function CurrentSubgroup() As Long

Property Get bCurveFits() As Boolean

Function CustomStatistic(ByVal sName As String, ByVal sFormula As String) As Boolean

Property Get nCustomStatistics() As Integer

Property Get sCustomStatisticName(ByVal index As Integer) As String

Property Get sCustomStatisticFormula(ByVal index As Integer) As String

Property Get dCustomStatisticValue(ByVal index As Integer) As Double

Function DataEnumToStatEnum(ByVal eData As pqEnumDataType) As pqEnumStatistic

Property Get sDateFormat() As String

Property Let sDateFormat(RHS As String)

Sub DateIDColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Sub DateTimeIDColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get sDecimalCharacter() As String

Property Get iDecimalDigits(ByVal eType As pqEnumStatistic) As Integer

Number of decimal digits to use when reporting values.

Property Let iDecimalDigits(ByVal eType As pqEnumStatistic, RHS As Integer)

Number of decimal digits to use when reporting values.

Property Get DefectsPer(ByVal lCount As Long) As String

Property Get DegreesOfFreedom() As Integer

Provide the degrees of freedom figured when calculating Chi Square.

Property Get bDisplayData(Optional ByVal index As Integer=0) As Boolean

Property Let bDisplayData(Optional ByVal index As Integer=0, RHS As Boolean)

Property Get bDisplayID(Optional ByVal index As Integer=0) As Boolean

Property Let bDisplayID(Optional ByVal index As Integer=0, RHS As Boolean)

Property Get sDisplayName() As String

Property Let sDisplayName(RHS As String)

Property Get DistributionAnalysis() As pqEnumAnalysisType

How do I analyze the distribution of the population?

Property Let DistributionAnalysis(RHS As pqEnumAnalysisType)

How do I analyze the distribution of the population?

Property Get DistributionName() As String

Provide the name of the distribution fitted over the population.

Property Get sErrMsg() As String

Property Let sErrMsg(RHS As String)

Property Get bError() As Boolean

Property Get EstimatedSigma(Optional ByVal eHow As pqEnumCalcEstSigma=1) As Double

Property Get EventHelper() As _PQDataEvent

Property Set EventHelper() As _PQDataEvent

Function FailedTestNumber(ByVal eType As pqEnumDataType, ByVal SG As Long, Optional ByVal Obs As Integer=0) As Integer

Property Get sFilter() As String

Property Let sFilter(RHS As String)

Property Get sFirstRecord() As String

Property Let sFirstRecord(RHS As String)

Function sFormat(ByVal vValue As Variant, ByVal eType As pqEnumStatistic, Optional ByVal bClip As Boolean=False) As String

Function GetCurvePoints(ByVal Count As Integer, ByVal x As Double, ByVal y As Double) As Integer

Function GetVal(ByVal value As Variant) As Double

Function GoToFirst() As Boolean

Function GoToFirstGrouping() As Boolean

Function GoToNext() As Boolean

Function GoToNextGrouping() As Boolean

Function GoToRow(ByVal lRow As Long) As Boolean

Function GoToSubgroup(ByVal lSG As Long) As Boolean

Property Get GrandMean() As Double

Property Get sGrouping() As String

Property Let sGrouping(RHS As String)

Property Get HistogramCellCount(ByVal Cell As Integer) As String

Property Let HistogramCellCount(ByVal Cell As Integer, RHS As String)

Sub HistogramCellData(ByVal Cell As Integer, ByVal dLeft As Double, ByVal dRight As Double, ByVal dRef As Double, ByVal lCount As Long)

Property Get HistogramCellLabel(ByVal Cell As Integer) As String

Property Get HistogramCellLeft(ByVal Cell As Integer) As Double

Property Get HistogramCellRight(ByVal Cell As Integer) As Double

Property Get HistogramCellStart() As String

Value of the left boundary of the first Histogram cell.

Property Let HistogramCellStart(RHS As String)

Value of the left boundary of the first Histogram cell.

Property Get HistogramCellWidth() As String

Desired width of each Histogram cell.

Property Let HistogramCellWidth(RHS As String)

Desired width of each Histogram cell.

Property Get HowToLabelHistogramCells() As pqEnumHistoLabelCells

Property Let HowToLabelHistogramCells(RHS As pqEnumHistoLabelCells)

Property Get eHowToTreatRows() As pqEnumTreatARSRows

Sub IDColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Function IDMap(ByVal vKey As Variant) As _PQMap

Property Get sIDName(ByVal iSeq As Integer, Optional ByVal eType As pqEnumNameType=1) As String

Property Get eIDType(ByVal vKey As Variant) As pqEnumMapType

Property Get bIgnoreMissingSubgroupOnMovingSubgroups() As Boolean

Property Let bIgnoreMissingSubgroupOnMovingSubgroups(RHS As Boolean)

Function bIsMissing(ByVal value As Double) As Boolean

Property Get bIsOOC(ByVal nTest As Integer, ByVal eType As pqEnumDataType, Optional ByVal lSG As Long=0, Optional ByVal Obs As Integer=0) As Boolean

Function bIsOOCTestValid(ByVal sTest As String) As Boolean

Property Get bIsPrimaryOOC(ByVal nTest As Integer, ByVal eType As pqEnumDataType, Optional ByVal Obs As Integer=0) As Boolean

Provide whether a subgroup is Out-of-Control.

Property Get bIsSecondaryOOC(ByVal nTest As Integer, ByVal eType As pqEnumDataType, Optional ByVal Obs As Integer=0) As Boolean

Provide whether a subgroup is a secondary Out-of-Control point.

Property Get bIsSubgroupCaused(Optional ByVal lSG As Long=0) As Boolean

Function bIsSwedEisenhartRunTest(ByVal iTest As Integer) As Boolean

Function bIsSwedEisenhartTest(ByVal iTest As Integer) As Boolean

Function bIsSwedEisenhartTrendTest(ByVal iTest As Integer) As Boolean

Function bIsSwedEisenhartVariablityTest(ByVal iTest As Integer) As Boolean

Function bIsTypeNumeric(ByVal sName As String) As Boolean

Function bIsTypeSubgroupNumber(ByVal sName As String) As Boolean

Property Get bIsWithinOOC(ByVal nTest As Integer, ByVal eType As pqEnumDataType, Optional ByVal Obs As Integer=0) As Boolean

Property Get Kurtosis() As Double

Provide Kurtosis of the population.

Property Get sLastRecord() As String

Property Let sLastRecord(RHS As String)

Property Get cLimits() As _Collection

Property Get sListSeparator() As String

Property Get LongestOOCRun(ByVal eType As pqEnumDataType) As Variant

Provide the value of the longest Out-of-Control test run.

Property Get sLowerSpec() As String

Property Let sLowerSpec(RHS As String)

Sub LowerSpecColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get Maximum(Optional ByVal eType As pqEnumDataType=0) As Double

Provide the Maximum of the population.

Property Get iMaximumSubgroupsToKeep() As Integer

Property Let iMaximumSubgroupsToKeep(RHS As Integer)

Property Get Mean(Optional ByVal eType As pqEnumDataType=0) As Double

Property Get MeanMean() As Double

Property Get MeanMedian() As Double

Property Get MeanRange() As Double

Property Get MeanRangeOfXbars() As Double

Property Get MeanSigma() As Double

Property Get MeasurementLimits(ByVal vKey As Variant) As _PQMeasurementLimits

Property Set MeasurementLimits(Optional ByVal vKey As Variant=) As _PQMeasurementLimits

Property Get Median(Optional ByVal eType As pqEnumDataType=0) As Double

Provide Median of the population.

Property Get MedianRange() As Double

Property Get Minimum(Optional ByVal eType As pqEnumDataType=0) As Double

Provide the Minimum of the population.

Function MinimumRow() As Long

Property Get MissingValue() As Double

Property Let MissingValue(RHS As Double)

Property Get Mode(Optional ByVal index As Integer=1) As Double

Provide one of the modes (1-n) of the population.

Property Get NumberOfModes() As Integer

Provide the number of modes found in the population.

Property Get MovingAverage() As Integer

Moving Average to use when the subgroup size = 1.

Property Let MovingAverage(RHS As Integer)

Moving Average to use when the subgroup size = 1.

Property Get MovingRange(Optional ByVal bMR As Boolean=False) As Integer

Moving Range to use when the subgroup size = 1.

Property Let MovingRange(Optional ByVal bMR As Boolean=False, RHS As Integer)

Moving Range to use when the subgroup size = 1.

Property Get sName() As String

My name.

Property Let sName(RHS As String)

My name.

Function NewLimits(ByVal sName As String) As _PQLimits

Function NewMeasurementLimits(ByVal sName As String) As _PQMeasurementLimits

Provide access to a new Measurement Limits object. (it is placed in the Limits collection).

Function bNormalDistribution() As Boolean

Sub NoteColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get bNoteColumn() As Variant

Property Get nNoteColumnCount() As Integer

Property Get NumberOfColumns() As Integer

Property Get NumberOfDataPoints() As Long

Provide the number of data points in the population.

Property Get NumberOfGroupings() As Integer

Property Get NumberOfHistogramCells() As Integer

Provide the number of cells in the current Histogram.

Property Let NumberOfHistogramCells(RHS As Integer)

Provide the number of cells in the current Histogram.

Property Get NumberOfIDs() As Integer

Property Get NumberOfOOCTests() As Integer

Property Get NumberOfPointsCaused(ByVal eType As pqEnumDataType) As Long

Property Get NumberOfPointsWithNotes(ByVal eType As pqEnumDataType) As Long

Property Get NumberOfPointsOutOfControl(ByVal eType As pqEnumDataType) As Long

Property Get NumberOfRecords() As Long

Property Get NumberOfSubgroups() As Long

Sub NumericIDColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Sub ObservationColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get nObservationColumnCount() As Integer

Function sObservationName(ByVal iObs As Integer, Optional ByVal eType As pqEnumNameType=1) As String

Property Get OOCRun(ByVal iTest As Integer, ByVal eType As pqEnumDataType) As Variant

Property Get OOCRunLimit(ByVal iTest As Integer, ByVal eType As pqEnumDataType) As Variant

Property Get sOOCTest(ByVal index As Integer) As String

Description of an Out-of-Control test.

Property Let sOOCTest(ByVal index As Integer, RHS As String)

Description of an Out-of-Control test.

Property Get sOOCText(ByVal index As Integer, Optional ByVal bExpanded As Boolean=False) As String

Property Get sOrderBy() As String

Property Let sOrderBy(RHS As String)

Property Get bOrderData() As Boolean

Property Let bOrderData(RHS As Boolean)

Property Get PearsonK() As Double

Provide above spec (percent).

Property Get PearsonL() As Double

Property Get PearsonU() As Double

Property Get Percentile(ByVal percent As Double) As Double

Property Get PercentAboveSpec() As Double

Property Get PercentBelowSpec() As Double

Provide below spec (percent).

Property Get PercentOutOfSpec() As Double

Provide out-of-spec (percent).

Property Get PercentTheoreticalAboveSpec() As Double

Provide theoretical above spec (percent).

Property Get PercentTheoreticalBelowSpec() As Double

Provide theoretical below spec (percent).

Property Get PercentTheoreticalOutOfSpec() As Double

Provide theoretical out-of-spec (percent).

Property Get PercentWithinSigma(ByVal fSigma As Single) As Double

Property Get Pp() As Double

Provide the Process index: Pp

Property Get Ppk() As Double

Provide the Process index: Ppk

Property Get sPQRS() As String

Property Let sPQRS(RHS As String)

Property Get Pr() As Double

Provide the Process index: Pr

Property Get Range() As Double

Provide Range of the population.

Function Refresh(Optional ByVal bRequery As Boolean=True) As Boolean

Sub Reset

Property Get bResetOOCUponFailure() As Boolean

Property Let bResetOOCUponFailure(RHS As Boolean)

Sub ResetTestResults

Property Get eResultRecordsToInclude() As pqEnumUseRows

Property Let eResultRecordsToInclude(RHS As pqEnumUseRows)

Property Get lResultRecordsToInclude() As Long

Property Let lResultRecordsToInclude(RHS As Long)

Property Get bRowSelection() As Boolean

Property Let bRowSelection(RHS As Boolean)

Sub RowSelectionByColumn(ByVal sName As String, ByVal n As Integer, ByVal eUnits As pqEnumRowSelect)

Sub RowSelectionByCount(ByVal lPerRows As Long)

Sub RowSelectionUsage(ByVal eTreat As pqEnumTreatARSRows, ByVal eWhich As pqEnumUseRows, Optional ByVal lUseRows As Long=1)

Sub SelectData(Optional ByVal sExtra As String=)

Description of what and how to select data within the data source. To inquire of the choices, enter sSelectData = "?"

Property Get Sigma() As Double

Provide the sigma (standard deviation) of the population.

Property Get SigmaFromTarget() As Double

Property Get sSigmaShift() As String

Property Let sSigmaShift(RHS As String)

Function dNSigmaValue(ByVal dNSigma As Double) As Double

Property Get Skewness() As Double

Provide Skewness of the population.

Property Get StatisticByID(ByVal eStat As pqEnumStatistic) As Double

Property Get StatisticByName(ByVal sStat As String) As Double

Property Get iStatisticID(ByVal sStat As String) As Integer

Function bStatisticIsValid(ByVal sFormula As String) As Boolean

Property Get eStatisticsBasis() As pqEnumStatsBasis

Property Let eStatisticsBasis(RHS As pqEnumStatsBasis)

Function SubgroupAdd() As Boolean

Property Get SubgroupCause(Optional ByVal iCharCount As Integer=0, Optional ByVal lSG As Long=0) As String

Property Get SubgroupCusum(ByVal iObs As Integer, Optional ByVal lSG As Long=0) As Double

Property Get SubgroupEnd() As Long

Property Get SubgroupFirst() As Long

Property Get SubgroupID(ByVal index As Variant, Optional ByVal lSG As Long=0) As String

Provide an identifier for the current subgroup.

Function SetSubgroupID(ByVal lSG As Long, ByVal index As Integer, ByVal sID As String) As Boolean

Property Get SubgroupLabel(ByVal iLabel As Integer) As String

Provide a Label for the current subgroup.

Property Get SubgroupLast() As Long

Property Get SubgroupMax(Optional ByVal lSG As Long=0) As Double

Provide the maximum of the observations of the current subgroup.

Property Get SubgroupMean(Optional ByVal lSG As Long=0) As Double

Provide the average of the observations of the current subgroup.

Property Get SubgroupMedian(Optional ByVal lSG As Long=0) As Double

Provide the median of the observations of the current subgroup.

Property Get SubgroupMin(Optional ByVal lSG As Long=0) As Double

Provide the minimum of the observations of the current subgroup.

Property Get SubgroupNote(Optional ByVal iCharCount As Integer=0, Optional ByVal lSG As Long=0) As String

Function SubgroupNumber(ByVal sColumn As String, ByVal sText As String, ByVal iProximity As Integer) As Long

Property Let SubgroupNumberColumn(RHS As String)

Property Get SubgroupObservation(ByVal iObs As Integer, Optional ByVal lSG As Long=0) As Double

Function SetSubgroupObservation(ByVal lSG As Long, ByVal iObs As Integer, ByVal dValue As Double) As Boolean

Property Get SubgroupObservationRange(ByVal iObs As Integer, Optional ByVal lSG As Long=0) As Double

Property Get SubgroupRange(Optional ByVal lSG As Long=0) As Double

Provide the range (max - min) of the observations of the current subgroup.

Property Get SubgroupRangeOfXbars(Optional ByVal lSG As Long=0) As Double

Property Get SubgroupSigma(Optional ByVal lSG As Long=0) As Double

Provide the sigma (standard deviation) of the observations of the current subgroup.

Property Get SubgroupSize(Optional ByVal lSG As Long=0) As Integer

Provide the number of observations in each subgroup.

Property Get SubgroupStart() As Long

Property Get SubgroupStatistic(ByVal eType As pqEnumDataType, Optional ByVal lSG As Long=0) As Double

Property Get SubgroupSum(Optional ByVal lSG As Long=0) As Double

Property Get sSubset() As String

Property Let sSubset(RHS As String)

Function SwedEisenhartMaximumRunLengthAllowed() As Integer

Function SwedEisenhartMaximumRunsAllowed() As Integer

Function SwedEisenhartMaximumTrendLengthAllowed() As Integer

Function SwedEisenhartMinimumRunsAllowed() As Integer

Function SwedEisenhartPoints() As Integer

Function SwedEisenhartRuns() As Integer

Property Get TabularConstant(ByVal eType As pqEnumTabularConstant, ByVal value As Single) As Double

Property Get dTarget() As Double

Property Get sTargetSpec() As String

Property Let sTargetSpec(RHS As String)

Sub TargetSpecColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get TargetZ() As Double

Property Get sTimeFormat() As String

Property Let sTimeFormat(RHS As String)

Sub TimeIDColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Function sTimeLabel(ByVal sLabel As String, ByVal eUnits As pqEnumRowSelect) As String

Property Get Tp() As Double

Property Get Tpk() As Double

Property Get TpkFor6Sigma() As Double

Property Get Tpl() As Double

Property Get Tpu() As Double

Property Get Tr() As Double

Property Get UID() As Long

Property Let UID(RHS As Long)

Property Get sUniqueIDColumn() As String

Property Let sUniqueIDColumn(RHS As String)

Property Get eUnits() As pqEnumRowSelect

Property Get sUpperSpec() As String

Property Let sUpperSpec(RHS As String)

Sub UpperSpecColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get ValuesOutLeft() As Long

Number of values that lie to the left of the histogram cells.

Property Get ValuesOutRight() As Long

Number of values that lie to the right of the histogram cells.

Property Get ZLower() As Double

Property Get ZUpper() As Double

Events

No Events.

PQMeasurementLimits {42DEF532-CAE3-44BE-8467-EF60388718CF}

Methods

Property Get dSigma() As Double

Property Let dSigma(RHS As Double)

Property Get sActualCalcFrom() As String

Property Get sActualCalcTo() As String

Property Get lApplyFrom() As Long

Property Let lApplyFrom(RHS As Long)

Sub ApplyLimits(ByVal eType As pqEnumDataType, ByVal UCL As Double, ByVal CTL As Double, ByVal LCL As Double, ByVal n As Variant, ByVal dNSigma As Double)

Property Get lApplyTo() As Long

Property Let lApplyTo(RHS As Long)

Function lCalcFirst() As Long

Property Get lCalcFrom() As Long

Property Get sCalcFrom() As String

Property Let sCalcFrom(RHS As String)

Function lCalcLast() As Long

Property Get lCalcTo() As Long

Property Get sCalcTo() As String

Property Let sCalcTo(RHS As String)

Function Calculate() As Boolean

Sub ClearLimits

Property Get CTL(Optional ByVal eType As pqEnumDataType=0) As Double

Provide the centerline of a control limit.

Property Get oData() As _PQData

Property Set oData() As _PQData

Property Get sDecimalCharacter() As String

Sub EstablishLimits(ByVal eType As pqEnumDataType)

Property Get EventHelper() As _PQDataEvent

Property Set EventHelper() As _PQDataEvent

Property Get bExtendLimits() As Boolean

Property Let bExtendLimits(RHS As Boolean)

Function sFormat(ByVal vValue As Variant, ByVal eType As pqEnumStatistic) As String

Property Get eHowCalculated() As pqEnumCalcLimits

Property Let eHowCalculated(RHS As pqEnumCalcLimits)

Property Get eHowToCalculate() As pqEnumCalcLimits

Property Let eHowToCalculate(RHS As pqEnumCalcLimits)

Property Get IndividualsCTL() As Variant

Provide the centerline of the Individuals control limits.

Property Let IndividualsCTL(RHS As Variant)

Provide the centerline of the Individuals control limits.

Property Get IndividualsMCTL() As Variant

Property Let IndividualsMCTL(RHS As Variant)

Property Get IndividualsSCTL() As Variant

Property Let IndividualsSCTL(RHS As Variant)

Property Get IndividualsLCL() As Variant

Provide the lower line of the Individuals control limits.

Property Let IndividualsLCL(RHS As Variant)

Provide the lower line of the Individuals control limits.

Property Get IndividualsMLCL() As Variant

Property Let IndividualsMLCL(RHS As Variant)

Property Get IndividualsSLCL() As Variant

Property Let IndividualsSLCL(RHS As Variant)

Property Get IndividualsUCL() As Variant

Provide the upper line of the Individuals control limits.

Property Let IndividualsUCL(RHS As Variant)

Provide the upper line of the Individuals control limits.

Property Get IndividualsMUCL() As Variant

Property Let IndividualsMUCL(RHS As Variant)

Property Get IndividualsSUCL() As Variant

Property Let IndividualsSUCL(RHS As Variant)

Property Get bIsDynamic() As Boolean

Property Let bIsDynamic(RHS As Boolean)

Function bIsMissing(ByVal dValue As Double) As Boolean

Property Get LCL(Optional ByVal eType As pqEnumDataType=0) As Double

Provide the lower line of a control limit.

Property Get eLimitsType() As pqEnumDataType

Property Let eLimitsType(RHS As pqEnumDataType)

Property Get sListSeparator() As String

Property Get MeasurementData() As _PQMeasurementData

Property Get MedianCTL() As Variant

Provide the centerline of the Median control limits.

Property Let MedianCTL(RHS As Variant)

Provide the centerline of the Median control limits.

Property Get MedianLCL() As Variant

Property Let MedianLCL(RHS As Variant)

Property Get MedianUCL() As Variant

Provide the upper line of the Median control limits.

Property Let MedianUCL(RHS As Variant)

Provide the upper line of the Median control limits.

Function MissingValue() As Double

Property Get sName() As String

My name.

Property Let sName(RHS As String)

My name.

Function bNotMissing(ByVal dValue As Double) As Boolean

Property Get dNumberOfSigma() As Double

Property Let dNumberOfSigma(RHS As Double)

Property Get RangeCTL() As Variant

Provide the centerline of the Range control limits.

Property Let RangeCTL(RHS As Variant)

Provide the centerline of the Range control limits.

Property Get RangeMCTL() As Variant

Property Let RangeMCTL(RHS As Variant)

Property Get RangeLCL() As Variant

Property Let RangeLCL(RHS As Variant)

Property Get RangeMLCL() As Variant

Property Let RangeMLCL(RHS As Variant)

Property Get RangeUCL() As Variant

Provide the upper line of the Range control limits.

Property Let RangeUCL(RHS As Variant)

Provide the upper line of the Range control limits.

Property Get RangeMUCL() As Variant

Property Let RangeMUCL(RHS As Variant)

Property Get RangeOfXbarsCTL() As Variant

Property Let RangeOfXbarsCTL(RHS As Variant)

Property Get RangeOfXbarsLCL() As Variant

Property Let RangeOfXbarsLCL(RHS As Variant)

Property Get RangeOfXbarsUCL() As Variant

Property Let RangeOfXbarsUCL(RHS As Variant)

Sub Reset

Sub SetSubgroupRange

Property Get bShowNegativeLimits() As Boolean

Property Let bShowNegativeLimits(RHS As Boolean)

Property Get SigmaCTL() As Variant

Provide the centerline of the Sigma control limits.

Property Let SigmaCTL(RHS As Variant)

Provide the centerline of the Sigma control limits.

Property Get SigmaLCL() As Variant

Property Let SigmaLCL(RHS As Variant)

Property Get SigmaUCL() As Variant

Provide the upper line of the Sigma control limits.

Property Let SigmaUCL(RHS As Variant)

Provide the upper line of the Sigma control limits.

Property Get sSortOrderColumn() As String

Property Let sSortOrderColumn(RHS As String)

Property Get iSS() As Integer

Property Let iSS(RHS As Integer)

Sub SubgroupLimits(ByVal SG As Long, ByVal UCL As Double, ByVal CTL As Double, ByVal LCL As Double, ByVal bCalc As Boolean)

Property Get SubTitle(ByVal iType As Integer, ByVal eType As pqEnumDataType) As String

Property Get Title(ByVal eType As pqEnumDataType, Optional ByVal eType2 As pqEnumDataType=0) As String

Provide a Limits Title for a particular type.

Property Get UCL(Optional ByVal eType As pqEnumDataType=0) As Double

Provide the upper line of a control limit.

Property Get UID() As Long

Property Let UID(RHS As Long)

Property Get bUseLimits() As Boolean

Whether to use these limits.

Property Let bUseLimits(RHS As Boolean)

Whether to use these limits.

Property Get bVaryingLimits() As Boolean

Function bWithinSigma(ByVal dSigma As Double, ByVal dValue As Double) As Boolean

Property Get iWtAvg() As Integer

Property Let iWtAvg(RHS As Integer)

Property Get iWtRange(Optional ByVal bMR As Boolean=False) As Integer

Property Let iWtRange(Optional ByVal bMR As Boolean=False, RHS As Integer)

Property Get XbarAsIndCTL() As Variant

Property Let XbarAsIndCTL(RHS As Variant)

Property Get XbarAsIndLCL() As Variant

Property Let XbarAsIndLCL(RHS As Variant)

Property Get XbarAsIndUCL() As Variant

Property Let XbarAsIndUCL(RHS As Variant)

Property Get XbarRCTL() As Variant

Provide the centerline of the Xbar control limits.

Property Let XbarRCTL(RHS As Variant)

Provide the centerline of the Xbar control limits.

Property Get XbarRLCL() As Variant

Property Let XbarRLCL(RHS As Variant)

Property Get XbarRUCL() As Variant

Provide the upper line of the Xbar control limits.

Property Let XbarRUCL(RHS As Variant)

Provide the upper line of the Xbar control limits.

Property Get XbarSCTL() As Variant

Property Let XbarSCTL(RHS As Variant)

Property Get XbarSLCL() As Variant

Property Let XbarSLCL(RHS As Variant)

Property Get XbarSUCL() As Variant

Property Let XbarSUCL(RHS As Variant)

Sub Defaults

Property Get PQLimits_CTL(Optional ByVal eType As pqEnumDataType=0) As Double

Property Set PQLimits_oData() As _PQData

Property Get PQLimits_LCL(Optional ByVal eType As pqEnumDataType=0) As Double

Events

No Events.

PQProductTargetPairs {DBFD1051-11A4-4094-949F-1089C81260A7}

Methods

Property Get bCaseSensitive() As Boolean

Property Let bCaseSensitive(RHS As Boolean)

Property Get EventHelper() As _PQDataEvent

Property Set EventHelper() As _PQDataEvent

Function AddPair(ByVal sProduct As String, ByVal sTarget As String) As Integer

Function AddProduct(ByVal sProduct As String) As Integer

Function AddTarget(ByVal sTarget As String, ByVal index As Integer) As Boolean

Sub Clear

Property Get Count() As Integer

Function DeleteProduct(ByVal sProduct As String) As Boolean

Property Get index(ByVal sProduct As String) As Integer

Property Get bIsTargetMissing(ByVal index As Integer) As Boolean

Sub Merge(ByVal oPTP As _PQProductTargetPairs)

Property Get sProduct(ByVal index As Integer) As String

Property Get sTarget(ByVal index As Integer) As String

Events

Public Event NewProductTargetPair(ByVal sProduct As String, ByVal sTarget As String)

PQRS {153B7035-99E5-4698-9246-D97048143058}

Methods

Property Get eType() As eRSType

The type of PQ recordset object that I am.

Property Let eType(RHS As eRSType)

The type of PQ recordset object that I am.

Property Get sName() As String

My name.

Property Let sName(RHS As String)

My name.

Property Get bReadonly() As Boolean

Whether to treat as a read-only Recordset.

Property Let bReadonly(RHS As Boolean)

Whether to treat as a read-only Recordset.

Property Get sTag() As String

Property Let sTag(RHS As String)

Property Get sErrMsg() As String

The outstanding error condition.

Property Let sErrMsg(RHS As String)

The outstanding error condition.

Property Get AbsolutePosition() As Long

Sub AddNew

Prepare to add a new row to the underlying recordset.

Property Get BOF() As Boolean

Whether at Beginning-of-File (data).

Property Get Bookmark() As Variant

Get/Set an object that determines the position of the recordset.

Property Let Bookmark(RHS As Variant)

Get/Set an object that determines the position of the recordset.

Property Get Bookmarkable() As Boolean

Whether the underlying recordset can accomodate bookmarks.

Property Get oColumn(ByVal vIndex As Variant) As _PQData

Property Get cColumns() As _Collection

Property Set cColumns() As _Collection

Function DeclareField(ByVal sName As String) As Integer

Declare a field name so it can be assigned a unique ID.

Function DefineField(ByVal sName As String, Optional ByVal bCalc As Boolean=False) As _PQField

Declare a field to be mapped on a field in the underlying recordset, or to be calculated from one or more fields in the recordset.

Sub Delete(Optional ByVal Opt As Variant)

Sub Edit

Prepare to modify one or more field values in the current row of the underlying recordset.

Property Get EOF() As Boolean

Whether at End-of-File (data).

Property Get bError() As Boolean

Property Get sErrText(ByVal eErr As pqEnumRSErrs) As String

Property Get EventHelper() As _PQDataEvent

Property Set EventHelper() As _PQDataEvent

Function FieldFormula(ByVal sName As String, ByVal sFormula As String) As Boolean

Provide the formula to use when calculating the value of a calculated field.

Property Get Fields() As _Collection

The PQFields collection.

Sub Find(ByVal Start As Variant)

Sub ForgetFields

Function GetString(ByVal iFormat As Integer, Optional ByVal lNumRows As Long=-1, ByVal sColDelim As String, ByVal sRowDelim As String, ByVal sNullExp As String) As String

Function GoToRow(ByVal lRow As Long) As Boolean

Sub Move(ByVal Rows As Variant, Optional ByVal Start As Variant)

Sub MoveFirst

Position to the first row in the underlying recordset.

Sub MoveLast

Position to the last row in the underlying recordset.

Sub MoveNext

Position to the row after the current row in the underlying recordset.

Sub MovePrevious

Position to the row before the current row in the underlying recordset.

Property Get RecordCount() As Long

Number of records in the underlying recordset.

Property Get Recordset() As Object

Property Set Recordset() As Object

Function Requery(Optional ByVal Opt As Variant) As Boolean

Sub Reset

Property Get sType() As String

Property Get Updatable() As Boolean

Sub Update(Optional ByVal Parm1 As Variant, Optional ByVal Parm2 As Variant)

Complete the actions necessary following AddNew or Edit.

Events

No Events.

PQRSMem {D222D6D3-24F0-42EE-8551-542EDCB7BC03}

Methods

Property Get AbsolutePosition() As Long

Sub AddRow

Prepare to add a new row.

Property Get BOF() As Boolean

Property Get Bookmark() As Variant

Property Let Bookmark(RHS As Variant)

Function Column(ByVal index As Integer, ByVal sName As String, ByVal iWidth As Integer) As Integer

Property Get cColumns() As _Collection

Property Set cColumns() As _Collection

Sub Delete(Optional ByVal Opt As Variant)

Sub EditRow

Prepare to edit the current row.

Property Get EOF() As Boolean

Property Get sErrMsg() As String

Property Let sErrMsg(RHS As String)

Property Get bError() As Boolean

Property Get EventHelper() As _PQDataEvent

Property Set EventHelper() As _PQDataEvent

Property Get Fields() As _Collection

Sub Find(ByVal Start As Variant)

Function GetString(ByVal iFormat As Integer, Optional ByVal lNumRows As Long=-1, ByVal sColDelim As String, ByVal sRowDelim As String, ByVal sNullExp As String) As String

Sub Move(ByVal Rows As Variant, Optional ByVal Start As Variant)

Sub MoveFirst

Sub MoveLast

Sub MoveNext

Sub MovePrevious

Property Get sName() As String

Property Let sName(RHS As String)

Property Get RecordCount() As Long

Sub Requery(Optional ByVal Opt As Variant)

Sub Reset

Set to the same state as when originally created.

Property Get sTag() As String

Property Let sTag(RHS As String)

Property Get sType() As String

Sub Update(Optional ByVal Parm1 As Variant, Optional ByVal Parm2 As Variant)

Events

Public Event GetValue(ByVal lRow As Long, ByVal iColumn As Integer, ByVal vValue As Variant)

Public Event NumberOfRows(ByVal lRows As Long)

PQShortRunData {764E3B03-C024-4A23-81A3-BA8360682447}

Methods

Property Get bCaseSensitive() As Boolean

Property Let bCaseSensitive(RHS As Boolean)

Property Get eHowToTreatGrossData() As pqEnumGrossData

Property Let eHowToTreatGrossData(RHS As pqEnumGrossData)

Property Get dGrossDataMinimum() As Double

Property Let dGrossDataMinimum(RHS As Double)

Property Get dGrossDataMaximum() As Double

Property Let dGrossDataMaximum(RHS As Double)

Function ApplyDecimalChar(ByVal sText As String) As String

Sub CauseColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get bCauseColumn() As Variant

Property Get nCauseColumnCount() As Integer

Property Let CauseCondition(RHS As String)

Property Get CoefficientOfVariation() As Double

Property Get sColumnName(ByVal iSeq As Integer) As String

Property Get eColumnType(ByVal iSeq As Integer) As pqEnumMapType

Property Get bConstantSubgroupSize() As Boolean

Function CurrentRow() As Long

Function CurrentSubgroup() As Long

Function DataEnumToStatEnum(ByVal eData As pqEnumDataType) As pqEnumStatistic

Property Get sDateFormat() As String

Property Let sDateFormat(RHS As String)

Sub DateIDColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Sub DateTimeIDColumn(ByVal sColumn As String, Optional ByVal sName As String=, Optional ByVal bDisplay As Boolean=False)

Property Get sDecimalCharacter() As String

Property Get iDecimalDigits(ByVal eType As pqEnumStatistic) As Integer

Property Let iDecimalDigits(ByVal eType As pqEnumStatistic, RHS As Integer)

Property Get bDisplayData(Optional ByVal index As Integer=0) As Boolean

Property Let bDisplayData(Optional ByVal index As Integer=0, RHS As Boolean)

Property Get bDisplayID(Optional ByVal index As Integer=0) As Boolean

Property Let bDisplayID(Optional ByVal index As Integer=0, RHS As Boolean)

Property Get sDisplayName() As String

Property Let sDisplayName(RHS As String)

Property Get bDisplayProduct() As Boolean

Property Let bDisplayProduct(RHS As Boolean)

Property Get bDisplayTarget() As Boolean

Property Let bDisplayTarget(RHS As Boolean)