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

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

作　　者：李宫晟 张鹏[1] 苏关东 曹凌宇[1] 

机构地区：[1]中国石油大学(北京),北京102249

出　　处：《大学物理实验》2017年第4期89-93,共5页Physical Experiment of College

摘　　要：为了实现物理实验数据的高效处理,减少数据处理过程中的人为误差,实现数据处理的自动化。以落球法测量流体的粘滞系数为例,运用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.

关 键 词：落球法 YBA程序设计 粘滞系数 不确定度评定 实验数据处理 

分 类 号：O4-39[理学—物理]