Determination of flourmill roll groove depth, machining time and power consumption by using computer aided spreadsheet

In roller flour milling fluted and polished rolls are used to produce wheat-milled products. Corrugation shape,
numbers, depth and angle are the roll properties, which influence milling extractions. Determining the corrugation depth
considering profile angles and number of grooves decide land width, which is only a measurable parameter on the roll. A
simulation program which was hitherto unavailable for the benefit of milling engineers was developed to determine groove
depth, machining time and energy consumption for roll grooving operation by considering Excel's built in functions and
capabilities. Mathematical formulae and logic functions were used to determine depth of cut, machining time and energy
consumption during roll grooving operation. Spreadsheet calculated arc length, land width and machining time values were
compared with AutoCAD values and observed errors of 0.07%, 4.2-20.9% and 2.6-8.5%, respectively. Extension of this
simulator work to other sections of flourmill makes it possible to improve effectiveness of grinding and milling process.