[Public] Crafting recipe sheets

[CytheS 102]

Crafting Recipes: Link
Resource Combinations: Link
Specialty Seal (temporary): Link

The sheet above is designed to list all recipes and making it easier to be read, especially the combinations.
This sheet will be fully for public use, so any help in keeping the sheet updated would be helpful. Whether it's new change in existing recipes or mistake in the sheet.

Note: The current sheets are not guaranteed to be 100% accurate as any changes might occur in future patch.
Lastly thanks to TerrorRage,Bariakarl, and others for their contribution to the sheet.

Edited October 30, 2017 by CytheS

[CytheS 102]

-

Edited June 9, 2017 by CytheS

[Tinnis 7,851]

Nice work (we never bothered doing the 'total X required' info on the Caldera sheet ;p)

My suggestion with regarding public updating would be whip up a simple google form for people to submit information to, for you to then vet and add, but that is down to you

[CytheS 102]

8 hours ago, Tinnis said:

Nice work (we never bothered doing the 'total X required' info on the Caldera sheet ;p)

My suggestion with regarding public updating would be whip up a simple google form for people to submit information to, for you to then vet and add, but that is down to you

Thanks, and that's indeed an option. Though I would like make it editable by anyone if possible.
It makes my workload easier, and since it's will be entirely open to public.

Note :  there's dropdown box that show which recipe can have more than 1 combination result as well.
But this box can't be shown to people without edit permission

Edited May 23, 2017 by CytheS

[Scumlord 18]

You're a god! This is awesome. Gonna use this during my stream

[Jimbolini 281]

Great Job

[CytheS 102]

If anyone want to help, you may message me or request for edit permission.
Posting in here will do it as well. (email address will be needed for edit request)
 

Edited June 9, 2017 by CytheS

[CytheS 102]

After consideration, the sheet is decided to be open for editing by anyone.
Copying the sheet without permission is not preferred, so please ask a permission beforehand.
Any editing done accidentally need to be undo.

Additionally, a form is added for those that don't know how to edit and want to contribute
https://goo.gl/forms/pZivK22mfX7z99503

[CytheS 102]

-

[CytheS 102]

Update : Changed 'Total Resource' column to 'Craft Amount' column.
Building components will be tested this weekend as much as possible, and recipes that uses rare resources as well. 
(Heartwood, Soulgem, etc)

[CytheS 102]

Data on specialty seal is incorrect, the stats change depending on the crafted item.
More testing to find the stats on each item will be needed

Example : Skinning seal effect on Boar Leather and Cat Leather is different.

[TerrorRage 10]

You may find this helpful. I created this google sheet to help design weapons and armor for specific attributes.  It has almost all the crafting seals available, when I last updated it. It's still a work in progress, I have not been able to update it in some time due to work.  If you copy the document to your own drive all the pull down menus should work.

 

Here is the Link.

[CytheS 102]

2 hours ago, TerrorRage said:

You may find this helpful. I created this google sheet to help design weapons and armor for specific attributes.  It has almost all the crafting seals available, when I last updated it. It's still a work in progress, I have not been able to update it in some time due to work.  If you copy the document to your own drive all the pull down menus should work.

 

Here is the Link.

Thanks, it will be helpful.
Only need to include the data somewhere.

[BarriaKarl 1,091]

Your crafting recipes spreadsheet is the best out there, really useful.

Your resource combinations spreadsheets needs some love though. Actually i think all spreadsheets around are ignoring the stats granted by the recipes. Anyway, i found a spreadsheet that has some new info (though incomplete):

https://docs.google.com/spreadsheets/d/1-zi2lfdVAmh3iWrdSkG3cqXkpfZM70sQZYmwQcw9_HE/pubhtml#

Check the Necromancy Additives and Philosopher's stone Tabs. This is the only spreadsheet i found with that info.

[CytheS 102]

1 hour ago, BarriaKarl said:

