Function Wizard Functions

This chapter presents detailed descriptions of the functions available in RGA’s Function Wizards.

Spreadsheet Functions

These functions are available in the Synthesis Workbook's spreadsheet module in RGA. There are two types:

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,Time,[Conf_Level])

Example: =RELIABILITY("Folio1!Data1",1000,0.95) uses the analysis in Folio1!Data1 to return the 95% one-sided confidence bound on the reliability of an item that has 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 RGA. 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 values that are related to the basic project information (e.g., project name and display 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, growth rate and initial MTBF).

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, MTBF and Failure intensity).

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.

E-mail Link