Agreed. If someone wants a 2015 BY they can give it to us. Career is more important.
Announcement
Collapse
No announcement yet.
Announcement
Collapse
No announcement yet.
*** VD 10 Commentary Thread ***
Collapse
X
-
I downloaded stats from http://www.tgfantasybaseball.com/baseball/stats.cfm. The question is if I can extract the CY page from the spreadsheet, merge the data, and reimport without breaking anything. Are there any formulas on the CY sheet that pull from other sheets? I would assume not...
The one annoying bit is that I don't have Excel on my computer, just OpenOffice, and I'm not totally sure that supports all the features it needs to. If someone could save the hitter and pitcher CY pages in CSV format and mail them to me or put them on a fileshare somewhere (even pastebin) that would be great. If that happens during the day today I'll do the merge tonight.
This won't include any positional updates, but I can't think of any relevant ones offhand anyway.In the best of times, our days are numbered, anyway. And it would be a crime against Nature for any generation to take the world crisis so solemnly that it put off enjoying those things for which we were presumably designed in the first place, and which the gravest statesmen and the hoarsest politicians hope to make available to all men in the end: I mean the opportunity to do good work, to fall in love, to enjoy friends, to sit under trees, to read, to hit a ball and bounce the baby.
Comment
-
Originally posted by mjl View PostI'm pretty sure I can download stats from http://www.rotowire.com/baseball/player_stats.htm. The question is if I can extract the CY page from the spreadsheet, merge the data, and reimport without breaking anything. Are there any formulas on the CY sheet that pull from other sheets? I would assume not...
The one annoying bit is that I don't have Excel on my computer, just OpenOffice, and I'm not totally sure that supports all the features it needs to. If someone could save the hitter and pitcher CY pages in CSV format and mail them to me or put them on a fileshare somewhere (even pastebin) that would be great. If that happens during the day today I'll do the merge tonight.
This won't include any positional updates, but I can't think of any relevant ones offhand anyway.
There are internal sheet formulas, but nothing that draws from outside. The Taken, KO and Period columns have internal page formulas.
Comment
-
And is the SS updated to 2014? The VD9 one doesn't have Chris Davis at all, for example.In the best of times, our days are numbered, anyway. And it would be a crime against Nature for any generation to take the world crisis so solemnly that it put off enjoying those things for which we were presumably designed in the first place, and which the gravest statesmen and the hoarsest politicians hope to make available to all men in the end: I mean the opportunity to do good work, to fall in love, to enjoy friends, to sit under trees, to read, to hit a ball and bounce the baby.
Comment
-
oh ok. So what's it updated to? I can pull multiple years from that site and combine them, although as noted I don't think I'll be able to do the positional stuff automatically so it'll be up to the person taking a player if they're taking either a new player or someone already in the SS with a position change. And what criteria should I use to add players? I assume we don't want some guy who got 200 AB this year as a rookie.In the best of times, our days are numbered, anyway. And it would be a crime against Nature for any generation to take the world crisis so solemnly that it put off enjoying those things for which we were presumably designed in the first place, and which the gravest statesmen and the hoarsest politicians hope to make available to all men in the end: I mean the opportunity to do good work, to fall in love, to enjoy friends, to sit under trees, to read, to hit a ball and bounce the baby.
Comment
-
Code:=COUNTA(C2:AC2)-stand!A4+IF(MAX(dec!C3:Q3)>1,5,0)+IF(MAX(dec!C21:Q21)>1,7,0)
C2:AC2 - Correct
A4 = 0 (or blank)
C3:Q3 = BY from Dec sheet ... if any cell is more than 1 then display/add 5 otherwise 0 (right?)
C21:Q21 Car from Dec sheer ... if any cell is more than 1 then display/add 7 otherwise 0 (right?)
So a valid sheet is reading 3.97 (why is the base 3.97???????)
An invalid Hitter is reading 8.97
An invalid pitcher is reading 11.97
Comment
-
Originally posted by mjl View Postoh ok. So what's it updated to? I can pull multiple years from that site and combine them, although as noted I don't think I'll be able to do the positional stuff automatically so it'll be up to the person taking a player if they're taking either a new player or someone already in the SS with a position change. And what criteria should I use to add players? I assume we don't want some guy who got 200 AB this year as a rookie.
The current sheet is probably too erratic to merge. Some players are updated to 2014, other (not selected in the previous draft) will still be at 2011 or 2012.
Comment
-
Originally posted by johnnya24 View PostSo you will merge the 2014 career stats with the newly added 2015 stats?
The current sheet is probably too erratic to merge. Some players are updated to 2014, other (not selected in the previous draft) will still be at 2011 or 2012.
If I do this, it's pretty trivial to export the BYs also, though without some clever logic I'd likely export all of them which would be way more than we actually care about. Is that valuable or should I just not do any?In the best of times, our days are numbered, anyway. And it would be a crime against Nature for any generation to take the world crisis so solemnly that it put off enjoying those things for which we were presumably designed in the first place, and which the gravest statesmen and the hoarsest politicians hope to make available to all men in the end: I mean the opportunity to do good work, to fall in love, to enjoy friends, to sit under trees, to read, to hit a ball and bounce the baby.
Comment
Comment