FFL Excel Doc Advice (1 Viewer)

[Horses]

Over the last several season I've been making these excel spreadsheets to track how my team is doing in comparison to the rest of my league. I've found that when looking at specific players I can be distracted by the name of the player and not their actual performance so I created this spreadsheet to turn everything in to numbers. I can now very quickly see where my team is doing well in comparison to the rest of my league and where my team needs improvement. It's been really helpful when considering trades and who to pick up on the waiver wire.

I'm always looking for ways to improve this spreadsheet though and since you all are fantastic with numbers I thought I would share this sheet with all of you and see if anyone has any suggestions on how I can make this an even better tool. There's a page for each position that we start in our league.

FFL Excel Doc

 

[beaux]

Team PA is not needed IMO as you have no control in other owners teams.

 

[Horses]

Team PA is not needed IMO as you have no control in other owners teams.

Personally I like having the PA just so that I can see who has had the most difficult schedule and who has had the easiest.

 

[footballnerd]

MFL has this as part of their site

 

[Horses]

MFL has this as part of their site

MFL is actually where I got the idea from. Unfortunately none of my leagues want to use MFL for some reason. They all prefer Yahoo or CBS even though MFL is better in my opinion. So I created this spreadsheet to at least get this functionality without having to be in a MFL league.

 

[MIMN]

If I am in your league you might want to include bench points. A team that keeps having their bench players go off while their starters suffer has the points to win, just not the coaching. If a team has an under-performing starter they may be more willing to trade that starter away. That would be a team to look at for a "bounce back" player. They might also have performing players that are performing but they do not trust. If you trust the player you could convince them to "sell high."

CBS has the position rankings as well a a coaching ranking. When I see I am playing a team with a poor coaching ranking and high strength of schedule they have a chance to over perform and beat me in a close matchup (This week). That might lead me to take a couple of chances with my lineup for high upside players. If they have a bad schedule but have gotten everything out of their team that they could and I am expected to win I can probably play it safer.

 

[Horses]

If I am in your league you might want to include bench points. A team that keeps having their bench players go off while their starters suffer has the points to win, just not the coaching. If a team has an under-performing starter they may be more willing to trade that starter away. That would be a team to look at for a "bounce back" player. They might also have performing players that are performing but they do not trust. If you trust the player you could convince them to "sell high."CBS has the position rankings as well a a coaching ranking. When I see I am playing a team with a poor coaching ranking and high strength of schedule they have a chance to over perform and beat me in a close matchup (This week). That might lead me to take a couple of chances with my lineup for high upside players. If they have a bad schedule but have gotten everything out of their team that they could and I am expected to win I can probably play it safer.

That's an interesting idea. I'll look into working that in to my spreadsheet. Thanks.

 

[footballnerd]

That's an interesting idea. I'll look into working that in to my spreadsheet. Thanks.

ya I like the idea of including max points for (using best weekly line ups), that way you could see how well a team would perform each week with their optimal lineup, see their true potential rankings.

 

[th3f00l]

I'm working on a similar spreadsheet. It's calculating teams performances by position, based on the average points scored and points allowed. It gives me the percentage of the offensive points scored to defenses avg points allowed, and visa versa. It helps to better analyze performance, matchup, and strength of schedule.