Unfortunately, Microsoft Excel cannot handle this hybrid system of base 10 and base 6 mathematics that is the specialty of arithmetic of Cricket overs. To convert balls into overs in Excel use following formula:
=TRUNC(J17/6,0)+MOD(J17,6)/10
J17 is the address of cell containing balls. Following illustrates an example of this formula in action:
In above example, each yellow highlighted cell contains aforementioned formula. Turquoise highlighted cell contains formula explained here. Runs were added using a formula detailed here.
Posts
6 comments:
Hello,
This is great. However what is the formula to find out the balance overs left. So suppose bowled is 44.4 balance should be 5.2
What is the calculation for that?
Great it's working
@Huzan, if you know the total number of balls bowled and the total number of balls in the game, you could use the same formula mentioned in this post to calculate the remaining overs from the remaining number of balls. :)
U r great
Using same formula u should convert total balls into over formula.. In the left balls u should subtract the balls diliverd with total.. Balance balls should again convert into over formula. It will display your left overs..
331
Post a Comment