Meeting desired Targets

[Shweta Srivastava]

Hi there,

Please help me with the following issue.

I maintain a worksheet which aims to achieve customer satisfaction rate to
be 4.65


For example:

Total Total Customer Satisfaction
Target for
Score Responses (CSAT) rate (CSAT=4.65)
706 153 4.61 (706/153) ? fig. required to be 4.65
192 44 4.36 (192/44) ? fig. required to be 4.65
359 85 4.22 (359/85) ? fig. required to be 4.65
500 250 2.00 (500/250) ? fig. required to be 4.65
500 120 4.17 (500/120) ? fig. required to be 4.65


What function/formula can give me the figures to achieve the above mentioned
CSAT Target to 4.65?


Regards,
Shweta

 

[eksh]

Hi Shweta,

Do you mean the additional score with that amount of responses in order to
achieve CSAT = 4.65?
Then it will be 4.65*response - score.
let say A1 = 706 (score), B1 = 153 (response), your formula should be
"=4.65*B1-A1 & " fig. required to be 4.65"

 

[joel]

I assume you want the score of 4.65 based on the number of responses
received. this is simply 4.65 * 2nd column number

153 711.45
44 204.6
85 395.25
250 1162.5
120 558