Baseball Projection Tool Guide

By: Bryan Povlinski

System Requirements

Getting Started and Downloading Excel Files

  1. Now that you have Excel configured with everything you need you’re ready to open the main file. Download the file titled “MLB Projection Tool”. This file will be updated each week so you’ll need to come back to the site to get the most current data. If you have the FanDuel or DraftKings only package the file will be named “MLB FanDuel Projection Tool” or “MLB DraftKings Projection Tool.”
  2. The next file you’ll need is the MLB-Multi-Lineup-Optimizer. When you download this file you can’t just open it right away because the Projection Tool won’t recognize it. Instead, save the file to a location on your computer (it can be anywhere…Desktop, Downloads, separate folder, etc.) Then go back to Excel where you already have the Projection Tool open, click File > Open and go find your MLB-Solver file. You’ll need to make sure when that file gets saved it’s named exactly “MLB-Multi-Lineup-Optimizer.xlsm” If you download that file multiple times you might get a (2) or (4) added on to the end of the file name.

Using the Projection Tool

1. Refresh the spreadsheet to the current day’s data on the Daily Lineups tab

Simply click the “Refresh Data to Today” button on the Daily Lineups tab. This will refresh all of the data sources in the tool to the current date. You can analyze a Custom Date by entering a different date in the “Custom Date” field in the top left of the Daily Lineups tab, but starting lineups will only be set for the current date. In that situation, default starting lineups will be used. Also, be aware that official starting lineups are released at different times throughout the day. The sheet references Baseball Press so what you see there will be included in the tool. Anything not yet posted will revert to a default starting lineup.

You can manually adjust lineups on this tab if they haven’t been updated yet and you know from another source who is likely to play.

daily-lineups

2. Hunches & Exclusions

There are 6 main functions you can perform from this tab:

  1. Select the list of games for the slate you’re playing by using a 1 for any game you want included and a 0 for any game you want to remove (on the far right of the tab).matchup_list
  2. Exclude players that you want to make sure are not included in your starting lineup. Assuming you updated the lineups in the previous step you should only be getting projections for players that are expected to start. However, there may be players that you want to make sure are avoided. Check the Adjustment Selection tab for official player names, but simply enter the players name into that column and that will effectively set his projection to 0.
  1. Exclude teams that you want to make sure are not represented at all in your optimal lineup. You should enter team abbreviations as they appear on the Adjustment Selection tab. This can be useful for games that you expect to be rained out or for late/early games that don’t apply to your exact contest.
  2. Add points to a given player’s projection because you are confident that player will have a big game and you want to make sure that player is in your lineup. Simply add the player’s name and you’ll see his current projection appear. Then you can enter a new value that will get added to or subtracted from that player’s projection.
  3. Guarantee players to appear in your Optimal Lineup by listing the player in the Lineup Guarantee column. Make sure you spell the player’s name as it appears on FanDuel or DraftKings.
  4. Load your own custom projections to be used with the tool. If you choose this option – all of the different adjustment options or player exclusions are no longer applied. You will just get an optimal lineup based on your list of projections.

hunches-exclusions

4. Projections

On this tab you’ll determine the settings you’d like to use to generate your custom set of projections. Make sure you change the Fantasy Site setting in the top left to FanDuel or DraftKings based on the site you’d like to create a lineup for.

On the right you’ll see the Time Period used for baseline stats. The primary metric being used across the tool is Fantasy Points per Plate Appearance. That is calculated as fantasy points scored (based on the site specific settings) per each plate appearance historically. Runs and Stolen Bases (+ Caught Stealing) are computed at the per game level since they are not necessarily dependent on plate appearances.

There are several different factors that you can choose to use for determining each player’s projection. Most the adjustments are Yes/No options. Either you use that adjustment for all batters or you don’t use it at all.

projections-tab

Adjustments for Batters

Betting Situation – currently set to add 5% onto the projections for any batter playing in a game in which their team is favored and subtract 5% for any batter that’s playing on an underdog.

Betting Total – This takes the Vegas Over/Under for the game, divides by 2 to get projected runs for each team and multiples by 1.1 if a team is favored and by 0.9 if a team is the underdog. Then the betting total adjustment adjusts up or down based on how many projected runs a team is expected to score divided by a historical average of 4 runs per game. So if a team is projected to score 4.3 runs the calculation would be 4.3/4 for a value of 1.075.

Pitcher Strength – compares the average fantasy points allowed by the opposing starting pitcher to a historical average for all pitchers. Adjusts the batter’s projection up or down accordingly compared to how far off the pitcher is from the historical average. So if a pitcher like Clayton Kershaw allows 0.75 points per game to batters relative to an average pitcher then a batter facing Kershaw would have his projection multiplied by 0.75.

Pitcher Throwing Hand – adjusts for career batting performance depending on the throwing hand of the pitcher for each batter. If a batter scores 0.5 fantasy points per plate appearance against left-handed pitchers but scores 0.6 fantasy points per plate appearance overall (against all pitchers during his career) then the adjustment value would be 0.83 (0.5/0.6). The batter’s final projection would be multiplied by 0.83.

Pitching Ground/Fly – adjusts for career batting performance for each batter depending on the tendency of the pitcher to give up groundballs or flyballs more often

Pitcher Power/Finesse – adjusts for career batting performance for each batter depending on whether the opposing pitcher could be characterized as a Power Pitcher or a Finesse Pitcher

Ballpark – Based on how much offensive production a ballpark has historically produced relative to other ballparks. Data from FanGraphs Park Factors

Batter vs. Pitcher – Finds the difference between fantasy points per plate appearance for each player against the specific pitcher they’ll be facing for the day and that player’s overall career average. Many of these matchups have very few plate appearances to draw from. There is a BvP At-Bat Minimum threshold in the top left that you can set to ignore any BvP matchups with fewer plate appearances than you’ve chosen. By default it’s set to 40 so it will ignore any BvP matchups with less then 40 historical plate appearances, but you can change that you whatever you’d like.

Time Period for Baseline Stats

To get the baseline stats for each player you can choose the time period that you’d like to apply to all players. The options you have for batters are:

The % Used should add up to 1 for each of these time periods. For example, if you want the baseline stats to be generated using 50% of the batters’ preseason projection numbers and 50% of the current season numbers then you would put 0.5 on preseason projection and season. If you’d like to generate the baseline stats using a combination of all 5 time periods you can set each of them to 0.2. In that scenario the tool will use this calculation:

FPG (fantasy points/game) = Fantasy Points per Plate Appearance * Projected Plate Appearances + Runs and Stolen Bases per Game

(Preseason Projection FPG * 0.2) + (Season FPG * 0.2) + (Last 30 days FPG * 0.2) + ( Last 14 days FPG * 0.2) + (Last 7 days FPG * 0.2)

