A new way of "universing" - Page 7

CONN CHRIS · 01-30-2009, 11:06 AM

Man, I can't wait to upgrade my older-than-dirt excel version and give this a whirl.

Many thanks to you jade!

gocubsgo · 01-30-2009, 11:52 AM

Quote:

I was actually thinking today that the best way to go about this would be to have a control sheet listing all the currently active titles. On this sheet, you could list the criteria required for a fighter to be eligible ie. African nations for african nationals etc etc etc. As an added bonus, this method of control would mean that at any stage during your universe you could add or remove a title of any kind, based on any criteria.

You are correct you would need to have way more than 50 fighters but for titles like the EBU i have 40 fighters that qualify for this group.

I like the idea above that would be very easy to add and delete titles as the population of your universe changes.

Jade just an FYI i do not seem to be getting the same amount of sleep now that i am able to use this spreadsheet. I wonder if there is any direct correlation?

gocubsgo · 01-30-2009, 12:00 PM

For those that do not have Excel 2007 you may want to check out the college student option. If you can prove you are a college student or have a college student you can get a version of Office 2007 for like $50.

bear · 01-30-2009, 01:31 PM

Quote:

Originally Posted by CONN CHRIS

Man, I can't wait to upgrade my older-than-dirt excel version and give this a whirl.

Many thanks to you jade!

I would be equally inept with either version of excel. Of all ot he Microsoft office tools it is the one with which I am the least ept. Crikey, I have an easier time building a relational database with access

gocubsgo · 01-30-2009, 01:56 PM

Trust me Bear if i can figure this thing out anyone can.

jade_00 · 01-31-2009, 03:51 AM

Hi Guys,

Many thanks for the feedback recieved. Special mention to Javier and GoCubsGo (somebody really needs to explain baseball to me), for their very indepth and thoughtful responses. The more responses and ideas I get the better I can make this - I will go as far as to say this can be made into something special, for all TBCB users to enjoy.

Anyways, as requested, I have attached the original instruction document on how to use the sheet. I deleted this accidentally when I replaced the original file. This should go someway as to explain how to use the sheet at a basic level.

By all means, if you have any questions for me, hit the thread or IM me. If you have a suggestion, please put it on the thread - because if its public it gets everyone thinking

Mr Foo · 01-31-2009, 02:17 PM

Quote:

Originally Posted by jade_00

Hi Guys,

Many thanks for the feedback recieved. Special mention to Javier and GoCubsGo (somebody really needs to explain baseball to me), for their very indepth and thoughtful responses. The more responses and ideas I get the better I can make this - I will go as far as to say this can be made into something special, for all TBCB users to enjoy.

Anyways, as requested, I have attached the original instruction document on how to use the sheet. I deleted this accidentally when I replaced the original file. This should go someway as to explain how to use the sheet at a basic level.

By all means, if you have any questions for me, hit the thread or IM me. If you have a suggestion, please put it on the thread - because if its public it gets everyone thinking

So basically, if I wanted 2,500 fighters in my database, I would have to manually enter all 2,500 fighters into the spreadsheet, yeah?

gocubsgo · 01-31-2009, 06:45 PM

Short of being able to export the fighter into a CSV or Excel spreadsheet or heck anywhere else you can cut and paste into excel from then you would have to manually enter the names.

jade_00 · 01-31-2009, 06:51 PM

Quote:

Originally Posted by Mr Foo

So basically, if I wanted 2,500 fighters in my database, I would have to manually enter all 2,500 fighters into the spreadsheet, yeah?

You can copy all the names into the 'Pool' tab, but yes, you would have to hit 'Add Fighter' 2500 times over the course of your universe to make them active. The more astute excel users will just aske their PC to run the macro 2500 times if you wanted them all active straight away.

gocubsgo · 01-31-2009, 10:36 PM

Jade is there a way for me to change the ranges for the aging levels?

gocubsgo · 02-01-2009, 02:01 AM

One other thing is there a way to create our own matchups? Let say i want the top two Italian fighters to fight for the Italian belt?

jade_00 · 02-01-2009, 05:53 AM

Quote:

Originally Posted by gocubsgo

Jade is there a way for me to change the ranges for the aging levels?

You need to change the VBA code. I plan to make this variable in the finished product. Unless you want to change the code the answer is no.

Mr Foo · 02-01-2009, 06:19 AM

Quote:

Originally Posted by jade_00

You can copy all the names into the 'Pool' tab, but yes, you would have to hit 'Add Fighter' 2500 times over the course of your universe to make them active. The more astute excel users will just aske their PC to run the macro 2500 times if you wanted them all active straight away.

Sorry to ask, can you explain how to copy them into the 'pool' tab.

gocubsgo · 02-01-2009, 02:27 PM

Quote:

One other thing is there a way to create our own matchups? Let say i want the top two Italian fighters to fight for the Italian belt?

Jade can this be done? As for the other question i will just wait until the final product is released not even sure what VBA is.

