This macro was written in Microsoft Visual Basic for use with Microsoft Excel. It computes cross-sectional geometric properties from biplanar radiographic images using the eccentric ellipse model (EEM) described in detail by Milgrom et al. (1989) and Ohman (1993). The Macro was first implemented in: O’Neill MC, Ruff CB. 2004. Estimating human long bone cross-sectional geometric properties: a comparison of noninvasive methods. J. Hum. Evol. 47:???-???

A. General Instructions
The EMM_Macro is very simple and works in the same manner as a cell function. To begin, enter your data in the columns G through N:
AP
ap
ac
pc
ML
ml
mc
lc
AP = anteriorposterior external breadth
ap = anteriorposterior breadth of medullary cavity. Computed automatically as AP-(ac+pc).

Leave blank (see below for explanation).
ac = anterior cortical thickness
pc = posterior cortical thickness
ML = mediolateral external breadth
ml = mediolateral breadth of the medullary cavity. Computed automatically as ML-(mc+lc).
Leave blank (see below for explanation).
mc = medial cortical thickness
lc = lateral cortical thickness

Once the data is entered the Macro is implemented by going to TOOLS, scrolling down to MACRO, and then clicking on MACROS. Make sure “EccentricEllipseMacro” is highlighted and then click RUN. This will compute the cross-sectional geometric properties using the eccentric ellipse model for 150 sections.

Download pdf Using the Microsoft Visual Basic Macro EMM_MACRO