For pitchers the same calculation applies, but only time periods for career and season are available.

There’s one additional adjustment that you can choose to use for pitchers:

Points Against – adds up all of the projected points for the opposing lineup and compares it to all other pitcher matchups for the current day. If you use the adjustment it will improve the projection for pitchers against a weaker lineup and lower the projection for pitchers facing a difficult lineup.

Optimal Lineups

At this point you should have all of your projections set. Now you’re ready to find the Optimal Lineup based on all of your custom settings. First, make sure you have the “Fantasy Site” setting on the correct site before you move to the FanDuel Optimal Lineup or DraftKings Optimal Lineup tab. If those are out of sync, you won’t get the correct salaries and projections for the site you’re trying to build a lineup for. Then head over to the Optimal Lineup tab for the site you want a lineup for.

solver

Stack Settings

The Stack Settings box provides the ability to ensure that you’ll get the best “stack” of players from a team you specific. For example, if you think the Rangers have an outstanding matchup against a poor pitcher with a high over/under you might want to stack up to 4 Rangers on your roster hoping they all have big games. In the Stack Settings box you can enter a Team Abbreviation and then a number of players from which you’d like to stack. Be sure you don’t make that number greater than 4 because you can only include a maximum of 4 players from a single team in your lineup.

Finally, hit the Find Optimal Lineup button for Excel Solver to run and generate an optimal lineup. You’ll see a progress % in the bottom left corner of Excel, but it typically will take 20-40 seconds to run and create your lineup. You’ll see a pop-up appear asking if you want to Keep Solver Solution. Click OK and your mathematically optimal lineup according to your projections will appear.

If you want to get multiple lineups based on your custom settings you’ll need to make sure you have the MLB-Solver file open (with Editing Enabled) and then hit the “Send to Solver” button. At this point you should save and close the Projection Tool. If you leave it open while the MLB-Solver file runs it will take considerably longer to run.

MLB Multi-Lineup Optimizer

After you close the Projection Tool – you’re ready to run the solver file and get as many lineups as you want from your custom settings. You can change the number of lineups in the box to the right. The tool is setup to find 10 lineups by default. If you change that value you may not see the full formatting applied to every lineup, but you’ll still get as many lineups as you request. You can Exclude or Lock any player in the list by using a capital X or L in the first column. Expect FanDuel lineups to take about 5-10 seconds per lineup so 10 lineups would be generated in about 1 minute and DraftKings lineups will take longer at 20-30 seconds per lineup. This is due to DraftKings’ added complexity with players eligible for multiple positions.

multi-solver

You’ll then be taken to your lineups with additional stats listed for each player selected. You can always go back and re-run it and exclude or lock players based on your preference.

final-lineups

Lineup Generator

The Lineup Generator first requires you to send refreshed data from the Projection Tool by clicking on the “Send to Lineup Generator” button on the Optimal Lineup tab of the Projection Tool. Make sure your file names are the same as when you downloaded them from the site. Once the data is transferred you’ll want to save and close the Projection Tool.

generator1

Next, you’ll want to click the “Enable Fast-Editing” button on the right so that you can quickly add new players to your list of preferred players on the first tab. You’ll need to manually add players to each position in the blue boxes. Once you have all the players listed that you’d like to consider – you can hit the Generate Lineups button and all of the combinations from the players you’ve listed will be ranked on the Ranked Lineups tab. Ignore the error (just hit End) if you don’t want a CSV created for upload directly to FanDuel or DraftKings

If you want a CSV of your lineups generated that you can upload directly to FanDuel or DraftKings – make sure you open the “FanDuel Upload Template” (or DraftKings Upload Template) in the same folder as the Lineup Generator file. This will automatically create your CSV file through the lineup generation process.

Lineup Generator video walk-through

Differences with Excel for Mac 2011

If you’re using Excel for Mac 2011 there is a separate file optimized specifically for your version. You should follow these instructions.
1. Open the Projection Tool and Refresh Data to Today.
2. Open the MLB-SolverMac file and make sure you have the Projection Tool and the MLB-SolverMac file named as they are on the site.
3. On the Optimal Lineup tab within the Projection Tool click “Send Data to Solver
4. At this point – save and close the Projection Tool.
5. Click Run Model in the Solver file. (you’ll need to make sure you follow the standard steps to get the Solver plugin connected in the Solver file – see the Troubleshooting Tips tab)
At the end you may see a 1004 application failed error. This is a false alarm error message that occurs because of a difference between Solver on Mac vs. Windows. Everything has run as expected – just hit End and you can continue to use the sheet like normal.

Video Walk-Through


Tips and Troubleshooting

