Search

Showhorse.com Forum · General

Replies in this thread : 8

Author Topic : Standard Deviation Calculator
 Painters
Family Account Owner
Posts : 141

System.__ComObject
5/7/2018 11:57:46 AM reply with quote send message to Painters Object to Post   

Helpful Hint (I think) if you want to use this:

www.calculator.net/standard-deviation-calculator.html?numberinputs=96%2C90%2C85%2C103%2C93%2C97%2C88%2C98%2C77%2C88%2C85%2C83%2C92%2C79%2C84%2C95%2C71%2C92&x=66&y=21

Entering each horse's numbers is going to be a bit tedious but if you copy the numbers from that little scrolling box under the colour bar chart and paste them into a simple Notepad program (comes with all Windows OS versions I believe) you can save some work.

The numbers will paste down the page but starting with the top one, type a comma then hit the delete button. You are actually deleting the line-feed character. This will bring the second number onto the same line as the previous.

Space to the end of that second number, type another comma and delete, and so on.

Eventually you will have the required comma delineated string to cut and paste into the calculator.

Remember to exclude the Temp, CowSense, Agility, and Surefoot - they are not part of the normal equation we use - just the first 18 numbers.

Cut and paste this string into the calculators data box.

Hope this helps. I know it's still a bit tedious but at least you don't have to type each value - correctly - into the calculator.
 Big Horn Ranch
Premium Member
Posts : 11

Premium Member
5/7/2018 11:16:32 PM reply with quote send message to Big Horn Ranch Object to Post

Anyone have a link to the Excel spread sheet?
 GaylanStudio
Family Account Owner
Posts : 1,000+

Family Account Owner
5/8/2018 1:13:56 AM reply with quote send message to GaylanStudio Object to Post

No link but I can send you a copy of my Excel spreadsheet. Or if you just want a few horses done to check I'll see what I get for you.
 P8ntedPny
Family Account Owner
Posts : 500+

Family Account Owner
5/10/2018 3:42:27 AM reply with quote send message to P8ntedPny Object to Post

Yeah please send again as my other copy was corrupted..
 P8ntedPny
Family Account Owner
Posts : 500+

Family Account Owner
5/10/2018 3:42:34 AM reply with quote send message to P8ntedPny Object to Post

Yeah please send again as my other copy was corrupted..
 P8ntedPny
Family Account Owner
Posts : 500+

Family Account Owner
5/10/2018 3:42:35 AM reply with quote send message to P8ntedPny Object to Post

Yeah please send again as my other copy was corrupted..
 P8ntedPny
Family Account Owner
Posts : 500+

Family Account Owner
5/10/2018 3:42:35 AM reply with quote send message to P8ntedPny Object to Post

Yeah please send again as my other copy was corrupted..
 Big Horn Ranch
Premium Member
Posts : 11

Premium Member
5/21/2018 5:48:00 PM reply with quote send message to Big Horn Ranch Object to Post

Are these numbers correct? Which set of numbers are you supposed to use when you use the Excel sheet?
showhorse.com/horse.aspx?id=683399
showhorse.com/horse.aspx?id=683396

Do you use the white are named String Size or the one named Autumnwoods Calc.
 GaylanStudio
Family Account Owner
Posts : 1,000+

Family Account Owner
5/22/2018 9:41:05 PM reply with quote send message to GaylanStudio Object to Post

this post has been edited 3 time(s)

We seem to agree for "Win" but not for "Apprentice" - don't know why.

This is what I get - all of the numbers I generate:

Midnighr Win
================
OAT (Adjusted): 1673
OAT (Not Adjusted): 1743
Standard Deviation: 08.06
Halter Score: 749.41
================
749.41 1673+70 [08.06 69] 15h1 60-53
749.41 1673 [08.06 69] 15h0 42-60-53
749.41[1673=559+577+537]08.06[15h0 60-53]
OAT: 1743 StDev: 08.06 Halter: 749.41 Temp: 69
================
599 559 Totals - Conformation
603 577 Totals - Muscling
541 537 Totals - Balance
================
1673 1743 Totals - Overall
================

Apprentise
================
OAT (Adjusted): 1652
OAT (Not Adjusted): 1688
Standard Deviation: 08.16
Halter Score: 742.13
================
742.13 1652+36 [08.16 53] 14h3 56-51 -
742.13 1652 [08.16 53] 14h3 49-56-51 -
742.13[1652=557+561+534]08.16[14h3 56-51] -
OAT: 1688 StDev: 08.16 Halter: 742.13 Temp: 53
================
569 557 Totals - Conformation
579 561 Totals - Muscling
540 534 Totals - Balance
================
1652 1688 Totals - Overall
================


You can use whatever notation you want.

When I'm sending to auction I try to remember to put those first 6 lines (including the ===) in the auction description. Not many seem to use this field but if I want the horse to sell I want to tell potential buyers as much as I can.

For my "Call Name" I usually use the the next line down - it has the halter score, adjusted OAT plus the amount to add to get the non adjusted OAT, [StdDev and Temp], size, Agility, Surefoot.

The next line down doesn't have the OAT adjustment in order to make room for the cow sense for the cutting horses.

I paste the whole lot into the horse notes so I have it for reference even if I don't often use a lot of it.

I have made some modifications to may spreadsheet over the past few months if you have the old one I sent out to other folks - feel free to share with anyone.

String size tells you the length of the string so you know if it's too long - 50 characters max for the "Call Name".

To get the new spread sheet I need your real email address - send me a PM.




-----
Last edited by GaylanStudio on 5/22/2018 10:03:55 PM

Replies in this thread : 8

Post Reply