Hi all,
I have a simple spreadsheet that calculates daily performance rates, using the actual daily scores in E3 to I3, divided by the target score in D3, which returns the result in K3 to O3. See below.
However, if the overall schedule is met in less than a week, the day this is met (Thu), the performance rate is reduced as N3 is calculating against the daily target D3.
Is there a way to calculate this percentage so it works out against the remaining balance on that day?
To note, sometimes the final number for the daily score can be over the amount required to fulfil the schedule, so if H3 was >47 N3 would show >100%.
Thank you..
I have a simple spreadsheet that calculates daily performance rates, using the actual daily scores in E3 to I3, divided by the target score in D3, which returns the result in K3 to O3. See below.
However, if the overall schedule is met in less than a week, the day this is met (Thu), the performance rate is reduced as N3 is calculating against the daily target D3.
Is there a way to calculate this percentage so it works out against the remaining balance on that day?
To note, sometimes the final number for the daily score can be over the amount required to fulfil the schedule, so if H3 was >47 N3 would show >100%.
Thank you..