Commerce Profit Code - Data Help Requested

• Friggerton wrote on 2014-04-03 22:20
  I'd like to write a program in MATLAB that will calculate ducats/gold per minute for commerce going between towns, which will show which is the highest profit route as well as the destination that will yield the highest ducats per minute. I'm fairly certain I can do the coding, but I could use some help getting the following info:
  
  

  
  
  • Trip times from each town to each town (i.e. how long it takes to get from Tara to each other town) using the wagon, elephant, and alpaca wagon.
    
  • Trip times above but with an alpaca robe - I haven't seen a tested percentage for this.
    
  • The number of limited goods from Tara and Emain Macha you can buy with each mount (wagon, partner wagon, alpaca wagon, elephant, partner elephant) - my merchant rating isn't high enough in these towns as I rarely commerce there.
    

  
  
  Please provide an average of at least 10 runs for between each town, avoiding bandits as possible, and note the route you took.
  
  I'm not planning on coding for Belvast, because I personally never go there (with the multiple minute boat delay.) If people would like to provide data and want it included, I can do so.
  
  One question: is the 3% per level increase of transport speed from commerce reforges added to the mount itself, or still relating to the multiple of running speed listed on the wiki? I presume it's the former.
  
  If people contribute I'll make the code available on Nation once it's finished, and people can use it by downloading a free MATLAB clone like Freemat.
• Hatsunechan wrote on 2014-04-03 22:49
  https://docs.google.com/spreadsheet/ccc?key=0AsIybnqIOKoJdHBScFJKQjVOdV9rWXlwOGgwVGMxYnc#gid=0
• Aubog007 wrote on 2014-04-04 03:18
  ^
  
  
  It's extremely old, with no boosts whatsoever, but do the math.
• Friggerton wrote on 2014-04-04 05:20

  Quote from Aubog007;1212698:

  ^
  
  
  It's extremely old, with no boosts whatsoever, but do the math.

  
  
  Thanks. The second chart of profits and efficiencies talks about reforges, but the above chart is without any buffs?
• Zekkii wrote on 2014-04-04 09:23
  I haven't edited it with the intention of public use for some time. In my private files I have a fully working calculator that functions within the spreadsheet that is programmed with the times.
  
  

  [Image: http://i.imgur.com/O6ECmlN.png]

  
  
  The white area being the entry fields. Alpaca robe should be represented as a level 10 commerce reforge, and no you can not use both.
• Aubog007 wrote on 2014-04-04 10:59

  Quote from Friggerton;1212728:

  Thanks. The second chart of profits and efficiencies talks about reforges, but the above chart is without any buffs?

  
  
  
  Yes. I use it myself, until i memorized it and also memorized the ducat/minute per route.
• tachiorz wrote on 2014-04-04 15:25

  Quote from Zekkii;1212747:

  Alpaca robe should be represented as a level 10 commerce reforge, and no you can not use both.

  
  Wait, it won't stack with level 10 reforge? I bought alpaca just for robe, to get 10+10 level for my giant >_>
• Xeno wrote on 2014-04-04 16:20
  I was under the impression Tara->Location was always the highest ducat profit you could make.
• Aubog007 wrote on 2014-04-06 01:42

  Quote from Xeno;1212791:

  I was under the impression Tara->Location was always the highest ducat profit you could make.

  
  
  Tara sucks for ducat/time.
• Zekkii wrote on 2014-04-06 03:18

  Quote from Aubog007;1213051:

  Tara sucks for ducat/time.

  
  That depends on your server really, it's pretty decent in Alexina.
• Aubog007 wrote on 2014-04-06 09:05

  Quote from Zekkii;1213071:

  That depends on your server really, it's pretty decent in Alexina.

  
  
  I just know that dun to emain has to be 1/4 or less to be worsethan dun to tara, which is rare.
  
  
  The only reason i use Tara is because of letters of guarantee. If it wasn't for those letters. I wouldnt touch tara. Hell, it was my last level 9.
  Sure, Tara to bangor is nice, but dun to bangor can be done more efficiently, emain to bangor is a hidden gold mine.
  
  Hell emain is a hidden goldmine (tarlach example)
  The key to commercing is spiraling out from dun. And using tara when the prices are low everywhere else. (Pre letter of guarantee)