gocubsgo · 02-02-2009, 11:57 AM

Anyone else having a blast with this thing? I have a few more months i want to get thru to build up some history and then i will start a new universe to follow my progress and use of this scheduler. While at first a little cumbersome i now have 70 fighters in my little world and i can fly thru a month pretty well. I started with fighters from 1960-1964 and am now adding in fighters from random years. The first group to join in was 1989. I highly recommend taking Office 2007 for their 60 day trial and giving this spreadsheet (and more) a try.

Mr Foo · 02-02-2009, 01:52 PM

How do you copy the names into the pool tab?

gocubsgo · 02-02-2009, 02:09 PM

If you can find a source to copy the names from and then to paste them into the excel spreadsheet.

gocubsgo · 02-11-2009, 11:31 PM

Anyone seen Jade recently? I have an issue i need to work out before i can move forward in my test inuverse.

jade_00 · 02-12-2009, 02:16 AM

Quote:

Originally Posted by gocubsgo

Anyone seen Jade recently? I have an issue i need to work out before i can move forward in my test inuverse.

I am here.

gocubsgo · 02-12-2009, 10:02 AM

Did you get the PMs i sent?

01-30-2009, 11:06 AM	#121 (permalink)
CONN CHRIS Global Moderator Join Date: Oct 2004 Posts: 23,467 Thanks: 550 Thanked 491x in 341 posts	Man, I can't wait to upgrade my older-than-dirt excel version and give this a whirl. Many thanks to you jade! __________________ REC World Prizefighter Rankings Challenge my Brute!

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

01-30-2009, 12:00 PM	#123 (permalink)
gocubsgo All Star Starter Join Date: Mar 2003 Location: Illinois Posts: 1,495 Thanks: 19 Thanked 3x in 3 posts	For those that do not have Excel 2007 you may want to check out the college student option. If you can prove you are a college student or have a college student you can get a version of Office 2007 for like $50.

01-30-2009, 01:56 PM	#125 (permalink)
gocubsgo All Star Starter Join Date: Mar 2003 Location: Illinois Posts: 1,495 Thanks: 19 Thanked 3x in 3 posts	Trust me Bear if i can figure this thing out anyone can.

01-31-2009, 06:45 PM	#128 (permalink)
gocubsgo All Star Starter Join Date: Mar 2003 Location: Illinois Posts: 1,495 Thanks: 19 Thanked 3x in 3 posts	Short of being able to export the fighter into a CSV or Excel spreadsheet or heck anywhere else you can cut and paste into excel from then you would have to manually enter the names.

01-31-2009, 10:36 PM	#130 (permalink)
gocubsgo All Star Starter Join Date: Mar 2003 Location: Illinois Posts: 1,495 Thanks: 19 Thanked 3x in 3 posts	Jade is there a way for me to change the ranges for the aging levels?

02-01-2009, 02:01 AM	#131 (permalink)
gocubsgo All Star Starter Join Date: Mar 2003 Location: Illinois Posts: 1,495 Thanks: 19 Thanked 3x in 3 posts	One other thing is there a way to create our own matchups? Let say i want the top two Italian fighters to fight for the Italian belt?

02-02-2009, 11:57 AM	#135 (permalink)
gocubsgo All Star Starter Join Date: Mar 2003 Location: Illinois Posts: 1,495 Thanks: 19 Thanked 3x in 3 posts	Anyone else having a blast with this thing? I have a few more months i want to get thru to build up some history and then i will start a new universe to follow my progress and use of this scheduler. While at first a little cumbersome i now have 70 fighters in my little world and i can fly thru a month pretty well. I started with fighters from 1960-1964 and am now adding in fighters from random years. The first group to join in was 1989. I highly recommend taking Office 2007 for their 60 day trial and giving this spreadsheet (and more) a try.

02-02-2009, 01:52 PM	#136 (permalink)
Mr Foo Minors (Rookie Ball) Join Date: Mar 2007 Posts: 28 Thanks: 1 Thanked 0x in 0 posts	How do you copy the names into the pool tab?

02-02-2009, 02:09 PM	#137 (permalink)
gocubsgo All Star Starter Join Date: Mar 2003 Location: Illinois Posts: 1,495 Thanks: 19 Thanked 3x in 3 posts	If you can find a source to copy the names from and then to paste them into the excel spreadsheet.

02-11-2009, 11:31 PM	#138 (permalink)
gocubsgo All Star Starter Join Date: Mar 2003 Location: Illinois Posts: 1,495 Thanks: 19 Thanked 3x in 3 posts	Anyone seen Jade recently? I have an issue i need to work out before i can move forward in my test inuverse.

02-12-2009, 10:02 AM	#140 (permalink)
gocubsgo All Star Starter Join Date: Mar 2003 Location: Illinois Posts: 1,495 Thanks: 19 Thanked 3x in 3 posts	Did you get the PMs i sent?