Page 1 of 1

START

Posted: March 22nd, 2010, 7:25 am
by Black Sox
Having trouble re sorting the player list to alphabetical. It looks like it's sorted by PA right now. Whenever I select I effects the formula. What am I doing wrong.

Thanks

Re: START

Posted: March 22nd, 2010, 8:26 am
by Todd Zola
Actually I need to post the updated version. I'll get it this evening.

How are you sorting? I sort all the time and it works just fine.

Re: START

Posted: March 22nd, 2010, 12:16 pm
by Black Sox
didn't realize if I double click on heading it will sort, Thanks :oops:

Re: START

Posted: March 23rd, 2010, 3:51 pm
by ksenor
Todd Zola wrote:Actually I need to post the updated version. I'll get it this evening.

How are you sorting? I sort all the time and it works just fine.
Is the sheet that is avaiable on the platinum page the updated version?

Also, I was wondering if you would give me the password....I was going to play with to see if I couldn't add holds and OPS to the standings.

I have done a lookup to bring over the dollar values you gave me from the custom 6x6. I'm thinking this could be one hell of a draft cheat sheet that would give me a running picture of the league as the draft is happening.

Re: START

Posted: March 23rd, 2010, 4:12 pm
by Todd Zola
Dammit, i knew I forgot something.

I'm not sure I even remember the p/w, but I will try my usuals. The coding is nothing proprietary, I lock it more to prevent others from inadvertently changing it. The only unique thing is the way I break ties, There may be a better way to do it, but when you use the rank function, it does not give "the half point." So I write a series of if/then statements to recognize when 2 (or more) teams have the same totals and then it gives them each the same. It might be a round about way, but it works!!!

and FWIW, you can paste the updated projections in -- that page is not protected

and try START as the p/w :)

i don't have excel on this laptop where I am so I can't check it :(

Re: START

Posted: March 23rd, 2010, 4:25 pm
by ksenor
I'm all about work arounds when using excel!!!

START isn't it.... :lol: