I figure this is as good a place to post this as any. I spent the last few days putting together a Tree druid spell rotation spreadsheet. I would first like to apologize for the bad layout, this is my first ever attempt at throwing together a spreadsheet, so please bear (or tree) -lol i made a funny- with me. The spreadsheet can be found on filefront here
. I am an excel novice so i will apologize in advance for any problems you encounter.
A couple notes, the command buttons on the far right control most every single raid buff situation I could think of; spread sheet reset, basic raid buffs (kings, BoW, imp DS, ect) full raid buffs (basic buffs +battle/guardian elixir, cooking, and oils) and the shaman button.
I consider this sheet only in beta, because there are a few known bugs, and a few other sections I am not sure I got the correct information. Please double check the Outputs to make sure it is consistent with what your hots do in game. I had to do some sloppy testing on the PTR to guestimate the spell coefficients, because when i tried the wowwiki ones, they were off big time so i tried to find them on my own.
One important notice, when you decide to change the spell rotation, make S*U*R*E the values in both the Big Six section, and the Rotation Input section are the same. The Big Six section is there so you can visualize your rotation, and the inputs section is there for ease of computing. A very common error is to change the Big Six section and leave the inputs alone and vice versa. The mana costs must also be correct. Except for the regrowth idol please enter the base mana cost of the spell, not the tree cost. If you use the regrowth idol, the mana cost should update on its own /crosses fingers.
This sheet doesnt contain any fancy gear/gem/enchants selection, and only a limited number of gear changes are taken into account. This sheet just exists at the moment to figure a spell rotation, and calculate how much healing it does, and how long you can cast it.
The "Outside regen" section is buggy, if you get that error on the sheet, ignore it as well as the command buttons relating to it. You can play around with it, and if you know your excel/theorycrafting, you can try to fix it, but the bugs will be pretty apparent.
The deal with that section is there was no way for me to know how many pots/procs/innervates, ect you were to recieve unless I already knew how long you were going to cast. Since this outside regen depends on how long you will cast, I had a problem. Outside regen meant more procs/pots, more procs/pots meant more casting time, more casting time meant more pots/procs and the circle continues.
In addition, the way the sheet handles innervate is wrong. For simplicity's sake, I just took the total OFSR mp5 regen and multiplied it by 16 (4 mp5 ticks of 4x regen) which is most assuredly not how innervate works, but I felt rushed because I had already spent a lot of time on it and needed to get it out.
If you have any suggestions, comments, corrections, or bug fixes please, please o please post them here, PM me on this forum, or contact me in game.