This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!
hey, he's not the only non-All Star drafted...of course, the others played pre-1933, but, still...My thoughts exactly....if the words Todd Zeile and all-star don't go together how does Todd Zeile and all-time great go together
So if I got this right you have two spreadsheets:1. The first spreadhsheet has three columns, one with the last name, one with first name and one with the ID. Bonds | Barry | bondba012. The second spreadsheet has the ID, year and win shares.bondba01 | 2002 | 35If that's what you've got then I'd just concatenate the two name columns together on sheet1 =concatenate(cell1," ",cell2). Then I'd do a vlookup on sheet2 looking at player id and pulling back the name.
In his 3rd best year (according to WIS.com), he hit 31 HR's and 90 RBI's.You telling me that's bad for a 4th bench player who can also play Catcher?hey, he ranks pretty high with players whose last name starts with "Z".My thoughts exactly....if the words Todd Zeile and all-star don't go together how does Todd Zeile and all-time great go together
Nope....it's bad for an all time draft. Sorry but if this was a Larry Boy pick he'd be getting flogged.In his 3rd best year (according to WIS.com), he hit 31 HR's and 90 RBI's.You telling me that's bad for a 4th bench player who can also play Catcher?hey, he ranks pretty high with players whose last name starts with "Z".My thoughts exactly....if the words Todd Zeile and all-star don't go together how does Todd Zeile and all-time great go together
At this point in the draft, I'm looking for verastility. I'd take a guy like Zeile over a slightly more talented 3B or 1B that can only play 1 position. Zeile can play 3. Plus, how often is the guy gonna play?SeriouslyNope....it's bad for an all time draft. Sorry but if this was a Larry Boy pick he'd be getting flogged.In his 3rd best year (according to WIS.com), he hit 31 HR's and 90 RBI's.You telling me that's bad for a 4th bench player who can also play Catcher?hey, he ranks pretty high with players whose last name starts with "Z".My thoughts exactly....if the words Todd Zeile and all-star don't go together how does Todd Zeile and all-time great go together
Well once you get done sim-In his 3rd best year (according to WIS.com), he hit 31 HR's and 90 RBI's.You telling me that's bad for a 4th bench player who can also play Catcher?hey, he ranks pretty high with players whose last name starts with "Z".My thoughts exactly....if the words Todd Zeile and all-star don't go together how does Todd Zeile and all-time great go together
Edit: Actually, he's my 5th bench player.
...you'll be happy to note your looking at his 4th best year. His 3rd according to WIS was 99 when he hit 24. 
I think its ok if you back it with the "homerun call" story.Nope....it's bad for an all time draft. Sorry but if this was a Larry Boy pick he'd be getting flogged.In his 3rd best year (according to WIS.com), he hit 31 HR's and 90 RBI's.You telling me that's bad for a 4th bench player who can also play Catcher?hey, he ranks pretty high with players whose last name starts with "Z".My thoughts exactly....if the words Todd Zeile and all-star don't go together how does Todd Zeile and all-time great go together
Ok, I understand that. A guy that can play C and 3B but damn.....Todd Zeile and alltime MLB draft just don't go together well.At this point in the draft, I'm looking for verastility. I'd take a guy like Zeile over some 3B or 1B was available, but could only that position. Zeile can play 3. Plus, how often is the guy gonna play?SeriouslyNope....it's bad for an all time draft. Sorry but if this was a Larry Boy pick he'd be getting flogged.In his 3rd best year (according to WIS.com), he hit 31 HR's and 90 RBI's.You telling me that's bad for a 4th bench player who can also play Catcher?hey, he ranks pretty high with players whose last name starts with "Z".My thoughts exactly....if the words Todd Zeile and all-star don't go together how does Todd Zeile and all-time great go together
Highlight all. (ctrl+a)Go to data, choose sort. (alt+d, enter)Use the pull down to select win shares, then choose descending.For those of us that forgot how to use excel well, how do we sort by win share?
IS that so? That's good because:A. he hit .293 that year vs .268 in '97Well once you get done sim-In his 3rd best year (according to WIS.com), he hit 31 HR's and 90 RBI's.You telling me that's bad for a 4th bench player who can also play Catcher?hey, he ranks pretty high with players whose last name starts with "Z".My thoughts exactly....if the words Todd Zeile and all-star don't go together how does Todd Zeile and all-time great go together
Edit: Actually, he's my 5th bench player.
but a true all-time draft doesn't hold position into account... it just is saying who is the greatest players of all time...This is about making a team that can play, so, that means it doesn't necessarily mean draft the greatest player and go, although it is like that for the first few rounds...Ok, I understand that. A guy that can play C and 3B but damn.....Todd Zeile and alltime MLB draft just don't go together well.At this point in the draft, I'm looking for verastility. I'd take a guy like Zeile over some 3B or 1B was available, but could only that position. Zeile can play 3. Plus, how often is the guy gonna play?SeriouslyNope....it's bad for an all time draft. Sorry but if this was a Larry Boy pick he'd be getting flogged.In his 3rd best year (according to WIS.com), he hit 31 HR's and 90 RBI's.You telling me that's bad for a 4th bench player who can also play Catcher?hey, he ranks pretty high with players whose last name starts with "Z".My thoughts exactly....if the words Todd Zeile and all-star don't go together how does Todd Zeile and all-time great go together
thanks. i had to cut and paste then put the wanted field all the way to the left cause I forgot.Highlight all. (ctrl+a)Go to data, choose sort. (alt+d, enter)Use the pull down to select win shares, then choose descending.For those of us that forgot how to use excel well, how do we sort by win share?
To each his own, I guess.Ok, I understand that. A guy that can play C and 3B but damn.....Todd Zeile and alltime MLB draft just don't go together well.At this point in the draft, I'm looking for verastility. I'd take a guy like Zeile over some 3B or 1B was available, but could only that position. Zeile can play 3. Plus, how often is the guy gonna play?SeriouslyNope....it's bad for an all time draft. Sorry but if this was a Larry Boy pick he'd be getting flogged.In his 3rd best year (according to WIS.com), he hit 31 HR's and 90 RBI's.You telling me that's bad for a 4th bench player who can also play Catcher?hey, he ranks pretty high with players whose last name starts with "Z".My thoughts exactly....if the words Todd Zeile and all-star don't go together how does Todd Zeile and all-time great go together
You're right though. LB would be torn a new one for that pick.Ok, I understand that. A guy that can play C and 3B but damn.....Todd Zeile and alltime MLB draft just don't go together well.At this point in the draft, I'm looking for verastility. I'd take a guy like Zeile over some 3B or 1B was available, but could only that position. Zeile can play 3. Plus, how often is the guy gonna play?SeriouslyNope....it's bad for an all time draft. Sorry but if this was a Larry Boy pick he'd be getting flogged.In his 3rd best year (according to WIS.com), he hit 31 HR's and 90 RBI's.You telling me that's bad for a 4th bench player who can also play Catcher?hey, he ranks pretty high with players whose last name starts with "Z".My thoughts exactly....if the words Todd Zeile and all-star don't go together how does Todd Zeile and all-time great go together
I wouldn't say that. I have seen this guy get drafted in every single "All-Time" draft I have done.Ok, I understand that. A guy that can play C and 3B but damn.....Todd Zeile and alltime MLB draft just don't go together well.At this point in the draft, I'm looking for verastility. I'd take a guy like Zeile over some 3B or 1B was available, but could only that position. Zeile can play 3. Plus, how often is the guy gonna play?SeriouslyNope....it's bad for an all time draft. Sorry but if this was a Larry Boy pick he'd be getting flogged.In his 3rd best year (according to WIS.com), he hit 31 HR's and 90 RBI's.You telling me that's bad for a 4th bench player who can also play Catcher?hey, he ranks pretty high with players whose last name starts with "Z".My thoughts exactly....if the words Todd Zeile and all-star don't go together how does Todd Zeile and all-time great go together
Good point.So.....how bout that Iraqi election?
I'm bored and I have great disgust for Mr. Zeile. I own entirely too many of his baseball cardsIS that so? That's good because:A. he hit .293 that year vs .268 in '97Well once you get done sim-In his 3rd best year (according to WIS.com), he hit 31 HR's and 90 RBI's.You telling me that's bad for a 4th bench player who can also play Catcher?hey, he ranks pretty high with players whose last name starts with "Z".My thoughts exactly....if the words Todd Zeile and all-star don't go together how does Todd Zeile and all-time great go together
Edit: Actually, he's my 5th bench player.
B. had more RBI's
C. had a higher sluffing %
Thanks for pointing that out, I appreciate it.
BTW, why the hubub for a bench player?
I wouldn't say that. I have seen this guy get drafted in every single "All-Time" draft I have done.Ok, I understand that. A guy that can play C and 3B but damn.....Todd Zeile and alltime MLB draft just don't go together well.At this point in the draft, I'm looking for verastility. I'd take a guy like Zeile over some 3B or 1B was available, but could only that position. Zeile can play 3. Plus, how often is the guy gonna play?SeriouslyNope....it's bad for an all time draft. Sorry but if this was a Larry Boy pick he'd be getting flogged.In his 3rd best year (according to WIS.com), he hit 31 HR's and 90 RBI's.You telling me that's bad for a 4th bench player who can also play Catcher?hey, he ranks pretty high with players whose last name starts with "Z".My thoughts exactly....if the words Todd Zeile and all-star don't go together how does Todd Zeile and all-time great go together
I think you've actually taken him so you don't get to vote.
Sort of. I have three sheets. 1) One I have just the last and first names and am trying to retrieve the ID. This is a team list from this draft.2) The second will have the last name, first name, and the ID. This is the master list of players and IDs. This is where I'm trying to pull the ID from.3) The third is a list of all players, seasons, and win shares. I'm trying to use the ID and season to pull the number of Win Shares from this one.Concatenate will work but it'll take a bunch of manual work since I really have a sheet for each team (instead of how I listed it in #1 above as one sheet).
Otherwise known as 'commons'.I'm bored and I have great disgust for Mr. Zeile. I own entirely too many of his baseball cardsIS that so? That's good because:A. he hit .293 that year vs .268 in '97Well once you get done sim-In his 3rd best year (according to WIS.com), he hit 31 HR's and 90 RBI's.You telling me that's bad for a 4th bench player who can also play Catcher?hey, he ranks pretty high with players whose last name starts with "Z".My thoughts exactly....if the words Todd Zeile and all-star don't go together how does Todd Zeile and all-time great go together
Edit: Actually, he's my 5th bench player.
B. had more RBI's
C. had a higher sluffing %
Thanks for pointing that out, I appreciate it.
BTW, why the hubub for a bench player?
If I Paypal you a buck, can you give me a few cards?I'm bored and I have great disgust for Mr. Zeile. I own entirely too many of his baseball cardsIS that so? That's good because:A. he hit .293 that year vs .268 in '97Well once you get done sim-In his 3rd best year (according to WIS.com), he hit 31 HR's and 90 RBI's.You telling me that's bad for a 4th bench player who can also play Catcher?hey, he ranks pretty high with players whose last name starts with "Z".My thoughts exactly....if the words Todd Zeile and all-star don't go together how does Todd Zeile and all-time great go together
Edit: Actually, he's my 5th bench player.
B. had more RBI's
C. had a higher sluffing %
Thanks for pointing that out, I appreciate it.
BTW, why the hubub for a bench player?
and worthlessOtherwise known as 'commons'.I'm bored and I have great disgust for Mr. Zeile. I own entirely too many of his baseball cardsIS that so? That's good because:A. he hit .293 that year vs .268 in '97Well once you get done sim-In his 3rd best year (according to WIS.com), he hit 31 HR's and 90 RBI's.You telling me that's bad for a 4th bench player who can also play Catcher?hey, he ranks pretty high with players whose last name starts with "Z".My thoughts exactly....if the words Todd Zeile and all-star don't go together how does Todd Zeile and all-time great go together
Edit: Actually, he's my 5th bench player.
B. had more RBI's
C. had a higher sluffing %
Thanks for pointing that out, I appreciate it.
BTW, why the hubub for a bench player?
Sort of. I have three sheets. 1) One I have just the last and first names and am trying to retrieve the ID. This is a team list from this draft.2) The second will have the last name, first name, and the ID. This is the master list of players and IDs. This is where I'm trying to pull the ID from.3) The third is a list of all players, seasons, and win shares. I'm trying to use the ID and season to pull the number of Win Shares from this one.Concatenate will work but it'll take a bunch of manual work since I really have a sheet for each team (instead of how I listed it in #1 above as one sheet).
I think I'd have to have them in front of me to be of any use. If you like, you can email all three of them to me and I can take a look at it.
wait until we do the full-53 man roster NFL draft...
yeah, I've seen a few people (I'm one of them) interested in doing an NFL draft...that sucker's gonna be long...Ffffifty three? Who will be the first to not make it to the end? I'm 36 now so smart money's on me.
My entire fortune in baseball cards is now 'commons'.Otherwise known as 'commons'.I'm bored and I have great disgust for Mr. Zeile. I own entirely too many of his baseball cardsIS that so? That's good because:A. he hit .293 that year vs .268 in '97Well once you get done sim-In his 3rd best year (according to WIS.com), he hit 31 HR's and 90 RBI's.You telling me that's bad for a 4th bench player who can also play Catcher?hey, he ranks pretty high with players whose last name starts with "Z".My thoughts exactly....if the words Todd Zeile and all-star don't go together how does Todd Zeile and all-time great go together
Edit: Actually, he's my 5th bench player.
B. had more RBI's
C. had a higher sluffing %
Thanks for pointing that out, I appreciate it.
BTW, why the hubub for a bench player?
No kidding. Boy did that investment go to hell.My entire fortune in baseball cards is now 'commons'.Otherwise known as 'commons'.I'm bored and I have great disgust for Mr. Zeile. I own entirely too many of his baseball cardsIS that so? That's good because:A. he hit .293 that year vs .268 in '97Well once you get done sim-In his 3rd best year (according to WIS.com), he hit 31 HR's and 90 RBI's.You telling me that's bad for a 4th bench player who can also play Catcher?hey, he ranks pretty high with players whose last name starts with "Z".My thoughts exactly....if the words Todd Zeile and all-star don't go together how does Todd Zeile and all-time great go together
Edit: Actually, he's my 5th bench player.
B. had more RBI's
C. had a higher sluffing %
Thanks for pointing that out, I appreciate it.
BTW, why the hubub for a bench player?
01.03 ART SHELLI wanna be the guy to go O-Line for the first five rounds just to argue that a championship team is built from the trenches out.
Concatenate is working like a charm. Got it done. Just need to fix the ones where the names are slightly different.
