Jeagan Posted August 17, 2019 Share Posted August 17, 2019 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! 1 Link to comment Share on other sites More sharing options...
Frostweaver Posted August 17, 2019 Share Posted August 17, 2019 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. Link to comment Share on other sites More sharing options...
Jeagan Posted August 17, 2019 Author Share Posted August 17, 2019 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. Link to comment Share on other sites More sharing options...
Neural Posted August 17, 2019 Share Posted August 17, 2019 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. Altaholic Link to comment Share on other sites More sharing options...
Jeagan Posted August 18, 2019 Author Share Posted August 18, 2019 Updated, now the salvage should highlight a light blue if the value is >0 1 Link to comment Share on other sites More sharing options...
Neural Posted August 18, 2019 Share Posted August 18, 2019 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! Altaholic Link to comment Share on other sites More sharing options...
Jeagan Posted August 19, 2019 Author Share Posted August 19, 2019 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! Link to comment Share on other sites More sharing options...
Jeagan Posted September 8, 2019 Author Share Posted September 8, 2019 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. Link to comment Share on other sites More sharing options...
Jeagan Posted September 16, 2019 Author Share Posted September 16, 2019 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! Link to comment Share on other sites More sharing options...
Jeagan Posted January 26, 2020 Author Share Posted January 26, 2020 Just making a post so this is a bit easier for everyone to find. Yay spreadsheets, hope it's helpful! Link to comment Share on other sites More sharing options...
Recommended Posts