I have a Spreadsheet with the following fields:
1. Down the left hand side is a list of components which together make an overall solution. For ease lets say these are Car parts.
2. Next to the list of Car parts are milestones (dates) for which the Car part must be tested. Each one marked with an "X" of when it is to be completed by
3. Along the top is a list of importance, as there is always a certain amount of time and resource which can be applied, importance allows for phases. T1 = must be completed within milestone, T2 = within 1 month of milestone, T3 = within 2 months etc.
4. Above the importance is a list of generic tests that must be completed. These are mark against the component with an "R", R = required.
Is is possible to apply a filter which allows the "Milestone" and "Importance" to both be filtered at the same time. Thus allowing us to see orelevant details.
Bookmarks