Formation Spreadsheet

[Yabdul Balam Abdala]

Making any progress?

I'VE BEEN VERY BUSY AT JOB, BUT I DID MAKE SOME PROGRESS.
THERE ARE STILL THINGS TO BE MADE, PLEASE CHECK IT OUT AND GIVE ME YOUR FEEDBACK.

KUDOS,

EXCEL FILE: https://www.dropbox.com/s/cgl2eyujj7...itos.xlsx?dl=0

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

[Tactician]

I have tested the first few formations using Microsoft Excel 2010.

The following formations from the database sheet are not detected.
3N-1-3W-2(AMC)-1
3-1-4-2

3-1-4-1-1 is detected as 3N-1-3W-2(AMC)-1.

[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

[motrin]

OK...finished up the opponent side, highlighted in yellow/red and attached to the post. I didn't check the Me side. I also used Microsoft Excel 2010.

[Yabdul Balam Abdala]

OK...finished up the opponent side, highlighted in yellow/red and attached to the post. I didn't check the Me side. I also used Microsoft Excel 2010.

That's Perfect !
The Me side can by Copied from the opponent side, later this night I'll Update with this fixes.

If I manage to implement the "recomend CounterFormation" feature I'll post it tomorrow.
Thanks a lot for your help

[Yabdul Balam Abdala]

*Update*

Version 4
https://www.dropbox.com/s/a2xepegzk7...opia.xlsx?dl=0

- Fixed formation detection
- Addded ilegal formation detection
- This should probably be enough for most ppl.

Version 5
https://www.dropbox.com/s/xnu757dbci...opia.xlsx?dl=0

- Compares formations against a table and gives a rating to the specific matchup selected.*
- Values are random ATM.

this was fun, i hope its useful to you guys

[motrin]

*Update*

Version 4
https://www.dropbox.com/s/a2xepegzk7...opia.xlsx?dl=0

- Fixed formation detection
- Addded ilegal formation detection
- This should probably be enough for most ppl.

Version 5
https://www.dropbox.com/s/xnu757dbci...opia.xlsx?dl=0

- Compares formations against a table and gives a rating to the specific matchup selected.*
- Values are random ATM.

this was fun, i hope its useful to you guys

I'll take a look in the next couple days. I'm loving it so far