Use this tool to upload your NGA ground-motion files (.AT2) to your Excel workbook.
The tool reads the NGA row format (NGAWest2 and later) and saves it into column data and plots each time series It also integrates (trapezoidal rule) the acceleration to give you velocity and displacement.
You can then move or copy the worksheet to your Excel workbooks.
You can also select all the plots (select one graph, press ctrl-A, deselect the button by pressing the ctrl key and then the button) and then paste them into a Word document. You will have one record, 3 graphs, per page.
This is an excel file with macros, so make sure you enable macros and the Developer Tab in Excel.
top of page
bottom of page