Every Available Excel sheet for Cement Mill Trump curve + instructions how to use it

Previous Post
Next Post

Every Available Excel sheet for Cement Mill Trump curve + instructions how to use it

 

To Download the Below Excel sheet + most Important Cement Books and Guides from Famous companies click here now 

 

 

Date:8/24/2020
Content:Instructions for correct use of this spreadsheet
Colour code
Blue on light greenText, titles (appearing in printed pages)
Blue on yellow (bold or light))Cells to fill in
Red on light greenIntermediate 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:

Plant:RashadyaDate / Time :8/24/2015
Mill:CM AProduct:CEM I 42.5 N
Separator:2nd genarationor node:Force passage RA through {0;0}? (Y/N)n(default should be N)
Sizer details:PSD
Comments:MeshSize R/A Calculation
CalculationClass
(lower < upper)Particle Size Distributions
dxfxaxrxfx-axfx-rxfx-ax/fx-rx(fx-ax).(fx-rx)(fx-rx)²
Mesh% cumulative passingdxP(x) %R/A
(µm)FinesFeedRejectsfractionfines < 0.994.431.270.51
10.994.431.270.511.4 µm30.2%0.4231.410.99 < 24.322.981.151.343.170.424.2510.05
22.008.754.251.662.8 µm17.7%0.6182.772 < 3.857.983.701.064.286.920.6229.6247.89
33.8516.737.952.724.4 µm15.4%0.6324.413.85 < 5.054.742.080.532.664.210.6311.2017.72
45.0521.4710.033.255.4 µm24.9%0.9635.405.05 < 5.785.131.201.053.934.080.9616.0316.65
55.7826.6011.234.307.1 µm6.0%0.5957.085.78 < 8.689.724.160.385.569.340.6051.9387.24
68.6836.3215.394.689.3 µm14.3%0.6359.328.68 < 103.791.630.392.163.400.647.3411.56
710.0040.1117.025.0711.4 µm10.8%0.62911.4010 < 137.903.300.594.607.310.6333.6353.44
813.0048.0120.325.6614.9 µm11.2%0.35414.9113 < 17.15.543.730.431.815.110.359.2526.11
917.1053.5524.056.0921.0 µm16.0%0.60420.9617.1 < 25.6815.577.271.828.3013.750.60114.13189.06
1025.6869.1231.327.9128.7 µm37.0%0.66228.6725.68 < 328.735.043.163.695.570.6620.5531.02
1132.0077.8536.3611.0735.1 µm53.3%0.67035.1332 < 38.566.915.534.851.382.060.672.844.24
1238.5684.7641.8915.9241.3 µm64.5%0.42341.2738.56 < 44.164.444.664.96-0.22-0.520.420.110.27
1344.1689.2046.5520.8850.6 µm76.3%0.67850.5744.16 < 57.96.7711.2613.39-4.49-6.620.6829.7243.82
1457.9095.9757.8134.2762.1 µm85.6%0.51462.0557.9 < 66.52.175.157.97-2.98-5.800.5117.2833.64
1566.5098.1462.9642.2471.1 µm90.4%0.61871.0766.5 < 75.951.445.728.36-4.28-6.920.6229.6247.89
1675.9599.5868.6850.6081.2 µm97.0%0.64181.2475.95 < 86.90.425.508.35-5.08-7.930.6440.2862.88
1786.90100.0074.1858.9593.0 µm100.0%0.64493.0386.9 < 99.60.005.147.98-5.14-7.980.6441.0263.68
1899.60100.0079.3266.93113.8 µm100.0%0.631113.7999.6 < 1300.008.6613.73-8.66-13.730.63118.90188.51
19130.00100.0087.9880.66149.1 µm100.0%0.630149.10130 < 1710.006.149.74-6.14-9.740.6359.8094.87
20171.00100.0094.1290.40183.1 µm100.0%0.638183.07171 < 1960.002.103.29-2.10-3.290.646.9110.82
21196.00100.0096.2293.69100.0%196 < coarse0.003.786.31#N/A#N/A#N/A
22#N/A#N/A#N/A#N/A#N/A#N/A
23#N/A#N/A#N/A#N/A#N/A#N/A
24#N/A#N/A#N/A#N/A#N/A#N/A
25#N/A#N/A#N/A#N/A#N/A#N/A
26#N/A#N/A#N/A#N/A#N/A#N/A
27#N/A#N/A#N/A#N/A#N/A#N/A
28#N/A#N/A#N/A#N/A#N/A#N/A
29Average (R/A )=0.619Number of data = 20#N/A#N/A#N/A#N/A#N/A#N/A
K15:K34M15:M34N15:N34O15:O34P15:P34Q15:Q34average R/AAdjustmentavrg. of R/AR/A theoretical
0.619-0.0430.6000.619
R/A Line-14-8.708
plot:148.622
Plotting Tromp Curve and Fines yieldCalculating imperfection
Tromp CurveFines YieldBy regression lineBy reduced Tromp curve
dxPxvalidxYieldlog10(dx)PxPoint #dxP’x
Rank
11.430.2%30.2%0.9975.1%#N/A#N/A11.425.8%
22.817.7%17.7%275.8%#N/A#N/A22.812.5%d 25 calculation
34.415.4%15.4%3.8578.8%#N/A#N/A34.410.0%0.25
45.424.9%24.9%5.0579.9%#N/A#N/A45.420.2%Between points
57.16.0%6.0%5.7876.3%#N/A#N/A57.10.0%910
69.314.3%14.3%8.6881.2%#N/A#N/A69.38.9%20.95510.6%
Plant:RashadyaDate / Time :8/24/2015711.410.8%10.8%1081.6%#N/A#N/A711.45.2%28.66633.0%
Mill:CM AProduct:CEM I 42.5 N814.911.2%11.2%1382.8%#N/A#N/A814.95.6%25.925.0%
Separator:2nd genarationor node:0921.016.0%16.0%17.184.3%1.3216.0%921.010.6%
1028.737.0%37.0%25.6884.4%1.4637.0%1028.733.0%
1135.153.3%53.3%3281.2%1.5553.3%1135.150.3%d 50 calculation
1241.364.5%64.5%38.5676.5%1.6264.5%1241.362.2%0.5
1350.676.3%76.3%44.1672.2%1.7076.3%1350.674.8%Between points
1462.185.6%85.6%57.963.3%1.7985.6%1462.184.7%1011
1571.190.4%90.4%66.558.5%1.8590.4%1571.189.8%28.66633.0%
1681.297.0%97.0%75.9554.4%1.9197.0%1681.296.8%35.12750.3%
1793.0100.0%100.0%86.950.8%1.97100.0%1793.0100.0%35.050.0%
18113.8100.0%100.0%99.647.8%#N/A#N/A18113.8100.0%
19149.1100.0%100.0%13043.3%#N/A#N/A19149.1100.0%
20183.1100.0%100.0%17140.6%#N/A#N/A20183.1100.0%d 75 calculation
21#N/A100.0%FALSE19639.7%#N/A#N/A21#N/A#N/A0.75
22#N/A#N/AFALSE#N/A#N/A#N/A22#N/A#N/ABetween points
23#N/A#N/AFALSE#N/A#N/A#N/A23#N/A#N/A1314
24#N/A#N/AFALSE#N/A#N/A#N/A24#N/A#N/A50.56574.8%
25#N/A#N/AFALSE#N/A#N/A#N/A25#N/A#N/A62.05184.7%
26#N/A#N/AFALSE#N/A#N/A#N/A26#N/A#N/A50.975.0%
27#N/A#N/AFALSE#N/A#N/A#N/A27#N/A#N/A
28#N/A#N/AFALSE#N/A#N/A#N/A28#N/A#N/A
29#N/A#N/A#N/A29
Minimum:6.0%Maximum:84.4%Q65:Q73R65:R73
at rank #5at rank #10Imperfection Line
Corresponding dx7.08Corresponding x25.68mb
1.310170847-1.518950483
Lines for by-pass point:x- axisy-axisLog(x)xy
Horizontal line16.0%1.15935298614.430
6.0%7.086.0%1.92261222283.681
Vertical line7.086.0%1.35016779522.40.25d 2525.9
7.1 µm7.0801.54098260434.80.5d 5035.0
1.73179741353.90.75d 7550.9
Imperfection0.450.36

Cement Mill A
Itemtypical performanceActualComment
Bypass (%)10 – 3548.253%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.
Acuity limit (micron)15 – 207.10 indicate a good selectivity in the separator
Imperfection0.3 – 0.40.33within range
Circulating load (%)100 – 300423%over target ,which is mean the more the material goes back to the mill

 

 

Download Links

 

download the 4 excel sheets from the below links

 

https://www.mediafire.com/file/rhvwid4506zfzac/CEMENT_MILL_TROMP_CALCULATIONS_cementequipment.org.xlsx/file

 

https://www.mediafire.com/file/ev7quad6tgs6a9g/TROMP_CURVE_CALCULATIONS_AND_RESULTS_cementequipment.org.xlsx/file

https://www.mediafire.com/file/y22n8dqjo04cdc6/TROMP_CURVE_CALCULATIONS_AND_RESULTS2_Cementequipment.org.xls/file

https://www.mediafire.com/file/fepmfv169td4lcl/Lafarge_TROMP_CURVE_CALCULATIONS_AND_RESULTS_cementequipment.org.xls/file

 

Previous Post
Next Post

Leave a Reply