Use our XLC calculation template to make sure that you never make
mistakes with units. One of the most common remarks in the site repository is “I wish this was in metric
units” or alternatively “I wish this was in imperial units”. Use our template and simply click from from one system of units to another. The
golden rule: ALWAYS use
You would think managing units was a trivial
exercise but over the years many mistakes have been made through the
incorrect use of units. Here are a couple of prominent examples:
In 1983 a Boeing 767 jet ran out of fuel in mid-flight because of two
mistakes in figuring the fuel supply of Air Canada's first aircraft
use metric measurements. Fortunately the crew was able to glide the
aircraft safely to an emergency landing at Gimli Industrial Park
In 1999 NASA lost a $125 million Mars orbiter because one engineering
team used metric units while another used US customary units for a
calculation. The Mars Climate Orbiter was intended to enter orbit at
altitude of 140.5–150 km above Mars. However, the unit error caused
spacecraft to only reach 57 km. The spacecraft was destroyed by
atmospheric stresses and friction at this low altitude.
This sheet tabulates loads on connections or other structural components
and factors the loads based on strength design and allowable stress
design combinations. User can customize load combinations as needed.Thank you jpdgate.
Static structural analysis of 2D linear elastic frames and trusses.
Computes the static deflections, reactions, internal element forces
using direct stiffness methods. Work has started on a 3D version EXCsta_3D.xlsx perhaps you would like to get involved in its development?Thank you Turan Babacan.
This is an excel spreadsheet that calculates the allowable moment
capacity of a beam with variable unbraced lengths base on section F of
the AISC360-05 specification chapter F, section F.2. I am new at this so
if anyone can improve upon it, please do so, or let me know what and
how i can improve on it. Thank you Margarito Castillo.
Analysis of a 2D frame subject to distributed loads, point loads and
moments. For distributed loads specify length from the ends of the start and end
of the load, and the load intensity at the start and end.
For Point loads and moments specify the position and magnitude
Positions and load lengths are measured along the beam axis, as a ratio
of the beam length. Distributed and point load direction is either "X" (horizontal) or "Y"
(vertical). Thank you Doug Jenkins.
Laminated plate theory (LPT) or classical lamination theory (CLT)
basic design tool for evaluating different laminates when experimental
data are not available. LPT can be used to combine properties and the
orientation of each ply in a predetermined stacking sequence to predict
the overall performance characteristics for a laminate. LPT is based on
the assumptions that the laminate deforms under conditions of plane
stress and that the strains experienced by the individual layers of the
laminate are compatible with the strains in the neighbouring layers. The
mechanical properties (i.e. the moduli and poisons ratios)of the
unidirectional composite are required before LPT can be applied and
these are best obtained from mechanical tests. In-plane loading and
loading from bending can be considered. LPT can also be used to assess
the stresses that arise through temperature and moisture changes. This
theory provides the in-plane stresses and strains for each lamina of the
laminate and can be combined with failure criteria for individual
plies. Thank you rahulmenon.