How to make a perfect weapon

I made a calculator for the optimal path for making a perfect weapon. You can use this for other equipment too (BWG, earrings, etc)

Make your own copy to use it!
https://docs.google.com/spreadsheets/d/1Pnm3bAFvnAlAnQN1BpT2B3__81G8ctE_X0ssqFu344E/edit?usp=sharing

You'll need the estimate prices of

• clean weapon
• 30% scroll
• 10% scroll
• white scroll (WS)
• clean slate scroll 20% (CSS20)

Each attempt continues from the cheapest of the 3 options of the previous attempt

Assumptions (if they're wrong I'll adjust the calculator)

• 30% scrolls give you 30% success, 35% failure (-1 slot), 35% boom
• CSS20 gives you 20% success (restore 1 slot), 40% failure, 40% boom
• CSS20 can be used an infinite number of times as long as a slot can be restored

• 30% scrolls are always used with either CSS20 or WS (for very cheap weapons, selling/scrolling a 6 slot with 1 fail may be better than using a CSS20 depending on the price)
• 10% scrolls are always used with WS (for very cheap weapons a 10% scroll may be better to use than a 30% scroll - both without WS)

• 30%/CSS20 has a 33.96% chance of success (+1) and requires on average 1.1321x 30% scrolls and 0.6603x CSS20
• 30%/WS has a 46.15% chance of success (+1) and requires on average 1.5385x 30% scrolls and 1.5385x WS
• 10%/WS has a 100% chance of success (+1) and requires on average 10x 10% and 10x WS

 

If you want to do a custom order you can delete (DEL) the yellow boxes. You can make a new copy to restart the process (or undo with ctrl+z)