17:36:42 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] => HLOOKUP
    [121] => HOUR
    [122] => HYPERLINK
    [123] => HYPGEOMDIST
    [124] => IF
    [125] => IFERROR
    [126] => IMABS
    [127] => IMAGINARY
    [128] => IMARGUMENT
    [129] => IMCONJUGATE
    [130] => IMCOS
    [131] => IMDIV
    [132] => IMEXP
    [133] => IMLN
    [134] => IMLOG10
    [135] => IMLOG2
    [136] => IMPOWER
    [137] => IMPRODUCT
    [138] => IMREAL
    [139] => IMSIN
    [140] => IMSQRT
    [141] => IMSUB
    [142] => IMSUM
    [143] => INDEX
    [144] => INDIRECT
    [145] => INT
    [146] => INTERCEPT
    [147] => INTRATE
    [148] => IPMT
    [149] => IRR
    [150] => ISBLANK
    [151] => ISERR
    [152] => ISERROR
    [153] => ISEVEN
    [154] => ISLOGICAL
    [155] => ISNA
    [156] => ISNONTEXT
    [157] => ISNUMBER
    [158] => ISODD
    [159] => ISPMT
    [160] => ISTEXT
    [161] => KURT
    [162] => LARGE
    [163] => LCM
    [164] => LEFT
    [165] => LEFTB
    [166] => LEN
    [167] => LENB
    [168] => LINEST
    [169] => LN
    [170] => LOG
    [171] => LOG10
    [172] => LOGEST
    [173] => LOGINV
    [174] => LOGNORMDIST
    [175] => LOOKUP
    [176] => LOWER
    [177] => MATCH
    [178] => MAX
    [179] => MAXA
    [180] => MAXIF
    [181] => MDETERM
    [182] => MEDIAN
    [183] => MID
    [184] => MIDB
    [185] => MIN
    [186] => MINA
    [187] => MINIF
    [188] => MINUTE
    [189] => MINVERSE
    [190] => MIRR
    [191] => MMULT
    [192] => MOD
    [193] => MODE
    [194] => MONTH
    [195] => MROUND
    [196] => MULTINOMIAL
    [197] => N
    [198] => NA
    [199] => NEGBINOMDIST
    [200] => NETWORKDAYS
    [201] => NOMINAL
    [202] => NORMDIST
    [203] => NORMINV
    [204] => NORMSDIST
    [205] => NORMSINV
    [206] => NOT
    [207] => NOW
    [208] => NPER
    [209] => NPV
    [210] => OCT2BIN
    [211] => OCT2DEC
    [212] => OCT2HEX
    [213] => ODD
    [214] => OFFSET
    [215] => OR
    [216] => PEARSON
    [217] => PERCENTILE
    [218] => PERCENTRANK
    [219] => PERMUT
    [220] => PI
    [221] => PMT
    [222] => POISSON
    [223] => POWER
    [224] => PPMT
    [225] => PRICE
    [226] => PRICEDISC
    [227] => PRICEMAT
    [228] => PRODUCT
    [229] => PROPER
    [230] => PV
    [231] => QUARTILE
    [232] => QUOTIENT
    [233] => RADIANS
    [234] => RAND
    [235] => RANDBETWEEN
    [236] => RANK
    [237] => RATE
    [238] => RECEIVED
    [239] => REPLACE
    [240] => REPLACEB
    [241] => REPT
    [242] => RIGHT
    [243] => RIGHTB
    [244] => ROMAN
    [245] => ROUND
    [246] => ROUNDDOWN
    [247] => ROUNDUP
    [248] => ROW
    [249] => ROWS
    [250] => RSQ
    [251] => SEARCH
    [252] => SEARCHB
    [253] => SECOND
    [254] => SERIESSUM
    [255] => SIGN
    [256] => SIN
    [257] => SINH
    [258] => SKEW
    [259] => SLN
    [260] => SLOPE
    [261] => SMALL
    [262] => SQRT
    [263] => SQRTPI
    [264] => STANDARDIZE
    [265] => STDEV
    [266] => STDEVA
    [267] => STDEVP
    [268] => STDEVPA
    [269] => STEYX
    [270] => SUBSTITUTE
    [271] => SUBTOTAL
    [272] => SUM
    [273] => SUMIF
    [274] => SUMIFS
    [275] => SUMPRODUCT
    [276] => SUMSQ
    [277] => SUMX2MY2
    [278] => SUMX2PY2
    [279] => SUMXMY2
    [280] => SYD
    [281] => T
    [282] => TAN
    [283] => TANH
    [284] => TBILLEQ
    [285] => TBILLPRICE
    [286] => TBILLYIELD
    [287] => TDIST
    [288] => TEXT
    [289] => TIME
    [290] => TIMEVALUE
    [291] => TINV
    [292] => TODAY
    [293] => TRANSPOSE
    [294] => TREND
    [295] => TRIM
    [296] => TRIMMEAN
    [297] => TRUE
    [298] => TRUNC
    [299] => TYPE
    [300] => UPPER
    [301] => VALUE
    [302] => VAR
    [303] => VARA
    [304] => VARP
    [305] => VARPA
    [306] => VERSION
    [307] => VLOOKUP
    [308] => WEEKDAY
    [309] => WEEKNUM
    [310] => WEIBULL
    [311] => WORKDAY
    [312] => XIRR
    [313] => XNPV
    [314] => YEAR
    [315] => YEARFRAC
    [316] => YIELDDISC
    [317] => YIELDMAT
    [318] => ZTEST
)
17:36:42 Create new PHPExcel object<br />17:36:42 Add some data and formulas<br />17:36:42 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.1428571428571<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.618876325293<br />Value of B27 [=STDEVA(B2:B12)]: 6.8839588093545<br />Value of B28 [=STDEVP(B2:B12)]: 6.1278887398649<br />Value of B29 [=STDEVPA(B2:B12)]: 6.5306967469023<br />Value of B31 [=DEVSQ(B2:B12)]: 262.85714285714<br />Value of B32 [=VAR(B2:B12)]: 47.444444444444<br />Value of B33 [=VARA(B2:B12)]: 47.388888888889<br />Value of B34 [=VARP(B2:B12)]: 42.172839506173<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.7272727272727<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.3483997249265<br />Value of C27 [=STDEVA(C2:C12)]: 1.3483997249265<br />Value of C28 [=STDEVP(C2:C12)]: 1.2856486930665<br />Value of C29 [=STDEVPA(C2:C12)]: 1.2856486930665<br />Value of C31 [=DEVSQ(C2:C12)]: 18.181818181818<br />Value of C32 [=VAR(C2:C12)]: 1.8181818181818<br />Value of C33 [=VARA(C2:C12)]: 1.8181818181818<br />Value of C34 [=VARP(C2:C12)]: 1.6528925619835<br />Value of C35 [=VARPA(C2:C12)]: 1.6528925619835<br />Value of D14 [=((D2 * D3) + D4) & " should be 10"]: 10 should be 10<br />Value of E14 [=PI()]: 3.1415926535898<br />Value of E15 [=RAND()]: 0.7703033<br />Value of E16 [=RANDBETWEEN(5, 10)]: 10<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.2222222222222<br />Value of F22 [=MEDIAN(B2:C12)]: 4<br />Value of F23 [=MODE(B2:C12)]: 4<br />17:36:42 Write to Excel2007 format<br />17:36:42 File written to 13calculation.xlsx<br />Call time to write Workbook was 0.0074 seconds<br />17:36:42 Current memory usage: 6 MB<br />17:36:42 Peak memory usage: 6 MB<br />17:36:42 Done writing file<br />File has been created in /home/admin2bannerworl/public_html/admin2.bannerworld.co.uk/vendor-old/phpoffice/phpexcel/Examples<br />