DPS Spreadsheets

**Khary** · 2012-11-09 10:21

Originally Posted by NynJa

Run them on your pc, works for me.

Hmmm Ok I'll give that a try lol. Ty Nynja.
Yep that did it, can't believe I didn't think if that /facepalm

**Mercilessturtle** · 2012-11-09 11:08

Originally Posted by Motenten

The "Relic Bonus" line on the Data page. It's line 99 on the Drg sheet.

That's the WS bonus? He's talking about 2x/2.5x/3x procs. It would be nice to have that built in instead of having to guesstimate it into the ODD field.

**Loziel** · 2012-11-09 12:16

Yeah the 2x 2.5x 3x bonus is what I was talking about. I hear gungnir is 3x but line 99 on the data sheet says 100%. I don't see how these equate and I don't know what the proc rate is for these hidden effects. Is the sheet calculating these automatically when you select gungnir? Or does it need to be modded?

**Mercilessturtle** · 2012-11-09 12:41

You have to do it by putting it into the ODD% spot on the main setup page. The proc rate is equivilent to 20% ODD I think, like the 2x weapons are 20%, the 3x weapons are 10%. So you can just put 20% ODD for any relic. Except that it can't proc on DA, TA, etc so if you want to be totally accurate you need to lower it from 20% based on how much multi-attack you have.

**ccl** · 2012-11-18 13:18

Is it possible to add namas arrow+Yoichi+arrow for ws on sam spreadsheet while tping with amano ? With the way we do stuff atm (min*4/chaos roll), and ratt higher Pdif, it seems awesome for lvl 120+ stuff ect.

**Whiteknight** · 2012-11-19 14:47

Hey, is it possible to add Porhos Byrnie and Sljor ring (the ring from meeble with Str3 and DA+1%) for drg spreadsheet?
Thanks.

**Motenten** · 2012-11-19 15:13

@ccl: I don't think I can incorporate that just yet. Perhaps if/when I get rng/cor sheets put together then I can consider adding ranged attack stuff to others.

@Whiteknight: Added items.

**Whiteknight** · 2012-11-19 16:48

Thanx. Forgot to say, Atmacites aren't working. All I get is a Non attribuated cell.
Also, does the set effect on phorcys works on it? (should add 2 str dex agi) when at least 2 pieces are equiped.

**suji** · 2012-11-19 20:45

Originally Posted by Whiteknight

Thanx. Forgot to say, Atmacites aren't working. All I get is a Non attribuated cell.
Also, does the set effect on phorcys works on it? (should add 2 str dex agi) when at least 2 pieces are equiped.

Atmacites just aren't implemented but you can manually add the effects using the free-form row under your gear sets if you want to compare them. And you have to do the Thaumas/Phorcys set bonuses yourself in the same row-- only the empy set bonus is accounted for automatically.

**diasetsu** · 2012-11-19 21:43

Originally Posted by Whiteknight

Also, does the set effect on phorcys works on it? (should add 2 str dex agi) when at least 2 pieces are equiped.

The "Gear" page has cell protection so you can't fiddle with certain cells. You'll have to turn that off. I am not sure if it is done the same with all versions of Excel, but usually a help pop up will show when you click on a protected cell that tells you how to turn cell protection off. Once Cell protection for the "Gear" tab is off you will just have to modify a few cells.

Code:

+IF(COUNTIF(B3:B17,"Phorcys")=5,15,IF(COUNTIF(B3:B17,"Phorcys")=4,10,IF(COUNTIF(B3:B17,"Phorcys")=3,5,IF(COUNTIF(B3:B17,"Phorcys")=2,2,0))))

Add this to cells D20, G20, H20 and I20

Code:

+IF(COUNTIF(B25:B39,"Phorcys")=5,15,IF(COUNTIF(B25:B39,"Phorcys")=4,10,IF(COUNTIF(B25:B39,"Phorcys")=3,5,IF(COUNTIF(B25:B39,"Phorcys")=2,2,0))))

Add this to cells D42, G42, H42 and I42

Code:

+IF(COUNTIF(AB3:AB17,"Phorcys")=5,15,IF(COUNTIF(AB3:AB17,"Phorcys")=4,10,IF(COUNTIF(AB3:AB17,"Phorcys")=3,5,IF(COUNTIF(AB3:AB17,"Phorcys")=2,2,0))))

Add this to cells AD20, AG20, AH20 and AI20

Code:

