23:16:46 List implemented functions Array ( [0] => ABS [1] => ACOS [2] => ACOSH [3] => ADDRESS [4] => AND [5] => ASIN [6] => ASINH [7] => ATAN [8] => ATAN2 [9] => ATANH [10] => AVEDEV [11] => AVERAGE [12] => AVERAGEA [13] => BESSELI [14] => BESSELJ [15] => BESSELK [16] => BESSELY [17] => BETADIST [18] => BETAINV [19] => BIN2DEC [20] => BIN2HEX [21] => BIN2OCT [22] => BINOMDIST [23] => CEILING [24] => CHAR [25] => CHIDIST [26] => CHIINV [27] => CHOOSE [28] => CLEAN [29] => CODE [30] => COLUMN [31] => COMBIN [32] => COMPLEX [33] => CONCATENATE [34] => CONFIDENCE [35] => COS [36] => COSH [37] => COUNT [38] => COUNTA [39] => COUNTBLANK [40] => CRITBINOM [41] => DATE [42] => DATEDIF [43] => DATEVALUE [44] => DAY [45] => DAYS360 [46] => DEC2BIN [47] => DEC2HEX [48] => DEC2OCT [49] => DEGREES [50] => DELTA [51] => DEVSQ [52] => EDATE [53] => EFFECT [54] => EOMONTH [55] => ERF [56] => ERFC [57] => EVEN [58] => EXP [59] => EXPONDIST [60] => FACT [61] => FACTDOUBLE [62] => FALSE [63] => FIND [64] => FISHER [65] => FISHERINV [66] => FLOOR [67] => FV [68] => GAMMADIST [69] => GAMMAINV [70] => GAMMALN [71] => GCD [72] => GEOMEAN [73] => GESTEP [74] => HARMEAN [75] => HEX2BIN [76] => HEX2DEC [77] => HEX2OCT [78] => HOUR [79] => HYPGEOMDIST [80] => IF [81] => IFERROR [82] => IMABS [83] => IMAGINARY [84] => IMARGUMENT [85] => IMCONJUGATE [86] => IMCOS [87] => IMDIV [88] => IMEXP [89] => IMLN [90] => IMLOG10 [91] => IMLOG2 [92] => IMPOWER [93] => IMPRODUCT [94] => IMREAL [95] => IMSIN [96] => IMSQRT [97] => IMSUB [98] => IMSUM [99] => INDEX [100] => INT [101] => ISBLANK [102] => ISERR [103] => ISERROR [104] => ISEVEN [105] => ISLOGICAL [106] => ISNA [107] => ISNONTEXT [108] => ISNUMBER [109] => ISODD [110] => ISTEXT [111] => KURT [112] => LARGE [113] => LCM [114] => LEFT [115] => LEN [116] => LN [117] => LOG [118] => LOG10 [119] => LOGINV [120] => LOGNORMDIST [121] => LOOKUP [122] => LOWER [123] => MATCH [124] => MAX [125] => MAXA [126] => MEDIAN [127] => MID [128] => MIN [129] => MINA [130] => MINUTE [131] => MOD [132] => MODE [133] => MONTH [134] => MROUND [135] => MULTINOMIAL [136] => NA [137] => NEGBINOMDIST [138] => NETWORKDAYS [139] => NOMINAL [140] => NORMDIST [141] => NORMINV [142] => NORMSDIST [143] => NORMSINV [144] => NOT [145] => NOW [146] => NPER [147] => NPV [148] => OCT2BIN [149] => OCT2DEC [150] => OCT2HEX [151] => ODD [152] => OFFSET [153] => OR [154] => PERCENTILE [155] => PERMUT [156] => PI [157] => PMT [158] => POISSON [159] => POWER [160] => PRODUCT [161] => PROPER [162] => PV [163] => QUARTILE [164] => QUOTIENT [165] => RADIANS [166] => RAND [167] => RANDBETWEEN [168] => REPT [169] => RIGHT [170] => ROUND [171] => ROUNDDOWN [172] => ROUNDUP [173] => ROW [174] => SEARCH [175] => SECOND [176] => SERIESSUM [177] => SIGN [178] => SIN [179] => SINH [180] => SKEW [181] => SLN [182] => SMALL [183] => SQRT [184] => SQRTPI [185] => STANDARDIZE [186] => STDEV [187] => STDEVA [188] => STDEVP [189] => STDEVPA [190] => SUBTOTAL [191] => SUM [192] => SUMSQ [193] => SYD [194] => T [195] => TAN [196] => TANH [197] => TDIST [198] => TIME [199] => TIMEVALUE [200] => TINV [201] => TODAY [202] => TRIM [203] => TRIMMEAN [204] => TRUE [205] => TRUNC [206] => UPPER [207] => VAR [208] => VARA [209] => VARP [210] => VARPA [211] => VERSION [212] => VLOOKUP [213] => WEEKDAY [214] => WEEKNUM [215] => WEIBULL [216] => WORKDAY [217] => YEAR [218] => YEARFRAC ) 23:16:46 Create new PHPExcel object 23:16:46 Add some data 23:16:46 Calculated data Value of B14 [=COUNT(B2:B12)]: 6 Value of B15 [=SUM(B2:B12)]: 42 Value of B16 [=MAX(B2:B12)]: 12 Value of B17 [=MIN(B2:B12)]: 2 Value of B18 [=AVERAGE(B2:B12)]: 7 Value of B19 [=MEDIAN(B2:B12)]: 7 Value of B20 [=MODE(B2:B12)]: #N/A Value of B22 [=COUNTA(B2:B12)]: 10 Value of B23 [=MAXA(B2:B12)]: 12 Value of B24 [=MINA(B2:B12)]: 0 Value of B26 [=STDEV(B2:B12)]: 3.74165738677394 Value of B27 [=STDEVA(B2:B12)]: 4.47337804249888 Value of B28 [=STDEVP(B2:B12)]: 3.41565025531987 Value of B29 [=STDEVPA(B2:B12)]: 4.24381903478459 Value of B31 [=DEVSQ(B2:B12)]: 70 Value of B32 [=VAR(B2:B12)]: 14 Value of B33 [=VARA(B2:B12)]: 20.0111111111111 Value of B34 [=VARP(B2:B12)]: 11.6666666666667 Value of B35 [=VARPA(B2:B12)]: 18.01 Value of C14 [=COUNT(C2:C12)]: 10 Value of C15 [=SUM(C2:C12)]: 30 Value of C16 [=MAX(C2:C12)]: 4 Value of C17 [=MIN(C2:C12)]: 1 Value of C18 [=AVERAGE(C2:C12)]: 3 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.05409255338946 Value of C27 [=STDEVA(C2:C12)]: 1.34839972492648 Value of C28 [=STDEVP(C2:C12)]: 1 Value of C29 [=STDEVPA(C2:C12)]: 1.28564869306645 Value of C31 [=DEVSQ(C2:C12)]: 10 Value of C32 [=VAR(C2:C12)]: 1.11111111111111 Value of C33 [=VARA(C2:C12)]: 1.81818181818182 Value of C34 [=VARP(C2:C12)]: 1 Value of C35 [=VARPA(C2:C12)]: 1.65289256198347 23:16:46 Peak memory usage: 2 MB 23:16:46 Done.