18 Extendedcalculation

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