spreadsheet
typeScript/javascript spreadsheet parser, with formulas.
git clone https://git.vogt.world/spreadsheet.git
Log | Files | README.md
← All files
name: src/Formulas/AllFormulas.ts
-rw-r--r--
5878
  1import {
  2  ABS,
  3  ACOS,
  4  ACOSH,
  5  ACOTH,
  6  ASIN,
  7  ASINH,
  8  ATAN,
  9  ATAN2,
 10  ATANH,
 11  COT,
 12  COTH,
 13  COSH,
 14  COS,
 15  COUNTUNIQUE,
 16  EVEN,
 17  ERF,
 18  ERFC,
 19  INT,
 20  ISEVEN,
 21  ISODD,
 22  MOD,
 23  ODD,
 24  SIN,
 25  SINH,
 26  SUM,
 27  SQRT,
 28  SQRTPI,
 29  PI,
 30  POWER,
 31  LOG,
 32  LOG10,
 33  LN,
 34  TAN,
 35  TANH,
 36  ROUND,
 37  ROUNDDOWN,
 38  ROUNDUP,
 39  SUMPRODUCT,
 40  SUMIF,
 41  SUMSQ,
 42  SUMX2MY2,
 43  SUMX2PY2,
 44  FLOOR,
 45  IF,
 46  COUNTIF,
 47  COUNTIFS,
 48  CEILING,
 49  TRUNC,
 50  RADIANS,
 51  DEGREES,
 52  COMBIN,
 53  MULTIPLY,
 54  MINUS,
 55  RAND,
 56  RANDBETWEEN,
 57  SIGN,
 58  DIVIDE,
 59  EQ,
 60  GT,
 61  GTE,
 62  LT,
 63  LTE,
 64  NE,
 65  GCD,
 66  LCM,
 67  GAMMALN,
 68  PRODUCT,
 69  QUOTIENT,
 70  UPLUS,
 71  UMINUS,
 72  MROUND,
 73  FACTDOUBLE,
 74  UNARY_PERCENT,
 75  MULTINOMIAL,
 76  SERIESSUM,
 77  SUBTOTAL
 78} from "./Math";
 79import {
 80  FREQUENCY,
 81  GROWTH,
 82  LINEST
 83} from "./Range";
 84import {
 85  NA,
 86  ISTEXT,
 87  ISLOGICAL,
 88  ISNUMBER,
 89  ISNONTEXT,
 90  ISEMAIL,
 91  ISURL,
 92  N,
 93  ISREF,
 94  ERRORTYPE,
 95  ISBLANK,
 96  ISERR,
 97  ISERROR,
 98  ISNA,
 99  IFERROR,
100  TYPE,
101  COLUMN,
102  ROW,
103  ISFORMULA
104} from "./Info";
105import {
106  CHOOSE,
107  ADDRESS,
108  COLUMNS,
109  ROWS
110} from "./Lookup";
111import {
112  TO_DATE,
113  TO_DOLLARS,
114  TO_PERCENT,
115  TO_TEXT
116} from "./Convert";
117import {
118  AND,
119  EXACT,
120  TRUE,
121  FALSE,
122  NOT,
123  OR,
124  XOR
125} from "./Logical";
126import {
127  BIN2DEC,
128  BIN2HEX,
129  BIN2OCT,
130  DEC2BIN,
131  DEC2HEX,
132  DEC2OCT,
133  DELTA
134} from "./Engineering";
135import {
136  ACCRINT,
137  CUMPRINC,
138  CUMIPMT,
139  DB,
140  DDB,
141  DOLLAR,
142  DOLLARDE,
143  DOLLARFR,
144  EFFECT,
145  SYD,
146  SLN,
147  NPV,
148  NPER,
149  NOMINAL,
150  MIRR,
151  IRR,
152  IPMT,
153  FV,
154  PPMT,
155  FVSCHEDULE,
156  PV,
157  RATE
158} from "./Financial";
159import {
160  AVERAGE,
161  AVERAGEA,
162  AVERAGEIF,
163  AVEDEV,
164  CORREL,
165  COUNT,
166  COUNTA,
167  PEARSON,
168  MEDIAN,
169  DEVSQ,
170  EXPONDIST,
171  FDIST$LEFTTAILED,
172  FINV,
173  FISHER,
174  FISHERINV,
175  MAX,
176  MAXA,
177  MIN,
178  MINA,
179  QUARTILE,
180  PERCENTILE,
181  STDEV,
182  STDEVA,
183  STDEVP,
184  STDEVPA,
185  TRIMMEAN,
186  SLOPE,
187  STANDARDIZE,
188  SMALL,
189  LARGE,
190  KURT,
191  INTERCEPT,
192  FORECAST,
193  POISSON,
194  PERCENTRANK,
195  PERCENTRANK$EXC,
196  NORMSINV,
197  NORMSDIST,
198  NORMDIST,
199  NORMINV,
200  NEGBINOMDIST,
201  GEOMEAN,
202  HARMEAN,
203  CONFIDENCE,
204  BINOMDIST,
205  COVAR,
206  WEIBULL,
207  VARPA,
208  VARP,
209  VARA,
210  VAR,
211  PERMUT,
212  RSQ,
213  SKEW,
214  STEYX,
215  PROB,
216  MODE,
217  RANK,
218  RANK$AVG,
219  RANK$EQ,
220  LOGNORMDIST,
221  TDIST,
222  HYPGEOMDIST,
223  ZTEST
224} from "./Statistical";
225import {
226  ARABIC,
227  CHAR,
228  CODE,
229  SPLIT,
230  CONCATENATE,
231  CONVERT,
232  TRIM,
233  LOWER,
234  UPPER,
235  T,
236  ROMAN,
237  TEXT,
238  FIND,
239  JOIN,
240  LEN,
241  LEFT,
242  RIGHT,
243  SEARCH,
244  REPT,
245  VALUE,
246  CLEAN,
247  MID,
248  PROPER,
249  REPLACE,
250  SUBSTITUTE
251} from "./Text"
252import {
253  DATE,
254  DATEVALUE,
255  DATEDIF,
256  DAYS,
257  DAY,
258  DAYS360,
259  EDATE,
260  EOMONTH,
261  MONTH,
262  YEAR,
263  WEEKDAY,
264  WEEKNUM,
265  YEARFRAC,
266  TIMEVALUE,
267  HOUR,
268  MINUTE,
269  SECOND,
270  NETWORKDAYS,
271  NETWORKDAYS$INTL,
272  NOW,
273  TODAY,
274  TIME,
275  WORKDAY,
276  WORKDAY$INTL
277} from "./Date"
278
279// Using alias to bind dot-notation function names.
280const __COMPLEX = {
281  "F.DIST": FDIST$LEFTTAILED,
282  "NETWORKDAYS.INTL": NETWORKDAYS$INTL,
283  "WORKDAY.INTL": WORKDAY$INTL,
284  "POISSON.DIST": POISSON,
285  "PERCENTRANK.INC": PERCENTRANK,
286  "PERCENTRANK.EXC": PERCENTRANK$EXC,
287  "ERROR.TYPE": ERRORTYPE,
288  "RANK.AVG": RANK$AVG,
289  "RANK.EQ": RANK$EQ
290};
291
292const __TRY_CATCH_FORMULAS : Object = {
293  "ERROR.TYPE": ERRORTYPE,
294  "ERRORTYPE": ERRORTYPE,
295  "ISERR": ISERR,
296  "ISERROR": ISERROR,
297  "ISNA": ISNA,
298  "IFERROR": IFERROR
299};
300
301export {
302  __COMPLEX,
303  __TRY_CATCH_FORMULAS,
304
305  ABS,
306  ACOS,
307  ACCRINT,
308  ACOSH,
309  ACOTH,
310  AND,
311  ARABIC,
312  ASIN,
313  ASINH,
314  ATAN,
315  ATAN2,
316  ATANH,
317  AVEDEV,
318  AVERAGE,
319  AVERAGEA,
320  AVERAGEIF,
321  BIN2DEC,
322  BIN2HEX,
323  BIN2OCT,
324  CEILING,
325  CHAR,
326  CODE,
327  COMBIN,
328  CONCATENATE,
329  CONVERT,
330  CORREL,
331  PEARSON,
332  COS,
333  PI,
334  COSH,
335  COT,
336  COTH,
337  COUNT,
338  COUNTA,
339  COUNTIF,
340  COUNTIFS,
341  COUNTUNIQUE,
342  CUMIPMT,
343  CUMPRINC,
344  DATE,
345  DATEVALUE,
346  DAY,
347  DAYS,
348  DAYS360,
349  DB,
350  DDB,
351  DEC2BIN,
352  DEC2HEX,
353  DEC2OCT,
354  DEGREES,
355  DELTA,
356  DEVSQ,
357  DOLLAR,
358  DOLLARDE,
359  DOLLARFR,
360  EDATE,
361  EFFECT,
362  EOMONTH,
363  ERF,
364  ERFC,
365  EVEN,
366  EXACT,
367  EXPONDIST,
368  FALSE,
369  FINV,
370  FISHER,
371  FISHERINV,
372  FLOOR,
373  IF,
374  INT,
375  ISEVEN,
376  ISODD,
377  LN,
378  LOG,
379  LOG10,
380  MAX,
381  MAXA,
382  MEDIAN,
383  MIN,
384  MINA,
385  MOD,
386  TRUE,
387  NOT,
388  ODD,
389  OR,
390  POWER,
391  ROUND,
392  ROUNDDOWN,
393  ROUNDUP,
394  SIN,
395  SINH,
396  SPLIT,
397  SQRT,
398  SQRTPI,
399  SUM,
400  SUMIF,
401  SUMPRODUCT,
402  SUMSQ,
403  SUMX2MY2,
404  SUMX2PY2,
405  TAN,
406  TANH,
407  TRUNC,
408  XOR,
409  YEARFRAC,
410  RADIANS,
411  MONTH,
412  YEAR,
413  WEEKDAY,
414  WEEKNUM,
415  DATEDIF,
416  TIMEVALUE,
417  HOUR,
418  MINUTE,
419  SECOND,
420  NETWORKDAYS,
421  NETWORKDAYS$INTL,
422  NOW,
423  TODAY,
424  TIME,
425  WORKDAY,
426  WORKDAY$INTL,
427  MULTIPLY,
428  MINUS,
429  RAND,
430  RANDBETWEEN,
431  SIGN,
432  DIVIDE,
433  EQ,
434  GT,
435  GTE,
436  LT,
437  LTE,
438  NE,
439  NA,
440  CHOOSE,
441  GCD,
442  TRIM,
443  LCM,
444  GAMMALN,
445  QUARTILE,
446  PERCENTILE,
447  PRODUCT,
448  QUOTIENT,
449  UPLUS,
450  UMINUS,
451  STDEV,
452  STDEVA,
453  STDEVP,
454  STDEVPA,
455  ISTEXT,
456  ISLOGICAL,
457  ISNUMBER,
458  ISNONTEXT,
459  MROUND,
460  FACTDOUBLE,
461  FREQUENCY,
462  GROWTH,
463  TRIMMEAN,
464  SLOPE,
465  LOWER,
466  UPPER,
467  STANDARDIZE,
468  SMALL,
469  LARGE,
470  KURT,
471  INTERCEPT,
472  FORECAST,
473  SYD,
474  SLN,
475  NPV,
476  NPER,
477  NOMINAL,
478  MIRR,
479  IRR,
480  IPMT,
481  FV,
482  ISEMAIL,
483  ISURL,
484  LINEST,
485  POISSON,
486  PERCENTRANK,
487  PERCENTRANK$EXC,
488  NORMSINV,
489  NORMSDIST,
490  NORMDIST,
491  NORMINV,
492  NEGBINOMDIST,
493  GEOMEAN,
494  HARMEAN,
495  CONFIDENCE,
496  N,
497  UNARY_PERCENT,
498  MULTINOMIAL,
499  BINOMDIST,
500  COVAR,
501  ISREF,
502  ERRORTYPE,
503  ISBLANK,
504  ISERR,
505  ISERROR,
506  ISNA,
507  IFERROR,
508  TYPE,
509  COLUMN,
510  ROW,
511  T,
512  PPMT,
513  WEIBULL,
514  VARPA,
515  VARP,
516  VARA,
517  VAR,
518  PERMUT,
519  RSQ,
520  SKEW,
521  STEYX,
522  PROB,
523  MODE,
524  RANK,
525  RANK$AVG,
526  RANK$EQ,
527  LOGNORMDIST,
528  TDIST,
529  TO_DATE,
530  TO_DOLLARS,
531  TO_PERCENT,
532  TO_TEXT,
533  ISFORMULA,
534  ADDRESS,
535  COLUMNS,
536  ROWS,
537  SERIESSUM,
538  ROMAN,
539  TEXT,
540  FVSCHEDULE,
541  PV,
542  RATE,
543  SUBTOTAL,
544  HYPGEOMDIST,
545  ZTEST,
546  FIND,
547  JOIN,
548  LEN,
549  LEFT,
550  RIGHT,
551  SEARCH,
552  REPT,
553  VALUE,
554  CLEAN,
555  MID,
556  PROPER,
557  REPLACE,
558  SUBSTITUTE
559}