Discussion BBL|10 SC: Team & In-Game Discussion - Home of #1 and #2 Leagues

[Herbie66]

Daniel Hughes is a nice price

he , Bryant , Turner & Wildermuth all look viable bench starting picks

 

[Herbie66]

So if Tahir is available to play Dec 26 that means Noor Ahmad only plays 3 games , is he worth even starting on the bench for that limited time.

Not sure he would make any meaningful dollars.

 

[Woosie]

So if Tahir is available to play Dec 26 that means Noor Ahmad only plays 3 games , is he worth even starting on the bench for that limited time.

Not sure he would make any meaningful dollars.

👍 Good info. 🤔 How much would he go up if he made 40 a game?

 

[Herbie66]

👍 Good info. 🤔 How much would he go up if he made 40 a game?

I have absolutely no idea.

@Tails is the guru when it comes to price projections for players.

 

[Woosie]

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 ...

Excellent. Nice to be able to put my Excel skills to good use from time to time

After all that, I got to the dot balls.. and nothing, bigbashboard.com doesn't have the dot balls for the bowlers..
Oh well, I know how to work the formula now 😃

 

[Herbie66]

So by my records if DC goes at an average of 50:
- First two games he will priced at ~111k
- If he holds that for another game it will be ~114k

So by my records if Khawaja goes at an average of 50:
- First two games he will priced at ~119k
- If he holds that for another game it will be ~122k

Quite a few other variables will come into play but those are my estimates give or take $500 for rounding purposes ...

That's excellent to know that.

Hopefully allows a easy Cartwright trade to a Lynn/Khawaja/Christian/Behrendorff type etc in Round 3 if they look like I need them.

 

[Woosie]

Sydney Sixers

Abbott - Test Squad
Bird - Australia A
Brathwaite
Curran - probably in South Africa
Dwarshuis
Starc - Test Squad

2 spinners out of Manenti/Pope/SOK until Lyon is available

might be harder than the Rubik's cube trying to figure their XI out eventually

Hughes , Phillippe , Vince , Henriques , Silk , DC

Will Henriques bowl? Or should I just not go there?

 

[Herbie66]

Will Henriques bowl? Or should I just not go there?

They normally have 6 options without him , but given their absences he may well have a over somewhere along the line.

Think he misses the first 2 Rounds , not part of my plans so haven't fully checked the Sixers schedule.

 

[Woosie]

They normally have 6 options without him , but given their absences he may well have a over somewhere along the line.

Think he misses the first 2 Rounds , not part of my plans so haven't fully checked the Sixers schedule.

I guess I'm looking for alternatives for DC

 

[Herbie66]

I guess I'm looking for alternatives for DC

Lynn , Khawaja , Cartwright , Hinchliffe , Handscomb , McDermott etc etc

 

[Beg2Differ]

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?

Looks like you may have solved it however there are actually a number of ways you could do this.

The original formula has the following problems.

• You don't need it enclosed in a SUM formula when you have the plus sign between the 2 components however it will still work.
• The AND component is being used incorrectly.
• In a nested IF as you have done you need to reverse the order otherwise it meets the first test, returns 5 and evaluated no further for the higher strike rates.
• Theoretically you should also change it to N2>=120 rather than N2>119.99 because there are values between 119.99 and 120 where you don't want the bonus applied however given the numbers that will be relevant here that shouldn't be a problem.

Using a nested if I would recommend the following.

=I2+IF(I2<20,0,IF(N2>=160,25,IF(N2>=150,20,IF(N2>=140,15,IF(N2>=130,10,IF(N2>=120,5,0))))))

However the tidiest way is probably with a VLOOKUP as follows.

 

[Darkie]

I guess I'm looking for alternatives for DC

My overall “value” picks were Christian, NCN, Khawaja, Ahmad, Tye, Behrendorff, A Agar, Green, Stanlake and possibly Wildermuth and Pucovski.

 

[Herbie66]

Had a tweak today , even had DC at one stage 😀

Gotch or Nielsen / McDermott

Short (VC) , Stoinis (C) , Maxwell , Hughes , Bryant / Turner , Wildermuth

Meredith , Zampa , Faulkner , NCN , Stanlake / Renshaw , Ahmad

Bank $ 27,000.00
5-6 Stars , 4 Hurricanes , 1-2 Strikers

think Hughes , Bryant , Turner all represent enough value to start and could be 30 - 40 ppg players

Round 2 targets will be Khan , Siddle , Wells

Round 3 Carey + 2

 

[Falcon$loth]

Had a tweak today , even had DC at one stage 😀

Gotch or Nielsen / McDermott

Short (VC) , Stoinis (C) , Maxwell , Hughes , Bryant / Turner , Wildermuth

Meredith , Zampa , Faulkner , NCN , Stanlake / Renshaw , Ahmad

Bank $ 27,000.00
5-6 Stars , 4 Hurricanes , 1-2 Strikers

think Hughes , Bryant , Turner all represent enough value to start and could be 30 - 40 ppg players

Round 2 targets will be Khan , Siddle , Wells

Round 3 Carey + 2

You should swap wildermuth and renshaw around so you can loop between Bryant and turner

 

[Herbie66]

You should swap wildermuth and renshaw around so you can loop between Bryant and turner

I was probably going to loop Hughes but that's another option

 

[Herbie66]

Briggs $ 138,000.00 Bowl

Brathwaite $ 160,000.00 Bat/Bowl although they have spelt his name wrong

 

[Woosie]

Looks like you may have solved it however there are actually a number of ways you could do this.

The original formula has the following problems.

• You don't need it enclosed in a SUM formula when you have the plus sign between the 2 components however it will still work.
• The AND component is being used incorrectly.
• In a nested IF as you have done you need to reverse the order otherwise it meets the first test, returns 5 and evaluated no further for the higher strike rates.
• Theoretically you should also change it to N2>=120 rather than N2>119.99 because there are values between 119.99 and 120 where you don't want the bonus applied however given the numbers that will be relevant here that shouldn't be a problem.

Using a nested if I would recommend the following.

=I2+IF(I2<20,0,IF(N2>=160,25,IF(N2>=150,20,IF(N2>=140,15,IF(N2>=130,10,IF(N2>=120,5,0))))))

However the tidiest way is probably with a VLOOKUP as follows.

View attachment 22825

The VLOOKUP looks the simplest way. Thanks for the feedback.
As you may have read already the site I was going to use doesn't have dot balls in the overall data, and I can't find another site. Any suggestions? I've got a few weeks 😃

 

[Darkie]

The VLOOKUP looks the simplest way. Thanks for the feedback.
As you may have read already the site I was going to use doesn't have dot balls in the overall data, and I can't find another site. Any suggestions? I've got a few weeks 😃

I think the dot balls are probably an underestimated source of points. I can’t recall the exact numbers, but I think those with the highest dot ball % bowl about 40% dot balls, while 30% is more typical. If you wanted you could potentially assume a number (or even a number varying with ER) and proceed from there.

If you get the average dot ball % in the ball park it will probably be good enough in the circumstances. Even if you’re off by 10% in a given game, if a bowler bowls c. 20 balls, you’ll only be off by 2 SC.

 

[Ironhawk]

The VLOOKUP looks the simplest way. Thanks for the feedback.
As you may have read already the site I was going to use doesn't have dot balls in the overall data, and I can't find another site. Any suggestions? I've got a few weeks 😃

While you have SC Plus (I think everyone has access right now), you can view any players stats from previous years on the site. Look up the player, change the drop down to whichever year you want then click on the stats breakdown.

 

[Ben's Beasts]

https://twitter.com/i/web/status/1328095472045617154