Topic Resto Information Spreadsheet
Edited by Hexaddict on 08/08/11 10:43 (BST)
Hello everyone! For a while now I've had some ideas about creating an informative and helpful spreadsheet aimed at level 85 Restoration Shamans regardless of skill/gear level and so far here's what I've come up with. Any suggestions for improvement or development or any problems please notify me and I'll work on them as soon as possible. While it is a spreadsheet mainly aimed at Shamans, any spell class may find the trinket calculator helpful. If you are a DPS class, you should use Spirit as the equivalent stat to Hit Rating and you may want to rate Indirect Mana Gains/Mana Cost Reductions lowly.
Ever browsed those fansite forums and been baffled by the math and explanations they use? This does all the math for you and translates it into easy to understand English! Ever been puzzled over which trinkets to go for? After a small amount of user input it will tell you what's best for YOU! Ever wondered if you're going wrong with your stats or using the wrong Meta/Flask/Foodbuff? Enter your stats and preferences and it will tell you! You can also try out different combinations of talents with a talent calculator.
So far I've designed the spreadsheet so it's as user friendly as possible and so that a person of any age or native language can use it. If in doubt, read the Key and any information boxes as well as looking at the entire page before giving up!
Last of all, I hope it is useful for you! :)
Latest Version: 1.4.4
Last Update: 8th August 2011
What changed in the last update: Updated the trinket list with the new introductions in patch 4.2.
File Size: 552.3KB
Copy the link into your address bar and press "Click here to start downloading from MediaFire". That's all from me - Cya around!
I like what I see, though I got a few detail feedback points:
a) How do you figure out the whole "Enough Spirit"? Based on average mana usage? Maybe add a line then that if the user serves as a sort-of mana battery for the raid, excess spirit isn't wrong.
b) I remember reading on EJ a while ago - and to date it hasn't been challenged - that the 21 Int + 600 mana proc Metagem from WotLK is still on-par at current epic gearlevels, and vastly superior for someone starting out, compared to the Ember one. Maybe add it in your spreadsheet, and then if the user's stats are too high note that the Ember should pull ahead by now.
Edited by Hexaddict on 14/05/11 18:08 (BST)
Some good ideas - will surely implement them soon enough. The "Enough Spirit" is currently based upon a constant value and if it is over this value it is classified as "enough" and if not it isn't, which admittedly has many flaws. Thanks for the feedback :)
EDIT: File has been updated with these improvements.
Edited by Hexaddict on 15/05/11 11:09 (BST)
Coming soon will be a small questionnaire and from that it will recommend what talents are best for you - as well as a talent calculator.
Any more suggestions let me know!
Really nice spreadsheet, the only thing I found was that in the 'How Many Points in Acuity' box, I wasn't able to enter 0, so it ended up giving me a higher crit rating than I actually have. (I'm toying with the idea of dropping TC and putting the points in Acuity, but for the moment I have no points in it.)
Edited by Hexaddict on 15/05/11 17:46 (BST)
Great. New Update - Talent Calculator. Nothing along the lines of recommending talents yet, though.
38 Downloads so far.
Edited by Hexaddict on 16/05/11 11:30 (BST)
New update - Goblin racial functionality and a weapon enchant check.
Copy the link on the first post into your browser's address bar and click download
Edited by Shockzilla on 21/05/11 09:24 (BST)
Will try out when I have the chance. :)
Edit; only me who are having problem changing the stats? Says I cannot change certain stuff in the file, and when I try to lift those restrictions I need a PW
Edited by Hexaddict on 21/05/11 10:46 (BST)
Will have a look and see what's up with the weapon enchant thing, and you *should* be able to modify the boxes that need to be modified, I protected the rest to avoid accidental formula deletions and such.
EDIT: Noticed the problem and it should work fine now. It seems the two new options I added in the last update I forgot to turn off the protection for them therefore you were unable to modify anything in that particular cell.