Post by Danchat on Jul 26, 2022 22:08:28 GMT -6
I sat there all day, game by game .... haha j/k. I have my shortcuts . Which amount to CTRL+A, CTRL+V, and then a few formulas in excel to sort it all out.
I might have to get those formulas from you... maybe in exchange for some new features?
I tested with everything on default.
That is another thing I'm figuring out, what exactly the default coaching sliders should be. There's no coaching sliders table in Madden that can replicate what I have, so when a new roster is imported, I will need to have a default coaching slider table inserted into the database. I can have that match the 58/42 split.
True, but the problem with having to adjust the sliders is you have to do it all the time because you can't save them across multiple sessions. Adjusting the default settings would be easier xD.
Yeah, that is annoying. If I let you edit the sliders and send that to the database, then it changes for everyone. What I'm thinking right now is using an account system where you'll be able to log in and permanently edit the sliders as long as you are the one who uploaded that roster. It's either that or I create a new batch of data for every unique user accessing my site, which is not a sustainable model if I had a large number of users.
How do you adjust the sim to work with starters, but not backups? Isn't it going by their ratings?
It's not the sim, I manually edited the Madden stats in the PLAY table to get the QBs to play as closely as they did in the real 2021 season. I didn't touch the backup QBs' stats when I did this. I'll do the same for 2022 since that will be the roster that 90-99% of my users will be playing with, while the advanced users like you and others from Footballidiot will be playing with their own custom rosters.
Do you also have 1 point safeties?
No, I don't have blocked kicks implemented. Once/If I develop that, I don't know if I'll include 1 point safeties. I forgot they were a thing.
Yeah with 2 decimal places a totals page wouldn't be needed, just need to ignore the decimal on 100 game sims. I mentioned 1000 game sims because you had that option once upon a time, I noticed it had been removed, which is fine because 100 is good enough.
I'll get that done. And there hasn't been a 1000 game sim option previously... unless I completely forgot about it.
You should probably think about using someone elses rosters. Does RogerJinx come up with his own, or does he port them over from new versions of Madden using their roster/ratings patches?
I actually don't know what he does, but his rosters are by far the most popular on the site, so I figure they're the most accurate. I know he puts a lot of work into them, and how the ratings affect Madden 08 compared to my simulator are an entirely different beast.
That alone probably isn't enough to explain the wider pass/run TD ratio in the sim however (62.5% of TD's come via the pass in the NFL, 72.8% in the sim), or the lack of INT's and sacks. Which is odd because there are far too many sacks in Madden lol.
Not sure if I explained this before, but the simulator isn't bound to Madden tendencies since the code is based upon how Strat-O-Matic Football is played, which is then sprinkled in with layers of my code that basically attempts to recreate football like it is played in 2020-2021. So things like interception rate and sack rate are determined by my own variables and nothing related to Madden.
Perhaps it is time... yes, I think it is. Here is the origin of how I got to where the sack and interception rates are at. So in Fall-Winter 2021, I was working hard on the simulator in Python, and simulated a whole season of one of my custom-made Madden franchises. It took quite a while since the Python version only goes game by game instead of being as lightning fast as the Angular version... but here's the leaderboards for the passing games:
I felt like the sack and interception rates were too high for some of the best QBs in this league, so I balanced them out over the year and have implemented that into the Angular version. There's also some code that factors in awareness, break tackle, and speed/agility to allow QBs to evade sacks in different ways.
And for the heck of it, here is the receiving leaderboard for the league:
I wish I could get these up and running in the simulator, but this is coming from my SQL database that has tables that plop single-game stats into a table, and a trigger in that table immediately updates a seasonStats table that updates the values above. There's just no way to do it in the Angular simulator unless I let every user insert data into my tables, which could get out of control really fast, especially with how insanely fast it simulates games.
Here's one more tidbit, a view from a receiver's weekly output:
Having a weekly game log (something you can only find in the Superstar mode in Madden 08) would be really cool, but this is starting to go from simply simulating games to creating my own version of Pro Football Reference...