2009-05-18, 04:30 PM
Tykian Wrote:Hey Kaida, I fixed your calculator. It may work for you, but currently, as it is, your calculator can't account for Maple Warrior/Homing being level 0. I fixed this by adding a level 0 row, and compensating the skill lookup for that. I also rounded your average hits to to kill.
Okay, I fixed it and put it in the first post. If it doesn't work for anyone, redownload it and it should. (Sidenote: is INT() not a function in Excel? If so, what should I use that does the same thing?)
However, I undid the rounding of the hits to kill. While I agree that it's not a great estimate for small numbers of hits to kill unless you understand that it has an invisable +/-, rounding it doesn't make it any more clear. Seeing that it takes an average of 5.14 hits to kill a monster can tell you that you're close to killing it in 5 hits half the time. If you just trunc that to 6, all it makes is ambiguity.