# How do I calculate height of a person by the lenth of the Ulna.

RATTER15 | 11:26 Wed 20th Apr 2011 | Technology
I frequently use a chart to work this out, no problem. However I'm working on a spreadsheet that will work this out for me along with other things, there are lots of charts and calculators online that will do this for but I need the calculations so I can insert the formula into excel, I cant find it!! any help please?

1 to 20 of 34

No best answer has yet been selected by RATTER15. Once a best answer has been selected, it will be shown here.

Question Author
*length*
Question Author
ty Chuck, but it doesnt give the calculation, just the result.
Heres the formulas (doesn't work on me BTW it makes me about 15cm shorter than I am)

http://forensics.rice...dfs/activity_nine.pdf
Stature = 3.958 * ulna length + 664.72  83.28

I am off out now , but Google ...Trotter Gleser.
I see no "arm" in this question, but sorry can not give you a proper answer!
Question Author
Thanks again chuck, unfortunately I cant use that in my situation "The formulas provided were designed for individuals between 23 – 30
years old. Before the ages of 18-23 a person’s bones have yet to full ossify. Ossification is the natural replacement of cartilage
with bone; it is responsible for nearly all bone growth. Because these bones are still growing, the relationship between bone length
and an individual’s height is extremely variable. Be sure that your class realizes that the data they collect from each other is only
applicable to their same age group. It would NOT apply to adults."

I'm working on the elderly, I didn't realise the calculation was age related.
Question Author
That is interesting sqad, Im no mathamatician, what do those number mean, I cant make sense of them, "Stature = 3.958 * ulna length + 664.72  83.28"

3.958 what ?
Just 3.958....

Sqads formula seems to be using MM

If the ulna measures 32CM (320MM) (as mine seems to) it would be

Stature = (3.958 * 320) + 664.72

So stature (height) = 1 931.28MM or 1.93M

(still low for me!)

The last bit of sqads formula was simply given the normal margin of error as plus or minus 83.28mm
also sqad seemed to have gotten the details from here...

http://www.eurasianjo.../article/view/327/179
Ratter...I am back now.........chuck has made it clear, but this is a complicated problem which depends upon sex and racial characteristics.

Trotter and Gleser are the recognized experts in this field.

Ratter.....why do you want this specialised information.?
First remove and measure the ulna. Then starting at the feet with the ulna parallel to the shin, rotate the ulna upwards until you reach the head. Multiply the length of the ulna by the number of rotations+1.
Don't forget to replace the ulna when you've finished.
Question Author
Thanks all for your help, I think its just going to be to complicated to put this formula into excel to work for everybody.

Sqad, I was trying to make things a little automated in the home where I work, to work out the BMI I need the height of the person concerned, to get their height I need to work it out from the ulna, its not very diplomatic to measure someone from head to toe whilst they are lying in bed as many cannot stand and the Ulna measurement is the way my Company likes it to be done. Its all part of a malnutrition monitoring programme that I'm working on.
Question Author
Eddie, weighing is not a problem as we hoist onto scales etc. we monitor and record all food that is consumed and we are aware of calorific values but as of yet we don't have to record the calorific values, I'm sure it will come though.
Hi Ratter, it looks a fearly simple calculation to put into Excel. If you look at the Chuck's URL it shows the calculations. All you would have to do is put the patient(?) measurment in then look at the appropriate row of sex and race to get your answer.

I'd be happy to help with it if you would find it useful?
Question Author
Johne1892, I'm very new to excel, this is a bit of a project I'm cutting my teeth on.

Your help would be appreciated, many thanks :-)
Hmmm, If I get some spare time over the weekend I might try looking into this a bit more.

as it stands it's a tricky one as there are a few variables that need to be taken into account.

You have (as far as I can see)

Length of Ulna
Male or Female
Age

There are two ways of doing it that spring to my mind (I'm not an excel expert though, but I can get by)

You could firstly try and write a single formula that includes several if statements to take into account the age and sex so it calculates properly.

Or, write out a table on a separate worksheet with all the results on it and write a vlookup formula, again with several if statements in it to return the result from the correct column depending on age and sex.

I think I'd be tempted to go for the table and vlookup solution, but I'd have to have a play to see exactly how to get it to work.
RATTER,,,,blimey, that sounds pretty high powered to me, but a question "Is measuring the BMI of an elderly person the best way of assessing malnutrition?"

Question Author
Thanks Chuck, any help would be greatly appreciated. Sqad, the BMI is just a part of it. The malnutrition i calculated on the universally recognised M.U.S.T tool, see here:

http://www.bapen.org....fs/must/must_full.pdf

I also need it to be able to work out the percentages of weight loss/gain on a monthly basis.over.

I think it is fairly safe to say that due to the fact we have extremely few ethnics living in this area and none in the home I won't need to consider ethnic minorities at this point. All residents are over 60 so anything based on an elderly scale will be accurate enough.

Many thanks for any help :-)

1 to 20 of 34