Development of the VBA-based software for plotting coal screening equipment performance evaluation charts
SHEN Yanjie
Abstract：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 actu-al size analysis data of feed,and oversize and undersize products are entered,the software can automatically ex-ecute data calculation and generate four table files(data of size distribution of feed and products,partition coeffi-cients 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 capabil-ity of the software to perform such functions as calculation of screening data,plotting of curves,screen perform-ance 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.
Keywords：Design of coal washing processcoal screening equipment performance evaluationAutoCADVBAplotting of characteristic curvedata check
Publication Date：2024-12-25
Online Publishing Date：2025-08-15(First online date of this platform, not the publication date of the document)
Pages：8( 33-40 )