EA UFC Excel Spreadsheet

[jeremym480]

I updated RyanLeaf16's spreadsheet that been making its rounds since UFC 10 (iirc). It has been expanded upon and has lot's of things that automatically update with the user having to do very little work.

I only added the fighters on the opening roster (with the exception of Bruce Lee). All of the records and everything should be up-to-date and I'll continue to update the records for the next couple of fight cards.

I know that some of you have your own that you use, so please feel free to share them if you want. Also, if you have any ideas on how to improve it please feel free to share those as well. Let me know if you have any questions.

[RyanLeaf16]

Re: EA UFC Excel Spreadsheet

LOL - I was just thinking about having to start prep for the upcoming game. With Grad school it is a lot tougher to find time to commit to gaming, so I was planning on working bit by bit over the next few weeks - if time permitted of course.

[jeremym480]

Re: EA UFC Excel Spreadsheet

This very much a WIP, however I've decided on most of my CAF's. I still have to input their records as well update the rankings after last weekends card.

I did, however add a few things. I updated the Events History Tab so that the Awards update on the Master tab automatically. Also I added a Finishes Tab that pulls from the Events History Tab and records how each fight ends. I threw up a few dummy cards so you can see it in action.

[TheBuddyHobbs]

Re: EA UFC Excel Spreadsheet

Thanks for this! This should benefit our online league very well.

[Mr. Miyagi]

Re: EA UFC Excel Spreadsheet

Jeremy I'm trying to get a hold of you if you see this.

[jeremym480]

Re: EA UFC Excel Spreadsheet

Jeremy I'm trying to get a hold of you if you see this.

When I PM you I get this error

Spoiler

Mr. Miyagi has chosen not to receive private messages or may not be allowed to receive private messages. Therefore you may not send your message to him/her.

If you are trying to send this message to multiple recipients, remove Mr. Miyagi from the recipient list and send the message again.

Maybe it's your Message settings or maybe you're to new? I don't know. I'll be playing my PS4 for the next 30 mins so if you need anything you can hit me up on there. My PSN name is the same as on here.

[Mr. Miyagi]

Re: EA UFC Excel Spreadsheet

I guess it's because I had to make this new name. I'm about to go grocery shopping with the wife. I got the game from my former employer. It's a local game store but unfortunately they are about to close. Sorry I didn't get back to you sooner.

[COMMISSIONERHBK9]

Re: EA UFC Excel Spreadsheet

you guys are on fire tonight thank you

[dazzelle]

Re: EA UFC Excel Spreadsheet

Not sure if on purpose but couldn't see Korean Zombie.

don't have ms excel any other way to use it, also never used anything like this but how much info do we put in and what is updated auto.

[rafaelpaolo84]

Re: EA UFC Excel Spreadsheet

WOW thank you so much for this!!! I'll have to spend more time digesting all the info and understanding how all of this works, but I'm definitely going to use this for my virtual league!

[jeremym480]

Re: EA UFC Excel Spreadsheet

Not sure if on purpose but couldn't see Korean Zombie.

don't have ms excel any other way to use it, also never used anything like this but how much info do we put in and what is updated auto.

Chan Sung Jung (aka the Korean Zombie) is on there.

Excel is basically the only way with all of the formulas and stuff. Google docs sucks (for me anyway). It should work on Excel Online and I think all you need is an Microsoft account. I'll try converting it to an online file later and post the link.

Basically what you do is input your future cards on the Upcoming Events Tab. Once you start playing you enter the winner, how the won and the award winners. Then move the played event from the Upcoming Events Tab to the Events History Tab. That info is then automatically pulled from the Events Tab to the Master Spreadsheet.

On the Master spreadsheet each fighters record and the awards that they won automatically update from the info on the Events History Tab. You do have to manually enter the Streaks. Also on the Rankings Tab you have to update the rankings manually. However, their rankings update on the Master Spreadsheet once you complete it (on the Rankings Tab).

That's the basic stuff... I think that if you played around with it a little bit you would see how it all works. Today I'm going to try to update the CAF's records and touch up a few other things. I'll post an updated version when I'm done.

[dazzelle]

Re: EA UFC Excel Spreadsheet

Chan Sung Jung (aka the Korean Zombie) is on there.

That shows my knowledge of MMA.

I found a program called open office, from what i can tell it works. I created a card and set winners and moved it to event history like you said, it updated the fighter's W/L on the master screen. so think it should be fine.

"Also on the Rankings Tab you have to update the rankings manually"

how do you calculate the rankings,move them up a spot if they win down if they lose.

Damn, wish there was a event mode. Still 2gb til my game is downloaded.

[rmcguire]

Re: EA UFC Excel Spreadsheet

what on the upcoming events and events history tab is Ryan Win Total and Jeremy Win Total?

Also how does the title history work? I made UFC 176 with Machida d. Weidman and changed the current champion to Lyoto Machida and the date the title was won, but how does it calculate the current title reign?

thanks for this

[jeremym480]

Re: EA UFC Excel Spreadsheet

what on the upcoming events and events history tab is Ryan Win Total and Jeremy Win Total?

Sorry... That was left over from UFC 3. One of my buddies and I used this for an online league and we kept up with our record against one another. You can delete that or used it to keep up with your record against the CPU.

Also how does the title history work? I made UFC 176 with Machida d. Weidman and changed the current champion to Lyoto Machida and the date the title was won, but how does it calculate the current title reign?

The Title History page does require some knowledge of Excel, but it shouldn't be that difficult. Bare with me because I haven't used this in a few years so I may leave something out...

First off, a few things should be pulled from other tabs - 1) the title holder should automatically pull from the rankings tab and the days of the Current Title Reign should calculate from info provided by the Events History Tab.

Side note: One thing to keep in mind is that as soon as you complete an Event move it from the Upcoming Events Tab to the Events History tab. The easiest way is to "Cut" (click on line 3 and drag it down to 19) then go to the History tab and use "Insert the Cut Cells" on line 3. Once you have completed that then there will me a blank space on the Upcoming Events tab. Just delete those lines and the next event will replace it. From there the new Events date will be in cell A6 and that's how it updates on the Title History tab.

The next thing is what if the title changes hands? Well, let's say. for example, that Rousey loses to Alexis Davis... I will walk you through the steps. (you can do this a few ways but here's what would probably be easiest if you're not familiar with Excel.

1) Move the Event from Upcoming to Events History as described above
2) Insert a row under Rousey's name. The colors of the lines will change. You can change those if you want it's up to you.
3) Manually enter or Copy and Paste Rousey's info in the one line 13 (name and Title Reign) in the respective cells.
4) Go to the Rankings Page and put Davis as the new champ
5) In the new cell that you Inserted in step 2 do the following
a) Go to column A cell 14 and type "=B2". This will add the new champs name
b) Go to column B cell 14 and type "=C2". This will stat calculating their title reign.
6) Go to cell E2 and manually enter Rousey's name and enter the date that it was won in cell H2

You will have to keep up with Title Defenses manually.

That should be it.


thanks for this

I'm hoping that answers your questions. I'm not that great at describing things, but I tried to be as thorough as possible. If you (not necessarily, you rmcguire, but anyone needs help with Excel most of the time you can find what your looking for by Googling it). If you have any more questions about this spreadsheet let me know.

I have an updated copy of my spreadsheet attached. I think I was missing some formulas on the Title History page before.

[mavsaddict]

Re: EA UFC Excel Spreadsheet

Thanks so much for doing this. Unfortunately my friend and I have been tinkering with this and we're beyond confused. I am ok with excel but not really with the formulas and such. Am I missing something? Is there a way this can be broken down so that I can understand how to use this tool to generate rankings?

Which sheet do I have to go to in order to enter new results? Does everything have to be recorded through the results of the EVENTS HISTORY sheet? My friend and I recorded (on paper) fights before I ever got a hold of this spreadsheet. I have no idea how to enter these results to auto generate rankings.

I'm so lost. Please help me understand how to use this if you can.

For example if Yoel Romero won the championship against Weidman and he isn't listed on your spreadsheet, I would have no idea how to change this.