We have build a simple calculator using Excel that calculates the upload and download times for files over a satellite network ASE 9700.
A client from Ireland has reached us for the following job:
Need a simple calculator (using Excel, VBA, Online) that will calculate the upload and download times for files over a satellite network. I have the calculation in Excel, but need someone to create a well designed and simple to use calculator.
Input:
Output:
Parameters:
Example:
We have created a hidden sheet with styled table, where we gathered all the parameters required for calculation:
And here is how the final calculator was designed:
We have used data validation for Upload/ Download selection, while the user enters file size. Transfer time is calculated on the fly in the custom minutes / seconds format.