[Amigo-2k]

I built something like this about 5 years ago:

Download the excel file here: www.walkerdowney.com/ryanendres/carshowform.xls

Download the how to document on using it here: http://www.walkerdowney.com/ryanendr...wFormHowTo.doc


For more car show tips and tricks check out: www.carshowtips.com

[gregneun]

I'd be a little bit concerned about borrowing the ballot machines in Illinois. You're libel to get dead people voting on their favorite cars. Lotsa 1960 votes again.

Greg

[Old Blue 66]

Originally Posted by gregneun

I'd be a little bit concerned about borrowing the ballot machines in Illinois. You're libel to get dead people voting on their favorite cars. Lotsa 1960 votes again.

Greg

Ha. Very funny. You may be thining of FL. We own the ballot machines.

[69geeto]

The ballot machine would be the way to go, unfortunately, the availability and cost for most shows won't allow for this option. So, in the interim, it's Excel

[GT182]

Originally Posted by Old Blue 66

Ha. Very funny. You may be thining of FL. We own the ballot machines.

Yeah but the Chads will screw up the count. LOL

[Old Blue 66]

Originally Posted by 69geeto

The ballot machine would be the way to go, unfortunately, the availability and cost for most shows won't allow for this option. So, in the interim, it's Excel

I know that. What I was talking about was finding a cost effective solution which you have. These machines were donated to us sometime ago.

How do you read the ballot? Are you importing it to Excel?

[69geeto]

We're just entering the numbers off the standard ballot. No machine yet. So, the numbers go into Excel and one click, and you have the winners information printed and ready to hand out awards.

[69geeto]

Just uploaded a tutorial (first try at this) on the Best in Show software. Enjoy the movie
https://www.youtube.com/watch?v=3yVqIrs6kAg

[GTO JUDGE]

We purchased this software last year and used it for our All Pontiac Show. It worked flawlessly. Took less than 5 minutes to tally the votes. Cut a good hour off hand counting.

[69geeto]

Thanks for the feedback. I'm glad it's working for you as advertised!

[69geeto]

If anyone is still interested, There is a new website and a few new tutorial videos. https://www.youtube.com/watch?v=vSKf...aoiCXh5jLjJMhu

[Longs]

I created a similar tool using Excel so that our GTO Club could use the GTOAA "weighted scoring" method for a local car show that we sponsor. The GTOAA scoring assigns different weights (3 points for a first place vote, 2 points for a second place vote, and 1 point for a third place vote) in its Popular Vote scoring. We've used it for a couple of shows, but it still takes time to key all of the votes into Excel. Yes, when you're finished entering votes, the results are instantaneous with Excel Pivot Tables.

At the last show with approximately 150 cars we keyed over 2,400 ballot entries. Even keying at 2 seconds per vote, that translates into 80 minutes using one computer, and that's with someone who is very proficient using the numeric 10-key pad on the computer keyboard. GTOAA Popular Vote counts will exceed 12,000 - 14,000 votes to be counted, maybe more.- you'd need several proficient 10-key data entry people to not have someone working on the entries for 8 - 10 hours. GTOAA's position is that it's easier to get 10 - 12 people around a table, passing the ballots around and tallying with paper. If the most important factor is "clock time", one or two people on computers can't tally faster than a dozen or more people with pencil and paper. For a local show where it's difficult to get volunteers to tally, the computer's a good option. I'd be surprised if anyone could convince GTOAA to abandon the paper method anytime soon.

If you could scan ballots and populate a program, that would be the best method, but then the software has to be able to deal with sloppy handwriting and other challenges.. There are probably capable optical character recognition programs out there, presumably that could create records in a database or spreadsheet to enable pivot table calculations.