Been busier than I expected, sorry.
|
Originally Posted by Vec
I was just wondering if you were planning on putting something similar to Blessing of Kings in the Buffs section.
|
Yup, it's planned.
|
Originally Posted by Lodi
Lactose, I didn't catch anything about modelling the interference from using arcane and multi (to both steady, and even the autoshot on a quite-fast weapon).
|
At the moment there's no support for this, still thinking of ways to make the shot / rotation tweaking work as good as possible.
|
Originally Posted by Shookers
It would be nice if you could include the relative value of Hit Rating as compared to Agility. As of now I've just been assuming it has approximately the same value as Crit Rating, yet I know that cannot be accurate.
|
It's planned.
|
Originally Posted by Arganise
Secondly, I'm quite confused with how the Shots fields work (i.e. Seconds between Auto Shots). I have some idea, but it would help alot if you could explain abit how to use it properly.
|
At this stage, it's very rough and extremely likely to be scrapped / revamped completely, so I'm hesitant of documenting it atm. If it's archaic to you, don't worry about it, things will be sorted out a bit later.
|
Originally Posted by Auxilium
Back when the first changes were announced I briefly considered *not* taking the Improved Arcane Shot talent. Have you been considering any potentional benefits of a 6 sec Arcane Shot over 5 sec Arcane Shots? Being able to spend 5 points elsewhere might improve overall performance. I know this is not directly related to the spreadsheet, but then it would affect your cycle.
|
Personally I think Improved Arcane Shot might be a bit of a waste compared to the other options, at least for raiding purposes.
|
Originally Posted by tict
So Lactose thanks for the spreadsheet. Quick question though, as noted above would it be correct to believe that a quick ranged weapon is really that much better then a slow/medium speed one?
|
If you're able to shoot like you've input, it should be accurate. However, I kinda highly doubt you're able to perform the abilities that perfect, making fast weapons not all that godlike.
|
Originally Posted by Azulor
1. The formulas for both arcane shot average and multishot average appear incorrect. For example, B176 upon simplification appears to return B175*B151, which is Multishot crit. This explains why changing entries in Improved Barrage have no impact on the final DPS calculations. Likewise, B164 returns B163*B151, basically arcane crit.
|
This is fixed locally, but not yet uploaded.
|
2. The logical statements you use to build the raw numbers from row 157 onwards are sensitive to B94 and B97, which are sensitive to B29 and B31 (also the C column for new DPS I suppose). You might want to change the default return on, for example, B97/C97 and B94/C94 to be max rank because as written with no entries in B29/C29 and B31/C31, the arcane and multishot damage gets computed as zero literally (not simply min zero added damage).
|
I don't have the spreadsheet open in front of me right now, so I'll have to check this a bit later.
|
Originally Posted by taurenhunter
I would like to make a suggestion: to put names on the relevant Excel columns/cells.
|
Nice idea, I'll see what I can do, even though it forces me to come up with sensible names for the cells ;)
I'd also like to thank Glaurong for the formula; credit where credit is due ;)
Also... someone asked me earlier if I'm German, due to some WAHR / FALSCH stuff... No, I'm not, nor do I have a German spreadsheet program installed, so I have no idea where this is from :P