Tears Of The Ascended
Would you like to react to this message? Create an account in a few clicks or log in to continue.


tearsoftheascended.enjin.com
 
HomeLatest imagesSearchRegisterLog in

 

 DPS Sigils and You!

Go down 
4 posters
AuthorMessage
Abyss
Jungle Troll
Jungle Troll
Abyss


Posts : 208
Join date : 2011-02-05
Age : 33

DPS Sigils and You! Empty
PostSubject: DPS Sigils and You!   DPS Sigils and You! I_icon_minitimeThu Sep 19, 2013 11:25 pm

Introduction:
So as not to be outdone by Skittles, I’ve decided to write up a guide concerning a question that was posed a few nights ago in guild chat.  The question regarded which “DPS” sigil (Fire, Strength, Force, Night) was most optimal to run for a particular build, and the answers that were given were quite varied.  Since there was some opinion as to which was best I decided to do some math on the matter. 
The most important thing to note about this is different builds will yield different results with the exception of Night being superior to Force when conditions for the Night sigil are met.  This means you’ll have to do math if you really care to optimize sigils for any particular build.  There are a lot of variables associated this, but the math is very straightforward and I’ve done all the work is determining which equations to use for what.

DPS Sigil Spreadsheet - You still need to calculate Skill Specific Coefficient yourself.  See that section for details.

Things you need to know about your build in order for this to work:

1.)      Power – The number next to power in the hero panel.  This is not the same as Attack.
2.)      Precision – The number next to Precision in the hero panel.
3.)      Critical Damage – The number next to Critical Damage in the hero panel.  This does not include the base 50%, but the formula in this guide does.  Just plug in the hero panel’s number.
4.)      Base Damage Modifiers – Any traits that give +X% damage.  (Not Critical damage) Do not include modifiers from Force or Night sigils in this number.
5.)      Weapon Strength – This is the average damage of your weapon(s).  For example, on my axe the range is 900 to 1100, so the average is 1000.  Weapon strength is also equal to the difference between the values of Attack and Power in the hero panel.
6.)      Skill Rotation Time and strikes per rotation – Time will be in seconds.  For example, one rotation of Axe auto attack on Warrior is 3.6 seconds with 6 strikes.  If you auto attack a lot you can use that, but if you hardly auto attack you’ll want to use your other skills.
7.)      Skill Specific Coefficient – This one is a little trickier.  I’ll have a section on how to calculate this.
8.)      Bonuses – This includes any bonuses to Power, Precision, Crit Chance, Critical Damage, potential Might stacks (not including Sigil of Superior Strength), Fury, etc. that are not included in the numbers on the hero panel.  For example if there aren’t any banners down you won’t get a boost for it even if it is on your bar.  Heightened Focus, a warrior trait in the Discipline line provides a 15% boost to Crit Chance that will not show up on the hero panel.  The best way to be sure if you have a trait like this is to swap out the trait and see if a number changes.  If it does not change you’ll have to add it manually.

Some other useful information to you:

1.)      Might – Each stack of might provides 35 Power.
2.)      Superior Sigil of Fire – The Skill Specific Coefficient for this skill is 1.0.  30% chance to trigger on crit, 5 second cool down.
3.)      Sigil of Superior Strength – 30% chance on crit to gain might for 10 seconds. It has a 1 second cool down.  Because it has a cool down of 1 second and the might lasts for 10 seconds, the maximum might stacks you can get from this is 5.  This equates to a maximum of 175 power.

 
Formulas and other mumbo-jumbo:
This section is going to detail how to calculate the effectiveness of these sigils using my Warrior build as an example.  It’s helpful to write out your variables beforehand, so for my Warrior’s build the variables are:
-          Power: 2879 (Base + 3xMight from FGJ + Banner of Str + Empower Allies)
-          Crit Damage: 143% = 1.43 (Base + Sweet and Spicy Butternut Squash Soup)
-          Precision: 2250 (Base + 25 Perception stacks + Banner of Disc + Signet of Fury)
-          Base Damage Modifiers: 30% = .3 (Strength traits V and XI, Scholar Runes)
-          Additional Crit Chance: 35% = .35 (Fury, Heightened Focus)
-          Weapon Strength: 1080 (Ascended Axe, Ascended Mace)
-          Skill Specific Coefficient: 1.2 (I’ll show calculations for this in a later section)
-          Rotation (Strikes/seconds): 6 Strikes, 3.6 Seconds (Axe Auto Attack chain)


Crit Chance:

Spoiler:

 
Skill Specific Coefficients:

Spoiler:

 
PROC of Sigil of Fire, Sigil of Strength:

Spoiler:


Damage of Superior Sigil of Fire:
Spoiler:

 
The Big Equation:

Spoiler:

