"EXPERIENCE, SERVICE, SOLUTIONS"

CASPER, PHILLIPS & ASSOCIATES


Example Module

20. CPA/STAYS FORESTAY & BACKSTAY WORKBOOK
 
 

EXPLANATION OF CELLS - FATIGUE CALCULATIONS
Column Description
Spectrum number (read from SPECTRUM.FAT input file) 
Starting moving load position (read from SPECTRUM.FAT input file) 
Ending moving load position (read from SPECTRUM.FAT input file) 
Number of cycles (read from SPECTRUM.FAT input file) 
f max (maximum algebraic stress) 
f min (minimum algebraic stress) 
 


 

EXPLANATION OF MACROS (Visual Basic worksheet)
Subroutine "auto_open"  Automatically loads and opens the "Stays" toolbar containing one button. 
Subroutine "auto_close"  Automatically closes the "Stays" toolbar so it does not appear on other workbooks when the workbook is closed. 
Subroutine "ReadFile"  Runs when the "ReadFile" button is selected. The macro enters the data into the worksheet and calculates the equations. 
Function "LOG10(x)"  Log base 10 of the number x. 
 

EXAMPLE WORKBOOK FOR BS2573:

Home | Cranes | Automated Design | Accident Repair | Staff List | Client List | Employment