- We created a scoring system that takes into account each of the following factors:
- Feasibility
- Cost
- Timeline
- Economic Viability
- Legal Liability
- Alignment to Mission
- Meme Value
- Each is added as a field to the right with a dropdown to select the score.
- The "REF" tab has all the factors and the weighting for the score calculations so feel free to modify the factors or change the weights.
- Filtered out ideas that are not complete or detailed and any duplicates which is noted in columns “Status” and “Rationale for Status”.
- Parcel 1 ideas were colored in following way:
- Light green: strong proposal
- Dark green: strong proposal but could be costly to maintain
- Yellow: has 1 or 2 key weaknesses
- Red: weak proposal or needs more detail
- Added two columns:
- "Parcel vs Side Project": for the purpose of this exercise, we filtered out side projects, as those can always be added on later.
- "Category of Parcel" : we ended up with 7 categories of parcels / ideas:
- Economic Use (just a business)
- Embassy / HQ
- Partnership
- Retreat
- Retreat / Economic Use
- Start a city
c. We then added a column "Linked Parcel ID" we used this to group ideas that were similar or could be merged, eg. there were two proposals for a property in Denver, one had a specific parcel, the other didn't, so we put them both as #9 in that column. We also marked some as "category" if the idea would be applicable to any parcel in that category which was true of some of the more general ideas.