spreadsheet
typeScript/javascript spreadsheet parser, with formulas.
git clone https://git.vogt.world/spreadsheet.git
Log | Files | README.md
← All files
name: dist/Formulas/AllFormulas.js
-rw-r--r--
9896
  1"use strict";
  2exports.__esModule = true;
  3var Math_1 = require("./Math");
  4exports.ABS = Math_1.ABS;
  5exports.ACOS = Math_1.ACOS;
  6exports.ACOSH = Math_1.ACOSH;
  7exports.ACOTH = Math_1.ACOTH;
  8exports.ASIN = Math_1.ASIN;
  9exports.ASINH = Math_1.ASINH;
 10exports.ATAN = Math_1.ATAN;
 11exports.ATAN2 = Math_1.ATAN2;
 12exports.ATANH = Math_1.ATANH;
 13exports.COT = Math_1.COT;
 14exports.COTH = Math_1.COTH;
 15exports.COSH = Math_1.COSH;
 16exports.COS = Math_1.COS;
 17exports.COUNTUNIQUE = Math_1.COUNTUNIQUE;
 18exports.EVEN = Math_1.EVEN;
 19exports.ERF = Math_1.ERF;
 20exports.ERFC = Math_1.ERFC;
 21exports.INT = Math_1.INT;
 22exports.ISEVEN = Math_1.ISEVEN;
 23exports.ISODD = Math_1.ISODD;
 24exports.MOD = Math_1.MOD;
 25exports.ODD = Math_1.ODD;
 26exports.SIN = Math_1.SIN;
 27exports.SINH = Math_1.SINH;
 28exports.SUM = Math_1.SUM;
 29exports.SQRT = Math_1.SQRT;
 30exports.SQRTPI = Math_1.SQRTPI;
 31exports.PI = Math_1.PI;
 32exports.POWER = Math_1.POWER;
 33exports.LOG = Math_1.LOG;
 34exports.LOG10 = Math_1.LOG10;
 35exports.LN = Math_1.LN;
 36exports.TAN = Math_1.TAN;
 37exports.TANH = Math_1.TANH;
 38exports.ROUND = Math_1.ROUND;
 39exports.ROUNDDOWN = Math_1.ROUNDDOWN;
 40exports.ROUNDUP = Math_1.ROUNDUP;
 41exports.SUMPRODUCT = Math_1.SUMPRODUCT;
 42exports.SUMIF = Math_1.SUMIF;
 43exports.SUMSQ = Math_1.SUMSQ;
 44exports.SUMX2MY2 = Math_1.SUMX2MY2;
 45exports.SUMX2PY2 = Math_1.SUMX2PY2;
 46exports.FLOOR = Math_1.FLOOR;
 47exports.IF = Math_1.IF;
 48exports.COUNTIF = Math_1.COUNTIF;
 49exports.COUNTIFS = Math_1.COUNTIFS;
 50exports.CEILING = Math_1.CEILING;
 51exports.TRUNC = Math_1.TRUNC;
 52exports.RADIANS = Math_1.RADIANS;
 53exports.DEGREES = Math_1.DEGREES;
 54exports.COMBIN = Math_1.COMBIN;
 55exports.MULTIPLY = Math_1.MULTIPLY;
 56exports.MINUS = Math_1.MINUS;
 57exports.RAND = Math_1.RAND;
 58exports.RANDBETWEEN = Math_1.RANDBETWEEN;
 59exports.SIGN = Math_1.SIGN;
 60exports.DIVIDE = Math_1.DIVIDE;
 61exports.EQ = Math_1.EQ;
 62exports.GT = Math_1.GT;
 63exports.GTE = Math_1.GTE;
 64exports.LT = Math_1.LT;
 65exports.LTE = Math_1.LTE;
 66exports.NE = Math_1.NE;
 67exports.GCD = Math_1.GCD;
 68exports.LCM = Math_1.LCM;
 69exports.GAMMALN = Math_1.GAMMALN;
 70exports.PRODUCT = Math_1.PRODUCT;
 71exports.QUOTIENT = Math_1.QUOTIENT;
 72exports.UPLUS = Math_1.UPLUS;
 73exports.UMINUS = Math_1.UMINUS;
 74exports.MROUND = Math_1.MROUND;
 75exports.FACTDOUBLE = Math_1.FACTDOUBLE;
 76exports.UNARY_PERCENT = Math_1.UNARY_PERCENT;
 77exports.MULTINOMIAL = Math_1.MULTINOMIAL;
 78exports.SERIESSUM = Math_1.SERIESSUM;
 79exports.SUBTOTAL = Math_1.SUBTOTAL;
 80var Range_1 = require("./Range");
 81exports.FREQUENCY = Range_1.FREQUENCY;
 82exports.GROWTH = Range_1.GROWTH;
 83exports.LINEST = Range_1.LINEST;
 84var Info_1 = require("./Info");
 85exports.NA = Info_1.NA;
 86exports.ISTEXT = Info_1.ISTEXT;
 87exports.ISLOGICAL = Info_1.ISLOGICAL;
 88exports.ISNUMBER = Info_1.ISNUMBER;
 89exports.ISNONTEXT = Info_1.ISNONTEXT;
 90exports.ISEMAIL = Info_1.ISEMAIL;
 91exports.ISURL = Info_1.ISURL;
 92exports.N = Info_1.N;
 93exports.ISREF = Info_1.ISREF;
 94exports.ERRORTYPE = Info_1.ERRORTYPE;
 95exports.ISBLANK = Info_1.ISBLANK;
 96exports.ISERR = Info_1.ISERR;
 97exports.ISERROR = Info_1.ISERROR;
 98exports.ISNA = Info_1.ISNA;
 99exports.IFERROR = Info_1.IFERROR;
