Elitist Jerks - View Single Post - Hunter Spreadsheets -- In development

◊ Lactose · 02/07/07, 2:41 PM

Step 1: Enter your gear
On the 'Gear' tab you can select for every item/enchant/gem your character currently has. If you find you have an item that is not currently listed, you can enter stats for it in the 'Custom Gear' tab, and then select "Custom" for that slot. The spreadsheet automatically checks for valid gem combinations for socket bonuses and meta gem requirements.

It is also possible to import gear from the armory. This is still fresh, and might have some bugs. It currently does not include enchants.

There are 5 profiles available to use. You can select a profile name, and either save the current gear set up to it, or load in a saved profile. The profiles contain gear, talents, pet specifications, and shot rotations. You can change the name of your profiles on the 'Settings and Results' tab. The buttons marked "Save" and "Load" do just that.

The "CalcAttributes" button is used to refigure the DPS increase of each specific stat. This happens automatically as gear is changed, but not when talents, shots, or pet information changes, or a new profile is loaded. Clicking the button will recompute the results shown on the 'Settings and Results' tab.

Step 2: Enter your talent spec
On the 'Talents' tab you can enter your current talents. Anything with a red background means it has no effect on any of the spreadsheet's calculations. These can be filled in purely to track the information for you. There is no enforcement of total talent points or their distribution. A "Reset" button is provided to clear all talents back to 0.

Step 3: Enter Shot Rotations
This is the most complicated part of using the spreadsheet, but done in a systematic manner isn't too hard to deal with. There are 4 Shot Rotations that can be specified. They are as follows:

