Crossbow Mastery analysis and clarification

Discussion in 'Closed' started by smilinsphere, Feb 1, 2021.

  1. smilinsphere
    Offline

    smilinsphere Donator

    Joined:
    Jan 8, 2016
    Messages:
    254
    Likes Received:
    534
    Gender:
    Male
    Location:
    US
    IGN:
    LadyLeaf
    Level:
    18x
    Guild:
    [♛] DIVINITY
    Hey Royals,

    So I'm like one of the 5 people on this server that actually plays a marksman, so seeing the recent buff to 100% crossbow mastery in the latest update was nice to see. However, today I was going through my damage range calculator that I had made on Google Sheets, and I discovered that there appears to be a discrepancy on what the minimum range for crossbows is in-game, and what it should theoretically be. Essentially it's about 10% lower than what it should be.

    Initially, thought it was an issue with my calculator, but after checking the range with some of my other characters, as well as other people's characters, there doesn't seem to be any problem with my calculator as far as I'm aware. So that being said, let me go through some of the calculations that I did to get here.

    First off, let's talk damage range formula, I don't believe there's an official statement on what the damage range formula used in Royals is, but this one here appears to be accurate:

    MAX = (Primary Stat + Secondary Stat) * Weapon Attack / 100
    MIN = (Primary Stat * 0.9 * Skill Mastery + Secondary Stat) * Weapon Attack / 100

    SOURCE: (https://ayumilovemaple.wordpress.com/category/maplestory-formula/)

    Let's use my Marksman as an example:
    glarkenspokstats.png
    Total Dex: 882
    Total STR: 110
    Total weapon attack: 127 (xbow) + 12 (SCG) + 5 (PGC) + 3 (MoN) + 1 (2CLWR) +4 (blue arrows) + 15 (marksman boost) = 167 weapon att

    Keep in mind, in the calculation, the Primary Stat is also multiplied a value unique to each weapon type, for Crossbows, this value is 3.6. Also keep in mind all final values are rounded down to nearest whole number.

    MAX = ((882 * 3.6) + 110) * 167 / 100
    MAX = (3175.2 + 110) * 167 / 100
    MAX = 3285.2 * 167 / 100
    MAX = 548628.4 / 100
    MAX = 5486.284
    MAX = 5486

    So the max range value seems to check out as far as calculations go, now let's look at the MIN value:

    MIN = ((882 * 3.6) * 0.9 * 100% + 110) * 167 / 100
    MIN = (3175.2 * 0.9 * 100% + 110) * 167 / 100
    MIN = (2857.68 * 100% + 110) * 167 / 100
    MIN = (2857.68 * 1.0 + 110) * 167 / 100
    MIN = (2857.68 + 110) * 167 / 100
    MIN = 2967.68 * 167 / 100
    MIN = 495602.56 / 100
    MIN = 4956.0256
    MIN = 4956

    So as we can see, the MIN value calculated ends up being almost 500 range higher than what's shown in game. So perhaps the MIN formula is different for Royals? Well, to be absolutely certain let's use the same formula on a different class. Let's check out my NL:

    Lillithestats.png
    Total LUK: 942
    Total DEX: 142
    Total STR: 62 (yes, STR is actually used for NL's range too)
    Total Weapon attack: 73 (RC) + 15 (SGC) + 15 (BFC) + 13 (RCS) + 1 (2CLWR) + 29 (Cilbis) = 146 weapon att

    The primary stat multiplier for claws is also 3.6 and Mastery is 60%
    Also for claws, the DEX and STR stats are added up for the secondary stat value, so we'll be using 204 for that

    MAX = ((942 * 3.6) + 204) * 146 / 100
    MAX = (3391.2 + 204) * 146 / 100
    MAX = 3595.2 * 146 / 100
    MAX = 524899.2 / 100
    MAX = 5248.992
    MAX = 5248

    Once again, MAX value checks out, now let's see what the MIN comes out as:

    MIN = ((942 * 3.6) * 0.9 * 60% + 204) * 146 / 100
    MIN = (3391.2 * 0.9 * 60% + 204) * 146 / 100
    MIN = (3052.08 * 60% + 204) * 146 / 100
    MIN = (3052.08 * 0.6 + 204) * 146 / 100
    MIN = (1831.248 + 204) * 146 / 100
    MIN = 2035.248 * 146 / 100
    MIN = 297146.208 / 100
    MIN = 2971.46208
    MIN = 2971

    As we can see here, the MIN value is indeed accurate to what's actually shown in game, so this shows that the formula itself doesn't seem to be the issue here. So what heck is going on here?

    Let's go back to my Marksman and do the MIN calculations again, however, this time changing 100% for mastery to 90%:

    MIN = ((882 * 3.6) * 0.9 * 90% + 110) * 167 / 100
    MIN = (3175.2 * 0.9 * 90% + 110) * 167 / 100
    MIN = (2857.68 * 90% + 110) * 167 / 100
    MIN = (2857.68 * 0.9 + 110) * 167 / 100
    MIN = (2571.912 + 110) * 167 / 100
    MIN = 2681.912 * 167 / 100
    MIN = 447879.304 / 100
    MIN = 4478.79304
    MIN = 4478

    So what it seems to be the case here is that the Mastery is still only 90% rather than the advertised 100%. Now, this could be a number of different possible things, the value not being updated properly, a visual glitch, an incorrect value being used. etc. Also it's very possible that my numbers and calculations are still wrong and I'm completely missing something, so if that's the case let me know :p. Also, keep in mind that I don't recall my Marksman's range prior to the update, and I haven't done any in-game damage testing to do any comparisons, so all y'alls thoughts are appreciated. :)

    P.S. If anyone who's good with Google Sheets and stuff wants to show me how to share a docs in a way that let's more than 1 person use it at a time, let me know. I'm totally down with posting my Damage Range Calculator for anyone who wants to use it.
     
    Amaranthen, natsy, Joong and 15 others like this.
  2. Geyforlife
    Offline

    Geyforlife Well-Known Member

    Joined:
    Jul 30, 2017
    Messages:
    1,187
    Likes Received:
    2,616
    Country Flag:
    IGN:
    Geybrian
    Level:
    o7
    Guild:
    USSR
    Can confirm something might be up. The range that is displayed is the same as before --- as though mastery is still 90%.

    EDIT: also, this thread probably belongs in Report Bug section.
     
    Last edited: Feb 1, 2021
    Shnang and Tsue like this.
  3. smilinsphere
    Offline

    smilinsphere Donator

    Joined:
    Jan 8, 2016
    Messages:
    254
    Likes Received:
    534
    Gender:
    Male
    Location:
    US
    IGN:
    LadyLeaf
    Level:
    18x
    Guild:
    [♛] DIVINITY
    Yeah, in hindsight, this probably should've gone in the bug section, but since I wasn't entirely sure if this even was a bug or a deliberate programming decision at the time of writing, I decided not to post it there. I guess we'll leave it to the Staff's discretion whether to move it or not.
     
  4. LichWiz
    Offline

    LichWiz Well-Known Member

    Joined:
    Jun 21, 2016
    Messages:
    2,037
    Likes Received:
    4,412
    IGN:
    IronShichika
    Level:
    200
    Guild:
    Ironman
    Yea its definitely a bug, @Sen and @Dave Deviluke can one of you please move this to the bug section so it will get its proper attention? Thank u :)
     
  5. Dave Deviluke
    Offline

    Dave Deviluke Forum Moderator

    Joined:
    Oct 5, 2017
    Messages:
    10,954
    Likes Received:
    10,563
    Gender:
    Male
    Location:
    MapleRoyals Discord
    Country Flag:
    IGN:
    CygnusQueen
    Level:
    110
    Guild:
    WorldTour
    Shifted from Feedback to Report Bug
     
    Geyforlife, smilinsphere and LichWiz like this.
  6. Joong
    Offline

    Joong Developer

    Joined:
    Aug 9, 2013
    Messages:
    1,438
    Likes Received:
    4,620
    Hi, I believe we have resolved this for next patch via client modifications. Thanks for your report!
     

Share This Page