An Excel spreadsheet, shown below, is available to assist in the use of Microstran Response Spectrum Analysis of structures to NZS 4203. The procedure is described briefly in notes at the top of the spreadsheet. The spreadsheet calculates scale factors that have to be entered in Microstran dialog boxes during the response spectrum analysis.
February, 2000: The spreadsheet now interpolates for values of period and ductility factor that are not equal to values tabulated in the code.
Values shown in the spreadsheet relate to this structure:
The spreadsheet is available at Microstran Excel Spreadhsheet Extensions.