EA UFC Excel Spreadsheet

[jeremym480]

Quote: Originally Posted by ateneyck

The updated spreadsheet looks great, and I am using it as my base to start my UFC. Quick question though, how do you update rankings using Excel? Thanks for the hard work really useful.

Rankings is one of the things that you have to update manually. I based my initial rankings mostly off of http://rankingmma.com/ufc-rankings/ however there were some fighters that I used my own discretion on. Once you update Rankings, the should pull through to the Master Tab.

...And most of the thanks goes to RyanLeaf16 on here. He worked up the original spreadsheet and one of my buddies from work added on a few things when we played together on UFC 3. All I've done really is update the fighters names, records, etc.

[ateneyck]

Quote: Originally Posted by jeremym480

I've been working on updating my spreadsheet all morning. Here it is: https://onedrive.live.com/redir?resi...nt=file%2cxlsx I have my CAF's on there, but you can just delete them off of the Master and Rankings tab if you don't want them. All fighters should have the correct records and belts. Although, there's some of my CAF's are in their old divisions. If you're wondering about the colors on the Rankings tab Green is for CAF's that I already have made and Red is for ones that I plan on making soon. If you have any questions let me know.

Hey, first off your spreadsheet is really good. Great job.
Secondly, your cafs are they in a different color on the master?
Thanks

[jeremym480]

Quote: Originally Posted by ateneyck

Hey, first off your spreadsheet is really good. Great job. Secondly, your cafs are they in a different color on the master? Thanks

Yeah, all of the ones that aren't black are caf's. At the time of this spreadsheet the ones in green was caf's I had already created and the ones in red I still had to create.

[ateneyck]

Quote: Originally Posted by jeremym480

Yeah, all of the ones that aren't black are caf's. At the time of this spreadsheet the ones in green was caf's I had already created and the ones in red I still had to create.

Ok, is there a way you can point me into the direction of where or how you created your caf's? It would be much appreciated, I'm looking for guys in the featherweight, LHW, and heavyweight, also I'm looking for a Patrick Cote.

Thanks again and keep up the good work.

[jeremym480]

Quote: Originally Posted by ateneyck

Ok, is there a way you can point me into the direction of where or how you created your caf's? It would be much appreciated, I'm looking for guys in the featherweight, LHW, and heavyweight, also I'm looking for a Patrick Cote. Thanks again and keep up the good work.

Creating CAF's is no easy task since there's no way to share them and your limited to 10 (unless you're on PS4 and can use other profiles to create them). You'll need to sign up on EA's website so that you can upload the fighters via Game Face. You will have to download photos of the fighters and resize them to get them to work with the website. I have most of mine in a file, but if I recall correctly you still have to save and resize them. The file is too big to post on here, but I can send them to you in an email if you want. Just PM your email address and I'll send it to you.

Here's a spreadsheet with a link to the ratings that I used. Feel free to change them as you see fit. https://onedrive.live.com/edit.aspx?...acqt=undefined

[ateneyck]

Quote: Originally Posted by jeremym480

Creating CAF's is no easy task since there's no way to share them and your limited to 10 (unless you're on PS4 and can use other profiles to create them). You'll need to sign up on EA's website so that you can upload the fighters via Game Face. You will have to download photos of the fighters and resize them to get them to work with the website. I have most of mine in a file, but if I recall correctly you still have to save and resize them. The file is too big to post on here, but I can send them to you in an email if you want. Just PM your email address and I'll send it to you. Here's a spreadsheet with a link to the ratings that I used. Feel free to change them as you see fit. https://onedrive.live.com/edit.aspx?...acqt=undefined

So, when I clicked on the hyperlink it says that it's deleted?
Thanks and the faces were a huge help.

[jeremym480]

Quote: Originally Posted by ateneyck

So, when I clicked on the hyperlink it says that it's deleted? Thanks and the faces were a huge help.

I don't know what the problem is because when I click it it works. I'll post it again and if it's doesn't work this time then I will email you a copy in Excel rather than Excel Online.

[queenie.paula]

asked in the other thread with no answer, im not able to fool with your spreadsheet right now, if I ad say a new number for someone wins or loses, will all the other number adjust automatically?


sorry im not a pro with spreadsheets