# 13 Calculation

09:32:18 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] => 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] => ISFORMULA [155] => ISLOGICAL [156] => ISNA [157] => ISNONTEXT [158] => ISNUMBER [159] => ISODD [160] => ISPMT [161] => ISTEXT [162] => KURT [163] => LARGE [164] => LCM [165] => LEFT [166] => LEFTB [167] => LEN [168] => LENB [169] => LINEST [170] => LN [171] => LOG [172] => LOG10 [173] => LOGEST [174] => LOGINV [175] => LOGNORMDIST [176] => LOOKUP [177] => LOWER [178] => MATCH [179] => MAX [180] => MAXA [181] => MAXIF [182] => MDETERM [183] => MEDIAN [184] => MID [185] => MIDB [186] => MIN [187] => MINA [188] => MINIF [189] => MINUTE [190] => MINVERSE [191] => MIRR [192] => MMULT [193] => MOD [194] => MODE [195] => MODE.SNGL [196] => MONTH [197] => MROUND [198] => MULTINOMIAL [199] => N [200] => NA [201] => NEGBINOMDIST [202] => NETWORKDAYS [203] => NOMINAL [204] => NORMDIST [205] => NORMINV [206] => NORMSDIST [207] => NORMSINV [208] => NOT [209] => NOW [210] => NPER [211] => NPV [212] => OCT2BIN [213] => OCT2DEC [214] => OCT2HEX [215] => ODD [216] => OFFSET [217] => OR [218] => PEARSON [219] => PERCENTILE [220] => PERCENTRANK [221] => PERMUT [222] => PI [223] => PMT [224] => POISSON [225] => POWER [226] => PPMT [227] => PRICE [228] => PRICEDISC [229] => PRICEMAT [230] => PRODUCT [231] => PROPER [232] => PV [233] => QUARTILE [234] => QUOTIENT [235] => RADIANS [236] => RAND [237] => RANDBETWEEN [238] => RANK [239] => RATE [240] => RECEIVED [241] => REPLACE [242] => REPLACEB [243] => REPT [244] => RIGHT [245] => RIGHTB [246] => ROMAN [247] => ROUND [248] => ROUNDDOWN [249] => ROUNDUP [250] => ROW [251] => ROWS [252] => RSQ [253] => SEARCH [254] => SEARCHB [255] => SECOND [256] => SERIESSUM [257] => SIGN [258] => SIN [259] => SINH [260] => SKEW [261] => SLN [262] => SLOPE [263] => SMALL [264] => SQRT [265] => SQRTPI [266] => STANDARDIZE [267] => STDEV [268] => STDEV.S [269] => STDEV.P [270] => STDEVA [271] => STDEVP [272] => STDEVPA [273] => STEYX [274] => SUBSTITUTE [275] => SUBTOTAL [276] => SUM [277] => SUMIF [278] => SUMIFS [279] => SUMPRODUCT [280] => SUMSQ [281] => SUMX2MY2 [282] => SUMX2PY2 [283] => SUMXMY2 [284] => SYD [285] => T [286] => TAN [287] => TANH [288] => TBILLEQ [289] => TBILLPRICE [290] => TBILLYIELD [291] => TDIST [292] => TEXT [293] => TIME [294] => TIMEVALUE [295] => TINV [296] => TODAY [297] => TRANSPOSE [298] => TREND [299] => TRIM [300] => TRIMMEAN [301] => TRUE [302] => TRUNC [303] => TYPE [304] => UPPER [305] => VALUE [306] => VAR [307] => VARA [308] => VARP [309] => VARPA [310] => VLOOKUP [311] => WEEKDAY [312] => WEEKNUM [313] => WEIBULL [314] => WORKDAY [315] => XIRR [316] => XNPV [317] => YEAR [318] => YEARFRAC [319] => YIELDDISC [320] => YIELDMAT [321] => ZTEST ) 09:32:18 Create new Spreadsheet object
09:32:18 Add some data and formulas
09:32:18 Calculated data
09:32:18 Value of B14 [=COUNT(B2:B12)]: 7
09:32:18 Value of B15 [=SUM(B2:B12)]: 64
09:32:18 Value of B16 [=MAX(B2:B12)]: 22
09:32:18 Value of B17 [=MIN(B2:B12)]: 2
09:32:18 Value of B18 [=AVERAGE(B2:B12)]: 9.1428571428571
09:32:18 Value of B19 [=MEDIAN(B2:B12)]: 8
09:32:18 Value of B20 [=MODE(B2:B12)]: #N/A
09:32:18 Value of B22 [=COUNTA(B2:B12)]: 10
09:32:18 Value of B23 [=MAXA(B2:B12)]: 22
09:32:18 Value of B24 [=MINA(B2:B12)]: 0
09:32:18 Value of B26 [=STDEV(B2:B12)]: 6.618876325293
09:32:18 Value of B27 [=STDEVA(B2:B12)]: 6.8839588093545
09:32:18 Value of B28 [=STDEVP(B2:B12)]: 6.1278887398649
09:32:18 Value of B29 [=STDEVPA(B2:B12)]: 6.5306967469023
09:32:18 Value of B31 [=DEVSQ(B2:B12)]: 262.85714285714
09:32:18 Value of B32 [=VAR(B2:B12)]: 47.444444444444
09:32:18 Value of B33 [=VARA(B2:B12)]: 47.388888888889
09:32:18 Value of B34 [=VARP(B2:B12)]: 42.172839506173
09:32:18 Value of B35 [=VARPA(B2:B12)]: 42.65
09:32:18 Value of B37 [=DATE(2007, 12, 21)]: 39437
09:32:18 Value of B38 [=DATEDIF( DATE(2007, 12, 21), DATE(2007, 12, 22), "D" )]: 1
09:32:18 Value of B39 [=DATEVALUE("01-Feb-2006 10:06 AM")]: 38749
09:32:18 Value of B40 [=DAY( DATE(2006, 1, 2) )]: 2
09:32:18 Value of B41 [=DAYS360( DATE(2002, 2, 3), DATE(2005, 5, 31) )]: 1198
09:32:18 Value of C14 [=COUNT(C2:C12)]: 11
09:32:18 Value of C15 [=SUM(C2:C12)]: 30
09:32:18 Value of C16 [=MAX(C2:C12)]: 4
09:32:18 Value of C17 [=MIN(C2:C12)]: 0
09:32:18 Value of C18 [=AVERAGE(C2:C12)]: 2.7272727272727
09:32:18 Value of C19 [=MEDIAN(C2:C12)]: 3
09:32:18 Value of C20 [=MODE(C2:C12)]: 4
09:32:18 Value of C22 [=COUNTA(C2:C12)]: 11
09:32:18 Value of C23 [=MAXA(C2:C12)]: 4
09:32:18 Value of C24 [=MINA(C2:C12)]: 0
09:32:18 Value of C26 [=STDEV(C2:C12)]: 1.3483997249265
09:32:18 Value of C27 [=STDEVA(C2:C12)]: 1.3483997249265
09:32:18 Value of C28 [=STDEVP(C2:C12)]: 1.2856486930665
09:32:18 Value of C29 [=STDEVPA(C2:C12)]: 1.2856486930665
09:32:18 Value of C31 [=DEVSQ(C2:C12)]: 18.181818181818
09:32:18 Value of C32 [=VAR(C2:C12)]: 1.8181818181818
09:32:18 Value of C33 [=VARA(C2:C12)]: 1.8181818181818
09:32:18 Value of C34 [=VARP(C2:C12)]: 1.6528925619835
09:32:18 Value of C35 [=VARPA(C2:C12)]: 1.6528925619835
09:32:18 Value of D14 [=((D2 * D3) + D4) & " should be 10"]: 10 should be 10
09:32:18 Value of E14 [=PI()]: 3.1415926535898
09:32:18 Value of E15 [=RAND()]: 0.7703033
09:32:18 Value of E16 [=RANDBETWEEN(5, 10)]: 10
09:32:18 Value of F17 [=COUNT(B2:C12)]: 18
09:32:18 Value of F18 [=SUM(B2:C12)]: 94
09:32:18 Value of F19 [=MAX(B2:C12)]: 22
09:32:18 Value of F20 [=MIN(B2:C12)]: 0
09:32:18 Value of F21 [=AVERAGE(B2:C12)]: 5.2222222222222
09:32:18 Value of F22 [=MEDIAN(B2:C12)]: 4
09:32:18 Value of F23 [=MODE(B2:C12)]: 4
09:32:18 Write Xlsx format to `/tmp/phpspreadsheet/13_Calculation.xlsx` in 0.0059 seconds
09:32:18 Write Xls format to `/tmp/phpspreadsheet/13_Calculation.xls` in 0.0137 seconds
09:32:18 Peak memory usage: 2MB