tzeg6@T+ f,c>o⌻wRW/ ‹KgMzPny\F7nXoāKJg EB? Cez>^^$/fЁ1. ?c6ir;*{4N;@a-ɉ53j`?<:A0׶,)ՈGsB =- lN i|E2ZyCFaj^{X1Kg*cxP{7sr¶(CL dV\ |>Q0!|+703B |> ^6_P لwlӂU{Jx .]kBAĄ =>g.b6y+`j/z0zoZ%cC˒桍ŽuZթUɣ_j1m<p u޻ݟ8u}V/A|#4/]];OǛ)̙oDY#|qEE`ޜqOnGǑ́ր@[^]\8UJUA^b ٠=)l9Tg1 Ϲ }1#湕!7nF!`g\ +5Hd`;R0ƭYD,\; ?|:}.dj%9x\/A|#4/]];OǛ)̙uGOGٙ'H1EE9~j%R/A|#4/]];OǛ)̙E~kJ!͖ǘg=ݍ@H1 Y/ʟ(9h\І+2F{GNf $ؗe4pX'$9`FsL%ws)~;Qc01>Sgc?yx?h#/|Z]b"{aPdMv?_6׶p[|h7̥ =KN%բzɈGa8ƒKk'@wl)mļ%OFl@IV$ŵ"YE=if tnCҸ9ᗽU~FPO8Ș3>EX<?$U?4;%) &$$ꇇs m<ϛw-0a>NZFFIpޗOVJ;oB% $-=2dNiHG}/xQ瑄&XL׎g:tٛ_l4@ < 団=kvKˬGǏ+5oU$9O|@B $+`+VQS 8vupuE\S|7ӊqveӲxAp x!O mK RX o|i[6E5u=F9)ͺ.'+#ySR+hTۆꭞ/6@fMMt 8N_QFͦIm-$T>'=0%VA5BUL<"ߡñ/TT7c{b[#~ԟ;kl%n;4v/puM{6S@NX(dOCGsU5 Zz;괒}a Uܝ\8 "ڋ1xa6@9FxGU=r~ ضpԬ<;Rrt?ejtvUVļhTm>h..6ia^i8,. d]%^m }eAʥAr(@UYD0ڴje@e8o9#ZGR 389b.%TJ%ScV$>.Uͧ'үxak=XpSxtk׍* ` uxo~H6~贺 ߢ Y*jE?ޝ?*$;UdMߖRQMG\s'e m͏SuEJnb{,@\QsQQݶpeho>Zk-GȡV1P! vp#ZP왲;X7W៼[x?J_?rͷLX 'uUavyճ- yT2(! 7w2r~G QɐXL4,ҽ٨F?B/k!e I_roJR/M#j(6@9FxGU=r~ ]F)kTexnJЎ\现8 Ud\;Jm#+5e.c3B[cyK\U{ow9Nا1 u1hD]d_Czh?:wZ\BA19[?xNr[ޠr5hq_c?Z~YðЪh^ 3QM0Jxv%|qoX9H)t 8N_QFͦIm-$T>'=0%VA5BUL<"ߡñ/TT7c{b[#~ԟ]EXʜ]${F,nDw/¾bVs, JAMA For an m-by-n matrix A with m >= n, the singular value decomposition is an m-by-n orthogonal matrix U, an n-by-n diagonal matrix S, and an n-by-n orthogonal matrix V so that A = U*S*V'
  •  JAMA Pythagorean Theorem: a = 3 b = 4 r = sqrt(square(a) + square(b)) r = 5 r = sqrt(a^2 + b^2) without under/overflow
  •  PHPExcel
    • Back to top  

    PHPExcel_Calculation_Functions

    category PHPExcel
    package PHPExcel_Calculation
    copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)

     Methods

    DIV0

    DIV0() : string
    Static
    access public
    category Error Returns

    Returns

    string#Not Yet Implemented

    DUMMY

    DUMMY() : string
    Static
    access public
    category Error Returns

    Returns

    string#Not Yet Implemented

    ERROR_TYPE

    ERROR_TYPE(mixed $value) : boolean
    Static

    Parameters

    $value

    mixed

    Value to check

    Returns

    boolean

    IS_BLANK

    IS_BLANK(mixed $value) : boolean
    Static

    Parameters

    $value

    mixed

    Value to check

    Returns

    boolean

    IS_ERR

    IS_ERR(mixed $value) : boolean
    Static

    Parameters

    $value

    mixed

    Value to check

    Returns

    boolean

    IS_ERROR

    IS_ERROR(mixed $value) : boolean
    Static

    Parameters

    $value

    mixed

    Value to check

    Returns

    boolean

    IS_EVEN

    IS_EVEN(mixed $value) : boolean
    Static

    Parameters

    $value

    mixed

    Value to check

    Returns

    boolean

    IS_LOGICAL

    IS_LOGICAL(mixed $value) : boolean
    Static

    Parameters

    $value

    mixed

    Value to check

    Returns

    boolean

    IS_NA

    IS_NA(mixed $value) : boolean
    Static

    Parameters

    $value

    mixed

    Value to check

    Returns

    boolean

    IS_NONTEXT

    IS_NONTEXT(mixed $value) : boolean
    Static

    Parameters

    $value

    mixed

    Value to check

    Returns

    boolean

    IS_NUMBER

    IS_NUMBER(mixed $value) : boolean
    Static

    Parameters

    $value

    mixed

    Value to check

    Returns

    boolean

    IS_ODD

    IS_ODD(mixed $value) : boolean
    Static

    Parameters

    $value

    mixed

    Value to check

    Returns

    boolean

    IS_TEXT

    IS_TEXT(mixed $value) : boolean
    Static

    Parameters

    $value

    mixed

    Value to check

    Returns

    boolean

    N

    N(\value $value) : \number
    Static

    Returns a value converted to a number

    Parameters

    $value

    \value

    The value you want converted

    Returns

    \numberN converts values listed in the following table If value is or refers to N returns A number That number A date The serial number of that date TRUE 1 FALSE 0 An error value The error value Anything else 0

    NA

    NA() : string
    Static

    Excel Function: =NA()

    Returns the error value #N/A #N/A is the error value that means "no value is available."

    access public
    category Logical Functions

    Returns

    string#N/A!

    NAME

    NAME() : string
    Static

    Returns the error value #NAME?

    access public
    category Error Returns

    Returns

    string#NAME?

    NULL

    NULL() : string
    Static

    Returns the error value #NULL!

    access public
    category Error Returns

    Returns

    string#NULL!

    NaN

    NaN() : string
    Static

    Returns the error value #NUM!

    access public
    category Error Returns

    Returns

    string#NUM!

    REF

    REF() : string
    Static

    Returns the error value #REF!

    access public
    category Error Returns

    Returns

    string#REF!

    TYPE

    TYPE(\value $value) : \number
    Static

    Returns a number that identifies the type of a value

    Parameters

    $value

    \value

    The value you want tested

    Returns

    \numberN converts values listed in the following table If value is or refers to N returns A number 1 Text 2 Logical Value 4 An error value 16 Array or Matrix 64

    VALUE

    VALUE() : string
    Static

    Returns the error value #VALUE!

    access public
    category Error Returns

    Returns

    string#VALUE!

    VERSION

    VERSION() : string
    Static

    Returns

    stringVersion information

    _ifCondition() 

    _ifCondition($condition) 
    Static

    Parameters

    $condition

    Convert a multi-dimensional array to a simple 1-dimensional array

    flattenArray(array $array) : array
    Static

    Parameters

    $array

    array

    Array to be flattened

    Returns

    arrayFlattened array

    Convert a multi-dimensional array to a simple 1-dimensional array, but retain an element of indexing

    flattenArrayIndexed(array $array) : array
    Static

    Parameters

    $array

    array

    Array to be flattened

    Returns

    arrayFlattened array

    Convert an array to a single scalar value by extracting the first element

    flattenSingleValue(mixed $value) : mixed
    Static

    Parameters

    $value

    mixed

    Array or scalar value

    Returns

    mixed

    Return the current Compatibility Mode

    getCompatibilityMode() : string
    Static
    access public
    category Function Configuration

    Returns

    stringCompatibility Mode Possible Return values are: PHPExcel_Calculation_Functions::COMPATIBILITY_EXCEL 'Excel' PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC 'Gnumeric' PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE 'OpenOfficeCalc'

    Return the current Return Date Format for functions that return a date/time (Excel, PHP Serialized Numeric or PHP Object)

    getReturnDateType() : string
    Static
    access public
    category Function Configuration

    Returns

    stringReturn Date Format Possible Return values are: PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC 'P' PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT 'O' PHPExcel_Calculation_Functions::RETURNDATE_EXCEL 'E'

    isCellValue() 

    isCellValue($idx) 
    Static

    Parameters

    $idx

    isMatrixValue() 

    isMatrixValue($idx) 
    Static

    Parameters

    $idx

    isValue() 

    isValue($idx) 
    Static

    Parameters

    $idx

    Set the Compatibility Mode

    setCompatibilityMode(string $compatibilityMode) : boolean
    Static
    access public
    category Function Configuration

    Parameters

    $compatibilityMode

    string

    Compatibility Mode Permitted values are: PHPExcel_Calculation_Functions::COMPATIBILITY_EXCEL 'Excel' PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC 'Gnumeric' PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE 'OpenOfficeCalc'

    Returns

    boolean(Success or Failure)

    Set the Return Date Format used by functions that return a date/time (Excel, PHP Serialized Numeric or PHP Object)

    setReturnDateType(string $returnDateType) : boolean
    Static
    access public
    category Function Configuration

    Parameters

    $returnDateType

    string

    Return Date Format Permitted values are: PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC 'P' PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT 'O' PHPExcel_Calculation_Functions::RETURNDATE_EXCEL 'E'

    Returns

    booleanSuccess or failure

     Properties

     

    $ReturnDateType : string
    access private
     

    $_errorCodes : array
    access private
     

    $compatibilityMode : string
    access private

     Constants

     

    constants

    COMPATIBILITY_EXCEL 
     

    COMPATIBILITY_GNUMERIC

    COMPATIBILITY_GNUMERIC 
     

    COMPATIBILITY_OPENOFFICE

    COMPATIBILITY_OPENOFFICE 
     

    RETURNDATE_EXCEL

    RETURNDATE_EXCEL 
     

    RETURNDATE_PHP_NUMERIC

    RETURNDATE_PHP_NUMERIC 
     

    RETURNDATE_PHP_OBJECT

    RETURNDATE_PHP_OBJECT