Spreadsheet: 0c5e8d16-e7be-49e4-8701-c26675517126
Sheet: Sheet1

Utah Department of Transportation | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Project: | Hypothetical Bridge Project | Unnamed: 7 | Unnamed: 8 | Utah Department of Transportation.1 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Project:.1 | Hypothetical Bridge Project.1 | Unnamed: 16 | Unnamed: 17 | Utah Department of Transportation.2 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Project:.2 | Hypothetical Bridge Project.2 | Unnamed: 25 | Unnamed: 26
4501 South 2700 West |  |  |  |  | By: | JJS | Checked: | CELS | 4501 South 2700 West |  |  |  |  | By: | JJS | Checked: | CELS | 4501 South 2700 West |  |  |  |  | By: | JJS | Checked: | CELS
Salt Lake City, UT 84114 |  |  |  |  | Date: | 2010-08-30 00:00:00 |  | 2010-08-30 00:00:00 | Salt Lake City, UT 84114 |  |  |  |  | Date: | 2010-08-30 00:00:00 |  | 2010-08-30 00:00:00 | Salt Lake City, UT 84114 |  |  |  |  | Date: | 2010-08-30 00:00:00 |  | 2010-08-30 00:00:00
 |  |  |  |  | Sheet No. | 1 | of | 3 |  |  |  |  |  | Sheet No. | 2 | of | 3 |  |  |  |  |  | Sheet No. | 3 | of | 3
ABC Rating Procedure |  |  |  |  |  |  |  | June 2010 | ABC Rating Procedure |  |  |  |  |  |  |  | June 2010 | ABC Decision Flowchart |  |  |  |  |  |  |  | June 2010
 |  |  |  |  |  |  |  |  | Note: Do not adjust weight factors without prior consultation with UDOT Structures Division Project Manager |  |  |  |  |  |  |  |  | * Region Director or Project Development Director to evaluate possible indirect benefits
Enter values for each aspect of the project.  Attach applicable supporting data.
 |  |  |  |  |  |  |  |  |  | ABC RATING SCORE FACTORS AND WEIGHTS
 |  |  |  |  |  |  |  |  |  |  |  |  | Weight | Adjusted | Maximum | Adjusted
Average Daily Traffic |  | 5 | 0 | No traffic impacts |  |  |  |  |  |  |  | Score | Factor | Score | Score | Score
Combined on and under |  |  | 1 | Less than 5000 |  |  |  |  |  | Average Daily Traffic |  | 5 | 10 | 50 | 5 | 50
Enter 5 for Interstate Highways |  |  | 2 | 5000 to 10000 |  |  |  |  |  | Delay/Detour Time |  | 2 | 10 | 20 | 5 | 50
 |  |  | 3 | 10000 to 15000 |  |  |  |  |  | Bridge Classification |  | 1 | 5 | 5 | 5 | 25
 |  |  | 4 | 15000 to 20000 |  |  |  |  |  | User Costs |  | 4 | 10 | 40 | 5 | 50
 |  |  | 5 | More than 20000 |  |  |  |  |  | Economy of Scale |  | 2 | 3 | 6 | 3 | 9
 |  |  |  |  |  |  |  |  |  | Use of Typical Details |  | 1 | 3 | 3 | 5 | 15
Delay/Detour Time |  | 2 | 0 | No delays |  |  |  |  |  | Safety |  | 5 | 10 | 50 | 5 | 50
 |  |  | 1 | Less than 5 minutes |  |  |  |  |  | Railroad Impacts |  | 0 | 5 | 0 | 5 | 25
 |  |  | 2 | 5-10 minutes |  |  |  |  |  |  |  |  | Total Score | 174 | [NAME]. Score | 274
 |  |  | 3 | 10-15 minutes
 |  |  | 4 | 15-20 minutes
 |  |  | 5 | More than 20 minutes |  |  |  |  |  |  |  | ABC Rating Score: |  | 63.5036496350365
 |  |  |  |  |  |  |  |  | The ABC Rating Score is driven by the four most heavily weighted factors: Average Daily Traffic, Delay/Detour Time, User Costs and Safety. For a detailed explanation, review the narrative on page 4 of the ABC Decision Making Process.
Bridge Classification |  | 1 | 1 | Normal Bridge
 |  |  | 3 | Essential Bridge
 |  |  | 5 | Critical Bridge
User Costs |  | 4 | 0 | No user costs |  |  |  |  | Cost Considerations:
 |  |  | 1 | Less than $10,000 |  |  |  |  | Calculate the following costs for use in determining the lowest total project cost
 |  |  | 2 | $10,000 to $50,000 |  |  |  |  |  | TOTAL PROJECT COST EVALUATION
 |  |  | 3 | $50,000 to $75,000 |  |  |  |  |  |  |  | Alternative #1 |  | Alternative #2
 |  |  | 4 | $75,000 to $100,000 |  |  |  |  |  | Construction Costs |  | 2500000 |  | 3000000
 |  |  | 5 | More than $100,000 |  |  |  |  |  | User Costs |  | 1000000 |  | 250000
 |  |  |  |  |  |  |  |  |  | Total Project Cost |  | 3500000 |  | 3250000
Economy of Scale |  | 2 | 0 | 1 span
(total number of spans) |  |  | 1 | 2 to 3 spans
 |  |  | 2 | 4 to 5 spans
 |  |  | 3 | More than 5 spans
Use of Typical Details |  | 1 | 1 | Complex geometry or unfavorable site conditions
 |  |  | 3 | Some complexity, but favorable site conditions
 |  |  | 5 | Simple geometry and favorable site conditions
Safety |  | 5 | 1 | Short duration impact with simple MOT scheme
 |  |  | 2 | Short duration impact with multiple traffic shifts
 |  |  | 3 | Normal duration impact with multiple traffic shifts
 |  |  | 4 | Extended duration impact with multiple traffic shifts
 |  |  | 5 | Extended duration impact with complex MOT scheme
Railroad Impacts |  | 0 | 0 | No railroad or minor railroad spur
 |  |  | 3 | One mainline railroad track
 |  |  | 5 | Multiple mainline railroad tracks