Dream Team Help
Posted: Mon Aug 18, 2008 9:15 am
Hey guys,
not sure if this is the right place to put this question, please move to the right place if needed.
Anyway to get down to the question, some of my friends have a dream team fantasy football league. We use the points and scoring from dreamteamfc.com. Currently my friend who's running it sends a email out to us all. We pick our teams from the list of players from the sun dream team fc then email him back. He then enters all the teams and players into a excel spreadsheet and sets up a formula that copies from a sheet with all the points that he updates from a newspaper. Takes a while to setup.
Anyway I thought this was madness especially as our league gets bigger. Currently 22 of us but its going to involve a lot more work as more people join in. For example my cousin does the same thing and theres 100+ of them. Some poor sod has to setup the initial formula's for 100+ teams with 11 players in each. That's 1000+ formulas he has to setup
Not to mention when the transfer periods opens up which involves them storing data and then moving in each teams transfer changes.
Anyway I figured there would be a easier way of doing this. My thinking was once or twice a week I could copy and paste the data for goalkeepers, defenders, midfielder and strikers (http://www.dreamteamfc.com/fantasyfootb ... .aspx?pp=1) into excel then convert that to mysql database or which ever database would be easier, can php copy direct from excel?
Then setup something for each person taking part to select his team from the database. This would then be put into a table to show his points and scores. Then also a global ladder to show how he's doing in comparison to everyone else. At the moment this is all done in Excel. Would make it so much easier if I can automate it somewhat.
Would also need a way that come transfer period there 2 or three through the year that they can swap 3 three players if they wish. Meaning upto 3 players they removed would need to have there points stored and then extract the info for there 3 new players coming in. Bare in mind they can only have points from the point they start using the players. I guess this could be done by taking away the points point upto said date on the total amount of points he has so far.
considering how popular the sun dream team is and how many people do there own mini leagues I thought someone may have already set something up but I couldn't find anything.
anyway if someone can provide me with some help/tips and point me in the right direction. I've not really done anything like this before. I guess the first step will be to build the database and setup something so people can register there own teams.
Thanks in advance.
not sure if this is the right place to put this question, please move to the right place if needed.
Anyway to get down to the question, some of my friends have a dream team fantasy football league. We use the points and scoring from dreamteamfc.com. Currently my friend who's running it sends a email out to us all. We pick our teams from the list of players from the sun dream team fc then email him back. He then enters all the teams and players into a excel spreadsheet and sets up a formula that copies from a sheet with all the points that he updates from a newspaper. Takes a while to setup.
Anyway I thought this was madness especially as our league gets bigger. Currently 22 of us but its going to involve a lot more work as more people join in. For example my cousin does the same thing and theres 100+ of them. Some poor sod has to setup the initial formula's for 100+ teams with 11 players in each. That's 1000+ formulas he has to setup
Anyway I figured there would be a easier way of doing this. My thinking was once or twice a week I could copy and paste the data for goalkeepers, defenders, midfielder and strikers (http://www.dreamteamfc.com/fantasyfootb ... .aspx?pp=1) into excel then convert that to mysql database or which ever database would be easier, can php copy direct from excel?
Then setup something for each person taking part to select his team from the database. This would then be put into a table to show his points and scores. Then also a global ladder to show how he's doing in comparison to everyone else. At the moment this is all done in Excel. Would make it so much easier if I can automate it somewhat.
Would also need a way that come transfer period there 2 or three through the year that they can swap 3 three players if they wish. Meaning upto 3 players they removed would need to have there points stored and then extract the info for there 3 new players coming in. Bare in mind they can only have points from the point they start using the players. I guess this could be done by taking away the points point upto said date on the total amount of points he has so far.
considering how popular the sun dream team is and how many people do there own mini leagues I thought someone may have already set something up but I couldn't find anything.
anyway if someone can provide me with some help/tips and point me in the right direction. I've not really done anything like this before. I guess the first step will be to build the database and setup something so people can register there own teams.
Thanks in advance.