Fight scheduling and rankings spreadsheet

[dpmx21]

Quote: Originally Posted by dpmx21

Can I get a mod to edit this thread title please? That "scheudling" is driving me crazy.

Just bumping this.

[aholbert32]

Quote: Originally Posted by dpmx21

Updated spreadsheet. Points now added for knockouts, tko's, submissions, and fight bonus awards. The file attached is my current fight records. Just go to "Schedule" and delete the ppv's and start your own. I can delete all this stuff tomorrow after work, and upload a blank sheet. Hope you guys that keep records enjoy this. Let me know what I can do to make it better. Attachment 96875

this is great. I'll start adding them once I get a clean sheet.

[dpmx21]

Quote: Originally Posted by aholbert32

this is great. I'll start adding them once I get a clean sheet.

Here's your clean sheet man. Adding caf's may be a little more difficult this time around with the added formulas. If you want to copy them over existing fighters that you won't use, that would be much more simple. If not, I'm sure we can work it out. Let me know what you think and how we can improve.



Fight rankings test.zip

[bigO12677]

You did a great job with this, thank you for sharing.
I have an idea/suggestion if you dont mind, instead of total fights how about a win/loss streak?

In the rankings tab do you have to manually change the champs and #1 contenders?
I set up a championship fight in schedule and notice it didnt change so i wanted to be sure about it.

One more question, for fighters on the sheet but fight in multiple weight classes and i wanted to add them to those other weight classes, should i copy&paste or add them as new? How will it affect the sheet?

[aholbert32]

Quote: Originally Posted by dpmx21

Here's your clean sheet man. Adding caf's may be a little more difficult this time around with the added formulas. If you want to copy them over existing fighters that you won't use, that would be much more simple. If not, I'm sure we can work it out. Let me know what you think and how we can improve. Attachment 97001

The only issue I'm running into is that for CAFs the bonuses are not showing up on their records. For example, I had a fight between a CAF and a roster fighter that was fight of the night. The roster fighter record showed the FON and the FON was calculated into his points. That wasnt the case for the CAF.

Everything else is working fine and i havent had any issues adding CAFs except for this issue.

[dpmx21]

Quote: Originally Posted by bigO12677

You did a great job with this, thank you for sharing. I have an idea/suggestion if you dont mind, instead of total fights how about a win/loss streak? In the rankings tab do you have to manually change the champs and #1 contenders? I set up a championship fight in schedule and notice it didnt change so i wanted to be sure about it. One more question, for fighters on the sheet but fight in multiple weight classes and i wanted to add them to those other weight classes, should i copy&paste or add them as new? How will it affect the sheet?

Love the suggestion on the win/loss streaks, but I haven't really dove into it yet. As far as number one contenders and champions go, you have to manually give the champion 10 points. That's how I do it to ensure he's the top guy in the weight class. The number one contender is always the second ranked fighter in the weight class. Changing the fight to a title fight or number one contender fight in the schedule has no affect on the rankings. If there's a way to do this please help me figure out how lol. As far as same weight classes go, it should be as simple as copying the entire formula from the fighters ranking. I'll experiment when I get home to make sure. Thanks for your interest.

[dpmx21]

Quote: Originally Posted by aholbert32

The only issue I'm running into is that for CAFs the bonuses are not showing up on their records. For example, I had a fight between a CAF and a roster fighter that was fight of the night. The roster fighter record showed the FON and the FON was calculated into his points. That wasnt the case for the CAF. Everything else is working fine and i havent had any issues adding CAFs except for this issue.

This is strictly in the formula. It's a tedious process, but like before we'll get through it. As soon as I get home I'll try to write up some instructions.

[dpmx21]

Ok. For every CAF you make, you must change the formula in (KO, TKO, SUB, FOTN, KOTN, and SOTN). For example, I just created a fighter in the heavyweight division. Prior to creating the fighter there were 15 fighters in that division, on the spreadsheet it is A2:A16. After adding your caf, just copy everything from the cell above and drag it down. In my case, I will copy B16:N16 and drag it down. Now you'll have to delete the 1 that it has in Draw, because it auto adds. Now go to KO. You'll see this formula =COUNTIFS(Schedule!D,A$2:A$16,Schedule!F:F,G$1). Note the A$16. This HAS to be changed to A$17 in order for your caf to receive the bonuses. You must do this for all six, KO, SUB, TKO, FOTN, KOTN, and SOTN. Just make sure the last fighters cell location matches the number in the formula. If you add 5 cafs to the heavyweight division the formula will look like this =COUNTIFS(Schedule!D,A$2:A$21,Schedule!F:F,G$1)