Onetime's Quick Draw Calculator V1.0.2Follow

I have taken an idea I saw with VZX's Corsair WS calculator, and modified to calculate Quick Draw, and I thought I'd share it with people who want to get numbers on their Quick Draws, instead of having to calculate manually. I hope people get use from it, and also if anyone with more knowledge on Quick Draw wants to help me modify it, I would welcome that, as this is my first venture if creating a calculator for anything FFXI related.

Also, any feedback, positive or negative, is welcomed and appreciated. If I suck, tell me so! I just wanted to provide something to the Corsair Community. And of course, much thanks goes to VZX, whose WS Calculator was the inspiration for this little piece. So enjoy, and I hope you get as much use from it as I do.


Click on or Copy and Paste the URL to download the spreadsheet.
http://www.teradepot.com/cqzudkll1i5w/QuickDraw_V102.xls.html

Edit: I guess it was clickable after all...

Edit: Uploaded V 1.0.1: Fixed AF Hat in calculation, and Changed Nimue's Tights to MAB +4 instead of +3

Edit: Uploaded V1.0.2: Changed Day/Weather Bonuses to be added together instead of multiplied.

Edited, Jul 10th 2009 6:36pm by ehalvorsen

Edited, Jul 10th 2009 7:48pm by ehalvorsen

Thanks for this.
Now if only we knew the QD Acc formula.

Only other thing its missing I believe is the obis?

SHOULD be an easy fix to include the hat by changing the formula in L-20 to read:
=(2*(B9+G32)*(1+(G30/100))*(L17))

Edit:
I'm still trying to figure out why I'm getting a 50dmg difference between formula and field though. Not sure what's causing it (Don't think its resists)

Edited, Jul 10th 2009 3:25pm by Lucavern

Just that, but it's of course significant.



Seems safe to assume day + single weather = 20%, as the only option not stated there.

Edited, Jul 10th 2009 8:00pm by Carrilei

Not 100% sure of the link you mean, but http://www.freewebs.com/vzx-01/ is the only one I have. There's a ranged WS calculator link there, just don't know if it's as recent as you were saying.

I wanted to hold out until I got a Mog Satchel to knock out all the Obi's (as well as 8x staves), but I may bite the inventory bullet and deal with it now lol.

Edited, Jul 10th 2009 8:33pm by Carrilei

I would imagine they're added (for instance, the 10% simply being added to the 25% = 35% for double weather + day).. But I wouldn't take my logic as fact, I'm no magic guru =/

2 * (Gun base DMG + bullet base DMG)*(1+(MAB/100))*(staff bonus)*(Day/Weather Bonus)


AF Tricorne as 10 MaB
2 * (39 + 70) * (1 + (MaB/100)) * (1.00) * (1.00)
2 * (109) * (1.1)
218 * 1.1 = 239.8.


AF Tricorne as 10 base DMG
2 * (39 + 70 +10) * (1 + MaB/100)) * (1.00) * (1.00)
2 * (119) * (1.00) * (1.00) * (1.00)
2 * 119 = 238


I thought that the AF Tricorne QD Enhancement added 10 base damage? It seems you have it as +10 MaB? As you can see it's a very close result, but just thought I'd point it out.

Nice work though overall, ehalvorsen.


Edit: Hmm, it does come to 238 though, I assume you have it act like 10 DMG even though it's in the MaB column? Nevermind me then!

Edited, Jul 10th 2009 9:28pm by Carrilei

I think the satchel's biggest impact on this game (you know, aside from the obvious 80 extra inventory) was the impact it had on the usability of obis. Prior to the satchel, I'd have said obis weren't worth having in many cases (and as such, I only owned 2.. ice and thunder for BLM).

The satchel allows you to have all the staves and obis with you at all times, write them into your macros full-time and yet pick exactly when you want to use them while retaining the ability to access them whenever. When the satchel came out, I picked up fire, wind and dark (again for BLM). When I finally realized ruins = double water weather duh, I picked up water (and earth cuz i use earth shot a lot) for COR.

Today did a bunch of Gotoh Za's (5 total) spanning earth, water and wind days. Simply swapped out my obi, cards and staves with the right day and landed nice QDs all event long. I keep ice n earth in my gobbiebag full time when Im trying for QD simply to land the para and slow boosts. Then pick the day of the week plus any matching weather and i'm set.

Armed gears tho need all 6 staves, all 6 obis, all 6 cards lol.

TDGSW you're on Pandy, no? Feel free to send me a tell if you wanna farm some organs =o

Guess it might not really be better than solo, but meh.

Edited, Jul 11th 2009 6:24am by Carrilei

On the left-hand side, it's under 'Damage Related.'

Yeah, to my knowledge that's how it works. I would wait for the RDM to Dia Sarameya then follow with light shot. Even though it will always "miss" because it can' sleep Sara, it will still influence the dia enfeeb.