How many gems does it take to get to XXXXX banners in pvp

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

  • How many gems does it take to get to XXXXX banners in pvp

    This sheet will tell you how many gems/fights/refills it will take to get to XXXX banners in pvp.
    The raw data amounts of when banners change seems to vary a little bit so this is averaged between the people that collected it. ( We will continue to modify as necessary ) currently this is EXTREMELY close to being accurate but additional data will be added as its sent to me.

    https://docs.google.com/spreadsheets...it?usp=sharing

    Enter your current banners and your desired banners .... thats it

    special thanks to a few people for their HUGE contribution to this work in progress
    @pe wa ( for me failing on sheets ) ( #sheetexpert )
    @littleblackjoe
    @primorac
    @mam_hoda ( data collection and feedback )

    if you have collected banner change points when pvping please feel free to inbox me or @pe wa and we will continue to optimize the sheet to get the most accurate result

    several other threads on this topic have been posted but will link ( and get combined )
    http://forums.capitalgames.com/showt...each-x-banners

    #sticky

    :edit 2/2 all fixed and locked correctly ( thanks solely to PeWa )
    Last edited by winterme936; 02-02-2015, 10:23 AM.

  • #2
    +1. Really great work and effort that will help out pretty often when people (especially F2P) have to decide wether its worth to participate in an event or not.

    To those who want to try it out:
    Current banner has to be set to >0 as it doesn't reflect a 0 banner start yet. Furthermore the gem cost for >10k banners seem to be rather inconsistent compared to what we actually spent, so I'd suggest that anyone who goes for top bracket rewards: please collect data from above 8k so the winter can do a fine-tuning.
    However the gem estimates up to 10k banners are really accurate if not perfect (in a 0 loss streak).


    #worthtobestickied


    EDIT: now it's also accurate after reaching 10k banners (change in code) so this should be definitely stickied now and probably moved to PvP sub forum.
    Last edited by LittleBlackJoe; 01-20-2015, 05:10 AM.

    Comment


    • #3
      Great work Winter, very neat, thanks to everyone involved.

      Comment


      • #4
        Good job,

        The sheet will lose accuracy the higher up the banner count gets. Not because the sheet is inaccurate but mainly because it starts to become harder to win fights consistently, especially if there is a lack of nug teams. Also in the last hour when everyone is going crazy and taking any fight that they can win to eek out some more points, regardless of banners. At least this will provide a platform for people who would like to know the minimum it'll take in fights/gems to get to a desired level.
        Pog Mo Thoin
        Barky`4 CG DP`4 Isa`2 LMT`2 VT
        AGL`2 Ben`2 Flem Mori Saar Erk Kol Ari`2 Smoop
        GEF KM VA`2 Wyn`2 Merl`2 Uld`2
        Byrn EH`3 KA`2 LPH SC SG SN`4 Cal`3 Dan`3 GWO`2 GWS`2 WCD`4 AD CS RLM`2 SW`2
        LC: HD HO Hyb QotB Snug TGO

        Comment


        • #5
          Lots of thanks for @pe wa for the help he wound up doing the math on it and allowed me to fine tune it

          Comment


          • #6
            @LittleBlackJoe: I'll review the code on starting from 0... this should have been functional.

            EDIT: Ok, slight change to how the formulae ensure that the Starting Banners value isn't empty has corrected the issue.
            Last edited by Cerberus; 01-20-2015, 11:11 AM.
            IGN: Cerberus, Richard Rahl, Malthael, Vish Kal
            Nexus Drop Tracking | Pack Drop Tracking
            Event Stat Calculator | Hero List | Consume Points

            Comment


            • #7
              Thanks pewa 0 value works

              Comment


              • #8
                Heh, well I just used it, and it works :P

                Since I only have 105 gems atm, I know that there is no point in even trying to get to top 25 in this event, as I'd need at least 111 gems from my current position to stand a chance. Doing a rough calc in my head I worked it out at roughly the same cost.

                Excellent work guys I can see this saving people some gems in the long run. Maybe post should be in the PVP section though?

                +1 for Sticky
                Pog Mo Thoin
                Barky`4 CG DP`4 Isa`2 LMT`2 VT
                AGL`2 Ben`2 Flem Mori Saar Erk Kol Ari`2 Smoop
                GEF KM VA`2 Wyn`2 Merl`2 Uld`2
                Byrn EH`3 KA`2 LPH SC SG SN`4 Cal`3 Dan`3 GWO`2 GWS`2 WCD`4 AD CS RLM`2 SW`2
                LC: HD HO Hyb QotB Snug TGO

                Comment


                • #9
                  This really needs a sticky. It took me a while to find it today for use in another thread.

                  Comment


                  • #10
                    Originally posted by Ghost Chili View Post
                    This really needs a sticky. It took me a while to find it today for use in another thread.
                    this x 100.

                    Comment


                    • #11
                      Originally posted by Ghost Chili View Post
                      This really needs a sticky. It took me a while to find it today for use in another thread.
                      Until it gets stickied, just subscribe to the thread. Then you can always find it in your subscriptions list.

                      http://forums.capitalgames.com/subsc...iption&t=73342
                      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


                      • #12
                        Can we get a sticky on this please Lyeshal or anyone else, thanks
                        Pog Mo Thoin
                        Barky`4 CG DP`4 Isa`2 LMT`2 VT
                        AGL`2 Ben`2 Flem Mori Saar Erk Kol Ari`2 Smoop
                        GEF KM VA`2 Wyn`2 Merl`2 Uld`2
                        Byrn EH`3 KA`2 LPH SC SG SN`4 Cal`3 Dan`3 GWO`2 GWS`2 WCD`4 AD CS RLM`2 SW`2
                        LC: HD HO Hyb QotB Snug TGO

                        Comment


                        • #13
                          Moving to the Battlefield, and then will sticky.

                          Comment


                          • #14
                            Originally posted by Lyeshal View Post
                            Moving to the Battlefield, and then will sticky.
                            Thanks x 10 chars
                            "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


                            • #15
                              Originally posted by winterme936 View Post
                              This sheet will tell you how many gems/fights/refills it will take to get to XXXX banners in pvp.
                              The raw data amounts of when banners change seems to vary a little bit so this is averaged between the people that collected it. ( We will continue to modify as necessary ) currently this is EXTREMELY close to being accurate but additional data will be added as its sent to me.

                              https://docs.google.com/spreadsheets...it?usp=sharing

                              Enter your current banners and your desired banners .... thats it
                              look like something wrong, it doesn't work anymore

                              could you please Fix this
                              |OG||RLC| Count Money Ally Code: 698-638-736

                              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