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.
Conrad Harrison 2007-04-04 21:17:26 Interesting if your a student doing textbook problems, and learning the process. Plots of shear force, and bending moment diagrams would be useful. Otherwise one spreadsheet with different end conditions and multiple loads is of more practical value.
Stephen Argles 2007-04-24 03:02:05 I agree with Infojunkie65. The Heaviside function is named after Oliver Heaviside. It has nothing to do with weight.