hi, the spreadsheet works wonders, however as u know weapons that have +%damage ar still a bit off as it is my case right now, in the spreadsheet showing like 37k dps and on my screen its a little more.
Yeah, that's a bug that seems to apply to the in game number but not the number shown in your profile out of game. Since I assume most people use the in game value I'm trying to match that as best as possible, which unfortunetelly sometimes requires fudging the weapon damage slightly to get a match when weapons with +damage% are present.
forget that I messed up on a max damage number, now its like 1 single point off, so its as good as it comes.
hi, the spreadsheet works wonders, however as u know weapons that have +%damage ar still a bit off as it is my case right now, in the spreadsheet showing like 37k dps and on my screen its a little more.
I can see what you mean now, apologies for the ignorance of that tooltip bug.
Quite a shame, really, oh well - lower DPS it is.
Thats one of the reasons Im not even using magic weapon anymore, when I realized its a false 30% damage increase, sometimes people would think, OMG its 30% damage increase I HAVE TO USE IT, but its actually only 15%, so I guess its ok to skip it for somethingelse.
PS: Im still using the spreadsheet(I think its the one you edited for the first time), and its working great for me, once you learn how to mess around with the numbers and all everything fits fine, and check with the in game changes. I dont use the EHP though cuz I have a rough idea and dont need it.
Is there anything like this to switch from items? For xample if I want to upgrade my amu/ring. I have a +270 int +13 ias +7% life ring and I want to upgrade it. I bought a amu with +48% crit +6% hit +14 ias and only gave me only 500 damage increase so I sold it again. I really thought it would give me a bigger increase so a progrem could helm me on that before I buy?.
if you look up the spreadsheet, youll see that you can change stats like intelligence, ias from off weapon equipment, critical chance and damage, so all you have to do is fill those in the spreadsheet and make the comparison.
Ive recently found 2 rare weapons with some sweet mods, one is a 714 dps 1 hander ok when I put it on my dps decreases by like 800damage, and the other is a sweet little dagger with 648 DPS, although when I put it on it does about the same damage as the 714 dps one hander, and both do about 800damage less then my 966DPS vanilla mace. Granted both of them add like 150 intelligence and the dagger gives 51%+ critical damage, but its still funny to see they all are about the same level(damage wise). In the spreadsheet though the numbers are a little off since it shows those 2 new weapons as "worse" then they appear in my charscreen damage... both of those weapons have %ias, maybe its something to do with that.
I dont know what I was doing wrong before, now its quite accurate, and teh 1.91.. thing was in the MOD AS like you said but the DPS is the same, so I guess its working well, its interesting this because now I know I dont want to get enough gold to buy a 10 mil rare weapon to only get an 10% DPS increase over my vanilla 1 hander... thanks, this thing really is awesome, hats off to you sir.
Ok thank you, I got the primary stat wrong(I put the weapon dps instead of intel lol) now its working. Only thing that is a bit off is my attack speed. For some reason I have 1.9 attacks per second, but in the spreadsheet it appears as 1,918, so in the spreadsheet my damage is boost a little bit(like more 500 damage out of 37k) so I guess its fine, cheers for the help this thing is awesome.
Ok I downloaded it, but Im having some trouble filling in the stats: Weapon Attacks per sec: in this one I put the base weapon speed which is 1,2 in my case Weapon +attack speed: in this one I also put 1,2 since my weapon has no inherent speed bonus, correct? Primary Stat: In this one I filled with the weapon DPSMin Weapon Damage: this one was min from weapon damage shown above attack speed of weaponMax Weapon Damage: same as aboveMin + Dmg: from OH and an ammyMax + Dmg: same as aboveCrit %: okCrit Damage %: okAttack Speed: put the same as the other above which is the weapon base speed(1,2)Bonus Damage %: I put 15% from glass cannon correct?+Attack Speed: in this one I put bonuses from rings, wrists, gloves= 58%, if the weapon had any shouldve I get it included?Weapon: 1 for yes and 0 for no? dont get this one sorry.
My DPS shown on the sheet is 27K but my DPS shown on the char screen is 37K, so I think I screwed up somewhere, Im not using force weapon btw, only glass cannon.
Interesting. There are so many times I wodner if I get a for example 900dps weapon with +100 int boost is it gonna be better than my 1000dps weapon with no boosts, but I just cant buy the weapon just to see if Ill get a damage boost(or if its negligible) so later I find out it wasnt worth it u know...
Rollback Post to RevisionRollBack
To post a comment, please login or register a new account.
PS: Im still using the spreadsheet(I think its the one you edited for the first time), and its working great for me, once you learn how to mess around with the numbers and all everything fits fine, and check with the in game changes. I dont use the EHP though cuz I have a rough idea and dont need it.
My DPS shown on the sheet is 27K but my DPS shown on the char screen is 37K, so I think I screwed up somewhere, Im not using force weapon btw, only glass cannon.
sorry about the color on the things lol