Shroud of the Avatar Currency Converter

Discussion in 'Player Created Resources' started by Warrior B'Patrick, Feb 20, 2018.

Tags:
Thread Status:
Not open for further replies.
  1. Warrior B'Patrick

    Warrior B'Patrick Avatar

    Messages:
    1,221
    Likes Received:
    2,402
    Trophy Points:
    113
    Gender:
    Male
    Location:
    Athens, Georgia, USA
    I did this for fun and to see it if might be worthwhile. I know anyone who trades a lot will be able to convert in their head but new users may not. Please give me feed back on this and if there is anyway to make it better I will be happy to update it. I know I need a better way to calculate COTO values. Any suggestions please reply.

    The formulas at the top are meant to be edited to remain current. Please edit the text under the cell so all can see how the number was reached. The formulas in the red boxes are locked.

    Here is the link and an image of what it looks like.

    https://docs.google.com/spreadsheet...sAKPfqGWRIA0cjoUsMX8VhWMs/edit#gid=1474911769

    [​IMG]

    I have edited this to remove the Store Credit info.
     
    Last edited: Mar 17, 2019
    Warrior B'Patrick, Feb 20, 2018
    #1
    Sentinel2, Fionwyn Wyldemane, Cordelayne and 6 others like this.
  2. Kabalyero Kidd

    Kabalyero Kidd Avatar

    Messages:
    2,054
    Likes Received:
    5,437
    Trophy Points:
    165
    Location:
    Beran's Reach, Beregost and Whyte Roc
    I'm getting this error page...

    [​IMG]
     
    Kabalyero Kidd, Feb 20, 2018
    #2
    Fionwyn Wyldemane likes this.
  3. Warrior B'Patrick

    Warrior B'Patrick Avatar

    Messages:
    1,221
    Likes Received:
    2,402
    Trophy Points:
    113
    Gender:
    Male
    Location:
    Athens, Georgia, USA
    Warrior B'Patrick, Feb 20, 2018
    #3
    Fionwyn Wyldemane and Kabalyero Kidd like this.
  4. majoria70

    majoria70 Avatar

    Messages:
    10,348
    Likes Received:
    24,870
    Trophy Points:
    153
    Gender:
    Female
    Location:
    United States
    I really like it a lot @Warrior B'Patrick. I can see it being very useful to get a perspective and comparison. :)
     
    majoria70, Feb 20, 2018
    #4
    Fionwyn Wyldemane likes this.
  5. Kabalyero Kidd

    Kabalyero Kidd Avatar

    Messages:
    2,054
    Likes Received:
    5,437
    Trophy Points:
    165
    Location:
    Beran's Reach, Beregost and Whyte Roc
    Kabalyero Kidd, Feb 20, 2018
    #5
    Fionwyn Wyldemane likes this.
  6. Weins201

    Weins201 Avatar

    Messages:
    7,121
    Likes Received:
    10,958
    Trophy Points:
    153
    All I am going to say is players shop around these numbers are easily found much cheaper.

    nice tool but not set in stone.
     
    Weins201, Feb 20, 2018
    #6
  7. Spoon

    Spoon Avatar

    Messages:
    8,403
    Likes Received:
    23,554
    Trophy Points:
    165
    Gender:
    Male
    Location:
    Sweden
     
    Spoon, Feb 20, 2018
    #7
    Fionwyn Wyldemane likes this.
  8. Warrior B'Patrick

    Warrior B'Patrick Avatar

    Messages:
    1,221
    Likes Received:
    2,402
    Trophy Points:
    113
    Gender:
    Male
    Location:
    Athens, Georgia, USA
    Greetings all, I have edited the Currency converter to remove the Store Credit info. Please feel free to edit the formulas for IGG and COTOs to be current and as always let me know if there is anything I can add/change to make it better.
     
    Warrior B'Patrick, May 19, 2018
    #8
    Fionwyn Wyldemane likes this.
  9. Warrior B'Patrick

    Warrior B'Patrick Avatar

    Messages:
    1,221
    Likes Received:
    2,402
    Trophy Points:
    113
    Gender:
    Male
    Location:
    Athens, Georgia, USA
    Greetings all. I have edited the SOTA Currency Converter To show correct number of COTOs per $1 USD from the forum examples as of 3/17/19. If prices have changes in the forums please feel free to edit the formulas and change the text under the formula to match.
     
    Last edited: Mar 17, 2019
    Warrior B'Patrick, Mar 17, 2019
    #9
    Kabalyero Kidd and Fionwyn Wyldemane like this.
  10. Vladamir Begemot

    Vladamir Begemot Avatar

    Messages:
    6,194
    Likes Received:
    12,076
    Trophy Points:
    153
    Gender:
    Male
    I don't keep up on the prices very well, but the gold to dollars seems wrong by a zero. Isn't it $70 per million, not $700?
     
    Vladamir Begemot, Mar 17, 2019
    #10
    Fionwyn Wyldemane likes this.
  11. Warrior B'Patrick

    Warrior B'Patrick Avatar

    Messages:
    1,221
    Likes Received:
    2,402
    Trophy Points:
    113
    Gender:
    Male
    Location:
    Athens, Georgia, USA
    Greetings Vladamir Begemot. Yes I did drop a zero while editing it. Thanks for the catch.
     
    Warrior B'Patrick, Mar 17, 2019
    #11
    Fionwyn Wyldemane, Jaesun and Vladamir Begemot like this.
Thread Status:
Not open for further replies.