OOTP Developments Forums - View Single Post

westendcards · 07-17-2013, 03:44 PM

https://www.dropbox.com/s/u7fkgfww4x...se%20V1.1.xlsx

OK, I have uploaded the new veriosn of the spreadsheet.

Two tabs, one for your roster one for your bouts.

On the roster tab you enter the boxers name (Also game rating, Class and real record if you would like). If you automatically add records to fighters in TBCB you can add these statistics manually to columns T-AA. If you sim all of your fights you can leave these columns blank.

On the bouts tab you enter the fight date and class and the 2 boxers. As you will see with the examples I included, I add the fight on two lines with boxer #1 in column D and Boxer #2 in column G, then I also add the bout again with the boxers in the opposite columns. I do this so when I sort or filter I will always have the record of both fighters complete.

After you run you bout, you simply put a "1" in the appropriate W/KO/TKO/L/D/ND/DQ fields. Everything else on both sheets autopopulates. You will be able to see on the bout tab what bout # it is for both fighters before their fight, you can filter by boxer to see a list of all of their fights with opponenets names and records at the time of the fight. You can sort the Bouts tab by date, by fighter or any way you want, it does not matter because your statistics and bout numbers will always autopopulate.

The roster page will also autopopulate to show how many bouts a fighter has had, what their current record is, their last fight date, win and KO %'s.

I will filter by last fight date when creating bouts to make sure I only use fighters that are available to fight.

I find this a useful tool to see all universe data in one place. It may take a little time initially setting up the roster to include all of your boxers, I exported the CSV file and copied and pasted. If you can get use out of it great. Please let me know if you have any questions.

Thanks

07-17-2013, 03:44 PM	#12
westendcards All Star Reserve Join Date: Dec 2005 Posts: 551	https://www.dropbox.com/s/u7fkgfww4x...se%20V1.1.xlsx OK, I have uploaded the new veriosn of the spreadsheet. Two tabs, one for your roster one for your bouts. On the roster tab you enter the boxers name (Also game rating, Class and real record if you would like). If you automatically add records to fighters in TBCB you can add these statistics manually to columns T-AA. If you sim all of your fights you can leave these columns blank. On the bouts tab you enter the fight date and class and the 2 boxers. As you will see with the examples I included, I add the fight on two lines with boxer #1 in column D and Boxer #2 in column G, then I also add the bout again with the boxers in the opposite columns. I do this so when I sort or filter I will always have the record of both fighters complete. After you run you bout, you simply put a "1" in the appropriate W/KO/TKO/L/D/ND/DQ fields. Everything else on both sheets autopopulates. You will be able to see on the bout tab what bout # it is for both fighters before their fight, you can filter by boxer to see a list of all of their fights with opponenets names and records at the time of the fight. You can sort the Bouts tab by date, by fighter or any way you want, it does not matter because your statistics and bout numbers will always autopopulate. The roster page will also autopopulate to show how many bouts a fighter has had, what their current record is, their last fight date, win and KO %'s. I will filter by last fight date when creating bouts to make sure I only use fighters that are available to fight. I find this a useful tool to see all universe data in one place. It may take a little time initially setting up the roster to include all of your boxers, I exported the CSV file and copied and pasted. If you can get use out of it great. Please let me know if you have any questions. Thanks Last edited by westendcards; 07-17-2013 at 04:21 PM.