Project 1999

Project 1999 (/forums/index.php)
-   Melee (/forums/forumdisplay.php?f=63)
-   -   Google doc for comparing 2HB to DW pre-60 (at each level) *monk* (/forums/showthread.php?t=163763)

jake505 08-31-2014 12:17 PM

Google doc for comparing 2HB to DW pre-60 (at each level) *monk*
 
I put together a spreadsheet for calculating DPS for any weapon setup from 25-60 for monks (I get tons of questions about what weps to use and when). This spreadsheet removes the need to run the calculations by hand as it can be a pain with dual wield percentages and main-hand bonuses changing as you level up.

The doc allows you to compare weapon combos so you can quickly answer the following questions: 1.) When to switch from 2HB to DW 2.) When a given upgrade is worth the cash 3.) What combo of weapons is the best dps at my level.

To use the sheet, just toss in your delay/dmg at the top of the sheet and it will shoot out DPS at each level. For the DW look at the DW DMG, for 2HB -> 2HB DMG. You can use the second set of columns on the right to compare two complete DW/2HB setups side by side.

Quickfist's DPS Calculator

V2 Updates:
* Used Zilz's template that allows you to compare two complete DW/2H setups side by side, Thanks Zilz!
* Fixed damage for fists by accounting for lower skill cap, fist dmg was slightly inflated in last version. If you are using fists in comparison put an 'X' in the appropriate box. Fist Dmg/Dly
* Fixed 2HB bonus dmg formula for weapons slower than 45.
* Added some basic instructions

Let me know if you find any flaws in the formulas.

Quickfist || 60 Monk || <The A-Team>

Corydon 09-15-2014 03:46 AM

No replies yet, so take mine:
Thanks for this! Appreciated :D

Ando 09-26-2014 12:33 PM

Wow this is amazing. Thanks.

Zliz 10-19-2014 04:59 PM

Thanks for this!

One question: What is that "28" number doing in cell C7? Just a mistake?

jake505 10-19-2014 05:10 PM

The sheet is publicly shared so sometimes some typos sneak in, cleaned up the spurious 28. I also locked down the calculation rows so only the weapon delay/dmg rows can change.

Glad you are finding the sheet useful!

~Quickfist

Zliz 10-20-2014 08:42 AM

I took the liberty of making a copy of the sheet where it's doubled up, so one can also use it to compare two different setups (DW or 2HB) at once:

https://docs.google.com/spreadsheets...it?usp=sharing

Hope the link works.

jake505 01-16-2015 11:35 AM

Bumping this and editing OP with updated version

Spyder73 01-16-2015 06:34 PM

My work internet wil not let me open google docs. I recently completely my Epic and I also lucked out and got a T Staff from KC. Just eye balling it, it feels very close. Bad runs with the 2h are more noticable, but then again it can also double hit for 150,150, +120proc in the span of a single hit. What does the google doc say? Epic + SoS is best DPS? I am wondering how much procs throw this off?

fezzyfezz 01-26-2015 02:12 AM

This is awesome BTW, thanks a ton

fiveeauxfour 01-26-2015 09:28 PM

Another great resource


All times are GMT -4. The time now is 11:11 PM.

Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.