bigken117 wrote:I'm working on it. Job, family, Christmas...all that other stuff goes on too. But I would like to thank the individuals who put spaces after their players names to F up my Vlookup
I could standardize the formatting if it's a problem. All my friends are on vacation somewhere so I have a lot of free time.
Rocinante2: you know Rocinante2: its easy to dismiss the orioles as a bad team ofanrex: go on Rocinante2: i'm done Rocinante2: lmao
bigken117 wrote:I'm working on it. Job, family, Christmas...all that other stuff goes on too. But I would like to thank the individuals who put spaces after their players names to F up my Vlookup
I could standardize the formatting if it's a problem. All my friends are on vacation somewhere so I have a lot of free time.
This is coming along... I have 6 sets done, but now that I have the layout all set it takes ~15 minutes per member. So within the next couple days...hopefully.
If you want to send me some updates based on recent signings (like now that Arrendondo won't be closing) or other personal preference (I'm sure kcollins wants to make Tex his #1 1B) go ahead and PM me the changes only (i.e. move Tex to #1, move Arrendondo to #30) simple stuff like that the formula can handle. Don't send me another sheet, or I will card you.
And if anyone knows how to get the N/A's returned in vlookup to change into 26 or 76 as needed, without me typing them in manually, holla at ya boy
bigken117 wrote:This is coming along... I have 6 sets done, but now that I have the layout all set it takes ~15 minutes per member. So within the next couple days...hopefully.
If you want to send me some updates based on recent signings (like now that Arrendondo won't be closing) or other personal preference (I'm sure kcollins wants to make Tex his #1 1B) go ahead and PM me the changes only (i.e. move Tex to #1, move Arrendondo to #30) simple stuff like that the formula can handle. Don't send me another sheet, or I will card you.
And if anyone knows how to get the N/A's returned in vlookup to change into 26 or 76 as needed, without me typing them in manually, holla at ya boy
Happy New Year!
Can you make Teix number 1 at every position for me? Thanks. Seriously though, I'll move him to 3 ahead of Howard.
bigken117 wrote:This is coming along... I have 6 sets done, but now that I have the layout all set it takes ~15 minutes per member. So within the next couple days...hopefully.
If you want to send me some updates based on recent signings (like now that Arrendondo won't be closing) or other personal preference (I'm sure kcollins wants to make Tex his #1 1B) go ahead and PM me the changes only (i.e. move Tex to #1, move Arrendondo to #30) simple stuff like that the formula can handle. Don't send me another sheet, or I will card you.
And if anyone knows how to get the N/A's returned in vlookup to change into 26 or 76 as needed, without me typing them in manually, holla at ya boy
Happy New Year!
I'm sure there are a few things I could update, but I'm going to leave it alone for now. The point of doing early rankings is to have a starting point and then adjust as things develop. If we do another one in a month or two, we can see the changes reflected then.
bigken117 wrote: And if anyone knows how to get the N/A's returned in vlookup to change into 26 or 76 as needed, without me typing them in manually, holla at ya boy
Why not just do the ranking college football style? 25 pts for 1st, 1 pt for 25th and 0 for 26th
bigken117 wrote: And if anyone knows how to get the N/A's returned in vlookup to change into 26 or 76 as needed, without me typing them in manually, holla at ya boy
Why not just do the ranking college football style? 25 pts for 1st, 1 pt for 25th and 0 for 26th
Interesting. Since I'm halfway through my IFNA formulae I'll finish it up the way I have it, but doing it that way should be easy enough once I get them done.
bigken117 wrote:Just waiting on a couple more and these things will be ready to go
Hate to throw a monopoly-piece size wrench into things, but if you could move Zack Grienke up to 15 in my rankings and everyone else move down one spot accordingly, that'd be great. If not it's ok.
Cafe Home
Fantasy Football
Fantasy Basketball
Fantasy Hockey
by Neato Torpedo » Tue Dec 23, 2008 5:30 pm 
so I have a lot of free time.
I have 6 sets done, but now that I have the layout all set it takes ~15 minutes per member. So within the next couple days...hopefully. 
