Battrick Popping Predictor

[Gilly Fan]

This is a predictor for when your players will pop.
Note, there are 18 weeks in a season, we have 12 weeks left.


http://www.zshare.net/download/2351226eccec2c/


Here is how a couple of players of mine will look at the end of the season.

Now -

Billy Myall (1072134)


LH Batsman, LH Spin Bowler, superb batting form, strong bowling form, invigorated
A steady player with superb leadership skills and abysmal experience.

Plays For: Gillys Demolition Team
Nationality: Australia
Age: 18 Years Old
Battrick Rating: 7,552
Wages: £636 p/w
Stamina: competent Wicket Keeping: worthless
Batting: respectable Concentration: competent
Bowling: worthless Consistency: abysmal
Fielding: woeful

End of the season -

Billy Myall (1072134)


LH Batsman, LH Spin Bowler, superb batting form, strong bowling form, invigorated
A steady player with superb leadership skills and abysmal experience.

Plays For: Gillys Demolition Team
Nationality: Australia
Age: 19 Years Old
Battrick Rating: ???
Wages: ??? p/w
Stamina: Proficient Wicket Keeping: worthless
Batting: Proficient Concentration: Respectable
Bowling: worthless Consistency: abysmal
Fielding: Feeble

And when he turns 20.

Billy Myall (1072134)


LH Batsman, LH Spin Bowler, superb batting form, strong bowling form, invigorated
A steady player with superb leadership skills and abysmal experience.

Plays For: Gillys Demolition Team
Nationality: Australia
Age: 20 Years Old
Battrick Rating: ???
Wages: £??? p/w
Stamina: Surperb Wicket Keeping: worthless
Batting: Surperb Concentration: Surperb
Bowling: worthless Consistency: abysmal
Fielding: Respectable

And for Lee Lisbie. Another of my young guns.

Now -

Lee Lisbie (1064035)


LH Batsman, LFM Bowler, feeble batting form, respectable bowling form, invigorated
A steady player with respectable leadership skills and abysmal experience.

Plays For: Gillys Demolition Team
Nationality: New Zealand
Age: 18 Years Old
Battrick Rating: ????
Wages: £??? p/w
Stamina: mediocre Wicket Keeping: worthless
Batting: worthless Concentration: mediocre
Bowling: respectable Consistency: competent
Fielding: mediocre

At the end of the season -

Lee Lisbie (1064035)


LH Batsman, LFM Bowler, feeble batting form, respectable bowling form, invigorated
A steady player with respectable leadership skills and abysmal experience.

Plays For: Gillys Demolition Team
Nationality: New Zealand
Age: 18 Years Old
Battrick Rating: ????
Wages: £??? p/w
Stamina: Respectable Wicket Keeping: worthless
Batting: worthless Concentration: mediocre
Bowling: Proficient Consistency: Proficient
Fielding: Competent

When he turns 20 -

Lee Lisbie (1064035)


LH Batsman, LFM Bowler, feeble batting form, respectable bowling form, invigorated
A steady player with respectable leadership skills and abysmal experience.

Plays For: Gillys Demolition Team
Nationality: New Zealand
Age: 18 Years Old
Battrick Rating: ????
Wages: £??? p/w
Stamina: Superb Wicket Keeping: Feeble
Batting: Wortheless Concentration: Respectable
Bowling: Superb Consistency: Remarkable
Fielding: Strong

These are the nets I am currently using.

Myall - 2 batting, 1 stanima, 1 fielding
Lisbie - 2 bowling, 1 stanima, 1 fielding, 1 keeping

Note: These are not exact because it is not at the start of the season. These are just rough estimates!

 

[handsome]

Hmmm great work.

 

[The Spin]

Heres what it comes up with for Marsden at the end of the season:

Pete Marsden, 19yo
Stamina: Superb Wicket Keeping: Abysmal
Batting: Remarkable Concentration: Strong
Bowling: Worthless Consistency: Woeful
Fielding: Proficient

 

[covlad-99]

great find

wow. this really is superb. fantastic job mate.

 

[handsome]

How to use it?

 

[Gilly Fan]

There are instructions on it. And down the bottom there are 3 tabs. Do your magic in the 2nd tab.

 

[aussie1st]

Pretty cool estimate, won't need to manually figure it now.

 

[handsome]

How to open it, Which program u need to open it?

 

[aussie1st]

Microsoft Excel

 

[Brett_Lee]

Hanson: Pro/Sup/Remark (currently 18 - batsman)
Shaka: Com/Sup/SUp (Currently 18 - Bowler)
Holland: Str/Str/Str (Currently 17 - Bowler)

Thats what my players will turn out at the end of the season.

Am pretty happy with that

 

[voldemort]

This aint fair... We all used to manually calculate and figure otu and you have tools to do that in a a few seconds : we used to pour over many pages and calculate...

 

[Gilly Fan]

The bad thing about this is that it doesn't say how long they have been whatever level they are. Whether it is late, early, middle. You don't know.

 

[ZoraxDoom]

This aint fair... We all used to manually calculate and figure otu and you have tools to do that in a a few seconds : we used to pour over many pages and calculate...

Amen! Newbies have it too easy...
I have gotten to the point where I can predict what a player will end up with what nets in a matter of seconds. It is one of the joys of the game!

 

[handsome]

Amen! Newbies have it too easy...
I have gotten to the point where I can predict what a player will end up with what nets in a matter of seconds. It is one of the joys of the game!

Perhaps you would like to share some of those experiences with us or maybe in MSN with u r best buddy me

 

[zainawan89]

Zorax and naufal is right.
But training times is my speciality. and as for as i know training data in this sheet is not right. Pop times for second net r wrong. they r lower than that.
for 18yo it is 8.2 not 8.6
but its just me i will talk to the guy who made that helpfile these times r taken from thr.

and if u want to see the sublevels. just change the formula remove ROUNDDOWN from cells predicting the level u will get sub levels too.
and careful if u entered weeks cross age update (season start) u wouldn't get right pops.