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

CUSTOMER |  |  |  |  |  |  | BLUE | INPUT  ~ DESIGN DATA
PROJECT |  |  |  |  |  |  | RED | INPUT ~ FROM TABLES
CONVEYOR REF: |  |  |  |  |  |  | BLACK | CALCULATED OUTPUT
 |  |  |  |  |  |  | GREEN | ENTER MANUALLY - IN PROGRESS
DESIGN DATA
DRUM CENTRES |  |  |  | 69 | M. |  |  |  |  |  |  |  |  |  |  |  |  | FEEDER  BELT SPEED AT LOAD HT
Length mod factor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T/Cu.M |  | ton | WID | HT | AREA |  | SPEED
Combine length |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000 | 900 | 250
BELT WIDTH |  |  |  | 650 | [NAME]
BELT SPEED |  |  |  | 2 | M/Sec
CONVEYOR INCLINE |  |  |  | 8 | Degrees
INCLINE FACTOR |  | (K)
TROUGHING ANGLE DEGREES |  |  |  | 35
LIFT HEIGHT |  |  |  |  | M.
MATERIAL
 | TYPE |  |  | AGG
 | LUMP SIZE |  |  | 20 | [NAME].
 | BULK DENSITY |  |  | 1.6 | T/Cu. M.
CAPACITY |  |  |  | 300 | T.P.H.
MATERIAL C.S.A. |  |  |  |  | Sq. M.
EFFICIENCY FACTOR |  |  |  | 0.85
MAX. CAPACITY (c.s.a. x speed)not power |  |  |  |  | T.P.H.
PROPOSED BELT STRENGTH |  |  |  | 500
 |  |  |  |  | WT.
BELT TOP COVER THICKNESS ([NAME]) |  |  |  | 5 |  | Kg
BELT BOTTOM COVER THICKNESS ([NAME]) |  |  |  | 2 |  | Kg
No OF PLIES |  |  |  | 3
PLY WEIGHT PER SQ. METRE |  |  |  | 1.4 |  | Kg
 |  | TOTAL BELT WEIGHT |  |  |  | Kg
T. IDLER WEIGHT |  |  |  |  | Kg
T. IDLER PITCH |  |  |  | 1000 | [NAME]
R. IDLER WEIGHT |  |  |  |  | Kg
R. IDLER PITCH |  |  |  | 2500 | [NAME]
G FACTOR (WEIGHT OF MOVING PARTS) |  |  |  |  | Kg
FRICTION FACTOR |  |  |  | 0.03
SKIRT LENGTH |  | PER SIDE |  | 2.5 | M.
POWER REQ,D -- EMPTY CONVEYOR |  |  |  |  | Kw
POWER REQ,D CONVEY MATL. - HORIZ |  |  |  |  | Kw
POWER REQ,D CONVEY MATL. - VERT |  |  |  |  | Kw
SKIRT ALLOWANCE |  |  |  |  | Kw
SUB TOTAL |  |  |  |  | Kw
ADDITIONAL FACTOR |  |  |  | 1.15 | 2t/m3 |  | Hopper drag
DRIVE POWER AND BELT DESIGN DATA
DRIVE MOTOR
POWER AT DRIVE DRUM SHAFT |  |  |  |  | Kw
DRIVE TYPE
DRIVE EFFICIENCY |  |  |  | 0.97
Design power at motor
POWER AT MOTOR |  |  |  | 18.5 | Kw
HEAD DRUM DIA OVER LAGGING |  |  |  | 528 | [NAME].
HEAD DRUM [NAME] |  |  |  |  | r.p.m.
TORQUE |  |  |  |  | Nm.
TORQUE @ absorbed power |  |  |  |  | Nm.
BELTING
EFFECTIVE TENSION |  |  |  |  | N |  | based on [NAME] power ar head shaft
WRAP ANGLE |  |  |  | 205 | Degrees
 |  | Lagging | Moisture | Coefficient
LAGGING TYPE |  | Rubber | Moist
KFACTOR
 |  |  |  |  | Factor f1
