Under achievement Index

[Darren]

The whole issue of whether or not United are the greatest under acheivers in the last 30 odd years intrigued me so much that I thought i would do a bit of work on it. So....

What I have done is worked out the average average attendance for each club that has been in the top division since 1976 and compared that attendance to the number of years they have had in the top division and how often they have won or been runners up in major competitions

Colu,m A shows the attendance rank
Column B is the name of the club.
Column C shows the average avearge attendance 1976-2009
Column D shows the number of years in the top division 1976-2010
Column E shows the ranking for number of years in the top division
Column F shows the number of times the club has won or been runners up in a major competition 1976-2009
Column G shows the ranking for Column F
Column H is A-E
Column I is A-G
Column J is H+I

Basically the last column is the money column - the higher the figure the more the over achiever, the lower figure the greater the under acheivement (using attendances to indicate level of resources)

The upshot is that United (jointly with Derby) are indeed the biggest under acheivers with Wimbledon and Wigan the greatest over acheivers.


A B C D E F G H I J

1 Man Utd 52, 505 34 1 40 2 0 -1 -1
2 Liverpool 40,091 34 1 42 1 +1 +1 +2
3 Arsenal 36,019 34 1 28 3 +2 0 +2
4 Newcastle 33,594 27 8 4 10 -4 -6 -10
5 Leeds 31,792 20 14 2 17 -9 -12 -21
6 Man City 31,760 25 11 2 17 -5 -11 -16
7 Everton 31,280 34 1 12 5 +6 +2 +8
8 Tottenham 31,204 33 5 10 7 +3 +1 +4
9 A. Villa 30,246 33 5 8 8 +4 +1 +5
10 Chelsea 27,619 27 8 17 4 +2 +6 +8
11 Sunderland 26,291 16 17 2 17 -6 -6 -12
12 West Ham 25,120 28 7 3 12 +5 0 +5
13 Sheff Wed 22,173 15 20 3 12 -7 +1 -6
14 N. Forest 21,986 20 14 11 6 0 +8 +8
15 Middlesboro' 21,142 21 13 5 9 +2 +6 +8
16 Derby 20, 441 15 20 0 36 -4 -20 -24
17 Wolves 19,367 8 33 1 24 -16 -7 -23
18 Southampton 19,254 27 8 3 12 +10 +6 +16
19 Ipswich 18,907 15 20 4 10 -1 +9 +8
20 Birmingham 18,139 14 25 1 24 -5 -4 -9
21 WBA 18,014 15 20 0 36 +1 -15 -14
22 Leicester 17,999 15 20 3 12 +2 +10 +12
23 Norwich 17,927 18 16 1 24 +7 -1 +6
24 Sheff Utd 17,092 5 36 0 36 -12 -12 -24
25 Coventry 16,992 25 11 1 24 +14 +1 +15
26 Blackburn 16,244 16 17 3 12 +9 +14 +23
27 C. Palace 15.890 9 30 1 24 -3 +3 0
28 Bolton 15,041 14 25 2 17 +3 +11 + 14
29 Stoke 14,446 9 30 0 36 -1 -7 -8
30 QPR 13,908 16 17 2 17 +13 +13 +26
31 Portsmouth 13,675 8 33 1 24 -2 +7 +5
32 Charlton 13,605 12 28 0 36 +4 -4 0
33 Watford 13,266 8 33 2 17 0 +16 +16
34 Bristol C 11,843 4 38 0 36 -4 -2 -6
35 Fulham 10,563 9 30 0 36 +5 -1 +4
36 Barnsley 10,215 1 48 0 36 -12 0 -12
37 Brighton 10.039 4 38 1 24 +1 +13 +14
38 Hull 9,899 2 43 0 36 +5 +2 +7
39 Burnley 9, 962 1 48 0 36 -9 +3 -6
40 Reading 9,587 2 43 0 36 -3 +4 +1
41 Bradford 9,160 2 43 0 36 -2 +5 +3
42 Luton 8,666 10 29 2 17 +13 +25 +38
43 Millwall 8,461 2 43 1 24 0 +19 +19
44 Wimbledon 7,694 14 25 1 24 +19 +20 +39
45 Swindon 7,691 1 48 0 36 -3 +9 +6
46 Oldham 7,487 3 41 1 24 +5 +22 +27
47 Swansea 7,150 2 43 0 36 +4 +11 +15
48 Notts Co. 6,980 4 38 0 36 +10 +12 +22
49 Wigan 6,548 5 36 1 24 +13 +25 +38
50 Oxford 6,372 3 41 1 24 +9 +26 +35

 

[BornOnShorehamStreet]

"The whole issue of whether or not United are the greatest under acheivers in the last 30 odd years intrigued me so much that I thought i would do a bit of work on it"

Yer sad beggar!

:blink:

Having said that, what an awesome piece of work. Actually I'm surprised it doesn't show us even more under-achieving than that!

Mind you, after 50 years of watching them......

:bomb:

 

[Grecian2000]

To be fair to Derby, their attendance will have been boosted, in the early years of your survey, by the fact they were Champions twice in the decade previous to your starting point.

I think we can proudly say we have under acheived for longer than anyone.

 

[raul]

Dazzler, that is a real effort there. How you find time for any other activities i'll never know..

Only gripe is, as a Skype user, half of the stats have morphed into a phone number. So if I click on LIverpool I end up phoning some old dear in Newcastle for some reason. Any chance of spacing out a bit more so I can fully appreciate your work?


