 With so many software utilities out there you could just slob out and let the black box solvers take over. However if you want to keep those engineering muscles in tone youre better off thinking through a problem using your trusted engineering theory books and encoding a spreadsheet. When working with spreadsheets you are forced to understand the mechanics of the problem thereby putting yourself in the best position to devise innovative solutions. The process reinforces your knowledge and empowers you to break new technical ground with confidence. So dont get sloppy and be seduced by black boxes - broaden your engineering vocabulary by doing more calculations. Once a problem is encoded in a spreadsheet there are many Excel features that give you an enormous return on your time invested.

Respository News

We could do with some more uploads. I am afraid that there is not too much to report this week.  CurvedBeams.xls

Calculate hyperbolic bending stress distribution in a curved beam.

Calculation Reference
Machine Design - Schaum's Dennis Kirk's Engineering Calculations The Dennis Kirk Engineering website - you can download Microsoft Excel spreadsheets covering a number of useful mechanical, fluid flow and gas compression calculations.
Y Factor.pdf - A design memorandum which proposes a better way to extend the calculation of compressible flow through thin, square edge orifice plates to high differential pressures (eg vent or blowdown from high pressure to atmosphere). And a working Excel spreadsheet is also available.
drvbelt.zip - A Microsoft Excel Worksheet which calculates the length of a Drive Belt. Works in both US and SI Units. Updated April 2001 Ver 2.100
interfun.zip - A Microsoft Excel Worksheet which includes an X-Y Interpolation User Defined Function for obtaining intermediate values from a data table. Updated April 2001
interpo3.zip - A Microsoft Excel Worksheet which carries out an X-Y Interpolation for obtaining intermediate values from a data table.
interpol.zip - A Microsoft Excel Worksheet which interpolates to obtain intermediate values from a data list. Ver 1.100
motorpwr.zip - A Microsoft Excel Worksheet which calculates the load on a 3 phase electric motor.
pipekcal.zip - A Microsoft Excel Worksheet which calculates the K Factor and Equivalent Length of a large range of pipe and fittings for use in flow calculations. Ver 2.200
centpump.zip - A Microsoft Excel Worksheet for Centrifugal Pump calculations. Ver 1.001
cogcalc.zip - A Microsoft Excel Worksheet to determine the Centre of Gravity of small or large structures from single components to offshore platforms. Ver 1.103
gasconv.zip - A Microsoft Excel Worksheet to convert gases between different pressure and temperature states in both Metric and British (US) units. Ver 1.103
gpsagasprop.zip - A Microsoft Excel Worksheet to calculate Properties of Hydrocarbon based Gas Mixtures using the GPSA Engineering Data Book (11th Ed'n). Works in both US and SI Units. Updated April 2001 Ver 1.420
pipepvtdata.zip - A Microsoft Excel Worksheet of the pressure temperature limits of various Piping Flanges and Valves. Updated April 2001
transhft.zip - A Microsoft Excel Worksheet to calculate the Capacity of Transmission Drive Shafts. Updated April 2001 Ver 2.100
eoscalcs.zip - A Microsoft Excel Worksheet that calculates Gas Properties using Equations of State from Van der Waals, Redlich-Kwong, Soave-Redlich-Kwong and Peng-Robinson.
orifice.zip - Orifice plate calculation for liquids or gases using Crane Flow of Fluids method. Includes Nozzle, Venturi and Square Edge orifice plates,
stat.zip - Simple statistical analysis of small sample data sets. Considers the probability that the data fits a Normal distribution profile.
fancalc.zip - Basic Centrifugal Fan calculations
springcalc.zip - Calculations for Coil Springs wound from round steel wire.
pipe_flow.zip - Calculates Liquid or Gas flow through a pipe system comprising pipe, fittings and valves of up to four different sizes.