Volume Height Index for Excel
As a metric for body size, the Volume Height Index or VHI can be used. A VHI score is calculated by dividing a person's volume by the square of his height. By setting up a table in Excel and using a formula, you can simplify the process of calculating VHI scores.
-
Volume
-
In Column A Row 1, type "Volume." In Column A Row 2, you will ultimately enter the volume of Person 1 for whom you want to calculate a VHI score. Until you are ready to actually calculate the score, simply insert a place-holding value such as "1."
Height
-
In Column B Row 1, insert the text "Height." In Column B Row 2, type a place-holding value such as "2." Later you will replace this value with the actual height of the subject you want to calculate a VHI score for.
VHI Formula
-
In Column C Row 1, give the column a header by typing "VHI Score" or "VHI Calculation," as desired. In Column C Row 2, begin inserting the VHI formula by entering an "=" sign and following it with the place-holding volume value "A2." Insert a "/" to signify the volume is going to be divided by the following expression. Add an open parenthesis "(" and your height value of "B2." Insert the carrot symbol "^" followed by "2" to mathematically raise the height to a power of 2. Insert a close parenthesis ")" to close the expression. The formula in its entirety should appear as follows: =A2/(B2^2).
Key
-
Insert an explanatory key to the side of your formula, as desired. For example, in Column E Row 1 type "Key." In Column E Row 2 type "Volume is in cubic liters." In Column E Row 3, type "Height is in meters." In Column E Row 4, type "VHI Score is in liters divided by squared meters." When satisfied, click "File" and "Save As" to save your VHI Excel file. Re-open the file anytime you want to calculate a VHI score. At that time, input a subject's volume into field A2 and the subject's height into field B2. The VHI Score will automatically readjust in field C2.
-
