Ok, it's still one giant stupid list but it's good enough that I'm ok releasing it.
Here is the linkUsing it is fairly easy. For looking up info you just find the item you want. The first set of columns give you the base price (0 ego mod), the Weight, and the Price Per Pound (PPP). PPP is the best way to figure out how useful an item is for trade.
For example, even though bronze daggers sell for only 1.75 and bronze long swords sell for 5.25 the dagger is actually better. It's 1.75 per pound while the sword is only 1.05.
Because of this Willowy and Slender items are worth quite a bit more in trade then the normal 10% markup that gets applied to items per mod. Not in end value, but in sell value vs weight in your inventory.
To add an item, you need to add a row at the bottom. If your Ego modifier isn't 0 you'll need to calculate the base price. There is an item calculator tab that is used for this. Just plug your info into the line there to get the base price. Then you add the item name, it's base price, and the weight to the spreadsheet. To get the other columns to fill in you just copy the cells from a fully filled in line and paste them in.
If your item has 0 weight (or negative, I suppose) put 0.1 in for the weight. That keeps the calculations from breaking and gives us a decent idea of the relative usfullness of the item. 0 weight items are awesome for holding value, since they don't hurt your inventory any.
To get everything back in alphabetical order, just highlight the sheet and go to
Tools->Sort Sheet by Column A. That'll sort things out.
If you want to mess with the spreadsheet (say, order everything by the PPP to see the best trade items) please make a copy for yourself and play with it there. I don't want this one to get all messed up.