CSV Download Files - Missing Variables & Changes - Please Change Back

[RAY@HQ]

Bunch of changes this AM in CSV-land:
- player names are last, first
- age and bats added
- LIMA added
- 3 ADP fields added (min, max, ADP)
- all negative playing time guys filtered out

There's still some weirdness down in the low-PT end of the file (negative ABs, etc), and the LY15 issue that Blueboy noted above is still outstanding.

Bottom line: we still have some cleanup to do IN the file, but in terms of format of columns/layout, I think we might have that nailed now. Anyone who disagrees with that, let me know.

[blueboy714]

Reported, thanks. I've made data cleanup issues our top tech priority. Should see a lot of improvement in that area this coming week.

Thank you Ray. I appreciate it. I'm still unsure why the download file formatting changing with the new website redesign. It would have been easier to keep the layout the same.

The new download file for projections have been a nightmare. I've been subscribing to BHQ site since the early 2000's and getting the books long before that. I went with the draft prep this year because I have an early draft this year. If the files aren't corrected this week then I am SOL. If the download files are corrected this week can I get refund on my subscription?

[RAY@HQ]

Reported, thanks. I've made data cleanup issues our top tech priority. Should see a lot of improvement in that area this coming week.

[blueboy714]

I found another issue.

7 - there are a ton of players with a blank LY15 (played 15 games at a position last year) that actually qualified at their primary position according to new "POS" column. Ohtani is a DH but his LY15 is blank, Yainer Diaz qualifies at C (he played 60 games at C) but his LY15 is blank.

This is just an absolute nightmare to try to use these projections this year.

[viper]

Ray's request would be the best of all possible worlds for me.

[viper]

I use the Text to Column feature in the Data grouping in Excel. The break option is a space. You need three blank columns as there are a couple of De Los Santos's out their. I sort this by the column you would find Jrs in. This puts all the multi columned players together. Correct them manually to make just two names. Assume the First name is in Col A and the last name is in column B. The formula is name = ColB&", "&ColA. I have to do this with all the FanGraph sites. It was so nice before not to have to deal with it in BBHQ but that's life.

[RAY@HQ]

I've requested the names be changed back to last, first in one cell.

[Sleehrat]

Quick-and-dirty method to split a name field into first name and last name, using Excel:

If full name is in cell A2:

First name:

=LEFT(A2,SEARCH(" ",A2)-1)

Last name:

=RIGHT(A2,LEN(A2)-SEARCH(" ",A2,1))

My savior is using =TextSplit formula, designating split by spaces. the extra names an Jr. II, III add an extra step for me, but it my go-to formula for breaking out a field that has multiple items in the cell. I then Concat it back to a =(last name,", ",first name) formula.

[RAY@HQ]

Is there an update as to when these will get fixed/updated? I'm behind on my projections because BHQ's new site & player data is so messed up since going to the new format.

As I said, a matter of days. I said to someone else in another thread, things are getting fixed quickly in general, we've cleaned up a lot of stuff since last weekend. But I'm not going to be able to give ETAs on any specific fix. I did put this in my highest-priority group yesterday.

[blueboy714]

Quick-and-dirty method to split a name field into first name and last name, using Excel:

If full name is in cell A2:

First name:

=LEFT(A2,SEARCH(" ",A2)-1)

Last name:

=RIGHT(A2,LEN(A2)-SEARCH(" ",A2,1))

Thanks - That doesn't always work for someone with a name with multiple spaces in their full name - esp. Japanese names and players with middle initials. I use something similar but it isn't 100% perfect either.

[Tom_T]

Quick-and-dirty method to split a name field into first name and last name, using Excel:

If full name is in cell A2:

First name:

=LEFT(A2,SEARCH(" ",A2)-1)

Last name:

=RIGHT(A2,LEN(A2)-SEARCH(" ",A2,1))

[blueboy714]

These are all pretty easy changes, should just be a matter of days.

Is there an update as to when these will get fixed/updated? I'm behind on my projections because BHQ's new site & player data is so messed up since going to the new format.

[RAY@HQ]

These are all pretty easy changes, should just be a matter of days.

[blueboy714]

Yes, will get all of these cleaned up except BPV. BPX is just BPV indexed to league average (ie 100 = average, 110 = 10% better than league average). We've switched to BPX in the Forecaster for a number of years, and will lock in on BPX here on the site going forward.

(Yes, we also need to bring over/upgrade the Glossary so we can document these things.)

Good list, thanks for enumerating these.

Thanks - BPX is a lot more useful than BPV.
Do you have a time-frame for these updates getting done? I am about week behind past years in my league drafts prep because of these changes.

[RAY@HQ]

Yes, will get all of these cleaned up except BPV. BPX is just BPV indexed to league average (ie 100 = average, 110 = 10% better than league average). We've switched to BPX in the Forecaster for a number of years, and will lock in on BPX here on the site going forward.

(Yes, we also need to bring over/upgrade the Glossary so we can document these things.)

Good list, thanks for enumerating these.