|
Post by Andrew Grant on Oct 26, 2012 15:33:56 GMT -5
I have developed a program for Microsoft Excel 2007/2010 to run double elimination tournaments. Download it and try it out. It is fully automated. It is setup to run up to 20 classes with up to 16 pullers in each class with logic to evenly distribute byes and avoid repeated match ups when possible. The program can expedite our tournaments, keep our audience informed and allow the final standings and a log of all the matches to be easily published. uploadingit.com/file/jbk4yft6phfcpags/TP4xL_MarchEDIT.xlsm
|
|
|
Post by A L L E N F I S H E R on Oct 26, 2012 17:18:11 GMT -5
This is really cool Andrew. Thanks so much for taking the time to do this. How do you get the Excel file?
|
|
Josh McEllrath
Gold Member
National Champion
PNW Armwreckers
Posts: 508
|
Post by Josh McEllrath on Oct 26, 2012 21:32:43 GMT -5
Andrew this is great!! Everyone else who is thinking of using this, please use an Infocus projector or hook your computer up to a video monitor big enough for your competitors to view the brackets.
|
|
|
Post by John Wilson on Oct 26, 2012 22:30:55 GMT -5
This needed to happen many years ago!
FANTASTIC! Big THANK YOU to Andrew Grant!
|
|
|
Post by michaelmeador on Oct 26, 2012 22:37:26 GMT -5
Its saying I have to be granted access to view the item, I sent the request but not sure how that works?
|
|
|
Post by michaelmeador on Oct 26, 2012 23:04:29 GMT -5
Yep, that worked and its badass...
I agree with Josh about the display of the bracket, A mounted TV set would be Ideal if applicable.
|
|
|
Post by John Wilson on Oct 26, 2012 23:24:24 GMT -5
it worked for me. THANK YOU
|
|
|
Post by Jim Wagner on Oct 27, 2012 6:59:27 GMT -5
thank you Andrew
|
|
|
Post by John Wilson on Oct 27, 2012 11:05:30 GMT -5
Andrew,
After playing with this for about an hour, it is safe to say that this is a really powerful tool. But many armwrestlers don't use computers to this level every day.
If I may make a suggestion, I think a really good addition to this would be a very easy to follow guide for someone to learn how to use it. When I need someone to help me learn a new interface, I ask them to give me a Sesame Street level explanation of it. I'm not too proud to ask someone to draw me a picture.
A Sesame Street explanation / guide tab in the workbook that walks a person through setup and use would be very helpful in my opinion.
|
|
|
Post by Carl Bowers on Oct 27, 2012 12:37:32 GMT -5
Andrew, these spreadsheets are nicely done. However, I have to agree with John that a sensible users guide should accompany the program for people that are not comfortable with excel. Again, very professionally done.
|
|
|
Post by Bill Cox on Oct 27, 2012 14:45:10 GMT -5
Hi Andrew. Could you possibly write that down on here for some of us that can't follow the demo video that fast and remember it all. That way e1 can copy and paste the written info to their files. The brackets look great, thank you creating this.
|
|
|
Post by Andrew Grant on Oct 28, 2012 17:44:22 GMT -5
|
|
|
Post by Jeff Janes on Oct 31, 2012 15:54:20 GMT -5
This is an awesome tool! How do you give the competitior a "weight'?
|
|
|
Post by Jeff Janes on Oct 31, 2012 15:55:21 GMT -5
Now if you could just create an "app for that"!
|
|
|
Post by Andrew Grant on Nov 1, 2012 10:21:35 GMT -5
You assign the competitor a weight when you load him onto the list by pressing the 'NEW PULLER' button.
You will be prompted for a first and last name, then for the weight (skill number and class). The weights are stored in column B in the 'select tab' and can be modified at any time.
The program can seed every single round by weight while avoiding repeated matchups. I think this is a great way to to run a small tournament without splitting people into weight classes
|
|