Related Topics:
	Analysis Workbook

Analysis Workbook Example

You can use the Function Wizard to generate many different types of results in an analysis workbook or general spreadsheet. This section provides an example that shows how you can generate custom reports from your data. In this case, you will use Weibull++ to compare the failure time distributions from different tests of a component.

The data sets used in this example are available in the example database installed with the Weibull++ software (called "Weibull9_Examples.rsgz9"). To access this database file, choose File > Help, click Open Examples Folder, then browse for the file in the Weibull sub-folder. The name of the project is "Standard - Overlay Plot."

Note: This example uses the Weibull++ software, but a similar process can be used to generate custom analyzes in ALTA, RGA and BlockSim.

Using the Function Wizard to Create a Table of Results

1. Add an analysis workbook to the project (Insert > Reports and Plots > Analysis Workbook) and select the first data source, which is the “Test 1” data sheet for Component 1.

2. Click the Associate Data Source icon and assign the second data source, the “Test 2” data sheet for Component 1.

3. Update the column headings in the report: Time in column A, Reliability Test 1 in column B and Reliability Test 2 in column C.

4. In cell A1, enter the first time value (100). In cell A2, use the formula =A1+100 to increment the time value used in that cell. Then select cell A2 and drag the fill handle to cell A12 to copy the same function into the rest of the cells in the column.

   

5. Select cell B1 and open the Function Wizard. Select the RELIABILITY function, use a relative reference to cell A1 for the Age value and select the first associated data source.

6. Insert the function into cell B1. Then drag the fill handle to cell B12 to copy the same function into the rest of the cells.

7. Select cell C1 and open the Function Wizard. Select the RELIABILITY function, use a relative reference to cell A1 for the Age value and select the second associated data source.

8. Insert the function into cell C1. Then drag the fill handle to cell C12.

By looking at the data in the table you can see which design has the better reliability at a given time.

Using the Chart Wizard to Create a Bar Chart

You can also add custom charts to the report using the Chart Wizard. For example, to add a bar chart that shows a comparison of the reliability values over time, do the following:

1. Select the cells in the "Reliability Test 1" and "Reliability Test 2" columns and then choose Sheet > Sheet Actions > Chart Wizard.

2. Click inside the worksheet and drag to select the area under the data to insert the chart.

3. In the Gallery window, select the Bar option, then click Next and follow the wizard to add titles. When you are done, the report will look like this: