Re: UFC 3 - Excel Spreadsheet

[toby0824]

Re: UFC 3 - Excel Spreadsheet

How in the heck do they not have a promoter mode or something. It would be essentially just like a madden season and have it like 8 years long or something. WTF, can't believe by the third installment they don't have this, I have no interest in the career mode and would rather just play with all the guys in a "season". We can hope for next time I guess, but won't hold my breath. Spread sheet is awesome, but why should be have to do this, it should be standard with this game.

[2k10Fonzarelli]

Re: UFC 3 - Excel Spreadsheet

What is this for and how does it work?

I Think this can substitute as some sort of "universe" application which I can use to pit fighters against one another. If it Cpu v Cpu or whatever.

So, do records and P4P ranking automatically update themselves?
If I assign a winner, what do I use to update the list?(assuming the above question is answered with a yes)

I'm using Challonge.com to run a CPU v CPU round robin which I sometime participate in, but it doesn't have the level of tracking that is seemingly present on this excel document.

Any quick starter tips?

[jeremym480]

Re: UFC 3 - Excel Spreadsheet

What is this for and how does it work?

I Think this can substitute as some sort of "universe" application which I can use to pit fighters against one another. If it Cpu v Cpu or whatever.

So, do records and P4P ranking automatically update themselves?
If I assign a winner, what do I use to update the list?(assuming the above question is answered with a yes)

I'm using Challonge.com to run a CPU v CPU round robin which I sometime participate in, but it doesn't have the level of tracking that is seemingly present on this excel document.

Any quick starter tips?

Yes, is a way to keep up with your own UFC "universe". You can use it for cpu/cpu match-ups or whatever you want.

The only thing you really have to enter are the fight cards (enter the match-ups in cells C & E and when you select a winner everything should pull from there). You will also have to manually enter the next/last cards on the master spreadsheet, and update the rankings occasionally. Everything else, including p4p rankings, should be set up to calculate automatically.

[jeremym480]

Re: UFC 3 - Excel Spreadsheet

How in the heck do they not have a promoter mode or something. It would be essentially just like a madden season and have it like 8 years long or something. WTF, can't believe by the third installment they don't have this, I have no interest in the career mode and would rather just play with all the guys in a "season". We can hope for next time I guess, but won't hold my breath. Spread sheet is awesome, but why should be have to do this, it should be standard with this game.

I agree. The career mode now is similar to a "My Player"/"Road to the Show" type of mode. Which I've never really had much of an interest in. I'm a franchise guy first and foremost, so I would love to see a "promoter mode"; where you can set up fightcards and it kept up with records, rankings, titles, win/loss streaks, etc. Unfortunately, it seems that most devs are more focused on online these days, so we are probably in the minority. My fingers are crossed though.

[2k10Fonzarelli]

Re: UFC 3 - Excel Spreadsheet

this is fantastic!!

Thank you!

Quick question. What do i need to do to add new fighters to the list and ensure they're tracked accurately?

[jeremym480]

Re: UFC 3 - Excel Spreadsheet

this is fantastic!!

Thank you!

Quick question. What do i need to do to add new fighters to the list and ensure they're tracked accurately?

First add the fighter(s) to the rankings tab whereever you think that they should be ranked or use a website rankings.

Then, just add them to the appropriate weight-class on the Master spreadsheet. Be sure you paste all the formulas on that row. You can either use paste special (formula) or hit Control D on each individual cell to get the formula above it to pull down. You will have to manually enter the old records, but everything else should be good to go.

Lastly, you need to get them in the p4p rankings. The easiest way to do it is to add them to the bottom of the rankings and pull down the formula from the last ranked fighter. Then what you want to do is highlight cells B30 and C30 starting at the first fighter and ending with the last. Then, left click on that, select SORT and sort from smallest to the largest.

I hope that isn't too confusing. If you have any problems or need something explained better just let me know.

[2k10Fonzarelli]

Re: UFC 3 - Excel Spreadsheet

OK, I think I follow this. I'm going to try a few matches later and see if it works.

Thanks for the help. Its was well written, I had no problems following it despite no experience with excel .

[mountaindew77]

Re: UFC 3 - Excel Spreadsheet

Just wanted to say thank you times a billion. This is awesome. I was surprised when I finished my first event and put it in the fight card, it automatically updated the wins and losses on the Master page. Just awesome. Saved me a lot of paper!

Oh and if you're confused use Jeremy's explanation up there. Helps a lot.

[Control-X]

Re: UFC 3 - Excel Spreadsheet

First add the fighter(s) to the rankings tab whereever you think that they should be ranked or use a website rankings.

Then, just add them to the appropriate weight-class on the Master spreadsheet. Be sure you paste all the formulas on that row. You can either use paste special (formula) or hit Control D on each individual cell to get the formula above it to pull down. You will have to manually enter the old records, but everything else should be good to go.

Lastly, you need to get them in the p4p rankings. The easiest way to do it is to add them to the bottom of the rankings and pull down the formula from the last ranked fighter. Then what you want to do is highlight cells B30 and C30 starting at the first fighter and ending with the last. Then, left click on that, select SORT and sort from smallest to the largest.

I hope that isn't too confusing. If you have any problems or need something explained better just let me know.

I've done that (bolded part) but what about the Rank, Original P4P Points, and Progress Points of our created/added fighter? Is that supposed to remain blank?

What I did:
Just for fun I added a Floyd Mayweather with a 42-0-0 record on the master sheet at Lightweight by following your procedure. He was ranked 3rd. Next, I got him to the P4P rankings by adding him at the bottom of the list (after a Kyle Noke). I copied the formula from cell B158 (and I got 3.22 points for my fighter). Next I highlighted from cells B30 and C30 like you said and was able to sort them from smallest to largest, the fighters were rearranged but the problem is... my added fighter (Mayweather) had no RANK Number, no Original P4P Points, and no Progress Points unlike the other existing fighters. Shouldn't you do something with a fighter's Rank or "Original P4P Points" and/or "Progress (Points)" first before sorting them all out? Thanks for this file btw.

[mountaindew77]

Re: UFC 3 - Excel Spreadsheet

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]

Re: UFC 3 - Excel Spreadsheet

I got it. Thanks for the help @mountaindew.

[rmcguire]

Re: UFC 3 - Excel Spreadsheet

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]

Re: UFC 3 - Excel Spreadsheet

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]

Re: UFC 3 - Excel Spreadsheet

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]

Re: UFC 3 - Excel Spreadsheet

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