What’s the spreadsheet formula to calculate the time in seconds taken by each to transfer a file 100MB in size

PCworld asked:

I want to calculate the following table:

Technology …. max speed ….Time(s) to transfer 100MB file

Zigbee ……………..250 Mbps

Wibree………………1 Mbps

Bluetooth…………..1 Mbps

Bluetooth 2………..3 Mbps

WiFi ‘b’ …………….11 Mbps

WiFi ‘g’……………..54 Mbps

WiMax……………..70 Mbps

Wireless USB…..480 Mbps

WiFi ‘n’…………….540 Mbps

Please help…..

Comments

One Response to “What’s the spreadsheet formula to calculate the time in seconds taken by each to transfer a file 100MB in size”

bob135 on July 6th, 2008 12:52 pm

in your spreadsheet, in column A, type all of the technologies. In column B, type all of the max speeds. In cell C1, type =100/B1 . That will give you the time in seconds. Copy and paste cell C1 all the way down to C9.