Page 1 of 8 123 ... LastLast
Results 1 to 10 of 75
Like Tree42Likes

Thread: Formation Spreadsheet

  1. #1
    Dreamer motrin's Avatar
    Join Date
    Feb 2016
    Posts
    451

    Formation Spreadsheet

    When I started playing this game, I made this little spreadsheet to help me decide which formation I would use for matches:

    Formation Spreadsheet-formation-tactics.jpg

    Basically, I enter the formation of my opponent by placing a 1 where there is a player. Then I place my players. Below, it will show which team has better coverage on each block. The numbers inbetween are just indicators of how many defenders/midfielders/attackers that I have vs my opponent.

    Previously, I could enter the individual player quality on the right side. I removed that for now since I didn't find it useful (It can easily be added back by changing the ACOUNT to SUM in the formulas.

    I've been experimenting with the spreadsheet suggesting suitable tactics. They're probably all messed up but it's a work in progress. Use at your own risk.

    No, it doesn't guarantee anything, and I make no claims for it. It only helps me visualize the strength of the formations and I figured someone here may find it useful.


    I created a throwaway Google account to upload the spreadsheet to incase you just want to try it. Just remember that anyone can edit this one. I recommend you copy it to your own google sheet account and use from there.

    Formation Spreadsheet
    Last edited by motrin; 03-28-2019 at 05:49 AM.

  2. #2
    Greek Forum Moderator nikolgiorgos's Avatar
    Join Date
    Jul 2014
    Posts
    17,714
    Interesting
    It's good for me that I spend only 2-3 min to set my team for the next game.
    Of course setting the formation is only the half job.
    Καλώς ήρθατε στο Ελληνικό φόρουμ
    http://forum.topeleven.com/%CE%93%CE...%B4%CE%B1.html

  3. #3
    Newbie
    Join Date
    Mar 2016
    Posts
    2
    I got an error while opening the .xml =(.
    "This XML file does not appear to have any style information associated with it".
    Anyone have an idea on how to solve it?
    Thanks!!

  4. #4
    Dreamer motrin's Avatar
    Join Date
    Feb 2016
    Posts
    451
    Not XML...xls. Excel spread sheet

  5. #5
    Dreamer motrin's Avatar
    Join Date
    Feb 2016
    Posts
    451
    I created a throwaway Google account to upload the spreadsheet to incase you just want to try it. Just remember that anyone can edit this one.

    https://docs.google.com/spreadsheets...it?usp=sharing
    Last edited by motrin; 03-08-2016 at 01:27 AM. Reason: edit link

  6. #6
    Newbie Theodor Dinu's Avatar
    Join Date
    Apr 2014
    Posts
    40
    I find it a fantastic idea. Will give it a try.
    Manager of Invictus

  7. #7
    Newbie
    Join Date
    Jun 2013
    Posts
    25
    This is sooo clever, I can't believe i didn't think of this myself.

    Edit: The excel attachment didnt work, i used the Gdocs file

  8. #8
    Newbie
    Join Date
    Jun 2013
    Posts
    25
    I'll work on this and make some adjustments (some of your calculations are misplaced IMHO).
    When I'm done with the corrections I'll share it with you.

  9. #9
    Newbie
    Join Date
    Jun 2013
    Posts
    25
    Already working on something:

    Formation Spreadsheet-screenshot-324-.jpg

  10. #10
    Dreamer motrin's Avatar
    Join Date
    Feb 2016
    Posts
    451
    Awesome... Modify away

Page 1 of 8 123 ... LastLast