Fan Projections Now Exportable
I’ve made a few updates as requested for the Fan Projections.
– The Fan Projections now only require 15 votes to be eligible. This added an additional 200 or so players into the mix and I imagine that most MLB regulars and some not so regulars should have Fan Projections now.
– There’s now an UZR column in the sortable projections.
– You can now export the Fan Projections to either Excel or CSV files in the projections page.
David Appelman is the creator of FanGraphs.
Dave —
can you make “more batted ball data” exportable? Such as specific GB numbers, FB numbers and IFFB nbrs?
Haha, Kenji Johjima has the highest projected OPS. Most people’s stats are fairly high, but the rankings look pretty solid.
Heh, Johjima’s fan projection is just broken. I think when updating his projection people might have just pushed the playing time down to zero without changing his HR/2B/3B numbers to zero too.
The way his projections work out between batting average and 2B/3B and HR, he’s projected to hit -6 singles as in negative-six singles.
Why is it that there is still the issue with the player names? On the Export to CSV function the names come out like:
Chase Utley
On the Export to Excel function all the names (and also the column headers) are hyperlinked.
Will this ever get fixed? Or is it not seen as a problem?
Funny–I tried to demonstrate the HTML coding that’s an issue in the Export to CSV function and the website resolved it. Let’s try this, putting a space in between the < and the a:
Chase Utley
Nope, that did not do it either. Let’s try once more, i will remove the Chase Utley
This too drives me somewhat nuts.
Hmm, I guess there’s no way to show it here because of the way the website resolves these. But look in your Excel, you will see what I mean after you download it.
I know what you’re talking about. Someone has a script out there to remove the HTML and break it down into player name/playerid. Honestly, it’s not a particularly easy fix because our export function literally takes what’s in the table and spits it out.
Also the way it is now you actually do get the playerid and historical position for the player when this was not the intended case.
I guess “fixing” this is somewhere on the to-do list, but when there’s one person coding the entire site it all comes down to priority and this in my opinion is not a high one.
Anyone have a method of deflating stats across the board? Shouldn’t be too difficult on excel, but what do I know, I’m still working on the SUM function.
Most of the stats look solid, but fan projections are giving pitchers too high of a WHIP versus other projections.
Yes, that still needs to be fixed. Hits for pitchers are definitely out of whack.
Can we add Android app to the to-do list?
In order to get rid of the HTML code, create a new column in Excel beside the name column.
Create the formula:
=MID(A2,FIND(“>”,A2,1)+1,LEN(A2)-FIND(“>”,A2)-4)
This should get rid of the HTML code.