Hunter Spreadsheets -- In development - Page 54

xEw · 09/27/07, 6:57 AM

Originally Posted by Xeno

Mark of conquest seems to be listed as 42.8 mp5? I'm sure this is just a typo, it's closer to 32 mp5, definitely between 30-35.

There is no "definitely" because it's a hitproc and therefore it's dependant on your attackspeed/shotfrequency. Theoretically there are quite higher effective mp5-values possible than 42,8.

Cheeky · 09/27/07, 8:45 AM

Originally Posted by Xeno

edit: After looking at the mark of conquest calculation it seems like the problem is that you have it as a flat chance on hit. From my testing the internal cooldown is 17 secs (very confident of that number) with a 13% chance to proc (reasonably confident of that number.)

Do you have some logs of this testing? I'd love to analyze them myself, I don't think anyone has done extensive testing of it publicly yet.

Thank you for the other points, I'll get them updated.

Ladwenae · 09/27/07, 9:25 AM

I have done some testing with mark of conquest and I ended up with ~37Mp5 and from what I remember my testing supports a 17 second hidden cooldown as well.

Cheeky · 09/27/07, 9:46 AM

The 2.2 version (31) is now released. I'll get the OO version up later today. I have not changed the [Isle of Conquest Mark of Honor] model yet, but based on new information I plan to.

