Tallowby's Crafter Aid ( v15) Dark Brotherhood DLC Updated

Tallowby · July 2014

TALLOWBY'S CRAFTER AID
File: Version 15 BETA
Archive
v14 / v13 / v12 / v11 / v10 / v9 / v8 / v7 / v6 / v5

Screenshots (Crafting Progress Sheet), (Blacksmithing), (Provisioner's Cookbook)

Last Revision Key Changes: (v15.2 BETA)

Spoiler

15.2
- Removal of VR levels and conversion to CP levels complete.
- Addition of Dark Brotherhood craftable sets
- Addition of new style materials

Note: Next update to include the addition of poison ingredients(Ingredients Page) and Poisons (Potions Page)

v15
Modified Crafting overview sheet
- Removed VR levels

Modified Racial Style Sheet
- Added Dark Brotherhood DLC 3 New Styles

Modified Blacksmithing/Clothing/Woodworking Sheets
- Modified Traits Effects

In Process Items
- Full conversion from VR Levels to Champion Point System

(Last Update 6/16/16)

Minimal Data entry required...

Enter Toon Name, Level.
Document Motif/Styles learned.
Enter Craft Level.
Document Traits Learned, Researching and in storage. (next research time listed)
Document Passive Skill Points allocated.
Optional - Document time your Hireling makes deliveries.
Optional - Enter current inventory levels (will modify data on other sheets)

This aid is contained in one Excel document. Sheets contained within...

All Craft Progress Report Sheet (See above)
Blacksmithing Craft Sheet (See above)
Clothier Craft Sheet
Woodworking Craft Sheet
Alchemy Craft Sheet
Provisioning Craft Sheet
Enchanting Craft Sheet
Ingredient List - Stats on all items (Optional Crafting Inventory Entry)
If inventory totals are entered
the quantity which you can produce will auto fill on the next 3 sheets.
Cookbook - Enter known recipes √ (See above)
Potions - Alchemy Recipes
Glyph - Enchanting Recipes
Checklist Sheet <-- NEW
Crafting Sets & Location Guide
Inspiration Point Maxing Tables (Used for Crafting Buddy Optimization)

Ashtaris · July 2014

It's obvious that you took considerable time and effort in creating those spreadsheets. Nice job! I'll be checking them out this evening

Tallowby · July 2014

Thanks kindly

Tallowby · August 2014

Ashtaris wrote: »

It's obvious that you took considerable time and effort in creating those spreadsheets. Nice job! I'll be checking them out this evening

So what did you think?

Tarukmockto · August 2014

I think it's awesome and saves me a huge amount of work creating my own! lol Thanks.

Tallowby · August 2014

Could use some assistance...

Passive Skill unlock levels - missing last 2 for provisioning and last 6 for alchemy. Check out what I have via the link.

New Patch out today. Any changes requiring an update? Post here please.

SirJesto · August 2014

Awesome matrix @Tallowby !

I use Multiple characters for crafting. Is there a way to use 1 copy of this file to deal with all of them?

thanks again.

two_beer · August 2014

Excellent work - I'm looking forward to the next version now that the patch changed a lot of things.

Tallowby · August 2014

SirJesto wrote: »

Awesome matrix @Tallowby !

I use Multiple characters for crafting. Is there a way to use 1 copy of this file to deal with all of them?

thanks again.

1. Are you saying you use multiple characters to master different crafts? I can unlock the craft page title for Toon name addition. (ie 'Toon A' Blacksmith, 'Toon B' Clothier, 'Toon A' Woodworking,... ect). So the 1st sheet 'Overview' would list off Toon names by each craft as well. If so I will add on next update.

2. Or are you sharing a single craft between 2 Toons? Multiple concerns implementing a change this way. Passive skill points allocated will be a major concern.

I use 3 Crafting characters myself. I use 3 files at the moment (Horizontal Tile Layout). Works well for known traits and constructing gear with traits for a Toon that needs it. (See who has what and who need what)

SirJesto · August 2014

Tallowby wrote: »

show previous quotes

SirJesto wrote: »

Awesome matrix @Tallowby !

I use Multiple characters for crafting. Is there a way to use 1 copy of this file to deal with all of them?

thanks again.

1. Are you saying you use multiple characters to master different crafts? I can unlock the craft page title for Toon name addition. (ie 'Toon A' Blacksmith, 'Toon B' Clothier, 'Toon A' Woodworking,... ect). So the 1st sheet 'Overview' would list off Toon names by each craft as well. If so I will add on next update.

2. Or are you sharing a single craft between 2 Toons? Multiple concerns implementing a change this way. Passive skill points allocated will be a major concern.

I use 3 Crafting characters myself. I use 3 files at the moment (Horizontal Tile Layout). Works well for known traits and constructing gear with traits for a Toon that needs it. (See who has what and who need what)

It's actually a bit of both 1 and 2 lol.

I have 5 crafters.

#1 = Heavy Armor & Shields, #2 = Metal Weapons, #3 = Bows & Medium Armor
#4 = Light Armor, Restoration Staffs, Alchemy & Provisioning, #5 = Destruction Staffs and Enchanting.

So yeah, It's a bit of a nightmare lol.

The one good thing is they are all max crafting level and each have all passive skills for their crafts.

Tallowby · August 2014

SirJesto wrote: »

show previous quotes

Tallowby wrote: »

SirJesto wrote: »

Awesome matrix @Tallowby !

I use Multiple characters for crafting. Is there a way to use 1 copy of this file to deal with all of them?

thanks again.

1. Are you saying you use multiple characters to master different crafts? I can unlock the craft page title for Toon name addition. (ie 'Toon A' Blacksmith, 'Toon B' Clothier, 'Toon A' Woodworking,... ect). So the 1st sheet 'Overview' would list off Toon names by each craft as well. If so I will add on next update.

2. Or are you sharing a single craft between 2 Toons? Multiple concerns implementing a change this way. Passive skill points allocated will be a major concern.

I use 3 Crafting characters myself. I use 3 files at the moment (Horizontal Tile Layout). Works well for known traits and constructing gear with traits for a Toon that needs it. (See who has what and who need what)

It's actually a bit of both 1 and 2 lol.

I have 5 crafters.

#1 = Heavy Armor & Shields, #2 = Metal Weapons, #3 = Bows & Medium Armor
#4 = Light Armor, Restoration Staffs, Alchemy & Provisioning, #5 = Destruction Staffs and Enchanting.

So yeah, It's a bit of a nightmare lol.

The one good thing is they are all max crafting level and each have all passive skills for their crafts.

If you come up with an idea let me know. I may work later on a guild version that will have to do what you are asking.

Tallowby · September 2014

Update

Notes on main post

Tallowby · October 2014

UPDATE
- added new hard craft trait
- tweaks & bug fixes

Tallowby · February 2015

UPDATE
Pre Provisioning bug fixes and tweaks.

Expect large provisioning update after 1.6 goes live

Tallowby · March 2015

Major Update

Due to the changes to Provisioning migrating from version 8 to 9, transferring will be more of a challenge.

I have included a cross reference for recipe names (1.5 /1.6). The 1.5 list is hidden by default. Also the normally hidden recipes are visible to help with the change, hide when familiar.

T.

Altha · March 2015

Thank you again for such a great resource

Tallowby · March 2015

New Update pending...

I will be posting an updated version (9.2) to add additional recipes in a weeks time.

The provisioning changes added ~ approx. 100 new recipes to the total. I have most and believe there are only 15 more to complete.

Tallowby · March 2015

With so many new recipes I will need to make incremental updates. I was unable to find info/stats on a few remaining recipes.

9.2 update adds 120 new recipes for a total of 471

I believe I am missing ~15 Recipes.

Tallowby · March 2015

Update 9.3 is up

All 1.6 Provisioning changes/additions implemented.(1 recipe buffs missing)
All Crafting Set buffs updated to 1.6 ranges

T.

Tallowby · March 2015

Final buff info added to the 9.3 file

Tallowby · April 2015

Major 1.6-2.02 changes - updated in version 10

Buffs for all consumables to 2.02 values included

Alchemy Recipes - 2.02 buffs updated
3/30/15 Provisioning Recipe changes - 2.02 buffs updated
Enchanting Recipes - 2.02 buffs updated
Crafting Set info updated to 2.02 values
Many visual design changes
Error corrections

Tallowby · April 2015

Listed last post as 1.6 actual revision number 2.02

bbritton8883525_ESO · April 2015

Great resource! I have posted a link on my guild's website.

Thank you.

pilsner · July 2015

Really heavy work put into this one - I really appreciate what you've done!
I've been using this for the last two weeks and it has been a great help. I've done some modifications, partly because I run it in Numbers on a Mac, but also to add a calculation of when researching a treat is finished.

I'm currently adding a "bank" to keep track of what is available there for all my characters - we will see how that works out (Numbers is OK, but I'm more familiar with Excel)

