Elitist Jerks (http://elitistjerks.com/forums.php)
-   Druids (http://elitistjerks.com/f73/)
-   -   [Resto] TreeCalcs (http://elitistjerks.com/f73/t116144-resto_treecalcs/)

 Hamlet 02/02/11 3:11 PM

[Resto] TreeCalcs

Getting a thread going for this. Short post for now, probably more when I have time. Here's an update with some stuff I was tinkering with (all on the talents/tables page). It's not dressed up yet, just some new numbers, and in general I have to decide how to present everything.

These are the two things TC wasn't that great at analyzing:
1) Effect of changes in total mana pool on longevity.
2) Correlation between mana consumption and added healing.

Slourette had done some interesting math on (2) a little ways back in the Resto thread. He uploaded a version of the sheet with a whole added framework for total healing done over a fight of fixed length. I liked where it was going, but I was hoping not to have to add a bunch of new machinery to the sheet. I think what I have here works pretty well. Briefly, it varies the % spell usage of Nourish vs. Rejuv to see the effect on mana consumption and on HPS. From that it computes the HPS gain from added MP5, assuming you vary spell usage to hold mana consumption constant. I added another column next to the scaling factors for stats, for now, to show what happens if you take this into account. They're pretty similar to the "sustained healing" stat weights people have been throwing around.

For (1), I just compute the MP5 equivalence of increases in starting mana pool, based on the current time to OOM. Those values are currently added to the MP5 scaling factors for Int/Furor/HotW/etc.

I think this all pretty good, but I want to find a way to nicely present everything without adding more clutter to the page.

EDIT: Main version of the sheet always lives on the main guide here:
http://elitistjerks.com/f73/t110354-...6_a/#TreeCalcs

On the "Gear Setup" sheet, I'm getting Error 502 in all the equipment slots (i.e. A56). I imagine it has to do with using OpenOffice as a search brought up similar issues with this program in the Balance druid spreadsheet thread. Any solution to this, or do I need to hunt down a copy of Microsoft Excel?

 Hamlet 02/02/11 5:11 PM

I think there's a mostly-working fix in WrathCalcs right now. It should be moved to TreeCalcs as well once it's all done.

 Tecton 02/02/11 7:07 PM

Yeah, sorry guys, I'll get this updated with the OpenOffice stuff as soon as possible.

 Erdluf 02/03/11 9:20 AM

You shouldn't need to use tables for the HPS/MP5 computation.

For the HPS/MP5 you get by using extra mana to convert Nourishes into HT

HPS/MP5 = (HT_HPET - Nourish_HPET) / (HT_MP5 - Nourish_MP5)

Using HPET and MP5 values from the Rotation page, I'm matching your table results when I use HT or Rg fillers. I'm getting values that are slightly off when I use a Rj filler. I don't know why the Rj numbers don't match.

Edit:

For many (most?) resto's, Rejuv without symbiosis is more efficient than Nourish with symbiosis. If that is true for you, and if you are mana constrained (and have enough targets for Rejuv), you should only cast Nourish to refresh Lifebloom. The mana you spend on any other Nourish would be better to save for a Rejuv cast.

Otherwise, it is better to spend time not casting (bandage or melee). This shows up in column N of the main tab, where "Cast Delay" shows an increase in HPS.

 Hamlet 02/03/11 12:12 PM

Those are both good points.

The slight discrepancy with Rejuv is because is changing the Rejuv frequency changes Revitalize proc rate (and if I implement it, Nature's Bounty uptime). Not sure if that's worth having another table in there. It is only one table though.

The spell usage issue will be interesting as soon as the patch hits. Right now you barely have to stop casting Rejuv between trinketed MTT and the very low cost, so I don't think about this (esp. since I'm playing Balance most of the time). For now I'll just add in the new tech with the current model, but it shouldn't be too hard to adapt if we change the spell usage model in some way. It would very easy to change the filler option from "Nourish" to "do nothing." I could add in slightly more refined Rejuv/Rg/HT filler options too, but I figure most people are using HT/RG outside of Clearcasts so rarely that it's not worth trying to estimate.

I think I will have to add a third scaling column for everything, to give the "combined HPS+MP5" score, since I don't really want to eliminate either the current HPS or MP5 columns.

 Hamlet 02/03/11 1:22 PM

1 Attachment(s)
Update with the main page dressed up a little to take the above into account. I also change the individual spell stat scaling weights to something that might be more informative--it's raw HPET gain for each spell, with the user-input Mastery usage percentages taken into account.

 smallrabbit 02/04/11 8:31 AM

Quote:
 Originally Posted by Hamlet (Post 1858948) but I figure most people are using HT/RG outside of Clearcasts so rarely that it's not worth trying to estimate
From the view of 10 man hc encounters you really do often need to chaincast HT on tanks (at least with our setup) - so it would be a nice option for me, if you implement it.

Wyrmbraker is nealry pure HT spam in the beginning. Maloriak there are some situations where you need to HT. OK, Chimaeron is a special encounter to healers. Buton the encounter we are working on, Chogall, it's also necessary to use HT quite often.

 Nihlo 02/04/11 9:11 AM

Thanks for the Sheet, just two questions:

- to remove a reforgement from an item, I just choose nothing in the "into" box ?
- I sometimes receive 2x Dark Intent (the buff stacks), could you add this as an option in the buff-section ? Just curious about the new breakpoints then.
- Does "Innervate Someone eles" takes into account that you switch Ina with another Druid ? Or is this option missing ?

 lolofora 02/05/11 4:13 AM

Thank you again for this work!

I think there is problem on the ratio INT/MP5 (MAIN tab, O7)

Intelligence gives more mp5 than spirit?
+1 INT -> 1.08 MP5
+1 SPIRIT-> 0.66 MP5

In your formula, you have integrated "longevity", which explains this bizarre result.
Maybe he should add another column "longevity"next to MP5.

Personally column "Combined' isn't interesting information.

 Erdluf 02/05/11 12:41 PM

lolofora,

I agree that the short "time to oom" for the downloaded sheet means that the mana contribution from Int is overstated. However, since we don't have a lot of gearing opportunities to trade Int for Spirit (outside of trinkets) the error may not matter too much.

If you wanted to know the relative mana contribution of Int and Spirit on a five-minute fight, I think you can get good numbers by adjusting "casting delay" (M11 on the main tab) until OOM goes to five minutes (for the sheet as downloaded, casting delay = 0.32), and then hitting F9 so that tables get updated.

I argue that the "Combined" column is interesting

- It gives treecalcs a quantitative way to measure the relative value of mana and throughput.
- In LK, mana was more of a hard-cap stat. If you didn't have enough, it was the best stat. Once you had enough, it was worthless. In Cata, either statement is often false.

As an example, we can use TreeCalcs to determine how long a mana-constrained fight needs to be for Genesis to be better than Furor. I'd encourage discussions that improve that quantitative model. Even with flaws, I find that capability interesting.

 Hamlet 02/05/11 1:12 PM

Hmm, yeah, I should put some better gear in the default sheet. You do have to turn Rejuv frequency down to get reasonable longevity post-patch though, as Rejuv cost is going back up, WG expenditure is going up, and MTT gains are smaller. We'll have to use Nourish (or almost equivalently, nothing) a significant portion of the time. Until I change the model somehow, adding in some casting delay is a good way to simulate doing nothing, but it really changes very little from just casting Nourish.

I'll add in another option for 30% Innervates (swapping with another Druid), but other than that I can't think of any ways it's underestimating longevity.

 Nihlo 02/08/11 9:52 AM

just a small thing:
Stormrider's Handwraps - Item - World of Warcraft
are the resto-t11 gloves with spirit & haste

Stormrider's Gloves - Item - World of Warcraft
are the moonkin-t11 gloves with haste & crit

you probably just have to switch the names.

 qwweer 02/09/11 3:24 AM

It would be very nice if you added Dorian's Lost Necklace into TC gear list.

 Lilwyn 02/09/11 6:10 AM

Is it possible to add empty value to "Reforge from" combo boxes for all slots, as currently it's not possible to reset reforges? You can select empty value from "Reforge into" combo box but stat you are reforging from will still be reduced.

All times are GMT -4. The time now is 11:22 PM.