EA Sports UFC 5 Universe Mode

[wombatsportz]

Re: EA Sports UFC 5 Universe Mode

I use the automatic system. But, for example, Jon Jones. It shows "NR", and even if I update the W-Ls it still shows "NR". How can I make it so that it does consider Jon Jones in the ranking?

On the other hand, in the automatic ranking, I see that it does not evaluate from 1 to 15. Sometimes it assigns 1, 2, 3, skips 4 or 5, for example. Why does it happen?

On the workbook that I uploaded, Jon Jones and Tom Aspinall are listed as Champions (C) in the Heavyweight division. The C has to be assigned manually, even on the auto ranking system. Did you happen to remove the C ranking from Jones? If so, there is most likely no formula calculating Jones ranking after the C was removed. You will need to drag the formula to Jones rank cell on the data sheet from a fighter that does have a rank formula in their rank cell. You can do this by dragging the bottom right corner from the cell above or below him in column H. Also, you can copy this formula below and paste it into Jones rank cell assuming he is still located on row 116 in the data sheet and you haven’t moved any columns around;

=IF(AND(O116="Active", COUNTIFS($D$2:$D$1057, D116, $J$2:$J$1057, ">" & J116)+1 > 15), "NR", IF(O116="Active", COUNTIFS($D$2:$D$1057, D116, $J$2:$J$1057, ">" & J116)+1, "NR"))


There is some numerical rankings that are skipped because the manual champion ranking is also taken into account here. For example, in Middleweight Du Plessis is rank 1, Chimaev is 2, 3 is skipped, and Andesanya is 4. Strickland has the manual C rank assigned, but his "Rank Sum" would have him ranked as 3. If you dragged a rank formula into his rank cell, his rank would change to 3. I couldn’t get the formula to work out quite right with trying to exclude champions from the rankings, so most of the weight classes will probably have one numerical rank that is skipped.

[Libereco]

Re: EA Sports UFC 5 Universe Mode

On the workbook that I uploaded, Jon Jones and Tom Aspinall are listed as Champions (C) in the Heavyweight division. The C has to be assigned manually, even on the auto ranking system. Did you happen to remove the C ranking from Jones? If so, there is most likely no formula calculating Jones ranking after the C was removed. You will need to drag the formula to Jones rank cell on the data sheet from a fighter that does have a rank formula in their rank cell. You can do this by dragging the bottom right corner from the cell above or below him in column H. Also, you can copy this formula below and paste it into Jones rank cell assuming he is still located on row 116 in the data sheet and you haven’t moved any columns around;

=IF(AND(O116="Active", COUNTIFS($D$2:$D$1057, D116, $J$2:$J$1057, ">" & J116)+1 > 15), "NR", IF(O116="Active", COUNTIFS($D$2:$D$1057, D116, $J$2:$J$1057, ">" & J116)+1, "NR"))


There is some numerical rankings that are skipped because the manual champion ranking is also taken into account here. For example, in Middleweight Du Plessis is rank 1, Chimaev is 2, 3 is skipped, and Andesanya is 4. Strickland has the manual C rank assigned, but his "Rank Sum" would have him ranked as 3. If you dragged a rank formula into his rank cell, his rank would change to 3. I couldn’t get the formula to work out quite right with trying to exclude champions from the rankings, so most of the weight classes will probably have one numerical rank that is skipped.

Thank you very much for the detailed explanation. I have only one doubt: why do some fighters have "NR", without being champions? For example, Tony Ferguson has "NR" in the auto rank, despite being active and not being champion.

[wombatsportz]

Re: EA Sports UFC 5 Universe Mode

Thank you very much for the detailed explanation. I have only one doubt: why do some fighters have "NR", without being champions? For example, Tony Ferguson has "NR" in the auto rank, despite being active and not being champion.

No problem!

It’s because he is ranked outside of the top 15 in his weight class. The auto ranking is ultimately determined by the “Rank Sum” value in column J on the data sheet. The 15 fighters in each weight class with the highest Rank Sum will be ranked. Any fighter that has a rank sum that falls out of the top 15 highest values will be labeled as not ranked “NR”. If a NR fighter goes on a win streak eventually they will get ranked as their rank sum increases.

