Match scoring software

I'm taking over as match director for a local match and I'm looking for some way of making the scoring etc easier. I know about the Tournament excel macros - I even bought a copy - but it doesn't run on Excel 2010 on a 64 bit OS. Does anyone know of an alternative?

Thanks
Derek

There would always be creating your own program with MS Excel. It is a lot of work but is possible. Not sure about 2010 though.

Excel has always been a powerful tool.

I'm running Tournament on Windows 7 using an obsolete version of Excel (2000). Works fine. Check around for older MS Office disks.

Check out Open Office. It's a suite of office software that is compatible with MS Office but is.... free. It is supported by Oracle. I would be almost positive it will run your excel spread sheet. It's great software.

Email or post a copy of the spreadsheet, I would like to see which formulas are incompatible, and we can all work on a new version instead of trying to make due.
kovach_robert@hotmail.com

Proprietary software Rob the formulas are hidden. The best bet is find an older program to run it on or contact John Dreyer and see if he will be making upgrades to accommodate office 2010.

John is on the forum as bullseyepistol

Otherwise I have had good luck posting questions to the software users group

HERE

gimble88 wrote:Check out Open Office. It's a suite of office software that is compatible with MS Office but is.... free. It is supported by Oracle. I would be almost positive it will run your excel spread sheet. It's great software.

True, but it didn't support the required macros to run Tournament.

Well, I mailed John a couple of times with no response.

If I had the time to write my own I wouldn't have bought this in the first place :-)

However, vmware, a 32bit copy of Win7 and Excel 2007 are a winning combination. Clumsy - but hey, for once a month I can live with it.

My office computer with MS Vista and MS Office runs Dreyer's Tounament 2 software just fine. However, my home laptop with Vista and Open Office won't run it (macros problem?). I found an old version of MS Office that I'll install on the laptop and see if that works.

John's software is really good and saves loads of time, but it needs to be updated. I hope he's working on it.

Ira Latimer wrote:My office computer with MS Vista and MS Office runs Dreyer's Tounament 2 software just fine ... Vista and Open Office won't run it.

Hello Ira, Derek, et al,

Tournament 2 was designed to work on any Windows Platform. There must be MS Excel (Microsoft Office version 2000 and later) installed on your machine. (Open Office is a watered-down open source clone of the real thing. I have used it by need on my Linux machines, but is ain't the same. I do not, and never will support it.)

I have successfully installed and am using Tournament 2 on a laptop computer with 64-bit Windows 7 and Office 2007, and I assume that Office 2010 will work as well. However, admittedly it works more seamlessly with Office 2003 or earlier versions. That is Microsoft's fault for changing their Office GUI interface. (Bill Gates, you jerk.)

The key in the installation of Tournament 2 on a machine with Microsoft Office 2007 or later is "don't force it." That means:

• If you have already installed Tournament and it doesn't work at all, delete the directory (folder) C:\Tournament and start over with fresh installation.
  
• Install the software from the installation file according to directions. It takes a few seconds.
  
• The FIRST TIME you start the program, Excel will ask you to convert the Macros - DON'T DO IT!!! You MUST leave them in the old format.
  
• One running in Excel, click on the ADD-ONS tab in the new lame Excel ribbon to expose the Tournament Menu Bar. ALL functions - including EXIT - are accessed there. You can't even close the program by clicking on the "X" at top right.
  
• When you exit the program for the first time, Excel will ask you to convert to a new format - DON'T DO IT!!! It will not work if saved in the .XLSM or other new file type.

If the first time the program is opened in Excel 2007 or later is done like this, you should have NO problems in all future sessions.

Hi John

Well, as a result of my testing (being a software QA geek I have all this *stuff* at hand :-)) Office 2k3 on XP works as expected, Office 2k7 and 2k10 work fine on Win7 32 bit, BUT Office 2k10 and Win7 (both 64 bit) fails to compile the macros.

I used the same clean install technique for each one - each starting from a clean, cloned, VM which is fully patched.

