Results 1 to 2 of 2

Thread: International Calling CSV and formula

  1. #1

    Default International Calling CSV and formula

    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

  2. #2
    Join Date
    Jul 2010
    Posts
    369

    Default Re: International Calling CSV and formula

    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.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •