[ Index ]

PHP Cross Reference of Unnamed Project

title

Body

[close]

/lib/phpexcel/PHPExcel/Calculation/ -> Database.php (summary)

[Source view] [Print] [Project Stats]

(no description)

File Size: 676 lines (33 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class

PHPExcel_Calculation_Database:: (15 methods):
  fieldExtract()
  filter()
  getFilteredColumn()
  DAVERAGE()
  DCOUNT()
  DCOUNTA()
  DGET()
  DMAX()
  DMIN()
  DPRODUCT()
  DSTDEV()
  DSTDEVP()
  DSUM()
  DVAR()
  DVARP()


Class: PHPExcel_Calculation_Database  - X-Ref

PHPExcel_Calculation_Database

Copyright (c) 2006 - 2015 PHPExcel

This library is free software; you can redistribute it and/or
modify it under the terms of the GNU Lesser General Public
License as published by the Free Software Foundation; either
version 2.1 of the License, or (at your option) any later version.

This library is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
Lesser General Public License for more details.

You should have received a copy of the GNU Lesser General Public
License along with this library; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA

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

getFilteredColumn($database, $field, $criteria)   X-Ref
No description

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: Thu Aug 11 10:00:09 2016 Cross-referenced by PHPXref 0.7.1