TꙬLS for Career Mode Stories: English Football Leagues
November 7, 2021 3:35AM
edited October 2022
https://youtu.be/glLYSBb9DSQApplication 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:
User Guide
Spreadsheet Applications Post edited by Virtual_K on
1
Howdy, Stranger!
Comments
More sample screenshots:
EFL Championship League Table
Promotion Playoff Bracket
Weekly Results
I'm not being paid by Virtual_K to write this review at all. Easily, 5/5 star rating.
Check's in the mail.
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?
I used the custom table only twice so far, it seemed to work fine without any issues.
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.
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.
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
֎ 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
֎ 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).
More Screenshots:
Weekly Results menu with custom colors
Team Summary
I'll update the other English leagues in the near future.
Download
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.
֎ 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.
Download
֎ 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.
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.
UPDATE: EFL Championship, League One, and League Two have been updated.
Download
֎ 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.
֎ 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.
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.
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
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:
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
p.s. Chelsea need to get their sh** together
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.
Sample Match Reports:
Full report
Condensed
Stats can be isolated and used with other scoreboards if desired.
Penalties will auto hide/show if option enabled, or manual if desired.
Stats will change colors with the teams.
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.
Competition configuration
Match Events configuration
Weather Icons configuration
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
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.
Hope this doesn't discourage people from giving it a try.