WSC (weaponskill mod) Spreadsheet Calculator

[Raen Ryong]

This is a spreadsheet allowing you to work out the WSC (weaponskill mod) portion of your weaponskill damage. It's very simple to use. Simply type in the % of the mod (eg, a 50% STR 50% VIT weaponskill, you will type in 50 into one of the mods and 50 into one of the others; it does not matter which way around it goes) and then the values of your stats and the spreadsheet will calculate the rest for you.

To simplify it further, the numbers displayed in red are the only ones which need changing.

A brief explanation;
http://wiki.ffxiclopedia.org/wiki/WSC <== take your Alpha value from this. By default it's 0.83 (value at level 75), but as your level decreases, Alpha increases. Just substitute it in.

Percentage, simply replace by the relevant percentage, and value, the value of that mod (for instance, for a 50% STR WS, where you had 90STR, you'd put in 50 into the percentage column, and 90 into the value column. Simple).

If the weaponskill only has one mod, just put 0 in the secondary mod percentage column.

Now notes;

This is only a WSC calculator! It does NOT calculate fSTR benefit from STR. It does NOT calculate attack bonus from STR. It does NOT calculate the potential benefits of accuracy from DEX. This is simply WEAPONSKILL MOD, nothing more, nothing less.

To calculate the impact of fSTR, 1 fSTR = 1 WSC (which this spreadsheet calculates). For melee, 4str = 1fstr, generally. For ranged, 2str = 1fstr, generally. So if 10STR gave you one less WSC than 6STR 10VIT, they would be EQUAL in terms of (WSC + fSTR). 10STR would win in this case because you'd also get an attack benefit from it (ensure when using this comparison that fSTR is not at cap).

http://www.savefile.com/files/1611382 <== link to file.

I know this is an incredibly simple spreadsheet, but I still hear people asking about WS mods all of the time, and so thought I might as well make it since it is so simple.

[LinktheDeme]

is this virused? D:

[Raen Ryong]

I would hope not or I'm infected too, it's on my desktop :O

[Raen Ryong]

Uploading the spreadsheet to the forums (in a zip file since .xls extensions do not seem to be allowed) since people seem wary of downloading from an external site.

[Amele]

Uploading the spreadsheet to the forums (in a zip file since .xls extensions do not seem to be allowed) since people seem wary of downloading from an external site.

just make it a google doc. and while we're at it. the functionality you provided hardly justifies a full spreadsheet x.o add some features!

[riddaraan]

Why don't people start adding "Approximate Defense" and "Approximate Evasion" to mobs in the wikis? And then you could add a function to mobs in the spreadsheet, which would help you calculate what food is best for you to use, given that situation?

[Amele]

Why don't people start adding "Approximate Defense" and "Approximate Evasion" to mobs in the wikis? And then you could add a function to mobs in the spreadsheet, which would help you calculate what food is best for you to use, given that situation?

I can give him the formulas for calculating evasion and defense (and vit and agi) based on mob ranks and level. I've got a spreadsheet myself that I use for comparing gear, food, and weapon sets but it suffers from the fact that what we know about pdif and cRatio is a mess right now. (accuracy, fstr, and wsc are all easy).

[Raen Ryong]

Yeah, I know it doesn't justify a spreadsheet and is painfully thin on content at the same time, people always seem to ask about WSC so I thought about making it.

No idea how to make it a google doc, not too experienced at this kind of thing

What kind of features would you suggest? I was planning on keeping this as a pure WSC calculator but I can always expand it given the time/motivation I suppose =p

[riddaraan]

If you want it to be a really helpful spreadsheet, there's a lot you can do. If you want some help, I may be able to throw some your way, if I can find some time.

One thing, for instance, is to take Amele's information, and input it in such a way that your starting page will give the player a drop-down menu, where they can choose their preferred mob. Greater Colibri, Mammool Ja Somethingorother, you name it. That will spit out some numbers which we can use to approximate VIT, AGI, Defense, & Evasion. Then you have a section in which the players input their armor, weapon, skill level, STR, DEX, etc. And based upon that, also accounting for WS mods, you can give players a rough idea at what sort of damage and accuracy they'd be looking at for both TPing, and WS damage (of course it'd show you each physical WS for that weapon, and the theoretical damage).

Then add a small menu where the players can choose which food they're planning on using. That will show an "altered stats" display, and an "altered stats" adjustment for damage & accuracy.

I know there's a lot of variables to account for in this, as you'll need databases for armor, weapons, food, and mobs. But if you REALLY want to make something that the FFXI community as a whole will find useful, this is what you want to do.

And if you're ever so ambitious as to begin this little project, you may consider adding in HNM & such.

Of course, then you'll probably want to make one for mages too...


Oh yeah, you'll need to throw in options for Allied Sigil, Signet, or Sanction.

And then an option for weapons which have latents under 100% TP....

Should I go on?

[RKenshin]

I started making a type of spreadsheet with the same general purpose, but just not specifically for WS.

I haven't had time to finish it though. It's like 80% done but no time to put into finishing it over the last month or two.

This is what it looks like at the moment:
http://img88.imageshack.us/img88/1033/damagelt1.jpg

Better example:

[Amele]

are the damage values calculated or do you have to input them manually? if you're calculating I'd be interested in the formula(s) you are using to do so.

yours is close to mine except I wasn't taking to averages, just mins and maxes (I wanted a toy to play with at work where I don't have access to parse data and I haven't figured out a satisfactory way to generate averages. I also laid mine out horizontally more than vertically.)

[RKenshin]

The majority of it is data that you enter to represent the situation you want to compare. Like, the delay of the weapons, the amount of dual wield present (if any), the amount of DA, TA, Store TP, Zanshin, and the WS/melee average.

Or basically, any field you see there that isn't highlighted in light blue, you enter the value for. The blue highlighted fields are the calculations.

That picture I just uploaded is an example of comparing the effects of Destroyers vs Wagh, with guessed stats (so it's not so accurate). But, if you could parse out your melee/WS average with each, you just enter that info into the excel sheet and it would calculate the difference.

But yeah, lots of calculations. One of the longer formulas:

[Amele]

yeah, was referring specifically to the avg. damage numbers (ex: d37, d38). IF I had a model for equating cRatio to average pdif (and not just min and max - which seem incorrect for 2h still.. ) I could write the cells that would solve your damage for you based on the mob and your stats, but lacking a way to determine what the average should be short of parsing I'm a little stuck lol.

overall our sheets are about the same (you've got a much cleaner layout though) - I'll upload mine next time I get an opportunity (traveling this week, so no access to @work documents). to show some of the stuff I've been working on in this area.