Difference between revisions of "Excel to Analytica Mappings"
(added word article) |
|||
| Line 1: | Line 1: | ||
| + | [[Category: Concepts]] | ||
| + | |||
| + | __TOC__ | ||
| + | |||
| + | |||
The paper [[media:Translating from Excel to Analytica.doc|A Guide to Translating from Excel to Analytica]] by Max Henrion and Richard Morgan covers the overall process and steps involved in translating a spreadsheet. | The paper [[media:Translating from Excel to Analytica.doc|A Guide to Translating from Excel to Analytica]] by Max Henrion and Richard Morgan covers the overall process and steps involved in translating a spreadsheet. | ||
| Line 5: | Line 10: | ||
We haven't yet found anything you can do in Excel but not Analytica. If you find a function where no translation is shown, this does not mean there isn't an equivalent. More likely, it just means that the equivalent hasn't been filled in yet. Please contribute and fill it in! Note, in order to look at the Analytica equivalents under each category you will need to click on the subheading of the relevant category. | We haven't yet found anything you can do in Excel but not Analytica. If you find a function where no translation is shown, this does not mean there isn't an equivalent. More likely, it just means that the equivalent hasn't been filled in yet. Please contribute and fill it in! Note, in order to look at the Analytica equivalents under each category you will need to click on the subheading of the relevant category. | ||
| − | + | == [[Excel to Analytica Mappings/Database Functions|Database Functions]] == | |
| − | = [[Excel to Analytica Mappings/Database Functions|Database Functions]] = | ||
DAVERAGE | DAVERAGE | ||
| Line 21: | Line 25: | ||
DVARP | DVARP | ||
| − | = [[Excel to Analytica Mappings/Date and Time Functions|Date and Time Functions]] = | + | == [[Excel to Analytica Mappings/Date and Time Functions|Date and Time Functions]] == |
DATE | DATE | ||
| Line 43: | Line 47: | ||
YEARFRAC | YEARFRAC | ||
| − | = [[Excel to Analytica Mappings/Engineering Functions|Engineering Functions]] = | + | == [[Excel to Analytica Mappings/Engineering Functions|Engineering Functions]] == |
BESSELI | BESSELI | ||
| Line 83: | Line 87: | ||
OCT2HEX | OCT2HEX | ||
| − | = [[Excel to Analytica Mappings/Financial Functions|Financial Functions]] = | + | == [[Excel to Analytica Mappings/Financial Functions|Financial Functions]] == |
ACCRINT | ACCRINT | ||
| Line 139: | Line 143: | ||
YIELDMAT | YIELDMAT | ||
| − | = [[Excel to Analytica Mappings/Information Functions|Information Functions]] = | + | == [[Excel to Analytica Mappings/Information Functions|Information Functions]] == |
CELL | CELL | ||
| Line 159: | Line 163: | ||
TYPE | TYPE | ||
| − | = [[Excel to Analytica Mappings/Logical Functions|Logical Functions]] = | + | == [[Excel to Analytica Mappings/Logical Functions|Logical Functions]] == |
AND | AND | ||
| Line 168: | Line 172: | ||
TRUE | TRUE | ||
| − | = [[Excel to Analytica Mappings/Lookup Functions|Lookup Functions]] = | + | == [[Excel to Analytica Mappings/Lookup Functions|Lookup Functions]] == |
ADDRESS | ADDRESS | ||
| Line 189: | Line 193: | ||
VLOOKUP | VLOOKUP | ||
| − | = [[Excel to Analytica Mappings/Math Functions|Math Functions]] = | + | == [[Excel to Analytica Mappings/Math Functions|Math Functions]] == |
ABS | ABS | ||
| Line 251: | Line 255: | ||
TRUNC | TRUNC | ||
| − | = [[Excel to Analytica Mappings/Statistical Functions|Statistical Functions]] = | + | == [[Excel to Analytica Mappings/Statistical Functions|Statistical Functions]] == |
AVEDEV | AVEDEV | ||
| Line 334: | Line 338: | ||
ZTEST | ZTEST | ||
| − | = [[Excel to Analytica Mappings/Text and Data Functions|Text and Data Functions]] = | + | == [[Excel to Analytica Mappings/Text and Data Functions|Text and Data Functions]] == |
ASC | ASC | ||
| Line 370: | Line 374: | ||
UPPER | UPPER | ||
VALUE | VALUE | ||
| + | |||
| + | ==See Also== | ||
| + | <div style="column-count:2;-moz-column-count:2;-webkit-column-count:2"> | ||
| + | * [[Excel to Analytica Mappings/Database Functions]] | ||
| + | * [[Excel to Analytica Mappings/Date and Time Functions]] | ||
| + | * [[Excel to Analytica Mappings/Engineering Functions]] | ||
| + | * [[Excel to Analytica Mappings/Financial Functions]] | ||
| + | * [[Excel to Analytica Mappings/Information Functions]] | ||
| + | * [[Excel to Analytica Mappings/Logical Functions]] | ||
| + | * [[Excel to Analytica Mappings/Lookup Functions]] | ||
| + | * [[Excel to Analytica Mappings/Math Functions]] | ||
| + | * [[Excel to Analytica Mappings/Statistical Functions]] | ||
| + | * [[Excel to Analytica Mappings/Text and Data Functions]] | ||
| + | * [[media:Translating from Excel to Analytica.doc|A Guide to Translating from Excel to Analytica]] | ||
| + | * [[Excel to Analytica Translation]] | ||
| + | * [[Read from and write to Excel spreadsheets]] | ||
| + | * [[Functions To Read Excel Worksheets]] | ||
| + | * [[Functions to Write Data to Excel Worksheets]] | ||
| + | </div> | ||
Revision as of 20:12, 22 February 2016
The paper A Guide to Translating from Excel to Analytica by Max Henrion and Richard Morgan covers the overall process and steps involved in translating a spreadsheet.
This page provides mappings from functions found in Excel to the equivalent function or method in Analytica.
We haven't yet found anything you can do in Excel but not Analytica. If you find a function where no translation is shown, this does not mean there isn't an equivalent. More likely, it just means that the equivalent hasn't been filled in yet. Please contribute and fill it in! Note, in order to look at the Analytica equivalents under each category you will need to click on the subheading of the relevant category.
Database Functions
DAVERAGE DCOUNT DCOUNTA DGET DMAX DMIN DPRODUCT DSTDEV DSTDEVP DSUM DVAR DVARP
Date and Time Functions
DATE DATEVALUE DAY DAYS360 EDATE EOMONTH HOUR MINUTE MONTH NETWORKDAYS NOW SECOND TIME TIMEVALUE TODAY WEEKDAY WORKDAY YEAR YEARFRAC
Engineering Functions
BESSELI BESSELJ BESSELK BESSELY BIN2DEC BIN2HEX BIN2OCT COMPLEX CONVERT DEC2BIN DEC2HEX DEC2OCT DELTA ERF ERFC GESTEP HEX2BIN IMABS IMAGINARY IMARGUMENT IMCONJUGATE IMCOS IMDIV IMEXP IMLN IMLOG10 IMLOG2 IMPOWER IMPRODUCT IMREAL IMSIN IMSQRT IMSUB IMSUM OCT2BIN OCT2DEC OCT2HEX
Financial Functions
ACCRINT ACCRINTM AMORDEGRC AMORLINC COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPNUM COUPPCD CUMIPMT CUMPRINC DB DDB DISC DOLLARDE DOLLARFR DURATION EFFECT FV FVSCHEDULE INTRATE IMPT IRR ISPMT MDURATION MIRR NOMINAL NPER NPV ODDFPRICE ODDFYEILD ODDLPRICE ODDLYIELD PMT PPMT PRICE PRICEDISC PRICEMAT PV RATE RECEIVED SLN SYD TBILLEQ TBILLPRICE TBILLYIELD VDB XIRR XNPV YIELD YIELDDISC YIELDMAT
Information Functions
CELL ERROR.TYPE INFO ISBLANK ISERR ISERROR ISEVEN ISLOGICAL ISNA ISNONTEXT ISNUMBER ISODD ISREF ISTEXT N NA TYPE
Logical Functions
AND FALSE IF NOT OR TRUE
Lookup Functions
ADDRESS AREAS CHOOSE COLUMN COLUMNS GETPIVOTDATA HLOOKUP HYPERLINK INDEX INDIRECT LOOKUP MATCH OFFSET ROW ROWS RTD TRANSPOSE VLOOKUP
Math Functions
ABS ACOS ACOSH ASIN ASINH ATAN ATAN2 ATANH CEILING COMBIN COS COSH DEGREES EVEN EXP FACT FACTDOUBLE FLOOR GCD INT LCM LN LOG LOG10 MDETERM MINVERSE MMULT MOD MROUND MULTINOMIAL ODD PI POWER PRODUCT QUOTIENT RADIANS RAND RANDBETWEEN ROMAN ROUND ROUNDDOWN ROUNDUP SERIESSUM SIGN SIG SINH SQRT SQRTPI SUBTOTAL SUM SUMIF SUMPRODUCT SUMSQ SUMX2MY2 SUMX2PY2 SUMXMY2 TAN TANH TRUNC
Statistical Functions
AVEDEV AVERAGE AVERAGEA BETADIST BETAINV BINOMDIST CHIDIST CHIINV CHITEST CONFIDENCE CORREL COUNT COUNTA COUNTBLANK COUNTIF COVAR CRITBINOM DEVSQ EXPONDIST FDIST FINV FISHER FISHERINV FORECAST FREQUENCY FTEST GAMMADIST GAMMAINV GAMMALN GEOMEAN GROWTH HARMEAN HYPGEOMDIST INTERCEPT KURT LARGE LINEST LOGEST LOGINV LOGNORMDIST MAX MAXA MEDIAN MIN MINA MODE NEGBINOMDIST NORMDIST NORMINV NORMSDIST NORMSINV PEARSON PERCENTILE PERCENTRANK PERMUT POISSON PROB QUARTILE RANK RSQ SKEW SLOPE SMALL STANDARDIZE STDEV STDEVA STDEVP STDEVPA STEYX TDIST TINV TREND TRIMMEAN TTEST VAR VARA VARP VARPA WEIBULL ZTEST
Text and Data Functions
ASC BAHTTEXT CHAR CLEAN CODE CONCATENATE COLLAR EXACT FIND FINDB FIXED JIS LEFT LEFTB LEN LENB LOWER MID MIDB PHONETIC PROPER REPLACE REPLACEB REPT RIGHT RIGHTB SEARCH SEARCHB SUBSTITUTE T TEXT TRIM UPPER VALUE
See Also
- Excel to Analytica Mappings/Database Functions
- Excel to Analytica Mappings/Date and Time Functions
- Excel to Analytica Mappings/Engineering Functions
- Excel to Analytica Mappings/Financial Functions
- Excel to Analytica Mappings/Information Functions
- Excel to Analytica Mappings/Logical Functions
- Excel to Analytica Mappings/Lookup Functions
- Excel to Analytica Mappings/Math Functions
- Excel to Analytica Mappings/Statistical Functions
- Excel to Analytica Mappings/Text and Data Functions
- A Guide to Translating from Excel to Analytica
- Excel to Analytica Translation
- Read from and write to Excel spreadsheets
- Functions To Read Excel Worksheets
- Functions to Write Data to Excel Worksheets
Enable comment auto-refresher