So as we're getting more gear and reducing fight lengths i think we need a bit more accuracy with the spreadsheet. I had previously asked that the spreadsheet change the way Bloodlust/Heroisim works. The spreadsheet is set up for an infinite fight length. I'd rather we be able to set the length of the fight and have the spreadsheet update the DPS based on this. Since Bloodlust/Heroism can really effect dps i've concentrated on this. I changed one calculation as follows on the Fury page.
See the 600 almost at the end. This indicates 10 minutes. What i want instead is to be able to change the duration of the fight so Bloodlust is more accurate. I do this by changing 600 to G44. So it looks like this instead.
Now i can change the duration of the fight in Cell G44. Setting duration to 600 matches the previous dps value shown. Obviously setting the duration lower increases the dps as it should. For Arms you change the calculation in N26 to G42 instead of G44.
I'd think this would be worth changing in the spreadsheet. Just have the duration in cell G44 (Fury) and G42 (Arms) set to 600 as default and add a comment to the cell. Or leave it at 360 default so you don't have to change all the ability usage amounts MS, OP, WW, BT, etc, etc.
Last edited by catch22atplay : 04/13/10 at 10:30 PM.
Thanks for the errors guys. I fixed pretty much everything that was mentioned plus what's in the error log on the first post.
Well I have a few issues with allowing for a specific fight length.
First issue is, it will affect how hysteria, tricks, and shattering throw are tabulated.
Secondly, it will increase DPS metric in general, straying away from the it's historical accuracy over the past year.
Thirdly it was mentioned to just have it modify only the percentage of the fight that Heroism/Bloodlust covers when in truth other things are affected as well. Is it kosher to make this modification only to increase the effectiveness of Heroism/Bloodlust in the spreadsheet?
It's been historically accurate since the rage issue was fixed 10 months ago or so for long duration fights. It's been historically inaccurate for short length fights. Granted we're all aware of the limitations as we know it isn't set up for those short length fights. But when i can beat the spreadsheet and i often do. Example Festergut WoL report 13,151 dps vs spreadsheet's 12,022 This is when i look for ways to make it more accurate for these short duration fights.
Shattering throw you can just replace the 3 instances of 300 with G44 in cell D73. Then remove cell AP37 note that says /5min. Not sure if that's the correct way to do it.
Tricks i'd probably leave alone as you can set how many tricks per 30 seconds.
Hysteria has a bit longer of a time table with how many per 3 minutes. Changing that one would require changing cells D78,D79,F78,F79.
Then you'd also need to change Death Wish in D79 and F79 to work with a duration.
Recklessness would also need to be changed. Although i don't see it referenced anywhere. Maybe i'm blind.
It seems like a lot of work. I was looking for a baby step in the right direction with the Bloodlust/Heroism change and not a complete overhaul. Especially as we move closer to Cat and Haste becomes one of our primary stats to use.
Last edited by catch22atplay : 04/18/10 at 8:10 PM.
I did a smaller update. This does not include fight length changes because implementing that requires a lot more changes and moving things around than I have time to sort through at the moment. Again, the download links are via my guild webpage, which is linked from the first post.
Error Type: TYPO
Warmace of Menethil (reg) ilvl is incorrect.
SHOULD BE: 258
Found this was the source of the fetch armory error I kept having: it kept putting the heroic version on my paper doll because the ilvls didn't match in Function validateItemName.