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

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

Version 49:

Corrected the proc duration of the [Abacus of Violent Odds] from 20 seconds to 10 seconds.
Fixed the DPS gains from the [Darkmoon Card: Wrath] and [Darkmoon Card: Crusade].
Fixed cell permissions on DPS per attribute to allow for CalcAttributes to work again.
Corrected the lookup of on-use +AP procs. This should fix some errors with these trinkets.
Corrected the lookup of Multi-Shot damage bonus with PvP gloves. This was probably leading to N/A issues for Multi-Shot damage.
Fixed set bonuses for weapons, shoulders, and gloves.

Version 48:

Added new enchants (Surefooted, Restore Mana Prime, Boar's Speed, Ring enchants now actually work.)
Begun adding a gear planner feature, sorting items by DPS and availability. Haste and procs may be a little screwy. Melee weapons are broken down into one-handed and two-handed categories. Ranged weapons are not supported.
Cleaned up items supported to only be unique items in TBC content.
Redid +1 stat calculations. This should operate much smoother. It will also generate a "haste cap" where haste is no longer beenficial, and a lookup table of haste -> DPS. This is used to more accurately judge the future value of haste.
Provide value of hit based off of have 0 +hit gear (useful for item DPS comparisons.)
Fixed problems with counting the proc of [Madness of the Betrayer] properly.
Simplified a lot of the code in the spreadsheet (I started treating this like a real software project). This should result in less bugs and faster turn-around times on fixes.
Completed new model of the [Dragonspine Trophy]. You can also see it's uptimes now if don't have it equipped.
Changed [Madness of the Betrayer] model to be PPM with differing rates of proc on Auto Shots and Special Shots. This lowers the effective uptime.
Automate the process of build Main/Off hand weapon lists. This should eliminate future bugs in the lists not being accurate with the master list.
Changed formatting on the gear page so that "0" values are in white text.
Added new gear ([Assassin's Alchemist Stone], [Figurine - Khorium Boar], [Claw of Molten Fury], [Fist of Molten Fury])
Corrected some item stats ([Grimgrin Faceguard], [Feltooth Eviscerator], [Leggings of the Pursuit], [Scaled Drakeskin Chestguard])
Corrected some spelling mistakes in item names ([The Blade of Harbingers], [Shard-bound Bracers])
A better model for the [Shattered Sun Pendant of Might] (Scryer) is being used. 16.7% chance of proc after the cooldown, and using ranged critical hit chances to critically hit for double damage.

Version 47:
- Armory scraping for Gear now correctly pulls most enchants too. Thanks to Drakier of Uther for providing the framework and the current set of supported enchants.
- Corrected some item stats ([Band of Ruinous Delight], [Hauberk of the War Bringer], [Tunic of the Ranger Lord]).
- Corrected some item names ([Scale Leggings of the Skirmisher]).
- Added some new items ([Bracers of the Forest Stalker], [Figurine - Shadowsong Panther], [Cloak of the Coming Night], [Sunrage Treads], [Stalker's Chain Armor], [Stalker's Chain Helm], [Stalker's Chain Leggings], [Stalker's Chain Spaulders], [Stalker's Chain Gauntlets], [Assassin's Alchemist Stone], [Leggings of the Betrayed], [Band of Celerity]).
- Modeled the Aldor [Shattered Sun Pendant of Might] similar to other, similar trinkets (45 second internal cool down, 10% chance on hit.)
- Allow for selection of Aldor/Scryer factions (only applies to [Shattered Sun Pendant of Might]) on the 'Settings and Results' tab.

I'll be out of town next week on business. Please send all bug reports to Lactose.

Next up:
Gear sorting based on DPS (starting to put infrastructure in place)
Better modeling for PPM-based items
Better model for Scryer [Shattered Sun Pendant of Might] proc, once we have more data.
Various bug fixes (like auto calculation of stat->DPS changes on gear updates.)

Version 46:
- Fixed some item stats ([Ar'tor's Mainstay], [Gronnstalker's Boots], [Gronnstalker's Belt], [Gronnstalker's Bracers]).
- Added new gear ([Belt of the Silent Path], [Blade of Serration], [Swift Blade of Uncertainty], [The Mutilator], [Trousers of the Scryers' Retainer], [Tunic of the Dark Hour], [Vanir's Left Fist of Brutality], [Vanir's Left Fist of Savagery], [Vanir's Right Fist of Brutality], [Mantle of the Golden Forest], [Band of Ruinous Delight], [Sin'dorei Pendant of Triumph]).
- Fixed some item names ([Choker of Bloodied Feathers], [Harbinger of Doom]).
- Raptor pets now consider Dash a valid skill.
- Added Judgment of the Crusader to Buffs tab.
- Put Lightning Breath on a 2-roll system.

Comments, criticism, ideas and insults are always welcome.

02/07/07, 2:42 PM	#4 (permalink)
◊ Lactose Don Lactose Lactose Tauren Hunter <Cráb People> Talnivarr (EU)	Change logs Version 49: Corrected the proc duration of the [Abacus of Violent Odds] from 20 seconds to 10 seconds. Fixed the DPS gains from the [Darkmoon Card: Wrath] and [Darkmoon Card: Crusade]. Fixed cell permissions on DPS per attribute to allow for CalcAttributes to work again. Corrected the lookup of on-use +AP procs. This should fix some errors with these trinkets. Corrected the lookup of Multi-Shot damage bonus with PvP gloves. This was probably leading to N/A issues for Multi-Shot damage. Fixed set bonuses for weapons, shoulders, and gloves. Version 48: Added new enchants (Surefooted, Restore Mana Prime, Boar's Speed, Ring enchants now actually work.) Begun adding a gear planner feature, sorting items by DPS and availability. Haste and procs may be a little screwy. Melee weapons are broken down into one-handed and two-handed categories. Ranged weapons are not supported. Cleaned up items supported to only be unique items in TBC content. Redid +1 stat calculations. This should operate much smoother. It will also generate a "haste cap" where haste is no longer beenficial, and a lookup table of haste -> DPS. This is used to more accurately judge the future value of haste. Provide value of hit based off of have 0 +hit gear (useful for item DPS comparisons.) Fixed problems with counting the proc of [Madness of the Betrayer] properly. Simplified a lot of the code in the spreadsheet (I started treating this like a real software project). This should result in less bugs and faster turn-around times on fixes. Completed new model of the [Dragonspine Trophy]. You can also see it's uptimes now if don't have it equipped. Changed [Madness of the Betrayer] model to be PPM with differing rates of proc on Auto Shots and Special Shots. This lowers the effective uptime. Automate the process of build Main/Off hand weapon lists. This should eliminate future bugs in the lists not being accurate with the master list. Changed formatting on the gear page so that "0" values are in white text. Added new gear ([Assassin's Alchemist Stone], [Figurine - Khorium Boar], [Claw of Molten Fury], [Fist of Molten Fury]) Corrected some item stats ([Grimgrin Faceguard], [Feltooth Eviscerator], [Leggings of the Pursuit], [Scaled Drakeskin Chestguard]) Corrected some spelling mistakes in item names ([The Blade of Harbingers], [Shard-bound Bracers]) A better model for the [Shattered Sun Pendant of Might] (Scryer) is being used. 16.7% chance of proc after the cooldown, and using ranged critical hit chances to critically hit for double damage. Version 47: - Armory scraping for Gear now correctly pulls most enchants too. Thanks to Drakier of Uther for providing the framework and the current set of supported enchants. - Corrected some item stats ([Band of Ruinous Delight], [Hauberk of the War Bringer], [Tunic of the Ranger Lord]). - Corrected some item names ([Scale Leggings of the Skirmisher]). - Added some new items ([Bracers of the Forest Stalker], [Figurine - Shadowsong Panther], [Cloak of the Coming Night], [Sunrage Treads], [Stalker's Chain Armor], [Stalker's Chain Helm], [Stalker's Chain Leggings], [Stalker's Chain Spaulders], [Stalker's Chain Gauntlets], [Assassin's Alchemist Stone], [Leggings of the Betrayed], [Band of Celerity]). - Modeled the Aldor [Shattered Sun Pendant of Might] similar to other, similar trinkets (45 second internal cool down, 10% chance on hit.) - Allow for selection of Aldor/Scryer factions (only applies to [Shattered Sun Pendant of Might]) on the 'Settings and Results' tab. I'll be out of town next week on business. Please send all bug reports to Lactose. Next up: Gear sorting based on DPS (starting to put infrastructure in place) Better modeling for PPM-based items Better model for Scryer [Shattered Sun Pendant of Might] proc, once we have more data. Various bug fixes (like auto calculation of stat->DPS changes on gear updates.) Version 46: - Fixed some item stats ([Ar'tor's Mainstay], [Gronnstalker's Boots], [Gronnstalker's Belt], [Gronnstalker's Bracers]). - Added new gear ([Belt of the Silent Path], [Blade of Serration], [Swift Blade of Uncertainty], [The Mutilator], [Trousers of the Scryers' Retainer], [Tunic of the Dark Hour], [Vanir's Left Fist of Brutality], [Vanir's Left Fist of Savagery], [Vanir's Right Fist of Brutality], [Mantle of the Golden Forest], [Band of Ruinous Delight], [Sin'dorei Pendant of Triumph]). - Fixed some item names ([Choker of Bloodied Feathers], [Harbinger of Doom]). - Raptor pets now consider Dash a valid skill. - Added Judgment of the Crusader to Buffs tab. - Put Lightning Breath on a 2-roll system. Comments, criticism, ideas and insults are always welcome. Last edited by Lactose : 05/12/08 at 8:25 PM.
	SNAKEBALL™