{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Disclaimer","Risk-Targeted_ARS-V2025.1"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":1,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["Period (s)","Spectral Acceleration (g)"]
[0,0.29199999999999998]
[0.01,0.29199999999999998]
[0.02,0.30499999999999999]
[0.03,0.32700000000000001]
[0.05,0.38400000000000001]
[7.4999999999999997E-2,0.499]
[0.1,0.61499999999999999]
[0.15,0.66800000000000004]
[0.2,0.63200000000000001]
[0.25,0.57499999999999996]
[0.3,0.53200000000000003]
[0.4,0.45500000000000002]
[0.5,0.39300000000000002]
[0.75,0.30299999999999999]
[1,0.248]
[1.5,0.18099999999999999]
[2,0.14000000000000001]
[3,9.1800000000000007E-2]
[4,6.7900000000000002E-2]
[5,5.16E-2]
[7.5,3.3300000000000003E-2]
[10,2.76E-2]

{"sheet":"Disclaimer","index":1,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,1,13,6],[1,1,1,4],[2,1,9,20],[10,1,10,20],[11,1,11,11],[12,1,12,20]]}
[]
[null,"Disclaimer!"]
[null,"• This Excel Tool is intended for development of the Seismic Design Response Spectrum for a given bridge site. The response spectral accelerations are obtained from the AASHTO–USGS Seismic Design Ground Motion Database developed by the USGS using the 2018 NSHM. While every attempt has been made to ensure the accuracy of this Tool, this version shall be used for preliminary designs only.\n"]
[]
[]
[]
[]
[]
[]
[]
[null,"• For final design, obtain the spectral response parameters at "]
[null,"https://doi.org/10.5066/F7NK3C76"]
[null,"• If you discover any flaws or have suggestions for improvements,"]
[null,"please contact us."]

