Formation Spreadsheet

[Tactician]

*UPDATE* Version 3

New:
- Formations Database
- Automatic Formation recognition
- Removed Vanilla model
- Clear Board Button (inactive ATM)
- DropDown selector

So, the idea here is to incorporate The CounterFormations Table (Sticky Forum Post) with a dynamic search within the excel file. It's actually really easy, and I want to improve the functionality and format, but currently I need help.

Somebody needs to test the formation detection and Highlight in red those that dont work and highlight in yellow the ones that work.
I'll wait for someone to do this testing and once we get this done I'll move to the next part.

-Cheers

Excel File: https://www.dropbox.com/s/omscomuzkl...opia.xlsx?dl=0

Thanks.

So no flavour this time?

About the formation recognition, if 4-1DMC-2MC-2WAM-2F is set as formation, it is detected as 4-5-1V. If a 3rd striker is added (4-5-3V), it is detected as 4-1DMC-2-3, and if 4-1DMC-2MC-3AMW-2F is set, it is detected as 4-1-2-1-2 N.D. 4-3MC-2WAM-3F is detected as 4-2-2-2 Hexagon. If you play with the other positions by adding extra players (more than 11), you will notice a similar effect. So, briefly, there is some sort of conflict when there are more than 11 players on the board.

Setting more than 11 players on the board should return as a non-valid formation message.