Belushi 9 Posted July 30, 2004 Just downloaded the compiler last night and I'me very happy with it. I was reading through the help post at the top of this forum, and it recommeded for an auction draft to use the "Last Drafted" method instead of "Complier Recommended". I hit Compile Cheatsheet, and it screws up the cheatsheet. Under my max bid for every player, every position is #REF. I looked through a few of the other tabs to see if I could find the problem, but no luck. There is a VLookup formula in that cell, but I'm not quite that advanced in Excel to figure out what's wrong. Share this post Link to post Share on other sites
Mike MacGregor 20 Posted July 31, 2004 Hi Belushi. I don't think this will be caused by changing the overall ranking method. One thing that springs to mind is, check the scoring tab and make sure you do not have a zero in any of the scoring categories under "Per Unit". Even if you do not use a category it should not be 0. There could be a few things going on though. Maybe you should send it to me to look at. compiler@fftoday.com Please zip the file if you could and only send the Compiler. Thanks. Share this post Link to post Share on other sites
poseidon343 0 Posted August 1, 2004 I am having the same problem w/ the #REF. I checked the "per unit" for zeros, but still no go. Share this post Link to post Share on other sites
Mike MacGregor 20 Posted August 2, 2004 Can one of you send my a copy (zipped, preferably) and I'll take a look? Share this post Link to post Share on other sites
Belushi 9 Posted August 3, 2004 Thanks Mike. I'll send it to you from home tonight. Share this post Link to post Share on other sites
