My biggest concern is ease of use, and nothing beats a google spreadsheet or document (Except maybe Office). At some point, the free-form nature of the formats starts to cause a problem.
Specifically, I have the same conceptual data split up between two documents. This is done because both provide useful views of the data. (Note that this is meant to strictly manage feature descriptions written by "management" and then correlated with tasks created by "development")
- Document (Basically the functional specification)
- Contains high level descriptions of releases and features
- This is written in user-speak but created by management/marketing/producers/customer proxy
- Useful for a quick glance or detailed read through of the features in a release.
- This is "user" facing
- Spreadsheet (Basically the engineering schedule)
- Contains line item descriptions of feature tasks, estimates, and resource assignments
- This is developer facing
- Updated collaboratively by developers as they work
- Useful for a detailed view of the effort required (and spent) for features in a release.
Sometimes we want to reprioritize features, or add/remove ones, and that happens in the document. That restructuring then needs to be duplicated in the spreadsheet. This is a pain in the ass.
- My ideal solution would
- Easily support batch rearrangement of arbitrary groups of items (like a spreadsheet does).
- Be completely usable without touching a mouse.
- Be able to switch back and forth from a narrative outline view to a detailed line item view.
- Have different data visible in each view, but have the data travel with the items if they move.
- Support basic rich-text formatting
- Support simultaneous-ish editing by multiple users (Ala google apps, zoho, etc.)
- Absolutely no support for diagramming.
So how do you to track this stuff?