M24 Custom Playbook Tool & CFM GM Tool

[Philosopher0]

Hey guys I built a spreadsheet for my 32 user cfm league for planning out custom playbooks. It has a formation and play logs that list everything available in a custom playbook as well as formation guides with who lines up where in what formations. Also included are playcall sheets, GM Tools, and loads of other things too!
Check it out.

https://docs.google.com/spreadsheets...t?usp=drivesdk

[A_ZomBevo]

*EDIT* I am dumb ignore the question for a GM league lol

[Philosopher0]

I missed the question but the gm tool can be used for each team in a gm leagues

[canes21]

Great sheet. Thank you for sharing this.

[Blazer81]

I may be missing something but on the planner sheet, I am not getting a drop down for formations. Is it me or...?

[RogueHominid]

This is so cool.

I’ve tried to reduce a number of playbooks to 1 formation to see who has the best single formation to use as a base.

Do you happen to know which books can reduce to 1 normal shotgun formation like Gun Doubles Y Off WK or something like that? Or even something like Single Back Ace?

[Philosopher0]

Quote: Originally Posted by Blazer81

I may be missing something but on the planner sheet, I am not getting a drop down for formations. Is it me or...?

Try making a new copy of the masters heat I was updating the sheet and fixing a bug around when you posted this it might be fixed now.

[Philosopher0]

Quote: Originally Posted by RogueHominid

This is so cool. I’ve tried to reduce a number of playbooks to 1 formation to see who has the best single formation to use as a base. Do you happen to know which books can reduce to 1 normal shotgun formation like Gun Doubles Y Off WK or something like that? Or even something like Single Back Ace?

I've gotten a playbook down to sjngkeback dice slot and y trips, it's possible to get it down to many sets, here's the trick to it...

So there are 2 scenarios we can't rate plays for:
* conserve time (which supercedes 2 minute scenerario for some reason) and
*play action

So you can rate one play 1 star in all scenarios, and delete all the other formations until ideally down to 1 or 2 formations you like or ones that are out of the way and rarely used like an I form tight formation maybe.

You'll have issues though depending on what plays in a playbook are rated a star for those scenarios. In one playbook, let's say buffalo, gun tight might not have a pause play that's rated in that scenario, even if it has pa plays. But in nyg playbook maybe it does.

The order you delete formations can help too. I try and trim a playbook down to 5 sets I can live with. Save it. Then try various ways to whittle it down ideally to 1 set, if I screw up I retry from the save, or I try another playbook.

On Xbox next gen madden share I have one uploaded I believe with only about dice slot and yvtrips, but I may try and make a series of empty playbooks with different starting formations.