RAG Indicators
RAG stands for Red, Amber and Green. RAG indicators visually indicate the health of projects or tasks with respect to schedule and cost.
Celoxis automatically calculates the RAG indicators for projects and tasks regularly if the project's is in the Execution stage. Otherwise, the RAG indicator is shown as Not Active.
Schedule RAG Indicators
For every project and task, Celoxis automatically calculates its projected finish date based on the current rate of progress once a day. It is the date on which the project or task is likely to finish based on the current rate of progress.
For example, say a task was scheduled to complete in 4 days and after 2 days it is only 25% complete. Celoxis will calculate the projected finish date of the task to be the 8th day instead of the original 4th.
For a project or summary task, its projected finish date is the maximum of the projected finish dates of its leaf-level tasks.
RAG indicators are assigned as follows:
Off Track | The planned finish date is in the past. |
At Risk | The projected finish date is after the planned finish date. |
On Track | The projected finish date is on or before the planned finish date. |
Completed | Task is 100% complete |
Blocked | Task is scheduled to start but not all its predecessors are complete. |
Future | Task is scheduled to start in the future. |
Not Active | Project's state is not in the Execution stage |
Cost RAG Indicators
For every project and task, Celoxis automatically calculates its projected cost based on the current rate of spend once a day. It is the cost the project or task is likely to incur based on the current rate of spend.
For example, say a task's budget is $1000 and it is 25% complete with an actual cost of $200. Celoxis will calculate the projected cost of the task to be the $800 instead of $1000.
For a project or summary task, its projected cost is the sum of the projected cost of all its leaf-level tasks.
RAG indicators are assigned as follows:
Off Track | Actual cost has exceeded the budget. |
At Risk | Projected cost exceeds the budget. |
On Track | Projected cost does not exceed the budget. |
Not Active | Project's state is not in the Execution stage. |
If a project's Always assume this project is on time and budget. option is checked, then its and its tasks' RAG status will always be shown as On Track
To edit this option, go to the project's edit screen: and click on the Advanced tab.
Calculation of Projections
Calculating projections is a resource intensive operation hence it is infeasible for the system to maintain RAG indicators in real-time.
Celoxis calculates projections once a day on a best effort basis. However, you can ask the system to recalculate projections for a project anytime using ▸ Recalculate Projections. You can even recalculate projections for multiple projects using Project Bulk Actions ▸ Recalculate Projections from your project list view.