基于VBA宏语言的隔震橡胶支座试验数据处理程序

A calculation program for mechanical test data of rubber isolation bearings for buildings based on VBA Macro Language

依据隔震橡胶支座试验方法,配合电液伺服压-剪试验机力学性能试验,利用嵌入Microsoft Excel中的VBA宏语言接口实现了用于处理原始试验数据的程序。该程序可计算得隔震橡胶支座力学性能主要参数。主要介绍该计算程序的设计思路、具体算法和实例计算。

According to the test methods of rubber isolation bearings for buildings on electro-hydraulic-servo pressure-shear testing machine,a macro language based program is developed using VBA engine embedded in Microsoft Execl. The program is capable of calculating parameters from mechanical tests of rubber isolation bearings for buildings. Basic thoughts and algorithm of the program are introduced in this article. An example of performing the program is shown afterwards.