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}