The actual UFC only ranks the top 15 fighters in each weight class, so I have followed that format also.

[Libereco]

Re: EA Sports UFC 5 Universe Mode

No problem!

It’s because he is ranked outside of the top 15 in his weight class. The auto ranking is ultimately determined by the “Rank Sum” value in column J on the data sheet. The 15 fighters in each weight class with the highest Rank Sum will be ranked. Any fighter that has a rank sum that falls out of the top 15 highest values will be labeled as not ranked “NR”. If a NR fighter goes on a win streak eventually they will get ranked as their rank sum increases.

The actual UFC only ranks the top 15 fighters in each weight class, so I have followed that format also.

Great! Got it. The only problem is that in "Matchmaking tool" it is not clear who is the champion of each category, as it appears in gray along with the rest of the unranked fighters because they are out of the top 15. It would be ideal if it came out as 'C' or distinguished from the others.

[wombatsportz]

Re: EA Sports UFC 5 Universe Mode

Great! Got it. The only problem is that in "Matchmaking tool" it is not clear who is the champion of each category, as it appears in gray along with the rest of the unranked fighters because they are out of the top 15. It would be ideal if it came out as 'C' or distinguished from the others.

Yeah, I agree!

That’s another thing I couldn’t get working quite right. I might try to work with it again in the future, but for now the champion will need to be identified on another tab and then work with the matchmaking tool from there. The matchup comparison will display the “C” ranking for the champion there.

[wombatsportz]

Re: EA Sports UFC 5 Universe Mode

I just updated the Excel Workbook in my initial post. The new workbook has the 5 new fighters that were added in the 1/12/2024 update, as well as results from the Ankalaev vs Walker Fight Night with updated fighter records and rankings. I have also added newly announced fights and events since the last time the file was uploaded.

I'm not going to be updating the document after every UFC event, but I went ahead and did it this time while I was adding the new fighters.

Enjoy!

[barisfitness]

Re: EA Sports UFC 5 Universe Mode

i use automatic sorting. although I have changed the data on the datasheet, the rankings in the matchmaking tool section do not change. automatic and manual do not matter. What is the reason for this, where did I do wrong? the ranking and winning streak remain the same. my second question is, when the belt changes hands, will there be data corruption if I give the "c" job on the champion to the winner with my own hand?

[wombatsportz]

Re: EA Sports UFC 5 Universe Mode

i use automatic sorting. although I have changed the data on the datasheet, the rankings in the matchmaking tool section do not change. automatic and manual do not matter. What is the reason for this, where did I do wrong? the ranking and winning streak remain the same. my second question is, when the belt changes hands, will there be data corruption if I give the "c" job on the champion to the winner with my own hand?

I have the matchmaking tool sheet protected by default. To update the matchmaking tool to reflect changes on the data sheet, you will need to unprotect the sheet and then refresh the data. You can do this by selecting the review tab on the Excel ribbon and then selecting the "unprotect sheet" button. After you have done that, select the data tab on the ribbon and click the "refresh all" button. This will update the data in the pivot table to reflect changes that have occurred on the data sheet.

To answer your second questions, there will be no data corruption or anything that is unfixable when you manually assigned the "C" ranking to the new champion. However, you will have to apply the auto rank formula to the previous champions rank cell to get the auto rank to populate for them again. You can do this by selecting the auto rank cell of a fighter in a row above or below the previous champion, and then click the bottom right corner of the cell and drag the formula down/up to the previous champions auto rank cell to apply the formula to them also.

I hope this helps!

[wombatsportz]

Re: EA Sports UFC 5 Universe Mode

Just updated the workbook to include the three new fighters added with the 2/9/2024 update. I also updated fighter records, event results, and announced fights as of the Hermansson vs Pyfer fight night this past weekend.

Enjoy!

[EvanJames42]

Re: EA Sports UFC 5 Universe Mode

Hi, everyone!

You might have seen another thread that I posted which included a slider set that I developed specifically for simulation AI vs AI gameplay in UFC 5, as well as information and suggestions on the in-game AI styles. Here is a link to that thread in case you haven’t come across it yet.

Wombat's UFC 5 Simulation AI vs AI Sliders and AI Styles

