Phoenix Swing Speed Spreadsheet Calculator

IMPORTANT: To use the calculator, you must go to FILE>Make a Copy on the top left of page, This link is for the master copy so you will need to make your own copy to plug in your own values. All requests to edit the master copy will be ignored.

https://docs.google.com/spreadsheets/d/1G3YNfILQigMuZnNJ0439Wl2_04wZtVdaasd2bJsJa-8/edit#gid=0

I made a spreadsheet for swing speed, I just copied same ''UI'' as the cast speed one made by Yint.

Let me know if you would find something strange

Sun 17 Mar 2019 2:09 PM by inoeth

hey mod can you make this sticky plz?

Sun 17 Mar 2019 2:38 PM by phixion

Nice, thanks.

Sun 17 Mar 2019 10:55 PM by Goforit

Nice. Is the haste value in % ?

Wed 27 Mar 2019 1:46 PM by inoeth

bump

Thu 28 Mar 2019 6:35 AM by jelzinga_EU

Nice work, but I don't understand how Mastery of Arms is calculated. I thought the first level was 1% swing-speed yet when I fill in the most basic stats (60 QUI, no haste, no buffs/items) it gives a relative speed increase of 5.4%

Am I misunderstanding something ?

Sat 25 May 2019 10:00 AM by Goforit

Why is this not sticked?

Sat 25 May 2019 11:13 AM by Vkejai

Prob cos they change it again soon

Sat 25 May 2019 5:15 PM by Goforit

well, it was never sticked...and i wonder why

Mon 9 Sep 2019 8:53 AM by Cadebrennus

Schett wrote: ↑
Sun 10 Mar 2019 11:14 PM
https://docs.google.com/spreadsheets/d/1G3YNfILQigMuZnNJ0439Wl2_04wZtVdaasd2bJsJa-8/edit#gid=0

I made a spreadsheet for swing speed, I just copied same ''UI'' as the cast speed one made by Yint.

Let me know if you would find something strange

Thanks for sharing! Very cool.

Sat 14 Sep 2019 9:05 PM by [email protected]

Went to edit and copied. but still cannot figure out how to change to my spds/stats . any help TY.

Tue 24 Sep 2019 11:18 PM by stewbeedoo

Same here.

Also confused by the Haste value which in the sample file do not appear to be % based?

Wed 25 Sep 2019 12:54 AM by ColdHands

Also confused about haste. Haste, Celerity, and MoA are they additive for a total haste value or does one apply first and the others apply the effective swing speed after.

example:: Mid Melee have 4 sec swing with 0 haste. Healer haste @15%, Celerity @31%, MoArms 5 @ 9% is a total of 55% = 1.8?

or

Same scenario except MoA applies first dropping swing speed to 3.64 then Haste and Celerity at 46% which = 1.97

Wed 25 Sep 2019 8:04 AM by Cadebrennus

We definitely need a Dev answer on this because much of the programming and formulas have been changed here.

Fri 24 Apr 2020 11:04 PM by gotwqqd

It seems that the tables are contradictory
If you compare the %speed increase with the actual speed increase tables for various specs the numbers don’t match as they should

Fri 31 Jul 2020 8:39 PM by gotwqqd

Bump

Why not stickies?

Fri 31 Jul 2020 8:50 PM by gotwqqd

How would I save this to an iPhone or iPad to open later with google docs ?

Wed 17 Feb 2021 7:23 PM by Schett

As I'm still getting requests to edit this google doc, people seem to still use it

So quick reply on the thread since I haven't been playing for quite some time.

The formula is this

swing speed = [WEAPON BASE SPEED] * 100
*= (1 - (MIN(250 ; [QUICKNESS]) - 50) / 500)
*= (1 - ([HASTE] + [CELERITY]) / 100)
*= (1 - [TOA] / 100)
/= 100
(after each line the values are round down)

taken from
https://camelotherald.fandom.com/wiki/Quickness

For Dual Wield
[WEAPON BASE SPEED ] = ( [MAIN HAND BASE SPEED] + [OFF-HAND BASE SPEED] )/2

Back when I made this MoA counts as ToA bonus in the formula I tested it to make sure (might have changed now as I'm not up to date with the server anymore)

The % speed increase is the % speed increase you get for each RA point.

The blue shows you the range of your total RA points