Crafting Spreadsheet

[Jeagan]

Not sure if anyone's done this already, but I made a spreadsheet of the basic crafting recipes to calculate what materials you need to purchase, and how many.

 

https://docs.google.com/spreadsheets/d/1vVF59yH7SLfwH3zKJwBA0BqbeMuJn-sehCfNpFT4qzQ/edit?usp=sharing

 

Let me know if I made any mistakes!

[Frostweaver]

It looks good.
Feel like making a second one for cross referencing set bonuses? It would take a lot of the effort out of experimenting in Pines to find out what sets you need to both maximize damage/softcap defenses and perma-hasten.

[Jeagan]

Not sure what exactly you would want the spreadsheet to do. You can find the different bonuses for the sets at https://paragonwiki.com/wiki/Enhancement_Sets, but as far as making a spreadsheet that tells you what set bonuses you'll need for X amount of bonus, that's got too many variables involved.

[Neural]

A suggestion:  Not sure if google docs can do this.  Is there a function that allows you to change the background color of a cell if the value is greater than 0?  That way the salvage components that are needed would have the quantity cell highlighted, making it easy to quickly find.

[Jeagan]

Updated, now the salvage should highlight a light blue if the value is >0

[Neural]

20 hours ago, Jeagan said:

Updated, now the salvage should highlight a light blue if the value is >0

That is perfect.  This is useful in a number of ways.  Thank you!

[Jeagan]

My pleasure 🙂 I've been using it for crafting 25s on my baby alts 😛

 

I'm considering adding a price calculator, as well, both for base and memorized crafting. Probably not going to include purchase of recipe cost, as that has too many variables involved (where the recipe is purchased from, how many copies are already owned, etc). I'm glad you like it so far, though!

[Jeagan]

Realized that I don't have enough data input for the pricing, such as which specific level of recipe is being used. I may have a max cost to craft, no including material and recipe purchase. I don't know if that is at all feasible or even useful.

[Jeagan]

Jeagan's Crafting Spreadsheet

https://docs.google.com/spreadsheets/d/1vVF59yH7SLfwH3zKJwBA0BqbeMuJn-sehCfNpFT4qzQ/edit?usp=sharing

 

Only for basic IOs, not sets!

Input: the number of each enhancement, by level needed

Output: how many of each basic salvage needed, and how many total salvage slots are needed

 

Please clean up after use! Just empty out the input fields!

 

[Jeagan]

Just making a post so this is a bit easier for everyone to find. Yay spreadsheets, hope it's helpful!