Change Log:
- Corrected a bug in figuring out miss rates for weapon skill 351-354. Everything else was spot on.
- Resorted list of Chest items. This was causing some items to appear with the wrong statistics.
- Added new gear ([Messenger of Fate], [Shadowvine Cloak of Infusion], [Embrace of the Dawn], [Blazing Eternium Band], [Deathwing Brood Cloak] of the Bandit, [Stylin' Crimson Hat], [Delicate Fire Ruby], [Rigid Bladestone], [Stone of Blades], [Crimson Sun], [Falling Star], [Claw of the Phoenix]).
- Fixed description of [Balanced Shadowsong Amethyst]
- Updated items ([Fel Edged Battleaxe], [Figurine - Talasite Owl], [Timelapse Shard], [Warmth of Forgiveness], [Merciless Gladiator's Painsaw], [Choker of Serrated Blades], [Arcanite Steam-Pistol], [Serpent Spine Longbow], [Fang of Vashj], [Talon of Azshara], [Talon of the Phoenix], [Netherbane], [Twinblade of the Phoenix])
- Removed items ([item]Infused Shadow Draenite).
- Added new enchants (Greater Agility to weapons).
- Fixed a bug where the [Relentless Earthstorm Diamond] would grantbonus crit damage even if you didn't have the gem requirements met.
- The [Relentless Earthstorm Diamond] no longer adds critical strike damage to Arcane Shot.
- Only 2.2 Haste Rating conversions are used.
- Removed Sharpening Stones from weapon buffs.

Lactose · 09/27/07, 11:06 AM

Main posts updated. As always, submit bug reports either here or in a PM to me.

lmk · 09/27/07, 12:32 PM

I don't know if this is related to the DLL loading error previously posted about, but running versions 30 and 31 on Excel:Mac 04 none of the buttons do anything -> Shot rotation buttons don't change the shot rotation, saving/loading sets doesn't work, etc. I think it might be a macro problem, but don't know enough about macros to really look into it. Also haven't tested versions earlier than 30.

Edit: I can do any testing, if you tell me what to do.

Koroshiya · 09/27/07, 12:48 PM

I was wondering if I am looking at this all wrong or if the Pet Damage isn't completely flushed out in the spread sheet?

I see the following...

Ability			Damage		Focus		Cooldown
Bite			209.01		35		10
Claw			0.00		0		0
Fire Breath			
Furious Howl		0.00		0		0
Gore			128.02		25		1.5
Growl			0		15		5
Lightning Breath	0.00		0		0
None			0		0		0
Posion Spit			
Scorpid Poison		0.00		0		0.00
Screech			81.86		20		1.5
Thunderstomp

Please forgive me if I am missing something obvious.

Cheeky · 09/27/07, 2:19 PM

Originally Posted by Koroshiya

I was wondering if I am looking at this all wrong or if the Pet Damage isn't completely flushed out in the spread sheet?

I see the following...

Ability			Damage		Focus		Cooldown
Bite			209.01		35		10
Claw			0.00		0		0
Fire Breath			
Furious Howl		0.00		0		0
Gore			128.02		25		1.5
Growl			0		15		5
Lightning Breath	0.00		0		0
None			0		0		0
Posion Spit			
Scorpid Poison		0.00		0		0.00
Screech			81.86		20		1.5
Thunderstomp

Please forgive me if I am missing something obvious.

I think I left some ranks in Screech (I was testing something) when I saved it last. That table is filled out based on the ranks specified for the abilities. Some aren't modeled yet, they are in red in the Pet Training matrix.

Regarding Mac Excel, I have no idea how to even begin debugging what is wrong. Do you get a Visual Basic error and access to the built-in debugger? I have no way to testing this on Mac, and no idea what it's limitations are compared to Windows.

Koroshiya · 09/27/07, 3:49 PM

Originally Posted by Cheeky

I think I left some ranks in Screech (I was testing something) when I saved it last. That table is filled out based on the ranks specified for the abilities. Some aren't modeled yet, they are in red in the Pet Training matrix.

Regarding Mac Excel, I have no idea how to even begin debugging what is wrong. Do you get a Visual Basic error and access to the built-in debugger? I have no way to testing this on Mac, and no idea what it's limitations are compared to Windows.

Okay I see how it works now... Pick a pet.. train it... pick it's abilities.. catch your DPS.

Also, it's still using the Scorpid pre-patch if I am correct.. so I can just go ahead and discount it.

I really appreciate all your work Cheeky, I honestly have no idea how you do it!

Looks like Ravager and Wind Serpent are the highest DPS pets but I worry about pathing and certain encounters such as Void Reaver for the Wind Serpent...

Now it's time to start searching on the appropriate way to spec a pet. I here some saying get 3 of the same pet and have 2 of them with certain resistances.. and the other with none. Want to find some data to help me make a decision on what to do.

Cheeky · 09/27/07, 4:03 PM

Originally Posted by Koroshiya

Also, it's still using the Scorpid pre-patch if I am correct.. so I can just go ahead and discount it.

I'm hoping to do some testing this weekend to see what the new spell coefficient is. I did all that work to build the model for it, might as well spend an hour seeing exactly what Blizzard changed about it.

Xeno · 09/27/07, 4:09 PM

mark of conquest.xls The logs are pretty scattered I don't think I can possibly find them. This wasn't designed to find the proc chance just the internal cooldown, the problem is I took mana breaks and didn't record them so 13% is kinda sketchy. The internal cooldown I think is pretty clearly 17 secs. A few hours at dr. boom with procwatch using just autoshot should do the trick for the proc chance.

Shaile · 09/27/07, 4:54 PM

Is it possible to implement a resilience tab for the target? interested in how high resilience target affect crit/agi gems contra pure ap gems/enchants.

Cheeky · 09/27/07, 5:02 PM

Originally Posted by Shaile

Is it possible to implement a resilience tab for the target? interested in how high resilience target affect crit/agi gems contra pure ap gems/enchants.

I can do that, but it's a low priority for me. I have a few more PvE changes I'd like to add first. I'll keep it in mind.

lmk · 09/27/07, 6:04 PM

Regarding Mac Excel - it appears the buttons themselves are doing absolutely nothing, they don't cause anything to run. If I manually view the macros available in the workbook I get only two total for the whole workbook: 'SteadyRotation' and 'ResetRotation'. Running either one causes an error and sends me to the debugger.

Running 'SteadyRotation' causes "Compile Error: Object required" and sends me to the debugger with the first line of the function (method? macro? I never used VB) highlighted: Sub SteadyRotation().

Running 'ResetRotation' causes "Run-time error 1004: Method 'Range' of object '_Global' failed", and highlights the following line in the macro: For Each cell In Range("SelectedShots").

It looks to me, never having used VB, that there is a considerable amount missing that might have to do with the DLL loading problem another person reported. It's possible Mac Excel just does things completely differently. Is there an option to export the spreadsheet in Excel:Mac 2004 format?

If not, it's not a huge deal, I can save separate copies for different gear sets and manually change my shot rotation. Also, Mac Office '08 is out in January and may fix all this.

Cheeky · 09/27/07, 7:47 PM

Originally Posted by lmk

Regarding Mac Excel - it appears the buttons themselves are doing absolutely nothing, they don't cause anything to run. If I manually view the macros available in the workbook I get only two total for the whole workbook: 'SteadyRotation' and 'ResetRotation'. Running either one causes an error and sends me to the debugger.

Running 'SteadyRotation' causes "Compile Error: Object required" and sends me to the debugger with the first line of the function (method? macro? I never used VB) highlighted: Sub SteadyRotation().

Running 'ResetRotation' causes "Run-time error 1004: Method 'Range' of object '_Global' failed", and highlights the following line in the macro: For Each cell In Range("SelectedShots").

It looks to me, never having used VB, that there is a considerable amount missing that might have to do with the DLL loading problem another person reported. It's possible Mac Excel just does things completely differently. Is there an option to export the spreadsheet in Excel:Mac 2004 format?

If not, it's not a huge deal, I can save separate copies for different gear sets and manually change my shot rotation. Also, Mac Office '08 is out in January and may fix all this.

No option to save as a Mac-specific format. I have no idea why it wouldn't find the VB parts - I haven't done anything different in the way I save it.