Large universe Rules and Whatnot - Page 4

franklin_1 · 08-28-2006, 12:15 AM

Quote:

Originally Posted by CONN CHRIS

Ok, I saved your great xls file but I can not get the generator page to generate names. hitting f9 just brings the lovely MS assistant out of its box.

I feel like a dunderhead, but could you give me a little more help with using it. This could be the answer to my stiff creation woes.

I don't know why it's not working for you Chris, I downloaded it as well and it works like a charm for me. Maybe try redownloading it?

CONN CHRIS · 08-28-2006, 09:35 AM

Quote:

Originally Posted by franklin_1

I don't know why it's not working for you Chris, I downloaded it as well and it works like a charm for me. Maybe try redownloading it?

I still can't get it to work. Any ideas?

I feel dumb.

CONN CHRIS · 08-28-2006, 09:39 AM

I will finish the final posts soon. Before that though, I have a question:

Does anyone have a suggestion for re-doing the International match-ups from post 43?

I would like to have better fight match-ups but I need to keep the system relatively simple and repeatable due to the size of this thing.

Could it be as simple as pitting 1v10, 2v8... then 11v20, 12v19... 21v30, 22v29...?

Thanks

CONN CHRIS · 08-28-2006, 10:35 AM

Quote:

Originally Posted by CONN CHRIS

I will finish the final posts soon. Before that though, I have a question:

Does anyone have a suggestion for re-doing the International match-ups from post 43?

I would like to have better fight match-ups but I need to keep the system relatively simple and repeatable due to the size of this thing.

Could it be as simple as pitting 1v10, 2v8... then 11v20, 12v19... 21v30, 22v29...?

Thanks

Actually, the more that I have thought about this, the more I realize that setting up the International bouts for the top thirty according to subjective criteria would not take much longer. I could then have a rote set up for the 31-75 ranked international fights.

I would be interested though if someone has a systematic approach that would work well.

Kevin · 08-28-2006, 01:17 PM

I tend to match up the contenders by their most recent records. That way you are having elimination bouts of fighters on recent win streaks to get a #1 contender for a world title. Conversely, fighters with a recent loss meet each other to determine who is worthy to remain in the higher contender groups.

These threads on universe development have been very interesting. Thanks.

JCWeb · 08-28-2006, 01:33 PM

Chris, what I do in my Uni (which I'm sure has a much smaller number of active fighters than yours because the rankings list doesn't go much below the top 30 in most cases) is match up guys roughly based on the following criteria: (1) who's available that month, (2) who has similar rankings (looking at pp, not the boxer rating), (3) guys on a roll with a win last bout tend to face each other, and (4) guys who haven't met before tend to face each other. I don't use any elaborate spreadsheet "system" or die-rolling, it's just seat-of-the-pants looking at what matches make sense. I.e., if a guy holds a regional belt and there's another guy doing well in the same region, he challenges for the belt. Of course, there's exceptions, like if two fighters had a weird result or close bout the last time (i.e. a stoppage on cuts, a foul, or a draw or split decision) the likelihood I would match them up again is alot greater than otherwise.

Don't know how to program this in a computerized exercise, but these are just the factors I look at.

Non Compos Mentis · 08-28-2006, 02:37 PM

Quote:

Originally Posted by CONN CHRIS

I still can't get it to work. Any ideas?

I feel dumb.

Different versions of Excel is my not very well-informed guess.

CONN CHRIS · 08-28-2006, 02:41 PM

Quote:

Originally Posted by Non Compos Mentis

Different versions of Excel is my not very well-informed guess.

I have excel 2002.

And I still feel dumb.

CONN CHRIS · 08-28-2006, 02:43 PM

Thanks Kevin and JCWeb. I like the subjective (seat-of-the-pants) angle. I am going to try that this next round on the top thirty and see what happens. It may not take as much time as I fear and would certainly be more enjoyable.

a87star · 08-28-2006, 04:04 PM

I appreciate this whole thread you did. Glad you took the time to explain your universe. Did you post the announcer .dat file and photos yet?

CONN CHRIS · 08-29-2006, 08:15 AM

Quote:

Originally Posted by a87star

Did you post the announcer .dat file and photos yet?

I will try to get those uploaded tonight.

bear · 08-29-2006, 08:44 AM

Quote:

Originally Posted by CONN CHRIS

I still can't get it to work. Any ideas?

I feel dumb.

I can't get it to work either.

Bear

CONN CHRIS · 08-29-2006, 09:57 AM

Quote:

Originally Posted by bear

I can't get it to work either.

Bear

Bear:

I just sent a PM to Swimmer to see if he can help. This spread sheet looks fantastic and will get a lot of use in my universe if I can get it to work.

Christopher

gocubsgo · 08-29-2006, 01:22 PM

Yep mine does nothing. When i hit F9 nothing happens.

CONN CHRIS · 08-29-2006, 01:27 PM

Quote:

Originally Posted by gocubsgo

Yep mine does nothing. When i hit F9 nothing happens.

F9 is supposed to calculate all cells with formulas. I wonder if there is a problem with the formulas. I'll look into it if I don't hear back from Swimmer - It's a beautiful spreadsheet.

gocubsgo · 08-29-2006, 01:38 PM

I agree this thing looks great.

PublicEnemy · 08-29-2006, 01:50 PM

F9 doesn't work for me either. I have to reopen the spreadsheet to get it to create new names.

Here's a couple of flags Chris (or anyone else) might like.
Austria-Hungary for pre world war one years and the newly independant nation of Montenegro (recently seperated from Serbia)