If you’re still reading this it means you either like math or you’re good at it.  If that’s the case I’m going to assume you can finish this on your own, and I’m just going to make a spreadsheet for everyone else.  I’m tired of typing out equations…


Last edited by Abyss on Fri Sep 27, 2013 4:32 am; edited 3 times in total
Back to top Go down
rhokk
Jungle Troll
Jungle Troll
rhokk


Posts : 102
Join date : 2011-08-17

DPS Sigils and You! Empty
PostSubject: Re: DPS Sigils and You!   DPS Sigils and You! I_icon_minitimeFri Sep 20, 2013 10:40 am

The warrior example in "Damage of Superior Sigil of Fire:" is the same as the formula.
Back to top Go down
Frosty
Needs To Get Off The Forum
Needs To Get Off The Forum
Frosty


Posts : 1028
Join date : 2011-01-05
Age : 40
Location : St. Louis, MO

DPS Sigils and You! Empty
PostSubject: Re: DPS Sigils and You!   DPS Sigils and You! I_icon_minitimeFri Sep 20, 2013 5:02 pm

Byssy makin' us all look dumb.  Mad
Back to top Go down
Abyss
Jungle Troll
Jungle Troll
Abyss


Posts : 208
Join date : 2011-02-05
Age : 33

DPS Sigils and You! Empty
PostSubject: Re: DPS Sigils and You!   DPS Sigils and You! I_icon_minitimeFri Sep 20, 2013 5:12 pm

rhokk wrote:
The warrior example in "Damage of Superior Sigil of Fire:" is the same as the formula.
I knew I was going to mess up with my uploading somewhere. Q.Q
It's fixed now.  Also, if anyone knows how to limit a value in excel to be less than or equal to 1, I will love you long time.
Back to top Go down
Draezha
Jungle Troll
Jungle Troll
Draezha


Posts : 132
Join date : 2013-06-20
Age : 33
Location : Colorado

DPS Sigils and You! Empty
PostSubject: Re: DPS Sigils and You!   DPS Sigils and You! I_icon_minitimeMon Sep 23, 2013 4:20 pm

Pretty sure you go to the solver parameters and then it's 
$B$2:$B$150 < = 1

(I used random numbers for the cell numbers, the cells being the data that you are looking to create a formula for.)

Unless I'm getting confused, which is very likely since it's been a while since I've done anything serious with excel.
Back to top Go down
rhokk
Jungle Troll
Jungle Troll
rhokk


Posts : 102
Join date : 2011-08-17

DPS Sigils and You! Empty
PostSubject: Re: DPS Sigils and You!   DPS Sigils and You! I_icon_minitimeMon Sep 23, 2013 5:17 pm

Using the IF function, you can accomplish this:

=IF(conditionalExpression, trueAction, falseAction)

So you could say:

=IF(A1 <= 1, A1, 1)

Where "A1 <= 1" is the condition you are trying to measure, "A1" by itself is what you want to display when this is true, and "1" is what you want to display when this is false.
Back to top Go down
Draezha
Jungle Troll
Jungle Troll
Draezha


Posts : 132
Join date : 2013-06-20
Age : 33
Location : Colorado

DPS Sigils and You! Empty
PostSubject: Re: DPS Sigils and You!   DPS Sigils and You! I_icon_minitimeMon Sep 23, 2013 6:24 pm

Yep, you lost me. Been too long. Ima go back to bein a stupid good for nothin drunk and punch things ;3
Back to top Go down
Abyss
Jungle Troll
Jungle Troll
Abyss


Posts : 208
Join date : 2011-02-05
Age : 33

DPS Sigils and You! Empty
PostSubject: Re: DPS Sigils and You!   DPS Sigils and You! I_icon_minitimeFri Sep 27, 2013 4:31 am

There probably isn't a high demand for it, but I finished the spreadsheet.
On a side note, it turns out the fire sigil PROC section is erroneous.  The only time the procs per second required to trigger the sigil will be higher than 0.3 is if you're attacking less than 1 time a second.  I'll rework that tomorrow.

Google Docs DPS Sigil Spreadsheet

You'll still need to calculate the average skill coefficient of your chain for this, because I don't even want to try to type that in excel.  The instructions for that are still in the first post in the Skill Specific Coefficients section.  It's just an average with a funny name; you can do it.  Aside from that, save the file and enter your own values into the C column, then watch it do work.
Back to top Go down
Sponsored content





DPS Sigils and You! Empty
PostSubject: Re: DPS Sigils and You!   DPS Sigils and You! I_icon_minitime

Back to top Go down
 
DPS Sigils and You!
Back to top 
Page 1 of 1

Permissions in this forum:You cannot reply to topics in this forum
Tears Of The Ascended :: Dungeons-
Jump to: