18 Extendedcalculation

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