Football Projection Tool Guide

By: Bryan Povlinski

The NFL Projection Tool allows you to use a variety of stats to create custom projections and generate weekly fantasy lineups. You can purchase the tool here if you haven’t already.

System Requirements

1. Microsoft Excel

If you’re running Windows you must have Excel 2016, 2013, 2010, or 2007. On Mac you’ll need Excel for Mac 2016 (although some workarounds are required) or Excel for Mac 2011.

2. Solver plugin for Excel (free). Instructions on how to enable it are found here. If you don’t enable this plugin you won’t be able to use the tool to generate an optimal lineup. There’s an extra set of steps that are required for Mac users.

Mac Users Only
1. Click on Tools > Hover over Macros and choose VBA Editor
2. Then click on Tools again and choose References
3. When the reference box opens up you want to make sure the box next to “Missing Solver.XLAM” is unchecked and “Solver” is checked.

Video Guides

Projection Tool, Multi-Lineup Optimizer, Lineup Generator

How to Use the Tool to Create Projections and Generate an Optimal Lineup

Projections

The first step is to ensure you have the scoring settings set for the site you’d like to create a lineup for. In the top left of the “Projections” tab is a black box labeled fantasy site. Change that value via the dropdown box to the site you’re creating a lineup for.

fantasy_site

 

The NFL Projection Tool allows you to use historical data and matchup specific stats to create custom projections for each player. There’s a lot of data at your disposal, and this guide will show you how to go through the workflow to ultimately produce the best possible lineups for daily sites like FanDuel and DraftKings.

There are 4 main components of the NFL Projection Tool:

Adjustments, Player History, Rank, Depth Chart

Each of the 4 components generates a projection for each player and then you can choose how you’d like to weight the 4 component projections to get to your final composite projections which you’ll use to choose your optimal lineups. Here’s how each of the components works:

Adjustments

The Adjustments projection starts out with a historical average of fantasy points scored by a range of the weekly rankings at each position. For QB’s and TE’s the average of all starters is used, RB’s and Wr’s are broken up into ranges of 1-15, 16-30, 31-80. So if a RB is ranked 45th in the current week his base projection would be the historical average of RB’s ranked 31-80 in past weeks. Then adjustments from all of the other factors will increase or decrease that base projection. In this method historical stats from each player are not used at all. All of the adjustment values have been determined by analyzing historical data in the same situations over the past 4 years (2010-2013). The situational factors you can choose to use in your custom projections are:

For example, in Week 1 of 2014 Peyton Manning starts with a base projection of 15.9 (based on Fanduel scoring) which is the average for all starting QB’s. Then he gets a 10% increase from the Vegas line since the Broncos are a 7 point favorite against the Colts and historically QB’s in that situation scored 10% higher than average. The Vegas Projected Points for the Broncos is 31 based on the over/under of 56 and the 7 point cushion for Denver. Manning gets a 40% increase from that value because QB’s that have played with Vegas Projected Points of 31 have scored 40% higher than the average QB. The same types of adjustments are made for the rest of the factors if you choose to use them by selecting “Yes” or “No” in the Use? column.

Player History

There are 4 sub-components that you can use to create your own custom player history projection:

You can choose how you’d like to weight each of those components to create your own composite player history projection. For example, during the first 2-3 weeks of the year it doesn’t make much sense to use in-season statistics because the sample size will be too small. In that case it might make sense to split 50/50 between preseason projections and defense-adjusted. Later in the season you might want to use all four elements. Just remember the total weight assigned to each of the four components must equal 1.

Each sub-component contains all relevant fantasy stats including rushing attempts, receiving targets and of course all the stats that produce fantasy points.

 

projection_settings

Rank

The rank method is very simple. Over the last 4 years I’ve computed the average fantasy points scored by each week according to the projected weekly ranking value of each position. The best fit regression line was found to smooth over the anomalies. The starting point (based on Fanduel scoring) is 20.94 for QB’s which decreases by 0.36 points for each rank of QB. RB’s start at 16.47, WR’s at 14.46, and TE’s at 11.8. For example, a QB ranked 10th in the weekly rankings would get a projection of 20.94 – (o.36*10) which is equal to 17.34.

Depth Chart (starting week 4)

Once the season gets into full swing the Depth Chart component will become active. This will look at the average fantasy points scored by the player at each given position on the depth chart from week to week. As an example, say Jamaal Charles gets injured in week 6 and is unable to play in week 7. Charles has been the #1 running back on the Chiefs and he’s scored 17 fantasy points per game. With Charles out the next week someone else (almost certainly Knile Davis) would take over the #1 running back spot. The tool would set a value of 17 fantasy points to the player that assumes a starting role.

Final Projections

Now that you’ve gotten projections using four different methodologies you can choose to weight all 4 of them equally or create your composite projection any way you’d like. The values must add up to 1, but you could choose to give all other methods a weight of 0 if you’d only like to use Player History.

projection_settings2

Manual Adjustments

Once you’ve finished tweaking the settings you can browse through the projections for each of the players. The “Customized Projection” all the way to the right of your sheet is the final value that you’ll be using to create your optimal lineup. If any of those values jump out to you as being wrong you can make a manual adjustment for any player. Simply navigate to the Manual Adjustments tab, enter the players name in the “Manual Adjustments” column (make sure you spell it correctly or it won’t show you a valid projection) and then enter the value you want to add or subtract from the current value. You’ll see the projection change as soon as you enter in a value.

