Creating Your Own Dynasty Spreadsheet

[gausec]

I was wondering, how many of you who play create their own spreadsheets? I am in the process of creating a spreadsheet, for roster management of the one team I own. In this sheet, I will color code my roster players, who are on the bubble, what I anticipate my starting lineup to be etc.

I was hoping to create a resource that can be shared with the community, as a template for roster management or other useful spreadsheet tools. If there is anything you think would be useful please include it, and I will try to incorporate it. Or if someone has already created this and is willing to share, please feel free to!

Thanks for the time!

[krombj19]

i like doing it in Excel. i don't color code besides the players i plan on acquiring.. i list the positions in the first column, and then the name, contract price, and contract years left. i add all contract price cells together to get the salary cap.

[Bot101]

This sounds pretty cool.

[pierson242]

I would love to see what you come up with!

[WhatWouldDitkaDo]

I do this. I would also recommend a tab with a trade log of all trades that occur in your league. It's helpful in determining which teams value rookie picks, which teams trade more often, which teams give up on under-performing rookies etc.

[gausec]

I converted what I used into google sheets, it is not revolutionary by any means. However, it does help me visualize what my team needs/what pieces I have. I used one of my teams as an example to help visualize it. One thing I was wondering, is there a way for the lineup to auto-populate based on the rankings of the players for their position?

If anyone has any feedback please feel free to leave it (negative or positive!). I had previously had the positions fit on one screen without scrolling however there was no way to delete a row without it totally messing up the cell. If you want to delete a player I'd recommend deleting the row so the formula will deduct the player for the total. If you're replacing the player with another you can simply overwrite it.

https://docs.google.com/spreadsheets/d/ ... edit#gid=0

[Tsunami]

I make a spreadsheet for contract leagues to calculate auction values. I also use one for a large keeper league to see who is available and to offer trades to anyone with not enough or too many keepers. Basically unique leagues require unique information. But for pretty normal leagues I don't find it necessary.

[Jigga94]

I think the best way to get the lineup to autofill would just have the QB slot (cell H3) reference your QB#1 (cell C14) and just change the Roster order as you see it. You could also do a cell of projected points where you could set a MAX function but that would only return numbers, not the names of players

[Jigga94]

I make a spreadsheet for contract leagues to calculate auction values. I also use one for a large keeper league to see who is available and to offer trades to anyone with not enough or too many keepers. Basically unique leagues require unique information. But for pretty normal leagues I don't find it necessary.

Exactly, Excel is great for numbers and showing data, but with just a bunch of names its not really helpful

[Ruggenater]

I think the best way to get the lineup to autofill would just have the QB slot (cell H3) reference your QB#1 (cell C14) and just change the Roster order as you see it. You could also do a cell of projected points where you could set a MAX function but that would only return numbers, not the names of players

Add the OFFSET function in with the MAX to return the player. I have an Excel-based redraft auction draft tool that helps me set auction values for every player based on aggregate stat projections from FantasyPros that I've also set up to fill in starting lineups to effectively "power rank" teams ahead of the season.

[Jigga94]

I think the best way to get the lineup to autofill would just have the QB slot (cell H3) reference your QB#1 (cell C14) and just change the Roster order as you see it. You could also do a cell of projected points where you could set a MAX function but that would only return numbers, not the names of players

Add the OFFSET function in with the MAX to return the player. I have an Excel-based redraft auction draft tool that helps me set auction values for every player based on aggregate stat projections from FantasyPros that I've also set up to fill in starting lineups to effectively "power rank" teams ahead of the season.

Having trouble using that function to return the players name. Could you explain it a little further? Thanks!

[kamihamster]

edit: wrong link...
https://docs.google.com/spreadsheets/d/ ... sp=sharing
that's the right one

there's mine. lots of stuff haven't been updated in a while. it mostly makes sense to me. the most useful tabs for me are the "team strength" ones where I can see every teams players and picks. it really helps when im trying to construct a trade.

lots of things didn't transfer well when uploading from excel to google sheets.

[gausec]

edit: wrong link...
https://docs.google.com/spreadsheets/d/ ... sp=sharing
that's the right one

there's mine. lots of stuff haven't been updated in a while. it mostly makes sense to me. the most useful tabs for me are the "team strength" ones where I can see every teams players and picks. it really helps when im trying to construct a trade.

lots of things didn't transfer well when uploading from excel to google sheets.

Intresting stuff in regards to the compete or rebuild analysis, can you explain this sheet a little more? Do you just input the weekly totals?

[kamihamster]

edit: wrong link...
https://docs.google.com/spreadsheets/d/ ... sp=sharing
that's the right one

there's mine. lots of stuff haven't been updated in a while. it mostly makes sense to me. the most useful tabs for me are the "team strength" ones where I can see every teams players and picks. it really helps when im trying to construct a trade.

lots of things didn't transfer well when uploading from excel to google sheets.

Intresting stuff in regards to the compete or rebuild analysis, can you explain this sheet a little more? Do you just input the weekly totals?

pretty much. there's lots of formulas and stuff that i came up with. nothing too crazy as i am not very good with math. it just helps me see from a purely numbers standpoint if i should be trying to compete or not.

it also tracks my teams performance. i really need to add a notes section for each week so i can look back and see why i might have had an increase or drop off in production. it also plots every teams performance against each other so you can see how variable some are and how studly or dudly others are. ... this sheet really looks better in excel

[Ruggenater]

I think the best way to get the lineup to autofill would just have the QB slot (cell H3) reference your QB#1 (cell C14) and just change the Roster order as you see it. You could also do a cell of projected points where you could set a MAX function but that would only return numbers, not the names of players

Add the OFFSET function in with the MAX to return the player. I have an Excel-based redraft auction draft tool that helps me set auction values for every player based on aggregate stat projections from FantasyPros that I've also set up to fill in starting lineups to effectively "power rank" teams ahead of the season.

Having trouble using that function to return the players name. Could you explain it a little further? Thanks!

Depending how your data table is set up, you'll want something like OFFSET([cell reference for top of player name column],MATCH(MAX([projected points column]),[projected points column],0),0). Don't include the column header in the [projected points column] reference, or if you do, subtract 1 from that piece of the formula.