File: Tromp curve_eng v3
Date: 5/14/2008
Version Date Who Comments
1.0 12/1/2004 Mario Interlenghi CTEO milling group version.
Karim El Hajoui
Cédric Richard
2.0 4/25/2007 Olivier Bernard TCEA version for Excel 2000
1
2
3
#
3.0 5/14/2008 Olivier Bernard TCEA version for Excel 2003 - Template for harmonized version
1
Comments
CTEO milling group version.
TCEA version for Excel 2000
Logo changed to TCEA
Plot (fx-ax) vs (fx-rx): regression line connected to cells S40:S41 and T40:T41
Plot (fx-ax) vs (fx-rx): names "Droite_RA_1" and "Droite_RA_2" removed
2 and 3 done to give the possibility to copy the tab several times in the spreadsheet without creating problems with
the names
There remains the necessity to adjust manually the data cells for this plot within the range P9:Q37, when the
number of sieves varies
Calculations for plotting the cumulative fines yield (range R49:R77): the formula used was incorrect, changed to
"1-R/A*r/a"
TCEA version for Excel 2003 - Template for harmonized version
Fully revised version, with Tromp curve plot in Log - Linear scales (former version was
Log - Gaussian)
File: Tromp curve_eng v3
Date: 8/24/2015
Content: Instructions for correct use of this spreadsheet
Colour code
Blue on light green Text, titles (appearing in printed pages)
Blue on yellow (bold or light)) Cells to fill in
Red on light green Intermediate results
Red on light green (bold) Important results
Spreadsheet protection
To avoid unvoluntary mistakes, spreadsheets are protected so that it is only possible to
fill in yellow cells in normal use.
To unprotect, use the password "lafarge" - at your own risk!
For any question, please refer to CTC grinding department:
Instructions for Tromp curve spreadsheet
General organisation of the spreasheet:
User zone (will Calculation zone
be printed) 4b
1
R/A calculation
block
2
3 Tromp curve Imperfection
calculation block calculation block
Printed on 07/13/2019 Page 3 / 14
Verification zone
4a
Steps for spreadsheet use
1 Fill in the general information cells
2 Fill in the PSD data
Up to 29 sieve size can be used
Particle size distributions MUST be entered in ascending order
3 Adjust the Imperfection Line to fit the Tromp curve
Enter the first and last points to use in the yellow cells.
First point should be between 1 and last point.
Last point should be between first point and available number of points (Nb_data above)
For advanced users:
4 Check that the "R/A points" are correctly aligned, and that the "R/A line" passes
near the origin. You can force that by entering "Y" in the cell at the top of the calculation zone
Printed on 07/13/2019 Page 4 / 14
R/A calculation
block
rfection
ulation block
Printed on 07/13/2019 Page 5 / 14
Lafarge process Tool Kit Tromp Curve version 3.0
Plant: Rashadya Date / Time : 8/24/2015
Mill: CM A Product: CEM I 42.5 N
Separator: 2nd genaration or node:
Sizer details: PSD
Comments:
Mesh % cumulative passing dx P(x) %
(µm) Fines Feed Rejects
1 0.99 4.43 1.27 0.51 1.4 µm 30.2%
2 2.00 8.75 4.25 1.66 2.8 µm 17.7%
3 3.85 16.73 7.95 2.72 4.4 µm 15.4%
4 5.05 21.47 10.03 3.25 5.4 µm 24.9%
5 5.78 26.60 11.23 4.30 7.1 µm 6.0%
6 8.68 36.32 15.39 4.68 9.3 µm 14.3%
7 10.00 40.11 17.02 5.07 11.4 µm 10.8%
8 13.00 48.01 20.32 5.66 14.9 µm 11.2%
9 17.10 53.55 24.05 6.09 21.0 µm 15.9%
10 25.68 69.12 31.32 7.91 28.7 µm 37.0%
11 32.00 77.85 36.36 11.07 35.1 µm 53.3%
12 38.56 84.76 41.89 15.92 41.3 µm 64.5%
13 44.16 89.20 46.55 20.88 50.6 µm 76.3%
14 57.90 95.97 57.81 34.27 62.1 µm 85.6%
15 66.50 98.14 62.96 42.24 71.1 µm 90.4%
16 75.95 99.58 68.68 50.60 81.2 µm 97.0%
17 86.90 100.00 74.18 58.95 93.0 µm 100.0%
18 99.60 100.00 79.32 66.93 113.8 µm 100.0%
19 130.00 100.00 87.98 80.66 149.1 µm 100.0%
20 171.00 100.00 94.12 90.40 183.1 µm 100.0%
21 196.00 100.00 96.22 93.69 100.0%
22
23
24
25
26
27
28
29 Average (R/A )=
% Cum ulativ e P as s ing
100.00
90.00 Fines
80.00 Feed
Reject
70.00 s
60.00
50.00
40.00
30.00
20.00
10.00
0.00
1.00 10.00 100.00 1000.0
Mesh (µm)
40.00
30.00
20.00
10.00 Lafarge process Tool Kit Tromp Curve version 3.0
0.00
1.00 10.00 100.00 1000.0
Mesh (µm)
Plant: Rashadya Date / Time : 8/24/2015
Mill: CM A Product: CEM I 42.5 N
Separator: 2nd genaration or node: 0
100.0%
90.0%
80.0%
70.0%
60.0%
50.0%
40.0%
30.0%
20.0%
10.0%
0.0%
1 10 10
Mesh (µm)
Available number of points for Imperfection line: 20 (Nb_data)
Imperfection Line adjustment: from point # 1 9 to point # 2
Main tromp Curve parameters:
R/A 0.619 Circulating load 162% d25
Fines 84.4% By-Pass 0.0% d50
Lafarge process Tool Kit Tromp Curve version 3.0
cumulative yield Acuity limit #N/A d75
Imperfection 0.45
Reduced imperfection #N/A
Lafarge process Tool Kit Tromp Curve version 3.0
R/A
fraction
0.423
0.618
0.632
0.963
0.595
0.635
0.629
0.354
0.604
0.662
0.670
0.423
0.678
0.514
0.618
0.641
0.644
0.631
0.630
0.638
0.619
00 100.00 1000.00
Mesh (µm)
Lafarge process Tool Kit Tromp Curve version 3.0
00 100.00 1000.00
Mesh (µm)
10 100
Mesh (µm)
17
22.4 µm
34.8 µm
Lafarge process Tool Kit Tromp Curve version 3.0
53.9 µm
Cement Mill
Item typical performance
Bypass (%) 10 - 35
Acuity limit (micron) 15 - 20
Imperfection 0.3 - 0.4
Circulating load (%) 100 - 300
Cement Mill A
Actual
48.253%
7.10
0.33
423%
Comment
As for the bypass, this is usually more related to the separator feed
load qf/qa,small quantity of the circulation fan gases flow,its good to
check its dampers position
the more feed load we put to the separator, the more we will have
bypass.
indicate a good selectivity in the separator
within range
over target ,which is mean the more the material goes
back to the mill
