Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics

 
 
LinkBack Thread Tools
Old 09/23/07, 2:13 AM   #776
Fuulish
Glass Joe
 
Orc Shaman
 
Hyjal
Originally Posted by Cheeky View Post
1) you can name the sets, is that not enough? Adding comments could be pretty easy.

2) That sounds reasonable, It's just a question of managing all the data in a readable format.
Oh I didn't realize you could already name the sets. Sorry about that. Could you tell me how?

Offline
Old 09/23/07, 3:21 AM   #777
Cheeky
Great Tiger
 
Cheeky
Troll Hunter
 
No WoW Account
Originally Posted by Fuulish View Post
Oh I didn't realize you could already name the sets. Sorry about that. Could you tell me how?
On the 'Settings and Results' tab, just click on the set name and change it to whatever you want. Next time you select the drop down menu on the 'Gear' tabs it will have your names.

I think the whole feature breaks if you use the same name twice, so try and keep them different.


Offline
Old 09/24/07, 8:39 AM   #778
mickeyknox
Glass Joe
 
Blood Elf Paladin
 
Nathrezim
Error in loading DLL occurs when I try to open the 2 newest files in Excel:Mac 04. Haven't tried the older ones.

Last edited by mickeyknox : 09/24/07 at 8:44 AM.

Offline
Old 09/24/07, 11:03 AM   #779
Cheeky
Great Tiger
 
Cheeky
Troll Hunter
 
No WoW Account
Originally Posted by mickeyknox View Post
Error in loading DLL occurs when I try to open the 2 newest files in Excel:Mac 04. Haven't tried the older ones.
Not sure what I can do to help with that. I don't have access to a Mac, so I can't even try to reproduce this problem. Any other Mac users having trouble?


Offline
Old 09/24/07, 11:14 AM   #780
mickeyknox
Glass Joe
 
Blood Elf Paladin
 
Nathrezim
It goes through "converting" a bunch of Metafiles, and then asks me if I want to enable/disable macros or not open the file. If I try to enable or disable them, I get the "Error in loading DLL" message.

Offline
Old 09/25/07, 5:30 AM   #781
PeterWelzien
Glass Joe
 
Orc Hunter
 
Aszune (EU)
Stylin' Crimson Hat is missing.

Offline
Old 09/25/07, 5:52 PM   #782
onsi
Glass Joe
 
Night Elf Hunter
 
Stormscale (EU)
Great work Cheeky,anyone can confirm if DST modeling is up to date(v2.2)?

Last edited by onsi : 09/25/07 at 5:58 PM.

Offline
Old 09/25/07, 6:37 PM   #783
Cheeky
Great Tiger
 
Cheeky
Troll Hunter
 
No WoW Account
Originally Posted by onsi View Post
Great work Cheeky,anyone can confirm if DST modeling is up to date(v2.2)?
All changelogs are posted at the top of the thread:

Originally Posted by Lactose View Post
Version 29:
- Updated model of [Dragonspine Trophy] to include a user-provisionable cooldown. Default is 20 seconds. The model had to completely change to support the internal cooldown, setting it to 0 will not generate the same numbers given previously. Please use version 28 of the spreadsheet to get numbers for 2.1 with the Dragonspine Trophy
- Provided the user the ability to select 2.1 or 2.2 Haste Rating conversion rates. (This will be removed when 2.2 goes live.)


Offline
Old 09/25/07, 7:02 PM   #784
nicat
Glass Joe
 
Night Elf Hunter
 
Detheroc
Cheeky,

I am sure you will probably pick up the changes, but figured I would get a hunter list together. It appears some of the latest items in 2.2 are missing from the spreadsheet.

All Gems are unique-equipped

Delicate Fire Ruby (12 agility)
Rigid Bladestone (12 hit rating)
Stone of Blades (12 crit rating)
Crimson Sun (24 Attack power)
Falling Star (18 stam)

Enchant

Enchant Weapon - Greater Agility (20 agility to 1h)

Offline
Old 09/25/07, 7:11 PM   #785
Lactose
Don Lactose
 
Lactose's Avatar
 
Tauren Hunter
 
Talnivarr (EU)
Missing items & enchants added to bug list.

Look, Lactose, we'd rather you didn't eradicate the whole human race.
- Sam & Max

Offline
Old 09/26/07, 1:57 PM   #786
Bikiniwax
Piston Honda
 
Night Elf Hunter
 
Laughing Skull
Using version 30 of the spreadsheet:

I plugged in all my talents and gear (from my Armory) but for some reason the Crit and AP on the spreadsheet are not what is on my Armoury.

AP Armoury - 1816
AP Spreadsheet - 1848

Crit % Armoury - 27.22%
Crit % Spreadsheet - 26.62%

My HP, Mana and Armour are correct.

For the life of me, I cannot figure out why the difference in Crit and Ap (32 AP diff).

I logged out only with AotH on and no other buffs.

Offline
Old 09/26/07, 2:06 PM   #787
MikeMo
Von Kaiser
 
Human Death Knight
 
Laughing Skull
I know crit is typically lower since by defaul the spread sheet calculates it based on the fact that you will be fighting a level 73 boss. I am not sure why your AP is lower however.

United States Offline
Old 09/26/07, 2:35 PM   #788
Bikiniwax
Piston Honda
 
Night Elf Hunter
 
Laughing Skull
Originally Posted by MikeMo View Post
I know crit is typically lower since by defaul the spread sheet calculates it based on the fact that you will be fighting a level 73 boss. I am not sure why your AP is lower however.
You're right! I had it set to a lvl 73 mob. Once I set it to lvl 70, my Crit jumped to 27.22% which matches my armoury. Thanks!

