Fantasy Football Draft Spreadsheet

By: Bryan Povlinski

If you do a fantasy football draft online on one of the major sites like Yahoo, ESPN, or CBS Sports you’ll have a lot of rankings and information at your disposal as you’re drafting. However, one of the frustrating things is that you really can’t see the makeup of all the other teams mid-draft without individually clicking to each one separately. It’s difficult to know how many of your opponents have already taken their quarterback or how many running backs the 2 guys ahead of you already have.

This tool allows you to see the makeup of every team on one spreadsheet. However, it does require you to manually enter in each pick as it’s made. It’s only as current as you’re able to keep it. It can be extremely helpful in making decisions based on scenarios that play out throughout the draft.

2016 Fantasy Football Draft Board (positional color coding, count of position per team)

Draft_Board

Here’s how to use the sheet:

1. Click File > Make a copy (which will save to your Google Docs/Google Drive account) and then you will be able to edit the sheet.

2. Prior to the draft you should fill out the tab labeled “Team Names, League Size, and Draft Order.” Everything highlighted in yellow should be customized to your league. You can change the team names to all of the team names in your league. Be sure to enter the league size as well. Then enter the draft order that your league has decided upon. You can erase team names that are beyond the size of your league (for example, if you only have 10 teams then just erase the names Team 11 and beyond).

3. When your draft starts you should begin to manually enter player names on the first tab labeled “Actual Draft Results.” I’ve entered some dummy data into the first round, but you should erase those names (in the yellow highlighted column…not under the team names) and enter in the players that you actually draft.

