# 13 Calculation

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