摘要
利用Microsoft Excel的自定义函数与VBA混合编程准确而又快捷地解决了单级萃取和多级萃取的诸多计算问题,所获得的数据结合Excel的图表功能再现手工绘图原理,从而形成了萃取过程的Excel VBA图解计算方法,实现了萃取计算的图形化、可视化和自动化。Excel VBA图解计算方法易于掌握,避免了传统的手工计算及绘图带来的较大误差,对于处理类似的化工计算有一定的参考作用。
Using the customized function of Microsoft Excel and VBA programming, can solve many calculation problems of singlestage extraction and multi-stage extraction accurately and facilely represents the process of manual drawing by the function of Excel chart. Thereby, formed the Excel VBA diagrammatic calculation method of extraction process and achieves the graphical, visualization and automation of extraction calculation. The Excel VBA patterned calculation is easy to master, and consequently avoided the mistake of traditional manual calculation and drawing. This method is very straightforward and it is also useful to the similar chemical calculation.
出处
《计算机与应用化学》
CAS
CSCD
北大核心
2008年第11期1412-1416,共5页
Computers and Applied Chemistry
基金
江西省教育厅2008年度科技资助项目(GJJ08461).