3310. SumMassProps - An Excel VBA Solution for Summing Mass Properties

SAWE Members get 10 free product downloads each year. *
For more information, see FrequentlyAsked Questions.

* Discount will be applied at checkout. One free product per order. Current year conference papers are not included.

Title3310. SumMassProps - An Excel VBA Solution for Summing Mass Properties
Publication TypeConference Paper
Paper Number3310
Year of Publication2003
AuthorsZimmerman, Robert L.
Conference62nd Annual Conference, New Haven, Connecticut
Conference LocationNew Haven, Connecticut
PublisherSociety of Allied Weight Engineers, Inc.
Date Published5/17/03

Microsoft Excel is a general-purpose spreadsheet program that lends itself to mass properties calculations. There have been many papers written and presented to the SAWE showing differing techniques to use in determining assembly and vehicle mass properties. The problem with these techniques is that they require a portion of the spreadsheet to be used for storage of intermediate results and the equations used become complex and confusing using Excel?s native symbology. This paper introduces a comprehensive solution set for mass property summation using the built-in Visual Basic for Applications macro language extant in Excel. The solution set, ?SumMassProps.xla,? is embedded in an Excel Add-in. SumMassProps is comprised of three increasingly comprehensive custom functions: CCOG, a function to compute Center of Gravity; CMPROP, a function to compute the complete 10 by X mass property tensor; and CMUP, a function that extends CMPROP by also computing the combined independent uncertainty properties of all ten mass property terms in the mass property tensor. The Add-in also includes facilities to aid in setting up and using the functions in a spreadsheet. By using the Add-in paradigm, the solution set becomes available for use in any spreadsheet that is on the user?s computer. By using SumMassProps, the mass property engineer is freed from spending time debugging spreadsheets and re-inventing the wheel to determine a composite body?s mass properties. This solution set ensures that the proper equations are used and implemented in a consistent manner and speeds up production of reports and ?what-if? scenarios.

Key Words10. Weight Engineering - Aircraft Design, Mike Hackney Best Paper Award
Purchase/download this paperhttps://www.sawe.org/papers/3310/buy

Non-Member Price: $22.50; Member Price: $10.00 Members: First 10 product downloads are Free.


L. R. "Mike" Hackney Award

SAWE product downloads are copyrighted and shall not be reproduced, distributed, performed, publicly displayed, or made into a derivative work without permission from SAWE.

SAWE Copyright Policy