18 Extendedcalculation

22:53:49 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] => SYD [316] => T [317] => TAN [318] => TANH [319] => TBILLEQ [320] => TBILLPRICE [321] => TBILLYIELD [322] => TDIST [323] => TEXT [324] => TEXTJOIN [325] => TIME [326] => TIMEVALUE [327] => TINV [328] => TODAY [329] => TRANSPOSE [330] => TREND [331] => TRIM [332] => TRIMMEAN [333] => TRUE [334] => TRUNC [335] => TYPE [336] => UNICHAR [337] => UNICODE [338] => UPPER [339] => VALUE [340] => VAR [341] => VAR.P [342] => VAR.S [343] => VARA [344] => VARP [345] => VARPA [346] => VLOOKUP [347] => WEEKDAY [348] => WEEKNUM [349] => WEIBULL [350] => WORKDAY [351] => XIRR [352] => XNPV [353] => XOR [354] => YEAR [355] => YEARFRAC [356] => YIELDDISC [357] => YIELDMAT [358] => ZTEST ) 22:53:49 Create new Spreadsheet object
22:53:49 Add some data
22:53:49 Calculated data
22:53:49 Value of B14 [=COUNT(B2:B12)]: 7
22:53:49 Peak memory usage: 5MB