Jump to content
Sal's RuneScape Forum
  • entries
    267
  • comments
    1,062
  • views
    106,203

Hey Mathematicians/Excel users

Kemosabe

942 views

Friends and I are trying to create a ladder for League of Legends 1v1s based on the elo rating system. I was wondering how we'd input the equation into excel and then have a list that automatically updates the ladder.

 

Alternatively I've found an elo calculator if we can't do the first part - I guess what we could do was use a third party elo calculator and then put them into an excel spreadsheet to save them. Is it possible to make a ranking list/ladder in excel that updates as I change the elos?



6 Comments


Recommended Comments

yes

as in you have to click to update (it will do so auto when opened)

Do you know how?

Share this comment


Link to comment

Egghebrecht, on , said:

 

yes

as in you have to click to update (it will do so auto when opened)

Do you know how?

I remember merch gwyar explaining a similar system in her blog for keeping track of your own highscores

 

personally I've only done such tricks with links to other excel tables so far

Share this comment


Link to comment

Write your own program to keep track of elo and hook it up to a mySQL database.

Share this comment


Link to comment

Write your own program to keep track of elo and hook it up to a mySQL database.

That implies some degree of coding knowledge and wouldn't have required this post if that was the case. ;)

Share this comment


Link to comment

this will require some tinkering, you need a crosstable (your list of results) and a table with all 'events' and the total 'points' calculation

 

auto ranking is the easy part :P

Share this comment


Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×

Important Information

By using this site, you agree to our Guidelines and Privacy Policy.