Function Wizard Functions

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

Spreadsheet Functions

These functions are available in the ReliaSoft Workbook's spreadsheet module in Weibull++.

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 ReliaSoft Workbook's word processing module in Weibull++. 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.).

Related Topics and Links