logo.gif (3295 bytes)Dennis Kirk Engineering
Principal: Dennis Kirk-Burnnand B.E. (Mech) Auckland 1975

Last Updated December 2005

You may now download the files you chose.  If the files are upgraded I may contact users who have provided sufficient contact details. To be able to use the files you require an unzipping program like Winzip.

Harriet003.jpg (41139 bytes) Harriet004.jpg (37994 bytes) Harriet006.jpg (35890 bytes)

 
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 X-Y Interpolation User Defined Function for obtaining intermediate values from a data table. 
 
3. interpo3.zip 10KB A Microsoft Excel Worksheet which carries out an X-Y 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, Redlich-Kwong, Soave-Redlich-Kwong and Peng-Robinson.
 
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.