NFL Predictions in Excel Format

I am looking for an excel spreadsheet that will take existing data from previous games, i.e. points scored, points allowed, offensive yards per game, defensive yards allowed, to come up with a yards per point figure both for offense and defense, home figures as well as on the road games. There are many websites that speak of using the YPP formula to make fairly accurate game predictions, but they don't seem to take into account that teams play differently at home as they do on the road. This spreadsheet would also have to have the capability to update itself as new figures become available. Being able to chart this information would also be a big plus. I have an excel spreadsheet started with all of the team names and several stats, but just can't get the math programming to turn out right. (emailed to you upon request)

o.k. so I figured out how to include the existing spreadsheet that I have been working on. To me it is fairly straight forward. It's just tying all of the information together, or getting the separate sheets to talk to each other, share the needed information, and come up with a prediction that makes sense. Hopefully the sheet that I have provided makes sense to you. I have figured out that the home stats and predictions should be different from the away stats, for obvious reasons.
Also, if this helps, I do have other nfl prediction software that uses an array of different figures to come to it's conclusions in which I will provide to you if you should see a need to use bits and pieces of it. I'm not so concerned with straight up predictions as much as I am about the spread and being able to post good results versus that. Over/Under prediction capabilities would be nice as well. No office pool capabilities, please. The Vegas point spread vs what the spreadsheet has calculated, and the anomoly between the two is my greatest concern. Not to mention winning as well.

Skills: Data Entry, Data Mining, Data Processing, Excel

See more: excel spreadsheet nfl, excel nfl predictions, nfl excel format, excel spreadsheet predictions, nfl excel data, nfl excel spreadsheet, using excel nfl, nfl excel, nfl predictions excel chart, road to programming, programming in excel 2013, programming in excel, programming games in c++, programming games for websites, nfl programming, math programming, math in programming, get started with c# programming, get started with c programming, game programming home, defensive programming, big data programming, programming with excel, excel spreadsheet formula, math websites

About the Employer:
( 0 reviews ) Medical Lake, United States

Project ID: #4745607

12 freelancers are bidding on average $163 for this job


Hi, I have gone through your requirement and I am glad that I am best fit in your requirement , Please give me opportunity to work with you. Please check PM . Thanks,

$227 USD in 5 days
(93 Reviews)

I am ready to start this project...

$168 USD in 5 days
(9 Reviews)

Hi stevek99224! Experienced Excel and VBA user. I'm ambitious, hardworking, punctual and really want to perform well. Please check PM and Portfolio to see my skills! :)

$140 USD in 3 days
(7 Reviews)

We will do it as require.

$155 USD in 3 days
(1 Review)

I have done something similar when it comes to calculating stats at my work. I can send over the spreadsheet I created so that you can see what I am talking about. I am very good with excel formulas and having calcul More

$30 USD in 3 days
(0 Reviews)

Please refer to my PM. Thank you for considering my bid.

$250 USD in 3 days
(0 Reviews)

What a great sounding project! Greetings from the United Kingdom! I absolutely love the NFL and am a keen follower of NE! They can't defend for nothing but Brady/Gronkowski combo is awesome! Anyway, I have all the stat More

$133 USD in 3 days
(0 Reviews)

I currently have an office pool for college football run by a spreadsheet I developed that keeps track of various stats throughout the season. This is a project I would be greatly interested in. Give me a chance to wor More

$155 USD in 3 days
(0 Reviews)

Hi i have all the requires skill to complete this job effectively and efficiently. Please consider me for this project.

$222 USD in 5 days
(0 Reviews)

As a big NFL fan and someone who wishes he had enough money to gamble more, this project really excites me. I would love to work on it for you. I've actually already started with it because it intrigues me. Thanks fo More

$50 USD in 3 days
(0 Reviews)

Hi check my message.

$180 USD in 3 days
(0 Reviews)

Hi, I'd love to do this - I've already developed an extensive prediction model for UK soccer matches, that uses a variety of statistical techniques (Poisson probability distribution, etc) to make its correct score pred More

$250 USD in 5 days
(0 Reviews)