•  
  •  
 

Publication Year

2010

Abstract

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.

Erratum

This article was previously called Article 15.

Included in

Mathematics Commons

Share

COinS

Advisors:

Gerald Hefley, Mathematics and Statistics

Ben Lynch, United Parcel Service of America

Problem Suggester:

Ben Lynch