bear · 08-29-2006, 03:57 PM

Quote:

Originally Posted by CONN CHRIS

F9 is supposed to calculate all cells with formulas. I wonder if there is a problem with the formulas. I'll look into it if I don't hear back from Swimmer - It's a beautiful spreadsheet.

Excell is the office tool I'm least ept with. I had 3 weeks of training with Lotus 1-2-3 about 12 years ago and never had any occasion to use any spread sheet skills. I can build a relational database in access without missing a beat. Go figure.

Bear

gocubsgo · 08-29-2006, 04:28 PM

Quote:

Excell is the office tool I'm least ept with. I had 3 weeks of training with Lotus 1-2-3 about 12 years ago and never had any occasion to use any spread sheet skills. I can build a relational database in access without missing a beat. Go figure.

Bear

Well you've got that going for you.

CONN CHRIS · 08-29-2006, 05:13 PM

Quote:

Originally Posted by PublicEnemy

F9 doesn't work for me either. I have to reopen the spreadsheet to get it to create new names.

Here's a couple of flags Chris (or anyone else) might like.
Austria-Hungary for pre world war one years and the newly independant nation of Montenegro (recently seperated from Serbia)

That's great! Thank you. I picked a few up from the Commenwealth thread when Tom provided a link:

The Dominion of Newfoundland: a country from 1907 to 1949

08-28-2006, 09:39 AM	#63 (permalink)
CONN CHRIS Global Moderator Join Date: Oct 2004 Posts: 23,467 Thanks: 552 Thanked 494x in 344 posts	I will finish the final posts soon. Before that though, I have a question: Does anyone have a suggestion for re-doing the International match-ups from post 43? I would like to have better fight match-ups but I need to keep the system relatively simple and repeatable due to the size of this thing. Could it be as simple as pitting 1v10, 2v8... then 11v20, 12v19... 21v30, 22v29...? Thanks __________________ REC World Prizefighter Rankings Challenge my Brute!

08-28-2006, 01:17 PM	#65 (permalink)
Kevin Major Leagues Join Date: Dec 2001 Location: Nova Scotia Posts: 474 Thanks: 0 Thanked 0x in 0 posts	I tend to match up the contenders by their most recent records. That way you are having elimination bouts of fighters on recent win streaks to get a #1 contender for a world title. Conversely, fighters with a recent loss meet each other to determine who is worthy to remain in the higher contender groups. These threads on universe development have been very interesting. Thanks. __________________ It seems more like today than it did all day yesterday.

08-28-2006, 01:33 PM	#66 (permalink)
JCWeb All Star Starter Join Date: Jun 2005 Posts: 1,027 Thanks: 0 Thanked 13x in 12 posts	Here's What I Do ... Chris, what I do in my Uni (which I'm sure has a much smaller number of active fighters than yours because the rankings list doesn't go much below the top 30 in most cases) is match up guys roughly based on the following criteria: (1) who's available that month, (2) who has similar rankings (looking at pp, not the boxer rating), (3) guys on a roll with a win last bout tend to face each other, and (4) guys who haven't met before tend to face each other. I don't use any elaborate spreadsheet "system" or die-rolling, it's just seat-of-the-pants looking at what matches make sense. I.e., if a guy holds a regional belt and there's another guy doing well in the same region, he challenges for the belt. Of course, there's exceptions, like if two fighters had a weird result or close bout the last time (i.e. a stoppage on cuts, a foul, or a draw or split decision) the likelihood I would match them up again is alot greater than otherwise. Don't know how to program this in a computerized exercise, but these are just the factors I look at.

08-28-2006, 02:43 PM	#69 (permalink)
CONN CHRIS Global Moderator Join Date: Oct 2004 Posts: 23,467 Thanks: 552 Thanked 494x in 344 posts	Thanks Kevin and JCWeb. I like the subjective (seat-of-the-pants) angle. I am going to try that this next round on the top thirty and see what happens. It may not take as much time as I fear and would certainly be more enjoyable. __________________ REC World Prizefighter Rankings Challenge my Brute!

08-29-2006, 01:50 PM	#77 (permalink)
PublicEnemy Minors (Rookie Ball) Join Date: May 2006 Posts: 49 Thanks: 0 Thanked 0x in 0 posts	F9 doesn't work for me either. I have to reopen the spreadsheet to get it to create new names. Here's a couple of flags Chris (or anyone else) might like. Austria-Hungary for pre world war one years and the newly independant nation of Montenegro (recently seperated from Serbia) Last edited by PublicEnemy; 10-05-2006 at 02:48 PM.

08-28-2006, 04:04 PM	#70 (permalink)
a87star Hall Of Famer Join Date: Sep 2005 Location: Staten Island, NY Posts: 4,843 Thanks: 110 Thanked 18x in 16 posts	I appreciate this whole thread you did. Glad you took the time to explain your universe. Did you post the announcer .dat file and photos yet?

08-29-2006, 01:22 PM	#74 (permalink)
gocubsgo All Star Starter Join Date: Mar 2003 Location: Illinois Posts: 1,495 Thanks: 19 Thanked 3x in 3 posts	Yep mine does nothing. When i hit F9 nothing happens.

08-29-2006, 01:38 PM	#76 (permalink)
gocubsgo All Star Starter Join Date: Mar 2003 Location: Illinois Posts: 1,495 Thanks: 19 Thanked 3x in 3 posts	I agree this thing looks great.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode