萃取计算的Excel VBA图解方法

Extracted calculation of the Excel VBA diagrammatic method

利用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.