Update: Thanks to Huyck22, who commented below, the draft spreadsheet now has a color indicator for positions and a count for how many players at each position a team has drafted. I think it looks a lot nicer than the original and it really helps you get a good idea of what each team might do with their next picks. Also, I’ve found that it’s useful to have 2 versions of this spreadsheet open when you’re using it for a live draft. One to enter in the draft results and a 2nd (hopefully bigger screen) open to display the teams. Since you have to enter draft results into the same page as the teams you can do it all from one sheet, but you have to continually scroll up and down – having 2 sheets open prevents that hassle.

  • Jason

    Thanks for making this, I’m planning on using it my league’s draft this weekend!

  • jeremyjortega

    How do I make it where it is 18 rounds?

    • jeremyjortega I’ve changed the sheet to allow for a maximum of 24 teams. You should be able to set it to 18 now and order of draft picks should fall into place. Let me know if you have any issues.

  • Huyck22

    I tweeked your board and spruced it up to use as our actual dratf board.  Added position indicator, position counter and a column idicating any duplicates (red #1) Thank you for the ton of hard work.
    https://docs.google.com/spreadsheet/ccc?key=0AptQ3zKi6CfAdFV5bExWS0RSOVFYZFgtOFlKcFBVUVE&usp=sharing

  • Huyck22 This is awesome! I had wanted to add color coding for each position, but I hadn’t gotten a chance to update it yet. Do you mind if I update the post and link to your version now that it’s not only functional but looks great too? Can I give you a link back to a website or Twitter handle or anything? Thanks for making this a lot better – I really appreciate it.

  • Huyck22

    please feel free to share , no links necessary, glad I could help. FYI  It is only done for 8 teams and 16 rounds.

  • TribeFanMcC

    is there an easy wasy to edit the draft order if we have traded picks?

  • TribeFanMcC Yes – it should be fairly simple. On the Teams Names, League Size, and Draft Order tab just find the draft pick numbers in the table and switch them. There will be a formula in there, but you can just overwrite that one cell with a number. Now the new team will have the pick from the other team and vice versa

  • Dawgs50

    Is it possible to update the rankings or customize it according to my rankings?

    • Yes – just edit the rankings on the “Overall Rankings” tab to whatever you’d like. Just make sure the same data elements stay in the same columns (position, rank , etc.)

  • bsaunders0587

    sheetsports Maybe I’m just being stupid here, but how would you edit the sheet if a team has swapped picks in various rounds?

    So for example, if a team traded away their 9th round pick in order to get 2 7th round picks, how do you give them 2 7th round picks?

  • Trey_Dizzle

    It doesn’t work. I enter a name in column B of the Actual Draft Results tab and literally nothing happens. It doesn’t populate the spreadsheet. If I enter the names directly in the individual team columns they show up with position info but column B stays unpopulated. Any ideas?

  • TXSportsWife

    Thanks for making my life a helluva lot easier. I was going to have to come up with a spreadsheet like this and now I don’t have to on my own!!!!!!!!!!!!

  • CoolinDre1

    TXSportsWife  Did it work well for you?

  • Brian Ales

    I used your already awesome spreadsheet and added a tab for a more VIEWER friendly draft board. Mostly designed to be displayed only when displayed in full screen. The person filling out the draft would use the infrastructure you already have. If your interested in seeing it let me know how I can best share it to you.

    • spreadsheetsports

      Brian – I’d love to take a look. Getting the spreadsheet to fully display on a screen during a live draft has been difficult at times so it would be great to see what you added. Can you email me at bryan@spreadsheet-sports.com and we can go from there? Thanks!

      • Jeremy Wellbaum

        I’d like to see what he did as well…

        • spreadsheetsports

          I was never able to get this to see how it would look different. The way I’ve used it is to have one computer hooked up to a TV to display the draft board there as an extended display and then have it open on the computer screen in a separate window to enter all of the names so the view on the TV always stays in the same place

          • DDiss

            Brian, love this spreadsheet. I added a little more to it. On the Actual Pick, I added a drop down (or type ahead) for the players. Once a player is picked, then you cannot select them for any other round. They are removed from the drop down. Still working on a couple other things that can help increase functionality. Hope this helps, see what you think:
            https://docs.google.com/spreadsheets/d/1_wC5JGU4IlMtNI5t_I-zqT0y2gjFZAxVgwArYR8ecTg/edit?usp=sharing

          • spreadsheetsports

            This is a great addition. I’ve implemented it in the main sheet now. One thing I wasn’t clear on though – I see your arrayformula to remove the player if they were already selected, however, you’re still using that main column in the data validation component. How do you get it to remove the player from the dropdown once they’re already selected, but for the previously selected cells not show a warning label now that they’re no longer in the arrayformula list?

  • Henry Castro

    Hi, I am trying to use your spreadsheet for this years fantasy football draft party. I love the spreadsheet you’ve created! The only thing is the position colors and position count are not working for me. How can I fix this? Also, will it only work on google docs? Does it affect the spreadsheet if I download it to excel? Thanks!

    • spreadsheetsports

      Fixed the positional colors and position count. It should work when exported to Excel. I’m not sure if the conditional color formatting will be 100% maintained because there are some slight differences between Google Docs and Excel, but it should work there as well.

      • Henry Castro

        Thank you, it works now. I edited the defense counts as well. The cells were looking for “D” changed it to “DST” for accurate counts. I also made it so that the position tabs also reflect the availability of a player.

        I do have one more question. I’m not understanding how I can have the same spreadsheet opened twice and have them reflect the same information as I am making updates. I’m also not using Googledocs, I downloaded everything to my desktop and am using excel.

  • Eddie Morace Jr.

    The ranking for RB is not there

  • Andrew Garber

    When I type a name into actual draft results it does not update the player to selected, how do I fix this? Thanks

    • spreadsheetsports

      Make sure you’re entering the names in column B of the Actual Draft Results tab. If you enter them there (and spell the names exactly right) they will get updated on the Overall Rankings list and the list for their position to “Selected”

  • This spreadsheet is great – thank you! We’re playing on ESPN and roster includes a Head Coach position. How do you recommend incorporating this?

    • spreadsheetsports

      Hmm – you may have to do that outside of the sheet or you could potentially list the coaches (probably in order of projected records assuming you get points for wins) at the bottom of the Overall Rankings tab. Then you can select them onto teams just like any other player.

  • Jeremy Wellbaum

    Do you have a sheet for IDP?

    • spreadsheetsports

      Nothing on IDP as of now. You could add it fairly easily though if you needed it on yours. Just add defensive players to the bottom of the Overall Rankings tab (and then you can duplicate the formulas in the positional sheets if you’d like to see that separately) depending on how many different positions you actually use. You’ll want to find a rankings list first to sort them by best to worst.

      • Jeremy Wellbaum

        You say that as if I am some sort of Excel wizard… I’m being sarcastic. I just hate how there’s no love for IDP… unless you pay…

        • spreadsheetsports

          I’ll see if I can add it eventually. The challenge is that everyone seems to do IDP a bit differently. Some have all Defensive players grouped together, others have lineman, linebackers, secondary, and others have specific positions so it’s difficult to add it to the sheet in a way that would be helpful to the majority of people. Once you make a copy it’s flexible to add it yourself based on your specific format.

          • Jeremy Wellbaum

            I’m working on adding IDP. I think I have your sheet figured out. Trying to figure out how to have them go from available to selected…

          • Jeremy Wellbaum

            =importhtml(“http://espn.go.com/fantasy/football/story/_/page/IDPranks150618/jim-mccormick-2015-fantasy-football-idp-rankings”,”table”,0) FTW… I think that’s a decent start…

          • Jeremy Wellbaum
          • spreadsheetsports

            I think you’re all set. Nice work adding that in. Let me know if you run into any issues when you start selecting defensive players as you’re using it.

  • Matt

    I’m doing a 16 team league and I would like to place teams 9-16 below teams 1-8 so that every team can be seen on the screen. How do I move everything without changing the format? I can’t seem to get it right.

    • spreadsheetsports

      Just updated the sheet to put teams 9-16 underneath the first 8 teams. That’s a good idea to be able to get it all on one screen. Let me know if it works the way you expected.

      • Nick Herrmann

        How do I do the same thing with 12 teams (teams 7-12 beneath team 1-6)? I tried and have failed in doing so.

        • spreadsheetsports

          Just change the league size to 12 on the bottom of the Team Names, League Size, Draft Order tab. The additional blocks of teams just won’t be used.

          • Nick Herrmann

            No. I am talking about orientation. I would like to view Teams #1-6 in the same rows, and then Teams #7-12 in the same rows. Currently the spreadsheet displays Teams #1-8 and then Teams #9-12 below them. If you had 6 above and 6 below (instead of 8 above, 4 below), I could utilize the display area more efficiently.

          • spreadsheetsports

            Moving entire team lists is somewhat tricky. You can do it with what’s there, but you need to make sure you’re using the same formula that’s in each cell currently the exact same way in the new place. If you try to copy and paste the formulas all at once they will reference the wrong cells. For most of it – you can just copy the first cell in the list exactly and then fill down from that cell to the rest of the cells beneath it. Sorry for the vague explanation, but it’s not a change I’m interested in making for the posted sheet and it’s not something I can easily provide instructions to.

          • Nick Herrmann

            OK I figured it out. If anyone else would like to do this (as 12-team leagues are most plentiful), insert blank cells at A8, A9, B8, B9 and shift Team 7-12 and Draft Order 7-12 down below these blank cells. Delete Columns L & M so Teams #1-12 are in Order in Row 2. Simple as that.

          • spreadsheetsports

            Sweet! Nice work.

          • Kevin Carlin

            Hi Nick, incase Nick isn’t able to help. Could you tell me how to do a mock up to display for 6 on top and 6 on the bottom for a 12 team league? I was looking to have it display all on one page for the Actual Draft Results Tab?

          • Kevin Carlin

            nevermind I got it now

          • spreadsheetsports

            Glad you got it working!

          • Kevin Carlin

            I’m struggling with setting this up but would love to have it set up this way. Could you possibly be a little more descriptive? What tab would I enter this into?

          • Heath Lewison

            It’s relatively easy to do. As the author said you just have to ensure all of the formulas are correct through the different teams once you make the change. I can share it out if you’re interested.

  • CockySumBitch

    How can I update the rankings based on my league’s scoring? Thanks for any assistance.

    • spreadsheetsports

      You can change the overall rankings tab to any rankings list you want. Just make sure you update all the columns

      • CockySumBitch

        One more question for you. Is it possible to import a whole data set from ESPN that come in groups of 40 players? [=importhtml(“http://games.espn.go.com/ffl/tools/projections?leagueId=14&startIndex=160″,”table”,0)] That string gives me players 161-200. I’m trying to pull players 1 to 400 all at once.

        • CockySumBitch

          The end of that http is [ffl/tools/projections?leagueId=14&startIndex=160]

          • spreadsheetsports

            Not through a single importhtml command. You’ll need to do multiple importhtml’s down the page. So you could have your first cell call the page for players 1-40 (startindex=0) and then 41 cells down put in another importhtml with startindex=40 and so on down the sheet.

  • Travis Searcey

    Why does the “actual pick” column have a red flag and say Invalid Content? Am I doing something wrong

    • spreadsheetsports

      Nothing wrong – it’s just telling you that player is no longer in the player pool any longer because they’ve already been selected.

  • Dave Assini

    Hey bryan, this is great, thanks for sharing.. Can you break down what you meant by having 2 sheets open during the live draft? Is there a way to view the sheet where it shows the full roster of all 12 teams without scrolling? Would be nice to push onto TV during draft.

    • spreadsheetsports

      What I typically do is have my computer connected via HDMI to my TV and I extend the display (not duplicate) so that I can have one copy of the sheet open on my computer and another copy open on the TV screen for everyone to see. When picks are made – I enter them into the Actual Pick column on my computer and I’ll scroll down as far as I need to go to enter picks. On the TV I leave it static at the very top of the sheet so everyone can see the teams getting filled in. If others have their own computers they can have their own copy open and click around tabs to see the best available at a given position. I can also flip the version on the TV to another tab if someone requests to see another area of the sheet while they’re making their pick. Hope that helps – it’s worked really well for me.

      • Dave Assini

        Okay, awesome. Thanks

  • Mike Mendiola

    Love this spreadsheet! One question – I’ve been trying to get it to work to no avail but I notice it reverses order (snakes) after Team 12’s selection. How do I adjust it to reverse after Team 16 makes their selection? I’m in a 16-team league. Thanks!

    • spreadsheetsports

      You need to set the number of teams to be 16 on the Team Names, League Size, Draft Order tab (bottom left).

      • Mike Mendiola

        Got it, thanks!

  • Chris Miller

    This is really awesome. How did you get it so that once a player was selected in “column B” it showed them as no longer available in the rankings sheet? Trying to make a similar board for a different league and that function would be really useful. Thank you very much.

    • spreadsheetsports

      Just a lookup on the rankings sheet to column B where picks are made to see if that player appears on column B. Here’s the exact formula: =iferror(if(vlookup(D3,’Actual Draft Results’!B:B,1,FALSE)=D3,”Selected”,”Available”),”Available”)

      • Chris Miller

        Awesome, thanks a lot. This is really helpful

  • Leo Ruiz

    I have a question in regards to the actual Pick drop down. how do i edit that to go past just the 300? on the overall page i added all 835 nfl ranked players and did the formulas on that page for columns D, E and I.

    • spreadsheetsports

      Just highlight the entire “Actual Pick” column and select Data > Validation. In the box that pops up – change the Cell Range and the Criteria to your new range.

  • Austin High

    man this is amazing. thank you so much for this

  • Austin High

    I changed the league size to 14, but on the league size sheet there is 24 teams and on the actual draft sheet there is 16 teams.

    • Austin High

      Also when I am entering in Team names, once I get to Team 9 and on it shows this message, “Did not find value ‘The Funky Bunch’ in VLOOKUP evaluation”

      • spreadsheetsports

        I’m not sure what you mean by this. If you share your custom file with me I can take a look. bryan@spreadsheet-sports.com

      • Michael Neff

        Click the view tab, click “all formulas.” In column N1(and beyond), make sure it says “=A10” instead of your team name. Same goes for all other cells

        • Austin High

          Hey Thanks man that fixed the problem exactly

    • spreadsheetsports

      This shouldn’t matter – just make sure the League Size value at the bottom of that tab is set to the correct number. Delete any values on the Team Names, League Size sheet below the team names that you want to enter. There will still be 16 teams defaulted on the Actual Results page, but they won’t get filled in past the teams that you use.

  • Michael

    is there a way to adjust the snake draft to straight? We utilize three keepers, and a straight draft instead of the snake. Thank you!

    • spreadsheetsports

      You should be able to set the Snake Order column to 1 on each round instead of alternating between 1 and 2

  • Chad Hamsher

    Great spreadsheet. Wondering if there is a way to add one more round of the draft. I’m in a 12 team league, and we have 17 rounds and your sheet only goes to 16.

    • spreadsheetsports

      The formulas should all be filled down to the 17th team member even though it doesn’t show it. If not – you can just fill the formulas down one extra row on each team.

  • James Petrolla

    Is there not a way to have 10 teams straight across instead of 1-8 then 9 and 10 below that?

    • spreadsheetsports

      You’re welcome to edit the file in any way you’d like. You would just need to copy the exact formulas that are used on teams 9 and 10 into the new place where you’d like to put them. Just dragging formulas across from team 8 will not work.

  • Brian

    Will the ranking tabs be updated as we get closer to the season opener?

    • spreadsheetsports

      I was not planning on it. Rankings can change every day and what I have in there now should act as a fairly good starting point for any draft. Obviously you might want to move guys like Foster down due to injury, but you’re welcome to edit that tab however you’d like.

      • Brian

        How did you download the overall rankings table from ESPN onto the spreadsheet? Is there a way to link Excel to that webpage so it automatically updates when ESPN updates their table?

        • spreadsheetsports

          You can use this function to grab the data from the ESPN table: =importhtml(“http://espn.go.com/fantasy/football/story/_/id/12866396/top-300-rankings-2015″,”table”,0). It’s not 100% clean though as you have to remove the extra text around the player’s name among other things. I’ll see if I can get it back to being linked directly to that table in the spreadsheet by default.

          • Austin High

            where do we import that formula?

          • Reagan Knowles

            Enter this formula into cell A1:

            =IMPORTHTML(“http://espn.go.com/fantasy/football/story/_/id/12866396/top-300-rankings-2015″,”table”,0)

  • Chaonan

    With Arian Foster out (and maybe others?), it seems the top 300 rankings need to be updated. Is there a quick an easy way to do that?

    EDIT: Ignore…

  • Scott Crespo Spearink

    I am in a 20 team league so I need to add more players/teams how do I do this so that the actual draft tab will find it when I type it in. Thanks

    • spreadsheetsports

      Just change the league size to 20 at the bottom of the Draft Order, League Size tab and it should allow for all 20 teams

      • Scott Crespo Spearink

        Sorry I wasn’t clear enough, there’s 20 in the league but there isn’t enough kickers/defences on the list so I have added a load of NFL players and teams so the list has gone from 300 to about 410, how do I get the actual pick to locate the player that is outside of the 300 you have added. For example if I type Ed then Eddie lacy will come up, but if I type Pit for the steelers to come up ( a team I added) then I have to write the word fully.

        • spreadsheetsports

          Highlight the entire column and click on Data – Validation. Then change the cell range and Criteria range to your new range

  • Nick Stone

    First of all love the sheet, but I did have one quick question about the draft order. We have a lot of picks traded so that means for a custom draft order at times, is there an easy way to accomplish this?

    • spreadsheetsports

      You can make changes to the formula on each pick on the Draft Order, League Size, etc. tab. It’s hard to know exactly what changes you would need to make, but that’s where picks get associated to teams.

  • Heath Lewison

    Great work! If I wanted to add players because of limited availability (ESPN only ranks the top 18 D/ST teams for example) can I just add lines to the “Overall Rankings” tab and the rest will auto-populate or will it be more labor intensive than that? If someone in my league thinks the San Diego Chargers D/ST is worth drafting then it won’t auto-populate. I know this is a limitation of ESPN’s Top 300 but it’s nice to have all players ranked out for each position. It’s a minor gripe but I just thought I’d ask. Thanks for all the work and sharing it out!

    • spreadsheetsports

      Yes – you can add more to the Overall Rankings tab at the bottom. The only additional change you’ll need to make is to highlight column B on the Actual Results tab where you input all of the players drafted and click Data – Validation. Input your new ranges here so that the player list will continue to auto-populate to the new range you’ve used.

      • Heath Lewison

        Got it. Great…thanks again! So what is the data in the last tab used for then? (Raw Ranking List) Is it a repository for anything?

        • spreadsheetsports

          It’s where I previously had a direct connection setup to the ESPN Top 300 page, but it was causing problems and I just removed the connection and left the static data.

  • t g

    Sheet 1 that has the url import from espn is updated. but its not filtering/updating the other sheets. is there a way to make sure those update as well? been looking through everything but cant find how its set to do that.

    like right now the over all rankings has eddie listed as #1 but the new top 300 has leveon as #1.

    • mark

      ^ This. I love this spreadsheet but had the exact same question — especially with some of the high profile injuries (i.e., Nelson) that have happened since this sheet was compiled.

      GREAT tool!!!

      • spreadsheetsports

        This was a manual process to parse the data from the ESPN URL into the final format. I will likely update it one more time in the next few days, but you’re welcome to split the data into the correct columns on the Overall Rankings tab if you need it done faster.

        • mark

          I am an old guy and not very literate in spreadsheet. Let us know when/if you update the sheet?

          • spreadsheetsports

            Updated now

  • David Weinberger

    This is great. how would i update the spreadsheet to pull in the by week info next to the the player drafted?

    • spreadsheetsports

      You can write a vlookup statement in column C of the Actual Results tab to grab the Bye Week from the Overall Rankings tab. Something like =vlookup(b2,’Overall Rankings’!D:G,4,FALSE) should work.

  • Mark

    I love the spreadsheet, but i am having some issues. I am in a 12 team, 19 round league. I entered the last pick just to test it out and no player showed up in team 12’s round 19 box.

    • spreadsheetsports

      You’ll need to extend the formulas down 3 more rows for each team. Just drag down the formulas for the pick and position for 3 more boxes under each individual team and you should have it all set for 19 rounds

      • Mark

        would copy and pasting work? and replace the numbers with the correct one (i.e. team one round 16 is !F17 so round 17 would be !F18)?

        • spreadsheetsports

          Yes – that should work. I just meant to drag down the formula (essentially copy and pasting over multiple cells) to make it easier

          • Mark

            Thanks! That solved it. this isn’t too major as it’s just for organization, but the color for each position does not show up in rounds 17, 18, or 19. The position abbreviation is there, just without the corresponding color

          • spreadsheetsports

            You can click on Format > Conditional Formatting and change the rules to the new range of cells based on the ones you added.

          • Mark

            PLEASE HELP. I am in a major crisis and i need help asap. I have added to more teams so my league is at 14 as of now. I changed the league size from 12 to 14 and now the draft board isn’t responding to the fact that there are 14 teams. I have no idea what to do

          • spreadsheetsports

            I would just make a new copy of the sheet from the site. I’m not sure what you changed so I can’t tell what’s wrong. All you should need to do to change to 14 teams is to change the League Size number at the bottom of that tab.

  • Banks Van Pelt

    Awesome tool, great job, just had to follow your simple directions to use it.

  • Michael Wegsteen

    I am not seeing how to extend to 12 teams. I have entered in my team names and changed the number to 12 but only see teams 1-8. Any ideas?

    • spreadsheetsports

      Did you scroll down on the screen? The rest of the teams are listed below the first row of teams. You just need to change the League Size to 12 at the bottom of the Team Names, League Size, and Draft Order tab and then name your teams. You shouldn’t have to change anything else.

  • Matthew

    Hey there. Awesome spreadsheet. One question. What is column C calculating by default on the Actual Draft tab? They all pop up as 0 when a player is entered next to it

    • spreadsheetsports

      It’s just letting you know whether a player has already been selected. A 0 is expected if the player hasn’t yet been drafted.

  • Matthew

    Is there a way to enter the bye week of the players next to the team list section on the actual draft tab? I figured out the formula to make it work if I always draft the same number of teams, but when you alter the number of teams drafting, the columns next to the teams don’t change with it. Not sure if what I am saying is clear or not. For instance, If I have a 24 team draft and enter all the formulas to pull the bye weeks in columns next to the player names (in the team list section), it works fine…however, once I adjust it to a 12 team draft, the bye weeks still pop up in snake order next to all 24 teams as if I never changed it.

    • spreadsheetsports

      I would write a vlookup against the player selected in the Actual Results tab and lookup to the Bye week column in the Overall Rankings tab.

  • zloving

    I’m not able to download the spreadsheet, there’s no menu at the top. Is there another way to download?

    • jake

      go to the address bar and delete all the text after and including “htmlview…..”

      this will bring up the menu

  • Tim

    I’m looking at some of the formulas and relationships between cells and for the life of me, can’t figure out how you get the names to disappear from the Overall Rankings sheet, column I (I do know what it’s used for, validation on the Draft tab), or the Selected/Available to switch on the position rankings. Where can I see these formulas, because I might want to customize it for next year?

    • spreadsheetsports

      Column I of the overall rankings sheet displays the player name of the same line unless he has already been chose in the Actual Results tab. Then I use column I as validation on the dropdown on the Actual Results tab so it won’t include players that have already been selected. All of the formulas are available in their respective cells so you’re welcome to edit or change anything as you see fit.

      • Tim

        So I fully understand why column I is there and what it’s used for, but my question is HOW does it come up properly? I swear when I look at the cells in column I, it either has the name or not, but I don’t know how you did that from a technical point of view. Am I missing a macro or a script somewhere?

        • Tim

          Okay, I think I see it now. There’s one formula at the top of the column. I’ll work with that.

          • spreadsheetsports

            It’s in Data > Validation for column B in the Actual Results tab

          • Tim

            Thanks. I was actually talking about the formula in cell I2 (in the Overall rankings tab) and the formula in cell A2 in the Position tabs. I was thrown off by the fact that there weren’t any such formulas in the rest of column I, but I didn’t think to look in I2, or A2. I got clued in on the Defense tab as it wasn’t showing up, but I found it was looking for “D” instead of “DST”.

            The spreadsheet worked like a charm in today’s draft. I just didn’t have enough time to customize the rankings for my league, but it worked great (other than the times our owners drafted players outside the ESPN top 300). I’ve made some notes for personalization for myself, but have a whole year to work on it.

            Thanks!

          • spreadsheetsports

            Awesome – great to hear that it worked well for you!

  • Darrin Davis

    My league has “keepers”….Is there anyway to put in keepers w/out entering them into draft order…???

  • Kevin Foley

    What are the odds of you making a how to video on this before the season starts? I’m just throwing it out there as a valued and soon to be returning customer. I would pay you for a 30 second how to video.

    • spreadsheetsports

      The odds are low due to the amount of work I have this week to get the college football and NFL daily fantasy tools fully ready for the season. I will likely have a video tutorial for this next season though. It’s fairly straightforward to use – I think you’ll get the hang of it within a few minutes. You just need to apply your league settings on the Team Names, League Size, and Draft Order tab (so you’ll input the names of the teams in your league, change the number at the bottom to the number in your league and make sure you have the teams listed in the order they’ll be drafting). Then start entering in picks in the Actual Results tab. Everything should flow through and you’ll have a digital record of your draft.

  • Tom Reilly

    This is great. Thanks for sharing. Would you have a quick way to make this compatible with a keeper league? We trade picks so some teams have multiple picks per round and I am trying to figure out a way to have that make sense here.

    • spreadsheetsports

      There’s not a quick and easy way to do multiple picks per round. You can easily change what team gets a certain pick by editing the Draft Order in the Team Names, Draft Order and League Size tab starting in cell F2 through however many teams you have. If a team trades a pick just change the pick number to be associated with the correct team. If a team has multiple picks per round – you’ll have to make some manual changes by adding a pick onto the end of a team list or something like that because it’s not setup to handle that as of now.

  • C_lobon

    how can we add an IDP column?

    • spreadsheetsports

      You can add defensive players to the Overall Rankings tab, follow the same template for each of the position tabs if you need them, and then follow the same structure for IDP positions on the position counter on the Actual Results tab. You’ll also want to make changes in the Data > Validation section of the Actual Results tab so that the IDP players that you’ve added to Overall Rankings come through in the auto-fill.

  • Evan

    what would be the best way to center the draft board so it would show teams 1-5 up top, and teams 6-10 on the bottom, thanks so much for this!

    • spreadsheetsports

      You’ll need to copy the formulas in the Actual Results tab exactly and paste them into the new cells that you want to place them in. You can’t just copy one and then fill down or do a general copy and paste because it will move the references into the wrong cells.

  • Steve

    Maybe I’m just an idiot, but I can’t seem to figure out how to use the spreadsheet. There is no “file” for me to select to “make a copy” from. Is it a browser issue? Is it a PC issue?

    Nvm, fudged with the URL a bit more, I had to delete everything after …QRU

    • spreadsheetsports

      I’m not sure what the issue would be, but when you have a spreadsheet open in Google Docs you should see a menu item titled “File” at the top left of the sheet just below the sheet name. Click file and in the drop-down select Make a Copy.

  • MaineSkin

    I am assuming I can replace position indicators with fantasy basketball positions?

    • MaineSkin

      I pasted in the basketball rankings link and the sheet 1 updated. It did not split, but all the players are listed. The pull-down does not work though, so maybe someon can make this exact template, but for all possible fantasy sports.

      • spreadsheetsports

        Definitely a possibility, but likely not something I’ll be able to put in place over the next 2 weeks in time for this NBA season

        • MaineSkin

          may be able to squeeze $1 per copy made on Google. I’ve just sent it to 13 others for the NBA lg and one has already asked about the origin lol
          I’m sending them to here not directly to the workbook, so maybe it can create some more traffic on the site.

          • spreadsheetsports

            Appreciate it – I’ll see what I can do

  • Sean Braisted

    Trading picks seems like it would be easy, but I’m apparently doing it wrong. Is that something that is doable?

    • spreadsheetsports

      It is doable – you’ll need to change the pick numbers on the Team Names, League Size, and Draft Order tab. So if Team 7 trades the 7th pick to Team 4 for the 4th pick you’ll need to swap the value 4 to be under Team 7 and the value 7 to be under Team 4

      • Sean Braisted

        Ack. I was hoping to beat you back here and say don’t worry about it. I figured it out, thanks. This spreadsheet is a thing of beauty.

  • Norm Beck

    is this just for football or can it be used for a customized draft?

    • spreadsheetsports

      It’s built for football, but you’re welcome to create your own copy and customize it to any sport you’d like.

  • Michael Hulgan

    Will you have a 2016 update?

    • spreadsheetsports

      Yes, I plan to. It will be closer to draft season once we have a somewhat stable Top 300 list to pull from

      • thistimearound

        Thank you for this. So easy to have last year as a commissioner.

  • Kasper Tor Mathiasen

    Would it be possible to change the link to a dynasty draft ranking?

    • spreadsheetsports

      You definitely could. You would just want to edit the rankings on the Overall Rankings tab. I don’t have it connected directly to ESPN Top 300 in case they make any kind of changes to their format, but I do have a live connection on the Sheet1 tab at the very end so you can see how you would access data on a web page if you’d like to change it.

      • Kasper Tor Mathiasen
        • spreadsheetsports

          Yes, you can use any other source you’d like. You just need to find a source that it going to give you player names and positions (those are the most important 2 if you don’t care all that much about team or bye week). However, I don’t have that link setup to feed live into the Overall Rankings tab. That’s what’s driving the entire sheet. So I simply copy and paste the results (values only) from Sheet1 into Overall Rankings. You can do the same with any other source you want as long as you keep the column order the same.

          • Kasper Tor Mathiasen

            So just change:
            =importhtml(“http://espn.go.com/fantasy/football/story/_/id/16287927/fantasy-football-rankings-2016-espn-nfl-rankings-top-300-overall”,”table”,0)

            to.
            =importhtml(“http://espn.go.com/fantasy/football/story/_/id/15698900/mike-clay-top-200-dynasty-fantasy-football-rankings-nfl”,”table”,0)

            ?

          • spreadsheetsports

            Yes, and then paste the results to the corresponding columns in the Overall Rankings tab

  • Steve Cox

    thank you for making this bryan!! you rock!
    last year, in one of my leagues, our eight members were spread across four time zones, and our schedules were so random that we had to draft over the course of a week, by email. it went surprisingly well, thanks to your most excellent draft board.

    • spreadsheetsports

      Great to hear you got good use out of it!

  • Gregg Reno

    For anyone who is interested, I’ve published a heavily modified version of Bryan’s spreadsheet that adds multi-user functionality so each team owner can have a view of the main draft board, plus have their own custom rankings that get automatically updated during the live draft. The write-up of my updated version and how our league used it last year is here: http://greggreno.com/draftday/

    • Steven B

      This rocks!

  • B.j. Kramer

    We utilized this for a league last year. We have a bunch of military guys in our league so we used this via google sheets, worked just fine. One addition that I put on our sheet was team initials next to each pick. We have traded picks in our league and by adding the team initials next to the pick it alleviated any confusion as to who was picking.

    Thanks!

  • Jad Massarweh

    Does the rank sheet (on sheet 1) update automatically if espn updates their list?

    • spreadsheetsports

      No, I don’t have to connected live to the ESPN page in case they change their format or the URL in some way. There is a sheet (Sheet1) all the way at the end that is a live connection though. I’ll be updating as we get closer to the season from there, but you can copy the data on the right side of the Sheet1 page into the Overall Rankings tab if you need it updated sooner

  • Dominic Murazzi

    could you make a tutorial for how to make this? my league has draft pick trading and the snake function wouldnt work, so i was going to try to make my own version based on this but i don’t know enough about excel

    • spreadsheetsports

      Potentially yes. I’m planning to put together somewhat of a course for sports analytics and different tools like this. It’s unlikely that will be done in the next few weeks though in time for the NFL season. As for draft pick trading, you can simply switch out pick numbers on the Team Names, League Size, and Draft Order tab. So if Team 3 trades the 3rd pick to Team 6 for the 6th pick – simply switch the column for picks 3 and 6. If you trade multiple picks for one – you may need to reorder the picks in a given column but you should just be able to push the rest of the picks down and add in the additional pick a team got in the correct numerical place.

      • Greg Boyce

        Can you explain this more with regards to switching columns on the Team Names, League Size, Draft Order tab? How do you handle trades involving picks in different rounds – but an even one for one swap, not multiple picks for one?

        • spreadsheetsports

          Just flip the pick numbers under the correct Team column. For example, if Team 3 trades the 3rd pick to Team 4 for the 4th pick just put 4 under Team 3 and 3 under Team 4.

  • deCha Sanson

    Is there any way to use this offline once all the rankings are settled?

    • spreadsheetsports

      The rankings actually are not connected live. You can fairly easily update on your own if you’d like using the live connection to the rankings page in the tab labeled Sheet1. I will be updating in the main sheet as we get closer to the season. As far as accessing it offline – there is an offline mode for Google Docs. I honestly haven’t tried that so I’m not sure how well it works. I will say that it doesn’t translate perfectly into an Excel file if you download as Excel so I wouldn’t recommend that as the best option.

  • Jeremy Wellbaum

    I believe I asked this last year, but do you plan on incorporating IDP in your sheet? I took some time, and modified your 2015 sheet, but it took a lot of time, and I’m more busy this year…

    https://docs.google.com/spreadsheets/d/1aDh_l3HQDjt61pmQ_C3GJtC7cXkObQjQEZw0Bp4dFpk/edit?usp=sharing

    • spreadsheetsports

      No plans to add IDP to the main sheet for this season. Since you already have your modifications – assuming your league is the same number of people and the same settings – all you should have to do is swap out the Overall Rankings tab with the rankings you want to use for 2016 IDP and you should be all set.

  • Joey Fox

    Im having trouble adding a 17th round to the draft. How can i do this?

    • spreadsheetsports

      17th round should be added now

  • Steven B

    Bryan, thanks for making this original draft board. It was very helpful! Gregg, thanks for the modified version, we plan to use it this year.

    • Gregg Reno

      You’re welcome, and I hope you’re draft goes well!

  • dgcoot44

    Thanks for building and sharing this. I created a similar spreadsheet last season for our draft but yours really took it to the next level!

  • amesa5

    Thanks for the spreadsheet, I made one last year, but you took it to another level. I was hoping you could help me though. I want to use this but with my own ranking list. What columns do I need to input and where for the spreadsheet to use my own list? Thanks for all your help.

    • spreadsheetsports

      The Overall Rankings tab is what you would need to change. Just make sure you keep the columns and the position abbreviations the same as they’re set now. Let me know if that helps.

      • amesa5

        Ya, that helped, thank you!

  • Travis Mañach

    Awesome spreadsheet. Is there anyway on Sheet 2 that could denote who’s pick it is? Or am I missing something that does that already?

    • spreadsheetsports

      There’s not anything that does that now (although I’m not sure what you mean by Sheet 2) We’ve typically just watched the picks get put into a team at the top and you always know it’s the next team’s turn after you see a player get added to the team to the left

  • Jeffrey

    thank you! this is fantastic

  • Lee

    This spreadsheet rocks!! Thank you for making it makes it so much better. Love the validation of players tool. This is a lifesaver!!

  • Zach Jones

    Is anyone else having a hard time making a copy? It says I need to sign in, but when I click sign in it just loads the page again. Help please.

    • spreadsheetsports

      You should just be able to click File at the top left once you’re signed in to your own Google account and then choose Make a Copy

  • Nick Herrmann

    When I upload the team names onTeam Name page why doesn’t it automatically pull over to the draft results page?

    • spreadsheetsports

      It should pull them automatically if you enter the team names in the yellow section of the Team Names sheet – not across the top. You may need to make a fresh copy of the sheet if you’ve removed those formulas

  • Mike Gangi

    I’m having tons of trouble downloading this multiple ways. I can’t get any of the cells to populate after making a copy and then saving to my hard drive. It works fine if I operate out of Google Drive but not if I save it.

    When I open the copy downloaded from my Google Drive to my BRAND NEW Dell Ultrabook this is the error I get: “We found a problem with some content in ‘Fantasy Football Draft Board 2016.xlsx’.Do you want us to try to recover as much as we can? If you trust the source of this workbook, Click Yes”

    Once I do click YES it gives me a message saying that I need to update links (which I do and then it says that it can’t). Then it asks me if I want to continue or edit links.

    I also get a pop-up box simultaneously that says “Excel was able to repair the file by repairing or removing the unreadable content” and it allows me to look at a log. Upon closing this dialog box I get an exclamation point in every cell that SHOULD populate with a draft pick after selecting the player. The draft board does not populate at all.

    I find it odd that it works in Google Drive but not once it’s downloaded to my laptop. Is it because it is an active spreadsheet and needs to be used online?

    Any assistance would be great…I’m trying to share this with a friend.

    • spreadsheetsports

      It’s meant to be used online in Google Docs. There are some functions that Google Spreadsheets contain that Microsoft Excel does not fully support. It will attempt to download it as an Excel file, but you would need to make some changes to get everything working 100%. I would stick with using it online if you can.

    • Nicole Gilsdorf

      I was able to modify the Excel version of it well enough to use it just like you would in Google Docs. However the Top 300 list that it’s pulling from doesn’t update like Google Docs will.

      • spreadsheetsports

        Yes, you’ll have to re-do the data connection in Excel if you want it to be a live connection. You can use the Data tab and a web connection in Excel or use Power Query (free Excel add-in) to parse the data into the correct columns and format. You can also manually update the rankings list as you get close to your draft

        • Nicole Gilsdorf

          I’ll have to look into what you mentioned! I’ve always been fairly decent in Excel but modifying this file to work how it does in Google Docs stretched my brain cells, haha! There were a few things I had never done before. Thank you for making it! First year as a commish and finding this made my job a lot easier for our offline draft. =)

  • Gary Robert

    Great Sheet! How can I reduce the number of players to 14 and number of rounds to 15? I’d like to put the Actual Draft Results Page to reflect our leagues reality. Currently it shows up to roughly 24 teams and 17 rounds.

    • spreadsheetsports

      It’s always going to show the 17 rounds, but you can stop at 15 picks. For the teams – the number of teams should be set on the Team Names League Size Draft Order tab

      • Gary Robert

        I don’t mind the extra rounds showing if they have to, but how do I get the Actual Draft Results Page to remove the extra 2 teams that look like their missing names and data? It sets up a chart for 16 teams. I just wanted to clean it up for our league and show only the 14 with 7 teams on each line. Reducing the TNLSDO tab to 14 teams did not change it.

        • spreadsheetsports

          It’s not going to do 7 on each line. It won’t put any players in the other 2 teams if you have it set to 14 teams but those columns will still be there. You can move things around if you’re comfortable cutting and pasting to get it into the exact format you want. That’s probably the best option.

      • Kasper Tor Mathiasen

        Is it possible to insert an ekstra round – We have 18 rounds in my draft (IDP)

      • bdizzy54

        I’m in a 10 man, 20 round draft (keeper league).
        Any simple way to add more rounds?

        • spreadsheetsports

          You should just be able to drag the formulas down. You’ll need to cut and paste the second row of teams but it should be pretty straightforward.

  • Mathew Foster

    I love this sheet. Is there any way possible to make it for 19 rounds?

    • spreadsheetsports

      Yes, just pull down the formulas 2 extra rounds on the Actual Draft Results tab

      • Mathew Foster

        Appreciate the quick response, thank you

  • LC

    Hello. First off, this sheet is awesome!! Started using it for a 12 team league and when the owner of the 12th team makes his picks, it won’t populate his roster. When the 14th pick is made (by the 11th team), that pick will populate on the 11th team’s roster. Any idea why the roster won’t populate for the 12th owner (has picks 12 & 13)?

  • John Stewart

    This is awesome. Made a lot of modifications to meet my needs for a keeper league, which I will happily share with the group upon completion. One question relevant for the keeper players among us, where we have traded draft picks: What is the best way to reflect when Team 1 trades his 3rd round pick for Team 2’s 4th round pick, for example. I notice that if i manually change that in the setup matrix, the math that follows gets messed up for everything after that…thanks!
    -John

    • spreadsheetsports

      Yeah, there’s not exactly an easy way to do it. The math in the pick numbers is there to make the sheet dynamic based on the number of teams you have in your league so once you get the # of teams settled you can just remove the formulas from the pick numbers and start moving picks around to the correct team if you want

  • Racquel Ramsey

    So do I click on the color sheet to copy it

  • Racquel Ramsey

    Got it, 🙂

  • Veta Mcenery

    Thanks for sharing this. Unfortunately, I found this article too late – I already found the answer on another service. I’ve found PDFfiller – online service for forms filling. It’s pretty easy to use and pretty cheap. You can find fillable a form here https://goo.gl/SjyqCn

  • Yu Winburn

    Good to know. Unfortunately, I found this article too late – I already found the answer on another service. I’ve found some decent tutorials on how to fill OR Form 8.010.5 out online here https://goo.gl/rHIavi

  • Matthew Edwards

    wow guys, this is amazing! Quick question, hopefully. What would be the easiest way to modify this to add a column for each team? The reason is we do auction drafts, and I would love to include an amount next to the player selected so we can see how much he cost, and how much each team has left to spend. Thanks for making this spreadsheet available and for any ideas you might have!

    • spreadsheetsports

      You should be able to insert a column in between each team and the formulas should automatically update. You should be able to insert a column next to the Actual Picks and put the final price in there. I’m not sure how you’re going to assign the picks though because it’s designed to work with a snake draft not an auction that teams can claim players in any order.

  • Todd Siebert

    Sorry if this has already been asked, but how do you change the source data? I am in a PPR league so would like to pull PPR rankings.

    • spreadsheetsports

      You can change the data in the Overall Rankings tab. Just make sure you keep the same column structure with whatever new data you decide to put in there.

  • Mike Florence

    Great sheet! I’ll be showing this to the guys in my league. One question though… we are in a 10-team dynasty that is keeping 17 players and drafting 5 more (mainly rookies and free agents). What’s the best way to set this up so I can fill in the players being kept? I’m kind of talking my way through it as I type this question, but I don’t want to screw up a formula and have to start over.

    • adougy13

      I think you can just type in the players for each team being kept (as if they are being drafted) until you run out of keepers. And then from there you can start the new draft.

      • Mike Florence

        The only issue with that is the page only gives 17 player slots. Those 17 slots would be my keepers. So I need to add 5 more slots (basically rounds 1-5) for the players we draft. The key is adding those slots without messing up the formulas for any other cells they link to.

    • spreadsheetsports

      You can enter the kept players as the first draft picks for each team. You could just copy and paste that list into the Actual Draft results if you have them in order. Then pull the formulas down for each team to expand them to 22 slots and draft the last 5 players as normal for each team

  • Kyle Williams

    Any way to add defensive players?

    • spreadsheetsports

      You can add Defensive players to the Overall Rankings tab if you’d like and then you can draft them just like any other player

  • BNorgard

    Does sheet 1 update from ESPN automatically or is there a command. Also to change draft order what do you change? just re arrange team names? I changed the draft order on page 2 but it didn’t seem to move anything? The version I got today has 24 teams and 24 rounds. I deleted the extra teams and changed the teams to 10. How do I change the rounds so they reflect the correct pick numbers. ALSO this spreadsheet rocks and thanks for all the work!!!

    • spreadsheetsports

      It does update automatically but it’s not connected to the rest of the sheet. You need to copy and paste into the Overall Rankings tab. You can change the order and number of teams in the Draft Order Team Names tabs. You can hide the other teams or delete them if you want after you set the number of teams to what you want because the others won’t be used. I’m not sure if you changed anything other than the yellow cells on the Draft Order Team Names tab, but you shouldn’t change anything else.

      • BNorgard

        Do you just highlight cells on “sheet 1” and paste in to “raw rankings”?

        • spreadsheetsports

          Essentially yes, the columns on the right side of Sheet1, copy and then paste special – values only into Overall Rankings

  • Chris Kessler

    Love the sheet…question though. I am seeing an error on each position ranking tab, I am noticing that the these tabs aren’t updating either. Error says “Error: Array result was not expanded because it would overwrite data in B2”. Any thoughts?

    • spreadsheetsports

      I’m not seeing that on the position tabs. Did you make your own edits to the sheet that would have changed something? You may need to make another copy from the original sheet to clear that up.

  • Justin Wagler

    Thanks for sharing! This is great.
    I’ve made some adjustments to this for my league’s use but one thing I am struggling with is that since I have adjusted the rounds to read horizontally (1-8 / 9-16) I cannot make a pick in columns other than ‘B’ that the Overall Rankings will recognize to trigger the ‘Available’ to ‘Selected’

    Any suggestions to make this work across? Can you do a ‘vlookup’ that recognizes multiple columns?

    Thanks so much.

  • Jacob Griffiths

    Missing Martavis Bryant…Just fyi
    tried adding him in overall rankings at #104 (doesn’t matter to me) but he doesn’t show up when I go to type him into the actual draft pick

    • spreadsheetsports

      Hmm – it looks like ESPN doesn’t include him. He should show up if you’ve added him though. Make sure the formula gets filled down to the right of the rankings in the Overall Rankings tab

      • HeelYeah

        Isn’t he suspended for the whole season?

        • spreadsheetsports

          Yes, it looks like a minimum of one season

  • eyewitness29

    Where does the lookup from the current table get transferred to each of the other Overall Rankings and positional Rankings? I updated the data that go put into the “Sheet 1” tab so that it would pull in from the top 300 for PPR and that worked but it did not update the other tabs??

    • spreadsheetsports

      They’re not connected by default because I didn’t want the sheet to break in case ESPN changed their page or structure. You can just copy the right side of the Sheet1 tab and paste special – values only into the Overall Rankings tab.

      • eyewitness29

        Will that then populate to each of the other positional tabs? Or do I need to paste individually ?

        • spreadsheetsports

          Just Overall Rankings – the rest should update automatically

          • Cliff Mercer

            Great spreadsheet! I have the same issue the eyewitness29 had – trying to use ESPN’s PPR rankings. The challenge is, and it’s beyond me to fix, is that ESPN’s top 300 and ESPN’s top 300 PPR have different columns. It’s throwing a monkey wrench into everything.

          • spreadsheetsports

            You’ll need to manually clean up those columns before you replace them in the Overall Rankings tab. The Bye Week isn’t really needed so you can remove that column. Everything else should be essentially the same.

          • Cliff Mercer

            Again, that’s a fantastic tool you have created. Thank you for sharing it. I cleaned things up and before I got your email, I just changed everyone’s bye week to “99”. Working fine.

  • michael

    this is awesome! but having trouble with the picks being sorted into the individual teams. I’ve entered team names and draft order on second page but the picks don’t populate into each players list on the first page. help?

    • spreadsheetsports

      Make sure you only edit the cells in yellow on the 2nd tab. You shouldn’t change the team names at the top. Then on the Actual Draft Results tab – when you start entering in picks they should automatically flow to the correct team. You may need to make a new copy of the sheet

  • Joshua James USA

    Awesome to share this to everyone!

  • tom

    absolutely love it – how would you go about adjusting the sheet if you wanted to trade draft picks?

    • spreadsheetsports

      I would get the number of teams and the draft order set first and then copy/paste special – values only over all of the pick numbers in the Draft Order Team Name League Size tab. Then you can simply move pick numbers around under the correct team’s column

      • tom

        what i ended up doing – after i posted i saw you commented on another similar question before… thanks again, definitely helping us as we’re doing google hangouts to draft with your sheet

  • Ryan Rosso

    Hey guys, I went to page 2 and edited the team names in the Yellow section, but on the 1st page when I select a player the spreadsheet freezes and crashes, any idea?

  • Shawn

    A lot of people are asking about more rounds. Is there anyone who can adjust this to fit 20 rounds and post it? I tried but dragging down the formulas interfered with the position counts and obviously i’m not copy and pasting the right areas. Thanks.

  • Paul

    Hi,

    I don’t know if I’m doing something wrong here but when I try to download this as an excel spreadsheet it gives me errors and then it breaks some of the major formulas. Am I doing something wrong or do I have to use this in a browser? I think it has something to do with pulling the information from the website but I’m not sure. I would prefer to have this as an excel spreadsheet separate from any internet browser. Any help would be greatly appreciated. Thanks in advance!

    • spreadsheetsports

      It’s designed to be used in Google Docs. There are some formulas on the additional tabs (positional rankings) that are not supported in Excel. It’s possible to use it in Excel, but you may need to make some adjustments to fix those tabs if you care about them

  • Art Vandelay

    How did you have it dynamically pull names based on the characters entered from the “actual pick” list. For example when I type “a” it pulls anyone with an a in their name. Can you explain please?

    • spreadsheetsports

      See the formula in column I of the Overall Rankings tab. That’s the list that the players are pulling from, and there are Data Validation rules on the Actual Picks column to display only names from that list in the dropdown. Google sheets automatically provides the feature to filter based on typing characters and showing any matching values in the validation list

    • Cliff Mercer

      “And you want to be my latex salesman.”

  • Jordy

    How do you edit the rankings of players so my draft board is organized based on my decisions? Is there a way to easily edit the overall and position rankings? It would be great to be able to just drag and drop rows into their order and it auto reset verses creating an error.

    • spreadsheetsports

      You can change the rankings on the Overall Rankings tab. The positional tabs should update automatically.

      • Jordy

        Thank you! I was hoping for a quick drag and drop feature, but this will work more than fine. Great document. This will be year #2 of use!

  • robims

    This is awesome. Thanks, genius.

  • Anthony Liantonio

    Are the “Raw Rankings” from last year? It has players like Marshawn and Calvin Johnson still.

    • spreadsheetsports

      Yes, I will delete that tab. It’s not actively used

  • Kevin Bourne

    Wondering if this will work for a draft type that is 1-10 then next round will be 10-1. We have 10 teams.

    • spreadsheetsports

      Yes, the default is to use snake draft settings

      • Kevin Bourne

        So how do we get it to not use snake draft settings?

        • spreadsheetsports

          There’s not really a simple change. You would need to change the logic of how the pick numbers flow through the teams. You could just get your number of teams (10) set and then copy/paste special values only over all of the pick number logic on the Draft Order League Size tab. Then adjust those values to the correct teams as required for your league

  • Bob McClune

    Are the rankings updated as of today? This is badass…

    • spreadsheetsports

      Updated as of earlier this week. Probably around Aug 30th

  • Paul Spitz

    I second everyone’s comments on this being a great tool! My question is, I set the spreadsheet up for an 8 team league and everything worked fine until we got to round 9 of our 14 round draft. The spreadsheet stopped filling in the picks made by each team after round 8. Did I miss a setting to increase the number of rounds from 8 to 14?

    • spreadsheetsports

      My guess is you deleted all the rows on the Draft Order League Size tab after Team 8. You should not delete rows there. You just need to set the League Size to 8 and it will only populate 8 teams even though the rest of the teams still appear

  • Steve Williams

    Awesome. I discovered too late for 2016, will you update for 2017 do you think?

    • spreadsheetsports

      Yes, I plan to update to 2017 as we get closer to next season

      • Steven Stull

        What about individual defensive players? Could we get those?

        • spreadsheetsports

          You should be able to use the template for the other positions to add Defensive players if you’d like. There are many sources out there that rank defensive players so you can use whatever list you’d like. It’s possible we’ll add this to our sheet for next year, but it hasn’t been a big priority.