+- Southperry.net (https://www.southperry.net)
+-- Forum: Maplestory (https://www.southperry.net/forumdisplay.php?fid=15)
+--- Forum: Training Center (https://www.southperry.net/forumdisplay.php?fid=32)
+---- Forum: Bowman (https://www.southperry.net/forumdisplay.php?fid=47)
+---- Thread: The Archer's Book; A Post-Big bang Archer Calculator. (/showthread.php?tid=28733)
Pages:
1
2
The Archer's Book; A Post-Big bang Archer Calculator. - WayOfTime - 2010-08-07
Hello, Southperry! I would like to introduce my latest project, which is still in it's infancy. As many of you know, the BigBang update will change the face of the Maple World: massive buffs to skills, Victoria is shuffled around, and the biggest change of them all ... Archers will actually miss on stuff! Mainly because of the afformentioned buff, I have started to create, -insert burst of confetti- The Archer's Book!
Since the game mechanics have changed so much, I felt that it would be prudent to make (I hate to say this) a replacement for Sybaris's own calculator, which has been a staple for the Archer community at large. My only hope is that you will at least give me a chance and see how well I can do. This calculator will have what all archers would need on the field: Max and Min damages (critical and normal), Average damages per shot, chances to KB, skills, a monster table, and more! With a few clicks of the mouse, and some mild intuition, you will be able to tell all those things needed when you go train (except if you will die suddenly)!
Enough of the selling pitch, here is some real information. The data shown is in it's pure infancy, where most of the formulae were gathered directly from the southperry threads. Therefore, some of this data can and will be faulty, but I will fix it to the best of my abilities when a solution is found. That being said, I usually double or triple check all the formulae before inputing them; they are the most efficient a crazy mind like mine can think of
.The front part of the calculator is reminisent of Sybaris's own design, but with its own HUD and new way to introduce skills, it could be seen as sleeker.
![[Image: 1zp1ws4.png]](http://i35.tinypic.com/1zp1ws4.png)
Also, the monster table that is used is courtesy of our very own Fiel. Give him a round of applause!
![[Image: 28ugw8i.png]](http://i38.tinypic.com/28ugw8i.png)
Past Update: Version 1.1 Beta
Past Update: Version 1.2 Beta
Past Update: Version 1.3
Past Update: Version 1.4
Past Update: Version 1.5
Oh golly, Ms. Molly! This is a big one! I have now introduced the Potential System. The current windows in this system are % atk, % total, + critical chance, and + critical damage. I will add +Skill points eventually. I will then need to update the monster table to be able to distinguish if the monster is a boss, to be able to add a +% boss damage.
The data now is cleared up to look clean when there are no skill points added.
Version 1.7 (Vista)
Version 1.7 (2003)
I am starting to run out of ideas. If you have any ideas, please tell me!
Have fun, guys!
P.S. If any people as an archer can either a) take screen shots of their damage (with equips shown and range), or b) notify me if the skills are all right percentage-wise, let me know!
The Archer's Book; A Post-Big bang Archer Calculator. - Rob - 2010-08-07
Looks really awesome my man. I hope this works well.
The Archer's Book; A Post-Big bang Archer Calculator. - WayOfTime - 2010-08-08
The calculated is now in V 1.1 Beta. If you have any suggestions, please notify me by either this thread or a PM. I am still looking for someone with an archer who would like to be on the calculator. Any help is welcome!
The Archer's Book; A Post-Big bang Archer Calculator. - WingZero - 2010-08-08
Is there a way to integrate Potential bonus?
The Archer's Book; A Post-Big bang Archer Calculator. - larmie - 2010-08-09
WayOfTime Wrote:Hello, Southperry! I would like to introduce my latest project, which is still in it's infancy. As many of you know, the BigBang update will change the face of the Maple World: massive buffs to skills, Victoria is shuffled around, and the biggest change of them all ... Archers will actually miss on stuff! Mainly because of the afformentioned buff, I have started to create, -insert burst of confetti- The Archer's Book!
So how come there's no miss rate? :/ Not that most archers, wind shooters, thieves and night walkers wouldn't normally miss anything below their level. You only need an accuracy of 225 and that translates to 188 DEX or 225 LUK which translates to level 3x.
Still seems like a useful tool to calculate how long it takes for you to solo bosses.
The Archer's Book; A Post-Big bang Archer Calculator. - strobli - 2010-08-09
larmie Wrote:So how come there's no miss rate? :/ Not that most archers, wind shooters, thieves and night walkers wouldn't normally miss anything below their level. You only need an accuracy of 225 and that translates to 188 DEX or 225 LUK which translates to level 3x.
Still seems like a useful tool to calculate how long it takes for you to solo bosses.
There's a "Hit Chance" right under the monster's name although it is rather small.
Anyway this is looking really nice but I think you should have both an "Average Hits/Kill" and a "HKO Range" column like in Sybaris' old calculator. I thought both were really useful and they can fill some of that blank space. Also I think it'd be useful if you left the monster table cells unlocked so anyone can add in newer monsters themselves without you having to update the calculator all the time (I assume you'll be locking the file in the future so take this into consideration). Oh and you'll probably need to add in a way for us to add in our potential bonuses as well as effects from things like the critical ring. Just my two cents.
The Archer's Book; A Post-Big bang Archer Calculator. - JoeTang - 2010-08-09
There's some sort of error in how some of this damage is calculated. I'm not 100% sure what it is, and I'll try reviewing it afterwards, but I am almost 100% sure I can hit higher than what's rated on this calculator with the exact stats. Arrow Blow for sure seems to be heavily understated.
Part of it appears to be an issue with how Weapon Defense is associated with damage.
Level 61
60 STR
287 DEX
91 + 6 WA
1018~1566 Range
Against monsters with 150 WDEF, I can still hit near what the calculator tells me with 0 DEF. For example, I only have 1 Arrow Blow with maxed Fundamentals; however, I can hit over 4200 with it despite this telling me my max Critical is 3688. I can also hit over 3300 on non-criticals despite the calculator displaying 2719 as my maximum damage on a monster with 0 weapon defense.
![[Image: 4294.png]](http://img37.imageshack.us/img37/8880/4294.png)
![[Image: 3323z.png]](http://img190.imageshack.us/img190/7678/3323z.png)
My personal calculations tell me I can hit over 5k on a 0def monster with Arrow Blow alone, but I've yet to see it since I'm in KFT.
On the other hand, your Double Shot numbers seem a bit too high. It appears you've mixed up the damage bonuses from Fundamentals.
Arrow Blow:
=IF(AB>0;AB*0.03+1.4;0)+(Fundamentals*0.1)
Double Shot:
=IF(DS>0;DS*0.03+0.8;0)+(Fundamentals*0.06)
The Archer's Book; A Post-Big bang Archer Calculator. - WayOfTime - 2010-08-09
Ok. Let me start at the top:
I am planning to add a potential bonus area right next to the main stats area, but it is hard to tell how big it will need to be. It appears I will need atleast the following: % Total Damage, % Total Attack, +% chance, +minimum crit, +maximum crit (I do not know if these will be needed), +overall critical damage, and +All skills, when I learn what the max is for the skills and learn if this only affects 4th job. The +% dex and other apparel can be added normally for now until I manage to get MW up, and then it can go in "Equip Stats." There may not be a dedicated area for critical rings, but you can add the effects under +% crit chance (I will insert a comment in said area).
As Strobli said, there is a miss rate, but it is currently called "Hit Chance." Granted, it could be bigger, but it is still there (Bow chicka bow wow). Accuracy does next to squat for a character these days, where it isn't even worth focusing on even for warriors: with no accuracy equips at all, and just their basic mastery, at level 180 you would miss only 18% of the time.
I will add in those two columns in a new update, most-likely Version 1.3 Beta. V 1.2 Beta will be posted below, to alliviate some glitches. Most likely after Average Hits to Kill and HKO range, I will add Experience per shot.
Thanks for catching that, JoeTang. I updated the calculator and will add it below, and to the main post (may take a few seconds to update after I post this). Is the critical multiplied or added? When I updated the calc, it said that your max turns to 3003, and your crit max is 4504. Assuming that your mob you are attacking is a Hodori, it may be possible that a) critical is additive, b) defences are calculated AFTER the skill is calculated (no longer is taken from max/min subtracted by defences), or c) an amalgamation of both. I am leaning to the misterious d) which states that defences are calculated differently. No way to find out currently without very thurough testing.
Ah well, here you go: Version 1.2 Beta. Let me know if you find anything else, or have any brain waves; I am open to them.
The Archer's Book; A Post-Big bang Archer Calculator. - JoeTang - 2010-08-09
My bad, I just noticed I typoed 91 + 6 when it was 91 + 5. Point still stands. I want to lean towards the side that says monster defense is meaningless. Another point in the difference is that level 1 Arrow Blow does 143% damage in KMS, as opposed to 133% damage in KMST. Likewise, Double Shot does 10% more per arrow in KMS than in KMST as far as the most recent extractions have seen. But none of these account for the almost non-existent decrease posed from defense.
There's absolutely no way criticals are additive by the way as I otherwise would be able to easily hit over 5k per arrow on Double Shot. I'm just barely able to shy past 4k.
The Archer's Book; A Post-Big bang Archer Calculator. - WayOfTime - 2010-08-09
Maybe it wouldn't be a plus 150%, but a measly +50%. Obviously, it is just speculation. If you notice any other differences, skill wise, let me know. It looks like WDef does nothing, but the calculator says that you can hit 5k.
Crack. I just ran the numbers. You said you can just barely pass 4k? I used a hand-held calculator, and it says that if it is +50% damage instead, you would hit a max critical of 4128 damage, discounting reductions of defence. If this is true, this will majorly suck. It shows you do 42xx, so this may be wrong.
The Archer's Book; A Post-Big bang Archer Calculator. - JoeTang - 2010-08-09
WayOfTime Wrote:Maybe it wouldn't be a plus 150%, but a measly +50%. Obviously, it is just speculation. If you notice any other differences, skill wise, let me know. It looks like WDef does nothing, but the calculator says that you can hit 5k.
Crack. I just ran the numbers. You said you can just barely pass 4k? I used a hand-held calculator, and it says that if it is +50% damage instead, you would hit a max critical of 4128 damage, discounting reductions of defence. If this is true, this will majorly suck. It shows you do 42xx, so this may be wrong.
If it was just +50% I wouldn't be able to hit my amazing high 6ks on Iron Arrow. It's multiplicative.
The Archer's Book; A Post-Big bang Archer Calculator. - WayOfTime - 2010-08-09
Updated the calculator to include Average hko, HKO range, and exp per shot. The rest of the information is under the new spoiler.
The Archer's Book; A Post-Big bang Archer Calculator. - Dusk - 2010-08-09
Ctrl-click all the cells you want to be alterable, right click one of them and go to Properties. Set all the cells to be unlocked. Then you're free to protect the sheet without any problems getting the calculator to function.
The Archer's Book; A Post-Big bang Archer Calculator. - WayOfTime - 2010-08-10
It does function, but I forgot to get the cells where the check boxes change. Since it was late I did a general "pineapple it."
The Archer's Book; A Post-Big bang Archer Calculator. - IceMan - 2010-08-11
can you make the 2003 version?
The Archer's Book; A Post-Big bang Archer Calculator. - WayOfTime - 2010-08-11
Added a 2003 Version as requested. Read the spoilers for more info on this update!
The Archer's Book; A Post-Big bang Archer Calculator. - IceMan - 2010-08-12
thank you very much!!
The Archer's Book; A Post-Big bang Archer Calculator. - Bennie Boy - 2010-08-13
I'm sorry if I'm being really ignorant of something, but will you be adding Bowmaster skills like Hurricane, Inferno and such?
Also, does anyone know the version of Excel that Google Docs is more fond of, and could you make a version of this for that?
The Archer's Book; A Post-Big bang Archer Calculator. - JoeTang - 2010-08-13
Bennie Boy Wrote:I'm sorry if I'm being really ignorant of something, but will you be adding Bowmaster skills like Hurricane, Inferno and such?
Also, does anyone know the version of Excel that Google Docs is more fond of, and could you make a version of this for that?
There's a radio button on the top right to change to bows. I think the 2003 version might work for Google Docs. I know the latest versions of Excel have compatibility issues with OpenOffice, so I couldn't see the radio buttons on the first version. Luckily, I'm a Crossbowman.
The Archer's Book; A Post-Big bang Archer Calculator. - Bennie Boy - 2010-08-13
JoeTang Wrote:There's a radio button on the top right to change to bows. I think the 2003 version might work for Google Docs. I know the latest versions of Excel have compatibility issues with OpenOffice, so I couldn't see the radio buttons on the first version. Luckily, I'm a Crossbowman.
OMG! I can't believe I missed that! Thanks heaps!
Also, this is what I get when I upload the 2003 version to Google Docs. The Vista one is a whole lot worse.
![[Image: bookas.png]](http://img514.imageshack.us/img514/8841/bookas.png)