I started typing this update at 11:49am local time, so I'm still sticking to the my claim of "live tomorrow morning" as being accurate!
Attached is v1 of the spreadsheet.
Here are some important things to consider:
Some slider values are probably wrong. In fact, they could well be wrong in multiple places
That's the point of publishing them, and having a version history attached. Sliders go out into the world, people play with them, find how usable/accurate/broken they are, then we revise and publish another version.
If you use any of the sliders and have a game, come back in here and report what happened. Say what was good, say what wasn't good. Say what changes you made and if they worked. That's how we keep this project moving and improve it version on version.
Some parts of the world are harder for batting than others
The sliders in v1 have a hierarchy of conditions. They are as follows:
(Bowler friendly) West Indies --> South Africa --> Asia --> England/NZ --> Australia (Batter friendly)
That's the scale.
Can you make 400+ batting in the West Indies? Sure, but it'll be hard, it's only happened twice since February of 2019 IRL.
Will you automatically make 400+ batting in Australia? No, you'll have to bat well to do it, it isn't just a given. Ask England.
User ability is a thing
These sliders are not just plug and play.
If 100% of people just copy them down from the spreadsheet and put them straight into the game, 90% are probably going to be disappointed. The settings needs to be tailored to your own ability, how you like test cricket to be played, how you like the AI to play, there's loads of variables. It's not a one size fits all kind of deal.
I currently play on Veteran difficulty. Others will play on Legend, etc. etc. The difficulty level between even myself and Wealey is fairly noticeable. We both have fun playing our own way tho.
The spreadsheet is a guide, a starting point. No doubt with some trial and error of your own, you'll find something even better for you.
The spreadsheet itself
All you need to do is download it, click the dropdown box at the top of the one sheet available and off you go. All formula are hidden and can't be accidentally edited. It should be pretty hard to break! The sheet is designed so that the drop down box is the only thing that can be edited.
I managed to DL it fine on a laptop and on my phone. The only issue with a phone is you need some form of app to view excel files if you want to do it that way.
Thanks to
@WealeyH for his hard work on this one, and the others who have chipped in as well. It is a group effort and your time and expertise are thoroughly appreciated.
I'll put the spreadsheet on the first post so it doesn't just get lost in this wider thread.
Let me know how you all get on!