Big Post Incoming. I figured it's time to share some of the work I've been doing on the spreadsheet. It's not finished, and it could contain mistakes (lord knows I've fixed more than a couple). If anyone has any errors they find I'd appreciate help in improving the spreadsheet for the community. As has been said before, use it as a guide rather than a bible, and you should be fine.
Here is the download:
DPS Calculator - RNG v6.65
Additions include:
* Capping snapshot at 70%, not 80%
* Adding Gifts and Job Points relavant to DPS calculations (TODO: Conserve TP)
* Fixed the pDIF ratio caps, and have it automatically toggle to 3.25 on Archery and 3.5 on Marksmanship
* Work in Progess: Vorseals these toggles don't yet work
* Boosted the STP to accurately reflect actual SAM roll values
* Added indi-agi, indi-acumen and indi-fury
* Added 25% piercing bonus to Soundsplitter Bat so you can test dps vs piercing weak setups
* Added a new sub, Shield with the new ranger/cor shield.
* checked various calculations for accuracy though doing this in total would be a near impossible task for one person, found some errors with trueshot and other calcs
* added in a lot of new gear though not all of it
* added in double shot damage calculations from belenus cape
* Added AM3 for empy and for mythic calculations
* Fixed TP Bonus from WAR subjob fencer
* probably forgetting stuff as I've plucked on this in my spare time for months
* More todos: any help with verification is wonderful
* Need to add velocity shot step in delay reduction
Ok so I get a lot of questions about DPS. This combined with what I've seen and experienced in game with others and my own weapons is what I base my judgements on. Hopefully we can have less arguments or at least more civil ones if it comes up again. Again though, use this as a guide not the holy truth from above and always keep in mind: ***is situational. (Actually didn't use all the latest gear on all these sets either but it's still pretty current).
Anni - Coronach
Anni - Last Stand
Arma - Last Stand
Fail Not - Jishnus
Fomalhaut - Last Stand
Gandiva - Jishnus
Gastra - Trueflight
Yoichi - Jishnus
Note: I didn't really turn it up to 11 for Gastra, stacking mage buffs and vorseals, tried to leave it fairly vanilla outside tp gain and pdif cap. I also can't seem to make the image previews any wider sorry about that. I also tested atoyac crit damage myself it does apply to ranged attacks.
Edit: I made two small adjustments on the Data page since I posted the sets, one to DS Damage and one to Round Delay. The 2nd doesn't seem to have any effect on dps but the first has a slight effect (since it used just the weapons delay later on in the calcs anyway).
Edit 2: I was going over more and saw the toggle for pdif cap doesn't apply to the weaponskill page so fixing that and uploading new images and spreadsheet -- This is done now. It does shift the balance of power some in addition to the warrior fencer fixes. I was hoping Nisroch Jerkin would make up for it but not quite.
Edit 3: Fixed trueshot applied to magical ws and uploaded a new image and spreadsheet to reflect that
Edit 4: Verification work continues... I found some critical errors in the calcs for ranged attack damage. Basically, for set 1 it wasn't using empy 3x damage correctly by double using it which was leftover from older stuff (but still wasn't correct in how it did use it as that was odd). In both columns however, Dead Aim was a part of the spreadsheet for a very long time but for some reason wasn't being used. AM3 was set to 30% double dmg proc instead of 40% too for some reason. What clued me in is Gandiva had less average shot than Gastra, which didn't make sense to me at any level, Gandiva has higher base damage and higher average multiplier with am3 up, even if gastra did have higher pdif cap. 90% of the time I find something wrong it's because of noticing something like this so if anyone finds something odd or better yet has a fix let me know be more than happy to fix it. Average shot might raise eyebrows at first at 17,766 but I inspected further and since double shot is on, and the double shot damage cape ais on and trueshot distance is on, it actually falls in line with what I'd expect since even with gastra I've done single shots that proc triple and crit and get over 10k damage if pdif is capped and I'm at trueshot distance. New spreadsheet up as well as images. Gastra falls behind now, but keep in mind, malaise can double to triple damage and things like wizards roll, indi-agi or acumen aren't on (just indi-agi and indi-acumen boost dmg to 11,737 dps).
I asked a few people to help me verify the file but not sure if they have time and will get back to me or not. I currently can't find anything that "doesn't make sense" though as far as what I'd expect from final numbers.
Edit 5: Ok... so this should be the last edit for a long while to the data sheet at least. Hoping so. I made verification tests for both am3 empy and mythic and corrected their formula. The results are listed in the post now, thank you. The most current spreadsheet will list version 6.5 in the name. If anyone finds anything don't hesitate to let me know thank you.
Edit 6: Fixed Rogue's Roll as pointed out by Capuchin thanks :) Also made sure the fixes to magical ws in set 1 made it in, also pointed out by Capuchin.
Edit 7: I requested Byrth's help too and he has been very generous with his time and helped a lot. He identified several mistakes and while it's not ready for release yet due to a few other issues (tp generation isn't working quite right), I can release a few fixes right now. There's also some other things I spoke to him and Chia about, like the fact there's a ~3 second delay after ws that I don't know if any spreadsheets take into account. I haven't updated the images yet since still working on a more finished version. I was told before that this was one of the last spreadsheets Motenten worked on and was somewhat unfinished. I've edited a lot of it, but a lot of the work is his.
Edit 8: updated images, tp generation still needs to be taken another look at, as does attack speed. Mostly this will change the DPS caps tho rather than hurt gear comparison. I think personally I still prefer gandiva over Arma, for two simple reasons. Trueshot distance is easier to actually do (if you toggle off true shot distance it loses about 1k dps on arma). And you aren't using a 3k wildfire but a 3k jishnu's to activate am3. While 3k jishnu's is still pretty wasteful you do get crit chance out of it.
I'm going to do some more testing to model how delay works on a scale of high delay to low delay weapons to try and pin down min ranged delay all real life factors including latency average etc considered after talking with byth about it alot and another test to see if we can figure out if the model itself is accurate. The TP generation stuff mostly deals with arcadian beret.
I've also been thinking about showing the racc of each ws set and tp set... one of the biggest things relics bring is another 60+ racc and that really matters sometimes.