BELT TENSION TYPE |  |  |  | Screw
MODIFIED K FACTOR
TENSION T1 |  |  |  |  | N
TENSION T2 |  |  |  |  | N
g.t.u. weight |  |  |  |  | KGS
WORKING TENSION |  |  |  |  | KN/M
BELT MODULUS |  |  |  |  | KN/M
PERCENTAGE UTILISATION |  |  |  |  | %
UTILIZATION CATEGORY
FABRIC TYPE |  |  | EP
[NAME] DIA |  |  |  |  | [NAME]
1
ACTUAL DRIVE PULLEY DIA |  |  |  |  | [NAME]
RECOMMENDED TAIL PULLEY DIA. |  |  |  |  | [NAME]
2
ACTUAL TAIL PULLEY DIA. |  |  |  |  | [NAME]
DRUM AND SHAFT DESIGN DATA
DISTANCE FROM C\L BEARING TO C\L |  |  |  | 0.2 | m
DRUM BOSS
DRUM BOSS
SHAFT MATERIAL |  |  |  | EN8
DRUM KEYWAY FACTOR |  |  |  | PLAIN
ALLOWABLE SHEAR STRESS |  |  |  |  | Nm
ALLOWABLE BENDING STRESS |  |  |  |  | Nm
RESULTANT FORCE (BENDING)  = |  |  |  |  | N
BENDING MOMENT |  |  |  |  | Nm
TORSIONAL MOMENT |  |  |  |  | Nm
COMBINED BEM |  | BENDING) |  |  | Nm
COMBINED TEM |  | (TORSION) |  |  | Nm
SHAFT DIA BASED ON BENDING = |  |  |  |  | [NAME] |  | Select shaft size above the
SHAFT DIA BASED ON TORSION = |  |  |  |  | [NAME] |  | highest of these values.
SHAFT DIA SELECTED = |  |  |  | 140 | [NAME]
BEARING TYPE |  |  |  | BCP100
BEARING SIZE |  |  |  | 100
[NAME] |  |  |  |  | N
RATIO actual load to permissible
TAIL DRUM SHAFT DESIGN
DRUM KEYWAY FACTOR |  |  |  | 1
ALLOWABLE BENDING STRESS
DISTANCE FROM C\L BEARING TO C\L
DRUM BOSS |  |  |  | 0.2 | M
RESULTANT FORCE (BENDING) |  |  |  |  | N
BENDING MOMENT |  |  |  |  | Nm
MINIMUM SHAFT DIA . |  |  |  |  | [NAME]
SHAFT DIA SELECTED = |  |  |  | 100 | [NAME]
BEARING TYPE |  |  |  | MST75
BEARING SIZE |  |  |  | 75
[NAME] |  |  |  |  | N |  |  |  |  |  |  | 168 | 45 |  |  |  | 1650 | 2.2 | 0.278
RATIO actual load to permissible
 |  |  |  |  |  |  |  |  |  |  | 0.03 |  | 71 | 9.8
 |  |  |  |  |  |  |  |  |  |  | 0.03 |  | 209 | 9.8
DESIGN OUTPUT |  |  |  |  |  |  |  |  |  |  | 209 | 14.7 | 9.8
DRUM CENTRES |  |  |  | M. |  |  |  |  |  |  |  |  |  |  |  | N
BELT WIDTH |  |  |  | [NAME]
BELT SPEED (DESIGN) |  |  |  | M/Sec | ACTUAL BELT SPEED |  |  |  | M/Sec |  |  | 2.2 | 1000 |  |  | KW
CONVEYOR INCLINE |  |  |  | Degrees
MATERIAL
 | TYPE
 | LUMP SIZE |  |  | [NAME].
 | BULK DENSITY |  |  | T/Cu. M.
CAPACITY |  |  |  | T.P.H.
BELTING
 | T1 |  |  | N
 | T2 |  |  | N
 | TE |  |  | N
 | MOD | PLY | TOP COV | BOT COV | LENGTH
BELT JOINT TYPE
MINIMUM [NAME]
DRIVE DETAILS ELECTRIC |  |  |  |  | GEAR BOX DETAILS
POWER AT  DRIVE SHAFT |  |  |  | Kw | MAKE |  |  | SEW
POWER AT MOTOR |  |  |  | Kw | MODEL | MRC21 160 VO2A 132S4
MOTOR SIZE |  |  | 5.5 | Kw | MOTOR |  |  | 5.5 | Kw
[NAME] (DESIGN) |  |  |  | [NAME] | MAX TORQUE(GBOX) |  |  | 6150 | Nm | TABLE 7 ROSSI CATALOGUE
TORQUE |  |  |  | Nmm | MAX POWER (GBOX) |  |  | 8.7 | KW
 |  |  |  |  | SERVICE FACTOR(POWER)
 |  |  |  |  | ACT. OUTPUT SPEED |  |  | 14.79 | [NAME]
HOPPER DRAG FACTOR CALCULATIONS |  |  |  |  |  |  | length | width
HOPPER MATERIAL FOOT PRINT ON BELT |  |  |  |  |  | M2 | 1.4 | 0.8 |  | FEED FACTOR
HEIGHT OF MATERIAL OVER BELT |  |  |  |  | 1.7 | M |  |  |  | HOPPER (DEEP)
VOLUME MATERIAL OVER BELT |  |  |  |  |  | M3 |  |  |  | HOPPER SHALLOW  (-2M)
WEIGHT OF MATERIAL OVER BELT |  |  |  |  |  | T |  |  |  | UNDER SCREEN
 |  |  |  |  |  | N |  |  |  | CONVEYOR EVEN
MATERIAL SLIPPAGE\SHEAR FACTOR |  |  |  |  | 0.1
additional belt tension |  |  |  |  |  | N
ADDITIONAL POWER = |  |  |  |  |  | KW
FEED FACTOR |  |  |  |  | 1 |  | Loading Shovel
FACTORED POWER REQUIREMENT |  |  |  |  |  | KW
HOPPER FACTOR ON  CONVEYOR POWER
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1