Friday - 04th of July 2008
Check the Latest News!

XL Toolboxes

A SpreadsheetWorld, Inc. Website

XLGeometry PDF Print E-mail

Software for Geometric Shape Design

XLGeometry is a user friendly parameter driven Excel Toolbox which calculates geometric properties of hundreds of geometric shapes. It includes a worksheet which automatically compiles a list of geometries for a project. Some properties such as mass are automatically summarized.
Features: XLGeometry is:
  • Large Shape Library
  • Materials Selections
  • Closed Ends
  • Oblique Ends
  • Hollow Objects
  • Complied Parts List
  • Embedded Worksheet Functions
  • Affordable
  • Scalable
  • Effective
  • Innovative
  • User Friendly
  • Fast


The shapes are visually organized into groups for easy selection. The toolbox includes material properties for common engineering materials so that mass properties can be calculated.

Within each shape type, the Geometric Design Wizard presents a pallet of subtypes along with a form for inputting parameter values.

Once the properties for the selected shape are entered, the results are presented on the form and can then be embedded as a design parameter driven VBA function back on the Excel design summary worksheet. For the example below, the GDTCylEllipse() function was used which has 6 design parameters which can then be changed on the worksheet. At this point, Goal Seeker could be used to determine a size parameter needed to get a desired component weight.

Functions are embedded directly into worksheet ranges so that input parameters can be changed to achieve desired output. Functions can therefore be used inside worksheet iteration processes such as goal seeking, optimization using Solver, or Monte Carlo uncertainty analysis.

(137KB)

Buy at SpreadsheetWorld.com
 
< Prev   Next >