Any ideas, please

[cfer]

In the following spread sheet, column C = names, D = Target acheivement, E = Leg compliance, F = Trains.

I want to be able to have the names a true represetation in order.

Hope I can make sense.

If column F has 2 trains, column E represents how many Leg Compliance were returned, as in this case 2, giving 100%.
Column D represents if the trains both equalled the target, it would mean 100% acheivement.

Columd D can show 100% because there were 2 trains, only 1 was entered, giving a result of 100%.

It really does not give a true result.

Can any suggest a formula to acheive this.

Thanks in anticipation.
Cfer

Excel Workbook
	C	D	E	F
3	Name	TARGET ACHIEVEMENT	LEG COMPLIANCE	TRAINS
4	A1	100%	100%	2
5	A2	100%	100%	2
6	A3	100%	100%	1
7	A4	100%	100%	1
8	A5	100%	100%	1
9	A6	100%	100%	1
10	A7	100%	83%	5
11	A8	100%	50%	2
12	A9	100%	50%	2
13	A10	100%	50%	2
14	A11	100%	50%	1
15	A12	100%	50%	1
16	A13	100%	33%	1
17	A14	100%	33%	1
18	A15	100%	33%	1
19	A16	100%	33%	1
20	A17	100%	33%	1
21	A18	89%	64%	9
22	A19	88%	100%	8
23	A20	86%	88%	7
24	A21	83%	75%	6
25	A22	83%	75%	6
26	A23	83%	67%	6
27	A24	79%	100%	14
28	A25	75%	100%	8
29	A26	75%	89%	8
30	A27	71%	100%	7
31	A28	71%	88%	7
32	A29	70%	100%	10
33	A30	70%	100%	10
34	A31	67%	100%	6
35	A32	67%	100%	6
36	A33	63%	80%	8
37	A34	57%	70%	7
38	A35	56%	100%	9
39	A36	56%	82%	9
40	A37	50%	100%	10
41	A38	50%	100%	2
42	A39	50%	100%	2
43	A40	50%	100%	2
44	A41	50%	100%	2
45	A42	50%	83%	10
46	A43	50%	75%	6
47	A44	50%	73%	8
48	A45	50%	73%	8
49	A46	50%	50%	2
50	A47	50%	50%	2
51	A48	42%	92%	12
52	A49	40%	100%	5
53	A50	40%	77%	10
54	A51	40%	63%	5
55	A52	38%	80%	8
56	A53	38%	67%	8
57	A54	33%	100%	9
58	A55	33%	75%	6
59	A56	33%	60%	3
60	A57	30%	83%	10
61	A58	25%	100%	4
62	A59	25%	50%	4
63	A60	20%	83%	5
64	A61	17%	100%	6
65	A62	17%	86%	6
66	A63	14%	78%	7
67	A64	0%	100%	2
68	A65	0%	100%	1
69	A66	0%	100%	1
Sheet1

 

[Gerald Higgins]

I've read and re-read this and I just can't work out what you want.

Can you explain it really clearly please ?

 

[cfer]

Hi Gerald,

The figures above, do not represent a true picture of the top peformers. ie coloum D.

Coloum A will have actual names.


it is a bit confusing, the result I am looking for,

Column F represents the required returns by each individual.

If a person puts in 1 return (F), and only required to put in 1 return, then he has a 100% compliance,
If the data supplied meets the target, it is 100%

If he only puts in 1 return, but should have put in 2 returns, it means that he has 50% compliance (E), but if that one return equals the target he still gets 100% acheivement (D)

In essence they both acheived 100% acheivement (D).

Because these figures are over a month, some people will put in more returns than others, becuase a person puts 1 in, he can get 100%, but because some puts in more returns, the % will drop.

If I can weight the results to show the target acheivment, in ranking order.

Hope tis make sense.

Thanks again.

 

[Gerald Higgins]

Hope tis make sense.

Not to me, sorry, I just don't understand what you want.

Can you try explaining with a small sample of maybe one or two people, showing possible data for each one, exactly what you want the result to be for each one, and how you arrive at the result for each one ?

 

[cfer]

Hi Gerald,

Thanks for trying to understand what I am trying to do.

The issue I have is that if 1 person puts in only 1 return, and acheives the target, he will get 100%.

If another person puts in 3 returns, but should have put in 6 returns, if the 3 returns reach the target, he also will get 100%.

In each case they had a 100% return. As these figures are over a month, some will have less returns to submit than others, but some will not return the required number allocatted to them.

I am looking, I suppose you could say, a rating system.

If you have 100% for both acheivements and 100% for legs then you would be number 1

The list then goes down a sliding scale.

Thanks

Cfer

 

[Gerald Higgins]

I'll ask the question again

Can you try explaining with a small sample of maybe one or two people, showing possible data for each one, exactly what you want the result to be for each one, and how you arrive at the result for each one ?