You can also exclude particular players from your lineup if you want to avoid them completely by entering their name into the “Exclude Players” column.

Loading your own custom projections

Alternatively, if you have you own projections that you’d like to use and you’d prefer not to use the projection engine in the file you can load your own set of projections in the “Custom Projections” column of the Manual Adjustments tab. The format needs 2 columns: Player Name and Projected Points. Please be sure that player names match exactly with the Fanduel and DraftKings naming conventions. Loading data in these columns will completely overwrite the projections that the sheet derives so you will no longer be able to make adjustments via the controls.

Optimal Lineups

Once you have your projections set you’re ready to move to the Fanduel Optimal Lineup tab or the DraftKings Optimal Lineup tab. You can only create lineups for one site at a time, but all it takes is the change of the Fantasy Site value in the top left to switch to the other site.

At this stage, all you need to do is hit the “Run Model” button and it should take about 5-10 seconds to generate your optimal lineup. You will get an error message (Compile Error – Can’t find Project or Library) if you have not installed the Solver plugin in your instance of Excel so please be sure to follow the instructions to enable Solver.

The first component you’ll see on the left is the ability to Lock or Exclude players from your lineup. Simply put an “L” next to any player you want to guarantee to be part of your lineup regardless of their projection and an X to prevent that player from ever appearing in your optimal lineup.

Lineup Type Settings

Next to the “Find Optimal Lineup” button you’ll the the Lineup Type Settings. This allows you to gear your lineup towards the type of contest you’re playing in and what factors are important for you when building your lineup. The settings you can choose are based on two factors that are calculated as an average across the entire lineup.

Ownership %: This is an estimate of what the ownership levels will be for each player in DFS contests. This is not going to be exact because you won’t know ownership until the contests start and each contest could be different. Ownership is very important to GPP’s because you don’t want to own too many players that so many others are already going to own. By contrast, you don’t too many lesser owned players in a cash game lineup because that just increases your variance considerably.

Risk Level: This is the frequency at which a player fails to score at least 15 fantasy points. If a player can score at least 15 points – he should at least be serviceable and won’t completely kill your lineup. This metric looks back over the course of the season and identifies the number of games with less than 15 fantasy points and divides by the total games played. A player that has never scored 15 fantasy points would have a value of 100 and the lowest somewhere around 10 to 15.

Cash: High Ownership & Low Risk Level

Cash game settings put a minimum of 12 on the overall ownership percentage and a maximum of 60 on the risk level

GPP: Low Ownership & High Risk Level

GPP games use a maximum of 10 on ownership percentage and a minimum risk level of 50

Custom: Set your own ownership and risk level min and max

None: Create the best possible lineup regardless of Ownership % and Risk Level)

optimal_lineup

 

At this point you should be ready to find the best possible lineup. Hit the Find Optimal Lineup button and you should see the results box change after a few seconds.

Creating Lineups with the Multi-Lineup Optimizer

If you’re interested in getting more than the best possible lineup you’ll want to open the NFL-Multi-Lineup-Optimizer file along with the Projection Tool at the same time. Make sure the files are saved to your computer and you have the file named exactly as it was when you downloaded it from the site.

From the Projection Tool file, click the red “Send to Multi-Lineup Optimizer” button to copy data from the Projection Tool to the Lineup Optimizer. You’ll see an error message immediately if your Projection Tool file is named incorrectly so be sure to have that done first. *If you’re using Excel for Mac 2016 please see workaround below*

Once data is copied over, make sure you SAVE and CLOSE the Projection Tool.

lineup_optimizer

There are 3 new features in the Multi-Lineup tool that were not present in the Projection Tool

  1. Exposure: set a limit of the percentage a player appears in the lineups you request. So if you don’t want Andrew Luck to be in more than 50% of your lineups you would set luck to 0.5
  2. Lineup Lock: you can lock guys into certain positions that you definitely want in all your generated lineups. The tool will fill in the rest with the best possible options
  3. Number of Lineups: This is where you can request the number of lineups you’d like to receive. You should expect the tool to run about 2-3 seconds per lineup requested

Lineup Generator: ALL Possible Combinations

The Lineup Generator is designed to allow you to find ALL possible lineup combinations that can be created from a limited pool of players that you pre-define. This allows you to see how the players that you’re highest on best fit together in a lineup and may reveal similar combinations that you hadn’t thought of. To get your data to the Lineup Generator, click the green “Send to Lineup Generator” button in the Projection Tool *If you’re using Excel for Mac 2016 please read workaround instructions below*. Once this is complete, SAVE and CLOSE the Projection Tool

You’ll see several boxes at each position in the Lineup Generator. This is where you manually enter the players that you’re considering. Be sure not to delete the entire cells, but you can delete the values I’ve pre-loaded and build your own groups of players. You don’t have to use every box (if you only have 4 running backs you’re considering or you’re locked into 1 defense), but you cannot add any additional boxes. There is a hard limit at 3 QB, 6 RB, 8 WR, 3 TE, 6 K/Flex, 2 D

You can use the values on the bottom right to determine how many possible lineups can be generated based on how many players you input.

