Archived

This topic is now archived and is closed to further replies.

Paininabox

Resto Spreadsheet

69 posts in this topic

I don't know what I'm doing wrong but neither Firefox nor IE7 wont show any "Start Download" something to me =(

Share this post


Link to post
Share on other sites

Hi, thank you for the spread sheet for starters.

This is the first time I have attempted to use one, and I have found gear missing from the spread sheet.

Perhaps I am doing something wrong?

A good example would be:

Illustration of the Dragon Soul - Item - World of Warcraft

It is late for me, so I will continue to research further on this matter at another time.

I look forward to any help you may give me.

Thank you.

Share this post


Link to post
Share on other sites

Yes, I'm aware that there is quite a bunch of missing gear, particularly the trinkets and 3.2 gear. In the meantime, though, you can use the extra row to punch in your gear stats.

Has anyone looked at updating this to current game mechanics?

Well, the only thing the sheet is not updated on is the gear database and the ET change to nourish, so it's not like it's completely broken. There's also those extra rows to help you out, too. I'd really like to get back into developing this, so we'll see.

Share this post


Link to post
Share on other sites
Well, the only thing the sheet is not updated on is the gear database and the ET change to nourish, so it's not like it's completely broken. There's also those extra rows to help you out, too. I'd really like to get back into developing this, so we'll see.

I think it also needs updates for 3.2 replenishment and lifebloom-bloom.

Share this post


Link to post
Share on other sites
I think it also needs updates for 3.2 replenishment and lifebloom-bloom.

Ah yes, I forgot about that, thanks for the reminder.

Share this post


Link to post
Share on other sites

Version 1.4 is out. It includes a rebuilt statweighting system that Allinone used on his stat weights post, a rebuilt MRVD and HPVD algorithm to be faster/more accurate, updates to the databases, and compatibility fixes for 3.2. I also went through and updated the mp5 values on items throughout the databases, and lots of little things. As there is a lot going on in this update, please let me know if anything breaks or is inaccurate whether through my e-mail (paininabox@gmail.com), private message, or in this thread.

My plan for the next update is to zero in on the wonderful world of trinkets, as well as batter out any kinks left in getting accurate stat totals between wow and the sheet (round less, blizzard). If you have any feature requests or suggestions, please let me know.

Download link will be in the first post and in my sig.

Share this post


Link to post
Share on other sites

Would it be possible to add the possibility to remove colums from the spreadsheet since I tend to add a sum column to the Gearlist tab after MRVD/HPVD colums. I add the column to make it easier to see which item is of a higher total value. Even though the sum value doesnt always tell the truth so to say, it does make it easy to just glance the column and see which items are possible upgrades.

And why I ask one should be able to remove a column; if you add colums to random places the recalculation does bug .. at least on my excel. And sometimes I happen to save the sheet by accident with the sum column in there.

Btw, is it just on my excel or can't you sort the columns on Gearlist tab with neither Ascending nor Descending methods.. Says that the sheet is protected etc. I can filter the columns with "Wrist" in Slot column for example but cant use the mentioned sort methods..

Not big problems but if these dont need much work at least I would appreciate these to be "corrected".

Share this post


Link to post
Share on other sites

No, it's not possible to remove columns from the Gearlist since, as you have pointed out, it breaks the MRVD/HPVD calculation procedure. The best way would be to append your custom column after everything else. I'm putting out a quick update so that the gearlist can be sorted (which will allow you to add a column if you want, provided it's at the end) and I added the Vestments of the Blind Denizen.

Share this post


Link to post
Share on other sites

Hey all. I believe I've noticed a glitch with the spreadsheet. The Runed Cardinal Ruby (epic spellpower gem) seems to have the wrong spellpower coefficient in the gem list. It's listed as 25sp and in game it manifests as 23. The gem list seems to be password protected and I can't manage to change it.

This spreadsheet is invaluable to me and the rest of my resto druids. Thank you so much for working on this!!

Share this post


Link to post
Share on other sites

So, I reformated a while back and don't Office installed and went with Open Office. Alot of features are not working such as recalc button for HPVD. I will install office later to fix that for my self just a warning to your possible users.

Also, I was wondering how I add the new Idol. I dont see a spot for them any where that is visable and I'm afraid im going to mess up calculation if I try to add it.

Idol of Flaring Growth

Also, I read what you said about trinkets, but I thought I would request these being added as they are very popular with the druids. 90% of the druids you inspect will be wearing atleast one of them.

Spark of Hope

Sif's Remembrance

Solace of the Fallen

I Absolutely love the work you have done. Thank you.

__________________________

Xeo - Hard Mode Resto Druid

Share this post


Link to post
Share on other sites
I ran some testing and it looks to me as if Glyph of Nourish bonus is additive (not multiplicative) with the 20% bonus from having a HoT on the target.

Rawr Incident Report

That wouldn't surprise me, but I recall that when I was originally coding the spreadsheet that I did use it additively and for some reason I switched it around. I'll look over it sometime in the next couple days, thanks for the heads up.

@el-es-dee

Yeah, I'll get some support going for those trinkets in the next version, or that's the plan anyway. As for the idol, I'm not sure how I'll handle that but since it's going to be the new staple I'll be sure to do something for it as well.

@xanibear

Thanks for the heads up, I'll get that corrected. In the meantime you can add a -2 on the extra row of every piece of gear you have using a cardinal ruby. It'll skew the accuracy a bit on the gearlist calcs, but it's probably small enough that it's unimportant considering the degree of error undoubtedly on those calculations anyway.

Share this post


Link to post
Share on other sites

Thanks for the Update Pain. You know I love this tool.

I know you haven't messed with set bonuses in the past, but do you think it would be worth it to work in an option to allow for Rejuv Crits? Rejuv crits completely chance the face of our gear weight scaling. I estimated them but I for one would like a solid mathematical number to back it up. It could be as easy as adding another row in the stat weight sheets saying (T9 4P bonus?), so you wouldn't have to chance the spreadsheet dramatically, simply the rejuv calculation, with a simple (0,1) modifier for crits.

Share this post


Link to post
Share on other sites
Thanks for the Update Pain. You know I love this tool.

I know you haven't messed with set bonuses in the past, but do you think it would be worth it to work in an option to allow for Rejuv Crits? Rejuv crits completely chance the face of our gear weight scaling. I estimated them but I for one would like a solid mathematical number to back it up. It could be as easy as adding another row in the stat weight sheets saying (T9 4P bonus?), so you wouldn't have to chance the spreadsheet dramatically, simply the rejuv calculation, with a simple (0,1) modifier for crits.

Yeah, I agree with you. I want to add set bonus support to the spreadsheet, particularly t9. However, I haven't decided whether I would like simple checkboxes that the user ticks when they have it or to have the sheet find out for itself. Past that, I need to simply find the time to work on it. I want to get trinkets working, set bonuses going, and other things. Unfortunately, I'm also forced to rewrite the gearlist calcs (again) to optimize them a whole bunch. Rest assured it's on the to-do list, but I need to find an open time slot to do it first.

Share this post


Link to post
Share on other sites

[iTEM]47857[/iTEM] (the L232 version) changed in 3.2.2, got a 2nd blue socket and stats got reduced.

+60 Stamina

+66 Intellect

Blue Socket

Blue Socket

Socket Bonus: +7 Spell Power

Durability 70 / 70

Requires Level 80

Item Level 232

Equip: Improves critical strike rating by 60 (1.31% @ L80).

Equip: Improves haste rating by 52 (1.59% @ L80).

Equip: Increases spell power by 86.

I tried changing that myself in the spreadsheet, but it seems my Excel 2007 is a bit picky about certain things in the sheet. The moment I save it in old compatibility mode it whines about certain errors and stuff which will not get saved. Afterwards recalculating the gearlist throws up debugging errors. If I get bold and try to save it in the new (xlsx) format it even gets worse, Execel telling me that certain ranges are not to some standards and got renamed and afterwords nothing is working (telling me I might have to change vba code accordingly).

Anyone else managed to save this in Excel2007?

Share this post


Link to post
Share on other sites
I tried changing that myself in the spreadsheet, but it seems my Excel 2007 is a bit picky about certain things in the sheet. The moment I save it in old compatibility mode it whines about certain errors and stuff which will not get saved. Afterwards recalculating the gearlist throws up debugging errors. If I get bold and try to save it in the new (xlsx) format it even gets worse, Execel telling me that certain ranges are not to some standards and got renamed and afterwords nothing is working (telling me I might have to change vba code accordingly).

Anyone else managed to save this in Excel2007?

So you have problems when you try to change it and save it or when you try to save it only?

Share this post


Link to post
Share on other sites

First off, thanks for the work that went into this.

I'm new to using a tool like this to plan my toon so go easy on me please.

Am I missing something or is the list of enchants/inscriptions hidden and uneditable? I ask because my head and shoulder inscriptions as well as my chest enchant are not listed. Id gladly add them myself but cant find where to do so.

edit:

Im using it in office 07 with no problems.

Share this post


Link to post
Share on other sites
First off, thanks for the work that went into this.

I'm new to using a tool like this to plan my toon so go easy on me please.

Am I missing something or is the list of enchants/inscriptions hidden and uneditable? I ask because my head and shoulder inscriptions as well as my chest enchant are not listed. Id gladly add them myself but cant find where to do so.

edit:

Im using it in office 07 with no problems.

Everything that you select from a drop down menu on the gear and buffs tab is indeed hidden and not editable. Use the extra row and you can input the stats of the enchants that are missing from the drop downs.

Share this post


Link to post
Share on other sites

I am somewhat confused about the data on the statweights page. It seems to me that the table describes how much each spell benefits from each stat. I was under the impression that WG and Rejuv scaled best with SP, since they have large spell coefficients (not per tick, but per cast). I am getting something around 0.2 for the (Rejuv,SP) entry, but 1.42 for the (Nourish,SP) entry. I am not sure where this 0.2 came from, since I get around 0.65/tick or 3.88/cast as an increase of healing done from 1 SP. I noticed that the (% of casts chained) effects this value, but only slightly. Just wondering what this value means and how it is calculated.

Stats

Int: 1263

Spirit: 1503

SP: 3128

Crit: 15.59%

Haste: 13.48%

I am currently trying to calculate my new stat weights after getting my 4P T9, specifically regarding crit vs haste. If this change in the value of crit is small, haste may still be better (after soft cap) especially for someone who uses nourish a lot, since nourish scales much better with haste than with crit. If the change is large and crit is better, then I should try to trade all of my haste over the haste cap with crit.

Share this post


Link to post
Share on other sites
I am somewhat confused about the data on the statweights page. It seems to me that the table describes how much each spell benefits from each stat. I was under the impression that WG and Rejuv scaled best with SP, since they have large spell coefficients (not per tick, but per cast). I am getting something around 0.2 for the (Rejuv,SP) entry, but 1.42 for the (Nourish,SP) entry. I am not sure where this 0.2 came from, since I get around 0.65/tick or 3.88/cast as an increase of healing done from 1 SP. I noticed that the (% of casts chained) effects this value, but only slightly. Just wondering what this value means and how it is calculated.

That number is the hps increase from 1 point of that stat for each spell. Since rejuv's healing is spread out over 17 (before 3.3) seconds, it doesn't scale quickly hps-wise though it does scale quickly healing volume wise.

Please be aware that the spreadsheet doesn't currently support set bonuses, so crit won't get the proper rating that it would with 4pt9.

Share this post


Link to post
Share on other sites
That number is the hps increase from 1 point of that stat for each spell. Since rejuv's healing is spread out over 17 (before 3.3) seconds, it doesn't scale quickly hps-wise though it does scale quickly healing volume wise.

Please be aware that the spreadsheet doesn't currently support set bonuses, so crit won't get the proper rating that it would with 4pt9.

I think that the stat weights would be more accurate if you used Healing per second cast time instead of healing over duration of the HoT. Sure the HPS of one rejuv is healing (let's say 15k) / 18 seconds or about 800HPS, but if I am GCD capped spamming 1 rejuv per second, I am effectively doing the healing of 1 rejuv every GCD, or 15kHPS. Instead of a HoT, picture each rejuv as a 15k instant heal on a target. This actually makes an enormous difference to the stat weights. For me, haste goes from 0.58 SP to 0.16 just from changing how Rejuv scales with SP. I get the same effect from multiplying my percent healing (40%) by 18 (520%).

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.

  • Recently Browsing   0 members

    No registered users viewing this page.