Film, Media & TV1 min ago
How do I calculate height of a person by the lenth of the Ulna.
35 Answers
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?
Answers
Best Answer
No best answer has yet been selected by RATTER15. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.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
http://forensics.rice...dfs/activity_nine.pdf
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.
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.
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
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
http://www.eurasianjo.../article/view/327/179
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.
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.
-- answer removed --
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?
I'd be happy to help with it if you would find it useful?
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.
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.
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 :-)
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 :-)
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.