Talk:The Cost of Crafting

Comments
Contemplating merging all the market price lists into a single column set. This would have several convenient effects on development, but also certain usability concerns. Any input from anyone? &gt;Delve 17:04, 15 January 2011 (UTC)


 * Isn't that what the master price list is already? And after looking at the whole thing have one small concern.  If you have items listed as being in your inventory the crafted price goes down.  That might be misleading to some people if they can sell those items still  (ie. it would be cheapest to sell my two gold ores and buy a death crown instead of crafting it). --Fluffy 19:19, 15 January 2011 (UTC)


 * That's the point. It's not my intent to teach you how to make the best use of your resources, only to make it easier for you to do so. Look at the price of gold, see the crafting cost with ore in inventory (which is then deducted from the crafting cost) vs the cost of buying a death crown at market (which you should already have entered on the other tab, right?) and etc. Also, inventory is an entirely voluntary entry and there's a cautionary note in the guide regarding its effect on the calculations on the summary. I should think that would make people think before they use it at least, and I'm not interested in designing apps that remove the need to think. :) &gt;Delve 12:15, 16 January 2011 (UTC) As far as the single price list, right now the market price tab has things broken out into blocks by set. I'm thinking of putting it all in one long column. Which has usability implications but would make it much easier to maintain. I have to redefine a lot of the defined ranges when I need to move things around plus it makes me use more than one formula for the calculation tabs which means any time I have to change something (like when they removed the auction fee) I have a lot of manual adjustments to make instead of copy and pasting a formula across the whole table. &gt;Delve 12:15, 16 January 2011 (UTC)
 * Edit to add that the 'Master Price List' tab currently only has the items in the far left column on the Auction Price tab (which I still need to rename to 'Market Price' instead). If you look at the formulas on the respective sheets you can see this quite clearly if you're familiar with the query syntax. &gt;Delve 13:11, 16 January 2011 (UTC)


 * Given that response I wouldn't see any difference in usuability. Because of the length of the list I use the search/ find box for things I don't see immediately anyway.  Probably be easier on the eyes too.  I did not stare at your formula setup at all, do you want me to?   not signed in but: --Fluffy


 * I can keep up with them, I was only pointing out that you could look under the hood to see exactly what is used where. I'll give this a few more days for comment and then see how it works in practice. &gt;Delve 11:35, 21 January 2011 (UTC)

Thick Polar Bear Fur problem
Thick Polar Bear Fur lookup from (for instance) the Savage Leather Armor tab is wrong. It always shows up as 0 even when a number is entered in the auction prices tab.
 * I can't reproduce this on the current version of the spreadsheet. Please try it again and make a note if it's still a problem. Most of the functionality is handled by copy-pasted formula, so if there's a problem it's likely duplicated all over the place. &gt;Delve 17:15, 13 January 2011 (UTC)

ToDo List
put together an image of a completed form Delve 22:16, 22 November 2010 (UTC)
 * Done &gt;Delve 19:10, 26 November 2010 (UTC)

I'm working on a version that includes the auction markup. Just need to get the formulas copied where they need to be. >Delve 10:34, 25 November 2010 (UTC)
 * New version done, updating guide &gt;Delve 17:51, 26 November 2010 (UTC)
 * Done &gt;Delve 19:10, 26 November 2010 (UTC)

Rename 'Auction Prices' to 'Market Prices' and train myself to stop calling it an auction; old habits die hard. &gt;Delve 13:12, 16 January 2011 (UTC)

Add missing crafts from the wiki&gt;Delve 17:18, 13 January 2011 (UTC)

Look into creating a recursive 'grocery list' (probably not going to happen)&gt;Delve 17:18, 13 January 2011 (UTC)
 * Actually, in light of vindictusdb.com I'm going to close this ToDo permanently. Someone's done it already and in a prettier more useful fashion. If they could integrate reasonably accurate market prices into their database I might close the spreadsheet entirely! &gt;Delve 13:19, 16 January 2011 (UTC)

Spreadsheet Version History
1: Initial release &gt;Delve 22:15, 22 November 2010 (UTC)

2: Added marketplace markup and inventory calculations. Noticeably altered layout &gt;Delve 19:05, 26 November 2010 (UTC)

3: Added several sets and corrected some mistakes &gt;Delve 20:02, 3 December 2010 (UTC)

4: No major changes. Removed (mostly) the marketplace purchase markup because it's removed from the game. You'll still pay 1 gold more than the cost of the item, but I'm not going to bother accounting for that. I think I also added some boat 4 crafts, I haven't kept up with it very well. &gt;Delve

5: Added Blood Lord and Nightmare sets &gt;Delve 16:19, 22 January 2011 (UTC)

Version in development
Changed all instances of Auction to Market

Crafting Calculator Mk2
Developing a new spreadsheet using a completely different method. Hopefully this will save a lot of time and effort. While I work on it I probably won't make any updates or additions to the old version, but when I'm finished hopefully I won't need to worry about adding recipes later. &gt;Delve 19:37, 2 February 2011 (UTC)