[Beno999]

Originally Posted by jade_00

Ok.

Normally this error refers to a dll issue / compatibility. I MAY be able to fix it so it worked for you, but I would have to know the exact line in the code where the issue is occuring - without having your PC in front of me I can't do that.

I would suggest trying the following.

Instead of pressing the button that says 'Add Fighter', actually go into your Macro menu and run the macro manually - it is possible that the interface button itself is not compatible.

If this doesn't work, if you know how, take a screenshot of the VBA code indicating the line where the code falls down - that would give me a hint as to why.

Hope that helps.

The specific line of code for this error is:

ActiveWorkbook.Worksheets("Pool").Sort.SortFields. Clear

I myself got the exact same error he speaks of.

[jade_00]

Originally Posted by Beno999

The specific line of code for this error is:

ActiveWorkbook.Worksheets("Pool").Sort.SortFields. Clear

I myself got the exact same error he speaks of.

G'day mate - have you tried the file I posted in response to this query? I'd like to know if that fixes the problem.

[jade_00]

Some minor fixes.....

[Beno999]

yeah and it doesnt do the job mate, is one of the variables wrong or is it a line of code that just isnt compatible ?? obv ive used the compatibility pack provided by microsoft for the conversion from excel 2007 to 2003, but still.

[jade_00]

Originally Posted by Beno999

yeah and it doesnt do the job mate, is one of the variables wrong or is it a line of code that just isnt compatible ?? obv ive used the compatibility pack provided by microsoft for the conversion from excel 2007 to 2003, but still.

Looks like the issue is to do with the fact that Excel 2007 uses a multikey sort and earlier versions do not. I reckon I can fix this because none of the sorts in these macros are overly complex I should be able to write them in a simpler language.

Leave it with me for a couple hours, they might be simple, but theirs dozens of them

[Beno999]

Haha, much appreciated, ive been eager to actually try this program out good and proper as i am using Title Bout 2 and not 2.5, would make my universing so much easier.

[jade_00]

I've actually started using the Universe myself just to give it a crack, which I hadn't really had a chance to do. I have advanced approximately two years into the universe. I am yet to crown a champ, and no one really seems to want to step up - a couple guys were getting close but lost key fights. Here's a couple of screen shots of it in action.

[Beno999]

Think im gonna have to get dl'in Excel 2007 just for the sake of being able to use this program, it looks immense for what i want to do.

[comicfanman]

looks awesome

[Rob Morris]

When I click on Add fighter nothing appears to happen. Is there something you are meant to do before clicking Add Fighter?

[jade_00]

Originally Posted by Rob Morris

When I click on Add fighter nothing appears to happen. Is there something you are meant to do before clicking Add Fighter?

Hi there - have you read the rest of the thread? I'm guessing one of two things

1) You are running Excel 2007 and you do not have Macros enabled

-or-

2) You are running Excel 2003, in which we have established the sorting code needs to be fixed in order to be compatible. It's a bit of a job and I am yet to complete it.

[Rob Morris]

Originally Posted by jade_00

Hi there - have you read the rest of the thread? I'm guessing one of two things

1) You are running Excel 2007 and you do not have Macros enabled

-or-

2) You are running Excel 2003, in which we have established the sorting code needs to be fixed in order to be compatible. It's a bit of a job and I am yet to complete it.

I am running Excel 2007 with the macros enabled. When I click Add fighter the screen sort of flashes a it but no fighters are added. I am presuming you have to import or export the fighters from somewhere first as you have already said you cannot enter them manually. There is probably something really dumb I haven't done!

[jade_00]

Originally Posted by Rob Morris

I am running Excel 2007 with the macros enabled. When I click Add fighter the screen sort of flashes a it but no fighters are added. I am presuming you have to import or export the fighters from somewhere first as you have already said you cannot enter them manually. There is probably something really dumb I haven't done!

