Backgoode

The tauren racial appears to be calculated off 8121 health instead of 7941. Also, I can't seem to figure out how to get the blacksmithing sockets for gloves and bracers to appear without manually adding them myself. Is there something I'm missing?

 

◊ Diabhalta

Is there an excel version with macro's? Am I blind and not seeing it?

 

Thorgrim

[Fireproven Gauntlets] also received an upgrade in 3.0.8.

 

Taliafears

Doh, I forgot to add the blacksmith gem sockets back in. Putting them back in now. Tauren health should be calculating off of 7941 though, where are you seeing a discrepancy?

Thanks for the heads up on the Gauntlets, Thorgrim.

Diab, there's no excel version with the macro. OpenOffice can't seem to save a macro that works in excel, and I only have access to excel at work, so it's going to be too annoying to maintain all three versions into the future.

Please note that 1) OpenOffice is free for anyone, just visit OpenOffice.org and 2) the only macro is for sorting the gear lists, it's not necessary for the sheet to function. Also, OpenOffice users, note that the macro-less Excel version will work just fine for you if you happen to be annoyed by the macro warning.

 

Backgoode

Sorry, I wasn't clear. The sheet does calculate off of 7941, but in game the bonus is calculated from 8121. If you notice, the health you get from stam on your character sheet isn't what you would expect from the amount of stam you actually have. When naked, I have 170 stam talented, and I get 1520 health from it. So the first 18 are considered "base" for the calculation of the tauren bonus.

 

◊ Diabhalta

Cool, will download open office then. Thanks again for all your good work.

 

Taliafears

Uploaded a new version. Here are the changes:

- updated Tempered Titansteel Helm to 3.0.8 version, it's now extremely nice
- changed miss cap to 16, per Whitetooth's latest research, thanks Whitetooth!
- updated Fireproven Gauntlets
- added blacksmithing gem sockets back in
- updated gem handling to prevent errors when a socket is left empty
- added 25man version sarth (without shadron/vesperon)
- fixed AEP calculation for Eternal Earthsiege
- doubled magic damage during burst DPS, to keep in line with physical dps not being avoided during a burst
- fixed large bug with the decision on whether to break socket bonus
- fixed bug with sorting macro in openoffice 2

 

janaka

Thanks for this great spreadsheet that i'm using for quite a while now.

With former versions, i used a second copy of the sheet to put together a threat/tankdps set... would it be possible to allow custom boss profiles and burst/ttl/threat/dps weights again?

 

Taliafears

You can mess with the boss profiles and the stat weights on the Boss sheet. I have it hidden to keep it out of the way, but you can show it with Format -> Sheet -> Show -> (choose "Bosses").

 

janaka

Ah, great, thank you.

AC seems to be rated much to high with low TTL/burst and high threat/dps weights.
I chose Sarth25 and set TTL and burst weights to 0.05 each, and dps weight to 0.9. Yet [Cloak of the Shadowed Sun] is rated above [Platinum Mesh Cloak], for example. I don't hink AttT is THAT good.

Another thing i just noticed is that Elixier of Mighty Defense is not added to the DEF value on the Equip sheet - the calculation in Equip.I70 seems a little off.

 

Jayde

Platinum Mesh cloak is probably around 40-45 less AP raid buffed and less block value... so I think it would depend on one's total hit% as to if it pulled ahead or not. At low hit% values, it probably is a little better in terms of DPS. (But we're only talking about 18 DPS or thereabouts.)

I would guess that even, depending on the other settings, putting the TTL/Burst figures to 5% each could be enough to offset the small DPS contribution vs. the survivability difference on the two items. But it really depends on many factors such as the incoming damage and your pre-existing DPS stats.

 

janaka

Humm, well, was maybe not the best example. Another one: [Keystone Great-Ring] ranks above [Unsmashable Heavy Band], and it still does if i set TTL and burst to 0, and dps weight to 100%. Thats 6 AP vs. 11 Str + 40 BV.

With 100% dps weight, AP should be set to 60 AEP (because you need 60 Armor for 1 AP with AttT) and the other threat/dps stats accordingly, but they're not. Of course this would result in ridiculously high numbers. Dunno.

 

