General

Bowman

Bm Range Calculator Mm too sorta

I've adjusted @ryuushinou 's [url=http://www.basilmarket.com/forum/2612275]Mercedes Range Calculator[/url] to work for Bowmasters.

Clean and buffed ranges are correct.
[url=http://docs.google.com/spreadsheet/ccc?key=0AiJYQSoufKMhdDVHRFJEUjRQYVZtSk93RDZFRVlORXc#gid=24]BM Range Calculator[/url]

[header=update]Latest Update:[/header]
[i]BM Calculator[/i]
I now have Experimental (untested) calculations for Damage per Hit Non-crit/Crit working. %td and %boss multipliers should now be working as well.

[header=broken]Not working:[/header]
Passive Hyper skills

[header=add]To be added:[/header]
Theoretical Min/Max/Avg hits
Theoretical %/s sections
ADA/ABA

[header=test]Test:[/header]
Please, please, please, help me test this out and post your stats/skills if something doesn't add up correctly. Do note that your range is accurate only to +/- 1 currently and I am far too lazy to hunt down the rounding error at present time.

[header=howto]Instructions:[/header]
I have prevented the spreadsheet from being edited. However you may be able to make a copy in your own Google Drive or download it. From then on, ONLY you will be able to see your changes.

Enter your +attack, total dex/str, and any %att you may have from [b]all[/b] sources.
Don't know your attack? Calculate it using your existing range.
Input the level of your Kanna if applicable.
Input SP for each of your relevant skills.

Add any party buffs you may have.
Add any decent skills you may have.

[header=MM]If you are a MM[/header]
[url=http://docs.google.com/spreadsheet/ccc?key=0AiJYQSoufKMhdFhyczN6RDJJX1MybWJ6WExtMjVmekE&usp=sharing]MM Range Calculator[/url]
The range calculator for clean and buffed ranges has been tested. It appears to now be working. Please, please help test and report any errors along with your inputs so I can debug it!

March 18, 2013

22 Comments • Newest first

airforce1

@ryuushinou As I said, the MM calculator is completely untested. But it should work in theory with just changing the weapon multiplier and taking out AFA... Working copy is just for me to test additional features, I should really rename it lol.

Can you give me the stats you used and the actual range? I'll look into it. I'll also do some testing using my MM.
EDIT: I think I found the answer. My attack calculator somehow lost references to SkillDamage% (Kanna and SL).
Fixed it. Apparently I was dumb and left a hard coded SkillDamage% multiplier of 1.25 in the attack calculator instead of referencing the actual value. I also fixed a bug with Illusion Step in the MM calculator.

It appears to work for my MM now.

Reply March 24, 2013 - edited
ryuushinou

@airforce1: I went on my half stripped MM to test it out but I couldn't even get the clean range right . I tried both your MM and BM calculator.. They don't seem to work well(unless I was meant to fiddle with your working copy).

Just a few points to note: I've pin pointed where to round down for the max ranges for Mercedes which should give no error for MAX.. min is always off by 1 now though... I think.

Clean:
=rounddown(rounddown( W.Multi * (4*DEX+STR) * (ATT+rounddown(ATT*ATT%)) /100)*(1+PassiveD%))
Buffed:
=rounddown(rounddown(rounddown(W.Multi * (4*DEX+STR) * (ATT+rounddown(ATT*ATT%) /100) * (1+ActiveD%)) * (1+PassiveD%))

Found out that you need to round down each time you multiply damage% to your range.
PassiveD% - Kanna/SL
Active D% - TaC/Merc Buffs

Reply March 23, 2013 - edited
KurtCobaine

oh hey its the bm from twerk

Reply March 20, 2013 - edited
airforce1

Bump. I need more guinea pigs to test this to find out if it actually works.

Reply March 20, 2013 - edited
ryuushinou

@airforce1: It does? Okay no wonder skill charts go up to 33. zzz. Alright shall include that in mine as well..

Reply March 18, 2013 - edited
airforce1

@ryuushinou The difference is that the +1 passive breaks skill cap. I'm basically following the current template.

Reply March 18, 2013 - edited
DjFunky

Very nice, we need more of these

Reply March 18, 2013 - edited
Business

Nicee!

Reply March 18, 2013 - edited
ryuushinou

@airforce1: Re: Azwan Skill+1 and Equip +1s,

I'd rather the player add them up and enter it into the actual skill (given that only CO allows skills to go above max). Up to you I guess but if you're going to add one for Azwan.. add one for Equip Potentials.

@Dayias: Love that attack calculator too! It was my main focus when I was developing my calc.

Reply March 18, 2013 - edited
airforce1

@Dayias The stuff of the right hand side was just for my personal debugging and shouldn't been in the public version at all. All dex/str sources should be visible in the stat window and all att should be calculated based on range or manually added. There's not much point in iterating each one.

I do need to include the Azwan passive skill +1 option. I'd forgotten.

HP/MP calculator would be complicated because of the way the formula changed at Jump! update. It may be possible...

118822? You're range is nothing to be ashamed of! Mine jumped 15k in the last two weeks. Please include your dex, str, att, buffs, character cards, etc so I can debug it. Something like the the +dex from AB card might explain the discrepancy.
The upgrade feature doesn't even work yet lol.

Thanks for testing it out.

Reply March 18, 2013 - edited
Dayias

This seems really really cool.
Some minor changes to include would be things like:
- More options for where your att/dex/str sources come from (perhaps include an etc tab?). Because I know you're missing pet equips, android hearts, badges, and azwan inner ability for the attack section.
- Perhaps a way to calculate your HP/MP would be really nice too, though I understand that really has nothing to do with your range. I know a lot of people love to calculate out what their range will look like when they hit level 200, so why not have something to show what your HP/MP will be at max?
- Would be cool if your range wasn't on there so I didn't feel bad about my range

Other than that though, this thing is really accurate. My buffed range was off by ~1k, but I'm assuming that has to do with some sort of human error that I'm too lazy to figure out right now (For reference, my range is 118,822 buffed, but according to the chart it says it's 119,498... but I'm also not level 200). Using the "Calculate your ATT" feature gave me the same attack as I calculated by hand. Plus that feature is a super time saver. I haven't tried/tested the upgrade feature yet, but I'm sure I'll try it some day. This is really -really- cool though. I'm glad you spent time into doing this!(:
Thanks!

Reply March 18, 2013 - edited
bluebomber24

[quote=airforce1]@ryuushinou Which comments? I thought I got all the irrelevant ones... The hidden sheets should be hidden again. I haven't looked at them, but I wanted to keep them there in case something is useful.

Thanks, I'll do that. I was only planning to do some very simple %/s calcs for skills. It won't probably won't include the difficult stuff like rebuffing since that requires a lot of optimization calculations that I just don't have the ambition to deal with.

@bluebomber24 Just create a copy instead of downloading and you won't have to worry about any version problems.[/quote]

Now you know that I fail at reading instructions too. I will try to test tonight or morrow

Reply March 18, 2013 - edited
ryuushinou

@airforce1: LOL! You deserve a pat on the back

Oh and please bare with me... while I restructure my own spreadsheet to accomodate SE on sample damage outputs (but the main bone structure for the Skill chart is there so if needs be you can already extract it out).

Reply March 18, 2013 - edited
airforce1

@ryuushinou Fixed lol.

Guides and spreadsheets are both a pain in the arse... I consider this my community service for the year.

Reply March 18, 2013 - edited
ryuushinou

@airforce1: Check under "Buffed DEX".

Well neither do I. I haven't really touched on buffing durations. More on optimum damage output(and realistic in terms of skill order and execution timing). I've only been brought to the realisation recently that linked reinforcements are multiplicative to the main skill%(not sure how they work with each other though) so I have to completely restructure the theoretical DPM sheet.

But yeah...nearly done with the "Calculator" bit ... alot to do for skill breakdown and analysis(I don't have the patience to write a guide but I do have the patience for spreadsheeting!).

Reply March 18, 2013 - edited
airforce1

@ryuushinou Which comments? I thought I got all the irrelevant ones... The hidden sheets should be hidden again. I haven't looked at them, but I wanted to keep them there in case something is useful.

Thanks, I'll do that. I was only planning to do some very simple %/s calcs for skills. It won't probably won't include the difficult stuff like rebuffing since that requires a lot of optimization calculations that I just don't have the ambition to deal with.

@bluebomber24 Just create a copy instead of downloading and you won't have to worry about any version problems.

Reply March 18, 2013 - edited
ryuushinou

@bluebomber24: Yeah.. I took notice of that when I posted this thread on my thread. o.o

But now that I confirmed that @airforce1 has BM and MM under his hands, I might make a move on WH IF I can be bothered (I've already been reluctant to make the few tweaks on my main calculator because of all the trading/selling/buying in game due to Marvel).

Reply March 18, 2013 - edited
bluebomber24

[quote=airforce1]@bluebomber24 I added that to the instructions for slow people like you [/quote]

I can't use I have never updated to a new xcel. Going to have to convert the sheet later -_-" I am asusming this is good stuff. and much needed because the questions about range is kinda crazy.

Also....you guys are leaving WHs out. Kinda mean of you to not let them sit at the table.

Reply March 18, 2013 - edited
ryuushinou

@airforce1: When you have time, you may want to get rid of all the Mercedes references LOL (Comments and hidden sheets). I think you've made it so it doesn't refer to an external sheet?

When you do start working on the "upgrades" and sample damages you might want to regrab the new sheet I've created for the Merc Calc (Got rid of all the experimental DPM calcs I was doing[and sadly inaccurate]).

Reply March 18, 2013 - edited
airforce1

@bluebomber24 I added that to the instructions for slow people like you

Reply March 18, 2013 - edited
bluebomber24

So too me forever to figure out that I have to download it -_-

Reply March 18, 2013 - edited
ryuushinou

Made a link on my thread to yours. Post a link on the damage range thread as well.

Reply March 18, 2013 - edited