Ok, folks. We now round to 3 decimal places when we store distance data. This should ensure that if you type “1.0” miles in for distance, it will actually be 1.0 miles in the database. This also means we round down, of course.
The only ride that was affected by this change was a 1.0 mile ride on Jan 12 by Rob O. (Presumably Mikey’s rides would also be correct now, if he were to change them back to “1.0” instead of “1.01”.)
@dasgeh, your ride yesterday was 1.02 miles and so your point total for yesterday was 11.02 points.
I will give some thought to how we can make the ride totals more transparent on the site so as to prevent confusion or second-guessing about how your rides are being counted (or not). Perhaps something as simple as adding a “points” column to the “People” table would help.
