PQDM3 Interface Definition

Interfaces

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

PQAuxLine {A2637128-8434-11D6-BD85-00105A109808}

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 Variant) As Boolean

Property Get sListSeparator() As String

Property Get sName() As String

Property Let sName(RHS As String)

Sub SetSubgroupRange

Property Get SmartData() As _DPQSD3

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 {D6768AB7-2E8C-11D6-BD85-00105A109808}

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

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

Property Get nCategoryColumnCount() As Integer

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 sCellValue(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 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=)

Property Get nControlColumnCount() As Integer

Property Get sControlValue(ByVal index As Integer) As String

Property Get iControlValueCount() As Integer

yVal eData As pqEnumWhatToUse=1, Optional ByVal sFormula As String=, Optional ByVal sName As String=)

Property Get nDataColumnCount() As Integer

Property Get sDecimalCharacter() As String

Property Get iEntryCount() As Integer

Property Get sEntryName(ByVal index 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

Function ExternalValue(ByVal dValue As Double) As Variant

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 InternalValue(ByVal vValue As Variant) As Double

Function bIsMissing(ByVal value As Variant) As Boolean

Property Get sLastRecord() As String

Property Let sLastRecord(RHS As String)

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

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)

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)

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 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)

PQCorrelationData {D6768ABC-2E8C-11D6-BD85-00105A109808}

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)

Property Get bForceDecimalDigits() As Boolean

Property Let bForceDecimalDigits(RHS As Boolean)

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

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

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

Property Get sDecimalCharacter() As String

Property Get iDecimalDigits(ByVal index As pqEnumStatistic) As Integer

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

Function EnsureGoodValue(ByVal vValue As Variant) As Variant

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

Function ExternalValue(ByVal dValue As Double) As Variant

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

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

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) As String

Property Get eIDType(ByVal vKey As Variant) As pqEnumMapType

Function InternalValue(ByVal vValue As Variant) As Double

Function bIsMissing(ByVal value As Variant) 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

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

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

Property Get PrimaryDataValue() As Variant

Property Get PrimaryMaximum() As Variant

Property Get PrimaryMean() As Variant

Property Get PrimaryMedian() As Variant

Property Get PrimaryMinimum() As Variant

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

Property Get PrimaryModes() As Integer

Property Get sPrimaryName() As String

Property Get PrimarySigma() As Variant

Property Get PrimaryWithinSigma(ByVal nSigma As Single) As Variant

Property Get RCoefficient() As Double

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

Property Get eResultRecordsToInclude() As pqEnumUseRows

Property Let eResultRecordsToInclude(RHS As pqEnumUseRows)

Property Get lResultRecordsToInclude() As Long

Property Let lResultRecordsToInclude(RHS As Long)

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

Property Get SecondaryDataValue() As Variant

Property Get SecondaryMaximum() As Variant

Property Get SecondaryMean() As Variant

Property Get SecondaryMedian() As Variant

Property Get SecondaryMinimum() As Variant

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

Property Get SecondaryModes() As Integer

Property Get sSecondaryName() As String

Property Get SecondarySigma() As Variant

Property Get SecondaryWithinSigma(ByVal nSigma As Single) As Variant

Property Get RowID(ByVal index As Integer) As String

Property Get lRows() As Long

Property Get sSubsetOptions() As String

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

Property Get UID() As Long

Property Let UID(RHS As Long)

Property Get WithinSigma(ByVal nSigma As Single) As Variant

Events

No Events.

PQCountData {D6768AC0-2E8C-11D6-BD85-00105A109808}

Methods

Property Get cLimits() As _Collection

Property Set cLimits() As _Collection

Property Get sConstantNumberInspected() As String

Property Let sConstantNumberInspected(RHS As String)

Property Get bTreatBlankEntryAsZero() As Boolean

Property Let bTreatBlankEntryAsZero(RHS As Boolean)

Property Get bForceDecimalDigits() As Boolean

Property Let bForceDecimalDigits(RHS As Boolean)

Function ApplyDecimalChar(ByVal sText As String) As String

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

Property Get bCauseColumn() As Variant

Property Get nCauseColumnCount() As Integer

Property Let CauseCondition(RHS As String)

Property Get CBar() As Variant

Sub ClearLimits

Property Get sColumnName(ByVal iSeq As Integer) As String

Property Get eColumnType(ByVal iSeq As Integer) As pqEnumMapType

