HFC Gear Selector Tool

Anything mage specific not covered by any of the other subforums, like raid instance guides for mages.
Abides
Posts: 3
Joined: Mon Jun 22, 2015 12:06 am

HFC Gear Selector Tool

Unread postby Abides Mon Jun 22, 2015 1:26 am

Hi everyone. Many people may be familiar with the gear selector tool created by Berlinia, Chevchelious and Trolltok: http://altered-time.com/forum/viewtopic.php?f=24&t=500" target="_blank

Seeing that we have a new raid coming out, I've made an updated version of this tool specific to HFC: https://www.dropbox.com/s/tz77cx12wdtrb ... .xlsm?dl=0" target="_blank

I just started working on it a few days ago when I was figuring out what gear I needed for the tier, and decided to go as far as I could with it. It doesn't have crafted or Apexis gear, just raid drops. I didn't want to spend too much time in spreadsheets over the weekend. :)

Feel free to point out mistakes or make suggestions. Not all of the formula stuff works in Google docs / Dropbox, make sure to download it and open it with excel.
Chev
Global Moderator
Posts: 624
Joined: Fri Jun 27, 2014 6:44 pm
Location: Manchester, UK

Re: HFC Gear Selector Tool

Unread postby Chev Mon Jun 22, 2015 8:56 am

Cheers for this. I have been meaning to update this since the release date was announced but I just haven't had time.
vitaminc1231
Posts: 11
Joined: Mon Jan 19, 2015 12:20 pm

Re: HFC Gear Selector Tool

Unread postby vitaminc1231 Mon Jun 22, 2015 10:42 am

This is awesome! Thanks for the effort!!
Chev
Global Moderator
Posts: 624
Joined: Fri Jun 27, 2014 6:44 pm
Location: Manchester, UK

Re: HFC Gear Selector Tool

Unread postby Chev Mon Jun 22, 2015 11:20 am

For anyone new to this gear sheet, it should be noted the trinket rankings should be relied upon to heavily. The scoring method is worked out using flat values. E.g. If a trinket had a haste proc which lasted 20 seconds and proceed every 2 minutes, the value is worked out as (Haste / 120) * 60 to get the value for the average minute. It does not take into account how well the proc syncs up with different abilities. E.g. the Crystal.

This is also why the class trinket has a score of '0' because it does not have any base stasts but rather effects certain abilities.

When looking at trinkets to find a BIS, it is best looking at the stats to see how they effect rotations / sync with different cool downs.
Bakdor
Posts: 1
Joined: Thu May 14, 2015 11:24 pm

Re: HFC Gear Selector Tool

Unread postby Bakdor Mon Jun 22, 2015 6:10 pm

Thanks Abides that's amazing :)
Smaiki
Posts: 56
Joined: Thu Dec 18, 2014 12:16 pm

Re: HFC Gear Selector Tool

Unread postby Smaiki Mon Jun 22, 2015 8:13 pm

Nice work!!!! ;)
Two small things to add for the mythic BiS tabs:
- 1% haste = 90 rating (and not 100)
- Fire's crit rating is increased by 15% by Incineration (at the beginning it was 5%)

Cheers!
Abides
Posts: 3
Joined: Mon Jun 22, 2015 12:06 am

Re: HFC Gear Selector Tool

Unread postby Abides Mon Jun 22, 2015 11:27 pm

Nice work!!!! ;)
Two small things to add for the mythic BiS tabs:
- 1% haste = 90 rating (and not 100)
- Fire's crit rating is increased by 15% by Incineration (at the beginning it was 5%)

Cheers!
Updated, thanks!
Ataxus
Posts: 1
Joined: Fri May 30, 2014 1:15 pm

Re: HFC Gear Selector Tool

Unread postby Ataxus Tue Jun 23, 2015 12:18 am

I still see Incineration in the formula as 5% instead of 15% in the updated OP.
Abides
Posts: 3
Joined: Mon Jun 22, 2015 12:06 am

Re: HFC Gear Selector Tool

Unread postby Abides Tue Jun 23, 2015 7:50 am

I still see Incineration in the formula as 5% instead of 15% in the updated OP.
Forgot about the gear tab formulas. Updated there as well and updated mastery to 550.

Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 17 guests