All Issue
Ceramic Material Databank and Linear Programming of the Dispensation Based on Excel

LIU Ming, HUANG Zhongwen
(Jingdezhen Ceramic Institute, Jingdezhen 333403, Jiangxi, China)

Abstract: In this paper the ceramic material databank has been set up by using Excel, and a Visual interface for inquiring the databank has also been designed by using the Visual Basic language. So the user can dynamically inquire the databank. On the other hand, using the Programming_solving tool provided by Excel, the mathematical model at the lowest cost of raw material is created. The results of the computer simulation indicated that the Linear Programming technology can efficiently solve the optimized ceramic material dispensation.
Key words: ceramic formula; Excel databank; Programming Solver; Visual Basic Programming

  • 【 View full text】Downloadedtimes

Print    Favorites      export BibTex      export EndNote      export XML