Just as a reference point.

As I said above - it's not a big deal for me - but there again I can create virtually any environment known to man. It might be a bit more aggravating for someone who just bought a new laptop. God alone alone knows what will happen with Windows 8.

Derek

straybrit wrote:Office 2k10 and Win7 (both 64 bit) fails to compile the macros ... God alone alone knows what will happen with Windows 8.

Hello Derek,
Despite opposition from the wife and kids, I am going to burn a week of vacation from the restaurant before the end of the year to work on rebuilding the Tournament brand program from scratch on a new platform. My logic will be that a sacrifice in features is outweighed by future compatibility for a decade or more to come. I've even considered a cloud-based platform using PHP and AJAX. We'll see....

I will always continue to offer solutions for folks using the Excel-based product for as many years as I can....

John has a fine commercial product which does much more than one I've got available. But, if you're looking to build something yourself or you'd like to see what I have, I wrote a '95 version of a scoring workbook that has been used by many over the years. Although I had password protected the macros way back when, (and subsequently forgotten them all), they are editable by today's versions without too much difficulty. But, hopefully, there should be no need. Anyway the package, called Bullseye.xls, is available, free of charge, on my site.

I haven't done anything substantial over the recent years. The only thing I did was to fix a problem that didn't allow renaming of the package. That should work fine now. I'd be interested in whether this version works with the recent iterations of Excel, if anyone would like to try. It will not work with OpenOffice or LibreOffice.

The page for the package is:

http://www.starreloaders.com/edhall/bullseyeprogram.html

Take Care,
Ed Hall
http://airforceshooting.org/
http://www.starreloaders.com/edhall/

The excel scoring program on star does not work with excel 2010. I emailed a excel help forum and a guy on there was able to correct the extensions to make it work. I have used it several times and it works great. Send me an email and I can email it on.

Russ

ps. the first thing I did was virus scan it since I never would have thought somebody out there would fix something for free but he did, and a year later I have no virus.

My email is: japurd04@yahoo.com

If you're referring to a year old version, then you are probably talking about a naming trouble I had with the original program. Somehow I included some full path macro names in the VB, which made it crash if you changed the name. When MS went from the xls extension to the xlsx extension, that broke it, if you saved it in the new format. I have since corrected that trouble, but I have no way of checking whether there is anything else incompatible with the newer versions of Excel.

That is the only change I have made to the software in several years, so if you have a working copy, don't bother downloading the new one, (unless it's just to check whether it works[smile]).

Thanks for the note.

Take Care,
Ed Hall
Air Force Shooting Teams
Things of Interest to Bullseye (and International) Competitors

Thanks Ed! I will probably try it for fun. Before, it gave me the following error:

"Opening the VBA project in this file requires a component that is not
currently installed. The file will be opened without the VBA project. For
more information, search office.com for "VBA Converters".

Sounds like the problem you fixed. Your program is great and there are a lot of people out there that appreciate it. That was January when I couldn't get it to work.

Thanks!

RUss

Thanks Russ,

That might have been the program looking for the non-existent macros, but it's hard to say. It might also be referencing a change in the Visual Basic code over the years.

If I can get near a current Excel machine for a little while, I'll try to ensure it's up to standards.

Take Care,
Ed Hall
Air Force Shooting Teams
Things of Interest to Bullseye (and International) Competitors

A helpful hint if using John Dryer's programs is what to use for the awards rate matrix. At the local matches in this area we generally use
Fired Matches
1 (Open Win) 1,1,1,1 (Class / Category)
Aggs
2 (Open Win) 2,1,1,1 (Class / Category)
Grand Agg
3 (Open Win) 2,1,1,1 (Class Category)

This generally gives a good distribution of awards back to the competitors.

Cecil

Hi. I'm new and I'm computer challenged. I don't know a spread sheet from a dryer sheet. Is there a plug and play program for bullseye pistol shoot scoring w/dropped point handicap?
Thanks
Steve ssloan47@hotmail.com