[File] Commerce profit calculator
Posted: Tue Jan 17, 2012 5:14 pm
A calculator that helps you to calculate the maximum profit at a particular trade post through comparing the goods the trade post provides.
Controls (Located at the right side):
Transportation: Selecting the various transportation will automatically update the quantity you can carry by that method, selectable through drop down list.
Contracts: Allow you to choose contract if you used it to calculate the exp gain.
Targeted Item: The item you wish to trade, selectable through drop down list.
Current Profit: The profit displayed in game.
Display (Located at the left):
Best Transport: The best transportation to carry the particular item.
Required Gain: The profit needed for that item to match the item you wish to carry.
Ducat Gain: The total ducat profit you will be making with the deal (With Contract Accounted if Contract Used).
Exp Gain: The total exp you will be gaining from doing the trade (With Contract Accounted if Contract Used).
Usage:
1. Select the Transportation for your trade; Foot, Back Pack, Horse, or Pack Elephant, this will update the max quantities of the different items can be carried by the best transportation methods for comparison. (i.e. If you choose elephant but the horse carries more for certain item, the best transport will remain as horse and vice versa.)
2. Select the Target Item that you wish to trade categorized by the different trade posts. (e.g. Lovely Potion from Tir Chonaill.)
3. Input the profit gain displayed in game into the Current Profit Cell. (e.g. 78 in the screenshot.)
4. Look at the Tir Chonaill Item List in the display, check to see if the other item have value equal to or greater than the value listed in the Req. Gain Cell, if it doesn't you have the best profit route.(e.g. In the picture, in order for other Tir Chonaill Goods to have a deal better than Lovely Potion at 78 profit gain, there needs to be a deal in game that give 69 profit gain for Baby Potion, 56 profit gain for Diet Potion, etc...).
Download
Note: As with all spreadsheet-based calculators posted here, this can be uploaded to and opened with Google Docs. You don't need to have MS Office Excel.