No not at all - In order to add a fighter, you need to change the test names in the 'Pool' tab to a list of fighters. Ie. Muhammad Ali, Joe Frazier etc etc. Make sure the names are in Column A only (as in not first name in Column A, surname in Column B). Once you have a list, add at least four fighters in before deleting the rows in the 'main' and 'active' tabs that contain the test names.

[Rob Morris]

Originally Posted by jade_00

No not at all - In order to add a fighter, you need to change the test names in the 'Pool' tab to a list of fighters. Ie. Muhammad Ali, Joe Frazier etc etc. Make sure the names are in Column A only (as in not first name in Column A, surname in Column B). Once you have a list, add at least four fighters in before deleting the rows in the 'main' and 'active' tabs that contain the test names.

Ah thanks, I think I get it now. You have to add the names you want manually, then add fighter. For some reason I thought you could import your existing universe into the spreadsheet but this is for starting a new universe correct?

[jade_00]

Originally Posted by Rob Morris

Ah thanks, I think I get it now. You have to add the names you want manually, then add fighter. For some reason I thought you could import your existing universe into the spreadsheet but this is for starting a new universe correct?

If used as instructed it is for a new universe, correct. However, their is no reason I can't make it so you can import an existing universe into it. I made this sheet as a sort of combination of a few things that were bothering me, such as the lack of a good auto-scheduler (that was the HARDEST part to figure out), a new ranking system etc etc. Nothing is impossible, and I haven't heard a suggestion yet that I thought I couldn't do.

[barkflex]

Jade, just something I'm curious about, does your scheduler allow for more than three fights between any two boxers if it makes sense ranking wise?

[jade_00]

Originally Posted by barkflex

Jade, just something I'm curious about, does your scheduler allow for more than three fights between any two boxers if it makes sense ranking wise?

Wasn't aware that any scheduler had a cap on bouts between two fighters, but no their is no limit. I suppose its theoretically possible to have a dozen or more bouts between any two during a career, but that would be INCREDIBLY unlikely.

To answer the question, yes, in the unlikely event that it makes logical, practical sense for two fighters to have three or more bouts, this scheduler will allow it. One possible scenario I can envision is if the list of currently active fighters is particularly weak with the exception of two unusually good fighters at the top, they could foreseeably occupy the championship and the number one ranking for a long period of time. This would be unusual though.

A bit of info on the HOW of the scheduler:

It operates as closely as I could possibly make it to reality. The very first thing it does is establish whether or not a fighter is 'Active' at a given time. The World Champion can be active as much as once every two or three months, or as little as once a year. This filters all the way down to the Journeyman who are active as much as every month, and very rarely spend more then two or three months on the bench.

So, out of your list of current universe fighters (lets say sixty just to use a random number) you may have say, 20-30 of those active, or ten to fifteen bouts.

The World Champion, if active, MUST fight a ranked contender if their are any available (I rank 15 fighters, but again I can make this adjustable in later versions). Approximately half the time he fights he will make that the number one available contender.

Contenders, as in real life will fight amongst themselves to improve their ranking, and some will fight nobodies and journeymen to pad their records. However, when they do that they are penalised in the rankings (took me ages to figure that one out).

Newcomers and Prospects will generally busy themselves fighting stiffs (as real fighters do to gain experience) but the longer their career goes the more likely they are to step up.

I've been trying it myself over the last couple of days, and the scheduler does appear to be very realistic - however part of the reason I posted the file was to get the opinions of others - so have at it!

[umk]

Its sad this requires MS Excel 2007 and I can't use it. Can you make this not dependent on Excel? lol...

[jade_00]

Originally Posted by umk

Its sad this requires MS Excel 2007 and I can't use it. Can you make this not dependent on Excel? lol...

I can make it so at the very least Excel 2003 can use it, but the changes required in the code are so many its proving a tedious job. As of right now only 2007 can use it, and I'm very sorry about that

[umk]

If I had the time, I'd try to remake this in visual basic so that any computer that runs with windows can run it, similar to what I did with Thrift scouting reports. But this is so much bigger and I don't think I can finish it lol