NFL-Lineup-Generator

 

You’ll want to make sure the “Site” is set to the site you’re building lineups for and then hit the Generate Lineups button. You should see the best possible lineups created from that pool of players ranked in order of highest projected points.

For Excel for Mac 2016 only

The send buttons is currently not supported on so you”ll have to copy data manually between the sheets. Here are the steps for the Multi-Lineup Optimizer:

  1. In the Projection Tool on the Optimal Lineup tab of your choice: Highlight entire columns B:F in the Optimal Lineup tab and choose copy
  2. Paste Special – Values Only into B-F in the Multi-Lineup Optimizer on the FanDuel Optimizer tab
  3. In the Projection Tool Unhide columns J:S in the FanDuel Optimizer tab
  4. Copy columns M-N and paste special – values only into columns K-L on the Multi-Lineup Optimizer file in the FanDuel Optimizer tab
  5. Copy the entire sheet of the Projections tab in the Projection Tool
  6. Paste special > values only into the Static Adjustments tab of the Lineup Optimizer.
  7. Hide columns I:O in the FanDuel Optimizer tab

Steps to send data to the Lineup Generator

  1. In the Projection Tool on the Projections tab highlight cells A13:P2016 (can use CTRL + Shift + Down to get to the bottom of the column)
  2. Paste special – values only into the Projections tab of the Lineup Generator file in cells A3:P1990
  3. In the Projection Tool on the Projections tab highlight cells CU13:CY2016 (can use CTRL + Shift + Down to get to the bottom of the column)
  4. Paste special – values only into the Projections tab of the Lineup Generator file in cells AA3:AE1990
  5. In the Projection Tool on the Projections tab highlight cells DC13:DD2016 (can use CTRL + Shift + Down to get to the bottom of the column)
  6. Paste special – values only into the Projections tab of the Lineup Generator file in cells AH3:AI1990
  • Patrick

    This is great stuff. Like where you went with this. I would be interested in knowing some of the methodology behind these variables and where you are pulling most of your information from.

    • spreadsheetsports

      We’re working on providing more information behind the data. It should be available soon. Most of the raw data is coming from http://www.fantasydata.com.

      • Patrick

        Is fantasydata.com a free source? Cool stuff though. Thanks, looking forward to seeing more.

        • spreadsheetsports

          No – it’s not free. But there are a lot of other data sources out there that can get you most of the raw data.

          • Patrick

            Not really interested in finding the data, just curious about the “mathletics” point of view on this.

      • Eli

        Hi I purchased this software and installed the problem solver like the instructions said but when I hit run model button it foes not work nor create an optimal lineup for me it’s says some error message about macros could you please help me eliottwilliamson@yahoo.com

        • spreadsheetsports

          Eli – yes I tried emailing you, but I think your email address was spelled wrong because I was getting an “Undeliverable” error when I sent it. Here are the instructions:

          The compile error happens when you don’t have the free plugin Solver installed. It’s covered in the User Guide here: https://www.spreadsheetsports.com/support/nfl-projection-tool-user-guide/

          You can also just follow the instructions from Microsoft here: http://office.microsoft.com/en-us/excel-help/load-the-solver-add-in-HP010021570.aspx

          If you’re running Excel for Mac you should have to worry about installing, but you will need to complete this extra step:

          1. Click on Tools > Hover over Macros and choose VBA Editor

          2. Then click on Tools again and choose References

          3. When the reference box opens up you want to make sure the box next to “Missing Solver.XLAM” is unchecked and “Solver” is checked.

          Let me know if you still run into issues.

          • Eli

            Am getting a complied error message I installed the solver add in and am still getting the error message
            Sent from Yahoo Mail on Android

  • cjg13

    Using adjustments for temperature and wind is it better to wait till Sunday morning before setting the lineup since it’s hard to know the wind speed of a game on Wednesday?

    • spreadsheetsports

      Yes – there will be an update on Saturday with the most up to date weather information. You may want to turn those off until that data is ready on Saturday.

  • disqus_tXPk0LXrP7

    I’m playing in a draftking Monday/Thursday game and was wondering if there is a way to filter just the players for those two games? The PHI/IND and ATL/TB games. Do I go into the manual and filter out every team except those 4? I see the Thursday matchup isn’t in the model yet as well…..is there an update for that coming soon or can I manually change that as well?

    • spreadsheetsports

      Sorry for the delay on this – we’re currently set up to focus on games within a single NFL week. Colts-Eagles was week 2 and Bucs-Falcons is in week 3. We’ll look into that, but it may be a while before that can be implemented.

    • Toecutter

      You “could” edit out all but the Monday night game, and the 2 teams that are playing on Thursday, and then put in custom projections for the 2 Thursday teams’ players. Hopefully you have access to some reasonably reliable projections for the following Thursday’s game, or can just come up with your own off the top of your head! But at least the solver would give you an optimal lineup based off those projections.

      • disqus_tXPk0LXrP7

        That’s a good idea Toecutter! Thanks for that. I just discovered spreadsheet-sports about two weeks ago so I’m trying to get used to it still, but I will try that.
        BTW…..does anyone have a way around Microsoft office starter and it not having a add-on feature? I signed up for Office 2013 month free trial off the Microsoft website and then its $7 a month after that. I was also thinking of buying office 2007 which I found on craigslist for $30. I’m 99% sure 2007 is compatible with windows7?…..

  • Alfred

    When do you release the new week’s spreadsheet?

    • spreadsheetsports

      Late Tuesday night

  • Zach

    Would the spreadsheet work with OpenOffice Calc? I don’t own excel.

    • spreadsheetsports

      No – it requires a plugin that’s specific to Excel so as of now that’s the only tool that will work.

  • Dave Olson

    Question regarding your defensive adjusted avgs. Your “How To” states, “Defense-Adjusted averages – assumes that each player will receive his season average number of touches, but uses the opposing defenses’ yards per carry, yards per attempt/target, and TD rate per play to compute values for the offensive player if they performed exactly at the average level of the defense they’re facing. ”

    Would I be double dipping if I also used manual adjustments based upon the matchup?

    For example: QB’s facing the Eagles on avg score 4.6 more points than they are projected. So I took Eli Manning whom is projected for 17.31pts within your model. If I then adjust his points based upon the that 4.6 bump that the Eagles are allowing it gives me 21.91pts for Eli Manning. SO..my manual adjustment was made based upon the 4.6 additional points that the Eagles are allowing to opposing QB’s. Your system already takes into account Defense Adjusted Averages which makes me think the original 17.31pts that Eli is projected ALREADY includes this matchup advantage against the Eagles.

    I just want to make sure I am not Manually Adjusting Points to players that your system has already adjusted based upon the defensive matchup.

    Sorry for the long question but I can email if you prefer.

    Thanks and by the way I LOVE THIS TOOL!!! You’re damn good at what you do! Keep it up!

    • spreadsheetsports

      That’s a good question. I’ve been looking into ways to add that kind of defensive calculation in as well as an option. The Defensive Adjustment currently is just a component of the Player History projection. So it is taking into account the Eagles poor defense against QB’s, but because it’s getting calculated in with all of the other adjustments the effect is likely not that great.

      If you have a set of values that you’d like to use on that I would set the Defensive Adjustment value to 0 and just use whatever combination of Season/Last 3 Games/Preseason Projections that you prefer and then add your own defensive adjustments in as Manual Adjustments on top.

      I’ll see if I can add that logic into the tool because I think that’s a valid way of taking a defensive adjustment into account.

      • Dave Olson

        Thanks for the quick reply man!
        I think you have a great setup now but I just didn’t want to double dip and create a false number. I will make some changes like you suggested and see what comes up.

        Again, thanks for the reply and keep it up!!

  • Matt

    I’m wondering if there is a way to build a lineup sold a certain player? The example I’m thinking about would be like Peyton Manning, if I want him to be my QB regardless of his projection, is there a way to manipulate the program to build a team around him?

    • spreadsheetsports

      Yes – on the Manual Adjustments tab there is a section called “Lineup Guarantee.” Put any player in there that you’d like to build around and they will appear int he Optimal Lineup regardless. It obviously won’t work if you put too many top players in there and their salary is over the limit, but it should allow you to create lineups with 3-4 guaranteed guys.

  • Cacee

    Just bought the spreadsheet and I was wondering if there was a way to make the lineups gpp or cash. Is there an option to change that?

    • spreadsheetsports

      There’s not a specific setting for GPP or cash. Using the “Ceiling” projections could be one way to create a lineup for a GPP. For cash games I would recommend the default settings.

  • kchristo

    I seem to be having issues with the “Exclude Players” component of “Manual Adjustments.” First, I tried using the “Exclude Teams” to filter out teams from the 1:00 PM (EST) games so I could optimize a lineup for the afternoon/night games. I tried multiple formats; e.g. MIN, MINNESOTA VIKINGS, Minnesota, Minnesota Vikings, Vikings, VIKINGS, etc., but was unsuccessful at getting the solver to exclude players from these teams. Then I compiled a list of players from the day games using the “Projections” tab and filtering (de-selecting) the afternoon/night teams under “Team” column. I copied/pasted those names into the “Exclude Players” list to no avail once again. Can someone please provide some input to the problem.

    GREAT tool by the way! I was considering developing something like this myself but clearly there’s no need to re-create the wheel. Thanks.

    • spreadsheetsports

      To use the Exclude Teams functionality all you need to do is type in the team abbreviation in the Exclude Teams column on the Manual Adjustments tab. Make sure it matches the Team column from the Projections tab. So in your scenario, MIN would have been the correct abbreviation. What actually happens within the spreadsheet when you do that is that each player on those teams gets their projection set to 0. Then, when you re-run the optimal lineup it will not choose any of those players. If you’re loading your own custom projections, the Exclude Teams functionality will not work.

      • kchristo

        Thanks for the reply. Practically right after posing the question I realized I had custom projections which I deleted and it immediately resolved the issue.

  • kchristo

    Unfortunately, fanduel restricts your roster to allow a maximum of 4 players from the same team. I was wondering, are there plans to account for this in your algorithm? Or is there currently a work-around for this limitation?

    • spreadsheetsports

      I don’t plan to include it for NFL. There are a couple reasons: 1. It slows down the tool considerably 2. Getting 5 people from the same team in an optimal lineup doesn’t happen all that often in full schedule NFL contests 3. There’s a fairly simply work-around – if you run into that issue just exclude the player you like the least from that team and run the optimal lineup again.

  • Don Skwierczynski

    Just purchased and Love the NFL tool but not sure where to set the player history settings
    For week 7. Should I always leave the defense at .50?

    • spreadsheetsports

      That’s up to you. I leave the defense at .50 in the default settings because matchups are a big factor on fantasy performance, but you can tweak the settings to whatever works best for you.

  • FlipJack

    Just started playing around with the spreadsheet on Excel for Mac. I’ve setup Solver as described above (including going through the extra Mac steps). I get a lineup after hitting “Run Model” but I also get a popup that says “Solver Found an Integer Solution within tolerance.” I’m assuming this is ok and I should hit “Keep Solver Solution.” After clicking “OK” I get another message that says Runtime Error ‘1004’: Method ‘Calculation’ of object ‘_Application’ failed. Is this normal? Is it ok to just hit “End?” thanks!

    • spreadsheetsports

      Yes – the first message is telling you that it found an optimal lineup – so just hit OK. The second message is something that only happens on Mac because of the differences between Excel for Mac and the Windows version of Excel. It’s a false alarm message – everything worked as expected so just hit end.

  • Chris

    I just downloaded the NFL Projection spreadsheet and i’m having trouble with the run model. it keeps giving me unable to run NFL projection tool due to macros, but when i disable them and run it again all i get is coding. I don’t know if you can help or if it is just a setting on my laptop. just FYI I have a new laptop with 2013 Microsoft office. thanks

    • spreadsheetsports

      Chris,

      Send me a screenshot of the error message you’re seeing (bryan@spreadsheet-sports.com). On Excel 2013 you can enable Macros by clicking on File > Options > Trust Center > Trust Center Settings > Macro Settings. Make sure the option for “Disable all Macros without notification” is not selected. All others should be fine. If you’re getting a “Compile Error” here are the instructions you should follow:

      The compile error happens when you don’t have the free plugin Solver installed. It’s covered in the User Guide here: https://www.spreadsheetsports.com/support/nfl-projection-tool-user-guide/

      You can also just follow the instructions from Microsoft here: http://office.microsoft.com/en-us/excel-help/load-the-solver-add-in-HP010021570.aspx

      You may also want to shut down Excel completely and restart for the Solver installation to take effect.

  • 777Mike

    Do I have to manually change the opponent every week?

    • 777Mike

      Ummm…..never mind. I figured it out!

      • spreadsheetsports

        Week 8 will be posted later tonight. Everything will be loaded then with the correct matchups when you download the new sheet.

  • 777Mike

    When I run the Run Model its not populating the Defense or Kicker. Its coming up with #N/A.

  • AZ

    I’m having trouble with the Run Model. I went ahead and enables macros, and followed the process suggested here for Macs. However, it still doesn’t want to run and “Run Model” can’t even be clicked on.

    • spreadsheetsports

      Is there some kind of error message you’re getting? I’m not sure what you mean by “can’t even be clicked on.” Does it just do nothing or does some kind of error message pop up?

      • AZ

        It wasn’t doing anything at first. Now, it seems to start running but I get the following error message: “Run Time Error ‘1004’: Method ‘Calculation’ of object’_Application’ failed”

        • spreadsheetsports

          Make sure you’ve gone through the instructions for Mac:

          1. Click on Tools > Hover over Macros and choose VBA Editor

          2. Then click on Tools again and choose References

          3. When the reference box opens up you want to make sure the box next to “Missing Solver.XLAM” is unchecked and “Solver” is checked.

          You may also want to shut down Excel completely and restart for the Solver installation to take effect.

          • AZ

            Thanks. I went ahead and shut down Excel. It is all working now.

  • Tyler Brennan

    I cant get the solver to work, I have added in the add in needed I get a Compile error: cant find project or libary. On a PC

    • spreadsheetsports

      Tyler – you may want to shut down Excel completely and open the tool again to see if that works. Sometimes it doesn’t recognize it right away if you just installed Solver. You can tell if you have it installed if you click on Data in the top ribbon and see Solver as one of your options. Let me know if that doesn’t get it working.

  • EJ

    The “Already Purchased” link is not working properly for me, after I sign in it is requiring me to purchase the season again. I checked my bank statement and it shows I purchased the season not the monthly.

    • spreadsheetsports

      Please send me an email (bryan@spreadsheet-sports.com) with the email address you used to sign up. I’ll find your subscription and make sure you have access.

    • fred

      Ej u get your work right?

      • EJ

        Yeah Bryan helped me out, it was a mistake on my end.

        • fred

          a how do make a line to just run 4 team on this

          • EJ

            I go to “Manuel Adjustments” and under the “Exclude Teams” tab I enter the INITIALS of each time that I do not want players from. All the teams besides the ones you want playing

          • spreadsheetsports

            Fred – if you’re looking for the tool to work for Monday-Thursday matchups – it’s not set up to do that. Only single week contests are supported right now.

          • fred

            ooooooo ok thanks

  • fred

    do you have to keep downloading this system to get in.how do i egt in without downloading over over.i log in in but it keep asking me for money

    • spreadsheetsports

      Fred – you should be able to login here: http://www.spreadsheet-sports.com/nfl-update. You purchased the full season pass so you should choose “Already Purchased” under ALL Daily Sites for $49.99 and login with the account you created during signup. Let me know if that works for you. Please send any further login questions via email to bryan@spreadsheet-sports.com

      • fred

        can you give me a Quick call for i can get my Line up before Game start Please

  • fred

    i try that but it’s carry to my paypal to resign up. it’s making download over and over again .i’m trying to download it one time and for it can be on my desk top or i can just go to any computer and get on with down loading it anyway

    • spreadsheetsports

      You can download it onto your desktop and save it there – and then refer back to it whenever you’d like. It’s just an Excel file so you save to any location. You’ll need to download on each computer you’d like to use it though. You should not have to pay again – click on “Already Purchased” under All Daily Sites for $49.99 and then login with your Tinypass account. Your username is your email address. The FAQ page also has some helpful tips: https://www.spreadsheetsports.com/support/faq/

  • fred

    ii thought this do Bball too but guess not

  • NightOwl1

    if I were to buy this package would I thn download the solver?

    • spreadsheetsports

      Solver is a free add-in to Microsoft Excel. You just need to enable it for it to work.

      • NightOwl1

        when I download tha dd in for solver am I suppose to have the other options checked:analysis toolpack, analysis toolpak-VBA and euro currency tools?

  • NightOwl1

    how do I know my optimal lineup has been created. I’m not savvy with excel. Do I highlight the adjustments or somethingso it can calculate. And I only play on Sundays so I missed out on using dez bryant. Will it create another lineup because it didn’t when I tried

    • spreadsheetsports

      When you click the Run Model button it should take into account all of your adjustments and create a new lineup. I’ve added the game selector to the Projections tab so you can remove DAL-CHI from the options by putting a 0 in for that game. After you click Run Model it should take about 5-10 seconds to find a solution and then you should get a pop-up box saying a solution was found. Hit OK and your new lineup will show up. The beginning of this guide shows how to get Solver installed.

      • NightOwl1

        I do not see the game selector. when I run model it still shows dez bryant a player from the DAL-CHI game/ That is game is over is there anyway that I can get it ti run with different players without having to customize it myself. Like I said I’m not savvy with excel. So any advice helps please and thank you

      • NightOwl1

        ok I figured out how to remove players from DAL-CHI game but when I select run model dez bryant is still in the projection. am I doing something wrong?

        • spreadsheetsports

          You have to hit Run Model again to get a new lineup. The Game Selection grid is on the top right of the Projections tab. You may have to scroll over to see it

  • NightOwl1

    so your projection tool was way off this week for the NFL. And I’m sure I will not be refunded

    • spreadsheetsports

      What was way off? Were there specific players that underperformed? You have the ability to edit any projections that you don’t think are accurate.

  • NightOwl1

    Lesean McCoy way off and delanie walker, kyle Rudolph lost a lot of money today

    • spreadsheetsports

      McCoy was our 10th ranked running back this week. On FantasyPros he was 11th. So it’s unfortunate he had a bad game but a projection of 5 points would have seemed way too low considering his last few games. Walker and Rudolph both had extremely favorable matchups. Walker was presumably the best receiving option on his team. Sometimes it just doesn’t work out as you’d expect.

  • NightOwl1

    so I have lost all of my money using your tool. project points don’t come close

  • NightOwl1

    your projection tells me to put the same players each week lesean mccoy, joique bell etc and only once since I have used them they actually met there projected points or came close to it. no worries I already bought your product. Just lets me know not to longer pursue it

    • spreadsheetsports

      Sorry to hear that, but it’s a tool – not a magic ball. Any set of projections are going to be “off ” to some degree. The default projections in the tool have compared favorably to aggregate projections on FantasyPros throughout the year. There’s even functionality to load your own projections from any other source if you’re not happy with ours.

  • NightOwl1

    And that’s exactly the response I will pass on to those who are inquiring about your services. Great customer service!

  • ChicagoRolls

    Just purchased the NFL tool for the 2015-2016 season this morning, and having used the MLB tool this season, I can say the tool is great and so is the customer service.
    I’m really hoping Brian will have the CFB tool ready soon, as I’ll be purchasing it as well!

  • Ed Risha

    I used the baseball tool all year and I am impressed. Just purchased the football tool and hoping to see a college one one day. Thanks.

  • Cbailey

    I noted that the Draft solver parameters are only set for J2:J201 however the data runs through row 1026. Is the model at risk of not identifying any of the players in the J202:J1026 range? Please advise.

    • Cbailey

      Any insight on my question?

      • drewbie

        Solver can only have 200 inputs

  • Ryan Slade

    So basically, I could import projections from profootballfocus.com and then adjust their rankings by applying vegas lines, weather, etc to them? And could I adjust how much weight is added to each “adjustment”?

  • Justin Willmon

    Just bought this and am trying to get it figured out. Everytime I set my setting for the projections and then try to go in and hit “find optimal line up” button, it takes me to a Microsoft visual basic for applications page. Then a command box comes up that says “Complie error: cant find project or library.” Not sure what I need to do, I have already added the add in solver, but it still does it no matter what I do.

    • Ryan Slade

      Justin- Im still waiting for an answer to my question from the mod, but found this from an earlier question and it might help you.
      “Tyler Brennan
      I cant get the solver to work, I have added in the add in needed I get a Compile error: cant find project or libary. On a PC

      spreadsheetsports Mod Tyler B
      Tyler – you may want to shut down Excel completely and open the tool again to see if that works. Sometimes it doesn’t recognize it right away if you just installed Solver. You can tell if you have it installed if you click on Data in the top ribbon and see Solver as one of your options. Let me know if that doesn’t get it working.”

      or maybe turning on macros

      “On Excel 2013 you can enable Macros by clicking on File > Options > Trust Center > Trust Center Settings > Macro Settings. Make sure the option for “Disable all Macros without notification” is not selected. All others should be fine.
      You can also just follow the instructions from Microsoft here: http://office.microsoft.com/en…”

    • spreadsheetsports

      Justin – are you on a Mac? If so, follow these instructions:

      1. Click on Tools > Hover over Macros and choose VBA Editor
      2. Then click on Tools again and choose References
      3. When the reference box opens up you want to make sure the box next to “Missing Solver.XLAM” is unchecked and “Solver” is checked.

      Let me know if that works

      • Justin Willmon

        No im on a windows computer at the moment. Its running windows 8.

        • spreadsheetsports

          You should be able to check if the Solver plugin is installed when you’re on the Optimal Lineup tab by clicking on Data in the top Excel ribbon, then Solver and choosing Solve. If it runs successfully then you know you have Solver installed and you may just need to shut down and restart Excel for it to fully take effect. If you don’t see those options then you’ll need to go through the steps of installing the Solver plugin again.

          • Doug

            Having the same problem.

          • Doug

            Figured it out.

  • Dave

    Can’t get the system to only include Monday’s games. I changed the 1’s to 0’s for all the other teams, went into manual adjustments and excluded all the other team that way, too. Still keeps giving me a lineup with guys that played yesterday. I’m pretty sure I don’t want Kirk Cousins tonight.

  • Doug

    When does the Week 2 (2015) spreadsheet come out? I just purchased and received Week 1. Tried to update but got the same data.

    Thanks!

    • Adam Ford

      I just noticed that Doug, the week is not changing the schedule at the right no matter what I enter. Even stranger is that no questions on this board have been answered. Is there support for the product?

      • Brad Richoux

        Did y’all figure out how to get the updated weeks data? I only see week 1.

  • Adam Ford

    I’m getting #N/A on multiple positions in my optimal line up and I only changed from week 1 to week 2

    • Adam Ford

      nvm got it!

  • Dave

    When I run the fanduel optimal lineup, The only positions with projected points and value are the D and the kicker. Matt Hasselbeck is the QB. What’s going on?

  • Greg

    I’m having issues with the multiple lineups optimizer- currently for DK it freezes whenever I input more than 5 lineups, at 5 or less, all of the lineups are the exact same lineups, and are missing a RB2, WR3, DST and Flex- any advice?

    Mac Excel 2011 with Solver checked under macros

    • Sean

      Greg, did you figure it out because I am having the same issue!

    • Tony Brindizzle

      I am having the same exact problem! Please share answer if figured out

  • dh

    how do i download all of the stats from week to week as the season goes on so that all the projections are correct and updated

  • ChicagoRolls

    Hello, when will the CFB tool be updated for week 4? It still has week 3 on the DL page.

  • Ed Harris

    Hey were does the date go. I run the search for players and it come up with game that have been played already

  • Ed Harris

    This is showing the wrong games when I run the search. I choose week 3 and it’s not pulling info for the right game

    • Brad Richoux

      Did you ever figure this put. I keep getting week 1 info?

  • ChicagoRolls

    For the DK early slate for 10/3/15, the CFB tool is giving me James Conner in my optimized lineup and he is OUT for the season, (since week 1 I believe). Any idea why this is happening? I changed nothing in the setting before running the optimized lineup.

  • Brad Richoux

    How do I get current data. I purchased today and can’t seem to get week 5. I am entering 5 in the the week field?

  • Josh

    #NA shows up for a few positions when using the lineup optimizer. How do I resolve this problem? I am using excel 2016 with the solver installed.

    • tabagit

      I have the same problem with #NA. Also using Excel 2016 with Solver installed.

  • Connor

    Im running the multi lineup optimizer and a pop up keeps coming up saying that the maximum time was reached and then it just keeps going and doesnt give me any lineups. Any help?

  • BobLove

    I get #N/A for every position every time I run the model as a “cash” lineup type. It appears to build a line up quickly but once it is complete is clears it all out and everything fills in #N/A. Thanks for any help.

  • mason

    this is really making me mad. I just purchased it and it is still showing week 5 lineups…….please help

  • TJ

    I am having the same problem as Justin reported a month ago:

    “Just bought this and am trying to get it figured out. Everytime I set my setting for the projections and then try to go in and hit “find optimal line up” button, it takes me to a Microsoft visual basic for applications page. Then a command box comes up that says “Complie error: cant find project or library.” Not sure what I need to do, I have already added the add in solver, but it still does it no matter what I do.”

    I am on a MacBook Pro and using Excel 2011. When I click on ‘Tools,’ I was able to ‘Macros’ then VBA Editor; but it does not bring up ‘References’ as a selection.

  • Tony Two Toes

    New to this and am not as savvy as I used to be with Excel. I am having issues using the multi lineup generator. I seem to be able to get over the necessary information to the tool but when I ask it to generate, I get an excel error saying “excel not responding”. Now, I am trying to generate about 400 lineups using quite a few players and know that this will take a while but I left it over night and nothing comes up. Also, I am using Excel 2016 and just noticed the requirements. Is 2016 excel not compatible with 2013 excel and if not how or where do I get the 2013 version? Hope to hear from someone who can help. Thanks

    • spreadsheetsports

      Tony – can you shoot me an email to discuss further? Excel 2016 should work fine, but there’s a workaround if Solver won’t engage at all (which some customers have been reporting on 2016, but that doesn’t seem to be the case for you). I need to know which file you’re using (Multi-Lineup Optimizer or Lineup Generator and if you’re on Windows or Mac). Email: bryan@spreadsheet-sports.com

  • Steven

    What/where is the “Run Model” button? Is it the same thing as the “Find Optimal Lineups” button on the Optimizer tab?

    • spreadsheetsports

      Yes – that button changed to Find Optimal Lineups recently. I need to get the guide updated to reflect that.

  • aaron

    how do you transfer your line-ups to draft kings?

  • Brady McManus

    I can only get week 8 data? How do I pull the games for week 9!!!

    • Brady McManus

      I can’t believe in all the videos they don’t cover once how to update the weekly data… Frustrating! Love the tool but useless without new data. The way they do it on the NBA tracker is so simple

  • gsamuel

    None of the projected data from the projected tab is copying over to the fanduel optimal lineup tab. Also, optimal lineup tab is ignoring the games to include/exclude list, also its ignoring the manual adjustments list…? a couple of hours til kickoff… using Excel 2016 for mac.

  • Michael Heninger

    I’m getting an #NA error on multiple positions on my optimal lineup. Suggestions?

  • Matt DiRisio

    Hi guys, when I try to send my projections to the multi-lineup generator I get an error message saying “subscript out of range.” Any experience with that?

    • spreadsheetsports

      Yes – please see the Excel Troubleshooting Guide tab within the spreadsheet. The solution to that is explained there.

      • Matt DiRisio

        Still not working, and the names are exact, the two files are open in the same excel 2010 instance and there doesn’t seem to be a problem with the “editing” function in solver (no yellow bar). But in getting the same error about subscript out of range.

  • ICUDoc

    Does not seem to be working properly for the Thursday only slate – when I exclude all but the three Thursday games today it picks just those from the Thursday night game (GB/CHI) and ignores players from the other two….

    • spreadsheetsports

      If you re-download it should now be fixed

  • Jim Haytas

    When I push the red button for multi lineup generator it give me an error: Run time error ‘9’ subscript out of range. Please help. I saved my projection too just like the guide had suggested. Can’t seem to figure it out

    • spreadsheetsports

      It’s likely that one of the file names is slightly different than how it was on the site. For example, your browser may have added a (1) to the end. The tab labeled Excel Troubleshooting Guide inside the spreadsheet has some additional tips. If that doesn’t work – email me a screenshot of your file names. If you hit Debug when that message comes up it should be very clear what the issue is.

      • Jim Haytas

        Ok, so I cleared out all my downloads and documents with excel. Downloaded the Projection tool, got a line up set, downloaded the multi line up generator then hit the red button and got this: run time error “1004′ we cant do that to a merged cell. I hit debug and it shows me module 11 with a yellow arrow pointing to Selection.Copy

        • Jim Haytas

          figured it out, some how when i was selecting the games it merged all the sunday 4pm games

          • spreadsheetsports

            Glad you got it working!

  • PTP

    Are their known issues with Excel 2016? I see some possibles down the list here, but have not seen my error: Exception from HResult 0x800a03a

    • spreadsheetsports

      Yes – follow the instructions for Solver under Excel 2016. You’ll need to download the Reset Solver file linked on that page and open it first in Excel and follow those instructions before opening the Projection Tool

      • PTP

        Thanks a lot. I figured I was doing something wrong.

  • Robert Pacifico

    I’m loving everything I’m reading but I’m curious if I need to be excel literate to use this amazing program? If not I’m all in…I’m sick of losing every week lol

    • spreadsheetsports

      Being comfortable with Excel will definitely help you, but it’s not a requirement. Once you look through our User Guide and Troubleshooting Tips you should be able get the initial configuration set up and from there it’s just clicking a button or 2 to refresh and find the Optimal Lineup.

      • Robert Pacifico

        Thanks for the quick response. I did purchase the program I like the way it performs. However, I not sure if I made a mistake but when I was using multiple lineup generator I was seeing a lot of player names that should ng have been there. Can you explain how I could fix this?

        • spreadsheetsports

          Yes, you need to “send” the data from the Projection Tool to the Multi-Lineup Optimizer once you have everything set the way you want in the Projection Tool. Make sure the files are named as they were when you downloaded them from the site and have both open in Excel at the same time. Then hit the “Send to Multi-Lineup Optimizer” button on the Optimal Lineup tab of the Projection Tool. Let me know if that works for you.

  • Scott McClellan

    Can anyone confirm that they have been successful using this?