Hi
Can I please ask for a little help regarding solver as I cannot figure how to use it in this scenario.
I have these people and each week their results will update, for example I have filled in wk1 and wk2.
If I have these KRA levels
Is there a way I can have the values in the remaining weeks reflect a Base success and then if selected an Exceeding result and outstanding and so on.
My confusion with solve is that the changing cells wont be changing as new data comes in, how do I achieve this?
Can I please ask for a little help regarding solver as I cannot figure how to use it in this scenario.
I have these people and each week their results will update, for example I have filled in wk1 and wk2.
Code:
Person wk1 wk2 wk3 wk4 wk5 wk6
Bill 48.4 62.3
Mary 71.4 55.3
If I have these KRA levels
Code:
Target Result
Base 60
Exceed 75
Outstanding 88
Is there a way I can have the values in the remaining weeks reflect a Base success and then if selected an Exceeding result and outstanding and so on.
My confusion with solve is that the changing cells wont be changing as new data comes in, how do I achieve this?