If they are supposed to not be accessible by players, could someone at Funcom speak up to say “A friend of my colleague has heard that it seems to be possible that some of the stated hypothetical numbers could be wrong” ?
That’s usually not how things work. If this kind of info isn’t available somewhere, then it’s up to the community to find out the underlying mechanics. I’d be really surprised if anyone at Funcom speak up to confirm or even comment on these things.
Nothing has been copied from TSW. I’ve been working / theorycrafting with Smyrill and other people on lots of these numbers, and i can personally attest that they are very accurate so far. We’ll never be 100% certain about anything, but it’s so far good enough that you can take all this info reliably, yet with a grain of salt depending on what you want to do / calculate.
Everything is current as of the latest patch (2.20).
However some values may be off by ~1-2, since they were reverse calculated using values displayed on the character sheet which are rounded off. Specifically, secondary stats rating conversions and IP calculations may be off by a bit. I know for sure that legendary weapon IP values are off by ~2 at level 70, but I can’t find a formula that works equally across all qualities - maybe legendary weapons have a different IP formula compared to non-legendary weapons.
You are selling your topic short! This is a great spreadsheet with more than just theorycraft info. It also has base information on (nearly all??) the weapons, talismans, gadgets, and signets. Not to mention the mission list. It is the most comprehensive information on SWL gear and mechanics.
Feel free to copy/paste my reply and add it to the original link description. This is really good work and I’m glad you got around to posting the original link as many people reference it in their discussions (sometimes wrongly, but whatever. not like you can control that).
There’s a bonus calculator in my Museum of the Occult spreadsheet. All you need to do is make a copy for yourself and enter your own pedestal levels and it will all be calculated automatically on the main page. From there, you just multiply the bonus by your current Combat Power on your in-game character sheet.
<<There’s a bonus calculator in my Museum of the Occult spreadsheet.>> I didn’t want to know it cost THAT many shards! I need small bite size 5-10-50K at a time upgrade numbers - lol. Seriously though, wonderful spreadsheet Darxide.
This whole undertaking is so full of awesomeness. Thanks for doing the heavy lifting for all of us!
Actually, I think I forgot to post a link to the blank sheet over in the Theorycrafting subforum. Going to go do that right now, thanks for reminding me!