GeoKit:一个用VBA构建的地球化学工具软件包

GeoKit——A geochemical toolkit for Microsoft Excel

GeoKit是一个建立在Excel平台上,应用VBA编写而成的地球化学数据处理工具软件包,由主控模块、辅助模块和应用程序三个部分组成。主控模块文件格式为加载宏,是系统的控制中枢,可以实施对其他文件的控制与调用;辅助模块由Access数据库及由Excel建立的管理系统构成,可以方便地实现地球化学数据库的管理;应用软件由多个具有不同功能的相对独立的Excel文件构成,其主要组件包括以图形为主的地球化学散点图、稀土元素分布模式图、微量元素比值蛛网图和以参数计算为主的CIPW标准矿物计算、铅同位素模式年龄和参数计算及Sr-Nd同位素参数计算等。GeoKit界面友好,使用方便,是广大地质-地球化学工作者有用的工具软件。

GeoKit is a geochemical toolkit for Microsoft Excel designed with visual basic for application (VBA). The software system is composed of three components including controlling file, supporting system and working programs. The controlling file is an “addin”named “Click&OK.xla”(in Chinese), which will be automatically loaded at starting of Excel and create a user’s dropdown menu. This user’s menu controls all other functions. The supporting system consists of a database (Access) and an administering file (Excel) with which users could conveniently and efficiently manage their geochemical data. There are many working programs with different functions in GeoKit such as Scatter for Geochemistry, REE Pattern Diagram, Trace Element Ratio Spidergram, Calculation for CIPW Normative Minerals and Petrochemical Parameters, PbSrNd Isotope Parameters and so on. The GeoKit is friendship in interface and convenient in use and is a useful tool software for geological and geochemical workers.