Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Druids

Reply
 
LinkBack Thread Tools
Old 07/29/11, 5:28 PM   #241
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
You're not reforged optimally in the 2T11 sheet--the chest doesn't have haste on it. This is particularly important because 90 more haste from that reforge would put you over the 2322 breakpoint. Only one of the sets having that breakpoint was part of the discrepancy before. Once you change that the 2T11 is slightly ahead.

In general though, that they're this close isn't that surprising--the 2T11 is very weak (~250 DPS). These days a one-tier upgrade in one slot can typically be worth 150-200 DPS. The chest upgrade you're looking at here is only half a tier, but you're also swapping crit for haste, and the way you had it, you were picking up a DoT tick.

e: whoops, ignore the breakpoint comments, just noticed you don't have DI. The rest is the same though--6ilvl upgrade with an improvement in secondary stats it basically worth around as much the set bonus.

Last edited by Hamlet : 07/29/11 at 5:38 PM.


United States Online
Reply With Quote
Old 07/29/11, 9:33 PM   #242
Bloodfeud
Glass Joe
 
Tauren Druid
 
Lightbringer
Was coming back to post exactly that -- was looking at it more closely and realized there are two ways to get to 1742 hit/spirit with the T11.5 setup and I was using the wrong one.

My thanks for the speedy reply, wish I had been able to get back before I spent half an hour doing the reforge math (had time but no Internet access).

Offline
Reply With Quote
Old 08/03/11, 5:43 AM   #243
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
Fixed belt buckles and gems updating from battle.net properly, and spotted that tailoring leg enchants hadn't been allowed for (the sheet just adds them as the regular leg enchants now, but it's the same stats). I'll be adding the battle.net import to Treecalcs this weekend, so if you've spotted anything else that's not quite right, please let me know.
Attached Files
File Type: xls WrathCalcs 110803.xls (1.02 MB, 154 views)

Scotland Offline
Reply With Quote
Old 08/05/11, 11:14 AM   #244
LordAnxiety
Glass Joe
 
LordAnxiety's Avatar
 
Tauren Druid
 
Forscherliga (EU)
I don't know if this is a bug, but for me the Talent tree parsing doesn't work. Maybe this is because you didn't implement it at this time.

I running Microsoft Exel 2007 on Win7 with all updates.

Germany Offline
Reply With Quote
Old 08/05/11, 12:15 PM   #245
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
Originally Posted by LordAnxiety View Post
I don't know if this is a bug, but for me the Talent tree parsing doesn't work. Maybe this is because you didn't implement it at this time.

I running Microsoft Exel 2007 on Win7 with all updates.
Resolved, thanks! Fixed version enclosed.

Current issues: 64 bit Excel apparently doesn't work with the method I'm using for storing the armory info, I'm looking into it. Also, some more unusual characters aren't being caught by the internet encoding I'm doing, so I'm also looking into resolving that.
Attached Files
File Type: xls WrathCalcs 110805.xls (1.02 MB, 95 views)

Scotland Offline
Reply With Quote
Old 08/05/11, 12:50 PM   #246
LordAnxiety
Glass Joe
 
LordAnxiety's Avatar
 
Tauren Druid
 
Forscherliga (EU)
Jup thats works for me now

Another thing that I always discover is that I have to change most of the Booleans in "Main" sheet.

To explain the Problem:
I m German and therefor I using the German version of Exel. The Problem is that all the functions are translated to German and Exel only know the translation. The function are translate correctly so I see the German names, but with the Booleans there are is a problem.
The only boolean works is Main!K25 the Sinestra one, which is displayed in all Version correctly as "Falsch" (German for false). All other are displayed with the English names. Thats cause that my Exel cannot calculate the DPS and Time to OOM.
So I changed them (the Dropdown menus shows the right language) and then everything works.

So all in all only a very very little problem. But maybe you know whats happen and it doesn't take much time to change it.

Germany Offline
Reply With Quote
Old 08/05/11, 1:20 PM   #247
MoonslayerLB
Glass Joe
 
Night Elf Druid
 
Lightning's Blade
Battle.net armory import function is very nice, thank you for the update.

as an aside, is it generally better to look at a non-haste-breakpoint-inflated value of a gear piece when considering upgrades?
or is it one of those mileage-will-vary situations?

Offline
Reply With Quote
Old 08/05/11, 4:25 PM   #248
 Tecton
Soda Popinski
 
Tecton's Avatar
 
Troll Druid
 
Mal'Ganis
Originally Posted by LordAnxiety View Post
Jup thats works for me now

Another thing that I always discover is that I have to change most of the Booleans in "Main" sheet.

To explain the Problem:
I m German and therefor I using the German version of Exel. The Problem is that all the functions are translated to German and Exel only know the translation. The function are translate correctly so I see the German names, but with the Booleans there are is a problem.
The only boolean works is Main!K25 the Sinestra one, which is displayed in all Version correctly as "Falsch" (German for false). All other are displayed with the English names. Thats cause that my Exel cannot calculate the DPS and Time to OOM.
So I changed them (the Dropdown menus shows the right language) and then everything works.

So all in all only a very very little problem. But maybe you know whats happen and it doesn't take much time to change it.
I'll need to figure something out for that, then. Thanks for the input!

Scotland Offline
Reply With Quote
Old 08/05/11, 4:25 PM   #249
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Originally Posted by MoonslayerLB View Post
Battle.net armory import function is very nice, thank you for the update.

