I'm not loving a spreadsheet for this, it gets too wide and doesn't lend itself well to any kind of long form text. My notebooks are sprawling with unorganized ideas.
What do you use to organize or categorize business ideas and your progress with them?
Ok, that kinda works for a project, but you will have a bunch of projects, so, presumably these need to be linked to a strategy. What good is implementing a project perfectly if it is not in line with your strategy. So, it would be really good to clearly articulate your strategy and to review this over time.
So, it seems you need something at a higher level which defines your strategy of your organization and this should help drive you toward the general projects you need to consider. You need to consider project risks, the risk of inactivity, etc. I’m out of date on this stuff, but check out Project Management Institutes books on portfolio management and strategy alignment. You want to consider the risks associated with highly technical projects, projects that need to be rolled out at many locations (because mistakes are expensive to correct).
I somewhat followed Markowitz efficient frontier portfolio management (very notionally) with my results and felt I had something to explain in my organization. Simple is better, its easy to get overwhelmed with spreadsheets and charts. Bubble charts helped differentiate the various projects.
Screenshots from Airtable version, https://blog.airtable.com/airtable-for-angel-investing/