PDA

View Full Version : International Calling CSV and formula



genxweb
12-27-2010, 01:34 PM
I been getting a lot of clients asking for international calling rates. So I found a URL on here that allows you to download a CSV of the current rates. I then modified it:

Country, Digit, voipo rate, 9%, My Markup, client rate, Rounded, Final Rate

This is a automated spread sheet driven by formulas so changing a value will update that row. This allowed me to quickly create my own rates and give them to my clients.

Many of you may have done this already but I figure I would share for those that haven't

It can be downloaded here http://voipmyway.com/voipmyway_int.zip

GreenLantern
12-27-2010, 08:11 PM
GenX, thanks for sharing. Good work.

Some additional steps that you might want to employ. Use a single cell for each markup value, in this case 0.09 and 0.02. Then have the other cells point to the master values. That way you can change the master cell and your whole spreadsheet will change.

And if you want to go one step further, you can then "hide" your calculation columns and use the resulting sheet to create a printable list of rates, or export for use in a database.