I will add to this section based on feedback that I get…

  • Pingback: Introducing the Daily Fantasy Baseball Custom Projection Tool - Spreadsheet Sports | Spreadsheet Sports()

  • Pingback: MLB Custom Projection Tool Video Walk-Through - Spreadsheet Sports | Spreadsheet Sports()

  • Jason

    I am looking into how to perform the manual updates and In the last section it states “Open the CSV that your browser downloads with Excel and then copy the entire sheet and paste the entire sheet onto the Last 7 tab in the Projection tool. You can do the same thing with Last 14 and Last 30 if you wish. Just change the “Split” value on the Fangraphs page to the time period you want.”

    I do not see a tab that is listed as “Last 7” to be updated. I am going through a dry run to identify all of the functionality.

    I also do not see any formulas on the “All Batters” tab that would be affected by any data table change. (Basically a change in last 7). I am really looking to see the functionality of the projections on the “All Batters” tab.

    Is this because the sheet is not in full production yet?

    • spreadsheetsports

      The User Guide will be undergoing an overhaul this week to incorporate all of the new updates. What I’ve tried to get away from is any need to manually update through CSV’s, player pools, etc. It should all get automatically refreshed from the data I’m hosting on the backend and updated regularly. Shoot me an email on what you’re trying to accomplish or would like to see and I’ll see what I can do to accommodate.

      • Ty

        What is your source for the betting lines sheet? And historical data?

        • spreadsheetsports

          Betting lines come from sportsdatabase.com and historical data is a combination of Fangraphs, Baseball-Reference, and FantasyData.com

  • Sneakyb97

    Hey Bryan, just downloaded the tool. Looking forward to the season with it. I do have a couple questions. The projections seem awfully low. Is that because of all the aces going today or could I be doing something wrong?

    Also, I noticed you use Career numbers for the Pitchers base projection instead of Steamer Projections like you did for the hitters. I would think Steamer projections for the Pitchers would also be very valuable and accurate. Are career numbers for the Pitcher base projections a more accurate projection?

    This is my first experience with the MLB tool, so I’m learning on the go. Thank you!

    • spreadsheetsports

      Good call on the pitchers. It actually is using the same Steamer projections there, but it’s labeled incorrectly. I will update that tonight. Previously, I was using career numbers and I switched to the projections at the end of last season but never changed the headings for pitchers.

      Can you give me more detail on what you’re seeing as being awfully low? Are there any specific examples that you would expect to be a lot higher?

      • Sneakyb97

        Bryan, thank you for the feedback on the Steamer projections. Their numbers have been very useful in past seasons.

        Regarding the low projections, the average points per game for each player is much higher than today’s projections… example being Kershaw with a career avg of 30, but today’s projection is only 16. And Jose Abreu has an average of 9 but today is only projected for 3. The Pitcher projections seem more off than the hitters. Maybe I’m doing something wrong. My optimal lineup was only for 65 points. That doesn’t seem right, does it?

        Also, the daily lineups don’t appear to be updating even after being available on Baseball Press, and after clicking on “Refresh Data to Today.” Any thoughts?

        • spreadsheetsports

          I see the issue now with the lower projections. That will be addressed in the update I release tonight. You may want to join the Google+ group I have set up for product updates: https://plus.google.com/u/0/communities/111652855276551522282

          The refresh will also be addressed. You can force a refresh though by right clicking on any tab, choosing Unhide, then selecting “New Parser”. On that tab right-click cell A1 and choose refresh. That will manually force a refresh, but this will be made much simpler in the update tonight. Thanks for sending in the feedback.

          • Sneakyb97

            Not a problem. Thanks for the quick reply.

  • Michael Kraft

    Bryan,

    I’m having issues with players that are eligible for multiple positions, i.e. Jace Peterson. I have him as a guy in every lineup but my optimized lineup won’t include him, I think because he isn’t a specific position. Thoughts?

    • spreadsheetsports

      I’m not seeing any issue with him. How are you trying to get him in every lineup? If you’re using the optimal lineup inside the Projection Tool you should be putting him in the Lineup Guarantee on the Hunches & Exclusions tab. If you’re using the Solver file you should have an L next to his name in the first column. Are those not working for you?

  • Andrew Behrend

    I’m having issues with the solver. I’m on a mac and when i go to run a bunch of windows pop up and gives me the error code. i went to tools and clicked on the macros property and then went to tools again on reference was grayed out. not sure what to do now.

    • Neil Kucera

      I had a similar problem… lots of windows opened up and then I was able to uncheck Missing Solver, but there was no “Solver” option to select…

      • spreadsheetsports

        Starting with Excel 2011 Service Pack 1 (Version 14.1.0), Solver is once again bundled with Microsoft Excel for Mac. You do not have to download and install Solver from this page — simply ensure that you have the latest update of Excel 2011 (use Help – Check for Updates on the Excel menu).

        To enable Solver, click ‘Tools’ then ‘Addins’. Within the Addin box, check ‘Solver.xlam’ then hit ‘OK’.

    • spreadsheetsports

      This is what you need to do on Excel for Mac 2011.

      If you’re running Excel for Mac you shouldn’t 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.

      If you don’t see Solver in that list to check please follow the instructions on this page: http://www.solver.com/welcome-mac-users-solver-now-included-excel-2011

      The second time you click on Tools it should be in the new menu that pops up in the VBA Editor. If it’s grayed out, I would close the file, open Excel on it’s own and do a File > Open from Excel to open the Projection Tool file. Let me know if that helps.

  • Neil Kucera

    Hey Bryan,

    I just refreshed my lineups for tomorrow (4/7) and some of the projected lineups include players who aren’t in the major leagues? (ie. Yasmany Tomas is on the Dbacks lineup?) Did I jump the gun (it’s not even midnight here yet, so technically still 4/6) or is this a bug?

    Thanks!

    Neil

    • spreadsheetsports

      I just uploaded a new file that should fix those issues. I’ll have the default rosters updated soon. When I pulled projected starting lineups about 5 days before the season started – Tomas was listed as a projected starter for Arizona. After a full week of games I’ll change the default to what has actually happened. Those get overwritten when official lineups are released for the day after you run the refresh.

  • Mike

    Hello, just signed up was hoping you can walk me through an issue i am having. When i click Run Model I get an error that pops up and says compile error, cant find project or library. It also opens up Microsoft Visual Basic and a lot of windows open up in there. Any ideas? I would like to use the tool for tonights games.

    Thanks,

    Mike

    • spreadsheetsports

      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: https://support.office.com/en-za/article/Load-the-Solver-Add-in-0e6760e3-dab5-4fd4-bebb-15ee311a4316

      If you’re running Excel for Mac you shouldn’t 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.

      If you don’t see Solver in that list to check please follow the instructions on this page: http://www.solver.com/welcome-mac-users-solver-now-included-excel-2011

      You may also want to shut down Excel completely and restart for the Solver installation to take effect. Let me know if you still run into issues.

      • Mike

        Working good now thanks !

      • Jeremy

        Hello, I’m understand the instructions but I do not see these options. Using Microsoft office 2013

        • spreadsheetsports

          The 3 additional steps are only for Mac. The link in the first part are the full instructions for Excel 2013. Let me know if that didn’t work for you.

          • Nell Live Loyalty

            My spreadsheet won’t refresh

          • spreadsheetsports

            Make sure you have Macros and External Data Connection enabled in Excel – those are required for the sheet to connect to live data sources. Let me know what exactly you’re seeing that doesn’t look like it’s refreshing (what time is showing old data, etc). You can email me at bryan@spreadsheet-sports.com

  • Mike

    Im having some issues with the Run Model, it keeps listing 5 players from the same team as its optimal players for my lineup. I’m not using the stack settings, and when i tried to use the stack settings and selected 3 players it still produced 5 players from the same team. Draftkings has a limit of 4 i believe, any thoughts?

    • spreadsheetsports

      Can you save your file with the error and email it to me (bryan@spreadsheet-sports.com). I haven’t seen that as an issue before because it is already set to only allow 4 players per team.

  • Brian

    When I hit the “Refresh Data to Today” button on the Daily Lineups sheet, it keeps refreshing to 4/6/2015. What am I missing?

    • spreadsheetsports

      You need to grab a new file from the site. I loaded the one before the season with dates hard-coded to 4/6. I post updates on the Google+ community when new files are loaded.

  • Billy Biggs

    I get a run-time error ‘9’: Subscript out of range when I hit Send to Solver. Everything else looks great.

    • spreadsheetsports

      The “subscript out of range error”, is caused by one of the following issues:

      a) Not saved on your computer with the exact same name as it’s uploaded on the site (your browser could have added a (1) at the end when you downloaded it and that needs to be removed when you save it

      b) The Solver file is not open in the same instance of Excel (although don’t worry about that in Excel 2013 because all files open in their own stand-alone window and it will work fine there)

      c) Editing is not enabled on the Solver file. You should see a yellow notification bar below the formula bar if it’s not yet enabled.

  • Andrew Behrend

    i can’t get anything to work. this is the third day now, i keep getting errors. i added the solver and click to make sure its working now I’m getting can’t find project or library..

  • Chris

    How does the weather tolerance adjustment function?

  • Andrew Behrend

    now i finally got the solve to kinda work it has prior days players in and always gives the same lineup 10 times

  • Andrew Behrend

    now I’m getting runtime error 1004 ,calculation of object” application failed, when running the optimal line button

    • spreadsheetsports

      Andrew – make sure you hit the Refresh Data to Today button on the Daily Lineups tab to get the current day’s data. If that isn’t working for you – be sure to enable data connections if you see that prompt on your screen. The separate Solver file only works with 1 lineup on Mac. That’s due to a lack of support for VBA on Excel for Mac so it’s not possible to have that same functionality you can get on Windows. You can still find the “best” possible lineup there or directly in the Projection Tool.

      The Compile Error happens when Solver isn’t recognized. I sent over those instructions and it sounds like you got past that part. I’m not sure exactly what happened on the 1004 error. It’s hard for me to tell without seeing your sheet. If you want – you can email it to me at bryan@spreadsheet-sport.com and I’ll take a look at it and get back to you. I think I covered all your questions – let me know if that’s not the case. Email is typically best.

      • JQ2

        Getting same issue. Happens after everything runs.

        • spreadsheetsports

          Many of the error messages are due to a specific issue, but the Run Time 1004 error could be many different things. Please send me the spreadsheet with the error so I can take a look. My guess is that it will be resolved the next day, but if that’s not the case I’ll troubleshoot and get it fixed. Email is bryan@spreadsheet-sports.com

        • spreadsheetsports

          Follow up on this – the 1004 error on a Mac after everything has completed is a false alarm error message. Everything has run successfully – just hit End and you should be all set.

  • Robert Thompson

    Good Morning. I am running a new mac and I when I go to when i get to my tool bar all i have is Tool arrange and it does not give me the option to change the settings to make the sheet work. I am also having problems when I click on the blue tab it just highlights the box?

    • spreadsheetsports

      Could you send me an email with a screenshot of what you’re seeing? I’m not sure what you’re referring to. You can email me at bryan@spreadsheet-sports.com. I assume you’re using Excel for Mac 2011. That’s the version of Excel you need to run this tool.

      • Robert Thompson

        yes when I try and hither blue button this is what i get?

        • spreadsheetsports

          Please send me an email with the screenshot. I can’t see anything here in the comments.

      • Robert Thompson

        I Also get this when I run the solver.

  • Ron

    Are there dashboards for MLB somewhere?

    • spreadsheetsports

      They’re in the works, but not quite ready yet.

  • Joe Whalen

    It’s taking upwards of 10 minutes to create a lineup, after following all the directions. any idea why?

    • spreadsheetsports

      Are you running it in the separate Solver file or inside the Projection Tool? I would suggest following the instructions for moving everything to the Solver file and running it there. Make sure you close the Projection Tool though after you send everything over. Email is best to troubleshoot. If it continues to give you problems please shoot me an email at bryan@spreadsheet-sports.com. Thanks

  • Casey

    Everything is working so far for me except for the Exclude Players and Exclude Teams tab. I put in the early teams abbreviations in both of the columns and also changed the Use for Lineup section to 0 and it was still putting early game players in my lineup. I physically had to delete the entries on the player table to the left of the lineup and also change the max use at the bottom to 0 for it to stop. Anyway to fix this on my end?

    • spreadsheetsports

      Those controls should be working (just tested them this afternoon). When you exclude a team or player it sets their projection to 0 so it should never appear in an Optimal Lineup. These players appeared after you hit the Run Model and got your final lineup? I’d caution against manually deleting players or changing the max/min values. You can do that, but you’re going to need to change it back for future use. I would suggest downloading a fresh file and trying it then – if it’s still not working for you save and send me your file and I’ll take a look. bryan@spreadsheet-sports.com

      • Casey

        First of all, I would just like to thank you! After working on a few tweaks the spreadsheet has been producing some stellar lineups! Yes they did, but I believe it was because I was also putting in my own data. The problem has stopped when I just use the spreadsheets numbers.

        • spreadsheetsports

          Thanks for the compliments! That’s great to hear it’s been working well for you.

  • kentog

    Does it have to be excel? Can I use open office or Google Docs?

    • spreadsheetsports

      It has to be Excel due to the Solver plugin and macros

  • Ed Risha

    I have both a Mac and PC, I got it to work on my PC but cannot on the Mac. Whey I update the list it does that ok; however it does not pull the daily lineups to the projection tab. I have the current day lineups on first tab, but not getting pulled through to rest. Any info appreciated

    • spreadsheetsports

      Everything should work on Mac (assuming you’re using Excel for Mac 2011). There is a difference on the Optimal Lineup tab though. On Windows – you can find the Optimal Lineup directly inside the Projection Tool. On Mac you need to use the “Send to Solver” functionality and use the separate MLB-Solver-Mac file. I’m not sure what the issue would be if the lineups aren’t getting pulled to the Projections tab. What are you seeing on the Projections tab? If you’d like to send over your file as it exists with the error I can take a look and see what might be going wrong. Email is bryan@spreadsheet-sports.com

  • Jeremy

    I recently purchased the subscription, and now I don’t see where to download the spreadsheet or how to go about doing that. Using Mac Office 365

    • spreadsheetsports

      You can login at http://www.spreadsheet-sports.com/mlb-update by clicking on “Already Purchased” under the package you bought and entering in your credentials. The files and instructions are posted on that page. Let me know if you have any further questions – email is typically best: bryan@spreadsheet-sports.com

      • Jeremy

        OK, so. I have got the projection model to run several times and it produced so really good lineups; however, I am all of a sudden having trouble getting the “Solver” option to show up in the “Tools” menu? “Missing Solver” is there but not “Solver”. Thanks

        • spreadsheetsports

          I’m guessing you’re on Mac? If that’s the case – here’s how to get it back:

          To enable Solver, click ‘Tools’ then ‘Addins’. Within the Addin box, check ‘Solver.xlam’ then hit ‘OK’.

          Starting with Excel 2011 Service Pack 1 (Version 14.1.0), Solver is once again bundled with Microsoft Excel for Mac. You do not have to download and install Solver from this page — simply ensure that you have the latest update of Excel 2011 (use Help – Check for Updates on the Excel menu).

          • Jeremy

            I am currently using Office 365 and yes on MAC. But I will try that.

  • Peter

    How frequently are the salaries for players updated? I’m seeing Cueto at $9,600 in the DK player pool while his actual price on the DK site is $11,000. Shouldn’t this get updated when I request today’s data?

  • Dustin Thames

    Is there a way to limit only batters in top half (1-5) of the lineup? Not sure if that already exists, but I don’t see anything.

    • spreadsheetsports

      Just added this today so you’ll see 2 new lines in the Projections tab in the top left settings box for Batting Order Min and Batting Order Max. Set those 2 values and any player outside of your filters will get his projection set to 0 so he won’t be included in the Optimal Lineup. Make sure you grab the new file from the site.

  • Richard Broadway

    Why is my files still showing information from May 11, 2015. When today is May 13, 2015. I just started today and I pretty much just wasted a bunch of money

  • Bradford Dean

    I need some help with the spread sheet. I can update the daily states, however when I try to generated the optimal lineup i get an error. I didn’t make any changes in the Projections or Hunchs& Exclusions tabs, I made sure to choose FanDuel to begin, so the choice in the left hand top is on FanDuel. When I hit the Run Model button for Excel Solver to run and generate an optimal lineup-I get a “compile error message”.. I’m on a PC running excel 2010. Any suggestions

  • Bradford Dean

    Thanks Bryan for the prompt email suggesting The compile error happens when you don’t have the free plugin Solver installed. I installed it and generated the additional line ups. Great tool!

  • Alx

    I tried to close Solver and it asked me for a password

    • spreadsheetsports

      Just hold the escape key for a couple seconds and it goes away

  • Alx

    I am receiving a run time error “9”

    • spreadsheetsports

      The “subscript out of range error”, is caused by one of the following issues:

      a) Not saved on your computer with the exact same name as it’s uploaded on the site (your browser could have added a (1) at the end when you downloaded it and that needs to be removed when you save it

      b) The Solver file is not open in the same instance of Excel (although don’t worry about that in Excel 2013 because all files open in their own stand-alone window and it will work fine there)

      c) Editing is not enabled on the Solver file. You should see a yellow notification bar below the formula bar if it’s not yet enabled.

      Let me know if that’s not the error you’re getting and specifically what the error message says.

  • JC_Vicious

    Alright, trying to run solver on Mac, but when I click on DraftKings optimal lineup it is automatically showing “max” per position at 8 and the lineup always comes up jacked up. It doesn’t pick one player per position…some times picks 3 (3b) 2(ss), etc etc. It takes about 15 minutes to run the “model”. Any thoughts?

    • spreadsheetsports

      Yes – you should use the MLB-Solver-Mac file if you’re running the tool on a Mac. It’s optimized to be used in Excel for Mac. Just make sure you save both files and have them open in Excel at the same time. Click “Send to Solver” in the Projection Tool after you’ve updated everything and then close the Projection Tool. You’ll be able to find a valid lineup then in the MLB-Solver-Mac file.

      • JC_Vicious

        Help me out… here is what I am doing, obviously must be eating retard sandwiches:

        1. Open Projection Tool and update to today, make hunches and exclusions, change projections.
        2. Open mac-solver
        3. Send to solver in projection tool
        4. Nothing happens, when I look at the mac solver it is not updating lineups – almost looks like it is still making a lineup based off of yesterday’s stats – had Colon and Odriozzi.

        • spreadsheetsports

          Did everything update when you ran the Refresh Data to Today? Confirm that you see all new data throughout the tool when that happens. There is no error message on the refresh if something fails to update – it just goes through and updates what it can and skips the rest. So if you’re not connected to the internet or one of the websites that it pulls from is down it won’t fail completely. If you’re on a network that blocks Google Docs or certain websites – you’re not going to get the full refresh. Let me know if that’s the issue.

          • JC_Vicious

            Everything updated fine. Here are the problems:

            1. When I hit “send to solver” it just switches to the Mac Solver spreadsheet and nothing happens.
            2. The static adjustments do not change in the Mac Solver spreadsheet – do these need to be copied/and pasted?
            3. You said that as soon as I hit send to solver in the projection tool, it should automatically populate a lineup in the solver tool, it does not. I have to hit “run model” and it takes about 15 minutes to generate a lineup, and comes in over budget.

            Ideas?

            Thanks,

            JC

          • spreadsheetsports

            When you hit Send to Solver with both spreadsheets open, data gets copied on from the Optimal Lineup tab and and the Static Adjustments tab. You should not have to copy over anything manually. You need to close the Projection Tool before you hit Run Model in the Mac Solver file. That’s why it’s taking so long. With the Projection Tool closed it should be less than a minute and everything should follow salary cap and roster restrictions.

          • JC_Vicious

            Did exactly as you said:

            1. Opened projection tool and mac solver, and hit refresh data to today.

            2. Hit “Send to solver” on projection tool, and closed projection tool.

            3. Hit “Run Model” on mac solver, here is the lineup it gave me:

            P
            Jake Odorizzi

            P
            Chase Anderson

            3B
            Mike Moustakas

            1B
            Eric Hosmer

            OF
            Charlie Blackmon

            OF
            Anthony Gose

            2B
            Brian Dozier

            C
            Nick Hundley

            SS
            Zack Cozart

            OF
            Ryan Braun

          • JC_Vicious

            Static adjustments still show data from previous day as well, even after “refreshing to today”. Tried multiple times just to make sure I wasn’t missing a step.

          • spreadsheetsports

            Is the Refresh in the Projection Tool not working for you at all? Do you see the correct lineups on the Daily Lineups tab as they currently appear on BaseballPress? You can try manually refreshing the tab BaseballPress in the Projection Tool by right-clicking on cell A1 of that tab and choosing refresh.

          • JC_Vicious

            Alright, looks like that works building a lineup, but exclusions are not going through. For instance, tried to do an early lineup by both excluding the late teams manually and typing a “0” in the section where it says to “use in lineup” didn’t do these at the same time, did separately and it still builds a full day lineup.

          • spreadsheetsports

            You can email me your file if you want so I can see what might be going on, but I can’t really tell from that description what the problem would be. I know both exclusion methods work correctly so there has to be something else going on. bryan@spreadsheet-sports.com

          • jordan

            I seem to be having roughly the same issue as well. When i hit send to solver with both sheets open (i hit file/open) it takes me back to the projections tab and has everything copied. The solver is not updated with any of today’s data

            The solver file name is MLB-Solver.xlsm (copied and pasted from the instructions)

            Thank you in advance for your help

          • spreadsheetsports

            Do you have the All Sites package? If you have only FanDuel or DraftKings the file name should be MLB-FanDuel-Solver.xlsm or MLB-DraftKings-Solver.xlsm

  • No Free Beats!!!

    When I’m using the spreadsheet, as it solves for the players, it’s going over the budget by 4k. Am I doing something or am I missing a step?

    • spreadsheetsports

      Do you have the Solver plugin installed? And when you click the “Run Model” button you should be getting a pop-up that says Solver Found an Optimal Solution. If not, follow the instructions on the Troubleshooting Tips tab to install the Solver plugin. If that’s not the issue – send me an email with further details on what you’re seeing: bryan@spreadsheet-sports.com.

      • No Free Beats!!!

        Would I see that if I’m using a mac?

        • spreadsheetsports

          Yes – but there is an additional set of steps to install Solver (on the Troubleshooting Tips tab).

          Also – there is a separate Solver file optimized specifically for Mac. You’ll need to have both files open (and saved to your computer) and then hit the Send to Solver button in the Projection Tool. Then you’ll run your lineups from the MLB-Solver-Mac file. The instructions for that are the same as the Solver file in this guide. Let me know if that works for you. It’s much faster and more accurate on a Mac in that separate file.

  • Josiah Keas

    Can I email you? I’m having too many problems to write a long post.

  • Jamie Christian

    I’m having an issue with the projections not updating for today’s date. The lineups page is correct for today, but the projections are all still from yesterday. I hit refresh all and I don’t get any errors, but the projections are still from 5/22. Thanks!

  • Jamie Christian

    I am having some issues with certain pages not updating. The lineups page is correct, but the projections page is still showing the projections from yesterday. The salaries are not updating as well. They update on the DK data page but do not translate to the Optimal Lineup page. Thanks!

  • Matt

    The projection screen is giving me players that don’t play today. This is after refreshing data for today. How do I fix this?

    • spreadsheetsports

      As in the teams aren’t playing or the players aren’t in the starting lineup? One option would be to download a fresh file and try from there. You should also check the FanDuel Contest Data and DK Data tabs after you refresh to make sure they have today’s data. If not you can right click on the cell in the top left corner and choose refresh. Let me know if that helps.

      • Matt

        Downloading a fresh one did the trick. Thanks!

  • Matt

    When i send my data to the solver it gives me the error runtime number 9 subscript out of range. any ideas how to fix that?

    • spreadsheetsports

      The “subscript out of range error”, is caused by one of the following issues:

      a) Not saved on your computer with the exact same name as it’s uploaded on the site (your browser could have added a (1) at the end when you downloaded it and that needs to be removed when you save it

      b) The Solver file is not open in the same instance of Excel (although don’t worry about that in Excel 2013 because all files open in their own stand-alone window and it will work fine there)

      c) Editing is not enabled on the Solver file. You should see a yellow notification bar below the formula bar if it’s not yet enabled.

  • Michael M

    Yesterday for the DK spreadsheet it wasn’t selecting the final two OF positions (“#N/A” for all columns in those last 2 positions). I’m new to this and everything seemed to run fine. Any idea why this would happen? I also noticed that column H in the DraftKings Optimal Lineup only goes to row 201 despite almost 900 players listed. Is this related?

    • spreadsheetsports

      Is there any way you can send me the file with the errors still present? I can’t really tell unless I see how you got to that situation. The Optimal Lineup tab only goes to row 201 because Solver has a Max of 200 variables. The first step that takes place when you click the Run Model button is that it sorts the players on that tab so the top 200 players by projection will be listed first. Anyone beyond that would never be considered for an Optimal Lineup anyways. If you change the value on a player that was previously low on the list – he’ll get resorted the next time you hit Run Model.

      • Michael M

        I don’t have it saved, but I’ll try again tonight and will post the file if the error persists. Thanks.

        • Michael M

          I got it to run last night, although it took about 10 minutes on my Mac. A couple quick questions: does the MLB-Solver-Mac download replace the need for the MLB-DraftKings-Solver download if being run on a Mac or are they two different things? And in each case, am I understanding correctly that they must be renamed MLB-Solver.xlsm regardless? If I buy the data for DraftKings and FanDuel and they have separate solver sheets, how can I save them both as MLB-Solver.xlsm?

          • spreadsheetsports

            If it took that long you likely either didn’t send the data to the MLB-Solver-Mac file or you left the Projection Tool open in Excel when the Solver-Mac file ran. If you run it in Solver-Mac and close the Projection Tool file it should run much more quickly.

            On your other question – MLB-Solver-Mac replaces the need for DraftKings-Solver if you’re using a Mac. Don’t rename the file – just use save them exactly as they’re named when you download them.

            If you want both FD and DraftKings – they can both be run from the same sheet if you buy the All Daily Sites package. If you’ve bought one and want to buy the other – let me know and you can upgrade to the All Daily Sites and have everything run in the same files.

          • Michael M

            Yup – that’s what I did (had the Projection Tool open the whole time). I just tried it on my laptop and everything worked and was pretty fast (less than a minute to generate 10 lineups). Thanks for the quick responses!

          • Michael M

            Sorry, last question (I hope). When excluding teams, you say “enter team abbreviations as they appear on the Adjustment Selection tab” but there is no tab with that team. Regardless, if it’s a team like the Padres (one team I’m trying today since the game already started), it’s obvious that the only two choices are “Padres” or “SDP” but neither seems to work when I rerun the model. Individually excluding players using the “X” on the Optimal Lineup tab works, though, so I know the model is actually running again. Thoughts?

          • spreadsheetsports

            Adjustment Selection should be the Projections tab. It was renamed for this season. San Diego should be SDP. It should change all Padres projections to 0

          • Michael M

            I attached two images showing the teams I’m excluding, running the model, but the optimal lineup still yields Cashner and other Padres and others teams that should be excluded.

          • spreadsheetsports

            You have the values in the right place. I’m not sure if something got removed prior to that though. Can you try downloading a new sheet and running your exclusions there? I just tested that exact scenario and everything worked as expected on mine. Also, be sure to hit Run Model again after you make your exclusions. It won’t auto-update the final lineup until you’ve clicked Run Model

          • Michael M

            It works if I start over and make the changes. Thanks. However, if I run a model with 6 team exclusions, then try to add an additional team exclusion (or adjust projection ratios) and “run model” again, it still doesn’t seem to be picking up my changes. At least I know how to run it properly though and I’ll mess around with it for a few days to see if the issue with re-running the model might be on my side. Thanks again!

  • stephen

    are these projections made for cash games or gpps? Is there an option to run it for gpps like the basketball spread?

    • spreadsheetsports

      The projections are not specifically for a type of contest – they’re just the best representation of what the player is expected to score that we can come up with. We’re still working on additional features to weight certain adjustments higher but we haven’t quite gotten there yet.

  • ChicagoRolls

    Hi Bryan,
    I tried to DL a new sheet this morning, but when I click the “already purchased” link, it asks me to confirm my purchase and if I click that, it sends me to a payment option screen, and this is after I log in. I purchased the season long package, so I expect that there’s just something wrong with tinypass this morning, but could you check into this? Thanks!

    • spreadsheetsports

      Yes – can you shoot me an email with the email address you used to purchase your subscription and I’ll check your account? bryan@spreadsheet-sports.com

  • Dave Olson

    Question regarding the Preseason Does preseason mean 2014 to Current or 2010 to current? I guess I am asking how much data is taken for the preseason setting. Assuming the more historical data we have the more accurate we can be.

    Thanks man and keep up the good work!!!

    • spreadsheetsports

      Preseason is actually the Steamer projection rating for each player. They are established at the beginning of the year and get updated throughout the year. It takes into account past production but adjusts for age, projected opportunity, etc.

  • paolom

    Should the Mac Solver have an area for multiple lineups? Mine does not for some reason. Looking at the FanDuel Solver tab. Thanks for your help.

    • spreadsheetsports

      Unfortunately, no – Excel for Mac does not have support for running the Solver function multiple times automatically. Do get multiple lineups – you’ll need to use Excel on Windows. Everything should still work fine to get the best possible lineup on a Mac, but it will only run one at a time.

      • paolom

        Is there a way to fake the logic? i.e. does the multiple lineups function exclude lowest points per game player or something? Im just thinking of what tweaks i would make to generate the next best lineup etc. Thanks for your time.

        • spreadsheetsports

          You can add a new constraint to the Solver logic so that the total projected points have to be lower than the previous run. But on a Mac you’ll have to change that every time you want to get a new lineup.

  • Cliff Proctor

    I ran the model 3 times and on the 3rd time it cleared out all the names and replaced them with #N/A and now no matter what I do that is all I get.

    • spreadsheetsports

      You could email me the file if you want me to take a look, but something must have changed between one of those runs. I would suggest downloading a new file to get everything reset. Email is bryan@spreadsheet-sports.com

  • Jeremy

    I’ve recently upgraded to office 2016, and parts of the spreadsheet such as the daily lineups and player projections will not load. Is there a setting I need to change or something else?

    • spreadsheetsports

      I’m assuming you’re on a Mac? I haven’t seen the full version of Excel for Mac 2016 yet so I’m not sure what settings are needed. Can you email me screenshots of what you’re seeing? bryan@spreadsheet-sports.com

  • C_316

    Will the data for tonight’s Angels, Red Sox game be added to the Daily Lineups tab? I see it’s on the full lineups tab but if not on the daily lineups, will it calculate projections correctly?

    • spreadsheetsports

      The first game of the double-header will appear automatically in the Daily Lineups tab. If you want to change it to the second game you’ll need to manually adjust the starting pitchers and the official starting lineups when they’re released for Game 2. Just change the values that are highlighted in yellow on the Daily Lineups tab.

      • C_316

        Okay thanks!

  • gasman442

    why is it when i send to solver then run the model from the solver window i get lineups that have people that aren’t playing today?

    • spreadsheetsports

      It sounds like the refresh isn’t fully working for you on the Projection Tool. I would recommend downloading a fresh Projection Tool sheet from the site and running it from there. If that doesn’t work. You can always right click on the top left cell of the FanDuel Contest Data (or DK Data) tab and choose refresh to force refresh the salary data.

  • jsack

    I noticed tonight when running the projections and the fan duel optimal lineup tool it was giving me in invalid lineup due to pricing off on some player. Also having trouble once I get the optimal lineup sending it to the solver and getting players that aren’t playing today. I am fairly new to this but seem to have figured it out all the other times just wondering what to do next?

  • Vincent Gaudio

    When i run the optimal lineup, it chooses every single person for the lineup and just goes down the list, what am I doing wrong? it also takes about 10 mins to run 1 lineup… I am using a Mac

    • spreadsheetsports

      If you’re using a Mac – try these instructions. You’ll need both the Projection Tool file and the separate “MLB-Solver-Mac” download that’s available under the same list of links on http://www.spreadsheet-sports.com/mlb-update.

      1. Open the Projection Tool and Refresh Data to Today.
      2. Open the MLB-Solver-Mac file and make sure you have the Projection Tool and the MLB-Solver-Mac file named as they are on the site.
      3. On the Optimal Lineup tab within the Projection Tool click “Send Data to Solver”
      4. At this point – save and close the Projection Tool.
      5. Click Run Model in the Solver file. (you’ll need to make sure you follow the standard steps to get the Solver plugin connected in the Solver file – see the Troubleshooting Tips tab)

      If you’re on Windows and it’s still taking 10-15 minutes then you’re likely not closing the Projection Tool first before you hit the Run Model button in the Solver.

  • rrsheffield

    Running on a Mac, have followed all the instructions and get the optimal lineup. In the MLB-Mac-Solver, I run the model again…should I get a different line-up? I know on a MAC you can’t automatically run 10 line-ups. But if I manually run the model again, should I be getting a different result? I am not. Thanks

    • spreadsheetsports

      No – if you simply run it again without any changes you’ll get the same lineup. You can change projection settings, lock/exclude different players, or make some other kind of change to get a different lineup. Hopefully in the next version of Excel on Mac adds support to run the Solver plugin multiple times at once.

  • John Sautter

    Looking for the usage of the Weather tolerance on the projections sheet. Is that a percentage working off the chance of rain?

    • spreadsheetsports

      Yes percent chance of precipitation. Whatever you have it set to – it will zero out projections for any player in a game with a chance of rain above your tolerance.

  • David Orange

    Any reccomendations for weighting over the last 7 days, 14, 30, season, etc?

    • spreadsheetsports

      Typically I tend to lean towards the longer periods of time for most of the weighting. The Pre-Season projections get updated throughout the season and usually end up being very accurate at the end of the season for a player’s final stats. I usually leave most of the weight on Pre-Season and season with a bit of Last 14 and Last 7 added in to capture streakiness

  • rrsheffield

    Getting a run time error 1004, ‘method of calculation of object ‘_Application’ failed. What is causing this? How do I fix it?
    Also, when I send to solver then close the projection tool, then run model, i get a message at the bottom that says’Press Enter or Paste. Seems that the copy from the projection tool to solver is not completing. Is this normal? I am on a MAC using the MAC-Solver. Thanks

    • spreadsheetsports

      The 1004 error is a false alarm message that occurs on a Mac because of the difference between Windows Solver and Mac. Just hit End – everything has completed as expected. Here are the full instructions for Mac if it doesn’t seem to be copying over fully:

      1. Open the Projection Tool and Refresh Data to Today.
      2. Open the MLB-Solver-Mac file and make sure you have the Projection Tool and the MLB-Solver-Mac file named as they are on the site.
      3. On the Optimal Lineup tab within the Projection Tool click “Send Data to Solver”
      4. At this point – save and close the Projection Tool.
      5. Click Run Model in the Solver file. (you’ll need to make sure you follow the standard steps to get the Solver plugin connected in the Solver file – see the Troubleshooting Tips tab)

      • rrsheffield

        Thanks! One more thing, I have run the daily update 3 or 4 times and I have also downloaded the projection tool twice today and the salaries are not getting updated correctly. Anything else I can do?

        • spreadsheetsports

          What dates do you see on the FanDuel Contest Data tab? If it’s not the current day – you can right click the top left cell and choose refresh. If you downloaded the latest file you shouldn’t need to do that though. I loaded them early this morning with Monday’s prices. The file should be the 7/27 file.

  • Vincent Gaudio

    Anyone having issues tonight with the new spread sheet and compile error?

  • Ryan

    Using a mac. Sent from Projection tool to Solver. When I run in solver, the tool selects like every single player for my lineup. It is still running and I’m up to almost $269,000 salary. Help!

    • spreadsheetsports

      If you’re using a Mac (Excel for Mac 2011) there is a separate file optimized specifically for Mac. You should follow these instructions.

      1. Open the Projection Tool and Refresh Data to Today.
      2. Open the MLB-Solver–Mac file and make sure you have the Projection Tool and the MLB-Solver–Mac file named as they are on the site.
      3. On the Optimal Lineup tab within the Projection Tool click “Send Data to Solver“
      4. At this point – save and close the Projection Tool.
      5. Click Run Model in the Solver file. (you’ll need to make sure you follow the standard steps to get the Solver plugin connected in the Solver file – see the Troubleshooting Tips tab)

      At the end you may see a 1004 application failed error. This is a false alarm error message that occurs because of a difference between Solver on Mac vs. Windows. Everything has run as expected – just hit End and you can continue to use the sheet like normal.

      Let me know if you have any questions or run into issues.

      • Ryan

        Also, when I refresh the data, it doesn’t seem to refresh any of the projections on the projection sheet.

        • spreadsheetsports

          You may want to grab a fresh file from the site if it looks like the refresh isn’t working. If you make changes on some of the underlying tabs it can break the full refresh.

  • ChicagoRolls

    I’m not seeing an Advanced Metrics Dashboard for 8/29/15. Are there technical difficulties?

    • spreadsheetsports

      Yes we had several issues pop up today that prevented the dashboard from being updated. We’ll be back on the regularly scheduled updates tomorrow

  • Will

    I’m having issues with the DK mlb projections spreadsheet. The salaries aren’t accurate. In the Optimal lineup tool, there is no shortstop position. Also the chart won’t total the total projected points or salary.

  • Donald Larson

    Why does the multi line up solver create all the same lineups?

    • spreadsheetsports

      That should not be the case, unless you’re using it on a Mac. The Multi-Lineup Optimizer is not supported there. If you’re on a Mac, there will be the new Lineup Generator available soon for multiple lineups. If you’re on a PC can you email me your file so I can take a look at the issue? bryan@spreadsheet-sports

      • Donald Larson

        This is still creating the same lineup for all 10 lineups. I tried emailing the files to the above email and it does not recognize it.

        • spreadsheetsports

          Are you on Excel for Mac? If so – the current Multi-Lineup file does not work there. Email is bryan@spreadsheet-sports.com

          • Donald Larson

            no Using PC I tried to email and I just sent you the files I just downloaded

  • Donald Larson

    Also for Fanduel lineup in projection tool no 2nd baseman in line up.

  • Curtis Higgs

    Does this not work with Excel 2016?

    • spreadsheetsports

      It does. Please see the tab in the Projection Tool labeled Excel Troubleshooting Guide for version specific instructions. Let me know if that doesn’t help. There’s one extra step in 2016

      • Curtis Higgs

        It is still not working. I will get back with you tomorrow. I have got to go out for a while. I just upgraded from excel mac 2011 to 2016, and when you click on tools_macros_VBA, it is completely different. I had 0 problems with 2011 excel NBA sheets. I’ll have to shoot you a screen shot tomorrow or something. Thanks

        • spreadsheetsports

          Yeah just email me a screenshot of what you’re seeing. bryan@spreadsheet-sports.

          You shouldn’t need to get into the VBA though. Do you get an error just when you click the Run Model button?

          • Curtis Higgs

            When I click run model it does a couple of calculations in the bottom progress bar, but nothing happens. If I click send to solver i get a runtime error 9 subscript out of range. I cannot find the MLB-solver file anywhere on your website. Could you tell me where to find that? It is not on the same page as the projection tool. I looked and I had my wife look(just to make sure I wasn’t crazy).

          • spreadsheetsports

            The MLB-Solver file has been renamed this season to MLB Multi-Lineup Optimizer. I’m still in the process of updating the User Guide. If you’re getting an Out of Range error it’s likely that one of your file names is different than when you originally downloaded from our site. If you click Debug when that message comes up you should see exactly what the file names should be.

            If you’re on a Mac – try sending the data to the MLB Mac Optimizer file. That is designed to run best on Macs. Let me know if that helps.

  • Gusy

    how comw when I click run model for optimal line up I always get 3 first baseman in my optimal line up? and it says N/A for total projection? ive changed the min. and max to 2 pithers 1 1b, 2b, 3b, ss, c, and three of. I’m a total noob at all this and any help is appericated

    • spreadsheetsports

      You shouldn’t need to change any of the min or max positions. It’s already set to abide by either FanDuel or DraftKings roster requirements. I would suggest downloading a fresh sheet, and then make sure you have the Solver plugin fully enabled. Full instructions for that depending on your version of Excel are on the tab labeled Excel Troubleshooting Guide. Let me know if that helps.

      • Gusy

        Im using a PC excel 2016. I restarted everything and now I’m getting 3 first baseman. And three are N/A. When I press find optimal line up

        • spreadsheetsports

          On the Excel Troubleshooting Guide tab – there’s an explanation on the extra step that needs to be taken with Excel 2016. It’s under the first section for installing Solver with Excel 2016. There’s a “Reset Solver” file that you need to download and run first before you use the Projection Tool. Let me know if that gets it working for you.

          • Gusy

            Everything I run your solution it says run-time error 53
            File not found : solver 32.dll

          • spreadsheetsports

            Have you installed the Solver plugin first? If you have – you may need to go into Install Programs on your machine and right-click Excel and choose Repair. If you haven’t done the actual install of the Solver plugin yet you should do that first

          • Gusy

            Reinstalled excel and did the steps, works now.ty. the only problem I have now is when I try to multi line up optimizer it’s says run-time error 9. Then I press debug and I’m lost from there.lol.

          • spreadsheetsports

            That means you have one of the file names saved on your computer different from what they were originally called when you downloaded them from the website. Sometimes your browser adds a (1) when it downloads. You’ll need to remove that. If you click Debug it should highlight what the file name should be. This is also covered in full in the Excel Troubleshooting Guide tab if that helps. Let me know