In order to address the issue of increased efficiency and better planning for parcel shipments, an automated computer program was developed in Microsoft Excel that calculates center of mass and moments of mass with greater speed and reliability than currently implemented systems. This simple program requires only a variable density function and limits of integration for a given object as input within the spreadsheet system. Once the required input has been provided, a series of chain calculations, with the help of a Visual Basic for Applications (VBA) script, is able to process the input, which is done through integration and a Riemann sum. Furthermore, the foundation of the program can also be used for calculating other physical quantities of interest such as the moment of inertia or surface area of an object.
This article was previously called Article 15.
"Automated Determination of a Package's Center of Mass,"
Undergraduate Journal of Mathematical Modeling: One + Two:
1, Article 3.
DOI: http://dx.doi.org/10.5038/2326-3622.214.171.124 Available at: http://scholarcommons.usf.edu/ujmm/vol3/iss1/15
Gerald Hefley, Mathematics and Statistics
Ben Lynch, United Parcel Service of America