Ranking of Belt Conveyor Systems for Prefeasibility Study

Prefeasibility planning and cost estimation of conveyor systems has historically been undertaken by comparing fi xed plant transport requirements to that of similar systems in service. This paper describes the development of a prefeasibility conveyor technical design and cost estimation application using Microsoft Excel Visual Basic for Applications (VBA) platform. The application tool known as D-Convey (Dachshund Convey) was developed with the goal enabling the end user: to develop a technical model for conceptualised conveyor systems, to perform economic analysis on the developed technical model, and to conduct a comparative and risk analysis. An Excel VBA based platform was utilised to draw upon both the analytical and graphical capabilities of a spreadsheet. Some of the features of D-Convey system include a revolutionary dynamic graphical help system, known as the 'information pane' in lieu of traditional help fi les as well as the use of familiar graphical user interface elements such as the MS Offi ce 2007 task ribbon. The D-Convey system incorporates material database allowing for mass handling prefeasibility estimation in other industries; it has been validated at a local quarry.