Hello all,
First off, I hope I have posted this in the correct area.
I thought I would make my trade catalogue available to the community.
The game doesn't allow any way for the player to compare the trade prices of two settlements together, I found this quite annoying as it would take a good while to keep switching from one settlement's trade price sheet to another in order to find what item will bring in the most money.
My solution was to create this Excel document that doesn't just compare the two prices but calculates which items will bring in the most profit per unit and per cwt.
I find this file very useful as I like playing as a trader, I just hope that there are others who will find this file as useful as I do.
Download: Version 0.25 TradeCatalogue.xlsm (529KB)
Screenshots:
The main screen: http://screencast.com/t/ZCUvBtqrmzs
Settlement price screen: http://screencast.com/t/J3NpqNDCEaN
Main Menu: http://screencast.com/t/wF23j2ob
Instructions:
This file is created in Excel 2007 and is saved as a xlsm file. This is a macro enabled Excel workbook.
Every time you open this file you may be prompted by a security bar with an options button, please click this options button and select the "Enable This Content" radio button.
In order for the file to work you first need to fill in some data, unfortunately I am unaware of a way that the prices can be exported from the game so you will have to type them in to each settlements list.
First click the menu button and then select the settlement that you want to update, I have grouped them by the nation that owns them so that finding a settlement is a little easier.
Once in the individual settlement's catalogue just replace the zero's with the relevant price, the Buy column is for the cost of buying from the trader and the Sell column is for the money that the trader is offering you.
Please put zero's into the items that are contraband doing different will probably break the calculator.
The date cell is for you to enter the in game date when the price list was last updated, this is obviously useful so you know how old your current list is.
Once you have prices in at least two settlements you can go to the main screen and select the departure and arrival ports from the drop down lists.
the Profit per cwt and Profit per Unit columns will now fill up and you will presented with the Profits that can or cannot be made for each item.
I believe that covers the basic usage of the file.
All the item names and weights are linked to one sheet so that changing the order/names/weights of the items are not too difficult.
In order to alter this information please click the Goods button from the Menu.
The calculator does not yet support adding more items and removing items will just be done by leaving their prices on 0.
I may have missed some obvious information but this is the first time I have uploaded anything to anywhere so I apologise that I am new to this writing instructions business.
Additional but important information:
This file has not been tested very much beyond my normal use of it, if you find any bugs please let me know and I will try to sort them out.
Any other suggestions are also welcome.
This file is set up to fit the AOP:CoAS GOF1.1 mod with realistic weights and costs enabled, so all the items and weights are, as default, set to fit this set up, as mentioned in the instructions the names and weights of items can be changed by clicking the Goods button in the Main Menu.
I don't think I have missed anything out but if there is anything that you get stuck with please let me know and I will update these instructions accordingly.
I hope you enjoy this Trade catalogue and I hope it is as useful for you as it has been for me.
Thank you for reading and downloading
Liam1
First off, I hope I have posted this in the correct area.
I thought I would make my trade catalogue available to the community.
The game doesn't allow any way for the player to compare the trade prices of two settlements together, I found this quite annoying as it would take a good while to keep switching from one settlement's trade price sheet to another in order to find what item will bring in the most money.
My solution was to create this Excel document that doesn't just compare the two prices but calculates which items will bring in the most profit per unit and per cwt.
I find this file very useful as I like playing as a trader, I just hope that there are others who will find this file as useful as I do.
Download: Version 0.25 TradeCatalogue.xlsm (529KB)
Screenshots:
The main screen: http://screencast.com/t/ZCUvBtqrmzs
Settlement price screen: http://screencast.com/t/J3NpqNDCEaN
Main Menu: http://screencast.com/t/wF23j2ob
Instructions:
This file is created in Excel 2007 and is saved as a xlsm file. This is a macro enabled Excel workbook.
Every time you open this file you may be prompted by a security bar with an options button, please click this options button and select the "Enable This Content" radio button.
In order for the file to work you first need to fill in some data, unfortunately I am unaware of a way that the prices can be exported from the game so you will have to type them in to each settlements list.
First click the menu button and then select the settlement that you want to update, I have grouped them by the nation that owns them so that finding a settlement is a little easier.
Once in the individual settlement's catalogue just replace the zero's with the relevant price, the Buy column is for the cost of buying from the trader and the Sell column is for the money that the trader is offering you.
Please put zero's into the items that are contraband doing different will probably break the calculator.
The date cell is for you to enter the in game date when the price list was last updated, this is obviously useful so you know how old your current list is.
Once you have prices in at least two settlements you can go to the main screen and select the departure and arrival ports from the drop down lists.
the Profit per cwt and Profit per Unit columns will now fill up and you will presented with the Profits that can or cannot be made for each item.
I believe that covers the basic usage of the file.
All the item names and weights are linked to one sheet so that changing the order/names/weights of the items are not too difficult.
In order to alter this information please click the Goods button from the Menu.
The calculator does not yet support adding more items and removing items will just be done by leaving their prices on 0.
I may have missed some obvious information but this is the first time I have uploaded anything to anywhere so I apologise that I am new to this writing instructions business.
Additional but important information:
This file has not been tested very much beyond my normal use of it, if you find any bugs please let me know and I will try to sort them out.
Any other suggestions are also welcome.
This file is set up to fit the AOP:CoAS GOF1.1 mod with realistic weights and costs enabled, so all the items and weights are, as default, set to fit this set up, as mentioned in the instructions the names and weights of items can be changed by clicking the Goods button in the Main Menu.
I don't think I have missed anything out but if there is anything that you get stuck with please let me know and I will update these instructions accordingly.
I hope you enjoy this Trade catalogue and I hope it is as useful for you as it has been for me.
Thank you for reading and downloading
Liam1