7/9/2012 7:40:43 AM
My full Barbarian calcution spreadhseet - calculates and compares DPS, EHP and Upgrade paths based off your gearposted a message onThanks for the feedback. Sorry I've not been around the past few days. I'll see if I can work out the %damage multiplier dps more accurately over the next couple of days.Posted in: Barbarian: Bastion's Keep
7/4/2012 5:54:02 PM
It's very possible to clear inferno with a low budget as a barbarian. If you need help learning what's good to get, watch zraves video here.Posted in: Barbarian: Bastion's Keep
7/4/2012 2:12:15 PM
My full Barbarian calcution spreadhseet - calculates and compares DPS, EHP and Upgrade paths based off your gearposted a message onPosted in: Barbarian: Bastion's KeepQuote from Tsueah
I'll try it out in a minute, thanks for your efforts
Another suggestion: would it be possible to add the value of +Dmg to the Upgrade paths?
I see that damage on rings / amulets is greatly undervalued by many players and I would really like to know how +dmg works out!
€dit: no problem downloading the spreadsheet. After converting to excel '10 I simply copied values from the old sheet to the appropriate rows/columns - working flawless till now :)
Dps Ingame: 34502
Dps Sheet: 34592
I guess this can be simple rounding errors, on which side ever. Pretty accurate though!
If you're dual wielding, that's to be expected. If your weapon has a +% damage mod on it, that might be the cause, as the weapon dps might be slightly miscalculated. If neither of these are the case, unequip and reequip your weapon, make sure you have not follower and have another check. If it's still off can you tell me the passives/toggles you're using along with your weapon stats. If this is a bug that I can resolve I'd love to patch it up.
I'll also add +damage to upgrade paths in a future version. Currently I'm trying to figure out how best to lay out the EHP upgrade paths so as not to disrupt the flow of working with the sheet.
Thanks for the feedback!
7/4/2012 10:01:39 AM
My full Barbarian calcution spreadhseet - calculates and compares DPS, EHP and Upgrade paths based off your gearposted a message onVersion 1.12 Released.Posted in: Barbarian: Bastion's Keep
Fixed cold resistance bug.
Added more options for enchantress and streamlined War Cry.
Added Battle Rage calculation
Added option to calculate dodge as part of your EHP.
Added 2 more comparison tables and 2 more gear sets.
Added Life on Hit and Life Regen columns to calculate an approximate EHP gain per second while in combat.
Spreadsheet now displays your Dodge chance, Block Chance and Crit Damage modifier. (% damage increased by your crit chance and crit damage)
Edit: Some minor bugs in Battle rage calculation became apparent in conversion. I am fixing them on the live version currently.
Edit2: Battle Rage has now been fixed.
Quote from Tsueah
Nice spreadsheet, some macros to copy over the gear sets into other pages would be great
And maybe a third gearset for comparison reasons
Keep up the good work!
There shouldn't be any problem with copying and pasting selections of input data over the old values, so long as you line them up correctly.. If there is, let me know.
7/4/2012 8:42:15 AM
Thanks for the bug report Tsueah. I'll fix that momentarily. It seems to be taking the value from the Fire Res column.Posted in: Barbarian: Bastion's Keep
7/4/2012 7:41:35 AM
Posted in: Barbarian: Bastion's KeepQuote from vHatch
Thanks for this, been wanting to use one of these for my Barb like I did on my Wizard. Couple thoughts:
- How accurate should the damage be? The spreadsheet is showing 17810 damage, but the game shows 17977. I've checked my numbers several times and I can't find any error.
- An option for Battle Rage (Maurauders) is lacking.
- Enchantress has a 3% attack speed buff that isn't accounted for.
- Is an EHP in the millions accurate for someone with 60k hp?
- EHP upgrade paths would be nice too (EHP per armor/all-resist/vit)
Damage is accurate. If you're single wield and the damage is off, unequip and re-equip your weapon. This is an ingame bug. If it's still off, then check your stats are input correctly. If there's still a problem it may be down to a bug that I've not come across involving hidden stats on rings and amulets that cause additional damage on the ingame sheet.
Duel wield damage is currently slightly off due to rounding on the ingame character sheet. I've been unable to track this down but I'm of the opinion that the ingame dps displayed is incorrect and that mine is more accurate. I may be wrong but the difference should simply be noted before making any upgrade purchases.
Battle rage with Marauders, Other Rune and None options has already been added to my WiP sheet. It will be available in the next version. This was a simple oversight on my part as I don't use Battle Rage.
Enchantresses attack speed buff also has differences to the ingame description. simply adding 3% ias or 3% asi will bring up incorrect numbers. This is why the enchantress toggle is labelled as beta, until I can come up with an accurate formula to calculate the enchantresses boost to dps.
EHP calculation is spot on to the best of my knowledge. I've done some testing using a number of DoT's and armour/resist setups and have found the results to be as predicted. I.E 50% increase in calculated EHP gives about another 50% time to live ingame. Superstition is also accurate to the best of my knowledge but I need to test this further. EHP in the millions is certainly accurate for 60k hp. The stats and relatively low resists displayed in the table already are approximately 66k hp, 320 base resists and 7k base armour with over 1m EHP, factoring in the 30% innate reduction for melee characters, this isn't hard to achieve.
Thank you for your feedback, I hope this has cleared things up a little for you.
7/3/2012 7:06:56 PM
Thanks for the feedback. That's a good idea, I'll implement that in V1.2.Posted in: Barbarian: Bastion's Keep
7/3/2012 4:41:54 PM
I'll look into the scripting options for cross sheet data copy. I'll add a third and forth sheet in the next update, along with battlerage and a couple of code cleanups.Posted in: Barbarian: Bastion's Keep
7/3/2012 9:22:33 AM
Version 1.1 is now released. Made some significant Layout changes that should hopefully make it a bit easier to use. Also added a lot of passive functionality and options to more accurately reflect results. Gear comparisons are now on separate sheets.Posted in: Barbarian: Bastion's Keep
Version 1.11: Fixed a bug that was causing copies of the spreadsheet to have non-working formulae.
7/3/2012 4:31:01 AM
Irghen: Dex and dodge along with Block% aren't considered because of the random nature of the stat not truely adding to your EHP. I also don't know the attack roll system used by this game and because of the lack of addon support, I'm unable to gather a large enough sample sizes of blocks, dodges and hits to work it out for myself.Posted in: Barbarian: Bastion's Keep
Henny, what is it in particular you're having trouble with? I'll work on making the spreadsheets more user friendly shortly.
- To post a comment, please login or register a new account.