A1 Journal article (refereed), original research

Spreadsheet version of knowledge-based system for mixing tanks selection

Publication Details
Authors: Koiranen Tuomas, Kraslawski Andrzej, Nyström Lars
Publisher: Taylor & Francis: STM, Behavioural Science and Public Health Titles
Publication year: 1997
Language: English
Related Journal or Series Information: Chemical Engineering Communications
Volume number: 161
Issue number: 1
Start page: 185
End page: 204
Number of pages: 20
ISSN: 0098-6445
eISSN: 1026-7379
JUFO-Level of this publication: 0
Open Access: Not an Open Access publication


Mixing is a common unit operation and there are a great variety of the possible systems to be mixed and the configurations 10 be applied. All this makes the selection of mixing equipment as an important field for the expert systems application.

This paper presents the spreadsheet-based expert system for the selection of stirred tank vessels. The presented system has been designed to work in the narrow field of expertize. The general methodology of the mixers selection is presented first. The program structure and the implementation aspects are discussed further. The last part of the paper presents the example of the system application, comments about the obtained solutions and summary.

The expert systems implemented in spreadsheet programs are not very popular and there is a common believe that their capabilities are strongly limited. However, our experience proved that this type of expert system could be very useful in the equipment selection. We recommend the development of the expert systems starting from the specialized tools and next transfer of the structured knowledge systems into spreadsheet programs.

Last updated on 2017-29-08 at 14:36