Related Topics:

Function Wizard Functions

Data Entry Tips for Functions

Spreadsheet Functions

This section presents the function types that can be entered in the Synthesis Workbook's spreadsheet module and in Analysis Workbooks in Weibull++ and ALTA by using the Function Wizard. The functions are grouped into the following categories:

Syntax: RELIABILITY(Data_Src,Age,[Add Time],[Confidence Level])

Example: =RELIABILITY("Folio1!Data1",1000,200,0.95) uses the analysis in Folio1!Data1 to return the 95% one-sided confidence bound on the conditional reliability for a mission of 200 hours, given that the item has already operated for 1,000 hours.

Syntax: AVERAGE(Number1,Number2,...)

Example 1: =AVERAGE(10,7,9,27,2) sums the numbers, then divides by 5 to return 11.

Example 2: =AVERAGE(A1:A6) returns the average of the values in cells A1 through A6.

The mathematical functions are available in Analysis Workbooks and General Spreadsheets. For the new spreadsheet module in Synthesis Workbooks, you can now insert those functions directly from the Formulas tab in the ribbon. For details, see Insert Function.

 

Data Source Functions

Available for both Weibull++ and ALTA:

ATYPE D_COUNT FMATRIX UDF

CATEGORY

DISTR LKVALUE USERCOMPANY

COMMENTS

DTYPE NFCOUNT USERNAME
DATARANK FCOUNT PARAMNAME  

 

Available only for Weibull++:

AMEAN DATAENTRY PDF TIMEATPF
ASTDEV EFAILURES PROBFAIL TIMEATR
AVAR EFAILURESS RANKMETHOD TOTALOPERATINGTIME
CBMETHOD FAILURERATE RDT_WB1_B ZEROCOUNT
CCOEF KSGOF RDT_WB1_C  
CHIGOF NPOPULATIONS RDT_WB1_E  
COSTPERUNITTIME PARAMETER_VALUE RELIABILITY  

 

Available only for ALTA:

ACCELERATIONFACTOR CONDPROBFAIL_S PARAMETER_S SCALEPARAMETER
ACT_ENERGY CONDRELIABILITY_S PDF_S TIMEATPF_S
AMEAN_S FAILURERATE_S PROBFAIL_S TIMEATR_S
ASTDEV_S MODEL RELIABILITY_S  

 

Mathematical Functions

ABS DELTA LOGINV REPLACEB
ACOS DOLLAR LOGNORMDIST REPT
ACOSH ERF LOOKUP RIGHT
AND ERFC LOWER ROUND
ASIN ERROR.TYPE MATCH ROUNDDOWN
ASINH EVEN MAX ROUNDUP
ATAN EXACT MID ROW
ATAN2 EXP MIN ROWS
ATANH EXPONDIST MINUTE SEARCH
AVERAGE FACT MIRR SEARCHB
BESSELI FACTDOUBLE MOD SECOND
BESSELJ FALSE MONTH SIGN
BESSELK FDIST MROUND SIN
BESSELY FIND N SINH
BETADIST FINDB NA SLN
BETAINV FINV NEGBINOMDIST SQRT
BINOMDIST FISHER NORMDIST STANDARDIZE
CEILING FISHERINV NORMINV STDEV
CHAR FIXED NORMSDIST STDEVP
CHIDIST FLOOR NORMSINV SUBSTITUTE
CHIINV FV NOT SUM
CHOOSE GAMMADIST NOW SUMIF
CLEAN GAMMAINV NPER SUMSQ
CODE GAMMALN NPV SYD
COLUMN HLOOKUP ODD T
COLUMNS HOUR OFFSET TAN
COMBIN HYPGEOMDIST OR TANH
CONCATENATE IF PERMUT TEXT
CONFIDENCE INT PI TIME
COS IPMT PMT TIMEVALUE
COSH IRR POISSON TODAY
COUNT ISBLANK PPMT TRIM
COUNTA ISERR PRODUCT TRUE
COUNTIF ISERROR PROPER TRUNC
CRITBINOM ISLOGICAL PV TYPE
CUMIPMT ISNONTEXT QUOTIENT UPPER
CUMPRINC ISNUMBER RADIANS VALUE
DATE ISREF RAND VAR
DATEVALUE ISTEXT RANK VARP
DAY LEFT RATE VDB
DAYS360 LEN RDT_NPB_C VLOOKUP
DB LN RDT_NPB_N WEEKDAY
DDB LOG RDT_NPB_R WEIBULL
DEGREES LOG10 REPLACE YEAR

 

© 1992-2016. ReliaSoft Corporation. ALL RIGHTS RESERVED.

E-mail Link