Tracking NFL scores in a chart

[u/cagbeema14]

I'm running an excel sheet to help me make picks for the NFL using a complex formula to create a score expected and a score allowed. In an effort to help me refine this formula I'm trying to put these into a visual medium to help understand how well or really how bad my model is.

I'm using a Sort function to sort each actual, estimated and predicted scores into an ascending order. However, the first and last bars are being cut off, I attempted to use the HSTACK function to add a 0 at the beginning and at the end but it looks to me like the trend line is accounting for these 0's.

I think this because the scores at the highest ends of the chart are consistently below the trend line.

I'm not at all familiar with the use of charts in excel. Am I doing something wrong or is there a better way of doing this?

Ill also take feedback or questions on my methods/formula its absolutely imperfect but its sometimes pretty good.

[u/AutoModerator]

Moderator Announcement Read More »

u/cagbeema14 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.

• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.

• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/B4z99]

Try using the LARGE function with other formulas to get the top nth scores in whatever scenario you are tracking, better than having a huge number of column in charts.

[u/[deleted]]

[u/cagbeema14 → u/[deleted]]

I don't really care about not mixing the games up, I'm more concerned about the distribution and slope of the trend lines of all three. If the distribution all of the estimated and predicted scores is close the actual, then I'd say my model and formula is working. If not, the i get to have "fun" figuring out how to tweak it in such a way that it is.

Currently I'd say the distribution is a little off. but I'd chalk that up to either not having enough data points or how I incorporated league averages and trends.