In the last post of ‘How to get your WC Ranking‘, I developed a (rather crude) calculator in excel 2013 to tabulate the amount of gems I would need to spend in order to get to my ranking. After some tweaking, I’ve refined this for easy usage for all to refer to.
Without further ado, here is the WC VP Calculator Version 1.0:
Download it here on Google Drive!
To download, go to the top-left corner of the screen for ‘File’ -> ‘Download As…’->Excel (.xlsx)
*Do note that this is a very basic version and there are plans to refine this even further.
*Works best on Excel 2013
*Did a full AVG scan on my computer to ensure that the file is virus-free. Do let me know if there’s any issues.
The Calculator is divided into 3 main sections:
(0) Base Statistics & Targets: How much is needed
(1) As a Free Player: Amount of VP you’ll get without paying
(2) Pay-to-Play: Amount of Gems you’ll need to buy
How to Use?
Upon opening the calculator, you’ll be able to tell that the cells are coloured differently (unless you’re on Night Mode/ High Contrast Mode). Each colour represents a different aspect (see below):
Important output would be those which you’ll need to refer to; Semi-important output would be those which are just for reference and used in another equation further down.
(0) Base Statistics & Targets
In Section (0), you’ll need to input your current level and your target & current VP. This will return a simple result of the overall data of how much VP you have left to go.
Also, on the right, there is a VP-Energy rate. Due to the release of the repeat WC system, the VP-Energy rate is different from the original initial run so that would require input if necessary.
It will also help you know how many times you need to do the WC challenge before you hit your target VP.
*Something to note would be that the VP shown as the reward is the minimum amount of VP you’ll get when you complete each round. You can obtain up to +70 VP more but I’m not sure how that works out.
(1) As a Free Player
This section is if you want to play the WC without the use of any gems (which is really not feasible if you’re aiming for anything between 1-2500 of rank). However, this is to give you a guide as to how much VP you’ll get just based on a ‘Natural Gain‘ together with energy rewards from the WC, VIP bonuses, level ups and dailies.
*As the amount of energy keeps changing for the rewards given out, you’ll need to input it in manually for now. Further versions of the calculator will attempt to refine this to make this input automatic.
Last but not least, this is the section which you’ll want to look at. Taking into account the amount of energy you have left currently and the amount of gems you have, the calculator will tabulate the amount of extra gems you’ll need to buy.
*Gem per full energy refill might change if there are any in-game seasonal discounts.
That’s about it. This will be posted to the downloads section as well.