Formation Spreadsheet

[motrin]

Awesome... Modify away

[Yabdul Balam Abdala]

*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

[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.

[Yabdul Balam Abdala]

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.

Good thinking. I'll fix it ASAP.
Thanks for testing the database I'll start updating them.

[motrin]

I'll start doing some testing. Just a quick test (only opponent side):

3N-1-3W-2(AMC)-1 didn't work
3N-1-4-1-1 came up as 3N-1-3W-2(AMC)-1
3N-1-4-2 didn't work
3N-2(DML/DMR)-3N-2 didn't work
3N-2(DML/DMR)-3W(AML/AMC/AMR)-2 comes up as 3N-2(DML/DMR)-3N-2
3N-2-3W(AML/AMC/AMR)-2 i think the 2 is for MCs. It works if I put in DMCs. If it is DMCs, then it's ok.
3N-3-2W(AML/AMR)-2 didn't work
3N-4-1-2 comes up as 3N-3-2W(AML/AMR)-2
3N-5-1-1 didn't work
3N-5-2 V-Style Didn't work
4-2-1-3 is set up for 2 DMC. I think it should be 2 MC-1AMC-3
4-2(DMC)-1-2(AML/AMR)-1 didn't work
4-2(DMC)-1-2(AMC)-1 comes up as 4-2(DMC)-1-2(AML/AMR)-1
4-3N-1-2 didn't work
4-3N-2(AMC)-1 comes up as 4-3N-1-2
4-3N-2W-1 comes up as 4-3N-2(AMC)-1
4-3N-3 didn't work
4-3w-1-2 and it came up TRUE for both 4-3n-3 and 4-3w-1-2
4-4-2 NARROW DIAMOND is already included earlier
4-4-2 WIDE DIAMOND doesn't work
5-1-3N-1 comes up as 4-4-2 WIDE DIAMOND
5-1-3W-1 comes up as 5-1-3N-1
5-2-1-2 X-Style comes up as 5-1-3W-1
5-2(ML/MR)-2(AMC)-1 comes up as 5-2-1-2 X-Style

Highlighted and attached:
positos3 - oppdbcheck.zip

[Arion]

Well this one should be pinned. The problems of all the newbies asking for counter formations will be solved. Good job @motrin

[afthiparktos]

I think that the contribution of a player in the surrounding squares shouldn't be a whole point.

[Yabdul Balam Abdala]

I think that the contribution of a player in the surrounding squares shouldn't be a whole point.

It isn't.
That's why I'm working on a different model.
Still the idea is great.

[motrin]

It isn't.
That's why I'm working on a different model.
Still the idea is great.

Can't wait. The screenshot you gave looks great.

[motrin]

Made a minor modification for now. Surrounding squares are only 1/2 point now.