Development of the VBA-based software for plotting coal screening equipment performance evaluation charts

The evaluation of performance of coal screening equipment performance in coal preparation design process requires a lot of tedious and error-prone data calculation and charts drawing work. In order to simplify and improve efficiency of the process, and reduce the workload of design personnel in data calculation, a VBA-based software for plotting coal screening equipment performance evaluation charts is developed. Once the actual size analysis data of feed, and oversize and undersize products are entered, the software can automatically execute data calculation and generate four table files (data of size distribution of feed and products, partition coefficients and misplaced material, report text of screen performance, and calculated mean square errors) and five characteristic curves (distribution curve, characteristic curve of size of reconstituted feed, curve miscellany rate of oversize, curve of miscellany rate of undersize, and curve of total misplaced material). Thanks to the capability of the software to perform such functions as calculation of screening data, plotting of curves, screen performance evaluation and data checking, the data calculation and charting process is rendered effectively simplified and more efficient, capable of completing the charting work within 10 minutes. Moreover, the accuracy of the characteristic curves plotted is significantly improved by using the method of fitting between two points.