Sorting a football/soccer league table

thanks again to JBeaucaire's who got the zero points with no results in great help all need now folks is the how I sort the leauge tables so that those with higher points goes top of the table here again is the link all help very much appreciated

Thanks

Yes your help in this matter would be greatly appreciated I have spent a few hours filling in some of the fixtures upto the end of october and I am still adding I have also had a little go at creating an automatic ranking of league but to no avail here is the link for what I have done so far thanks very much again JBeaucaire

Thank You

Lee

ok sorry the idea is to have the TABLE sheet basically filled in with the amount of games played games won games drawn games lost goals for and against goal diffrence and finally points 3 points for a win 1 for a draw and 0 points for a lose

so when I fill in the score into sheet FIXTURES cells $E4 & $F4 automatically the data gets transfered to the TABLE sheet the only cells that need any input would be the FIXTURE sheet cells E4 & F4 right down to however many fixtures there will be I hope Im making sense,

Ive mocked the premier league result in the FIXTURES sheets and mocked what the values would be in the TABLE sheet however the TABLE sheet should automatically have the TEAMS with 3 points at the top of the table with the better GD (goal difference) being more goals scored the conceved above the team with equal points hope this helps and thanks very much for your time and patience I believe once the Premier Leauge is done I should be able to work the rest out myself (fingers crossed) Thanks very much again

yes but I also need it so the when I fill in the the scores in the FIXTURES! sheet I would like the table sheet to automatically know how many games have been played how many each team has won (FIXTURES!D4:D23) drawn (FIXTURES!F4:F23) and lost (FIXTURES!E4:E23) also showing the goals scored (FIXTURES!G4:G23) and goals concided (FIXTURES!H4:H23) then once all calculated the team with the most points (FIXTURES!J4:J23)and better goal difference (FIXTURES!I4:I23) that are at the top like what you have done

Thanks ever so much for all your work it is very much appreciated

sorry just noticed that it does do that however if no games are played it registers that 1 game has been played and that they are all draws so YES very nearly there

sorry for last post

and thanks ever so much again

that has worked fine however I will have a closer look later today just to make sure, before I tag it SOLVED can I just copy and paste the formula for the other leagues and 1 more little thing is I could do with a total on the TABLE! sheet in cells P104:P113 or can I just use auto sum even though the previous coloum has a formula in it?

thanks ever so much for all your time after studing it a little I see just a couple of things wrong with it doesn't automatically sort the teams in what should be the correct postion also when I add more scores to the fixture sheet they do not register on the TABLE sheet I have attached a copy of it but I have had to use the sort tool to put them in there correct place is there a way to do this automatically then thanks to you we will have it SOLVED yeah

Thanks very much again can't Thank you enough

Cheers

Ive managed to make the table sheet register all the fixture results however I do have to keep using the sort tool to sort it by column J then I in largest to smallest I was hoping that this would sort it self out automatically then I can call it SOLVED please help

plus can I just copy and paste the premier league formulas for the other leagues or....?

Thanks ever so much again I definetly owe you a few dozen pints

Cheers

Lee

ok I tried filling out some more mock scores but it resulted in errors when I used the sort tool only when I fill in the first games and use the sort tool it does work anyway, with the 1st attachment is before the sort (I can see how your formulas work) but I cannot work out how to sort it like the 2nd attachment which is what I would like the finished version to look like

I am deeply grateful for all your hard work

Cheers

Lee

oops it wasnt until I post and looked and again the sort was wrong on the second link Im just so anxious to get it done sorry anyway here is the way I would prefably like it to be sorted

sorry and thanks again

Hi

Is this what you are after for the football league tables?

This workbook was in preparation before Jerry took up the challenge, and the formulae used is now largely his work, as is usual it is far better than my efforts!

It is by no means a finished job.

There are a few questions to answer

1/. How are points awarded to your players?
Do they have to correctly forecast the score, or are you working a Home win, Away win, and Draw system?
Either way how do you allocate points to them.

2/. Are your games run on a weekly basis, with players entering forecasts for all the fixtures in all of the leagues or can they just enter forecasts in a particular league?

3/. The fixtures in this workbook are the ones published by the FA and begin 07/08/2010
with the premier league starting the following week. What week do you want to start with?

4/. I have not included the internationals at present, do you need them added, and if so how do they fit into your competition?

I have done nothing with the forecast aspect at present, as this will depend on the answers to the above.

My feeling is that this type of game is more usually played on a league basis, with rewards for the winning player in each league, then the results are grouped to give an overall winner.


I hope this is of some help.

Cheers

Hi Marcol

yes indeed very nice job however the prediction scores are rewarded as follows for the correct outcome of a prediction for example aston villa v west ham united was 1 - 0 player 1 correctly predicted and should be awarded 3 points however player 2 predicted a 2-0 win to aston villa so he should be allocated 1 point, hope I made sense in this issue,

the tables are correctly layed out and the fixtures but I only want to be able to pick and choose certain games to predict and calculate is there a way I could have a seperate sheet maybe to fill in the predictions and I would like to know where you sourced the link from and will it be that the fixtures and table be and scores for that matter be totally automatic?

I would prefer to start on the 14/8 as we tend to predict all the premier fixtures during the weekend and 1 team from each of the other championship, leauge 1 and league 2, Internationals are not a must but would be nice to be able to predict a few of them for example England Scotland Wales and the Irish teams just for something to fill in or perhaps if the results have to be manually entered then the international games may give me a little break lol

I would be running this competition at work to start of with and would like to have the prediction game split possibly into 4 so that there can be 4 winners throughout the season if that makes sense

also this is the ultimate would this game do you reckon be of intrest to others to be able to fill in for stakes or even just for fun on the web??

thanks Jerry and Marco for you invaluable input it is very much apprecitated

Cheers

Lee

thanks ever so much for your help in this matter

Lee

I have not added anymore code for the predictions yet, but here's another idea.

on sheet TABLE click on any of the League Titles.

This feature can be put on an index sheet later it is just temporarily triggered from this sheet.

Have fun

lol I like it but that would be better postioned above or below each fixture so once you have filled in the results quick click there and see how the table stands if you know what I mean lol,

I also like to add that I didnt mention before is having in the prediction table either along side the premier league or above and or maybe a quick link as before on the PREDICTION sheet in the same colour format also what would be nicer on the eye is for some kind of formula to show how many games each player has played how many 3 points they have tallied how many 1 points they have tallied and how many 0 points they have done and not sure but maybe some kind of 3 point 1 point goal diffrence just incase total points awarded at the end of each of the 4 rounds results in a draw

so in summary this aint easy to explain but I do hope you know what I mean if I'm not then please tell and I shall try and explain more thouroughly lol

Thanks again Marco and Jerry for all this its awesome