Unfortunately, my RAP still reports 1848 on the spreadsheet but 1816 on my Armory.


EDIT: Nevermind! I figured it out. I was looking at Total, Effective RAP which includes Procs (DST). Above that, my RAP shows 1816. Stupid brain.

Thanks again!

Offline
Old 09/26/07, 2:41 PM   #789
Cheeky
Great Tiger
 
Cheeky
Troll Hunter
 
No WoW Account
Originally Posted by Bikiniwax View Post
You're right! I had it set to a lvl 73 mob. Once I set it to lvl 70, my Crit jumped to 27.22% which matches my armoury. Thanks!

Unfortunately, my RAP still reports 1848 on the spreadsheet but 1816 on my Armory.


EDIT: Nevermind! I figured it out. I was looking at Total, Effective RAP which includes Procs (DST). Above that, my RAP shows 1816. Stupid brain.

Thanks again!
I really need to include a "Your character sheet says this" section. I get a lot of messages from people for this, especially about the crit chance.


Offline
Old 09/26/07, 2:48 PM   #790
Bikiniwax
Piston Honda
 
Night Elf Hunter
 
Laughing Skull
Good point!

Cheeky, what amount do suggest for plugging into the Target Armor box for your average LvL 73 boss?

Offline
Old 09/26/07, 5:04 PM   #791
Cheeky
Great Tiger
 
Cheeky
Troll Hunter
 
No WoW Account
Originally Posted by Bikiniwax View Post
Good point!

Cheeky, what amount do suggest for plugging into the Target Armor box for your average LvL 73 boss?
Well, that's the real trick, ain't it.

Lactose is in the process of tracking down armor values for different raid bosses. I hope to add a feature where you can select a boss and get an accurate armor value. I'll also provide Fairy Fire and Sunder Armor as mob debuffs. For now, I'd use 30-35% reduction, about ~5000 armor.


Offline
Old 09/26/07, 5:53 PM   #792
Bikiniwax
Piston Honda
 
Night Elf Hunter
 
Laughing Skull
Alright thanks!

Offline
Old 09/27/07, 5:03 AM   #793
SiRk
Glass Joe
 
Orc Death Knight
 
Frostmane (EU)
I'm sure you guys are already working on it, but don't forget to update all the SSC/TK items that have had their item level increased with patch 2.2

Keep up the good work!

Offline
Old 09/27/07, 5:34 AM   #794
Xeno
Von Kaiser
 
Orc Hunter
 
Suramar
version 30 bug: There's a problem with the relentless earthstorm diamond in that if you don't have the correct gems it will remain active for the purposes of increased critical hit damage.

RED also doesn't increase the total critical hit damage for arcane shot like other shots. If you have mortal shots the critical hit damage will be 233% unlike the other shots which would be 236.9%

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.

Choker of Serated Blades is incorrectly listed as having 154 armor penetration when in fact it is 175.

On a different note, would it be possible to make public the calculations for attributes + 1? Specifically haste, it seems … incorrect.

edit: Calculations!D32 has a typo Ranged WeaponWeapon DPS

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.)

edit: The problem with the +1 haste attribute was that I had just passed the quick shots "haste cap" effectively halving the +1 haste value.

Last edited by Xeno : 09/27/07 at 7:29 AM.

Offline
Old 09/27/07, 5:54 AM   #795
Lactose
Don Lactose
 
Lactose's Avatar
 
Tauren Hunter
 
Talnivarr (EU)
Originally Posted by Xeno View Post
On a different note, would it be possible to make public the calculations for attributes + 1? Specifically haste, it seems … incorrect.
The +1 part is a macro that increases the amount of the stat by 1, then runs the calculations again, storing the values and compares them at the end.

Adding the other points to the bug list. I'm sure there'll be incorrect items and such, even after the next version. If so, just post or PM me.

Look, Lactose, we'd rather you didn't eradicate the whole human race.
- Sam & Max

Offline
Old 09/27/07, 7:57 AM   #796
xEw
Glass Joe
 
Dwarf Hunter
 
Blackmoore (EU)
Originally Posted by Xeno View Post
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.

Offline
Old 09/27/07, 9:45 AM   #797
Cheeky
Great Tiger
 
Cheeky
Troll Hunter
 
No WoW Account
Originally Posted by Xeno View Post
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.


Offline
Old 09/27/07, 10:25 AM   #798
Ladwenae
Von Kaiser
 
Night Elf Hunter
 
Bronzebeard (EU)
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.

Offline
Old 09/27/07, 10:46 AM   #799
Cheeky
Great Tiger
 
Cheeky
Troll Hunter
 
No WoW Account
Version 31

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.


Offline
Old 09/27/07, 12:06 PM   #800
Lactose
Don Lactose
 
Lactose's Avatar
 
Tauren Hunter
 
Talnivarr (EU)
Main posts updated. As always, submit bug reports either here or in a PM to me.

Look, Lactose, we'd rather you didn't eradicate the whole human race.
- Sam & Max

Offline
 

Go Back   Elitist Jerks » Class Mechanics

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Item database project (for all these spreadsheets) Disquette Class Mechanics 89 05/24/08 5:32 PM
DPS and Healing Cloth Spreadsheets Aadar Class Mechanics 11 06/12/07 8:16 AM
[Hunter] Resky's BM and MM excel spreadsheets resky Class Mechanics 2 06/05/07 1:58 AM
In Development - Guild Banks and Voice Chat Trouble Public Discussion 103 05/18/07 2:32 PM