18 Extendedcalculation

02:16:48 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 ) 02:16:48 Create new Spreadsheet object
02:16:48 Add some data
02:16:48 Calculated data
02:16:48 Value of B14 [=COUNT(B2:B12)]: 7
02:16:48 Peak memory usage: 5.25MB