Hi All we are running an engagement for a large client, who have requested we run with a 10 point RAG tracker system. We have built this in excel, using 10 areas as our overall deliverables/milestones. Each of the 10 then areas has detail behind them (additional rows of text) in the next column, totalling 56 lines. Client is complaining that we are not running with a 10 point but a 57 point RAG tracker. However, if we delete the detail column, the 10 points become meaningless, as too high level. Any suggestions ? Saving Changes...
Sort By:
Ahmed FathySenior Manager, Enterprise Project Management Office| Department of Education, Northern Territory GovernmentDarwin, Northern Territory, Australia
Hi Jeanette,
I think it would be helpful to attach the excel sheet as it is quite vague to me at least to give a suggesiton.
However with this very high level description it may suugest that the details is either used in a formula or causing the same line to get repeated several times it seems.
Hope that may be helpful
Thanks
Ahmed Saving Changes...
PAOLINO MONTANINOExecutive, Head of European ERP Business Application| AVANADERome, Italy, Italy
Hello Jeanette,
based on your description I believe this is an high level / executive view of the project status.
I would suggest you create a dashboard containing this 10 points that you can rate Red/Amber/Green:
1) Scope Status
2) Schedule Status
3) Next Milestone Status
4) Product Status
5) Quality of the deliverables
6) Staffing Status
7) Open Risk Status (you can define a metric based on the number of risks open and their probability/impact)
8) Open Issues: you can define a metric based on the number of high severity issues open
9) Customer Performance
10) Budget status
You can create an excel spreadsheet with just 10 line: first column the topic you measure, second column the rating (RAG) and 3rd column a comment (so that you can add what you want).
Saving Changes...
James BrackenSenior Director| NTT DATA Services Plano, Tx, United States
I know this is an old post, but I would be interested in seeing how companies weight each of the 10 metrics (in this example) that make up the overall status. A RAG indicator on each of the 10 makes sense, but at the overall level would you weight each the same? Likely not. Saving Changes...
