When a result has more than 2 digits after the decimal point, it is often hidden by the cell formatting in Excel and in the application. This can however lead to wrong results and wrong averages because it can lead to values being rounded up instead of being rounded down.
Examples:
2nd place of 4x4x4 first round results for Hamburg_Open_2011_Results_Final.xls
The 4th time here is 47.555 seconds but it shows up as 47.55 seconds. This means that the average is exactly 45.245 seconds, but due to rounding errors some applications may make this into 45.24 seconds and other applications may make this into 45.25 seconds.
When a result has more than 2 digits after the decimal point, it is often hidden by the cell formatting in Excel and in the application. This can however lead to wrong results and wrong averages because it can lead to values being rounded up instead of being rounded down.
Examples:
2nd place of 4x4x4 first round results for Hamburg_Open_2011_Results_Final.xls The 4th time here is 47.555 seconds but it shows up as 47.55 seconds. This means that the average is exactly 45.245 seconds, but due to rounding errors some applications may make this into 45.24 seconds and other applications may make this into 45.25 seconds.
See also issue #18.