Flem274*
123/5
If it bothers you I'm happy to withdraw.
-
Welcome to the Cricket Web forums, one of the biggest forums in the world dedicated to cricket.
You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join the Cricket Web community today!
If you have any problems with the registration process or your account login, please contact us.
2022-2023 New Zealand First-Class Draft
- Thread starter Kippax
- Start date
HeathDavisSpeed
Cricket Web: All-Time Legend
@Kippax - not sure I can think of a way around this issue using the current scoring model.
The issue here is the different points for Batsmen 1-5, 6-7 and 8-11 but excluding night-watchmen.
I did think that I could use the 1st innings as the default batting line up, but there's still a chance of a night-watchman there.
Then, from one game to the next, someone like McPeake (who is at best a reasonable #9) could end up being #7 due to a combination of electoral lunacy and the selection of players like Snedden, McComb etc. So, from one game to the next, McPeake could go from being worth 12 to 21 points.
This is the sort of non-logical, human-led thing where Excel sucks. Two alternatives would be:
1. Create a data table listing whether each player is top order, middle order, tail ender. In this case, regardless of place in the batting order, McPeake would always count as tail ender. The downside is having to add new players to the database and the lack of clarity over some players' roles (e.g. Georgeson could be opening, could be down at #7/8)
2. Use FC batting averages as a proxy. Say, if you have an average <15 at the start of the season, you're a tail ender. <30 & >15 then 'middle order' and >30 top order. Problems here are small sample sizes for some players, new players having no average at all but would recognise a wicket's value based on a (somewhat flawed) measure of a batsman's quality.
Obviously changing to either of these mid-season isn't workable, but something to think about in the future.
For now, it probably means an extra manual adjustment for the scorer. At least it should only be 3 adjustments
1. Blunter's Bonus
2. Spinner's Parsimony Bonus
3. Adjust value of wickets taken when batting line-up used a night-watchman
Any other suggestion as an alternative to 1 or 2 above is welcome!
Athlai
Not Terrible
When I ran this forum game, there was significantly less toxicity. Maybe you should try that.
straw man
Hall of Fame Member
That sounds bad, I'm glad you're at least well enough to write a post. Get well soon vandem.
straw man
Hall of Fame Member
Amazing work @HeathDavisSpeed to mostly automate the scoring.
I'd briefly thought of how to do that myself, it seemed a huge task to pull the data from the format on the scorecards, pull out the relevant data and use oodles of special-case logic for the sorts of things below.
I'd briefly thought of how to do that myself, it seemed a huge task to pull the data from the format on the scorecards, pull out the relevant data and use oodles of special-case logic for the sorts of things below.
You've made pretty short work of it, very well done.
HeathDavisSpeed
Cricket Web: All-Time Legend
Ha! Longer ago than I care to think (about 12 years ago I suspect: http://www.cricketweb.net/forum/threads/rugby-union-sim.52393/), I built a rugby simulator in excel which will spit out commentary and statistics for an imaginary game of rugby. That taught me all the excel functions you need to know for this sort of task. This was child's play in comparison. But thank you!
I think it probably took about an hour or two of work all up to get it to the point it is now.
HeathDavisSpeed
Cricket Web: All-Time Legend
I cbf to come up with rules. Heef's too much of a happy-go-lucky, heads in the clouds guy for such things as rules to tie him down. Plus, he likes talking in the 3rd person.
Come up with some rules, I might be able to though. As long as you keep them simple.
honestbharani
Whatever it takes!!!
Plz do it for IPL next year too, Heef.
Athlai
Not Terrible
Yeah simple is always good, the CW Fantasy system isn't too bad for scoring as a baseline imo. Then tinkering around to see what seems most fair to everyone.
Twenty20 Matches
| Batting | Points |
| Each Run Scored | 1 Point |
| Scoring Rate 250+ | 60 Points |
| Scoring Rate 200.0 - 249.9 | 50 Points |
| Scoring Rate 175.0 - 199.9 | 40 Points |
| Scoring Rate 150.0 - 174.9 | 30 Points |
| Scoring Rate 125.00 - 149.99 | 20 Points |
| Scoring Rate 100.00 - 124.99 | 10 Points |
| Scoring Rate 75.01 - 99.99 | -5 Points |
| Scoring Rate 0.0 - 75.0 | -10 Points |
| Duck | -10 Points |
| Golden Duck | -20 Points |
| Diamond Duck | 0 Points |
Scoring rate min 20 runs or 20 balls
| Bowling | Points |
| Each Wicket Taken | 30 Points |
| Each Maiden Over | 10 Points |
| R.R.P.O: 3.0 or Less | 40 Points |
| R.R.P.O: 3.01 to 4.00 | 30 Points |
| R.R.P.O: 4.01 to 5.00 | 25 Points |
| R.R.P.O: 5.01 to 6.00 | 15 Points |
| R.R.P.O: 6.01 to 7.00 | 10 Points |
| R.R.P.O: 8.01 to 9.00 | -10 Points |
| R.R.P.O: 9.01 to 10.00 | -15 Points |
| R.R.P.O: 10.01 to 12.00 | -20 Points |
| R.R.P.O: 12.01 to 14.00 | -25 Points |
| R.R.P.O: 14.00+ | -30 Points |
Min 2 overs for economy
| Per Catch | 10 points |
| Per WK Catch | 8 Points |
| Per Run Out | 10 Points |
| Per Stumping | 15 Points |
| Notes: If applicable all players involved in a run out score points. | |
| 30 Run milestone | 15 Points |
| 50 Runs | 30 Points |
| 75 Runs | 45 Points |
| 100 Runs | 60 Points |
| 130+ Runs | 80 Points |
| 3 Wicket Haul | 40 Points |
| 4 Wicket Haul | 50 Points |
| 5 Wicket Haul | 60 Points |
| 6 Wicket Haul | 75 Points |
| Not Out / Retired Hurt | 5 Points |
| 4+ WK Dismissals | 20 Points |
| 3+ Fielding Dismissals (Non WK) | 20 Points |
| Man of the Match | 100 Points |
HeathDavisSpeed
Cricket Web: All-Time Legend
I've pretty much built 90% of that already. A few more formulae over the top and it'd work. Taking out the non-logic based functions means that you'd be able to automate 100% of the data. Perhaps using a macro to add the data to a separate sheet which effectively becomes the database.
Kippax
Cricketer Of The Year
Fancy low-ceiling McConchie and low-ceiling Schmulian delivering a 'Dawson crying' meme to Wellington youths, just as we were trying to get the ball rolling about discontinuing the use of the Dooka before Christmas.
One of that pair doesn't even have South African heritage on his side.
One of that pair doesn't even have South African heritage on his side.
Kippax
Cricketer Of The Year
2022/23 New Zealand First-Class Draft
Last edited:
Kippax
Cricketer Of The Year
Yes sorry for putting you crook pre-season. He's now got about 20 more bowling points than batting points. Maybe only one game left in his season, too. There's a chance he joins Munro in PSL cricket from the start of February until well into March.
Any word on Nuttall down your way @kaetor? Trying to prove fitness down at A level, or just joined McClure in getting on the wrong side of NZ stars being available and a Canty seeing good potential in its under-25s?
Any word on Nuttall down your way @kaetor? Trying to prove fitness down at A level, or just joined McClure in getting on the wrong side of NZ stars being available and a Canty seeing good potential in its under-25s?
straw man
Hall of Fame Member
Knew it was a risk - such is life.