I'll give you some detailed feedback in a message...

Thank you!
/Jörgen

Tallowby · July 2015

Update Key Changes: (v11)

Added Psijic Ambrosia
- Added Provisioning Skill Point Addition to Recipe Quality
- Recipe Added
- Added Perfect Roe Ingredient

Added Checklist Sheet
- Group Dungeons
- Public Dungeons
- World Boss
- Dolmen & Molag Bal Generals
- Cyrodiil Delves & Dolmen

Added additional options under Trait Research
- backpack
- bank/mule

pilsner · July 2015

pilsner wrote: »

I'll give you some detailed feedback in a message...

Ah - apparently I was not able to send you a message. I'll give a short note on the only major "issues" I've found:
N.B. I am using Numbers for Mac - so take that into consideration, although I've checked things in OpenOffice as well… This might also mean that I had greater ”rights” to the sheets than I was supposed to - hope you don’t mind me doing some fiddling around…
And - just to remind you again. I’m really thankful for the effort you put in to this. It has saved me tons of work, although I probably put in some hours on ”debugging” and conversion issues...

Calculation of time for next research:
You are currently dividing the time needed with a series of numbers (1; 1,05; 1,10; 1,20; 1,25) to correspond to the decrease in research time (5%, 10%, 20%, and 25%). This might be something that happened in the conversion to Numbers, (although unlikely, as opening it in OpenOffice renders the same result) - So, to keep it short, instead of using division, you should multiply with (1; 0,95; 0,9; 0,8; 0,75) in order to reach the intended result (compared with in game values). This is also, to the best of my knowledge, how you ”normally” do this kind of percent calculation (i.e. multiplication instead of division).

