Attack speed calculator for Dual-wielders!

[madhatteress]

Got hacked at 25 December 2011 and currently lost motivation updating this sheet. If anyone else wants to use my base: Feel free. Might update it somewhere in the future - not sure if I'll find the will for it tho.
_________

Attention please

The calculator was build in Epic 7 Part 2 -
and does not give accurate results in Epic 7 Part 3 -

cos several things have been changed. Chaos Magician buffs work different, new buffs from Master classes aren't inserted yet, among others. Please help me find the changes, so I can update this handy tool!

Since I have a real-life aswell, please be patient, the up-date might take a few days.

Best regards,
Toothy

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -


Inspired by the Sh attackspeed calc from Enya, I couldn't resist creating an attack speed calculation sheet for dual-wielders. The calculation for dual-wielders is slightly different than the one for 2nd weapon users, hence why the sheet is a bit bigger. But see yourself:



The red marks in the sheet are comments. I inserted plenty in hope it helps to understand what gets put where. Hover your mouse over them and the tooltips will appear as you can see here:



The excel-book actually contains 4 sheets:
- the calculation sheet,
- an overview about Pets that help you gain attackspeed stats,
- a table about the attackspeedplateaus,
- the currently available r7 attackspeed durability gear.

You will recognize that some cells / rows seem to be amiss. I have hidden certain lines, in which I was getting some minor results that were needed for the calculation. If you die from curiosity check them out - else just ignore them [the less one messes with this sheet, the longer it stays in a working condition!]

You can download this little toy here: click here. The file is about 110kb big, but if you're able to browse the forums at ease, the download shouldn't take too long.

Enjoy the sheet - and don't forget to leave some feedback,
yours sincerely, Toothy

[metaknight_]

Looks solid, though you should include base agi for some of those old school non-OB characters like myself.

[madhatteress]

If I got the wikia right, the spellsinger gets 4 bonus Agi for overbreeding. So a 150 voker non ob should have 70ish base agi. Looking for confirmation tho.

[nashiwa]

Nice chart I tried with what I planned for my R7, and I got 121 attspd.

[madhatteress]

Time to get r7 to confirm whether that thing was working properly then

[nashiwa]

Exactly now "only" 135% to go

[madhatteress]

Updated - now contains even more modifiers - and should work for all dual-wielders (Sins / Soldiers / Champs / Evokers). Happy testing everyone!

[dgosjgois]

What about the rare ND glove that adds 5%?

I think dura stats are roughly the same % at each rank if you want to extend this to any level.

R2: 0.327
R3: 0.41
R4: 0.512
R5: 0.64
R6: 0.8
R7: 1

[madhatteress]

What about the rare ND glove that adds 5%?

I think dura stats are roughly the same % at each rank if you want to extend to any level

You can fill this in for any level - as long as you figure out your base agility first and adjust the cell to it (and are dual-wielding ofc!).

For the Ancient gloves, that's a good question. Originally I was going to explain you how to adjust the chart, instead I just updated it - so pls download the newest version from above. [Cos I'm not sure how everyone's excel-skills are..]

[karanina]

great guide! will move this to "Player Guides", per request and report of the op

[madhatteress]

Thank you for moving this into the correct section. =)

[imagen]

fantastic.

could be a little more comprehensive if you add in

boss cards (takin +44spd, sl +30% spd, abhuva 7agi, tara 14agi, crusti 20agi, eva 21agi, draka 30agi, kiscia, +1 base atk spd for vokers, +2% archer)

char skills (paragon of anger 40%, support of gust 25% +1% per card lvl)

siren buff (im not 100% sure, but based on the fact that s3 gives +13 : maybe its +11 for s1, and +15 for s5. absolute figure, not %),

r7 set bonus (0/10/20/30 stats) and cleric buffs (tho i guess you can just adjust the base agi).

all in, evokers will break the 400 atk speed mark =D

[madhatteress]

could be a little more comprehensive if you add in boss cards (takin, sl)

I know that I forgot an "Agility boosting Beltcard" section [Abby, Tara, Crusty, Draka, Ashmaw, Queen Eva] (for these bonuses insert a row underneath Agility rings and adjust formular (or just type in a higher value in agi rings)), but tbh I left out the short-time adjustments on purpose. Cards like Takin / Sl have a chance to apply but no guarantee to permanently enjoy the buff, so I disliked emplementing these a lot. I'm no friend of speculation / gambling.

Kiscia got covered in cell C:13, just read the tool-tip and adjust. This chart doesn't help creating archers (with bows) tho. For archers try the excel sheet from Enya.

char skills (paragon of anger 40%, support of gust 25%, siren buff)

Siren buff might be something to consider to implement, thinking abt it's lasting time / cooldown, if you got a very devoted Huna might even add Support of Gust. Nonetheless these are not "permanent", hence why I didn't add them. If you insist I can explain you how to adjust your very own chart via pm, cos right now I soo do not am in the mood to adjust it again (already version 4 or 5), reupload, etc.

r7 set bonus and cleric buffs (tho i guess you can just adjust the base agi).

- for set bonus there IS a field which comments even lists the different options and what they give. [Row 36, culomn C!]
- Cleric buffs do NOT add agility [I know there might come a Mass Bless of Agi for MS Priest, basically build this with what we currently have tho. Might adjust at a later date =)]

fantastic.

Glad you still like it tho. ^^

[imagen]

hehe, i know how to adjust the fields to add in any 'extras' that i may wanna factor in. just wanted to consider for myself what else could boost atk speed in any way and thought i'd share what i brainstormed.

that being said, thanks again for the upload, its great.

[imagen]

Kiscia got covered in cell C:13, just read the tool-tip and adjust. This chart doesn't help creating archers (with bows) tho. For archers try the excel sheet from Enya.

what a disappointment kiscia turned out to be huh. wasted my money trying it out =D