I’m starting a new series dedicated to sharing project management templates we’ve created and frequently use at Metal Toad. We use various tools on projects (Harvest, Jira, Basecamp, Trello, Invision, etc.), but like many others we’ve talked to, we still use plenty of spreadsheets and documents to improve project tracking and documentation. Yes, there are tools that accomplish what we’re looking to do, but many don’t do it well enough, and others do it too well. Sometimes a spreadsheet is just right. Using a spreadsheet over a similar tool makes sense based upon the overall value provided by each based on the variables below:
If your potential tool solution doesn’t win out significantly over a spreadsheet, then it’s probably to your benefit to stick with the spreadsheet and figure out ways to make the spreadsheet better.
Now all of this tool talk should come with a caveat, which is that in my book, tools are always secondary to process. My process looks something like:
Have I mentioned that I love prototyping with spreadsheets? My teammates will happily tell you how giddy I can get when solving a complex problem or answering an important business question with a spreadsheet!
If you constantly find spreadsheets can’t provide the value of tools, then perhaps your spreadsheets could use some improvement. Future posts in this series will help with that.