18 Extendedcalculation

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