100exports.TYPE = Info_1.TYPE;
101exports.COLUMN = Info_1.COLUMN;
102exports.ROW = Info_1.ROW;
103exports.ISFORMULA = Info_1.ISFORMULA;
104var Lookup_1 = require("./Lookup");
105exports.CHOOSE = Lookup_1.CHOOSE;
106exports.ADDRESS = Lookup_1.ADDRESS;
107exports.COLUMNS = Lookup_1.COLUMNS;
108exports.ROWS = Lookup_1.ROWS;
109var Convert_1 = require("./Convert");
110exports.TO_DATE = Convert_1.TO_DATE;
111exports.TO_DOLLARS = Convert_1.TO_DOLLARS;
112exports.TO_PERCENT = Convert_1.TO_PERCENT;
113exports.TO_TEXT = Convert_1.TO_TEXT;
114var Logical_1 = require("./Logical");
115exports.AND = Logical_1.AND;
116exports.EXACT = Logical_1.EXACT;
117exports.TRUE = Logical_1.TRUE;
118exports.FALSE = Logical_1.FALSE;
119exports.NOT = Logical_1.NOT;
120exports.OR = Logical_1.OR;
121exports.XOR = Logical_1.XOR;
122var Engineering_1 = require("./Engineering");
123exports.BIN2DEC = Engineering_1.BIN2DEC;
124exports.BIN2HEX = Engineering_1.BIN2HEX;
125exports.BIN2OCT = Engineering_1.BIN2OCT;
126exports.DEC2BIN = Engineering_1.DEC2BIN;
127exports.DEC2HEX = Engineering_1.DEC2HEX;
128exports.DEC2OCT = Engineering_1.DEC2OCT;
129exports.DELTA = Engineering_1.DELTA;
130var Financial_1 = require("./Financial");
131exports.ACCRINT = Financial_1.ACCRINT;
132exports.CUMPRINC = Financial_1.CUMPRINC;
133exports.CUMIPMT = Financial_1.CUMIPMT;
134exports.DB = Financial_1.DB;
135exports.DDB = Financial_1.DDB;
136exports.DOLLAR = Financial_1.DOLLAR;
137exports.DOLLARDE = Financial_1.DOLLARDE;
138exports.DOLLARFR = Financial_1.DOLLARFR;
139exports.EFFECT = Financial_1.EFFECT;
140exports.SYD = Financial_1.SYD;
141exports.SLN = Financial_1.SLN;
142exports.NPV = Financial_1.NPV;
143exports.NPER = Financial_1.NPER;
144exports.NOMINAL = Financial_1.NOMINAL;
145exports.MIRR = Financial_1.MIRR;
146exports.IRR = Financial_1.IRR;
147exports.IPMT = Financial_1.IPMT;
148exports.FV = Financial_1.FV;
149exports.PPMT = Financial_1.PPMT;
150exports.FVSCHEDULE = Financial_1.FVSCHEDULE;
151exports.PV = Financial_1.PV;
152exports.RATE = Financial_1.RATE;
153var Statistical_1 = require("./Statistical");
154exports.AVERAGE = Statistical_1.AVERAGE;
155exports.AVERAGEA = Statistical_1.AVERAGEA;
156exports.AVERAGEIF = Statistical_1.AVERAGEIF;
157exports.AVEDEV = Statistical_1.AVEDEV;
158exports.CORREL = Statistical_1.CORREL;
159exports.COUNT = Statistical_1.COUNT;
160exports.COUNTA = Statistical_1.COUNTA;
161exports.PEARSON = Statistical_1.PEARSON;
162exports.MEDIAN = Statistical_1.MEDIAN;
163exports.DEVSQ = Statistical_1.DEVSQ;
164exports.EXPONDIST = Statistical_1.EXPONDIST;
165exports.FINV = Statistical_1.FINV;
166exports.FISHER = Statistical_1.FISHER;
167exports.FISHERINV = Statistical_1.FISHERINV;
168exports.MAX = Statistical_1.MAX;
169exports.MAXA = Statistical_1.MAXA;
170exports.MIN = Statistical_1.MIN;
171exports.MINA = Statistical_1.MINA;
172exports.QUARTILE = Statistical_1.QUARTILE;
173exports.PERCENTILE = Statistical_1.PERCENTILE;
174exports.STDEV = Statistical_1.STDEV;
175exports.STDEVA = Statistical_1.STDEVA;
176exports.STDEVP = Statistical_1.STDEVP;
177exports.STDEVPA = Statistical_1.STDEVPA;
178exports.TRIMMEAN = Statistical_1.TRIMMEAN;
179exports.SLOPE = Statistical_1.SLOPE;
180exports.STANDARDIZE = Statistical_1.STANDARDIZE;
181exports.SMALL = Statistical_1.SMALL;
182exports.LARGE = Statistical_1.LARGE;
183exports.KURT = Statistical_1.KURT;
184exports.INTERCEPT = Statistical_1.INTERCEPT;
185exports.FORECAST = Statistical_1.FORECAST;
186exports.POISSON = Statistical_1.POISSON;
187exports.PERCENTRANK = Statistical_1.PERCENTRANK;
188exports.PERCENTRANK$EXC = Statistical_1.PERCENTRANK$EXC;
189exports.NORMSINV = Statistical_1.NORMSINV;
190exports.NORMSDIST = Statistical_1.NORMSDIST;
191exports.NORMDIST = Statistical_1.NORMDIST;
192exports.NORMINV = Statistical_1.NORMINV;
193exports.NEGBINOMDIST = Statistical_1.NEGBINOMDIST;
194exports.GEOMEAN = Statistical_1.GEOMEAN;
195exports.HARMEAN = Statistical_1.HARMEAN;
196exports.CONFIDENCE = Statistical_1.CONFIDENCE;
197exports.BINOMDIST = Statistical_1.BINOMDIST;
198exports.COVAR = Statistical_1.COVAR;
199exports.WEIBULL = Statistical_1.WEIBULL;
200exports.VARPA = Statistical_1.VARPA;
201exports.VARP = Statistical_1.VARP;
202exports.VARA = Statistical_1.VARA;
203exports.VAR = Statistical_1.VAR;
204exports.PERMUT = Statistical_1.PERMUT;
205exports.RSQ = Statistical_1.RSQ;
206exports.SKEW = Statistical_1.SKEW;
207exports.STEYX = Statistical_1.STEYX;
208exports.PROB = Statistical_1.PROB;
209exports.MODE = Statistical_1.MODE;
210exports.RANK = Statistical_1.RANK;
211exports.RANK$AVG = Statistical_1.RANK$AVG;
212exports.RANK$EQ = Statistical_1.RANK$EQ;
213exports.LOGNORMDIST = Statistical_1.LOGNORMDIST;
214exports.TDIST = Statistical_1.TDIST;
215exports.HYPGEOMDIST = Statistical_1.HYPGEOMDIST;
216exports.ZTEST = Statistical_1.ZTEST;
217var Text_1 = require("./Text");
218exports.ARABIC = Text_1.ARABIC;
219exports.CHAR = Text_1.CHAR;
220exports.CODE = Text_1.CODE;
221exports.SPLIT = Text_1.SPLIT;
222exports.CONCATENATE = Text_1.CONCATENATE;
223exports.CONVERT = Text_1.CONVERT;
224exports.TRIM = Text_1.TRIM;
225exports.LOWER = Text_1.LOWER;
226exports.UPPER = Text_1.UPPER;
227exports.T = Text_1.T;
228exports.ROMAN = Text_1.ROMAN;
229exports.TEXT = Text_1.TEXT;
230exports.FIND = Text_1.FIND;
231exports.JOIN = Text_1.JOIN;
232exports.LEN = Text_1.LEN;
233exports.LEFT = Text_1.LEFT;
234exports.RIGHT = Text_1.RIGHT;
235exports.SEARCH = Text_1.SEARCH;
236exports.REPT = Text_1.REPT;
237exports.VALUE = Text_1.VALUE;
238exports.CLEAN = Text_1.CLEAN;
239exports.MID = Text_1.MID;
240exports.PROPER = Text_1.PROPER;
241exports.REPLACE = Text_1.REPLACE;
242exports.SUBSTITUTE = Text_1.SUBSTITUTE;
243var Date_1 = require("./Date");
244exports.DATE = Date_1.DATE;
245exports.DATEVALUE = Date_1.DATEVALUE;
246exports.DATEDIF = Date_1.DATEDIF;
247exports.DAYS = Date_1.DAYS;
248exports.DAY = Date_1.DAY;
249exports.DAYS360 = Date_1.DAYS360;
250exports.EDATE = Date_1.EDATE;
251exports.EOMONTH = Date_1.EOMONTH;
252exports.MONTH = Date_1.MONTH;
253exports.YEAR = Date_1.YEAR;
254exports.WEEKDAY = Date_1.WEEKDAY;
255exports.WEEKNUM = Date_1.WEEKNUM;
256exports.YEARFRAC = Date_1.YEARFRAC;
257exports.TIMEVALUE = Date_1.TIMEVALUE;
258exports.HOUR = Date_1.HOUR;
259exports.MINUTE = Date_1.MINUTE;
260exports.SECOND = Date_1.SECOND;
261exports.NETWORKDAYS = Date_1.NETWORKDAYS;
262exports.NETWORKDAYS$INTL = Date_1.NETWORKDAYS$INTL;
263exports.NOW = Date_1.NOW;
264exports.TODAY = Date_1.TODAY;
265exports.TIME = Date_1.TIME;
266exports.WORKDAY = Date_1.WORKDAY;
267exports.WORKDAY$INTL = Date_1.WORKDAY$INTL;
268// Using alias to bind dot-notation function names.
269var __COMPLEX = {
270    "F.DIST": Statistical_1.FDIST$LEFTTAILED,
271    "NETWORKDAYS.INTL": Date_1.NETWORKDAYS$INTL,
272    "WORKDAY.INTL": Date_1.WORKDAY$INTL,
273    "POISSON.DIST": Statistical_1.POISSON,
274    "PERCENTRANK.INC": Statistical_1.PERCENTRANK,
275    "PERCENTRANK.EXC": Statistical_1.PERCENTRANK$EXC,
276    "ERROR.TYPE": Info_1.ERRORTYPE,
277    "RANK.AVG": Statistical_1.RANK$AVG,
278    "RANK.EQ": Statistical_1.RANK$EQ
279};
280exports.__COMPLEX = __COMPLEX;
281var __TRY_CATCH_FORMULAS = {
282    "ERROR.TYPE": Info_1.ERRORTYPE,
283    "ERRORTYPE": Info_1.ERRORTYPE,
284    "ISERR": Info_1.ISERR,
285    "ISERROR": Info_1.ISERROR,
286    "ISNA": Info_1.ISNA,
287    "IFERROR": Info_1.IFERROR
288};
289exports.__TRY_CATCH_FORMULAS = __TRY_CATCH_FORMULAS;