NOTE: This spreadsheet is for the use of knowledgeable professionals, capable of evaluating the accuracy of the results.  The author is not responsible for the use to which these results are put.

1 The ‘Cyclone size’ sheet calculates dimensions for various standard cyclones.
  Enter the flow rate, design inlet velocity and gas density in the colored squares and the sheet will give dimensions for five standard cyclones – two high efficiency, and three low efficiency.  The table also gives the predicted pressure drop, but be aware that this is a very uncertain calculation (see original references).  See ‘Diagram’ sheet for nomenclature.
On the ‘Cyclone size’ sheet you specify the units you want to use – metric or US Customary (Imperial)

2 Two methods are provided for calculating cyclone efficiency.  You can calculate both, and compare the results on the chart.  Both sheets are set up with the same layout, so data can be copied between sheets easily.
3 The efficiency calculation requires particle size data, cyclone dimensions, and physical property data for the gas and the solids.  The calculation assumes that the size distribution of the particles is log normally distributed.  The sheet is set up so that you can enter either the mean and standard deviation of the log normal distribution, or the particle size data, from which these data are then calculated.

4 Procedure for efficiency calculations:
 a) Enter the cyclone dimensions in cells D4 to D11.  If you have calculated these using this spreadsheet, the values in cells 13 to 20 for the selected cyclone design can be directly copied into D4 to D11.  NOTE: Paste special the values – do not just copy the cells.

 b) Enter the gas property data in cells D18 to D21.
 c) Enter the particulate data in cells D26 to D29.  If you enter the mean and standard deviation, and select ‘N’ for cell D28, then the overall efficiency is immediately given in cell H15, and the inlet and outlet         size distributions are given in cells O21 to O41 and R21 to R41.
d) If you want to use the size distribution method, enter ‘Y’ in cell D28, and then the range limits starting in cell N50 and the corresponding % in range starting in O50.  If you want to use more than nine ranges, you can extend these columns to as many rows as you want – just remember to copy the formulae in columns M and P through T into any rows that you add. After entering the size distribution data, You have to run the regression tool.  Choose the ‘Tools’ menu then ‘Data Analysis’ then ‘Regression’.  For the ‘X’ value pick all the values in column Q, starting in Q50; for the ‘Y’ values, pick all the values in column T, starting in T50.  For the ‘Output range’ enter V48.  You will get a message saying results will overwrite cells – pick OK.
Once the regression is done, the results are available, as described in c) above.

5 The chart sheet graphs the penetration (col P = 1 – fractional efficiency) against particle size for the two efficiency calculation methods.  CAUTION:  The two efficiency sheets are not linked, so make sure they are both calculating from the same data if you want to compare the two efficiency calculations!

6 The spreadsheet is protected in order to prevent accidental overwriting of the formulae.
However, there is no password needed to unprotect it, so you can freely adapt it to suit your purposes.

Direct download from password 1236

 click here to diwnload

Leave a Reply