| [ Index ] |
PHP Cross Reference of moodle-2.8 |
[Source view] [Print] [Project Stats]
PHPExcel Copyright (c) 2006 - 2014 PHPExcel
| Copyright: | Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel) |
| License: | http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL |
| Version: | ##VERSION##, ##DATE## |
| File Size: | 725 lines (28 kb) |
| Included or required: | 0 times |
| Referenced: | 0 times |
| Includes or requires: | 0 files |
Class: PHPExcel_Calculation_Database - X-Ref
PHPExcel_Calculation_Database| __fieldExtract($database,$field) X-Ref |
| __fieldExtract Extracts the column ID to use for the data field. param: mixed[] $database The range of cells that makes up the list or database. param: mixed $field Indicates which column is used in the function. Enter the return: string|NULL |
| __filter($database,$criteria) X-Ref |
| __filter Parses the selection criteria, extracts the database rows that match those criteria, and returns that subset of rows. param: mixed[] $database The range of cells that makes up the list or database. param: mixed[] $criteria The range of cells that contains the conditions you specify. return: array of mixed |
| DAVERAGE($database,$field,$criteria) X-Ref |
| DAVERAGE Averages the values in a column of a list or database that match conditions you specify. Excel Function: DAVERAGE(database,field,criteria) param: mixed[] $database The range of cells that makes up the list or database. param: string|integer $field Indicates which column is used in the function. Enter the param: mixed[] $criteria The range of cells that contains the conditions you specify. return: float |
| DCOUNT($database,$field,$criteria) X-Ref |
| DCOUNT Counts the cells that contain numbers in a column of a list or database that match conditions that you specify. Excel Function: DCOUNT(database,[field],criteria) Excel Function: DAVERAGE(database,field,criteria) param: mixed[] $database The range of cells that makes up the list or database. param: string|integer $field Indicates which column is used in the function. Enter the param: mixed[] $criteria The range of cells that contains the conditions you specify. return: integer |
| DCOUNTA($database,$field,$criteria) X-Ref |
| DCOUNTA Counts the nonblank cells in a column of a list or database that match conditions that you specify. Excel Function: DCOUNTA(database,[field],criteria) param: mixed[] $database The range of cells that makes up the list or database. param: string|integer $field Indicates which column is used in the function. Enter the param: mixed[] $criteria The range of cells that contains the conditions you specify. return: integer |
| DGET($database,$field,$criteria) X-Ref |
| DGET Extracts a single value from a column of a list or database that matches conditions that you specify. Excel Function: DGET(database,field,criteria) param: mixed[] $database The range of cells that makes up the list or database. param: string|integer $field Indicates which column is used in the function. Enter the param: mixed[] $criteria The range of cells that contains the conditions you specify. return: mixed |
| DMAX($database,$field,$criteria) X-Ref |
| DMAX Returns the largest number in a column of a list or database that matches conditions you that specify. Excel Function: DMAX(database,field,criteria) param: mixed[] $database The range of cells that makes up the list or database. param: string|integer $field Indicates which column is used in the function. Enter the param: mixed[] $criteria The range of cells that contains the conditions you specify. return: float |
| DMIN($database,$field,$criteria) X-Ref |
| DMIN Returns the smallest number in a column of a list or database that matches conditions you that specify. Excel Function: DMIN(database,field,criteria) param: mixed[] $database The range of cells that makes up the list or database. param: string|integer $field Indicates which column is used in the function. Enter the param: mixed[] $criteria The range of cells that contains the conditions you specify. return: float |
| DPRODUCT($database,$field,$criteria) X-Ref |
| DPRODUCT Multiplies the values in a column of a list or database that match conditions that you specify. Excel Function: DPRODUCT(database,field,criteria) param: mixed[] $database The range of cells that makes up the list or database. param: string|integer $field Indicates which column is used in the function. Enter the param: mixed[] $criteria The range of cells that contains the conditions you specify. return: float |
| DSTDEV($database,$field,$criteria) X-Ref |
| DSTDEV Estimates the standard deviation of a population based on a sample by using the numbers in a column of a list or database that match conditions that you specify. Excel Function: DSTDEV(database,field,criteria) param: mixed[] $database The range of cells that makes up the list or database. param: string|integer $field Indicates which column is used in the function. Enter the param: mixed[] $criteria The range of cells that contains the conditions you specify. return: float |
| DSTDEVP($database,$field,$criteria) X-Ref |
| DSTDEVP Calculates the standard deviation of a population based on the entire population by using the numbers in a column of a list or database that match conditions that you specify. Excel Function: DSTDEVP(database,field,criteria) param: mixed[] $database The range of cells that makes up the list or database. param: string|integer $field Indicates which column is used in the function. Enter the param: mixed[] $criteria The range of cells that contains the conditions you specify. return: float |
| DSUM($database,$field,$criteria) X-Ref |
| DSUM Adds the numbers in a column of a list or database that match conditions that you specify. Excel Function: DSUM(database,field,criteria) param: mixed[] $database The range of cells that makes up the list or database. param: string|integer $field Indicates which column is used in the function. Enter the param: mixed[] $criteria The range of cells that contains the conditions you specify. return: float |
| DVAR($database,$field,$criteria) X-Ref |
| DVAR Estimates the variance of a population based on a sample by using the numbers in a column of a list or database that match conditions that you specify. Excel Function: DVAR(database,field,criteria) param: mixed[] $database The range of cells that makes up the list or database. param: string|integer $field Indicates which column is used in the function. Enter the param: mixed[] $criteria The range of cells that contains the conditions you specify. return: float |
| DVARP($database,$field,$criteria) X-Ref |
| DVARP Calculates the variance of a population based on the entire population by using the numbers in a column of a list or database that match conditions that you specify. Excel Function: DVARP(database,field,criteria) param: mixed[] $database The range of cells that makes up the list or database. param: string|integer $field Indicates which column is used in the function. Enter the param: mixed[] $criteria The range of cells that contains the conditions you specify. return: float |
| Generated: Fri Nov 28 20:29:05 2014 | Cross-referenced by PHPXref 0.7.1 |