	Related Topics:
	Standard Folios

Data Sheets

Analysis folios in Weibull++, ALTA, RGA and DOE++ are made up of data sheets. This topic describes the basic components of a data sheet and shows how you can resize the columns and rows, and enter formulas.

Components of a Data Sheet

Data sheets in most folio types share the same general components. The following picture shows the basic components of a data sheet using one particular format of the Weibull++ standard folio as an example.

Caption displays the name of the folio and the name of the sheet that is currently displayed.
Name Box displays the location of the currently selected cell by listing the column letter and row number that intersect at the cell’s location. Note that the column letter represents the order of the column as it appears in the data sheet.
Data Entry Bar displays the contents of the selected cell, which may be text, a numerical value or a formula. For text or numerical values, you can enter, or edit, the information directly inside the cell or inside the data entry bar. For a formula, you must use the data entry bar for editing; the cell will display only the calculated value.
Row Headings identify the row numbers. You can change the name or number of a row by double-clicking its heading. The row will still retain its order number in the data sheet.
Column Headings indicate the title for the entries in each column. These titles depend on the type of data you are entering. You can change the name of a column by double-clicking its heading.
Sheet Tabs represent the different sheets within the folio. To switch between sheets, click the appropriate tab. You can change the name of a sheet by double-clicking its tab.

Each standard folio can contain up to 256 data sheets with up to 65,536 data rows per sheet. However, the application’s speed of execution is inversely proportional to the number of data rows in the current data set. In addition, the number of folios that can be opened at once is dependent upon the amount of memory of your system.

Resizing Columns and Rows

To resize the columns for data sheets in folios in Weibull++, ALTA and RGA, there are two ways:

To resize a single column, move pointer over the line that borders the column in the column header. The pointer will change to a double-headed arrow. Click and then drag the double-headed arrow to the left or right to resize the column. To save the changes, choose Home > Edit > Format Selection > Column Width Style > Keep as Set by User.
To span the columns across the spreadsheet with equal widths, choose Home > Edit > Format Selection > Column Width Style > Span Evenly. To keep the ratio of the column widths to span across the spreadsheet after they have been resized, choose Span Proportionally.

To resize the rows, there are two ways:

To resize a single row, move the pointer over the line that borders the row in the row header. The pointer will change to a double-headed arrow. Click and then drag the double-headed arrow up or down to resize the row.
To resize several rows all at once, select a cell in each of the rows to be resized and then choose Home > Edit > Format Selection > Row Height. This opens the opens the Row Height window, which allows you to set the row height of the selected cells and specify a unit of measurement for the height.

Entering Formulas in the Data Sheet

Except for DOE++, data sheets in Weibull++, ALTA and RGA allow you to enter formulas in columns that do not require entries to be dates, times or text (e.g., you cannot use formulas in the State F or S column in a Weibull++ standard folio, or in the Classification column in an RGA standard folio). For example, in a Weibull++ standard folio, if you have a data set where the units were inspected every 24 hours, you can speed up data entry by creating a formula to add 24 hours to the previous inspection time, as shown next.

There are two types of cell references (locations) when inputting a formula: absolute and relative. By default, the cell reference is relative, meaning that as a formula is copied and pasted to other cells, the cell references in the formula will be adjusted to reflect the new relative location. In the previous figure, the formula in cell C2 is copied and pasted into cell C4. This changes the cell reference in the formula from “=C1+24” to “=C3+24”; therefore, the time value in C4 is 72+24 = 96.

In contrast, an absolute reference does not change when the formula is copied to other cells. Absolute references are designated by placing a dollar sign ($) in front of the row and/or column to be made absolute. If the formula in the example were rewritten to “=$C$1+24”, then copying the formula to cell C4 would retain the cell reference to C1 and the time value in C4 would result to 24+24 = 48.