DPS Spreadsheets

[ccl]

If you're looking at line D56/E56 for the final attack, that's after the Resolution attack penalty is accounted for.

.

Yeah I was looking there, ty both of you.

[Motenten]

Upgraded Bst.

Implemented Cloudsplitter and Primal Rend as magic weaponskills. Arbitrary setting of mob's Int values as copy of Vit. Please check this for errors.

Edit: Added a bunch of gear, primarily for the new weaponskills.

[Phix]

I just got the War spreadsheet and wanted to know if things like rancor collar were in there couldnt see it /; also how would i go about adding values for armadaberk with da3/stp6 ?
Thanks

[Taim Meich]

You can add pieces of equipment yourself. Just go to the gear lists tab, and add a row in the middle of the corresponding list, then fill it with the stats of that piece of equipment. Don't do it at the end or the beginning, because the list won't auto-stretch to include it.

[Motenten]

I just got the War spreadsheet and wanted to know if things like rancor collar were in there couldnt see it /; also how would i go about adding values for armadaberk with da3/stp6 ?
Thanks

Taim explained how to add stuff yourself. Let me know if you find standard items that are missing, and I'll add them to my version. Added Rancor Collar. Also, since I was there anyway, also added in the fTP by day adjustment, so that you can test the fTP effect on Mekira head depending on if the appropriate day applies.

[Motenten]

Fixed a couple bugs in pup spreadsheet. Main one was Martial Arts base delay not being properly set per level; previous version used the value for lvl 96 and below.

Also updated several spreadsheets to use fTP as a regular stat, and the ability to designate the day proc for Mekira/Athos gear.

[suji]

Let me know if you find standard items that are missing, and I'll add them to my version.

I've had to add a bunch of stuff when testing for situational gear sets. I'm not sure where the line between situational and standard is drawn, but here's what I've added while exploring ideas:

Uther's Grip -- for mobs with crit evasion

Fire Bomblet - accuracy tradeoffs

Nefarious Collar
Portus Collar - this and above for cases where rancor is a liability

Ghillie Earring +1 - accuracy tradeoffs
Belatz Pearl - legion

Armada Hauberk - a default stp5/da3 augmented one would suit most folks.
Valk Breastplate NQ/HQ/Augmented(standard)

Mars's Ring - acc sets
Ambuscade Ring - legion acc sets

Phos Belt - nitpicking since folks one use Bullwhip, but I renamed it in mine for clarity

I think that's it!

[Nightfyre]

Mythic AM3 for set 2 on the DRK spreadsheet seems to be controlled by the toggle for set 1 on the setup page.

[ryskar]

This isn't a relevant post, just wanted to say thank you for taking the time to make all of these, Mot. Also want to thank all the people who find the errors in these. Math is not my strong suit, so these are a lifesaver for me.

[Motenten]

I've had to add a bunch of stuff when testing for situational gear sets. I'm not sure where the line between situational and standard is drawn, but here's what I've added while exploring ideas:

Uther's Grip -- for mobs with crit evasion

Fire Bomblet - accuracy tradeoffs

Nefarious Collar
Portus Collar - this and above for cases where rancor is a liability

Ghillie Earring +1 - accuracy tradeoffs
Belatz Pearl - legion

Armada Hauberk - a default stp5/da3 augmented one would suit most folks.
Valk Breastplate NQ/HQ/Augmented(standard)

Mars's Ring - acc sets
Ambuscade Ring - legion acc sets

Phos Belt - nitpicking since folks one use Bullwhip, but I renamed it in mine for clarity

I think that's it!

Added.

Valk Breastplate NQ/HQ/Augmented(standard)

Note: I don't know what the 'standard' augment on these is, so just used the max TA value.

Mythic AM3 for set 2 on the DRK spreadsheet seems to be controlled by the toggle for set 1 on the setup page.

Fixed

[Oalka]

I just noticed on the BLU spreadsheets, on the "Data" page, column L rows 3-9, where it takes the 2nd characters' spell stat bonuses, it doesn't include column K row 3-9. I had set each set identical and came up with DPS numbers that were slightly different.

[Nightfyre]

I think you've got an old copy, redownload it.

[Motenten]

Actually, that is an error. Fixed.

[Motenten]

Rdm upgraded, several bugs fixed.

[Byrthnoth]

For the WAR spreadsheet:
* Day fTP Bonus doesn't seem to work (at least for Set 2)
* Savagery is not implemented.
* Ukko's Fury doesn't seem to get a native crit rate boost? I can see it in the WS description, but I can't see how it is factored in to the Data sheet and it doesn't look like it is.
* Is there any way to choose a Ratio of Blood Rage to Warcry or something? So say that I have 2 WARs rotating Blood Rage (so it's up 60% of the time we're fighting because we waste some time between monsters) and the same 2 WARs rotate Warcry (it's up 40% of the time we're fighting)

[pchan]

The crit is factored in the WS tab : J8 for the base, K8 for the additional from over tp, L10 -> L13 from gear and setup.

[Motenten]

Day fTP Bonus doesn't seem to work (at least for Set 2)

Bleh, implementation wasn't complete. Fixed.

Savagery is not implemented.

Added.

Ukko's Fury doesn't seem to get a native crit rate boost? I can see it in the WS description, but I can't see how it is factored in to the Data sheet and it doesn't look like it is.

It's factored in on the Weaponskill page, not the Data page, since it has to scale with TP.

Is there any way to choose a Ratio of Blood Rage to Warcry or something? So say that I have 2 WARs rotating Blood Rage (so it's up 60% of the time we're fighting because we waste some time between monsters) and the same 2 WARs rotate Warcry (it's up 40% of the time we're fighting)

Unfortunately for complicated mixes like that, you have to track such things manually. There are just far too many custom combinations for me to be able to track all of them in the spreadsheet. Basically figure the time each combination is active, multiply that percentage by the DPS for that setup, and add all those together.

[Byrthnoth]

The crit is factored in the WS tab : J8 for the base, K8 for the additional from over tp, L10 -> L13 from gear and setup.

Okay, but with a 27% boost to a 10% base with +20% from Blood Rage, one wouldn't expect -40% on the monster to give a 0% Crit rate. There's something wrong with it. Is it re-calculated later?

[pchan]

should be 27+10+20+7.5 (over tp) - 40=24.5% crit, I quickly checked the new version and it seems to be due to flooring earlier or later than expected. At this point you can ajust the "other list" cell and replace the 20% by -20% (intial crit boost for ukkon)

[pchan]

Ok so two problems for WS crit rate calculation (war spreadsheet, but probably all sheets) :

- the crit rate is capped at 0% (should be 1% ?) before adding the WS's base crit rate bonus and the bonus from over TP. SetMain1crit shouldn't be floored (it points to data/D64) but the WS cells ranging from L10 to L13 should.
- the spreadsheet refers to wrong columns when calculating rogue's roll. It should be

=SI($Setup.H9=1;1;MAX(MIN(D62+D63+$Setup.$B$13+$B$ 15+$C$15+RECHERCHEH($A64;INDIRECT(D$22);EQUIV("Tot al";Slots;0)+1;0)+SI($Setup.J42=1;$Setup.M42;0)+$L $8;1);0))

(french but you get it)