Alchemy Potion list:
I have not done much with this, but the little things I tried did not work out as intended. It is stated that it is ESO 1.6, so I should perhaps not be surprised. My primary character does not fiddle that much with potions, so it took some time until I tried to do a writ, and had to create a ”ravage stamina” potion. I tried some of the ones in the list, and if I remember it correctly, the Imp Stool + Mountain Flower gave me a Increase armor + Lower weapon power… And Namiras Rot + Water Hyacinth a Spell Critical potion… Or something along that way… Since I was able to ”unhide” the columns in the Ingredients sheet, I could there see a bit easier what I could expect from the different ingredients - which turned out quite OK. I might put some more effort into this one since I now have another character that specialices on magicka, enchanting and potions...

Minor stuff: spelling errors in some (a few) recipies which is only a problem if you try to search for them - I'll double check with the game running...

Otherwise you already included some of what I've done myself into v11, and yet some. Great work!

Regards,
Jörgen

Tallowby · July 2015

pilsner wrote: »

show previous quotes

pilsner wrote: »

I'll give you some detailed feedback in a message...

Calculation of time for next research:
Jörgen

Next Update....

Tallowby · August 2015

Last Revision Key Changes: (v12.1)

Modified Crafting Overview Sheet
- Added an ESO Plus membership toggle
- Modified Motif Style section to accommodate new styles

Blacksmithing Sheet
- Added Skill Point to Metalworking
- Added Colossus Material
- Revised research timers to match more closely to in game timers.

Clothier Sheet
- Added Skill Point to Tailoring
- Added Daedric Skin Material
- Added Harvester Silk Material
- Revised research timers to match more closely to in game timers.

Woodworking Sheet
- Added Skill Point to Woodworking
- Added Ruddy Ash Material
- Revised research timers to match more closely to in game timers.

Alchemy Sheet
- Added Skill Point to Solvent Proficiency
- Added Lorkhan's Tears Material
- Future incremental update pending for Potion Sheet

Provisioning Sheet
- Added Skill Point to Recipe Improvement
- Added 44 New VR 15 Recipes
- Corrected incorrect buff values

Enchanting Sheet
- Added Skill Point to Potency Improvement
- Added Potency Runes (Rejora & Repora)
- Added Essence Runes (Itade & Jehede)
- Future incremental update pending for Glyph Sheet

Ingredients Sheet
- Added all additional materials listed above
- Added Raw & Refined New Style materials (Malachite & Charcoal)
- Added Tal Var Stone
- Added Bait - best use guide

(Last Update 9/1/15)

pilsner · September 2015

Excellent! Been "AFK" for a while, and was really happy to see an update to this when I returned. Keep the good work up!
/Jörgen

Tallowby · November 2015

UPDATE v13

Modified Crafting Overview Sheet
- Modified Motif Style section to accommodate new styles
- Added Champion Point Total

Alchemy Sheet (UPDATED)
- Added Alchemy Trait Discovery Guide

Enchanting Sheet
- Added level & effect table

Ingredients Sheet
- Added Raw & Refined New Style materials (Orsinium)

Potions Sheet
- Simplified potion effects to stats buffed for cleaner look

Recipe Sheet
- Added new Orsinium Recipes
- Highlighted recipes data mined yet not yet introduced to game (orsinium?)

Glyph Sheet
- Simplified glyph effects to stats buffed for cleaner look

Other Checklists Sheet
- Added both Imperial City Group Dungeons
- Added both Orsinium Public Dungeons
- Added Imperial City & Orsinium Boss checklists (World, Roving, & Sector)
- Reordered Cyrodiil Delves by faction
- Reordered Cyrodiil Domlen by faction
- Added Cyrodiil Quest Hub check list

xerasia · January 2016

*gasp* *heavy breathing*
I've created a couple of spreadsheets myself to track crafting, but these are a work of art! Thank you for sharing and for all of your hard work.