Normal haste. This one is found on the 'Shot Rotations' tab, and bases timing off of the static haste and weapon speed your character has. On this sheet you can also specify your latency (or reaction time if you hand-time shots) and what Aspect you want to be in. There are buttons provided to assist in building standard rotations (please note that these do currently not work for Open Office users):
- Reset - clear all shots to None. This is best used when building your own shot rotation from scratch.
- AutoOnly - sets every shot to Auto Shot.
- 1:1 (Steady) - A standard Auto, Steady repeat rotation.
- 1:1 (Priority) - A standard 1:1 rotation where you can assign different specials to be prioritized if they are off cooldown.
- 1:1.X - This allows you to quickly build a shot rotation that will factor in 2 specials between autos as appropriate. You can indicate whether you want Arcane, Multi, or both included. If both are selected it picks the highest damaging shot if both are available at the same time.
Quick Shots. This is located on the 'Quick Shots' tab. In all respects it is identical to what you find on the normal 'Shot Rotation' tab. Latency and Aspect are used based on the values set on the 'Shot Rotation' tab. (If you do not use Aspect of the Hawk, or have no points in Improved Aspect of the Hawk this entire rotation doesn't matter.)
Dragonspine Trophy. There are 2 rotations available on the 'Dragonspine Trophy' tab. One is for the DST proc without Quick Shots active, and the other is for both Quick Shots and DST proc active simultaneously. The Dragonspine Trophy's effect is modeled by determining your time spent in different haste states, and the damage you do while they are active. If you do not have a Dragonspine Trophy equipped you can ignore this tab.

Step 4: Enter Pet data
The 'Pet' tab allows you to pick your pet's type (Cat, Ravager, etc.) and assign training points to all possible abilities. You get warnings if you pick abilities not applicable to your pet, or if you exceed the total number of training points available. You can also select a mood and loyalty level for your pet.

There is a "pet bar" feature where you can prioritize your pet's abilities based on how you want them to consume focus. It displays average cast times for each ability based on available focus, the ability cooldown, and the pet's global cooldown (1.5s). This is a handy way to see if Bite + Claw is better than Claw or compare other abilities head to head.

Step 5: Check results
The 'Settings and Results' tab provides summaries of a bunch of different information. Most of it should be self-explanatory. There is also a DPS equivalency matrix comparing different statistics. This is useful in determining which next item will provide the most "bang for the buck."

As you modify any value in the spreadsheet the results will update automatically. You also can see summary information from your saved profiles. Clicking in the profile name box allows you to rename it. There are also control setting to average out some talents, and to control the Dragonspine Trophy mechanics.

The "Export" button creates a file in your "My Documents" directory called CheekyHunterDPS.log that contains the data of all 5 of your profiles. The "Import" button loads this file into the spreadsheet. You will still need to use the "Load" button on the 'Gear' tab to bring the profile data into the active set of gear, talents, pet, and shot rotations. These files will be supported in future spreadsheet versions.

02/07/07, 2:41 PM	#2 (permalink)
◊ Lactose Don Lactose Lactose Tauren Hunter <Cráb People> Talnivarr (EU)	Spreadsheet FAQ/Guide Step 1: Enter your gear On the 'Gear' tab you can select for every item/enchant/gem your character currently has. If you find you have an item that is not currently listed, you can enter stats for it in the 'Custom Gear' tab, and then select "Custom" for that slot. The spreadsheet automatically checks for valid gem combinations for socket bonuses and meta gem requirements. It is also possible to import gear from the armory. This is still fresh, and might have some bugs. It currently does not include enchants. There are 5 profiles available to use. You can select a profile name, and either save the current gear set up to it, or load in a saved profile. The profiles contain gear, talents, pet specifications, and shot rotations. You can change the name of your profiles on the 'Settings and Results' tab. The buttons marked "Save" and "Load" do just that. The "CalcAttributes" button is used to refigure the DPS increase of each specific stat. This happens automatically as gear is changed, but not when talents, shots, or pet information changes, or a new profile is loaded. Clicking the button will recompute the results shown on the 'Settings and Results' tab. Step 2: Enter your talent spec On the 'Talents' tab you can enter your current talents. Anything with a red background means it has no effect on any of the spreadsheet's calculations. These can be filled in purely to track the information for you. There is no enforcement of total talent points or their distribution. A "Reset" button is provided to clear all talents back to 0. Step 3: Enter Shot Rotations This is the most complicated part of using the spreadsheet, but done in a systematic manner isn't too hard to deal with. There are 4 Shot Rotations that can be specified. They are as follows: Normal haste. This one is found on the 'Shot Rotations' tab, and bases timing off of the static haste and weapon speed your character has. On this sheet you can also specify your latency (or reaction time if you hand-time shots) and what Aspect you want to be in. There are buttons provided to assist in building standard rotations (please note that these do currently not work for Open Office users): Reset - clear all shots to None. This is best used when building your own shot rotation from scratch. AutoOnly - sets every shot to Auto Shot. 1:1 (Steady) - A standard Auto, Steady repeat rotation. 1:1 (Priority) - A standard 1:1 rotation where you can assign different specials to be prioritized if they are off cooldown. 1:1.X - This allows you to quickly build a shot rotation that will factor in 2 specials between autos as appropriate. You can indicate whether you want Arcane, Multi, or both included. If both are selected it picks the highest damaging shot if both are available at the same time. Quick Shots. This is located on the 'Quick Shots' tab. In all respects it is identical to what you find on the normal 'Shot Rotation' tab. Latency and Aspect are used based on the values set on the 'Shot Rotation' tab. (If you do not use Aspect of the Hawk, or have no points in Improved Aspect of the Hawk this entire rotation doesn't matter.) Dragonspine Trophy. There are 2 rotations available on the 'Dragonspine Trophy' tab. One is for the DST proc without Quick Shots active, and the other is for both Quick Shots and DST proc active simultaneously. The Dragonspine Trophy's effect is modeled by determining your time spent in different haste states, and the damage you do while they are active. If you do not have a Dragonspine Trophy equipped you can ignore this tab. Step 4: Enter Pet data The 'Pet' tab allows you to pick your pet's type (Cat, Ravager, etc.) and assign training points to all possible abilities. You get warnings if you pick abilities not applicable to your pet, or if you exceed the total number of training points available. You can also select a mood and loyalty level for your pet. There is a "pet bar" feature where you can prioritize your pet's abilities based on how you want them to consume focus. It displays average cast times for each ability based on available focus, the ability cooldown, and the pet's global cooldown (1.5s). This is a handy way to see if Bite + Claw is better than Claw or compare other abilities head to head. Step 5: Check results The 'Settings and Results' tab provides summaries of a bunch of different information. Most of it should be self-explanatory. There is also a DPS equivalency matrix comparing different statistics. This is useful in determining which next item will provide the most "bang for the buck." As you modify any value in the spreadsheet the results will update automatically. You also can see summary information from your saved profiles. Clicking in the profile name box allows you to rename it. There are also control setting to average out some talents, and to control the Dragonspine Trophy mechanics. The "Export" button creates a file in your "My Documents" directory called CheekyHunterDPS.log that contains the data of all 5 of your profiles. The "Import" button loads this file into the spreadsheet. You will still need to use the "Load" button on the 'Gear' tab to bring the profile data into the active set of gear, talents, pet, and shot rotations. These files will be supported in future spreadsheet versions. Last edited by Lactose : 10/26/07 at 11:04 AM.
	SNAKEBALL™