Migara
Cricketer Of The Year
Change it in one place and then copy and paste.
If you know bit of VBA, then you can name the ranges with formula and can run a VB Script to make the changes.
-
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.
DoG's Top 100 Test Bowlers Countdown Thread 100-1
- Thread starter Days of Grace
- Start date
If you know bit of VBA, then you can name the ranges with formula and can run a VB Script to make the changes.
Days of Grace
International Captain
No. It would take too long. I only want to find and replace one number with another across an entire workbook. Should take 5 seconds but Excel is not letting me do it for some reason.
EDIT: I think I solved it.
I'm changing the batsmen average:strike rate ratio from 4:1 to 9:1 in keeping with our discussions on strike-rate being more important for bowlers than batsmen in test cricket.
EDIT: I think I solved it.
I'm changing the batsmen average:strike rate ratio from 4:1 to 9:1 in keeping with our discussions on strike-rate being more important for bowlers than batsmen in test cricket.
Last edited:
I'm missing something about how the factors are weighted. Barnes has better stats and a higher PPI for his peak than for non home. The peak bonus is double the away bonus, so i figure he should end up with more than double the points. He gets far less than double though. Why is this?
stephen
Cricket Web: All-Time Legend
His peak wasn't long enough I imagine.
Victor Ian
International Coach
I imagine you are working with variables all over the place. It can be worthwhile setting up a list of variables and then pointing to them instead. You can also name variables to make it easier to follow and refer to.
eg Cell A1 = 21 --> From Menu Insert|Name|Define (call it 'something')
Cell A2 formula is = something
Cell A2 value is 21
in your variables table, use a column to record the name you have assigned. Then you can keep that open to the side of your workspace for easy referencing rather than having to look into the cell to see what name you have given it all the time
then you could have 300*9>ratioaveragestrikerate,9 or 300*ratioaveragestrikerate)>ratioaveragestrikerate,ratioaveragestrikerate, etc
This will give you full freedom once its done to go nuts and figure out the numbers you need to get Allan Border to the top!
Migara
Cricketer Of The Year
Easiest way is to type in the constants in the sheet and do a static reference to them. When you want to change the number, merely changin the constant will do.
Days of Grace
International Captain
Ok. Do you guys agree that batsmen should have a 9:1 ratio for average:strike-rate?
Starfighter
Cricket Web: All-Time Legend
It'll have to do.
smash84
The Tiger King
Sounds reasonable. Although in test matches i wouldn't mind even if it was 19:1
ankitj
Hall of Fame Member
Sounds OK but when you look at Sehwag or Gilchrist, you'd think they need some bonus points for being attacking batsmen who thrashed opposition out of game in 1-2 sessions.
stephen
Cricket Web: All-Time Legend
Yeah and there needs to be a way of differentiating Kallis from Ponting.
Days of Grace
International Captain
I’m taking strike-rate into account so that really is the bonus.
90/10 for batsmen
80/20 for bowlers
jaideep
U19 12th Man
Are you considering the strike rate for innings of 50+ runs or career strike rate?
Days of Grace
International Captain
Career and every innings.
I don't think it was this. His peak was closer to 50 than his away career. It's not specific to Barnes anyway, he's just a clear example.
Days of Grace
International Captain
Barnes bowled in exactly 50 innings. So his peak was his career. Other bowlers with longer careers had a change to have better peak figures than Barnes.
Sure, explains why he doesn't have the best peak. I'm asking about the relationship between peak and away bonuses though. He ecored 184 in peak and 107 in away. With his peak being better than away statistically and in PPI, and peak counting for double, I would expect his away to score somewhere below 92. What causes the adjustment?
Days of Grace
International Captain
I take the average of all the stats for each criteria across the top 100. So a bowler's stats for each criteria is weighted (compared) against the stats of other bowlers in the top 100.
The averages for the peak criteria are 22.50 52.50 5.50. If you have these peak stats exactly then you will get 150 points (20% of 750).
If a bowler has the exact same stats as the average across the top 100 bowlers for all the criteria then they would get 750 points.
Last edited: