Spreadsheet: 48770d1248077946-using-match-function-with-multiple-headers-drive-calc-rev0-masterxl2003
Sheet: Sheet2

JOB No. |  |  | BLUE | INPUT  ~ DESIGN DATA
DATE |  |  | RED | INPUT ~ FROM TABLES
 |  |  | BLACK | CALCULATED OUTPUT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ANGLE | K
Check table 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1
 |  |  | TABLE 8. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 | 1
 |  |  | CAPACITIES OF THROUGHED BELT CONVEYORS- |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  | FROM |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5 | 1
1200 IDLER AT 35 DEGREES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.5 | 0.99
 |  |  | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 |  |  |  |  |  |  |  | 3 | 0.99
 |  |  | Belt width | Rec.max lump ([NAME]) |  |  | Through |  | Area of |  |  |  |  |  |  |  |  | 3.5 | 0.99
 |  |  | ([NAME]) | Sized | Unsized |  | angle.degs |  | load.  sq.m |  |  |  |  |  |  |  |  | 4 | 0.99
 |  |  | 500 | 100 | 160 |  | 30 |  | 0.0228 |  |  |  |  |  |  |  |  | 4.5 | 0.985
 |  |  | 500 |  |  |  | 35 |  | 0.0236 |  |  |  |  |  |  |  |  | 5 | 0.985
 |  |  | 500 |  |  |  | 45 |  | 0.0263 |  |  |  |  |  |  |  |  | 5.5 | 0.985
 |  |  | 600 | 125 | 200 |  | 30 |  | 0.0347 |  |  |  |  |  |  |  |  | 6 | 0.98
 |  |  | 600 |  |  |  | 35 |  | 0.0364 |  |  |  |  |  |  |  |  | 6.5 | 0.975
 |  |  | 600 |  |  |  | 45 |  | 0.0399 |  |  |  |  |  |  |  |  | 7 | 0.975
 |  |  | 650 | 125 | 200 |  | 30 |  | 0.0415 |  |  |  |  |  |  |  |  | 7.5 | 0.975
 |  |  | 650 |  |  |  | 35 |  | 0.0433 |  |  |  |  |  |  |  |  | 8 | 0.97
 |  |  | 650 |  |  |  | 45 |  | 0.0477 |  |  |  |  |  |  |  |  | 8.5 | 0.965
 |  |  | 750 | 150 | 250 |  | 30 |  | 0.0581 |  |  |  |  |  |  |  |  | 9 | 0.96
 |  |  | 750 |  |  |  | 35 |  | 0.0609 |  |  |  |  |  |  |  |  | 9.5 | 0.955
 |  |  | 750 |  |  |  | 45 |  | 0.0665 |  |  |  |  |  |  |  |  | 10 | 0.95
 |  |  | 800 | 160 | 250 |  | 30 |  | 0.0657 |  |  |  |  |  |  |  |  | 10.5 | 0.945
 |  |  | 800 |  |  |  | 35 |  | 0.0678 |  |  |  |  |  |  |  |  | 11 | 0.94
 |  |  | 800 |  |  |  | 45 |  | 0.0753 |  |  |  |  |  |  |  |  | 11.5 | 0.935
 |  |  | 900 | 175 | 300 |  | 30 |  | 0.0859 |  |  |  |  |  |  |  |  | 12 | 0.93
 |  |  | 900 |  |  |  | 35 |  | 0.0894 |  |  |  |  |  |  |  |  | 12.5 | 0.925
 |  |  | 900 |  |  |  | 45 |  | 0.0984 |  |  |  |  |  |  |  |  | 13 | 0.92
 |  |  | 1000 | 200 | 300 |  | 30 |  | 0.1065 |  |  |  |  |  |  |  |  | 13.5 | 0.915
 |  |  | 1000 |  |  |  | 35 |  | 0.111 |  |  |  |  |  |  |  |  | 14 | 0.91
 |  |  | 1000 |  |  |  | 45 |  | 0.1219 |  |  |  |  |  |  |  |  | 14.5 | 0.905
 |  |  | 1050 | 225 | 350 |  | 30 |  | 0.1192 |  |  |  |  |  |  |  |  | 15 | 0.9
 |  |  | 1050 |  |  |  | 35 |  | 0.1249 |  |  |  |  |  |  |  |  | 15.5 | 0.895
 |  |  | 1050 |  |  |  | 45 |  | 0.1365 |  |  |  |  |  |  |  |  | 16 | 0.89
 |  |  | 1200 | 250 | 400 |  | 30 |  | 0.1571 |  |  |  |  |  |  |  |  | 16.5 | 0.88
 |  |  | 1200 |  |  |  | 35 |  | 0.163 |  |  |  |  |  |  |  |  | 17 | 0.87
 |  |  | 1200 |  |  |  | 45 |  | 0.1796 |  |  |  |  |  |  |  |  | 17.5 | 0.86
 |  |  | 1400 | 275 | 450 |  | 30 |  | 0.213 |  |  |  |  |  |  |  |  | 18 | 0.85
 |  |  | 1400 |  |  |  | 35 |  | 0.22 |  |  |  |  |  |  |  |  | 19 | 0.83
 |  |  | 1400 |  |  |  | 45 |  | 0.245 |  |  |  |  |  |  |  |  | 20 | 0.81
 |  |  | TABLE 6. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 0.785
 |  |  | BELT WEIGHT & THICKNESS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 0.76
 |  |  | MULTIPLY BELTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 0.735
 |  |  | Fabric types |  | B60 | EP100 | EP125 | EP160 | EP200 | EP250 | EP315 | EP400 | EP500 | EP630 |  |  |  | 24 | 0.71
 |  |  | Approx.weight/ply |  | 1.4 | 1.13 | 1.21 | 1.4 | 1.7 | 1.9 | 2 | 2.5 | 2.8 | 3.5 |  |  |  | 25 | 0.685
 |  |  | ([NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | 0.66
 |  |  | Approx.thickness/ |  | 1.2 | 0.8 | 0.9 | 1.1 | 1.2 | 1.4 | 1.6 | 1.8 | 2.2 | 2.6 |  |  |  | 27 | 0.635
Hopper drag |  |  | ply ([NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 0.61
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | 0.585
 |  |  | Cover types |  | AR | A | B | K | N | GW | GWF | SF | IW |  |  |  |  | 30 | 0.56
NOTES |  |  | Approx.weight kg/ |  | 1.12 | 1.12 | 1.14 | 1.14 | 1.14 | 1.18 | 1.25 | 1.28 | 1.41
 |  |  | [NAME]
 |  |  | TABLE 3.
 |  |  | WEIGHT OF MOVING PARTS OF CONVEYOR G (kg/m)
 |  |  | BELT WIDTH | WEIGHT/IDLER
 |  |  | 300 | 3.5
 |  |  | 400 | 4
 |  |  | 500 | 5.5
 |  |  | 650 | 10
 |  |  | 800 | 14
 |  |  | 1000 | 18
 |  |  | 1200 | 20
 |  |  | 1400 | 31
 |  |  | 1600 | 35
 |  |  | 1800 | 47
 |  |  | 2000 | 52
 |  |  | 2200 | 56
based on [NAME] power ar head shaft
 |  |  | TABLE 5.
 |  |  | DRIVE FACTORS m (-)
RUBBER, WET
 |  |  |  |  |  |  |  |  | 1 | 4 | Ceramic | Dry |  | Gravity | 1
 |  |  |  |  |  |  | u |  | 2 | 5 | Rubber | Moist |  | Screw | 1.16
If tension type = gravity f1 = 1 |  |  | 1 | ceramic | 4 | dry | 0.75 |  | 3 | 6 | Bare | Wet
If tension type = screw f1 = 1.16 |  |  | 1 | ceramic | 5 | moist | 0.5 |  |  |  |  |  |  | Select Keyway Factor
 |  |  | 1 | ceramic | 6 | wet | 0.45 |  |  |  |  |  |  | KEYWAY | 1.3
 |  |  | 2 | rubber | 4 | dry | 0.35 |  |  |  |  |  |  | PLAIN | 1
 |  |  | 2 | rubber | 5 | moist | 0.25
 |  |  | 2 | rubber | 6 | wet | 0.2
 |  |  | 3 | bare | 4 | dry | 0.3
 |  |  | 3 | bare | 5 | moist | 0.2
 |  |  | 3 | bare | 6 | wet | 0.1
 |  |  |  | TABLE 7. |  |  |  |  | [NAME] pulley.
 |  |  |  | RECOMMENDED MIN. PULLEY DIAMETERS ([NAME]). |  |  |  |  | [NAME] pulley -Heavily loaded snub pulley.
 |  |  |  | MULTIPLY BELTS |  |  |  |  | D3= Snub pulley - moderately loaded.
Refer Table 7 N/A FEXOWELL |  |  |  |  | CATEGORY | PLIES
 |  |  |  |  |  |  | 100 | 100 | 100 | 125 | 125 | 125 | 160 | 160 | 160 | 200 | 200 | 200 | 250 | 250 | 250 | FABRIC
 |  |  |  |  |  |  | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 3 | DRUM
 |  |  |  |  | 3 | 2 | 160 | 160 | 125 | 200 | 160 | 160 | 250 | 200 | 160 | 315 | 250 | 200
 |  |  |  |  | 3 | 3 | 200 | 200 | 160 | 315 | 250 | 200 | 400 | 315 | 250 | 500 | 400 | 315 | 630 | 500 | 400
 |  |  |  |  | 3 | 4 | 315 | 250 | 200 | 400 | 315 | 250 | 500 | 400 | 315 | 630 | 500 | 400 | 800 | 630 | 500
 |  |  |  |  | 3 | 5 | 400 | 315 | 250 | 500 | 400 | 315 | 630 | 500 | 400 | 800 | 630 | 500 | 1000 | 800 | 630
 |  |  |  |  | 3 | 6 |  |  |  | 630 | 500 | 400 | 800 | 630 | 500 | 1000 | 800 | 630 | 1250 | 1000 | 800
 |  |  |  |  | 2 | 2 | 160 | 125 | 125 | 200 | 160 | 160 | 200 | 160 | 160 | 250 | 200 | 160
 |  |  |  |  | 2 | 3 | 200 | 160 | 160 | 250 | 200 | 160 | 315 | 250 | 200 | 400 | 315 | 250 | 500 | 400 | 315
 |  |  |  |  | 2 | 4 | 250 | 200 | 160 | 315 | 250 | 200 | 400 | 315 | 250 | 500 | 400 | 315 | 630 | 500 | 400
 |  |  |  |  | 2 | 5 | 315 | 250 | 200 | 400 | 315 | 250 | 500 | 400 | 315 | 630 | 500 | 400 | 800 | 630 | 500
 |  |  |  |  | 2 | 6 |  |  |  | 500 | 400 | 315 | 630 | 500 | 400 | 800 | 630 | 500 | 1000 | 800 | 630
 | shear | bending |  |  | 1 | 2 | 125 | 125 | 125 | 160 | 160 | 160 | 160 | 160 | 160 | 200 | 200 | 160
en8 | 52 | 69 |  |  | 1 | 3 | 160 | 160 | 160 | 200 | 160 | 160 | 250 | 200 | 160 | 315 | 250 | 200 | 400 | 315 | 250
en3 | 40 | 52 |  |  | 1 | 4 | 200 | 160 | 160 | 250 | 200 | 200 | 315 | 250 | 200 | 400 | 315 | 250 | 500 | 400 | 315
 |  |  |  |  | 1 | 5 | 250 | 200 | 200 | 315 | 250 | 250 | 400 | 315 | 250 | 500 | 400 | 315 | 630 | 500 | 400
 |  |  |  |  | 1 | 6 |  |  |  | 400 | 315 | 315 | 500 | 400 | 315 | 630 | 500 | 400 | 800 | 630 | 500
Select Keyway Factor
KEYWAY | 1.3
PLAIN | 1
 |  |  |  |  |  |  |  |  | COMMON BELT SPECS
 |  |  |  |  |  | shear | bending |  | Column1 | Column2 | Column3 | Column4 | Column5
reviewed since metso |  |  |  |  | en8 | 52 | 69 |  |  | 2 | 3 | 4 | PLIES
 |  |  |  |  | en3 | 40 | 52 |  | 315 | 160 | 100 | 100
 |  |  |  |  |  |  |  |  | 400 |  | 125 | 100
 |  |  |  |  |  |  |  |  | 500 |  | 160 | 125
 |  |  |  |  |  |  |  |  | 630 |  | 200 | 160
 |  |  |  |  |  |  |  |  | STRENGTH
 |  |  | TABLE 8
Select shaft size above the
highest of these values. |  |  | BEARING RATINGS IN NEWTONS
 |  |  |  | COOPER SERIES 01 |  | R.H.P. MP SERIES
 |  |  | DIA. MM | [NAME] | STATIC | [NAME] | STATIC
 |  |  | 50 | 75000 | 80000 | 33400 | 25000
 |  |  | 55 |  |  | 40300 | 30900
 |  |  | 60 | 97000 | 111000 | 47700 | 37500
 |  |  | 65 | 97000 | 111000 | 50700 | 41100
 |  |  | 70 | 130000 | 157000 | 50700 | 41100
 |  |  | 75 | 130000 | 157000 | 55500 | 44500
 |  |  | 80 | 179000 | 226000 | 63500 | 53000
 |  |  | 85 | 179000 | 226000 | 74000 | 60500
 |  |  | 90 | 179000 | 226000 | 74000 | 60500
 |  |  | 95 |  |  | 111000 | 99000
 |  |  | 100 | 239000 | 318000 | 111000 | 99000
 |  |  | 105 | 239000 | 318000 | 111000 | 99000
 |  |  | 110 | 298000 | 407000
 |  |  | 115 | 298000 | 407000
 |  |  | 120 | 348000 | 484000
 |  |  | 125 | 348000 | 484000
 |  |  | 130 | 348000 | 484000
 |  |  |  |  |  |  |  |  |  |  | 2.2 | 0.278
 |  |  |  |  | 168 | 45 |  |  |  | 1650
 |  |  |  | 0.03 |  | 71 | 9.8
 |  |  |  | 0.03 |  | 209 | 9.8
 |  |  |  | 209 | 14.7 | 9.8
 |  |  |  |  |  |  |  |  | N
 |  | M/Sec |  |  | 2.2 | 1000 |  |  | KW
 | SEW
 | 5.5 | Kw
 | 6150 | Nm | TABLE 7 ROSSI CATALOGUE
 | 8.7 | KW
 | 14.79 | [NAME]
length | width
1.4 | 0.8 |  | FEED FACTOR
 |  |  | HOPPER (DEEP)
 |  |  | HOPPER SHALLOW  (-2M)
 |  |  | UNDER SCREEN
 |  |  | CONVEYOR EVEN
Loading Shovel