Open Source Visual Basic for Applications (VBA) Mechanical and Civil Engineering Software

S-S Curve.zip includes: 1. A macro enabled Excel workbook (S-S Curve Helper.xlsm) for creating a Stress-Strain curve using the Ramberg-Osgood formula and commonly available material properties. Combinations of tensile or compressive and engineering or true forms can be selected. 2. A procedure for Stress-Strain curve scaling. 3. A formula for plastic Poison’s Ratio between the proportional limit and fully plastic condition.

Una Aplicacion de base de datos de MS Access que permite cargar los ambientes de una vivienda, y calcula las pérdidas de KCal de cada ambiente. Se puede personalizar y agregar nuevos materiales.

Cable Spool.xlsm was developed to estimate loading on a storage drum due to winding of a steel cable. It was later updated to estimate internal loading in GRP ruggedized single fiber fiber-optic cable spools. Adhesive was applied as the cable was wound on a flanged mandrel. After the adhesive cured, the mandrel was removed leaving a spool composed of cable rings bound together by the adhesive. Both cables were very stiff radially. Hence, only axial and bending of the cable and mandrel stiffnesses were considered. Cable radial stiffness, which may be significant in some applications, was neglected. Derivation of the methodology is included.

Coexlam is a VBA Excel application that performs composite laminate analysis. Laminate theory is used with several strength criteria: maximal stress, maximal strain, Tsaï-Hill and Tasï-Wu. A help including a Getting Started part is now available in the application. The users can add their own formulas or application, an example is provided with a tank under pressure. Several load cases can be calculated in one time in the Print sheet. Laminates can be saved in the Library sheet. Several versions of Coexlam are available on Sourceforge: Coexlam v1.1 and Coexlam v1.2. The version 1.2 directly includes all the version 1.1 + additional features. Coexlam is a freeware under General Public License.Coexlam is developed by Coexpair, an aeronautic company specialised in composite development with RTM process for aeronautic major companies. Coexpair is a Radius Engineering partner. website: www.coexpair.com

LWCPV.3.zip includes: 1. A macro enabled Excel workbook (LWCPV.xlsm) for preliminary design and analysis of long cylindrical, layered-wall pressure vessels (PVs) subjected to external hydrostatic pressure. The following four types of layered-wall construction are addressed: a. Two-layer isotropic. b. Three-layer isotropic sandwich-wall; and c. Three-layer sandwich-wall with orthotropic outer layers and isotropic core. d. Three-layer sandwich-wall with isotropic outer layers and orthotropic core. Stress-strain solutions for all constructions are based on thick-wall three-dimensional elastic theory. Elastic Monocoque Instability pressure is calculated. Instructions on using each worksheet are given therein. 2. Technical notes outlining the underlying theory and discussing the above four types of PVs.

The collection Planar Elastica (Planar Elastica.zip) includes: 1. A technical note deriving the governing equations for a planar elastic subjected to general end loading (i.e., combined bending moment, angled direct load and torsional moment). This note is heart of this project. 2. Macro enabled Excel spreadsheet examples that illustrate use of the above result. These examples range in sophistication from large displacement leaf springs to one requiring simultaneous solution of two elastica problems. They are described in the above note. 3. Three supplemental technical notes entitled: a.) Bend Test Models; b.) Sensitivity to Nonlinearities and Nonhomogeneities; and c.) Twist Magnification.

Bending Modulus.xlsm is a macro enabled Excel workbook for estimating plastic bending modulus. Inputs are tensile yield and ultimate strengths and section factor.

The file “Ship, Tow-Tether and Moonpool Models.zip” is a collection of linked macro-enabled Excel workbooks suitable for conceptual to preliminary design of the title systems. The file “Block Diagram.pdf” shows linkages and summarizes each workbooks’ major features. FD and TD at the end of a file name denotes frequency domain and time domain solutions, respectively. Except for the moonpool TD model, which is a solution to the nonlinear equations of motion for the moonpool piston mode, TD solutions are obtained by superposing FD solutions in uniform random phase. Toolbars on the plot tabs can be activated to expose plot options. Model input parameters are defined in comments to the input cells of each workbook. (Use the TAB key to move between input cell.) Dropdown menus on the first worksheet of each linked workbooks facilitate moving between open workbooks. Supporting documentation is included.

SCPV is a family of three macro enabled Excel workbooks for analysis of long cylindrical pressure vessels with flat endcaps subjected to external hydrostatic pressure. CPVanalysis.xlsm does stress and stability analyses. It plots stresses, deflections and the equilibrium path for imperfect circular cylinders showing the onset of yielding and limit points in relation to elastic and inelastic bifurcation buckling pressures. Two types of initial geometric imperfections, outer diameter out-of-roundness and outer-to-inner diameter eccentricity with a phase angle between them, can be considered. CPVparametric.xlsm, does parametric analyses. It plots performance parameters against depth or pressure for up to five different combinations of materials and shell geometries including initial imperfections. CPVcreep.xlsm does analysis of creep instability in vessels with initial mode-2 out-of-roundness imperfections. Supporting documentation is included.