Property Get bConstantNumberInspected() As Boolean

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 bInternal As Boolean=False) As String

Sub CountOfEventsColumn(ByVal sField As String, Optional ByVal sName As String=)

Function nCountOfEventsColumnCount() As Integer

Sub CountOfItemsColumn(ByVal sField As String, Optional ByVal sName As String=)

Function nCountOfItemsColumnCount() As Integer

Property Get sDateFormat() As String

Property Let sDateFormat(RHS As String)

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

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

Property Get sDecimalCharacter() As String

Property Get iDecimalDigits(ByVal index As pqEnumStatistic) As Integer

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

Function EnsureGoodValue(ByVal vValue As Variant) As Variant

Property Get sErrMsg() As String

Property Let sErrMsg(RHS As String)

Property Get bError() As Boolean

Property Get EventCountMean() As Variant

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

Property Get EventHelper() As _PQDataEvent

Property Set EventHelper() As _PQDataEvent

Function ExternalValue(ByVal dValue As Double) As Variant

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 GoToFirstGrouping() As Boolean

Function GoToNext() As Boolean

Function GoToNextGrouping() As Boolean

Function GoToSubgroup(ByVal lSG As Long) As Boolean

Property Let sGrouping(RHS As String)

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

Function IDMap(ByVal vKey As Variant) As _PQMap

Property Get sIDName(ByVal iSeq As Integer) As String

Property Get eIDType(ByVal vKey As Variant) As pqEnumMapType

Sub InspectedColumn(ByVal sField As String, Optional ByVal sName As String=)

Function nInspectedDecimalDigits() As Integer

Property Get InspectedMaximum() As Double

Property Get InspectedMean() As Double

Property Get InspectedMinimum() As Double

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

Function InternalValue(ByVal vValue As Variant) As Double

Function bIsMissing(ByVal value As Variant) As Boolean

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

Function bIsOOCTestValid(ByVal sTest As String) As Boolean

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

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

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

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

Property Get ItemCountMean() As Double

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

Property Get sLastRecord() As String

Property Let sLastRecord(RHS As String)

Property Get sListSeparator() As String

Property Get LongestOOCRun(ByVal eType As pqEnumDataType) As Variant

Property Get Maximum() As Variant

Property Get iMaximumSubgroupsToKeep() As Integer

Property Let iMaximumSubgroupsToKeep(RHS As Integer)

Property Get Minimum() As Variant

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=)

Property Get bNoteColumn() As Variant

Property Get nNoteColumnCount() As Integer

Property Get NPBar() As Variant

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 NumberOfPointsOutOfControl(ByVal eType As pqEnumDataType) As Long

Property Get NumberOfSubgroups() As Long

