[Tool] Haste calculator

[Dfoley]

Hello everyone.

Due to the popularity of the previous post with the haste discussion, I decided to make a generic tool for the not so math savy people to see how their build compares.

Currently it is just for martial arts (pup and monk) and dual wielders. As I get time I will add in a tab for single wield, and a tab for 2 handers. The goal for me was to see the benefit of 1% haste vs -10 ma when deciding which necklace to use. I wanted to be able to compare the actual difference in swings per minute so it might be slightly tailored to my tastes at the moment but I am open to suggestions.

It is currently saved on google docs, and is an xls (office 97-2003 format).

Let me know any suggestions you have (aside from things I already said I am working on)

Notes:
1) Yellow fields are fields you must enter, most are either a drop down box or fill in the blank
2) Bard haste is assumed to be 25% and spell haste to be 15%. (For bard this requires +2 march and af3 gloves). I realize blu have a 10% spell haste but I didn't feel the need/desire to add it since they also get a 15%.
3) MA from gear is the -10 delay you get from things like cirque af3 armor. or the -5 you get from cirque necklace, etc.
4) DW from gear is the % listed on the piece, aka 5 is for suponomimi
5) Swings/ min is the number of 'rounds' multiplied by 2 (1 swing per hand) and then accounting for acc, DA, and TA.
6) I used % based calculations instead of 1024 numbers, I will be going back eventually to correct this but it will take some time. Although a rough sketch showed that was only a fraction of a % off on total calculations so it should only be a minor change.

Google docs version:
https://spreadsheets.google.com/ccc?key=0AiJNUfIjyWzrdGVjWlk0RkZJeFZGdW45MExILVRmZ3c&hl=en

XLS version (for download):
https://docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0ByJNUfIjyWzrNzIxYzY4NWMtZmFkYS00ZTg2LWIyMTctNmFiYTkyMzYwY2Zk&hl=en

When the link opens, select "File" "Download original", dont try to do it on the web, none of the drop down boxes work.

Update:
Added STP, TP/HIT, WS/MIN, and HIT WS
Minor fixes other tweaks

If you try the google doc version just know that you will have to type in everything since the drop down boxes dont work.

[Dfoley]

Updated the excel to include 2 handers and single wield

As I dont play a 2 handed job let me know if I am missing anything on this.

[Vivik]

Sadly, not even this can convince some people on this board that some of their gear choices are horrible.

[Dfoley]

True, but I did find it nice to know that i was right that I was better off with 24% gear haste and -20ma then 25% gear haste and -10ma

(pup/dnc, with spell and /dnc haste, if you add in bard haste it switches to 25% haste with -10ma > 24% haste with the -20ma)

[Zagen]

Interesting, would be better if it was an online form that way it doesn't require having Excel.

Some suggestions:
- Consider allowing haste to be added per slot since depending on the gear you might not get the full percentage. Of course this would mean you have to include the individual X/1024 values.
- Add STP (annoys me when I see a SAM with 7 hit build preaching Haste > STP).
- Reword "Haste needed to cap" its misleading. Maybe "Total Haste needed to cap attack rate" long I know but it clarifies what it means for those who don't know the finer details but want to use your tool.

[Ryozen]

http://ffxicalculator.com/

[Dfoley]

ffxi calculator doesnt do what this does, it is just strictly delcay calculation and doesnt allow for comaprison of DA / TA gear with haste gear.

I wish I had the skill to make it an online form or a .exe but excel is the extent of my knowledge. As far as haste per slot its not worth it since each piece of gear is basically a unique x/1024 value and without knowing it for each and every item it would never be acurate. Which is why some 25% haste builds are a true 25% and others are 24.3% or something.

stp is already done on ffxi calc, but i can see about adding it.

haste needed to cap is just that, the haste needed to reach the delay reduction cap.

[Ryozen]

http://bellsouthpwp2.net/k/i/kinematicf/FFXI/DPSSpreadsheets/

[Alkalinehoe]

inb4 naturebeckles.

[Ryozen]

Don't say that word. Suffice to say is one of the words the Knights of Ni! cannot hear!

[Zagen]

haste needed to cap is just that, the haste needed to reach the delay reduction cap.
I first read the comment as Haste from gear/spell and then realized you were talking about total delay reduction which isn't just "Haste".

[Arcon]

Funny you made that, I was just in the process of designing an online calculator for precisely that (and various other things, but the haste/delay argument made me do it). I had the idea a long time ago but never found the motivation to do it until yesterday, when I read some of the stuff on here.

If you wanna check it out, it will be here (but note that it's far from finished, and since I'm currently working on may get weird messages and stuff):
http://www.ffxiut.com/calc

Appreciate any input on that too. Can send me a PM on FFXIAH if you have any complaints or anything. All fields that show numbers should work correctly, the ones that don't I'm still working on.

Again, this is a work in progress, I have loads of ideas for that, like automatically calculating capped skills/attributes for jobs at various levels and other stuff. Any ideas are, of course, always welcome.

[Dfoley]

Okay after reviewing kinematics and ffxical i came to a few conclusions
1) FFXIcal is mostly crap, its got a lot of wrong calculations and doesn't allow you to freely set MA/DW to see what you need to cap delay reduction
2) Kinematics is amazing, dont get me wrong, but its more of a total package comparison of 'which gear set' will add more dd to TP and WS sets.

I was originally just interested in comparing Haste, DA, TA etc for all of my friends so they could see which would give them the most swings/min and or ws/min.

I updated the link in the first post to contain both a google docs version (not my favorite) and an xls version.

[Zagen]

ws/min.
This is why STP compared to Haste/DA/TA will matter :D I know you added it already at least to the google docs version.

And man I really need to see how much work it would be to convert your stuff to a web Form ~_~ not a fan of the weird spacing/formatting in the spreadsheet :D