I'm having an issue with the spreadsheet since I upgraded my gloves.
Before the upgrade, the stat sheet matched up with my DPS stat in-game perfectly (minus force weapon of course).
However since changing my gloves from an ASpeed pair to a Crit/Crit pair the spreadsheet gives me a lower number than my character sheet does. I'm using the detailed sheet, and the blue boxes in column R all match my character sheet, but the black ones R28 & R29 are lower than the in-game results.
Is there any indication whether the miscalculation is from the spreadsheet or the game client?
Okay, I had a look through myself and the Equipped Calculations sheet wasn't adding 60% crit from my weapon gem. If I manually changed this total to include that bonus, the numbers added up.
0
Before the upgrade, the stat sheet matched up with my DPS stat in-game perfectly (minus force weapon of course).
However since changing my gloves from an ASpeed pair to a Crit/Crit pair the spreadsheet gives me a lower number than my character sheet does. I'm using the detailed sheet, and the blue boxes in column R all match my character sheet, but the black ones R28 & R29 are lower than the in-game results.
Is there any indication whether the miscalculation is from the spreadsheet or the game client?
Screencaps:
Both sets of gloves to confirm stats
http://img703.images...89/gloveshv.jpg
Spreadsheet output with Crit/Crit gloves input
http://img832.images...spreadsheet.jpg
Character sheet with Crit/Crit gloves equipped
http://img6.imagesha.../statsheets.jpg
Okay, I had a look through myself and the Equipped Calculations sheet wasn't adding 60% crit from my weapon gem. If I manually changed this total to include that bonus, the numbers added up.
edit; P.S. sweet spreadsheet man, love the work.