ebarrelracing.com forum
General Category => General Discussion => Topic started by: Imprettiest on August 28, 2009, 10:14:05 AM
-
I have formulated (a no brainer) Excel spread sheet for any arena wishing to try it or use it. It is set up according to 1-50 runs. All you do is enter the name of the runner, the name of the horse, the amount paid, and their time. The spread sheet will automatically figure (the rest) their placing, and the total amount of money.
It does not, however, figure their placing 1-50 in order because it is set up for runs 1-50. To do this can be done simply enough by "SORTING". At the end run of the class simply "SELECT ALL" then click on the DATA tab on the Excel spread sheet, then select SORT and sort by placing. It will then sort from 1st place threw 50th place in order (it is very important to select all first). We use this template at the Ash Creek Arena and it works quite well. It takes the brain work out of doing anything, and the computer does everything for you accurately. I have highlighted the PLACINGS column in red type. This is where the formulas are located and it is in red type to indicate (a reminder) DO NOT TOUCH. You DO NOT wish to change any of the formulas, trust me. They are very long and legnthy.
This spread sheet belongs to me and I have no problem in sharing this information to help make someone else's life a little more simpler. Anyone wishing to try a sample spread sheet or would like to use a template spread sheet can write to me at [email protected]. My suggestion is that you keep the template in a safe place and never use it. Always make a copy of the original (copy and paste) to use.
I am currently working on a no brainer spread sheet to calculate all the classes, but that one may take a while to accurately formulate.
Gary Kennedy
-
Example formula (50th placing)=IF(D51<0,RANK(D51,$D$2:$D$51),RANK(D51,$D$2:$D$51,1)+ COUNTIF($D$2:$D$51,"<0"))+COUNTIF($D$2:D51,D51)-1 :
-
very cool
-
It does save a lot of frustrations, time, and saves you from any and all mistakes. The formulas and templates were tested and then retested again. As long as the formulas are not changed in any way it's fool proof and they do work well. You can make it 1-100 runs or what ever you care to make it.
Excel formulas can be very complex and I know many of people who have tried and failed. I see no need in keeping it all to myself.
-
Thats cool!!
-
I'm going to try it on the side lines and see if it does ok. It probably won't be the spreed sheet thats goofs up it will be me.
-
Just add about 15 different names and times as a test. Doesn't matter how many you add. It will only calculate the times that you put in. Not all 50 unless you enter 50 times, and they don't have to be run 1-15 order. You can skip a few here and there, it doesn't matter. You will see. It will automatically place the times from 1st place to 15th place. Just stay out of the red area where the formulas are located. You have no reason to go there unless you are changing a formula. Once you are threw adding names and times do as I said before.
Select ALL/ select the DATA tab/ select SORT/ sort by placing, and it will sort them 1st place threw 15th place in decending order along with their names and times.
-
HI Imprettiest - That is great ~I will email you - I would love to have a copy!!!! Very nice of you to share...
-
I've been working on it a little here -n- there in my spare time making improvements and modifying it. It's almost 100% complete, but the final copy when it it fully automated will have the formulas locked into place to make it (wife proof) from getting accidently messed up and I will keep the final copy to myself, but the formulas installed in the one I send you will help you greatly with your own sheet.
My final copy will place the winners automatically along with the D's and the payout. It will take a matter of only a few seconds and you will have the winners of each D-class and the amount of payout. As of right now it only takes a few minutes to figure who won what, but when I'm done it will only take about 5 seconds before they anounce the winners.
-
OK.. I RESENT THAT REMARK............SEEING HOW IM YOUR WIFE!!!!!!!!!!!...........MMMMM............ THANKS
-
Thats funny
-
Will it calculate if we use added money? The added money changes each barrel race.
-
all this formula does is set the placing 1st thru 208, so far... it does not calculate the monies.. I did that on my own for the 4D. Then when I do added money, I just divide it between the number of places. We pay out in equal money, for each D. this formula he has works as far as the placings
-
Can you send it to me at [email protected] I am trying to find something simple to use at our cowboy church barrel races.
-
Hey thanks this is alot of help but i need the program in excel that is used for barrel racing (nbha). This means that i need it to be a 4-d or a 5-d format. Thanks for the help!!!!!
-
I am looking for a finished spreadsheet. I will be using 2d, 3d & 4d payouts for our local jackpots. If anyone is willing to share an excel spreadsheet and calculations, please respond. Any help is greatly appreciated. [email protected]
-
I had it, but my old computer crashed so I lost it. Would you please send it to me at [email protected]? Thanks
-
The hubby has it on the computer at home, I will get him or I can send it to you.
-
thank you so much!
-
OldCanChaser, would you please send it to me? [email protected]
thanks
-
OldCanChaser, would you send it to me also? [email protected]
Thanks!
-
can you send to me too [email protected]
-
I posted this 2 years ago. Sorry for not replying sooner. Goes to show how much time I spend on here. Between family, the farm, & working a graveyard shift....it consumes me.
Here's the problem (besides what I mentioned above) :
The spread sheet is on a computer that has a 'BOOTLEG' version of Excel. I can not access the internet on that computer. The second that computer is linked with the Internet, Microsoft will shut it down & lock it up permanently! This computer here does not have Excel.
Here's the solution:
(2 solutions actually) I have the weekend off (it's a miracle) with nothing to do.
1) This weekend I will transfer the spread sheet to a computer with a licensed version of Excel and email out to whom ever in here that had a request with an email address.
2) The second solution is I will be posting the formulas or as many as ebarrelracing will allow to post, and you can use the formulas to do your own custom spread sheet.
I have, however, improved over the old spread sheet. The new spread sheet will go up to 208 placings flawlessly. Use these formulas to make the placings go to as far as you want. It is also my suggestion that you use the spread sheet that I send out ONLY as a template. Copy & paste from the original so that the original stays in tack.
Also, feel free to share! The formulas are NOT registered or patented.
-
thanks! I will just wait until you can transfer.
-
can someone please send me a copy of this spead sheet or a program for the 4-d barrel races to figure placing and money.
[email protected]