Taliafears

That does seem a little funky janaka, I'll take a look at it with DPS set high.

 

Taliafears

Looks like the weight for armor was hard-coded to 1 on the GearList sheet instead of parroting the derived value on the Stats sheet. Made sense when the sheet was all based on armor, but when I made it possible to be AP-relative, I should have updated this.

Also keep in mind that the sheet I published has hit and expertise values being overridden, so if you change to a heavy TPS/DPS weighting, you'll want to nix those overrides.

 

Taliafears

I don't think anyone is confused, but a couple notes:

When the sheet says DPS it means DPS *while tanking*, not while someone else is tanking. Also, the cycle decision is still made based on TPS, and I don't have any serious DPS cycles in there (which would include concussion blow and shockwave, most likely). These are both things I want to improve on.

 

janaka

Yeah, i did that. Btw, just out of curiosity, what made you come up with those overrides for Stamina and Defense?

 

Taliafears

I just felt like adding a point to Stamina, let's just call it intuition.

Defense is a big issue with any stat weighting system because it has this huge shift in value as soon as you hit 540. Any gear set you enter on the Equip sheet is probably going to be at 540 if you're currently using it, but the sheet could then show you a piece of gear that LOOKS like an upgrade, but that drops you under 540. My current solution is to just add 25% to the value of defense. It seems to work, but it's terribly ballpark.

You may just want to remove the override, equip all the highest rated gear, and then start switching out items with higher defense until you reach 540. That way might not be perfect either, but it works for the most part.

 

Taliafears

I also found the issue you brought up with the flask, janaka, thanks. It looks like none of the consumables were being counted on the Equip sheet.

I appreciate these reports folks, I suspected I'd break a lot of things when I moved things around so drastically, but it seemed necessary to keep the sheet from becoming even more messy over time. Hopefully with your help we can get all this stuff cleared up in short order.

 

janaka

You might want to add [Grim Toll]and [Mark of Norgannon].

Do you plan on adding more boss profiles? I could look through our wws logs, if that would help. Or if you need any other assistance, please let me now.

 

Taliafears

Uploading a new version momentarily. This will likely be the last version without announced 3.1 changes. Here's the list:

- added glyph of Devastate, with the relatively new info that it increases long-term devastate threat
- fixed a bug where buff foods and elixirs/flasks were not being counted on the Equip sheet
- updated the value of armor on the GearList sheet when the sheet switches to an AP-relative weighting
- added 3 new buffs, 3% damage from ferocious inspiration (or ret paly), 3% crit from master poisoner (or ret paly), and 2% phys
damage from savage combat (or arms warr)
- added mixology bonuses to flasks and elixirs if alchemist (many are guesses)
- added Concussion Blow back to appropriate cycles, since it's back off the GCD

 

janaka

Ok, you didn't ask for it... but i wanted Malygos25 in that sheet, so i looked through my last WWS log.
For what it's worth, these are the numbers i got:

DPS 14750
Speed 2.5
MagicDPS 1100


Edit: Also I'm pretty sure Malygos doesn't parry-haste, after i checked the logs for it.

 

Taliafears

Good info, thanks!

I put it in as .35 TTL and .45 Burst, like Sarth, and Tempered Titansteel Helm starts sorting very near the top with that massive stam itemization. I wonder if it'd be worthwhile to have one with the -2% spell damage meta, handy for switching in for malygos/sarth+3 or other heavy magic damage encounters.

 

janaka

Personally I set it to .2 TTL, .3 Burst and .5 Threat, since it's the only fight that really challenges me on threat.
But i guess that a lot up to personal taste.

 

crazyivan

Forgive my newbness, but where are you changing these parameters? The intro sheet references an options sheet. However, when I open the spreadsheet in OO 3.01, the only sheets that I see are Intro, GearList, Talents, Equip, Buffs, and Stats. I've tried opening the excel only version (in Excel) as well with the same result. Am I just blind or are there some sheets missing?

 

Ayekaramba

There are some hidden tables which can be re-shown via an option in the menu.