Edit - It's ok, I've sorted it

 

[Darren]

Dazzler, that is a real effort there. How you find time for any other activities i'll never know..

Only gripe is, as a Skype user, half of the stats have morphed into a phone number. So if I click on LIverpool I end up phoning some old dear in Newcastle for some reason. Any chance of spacing out a bit more so I can fully appreciate your work?


Edit - It's ok, I've sorted it

I tried to space it out and it ended up like that. If the mods want to set the table out in a more user friendly way, they should feel free to!

 

[Jim Chimmerney]

Blimey Dazzler, no wonder there's so much crime on the streets !!

This is heavily biaised towards crowds, the problem being, what if a large part of the revenue from the crowds wasn't pumped back into the team.

Just one question, how can column I be I - A ?

 

[SwissBlade]

Cracking bit of work Darren, I think you've topped me on the "nowt better to do" league table!

 

[Darren]

Blimey Dazzler, no wonder there's so much crime on the streets !!

This is heavily biaised towards crowds, the problem being, what if a large part of the revenue from the crowds wasn't pumped back into the team.

Just one question, how can column I be I - A ?

We don't know the money was pumped back into the team, but I think crowd size is a good rough and ready index to resource size.

Error corrected!

 

[davidpinder]

Theres a job for you at 10 downing street there not very good with numbers

 

[Jim Chimmerney]

We don't know the money was pumped back into the team, but I think crowd size is a good rough and ready index to resource size.

Error corrected!

Yep, a reasonable yardstick if not totally reliable.

Right, now it needs expanding back to 1880 to get the true overall picture, off you go :thumbup:

 

[Highbury_Blade]

Cracking bit of work Darren, I think you've topped me on the "nowt better to do" league table!

I think we can use this as cast iron evidence that the country is NOT been overrun by Asylum seekers.

 

[Darren]

I think we can use this as cast iron evidence that the country is NOT been overrun by Asylum seekers.

In my defence:

a. I did do all the adding up and subtracting outside work hours
b. I don't act for asylum seekers anyway!

 

[Highbury_Blade]

In my defence:

a. I did do all the adding up and subtracting outside work hours
b. I don't act for asylum seekers anyway!

Hey i thought you'd have much more fun activities to do outside of work.

 

[Darren]

Hey i thought you'd have much more fun activities to do outside of work.

I do. But I multi task. Whip in one hand, calculator in the other; they don't call me the rennaisance man of N8 for nothing....

 

[FlyingFjortoft]

excellent work
my one gripe is the year you started from
if you start from the year it went wrong for united, its bound to skew us way up the table...

 

[beightonblade]

Under achievement ............

now thats not fair .... everybody try's their best.

 

[Sothall_Blade]

"My one gripe is the year you started from. If you start from the year it went wrong for united, its bound to skew us way up the table..."

It's a fair point but if you took it back another 10 years who would we overtake? Our main rivals Derby and Leeds were winning titles in the early-mid 70's. Wolves and Man City were also consistently above us.

It's fair to say that in most of our lifetimes, nobody can touch the Blades when it's comes to being crap.

 

[beightonblade]

I thought we were onto sumat good when we were top of the owd 1st Division ............ then we played manure at owd trafford ......red hot day lots of Blades got there late and didn't get in.....our mob was on the Stretford End an saw owd Bestie score..... mind yer if whats his name wern't injured he'd have chopped him down......

 

[mattco2001]

ive posted this link on the forum before. very interesting read. its says that the biggest underacheivers are the piggies followed by wolves, forest, coventry and man city.
this was done last year so may have changed slightly. have a look...

not to take anything away from your work though darren!

http://community.footballpools.com/football-reports/achievers/biggest-achievers-and-underachievers

 

[Darren]

"My one gripe is the year you started from. If you start from the year it went wrong for united, its bound to skew us way up the table..."

It's a fair point but if you took it back another 10 years who would we overtake? Our main rivals Derby and Leeds were winning titles in the early-mid 70's. Wolves and Man City were also consistently above us.

It's fair to say that in most of our lifetimes, nobody can touch the Blades when it's comes to being crap.

Also, as our average attendance from 66-76 was fairly consistently over 20,000, we would probably move up the average attendance table as well.

 

[Jim Chimmerney]

Also, as our average attendance from 66-76 was fairly consistently over 20,000, we would probably move up the average attendance table as well.

Never mind all this 'probably', 1880 onwards, off you go

 

[Darren]

Never mind all this 'probably', 1880 onwards, off you go

Someone else can pick up the baton. I have a hot date tonight with a large breasted young lady, a goat and a tub of marmite

 

[Jim Chimmerney]

Someone else can pick up the baton. I have a hot date tonight with a large breasted young lady, a goat and a tub of marmite

Those of us from a previous site know you're not joking

 

[Vistoma]

Someone else can pick up the baton. I have a hot date tonight with a large breasted young lady, a goat and a tub of marmite

Marmite...you sicko

 

[Mary Christmas]

Under achievement ............

now thats not fair .... everybody try's their best.

“Trying is the first step to failure” Homer

I thought we were onto sumat good when we were top of the owd 1st Division ............ then we played manure at owd trafford ......red hot day lots of Blades got there late and didn't get in.....our mob was on the Stretford End an saw owd Bestie score..... mind yer if whats his name wern't injured he'd have chopped him down......

And I still think Stuart Scullion was the man of the match