Jump to content
Sign in to follow this  
WhyNot

Prot Gear Sim

Recommended Posts

Hey Everyone,

 

I'm new here and new at doing things like this but I would like some feedback and input on a little thing I am working on. I have created an excel sheet based of of this LINK with some gear and stat calculations on it taken from various websites (I will link them below). What I would like some help with is as close to correctly creating proper stat weights and obtaining some missing information.

 

Here is a link to the sheet so you can have a look and give hopefully constructive feedback. 

 

I only planed on creating this for myself but figured I would put it out there for anyone that would find it useful.

 

Spreadsheet Link

 

*Download to use it without changing the source. To use, just change the drop downs in the stat and enchant areas to any of the listed items/enchants and the stats will update. 

 

*Tanking talents tab added.

 

**Please note that this does not sim fights in any way**

 

Missing information:

 

All naked warrior race stats @ 60.

Shoulder enchant information

Adding buffs/potions/flasks

Talents

 

So let me know what you guys think if I should keep it going or not.

 

Sites used for information.

https://docs.google.com/spreadsheets/d/1j81TgG0p_HrYKajiUiQfYIoSUx1culzy2u_Fc4wtiS8/edit#gid=366316127

http://db.vanillagaming.org/

http://www.wow-one.com/forum/topic/61720-protection-stat-priority-and-plateaus/

http://vanillagaming.org/forum/index.php?action=printpage;topic=16596.0

https://forum.elysium-project.org/index.php?showtopic=22798

 

Edit:

I just swapped in Undertanker's TP from the link above as stat weights for the spreadsheet.

Edited by WhyNot

Share this post


Link to post
Share on other sites

The thing with tank gear is there is no set 13-items you never take off.

You have a TPS set (3 hit, 6 hit, 8 hit, 9 hit), max def set, max Stam set, and an OVERALL set, we are OP running MC with AQ40 geared dps set + your different resist sets. Items hold different value based on individual encounters. I may like Lifegiving Gem on Val/Chromag, but want Onxyia Talisman on Nef.

I recommend using Walgraves spreadsheet for a good reference and maybe he can link that here if he wants in a new thread.

Edited by Undertanker

Share this post


Link to post
Share on other sites

I fully understand that. This is more for reference and planing. Either way if there is a better one out there then let us use that one. 

 

Cheers.

Share this post


Link to post
Share on other sites

Any work to further the warrior class is appreciated. For reference, here's Walgraves sheet that I myself use alot.

 

https://docs.google.com/spreadsheets/d/1ykTa_OWeWsB3L3dJHxMaiC3p4IMSr0W0UMl3woQaSqI/edit?pli=1#gid=949587540

 

Maybe there's something there you can build upon and refine

 

EDIT: Spelling.

Edited by Storfan

Share this post


Link to post
Share on other sites

Thank you for the link Storfan this will help me out a lot. I will look into incorporating different sheets for different SETS. The thing i don't like about his sheet is that you don't have the choice of gear to mix and match yourself, unless I am missing something. I am trying to make a sheet that will let you, the player, find the right gear that best fits you in your current content not just BiS overall.

 

I will be looking to add in threat calculations soon as well.

 

Cheers.

Edited by WhyNot

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×