Page 3 of 8 FirstFirst 12345 ... LastLast
Results 21 to 30 of 75
Like Tree42Likes

Thread: Formation Spreadsheet

  1. #21
    Newbie
    Join Date
    Jun 2013
    Posts
    25

    Progresss

    Quote Originally Posted by motrin View Post
    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
    motrin and afthiparktos like this.

  2. #22
    Newbie
    Join Date
    Jun 2013
    Posts
    25
    *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
    motrin and sparklinginsilence like this.

  3. #23
    Elite Tactician's Avatar
    Join Date
    Jun 2015
    Location
    Mauritius
    Posts
    3,053
    Quote Originally Posted by Yabdul Balam Abdala View Post
    *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.
    Last edited by Tactician; 03-20-2016 at 08:14 PM.
    quit this game (23/08/2015)
    started playing again (13/03/2016)
    quit this game (08/08/2016)
    playing (11/12/2016)
    quit this game (11/01/2017)
    playing (May 2017)
    quit this game (23/07/2017)
    playing (22/07/2018)
    quit this deceiving game (24/08/2018)
    playing (02/09/2019)
    Final Quit; Enough is Enough (10/12/2019)

  4. #24
    Elite Tactician's Avatar
    Join Date
    Jun 2015
    Location
    Mauritius
    Posts
    3,053
    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.
    Last edited by Tactician; 03-20-2016 at 08:10 PM.
    quit this game (23/08/2015)
    started playing again (13/03/2016)
    quit this game (08/08/2016)
    playing (11/12/2016)
    quit this game (11/01/2017)
    playing (May 2017)
    quit this game (23/07/2017)
    playing (22/07/2018)
    quit this deceiving game (24/08/2018)
    playing (02/09/2019)
    Final Quit; Enough is Enough (10/12/2019)

  5. #25
    Newbie
    Join Date
    Jun 2013
    Posts
    25
    Quote Originally Posted by Tactician View Post
    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.

  6. #26
    Dreamer motrin's Avatar
    Join Date
    Feb 2016
    Posts
    451
    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
    Last edited by motrin; 03-20-2016 at 09:43 PM.

  7. #27
    Dreamer motrin's Avatar
    Join Date
    Feb 2016
    Posts
    451
    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.

  8. #28
    Newbie
    Join Date
    Jun 2013
    Posts
    25
    Quote Originally Posted by motrin View Post
    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

  9. #29
    Newbie
    Join Date
    Jun 2013
    Posts
    25
    *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
    sparklinginsilence and motrin like this.

  10. #30
    Dreamer motrin's Avatar
    Join Date
    Feb 2016
    Posts
    451
    Quote Originally Posted by Yabdul Balam Abdala View Post
    *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

Page 3 of 8 FirstFirst 12345 ... LastLast