Attached is an Excel workbook. It contains 3 worksheets. The first worksheet contains my attempt to assign Bicycle Board scores for LRTP Tier 1 project feasibility, mobility, preference and priority. To get priority, I summed the scores for feasibility, mobility and preference then normalized the sums to the 1-10 point scale that Bill suggested.
The second worksheet contains my attempt to prioritize the 36 intersections listed in LRTP Project 38 - Intersection Capacity and Safety Improvement Program. The score sheet that Bill wants us to complete also contains fields for feasibility, mobility, preference and priority. I only scored priority because I don't know what changes are planned for the intersections, so I couldn't score feasibility and mobility. That leaves preference and priority. I don't see the difference between preference and priority, so I just scored priority. To the scoresheet that Bill asked us to complete, I added 3 columns: Danger Rating; Signalized?; and Comments. The comments might help explain my scores but also include intersection improvement recommendations.
The third worksheet just has the intersections re-sorted in the order of priority that "we" gave them.
There are more rational bicycling accommodations in this LRTP than in past plans. All involved parties worked long and hard to get them there. If we keep them near the top of the priority list, some of them might actually get done!