FanPost

The Spreadsheet


Hi Y'all. Or, greetings from beautiful Winchester, Va., the gateway to Appalachia.

Many of you who followed NMA last season know that I kept a spreadsheet of the players' weekly scores and stats. YFF generates a huge amount of data, but unfortunately the way they presented it was pretty poor. So I started collecting the data in Excel format (it's a 100% automated process - no way would I do box-by-box data entry for 38 weeks :-P).

Fortunately YFF's new format didn't screw up my data collection technique completely, and I'm happy to say the spreadsheet is available once again on Google Docs by clicking here.

The not-so-good news is that the new format is making it difficult to extract some of the data, such as SOT, CS, etc. It's too early to say it's impossible, and I'll be working on improving the sheet throughout the season (any advice from the statistically inclined is always welcome).

One other drawback of the new format is that it shows players who played but didn't score, and those who didn't play at all, the same way - with a zero (the latter used to be shown as a dash). YFF keeps dozens of players on their books who were loaned out or spend the entire season on the reserves, so to avoid confusion I've deleted all of the "zero" scores. The rosters will flesh themselves out as more players enter games and score points.

Another thing that YFF fanatics may find useful is that the spreadsheet includes data from the previous three seasons. I'm looking into relatively easy ways to make that data more useful, in case someone wants to see how Robin van Persie did at home v. Aston Villa, for instance.

Finally, I'm hoping to be able to continue another feature where after the deadline I count up the players selected by the Top 50 YFF teams every week. It would be great to include captaincies in those numbers, too.

I don't know if Yahoo keeps its historical FF data, and if they do, why it isn't made available, so I hope a few people find this useful.

Best of luck to all this season.

BtG

X
Log In Sign Up

forgot?
Log In Sign Up

Please choose a new SB Nation username and password

As part of the new SB Nation launch, prior users will need to choose a permanent username, along with a new password.

Your username will be used to login to SB Nation going forward.

I already have a Vox Media account!

Verify Vox Media account

Please login to your Vox Media account. This account will be linked to your previously existing Eater account.

Please choose a new SB Nation username and password

As part of the new SB Nation launch, prior MT authors will need to choose a new username and password.

Your username will be used to login to SB Nation going forward.

Forgot password?

We'll email you a reset link.

If you signed up using a 3rd party account like Facebook or Twitter, please login with it instead.

Forgot password?

Try another email?

Almost done,

By becoming a registered user, you are also agreeing to our Terms and confirming that you have read our Privacy Policy.

Join Never Manage Alone

You must be a member of Never Manage Alone to participate.

We have our own Community Guidelines at Never Manage Alone. You should read them.

Join Never Manage Alone

You must be a member of Never Manage Alone to participate.

We have our own Community Guidelines at Never Manage Alone. You should read them.

Spinner.vc97ec6e

Authenticating

Great!

Choose an available username to complete sign up.

In order to provide our users with a better overall experience, we ask for more information from Facebook when using it to login so that we can learn more about our audience and provide you with the best possible experience. We do not store specific user data and the sharing of it is not required to login with Facebook.

tracking_pixel_9353_tracker