"EXPERIENCE, SERVICE, SOLUTIONS"

CASPER, PHILLIPS & ASSOCIATES

Example Module

20. CPA/STAYS FORESTAY & BACKSTAY WORKBOOK

CPA/STAYS is an EXCEL™ workbook for calculating member stresses and fatigue for catenary members. It may be modified and used for other structures. Use consistent units throughout.

Click on the "Stays" icon to start the workbook the first time. To revise the workbook, start Excel and open the desired workbook.

EXCEL is started and the workbook is automatically loaded as a copy of the master template stored in the directory "C:\CPA". A template is a special workbook that is serves as a pattern to create other workbooks (or spreadsheets). When a template is opened, Excel creates a copy of the template for the Engineer to work with. This leaves the original template intact the next time its needed.

The workbook is comprised of two (2) worksheets.

Sheet Title Description

1 Stays
The stay calculations. When the "ReadFile" button is depressed, the stress output file is opened, the information is loaded onto the worksheet, and the stresses are calculated.

2 Visual Basic
Visual Basic sheet containing programs to:
1. Set up the worksheet on opening.
2. Load the member properties, forces and lateral loads into the Stays worksheet and calculate the catenary stresses.
3. Reset the default Excel options upon closing the worksheet.

Sheet	Title	Description
1	Stays	The stay calculations. When the "ReadFile" button is depressed, the stress output file is opened, the information is loaded onto the worksheet, and the stresses are calculated.
2	Visual Basic	Visual Basic sheet containing programs to: 1. Set up the worksheet on opening. 2. Load the member properties, forces and lateral loads into the Stays worksheet and calculate the catenary stresses. 3. Reset the default Excel options upon closing the worksheet.

EXPLANATION OF CELLS (Stays worksheet)

The initial screen when the workbook is opened is shown below.

General note: Light yellow colored cells are input. The "Stays" toolbar is on the lower right side of the toolbars. The "Stays" toolbar consists of the "ReadFile" button. Button descriptions can be displayed in yellow under the button by placing the mouse cursor on the button.

General cell Description

E1 The member number, (1-4 characters). The filename is defined by combining the member number and joint number with the file extension (Cell L2). If either the number is less than 4 characters, an underscore is inserted between the member and joint numbers. In this example, the filename is "10302580.out".

G1 The joint number, (1-4 characters).

L1 The job number. The Visual Basic program reads the stress output file in the subdirectory described by the job number. In this example, the subdirectory is "c:\jobfiles\96006".

L2 Stress output file extension, (1-3 characters, may be preceded by "." for clarity). Default file extension is ".OUT".

F2 Method of entering properties (either File or Manual). If "File", the properties are read from the stress output file. The engineer can enter properties by changing the cell to "Manual" (or anything else).
C2 The section name
C3 The cross section area, A.
C4 Moment of inertia for dead loads, Ivert.
F4 Moment of inertia for lateral loads, Ilat.
C5 Section modulus for dead loads, Svert.
F5 Section modulus for lateral loads, Slat.

General cell	Description
E1	The member number, (1-4 characters). The filename is defined by combining the member number and joint number with the file extension (Cell L2). If either the number is less than 4 characters, an underscore is inserted between the member and joint numbers. In this example, the filename is "10302580.out".
G1	The joint number, (1-4 characters).
L1	The job number. The Visual Basic program reads the stress output file in the subdirectory described by the job number. In this example, the subdirectory is "c:\jobfiles\96006".
L2	Stress output file extension, (1-3 characters, may be preceded by "." for clarity). Default file extension is ".OUT".
F2	Method of entering properties (either File or Manual). If "File", the properties are read from the stress output file. The engineer can enter properties by changing the cell to "Manual" (or anything else). C2 The section name C3 The cross section area, A. C4 Moment of inertia for dead loads, Ivert. F4 Moment of inertia for lateral loads, Ilat. C5 Section modulus for dead loads, Svert. F5 Section modulus for lateral loads, Slat.