Guild Wars 2

I spent a few minutes over lunch calculating how many more games I needed to play in order to get to a specific rank using my current rank, rank points and win % as well as how much solo vs. team queue I do.

It was easy enough to make this a shared google doc, so I thought I’d post it here for people to play around with.

Directions:
1. Anything in grey or blue cannot be edited. These are output cells based on your inputs

2. The calculator needs certain inputs which you fill in, these are white cells and need to be accurate in order for the system to predict your games needed:

-Current Rank: This is your rank atm
-Current RP: These are the number of rank points you have within your current rank, so you can figure this out by highlighting the blue rank bar in the HotM and it will tell you say 27,000/45,000 or something like that
-Desired Rank: This is the rank you want to get to
-Distribution: this is your split between solo and team queue, if you only play about 10% solo queue, then the calc will auto-fill in 90% for team queue
-Win%: your win % in that game mode (either solo or team queue, you can get this from the leaderboards)
-Top Stat Avg: This is the number of top stats you average in each game mode (can be a decimal place)

3. This is literally 30 +/- mins of work, let me know if you find any errors or kittenumptions (lol, edits..). There is no hot join option, sorry, and you can break it by putting in things like 200% solo queue or 130% win distribution or a desired rank of 9000.

Again, let me know if I missed anything, I’ll update accordingly.

Calculator

edit: updated to fix the rank gain issue and cleaned up the the calc by putting in notification if you select something outside of the available range.

Oh joy, 350 more games until 60….

Anyways nice job.

Sweet! Thanks!

/15 char

Only 10k games till 80. Good job

1.3k matches to 60 :[

EDIT: Also thanks for making this, good stuff.

Glad some of you found it useful. I tried to lock some more column headings so people wouldn’t change them, but I really don’t know much about google docs.

I did make a few edits and formatting changes.

Anyway, let me know if you find any errors or mis-calcs.

can u make a iOS and Android app =]

yay only 1225 games to get from rank 54 to rank 60

only 2.3k games for 20 ranks.. i accept this outcome

Edit: Please make a proper leaderboard and ranking system and sell it to ANet :P

Hey folks, wanted to let you all know that in addition to the soloq formula not working, it also appears that the system over-estimates how much rank you need to reach a certain level.

Big thanks to Spirits Reloaded for pointing this out. It looks like the issue is the way the wiki shows the rank gains, it seems to say you need 8.97m rp to get 80, but I’m pretty sure you only need 8.2m. Would be really nice to get confirmation on this.

If someone can double check this, i believe the way I’ve worked it out on the attached (right side) is correct and the wiki (left side) is not. I’ve also posted in the wiki comments section to see if they can confirm it as well.

Wiki Rank Points

Anyway, I’ll try to have it fixed ASAP.