FAQ’s

Here are our most common Frequently asked questons. Please review them and if you still have a question, email me at excelbyjoe@gmail.com

Do I have to Enable macros to get this software to work?

Yes. When you open the software, it may ask you to enable macros. Click yes or click Enable. Otherwise the buttons will not work.

I have a Mac, will this work on a Mac?

Sorry but no it will not right now. It only works in Windows.

How do I Lock in or Exclude players from lineups?

To lock in or include players in all your lineups, you put an x in the multilineups tab.

To exclude players from your lineups, just change their projection to 0 so they will never get picked.

How do I use the NBA spreadsheets?

You can watch these videos to show you:

 

How do I use the PGA Golf Spreadsheet tool?

How do I use the NFL Football Spreadsheet tool?

How do I use the MMA Spreadsheet tool?

How do I use the Nascar Spreadsheet tool?

When do the salaries get updated for the day/week?

You have to manually add the salaries yourself from Draftkings or Fanduel.  Its very easy.

Just open up the slate you want to play.  Find the link to Export Salaries and click it and it will open in Excel.

Then just copy and paste it to the Draftkings Salaries tab or Fanduel Salaries tab.

My spreadsheet doesn’t work. Why?

This is a very vague question and can’t be answered without more information. Please read the other FAQ’s to see possible errors. Read through them and some tips below. Then you can email me excelbyjoe@gmail.com if you still can’t figure it out. But please tell me exactly what is going on, like what buttons you are pressing and what happens if anything. also any error messages.

1. Make sure you are in Windows Excel 2007 or newer
2. Restart Excel or even your computer if it isn’t working.
3. Make sure there’s no other Excel programs running or it could cause it to slow.
4. Make sure you have the correct login

Do I need Solver installed?

No you don’t.  I re programmed the lineup optimizer to not have to use Solver.  While Solver was good, it was extremely slow.  So now I have Excel doing the same thing, but just quicker.