Ferboten's Warrior DPS Calculator

[Ferboten]

After much procrastination, the latest version of my calculator is now ready for official release!

Latest Update: June 14, 2012
-Added Introduction/guide sheet
-Calculation for missed frenzied strikes due to crit dry spells, increases the value of crit slightly
-Calculation for average benefit of Golem Inductor based on rotation/lag

The latest version can be found here:

https://docs.google.com/spreadsheet/...WtfclM1N1ZVakE

[intrinsc]

Thanks for your hard work, ferbo.

[intrinsc]

I copied the sheet, but when I switch specs via drop down the distribution doesn't change. It's stuck on 44/22. Am I doing something wrong?

[Ferboten]

The spec? You have to change that manually unforunately. I could add a script that changes the spec automatically when you select a rotation.

[intrinsc]

No problem, I was just wondering.

[Ferboten]

Updated, for some reason the AP and Crit values were frozen, should be fixed now.

[renthicya]

I've tried to get this nice little thing, but all buttons except Download as are greyed out for some reason.
Any idea, perhaps a mirror for the calculator woudl be appreciated.

[Ferboten]

I've tried to get this nice little thing, but all buttons except Download as are greyed out for some reason.
Any idea, perhaps a mirror for the calculator woudl be appreciated.

Are you logged onto a google/gmail account? There's no way to mirror it unfortunately as google docs has its own system for these things. I'm considering switching over to Excel as it would make my life easier for some things.

[renthicya]

Yes, tried with logging in and out as well.

[Sebb]

Seeing tons of issues with the R/C cell referencing giving #Value errors.

I applaud the work, but I'd say the GI algorithm probably isn't worth it as much as just giving an estimated uptime. You could do a lot with this to improve by using data validation for the blessing/way/avatar/crystal/trinket options.

You could also include pivot tables for graphical presentation of damage done by source. Would be a nice little touch

[Ferboten]

Not sure what you mean, R/C cell? I'm not seeing any #Value errors from my end.

From what I've seen, the GI calculation is pretty accurate, at least from excel simulations. There's still a few tweaks to do, but they're pretty minor. I did it mostly because it was an interesting problem to tackle and I couldn't find anything similar on the web.

A damage breakdown would be cool, it's already on my list of things to do

[Sebb]

Not sure what you mean, R/C cell? I'm not seeing any #Value errors from my end.

From what I've seen, the GI calculation is pretty accurate, at least from excel simulations. There's still a few tweaks to do, but they're pretty minor. I did it mostly because it was an interesting problem to tackle and I couldn't find anything similar on the web.

A damage breakdown would be cool, it's already on my list of things to do

Oh, some certain cells have references as R[-1]C[0] etc and it's throwing stuff out. Might have to do with using a mac version of Excel (or just the versioning).

I'm sure it's accurate for a dummy or Ituzial, but probably goes out the window as soon as you get movement. Check out trying to do some sort of pivot table for the output screen, there's a lot of neat options.

[Ferboten]

Excel might be the issue here. It's best to make a copy within google docs and use that rather than downloading as an excel file. It gets rid of any scripts/formatting/data validation which basically ruins the calculator. Like I said earlier I'm considering switching to excel, but it's a pretty big amount of work, and I would have to find a host, etc.

[Killerkonnat]

I've wondered for a long time what does "SB" mean in "44 para / 22 champ SB"? Just Shifting Blades?

Also I noticed an amusing typo. You wrote the 38 para build as "38 PR/222CH/6RB".

[Sharogy]

Oh, some certain cells have references as R[-1]C[0] etc and it's throwing stuff out. Might have to do with using a mac version of Excel (or just the versioning).

I'm sure it's accurate for a dummy or Ituzial, but probably goes out the window as soon as you get movement. Check out trying to do some sort of pivot table for the output screen, there's a lot of neat options.

There are 2 functions that doesnt work properly when exported to excel, heck, it doesnt work no matter where i export them.

one is the ROUND(), this command in google doc accepts ROUND(Aug), while in excel and openoffice u have to supply a second Aug, in this case ROUND(Aug,0) yields the same result, toke me a while to correct this.

second one is the Vlookup(a,b,c,d), in openoffice and excel it doesnt support Array returns, in order to do that u have to get another "office addon" with multi returns or use a work-around with array formulae. this mess up the entire Golem inductor calculation, toke me awhile to fix this also.