+IF(COUNTIF(AB25:AB39,"Phorcys")=5,15,IF(COUNTIF(AB25:AB39,"Phorcys")=4,10,IF(COUNTIF(AB25:AB39,"Phorcys")=3,5,IF(COUNTIF(AB25:AB39,"Phorcys")=2,2,0))))

Add this to cells AD42, AG42, AH42 and AI42

Example: Cell AD20 currently is

Code:

=SUM(AD3:AD18)

You want it to be

Code:

=SUM(AD3:AD18)+IF(COUNTIF(AB3:AB17,"Phorcys")=5,15,IF(COUNTIF(AB3:AB17,"Phorcys")=4,10,IF(COUNTIF(AB3:AB17,"Phorcys")=3,5,IF(COUNTIF(AB3:AB17,"Phorcys")=2,2,0))))

Changing those cells will make the total stats rows account for Phorcys Set Bonuses so you no longer have to manually enter them into the set bonus rows.

**Loziel** · 2012-11-20 08:15

Is Wyvern dmg factored into drg dps sheet? What about if you use pet buff gear, for example moapapa stone

**Martel** · 2012-11-20 08:32

The sheets don't handle pets at all. IIRC, pet dmg calculations are not fully known.

But really, there's probly not much demand for wyvern DPS support. In any given endgame parse, my wyvern(kept alive high HP the whole time) typically does 0.5% dmg. And he has mythic AM3.

I think about the only use for it would be solo/lowman vs fodder mobs. But I doubt any piece of pet gear would be worth changing to over current options.

That being said, I wouldn't mind seeing wyvern DPS added to the DRG sheet, if only for curiosity's sake.

**Taint** · 2012-11-20 09:11

Originally Posted by suji

Atmacites just aren't implemented but you can manually add the effects using the free-form row under your gear sets if you want to compare them. And you have to do the Thaumas/Phorcys set bonuses yourself in the same row-- only the empy set bonus is accounted for automatically.

I changed the abyssea atma into atmacites, I also use it to add missing stats/JAs.

Spoiler: show

**Alistrianna** · 2012-11-23 07:23

Would it be possible to add Nematoma cap and Abatteur Subligar to MNK gear lists?

**Yugl** · 2012-11-23 08:11

Meanwhile, you can edit existing gear with the respective stats.

**Alistrianna** · 2012-11-23 08:14

didnt think of that honestly. new to using these DPS sheets and know nothing about excel. would it be easy to add them myself though?

**Loziel** · 2012-11-23 08:29

I honestly think that somebody capable should post on the JP forums letting the devs know that we have everything mathed out to the finest point and we can see exactly what each job is capable of in reference to the others with the gear and buffs available. whatever system they use to model their balance is way off. It's glaringly obvious to the players how terrible they are at balancing jobs in terms or damage and utility and they need to stop fobbing us off with balance excuses. I honestly think they do nothing more guess

**Taim Meich** · 2012-11-23 10:27

Originally Posted by Alistrianna

didnt think of that honestly. new to using these DPS sheets and know nothing about excel. would it be easy to add them myself though?

Very easy. Go to the Gear Lists tab, and scroll to the category of the item you want to add. Right click in the row number on the left in the middle of the list (that is, anywhere but on the last or first entry), and select "insert new row". Now, just fill in the appropriate values in the corresponding cells, and, voilà! You can now select that piece of equipment in the Gear tab.

**Yugl** · 2012-11-23 10:32

Originally Posted by Loziel

I honestly think that somebody capable should post on the JP forums letting the devs know that we have everything mathed out to the finest point and we can see exactly what each job is capable of in reference to the others with the gear and buffs available. whatever system they use to model their balance is way off. It's glaringly obvious to the players how terrible they are at balancing jobs in terms or damage and utility and they need to stop fobbing us off with balance excuses. I honestly think they do nothing more guess

Base damage and fTP are old business. Some of the regarding order of operations (When multipliers such as Damage Type bonus and PDT become a factor) are uncertain. Lastly, pDIF info is great, but far from the precision you're implying. Mob stats are unknown for a great variety of species as well. That said, a JP forum post displaying DPS sheets so JPs can use them (If they read English) would an interesting idea.

**ccl** · 2012-11-23 11:40

Originally Posted by Motenten

@ccl: I don't think I can incorporate that just yet. Perhaps if/when I get rng/cor sheets put together then I can consider adding ranged attack stuff to others.
.

Okay, how easy would it be then to just math at capped pdif at wich point(enemy level) namas > kaiten for sam ?

Thread: DPS Spreadsheets

Thread Tools