|
|
Post by spencer24 on Feb 16, 2020 2:03:19 GMT
I have a longstanding Excel document that keeps track of workers, # of wins, # of losses, # draws, # of total matches, win percentage, points (wins minus losses) and gender. Points have long been the hallmark of greatness in my Fire Pro world, but seven years in there are some guys just way ahead of the rest who have simply had far more matches in which to win and amass points. I would love if their was a simple equation available to somehow rank the workers in a weighted fashion comparing I guess taking win percentage and number of overall matches into account.
Anybody played around with something similar they could share? Math isn't my strong suit so ideally if anyone had an equation to plug right into Excel I would be eternally grateful.
|
|
|
|
Post by Severla on Feb 16, 2020 3:04:28 GMT
|
|
|
|
Post by pfadrian on Feb 16, 2020 18:20:16 GMT
|
|
|
|
Post by meltzy on Mar 23, 2020 3:45:26 GMT
Question though. Those points for wins and losses and match rating. Are those edit points that the wrestlers gain? So they can climb from say a mid career to a superstar? I’m really interested in starting a fed and have people submit custom edits and this would be a huge help on how to make the league great |
|
|
|
Post by bolleat on Mar 23, 2020 4:10:04 GMT
You have a number of stats there that basically different ways to look at raw data. Wins, losses, and draws are the raw data. Comparing win percentages is one way to use the raw data to normalize it so having more matches doesn't automatically make you higher ranked. Your points (wins-losses) is another way to look at the data, but this one allows more matches to mean more points. For example a guy who is 10 and 5 has a 66% win percentage, and 10-5=5 points. A guy with 66wins and 34 losses also has a win percentage of 66%, but 32 points. So if you want more matches to mean something then this method is good, if not, stick with win percentage.
So here is my thinking with the data you have. I think total matches does mean something, particularly if you are using it to move guys up the rank in your fed. So you could just use your wins-losses points system and then convert the number of points a guy has earned into a range you want your wrestlers to fall into. So you would have a baseline starting number of skill points each wrestler starts with, and a max the best wrestler can have. Then subtract the baseline from the max. That is the range of points a wrestler can earn. Now consider how many matches is the max a guy in your fed will have before retirement. Take that number and that is the max points a guy can earn from wins-losses. Now divide that number by the range of skill points a wrestler can earn. That is how many wins-losses needs to increase to gain 1 skill point.
For example: Young Lion starts with 150 points. Best wrestler ever in fed 350 points. 200 points is the range of skill points that can be earned. Max number of matches before someone retires = 1000 matches. 1000/200=5. So when I calculate wins-losses every time this number increases by 5 my wrestler gets 1 additional skill point. So if a wrestler has 20 wins and 5 losses, his points is 15, and he has earned 3 skill points. If he wins 1000 matches his points are 1000-0=1000 which means he has earned the full 350 points. Obviously this can be adjusted any way you like. This is a simplistic way of doing this and does not account for wrestler aging or match quality, but is based on the stats you have.
So in excel you can write "=whatever cell has your wins-losses/(1000/(350-150))" to calculate like above, or you can adjust the numbers. This will give you the number of additional skill points each wrestler should have above a 150 baseline. You can round the number to the nearest integer.
|
|
