SAWE Technical Papers

@inproceedings{3799,

title = {3799. A Quick Start Guide to Using Excel VBA},

author = {Robert J. Hundl},

url = {https://www.sawe.org/product/3799-a-quick-start-guide-to-using-excel-vba/},

year  = {2024},

date = {2024-05-22},

booktitle = {83rd International Conference, virtual (2024)},

pages = {41},

publisher = {Society of Allied Weight Engineers, Inc.},

abstract = {MS Excel is a tool that just about every engineer has on their desktop PC.  Visual Basic for Applications (VBA) is a very powerful feature included in MS Excel that most users don’t use.  It was first introduced in MS Excel in 1995 and over the years has become even more powerful.  In this paper, I will review useful programming commands, ways to speed up processing of data, and provide a few examples of use. },

keywords = {General},

pubstate = {published},

tppubtype = {inproceedings}

}

@inproceedings{3806,

title = {3806. SAWE Handbook Section 2.2 Solid Properties Excel Formulae},

author = {Robert L. Zimmerman },

url = {https://www.sawe.org/product/3806-sawe-handbook-section-2dot2-solid-properties-excel-formulae/},

year  = {2024},

date = {2024-05-22},

booktitle = {83rd International Conference, virtual (2024)},

pages = {17},

publisher = {Society of Allied Weight Engineers, Inc.},

abstract = {The SAWE Handbook Section 2 has figures and formulae for many shapes, including (Section 2.1) Plane Areas, (Section 2.2) Solids, and (Section 2.3) Shells, Section 2.4) Thin Rods. This paper will concentrate on Solids, Section 2.2, and convert the formulae from this section into equivalent Excel equations that can be used to derive the mass, center(s) of gravity, and the mass moments of inertia of these solid shapes. The resulting values can then be used in determining the mass properties of these and composite entities in further calculations.},

keywords = {General},

pubstate = {published},

tppubtype = {inproceedings}

}

@inproceedings{3807,

title = {3807. Why Measure?},

author = {Bob Cipolli},

url = {https://www.sawe.org/product/3807-why-measure/},

year  = {2024},

date = {2024-05-22},

booktitle = {83rd International Conference, virtual (2024)},

pages = {2},

publisher = {Society of Allied Weight Engineers, Inc.},

abstract = {Mass properties determination is critical for the mission success of a variety of objects. From spacecraft and airplanes to computer disc drive heads and golf balls. Weight, center of gravity, moment of inertia and product of inertia can be estimated through computer modeling but those values are lacking in real world tolerances that may not reflect the entire process of design, machining, assembly, and environment. This paper reviews some of the reasons for measuring those mass properties and the possible repercussions of flawed estimates.},

keywords = {General},

pubstate = {published},

tppubtype = {inproceedings}

}

@inproceedings{3809,

title = {3809. Practical Limits of Precision when Tracking Weight Changes in Series Production},

author = {Doug Fisher},

url = {https://www.sawe.org/product/3809-practical-limits-of-precision-when-tracking-weight-changes-in-series-production/},

year  = {2024},

date = {2024-05-22},

booktitle = {83rd International Conference, virtual (2024)},

pages = {12},

publisher = {Society of Allied Weight Engineers, Inc.},

abstract = {Calculafing and tracking the weight impact of design changes during aircraft product development and series producfion is an important part of ensuring a program's success. Computer model-based design tools and databases allow miniscule impacts to be calculated, documented, and tracked - each at a cost to the program in non-recurring hours. There exists a pracfical lower limit for weight impacts, below which the impact can be considered negligible. The cost of tracking impacts below this limit is wasteful and should be avoided. This paper will describe a method for determining this lower limit, along with the associated benefits and risks.},

keywords = {General},

pubstate = {published},

tppubtype = {inproceedings}

}