This Excel report displays
interstates with Poor OPI ratings that projects on the Interstate TIP
are addressing. This report also consists of two sections: one for Summary
Data and one for a list of projects that address OPI.
Descriptions of column calculations are listed
below:
· Miles: Calculated by summing all OPI Miles within the searched area for each of the OPI Rating Categories.
· Percentage of Total Miles:Calculated by dividing the OPI Category (e.g., Poor, Fair) Miles by the Total Miles in the search area.
· Total Miles Addressed:Calculated by summing the Improvement Miles on the detail section for each OPI Category.
· % Addressed by Projects:Calculated by dividing the Total Miles Addressed column by the Miles column for each OPI category.
· Miles Not Addressed:Calculated by subtracting the Total Miles Addressed from the Miles column for each OPI Category.
· % Not Addressed by Projects: Calculated by dividing the Miles Not Addressed by the Miles for each OPI Category.