An Excel spreadsheet, shown below, is available to assist in the use of Microstran Response Spectrum Analysis of structures to AS 1170.4. 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. Values shown in the spreadsheet relate to this structure:
The spreadsheet is available at Microstran Excel Spreadhsheet Extensions.