sushantrao
Board Regular
- Joined
- Jun 24, 2006
- Messages
- 151
Hi All
In above tabel in ? place i want the that % rate which help me to
achive 90% SLA target.
I want to prepre one tabel in which i know the % rate req for the achivement of SLA. for rest of the month days.
Eg : if I achive 43.33% Average SLA for first 3 days of the month
then what % rate needs to be maintain to achive target SLA for rest of 27 days.& that % rate will automatically come in Req SLA column in the place of ? ? .....
Reagrds,
Sushant
Calculator.xls | ||||||
---|---|---|---|---|---|---|
B | C | D | E | |||
2 | Days | Target SLA | Achived SLA | Req SLA | ||
3 | ||||||
4 | 1 | 90 | 50 | |||
5 | 2 | 90 | 30 | |||
6 | 3 | 90 | 50 | |||
7 | 4 | 90 | ? | |||
8 | 5 | 90 | ? | |||
9 | 6 | 90 | ? | |||
10 | 90 | ? | ||||
11 | 30 | 90 | ? | |||
12 | ||||||
13 | 90 | 43 | ||||
Sheet1 |
In above tabel in ? place i want the that % rate which help me to
achive 90% SLA target.
I want to prepre one tabel in which i know the % rate req for the achivement of SLA. for rest of the month days.
Eg : if I achive 43.33% Average SLA for first 3 days of the month
then what % rate needs to be maintain to achive target SLA for rest of 27 days.& that % rate will automatically come in Req SLA column in the place of ? ? .....
Reagrds,
Sushant