I got the idea to make this from a video that was also posted here: http://www.ownedcore.com/forums/mmo/...um-profit.html
The way to use the spreadsheet is you plug in all the information for the raw materials to craft a certain item, plug in how much each item is selling for at market value, and it has the calculations set up to determine how much silver per labor you would profit from crafting and selling that item. Essentially it just makes it way easier to find the best ways to make money through craft&sell
After plugging in all the prices, the table automatically calculates your silver:labor profit for crafting and selling a larder for example, along with displaying the total cost of all the mats, how much you're profiting, how much the auction house is taxing you, how much you're getting before any AH fees (your income), etc etc.
This is just what I've used over the last few months so there's only a limited amount of items that I actually added. feel free to add whatever you want, this is very basic excel editing.
Instructions:
1. Plug in the data for the MATERIAL COST in the cost window
2. Plug in the information for the INCOME tab (This is how much the crafted item is being sold for at AH price)
3. Let the excel sheet calculate the most profitable item to sell
4. ?????
5. $$$$$
Important things to note:
***The format for entering the price of an item is [000000 = 00g 00s 00c], so if you wanted to input an item for 12g 30s 50c you would type 123050 in the cell.
***All of the husbandry crafts were adjusted to how much labor I was consuming at 43k husbandry (obviously less than someone with 10k husbandry), so you need to adjust the ROL cell equation specifically for those items
**LP stands for Labor points, and ROL stands for return on labor (This is how much silver you are getting per labor). 1000 x ROL is basically meant to decide if you would still have a positive profit if you used a labor pot and crafted 1000LP of said item.
*A few of the cells are either unfinished or have never been started. If you look at the way the other cells were made, you can easily finish them yourself or add new ones
>>DOWNLOAD<<
Screenshots: