Phoenix Swing Speed Spreadsheet Calculator

Started 10 Mar 2019
by Schett
in RvR
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
This topic is locked and you can't reply.

Return to RvR or the latest topics