CSV download and upload numbers don't match on-screen
2 posts · Closed
Hi, I saved my Speed Meter results to an Excel spreadsheet using CSV. Date and Ping look fine, but the download and upload numbers don't seem to tally with the numbers shown on-screen.
For example: at 9:50am today download was 106 and upload was 13.6 (in Mbit/s). When I save to file, these numbers are shown as 13258991 and 1703936 respectively. If I divide these numbers by 128, I get near to the on-screen numbers, i.e. 103.58 and 13.31. Please advise on how I should convert the CSV numbers to correlate with the on-screen numbers.
The numbers are exported in bytes per second, regardless of the display settings that can be configured to show either bits per second or bytes per second.
The conversion is pretty easy. As 1 byte contains 8 bits and M means 1 million, to match the displayed numbers you need to multiply by 8 and divide by 1000000, i. e.:
13258991 * 8 / 1000000 = 106.07 1703936 * 8 / 1000000 = 13.63