OOTP Developments Forums - View Single Post

SandMan · 02-14-2005, 09:28 PM

I have a been using a spreadsheet that has over 700 names in a table. The nickname will have a value by it for the number of chances that the name will come up.

The spreadsheet has a front worksheet that you enter the number of teams that you have in your league. Press CTRL-SHIFT-L and a list with 5 columns of names appear. Say team one is from MILWAUKEE, and row 1 has the following names in it. ROCKIES, SMOKERS, RED SOX, FALCONS, GOLDEN EAGLES. This gives you 5 names to chose from. I usually pick the default in column 1, but sometimes the name does not fit the team and I then select the next value.......Very easy to use...

I have attached the file but it does REQUIRE MS EXCEL XP and the analysis pack loaded. It may also work with EXCEL 2000 but I am not sure.....

To USE simply enter the number of teams then. hit the CTRL-SHIFT-L and a list of names will appear....

02-14-2005, 09:28 PM	#16
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	Team Nicknames..... I have a been using a spreadsheet that has over 700 names in a table. The nickname will have a value by it for the number of chances that the name will come up. The spreadsheet has a front worksheet that you enter the number of teams that you have in your league. Press CTRL-SHIFT-L and a list with 5 columns of names appear. Say team one is from MILWAUKEE, and row 1 has the following names in it. ROCKIES, SMOKERS, RED SOX, FALCONS, GOLDEN EAGLES. This gives you 5 names to chose from. I usually pick the default in column 1, but sometimes the name does not fit the team and I then select the next value.......Very easy to use... I have attached the file but it does REQUIRE MS EXCEL XP and the analysis pack loaded. It may also work with EXCEL 2000 but I am not sure..... To USE simply enter the number of teams then. hit the CTRL-SHIFT-L and a list of names will appear.... Last edited by SandMan; 04-18-2007 at 12:15 PM.