search

scipio314 / draftKnight

draftKnight is an excel sheet that generates optimized fantasy football lineups for DraftKings
GNU General Public License v3.0
31 stars 13 forks source link

error creating linups #12

Closed paqratst1 closed 7 years ago

paqratst1 commented 7 years ago

I'm getting this error. image

paqratst1 commented 7 years ago

draftKnight (2).zip

paqratst1 commented 7 years ago

image I'm getting this one as well if not the above one

scipio314 commented 7 years ago

Thanks for letting me know. This is a common problem and has a simple fix. The error usually occurs when the added player pool is smaller than the previous weeks.

Open up the "All Players" tab (right click on the bottom and select unhide).
Then down at the bottom you will see some additional rows with errors in them. Delete the excess rows, then resize the table to stop at the bottom of all the players.

I've re-attached the file you sent me with the table fixed.
draftKnight (2).zip

Also, if you want to hide the pop ups about player status you can do that by going to the "review" section of the excel ribbon up top then selecting "show all comments".

paqratst1 commented 7 years ago

thank you so much for the quick reply. i was a little lost when it said to delete the empty fields in the all players tab. i didn't think to see if sheets were hidden. thank you

scipio314 commented 7 years ago

no problem, good luck this weekend!

scipio314 commented 7 years ago

7