You are here

199 calls to PHPExcel_Calculation_Functions::flattenSingleValue() in Loft Data Grids 6.2

PHPExcel_Calculation::_processTokenStack in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php
PHPExcel_Calculation::_showValue in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php
* Format details of an operand for display in the log (based on operand type) * *
PHPExcel_Calculation_Database::__fieldExtract in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Database.php
* __fieldExtract * * Extracts the column ID to use for the data field. * * @access private *
PHPExcel_Calculation_DateTime::DATE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php
* DATE * * The DATE function returns a value that represents a particular date. * * NOTE: When used in a Cell Formula, MS Excel changes the cell format so that it matches the date * format of your regional settings. PHPExcel does not change…
PHPExcel_Calculation_DateTime::DATEDIF in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php
* DATEDIF * *
PHPExcel_Calculation_DateTime::DATEVALUE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php
* DATEVALUE * * Returns a value that represents a particular date. * Use DATEVALUE to convert a date represented by a text string to an Excel or PHP date/time stamp * value. * * NOTE: When used in a Cell Formula, MS Excel changes the cell…
PHPExcel_Calculation_DateTime::DAYOFMONTH in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php
* DAYOFMONTH * * Returns the day of the month, for a specified date. The day is given as an integer * ranging from 1 to 31. * * Excel Function: * DAY(dateValue) * *
PHPExcel_Calculation_DateTime::DAYOFWEEK in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php
* DAYOFWEEK * * Returns the day of the week for a specified date. The day is given as an integer * ranging from 0 to 7 (dependent on the requested style). * * Excel Function: * WEEKDAY(dateValue[,style]) * *
PHPExcel_Calculation_DateTime::DAYS360 in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php
* DAYS360 * * Returns the number of days between two dates based on a 360-day year (twelve 30-day months), * which is used in some accounting calculations. Use this function to help compute payments if * your accounting system is based on…
PHPExcel_Calculation_DateTime::EDATE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php
* EDATE * * Returns the serial number that represents the date that is the indicated number of months * before or after a specified date (the start_date). * Use EDATE to calculate maturity dates or due dates that fall on the same day of the…
PHPExcel_Calculation_DateTime::EOMONTH in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php
* EOMONTH * * Returns the date value for the last day of the month that is the indicated number of months * before or after start_date. * Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month. * *…
PHPExcel_Calculation_DateTime::HOUROFDAY in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php
* HOUROFDAY * * Returns the hour of a time value. * The hour is given as an integer, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.). * * Excel Function: * HOUR(timeValue) * *
PHPExcel_Calculation_DateTime::MINUTEOFHOUR in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php
* MINUTEOFHOUR * * Returns the minutes of a time value. * The minute is given as an integer, ranging from 0 to 59. * * Excel Function: * MINUTE(timeValue) * *
PHPExcel_Calculation_DateTime::MONTHOFYEAR in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php
* MONTHOFYEAR * * Returns the month of a date represented by a serial number. * The month is given as an integer, ranging from 1 (January) to 12 (December). * * Excel Function: * MONTH(dateValue) * *
PHPExcel_Calculation_DateTime::NETWORKDAYS in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php
* NETWORKDAYS * * Returns the number of whole working days between start_date and end_date. Working days * exclude weekends and any dates identified in holidays. * Use NETWORKDAYS to calculate employee benefits that accrue based on the number…
PHPExcel_Calculation_DateTime::SECONDOFMINUTE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php
* SECONDOFMINUTE * * Returns the seconds of a time value. * The second is given as an integer in the range 0 (zero) to 59. * * Excel Function: * SECOND(timeValue) * *
PHPExcel_Calculation_DateTime::TIME in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php
* TIME * * The TIME function returns a value that represents a particular time. * * NOTE: When used in a Cell Formula, MS Excel changes the cell format so that it matches the time * format of your regional settings. PHPExcel does not change…
PHPExcel_Calculation_DateTime::TIMEVALUE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php
* TIMEVALUE * * Returns a value that represents a particular time. * Use TIMEVALUE to convert a time represented by a text string to an Excel or PHP date/time stamp * value. * * NOTE: When used in a Cell Formula, MS Excel changes the cell…
PHPExcel_Calculation_DateTime::WEEKOFYEAR in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php
* WEEKOFYEAR * * Returns the week of the year for a specified date. * The WEEKNUM function considers the week containing January 1 to be the first week of the year. * However, there is a European standard that defines the first week as the one…
PHPExcel_Calculation_DateTime::WORKDAY in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php
* WORKDAY * * Returns the date that is the indicated number of working days before or after a date (the * starting date). Working days exclude weekends and any dates identified as holidays. * Use WORKDAY to exclude weekends or holidays when…
PHPExcel_Calculation_DateTime::YEAR in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php
* YEAR * * Returns the year corresponding to a date. * The year is returned as an integer in the range 1900-9999. * * Excel Function: * YEAR(dateValue) * *
PHPExcel_Calculation_DateTime::YEARFRAC in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php
* YEARFRAC * * Calculates the fraction of the year represented by the number of whole days between two dates * (the start_date and the end_date). * Use the YEARFRAC worksheet function to identify the proportion of a whole year's benefits…
PHPExcel_Calculation_Engineering::BESSELI in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* BESSELI * * Returns the modified Bessel function In(x), which is equivalent to the Bessel function evaluated * for purely imaginary arguments * * Excel Function: * BESSELI(x,ord) * * @access public * @category Engineering…
PHPExcel_Calculation_Engineering::BESSELJ in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* BESSELJ * * Returns the Bessel function * * Excel Function: * BESSELJ(x,ord) * * @access public * @category Engineering Functions *
PHPExcel_Calculation_Engineering::BESSELK in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* BESSELK * * Returns the modified Bessel function Kn(x), which is equivalent to the Bessel functions evaluated * for purely imaginary arguments. * * Excel Function: * BESSELK(x,ord) * * @access public * @category Engineering…
PHPExcel_Calculation_Engineering::BESSELY in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* BESSELY * * Returns the Bessel function, which is also called the Weber function or the Neumann function. * * Excel Function: * BESSELY(x,ord) * * @access public * @category Engineering Functions *
PHPExcel_Calculation_Engineering::BINTODEC in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* BINTODEC * * Return a binary value as decimal. * * Excel Function: * BIN2DEC(x) * * @access public * @category Engineering Functions *
PHPExcel_Calculation_Engineering::BINTOHEX in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* BINTOHEX * * Return a binary value as hex. * * Excel Function: * BIN2HEX(x[,places]) * * @access public * @category Engineering Functions *
PHPExcel_Calculation_Engineering::BINTOOCT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* BINTOOCT * * Return a binary value as octal. * * Excel Function: * BIN2OCT(x[,places]) * * @access public * @category Engineering Functions *
PHPExcel_Calculation_Engineering::COMPLEX in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* COMPLEX * * Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj. * * Excel Function: * COMPLEX(realNumber,imaginary[,places]) * * @access public * @category Engineering Functions *
PHPExcel_Calculation_Engineering::CONVERTUOM in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* CONVERTUOM * * Converts a number from one measurement system to another. * For example, CONVERT can translate a table of distances in miles to a table of distances * in kilometers. * * Excel Function: * CONVERT(value,fromUOM,toUOM) …
PHPExcel_Calculation_Engineering::DECTOBIN in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* DECTOBIN * * Return a decimal value as binary. * * Excel Function: * DEC2BIN(x[,places]) * * @access public * @category Engineering Functions *
PHPExcel_Calculation_Engineering::DECTOHEX in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* DECTOHEX * * Return a decimal value as hex. * * Excel Function: * DEC2HEX(x[,places]) * * @access public * @category Engineering Functions *
PHPExcel_Calculation_Engineering::DECTOOCT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* DECTOOCT * * Return an decimal value as octal. * * Excel Function: * DEC2OCT(x[,places]) * * @access public * @category Engineering Functions *
PHPExcel_Calculation_Engineering::DELTA in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* DELTA * * Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise. * Use this function to filter a set of values. For example, by summing several DELTA * functions you calculate the count of equal pairs. This…
PHPExcel_Calculation_Engineering::ERF in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* ERF * * Returns the error function integrated between the lower and upper bound arguments. * * Note: In Excel 2007 or earlier, if you input a negative value for the upper or lower bound arguments, * the function would return a #NUM!…
PHPExcel_Calculation_Engineering::ERFC in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* ERFC * * Returns the complementary ERF function integrated between x and infinity * * Note: In Excel 2007 or earlier, if you input a negative value for the lower bound argument, * the function would return a #NUM! error. However, in Excel…
PHPExcel_Calculation_Engineering::GESTEP in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* GESTEP * * Excel Function: * GESTEP(number[,step]) * * Returns 1 if number >= step; returns 0 (zero) otherwise * Use this function to filter a set of values. For example, by summing several GESTEP * functions you calculate the…
PHPExcel_Calculation_Engineering::HEXTOBIN in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* HEXTOBIN * * Return a hex value as binary. * * Excel Function: * HEX2BIN(x[,places]) * * @access public * @category Engineering Functions *
PHPExcel_Calculation_Engineering::HEXTODEC in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* HEXTODEC * * Return a hex value as decimal. * * Excel Function: * HEX2DEC(x) * * @access public * @category Engineering Functions *
PHPExcel_Calculation_Engineering::HEXTOOCT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* HEXTOOCT * * Return a hex value as octal. * * Excel Function: * HEX2OCT(x[,places]) * * @access public * @category Engineering Functions *
PHPExcel_Calculation_Engineering::IMABS in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* IMABS * * Returns the absolute value (modulus) of a complex number in x + yi or x + yj text format. * * Excel Function: * IMABS(complexNumber) * *
PHPExcel_Calculation_Engineering::IMAGINARY in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* IMAGINARY * * Returns the imaginary coefficient of a complex number in x + yi or x + yj text format. * * Excel Function: * IMAGINARY(complexNumber) * * @access public * @category Engineering Functions *
PHPExcel_Calculation_Engineering::IMARGUMENT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* IMARGUMENT * * Returns the argument theta of a complex number, i.e. the angle in radians from the real * axis to the representation of the number in polar coordinates. * * Excel Function: * IMARGUMENT(complexNumber) * *
PHPExcel_Calculation_Engineering::IMCONJUGATE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* IMCONJUGATE * * Returns the complex conjugate of a complex number in x + yi or x + yj text format. * * Excel Function: * IMCONJUGATE(complexNumber) * *
PHPExcel_Calculation_Engineering::IMCOS in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* IMCOS * * Returns the cosine of a complex number in x + yi or x + yj text format. * * Excel Function: * IMCOS(complexNumber) * *
PHPExcel_Calculation_Engineering::IMDIV in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* IMDIV * * Returns the quotient of two complex numbers in x + yi or x + yj text format. * * Excel Function: * IMDIV(complexDividend,complexDivisor) * *
PHPExcel_Calculation_Engineering::IMEXP in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* IMEXP * * Returns the exponential of a complex number in x + yi or x + yj text format. * * Excel Function: * IMEXP(complexNumber) * *
PHPExcel_Calculation_Engineering::IMLN in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* IMLN * * Returns the natural logarithm of a complex number in x + yi or x + yj text format. * * Excel Function: * IMLN(complexNumber) * *
PHPExcel_Calculation_Engineering::IMLOG10 in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* IMLOG10 * * Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format. * * Excel Function: * IMLOG10(complexNumber) * *
PHPExcel_Calculation_Engineering::IMLOG2 in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* IMLOG2 * * Returns the base-2 logarithm of a complex number in x + yi or x + yj text format. * * Excel Function: * IMLOG2(complexNumber) * *
PHPExcel_Calculation_Engineering::IMPOWER in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* IMPOWER * * Returns a complex number in x + yi or x + yj text format raised to a power. * * Excel Function: * IMPOWER(complexNumber,realNumber) * *
PHPExcel_Calculation_Engineering::IMREAL in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* IMREAL * * Returns the real coefficient of a complex number in x + yi or x + yj text format. * * Excel Function: * IMREAL(complexNumber) * * @access public * @category Engineering Functions *
PHPExcel_Calculation_Engineering::IMSIN in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* IMSIN * * Returns the sine of a complex number in x + yi or x + yj text format. * * Excel Function: * IMSIN(complexNumber) * *
PHPExcel_Calculation_Engineering::IMSQRT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* IMSQRT * * Returns the square root of a complex number in x + yi or x + yj text format. * * Excel Function: * IMSQRT(complexNumber) * *
PHPExcel_Calculation_Engineering::IMSUB in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* IMSUB * * Returns the difference of two complex numbers in x + yi or x + yj text format. * * Excel Function: * IMSUB(complexNumber1,complexNumber2) * *
PHPExcel_Calculation_Engineering::OCTTOBIN in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* OCTTOBIN * * Return an octal value as binary. * * Excel Function: * OCT2BIN(x[,places]) * * @access public * @category Engineering Functions *
PHPExcel_Calculation_Engineering::OCTTODEC in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* OCTTODEC * * Return an octal value as decimal. * * Excel Function: * OCT2DEC(x) * * @access public * @category Engineering Functions *
PHPExcel_Calculation_Engineering::OCTTOHEX in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php
* OCTTOHEX * * Return an octal value as hex. * * Excel Function: * OCT2HEX(x[,places]) * * @access public * @category Engineering Functions *
PHPExcel_Calculation_Financial::ACCRINT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* ACCRINT * * Returns the accrued interest for a security that pays periodic interest. * * Excel Function: * ACCRINT(issue,firstinterest,settlement,rate,par,frequency[,basis]) * * @access public * @category Financial Functions *
PHPExcel_Calculation_Financial::ACCRINTM in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* ACCRINTM * * Returns the accrued interest for a security that pays interest at maturity. * * Excel Function: * ACCRINTM(issue,settlement,rate[,par[,basis]]) * * @access public * @category Financial Functions *
PHPExcel_Calculation_Financial::AMORDEGRC in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* AMORDEGRC * * Returns the depreciation for each accounting period. * This function is provided for the French accounting system. If an asset is purchased in * the middle of the accounting period, the prorated depreciation is taken into…
PHPExcel_Calculation_Financial::AMORLINC in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* AMORLINC * * Returns the depreciation for each accounting period. * This function is provided for the French accounting system. If an asset is purchased in * the middle of the accounting period, the prorated depreciation is taken into…
PHPExcel_Calculation_Financial::COUPDAYBS in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* COUPDAYBS * * Returns the number of days from the beginning of the coupon period to the settlement date. * * Excel Function: * COUPDAYBS(settlement,maturity,frequency[,basis]) * * @access public * @category Financial Functions *
PHPExcel_Calculation_Financial::COUPDAYS in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* COUPDAYS * * Returns the number of days in the coupon period that contains the settlement date. * * Excel Function: * COUPDAYS(settlement,maturity,frequency[,basis]) * * @access public * @category Financial Functions *
PHPExcel_Calculation_Financial::COUPDAYSNC in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* COUPDAYSNC * * Returns the number of days from the settlement date to the next coupon date. * * Excel Function: * COUPDAYSNC(settlement,maturity,frequency[,basis]) * * @access public * @category Financial Functions *
PHPExcel_Calculation_Financial::COUPNCD in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* COUPNCD * * Returns the next coupon date after the settlement date. * * Excel Function: * COUPNCD(settlement,maturity,frequency[,basis]) * * @access public * @category Financial Functions *
PHPExcel_Calculation_Financial::COUPNUM in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* COUPNUM * * Returns the number of coupons payable between the settlement date and maturity date, * rounded up to the nearest whole coupon. * * Excel Function: * COUPNUM(settlement,maturity,frequency[,basis]) * * @access public *…
PHPExcel_Calculation_Financial::COUPPCD in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* COUPPCD * * Returns the previous coupon date before the settlement date. * * Excel Function: * COUPPCD(settlement,maturity,frequency[,basis]) * * @access public * @category Financial Functions *
PHPExcel_Calculation_Financial::CUMIPMT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* CUMIPMT * * Returns the cumulative interest paid on a loan between the start and end periods. * * Excel Function: * CUMIPMT(rate,nper,pv,start,end[,type]) * * @access public * @category Financial Functions *
PHPExcel_Calculation_Financial::CUMPRINC in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* CUMPRINC * * Returns the cumulative principal paid on a loan between the start and end periods. * * Excel Function: * CUMPRINC(rate,nper,pv,start,end[,type]) * * @access public * @category Financial Functions *
PHPExcel_Calculation_Financial::DB in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* DB * * Returns the depreciation of an asset for a specified period using the * fixed-declining balance method. * This form of depreciation is used if you want to get a higher depreciation value * at the beginning of the depreciation (as…
PHPExcel_Calculation_Financial::DDB in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* DDB * * Returns the depreciation of an asset for a specified period using the * double-declining balance method or some other method you specify. * * Excel Function: * DDB(cost,salvage,life,period[,factor]) * * @access public *…
PHPExcel_Calculation_Financial::DISC in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* DISC * * Returns the discount rate for a security. * * Excel Function: * DISC(settlement,maturity,price,redemption[,basis]) * * @access public * @category Financial Functions *
PHPExcel_Calculation_Financial::DOLLARDE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* DOLLARDE * * Converts a dollar price expressed as an integer part and a fraction * part into a dollar price expressed as a decimal number. * Fractional dollar numbers are sometimes used for security prices. * * Excel Function: …
PHPExcel_Calculation_Financial::DOLLARFR in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* DOLLARFR * * Converts a dollar price expressed as a decimal number into a dollar price * expressed as a fraction. * Fractional dollar numbers are sometimes used for security prices. * * Excel Function: …
PHPExcel_Calculation_Financial::EFFECT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* EFFECT * * Returns the effective interest rate given the nominal rate and the number of * compounding payments per year. * * Excel Function: * EFFECT(nominal_rate,npery) * * @access public * @category Financial Functions *
PHPExcel_Calculation_Financial::FV in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* FV * * Returns the Future Value of a cash flow with constant payments and interest rate (annuities). * * Excel Function: * FV(rate,nper,pmt[,pv[,type]]) * * @access public * @category Financial Functions *
PHPExcel_Calculation_Financial::FVSCHEDULE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* FVSCHEDULE * * Returns the future value of an initial principal after applying a series of compound interest rates. * Use FVSCHEDULE to calculate the future value of an investment with a variable or adjustable rate. * * Excel Function: …
PHPExcel_Calculation_Financial::INTRATE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* INTRATE * * Returns the interest rate for a fully invested security. * * Excel Function: * INTRATE(settlement,maturity,investment,redemption[,basis]) * *
PHPExcel_Calculation_Financial::IPMT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* IPMT * * Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate. * * Excel Function: * IPMT(rate,per,nper,pv[,fv][,type]) * *
PHPExcel_Calculation_Financial::IRR in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* IRR * * Returns the internal rate of return for a series of cash flows represented by the numbers in values. * These cash flows do not have to be even, as they would be for an annuity. However, the cash flows must occur * at regular…
PHPExcel_Calculation_Financial::MIRR in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* MIRR * * Returns the modified internal rate of return for a series of periodic cash flows. MIRR considers both * the cost of the investment and the interest received on reinvestment of cash. * * Excel Function: …
PHPExcel_Calculation_Financial::NOMINAL in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* NOMINAL * * Returns the nominal interest rate given the effective rate and the number of compounding payments per year. * *
PHPExcel_Calculation_Financial::NPER in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* NPER * * Returns the number of periods for a cash flow with constant periodic payments (annuities), and interest rate. * *
PHPExcel_Calculation_Financial::PMT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* PMT * * Returns the constant payment (annuity) for a cash flow with a constant interest rate. * *
PHPExcel_Calculation_Financial::PPMT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* PPMT * * Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate. * *
PHPExcel_Calculation_Financial::PRICE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
PHPExcel_Calculation_Financial::PRICEDISC in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* PRICEDISC * * Returns the price per $100 face value of a discounted security. * *
PHPExcel_Calculation_Financial::PRICEMAT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* PRICEMAT * * Returns the price per $100 face value of a security that pays interest at maturity. * *
PHPExcel_Calculation_Financial::PV in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* PV * * Returns the Present Value of a cash flow with constant payments and interest rate (annuities). * *
PHPExcel_Calculation_Financial::RATE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* RATE * * Returns the interest rate per period of an annuity. * RATE is calculated by iteration and can have zero or more solutions. * If the successive results of RATE do not converge to within 0.0000001 after 20 iterations, * RATE returns…
PHPExcel_Calculation_Financial::RECEIVED in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* RECEIVED * * Returns the price per $100 face value of a discounted security. * *
PHPExcel_Calculation_Financial::SLN in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* SLN * * Returns the straight-line depreciation of an asset for one period * *
PHPExcel_Calculation_Financial::SYD in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* SYD * * Returns the sum-of-years' digits depreciation of an asset for a specified period. * *
PHPExcel_Calculation_Financial::TBILLEQ in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* TBILLEQ * * Returns the bond-equivalent yield for a Treasury bill. * *
PHPExcel_Calculation_Financial::TBILLPRICE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* TBILLPRICE * * Returns the yield for a Treasury bill. * *
PHPExcel_Calculation_Financial::TBILLYIELD in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* TBILLYIELD * * Returns the yield for a Treasury bill. * *
PHPExcel_Calculation_Financial::XIRR in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
PHPExcel_Calculation_Financial::XNPV in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* XNPV * * Returns the net present value for a schedule of cash flows that is not necessarily periodic. * To calculate the net present value for a series of cash flows that is periodic, use the NPV function. * * Excel Function: …
PHPExcel_Calculation_Financial::YIELDDISC in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* YIELDDISC * * Returns the annual yield of a security that pays interest at maturity. * *
PHPExcel_Calculation_Financial::YIELDMAT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* YIELDMAT * * Returns the annual yield of a security that pays interest at maturity. * *
PHPExcel_Calculation_Functions::ERROR_TYPE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Functions.php
* ERROR_TYPE * *
PHPExcel_Calculation_Functions::IS_BLANK in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Functions.php
* IS_BLANK * *
PHPExcel_Calculation_Functions::IS_ERR in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Functions.php
* IS_ERR * *
PHPExcel_Calculation_Functions::IS_ERROR in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Functions.php
* IS_ERROR * *
PHPExcel_Calculation_Functions::IS_EVEN in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Functions.php
* IS_EVEN * *
PHPExcel_Calculation_Functions::IS_LOGICAL in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Functions.php
* IS_LOGICAL * *
PHPExcel_Calculation_Functions::IS_NA in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Functions.php
* IS_NA * *
PHPExcel_Calculation_Functions::IS_NUMBER in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Functions.php
* IS_NUMBER * *
PHPExcel_Calculation_Functions::IS_ODD in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Functions.php
* IS_ODD * *
PHPExcel_Calculation_Functions::IS_TEXT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Functions.php
* IS_TEXT * *
PHPExcel_Calculation_Functions::TYPE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Functions.php
* TYPE * * Returns a number that identifies the type of a value * *
PHPExcel_Calculation_Functions::_ifCondition in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Functions.php
PHPExcel_Calculation_Logical::IFERROR in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Logical.php
* IFERROR * * Excel Function: * =IFERROR(testValue,errorpart) * * @access public * @category Logical Functions *
PHPExcel_Calculation_Logical::NOT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Logical.php
* NOT * * Returns the boolean inverse of the argument. * * Excel Function: * =NOT(logical) * * The argument must evaluate to a logical value such as TRUE or FALSE * * Boolean arguments are treated as True or False as appropriate …
PHPExcel_Calculation_Logical::STATEMENT_IF in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Logical.php
* STATEMENT_IF * * Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. * * Excel Function: * =IF(condition[,returnIfTrue[,returnIfFalse]]) * * Condition is any value or expression…
PHPExcel_Calculation_LookupRef::CELL_ADDRESS in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/LookupRef.php
* CELL_ADDRESS * * Creates a cell address as text, given specified row and column numbers. * * Excel Function: * =ADDRESS(row, column, [relativity], [referenceStyle], [sheetText]) * *
PHPExcel_Calculation_LookupRef::HLOOKUP in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/LookupRef.php
HLOOKUP The HLOOKUP function searches for value in the top-most row of lookup_array and returns the value in the same column based on the index_number.
PHPExcel_Calculation_LookupRef::HYPERLINK in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/LookupRef.php
* HYPERLINK * * Excel Function: * =HYPERLINK(linkURL,displayName) * * @access public * @category Logical Functions *
PHPExcel_Calculation_LookupRef::INDIRECT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/LookupRef.php
* INDIRECT * * Returns the reference specified by a text string. * References are immediately evaluated to display their contents. * * Excel Function: * =INDIRECT(cellAddress) * * NOTE - INDIRECT() does not yet support the optional a1…
PHPExcel_Calculation_LookupRef::LOOKUP in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/LookupRef.php
* LOOKUP * The LOOKUP function searches for value either from a one-row or one-column range or from an array. *
PHPExcel_Calculation_LookupRef::MATCH in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/LookupRef.php
* MATCH * * The MATCH function searches for a specified item in a range of cells * * Excel Function: * =MATCH(lookup_value, lookup_array, [match_type]) * *
PHPExcel_Calculation_LookupRef::OFFSET in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/LookupRef.php
* OFFSET * * Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. * The reference that is returned can be a single cell or a range of cells. You can specify the number of rows and * the…
PHPExcel_Calculation_LookupRef::VLOOKUP in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/LookupRef.php
* VLOOKUP * The VLOOKUP function searches for value in the left-most column of lookup_array and returns the value in the same row based on the index_number. *
PHPExcel_Calculation_MathTrig::ATAN2 in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* ATAN2 * * This function calculates the arc tangent of the two variables x and y. It is similar to * calculating the arc tangent of y ÷ x, except that the signs of both arguments are used * to determine the quadrant of the result. * The…
PHPExcel_Calculation_MathTrig::CEILING in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* CEILING * * Returns number rounded up, away from zero, to the nearest multiple of significance. * For example, if you want to avoid using pennies in your prices and your product is * priced at $4.42, use the formula =CEILING(4.42,0.05) to…
PHPExcel_Calculation_MathTrig::COMBIN in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* COMBIN * * Returns the number of combinations for a given number of items. Use COMBIN to * determine the total possible number of groups for a given number of items. * * Excel Function: * COMBIN(numObjs,numInSet) * *…
PHPExcel_Calculation_MathTrig::EVEN in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* EVEN * * Returns number rounded up to the nearest even integer. * You can use this function for processing items that come in twos. For example, * a packing crate accepts rows of one or two items. The crate is full when * the number of…
PHPExcel_Calculation_MathTrig::FACT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* FACT * * Returns the factorial of a number. * The factorial of a number is equal to 1*2*3*...* number. * * Excel Function: * FACT(factVal) * * @access public * @category Mathematical and Trigonometric Functions *
PHPExcel_Calculation_MathTrig::FACTDOUBLE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* FACTDOUBLE * * Returns the double factorial of a number. * * Excel Function: * FACTDOUBLE(factVal) * * @access public * @category Mathematical and Trigonometric Functions *
PHPExcel_Calculation_MathTrig::FLOOR in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* FLOOR * * Rounds number down, toward zero, to the nearest multiple of significance. * * Excel Function: * FLOOR(number[,significance]) * * @access public * @category Mathematical and Trigonometric Functions *
PHPExcel_Calculation_MathTrig::INT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* INT * * Casts a floating point value to an integer * * Excel Function: * INT(number) * * @access public * @category Mathematical and Trigonometric Functions *
PHPExcel_Calculation_MathTrig::LOG_BASE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* LOG_BASE * * Returns the logarithm of a number to a specified base. The default base is 10. * * Excel Function: * LOG(number[,base]) * * @access public * @category Mathematical and Trigonometric Functions *
PHPExcel_Calculation_MathTrig::MOD in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* MOD * *
PHPExcel_Calculation_MathTrig::MROUND in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* MROUND * * Rounds a number to the nearest multiple of a specified value * *
PHPExcel_Calculation_MathTrig::ODD in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* ODD * * Returns number rounded up to the nearest odd integer. * *
PHPExcel_Calculation_MathTrig::POWER in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* POWER * * Computes x raised to the power y. * *
PHPExcel_Calculation_MathTrig::RAND in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* RAND * *
PHPExcel_Calculation_MathTrig::ROMAN in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
PHPExcel_Calculation_MathTrig::ROUNDDOWN in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* ROUNDDOWN * * Rounds a number down to a specified number of decimal places * *
PHPExcel_Calculation_MathTrig::ROUNDUP in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* ROUNDUP * * Rounds a number up to a specified number of decimal places * *
PHPExcel_Calculation_MathTrig::SIGN in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* SIGN * * Determines the sign of a number. Returns 1 if the number is positive, zero (0) * if the number is 0, and -1 if the number is negative. * *
PHPExcel_Calculation_MathTrig::SQRTPI in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* SQRTPI * * Returns the square root of (number * pi). * *
PHPExcel_Calculation_MathTrig::TRUNC in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* TRUNC * * Truncates value to the number of fractional digits by number_digits. * *
PHPExcel_Calculation_Statistical::BETADIST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* BETADIST * * Returns the beta distribution. * *
PHPExcel_Calculation_Statistical::BETAINV in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* BETAINV * * Returns the inverse of the beta distribution. * *
PHPExcel_Calculation_Statistical::BINOMDIST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* BINOMDIST * * Returns the individual term binomial distribution probability. Use BINOMDIST in problems with * a fixed number of tests or trials, when the outcomes of any trial are only success or failure, * when trials are independent, and…
PHPExcel_Calculation_Statistical::CHIDIST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* CHIDIST * * Returns the one-tailed probability of the chi-squared distribution. * *
PHPExcel_Calculation_Statistical::CHIINV in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* CHIINV * * Returns the one-tailed probability of the chi-squared distribution. * *
PHPExcel_Calculation_Statistical::CONFIDENCE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* CONFIDENCE * * Returns the confidence interval for a population mean * *
PHPExcel_Calculation_Statistical::CRITBINOM in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* CRITBINOM * * Returns the smallest value for which the cumulative binomial distribution is greater * than or equal to a criterion value * * See http://support.microsoft.com/kb/828117/ for details of the algorithm used * *
PHPExcel_Calculation_Statistical::EXPONDIST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* EXPONDIST * * Returns the exponential distribution. Use EXPONDIST to model the time between events, * such as how long an automated bank teller takes to deliver cash. For example, you can * use EXPONDIST to determine the probability that…
PHPExcel_Calculation_Statistical::FISHER in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* FISHER * * Returns the Fisher transformation at x. This transformation produces a function that * is normally distributed rather than skewed. Use this function to perform hypothesis * testing on the correlation coefficient. * *
PHPExcel_Calculation_Statistical::FISHERINV in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* FISHERINV * * Returns the inverse of the Fisher transformation. Use this transformation when * analyzing correlations between ranges or arrays of data. If y = FISHER(x), then * FISHERINV(y) = x. * *
PHPExcel_Calculation_Statistical::FORECAST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* FORECAST * * Calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value. * *
PHPExcel_Calculation_Statistical::GAMMADIST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* GAMMADIST * * Returns the gamma distribution. * *
PHPExcel_Calculation_Statistical::GAMMAINV in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* GAMMAINV * * Returns the inverse of the beta distribution. * *
PHPExcel_Calculation_Statistical::GAMMALN in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* GAMMALN * * Returns the natural logarithm of the gamma function. * *
PHPExcel_Calculation_Statistical::GROWTH in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* GROWTH * * Returns values along a predicted emponential trend * *
PHPExcel_Calculation_Statistical::HYPGEOMDIST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* HYPGEOMDIST * * Returns the hypergeometric distribution. HYPGEOMDIST returns the probability of a given number of * sample successes, given the sample size, population successes, and population size. * *
PHPExcel_Calculation_Statistical::LINEST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* LINEST * * Calculates the statistics for a line by using the "least squares" method to calculate a straight line that best fits your data, * and then returns an array that describes the line. * *
PHPExcel_Calculation_Statistical::LOGEST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* LOGEST * * Calculates an exponential curve that best fits the X and Y data series, * and then returns an array that describes the line. * *
PHPExcel_Calculation_Statistical::LOGINV in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* LOGINV * * Returns the inverse of the normal cumulative distribution * *
PHPExcel_Calculation_Statistical::LOGNORMDIST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* LOGNORMDIST * * Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed * with parameters mean and standard_dev. * *
PHPExcel_Calculation_Statistical::NEGBINOMDIST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* NEGBINOMDIST * * Returns the negative binomial distribution. NEGBINOMDIST returns the probability that * there will be number_f failures before the number_s-th success, when the constant * probability of a success is probability_s. This…
PHPExcel_Calculation_Statistical::NORMDIST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* NORMDIST * * Returns the normal distribution for the specified mean and standard deviation. This * function has a very wide range of applications in statistics, including hypothesis * testing. * *
PHPExcel_Calculation_Statistical::NORMINV in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* NORMINV * * Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation. * *
PHPExcel_Calculation_Statistical::NORMSDIST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* NORMSDIST * * Returns the standard normal cumulative distribution function. The distribution has * a mean of 0 (zero) and a standard deviation of one. Use this function in place of a * table of standard normal curve areas. * *
PHPExcel_Calculation_Statistical::PERCENTRANK in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* PERCENTRANK * * Returns the rank of a value in a data set as a percentage of the data set. * *
PHPExcel_Calculation_Statistical::PERMUT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* PERMUT * * Returns the number of permutations for a given number of objects that can be * selected from number objects. A permutation is any set or subset of objects or * events where internal order is significant. Permutations are…
PHPExcel_Calculation_Statistical::POISSON in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* POISSON * * Returns the Poisson distribution. A common application of the Poisson distribution * is predicting the number of events over a specific time, such as the number of * cars arriving at a toll plaza in 1 minute. * *
PHPExcel_Calculation_Statistical::RANK in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* RANK * * Returns the rank of a number in a list of numbers. * *
PHPExcel_Calculation_Statistical::STANDARDIZE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* STANDARDIZE * * Returns a normalized value from a distribution characterized by mean and standard_dev. * *
PHPExcel_Calculation_Statistical::TDIST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* TDIST * * Returns the probability of Student's T distribution. * *
PHPExcel_Calculation_Statistical::TINV in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* TINV * * Returns the one-tailed probability of the chi-squared distribution. * *
PHPExcel_Calculation_Statistical::TREND in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* TREND * * Returns values along a linear trend * *
PHPExcel_Calculation_Statistical::WEIBULL in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* WEIBULL * * Returns the Weibull distribution. Use this distribution in reliability * analysis, such as calculating a device's mean time to failure. * *
PHPExcel_Calculation_Statistical::ZTEST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* ZTEST * * Returns the Weibull distribution. Use this distribution in reliability * analysis, such as calculating a device's mean time to failure. * *
PHPExcel_Calculation_TextData::ASCIICODE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php
* ASCIICODE * *
PHPExcel_Calculation_TextData::CHARACTER in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php
* CHARACTER * *
PHPExcel_Calculation_TextData::DOLLAR in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php
* DOLLAR * * This function converts a number to text using currency format, with the decimals rounded to the specified place. * The format used is $#,##0.00_);($#,##0.00).. * *
PHPExcel_Calculation_TextData::FIXEDFORMAT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php
* FIXEDFORMAT * *
PHPExcel_Calculation_TextData::LEFT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php
* LEFT * *
PHPExcel_Calculation_TextData::LOWERCASE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php
* LOWERCASE * * Converts a string value to upper case. * *
PHPExcel_Calculation_TextData::MID in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php
* MID * *
PHPExcel_Calculation_TextData::PROPERCASE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php
* PROPERCASE * * Converts a string value to upper case. * *
PHPExcel_Calculation_TextData::REPLACE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php
* REPLACE * *
PHPExcel_Calculation_TextData::RETURNSTRING in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php
* RETURNSTRING * *
PHPExcel_Calculation_TextData::RIGHT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php
* RIGHT * *
PHPExcel_Calculation_TextData::SEARCHINSENSITIVE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php
* SEARCHINSENSITIVE * *
PHPExcel_Calculation_TextData::SEARCHSENSITIVE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php
* SEARCHSENSITIVE * *
PHPExcel_Calculation_TextData::STRINGLENGTH in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php
* STRINGLENGTH * *
PHPExcel_Calculation_TextData::SUBSTITUTE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php
* SUBSTITUTE * *
PHPExcel_Calculation_TextData::TEXTFORMAT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php
* TEXTFORMAT * *
PHPExcel_Calculation_TextData::TRIMNONPRINTABLE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php
* TRIMNONPRINTABLE * *
PHPExcel_Calculation_TextData::TRIMSPACES in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php
* TRIMSPACES * *
PHPExcel_Calculation_TextData::UPPERCASE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php
* UPPERCASE * * Converts a string value to upper case. * *
PHPExcel_Calculation_TextData::VALUE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php
* VALUE * *