02:13:17 List implemented functions
Array
(
    [0] => ABS
    [1] => ACCRINT
    [2] => ACCRINTM
    [3] => ACOS
    [4] => ACOSH
    [5] => ADDRESS
    [6] => AMORDEGRC
    [7] => AMORLINC
    [8] => AND
    [9] => ASIN
    [10] => ASINH
    [11] => ATAN
    [12] => ATAN2
    [13] => ATANH
    [14] => AVEDEV
    [15] => AVERAGE
    [16] => AVERAGEA
    [17] => AVERAGEIF
    [18] => BESSELI
    [19] => BESSELJ
    [20] => BESSELK
    [21] => BESSELY
    [22] => BETADIST
    [23] => BETAINV
    [24] => BIN2DEC
    [25] => BIN2HEX
    [26] => BIN2OCT
    [27] => BINOMDIST
    [28] => CEILING
    [29] => CHAR
    [30] => CHIDIST
    [31] => CHIINV
    [32] => CHOOSE
    [33] => CLEAN
    [34] => CODE
    [35] => COLUMN
    [36] => COLUMNS
    [37] => COMBIN
    [38] => COMPLEX
    [39] => CONCATENATE
    [40] => CONFIDENCE
    [41] => CONVERT
    [42] => CORREL
    [43] => COS
    [44] => COSH
    [45] => COUNT
    [46] => COUNTA
    [47] => COUNTBLANK
    [48] => COUNTIF
    [49] => COUPDAYBS
    [50] => COUPDAYS
    [51] => COUPDAYSNC
    [52] => COUPNCD
    [53] => COUPNUM
    [54] => COUPPCD
    [55] => COVAR
    [56] => CRITBINOM
    [57] => CUMIPMT
    [58] => CUMPRINC
    [59] => DATE
    [60] => DATEDIF
    [61] => DATEVALUE
    [62] => DAY
    [63] => DAYS360
    [64] => DB
    [65] => DCOUNT
    [66] => DCOUNTA
    [67] => DDB
    [68] => DEC2BIN
    [69] => DEC2HEX
    [70] => DEC2OCT
    [71] => DEGREES
    [72] => DELTA
    [73] => DEVSQ
    [74] => DGET
    [75] => DISC
    [76] => DMAX
    [77] => DMIN
    [78] => DOLLAR
    [79] => DOLLARDE
    [80] => DOLLARFR
    [81] => DPRODUCT
    [82] => DSTDEV
    [83] => DSTDEVP
    [84] => DSUM
    [85] => DVAR
    [86] => DVARP
    [87] => EDATE
    [88] => EFFECT
    [89] => EOMONTH
    [90] => ERF
    [91] => ERFC
    [92] => ERROR.TYPE
    [93] => EVEN
    [94] => EXP
    [95] => EXPONDIST
    [96] => FACT
    [97] => FACTDOUBLE
    [98] => FALSE
    [99] => FIND
    [100] => FINDB
    [101] => FISHER
    [102] => FISHERINV
    [103] => FIXED
    [104] => FLOOR
    [105] => FORECAST
    [106] => FV
    [107] => FVSCHEDULE
    [108] => GAMMADIST
    [109] => GAMMAINV
    [110] => GAMMALN
    [111] => GCD
    [112] => GEOMEAN
    [113] => GESTEP
    [114] => GROWTH
    [115] => HARMEAN
    [116] => HEX2BIN
    [117] => HEX2DEC
    [118] => HEX2OCT
    [119] => HOUR
    [120] => HYPERLINK
    [121] => HYPGEOMDIST
    [122] => IF
    [123] => IFERROR
    [124] => IMABS
    [125] => IMAGINARY
    [126] => IMARGUMENT
    [127] => IMCONJUGATE
    [128] => IMCOS
    [129] => IMDIV
    [130] => IMEXP
    [131] => IMLN
    [132] => IMLOG10
    [133] => IMLOG2
    [134] => IMPOWER
    [135] => IMPRODUCT
    [136] => IMREAL
    [137] => IMSIN
    [138] => IMSQRT
    [139] => IMSUB
    [140] => IMSUM
    [141] => INDEX
    [142] => INDIRECT
    [143] => INT
    [144] => INTERCEPT
    [145] => INTRATE
    [146] => IPMT
    [147] => IRR
    [148] => ISBLANK
    [149] => ISERR
    [150] => ISERROR
    [151] => ISEVEN
    [152] => ISLOGICAL
    [153] => ISNA
    [154] => ISNONTEXT
    [155] => ISNUMBER
    [156] => ISODD
    [157] => ISPMT
    [158] => ISTEXT
    [159] => KURT
    [160] => LARGE
    [161] => LCM
    [162] => LEFT
    [163] => LEFTB
    [164] => LEN
    [165] => LENB
    [166] => LINEST
    [167] => LN
    [168] => LOG
    [169] => LOG10
    [170] => LOGEST
    [171] => LOGINV
    [172] => LOGNORMDIST
    [173] => LOOKUP
    [174] => LOWER
    [175] => MATCH
    [176] => MAX
    [177] => MAXA
    [178] => MAXIF
    [179] => MDETERM
    [180] => MEDIAN
    [181] => MID
    [182] => MIDB
    [183] => MIN
    [184] => MINA
    [185] => MINIF
    [186] => MINUTE
    [187] => MINVERSE
    [188] => MIRR
    [189] => MMULT
    [190] => MOD
    [191] => MODE
    [192] => MONTH
    [193] => MROUND
    [194] => MULTINOMIAL
    [195] => N
    [196] => NA
    [197] => NEGBINOMDIST
    [198] => NETWORKDAYS
    [199] => NOMINAL
    [200] => NORMDIST
    [201] => NORMINV
    [202] => NORMSDIST
    [203] => NORMSINV
    [204] => NOT
    [205] => NOW
    [206] => NPER
    [207] => NPV
    [208] => OCT2BIN
    [209] => OCT2DEC
    [210] => OCT2HEX
    [211] => ODD
    [212] => OFFSET
    [213] => OR
    [214] => PEARSON
    [215] => PERCENTILE
    [216] => PERCENTRANK
    [217] => PERMUT
    [218] => PI
    [219] => PMT
    [220] => POISSON
    [221] => POWER
    [222] => PPMT
    [223] => PRICE
    [224] => PRICEDISC
    [225] => PRICEMAT
    [226] => PRODUCT
    [227] => PROPER
    [228] => PV
    [229] => QUARTILE
    [230] => QUOTIENT
    [231] => RADIANS
    [232] => RAND
    [233] => RANDBETWEEN
    [234] => RANK
    [235] => RATE
    [236] => RECEIVED
    [237] => REPLACE
    [238] => REPLACEB
    [239] => REPT
    [240] => RIGHT
    [241] => RIGHTB
    [242] => ROMAN
    [243] => ROUND
    [244] => ROUNDDOWN
    [245] => ROUNDUP
    [246] => ROW
    [247] => ROWS
    [248] => RSQ
    [249] => SEARCH
    [250] => SEARCHB
    [251] => SECOND
    [252] => SERIESSUM
    [253] => SIGN
    [254] => SIN
    [255] => SINH
    [256] => SKEW
    [257] => SLN
    [258] => SLOPE
    [259] => SMALL
    [260] => SQRT
    [261] => SQRTPI
    [262] => STANDARDIZE
    [263] => STDEV
    [264] => STDEVA
    [265] => STDEVP
    [266] => STDEVPA
    [267] => STEYX
    [268] => SUBSTITUTE
    [269] => SUBTOTAL
    [270] => SUM
    [271] => SUMIF
    [272] => SUMPRODUCT
    [273] => SUMSQ
    [274] => SUMX2MY2
    [275] => SUMX2PY2
    [276] => SUMXMY2
    [277] => SYD
    [278] => T
    [279] => TAN
    [280] => TANH
    [281] => TBILLEQ
    [282] => TBILLPRICE
    [283] => TBILLYIELD
    [284] => TDIST
    [285] => TEXT
    [286] => TIME
    [287] => TIMEVALUE
    [288] => TINV
    [289] => TODAY
    [290] => TRANSPOSE
    [291] => TREND
    [292] => TRIM
    [293] => TRIMMEAN
    [294] => TRUE
    [295] => TRUNC
    [296] => TYPE
    [297] => UPPER
    [298] => VAR
    [299] => VARA
    [300] => VARP
    [301] => VARPA
    [302] => VERSION
    [303] => VLOOKUP
    [304] => WEEKDAY
    [305] => WEEKNUM
    [306] => WEIBULL
    [307] => WORKDAY
    [308] => XIRR
    [309] => XNPV
    [310] => YEAR
    [311] => YEARFRAC
    [312] => YIELDDISC
    [313] => YIELDMAT
    [314] => ZTEST
)
02:13:17 Create new PHPExcel object
02:13:17 Add some data
02:13:17 Calculated data
Value of B14 [=COUNT(B2:B12)]: 7
Value of B15 [=SUM(B2:B12)]: 64
Value of B16 [=MAX(B2:B12)]: 22
Value of B17 [=MIN(B2:B12)]: 2
Value of B18 [=AVERAGE(B2:B12)]: 9.1428571428571
Value of B19 [=MEDIAN(B2:B12)]: 8
Value of B20 [=MODE(B2:B12)]: #N/A
Value of B22 [=COUNTA(B2:B12)]: 10
Value of B23 [=MAXA(B2:B12)]: 22
Value of B24 [=MINA(B2:B12)]: 0
Value of B26 [=STDEV(B2:B12)]: 6.618876325293
Value of B27 [=STDEVA(B2:B12)]: 6.8839588093545
Value of B28 [=STDEVP(B2:B12)]: 6.1278887398649
Value of B29 [=STDEVPA(B2:B12)]: 6.5306967469023
Value of B31 [=DEVSQ(B2:B12)]: 262.85714285714
Value of B32 [=VAR(B2:B12)]: 47.444444444444
Value of B33 [=VARA(B2:B12)]: 47.388888888889
Value of B34 [=VARP(B2:B12)]: 42.172839506173
Value of B35 [=VARPA(B2:B12)]: 42.65
Value of C14 [=COUNT(C2:C12)]: 11
Value of C15 [=SUM(C2:C12)]: 30
Value of C16 [=MAX(C2:C12)]: 4
Value of C17 [=MIN(C2:C12)]: 0
Value of C18 [=AVERAGE(C2:C12)]: 2.7272727272727
Value of C19 [=MEDIAN(C2:C12)]: 3
Value of C20 [=MODE(C2:C12)]: 4
Value of C22 [=COUNTA(C2:C12)]: 11
Value of C23 [=MAXA(C2:C12)]: 4
Value of C24 [=MINA(C2:C12)]: 0
Value of C26 [=STDEV(C2:C12)]: 1.3483997249265
Value of C27 [=STDEVA(C2:C12)]: 1.3483997249265
Value of C28 [=STDEVP(C2:C12)]: 1.2856486930665
Value of C29 [=STDEVPA(C2:C12)]: 1.2856486930665
Value of C31 [=DEVSQ(C2:C12)]: 18.181818181818
Value of C32 [=VAR(C2:C12)]: 1.8181818181818
Value of C33 [=VARA(C2:C12)]: 1.8181818181818
Value of C34 [=VARP(C2:C12)]: 1.6528925619835
Value of C35 [=VARPA(C2:C12)]: 1.6528925619835
Value of B37 [=DATE(2007, 12, 21)]: 39437
Value of B38 [=DATEDIF( DATE(2007, 12, 21), DATE(2007, 12, 22), "D" )]: 1
Value of B39 [=DATEVALUE("01-Feb-2006 10:06 AM")]: 38749
Value of B40 [=DAY( DATE(2006, 1, 2) )]: 2
Value of B41 [=DAYS360( DATE(2002, 2, 3), DATE(2005, 5, 31) )]: 1198
02:13:17 Peak memory usage: 3.75 MB
02:13:17 Done.