Originally posted by johnnya24
View Post
Announcement
Collapse
No announcement yet.
Announcement
Collapse
No announcement yet.
*** VD 6 Commentary Thread ***
Collapse
X
-
Here's the error I'm getting... if I look in the playerID column on anyone's page (Eld, Revo etc pages) I'm getting this:
=IF(ISERROR(HLOOKUP("P1",ROUNDS!#REF!,2,0)),"",HLO OKUP("P1",ROUNDS!#REF!,2,0))
it looks like if I fix that reference everything else should load okay.
not sure why it looks like there's a space in that second HLOOKUP, there isn't.I'm not expecting to grow flowers in the desert...
Comment
-
Originally posted by heyelander View PostHere's the error I'm getting... if I look in the playerID column on anyone's page (Eld, Revo etc pages) I'm getting this:
=IF(ISERROR(HLOOKUP("P1",ROUNDS!#REF!,2,0)),"",HLOOKUP("P1",ROUNDS!#REF!,2,0))
it looks like if I fix that reference everything else should load okay.
not sure why it looks like there's a space in that second HLOOKUP, there isn't.
=IF(ISERROR(HLOOKUP("P1",ROUNDS!$C$2:SAA$4,2,0)),"",HLOOKUP("P1",ROUNDS!$C$2:SAA$4,2,0))
There is no location for the hlookup for some reason ...
You must be doing something wrong when you are downloading or opening the file. Maybe the new sheet is being merged with an old sheet or something?
Comment
-
Originally posted by johnnya24 View PostYou must be doing something wrong when you are downloading or opening the file. Maybe the new sheet is being merged with an old sheet or something?
Weird. Thanks for the text, I can update the references.
Ah... my version doesn't like the SAA if I get rid of the S and go with AA it all works.I'm not expecting to grow flowers in the desert...
Comment
-
Is the position sheet just f'ed up. I noticed it hasn't worked the last two drafts.Considering his only baseball post in the past year was bringing up a 3 year old thread to taunt Hornsby and he's never contributed a dime to our hatpass, perhaps?
Comment
-
Originally posted by heyelander View PostMy input is a left click to download and a click on continue to convert it. That's it. It's the most updated sheet since the rounds sheet is up to date.
Weird. Thanks for the text, I can update the references.
Ah... my version doesn't like the SAA if I get rid of the S and go with AA it all works.
I'll fix at the weekend.
Comment
-
Originally posted by johnnya24 View PostThe SAA must be a typo that is being ignored by the newer versions. I probably meant $AA.
I'll fix at the weekend.
$AA would allow us to draft 25 players, but if you set it for $BB or something it would allow us to draft more players and you wouldn't have to update those pages if we go back to a draft that includes more players selected.I'm not expecting to grow flowers in the desert...
Comment
-
Originally posted by heyelander View PostIt probably was a typo, but newer versions allow a butt load of columns. I checked with a coworker who runs 2010 and it goes out far past SAA so it's not an issue for anyone else. 2003 just limits it to IV. If you go to that page and replace SAA with IV it will work for everyone (err... me as well as continuing to work for everyone)
$AA would allow us to draft 25 players, but if you set it for $BB or something it would allow us to draft more players and you wouldn't have to update those pages if we go back to a draft that includes more players selected.
I don't want to extend it beyond AA in case people will use the right side of the sheet for optimizing picks later on ... I often copy paste player ID's and BY's over there.
Comment
-
Originally posted by johnnya24 View PostAll done ... I replaced the "SAA" on the E and F columns with "AA"
I don't want to extend it beyond AA in case people will use the right side of the sheet for optimizing picks later on ... I often copy paste player ID's and BY's over there.I'm not expecting to grow flowers in the desert...
Comment
-
Well I made another pick I really didn't want to make, but after using 2 top picks on closers I wanted to make sure I was in the top 1/3 and Wagner was one of the few top guys left that would not hurt my ratios. What I do with the rest of my pitching staff? Who the hell knows.
Comment
Comment