Net Benefit Calculator

[Tomk]

I would like to make a simple spreadsheet to calculate the net benefit of gear swaps for certain weapon skills. I am doing this for a couple of reasons; help me answer the little "whats better for X" questions, it will also help me understand the process by making the sheet and watching what happens with different stats.

The idea is a simple:
1. put in WS modifiers
2. Put in your stats
3. Put in your stats after you have changed to the gear your testing
4. something says better or worse by a lot or a little

Everything seems pretty cut and dry so far except for the delta values. I don't really care about specific mob damage, just net benefit so I will just ignore pdif, but what about fstr?

I was thinking of maybe using the first "preswap" stats to calculate a fake mobs vit to set as a benchmark to which the second stats will be compared. In order to do this I need to pick a benchmark fstr. So my questions are:

What fstr should I use?
Is there anyway to find mobs vit?
Is there a better way?

I have seen the damage calulators but using them for this raises the same questions since I don't know any mobs vit.

Thanks

[Granthis]

I've written a spreadsheet to help me evaluate various WS/Gear/Subjob combinations.

It will evaluate pDIF and fSTR based on Wiki formulae and settable enemy level, defense, and vitality. You can enter gear stats manually for STR Attack, etc. into equipment grids and have it read into the totals for STR, Attack, etc.

It does not account for accuracy (assumes 100%) or crit rate (assumes 0%) percentages yet (which is unfortunately a big deal for evaluating Hexa Strike). It also assumes level 75 player status, for purposes of scaling WSC values.

If folks are interested I'll throw it up on mediafire or some such and people can use it as a starting point for tweaking it to their needs.