Microsoft Excel Universe Spreadsheet

westendcards · 07-01-2013, 01:25 PM

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

Jeff1787 · 07-07-2013, 06:00 PM

I have added fight results in the bouts tab and nothing carries over to the roster.

Jeff

westendcards · 07-07-2013, 07:23 PM

Make sure your fighters are listed on the Roster tab, then when you add the bouts to the bouts tab the records will carry over. Remember I have some hidden columns on the bouts tab so if you are adding rows make sure you copy and fill down for columns through Z. If you need further instruction / help just let me know. I have several revisions since including formulas for next available fight date if anyone is interested.

Mark42661 · 07-07-2013, 08:34 PM

Will this work with OpenOffice 3?

westendcards · 07-08-2013, 02:33 PM

You should be able to - Give it a try, just set that application as the application to open .xls or .xlsx files.

Jeff1787 · 07-08-2013, 05:39 PM

I tried and it still doesn't work. Maybe you can post your latest revision...Thanks

Jeff1787 · 07-08-2013, 05:48 PM

I played around with it and now it works...thanks

westendcards · 07-10-2013, 11:07 PM

I have a new version that has some big improvements. Only issue is the forum will not let me upload XLSX files, which is a newer excel file version. When I convert the file to an XLS file it is too large to upload. Any ideas on how to upload an XLSX file?

bob_bask · 07-11-2013, 02:08 PM

Quote:

Originally Posted by westendcards

I have a new version that has some big improvements. Only issue is the forum will not let me upload XLSX files, which is a newer excel file version. When I convert the file to an XLS file it is too large to upload. Any ideas on how to upload an XLSX file?

Ge.tt/ have been the best I have used lately.

Upload the file and then post a link.

DJgreen_72 · 07-11-2013, 02:51 PM

Quote:

Originally Posted by bob_bask

Ge.tt/ have been the best I have used lately.

Upload the file and then post a link.

I use webroot for my virus protection program...It blocks Ge.tt/ as potentially containing Malware

bob_bask · 07-11-2013, 03:14 PM

Quote:

Originally Posted by DJgreen_72

I use webroot for my virus protection program...It blocks Ge.tt/ as potentially containing Malware

Use AVG myself, don't get no warnings.

Sure there are plenty of other options available.

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

westendcards · 07-17-2013, 04:07 PM

OK, I have now uploaded to dropbox and this appears to be working. Please let me know if you have any issues.

gRaider2001 · 09-21-2015, 12:09 AM

Thank you for creating and sharing this excel sheet:-)

Owen · 11-20-2015, 10:26 AM

Thanks for this. Nice work.

07-07-2013, 08:34 PM	#4
Mark42661 All Star Starter Join Date: Aug 2002 Location: Home of the Kansas City Chiefs! Posts: 1,080	Will this work with OpenOffice 3? __________________ A Man of the World Site dedicated to Sailor Tom Sharkey

07-08-2013, 05:39 PM	#6
Jeff1787 Hall Of Famer Join Date: Oct 2005 Location: The Doghouse Posts: 3,536	I tried and it still doesn't work. Maybe you can post your latest revision...Thanks __________________ 1903: The hatchet is finally buried

07-08-2013, 05:48 PM	#7
Jeff1787 Hall Of Famer Join Date: Oct 2005 Location: The Doghouse Posts: 3,536	I played around with it and now it works...thanks __________________ 1903: The hatchet is finally buried

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.

07-17-2013, 04:07 PM	#13
westendcards All Star Reserve Join Date: Dec 2005 Posts: 551	OK, I have now uploaded to dropbox and this appears to be working. Please let me know if you have any issues. Last edited by westendcards; 07-17-2013 at 04:21 PM. Reason: Update

07-01-2013, 01:25 PM	#1
westendcards All Star Reserve Join Date: Dec 2005 Posts: 551	Microsoft Excel Universe Spreadsheet 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 Last edited by westendcards; 07-17-2013 at 04:20 PM. Reason: New link

07-07-2013, 06:00 PM	#2
Jeff1787 Hall Of Famer Join Date: Oct 2005 Location: The Doghouse Posts: 3,536	I have added fight results in the bouts tab and nothing carries over to the roster. Jeff __________________ 1903: The hatchet is finally buried

07-07-2013, 07:23 PM	#3
westendcards All Star Reserve Join Date: Dec 2005 Posts: 551	Make sure your fighters are listed on the Roster tab, then when you add the bouts to the bouts tab the records will carry over. Remember I have some hidden columns on the bouts tab so if you are adding rows make sure you copy and fill down for columns through Z. If you need further instruction / help just let me know. I have several revisions since including formulas for next available fight date if anyone is interested.

07-08-2013, 02:33 PM	#5
westendcards All Star Reserve Join Date: Dec 2005 Posts: 551	You should be able to - Give it a try, just set that application as the application to open .xls or .xlsx files.

07-10-2013, 11:07 PM	#8
westendcards All Star Reserve Join Date: Dec 2005 Posts: 551	I have a new version that has some big improvements. Only issue is the forum will not let me upload XLSX files, which is a newer excel file version. When I convert the file to an XLS file it is too large to upload. Any ideas on how to upload an XLSX file?

09-21-2015, 12:09 AM	#14
gRaider2001 Minors (Triple A) Join Date: Dec 2013 Location: Ohio Posts: 224	Thank you for creating and sharing this excel sheet:-) __________________ Looking For Hints and Tips for OOTP 15 or Baseball in General? Please Check Out The Knowledge Thread Link Below: http://www.ootpdevelopments.com/boar...ge-thread.html

11-20-2015, 10:26 AM	#15
Owen Minors (Double A) Join Date: Aug 2004 Location: Atlantic City, NJ Posts: 196	Thanks for this. Nice work.