VBA程序设计在落球法测液体粘滞系数实验中的应用

Application of VBA Program in Measuring Liquid Viscosity by Ball-dropping Method

为了实现物理实验数据的高效处理,减少数据处理过程中的人为误差,实现数据处理的自动化。以落球法测量流体的粘滞系数为例,运用VBA编程调用Excel软件丰富的内置函数,开发了求解粘滞系数及其不确度的程序。本程序具有简单高效、界面简洁的特点,通过该程序计算的蓖麻油粘滞系数为1.42±0.12 Pa·s。同时阐述了使用VBA程序相对于使用Excel、Orgin等数据处理软件以及Visual Basic等程序处理物理实验数据的优势,有利于VBA程序设计在物理实验数据处理上的推广。

In order to achieve efficient data processing of physical experimental, reduce artificial errors in data processing , realize the automation of data processing, it takes the ball-dropping method as the example to meas-ure fluid viscosity.Using the built-in functions of Excel ,a VBA program is written to solve the liquid viscous re-sistance coefficient and to calculate the relative uncertainty.The program is simple ,efficient ,calculating the vis-cosity resistance coefficient of castor oil is 1.42 ± 0 . 1 2 Pa · s.It not only describes the advantages of using VBA program for physical experiment data processing compared with Excel ,Origin data processing software and V is -ual Basic program, but also can beneficial for generalized VBA program to processing physical experiment data.