TꙬLS for Career Mode Stories: English Football Leagues

1
Virtual_K
2030 posts Fans' Favourite
edited October 14

Application Preview

Hello. Technically, this is not a Career Mode Story but an Excel application I've been working on for a while that may be used to supplement a story and perhaps inspire some new people to create one. I have done a few stories in the past, mostly MLS based, but I have also used a previous version of this EPL application and decided to enhance it and make it usable to others since the Premier League is the most popular league, and a good place to start. My hope is to add English Championship before the end of the year.

UPDATE: EFL Championship, League One, and League Two are now available.

What does the application do?
In short, the application provides a league table, team summaries, weekly results, and some team stats. After some simple initial setup (entering team names, configuring logos and colors) the user just enters match scores into an easy-to-use form and the application does the rest. The user can create images to use in their story with just a click of the button (see the preview video).

❶ Use the custom table options to create an auto-sorting league table to look the way you want.
❷ Change the color scheme of weekly results to match your story theme.

System Requirements:
Microsoft Excel for Windows version 2019 and above or Excel 365, 32-bit or 64 bit with macros enabled.

CURRENT VERSIONS:
English Premier League v5.2.15 Updated July 2022!
English Championship v5.2.15 Updated July 2022!
English League One v5.2.15 Updated July 2022!
English League Two v5.2.15 Updated July 2022!

MatchLogv0.9.9beta Newly added October 2022!

*Various enhancements and fixes.

Download:
LAxk6yB.pngUser Guide

30hWBYG.pngSpreadsheet Applications
Post edited by Virtual_K on

