UFC 3 - Excel Spreadsheet - Page 5 - Operation Sports Forums
Home

UFC 3 - Excel Spreadsheet

This is a discussion on UFC 3 - Excel Spreadsheet within the MMA Forum forums.

Go Back   Operation Sports Forums > Combat Sports > MMA Forum
Reply
 
Thread Tools
Old 03-06-2012, 05:26 AM   #33
Rookie
 
dpmx21's Arena
 
OVR: 5
Join Date: Jul 2010
Location: Knoxville
Re: UFC 3 - Excel Spreadsheet

Thanks for that man. I'm thinking about adding the Pride guys to the roster as well.
dpmx21 is offline  
Reply With Quote
Old 03-07-2012, 06:53 AM   #34
Hail West Virginia
 
mtoo22's Arena
 
OVR: 10
Join Date: Dec 2005
Posts: 804
Blog Entries: 1
I had the Jones Evans matchup and Jon Jones won by TKO. However, Rashads ranking on the master stayed at 2 and his p4p only fell about .15 or so

Hail West Virginia
mtoo22 is offline  
Reply With Quote
Old 03-07-2012, 09:56 AM   #35
Trouble 0 7 11
 
jeremym480's Arena
 
OVR: 39
Join Date: Oct 2008
Location: Baton Rouge, LA
Posts: 16,465
Quote:
Originally Posted by mtoo22
I had the Jones Evans matchup and Jon Jones won by TKO. However, Rashads ranking on the master stayed at 2 and his p4p only fell about .15 or so

Hail West Virginia
You have to manually update the rankings on the rankings tab. It would be awesome if one of you Excel gurus could find a way to get the rankings to update automatically.

Sent from my Droid using Tapatalk
__________________
My 2K17 Boston Celtics MyLeague

Alabama Crimson Tide
Green Bay Packers
Boston Celtics

New Orleans Pelicans
jeremym480 is offline  
Reply With Quote
Old 03-07-2012, 11:42 AM   #36
Rookie
 
dpmx21's Arena
 
OVR: 5
Join Date: Jul 2010
Location: Knoxville
Re: UFC 3 - Excel Spreadsheet

Quote:
Originally Posted by jeremym480
You have to manually update the rankings on the rankings tab. It would be awesome if one of you Excel gurus could find a way to get the rankings to update automatically.

Sent from my Droid using Tapatalk
That's what I'm saying dude. It would also be awesome if someone could incorporate an ELO formula into the rankings. Here's a website based solely on the ELO formula.

http://www.mma-elo.com/about_system.php
ELO takes the fighters rating into account. Say you have a guy ranked #8 vs. a guy ranked #4. If the #8 guy wins, his rank will increase significantly while the #4 guy's rank will decrease significantly. If the #4 guy wins, his rank will not increase very much, and likewise for the #8 guy.
dpmx21 is offline  
Reply With Quote
Old 04-24-2012, 08:36 AM   #37
Rookie
 
ThuggyD55's Arena
 
OVR: 0
Join Date: Feb 2012
Re: UFC 3 - Excel Spreadsheet

Sorry, but it says the zip file is invalid or corrupt
ThuggyD55 is offline  
Reply With Quote
Old 03-07-2013, 02:37 AM   #38
Just started!
 
OVR: 0
Join Date: Mar 2013
Re: UFC 3 - Excel Spreadsheet

well i gotta tell ya taht im really thankful to you for putting this up!

However i do have alot of trouble with it...

I read your explanation on page 3 on how to add new fighters and what to consider while doing it but I just cant get it done.

Im a total excel noob to be honest...

So for example, I wanted to start off by adding Mark Hunt to the heavyweight division, so what I did was I just entered his name into the G18 cell on the rankings section.

Then I went to the Master Section and there I tried to copy line 137 to line 138 by right clicking on the "137" and choosing "copy"
then i right clicked on the "138" and pasted it.

So now, I have in line 138 the same line as in 137 with Travis Browne's data.

So here goes, when I now click into the first cell, the ranking cell and type in "18" since thats his position in the rankings section, the code gets lost.
Same with his record, when I type it in, the formula/code that is shown above the table will be replaced by the numbers/text that i just typed in.

So my guess is, that im doing it all wrong, but how can I enter new information without it replacing the formula?

Im quite lost....
elgatoo69 is offline  
Reply With Quote
Old 03-07-2013, 01:16 PM   #39
Trouble 0 7 11
 
jeremym480's Arena
 
OVR: 39
Join Date: Oct 2008
Location: Baton Rouge, LA
Posts: 16,465
Re: UFC 3 - Excel Spreadsheet

After you paste the formula's manually type in Mark Hunt's name in Column B. The ranking in Column A will update once you do that. You will also have to update Hunt's record in rows S-T.

or instead of copying and pasting you could just go to row 138 and in column A hit "Ctrl + D" on your keyboard. That will pull the formula from the cell above it. Type in Hunt's name in Column B and then hit Ctrl + D in the remaining cells on that row.

I hope that helps.
__________________
My 2K17 Boston Celtics MyLeague

Alabama Crimson Tide
Green Bay Packers
Boston Celtics

New Orleans Pelicans
jeremym480 is offline  
Reply With Quote
Old 03-10-2013, 11:43 AM   #40
Just started!
 
OVR: 0
Join Date: Mar 2013
Re: UFC 3 - Excel Spreadsheet

thanks alot for your answer!
It helped me but only to a certain degree...

I dont really know what the problem is now, I started to do it like you told me and at first it worked, when I entered the fighters name in the b column it would automatically set the ranking no. in column A.

However, when I started to type in the names of guys who are at rank #26 or higher, it doesnt work anymore... it just says #NV then...

what do I need to change in order for it to understand that there are more than 25 ranks?

Here is a screenshot so you can better understand what im talking about

elgatoo69 is offline  
Reply With Quote
Reply


« Previous Thread | Next Thread »

« Operation Sports Forums > Combat Sports > MMA Forum »


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -5. The time now is 05:32 AM.

Top -