Fantasy Football Scoring System

[joeyroland]

Hello everyone,

I am new to programming, creating webs, etc.

Basically I know MS Office and the general info needed start a PC and keep it running smoothly w/ new hardware & software. From a scale of 1-10 in regards to programming and the like, I would consider myself a 2 b/c I know there is such a thing and can use Frontpage fairly easy.

That's about it.

Anyway, my buddies and I have a keeper fantasy football league. It's pretty in depth and what not. But, for scoring, because there are now 12 teams in the league, we have chosen to allow ESPN do our scoring for us. The problem is that we do not always meet ESPN's validation rules and thus our stuff, (i.e. rosters) isn't as up to date as we would like it according to ESPN. However, on our league's website, (real crappy), we have all the rosters up to date but not the scoring.

My question [finally], is there some type of program that we can develope to allow us to see real-time stats throughout a game without having to keep paying ESPN to just score for us?

ESPN is currently charging 120 bucks / year for scoring in accordance with our rules.

I guess the criteria would ideally be:
1. Free (not including all the labor to put in)
2. Able to score according w/ our validation guidelines
3. As similar to ESPN's features as possible - just allowing us the oppurtunity to manipulate our rosters on their site as mush as we want.

Please talk down to me! THough I am really not educated on this stuff, I am VERY willing to learn!

Thanks!

Novel Over;)

[kpm547]

there is definetely a way to accomplish this. Either ASP or php and adatabase would do what you need. the programming for it could be fairly in depth. It all depends on how much information is required to be stored and how it will be updated and displayed. An example of what is being used now would help out.

[joeyroland]

Well, right now, as mentioned, ESPN is doing the scoring, but we have to go back and forth between their site and our own to get accurate scoring AND accurate rosters.

Our Point System is a little different from most. ESPN is the only one who would allow us to do our own scoring system for substantially less than everyone else.

Okay, that's cool, but as far as a database, I guess we would need to know not only all twelve team's rosters, (27 apiece), but also need to know the starting lineup and have the ability to score in our "custom" way - preferrebly in real time.

So, to get back to what you are asking for, I don't really know what "system" we use currently - just ESPN's format or whatever.

Sorry to be so generic. Like I said, I am really not good at this stuff.......yet!:p

Thanks!


EDIT: After some thought, is there a way we can have a database showing what each player has done to that point? In other words, what if I could take Tom Brady's stats up to a certain point in the game and then run some sort of query to input in our "scoring calculator" his numbers from that database?
Make more sense?

[kpm547]

Pretty much, anything can be done. I really don't have an idea of how a fantasy football league works though. So if you could give me an example of how it's being done now (show me your site and ESPN) site then I could get an idea of what is involved. By the sounds of it, this would not be a small program. But it is definetely possible with time.

[joeyroland]

Thanks for the continued help!!!!

Our site is here (http://footballinmd.bravepages.com/)

Also, with ESPN, you need a password and all that jazz. I myself don't even have one - yet. I will as soon as we renew our membership.

What we do is this:
Each team, going head to head versus another,

Starts:
1 Quarterback
1 Running Back
2 Wide Receivers
1 Tight End
1 Running back/wide receiver/ tight end, (coaches decide)

2 Defensive Linemen
2 Linebackers
2 Defensive Backs
1 Kicker

Our scoring system is:
Passing:
20 yards = 1 point Touchdown = 6 Interception = -4
Rushing:
10 yards = 1 point Touchdown = 6 Fumble Lost = -4
Receiving:
10 yards = 1 point Touchdown = 6 Fumble Lost = -4
Defense:
Sack/ Interception/ Forced Fumble/ Defensive Touchdown=6
1 Tackle = 1 point
2 Tackle = 2
3 Tackle = 4
4 Tackle = 5
5 Tackle = 7 and so on....
Kickers:
Field Goals = 3 Extra Points = 1 Missed XP = -4

Like I said, I know this may be a bit involved, but if I "shadowed" the scoring system for this upcoming year, ( that way I can reconcile to something), then maybe I can save the league that money for years to come.

Thanks again!

:D

[DocEvi1]

writing the code to do that isn't difficult, getting the results of the game into the computer is. thats why ESPN charge you.

My advice, you pays your monies for the service you recieve...

[joeyroland]

Well, if there was some way I could get a break down of what every person in the NFL did on a particular day, I can import it into a table and run some Macros or whatever to search for a player and enter his breakdown into a scoring calculator.

Though we may not have real-time updates, who cares for the money we would save?

Any ideas on getting a breakdown?

[bahama llama]

Hi,
I too am in a fantasy football league and I could not find an easy way to capture up to the minute stats. What I ultimately did was to create a scoring sheet in Excel for each position based on scoring, ie. running backs, recievers, and tight ends recieve the same scoring, so I created one mathmetical formula that would calculate the stats I entered manually from the NFL.com Web site. It isn't the best way but it works, and the cost is nothing. I believe too that you can export a spreadsheet from Excel as a Web page and use this for your Web site. I would recommend starting to learn ASP or PHP or something, so that you can incorporate a database to store your rosters and your weekly lineups. Just a thought. I plan on fully implementing something like this for next season, right now I just have different pieces, and a big mess. IF I get it up I will try and post a URL.
Hope this helps some.
Don.:t

[joeyroland]

Hey Don,

Are you manually getting the figures and then entering them into the formula?

I was thinking about recording a Macro where I get online, search ESPN or NFL.com and then put the input in and let the formula do the rest.

I was thinking that perhaps I could do a macros for each position.

Feasable?

[bahama llama]

Yep, I was doing it manually. As far as the macros go, I don't know much about them for getting Web content. Just about anything is possible though with enough time and effort.
Don.

[joeyroland]

True! And between now and the start of the 2005 season, I guess, in the words of the Stones, Time is on my side.

Well, should I get some huge breakthrough, I will post back!