Spreadsheet Functions

This section presents the functions that can be entered in analysis workbooks and general spreadsheets in Weibull++ and ALTA by using the Function Wizard. The functions are grouped into the following categories:

Data source functions return values that are based on the analysis in a specified data source.

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.

Mathematical functions do not require a data source. They perform a variety of mathematical and statistical operations (e.g., sine, pi or averages).

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.