Source
macafeu88•

You can also stick to the atk*(1+cr*cd) formula

5
imaaroncotta•

what are the * for? multiplication?

2
macafeu88•

Yes atk time (one plus cr times cd)

1
imaaroncotta•

and atk as in for example: 735 +785 (785 is in green) that one?

2
senkan•

thanks for this, i suck at making spreadsheets so this is really helpful

3
Parragorious•

Thanks

2
mindmuscleconnection•

Thanks for this.

Just a reminder, if Build A has a, let’s say additional +150 DPS over Build B, but build B increases your energy regeneration by a good margin (maybe >20%), build B might be better as it allows you to have better burst uptime thus increasing your overall DPS.

2
mindmuscleconnection•

Thanks for this.

Just a reminder, if Build A has a, let’s say additional +150 DPS over Build B, but build B increases your energy regeneration by a good margin (maybe >20%), build B might be better as it allows you to have better burst uptime thus increasing your overall DPS.

2
sttaseen07•

Hi Dex! Your tool is very useful. Just wondering, how did u calculate DPS?

2
DexcloudOP•

Everyone knows that 1% Crit Rate is equal to 2% Crit DMG. For ATK% it's 1.5% for every point of Crit Rate.

But if you subtract 1% Crit Rate, you have to subtract 2% Crit DMG too, so ATK% should be increase in 3%.

That being known, all I have to do is a table where those stats are varying, then I just have to find the build with the best DPS.

In fact, testing with the spreadsheet, I found that there is not a ratio for the ATK% (like the 1:2 ratio for Crit Rate and Crit DMG) but an Optimal Total ATK equal to 214% Base ATK.

1
phileq•

This spreadsheet is misleading – it calculates raw output damage, not DPS.

0
AutoModeratorMOD•

Hi u/Dexcloud. It seems you've posted either a simple question, or a question about team building, both of which are handled in our megathread here (pinned on the front page)! Please check our FAQ as it might answer a lot of your questions. Feel free to also join our Discord Server if you need general help over time! If this is in error, please contact the mods through mod mail!

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

-1