Page 1 of 1

HFC Gear Selector Tool

Posted: Mon Jun 22, 2015 1:26 am
by Abides
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.

Re: HFC Gear Selector Tool

Posted: Mon Jun 22, 2015 8:56 am
by Chev
Cheers for this. I have been meaning to update this since the release date was announced but I just haven't had time.

Re: HFC Gear Selector Tool

Posted: Mon Jun 22, 2015 10:42 am
by vitaminc1231
This is awesome! Thanks for the effort!!

Re: HFC Gear Selector Tool

Posted: Mon Jun 22, 2015 11:20 am
by Chev
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.

Re: HFC Gear Selector Tool

Posted: Mon Jun 22, 2015 6:10 pm
by Bakdor
Thanks Abides that's amazing :)

Re: HFC Gear Selector Tool

Posted: Mon Jun 22, 2015 8:13 pm
by Smaiki
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!

Re: HFC Gear Selector Tool

Posted: Mon Jun 22, 2015 11:27 pm
by Abides
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!

Re: HFC Gear Selector Tool

Posted: Tue Jun 23, 2015 12:18 am
by Ataxus
I still see Incineration in the formula as 5% instead of 15% in the updated OP.

Re: HFC Gear Selector Tool

Posted: Tue Jun 23, 2015 7:50 am
by Abides
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.