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

Design Calculations

MainPage
About DKE
Design Calculations
Work Samples
Links

Last Updated December 2005

We would appreciate it if you would fill in the form below before you download any of the files. The calculations are in MS Excel 95/97/2000 format.

Your Name:
Your Email:
Your Web Address (If available):
Your Country:
Your Occupation:
Reason for Download:
Your Comments:

Please select the files you plan to download.

Harriet007.jpg (41922 bytes) Harriet008.jpg (48126 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). And a working Excel spreadsheet is also available. 
Added December 2005
 

1.

drvbelt.zip 15KB 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
 

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. Updated April 2001
 

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. Ver 1.100
 

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. Ver 2.200
 

7.

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

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. Ver 1.103
 

9.

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

10.

gpsagasprop.zip 432KB 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
 

11.

pipepvtdata.zip 37KB A Microsoft Excel Worksheet of the pressure temperature limits of various Piping Flanges and Valves. Updated April 2001
 
12. transhft.zip 31KB A Microsoft Excel Worksheet to calculate the Capacity of Transmission Drive Shafts. Updated April 2001 Ver 2.100
 
13. eoscalcs.zip 51KB A Microsoft Excel Worksheet that calculates Gas Properties using Equations of State from Van der Waals, Redlich-Kwong, Soave-Redlich-Kwong and Peng-Robinson. 
Works in both US and SI Units. Updated April 2001 Ver 1.100
 
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,
New April 2001 Ver 1.201
 
15. stat.zip 8KB Simple statistical analysis of small sample data sets. Considers the probability that the data fits a Normal distribution profile.
New April 2001 Ver 1.000
 
16. fancalc.zip 7KB  Basic Centrifugal Fan calculations
New April 2001 Ver 1.000
 
17. springcalc.zip 10KB Calculations for Coil Springs wound from round steel wire.
  New April 2001 Ver 1.000
 
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.
  New April 2001 Ver 1.010
 

Click Submit to go to the download page. Remember the files you selected as you will need to select them again on the next page.

Harriet005.jpg (53177 bytes) Harriet009.jpg (45106 bytes)

 

There should be updates and more calculations soon.

 

[ MainPage ] [ About DKE ] [ Design Calculations ] [ Work Samples ] [ Links ]