*** VD 15 Commentary Thread ***

[johnnya24]

Does that dropbox link work for anyone else? https://www.dropbox.com/s/fe1c1enhg9...iveupload?dl=0

Does this work?

https://www.dropbox.com/s/8077k6i3e9ley71/hitter%20franchise%20data.xlsx?dl=0

EDIT: I think I uploaded the previous link too soon

[johnnya24]

Year spans sheet (3 years or 5 year spans)

https://drive.google.com/file/d/1DUtPcuVSVM9Hkl4Pg0mr_zN6CVBV_6Uz/view?usp=sharing

I know this is more data than we need (it's literally everyone, including pitchers who hit), but I'd rather start with that and let you guys pare it down rather than miss something.

That's amazing!

You're a wizard Ken.

[Ken]

Does this work?

https://www.dropbox.com/s/8077k6i3e9ley71/hitter%20franchise%20data.xlsx?dl=0

EDIT: I think I uploaded the previous link too soon

Yes this works, and I have the formulas to get your answers on franchizes. Excel is a little slow, so once it catches up I'll get you the answers

[cavebird]

Have we figured out how many franchises there are total once the BR designations that are the same franchise are combined?

[johnnya24]

Have we figured out how many franchises there are total once the BR designations that are the same franchise are combined?

Yeah. We are using the same as before. KS had all the old data stored in a spreadsheet. And the new Lahman database has the same team / franshise codes.

[Ken]

Yes this works, and I have the formulas to get your answers on franchizes. Excel is a little slow, so once it catches up I'll get you the answers

Heh, I got the answers but the formulas are huge so we have a 30 MB spreadsheet. I'm paring it down by adjusting how the formulas work.

[johnnya24]

Heh, I got the answers but the formulas are huge so we have a 30 MB spreadsheet. I'm paring it down by adjusting how the formulas work.

We can use that as a reference sheet for the future.

Then we can just "rasterize" the data for now ... or whatever the computing version of rasterization is.

[Ken]

https://drive.google.com/file/d/1niLJROmSOwtf8qvY6iKxumGukjYK9WuP/view?usp=sharing

I pared it down.

A few notes -
1) There's at least one player issue (A.J. Pierzynski I'm sure due to the periods). Worth looking through for others. Can probably just sort the 2nd tab by the max years to find them.
2) If editing the formulas, make sure that sheet 2. and 3. have the same column A - I'm not doing a lookup there, just assuming that they are going to be the same.
3) I went ahead and created a text representation of the franchises in column AN. i.e. Hank Aaron has "ATL" and Ed Abbaticchio has "ATL,PIT". This is in addition to the tick marks.
** note the tick marks on (3) are strings "1" instead of numbers (1). Did this so I could use "" in the formula for the blank cells.

I'm sure this can be improved slightly but I think it gets us 95% of the way there.

[johnnya24]

That's awesome ... i'll go through all that tonight when I hit the "quiet hours".

[The Feral Slasher]

That's awesome ... i'll go through all that tonight when I hit the "quiet hours".

I thought that was when you wash windows ?

[johnnya24]

I thought that was when you wash windows ?

Correct.

[heyelander]

"wash windows"

[johnnya24]

"wash windows"

and correct.

[DMT]

Welcome RJ's newest member jmaeroff, who will be joining us for VD15!

[Ken]

Welcome RJ's newest member jmaeroff, who will be joining us for VD15!

curious, how did he get in? Bryon never could.