Xenon Calculator (Range/Damage/Gear comparison)
Hello everybody, it's been a long time since I've acquired this spreadsheet, about two years to be exactâ€"and I've found it to be immensely useful and thought I might as well share it to the public.
First off,credits goes to the Xenon known as Nukes in Scania, formerly known as Unific.
He's the one who provided the base, I've merely modified it after updates have made the certain parts outdated, such as the xenon revamp and hyper stats.
To use it, you'll have to download LibreOffice, since I unfortunately do not have Microsoft Excel installed.
https://www.libreoffice.orgwnload/libreoffice-fresh/
Dropbox:
https://www.dropbox.com/s/tm46qhfszb0pqud/Xenon%20Calculator%20%28Dropbox%29.ods?dl=0
(DO NOT click, copy the link and paste in a new tab)
All you have to do is fill in the orange cells and it'll calculate your range and damage against common bosses. You can easily "upgrade" your equips to see your new damage after, which is the strongest point about this spreadsheet, imo.
---
FAQ:
Q:Why is the range wrong compared to my ingame range?
A:I have tried to find out the reason, unfortunately it continues to elude me. The good part is that it's only off by a very minuscule amount, less than a 0.005% error margin, and it'll still definitely give you a good idea of what your range is if you're past the 2m cap.
Q:How come my damage is off in the damage calculator?
A:Again, it may not be 100% correct, but I feel it's close enough. And pay attention to the Average damage instead of the min/max damage, due to the fact that damage distribution in MS is bell shaped (you have to roll both the min damage on your range and %crit damage to hit the lowest number, same with your highest damage), you're much more likely to hit closer to the average and the extremes in the min/max damage may mislead you.
(Will be updated when new questions arise that I'm sure I haven't anticipated.)
---
Note: The damage calculator in sheet 2 for dojo bosses is a bit off I feel, if anyone happens to know what the dojo bosses's %PDR is and exactly how the level difference bonus works, please pm me.
At the moment I have it set to if 5 levels or higher than mob=1.2x damage, if 5 levels or under mob=0.8x damage, and 4 levels below mob to 4 levels higher than mob=1x damage.
Also, reveal the comments, they have important information.
---
Meanwhile, leave any questions down below and I'll get back to you as soon as possible.