Compared with last season...

All advertisments are hidden for logged in members, why not log in/register?

Just to support grafikhaus , I've done a little thing to compare the League winners over the last 10 seasons. This graph shows highest, lowest, and average points progression through the season for the League One Winners - compared with United so far. May not get it updated every game but will try to keep on top of it!

upload_2015-9-9_15-14-35.png

Just on it:

Highest: Wolves (13) - 2014
Lowest: Scunthorpe (3) - 2007 (managed by whom?)
 

MobileBlade said:
Just to support grafikhaus , I've done a little thing to compare the League winners over the last 10 seasons. This graph shows highest, lowest, and average points progression through the season for the League One Winners - compared with United so far. May not get it updated every game but will try to keep on top of it!

View attachment 13245
Click to expand...

How many previous League winners are you using?
 
MobileBlade said:
Just to support grafikhaus , I've done a little thing to compare the League winners over the last 10 seasons. This graph shows highest, lowest, and average points progression through the season for the League One Winners - compared with United so far. May not get it updated every game but will try to keep on top of it!

View attachment 13245

Just on it:

Highest: Wolves (13) - 2014
Lowest: Scunthorpe (3) - 2007 (managed by whom?)
Click to expand...
Oooooh I do like a graph
 
I've also added a line with the median on as well but it did not update earlier. I will load it tomorrow!

Wolves were 2nd in league after 5 games. Scunthorpe were 22nd.
 
grafikhaus said:
Mobile, Mobile, you'll regret this...







Me too. But as the resident grafologist (Creating graphs and other United-related shite since 2012), I'm sulking...:(

Oh, and where are the major gridlines on the x-axis?

And the axis labels? :D
Click to expand...
Fuck off :)

PS - I can send you the data and you can do if you wish :)
 
OK. UNITED ARE NOW IN RED AND GRIDLINES ARE IN PLACE. ANYTHING ELSE :)

upload_2015-9-14_10-24-29.png

High: Wolverhampton Wanderers (2014)
Low: Scunthorpe (2007)
 

grafikhaus said:
Axis labels? United are '12'. 12 what? Apples, pears, Syrian migrants? :D



92 points. :)
Click to expand...

Why would we want to talk about Syrian migrants or even the Labour leadership contest on a United messageboard? Oh. Ok. Labels it is:

upload_2015-9-14_13-33-1.png

Separate note, do you know anything about calculation with Access. What I am after is simples in Excel but can I hell get it to work in Access?
 
MobileBlade said:
Separate note, do you know anything about calculation with Access. What I am after is simples in Excel but can I hell get it to work in Access?
Click to expand...

What are you wanting to calculate in Access?

Also, I think you said earlier that you're colour blind? The 'Median' (dark blue) and 'Low' (black) are too similar. Have you thought of using dashed/dotted lines?

lines.jpg
 
Last edited:
grafikhaus said:
What are you wanting to calculate in Access?
Click to expand...

To try and keep it simple but here goes. It is to do with attrition rates.

So, if we have had say 3 divisions and each division has 3 cost centres and I am trying to find out the attrition rate for each division over, say, a 3 month period. The calculation would be the total leavers divided the average number of employees for the period as a percentage.

To use some figures see this chart with some sample figures

upload_2015-9-14_13-57-47.png

I have put together a query and a report that will give the cost centre figures fine. However, for the divisions it giving me the total entries when I put in the sum (ie 4771 in this example) and when I ask for the average it is dividing it by the number of entries and totalling the average for each cost centre (if that makes sense) (ie 523.44)

Hope this makes sense but am banging me head against a wall now!!
 

Attachments

  • upload_2015-9-14_13-56-2.png
    upload_2015-9-14_13-56-2.png
    13.1 KB · Views: 1
grafikhaus said:
You've got me there, Mobile. But isn't this something you could do in Excel?
Click to expand...
It is but the advantage of Access is that it is easier to pull reports to cover specific variables. It is much easier and friendly then using filter or other combinations. The database covers much more as well so if it was just this one calculation then yes potentially Excel but there is the issue of importing and pulling the relevant data. Access is better for this - if only I could figure out how to work that formula!
 
MobileBlade said:
It's a long, long, long time since I was at school but isn't it the same thing?
Click to expand...
Depends how pedantic you're (I'm) being :)

Average is a general term for mean (sum/number), median (middle value), mode (most frequent number) and other similar statistical measures, but it's also commonly used (including in Excel!) to indicate the mean.

Wasn't a serious point anyway, just thought I'd have a poke as you were being inundated with requests ;)
 
Punk Blade said:
Depends how pedantic you're (I'm) being :)

Average is a general term for mean (sum/number), median (middle value), mode (most frequent number) and other similar statistical measures, but it's also commonly used (including in Excel!) to indicate the mean.

Wasn't a serious point anyway, just thought I'd have a poke as you were being inundated with requests ;)
Click to expand...
Yeah I know, I was just trying to be pedantic back. Doesn't help my access query though :)
 
MobileBlade I think you'll need to create a step query to calculate your averages:

Table 1 -
Query 1 (simple select query)
Calculate average [mean] number of employees using the Sum->Avg function
Calculate total number of leavers per cost centre using the Sum function

Query 2
Use the results from Query 1 to calculate your attrition

Happy to expand if you want but my new work laptop doesn't have access so I can't mock this up (sorry!).
 

Balham Blade said:
MobileBlade I think you'll need to create a step query to calculate your averages:

Table 1 -
Query 1 (simple select query)
Calculate average [mean] number of employees using the Sum->Avg function
Calculate total number of leavers per cost centre using the Sum function

Query 2
Use the results from Query 1 to calculate your attrition

Happy to expand if you want but my new work laptop doesn't have access so I can't mock this up (sorry!).
Click to expand...
Thanks Balham. I will try it!
 
You must log in or register to reply here.

Similar threads

ucandomagic
Matchday 35 Missing Graphs - By Request!
Replies
7
Views
609
blade too long
blade too long
ucandomagic
Some Graphs for New Seasons!
Replies
13
Views
1K
ThirdGenBlade
T
Isaw Joeshaw
Most impressive opposition players last season .
2
Replies
44
Views
3K
Groucho Blade
Groucho Blade
ucandomagic
Matchdays 43 & 44: A 2-Chapter Easter Weekend. Not with a Bang…
Replies
2
Views
347
ThirdGenBlade
T
ucandomagic
Matchday 46 Final Graphs, Charts and Playoff Preview: Blackburn Stalemate, Robins Next & No Wilder Record
Replies
3
Views
578
ThirdGenBlade
T

All advertisments are hidden for logged in members, why not log in/register?

All advertisments are hidden for logged in members, why not log in/register?

Back
Top Bottom