UFC 3 - Excel Spreadsheet

[mountaindew77]

First, you need to add one more rank in column A on the p4p list for every fighter you add. Next, copy/paste-special the formula for each column that uses one for every new fighter you add.

The original p4p points are all manually put in. When you only sort columns B/C, the original p4p points in D stay in place. So whenever you are done putting your new fighters in, sorting your rankings by weight class, and are ready to start your league; then sort columns B/C to get your starting p4p rankings. After you have done this highlight all of the p4p ratings in B and copy/paste them to column D. You now have your original p4p points for the start of your league and should never change. From now on when you want to sort p4p rankings, make sure you highlight B-D and always sort by B so that each fighters original p4p rank stays with them and it can track progress in E accurately.

Sorry if this is confusing. Hope it helps

[Control-X]

I got it. Thanks for the help @mountaindew.

[rmcguire]

so to make sure that the P4P rankings adjust accordingly we just change the My Wins/Losses/Draws and adjust the fighters rank accordingly then it should adjust their value of P4P?

thanks for this

[mountaindew77]

Quote: Originally Posted by rmcguire

so to make sure that the P4P rankings adjust accordingly we just change the My Wins/Losses/Draws and adjust the fighters rank accordingly then it should adjust their value of P4P? thanks for this

You can enter fight cards and once you put a winner in and put it in past events, it will automatically update the My W and my L. Just be sure you spell everyones name correctly to stay accurate. Or you can just manually enter wins and losses on the master page if you want

[dpmx21]

Sorry to bump this thread, but I just want to say thanks for posting this. I created my own spreadsheet to keep track of everything including methods of victory, but I just love the ease of use in this one. All I have to do is type the winner's name and it updates the rankings. I'm trying to become more well versed in excel and this spreadsheet helped alot,. I used that countif formula in my current spreadsheet and it is working great. I also love the P4P ranking you guys created. I'm sure you probably won't feel like doing this, but is there any way you could incorporate methods of victory into the rankings? Maybe give a guy who finishes his fight an extra point toward the ranking. You could also take an extra point away from a guy who gets finished. I plan on messing with this myself, but I feel I will become very frustrated in trying to devise the right formula. Once again though, thanks alot for posting this, and thanks to the guy who originally created it. Enjoying this game has become much easier.

[mountaindew77]

What I did was incorporate the fighters current streak into their p4p ranking.

[dpmx21]

Any chance you could post the formula?

[mountaindew77]

Quote: Originally Posted by dpmx21

Any chance you could post the formula?

=(Y3/(I3+J3+K3))-A3*-1 ... This is the original

=(-Y3/(I3+J3+K3))-(A3*-0.15)-(L3*0.02) ... This is my version

I made the fighters rank count for less (so someone who's not a title holder can still possibly be in top 7) by changing from -1 to -0.15. You can adjust this number however you like or keep it at -1. And the last part is what incorporates the fighters streak. Again, you can play with the numbers and adjust them however. The only thing that would be better is if it changed the fighter's streak automatically, but as it stands you have to change them manually. Which isn't all that bad if you do it after every couple fight cards.

Also, there is a lot of fighters on the spreadsheet that are not in the game or they are DLC.