Wind Archer Range Calculator
[Header]Blabber[/header]
I can't guarantee the accuracy of the calculator yet as I don't have a KMS account. I'm still working on the damage calculator and I will get onto this when I have time.
Anyway, I know there's a fair few people already preparing for the WA revamp and awaiting eagerly. I aim for this to be a tool to estimate your range and eventually damage that you will do with the gear you have prepared.
[i]I have prevented the spreadsheet from being edited as it is. [b]However[/b] you may be able to make a copy in your own Google Drive or download it. From there on, ONLY you will be able to see your changes.[/i]
[header]Wind Archer Calculator[/header]
[url=http://docs.google.com/spreadsheet/ccc?key=0An5-TcCPsuLqdExpdmRTRzBZczVNNDlWeGhueEVfSVE]Link to the calculator on Google Drive.[/url]
[b]Remember: Make your own copy of the spreadsheet by going to [i]File>Make a Copy or File > Download As[/i][/b]
Note: Please accept minor discrepancies. However if you come across this please let me know. I may request for detailed information on how you have came across it if you don't mind.
[header]Vut, dis no mek sens![/header]
Sheet "1. Input Data" will ask you to insert information of your current self and future upgrades. Please note I have not catered for difference due to level increase (AP and SP). [I may add options to allow for this.] Your buffed range can also be previewed at the top few cells of the sheet which should follow you as you scroll down.
[b]Sources for PDR:[/b]
Equipment - You will need to add this in.
Link Skill - You will need to add this in.
Albatross Maximum (15% at MAX) - You will need to add this in.
Emerald Dust - No need to add this in. [i]This is already included as an option in the next sheet.[/i]
Sheet "2. Calculator" will show your summary, range and your damage. The damage calculator will require you to input the skill level of your attacks (you can select "Y" for Are you level 200? to skip this).
[b]Damage Calculator [/b]
Pinpoint Pierce: Shoot two arrows to pierce the exact same spot on 1 enemy, dealing 340% damage 2 times. If you attack the same enemy multiple times, it will gain a debuff that increases your damage to it by 20%. (max level: 20)
Emerald Dust: Emerald Flower is strengthened, becoming better in combat, increasing its HP by 40,000 and duration by 20 seconds, as well as decreasing the defense of monsters around it by 10% and reducing your damage taken by 20%. (required skill: level 10 Emerald Flower) (max level: 10)
[b]Other ways to use this calculator:[/b] - Applies only after WA release.
How much DEX do I have on my equips? [b]Equips DEX[/b] on sheet 2 will give you your dex from Equips and passive skills(such as link skills). Subtract the DEX you receive from these passive skills and you will have a total that give you how much dex you obtain purely from equips. [This value takes out DEX received from potentials].
[b]Please do not hesitate to ask questions. Just make sure you tag me, ("@"+"BasilID" to tag) so I can respond to you sooner.[/b]
[header]Current Issues with Calculator[/header]
@ProHealer: Since there's no stat UI to look up values you cannot work out theoretical total dex.
[b]What I have done[/b] - I have made a temporary cell where you can input the total dex from your prepared equips. The "total dex" will be turned into a 'blue' cell until WA is released here in GMS.
[i]Note to KMS testers[/i](if there are any): Override/write the Total dex by looking at your stat UI and ignore the Equips dex/str cells to the right of the main column.
[Header]Other Archer Calculators[/header]
BM/MM: Thank @airforce1 for his efforts to adapt my calculator to work for [url=http://www.basilmarket.com/forum/2622026]BM/MMs[/url].
WH: Let's hope someone wants to make the effort D; .
Mercedes: http://www.basilmarket.com/forum/2612275
32 Comments • Newest first
The Wind Archer Calculator has now been changed to Post-release settings.
Cells that previously calculated your total dex/str has now being removed. Once it is released you can use the calculator by opening your stat UI.
Please expect discrepancies a week into release while I fix minor errors and misunderstanding of skills (and I'll be busy enjoying WA more importantly).
This looks better than the Merc calculator, at least when I last looked at it. Amusing growth in presentation.
@FwuffehStarz: That would absolutely depend on your gear? and the gear you have prepared but can't equip due to level restriction.
Pre-revamp range is simply you logging into your character. Post-revamp range is you inputting your assumed total dex(I might need to make something to help calculate this) and % stats. Then what you can do is add more onto it by inputting numbers in the "upgrades" section which'll show you your post-140 range.
@ryuushinou Do you have a raw answer too how much my range would be compared pre revamp to post?
@wynn: Depends on your crit rate but for argument's sake I'll just assume 90% crit.
Without=0.9*(1.8+1.35)/2+0.1=1.52
With crit ring=0.9*(1.8+1.55)/2+0.1=1.61
Which means a crit ring would allow you to do x1.06 much more damage. 10 attack probably will mean less the more you're funded(if you have more than 200att, the crit ring is likely to do more damage).
would a cruel ring which adds 20%min crit be better than 10 attack ring
@ryuushinou: ahhh, I guess it doesnt work on excel :S woops hehe
Great calculator! Calculating my range just makes me even more excited for the revamp although it's still not going to be 100% as I still have a lot of upgrading left to do.
Love the contribution you always make towards archers and basil stuff alike @ryuushinou
[quote=Cincinna]I have to say, you must be one of my favourite basilers at this point x3 So helpful, and a long time WA fan as myself c: Thanks~[/quote]
Also have to agree with this
Keep up the great work!
@FwuffehStarz: Could you elaborate on your question?
You enter your equipment stats and/or assumed stats you will have => Calculator spits out your range and damage you would do with primary skills.
[edit] Just saw your other post.. and it seems to be working fine. Have you made a copy to your own google drive? You can only make your own edits after making your own copy of the calculator.
How does the range calculator work..? Is it like completely separate from everything else?
@TurtleClaus: That'll be part of "Total" DEX, as equipment potentials will stack with this.
So for now you'll have to add up the estimated DEX you will receive from your equips +30 from PT. Otherwise the %DEX you get from MW and Blessing is incorporated through the skill list.
This calculator will make more sense when WA has been released. It's more like a range preview for now (for people who already have their gears prepared).
@razormana: nice .
[Edit] Using back substitution I worked out the information below. Could you confirm this is the case?
Total DEX: 3057 (Provided)
Base DEX: 778 (Provided)
Total STR: 600 (Provided)
Base STR: 4 (Provided)
ATT: 367 [b](Need confirmation)[/b]
ATT%: 15% [b](Need confirmation)[/b]
Total ATT: 421 [b](Need confirmation)[/b]
Total Damage %: 10% [b](Need confirmation: Do you have a DA link skill? or equips that give TD%?)[/b]
This gives me the exact clean range you have.
I can't get your Buffed range.. so I'll look into this.
@ryuushinou: Yea i kind of dont have it, and my range will be changing very soon.
As today i just got a full CRA set, Fafnir bow and a tyrant cape.
@razormana: Wow a tester! Yay! . Will do that right away. Before I get into some reworking of the calculator(as I suspect that Wind Blessing is not doing what I expect it to do...) can you show me a screen shot of what your 2nd sheet looks like? The "review your summary" section, as this well help me work out the differences.
Also from looking at your stat UI, they don't show you how much ATT you have?
Either way there's a big difference I'm not accounting for so I'll review it.
@ryuushinou This is looking to be a decent calculator. Can you please add in a 0 for skills levels of some skills. As i have no points into cygnus knights as of right now.
IDK if i have done something wrong, but when i am comparing this calculator to my real range,
the clean range is off by ~30k min/max
and the buffed range is off by about 45-50k for min/max.
http://i.imgur.com/mS0opn6.png?1 is the calculated ranges.
http://i.imgur.com/YFhNx7J.png?1 is my clean range (soul is at 0 so giving no atk)
http://i.imgur.com/fkiJWfP.jpg?1 fully buffed (still 0 on soul)
@airforce1: Damage calculator is fixed. Almost ready for whatever you have planned. I'll just do minor touch-ups and look into the STR not affected cell.
By the way I've looked into the cells and I think I've consolidated the formula regarding upgraded DEX/STR to not require the "DEX/STR not affected by %" cell. It's purely for the purpose of calculating how much DEX you receieve from Equips or passive skills.
As such I think I'll remove that STR% cell when WA is released.. I don't think anyone would be partocularly interested in how much STR they have in equips/passive skills.
@ryuushinou: It should take you under 5min lazy!
@airforce1: You know I hate adding effort for users (It's only really useful for the minor range increase from STR%/all stat% upgrades) But yeah I'll fit a space when I'm done with the damage calculator.
@ryuushinou: You still need to remember to add a STR not affected by % cell as well.
@DjFunky: Yes yes it will LOL. I'll be working on that in the next few days.
@ryuushinou Tnx for making this! Your hard work is much appreciated
I guess the dmg calc will include WA skills instead of Merc skills when the class is revamped, right?
I would only have 202k range with the gear I have right now.
After cubing it seems I would have 487k range with a fully scrolled and cubed(at least 15% ea) RA set + tyrant set(5stars ea) + 3 part Alien Frag set + Random stuff.
I wonder how much dmg I could do with Sky's song.
@ProHealer: I think I'll just add another temporary cell next to it and to ask for some understanding that there'll be discrepancies due to some dex not being included or ignored.
Btw thanks for picking that up
@ryuushinou
Right. Seems like we are able to pull every value needed for total DEX from either another row in the table or generic WA skill information. Perhaps we could look into just pulling those values into a calculation instead of asking for an input. (Unless we are missing something else needed for that specific value)
@ProHealer: It's not 'redundant' but it's hard to work out as there's no stat UI to look at (duh WA is not released - didn't think this through).
Usually(if you've used any of the recent range calculators in the archer forums) you're only required to read-off your stat UI, which is dex from equips, skills, character cards and %dex. Due to there being alot of sources you may mis count it was best to rely on what was given. i.e. Base DEX and total dex. Dex% needs to be counted to work out the bonus dex you get from MW and potential acting on it. So no it's not redundant at all.
The problem here is that as I have mentioned there's no point of reference until WA is actually released. My only suggestion is that if you already have a BM, read it off there or otherwise manually working it out.
Total dex= Equip dex+dex from character cards+dex from skills+base dex+dex% affecting on all your dex sources except character cards and inner ability
Oooh i cant wait to try this out, I was just wondering what my range would be today too. Thanks for making this
I have to say, you must be one of my favourite basilers at this point x3 So helpful, and a long time WA fan as myself c: Thanks~
[quote=ryuushinou]@ProHealer: Use GoogleDocs. In fact I recommend it over Microsoft Excel as the formula in google spreadsheet do not always work in Excel. Make a google account and follow the steps in the Opening Post.
@airforce1: Does that mean you're rushing me to complete the damage calculator? Give me 2 weeks for it to be ready for export![/quote]
Alright, one more question, where are we supposed to find "Total DEX" from, for the first section? Do we need to add base dex + dex from equips + %dex? and in that case isn't it redundant?
Thanks
@ProHealer: Use GoogleDocs. In fact I recommend it over Microsoft Excel as the formula in google spreadsheet do not always work in Excel. Make a google account and follow the steps in the Opening Post.
@airforce1: Does that mean you're rushing me to complete the damage calculator? Give me 2 weeks for it to be ready for export!
@ryuushinou: Well the idea would be to just use attack from non-skills. We'd have to deduct passives like AFA.
IMO there's no reason not to just merge the two calculators since many people will play both or at least want the comparison and I never did get around to converting to your user friendly format.
It's probably easier for me to do the importing rather than have you try to figure out what I did so I'll probably get started on it next week.
Cool - out of curiosity, any alternatives for those of us without Excel?
@airforce1: Uhh. I'll think about it but isn't it just entering the same value in a different calculator?
I can sort of picture importing my spreadsheet on the back of yours and my ouput having a switch to extract values from your BM calculator(or the other way around). I don't think I'll do this just yet though.. need to get my head around the damage calculator. o.o
(I feel so avant-garde, when there's no WA sub-forum to post this in... I wonder if mods could move it for me when it does get created...)
Edit: Just realised that because I heavily rely on the att shown in the stat UI I'm gonna have to go through the trouble of plus/minus attack when switching between BM/WA
@ryuushinou: I've had this idea for a while, but I'd love to have a BM<->WA conversion/comparison of range and damage. I'm not sure if you want to do it or I can make it my contribution