
0. 
Y_
Factor.pdf 
226KB 
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).
Purchase working Excel calculation here
(see bottom of page) 

1. 
drvbelt.zip 
15KB 
A Microsoft Excel Worksheet which
calculates the length of a Drive Belt 

2. 
interfun.zip 
20KB 
A Microsoft Excel Worksheet which
includes an XY Interpolation User Defined Function for obtaining intermediate values from
a data table. 

3. 
interpo3.zip 
10KB 
A Microsoft Excel Worksheet which carries
out an XY Interpolation for obtaining intermediate values from a data table. 

4. 
interpol.zip 
8KB 
A Microsoft Excel Worksheet which
interpolates to obtain intermediate values from a data list. 

5. 
motorpwr.zip 
5KB 
A Microsoft Excel Worksheet which
calculates the load on a 3 phase electric motor. 

6. 
pipekcal.zip 
16KB 
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. 

7. 
centpump.zip 
30KB 
A Microsoft Excel Worksheet for
Centrifugal Pump calculations. 

8. 
cogcalc.zip 
7KB 
A Microsoft Excel Worksheet to determine
the Centre of Gravity of small or large structures from single components to offshore
platforms. 

9. 
gasconv.zip 
17KB 
A Microsoft Excel Worksheet to convert
gases between different pressure and temperature states in both Metric and British (US)
units. 

10. 
gpsagasprop.zip 
432KB 
A Microsoft Excel Worksheet to calculate
Properties of Hydrocarbon based Gas Mixtures using the GPSA Engineering Data Book (11th
Edition) 

11. 
pipepvtdata.zip 
37KB 
A Microsoft Excel Worksheet of the
pressure temperature limits of various typical Piping Components and Valves. 

12. 
transhft.zip 
31KB 
A Microsoft Excel Worksheet to calculate
the Capacity of Transmission Drive Shafts. 

13. 
eoscalcs.zip 
51KB 
A Microsoft Excel Worksheet that
calculates Gas Properties using Equation of State from Van der Waals, RedlichKwong,
SoaveRedlichKwong and PengRobinson. 

14. 
orifice.zip 
186KB 
Orifice plate calculation for liquids or gases using Crane Flow of Fluids method. Includes Nozzle, Venturi and Square Edge orifice plates, 

15. 
stat.zip 
8KB 
Simple statistical analysis of small sample data sets. Considers the probability that the data fits a Normal distribution profile. 

16. 
fancalc.zip 
7KB 
Basic Centrifugal Fan calculations. 

17. 
springcalc.zip 
10KB 
Calculations for Coil Springs wound from round steel wire. 

18. 
pipe_flow.zip 
10KB 
Calculates Liquid or Gas flow through a pipe system comprising pipe, fittings and valves of up to four different sizes. 
