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