Worksheet format

The OHA worksheet format and instructions for completing it are included in the explanation of PET analysis in Chapter 16. 

Worksheets are normally not required. If the complexity of the change dictates the use of worksheets, use the system/subsystem hazard analysis worksheet format depicted earlier in Figure 8-4. 

An example FHA analysis worksheet is shown in Figure 2.31. This particular FHA analysis worksheet utilizes a columnar-type format. Other worksheet formats may exist because different organizations often tailor their FHA analysis worksheet to fit their particular needs. The specific worksheet to be used may be determined by the SSP, system safety working group (SSWG), or the FHA customer. 

Figure 2.58 shows an example columnar format PHA worksheet. This particular worksheet format has proven to be useful and effective in many applications, and it provides all of the information necessary from a PHA. 

Verification of data format entered into the computer Worksheet generation... 

Figure 6.4 Example Failure Compilation Worksheet Note The format used to enter failure data is X[Y,Z], where X is the total number of failures, Y is the number of demand-related failures, and Z is the number of time-related failures. From Science Applications International Corporation.

The MathCad worksheets used for this Chemometrics in Spectroscopy collaborative study series are given below in hard copy format. Unless otherwise noted, the worksheets have been written by the authors. The text files for the MathCad v7.0 Worksheets used for the statistical tests in this report are attached as Collabor GM, Collabor TV, ANOVA s4, ANOVA s2, CompareT, and Comp Meth. References [1-11] are excellent sources of information of the details on these statistical methods. 

For this chapter we continue to describe the use of confidence limits for comparison of X, Y data pairs. This subject has been addressed in Chapters 58-60 first published as a set of articles in Spectroscopy [1-3]. A MathCad Worksheet ( 1986-2001 MathSoft Engineering Education, Inc., 101 Main Street Cambridge, MA 02142-1521) provides the computations for interested readers. This will be covered in a subsequent chapter or can be obtained in MathCad format by contacting the authors with your e-mail address. The Worksheet allows the direct calculation of the f-statistic by entering the desired confidence levels. In addition the confidence limits for the calculated slope and intercept are computed from the original data table. The lower limits for the slope and the intercept are displayed using two different sets of equations (and are identical). The intercept confidence limits are also calculated and displayed. 

Table 4.7. Typical Format for a What-if Analysis Worksheet...

The next type of standard output is the spreadsheet. These file formats use comma-separated ASCII code, but also add calculation information and addressing information for the columns and rows they occupy. The simplest of these are. DIF files, which originated to allow information transfer between VisiCalc worksheets in the Apple II computer and have been retained as a standard format.. WK files are Lotus-1,2,3 formats and. XLS are Microsoft Excel formats that have become spreadsheet standards, allowing transfer of data, calculations, addresses, and macro programs. 

Figure 1.11 Demonstration of the error trapping routines in the code controlling worksheet calculations activated through the Character from Orbits command button. Note that the second screen dump has been enhanced to emphasise that a non-integer entry was made, because the default format for the of orbits input cells is integer.

This chapter covers the basics of working with Excel navigating around the worksheet, entering values and formulas, and formatting and editing a worksheet. If you are an experienced Excel user, you can probably skip this chapter however, even experienced users may find a few useful tips in this chapter,... 

In Excel 2000 for Windows, the Worksheet Menu Bar has the following pulldown menus File, Edit, View, Insert, Format, Tools, Data, Window and Help. The File, Edit, Format and Window menus are discussed in this chapter. Commands in other menus will be discussed in later chapters. 

Excel also provides "context-sensitive" shortcut menus. If you press the right mouse button (Windows) or press COMMAND+OPTION (Macintosh) while you select a worksheet element with the mouse pointer, a menu is displayed containing commands that apply to the selection. For example, if you select a column while holding down the right mouse button, a shortcut menu containing editing and formatting commands appropriate for a column appears. 

To use the Across Worksheets option in the Fill submenu, you must have selected multiple sheets beforehand. Select adjacent or non-adjacent sheets in the same way you select cells. To select an adjacent range of worksheets click on the tab of the first sheet, then hold down the SHIFT key and click on the tab of the last sheet in the range. To select non-adjacent sheets, hold down the CONTROL key (Windows) or the COMMAND key (Macintosh) while selecting. When you choose Across Worksheets from the submenu, the Fill Across Worksheets dialog box (Figure 1-18) will appear you can choose to fill Contents, Formats or both. 

---