My main motivation for developing that slider set was because I wanted to see realistic fights and outcomes in my UFC 5 “Universe Mode”. After several discussions on that thread, it seems like there are other players that have a desire to run a universe mode on UFC 5 too. Unfortunately, since this mode isn’t built into the game, it makes keeping track of events, fight outcomes, fighter records, and other stats a tedious process. I have developed a universe mode tracking Excel workbook in hopes of making the process of setting up and running a universe in this game easier and more enjoyable.

This Excel workbook includes 6 spreadsheets to help with the tracking of the universe. The sheets include; Fighter Roster & Stats, Event Schedule, Event Tracker, a Matchmaking tool, a CAF Generator, and a data sheet. Each of these sheets serve as a way to track and add immersion to the universe.

The roster & stats tab provides an accessible overview of the roster and each fighters in-game ratings, fighting style, win/loss record, previous and next fight info, and even a career longevity meter. The event schedule and tracker tabs allow you to book events and fights for those events. The matchmaking tool aids in finding competitive matchups for your events by taking into account several factors to make fighter comparisons. The CAF Generator generates CAF formulas with the click of a button. It will generate the fighters style, general information, and appearance including hair style, hair color, specific tattoos and location, and even shorts type. This tool will even generate values to produce realistic facial sculpting. With the click of a button, the fighter details can be copied over to the data sheet tab which is the sheet that includes the fighter data for all fighters in the universe.

The fighter roster & stats, Matchmaking tool, and CAF generator are all automated and don’t require any manual data entry. The event schedule, event tracker, and data sheet will require some data entry and editing as your universe mode progresses. Basically, the manual entry includes scheduling events on the event schedule sheet, booking fights for events on the event tracker sheet, and manually up****** fighters records and rankings on the data sheet. I have also implemented an optional auto ranking system that can be used. You can select between the manual or auto ranking system on the Fighter Roster & Stats sheet, and on the Matchmaking tool sheet. The auto system doesn’t require manual updates of the fighter rankings, but uses a formula to automatically calculate fighter rankings based on several factors. The auto ranking system doesn’t guarantee that the rankings will be entirely realistic or represent true to life rankings, but it does take away the hassle of constantly up****** the rankings manually. A more in depth overview of each sheet and instructions on how to work with them are included in the first tab (Overview and Instructions) of the workbook.

Attached is a .zip file to access the workbook. This is a macro-enabled workbook (.xlsm), so you may be prompted to enable or disable macros upon opening the file. The macros are for the buttons on the CAF Generator sheet, so that the CAF generations can be refreshed and the fighter details can be copied over to the data sheet. If you do not plan to use the CAF Generator sheet, the macros can be disabled.

*Note, that this workbook includes fighter win/loss records and rankings as of UFC Fight Night: Hermansson vs Pyfer. Future events and fights that have been announced as of 2/11/2024 are included as well.

Regardless of if you end up using this tool to track your universe or not, I would like this thread to serve as a place to share anything related to your UFC 5 universe. Feel free to share anything from fight cards, results, rankings, pictures, highlights, event posters, CAF’s from your universe, storylines, or anything else that pertains to your universe. I would like to hear about it all! I will be posting updates regularly from my universe as well.

Also, if you do decide to use this tool to track your universe and have any questions about it, just let me know and I will be happy to answer.

I look forward to hearing about your universe!

This is going to be a blast! However, are you able to help identify the personalized information on the sheet? I can't enable autosave mode. Would like for my brother and I to be able to talk over chat and create cards/rankings.

[Libereco]

Re: EA Sports UFC 5 Universe Mode

We have started a petition for EA to include Universe Mode in the game. All of us who have been simulating it for years in Excel should massively support the petition.

Go to Reddit and search "UFC 5 Universe Mode Proposal" post in EASportsUFC forum. I can't post links here.

[John_Elway]

Re: EA Sports UFC 5 Universe Mode

Thank you so much for sharing the spreadsheet!! I have been using your AI vs AI sliders my UFC 5 Universe also and couldn't be happier with the results.

[johnmangala]

Re: EA Sports UFC 5 Universe Mode

Really want to see Universe mode added in the future. Great post.