Cricket Stats - Balls Bowled

**softz** · 07-06-2009, 02:04 AM

Hey guys, another question:

Im trying to put together a small cricket stat spreadsheet and hit another bump:

what i want to do is turn overs bowled into balls, so the forum needs to be something like this:

Example, one cell = 17.2 then in the Ball cell needs to equal 17 times 6 + 2

so the 17 needs to be times by 6 and then what ever the decimal point needs to be added to the sum of 17*6

I hope that made sense to everyone

**tigertiger** · 07-06-2009, 02:17 AM

Example, one cell = 17.2 then in the Ball cell needs to equal 17 times 6 + 2

assuming data is located at cell A1

=INT(A1)*6 + (A1-INT(A1))*10

**softz** · 07-06-2009, 02:33 AM

Awesome, thank you very Much

Theres so much i need to learn with spredsheet lol

**pike** · 07-06-2009, 03:03 AM

hi softz
another useful cricket formula form Kris is

=DOLLARFR(DOLLARDE(SUM(B4:B9),6),6)

it sums up the overs and decimal in groups of six's

**tigertiger** · 07-08-2009, 02:30 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

thanhks.

**daddylonglegs** · 07-08-2009, 04:50 PM

Using DOLLARDE to convert a single value like 17.2

=DOLLARDE(A1,6)*6

Note: DOLLARDE is an Analysis ToolPak function in versions of Excel before 2007. Without ATP here's another option.......

=A1*6+MOD(A1,1)*4

**pike** · 07-08-2009, 06:47 PM

Good start to the Ashes last night should be a good series

**softz** · 07-08-2009, 08:40 PM

Yip, a nice even start. Both seemed to be pretty even

Altho im a NZer so im sitting on the fence on who i want to win but as most NZer would probably do im slightly leaning to English side lol