as an aside, is it generally better to look at a non-haste-breakpoint-inflated value of a gear piece when considering upgrades?
or is it one of those mileage-will-vary situations?
In general it doesn't matter since haste is the top secondary stat anyway. In the occasional case where it matters, just compare the pieces in the exact situation you're in rather than trying to come up with an general stat value. The exact value of haste is basically always situation-specific due to breakpoints.

For example, look at my gear now--I have [Valiona's Medallion] equipped over [Heartstone of Rhyolith] in order to get up over 2322 haste.


United States Online
Reply With Quote
Old 08/06/11, 3:39 PM   #250
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Slight change to DoT rounding and fixed name of Cindersilk Gloves.

(Also, keep importing Hamlet before uploading, makes it much easier for me to pick up new version and tinker :P ).

e: didn't put the rounding change (see here: http://elitistjerks.com/blogs/1152-h...points_update/ ) into the breakpoint table. With 3/3 Genesis, there are no even-numbered breakpoint where it comes up.
Attached Files
File Type: xls WrathCalcs 110806.xls (1.01 MB, 87 views)

Last edited by Hamlet : 08/06/11 at 3:48 PM.


United States Online
Reply With Quote
Old 08/06/11, 7:28 PM   #251
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Note: rename Mindweb Staff to Funeral Pyre.


United States Online
Reply With Quote
Old 08/06/11, 10:29 PM   #252
LordAnxiety
Glass Joe
 
LordAnxiety's Avatar
 
Tauren Druid
 
Forscherliga (EU)
Originally Posted by LordAnxiety View Post
Jup thats works for me now

Another thing that I always discover is that I have to change most of the Booleans in "Main" sheet.

To explain the Problem:
I m German and therefor I using the German version of Exel. The Problem is that all the functions are translated to German and Exel only know the translation. The function are translate correctly so I see the German names, but with the Booleans there are is a problem.
The only boolean works is Main!K25 the Sinestra one, which is displayed in all Version correctly as "Falsch" (German for false). All other are displayed with the English names. Thats cause that my Exel cannot calculate the DPS and Time to OOM.
So I changed them (the Dropdown menus shows the right language) and then everything works.

So all in all only a very very little problem. But maybe you know whats happen and it doesn't take much time to change it.
Again back to that topic:

I discovered in the new versions from Hamlet (20110806), that WrathCalcs is broken, but TreeCalcs (20110806) (again with the broken macros and broken talent saving), shows correct translated Booleans and give me a calculation. I don't remember than this Problem occurs first, but I'll give a look into it, to give you a more details.

The Edit means that I should only edit this article:

Searching now through the whole topic and found where the thing occurs first:
The last Version where everything is alright is: WratchCalcs 20110505b PTR which you find in this post: [Balance] WrathCalcs
The next file WrathCalcs 20110510 PTR is then broken first. You'll find it here: [Balance] WrathCalcs

At a deeper look into the file I see that in "Profiles" sheet only the Booleans from the Hamlet saving is broken. The Tecton saving is alright. That's what I discover then first on the life versions.

Hopefully that helps you a little bit more.

Another Edit again: I really don't think this is a very important bug, but maybe a notice in Guide would be cool, because I get yesterday a whisper from another Druide from my server because he didn't see a problem in the wrong language. So maybe a bug entry maybe help some of the people.

Last edited by LordAnxiety : 08/07/11 at 9:56 AM.

Germany Offline
Reply With Quote
Old 08/07/11, 4:51 PM   #253
Varuljin
Glass Joe
 
Varuljin's Avatar
 
Troll Druid
 
Forscherliga (EU)
Originally Posted by LordAnxiety View Post
Another Edit again: I really don't think this is a very important bug, but maybe a notice in Guide would be cool, because I get yesterday a whisper from another Druide from my server because he didn't see a problem in the wrong language. So maybe a bug entry maybe help some of the people.
Man, who actually thinks about that Excel is stupid enough not to translate FALSE and TRUE to the right german phrases! :P

And to note that: The "latest" Hamlet version in the main balance thread (07.07.2011) works good when it comes to the right dps output. Strange though

Germany Offline
Reply With Quote
Old 08/07/11, 8:37 PM   #254
 Hamlet
<Druid Trainer>
 
Hamlet's Avatar
 
Tauren Druid
 
Mal'Ganis
Is the problem that versions Tecton saved in Excel for Windows translate correctly and versions I saved in Excel for Mac don't?


United States Online
Reply With Quote
Old 08/07/11, 11:02 PM   #255
LordAnxiety
Glass Joe
 
LordAnxiety's Avatar
 
Tauren Druid
 
Forscherliga (EU)
Well I don't think so. Because in the 20110707 as I take a look into the "Profiles" sheet. Again the same: Tecton works. Hamlet and Hamlet T12 have the wrong translation. As I load them Exel doesn't know that these are booleans and doesn't translate them.

Last edited by LordAnxiety : 08/07/11 at 11:19 PM.

Germany Offline
Reply With Quote
Reply

Go Back   Elitist Jerks » Class Mechanics » Druids

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
[Balance] Theorycraft / Spreadsheet Thread (WrathCalcs) Hamlet Druids 0 06/30/10 7:36 PM
TreeCalcs: WrathCalcs, respecced Hamlet Druids 42 02/04/10 3:31 PM
WrathCalcs - Moonkin DPS Spreadsheet Adoriele Druids 93 06/09/09 6:37 PM