PDA

View Full Version : Trading tool



_felagund
2012-12-20, 02:20 AM
hey guys,

Is there any tool (Excel file or something else) that makes trading easy. buy & sell really take time sometimes..

Slipperychicken
2012-12-20, 12:43 PM
If you know how to work Excel formulas, you can pretty easily make a spreadsheet of the items you intend to sell, and the gold values you'll receive from each. Have say, one column of item names, another column of monetary values (the values you will receive. The default rule in 3.5 is buy at full price, sell for half price) for each item, then have them all totaled into a cell at the bottom. Once the transaction is finalized, you subtract the gold values and add all the items to your inventory.

Then have an additional, similar column for items you intend to buy. It can help to mark items on your character sheet as "junk" or "intend to sell". I personally do it by adding a dash next to the item in question.


In general, modifying your inventory is a lot easier when it's on a spreadsheet program like Excel.

Diarmuid
2012-12-20, 02:03 PM
I've got an excel sheet where I do something like is shown below. The formatting is all off, but column 1 is item name, then value, then how many we have, and then the price (b*c/2). This assumed the simple "sell for half value".

Item Value Qty Sell Price
elven chain +2 8150 2 8150
Small steel shield +1 1159 2 1159
Dagger +1, Corrosive 8302 2 8302
Cloak of Resistance +1 1000 2 1000
Full Plate +3 10650 1 5325
Dire Flail +2/+2 16690 1 8345
Gauntlets of Str +2 4000 1 2000
Periapt of Wisdom +2 4000 1 2000
Darkwood Lyre 1400 1 700
Gold Chess Set 550 2 550
Gold hairbrush 120 2 120
Gems 96 2 96
Gold 543 2 543 Per Person
38290 9572.5

I havent seen anything with those values already done, and once you start getting into magical items with abilities and plusses it would be hard to have a comprehensive list.