I have created an excel file that helps me track the status of my universe. I wanted to share a copy in case anyone else finds this helpful.
The file needs to be opened in Microsoft Excel and depending upon what version of excel you have you may receive an error. The file is an .XLS file, if you do receive an error try changing the extension to an .XLSX file.
You will see two tabs. The first tab will be your roster file. Here you can paste / add the list of your fighters from your universe. The third column can be used for anything, I always have the fighters real record in this column. There is nothing else you should ever have to type on this page as all of the remaining columns are set with formulas to carry over fight results. This will display the fighters record in your universe as well as the date of their last fight (Helps greatly when scheduling fights). If you scroll down you will see the universe totals (Wins, KO's, TKO's, Losses, etc.)
The second tab is for your bouts. You would enter the date and boxers name in column E. When you run the fight you go in and enter the results in column's I-O. Everything else on this page is set up with a forumula. You will see what the fighters record is at the time of the fight and how many bouts they have had.
I use this two ways. If I run a card or bouts in the scheduler, when I am done I copy and paste the info into the spreadsheet to calculate. When I am scheduling bouts, I enter the boxers on the bouts tab. You will see on the top row there are filters. You can filter by the boxer and you will get a list in order of their fights. The way each bout is set with two rows will result in always being able to filter by any boxer and still see the opponenet. Remember you only have to add the fighters into column E, Column D, F, G, and H auto populate.
Anyway, let me know if you have any questions. Have fun!
Please scroll down for additional instructions - New version 1.1
https://www.dropbox.com/s/u7fkgfww4x...se%20V1.1.xlsx