View Full Version : Crafting spreadsheet

01-31-2017, 09:40 AM
I got bored and frustrated, so I made this.
Its not great, but helps to figure out what materials you have/need.

If you have any suggestions for improving it, please let me know!
You can make changes yourself, but then, please upload your changes for others.


EDIT: Tried to change the preview pic to a larger pic, but I guess the forum is downsizing sizing it?
It's 400+ kb on my computer, but 19 kb when I upload it? You'll have to download the ZIP file
then open it. I made it in Excel 2013.

Laura TCK
01-31-2017, 11:43 AM
I clicked on thumbnail pic but it's to small, Safari won't open zip apart from that all looks good and will help anyone that have not seen a crafting chart before

02-01-2017, 01:43 PM
Nice sheet!

If you add a possibility to enter which materials you have crafted and what you still need for your target

02-02-2017, 01:04 AM
That's brilliant! Thanks for creating it. Will give it a go today

02-02-2017, 08:14 AM

On the Materials Page:

Column(C): Enter the number of materials you have

Column(E): The item you wish to craft
Column(F): The maximum number of items that can be crafted with the materials you have
Column(G): Yes / No you can craft the item
Column(H): The number of materials you have to craft that item
Column(I): The number of materials you need to craft that item

Hero Equipment:

Under Columns M thru R, enter your equipment Attack and Defense values
- This will highlight the items values with Red / Green to indicate if the items are worse / better then current items

On all other pages:

Column(B): The Item you wish to craft
Column(D): The Attack and Defense values for the item
Column(E): The number of items that can be crafted
Column(F): Yes / No the item can be crafted
Column(G): The number of materials you have to craft the item
Column(H): The number of materials you need to craft the item

02-02-2017, 01:03 PM
You did the thing I was planning to do for a long time. Thank you, thank you, thank you!

02-03-2017, 06:44 AM
I've finally finished crafting all I can with the materials on hand.
Took my attack from 5699 to 7460 and defense from 4343 to 5321

I was hitting for around 5200 before, now its around 7500.
Still kinda weak, but its better now.

Where the hell can you get the other items? Like the mandrake root, or the motes?


Laura TCK
02-03-2017, 11:30 AM
Motes are rare items from the rare boxes 16/20 heroic 20/30 on box events or buy them in store for gems but that's a lucky shot to get what you need, mandrake roots and sage mertyle are excotic crates 15/15 normal LTQ and haste and 10/20 heroic I think