Function Wizard Functions

This chapter presents detailed descriptions of the functions available in the Weibull++/ALTA Function Wizards.

Spreadsheet Functions

These functions are available in the Synthesis Workbook's spreadsheet module in Weibull++ and ALTA.

Spreadsheet Data source functions return values based on an analyzed folio. Use the Function Wizard for data sources to access these functions.

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

Example: =RELIABILITY("Weibull!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.

Spreadsheet Mathematical functions allow you to perform a variety of mathematical and statistical operations (e.g., sine, pi or averages). Use the Function Wizard for formulas to access these functions. (Note that this help file provides a partial list of the many math functions commonly used in spreadsheets. More math-related functions and their descriptions are available within the Function Wizard.)

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.

Word Processing Functions

These functions are available in the Synthesis Workbook's word processing module in Weibull++ and ALTA. To access these functions, use the Function Wizard for data sources. The selected function must first be inserted into the word processing module before you can change its settings.

Word Processing General functions return basic information about the database, project and current user (e.g., project name and user name).

Format: [PROJECT]

Example: [PROJECT] returns the current project name.

Word Processing Data source functions return values based on the associated data source (e.g., reliability, failure rate and mean).

Format: [RELIABILITY(Source Number)(Time)]

Example: [RELIABILITY(1)(1000)] uses the analysis in associated data source 1 to return the reliability at 1,000 hours.

Word Processing Confidence bounds functions return one-sided confidence bound values based on the associated data source (e.g., bounds on reliability, failure rate and mean).

Format: [BOUNDREL(Source Number)(Time; Confidence Level)]

Example: [BOUNDREL(1)(1000;0.9)] uses the analysis in associated data source 1 to return the 90% one-sided confidence bound on the reliability at 1,000 hours.

Word Processing Table functions return values in a table format based on the associated data source (e.g., probability of failure for a range of time, reliability for a range of time and parameter bounds).

Format: [TBLREL(Source Number)(Start Time;End Time;Time Increment)]

Example: [TBLREL(1)(100;500;50)] uses the analysis in associated data source 1 to return a table containing calculated reliability results at 100 hours and every additional 50 hours until 500 hours has been reached (i.e., 100, 150, 200, 250, etc.).

E-mail Link