You wasted all this time on google sheets for.....?

YOU! I did it for you, mostly. But I really want you to be able to leverage the data provided. To better understand what is going on with your team. It will give you a high level understanding, but you will have to understand the details, and within the details comes the wins, and with the wins come the glory that you all hunger for, because the devil is in the details.

Lets use Christie's team as an example of how to leverage this worksheet.

First, if you see something that looks wrong or if you have suggestions, let me know. Also, this best viewed on desktop.

You'll notice you have your own individual spreadsheet that has a few metrics that should help you what is currently happening with your team. I am going to take you chart by chart, excluding the win loss record for your team. If you can't figure that out you have more serious problems.

Figure 1

The chart to the left (Figure 1) shows the actual weekly score for your team vs the: moving average, weighted moving average and projected points.

The moving averages (requires four week intervals) can be used to understand the scoring trend for your team. It smooths out the weekly scoring figure, which is subject to some real highs and lows - i.e. high standard deviations.

The projected score can help you better understand if you are performing at or above what Yahoo thinks your team is doing. You can see from Christie's scoring chart she is all over the map and is trending downwards. She has not be able to really keep her team consistent in scoring. She also has more often than not been meeting her Yahoo projected scores. In other words, she has an unpredictable and underperforming team.

Figure 2

 Figure 2 shows a good breakdown of how this team stacks up to the rest of the league, performance in wins/losses, total +/- of points on the year, and how difficult the overall schedule has been.

The power rankings can be better understood in this post. Christie is a 9 out 14. This is not good.

In her victories she is beating teams by 14 points and is losing by just ~12. These are close games. She is neither blowing out teams, nor being blown out. This can be further seen in the 'Total Season +/-" figure. This is simply the delta of the total points scored on the year and total points scored against.

Figure 3

Figure 3 shows the average pts scored again, the weekly moving average pts, weighted moving average pts, and the total standard deviation. Again, the moving averages show us the trend. The standard deviation shows the the variation of the scores. This better helps us understand if her scores are really ALL over the map. A 13 standard deviation is actually pretty good, but also shows us that she has never really exploded on offense.

Just like in real football, fantasy football takes four quarters. The charts to the right (Figure 4) gives us a quarter by quarter look for Christie's team. As QTR 3 has just begun, you have to take these figures with a grain of salt.

Figure 4

You can see that her team has slowed down quarter over quarter, but so has her competition, allowing her to keep at that .500 level. The trending lines also help in visualizing this change.

But how does this all compare to the competition? You can see that in the middle chart, which shows she started pretty well over the first four games, as she was 4th overall in scoring and had a reasonable schedule.

The final chart in Figure 4 further shows the percentage growth. Again, as Q3 isn't finalized the Q2-Q3 isn't finalized and can't be really looked at.

This chart helps us really understand where her team is compared to other teams, over intervals of four games. Christie has been, at best, a middle of pack team to a lower end team.

Figure 5

The final charts further compare Christie's team to the other teams in the league. As a rule of thumb you want to see green not red in the delta column. The delta column is simply the difference between Christie's metrics vs the league's average/median/leader...

I wanted to provide the league medians, in addition to the averages, to further show how her team is doing. This comparison shows how far she is truly from the middle of the pack.

Of course, you must compare yourself against the league leader. You can see that she has big gap between her scores and the leader.

Finally, the last section of Figure 5 helps understand if the team is doing better than the rest of the league in beating its Yahoo projections and how well, or how poorly, they are doing comparatively.

Look, I hope this helps. It is pretty hard to predict the outcome of any game, but these metrics can help you determining whether your down week was just a blip in the road, or if it is time to hit the panic button.