The ED Battle Mechanics Spreadsheet! (Full Version)

All Forums >> [Artix Entertainment Games] >> [EpicDuel] >> EpicDuel General Discussion



Message

PD -> The ED Battle Mechanics Spreadsheet! (3/12/2011 1:21:49)

Hello Fellow Duelists!

Today I present you the ED Battle Mechanics Spreadsheet! This handy Spreadsheet will help you win more fights, as you'll be able to know just HOW much you enemy will be doing in ALL Cases (For all normal, rage, and Critical attacks), AND you'll be able to see just how much luck factors your enemy has. After all, you would agree with me when I say that knowing that your enemy will have a 20% Crit Chance, 15% Deflect Chance, 2 turns left for rage, a 40% Block Chance, and 30% Stun chance is pretty useful and can help you make the right decisions to win. Simply, I call this the next evolution of ED Battle Tactics. Together with use of the Compendium and the ED Wiki, you'll have a HUGE statistical advantage against ANYONE you face (Except for the Staff lol).

This spreadsheet includes...

  • Damage Calculation including Skills that ignore defense, increase defense, and other skills that are based off of %'s.
  • Battle Record Calculations to instantly get your Win and Loss Rates.
  • Crit Chance Calculations to deduce the enemy and your chance to crit during battle.
  • Block Chance Calculators to show you just how risky it is to use a normal strike instead of using your unblockables.
  • Stun Calculators to show your and the enemy's chances to get stunned
  • Rage Calculators to not only show how much rage points you need to be able to use an attack with Rage, but also see how much rage points you got that turn.
  • And Finally... Deflect Calculators to show how the chances of you and your enemy deflecting Gun and Auxillary attacks

    The Spreadsheet is in a Google Document. The Link to the Public version is here: Link to the Spreadsheet

    I have set it to be View-Only. In order to use this, you must download it as an Excel Sheet to your computer. To do that, on the Document, go to File -> Download as -> Excel. This will make it so you can turn it into an excel that. Once you do that, I recommend saving it to your computer for future usage.

    Feel free to post comments and give corrections. I need a lot of feedback to make this the best it can be.

    P.S: I still need to get the Stat Values and the First Strike Chance Formulas. If anyone knows them, please pm them to me. Thank you!
    P.S.S: The ED Forum Rules don't really elaborate on things on this, so please move this to the correct section if needed.



    • King FrostLich -> RE: The ED Battle Mechanics Spreadsheet! (3/12/2011 7:15:52)

    Ahh, the simple statistics in this game. I know alot of this though but it's gonna take alot of time for me to pile up my info.



    Billybunz -> RE: The ED Battle Mechanics Spreadsheet! (3/12/2011 8:34:35)

    woo cool :D



    Snaipera -> RE: The ED Battle Mechanics Spreadsheet! (3/12/2011 8:44:56)

    For some reason , I Cannot fill the orange fields in . That's a shame ,this thing looks beast . Well done !!



    Luna_moonraider -> RE: The ED Battle Mechanics Spreadsheet! (3/12/2011 11:14:21)

    wow nice spreed sheet. it be great if u can fill up the orange boxes i really wat to know how much in average my atom smasher does.(i already know but just wnat to see if your calculation is correct)



    PD -> RE: The ED Battle Mechanics Spreadsheet! (3/12/2011 14:19:03)

    quote:

    I have set it to be View-Only. In order to use this, you must download it as an Excel Sheet to your computer. To do that, on the Document, go to File -> Download as -> Excel. This will make it so you can turn it into an excel that. Once you do that, I recommend saving it to your computer for future usage.


    That quote addresses the reasons why you can not edit the boxes. You have to download it first

    EDITL If you still cannot fill in the orange boxes after you download it, please tell me. I might need to upload it in another location if that's the case.



    Giras Wolfe -> RE: The ED Battle Mechanics Spreadsheet! (3/12/2011 19:35:25)

    Cool, thanks for posting!



    PD -> RE: The ED Battle Mechanics Spreadsheet! (3/12/2011 19:46:33)

    Somethings I found interesting when I was making this...

    1. Assuming Enemy Defense, Player STR Bonus, Weapon Base, Agility, and Focus remained constant, adding 1 point into Double Strike, Massacre, Bezerk, and other % Based skill only increases 2 points. HINT: This might be a good battle tip for some. :P

    2. Compared to the Block Rates, the max Deflect, Crit and Stun Chances are pretty low in comparison, and it's much harder to make a big difference on Stun and Deflect Chances.

    3. Rage buildup is actually really fast when you calculate it. Average is about 4-6ish turns until rage is ready.



    Aere -> RE: The ED Battle Mechanics Spreadsheet! (3/13/2011 15:24:42)

    Average of 3-4 turns, actually :P



    Page: [1]

    Valid CSS!




    Forum Software © ASPPlayground.NET Advanced Edition
    7.800293E-02