Fully detailed Crafting Recipes (Basic Mats/Values/Itemstats) [Spreadsheet]

[k4mi]

This spreadsheet is for calculating items to their basic materials.
It sorts the item by professions recipes (blacksmith-, armorsmith- and alchemist-recipes) and shows their basic materials.


Download:
Excel: [url=https://www.dropbox.com/s/w1uk3enf11gy4aq/NICrafting_1.12.xlsx[/url]    Last edit: [time]1376483848[/time]
To open this file you need Microsoft Excel 2007 or higher.
If you are using any older version of Excel please try the 'Microsoft Office Compatibility Pack' and let me know if it works.


Usage:

Just use the drop down menu to search your item.
On Values-table you can choose your own values for the Basic Items.
The Mats-table is used for copying your whole materials from the Nordinvasion page.
On the main page are several options:
Calculate difference: Show the Basic Items / Professions Recipes you still need.
Your Material Value: Calculates the value of mats you pasted from the Nordinvasion page in the 'Mats'-table.
Clicking on a profession recipe: Shows you all the basic mats you need for the recipes and recipes from other profession you might need.
*note the spreadsheet wont calculate them twice, its just to help you crafting the profession recipes

Updates:
The only problem is keeping this up to date, because as far as i know excel has no automatic update function .
So you have to check this page for newer versions.

If you have any requests, suggestions or questions just feel free to ask.
I hope you enjoy it !

[Yabu]

This spreadsheet is probably the most practical and useful one I've tried this far! I love being lazy. :3 A warning to Chrome users: it doesn't calculate the mats if you copy it directly from chrome. Paste it in notepad first and then into the spreadsheet! It copies colour and shit, which the program can't handle.

[k4mi]

This spreadsheet is probably the most practical and useful one I've tried this far! I love being lazy. :3 A warning to Chrome users: it doesn't calculate the mats if you copy it directly from chrome. Paste it in notepad first and then into the spreadsheet! It copies colour and shit, which the program can't handle.

Thanks a lot should be fixed

[clickeverywhere]

Oh man, this thing looks awesome. I feel like I should sticky this. Definitely makes things a lot easier for crafters.

[k4mi]

Oh man, this thing looks awesome. I feel like I should sticky this. Definitely makes things a lot easier for crafters.

thanks a lot !

[Balaur]

http://miyo.iki.fi/NI/craftables.html

Works nicely in-game with Steam browser

[Jalau]

Amazing thing, can you add a Material adder so you can compare 2 Material list from 2 accounts?

[k4mi]

Amazing thing, can you add a Material adder so you can compare 2 Material list from 2 accounts?

You already can. Just paste the other list below, but i will add this in the next version for 4 chars. I think i will finish it this weekend.

[k4mi]

0.4.8 Version released now with a database so you dont have to copy paste anymore

[~CM~Dragz]

I love you for this. Even more than I did before  .