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++.
- 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 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.).