{"sheet":"Risk-Targeted_ARS-V2025.1","index":2,"n_rows":35,"n_cols":32,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,8,0,9],[1,8,1,9],[2,8,2,9],[8,6,8,9],[7,28,9,33],[11,45,11,47],[1,28,1,30],[1,31,1,33],[2,28,2,30],[2,31,2,33],[1,45,1,47],[10,41,10,43],[1,41,1,43],[10,30,10,31],[3,28,3,30],[3,31,3,33],[4,28,4,30],[5,28,5,33],[6,28,6,33],[6,1,6,4],[7,1,7,4],[12,30,12,31],[11,1,11,2],[0,2,0,6],[1,2,1,6],[2,2,2,6],[3,12,3,13],[0,12,0,13],[3,2,3,4],[4,2,4,4],[2,12,2,13],[6,6,6,9],[5,6,5,9],[0,27,0,33],[9,6,9,9]]}
[null,"Project Name:",null,null,null,null,null,"Key Number:",null,null,null,null,{"$f":"TODAY()","v":"2025-10-09"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"https://earthquake.usgs.gov/ws/designmaps/aashto-2023/spectra/\"&M7&\"/\"&L7&\"/\"&N7","v":"https://earthquake.usgs.gov/ws/designmaps/aashto-2023/spectra/-123.024/44.942/BC"}]
[null,"Highway:",null,null,null,null,null,"Milepost:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Site Class","Seismic Performance Level",null,null,"Project Type"]
[null,"Structure:",null,null,null,null,null,"Structure No.",null,null,null,null,"Project Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","PL1: Life Safety",null,null,"New Bridge - Seismic Design"]
[null,"County:",null,null,null,null,null,null,null,null,null,null,"New Bridge - Seismic Design",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B","PL2:Operational",null,null,"Existing Bridge - Seismic Retrofit"]
[null,"Designer:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BC","PL3: Fully Operational"]
[null,null,null,null,null,null,"Seismic Performance Level",null,null,null,null,"Latitude (Deg)","Longitude (Deg)","Site Class",null,null,null,null,null,null,null,null,null,null,null,null,null,"C","Notes:"]
[null,"Design Ground Motions ",null,null,null,null,"PL1: Life Safety",null,null,null,null,44.942,-123.024,"BC",null,null,null,null,null,null,null,null,null,null,null,null,null,"CD","SDS = 90 percent of the peak Sa value (GS 4.3.3)"]
[null,"AASHTO 2023 Risk-Targeted Ground Motions",null,null,null,null,null,null,null,null,null,"(42°00' to 46°18')","(-116°27' to -124°34')",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D","SD1 = 90 percent of the maximum value of the product, T*Sa, for periods from 1 to 2 s for sites with vs > 1,450 ft/s and for periods 1 to 5 s for sites with vs ≤1,450 ft/s, but not less than 100 percent of the value of Sa at 1 s."]
[null,"As","SDS","SD1","SDC",null,"Seismic Hazard Model",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DE"]
[null,{"$f":"C14","v":0.29199999999999998},{"$f":"0.9*(MAX(C14:C35))","v":0.60120000000000007},{"$f":"IF(OR(N7=\"A\",N7=\"B\",N7=\"BC\",N7=\"C\"),AE28,IF(OR(N7=\"CD\",N7=\"D\",N7=\"DE\",N7=\"E\"),AF28,\"\"))","v":0.25200000000000006},{"$f":"IF(D10<0.15,\"A\",IF(AND(D10>=0.15,D10<0.3),\"B\",IF(AND(D10>=0.3,D10<0.5),\"C\",IF(D10>=0.5,\"D\",\"\"))))","v":"B"},null,"2018 USGS National Seismic Hazard Model",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F",null,null,"Site Class"]
[null,{"$f":"IF(G7=AB31,\"500-Year EQ\",\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A, B, BC, C","CD, D, DE, E"]
[null,"Period, T (sec)","Sa (g)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Period, T (sec)","Sa (g)","T*Sa","SD1"]
[null,{"$f":"Data!A2","v":0},{"$f":"Data!B2","v":0.29199999999999998},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B14","v":0},{"$f":"C14","v":0.29199999999999998},{"$f":"AB14*AC14","v":0}]
[null,{"$f":"Data!A3","v":0.01},{"$f":"Data!B3","v":0.29199999999999998},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B15","v":0.01},{"$f":"C15","v":0.29199999999999998},{"$f":"AB15*AC15","v":2.9199999999999999E-3}]
[null,{"$f":"Data!A4","v":0.02},{"$f":"Data!B4","v":0.30499999999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.02,0.30499999999999999,6.1000000000000004E-3]
[null,{"$f":"Data!A5","v":0.03},{"$f":"Data!B5","v":0.32700000000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.03,0.32700000000000001,9.8099999999999993E-3]
[null,{"$f":"Data!A6","v":0.05},{"$f":"Data!B6","v":0.38400000000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,0.38400000000000001,1.9200000000000002E-2]
[null,{"$f":"Data!A7","v":7.4999999999999997E-2},{"$f":"Data!B7","v":0.499},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.4999999999999997E-2,0.499,3.7425E-2]
[null,{"$f":"Data!A8","v":0.1},{"$f":"Data!B8","v":0.61499999999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,0.61499999999999999,6.1499999999999999E-2]
[null,{"$f":"Data!A9","v":0.15},{"$f":"Data!B9","v":0.66800000000000004},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,0.66800000000000004,0.1002]
[null,{"$f":"Data!A10","v":0.2},{"$f":"Data!B10","v":0.63200000000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.63200000000000001,0.12640000000000001]
[null,{"$f":"Data!A11","v":0.25},{"$f":"Data!B11","v":0.57499999999999996},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,0.57499999999999996,0.14374999999999999]
[null,{"$f":"Data!A12","v":0.3},{"$f":"Data!B12","v":0.53200000000000003},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,0.53200000000000003,0.15959999999999999]
[null,{"$f":"Data!A13","v":0.4},{"$f":"Data!B13","v":0.45500000000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.45500000000000002,0.18200000000000002]
[null,{"$f":"Data!A14","v":0.5},{"$f":"Data!B14","v":0.39300000000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,0.39300000000000002,0.19650000000000001]
[null,{"$f":"Data!A15","v":0.75},{"$f":"Data!B15","v":0.30299999999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,0.30299999999999999,0.22725000000000001]
[null,{"$f":"Data!A16","v":1},{"$f":"Data!B16","v":0.248},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0.248,0.248,{"$f":"MAX(0.9*(MAX(AD28:AD30)),AC28)","v":0.25200000000000006},{"$f":"MAX(0.9*(MAX(AD28:AD33)),AC28)","v":0.25200000000000006}]
[null,{"$f":"Data!A17","v":1.5},{"$f":"Data!B17","v":0.18099999999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,0.18099999999999999,0.27149999999999996]
[null,{"$f":"Data!A18","v":2},{"$f":"Data!B18","v":0.14000000000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0.14000000000000001,0.28000000000000003,{"$f":"0.9*(MAX(AD28:AD30))","v":0.25200000000000006}]
[null,{"$f":"Data!A19","v":3},{"$f":"Data!B19","v":9.1800000000000007E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,9.1800000000000007E-2,0.27540000000000003]
[null,{"$f":"Data!A20","v":4},{"$f":"Data!B20","v":6.7900000000000002E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,6.7900000000000002E-2,0.27160000000000001]
[null,{"$f":"Data!A21","v":5},{"$f":"Data!B21","v":5.16E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5.16E-2,0.25800000000000001,null,{"$f":"0.9*(MAX(AD28:AD33))","v":0.25200000000000006}]
[null,{"$f":"Data!A22","v":7.5},{"$f":"Data!B22","v":3.3300000000000003E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.5,3.3300000000000003E-2,0.24975000000000003]
[null,{"$f":"Data!A23","v":10},{"$f":"Data!B23","v":2.76E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,2.76E-2,0.27600000000000002]