Hello Aaron,
Question for you regarding the "Overall" spreadsheet in the draft analyzer:
I've entered all league rules & req'd data, but the "Overall" page is still reading "N/A" in all categories. Do the players have to be entered manually into the "Overall" spreadsheet, or can I cut & paste from the "Cheat Sheets" page to infill the data. I attempted the cut and paste method once, but once the data is entered the "Overall" page doesn't seem to be sorting it in any way. (I'm moderately proficient with Excel at best, so please bear with me!)
Thanks,
Swerski's Meat Grinder (Matt)
Matt,
The N/A message is due to a tie taking place between two players of different categories. I'd have to take a look at your league's scoring system to see where the tie occurs. If you email it to me at aaron@dominateyourleague.com I'll make a fix and send it back to you. It is very rare that the sheet gets the error so I'll be interested to find otu where it is occuring.
Ok, before I do that & waste your time, here's a question that may solve my problem: Do the auction settings have to be utilized for the sheet to work properly? I zeroed them out, because our league doesn't assign any monetary values to players. I'll try setting the Auction settings back to the defaults & see if that works!
Thanks for the response!!
Post Edit:
OK tried that and it didn't work, I'll email you the sheets & see if you can figure it out! Thanks again!
Matt