Load Rating - Blank Excel Template summary tables.xlsx
XLSX spreadsheet 26 KB Posted
- Attached to
- AK NPS DENA 10(49), Polychrome Area Improvements
- Solicitation number
- 69056722R000015
About this file
This Excel file template contains three sheets for summarizing load rating data for structures. Sheet 1 includes fields for structure identification numbers, ratings for various truck and vehicle weights, controlling rating factors, and load and resistance values. Sheet 2 includes fields for permit vehicle gross weights and ratings. Sheet 3 includes fields for strength ratings by span for various trucks and vehicles.
The related federal contract opportunity is a solicitation to provide Polychrome Area Improvements for the National Park Service in Denali, Alaska. Services include construction work at the Polychrome Historic District. The solicitation number is 69056722R000015 and was issued by the Department of Transportation Federal Highway Administration. The response due date is not provided.
View the file
Other files
Show all 49
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| STRUCTURE LOAD RATING SUMMARY | |||||||||
| STRUCTURE No. | FAMS ID No. | ||||||||
| RATING TRUCKS | GROSS VEHICLE WEIGHT (TONS) | Capacity (Rn, Kips) | Dead Load (DC, Kips) | Wearing Surface (DW, Kips) | Live Load (LL, Kips) | CONTROLLING | |||
| RF | SPAN | MODE | ELEMENT | ||||||
| HL93 | 36 | ||||||||
| ORTYPE3 | 26 | ||||||||
| TYPE3S2 | 36 | ||||||||
| TYPE3-3 | 40 | ||||||||
| NRL | 40 | ||||||||
| ORSU4 | 28 | ||||||||
| ORSU5 | 32 | ||||||||
| ORSU6 | 35.75 | ||||||||
| ORSU7 | 39.75 | ||||||||
| ORTYPE3S2 | 40 | ||||||||
| EV2 | 28.75 | ||||||||
| EV3 | 43 | ||||||||
| H20 | 20 | ||||||||
| Note: Rn, DC, DW, and LL are factored values including all applicable LRFD and MBE factors used directly in the MBE rating factor equation 6A.4.2.1-1. |
Sheet2
| PERMIT VEHICLES | GROSS VEHICLE WEIGHT (TONS) | CTP | |
| RF | TON | ||
| ORTYPE3 | 26 | ||
| ORTYPE3S2 | 40 | ||
| TYPE3-3 | 40 | ||
| ORSU4 | 28 | ||
| ORSU5 | 32 | ||
| ORSU6 | 35.75 | ||
| ORSU7 | 39.75 | ||
| OR-CTP-2A | 52.75 | ||
| OR-CTP-2B | 52.75 | ||
| OR-CTP-3 | 49 | ||
| SINGLE_AXLE | 10.75 | ||
| DOUBLE_AXLE | 21.5 | ||
| TRI_AXLE | 32.25 | ||
| QUAD_AXLE | 43 |
Sheet3
| STRENGTH I - STRUCTURE LOAD RATING | |||||||||||
| FHWA BRIDGE NO. | FAMS ID NO. | ||||||||||
| RATING TRUCKS | GROSS VEHICLE WEIGHT (TONS) | SPAN 1 | SPAN 2 | SPAN 3 | SPAN 4 | SPAN 5 | SPAN 6 | CONTROLLING | |||
| RF | RF | RF | RF | RF | RF | RF | SPAN | MODE | BEAM | ||
| HL93 | 36 | ||||||||||
| ORTYPE3 | 26 | ||||||||||
| TYPE3S2 | 36 | ||||||||||
| TYPE3-3 | 40 | ||||||||||
| NRL | 40 | ||||||||||
| ORSU4 | 28 | ||||||||||
| ORSU5 | 32 | ||||||||||
| ORSU6 | 35.75 | ||||||||||
| ORSU7 | 39.75 | ||||||||||
| ORTYPE3S2 | 40 | ||||||||||
| EV2 | 28.75 | ||||||||||
| EV3 | 43 | ||||||||||
| H20 | 20 | ||||||||||
| ORCTP2A | 52.75 | ||||||||||
| ORCTP2B | 52.75 | ||||||||||
| ORCTP3 | 49 |
image1.png
File details come from the government source that posted it. Updated .