Your crafting recipes spreadsheet is the best out there, really useful.

Your resource combinations spreadsheets needs some love though. Actually i think all spreadsheets around are ignoring the stats granted by the recipes. Anyway, i found a spreadsheet that has some new info (though incomplete):

https://docs.google.com/spreadsheets/d/1-zi2lfdVAmh3iWrdSkG3cqXkpfZM70sQZYmwQcw9_HE/pubhtml#

Check the Necromancy Additives and Philosopher's stone Tabs. This is the only spreadsheet i found with that info.

Thanks for the finding, it's one that I need the most. The 'Necromancy Additives' is just body part, I suppose.
(the stats are still important to gather though)

I find that simple is best in some parts, not much to adjust in Resource Combination sheet.
Unless you have an advice on how to make it look better

[BarriaKarl 1,091]

14 minutes ago, CytheS said:

Thanks for the finding, it's one that I need the most. The 'Necromancy Additives' is just body part, I suppose.
(the stats are still important to gather though)

I find that simple is best in some parts, not much to adjust in Resource Combination sheet.
Unless you have an advice on how to make it look better

 

• Add the items of the type something+seal. Like copper bar+crafting seal=Crafting sealed copper bar (stat: Basic Crafting speed 0.051) Check TerrorRage spreadsheet.
• Add the remaining crafting tabs like Enchanting, Jewelcrafting, Necromancy and stonemasonry. If they dont have any recipe that grant some extra stats leave them open. That way we know there isnt anything to add instead of thinking you left something out.
• If possible show how the granted stats increase with color. You may leave this out for simplicity sake since the difference is minimal.
• You could expand the things that you grouped together like metal rings and metal sheets. It would increase volume and it would be a chore but it seems worth the effort. At least leave a note saying that the stats and the recipe (not really) are the same.
• This one is just me wishing you make my life easier but something that shows the base stats of all items would be awesome. This could be added like the notes you put on some items, hover over some armor to see all mitigations and other useful stuff. Probably should be added to the crafting recipes spreadsheet. Am i asking for too much? It was worth a try.

Now that i look at it those are pretty minor stuff. The worst part was having to use multiple fonts to find everything.

 

[CytheS 102]

15 minutes ago, BarriaKarl said:

 

• Add the items of the type something+seal. Like copper bar+crafting seal=Crafting sealed copper bar (stat: Basic Crafting speed 0.051) Check TerrorRage spreadsheet.
• Add the remaining crafting tabs like Enchanting, Jewelcrafting, Necromancy and stonemasonry. If they dont have any recipe that grant some extra stats leave them open. That way we know there isnt anything to add instead of thinking you left something out.
• If possible show how the granted stats increase with color. You may leave this out for simplicity sake since the difference is minimal.
• You could expand the things that you grouped together like metal rings and metal sheets. It would increase volume and it would be a chore but it seems worth the effort. At least leave a note saying that the stats and the recipe (not really) are the same.
• This one is just me wishing you make my life easier but something that shows the base stats of all items would be awesome. This could be added like the notes you put on some items, hover over some armor to see all mitigations and other useful stuff. Probably should be added to the crafting recipes spreadsheet. Am i asking for too much? It was worth a try.

Now that i look at it those are pretty minor stuff. The worst part was having to use multiple fonts to find everything.

 

I'm configuring on how to add the specialty seal currently, there's easily 10+ seals and listing all of them would make the data too messy.
The noticeable pattern is that same resources tier of the crafted item with same seal gives the same stats bonus. 
(resource tier is removed long ago though, so might be outdated)

I haven't delved much into mitigations, too busy to gather those.
That said, there's more and more important data that indirectly relate to crafting... so this might be a necessity.

[CytheS 102]

Another sheet is added temporarily for specialty seals stat.
 

[Auras 5]

[DELETED]

Edited June 19, 2017 by Auras

[eeliigaa 25]

How many combat stats are traded for how many crafting stats?