33 replies to this topic

[Wakal]

Beven,

We "fixed" the problem of minor/major scoring using (un)EzWinScore and the magic of Excel spreadsheets. The prime mover on that one is Jkmccoy, our own "Professor" here on this very board. He developed a very elegant solution that works perfectly, and has posted about it on this board repeatedly.

It requires a stats officer that is on the ball, of course.

And as Benny pointed out, it worked flawlessly for the 2003 and 2004 USPSA Texas State 3-Gun Championship.

However, fixing (un)EzWinScore shouldn't be a major undertaking. This sport, as a whole, has some of the most brilliant and innovative people I've ever met.

Sending out new copies of the new program to everyone, now THAT would be a major undertaking and, I suspect, the root cause of the lack of program upgrade.





Alex

[George]

We "fixed" the problem of minor/major scoring using (un)EzWinScore and the magic of Excel spreadsheets. The prime mover on that one is Jkmccoy, our own "Professor" here on this very board. He developed a very elegant solution that works perfectly, and has posted about it on this board repeatedly.

It requires a stats officer that is on the ball, of course.

Hi Alex,

I agree that I would have no problem using the “McCoy Method”, nor would Bruce Gary and about 1 out of 25-50 folks already using EZ-Winscore. So the “requires good stats officer” part is no lie and no easy task for a club without that already, whereas Bevens methodology requires no real data churning and special manipulation steps. It just re-defines a term and gets additional mileage out of the system already in place.

The definition of “Elegance“ in design is typically one of simpler, more flexible, less rigorous sets of actions and fewer parts. Adding Excel to EZ-Winscore is not “Elegant” no matter how elegantly a slick stats person applies a series of workarounds requiring additional steps.

Beven’s proposal is elegant and eminently workable for anyone who is already using EZ-Winscore no matter how slick they are, or aren’t. It also means that it can be put to use by anyone, at any club already using any version of EZ-Winscore or even MSS by just reading Beven’s initial post.

That’s “Elegant”

--
Regards,

Edited by George, 30 June 2004 - 06:55 PM.

[TeamGE]

Wakal,
I understand, and agree that your fix works and works well. And I am not trying to deminish your efforts or any of the other people who made it happen. You bring up an important point that I am try to make. You quoted "It requires a stats officer that is on the ball, of course" to make sure that the modified programs stay in line. I agree that we have some of the greatest minds in this sport that will fix our program and it will happen. But for right now, we need to take care of the computer tech stats officers that we so dearly need now, by giving them the easiest method of inputting scores. It is not fun being the stats person, and it is done by volunteers with a high burnout rate in the most part, (as is all the other jobs in the club). Show up at a 3gun match with 3 guns, declare division, class, power factor, pay your dues, and shoot the match. The stats person enters the score sheet numbers just like a pistol match, with Tactical in L10 and Heavy Metal in Revolver (as George suggested). Those shooters in those devisions will see their scores there. No extra work or software setup.

Edit note:
I just can't type fast enough to beat you to the post, George. Thanks and sorry for repeating just about everything you said.

[George]

just can't type fast enough to beat you to the post, George. Thanks and sorry for repeating just about everything you said.

Vice Versa

And now for something entirely different.

Anyone got any good ideas for a Hot Drop Box to allow for on the clock weapon abandonment? I was kinda looking at shoot through the barrel type props which everyone usually has at a range, pointed into a side berm/wall with a hunk of rug in it and maybe a partial end plug to keep a long gun from sailing right on through.

--
Regards,

Edited by George, 30 June 2004 - 07:07 PM.

[Barrettone]

Wakal:

Can you please PM me with the "McCoy Method" (excel spreadsheets) and all applicable instruction as to their use? I am the MD for the Area 5 3 Gun and would like to look at using it. Please tell me that he saved his work??? Sorry in advance for hijacking the thread.

Jeff

[George]

Here is the text from a post by Mr. McCoy simply outlining his method.

BTW - we will run the Texas State 3-Gun with multigun stages. Shooters have declared a division for the aggregate. I will score it as three separate matches and calculate tournament standings as the sum of match percentages in each of the one-gun matches (calculated manually since EZWinScore does not currently recognize Tactical division). Divisions for the one-gun matches will be based on the aggregate division (Open = Open pistol, Open rifle, Open shotgun; Limited = Limited pistol, Limited rifle, Limited shotgun; Tactical = Limited pistol, Open rifle, Limited shotgun). It is noteworthy that I currently have more entries in Tactical division than in either of the others. Each multi-gun stage will be scored in one of the single-gun matches and that will be clear in information given to the shooters (e.g. there is a rifle/pistol stage that will be scored in the rifle match). I know EZWinScore doesn't really allow scoring of multi-gun stages but I can fool it into working correctly and scoring each hit with the appropriate power factor.

Here is a link to the page from that thread where it is posted.

http://www.brianenos...pic=12562&st=40

--
Regards,

[Erik Warren]

My hint was to treat rifle like shotgun, all Major, all the time. (55 gr @ 3100 fps gets 3 points for a C while 180 gr at 920 fps gets 4 points for a C? BS! OK, maybe it makes sense in the context of a rifle-only match versus more powerful rifles, but in a multigun with pistols and birdshot, BS!)

Flex's one gun Minor, all guns Minor would work, too. But I like recognizing the rifle's significant power compared to the other guns. Plus, for rifle paper, we're not talking a whole lot of shots in a multigun match.

[Wakal]

Thanks for the backup! Old guys like me need sleep...0530 PT comes far too early.

Kelly is out camping with Mrs. Professor and all the Professorlings, but I will direct his attention to this thread when he returns.


On the subject of "grounding hot weapons"...here is what we used.

We started with a 10" cardboard tube 4' long, as found at your finer hardware stores. Lined with carpet padding and the bottem blocked (and stuffed with carpet padding). Top edge taped for a neat and semi-pro "look."

A 5' by 30" section of rubber conveyer belt, bolted to form a tube, and then filled with dirt...with the cardboard tube sticking out of it (and usually through a hole in a handy wall) at a 45-degree angle.

The rifle or shotgun's finish isn't hurt by the carpet padding (we all know how concerned the average IPSC shotoer is with their gun's pristine condition ), and is grounded muzzle-down in a heap of sand.

Weapons rack meets clearing barrel.





Alex

[TeamGE]

Flexmoney has started a thread on "Hot Drop Box" Ideas at:

http://www.brianenos...showtopic=14795

If you are interested.