UFC 2 Fight Schedule and Rankings Sheet

[dpmx21]

Quote: Originally Posted by bigO12677

I saw some people who are in the game but missing from the sheet, mainly why i asked to add everyone myself, i havent started making cafs

If you can name the people I have missed I will definitely add them and reupload the sheet.

Sent from my SM-G920T using Tapatalk

[dpmx21]

Quote: Originally Posted by TheBleedingRed21

Not taking away from your work, but in the "How's your Universe?" Thread there is a huge universe sheet that id suggest trying to tinkering with to better your sheet and knowledge of excel

Thanks for the advice man, but I've worked on this sheet since ufc 3 and I really enjoy it. There's just some small things that I want to add such as automated win streaks.

Sent from my SM-G920T using Tapatalk

[TonGunne]

Quote: Originally Posted by dpmx21

I would be more than happy to add your fighters for you. It's just way too much to type, and I'm not sure it will make sense. I wish the process was quicker, but it takes like 5 minutes to add a new fighter. You have to add them in the roster tab under "Roster", also in the roster tab in their corresponding weight class, again in their weightclass tab, copy the formula from the fighter above them, add them in the rankings tab, change the data validation for the drop down list so they're in there, then finally change the macro in their weightclass tab so they are included when the rankings auto-sort. It's a process that I wish I could simplify, but my Excel experience is lacking, so I do everything the hard way lol. As far as changing champions go, I always add +25 at the end of their points formula, that way their always listed as champion due to the added increase of points. If they lose their title, I just delete the +25, and add it to the new champions formula.

How do I change the data validation and macro? I really like your sheet but I dont know how to add or remove fighters

[ML]

The sheet randomly stopped automatically updating the rankings, everything is still being calculated but as a fighter gets or loses points the rankings arent reflecting this. Any idea how to fix?

[dynodan17]

Evening!

The Dropbox file is now unavailable. Any chance of a re-upload or could you send the file? Thanks