UFC 3 - Excel Spreadsheet

[aholbert32]

Quote: Originally Posted by Maverick32093209

Its funny...I am at an interesting place with this new spreadsheet i created. There are few things I can improve...but I am having so much fun with it that I am not going to take the time to stop playing with it to improve it

Are you going to post it or send it to me so I can post?

[Maverick32093209]

check your e-mail

[aholbert32]

Thanks Man.

Posted

[aholbert32]

Quote: Originally Posted by Maverick32093209

Dude....i took your excel file then put it on steroids. *Improved and simplified ranking system that give extra value to fight bonus and win streaks. You will need to input win streaks only into ranking and sort. Trust me when I say that you will ALL love what I made. The only problem is I dont know how to upload it. If someone can tell me how to upload an excel file then I will get it to you all.

So how does this work exactly. I inputted the win streaks into the HW section but it did not change the rankings for HW.

[Maverick32093209]

I should send you my new file...its even better....

but...the streaks alone will not move rank...you have to do the events.
Make sure to use the drop down to show the winning fighter.


You will need to sort and filter the rankings on the individual weight class page...so the are ordered correctly. YOu dont need to do so on the ranking sheets....except for the P4p Rankings at the bottom.

If you want...i can send you the new one...its a bit better

[Maverick32093209]

I just sent you an updated version that is better. Here are the directions.
I sent you the new file....here are the directions as clear as I can give them
[list=1]

Event Page
- Select Weightclass
- Select Red Corner and Blue Corner
- After each fight Select winner
- Select Fight Bonus that apply (its possible to win 2. DONT assign FOTN 2x)
- Select Method (has no bearing now...but I could in another version)
Weight Class Page
- After each fight enter the streak -1 for a loss, +1 for a win. If it is the
second loss in a row enter -2 etc.
- If a champion loses the belt then use the drop down to indicate that. If a top 5 contender loses to someone outside of the top 5 use the drop down to indicate that
- Highlight the rows starting at 3 going down to the last fighter (sort in ascending order to see the rankings.
Rank Sheet
-hilight row 34 to 190 sort in ascending order...this will give you the p4p list. The top rankings adjust on their own as long as you do so on the individual weightclass pages

[aholbert32]

Quote: Originally Posted by Maverick32093209

I just sent you an updated version that is better. Here are the directions. I sent you the new file....here are the directions as clear as I can give them [list=1] Event Page - Select Weightclass - Select Red Corner and Blue Corner - After each fight Select winner - Select Fight Bonus that apply (its possible to win 2. DONT assign FOTN 2x) - Select Method (has no bearing now...but I could in another version) Weight Class Page - After each fight enter the streak -1 for a loss, +1 for a win. If it is the second loss in a row enter -2 etc. - If a champion loses the belt then use the drop down to indicate that. If a top 5 contender loses to someone outside of the top 5 use the drop down to indicate that - Highlight the rows starting at 3 going down to the last fighter (sort in ascending order to see the rankings. Rank Sheet -hilight row 34 to 190 sort in ascending order...this will give you the p4p list. The top rankings adjust on their own as long as you do so on the individual weightclass pages

Thanks man. Is there anything I need to do to add fighters to the chart. I have a number of CAFs I want to add.

[Maverick32093209]

Quote: Originally Posted by aholbert32

Thanks man. Is there anything I need to do to add fighters to the chart. I have a number of CAFs I want to add.

That would be a bit of a problem. I could figure it out...give me some time.