Recent content by Roen

I was reviewing the information in the sheet, and I came across something I had forgotten about. At +16, +17, +18, +19 and +20, the amount of failure increases per fail are higher than previously. So at +16, every failed attempt gives you 2 failures. +17 gives 3 failures. +18 gives 4 failures...

Great! Thank you so much for your help. I really appreciate it.

Amazing, I've made a copy for myself to study later. By scaling I meant that. Like in my original attempt, I want to see the expectation for starting the process at an already accumulated failure amount. base + 1 failure = expectation base + 2 failures = expectation base + 3 failures =...

Perfect! Thank you a million times. I'll start working on how to get it into a forumla in excel. Any ideas? The kind of formula I'm looking for would be able to scale with the initial amount of failures. Example: +8, 4 failures I'm sorry if it is a bit vague.

yes! exactly. There is one more element to this though. for the +8, the incremental increase of 2,5% stops after failing 13 times. so the maximum chance would be 20% + 32,5% chance of success. How will this affect the table you made? Thank you so much for your help so far.

This is for use in a game. There is already a stated base success chance at each level of enchant. Base chances for success are as follows. At +8: 20% base, increase of 2,5% per failure. At +9: 17,5% base, increase of 2% per failure. Etc. All of these base values the game already informs you of.

The reason for enchant +16 becomming easier is due to the base % chance of success and the incremental increase per failure attempt being higher than +15. I am able to calculate the average amount of attempts at a given already attained amount of failures. For example: At "enchant level" 9...

Hello! To start off, this is my first post here, math is not my strongest subject and so I do not know if this is pre university or university math. Apologies if this is the wrong sub forum. I have created a google doc where I am currently trying to solv my problem, link below...