[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
ST_DataConsolidateFunction (Data Consolidation Functions)
Data consolidation functions specified by the user and used to consolidate ranges of data.
This simple type's contents are a restriction of the XML Schema string datatype.
The following are possible enumeration values for this type:
|
Enumeration Value |
Description |
|
average (Average) |
The average of the values. |
|
count (Count) |
The number of data values. The Count consolidation function works the same as the COUNTA worksheet function. |
|
countNums (CountNums) |
The number of data values that are numbers. The Count Nums consolidation function works the same as the COUNT worksheet function. |
|
max (Maximum) |
The largest value. |
|
min (Minimum) |
The smallest value. |
|
product (Product) |
The product of the values. |
|
stdDev (StdDev) |
An estimate of the standard deviation of a population, where the sample is a subset of the entire population. |
|
stdDevp (StdDevP) |
The standard deviation of a population, where the population is all of the data to be summarized. |
|
sum (Sum) |
The sum of the values. |
|
var (Variance) |
An estimate of the variance of a population, where the sample is a subset of the entire population. |
|
varp (VarP) |
The variance of a population, where the population is all of the data to be summarized. |
|
Referenced By |
|
dataConsolidate@function (§3.3.1.27); dataField@subtotal (§3.10.1.22) |
The following XML Schema fragment defines the contents of this simple type:
<simpleType name="ST_DataConsolidateFunction">
<restriction base="xsd:string">
<enumeration value="average"/>
<enumeration value="count"/>
<enumeration value="countNums"/>
<enumeration value="max"/>
<enumeration value="min"/>
<enumeration value="product"/>
<enumeration value="stdDev"/>
<enumeration value="stdDevp"/>
<enumeration value="sum"/>
<enumeration value="var"/>
<enumeration value="varp"/>
</restriction>
</simpleType>