Spreadsheet: 85353819-88ce-4b72-a30f-de6ae3d1454a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
 | Contents of Spreadsheet Fields are as Follows:
CMAQ ID | Application ID
[NAME] | [NAME]
Facility to be Improved | Project Location
Project Cost | Total project cost
Federal Request | Total federal request
Project Description | short description of the project
Program year | first program year
Completion year | completion year
ROW | ROW  code, N=not required, R=Required, A= Acquired
Design | Design code, N=Not Begun, U=Underway, S=Submitted, A=Approved.  Cell shaded green phase 2 approved
Construction Ready? | Project readiness. Y=project is mostly finished with design and ROW issues - suitable for 2013 implementation and before, N=outstanding ROW or engineering issues-cast doubt of project readiness by 2013, P=project can probably be ready by 2013.  Cell shaded RED=project not ready and construction programming requested for fy2012, YELLOW=project not ready and construction programming requested for fy2013
Interstate Sys | Interstates, 0=Off system, 1=On system
[NAME] | National Highway System, 0=Off system, 1=On system
SRA Sys | Strategic Regional Arterials, 0=Off system, 1=On system
OPA Sys | Other Principal Arterials, 0=Off system, 1=On system
CTA | CTA System, 0=Off system, 1=On system
Pace | Pace System, 0=Off system, 1=On system
TSP | Planned Transit Signal Priority Route, 0=Off system, 1=On system
[NAME] | Bus as probe monitored route, 1=0n system, 0=Off System
Total Veh | Total vehicle counts on each intersection link divided by two.  Total was divided by two to account for directionality.  Counts obtained from IRIS 2010.  For signal interconnect project maximum link vehicle count was used.
Total VPL | Total vehicle counts on each intersection link divided by the number of lanes.  Total was then divided by two to account for direction.  Vehicle counts obtained from IRIS 2010.  For signal interconnect project maximum link vehicle per lane was used.
Heavy Veh | Total heavy vehicle counts recorded on each intersection link in IRIS 2010 and then divided by two.  For signal interconnect project maximum link heavy vehicle count was used.
[NAME] | Maximum AM travel time index
Max PM TTI | Maximum PM travel time Index
Safety | Location of IDOT 5% crash list
Crashes08 | total 2008 Crashes at Project Location
Crashes09 | Total 2009 Crashes at Project Location
Severity Index08 | calculated by formula (20*#Fatal Crash)+(10*#Ainjury Crash)+(3*#Binjury Crash)+(2*#Cinjury Crash)+(1*#PDO Crash)/total crashes
Severity Index09 | calculated by formula (20*#Fatal Crash)+(10*#Ainjury Crash)+(3*#Binjury Crash)+(2*#Cinjury Crash)+(1*#PDO Crash)/total crashes
Congested | Location identified as congested by Counties and/or IDOT
Strategic Interest | Project type is inline with CMAP's strategic interest
Priority | Field for user to assign priorities based on evaluation criteria
Package 1 | Project part of pacakage 1
Package 2 | Project part of pacakage 2
Package 3 | Project part of pacakage 3
Package 4 | Project part of pacakage 4
Package 5 | Project part of pacakage 5
Package 6 | Project part of pacakage 6
Package Total | Total packages
Notes | User notes
Cost per User | total cost/total vehicles