honeydrew

Mom
Gender
Male
Guildcard
42001503
helo i made dis

this is used to determine pretty much every possible damage value. it is a tool designed to compare combos and weapons against each other and therefore optimize on damage. i started making it to accurately compare 100h vulcans against 50h cvulcs (tl;dr obviously cvulcs are better but 100h vulcs aren't totally invalidated by cvulcs)

to use it, download it (File > Download as) and open it in your browser or other spreadsheet processor and read the simple instructions, located in the second sheet at the bottom (README: Instructions for Use). you wont be able to edit the value in the sheet until you download it and open it yourself.

let me know what you think!

PSOBB: Complete Damage Analysis by Honeydrew
click File > Download as.. > Microsoft Excel
once you have the file, you can open it in your web browser or other spreadsheet processor. i use chrome because i live in 2018

helo i calculated yunchang vs zanba on hucast against dal ra lie



17 july edit: added in LCK and effective crit chance, and factored them into average damage values. also fixed shifta value being buggo
26 july fix: shifta gain value corrected, now affects weapon max atp only instead of both min and max
 
Last edited:
looks like mine doesnt really have any features over that link, but i didnt know about it until now. mine is open source i guess lol. and shows a little bit more of the data used in calculation. and is more geared toward optimizing on what combo to use, along with averages

edit:edit:edit: that link has no mention of ATA. mine takes full advantage of ATA as a data point to calculate averages with and without factoring the likelihood of hitting/missing an enemy, and to use those averages with ATA to determine a practical answer for "what combo is best from what character onto what enemy"
 
Last edited:
This is great! Couple questions.

  1. It seems the Shifta toggle doesn't do anything and the calculation assumes LV30 Shifta at all times. Should be an easy formula fix in J16 I think. Would be cool to modify for levels of Shifta (maybe just 15/20/30 as those are most common).

  2. There is no output that says "HHS is optimal" explicitly, but I think if I'm understanding correctly the 'greatest value per column' row shows that, I just need to back into which type of attack each of those maxes is. So in the version you uploaded HSS would be the optimal for maximum average damage, correct?

  3. I don't see a modifier for LCK, although I don't actually know how LCK works in relation to NHS and critical damage multiplier. It may or may not impact the calculation depending on how LCK works (if it is a multiplier on damage dealt then the benefit of H and S multipliers is amplified and could overcome the lower hit success, if that makes sense).
 
This is great! Couple questions.

  1. It seems the Shifta toggle doesn't do anything and the calculation assumes LV30 Shifta at all times. Should be an easy formula fix in J16 I think. Would be cool to modify for levels of Shifta (maybe just 15/20/30 as those are most common).

  2. There is no output that says "HHS is optimal" explicitly, but I think if I'm understanding correctly the 'greatest value per column' row shows that, I just need to back into which type of attack each of those maxes is. So in the version you uploaded HSS would be the optimal for maximum average damage, correct?

  3. I don't see a modifier for LCK, although I don't actually know how LCK works in relation to NHS and critical damage multiplier. It may or may not impact the calculation depending on how LCK works (if it is a multiplier on damage dealt then the benefit of H and S multipliers is amplified and could overcome the lower hit success, if that makes sense).

duty calls. fixing now

edit: 1: fixed
2: correct, this one was for 40h typeME/Mechs from max ata/arp ramar with RR onto Arlan or some random inputs i threw in, idr.

edit: 3: fixed. luck stat now accounted for in an effective crit chance and factored into average damages (thanks a bunch SLU). luck doesn't affect light/hard/special attacks separately/inconsistently so it was easy to implement

glad you like it fam :]
 
Last edited:
looks like mine doesnt really have any features over that link, but i didnt know about it until now. mine is open source i guess lol. and shows a little bit more of the data used in calculation. and is more geared toward optimizing on what combo to use, along with averages

edit:edit:edit: that link has no mention of ATA. mine takes full advantage of ATA as a data point to calculate averages with and without factoring the likelihood of hitting/missing an enemy, and to use those averages with ATA to determine a practical answer for "what combo is best from what character onto what enemy"

well the ata cal is right here:
http://legacywiki.schtserv.com/atacalc.php
 
i know about the ata calc. most players that are into this do. my calculator takes a lot of work out of calculating actual practical damage values with ATP, ATA, %, DFP, EVP, and now LCK included. if you would prefer to use different calculators combined to get the same result then go right ahead but that is quite a lot more unnecessary time spent on it
 
Last edited:
Nice dude!

And the spreadsheet combines those two links to determine the optimal combo for maximum average damage output. It's not easy to see that from the Schtserv links as you have to manually multiply and also consider the impact of H and Sac multipliers.

Yeah I guess I wasn't thinking about LCK and math correctly - it's applied the same to N H and S so it doesn't change the optimal combo determination.
 
I see you use a slightly different formula compared to the one on the wiki (with regards to how the shifta boost is calculated). Is the wiki formula wrong and where does yours come from? Also, how does a MAG factor in?

Great work by the way.
 
Last edited:
I see you use a slightly different formula compared to the one on the wiki (with regards to how the shifta boost is calculated). Is the wiki formula wrong and where does yours come from? Also, how does a MAG factor in?

Great work by the way.
do you mean how the shifta level and multiplier arent mentioned in mine at all? if you scroll right on the spreadsheet youll see some more parameters including shifta atp modifier. not sure if thats what you mean but please clarify if not

thank you by the way, it took me longer than i prefer to admit but i'm proud
 
In your formula, "Effective Equip ATP max gained from Shifta" only affects max ATP. The formula in the wiki seems multiply the weapon ATP variance by the shifta factor and then add then onto the rest. It also talks about "Weapon base ATP", but I'm not sure about what that is.

I think your formula is correct and the wiki one isn't. Where did you get your info from? I'd like to edit the wiki, but I'd have to be sure first.
 
In your formula, "Effective Equip ATP max gained from Shifta" only affects max ATP. The formula in the wiki seems multiply the weapon ATP variance by the shifta factor and then add then onto the rest. It also talks about "Weapon base ATP", but I'm not sure about what that is.

I think your formula is correct and the wiki one isn't. Where did you get your info from? I'd like to edit the wiki, but I'd have to be sure first.
to my knowledge it does only affect the max atp rather than the min and max. its from testing in sandbox mode, taking a high atp variance weapon and testing its damage variance. something like Toy Hammer with variance 399, you can see that you can still roll dmg with it based on its minimum atp of 1 rather than increasing the overall atp result post variance. basically shifta just affects variance alone rather than any other value. but yes go ahead and edit the wiki. thank you for your contribution
 
Before downloading I didn't realize it can be used as a calculator. This calculator may look clumsy since it is an Excel stuff but actually it can be very multifunctional, it is very handy to calculate both damage and accuracy. I have dropped all the other calculators because this one just shows all necessary infomation in a better way. Nice work!
 
Last edited:
Back
Top