Comments

  • Virtual_K
    2030 posts Fans' Favourite
    edited November 2021
    EUQx3Y2.png
    Post edited by Virtual_K on
  • Virtual_K
    2030 posts Fans' Favourite
    edited January 24
    English Premier League Table:
    dDbTnXw.png

    More sample screenshots:
    Rk6bMp4.png
    EFL Championship League Table

    7hXziOf.png
    Promotion Playoff Bracket

    kuyCb1d.png
    Weekly Results

    Post edited by Virtual_K on
  • Stlducks
    10272 posts Has That Special Something
    Hello, first time caller, long-time listener here. Big fan of the excel sheet. If anyone is intimidated by all the information, don't be. It is very easy to work. Take 10 minutes to set it up initially by putting in team names, stadium names, logos, credit card number and colors then the rest is very easy. It takes me only a minute after each match to put in the match scores and it does the table for me.

    I'm not being paid by Virtual_K to write this review at all. Easily, 5/5 star rating.
  • Virtual_K
    2030 posts Fans' Favourite
    Stlducks wrote: »
    Hello, first time caller, long-time listener here. Big fan of the excel sheet. If anyone is intimidated by all the information, don't be. It is very easy to work. Take 10 minutes to set it up initially by putting in team names, stadium names, logos, credit card number and colors then the rest is very easy. It takes me only a minute after each match to put in the match scores and it does the table for me.

    I'm not being paid by Virtual_K to write this review at all. Easily, 5/5 star rating.

    Check's in the mail. :D

    Thanks for the kind words.

    If anyone has questions or has run into any problems feel free to post in this thread.
    I have been spending all my free time working on the English Championship version, which is not that far off.
    Curious as to how the Custom Table is working for anyone who has tried it...anyone?
  • Stlducks
    10272 posts Has That Special Something
    Is anyone else here using the sheet? I know if you posted it on Reddit or Operation Sports it would be very popular just because there are more players on those sites.

    I used the custom table only twice so far, it seemed to work fine without any issues.
  • Virtual_K
    2030 posts Fans' Favourite
    Stlducks wrote: »
    Is anyone else here using the sheet? I know if you posted it on Reddit or Operation Sports it would be very popular just because there are more players on those sites.

    I used the custom table only twice so far, it seemed to work fine without any issues.
    I never visit those other sites. My main interest is to help this section by providing a resource that can reduce some of the work in doing a story. And if not, at least I tried. :)
  • Virtual_K
    2030 posts Fans' Favourite
    edited November 2021
    uqgybUE.jpg
    English Championship application is now available to download.

    ֎ English Football League 1 and 2 is currently under development and expected in a few weeks at the most. Given the similarity, they will be released at the same time.
    Post edited by Virtual_K on
  • Virtual_K
    2030 posts Fans' Favourite
    edited November 2021
    uqgybUE.jpg

    English Football League One and League Two are available to download..

    ֎ English Premier League and English Championship have also been upgraded to v5.1.2 adding a new stat to the team Summary: Current unbeaten streak.
    English Championship v5.1.1 was released prematurely and the clinch indicators and some of the graphs reference a 38 match season instead of 46, so it is recommended to download v5.1.2.

    If any errors are found just post them here and I'll fix them, otherwise this should be my last post for a while.
    Post edited by Virtual_K on
  • CHYP2074
    2598 posts Fans' Favourite
    Sorry to ask but how much does it cost? I love the idea but can't afford a really high cost...
  • Virtual_K
    2030 posts Fans' Favourite
    edited December 2021
    CHYP2074 wrote: »
    Sorry to ask but how much does it cost? I love the idea but can't afford a really high cost...

    Cost? LOL! The bit about the credit card from @Stlducks was a joke. It's all free, unless you don't have Excel and need to buy it...but go to Microsoft for that. :)

    Edit: I checked the download link and it had expired yesterday. Should be able to download now if that was the problem. :#
  • CHYP2074
    2598 posts Fans' Favourite
    Virtual_K wrote: »
    CHYP2074 wrote: »
    Sorry to ask but how much does it cost? I love the idea but can't afford a really high cost...

    Cost? LOL! The bit about the credit card from @Stlducks was a joke. It's all free, unless you don't have Excel and need to buy it...but go to Microsoft for that. :)

    Edit: I checked the download link and it had expired yesterday. Should be able to download now if that was the problem. :#

    lolol ok thanks
  • Virtual_K
    2030 posts Fans' Favourite
    uqgybUE.jpg

    ֎ Found a bug in all variations of the application where a change in font color to weekly results didn't get applied to the home team. Don't know how I missed that one, but it's been fixed. English Premier League and English Football Championship Honors page received a minor update in appearance.

    ❶ A Feedback button has been added to the menu to allow anonymous feedback and bug reporting within the app.
    ❷ A Download Files button has been added to the menu to download the latest versions of the applications.

    If any errors are found you can use the feedback button (preferred) or post them here.

    Download
  • Virtual_K
    2030 posts Fans' Favourite
    edited January 29
    uqgybUE.jpg

    ֎ Finally got around to adding a Calendar Browse feature for the EPL application, something I wanted to do at the beginning. The feature is available when editing scores and reviewing weekly results, which will make browsing match days easier. Also modified the look of the team logo on the Summary page, something I had been meaning to do for a while. I've also added a toggle full screen button to the navigation menu as well as some other minor improvements (see Readme in application).

    cF5SMra.png

    More Screenshots:
    yKXbHim.png
    Weekly Results menu with custom colors

    y3U8hQD.png
    Team Summary

    I'll update the other English leagues in the near future.

    Download

    Post edited by Virtual_K on
  • Stlducks
    10272 posts Has That Special Something
    Awesome. I’ll download this tonight and transfer my current one over. Fantastic stuff like always!
  • Virtual_K
    2030 posts Fans' Favourite
    Stlducks wrote: »
    Awesome. I’ll download this tonight and transfer my current one over. Fantastic stuff like always!

    Thanks again. I should mention that I had to fix a minor problem with the import wizard that would overwrite the default values if update custom colors was checked. So if you downloaded prior to Jan 26, 2022 then the file will have this minor bug. :#
  • Virtual_K
    2030 posts Fans' Favourite
    edited January 29
    uqgybUE.jpg

    ֎ English Football Championship, League One, and League Two have been updated to version 5.2.0 that includes the Calendar Browse feature.

    Should be my last English Leagues update for a while; moving on to another project. Will be happy to fix any issues that come up, however. B)

    Download

  • Virtual_K
    2030 posts Fans' Favourite
    edited February 23
    uqgybUE.jpg

    ֎ I am currently working on a match stats application, and in the process I had updated a few interchangeable forms that handle color configuration. They now include Excel's color picker dialog when configuring colors that allows the user to select standard colors or see custom colors as they are being entered. Excel still lacks a built-in eyedropper tool, but I understand that feature (available in PowerPoint) is being considered for a future release.

    mDK0dJM.png

    Status messages have been added for logo file paths that are empty or invalid plus a minor fix to the Honors page formatting. The EFL applications should be updated within the next several days. B)

    UPDATE: EFL Championship, League One, and League Two have been updated.

    Download
    Post edited by Virtual_K on
  • Virtual_K
    2030 posts Fans' Favourite
    uqgybUE.jpg

    ֎ I messed up the 5.2.1 update by accidentally deleting a cell required for My Club highlighting to work properly. Needless to say, that has been fixed with this update for all league versions. All should be well now...sorry. :#
  • Virtual_K
    2030 posts Fans' Favourite
    VU6Xbx3.png

    ֎ Greetings! While I'm still actively working on the match stats application (coming along slowly but surely), I came across a few potential issues with the English League applications that have been fixed with this update.
    1. A potential error can occur if a user attempts to add a score when no teams are configured that requires the user to restart the navigation menu. The Edit Scores button is now disabled until league teams are added.
    2. When editing individual team scores, there was the potential to add duplicate records if the user hit the update and continue button twice. This issue has been resolved.
    3. The English Football League tables had an issue with the match day results display on the Summary page when the number of matches reached at or near 40 (did not affect Premier League). This issue has been resolved.

    All in all, the applications work pretty well at this point. To test, I have been entering real time scores from the Premier League and English Championship each week; a testament to how easy they are to use. I hope to have something to post for the match statistics app by the end of this month. This app can be used with any league and will log match results and statistics so you will have something to show your grandchildren. :D
  • Virtual_K
    2030 posts Fans' Favourite
    uqgybUE.jpg

    Howdy! :)

    It's been awhile since I've posted on this matter, but I have done a lot of work on the match logging spreadsheet app recently and thought I would post an update before FIFA23 is released. Truth is, I took a long break because I was starting to doze off in front of my laptop screen :tired_face: . I have largely completed the data entry/retrieval portions of the app, which is the most challenging aspect, and am currently working on the graphical match presentation.

    The app, when finished, will be able to log all matches and relevant stats for an entire manager/player career (2000+ matches) and provide a configurable graphic. This includes:
    • Scores
    • Graphical Match Stats
    • Match Events (goals, assists, substitutions, etc.)
    • Penalties (if required)

    I also plan to add some additional things like a monthly match results (all competitions) and some type of annual summary report similar to the one in the League Tables apps for starters.

    It's should be pretty cool when completed, and will work with any competition and team. It will also be simple to use (similar to the League Tables).

    Peace out B) .

    p.s. Chelsea need to get their sh** together :lol: .
  • StevieCoys
    175 posts Has Potential To Be Special
    That sounds awesome. I'm amazed at the work you have done on this already and envy your excel skills!
  • Virtual_K
    2030 posts Fans' Favourite
    StevieCoys wrote: »
    That sounds awesome. I'm amazed at the work you have done on this already and envy your excel skills!

    It's one of those things where persistence pays off. I was playing my first player career mode back in the good ol' days when FIFA had game face (bring it back!) and decided that I wanted to create a real league table, not just one where I copied info from the screen. I schlepped through the process without reading a manual and discovered that the more I learned, the more I didn't know. I bought Excel Bible and read a chapter a day. At the end was a sampler section on VBA, enough to make me buy Excel Power Programming with VBA.

    You can do really cool things with VBA, and it's not that hard once you get your head around the sheer number of objects with their properties, events, and methods. :s The joke is, I learned how to really use Excel just for this stupid game! :lol:
  • StevieCoys
    175 posts Has Potential To Be Special
    That's hilarious. I have heard of people becoming fans of teams because they used them in a career but I have never heard of someone learning excel because of a game. At least you can say playing video games made you smarter.
  • Virtual_K
    2030 posts Fans' Favourite
    edited October 5
    Not sure if anyone still visits this section, but I thought I would post some screenshots of the Match Log application. The components seem to be working correctly, so after I button up a few things, I'll release a beta if anyone wants to try it out. As of now, the app will generate a graphical match report with some smart elements like auto hiding/showing penalties and changing competition colors and logos. The user even has the option to manually hide or show portions of the match report, like stats for instance.

    Sample Match Reports:

    xcaMU4D.png
    Full report
  • Virtual_K
    2030 posts Fans' Favourite
    th4Eyee.png
    Condensed

    V9IVTvG.png
    Stats can be isolated and used with other scoreboards if desired.

    zJ9RpXZ.png
    Penalties will auto hide/show if option enabled, or manual if desired.
    Og5zr1F.png
    Stats will change colors with the teams.
  • StevieCoys
    175 posts Has Potential To Be Special
    These look really good. I would love to try them out.
  • Virtual_K
    2030 posts Fans' Favourite
    StevieCoys wrote: »
    These look really good. I would love to try them out.

    Thanks! I put a lot of effort into making it quick and easy to use. I've used earlier versions of this app for my own stories in the past and it only takes a couple of minutes to enter the match data, the rest is just point and click. Hopefully I can get a lot done this weekend. I am shooting for the following weekend for initial release.

    I will mention there is a little bit of setup but nothing complicated. You can save time by having a folder of team logos, competition logos, match event icons, and weather icons at the ready. I'll post some screenshots to give you an idea what to expect.
  • Virtual_K
    2030 posts Fans' Favourite
    edited October 14
    Configuration Screenshots

    puOJdPe.png
    Competition configuration

    jUpcVGt.png
    Match Events configuration

    Dtyjh4B.png
    Weather Icons configuration
    Post edited by Virtual_K on
  • Virtual_K
    2030 posts Fans' Favourite
    edited October 15
    RHpFv29.gif

    Match Log beta is now available to test.

    While the beta is missing some planned features like a monthly and annual report, it is still pretty functional.
    The Import Wizard has been fully implemented and will import teams and the color table from the League Tables applications as well as upgrade the Match Log app when version 1.0.0 becomes available. The Match Report has a modular display, meaning the user has the option to turn off and on some portions of the graphic: Header, Scoreboard, goal scorers, penalties, bottom bar, and stats.

    Download
    Post edited by Virtual_K on
  • Virtual_K
    2030 posts Fans' Favourite
    Whoops!

    It seems I forgot to remove a REM statement that caused the Match Log beta not to be able to update the log tables when entering match information. Not a good way to start, but it has been fixed now. :blush:

    Hope this doesn't discourage people from giving it a try.
Sign In or Register to comment.