Event Stats Calculator

Collapse
This is a sticky topic.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Event Stats Calculator

    Hello to all,

    I've built a new Google Sheets document, that when you enter the following information to the appropriate blue-background fields, will calculate your event boosted Power + Health for an entire team:

    - Hero Name
    - Event buff <-- Group(s), Hero(es), Faction, Rarity; Multi-criteria support as of 2015-02-20
    - Auras <-- Dynamic as of 2015-01-13
    - Fortification screen total Power + Health
    - Individual Fortification slot buffs

    The sheet is available here, or in my signature.
    Last edited by Cerberus; 02-20-2015, 01:46 PM.
    IGN: Cerberus, Richard Rahl, Malthael, Vish Kal
    Nexus Drop Tracking | Pack Drop Tracking
    Event Stat Calculator | Hero List | Consume Points

  • #2
    Looks absolutely awesome! I'll definitely be giving it a spin

    Comment


    • #3
      UPDATE:

      The sheet now dynamically does Aura lookups. There are a few Aura's not currently implemented:
      - Ser Pounce-A-Lot (both auras)
      - Black Nugly Sweater (2nd Health aura to Nugly Sweater Nugs)

      Additionally, there is now significantly increased Event Bonus support handling buffs by: Group(s), Faction, Rarity, or Hero(es).

      All data input has been moved to near the top of the sheet, instead of being spread out vertically into the individual hero math areas.

      Big thanks to Cassius for his research, data, and time on helping get this improved.
      IGN: Cerberus, Richard Rahl, Malthael, Vish Kal
      Nexus Drop Tracking | Pack Drop Tracking
      Event Stat Calculator | Hero List | Consume Points

      Comment


      • #4
        Originally posted by Pe Wa View Post
        Big thanks to Cassius for his research, data, and time on helping get this improved.
        No problem Pe Wa. You did all the hard work. I just got to have fun with the tinkering.
        Spectres are not trained, but chosen. Individuals forged in the fire of service and battle - those whose actions elevate them above the rank and file.

        476-422-246

        Triple member of the Barfspawnless Hall of Fame.

        Comment


        • #5
          Perfeeeect I tested it and it got the stats on the PVP now just right. So impressed. Thank you to you guys!!

          Comment


          • #6
            Since we have a new sheriff in town cleaning up the sub-forums (combining like threads, unsticky-ing the old, sticky-ing some new) please consider this one for a sticky. I'd hate to see all of PeWa's hard work fall to the bottom of the battlefield section.

            #sticky
            Spectres are not trained, but chosen. Individuals forged in the fire of service and battle - those whose actions elevate them above the rank and file.

            476-422-246

            Triple member of the Barfspawnless Hall of Fame.

            Comment


            • #7
              It seems a great job but to be honest I dont understand how it works ... Im slow with so many formulas ... lol

              Suggestion: Explain how to fill it, it's not easy for no nerds guys. If you want to make it usefull for a larger base of players you should make it easier amd explain how to fill it
              FOURTH INTERNATIONA HODA TOURNAMENT

              http://forums.capitalgames.com/showt...s-P2P-Showdown

              JOIN THE TOURNEY AND FIGHT AGAINST BEST HoDA PLAYERS

              Comment


              • #8
                Originally posted by Riccardo Busia View Post
                Suggestion: Explain how to fill it, it's not easy for no nerds guys. If you want to make it usefull for a larger base of players you should make it easier amd explain how to fill it
                On the calculator tab, there are coloured cells for a player to enter their data.
                1. In cells A7 thru A11, enter your five squad members.
                2. In the range of cells B12 thru K23, enter each hero's health and power stats to determine un-fortified attributes (from the fortification screen, as event buffs do not apply to fortifications).
                3. In cells B30 thru M37, enter the event buffs (and wildcard buffs).
                4. Your estimated event-buffed power will display in cells J7 thru J11, and health in M7 thru M11. (When in a pre-battle screen, you can enter your own event values in I7-I11 and L7-L11 to compare to the estimated values.)
                Spectres are not trained, but chosen. Individuals forged in the fire of service and battle - those whose actions elevate them above the rank and file.

                476-422-246

                Triple member of the Barfspawnless Hall of Fame.

                Comment


                • #9
                  New Updates:

                  Support for Event Bonus by Hero (full name only at current, Persona support to come later)

                  Support for Aura Bonus by Hero (full name only at current, Persona support to come later)

                  Multi-Criteria support added for combined Group/Rarity/Faction/Hero criteria on Event Bonus

                  Cleaned up Event Bonus area for clarity sake
                  Last edited by Cerberus; 02-20-2015, 02:21 PM.
                  IGN: Cerberus, Richard Rahl, Malthael, Vish Kal
                  Nexus Drop Tracking | Pack Drop Tracking
                  Event Stat Calculator | Hero List | Consume Points

                  Comment


                  • #10
                    @Pe Wa: Before I knew you were building this, I built a similar tool-similar data, but targeted to giving a strategic view of the interaction of auras, abilities and event boosts towards the goals of forming squads and their counters for each event.

                    One thing that may help simplify your tool:
                    Base stats (without any forts) are 30.77% of max power. This was tested true across 15 top toons at T4. There are small variances where the Gallery values are off by up to 4 units vs. actual. KCC may be off by a bit more, but the variances won't affect your calculations in any meaningful way.

                    Simplest: Let people look up their own blasted fort values and overall stats!
                    Next Simplest: People could just enter the stats they see in their roster, and you could lookup max value to calculate event boosted value (assumes toons fully leveled and T4)
                    Next Simplest: People enter roster stats, lvl and tier (you look up max value/tier, lvl gain stats)
                    Last edited by MAM_HoDA; 02-27-2015, 04:51 PM.
                    "Dan and his BloodMage buddies loved the sport of hunting for the rare goaten eggs. With each new egg, they increased their efforts and enthusiasm. Then Dan found the goat who laid the eggs. Dan soon had all the eggs and went forth to resume the sport he loved. But, the village was empty as his buddies could no longer find eggs nor the sport they loved. Dan threw down his eggs and left, realizing that while he did indeed love the eggs, he loved the sport and his buddies more. When other goats returned, there was only Smaug who yawned and went back to sleep..." With a start, Dan awoke from his nightmare and vowed to run from GOATS!
                    Enter your Nexus drops and see your odds: http://bit.ly/HoDA_Nexus

                    Comment


                    • #11
                      Originally posted by Cassius View Post
                      On the calculator tab, there are coloured cells for a player to enter their data.
                      1. In cells A7 thru A11, enter your five squad members.
                      2. In the range of cells B12 thru K23, enter each hero's health and power stats to determine un-fortified attributes (from the fortification screen, as event buffs do not apply to fortifications).
                      3. In cells B30 thru M37, enter the event buffs (and wildcard buffs).
                      4. Your estimated event-buffed power will display in cells J7 thru J11, and health in M7 thru M11. (When in a pre-battle screen, you can enter your own event values in I7-I11 and L7-L11 to compare to the estimated values.)
                      Thanks. I'm on phone now I will try it when using my pc
                      FOURTH INTERNATIONA HODA TOURNAMENT

                      http://forums.capitalgames.com/showt...s-P2P-Showdown

                      JOIN THE TOURNEY AND FIGHT AGAINST BEST HoDA PLAYERS

                      Comment


                      • #12
                        This is just what I needed, but some toons, like Calpernia, are not on the list
                        IGN Grand Magus
                        Ally code 278-282-573
                        Lvl 196
                        236/302 Legendaries aquired

                        "For the triumph and the power"

                        Comment


                        • #13
                          Still Alive winterme936 ??? i started a project like this but with some little changes, but i'm still on a ultra slow development... the only thing that is hard is to calculate Aura bonus based by toons group.. and toons like Varric+Bianca... and to make it recognize the aura target and accumulate between the 5 slots on squad... maybe one day i do it... but your help would be amazing. bye, send me a PM if you're not eaten by a dragon.

                          Comment


                          • #14
                            I still have data to enter for Winterwarden Land - Ludicrous, may I still enter these?

                            Comment


                            • #15
                              thanks for info...
                              keratoconus
                              Los Angeles Keratoconus
                              los angeles keratoconus surgery

                              Crosslinking cure
                              Keratoconus specialist

                              Comment

                              Announcement

                              Collapse

                              Forum Rules and Disciplinary Actions

                              These rules set boundaries to ensure that the EA Capital Games games and forums continue to be a friendly place where members can learn and share information on a variety of computing and non-computing topics. Heroes of Dragon Age and its forums are available to players 13 and older, refrain from excessive cursing/swearing. For more information, please see this link.

                              By accessing the EA Capital Games applications, users agree to accept that game administrators and moderators may remove any content submitted by a player as defined below. Users agree to EA Terms of Service as well. Misrepresenting oneself to engage in illegal activity will be immediately reported to EA for legal action.

                              Even though these are forums to allow free expression of ideas, there are other (real) people involved and one should respect their opinions and questions as ORIGINALLY POSTED IN THE TOPIC HEADINGS. Moderators are here to uphold and enforce the Terms of Service. Freedom to express your ideas, concerns, suggestions, and feedback, does not allow you the freedom of saying anything you want when you agree to the Terms of Service.

                              Unless otherwise stated, courses of action will be as follows:

                              1. First Offense - Warning
                              2. Second Offense - 3 day ban
                              3. Third Offense - 1 week ban
                              4. Fourth Offense - Permanent ban


                              If you have received a Permanent ban, this will extend to all future accounts created. If you are discovered to create a new account, it will also be banned.


                              What is not permitted in the discussion forum:

                              Advertising
                              Advertising or soliciting other members to buy, sell, or peruse any products or services including other applications or accounts, along with chain letters and junk mail.

                              Topics/posts that contain this will be both edited and closed or deleted, and an immediate 3-day ban will be issued without warning.


                              Hatred
                              Racism, bigotry, misogyny, hate speech, discrimination against any race, sexual preference, gender, or religion will not be tolerated.

                              All topics/posts will be deleted. Death threats, even joking, will be deleted and an immediate 3-day ban will be issued without warning, with further review from the Sr Moderator.


                              Flaming
                              Flaming includes material that is knowingly defamatory, illegal, abusive, threatening or harassing.

                              As with anything, you, as a member, should use good common sense when posting. In other words, you agree not to be a jerk. Posts containing personal attacks on another user will be edited/deleted at the moderators’ will.

                              Flaming or bashing of EA/CG, the devs, or the mods is not allowed. All posts/threads will be deleted.


                              Right to Privacy
                              You will not violate a person's privacy by publishing against another members will, information that is private and personal. Nor will you post private communication between EA Capital Games Support, other forum members, moderators, community managers, administrators, EA Capital Games employees, or partners of EA Capital Games on these forums or anywhere else.

                              Unless expressly endorsed by EA Capital Games, publicizing any correspondence of a private nature such as support tickets, email, Private Messages (PM) or chat logs thereof by any medium is NOT permitted.

                              Discussing or posting of another players spending habits will be deleted.


                              Spamming
                              Obvious spam (repetitive nonsense posts) will result in the poster permanently banned and all posts deleted.


                              Porn
                              Material that is sexually or otherwise obscene is not permitted on these forums.

                              Topics/posts containing such will be deleted on sight. Forum poster will be permanently banned from the forums.


                              Warez
                              Providing or asking for information regarding the illegal downloading of "warez", "gamez" or any other software protected by copyright.


                              Future Events/Promotions
                              Any posts or threads revealing future events or promotions that were not disclosed by the Capital Games team will be deleted.


                              Cross-posting
                              Posting the same question in more than one forum is not allowed. Should this occur, then only the thread in the most relevant forum will be left open; all others will be locked/closed and subsequently deleted.


                              Cheating
                              The use of any exploits or known bugs or editing of files in order to gain an unfair advantage while playing, will result in a permanent game and forum ban.

                              Accusing another player of cheating will result in your post/thread being deleted and a message sent to you, stating to refrain from further accusations. If continued accusations occur, a forum ban will result. If you believe a player to be cheating, send a PM to the Community Manager with as much detail as possible.

                              Please privately contact the Community Manager in order to submit an inquiry regarding this behavior.


                              Off-Topic Posting
                              Taking over a thread by posting excessively off-topic is not allowed. Off-Topic posts and any responses will be moved to their own, new thread if possible, or else deleted.


                              Political Posting
                              Because political beliefs, like religion, are a personal and sensitive topic, avoid posting about politics on the forums.


                              Customer Support Inquiries
                              All inquiries regarding Customer Support should be routed through the online web portal for support. The Community Manager and Moderators are unable to assist with inquiries regarding support tickets. Posting your ticket number and requesting assistance on the forums will result in the post being deleted. Sending a Private Message to the Community Manager or Moderators about CSR Inquiries is not to be tolerated, and will be ignored.

                              Additionally, all interactions with Customer Support are considered confidential, and all issues are handled on a case-by-case basis. As such, posts containing transcripts or results of your interactions with Customer Support will be edited or deleted.


                              Violation of these terms is grounds for removal from EA Capital Games games and a report to Facebook.


                              What should I do if I see objectionable material on the forums?
                              It is important that members recognize the real-time nature of this forum: the moderators cannot always monitor the contents of posted messages, and as such depend upon you to inform them when participants or their messages are violating our policy as stated here. You must also recognize that they cannot respond immediately to such notices and that some time may pass before any warranted action is taken.

                              To contact a moderator, please use the Flag Post function on the post represented by a flag:


                              What happens if I break the rules?
                              At best, your post will be edited by one of the moderators and you will be issued a warning. If the offense is more serious your post will be deleted. Posting "why was my post edited/deleted?" etc. will only make matters worse, so please don't. If a moderator has not sent you a message stating why, please send the Sr Moderator a message asking for a reason.

                              Should you have already been issued warnings and continue to break the rules, you will be issued an infraction - your posting privileges will be disabled for three days, but you will still be able to view the forums as a guest.

                              For persistent and deliberate rule-breakers your account will be "Banned". That means you are no longer welcome on these forums and/or games and your account will no longer function in them. If you re-register, your new account will be banned as well.

                              Posting Suggestions
                              In the attempt to create a compromise where everyone is happy, the following suggestions are also recommended:

                              1. Be civil and courteous. This forum is visited by people from all over the world, of different ages, genders, religions, and backgrounds, and are each entitled to their own opinion.
                              Also, see Flaming, Right to Privacy, and Hatred.

                              2. Make sure that your message topics fit the topic description of the forum in which you are posting. This is for your own benefit - for example, a question regarding a bug or problem should be posted in the Feedback section.

                              3. Use the search function before posting, particularly if the question is problem oriented. Most technical questions have been answered before, and solutions are freely available.

                              4. Make sure that you have followed #3 before posting

                              5. Read the sticky threads at the top of each forum - they are there for a reason, and generally contain information relevant to the forum.

                              6. Don't quote the entire message that you're responding to, only the pertinent passage. This makes it easier to read for other users.

                              7. If you find it easier to express yourself en français, auf Deutsch, en español, in Nederlands, in Italiano, or any other language, post in the International Discussion forum. Hopefully someone who speaks the same language as you will be able to assist you. All posts in other sections (non-International) of the forums must be in English, so please make use of Google Translate if you need assistance with translation. Posting in English will allow the widest range of people to assist you.

                              In addition to the Forum Rules, you are bound to the general EA Terms of Service both on these forums and in the game. Links to the TOS are as follows:

                              EA TOS English
                              EA TOS French
                              EA TOS German
                              EA TOS Russian
                              EA TOS Spanish
                              See more
                              See less
                              Working...
                              X