FanPost

Brainstorming: Choose your squad

Dmitry Korotayev

International break coming up, and Chelsea isn't playing until the 19th of this month. I took this time to prepare a spreadsheet trying to emulate a new process for "You chose the squad" articles.

I posted a fanshot a couple of days ago, and 4 of you were generous enough to share your thoughts about the squad you'd like to see for CHE-CAR, Stamford Bridge. Since this was not enough data to come up with a general idea, I have taken the liberty to randomly duplicate the 4 entries to come up with 61 entries. Then I added a random entry with a lot of mistakes in it, viz, choosing only 8 players, 2 of them goalkeepers to iron out the problems we might face with this system.

The form in the linkshot above maybe tweaked by removing the "Not in the squad" option, as Google forms anyway allow you to not select any option from the available list. Here is how a generic form might look:

61c8c2b3_o_medium

Here are a few screenshots from the spreadsheet that show some results:
70c7d73d_o_medium

Data imported from the votes cast:
9a71f35f_o_medium

Sorting the imported data:
27f5cd35_o_medium

Graph showing votes cast:
724b6458_o_medium

More sorting and formation analysis:
13764daf_o_medium

Final results (Manual):
341029bc_o_medium

This is a brainstorming fanpost. Anyone interested, discuss in the comments and we can further tweak it.
We can also add a graphic representation of the chosen team.

If you would like to see the spreadsheet in it's entirety, I have shared it on Google Drive

This FanPost was contributed by a member of the community and was not subject to any sort of approval process. It does not necessarily reflect the opinions held by the editors of this site.

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 We Ain't Got No History

You must be a member of We Ain't Got No History to participate.

We have our own Community Guidelines at We Ain't Got No History. You should read them.

Join We Ain't Got No History

You must be a member of We Ain't Got No History to participate.

We have our own Community Guidelines at We Ain't Got No History. 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