I absolutely love this. I have been trying on and off for years to make an fm game on excel but I’ve never had the coding skills. This is great so thank you for sharing. I hope you have success with some of the desirable features like transfers and injuries. Keep up the good work 👍
I’m trying to think of a way to make it work - at the moment statistics determines results. I guess then you could backsolve a probability of who scored based on position? I’ll have a think about it.
I would love to see stats after every game and your team stats season to date and leaderboards across each league. Not sure if it's possible but it would be a great addition and improve immersion. Great work.
Id love to know if you had any plans to add this because if not do I have permission to try add something like this in? I'd like to put some time into it in the new year
I’m trying to think of a way to make it work - at the moment statistics determines results. I guess then you could backsolve a probability of who scored based on position? I’ll have a think about it. Please feel free to add whatever you like. The whole idea was yo have the game unlocked so people better versed in the community can add yo the game!
One thing that stands out to me in this simulation is the amount of awful title defences. The champions of the first 24 seasons finished in the next season: 1st - 4 times 2nd - 1 time 3rd - 4 times 5th - 2 times 6th - 2 times 9th - 1 time 10th - 1 time 11th - 2 times 12th - 2 times 14th - 1 time 16th - 1 time 17th - 2 times 18th - 1 time This means that the model predicts the reigning champion to finish in the bottom half the following season over a third of the time, and in 4 of the 24 years the reigning champion breaks Leicester's record of worst title defense in the Premier League era.
Hi! I love your work but I found a bug with version 1.4. When developing players, they were able to go well beyond the 'potential' cap - to almost 20 in every skill.. I saw you have a formula that has a TRUE or FALSE boolean reponse that dictates if a player is able to develop, but in the Developmentcode module you are checking for the string "False" instead of FALSE to auto jump to the next player. PS would still love to see you try a Souls title on Excel!
@@Dynamic_Pear Change it to this: ' Check Development Flag If wsPlayerData.Cells(PlayerRow.Row, 74).Value = FALSE Then ' Column BV GoTo NextPlayer End If It's then looking for the Boolean true/false in the cell value instead of a string "False"
Hello mate and fantastic video! Just finished my first season as Liverpool coach. I loved the competitiveness of alll competitions. I finished 3rd with 79 points with Arsenal above me at 84 and Brighton winning the title with 85. I have two things to say from now on: 1) Is there a way to "edit" things in the game? (Team names, Stadiums, Values, Player Stats etc.) If so, how? 2) What is coming up next? European competitions? World Cup/Euros? Or maybe something simplier like the community shield? Im SO invested in this game! Please let me know whats next by answering this comment 🙏
@@thomaskroulis hi man. Glad you are enjoying! 1) During a save if you unhide the live player data tab (right click tabs at the bottom and click unhide) you can adjust player data to your hearts content! Depending how good your skills are in excel - you could, before a save, unhide the starting player data tab and change some things around. This will be a bit harder as for example if you change a team name, you will have to change it consistently every time the name appears across all tabs (hidden and visible). 2) I haven’t decided on this - the reason I kept everything open and unlocked is so people much better at excel can take what I have done and make it 20x better! So maybe someone else takes over and adds a tonne of new features ?
@Dynamic_Pear Hope you continue mate! Doing a video with Zealand will really push your channel a lot, trust me. Also, why not try to upload your file on FMscout or sortitoutsi? I'm sure it will get super popular real soon!
@Dynamic_Pear Hello again man, I got a couple of questions. First of all, how exactly are youth players generated? Are they recycled like PES or something else? I haven't sim many years so idk yet. Also, is there a way to sort teams (in the league standings) by their league position? Also, why is there no extra time in cups? Or penalties if possible?
Hey man, I love this game. I've just been wondering how to find where a players potential was, and also which stats for a player corresponds to their attacking, midfield or defending power? (For example, what constitutes a great midfielder? What attributes affect it?) I feel like its somehwere in the coding of the game, but I cant find it.
When I made the game I wanted these to be ‘hidden’ but available if you want them. Potential and current ability can be found on the live player data tab (just right click tabs at the bottom of the excel sheet and click unhide). To see the attributes that make up the attack, midfield and defence scores - the easiest way to see this is on the tactics/ team selection tab. If you look at the attack/midfield/ defence %s the formula will show which of the attributes impact each score. Glad you enjoy the game!
I have encountered a problem where in "Training" a player is listed as squad player but is on the starting 11. I looked at formula in the cell and it remains unchanged comparing it to the cells in the same column. Do you have any idea what could be the problem?
I would rather have that since it is an alternative to a pricey full version on Steam. Sadly, I would rather have customized team leagues similar to this.
I can not get this to work no matter what I try. Whenever I play matches the results are all blank. The "Last League Match" on the Team Hub is updated but everything else remains like the start of the season. Table is all zero and no results in leagues or cups. Tried over and over with different teams but the same outcome. I am using Excel 2024
Can confirm those teams work on my side. Can you you check the league fixtures and cup fixtures tabs - are their fixtures to be played? (I.e is it the issue on fixture generation or match results).
@@Dynamic_Pear Yep all the fixtures are there. When I press 'Progress/Next Match" the pop up shows, for example "PRE v QUE | Result: ". So the fixtures are there and the matches are being played but a result isn't being generated. Everything else appears to work perfectly
@@liam9563 Can I suggest you start a new game with a Champ/Leage 1/ League 2 team. Go into the Match Outcome Tab - Delete the text box warning and try the populate match fixtures, Random outcome and Publish Results league bottons. Will be intersting to know which one of those are failing for you.
Hi. Macros are the code pieces within excel. You will have to enable macros for the game to work. You may also have to create a new save file of the excel to allow macros to run.
It’s not the worst future! Had a blast making this game - whilst it’s not perfect I think it holds up pretty well!
Thanks for watching/playing :)
I absolutely love this. I have been trying on and off for years to make an fm game on excel but I’ve never had the coding skills. This is great so thank you for sharing. I hope you have success with some of the desirable features like transfers and injuries. Keep up the good work 👍
Thank you! Appreciate you taking the time to watch/ comment :)
I’ve been noodling on a similar project in Python. As someone who uses excel for work, this is really interesting. Great work.
@@oconnellda thank you! Can’t wait to see your python project!
Keep going brother and thank you for this gem
@@sydneymohadzs4966 thank you! I’ll keep testing my skills :)
this is sick, do you plan on adding leading goalscorer, leading playmaker, and cleansheet stats + leaderboard?
I’m trying to think of a way to make it work - at the moment statistics determines results. I guess then you could backsolve a probability of who scored based on position?
I’ll have a think about it.
I would love to see stats after every game and your team stats season to date and leaderboards across each league. Not sure if it's possible but it would be a great addition and improve immersion. Great work.
Id love to know if you had any plans to add this because if not do I have permission to try add something like this in? I'd like to put some time into it in the new year
I’m trying to think of a way to make it work - at the moment statistics determines results. I guess then you could backsolve a probability of who scored based on position?
I’ll have a think about it.
Please feel free to add whatever you like. The whole idea was yo have the game unlocked so people better versed in the community can add yo the game!
Sir, you are a genius. Period
@@ParkAreLeef17 thank you!
One thing that stands out to me in this simulation is the amount of awful title defences.
The champions of the first 24 seasons finished in the next season:
1st - 4 times
2nd - 1 time
3rd - 4 times
5th - 2 times
6th - 2 times
9th - 1 time
10th - 1 time
11th - 2 times
12th - 2 times
14th - 1 time
16th - 1 time
17th - 2 times
18th - 1 time
This means that the model predicts the reigning champion to finish in the bottom half the following season over a third of the time, and in 4 of the 24 years the reigning champion breaks Leicester's record of worst title defense in the Premier League era.
Hi! I love your work but I found a bug with version 1.4. When developing players, they were able to go well beyond the 'potential' cap - to almost 20 in every skill.. I saw you have a formula that has a TRUE or FALSE boolean reponse that dictates if a player is able to develop, but in the Developmentcode module you are checking for the string "False" instead of FALSE to auto jump to the next player.
PS would still love to see you try a Souls title on Excel!
Thank you for finding this. I thought that area of code ignored caps specific info, obviously not!
I will fix when I am back home. Much appreciated!
@@Dynamic_Pear
Change it to this:
' Check Development Flag
If wsPlayerData.Cells(PlayerRow.Row, 74).Value = FALSE Then ' Column BV
GoTo NextPlayer
End If
It's then looking for the Boolean true/false in the cell value instead of a string "False"
I have just released a V1.5 fixing this and another bug in the Current Ability element of the game.
Thank you for your assistance.
Hello mate and fantastic video! Just finished my first season as Liverpool coach. I loved the competitiveness of alll competitions. I finished 3rd with 79 points with Arsenal above me at 84 and Brighton winning the title with 85. I have two things to say from now on:
1) Is there a way to "edit" things in the game? (Team names, Stadiums, Values, Player Stats etc.) If so, how?
2) What is coming up next? European competitions? World Cup/Euros? Or maybe something simplier like the community shield? Im SO invested in this game! Please let me know whats next by answering this comment 🙏
@@thomaskroulis hi man. Glad you are enjoying!
1) During a save if you unhide the live player data tab (right click tabs at the bottom and click unhide) you can adjust player data to your hearts content!
Depending how good your skills are in excel - you could, before a save, unhide the starting player data tab and change some things around. This will be a bit harder as for example if you change a team name, you will have to change it consistently every time the name appears across all tabs (hidden and visible).
2) I haven’t decided on this - the reason I kept everything open and unlocked is so people much better at excel can take what I have done and make it 20x better! So maybe someone else takes over and adds a tonne of new features ?
@Dynamic_Pear Hope you continue mate! Doing a video with Zealand will really push your channel a lot, trust me. Also, why not try to upload your file on FMscout or sortitoutsi? I'm sure it will get super popular real soon!
@Dynamic_Pear Hello again man, I got a couple of questions. First of all, how exactly are youth players generated? Are they recycled like PES or something else? I haven't sim many years so idk yet. Also, is there a way to sort teams (in the league standings) by their league position? Also, why is there no extra time in cups? Or penalties if possible?
this is insane bro
Hey man, I love this game. I've just been wondering how to find where a players potential was, and also which stats for a player corresponds to their attacking, midfield or defending power? (For example, what constitutes a great midfielder? What attributes affect it?) I feel like its somehwere in the coding of the game, but I cant find it.
When I made the game I wanted these to be ‘hidden’ but available if you want them.
Potential and current ability can be found on the live player data tab (just right click tabs at the bottom of the excel sheet and click unhide).
To see the attributes that make up the attack, midfield and defence scores - the easiest way to see this is on the tactics/ team selection tab. If you look at the attack/midfield/ defence %s the formula will show which of the attributes impact each score.
Glad you enjoy the game!
@@Dynamic_Pear Ahh, thanks!
@@Dynamic_Pear one last thing... it seems like set pieces are useless in this game?
Best set piece taker in starting 11 has an impact in match outcomes.
Can you try making an nba manager game using Excel 😢
I’ll add it to the list!
I have encountered a problem where in "Training" a player is listed as squad player but is on the starting 11. I looked at formula in the cell and it remains unchanged comparing it to the cells in the same column. Do you have any idea what could be the problem?
Not sure - hadn’t heard of this problem previously.
I’ll look into it
have u thought of making a discord server for this channel? please do so
@@mitchisindo I havent - do you think there would be a real interest in this?
just great! The only problem is that i get any results when i simulate games. Do someone know whats wrong?
@@lyricsertv2297 sounds like an issue with how excel treats languages - there is a fix in the comments section of my blog.
I would rather have that since it is an alternative to a pricey full version on Steam. Sadly, I would rather have customized team leagues similar to this.
Hey, im just wondering can i play this in excel 2021?
Not sure - why not give it a go and let us all know!
ok i've tried it but for some reason the results of matches won't show up, do you know the reason for that
@@Fenruari could be language issue - if your not in English excel. Solution is in the comment section of my blog
I can not get this to work no matter what I try. Whenever I play matches the results are all blank. The "Last League Match" on the Team Hub is updated but everything else remains like the start of the season. Table is all zero and no results in leagues or cups. Tried over and over with different teams but the same outcome. I am using Excel 2024
@@liam9563 Hi Liam - sorry you are getting these issues.
Are you on a PC or a Mac? What teams have you tried?
@@Dynamic_Pear On PC, I have tried, Chelsea, Crystal Palace, Wolves and Wigan
Can confirm those teams work on my side. Can you you check the league fixtures and cup fixtures tabs - are their fixtures to be played?
(I.e is it the issue on fixture generation or match results).
@@Dynamic_Pear Yep all the fixtures are there. When I press 'Progress/Next Match" the pop up shows, for example "PRE v QUE | Result: ". So the fixtures are there and the matches are being played but a result isn't being generated. Everything else appears to work perfectly
@@liam9563 Can I suggest you start a new game with a Champ/Leage 1/ League 2 team. Go into the Match Outcome Tab - Delete the text box warning and try the populate match fixtures, Random outcome and Publish Results league bottons. Will be intersting to know which one of those are failing for you.
i think it was obvious but I couldn't play it in excel 2013
can we get a mobile version
Wouldn't excel work in phone as well?
When i wanna start a game it says a macron cant open what is that and how do i fix it
Hi. Macros are the code pieces within excel. You will have to enable macros for the game to work.
You may also have to create a new save file of the excel to allow macros to run.
Please make a google sheets version lah
Not my area of expertise sorry - but happy for someone else to convert!
Bro can we play this on Android if than please make a tutorial video how we can play on Android
@@Piyushkumar-sq4dv just in excel my man - so will only work on a pc/ laptop.
🤓