Discussion BBL|10 SC: Team & In-Game Discussion - Home of #1 and #2 Leagues
- Thread starter Goodie's Guns
- Start date
Thanks mate appreciate the help, that’s given me a bit to think about. I’ve rejigged my team so I can use my stars players to trade for say Salt, Rashid and Siddle/Briggs I can have a fair few DGR players for the first 3 rounds. Hopefully M.Short actually plays or that’s a real waste of a spot. Cheers
Attachments
On the 3 trades issue, I agree that sometimes we just assume we have to/will use them and maybe that can get us into sticky situations.
Equally if you only had 2 trades you wanted to use, I suspect there would almost always be a 3rd side swap (eg for cash gen, if nothing else) that wouldn’t be beneficial ex ante. Whether it works out that way ex post is another question 🙂
Equally if you only had 2 trades you wanted to use, I suspect there would almost always be a 3rd side swap (eg for cash gen, if nothing else) that wouldn’t be beneficial ex ante. Whether it works out that way ex post is another question 🙂
Made an interesting no-Short (rd 1) team for 7 dgw depending on if Dunk is used after seeing Handscomb,
11 dgw rd 2 (getting Ellis, short and khan for stoinis, Zampa and Maxwell),
and up to 8 dgw round 3 (although that is a lot of strikers, Carey, Siddle, wells and Briggs main omissions to bring in but expensive so would likely need to trade Short). Any more than this would mean MShort and Nielson /Valente which is too far.
Food for thought for the DGW optimisers amongst us
11 dgw rd 2 (getting Ellis, short and khan for stoinis, Zampa and Maxwell),
and up to 8 dgw round 3 (although that is a lot of strikers, Carey, Siddle, wells and Briggs main omissions to bring in but expensive so would likely need to trade Short). Any more than this would mean MShort and Nielson /Valente which is too far.
Food for thought for the DGW optimisers amongst us
Attachments
This looks pretty good to me.
One feature of the “planning in blocks” approach is that it works well as a reminder of the impact of decisions in 2-3 rounds time. In particular it can work well to work backwards - eg starting from the fact that Adelaide have back to back DGRs, that’s a big advantage to picking their players, so which ones do you want, and how and when do you get them in?
For me it’s a reason to start somewhat fewer Hurricanes (who have the same early fixture, with one fewer DGR than Adelaide) and/or SGR players.
You might find that spots for a couple of Jacks/Ingram/Milne/Tye/Morkel types end up giving you more upside if they become (say) a Strikers player, when viewed across rounds 1-3.
You can obviously go too far with the DGR players, but (assuming you don’t start 5+ Strikers and create yourself a bye problem in R1) Strikers look more appealing to me than Hurricanes and even Stars, given the two DGRs - so I’m starting from that point.
One feature of the “planning in blocks” approach is that it works well as a reminder of the impact of decisions in 2-3 rounds time. In particular it can work well to work backwards - eg starting from the fact that Adelaide have back to back DGRs, that’s a big advantage to picking their players, so which ones do you want, and how and when do you get them in?
For me it’s a reason to start somewhat fewer Hurricanes (who have the same early fixture, with one fewer DGR than Adelaide) and/or SGR players.
You might find that spots for a couple of Jacks/Ingram/Milne/Tye/Morkel types end up giving you more upside if they become (say) a Strikers player, when viewed across rounds 1-3.
You can obviously go too far with the DGR players, but (assuming you don’t start 5+ Strikers and create yourself a bye problem in R1) Strikers look more appealing to me than Hurricanes and even Stars, given the two DGRs - so I’m starting from that point.
Starting to have doubts on the benefits of Dunk/Gotch now even at their price and DGR
Round 2 Maddinson is due back
Round 3 Bye
Round 4 isn't this where they said Bairstow is available from ?
and no one knows for sure when Pooran's first game is.
only other similar priced options though are :-
Gilkes/Holt (Billings factor)
Peirson (possibly Banton keeps)
looping Handscomb/McDermott Game 1 could cause issues if they fail
Bancroft $ 84,200.00 but could lose his spot to Livingstone & Roy.
Round 2 Maddinson is due back
Round 3 Bye
Round 4 isn't this where they said Bairstow is available from ?
and no one knows for sure when Pooran's first game is.
only other similar priced options though are :-
Gilkes/Holt (Billings factor)
Peirson (possibly Banton keeps)
looping Handscomb/McDermott Game 1 could cause issues if they fail
Bancroft $ 84,200.00 but could lose his spot to Livingstone & Roy.
Slickered, Remaining Salary $0.00. Guess it's meant to be.
B Dunk. (B McDermott.)
M Stoinis, G Maxwell, A Finch, C Lynn, M Bryant. (P Salt, H Nielsen.)
D Short, A Zampa, W Jacks, N Coulter-Nile, B Stanlake. (N Ahmad, M Owen.)
Anyone care to take a punt on the Hurricanes batting line up without Wade. Keen to know where Handscomb fits in the mix with McDermott and Ingram.
B Dunk. (B McDermott.)
M Stoinis, G Maxwell, A Finch, C Lynn, M Bryant. (P Salt, H Nielsen.)
D Short, A Zampa, W Jacks, N Coulter-Nile, B Stanlake. (N Ahmad, M Owen.)
Anyone care to take a punt on the Hurricanes batting line up without Wade. Keen to know where Handscomb fits in the mix with McDermott and Ingram.
You’re right about the AFL, and I believe it has changed recently for the BBL, so it is immediate.
Even adjusting for the two round lag, if a player was priced at $400k and punching out 120 every week (ie what you’d need to be worth $600k), I reckon it would probably take >6 rounds to make say 80% of the cash difference. The last bit is always very slow, but the first but does come quicker.
Even adjusting for the two round lag, if a player was priced at $400k and punching out 120 every week (ie what you’d need to be worth $600k), I reckon it would probably take >6 rounds to make say 80% of the cash difference. The last bit is always very slow, but the first but does come quicker.
Is someone able to help me with an Excel question.
I'm using bigbashboard to build a spreadsheet. (I don't know how to grab it all, so will work through a team a day). I've Googled and found many places for the info but not the specific formula I need.
Ive started to use the following (its about grabbing the correct points for the SR when runs are 20 or more, although I've used >19). I think I need the same part of the formula for the bowling SR as well... Here's the start.)
The example is: 23 (runs, which is "I2" ) + 25 (strikerate points of 191.67 which is is the cell "N2"), so answer should be 48, but I keep getting "23", or "28", depending on the removal of an "=" when it allows me.
=SUM((I2) +(IF(AND(I2>19,(IF(AND(N2>119.99,5, IF(N2>129.99,10,IF(N2>139.99,15,IF(N2>1499.99,20,IF(N2>159.99,25))))),0)))))
I want to do it all in one formula. Once I understand this, I can figure the rest, I'm just not sure if it's better to do it this way or add more columns which I know how to make it work.
Any thoughts?
I'm using bigbashboard to build a spreadsheet. (I don't know how to grab it all, so will work through a team a day). I've Googled and found many places for the info but not the specific formula I need.
Ive started to use the following (its about grabbing the correct points for the SR when runs are 20 or more, although I've used >19). I think I need the same part of the formula for the bowling SR as well... Here's the start.)
The example is: 23 (runs, which is "I2" ) + 25 (strikerate points of 191.67 which is is the cell "N2"), so answer should be 48, but I keep getting "23", or "28", depending on the removal of an "=" when it allows me.
=SUM((I2) +(IF(AND(I2>19,(IF(AND(N2>119.99,5, IF(N2>129.99,10,IF(N2>139.99,15,IF(N2>1499.99,20,IF(N2>159.99,25))))),0)))))
I want to do it all in one formula. Once I understand this, I can figure the rest, I'm just not sure if it's better to do it this way or add more columns which I know how to make it work.
Any thoughts?
Can't see the spreadsheet but I'd personally send @Beg2Differ a PM .... I might be wrong (doubt it) but he is currently and has been a previous "guru" at this sort of stuff ...
Last edited:
If that formula is a direct copy, I think it might be that the elements within a SUM formula are usually separated by a comma, which doesn’t appear to be included? I would consider eliminating the use of SUM altogether in this case, especially if it keeps causing you issues.
Also I think the nesting of the strike rate conditions (>119.99 etc) might be causing issues - I think it’s identifying that the first condition (>119.99) is being met, and therefore adding 5 for the SR bonus, rather than proceeding to test the more stringent SR conditions (129.99, 139.99 etc).
I think two options would be (1) to reverse the order of your SR tests so that they go from high to low, or (2) possibly tweak the formula more broadly so that a player gets 5 SR points if the SR is >119.99, a further 5 if it is also above 129.99, and so on. Option (2) is probably not as clean, but could potentially work.
If I were doing it, I’d reverse the order of those SR conditions first, and then see whether any further changes are required ... and if they are, assess whether anything else above would also be worth trying.
Also I think the nesting of the strike rate conditions (>119.99 etc) might be causing issues - I think it’s identifying that the first condition (>119.99) is being met, and therefore adding 5 for the SR bonus, rather than proceeding to test the more stringent SR conditions (129.99, 139.99 etc).
I think two options would be (1) to reverse the order of your SR tests so that they go from high to low, or (2) possibly tweak the formula more broadly so that a player gets 5 SR points if the SR is >119.99, a further 5 if it is also above 129.99, and so on. Option (2) is probably not as clean, but could potentially work.
If I were doing it, I’d reverse the order of those SR conditions first, and then see whether any further changes are required ... and if they are, assess whether anything else above would also be worth trying.
