Actual Hours
In short, this code assigns different colours based on the percentage difference in staffed hours.
If the percentage is negative, it’s red
If it's between 0 and 5, it's orange
If it's between 5 and 20, it's green
If it's 20 or more, it turns back to orange, as you are potentially overstaffed. There is never a red range for being over
Actual Skilled Hours
Colours are assigned based on the percentage difference of skilled staff hours compared to the skilled needs.
If the percentage is negative, it’s red
If it's between 0 and 5, it's orange
If it's between 5 and 20, it's green
If it's 20 or more, it turns back to orange, as you are potentially over-skilled. There is never a red range for being over