Magic Damage Calculator

Discussion in 'Guides' started by Plenty, Jun 26, 2015.

  1. Plenty
    Offline

    Plenty Well-Known Member

    Joined:
    Jun 11, 2014
    Messages:
    7,192
    Likes Received:
    7,771
    Gender:
    Male
    Location:
    California
    Country Flag:
    IGN:
    Plenty
    Level:
    200
    Guild:
    Hollywood


    This is my first time messing around with Google Sheets and using formulas online. Hope this helps you out! All you need to do is fill out your Magic, Int, base Attack and Mastery and it should show you your range!

    This sheet is based off this formula for figuring out Magic Attack:
    (Magic²/1000 + Magic * Mastery * 0.9)/30 + INT/200) * Basic Attack * Amp * Elemental Wand Bonus

    I might add DPS to this as well when I get the hang of it.

    Credit to Google Sheets
     
    Plenty, Jun 26, 2015
    #1
    irmy, EDelirio, Romina and 4 others like this.
  2. Eli
    Offline

    Eli Well-Known Member

    Joined:
    Aug 26, 2013
    Messages:
    3,676
    Likes Received:
    15,455
    Location:
    ht n chill
    IGN:
    Hannako
    Level:
    200
    Guild:
    Oblivion
    FIRST !!

    this is my favorite thing ever right now NGL

    ~1477-ish magic for 2hko o4 on bish :D
     
    Eli, Sep 17, 2015
    #2
    xxTuzixx, ImCanadian, Plenty and 1 other person like this.
  3. Neuroxide
    Offline

    Neuroxide Member

    Joined:
    Mar 15, 2016
    Messages:
    8
    Likes Received:
    3
    Gender:
    Male
    IGN:
    Neuroxide
    I can't seem to figure out what mastery is 0.o or where to find it...
     
    Neuroxide, Mar 15, 2016
    #3
  4. Shiyui
    Offline

    Shiyui Donator

    Joined:
    Jan 24, 2016
    Messages:
    1,285
    Likes Received:
    5,189
    Gender:
    Female
    Country Flag:
    IGN:
    Shiyui
    Level:
    200
    Guild:
    Fryslan
    Hello Plenty! :D

    I use your spreadsheet A LOT; thank you so much for making it! Just today I noticed that it seems like the base attack cell doesn't figure into the damage calcs. Whenever you might have the time, I'd be grateful if you could fix it. <3

    Have a nice day! o/
     
    Shiyui, Jun 8, 2016
    #4
    Plenty likes this.
  5. Plenty
    Offline

    Plenty Well-Known Member

    Joined:
    Jun 11, 2014
    Messages:
    7,192
    Likes Received:
    7,771
    Gender:
    Male
    Location:
    California
    Country Flag:
    IGN:
    Plenty
    Level:
    200
    Guild:
    Hollywood
    ~f17
     
    Plenty, Jun 9, 2016
    #5
    irmy, StrickBan and Shiyui like this.
  6. Shiyui
    Offline

    Shiyui Donator

    Joined:
    Jan 24, 2016
    Messages:
    1,285
    Likes Received:
    5,189
    Gender:
    Female
    Country Flag:
    IGN:
    Shiyui
    Level:
    200
    Guild:
    Fryslan
    Hello again Plenty!

    Recently, I noticed Google says your spreadsheet will be deleted soon. If you could sign in to take care of that, it'd be wonderful! Your calculator is too useful to be sacrificed for Google's storage space. ~f14
     
    Shiyui, Sep 18, 2016
    #6
    Plenty likes this.
  7. carcrash
    Offline

    carcrash Well-Known Member

    Joined:
    Aug 19, 2014
    Messages:
    381
    Likes Received:
    945
    Gender:
    Female
    Location:
    ur mum
    IGN:
    brakelights
    Level:
    199
    Guild:
    Boobs
    w0w summoning pl3nT ~f10 do u see dead people 2
     
    carcrash, Sep 18, 2016
    #7
    Plenty, Shiyui and Eli like this.
  8. Cyraptor
    Offline

    Cyraptor Donator

    Joined:
    Dec 9, 2016
    Messages:
    179
    Likes Received:
    378
    Gender:
    Male
    Location:
    California
    Country Flag:
    IGN:
    Cyraptor
    Level:
    200
    Guild:
    Guild
    Cyraptor, Jan 27, 2017
    #8
    L968 likes this.
  9. Shiyui
    Offline

    Shiyui Donator

    Joined:
    Jan 24, 2016
    Messages:
    1,285
    Likes Received:
    5,189
    Gender:
    Female
    Country Flag:
    IGN:
    Shiyui
    Level:
    200
    Guild:
    Fryslan
    George please fix. Best resource on forums is down again. ~f4
     
    Shiyui, Jun 26, 2017
    #9

Share This Page