15:45:07 List implemented functions<br />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] => DAVERAGE
    [63] => DAY
    [64] => DAYS360
    [65] => DB
    [66] => DCOUNT
    [67] => DCOUNTA
    [68] => DDB
    [69] => DEC2BIN
    [70] => DEC2HEX
    [71] => DEC2OCT
    [72] => DEGREES
    [73] => DELTA
    [74] => DEVSQ
    [75] => DGET
    [76] => DISC
    [77] => DMAX
    [78] => DMIN
    [79] => DOLLAR
    [80] => DOLLARDE
    [81] => DOLLARFR
    [82] => DPRODUCT
    [83] => DSTDEV
    [84] => DSTDEVP
    [85] => DSUM
    [86] => DVAR
    [87] => DVARP
    [88] => EDATE
    [89] => EFFECT
    [90] => EOMONTH
    [91] => ERF
    [92] => ERFC
    [93] => ERROR.TYPE
    [94] => EVEN
    [95] => EXP
    [96] => EXPONDIST
    [97] => FACT
    [98] => FACTDOUBLE
    [99] => FALSE
    [100] => FIND
    [101] => FINDB
    [102] => FISHER
    [103] => FISHERINV
    [104] => FIXED
    [105] => FLOOR
    [106] => FORECAST
    [107] => FV
    [108] => FVSCHEDULE
    [109] => GAMMADIST
    [110] => GAMMAINV
    [111] => GAMMALN
    [112] => GCD
    [113] => GEOMEAN
    [114] => GESTEP
    [115] => GROWTH
    [116] => HARMEAN
    [117] => HEX2BIN
    [118] => HEX2DEC
    [119] => HEX2OCT
    [120] => HOUR
    [121] => HYPERLINK
    [122] => HYPGEOMDIST
    [123] => IF
    [124] => IFERROR
    [125] => IMABS
    [126] => IMAGINARY
    [127] => IMARGUMENT
    [128] => IMCONJUGATE
    [129] => IMCOS
    [130] => IMDIV
    [131] => IMEXP
    [132] => IMLN
    [133] => IMLOG10
    [134] => IMLOG2
    [135] => IMPOWER
    [136] => IMPRODUCT
    [137] => IMREAL
    [138] => IMSIN
    [139] => IMSQRT
    [140] => IMSUB
    [141] => IMSUM
    [142] => INDEX
    [143] => INDIRECT
    [144] => INT
    [145] => INTERCEPT
    [146] => INTRATE
    [147] => IPMT
    [148] => IRR
    [149] => ISBLANK
    [150] => ISERR
    [151] => ISERROR
    [152] => ISEVEN
    [153] => ISLOGICAL
    [154] => ISNA
    [155] => ISNONTEXT
    [156] => ISNUMBER
    [157] => ISODD
    [158] => ISPMT
    [159] => ISTEXT
    [160] => KURT
    [161] => LARGE
    [162] => LCM
    [163] => LEFT
    [164] => LEFTB
    [165] => LEN
    [166] => LENB
    [167] => LINEST
    [168] => LN
    [169] => LOG
    [170] => LOG10
    [171] => LOGEST
    [172] => LOGINV
    [173] => LOGNORMDIST
    [174] => LOOKUP
    [175] => LOWER
    [176] => MATCH
    [177] => MAX
    [178] => MAXA
    [179] => MAXIF
    [180] => MDETERM
    [181] => MEDIAN
    [182] => MID
    [183] => MIDB
    [184] => MIN
    [185] => MINA
    [186] => MINIF
    [187] => MINUTE
    [188] => MINVERSE
    [189] => MIRR
    [190] => MMULT
    [191] => MOD
    [192] => MODE
    [193] => MONTH
    [194] => MROUND
    [195] => MULTINOMIAL
    [196] => N
    [197] => NA
    [198] => NEGBINOMDIST
    [199] => NETWORKDAYS
    [200] => NOMINAL
    [201] => NORMDIST
    [202] => NORMINV
    [203] => NORMSDIST
    [204] => NORMSINV
    [205] => NOT
    [206] => NOW
    [207] => NPER
    [208] => NPV
    [209] => OCT2BIN
    [210] => OCT2DEC
    [211] => OCT2HEX
    [212] => ODD
    [213] => OFFSET
    [214] => OR
    [215] => PEARSON
    [216] => PERCENTILE
    [217] => PERCENTRANK
    [218] => PERMUT
    [219] => PI
    [220] => PMT
    [221] => POISSON
    [222] => POWER
    [223] => PPMT
    [224] => PRICE
    [225] => PRICEDISC
    [226] => PRICEMAT
    [227] => PRODUCT
    [228] => PROPER
    [229] => PV
    [230] => QUARTILE
    [231] => QUOTIENT
    [232] => RADIANS
    [233] => RAND
    [234] => RANDBETWEEN
    [235] => RANK
    [236] => RATE
    [237] => RECEIVED
    [238] => REPLACE
    [239] => REPLACEB
    [240] => REPT
    [241] => RIGHT
    [242] => RIGHTB
    [243] => ROMAN
    [244] => ROUND
    [245] => ROUNDDOWN
    [246] => ROUNDUP
    [247] => ROW
    [248] => ROWS
    [249] => RSQ
    [250] => SEARCH
    [251] => SEARCHB
    [252] => SECOND
    [253] => SERIESSUM
    [254] => SIGN
    [255] => SIN
    [256] => SINH
    [257] => SKEW
    [258] => SLN
    [259] => SLOPE
    [260] => SMALL
    [261] => SQRT
    [262] => SQRTPI
    [263] => STANDARDIZE
    [264] => STDEV
    [265] => STDEVA
    [266] => STDEVP
    [267] => STDEVPA
    [268] => STEYX
    [269] => SUBSTITUTE
    [270] => SUBTOTAL
    [271] => SUM
    [272] => SUMIF
    [273] => SUMPRODUCT
    [274] => SUMSQ
    [275] => SUMX2MY2
    [276] => SUMX2PY2
    [277] => SUMXMY2
    [278] => SYD
    [279] => T
    [280] => TAN
    [281] => TANH
    [282] => TBILLEQ
    [283] => TBILLPRICE
    [284] => TBILLYIELD
    [285] => TDIST
    [286] => TEXT
    [287] => TIME
    [288] => TIMEVALUE
    [289] => TINV
    [290] => TODAY
    [291] => TRANSPOSE
    [292] => TREND
    [293] => TRIM
    [294] => TRIMMEAN
    [295] => TRUE
    [296] => TRUNC
    [297] => TYPE
    [298] => UPPER
    [299] => VAR
    [300] => VARA
    [301] => VARP
    [302] => VARPA
    [303] => VERSION
    [304] => VLOOKUP
    [305] => WEEKDAY
    [306] => WEEKNUM
    [307] => WEIBULL
    [308] => WORKDAY
    [309] => XIRR
    [310] => XNPV
    [311] => YEAR
    [312] => YEARFRAC
    [313] => YIELDDISC
    [314] => YIELDMAT
    [315] => ZTEST
)
15:45:07 Create new PHPExcel object<br />15:45:07 Add some data and formulas<br />15:45:07 Calculated data<br />Value of B14 [=COUNT(B2:B12)]: 7<br />Value of B15 [=SUM(B2:B12)]: 64<br />Value of B16 [=MAX(B2:B12)]: 22<br />Value of B17 [=MIN(B2:B12)]: 2<br />Value of B18 [=AVERAGE(B2:B12)]: 9.142857142857142<br />Value of B19 [=MEDIAN(B2:B12)]: 8<br />Value of B20 [=MODE(B2:B12)]: #N/A<br />Value of B22 [=COUNTA(B2:B12)]: 10<br />Value of B23 [=MAXA(B2:B12)]: 22<br />Value of B24 [=MINA(B2:B12)]: 0<br />Value of B26 [=STDEV(B2:B12)]: 6.618876325292973<br />Value of B27 [=STDEVA(B2:B12)]: 6.883958809354461<br />Value of B28 [=STDEVP(B2:B12)]: 6.127888739864919<br />Value of B29 [=STDEVPA(B2:B12)]: 6.530696746902279<br />Value of B31 [=DEVSQ(B2:B12)]: 262.8571428571429<br />Value of B32 [=VAR(B2:B12)]: 47.44444444444444<br />Value of B33 [=VARA(B2:B12)]: 47.38888888888889<br />Value of B34 [=VARP(B2:B12)]: 42.17283950617284<br />Value of B35 [=VARPA(B2:B12)]: 42.65<br />Value of B37 [=DATE(2007, 12, 21)]: 39437<br />Value of B38 [=DATEDIF( DATE(2007, 12, 21), DATE(2007, 12, 22), "D" )]: 1<br />Value of B39 [=DATEVALUE("01-Feb-2006 10:06 AM")]: 38749<br />Value of B40 [=DAY( DATE(2006, 1, 2) )]: 2<br />Value of B41 [=DAYS360( DATE(2002, 2, 3), DATE(2005, 5, 31) )]: 1198<br />Value of C14 [=COUNT(C2:C12)]: 11<br />Value of C15 [=SUM(C2:C12)]: 30<br />Value of C16 [=MAX(C2:C12)]: 4<br />Value of C17 [=MIN(C2:C12)]: 0<br />Value of C18 [=AVERAGE(C2:C12)]: 2.727272727272727<br />Value of C19 [=MEDIAN(C2:C12)]: 3<br />Value of C20 [=MODE(C2:C12)]: 4<br />Value of C22 [=COUNTA(C2:C12)]: 11<br />Value of C23 [=MAXA(C2:C12)]: 4<br />Value of C24 [=MINA(C2:C12)]: 0<br />Value of C26 [=STDEV(C2:C12)]: 1.348399724926484<br />Value of C27 [=STDEVA(C2:C12)]: 1.348399724926484<br />Value of C28 [=STDEVP(C2:C12)]: 1.28564869306645<br />Value of C29 [=STDEVPA(C2:C12)]: 1.28564869306645<br />Value of C31 [=DEVSQ(C2:C12)]: 18.18181818181818<br />Value of C32 [=VAR(C2:C12)]: 1.818181818181818<br />Value of C33 [=VARA(C2:C12)]: 1.818181818181818<br />Value of C34 [=VARP(C2:C12)]: 1.652892561983471<br />Value of C35 [=VARPA(C2:C12)]: 1.652892561983471<br />Value of D14 [=((D2 * D3) + D4) & " should be 10"]: 10 should be 10<br />Value of E14 [=PI()]: 3.141592653589793<br />Value of E15 [=RAND()]: 0.8326405<br />Value of E16 [=RANDBETWEEN(5, 10)]: 8<br />Value of F17 [=COUNT(B2:C12)]: 18<br />Value of F18 [=SUM(B2:C12)]: 94<br />Value of F19 [=MAX(B2:C12)]: 22<br />Value of F20 [=MIN(B2:C12)]: 0<br />Value of F21 [=AVERAGE(B2:C12)]: 5.222222222222222<br />Value of F22 [=MEDIAN(B2:C12)]: 4<br />Value of F23 [=MODE(B2:C12)]: 4<br />15:45:07 Write to Excel2007 format<br />15:45:07 File written to 13calculation.xlsx<br />Call time to write Workbook was 0.0250 seconds<br />15:45:07 Current memory usage: 6.25 MB<br />15:45:07 Peak memory usage: 6.25 MB<br />15:45:07 Done writing file<br />File has been created in /home/diamebua/beta/releases/20140218040015/shared/vendor/phpoffice/phpexcel/Examples<br />