Sub NumericIDColumn(ByVal sColumn As String, Optional ByVal sName 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

Property Let sOOCTest(ByVal index As Integer, RHS 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 Variant

Sub PercentColumn(ByVal sField As String, Optional ByVal sName As String=)

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

Sub ProportionColumn(ByVal sField As String, Optional ByVal sName As String=)

Function nProportionColumnCount() As Integer

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

Sub RatioColumn(ByVal sField As String, Optional ByVal sName As String=)

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

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

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 SubgroupAdd(Optional ByVal sText As String=) As Boolean

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

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 Variant

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

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 SubgroupInspected(Optional ByVal lSG As Long=0) As Variant

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

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

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

Property Get SubgroupLabel(ByVal iLabel As Integer) As String

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 Variant

Property Let SubgroupNumberColumn(RHS As String)

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

Property Get SubgroupStart() As Long

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

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 sTime As String, Optional ByVal sName As String=)

Property Get UBar() As Variant

Property Get UniqueIDColumn() As String

Property Let UniqueIDColumn(RHS As String)

Events

No Events.

PQCountLimits {D6768ABE-2E8C-11D6-BD85-00105A109808}

Methods

Property Get sActualCalcFrom() As String

Property Get sActualCalcTo() As String

Sub ApplyLimits(ByVal eType As pqEnumDataType, ByVal UCL As Variant, ByVal CTL As Variant, ByVal LCL As Variant, ByVal NBar 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 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 Double

Property Let dCountsMean(RHS As Double)

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

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 Double

Property Let dInspectedMean(RHS As Double)

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 Variant

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 sSortOrderColumn() As String

Property Let sSortOrderColumn(RHS As String)

Sub SubgroupLimits(ByVal SG As Long, ByVal MyUCL As Double, ByVal MyCTL As Double, ByVal MyLCL As Double, ByVal bCalc As Boolean)

Property Get SubTitle(ByVal iType As Integer, ByVal eType As pqEnumDataType, ByVal dMultiplier As Double) 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 Variant

Property Get bUseLimits() As Boolean

Property Let bUseLimits(RHS As Boolean)

Events

No Events.

PQData {D6768A9B-2E8C-11D6-BD85-00105A109808}

Methods

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 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

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

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 EnsureGoodValue(ByVal vValue As Variant) As Variant

Property Get sErrMsg() As String

Property Let sErrMsg(RHS As String)

Function ExternalValue(ByVal dValue As Double) As Variant

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

Property Let sGrouping(RHS As String)

Function IDMap(ByVal vKey As Variant) As _PQMap

Function InternalValue(ByVal vValue As Variant) As Double

Function bIsMissing(ByVal value As Variant) As Boolean

Property Get sListSeparator() As String

Property Get MissingValue() As Double

Property Let MissingValue(RHS As Double)

Function NewLimits(ByVal sName As String) As _PQLimits

Property Get NumberOfColumns() As Integer

Property Get NumberOfIDs() As Integer

Property Get NumberOfRecords() As Long

Property Get sOrderBy() As String

Property Let sOrderBy(RHS As String)

Sub PostSetup

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

Sub Reset

Sub SelectData(Optional ByVal sExtra As String=)

Property Get SmartData() As _DPQSD3

Property Get sSubset() As String

Property Let sSubset(RHS As String)

Property Get UID() As Long

Property Let UID(RHS As Long)

Function bValidField(ByVal sField As String) As Boolean

Events

No Events.

PQDataEvent {D6768AA3-2E8C-11D6-BD85-00105A109808}

Methods

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

Property Get sDecimalCharacter() As String

Sub DoSetup

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 GoToRow(ByVal sRS As String, ByVal lRow As Long) As Boolean

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

Property Get sListSeparator() As String

Function SmartData() As _DPQSD3

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 DecimalCharacter(ByVal sDC As String)

Public Event DoSetup(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 _DPQSD3)

Public Event GoToRow(ByVal sRS As String, ByVal lRow As Long, ByVal bSuccess As Boolean)

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

Public Event ListSeparator(ByVal sLS As String)

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 {D6768AC4-2E8C-11D6-BD85-00105A109808}

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

Function AddPQRS(ByVal oPQRS As _PQRS) As Variant

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 NewGradingData(ByVal sName As String, Optional ByVal vIndex As Variant=1) As _PQGradingData

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() 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 {D6768AB2-2E8C-11D6-BD85-00105A109808}

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 {D6768A86-2E8C-11D6-BD85-00105A109808}

Methods

None

Events

No Events.

PQField {D6768A9D-2E8C-11D6-BD85-00105A109808}

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 {D6768AB0-2E8C-11D6-BD85-00105A109808}

Methods

Property Get EventHelper() As _PQDataEvent

Property Set EventHelper() As _PQDataEvent

Property Set FieldCalculator() As _PQFldCalc

Events

No Events.

PQFieldMem {D6768AAE-2E8C-11D6-BD85-00105A109808}

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 {D6768A97-2E8C-11D6-BD85-00105A109808}

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.

PQGradingData {2D40ACEE-5B51-11D6-BD85-00105A109808}

Methods

Property Get sPrimaryField() As String

Property Let sPrimaryField(RHS As String)

Property Get sSecondaryField() As String

Property Let sSecondaryField(RHS As String)

Property Get bForceDecimalDigits() As Boolean

Property Let bForceDecimalDigits(RHS As Boolean)

Function ApplyDecimalChar(ByVal sText As String) As String

Property Get sCategoryName(ByVal iEntry As Integer, ByVal iBar As Integer) As String

Function Cause() As String

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

Property Get bCauseColumn() As Variant

Property Get nCauseColumnCount() As Integer

Property Let CauseCondition(RHS As String)

Property Get sClassName() As String

Property Let sClassName(RHS As String)

Sub ClassNamesColumn(ByVal sColumn 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)

Property Get sDateFormat() As String

Property Let sDateFormat(RHS As String)

Function DateIDColumn(ByVal sDate As String) As Integer

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 sDistrictName() As String

Property Let sDistrictName(RHS As String)

Sub DistrictNamesColumn(ByVal sColumn As String)

Function EnsureGoodValue(ByVal vValue As Variant) As Variant

Property Get sEntryName(ByVal iEntry As Integer) 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

Function ExternalValue(ByVal dValue As Double) As Variant

Property Get sFilter() As String

Property Let sFilter(RHS As String)

Function sFilterAsTitle() 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

Function GoToNext() As Boolean

Function GoToRecord(ByVal lRecord As Long) As Boolean

Function Grade() As Double

Property Get dGrade(ByVal iEntry As Integer, ByVal iBar As Integer) As String

Function GradeAverage() As Double

Function GradeMedian() As Double

Sub GradesColumn(ByVal sColumn As String)

Property Get nGradesColumnCount() As Integer

Property Get sGradeType() As String

Property Let sGradeType(RHS As String)

Sub GradeTypesColumn(ByVal sColumn As String)

Property Let sGrouping(RHS As String)

Property Get iID() As Integer

Property Let iID(RHS As Integer)

Function IDColumn(ByVal sID As String, Optional ByVal sName As String=) As Integer

Function IDMap(ByVal vKey As Variant) As _PQMap

Property Get sIDName(ByVal iSeq As Integer) As String

Property Get eIDType(ByVal vKey As Variant) As pqEnumMapType

Function InternalValue(ByVal vValue As Variant) As Double

Function bIsMissing(ByVal value As Variant) As Boolean

Property Get bIsRecordCaused(Optional ByVal lRow As Long=0) As Boolean

Property Get sLastRecord() As String

Property Let sLastRecord(RHS As String)

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 bNeedData() As Boolean

Function Note() As String

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

Property Get bNoteColumn() As Variant

Property Get nNoteColumnCount() As Integer

Property Get NumberOfBars(ByVal iEntry As Integer) As Integer

Property Get NumberOfColumns() As Integer

Property Get NumberOfEntries() As Integer

Property Get NumberOfIDs() As Integer

Property Get NumberOfRecords() As Long

Function NumericIDColumn(ByVal sColumn As String) As Integer

Property Get bReportOnOther() As Boolean

Property Let bReportOnOther(RHS As Boolean)

Property Get sRestrictReporting() As String

Property Let sRestrictReporting(RHS As String)

Property Get bReverseOrder() As Boolean

Property Let bReverseOrder(RHS As Boolean)

Property Get sSchoolName() As String

Property Let sSchoolName(RHS As String)

Sub SchoolNamesColumn(ByVal sColumn As String)

Sub SelectData(Optional ByVal sExtra As String=)

Sub ShareMyFields(ByVal oData As _PQData)

Property Get sStateName() As String

Property Let sStateName(RHS As String)

Sub StateNamesColumn(ByVal sColumn As String)

Property Get sStudentName() As String

Property Let sStudentName(RHS As String)

Sub StudentNamesColumn(ByVal sColumn As String)

Property Get sSubjectName() As String

Property Let sSubjectName(RHS As String)

Sub SubjectNamesColumn(ByVal sColumn As String)

Property Get sSubset() As String

Property Let sSubset(RHS As String)

Property Get sTeacherName() As String

Property Let sTeacherName(RHS As String)

Sub TeacherNamesColumn(ByVal sColumn As String)

Property Get UID() As Long

Property Let UID(RHS As Long)

Property Get eWhatToReport() As pqEnumReportOn

Property Let eWhatToReport(RHS As pqEnumReportOn)

Events

No Events.

PQLimits {D6768AA6-2E8C-11D6-BD85-00105A109808}

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 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 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 Variant, ByVal CTL As Variant, ByVal LCL As Variant, 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 sDecimalCharacter() As String

Function bError() As Boolean

Function GetVal(ByVal value As Variant) As Double

Function bIsMissing(ByVal value As Variant) As Boolean

Property Get eLimitsType() As pqEnumDataType

Property Let eLimitsType(RHS As pqEnumDataType)

Property Get sListSeparator() As String

Property Get SmartData() As _DPQSD3

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

Property Get UID() As Long

Property Let UID(RHS As Long)

Events

No Events.

PQMap {D6768A99-2E8C-11D6-BD85-00105A109808}

Methods

Property Get sName() As String

Property Let sName(RHS As String)

Property Get sInternalName() As String

Property Let sInternalName(RHS As String)

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

Events

No Events.

PQMeasurementData {D6768AA8-2E8C-11D6-BD85-00105A109808}

Methods

Property Get cLimits() As _Collection

Collection of Control Limits.

Property Set cLimits() As _Collection

Collection of Control Limits.

Property Get bForceDecimalDigits() As Boolean

Property Let bForceDecimalDigits(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 CalculateEstimatedSigmaUsingRange() As Boolean

Whether to use range (vs sigma) when calculating Estimated Sigma.

Property Let CalculateEstimatedSigmaUsingRange(RHS As Boolean)

Whether to use range (vs sigma) when calculating Estimated Sigma.

Property Get eCapabilityMidpoint() As pqEnumCapabilityMidpoint

Property Let eCapabilityMidpoint(RHS As pqEnumCapabilityMidpoint)

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

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 Variant

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 Variant

Provide the significance of Chi Square.

Property Get ChiSquareStatusMsg() As String

Sub ClearLimits

Property Get CoefficientOfVariation() As Variant

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 Cp() As Variant

Provide the Capability index: Cp

Property Get Cpk() As Variant

Provide the Capability index: Cpk

Property Get Cpl() As Variant

Provide the Capability index: Cpl

Property Get Cpm() As Variant

Provide the Capability index: Cpm

Property Get Cpu() As Variant

Provide the Capability index: Cpu

Property Get Cr() As Variant

Provide the Capability index: Cr

Property Get bCurveFits() As Boolean

Property Get sDateFormat() As String

Property Let sDateFormat(RHS As String)

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

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

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 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.

Function EnsureGoodValue(ByVal vValue As Variant) As Variant

Property Get sErrMsg() As String

Property Let sErrMsg(RHS As String)

Property Get bError() As Boolean

Property Get EstimatedSigma() As Variant

Property Get EstimatedSigmaBasedOnRange() As Variant

Property Get EstimatedSigmaBasedOnSigma() As Variant

Property Get EventHelper() As _PQDataEvent

Property Set EventHelper() As _PQDataEvent

Function ExternalValue(ByVal dValue As Double) As Variant

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) As String

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

Function GoToFirstGrouping() As Boolean

Function GoToNext() As Boolean

Function GoToNextGrouping() As Boolean

Function GoToSubgroup(ByVal lSG As Long) As Boolean

Property Get GrandMean() As Variant

Property Let sGrouping(RHS As String)

How to group the data when returning values. To inquire, enter sGrouping = "?"

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)

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

Function IDMap(ByVal vKey As Variant) As _PQMap

Property Get sIDName(ByVal iSeq As Integer) As String

Property Get eIDType(ByVal vKey As Variant) As pqEnumMapType

Property Get bIgnoreMissingSubgroupOnMovingSubgroups() As Boolean

Property Let bIgnoreMissingSubgroupOnMovingSubgroups(RHS As Boolean)

Function InternalValue(ByVal vValue As Variant) As Double

Function bIsMissing(ByVal value As Variant) As Boolean

Property Get bIsOOC(ByVal nTest As Integer, ByVal eType As pqEnumDataType, ByVal lSG As Long, 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

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

Property Get Kurtosis() As Variant

Provide Kurtosis of the population.

Property Get sLastRecord() As String

Property Let sLastRecord(RHS As String)

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)

Property Get Maximum() As Variant

Provide the Maximum of the population.

Property Get iMaximumSubgroupsToKeep() As Integer

Property Let iMaximumSubgroupsToKeep(RHS As Integer)

Property Get MeanMean() As Variant

Property Get MeanMedian() As Variant

Property Get MeanRange() As Variant

Property Get MeanSigma() As Variant

Property Get MeasurementLimits(ByVal vKey As Variant) As _PQMeasurementLimits

Property Set MeasurementLimits(ByVal vKey As Variant) As _PQMeasurementLimits

Property Get Median() As Variant

Provide Median of the population.

Property Get Minimum() As Variant

Provide the Minimum of the population.

Property Get MissingValue() As Double

Property Let MissingValue(RHS As Double)

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

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

Property Get Modes() 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() As Integer

Moving Range to use when the subgroup size = 1.

Property Let MovingRange(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=)

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 NumberOfSubgroups() As Long

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

Property Let ObservationColumn(RHS 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 sOrderBy() As String

Property Let sOrderBy(RHS As String)

Property Get bOrderData() As Boolean

Property Let bOrderData(RHS As Boolean)

Property Get PearsonK() As Variant

Provide above spec (percent).

Property Get PearsonL() As Variant

Property Get PearsonU() As Variant

Property Get PercentAboveSpec() As Variant

Property Get PercentBelowSpec() As Variant

Provide below spec (percent).

Property Get PercentOutOfSpec() As Variant

Provide out-of-spec (percent).

Property Get PercentTheoreticalAboveSpec() As Variant

Provide theoretical above spec (percent).

Property Get PercentTheoreticalBelowSpec() As Variant

Provide theoretical below spec (percent).

Property Get PercentTheoreticalOutOfSpec() As Variant

Provide theoretical out-of-spec (percent).

Property Get PercentWithinSigma(ByVal fSigma As Single) As Variant

Property Get Pp() As Variant

Provide the Process index: Pp

Property Get Ppk() As Variant

Provide the Process index: Ppk

Property Get sPQRS() As String

Property Let sPQRS(RHS As String)

Property Get Pr() As Variant

Provide the Process index: Pr

Property Get Range() As Variant

Provide Range of the population.

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

Property Get eResultRecordsToInclude() As pqEnumUseRows

Property Let eResultRecordsToInclude(RHS As pqEnumUseRows)

Property Get lResultRecordsToInclude() As Long

Property Let lResultRecordsToInclude(RHS As Long)

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

Sub RowSelectionByCount(ByVal lPerRows As Long)

Sub RowSelectionUsage(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 Variant

Provide the sigma (standard deviation) of the population.

Property Get SigmaFromTarget() As Variant

Function dNSigmaValue(ByVal dNSigma As Double) As Variant

Property Get Skewness() As Variant

Provide Skewness of the population.

Property Get StatisticByID(ByVal eStat As pqEnumStatistic) As Variant

Property Get StatisticByName(ByVal sStat As String) As Variant

Property Get eStatisticsBasis() As pqEnumStatsBasis

Property Let eStatisticsBasis(RHS As pqEnumStatsBasis)

Property Get iStatisticID(ByVal sStat As String) As Integer

Function SubgroupAdd(Optional ByVal sText As String=) 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 Variant

Property Get SubgroupEnd() As Long

Property Get SubgroupID(ByVal index As Variant) 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 SubgroupMax(Optional ByVal lSG As Long=0) As Variant

Provide the maximum of the observations of the current subgroup.

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

Provide the average of the observations of the current subgroup.

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

Provide the median of the observations of the current subgroup.

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

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

Property Let SubgroupNumberColumn(RHS As String)

PQDM3 Interface Definition

General Information

Contents

Enumerations

Interfaces

PQAuxLine {A2637128-8434-11D6-BD85-00105A109808}

Methods

Events

PQCategoryData {D6768AB7-2E8C-11D6-BD85-00105A109808}

Methods

Events

PQCorrelationData {D6768ABC-2E8C-11D6-BD85-00105A109808}

Methods

Events

PQCountData {D6768AC0-2E8C-11D6-BD85-00105A109808}

Methods

Events

PQCountLimits {D6768ABE-2E8C-11D6-BD85-00105A109808}

Methods

Events

PQData {D6768A9B-2E8C-11D6-BD85-00105A109808}

Methods

Events

PQDataEvent {D6768AA3-2E8C-11D6-BD85-00105A109808}

Methods

Events

PQDataMgr {D6768AC4-2E8C-11D6-BD85-00105A109808}

Methods

Events

PQDataMgrEvent {D6768AB2-2E8C-11D6-BD85-00105A109808}

Methods

Events

PQDMEnums {D6768A86-2E8C-11D6-BD85-00105A109808}

Methods

Events

PQField {D6768A9D-2E8C-11D6-BD85-00105A109808}

Methods

Events

PQFieldCalc {D6768AB0-2E8C-11D6-BD85-00105A109808}

Methods

Events

PQFieldMem {D6768AAE-2E8C-11D6-BD85-00105A109808}

Methods

Events

PQFldCalc {D6768A97-2E8C-11D6-BD85-00105A109808}

Methods

Events

PQGradingData {2D40ACEE-5B51-11D6-BD85-00105A109808}

Methods

Events

PQLimits {D6768AA6-2E8C-11D6-BD85-00105A109808}

Methods

Events

PQMap {D6768A99-2E8C-11D6-BD85-00105A109808}

Methods

Events

PQMeasurementData {D6768AA8-2E8C-11D6-BD85-00105A109808}

Methods