M11 Offensive Formations Spreadsheet TOOL

This is a new spreadsheet I decided to come up with because I was tired of searching on my "M11 Offensive Formations" spreadsheet for each playbook that has a formation I'm interested in..


This spreadsheet lists every offensive formation in the game.

The teams are listed from left to right based on what book has the MOST plays from that formation.. You'll see that Run Balanced is listed as "Team 1" for Singleback ACE, it's because that playbook has the MOST plays from SB ACE.


Here are the 11 formations:

Singleback
I-Form
Strong
Weak
Full House
Split
Near
Far
Shotgun
Gun
Wildcat


Subformation names are listed on each Formation's sheet.

The BEST thing about it is if you want to know what the sub-formation looks like.. Just click the name of that sub-formation.. you have an image open up
If I want to see Gun Snugs Flip, I click the Gun tab, then find Snugs Flip [In alphabetical order], then click the name.

or

If I want to see what playbook has my favorite formation in it that includes a HB Counter, Toss, AND HB Stretch play, I will check the team with the MOST plays in that formation.


LINK >>>>> http://tinyurl.com/M11OFormationsBREAKDOWN









STATS:

Most plays in a sub-formation (ALL TIED WITH 24 PLAYS):
Singleback ACE - Run Balanced
Singleback DICE SLOT - IND
Singleback Y-TRIPS - Run N Gun
I-Form PRO - Run Balanced
Gun PATS WING TRIPS - NE
Gun DOUBLES - Pass Balanced
Gun DICE SLOT - IND

Subformations:
Singleback: 49
I-Form: 15
Strong: 17
Weak: 12
Full House: 4
Split: 2
Near: 1
Far: 2
Shotgun: 2
Gun: 76
Wildcat: 13

thanks! good stuff. musta taken awhile haha.

Nice job .. What would be helpful if you wanted to put in the time is if we could click on the team name to show us what else that book has..

"wow Kc has x plays in x set- let me see what else they have"... List formations with # of plays

Could be something like the image which is definitely I nice bonus

Ok I see what you mean.

I'll work on that.. I'll see if I can and how.. I have a M11 Offensive formations spreadsheet already.. so I should make it so if I click on "KC" it will bring up all the other formations? w/ amount of plays?

Yea exactly.. I'm sure everyone would click to see

Basically he is asking you to combine the two spreadsheets you have.

For those who want to know what else the playbook has, just check out his other spreadsheet in his Sig.

"Madden 11 Offensive Formations"

*cough* nice *cough*

Awesome!

Pretty slick, gj

Repped.

amazing work!

this is exactly y maddenbible is the best, not only because of the best hosts, but on this website we have the best members

WHO AM I?!!!!

I AM A CHAMPION!!!!!!!

nice job man

Ok, someone look at this again please.


Tell me if you like what I added.

I've basically added a bar where you can click on the team name & you'll be taken to the tab on my other spreadsheet corresponding to that team. I like it.












If I made it so you could click the team name, I would have to find and replace the amount of plays, and the team name..

Find "18 - HOU" Replace with "=HYPERLINK("https://spreadsheets.google.com/pub?key=0Avm21nwnDRi9dEEyNU0tT2VXTGJ1dU1yOGRzWUZNZFE&hl=en&gid=12", "18 - HOU")"

Find "15 - HOU" Replace with "=HYPERLINK("https://spreadsheets.google.com/pub?key=0Avm21nwnDRi9dEEyNU0tT2VXTGJ1dU1yOGRzWUZNZFE&hl=en&gid=12", "15 - HOU")"

Find "9 - HOU" Replace with "=HYPERLINK("https://spreadsheets.google.com/pub?key=0Avm21nwnDRi9dEEyNU0tT2VXTGJ1dU1yOGRzWUZNZFE&hl=en&gid=12", "9 - HOU")"




Multiplay that by 37 times and I don't have the patience

I forgot you did the o like that.. Thought it was still like the d list.. Yea that works