Excel Spreadsheet Atk Speed Calculator

[blueheaven67]

Do to the new attack speed break point/plateau discoveries, I've made a fairly simple Excel Spread sheet which can help in determining what Equipment, Dura, Stones, Buffs, Unities, Belts, etc you will need in order to reach your target attack speed.

From my limited testing, the calculations so far have been "Dead on balls accurate".

I've found it very useful so far in perfecting my build; reaching the target speed with out going over and funneling the rest into things like Crit Rate and Crit Power.

Link:
http://www.mediafire.com/?2yqd0h4u2q2cs4x

If anyone knows of a less shaddy place I should upload this let me know.

Screen Shot:


Taken from the Pet leveling/Char leveling+Crackers thread:

If you don't have Microsoft Excel, you can still use free alternative methods to use it, like Calc coming with the free OpenOffice, or online spreadsheets (see http://en.wikipedia.org/wiki/List_of_online_spreadsheets).

Google Docs should work just fine.

[naabi]

Nice one! And here are atk.spd plateaus by elitexile.

So you may want to add those also in your excel so don't need to come all ways here and checks the actual atk.spd

All melee weapons:
(for dual wielding, two hits counts as one attack in this list)
96-103 attack speed = 50 attacks per minute
104-104 attack speed = 52 attacks per minute
105-115 attack speed = 55 attacks per minute
116-116 attack speed = 57 attacks per minute
117-129 attack speed = 61 attacks per minute
130-130 attack speed = 64 attacks per minute
131-147 attack speed = 68 attacks per minute
148-149 attack speed = 73 attacks per minute
150-171 attack speed = 78 attacks per minute
172-174 attack speed = 84 attacks per minute
175-205 attack speed = 92 attacks per minute
206-209 attack speed = 102 attacks per minute
210-255 attack speed = 110 attacks per minute
256-261 attack speed = 128 attacks per minute
262-338 attack speed = 136 attacks per minute
339-348 attack speed = 170 attacks per minute
349-??? attack speed = 182 attacks per minute

Crossbow:
98-105 attack speed = 50 arrows per minute
106-106 attack speed = 52 arrows per minute
107-122 attack speed = 55 arrows per minute
123-123 attack speed = 59 arrows per minute
124-135 attack speed = 61 arrows per minute
136-147 attack speed = 68 arrows per minute
148-149 attack speed = 75 arrows per minute
150-179 attack speed = 78 arrows per minute
180-185 attack speed = 86 arrows per minute
186-239 attack speed = 91 arrows per minute
240-244 attack speed = 102 arrows per minute
245-250 attack speed = 110 arrows per minute
251-348 attack speed = 136-138 arrows per minute
349-359 attack speed = 170-172 arrows per minute
360-??? attack speed = 182-184 arrows per minute

Longbow:
95-109 attack speed = 50 arrows per minute
110-110 attack speed = 52 arrows per minute
111-121 attack speed = 55 arrows per minute
122-130 attack speed = 61 arrows per minute
131-159 attack speed = 69 arrows per minute
160-166 attack speed = 75 arrows per minute
167-176 attack speed = 78 arrows per minute
177-179 attack speed = 89 arrows per minute
180-212 attack speed = 92 arrows per minute
213-216 attack speed = 102 arrows per minute
217-310 attack speed = 110 arrows per minute
311-328 attack speed = 136 arrows per minute
329-348 attack speed = 170 arrows per minute
349-??? attack speed = 182 arrows per minute

viewtopic.php?f=434&t=994221&start=60#p6149232


Edit. I found one typo in your excel. It's not Wind Potion that gives atk.spd, it's Quick Potion

[blubber000]

I have a excel sheet too for this. I've done some cross checks and we get exactly the same results. So i think calculations are right for both of us.

But to be honest i miss some fields in your sheet. I had to put alot of things in the additional fields.

For example i have on my sh:
- Agi from rings -> Additional Agi
- Agi from Ursa deco and deco cloak -> Additional Agi
- Attackspeed bonus from new weapons -> Additional Atk Spd
- Ergon Cratos Set boni -> Additional Atk Spd/Agi Incr %
- Wings -> Additional Agi Incr %

So you really need to know first what gives you a bonus and where to put it in. Alot of people don't know this all by intuition.

Another comment: I think you can hide the step to calculate Base Attackspeed, normally everyone is only interested in Final Attackspeed.

PS: I think SHs base Agi is 99, but im not sure.

[madhatteress]

Edit: Inspiring work, thanks for doing this. =)

Edit2: I can't thank you enough, if I hadn't seen this, I wouldn't have found enough motivation to finally build this: Attackspeed calc for Vokers.

[cyanide_killer]

Before Epic 7 pt2 base attack speed of a SH was 99, I guess now it is higher.

For an R5-R7 it would be good to know when to stop investing in attack speed for PVE purposes with champ mobs. Not always will you have CM buffs nor pieces.

With the new Epic 7 pt3, I wonder what will be the way to go. The styles get too modified

[blumenkohl]

Nice work, thank you!

However, a question: I use legendary (is that the name on US-servers as well?) t2 gloves, which give additional 5% attackspeed. Where and how do I include this into the table? Would love to test the table to (maybe) improve my equip.

[w1ndows]

They are "Ancient" gloves on the US servers. You add it in the B32 slot, "Additional atkspeed incr %" and put 5% in it.

[blueheaven67]

Nice work, thank you!

However, a question: I use legendary (is that the name on US-servers as well?) t2 gloves, which give additional 5% attackspeed. Where and how do I include this into the table? Would love to test the table to (maybe) improve my equip.

You can put the extra 5% in the second section in the field:

Additional Atk Speed Incr%:

I realize the spread sheet could use more specific fields for such things.

Also, I figured out why I had 100 agi as my base instead of 99. . .I was wearing my evet deco cloak which adds +1 to all stats. Doesn't have an affect on the final speed though. The base field is really there so you can mock around with stone setups easier without having to add them up yourself.

[imekalapuikkoa]

so is this the max. attack speed what Deadeye can get ?

360-??? attack speed = 182-184 arrows per minute


i have 460 attackspeed so do i have 100 attackspeed for nothing ?

[w1ndows]

For melee characters, the next atkspeed plateau after 349 is at 502. For SH it's probably over 520 or something so yes, 460 is useless.

[imekalapuikkoa]

without Deathtyrant cant get 520+ attackspeed, what an bullsh1t coders at this game, making this kind of caps -.-


i wash my mouth with soap

[w1ndows]

Add crit ratio or crit power, it's very beneficial as well.

[imekalapuikkoa]

ok thanks for info

[xsixaxis]

Correct me if I'm wrong I was gonna use this to work out
My sh's atk speed but

Isn't the belt from
Agi/atk speed added to the white number not the additional +


Note stfu on the necro still relevant information :3

[dgosjgois]

Correct me if I'm wrong I was gonna use this to work out
My sh's atk speed but

Isn't the belt from
Agi/atk speed added to the white number not the additional +


Note stfu on the necro still relevant information :3

I don't think it was meant to repeat exactly what rappelz client shows on your stat screen.

white = base + sum of additional bonuses
green = sum of % bonuses * ( base + sum of additional bonuses )