| | M11 Offensive Formations Spreadsheet TOOL | |
|
| Author | Message |
|---|
wangtangkiki

Posts: 2280 Join date: 2010-02-13
 | Subject: M11 Offensive Formations Spreadsheet TOOL Mon Nov 15, 2010 11:16 pm | |
| 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 WildcatSubformation 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/M11OFormationsBREAKDOWNSTATS: 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 _________________ PSN: wangtangkiki MB's Most Helpful Member 2010! MB's Member of the Year 2010!Thank you guys, I appreciate it. Madden is my passion. So are spreadsheets. Any video requests for M12? Email me: wangtangkiki@gmail.com
Last edited by wangtangkiki on Fri Nov 19, 2010 7:01 pm; edited 1 time in total |
|
 | |
jalapenos789

Posts: 173 Join date: 2010-09-19
 | Subject: Re: M11 Offensive Formations Spreadsheet TOOL Mon Nov 15, 2010 11:51 pm | |
| thanks! good stuff. musta taken awhile haha. |
|
 | |
bahdbwoy
Posts: 611 Join date: 2010-03-18
 | Subject: Re: M11 Offensive Formations Spreadsheet TOOL Mon Nov 15, 2010 11:55 pm | |
| 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 |
|
 | |
wangtangkiki

Posts: 2280 Join date: 2010-02-13
 | Subject: Re: M11 Offensive Formations Spreadsheet TOOL Tue Nov 16, 2010 12:05 am | |
| 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? _________________ PSN: wangtangkiki MB's Most Helpful Member 2010! MB's Member of the Year 2010!Thank you guys, I appreciate it. Madden is my passion. So are spreadsheets. Any video requests for M12? Email me: wangtangkiki@gmail.com |
|
 | |
bahdbwoy
Posts: 611 Join date: 2010-03-18
 | Subject: Re: M11 Offensive Formations Spreadsheet TOOL Tue Nov 16, 2010 12:09 am | |
| Yea exactly.. I'm sure everyone would click to see |
|
 | |
Ryker3

Posts: 180 Join date: 2010-08-29 Location: West Coast
 | Subject: Re: M11 Offensive Formations Spreadsheet TOOL Tue Nov 16, 2010 12:17 am | |
| 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" |
|
 | |
xHHx_megatron

Posts: 1334 Join date: 2010-04-05 Age: 24 Location: sooner state
 | Subject: Re: M11 Offensive Formations Spreadsheet TOOL Tue Nov 16, 2010 12:42 am | |
| |
|
 | |
ZFarls Admin

Posts: 1684 Join date: 2009-06-18 Age: 25 Location: Boston, MA
 | Subject: Re: M11 Offensive Formations Spreadsheet TOOL Tue Nov 16, 2010 8:20 am | |
| Awesome! _________________ [url]www.twitter.com/maddenbible[/url][/b] "A customer is the most important visitor on our premises, he is not dependent on us. We are dependent on him. He is not an interruption in our work. He is the purpose of it. He is not an outsider in our business. He is part of it. We are not doing him a favor by serving him. He is doing us a favor by giving us an opportunity to do so"  www.maddenbible.com |
|
 | |
eelyak
Posts: 53 Join date: 2010-08-10
 | Subject: Re: M11 Offensive Formations Spreadsheet TOOL Tue Nov 16, 2010 8:34 am | |
| |
|
 | |
ZAN

Posts: 1388 Join date: 2010-03-16 Age: 22 Location: Springfield, IL
 | Subject: Re: M11 Offensive Formations Spreadsheet TOOL Tue Nov 16, 2010 12:18 pm | |
| Repped. _________________ 1x C4 360 Majors SB Champ (Season V) Inaugural C4 NCAA 360 Champ, COTY, and MVP (Trifecta) C4 Most Consistent Madden 11 Player C4 Madden 11 Defensive Player of the Year Madden Bible's (Madden 12) TWIMMY post-humous Co-Defensive Player of the Year w/Jerms |
|
 | |
jordantrav

Posts: 167 Join date: 2010-02-20
 | Subject: Re: M11 Offensive Formations Spreadsheet TOOL Tue Nov 16, 2010 1:46 pm | |
| |
|
 | |
xHHx_JayNizz

Posts: 1521 Join date: 2010-01-24 Age: 21 Location: California
 | Subject: Re: M11 Offensive Formations Spreadsheet TOOL Tue Nov 16, 2010 2:02 pm | |
| 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!!!!!!! |
|
 | |
Tyler1281

Posts: 445 Join date: 2010-03-19 Location: Boston, MA
 | Subject: Re: M11 Offensive Formations Spreadsheet TOOL Tue Nov 16, 2010 2:53 pm | |
| |
|
 | |
wangtangkiki

Posts: 2280 Join date: 2010-02-13
 | Subject: Re: M11 Offensive Formations Spreadsheet TOOL Wed Nov 17, 2010 5:07 am | |
| 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  _________________ PSN: wangtangkiki MB's Most Helpful Member 2010! MB's Member of the Year 2010!Thank you guys, I appreciate it. Madden is my passion. So are spreadsheets. Any video requests for M12? Email me: wangtangkiki@gmail.com |
|
 | |
bahdbwoy
Posts: 611 Join date: 2010-03-18
 | Subject: Re: M11 Offensive Formations Spreadsheet TOOL Wed Nov 17, 2010 5:45 am | |
| I forgot you did the o like that.. Thought it was still like the d list.. Yea that works |
|
 | |
| | M11 Offensive Formations Spreadsheet TOOL | |
|