VBA在桩基检测数据批量处理中的应用

工程上有时需将Excel中的数据批量处理成Word文档,以充分利用Excel强大的数据处理和计算分析功能与Word较强的文字处理和排版能力。当工程数据信息较多时,采用传统手工编辑的方法,其工作量非常大,重复性工作多,既费时又很容易出错。结合大型桩基工程,利用Microsoft Office软件中的VBA编程方法实现了桩基检测信息的自动批量生成,为桩基检测提供了及时准确的数据,大大提高了工作效率,具有重要的应用价值。     

青海省都兰县果洛龙洼金矿成矿流体

果洛龙洼金矿是青海东昆仑地区最典型、最具规模的金矿床之一。在前人资料基础上,将果洛龙洼金矿热液成矿期划分为4个成矿阶段：贫矿化石英阶段、石英-多金属硫化物阶段（主要成矿阶段）、石英-贫硫化物阶段（次要成矿阶段）和石英-碳酸盐阶段。随后对主要和次要成矿阶段石英脉开展流体包裹体显微测温和H-O同位素研究。结果表明：原生流体包裹体主要包括气液两相、富CO₂三相、纯CO₂两相共3类;成矿流体总体以CO₂-NaCl-H₂O体系为主,均一温度为130.0~357.3 ℃,盐度（w(NaCl)）为1.83%~20.11%。石英-多金属硫化物阶段石英δ¹⁸O_V-SMOW值为14.8‰~17.2‰,据此计算流体的δ¹⁸O_H2O值为5.5‰~8.5‰,流体的δD_V-SMOW值为-61‰~-96‰;而石英-贫硫化物阶段石英δ¹⁸O_V-SMOW值为15.7‰~16.9‰,据此计算流体的δ¹⁸O_H2O值为4.1‰~5.3‰,流体的δD_V-SMOW值为-84‰~-101‰。由此认为：主要成矿阶段成矿流体可能为高温低盐度富CO₂变质热液和低温中高盐度岩浆热液两个端元组成的混合流体;次要成矿阶段成矿流体主要为混合后更均匀的中低温中低盐度热液,但后期明显有大气降水混入。总之,成矿流体的来源、性质及其演化等方面的研究结果进一步证明果洛龙洼金矿为造山型金矿。     

Calcified roasting-acid leaching process of vanadium from low-grade vanadium-containing stone coal

The low-grade vanadium-containing stone coal used in this experiment was collected from Wuxi Coun- try, Chongqing City, China. The experiment focused on the vanadium recovery from roasted residue through opti- mizing the process conditions of an effective and environmentally-friendly technology, named calcified roast- ing-sulfuric acid leaching technology. By single-factor experiments and orthogonal experiments, the effects of roast- ing temperature, roasting time, sulfuric acid concentration and leaching time on the leaching ratio of vanadium were analyzed. The results showed that the leaching ratio of vanadium reached 85.5% under the proper technological con- ditions of roasting temperature=950℃, roasting time=4 h, 40% concentration of sulfuric acid and leaching time=6 h.     

麦饭石对腐殖酸及重金属离子的吸附作用

研究了麦饭石对腐殖酸和重金属离子（Ｈｇ２＋,Ｐｂ２＋,Ｃｕ２＋,Ｚｎ２＋,Ｃｄ２＋）的吸附作用,实验结果表明麦饭石对腐殖酸和重金属离子都具有较好的吸附性能,且腐殖酸的存在有利于麦饭石对重金属离子的吸附。ｐＨ值是影响吸附的重要因素,当ｐＨ值为５．０～６．０时,麦饭石同时吸附腐殖酸和重金属离子的效果最好,麦饭石在吸附腐殖酸和重金属离子的同时能溶出微量元素硒,这对于大骨节病的防治有重要意义。     

P-T Paths Derived from Garnet Growth Zoning in Danba Domal Metamorphic Terrain, Sichuan Province, West China

Danba (丹巴) domal metamorphic terrain belongs to Songpan (松潘)-Ganze (甘孜) orogenic belt, where typical Barrovian and Buchan metamorphic zones are preserved. The former included chlorite, biotite, garnet, staurolite, kyanite and sillimanite zones, while the latter only developed silimanite+muscovite and sillimanite+K-feldspar zones. Integrated study has been carried on metamorphic reactions of garnet production and consumption, P-T paths and P-T-X-M phase relation and thermal tectonic model for Danba metamorphic zones. Petrological textures in thin sections show that garnet production and consumption in kyanite-sillimanite zone is mainly attributed to ChI+Ms+PI+Q=Grt+Bt+H2O and kyanite=sillimanite respectively. Based on mineral compositions, the geothermobarometry gives an average P, T condition of (4.9±0.3)×108 Pa, 543±30℃ for the first growth stage of the garnet and (5.8±0.3)±108 Pa, 534±29 ℃ for the second stage of garnet growth respectively. Anti-counter clockwise P-T paths were drawn using Gibbs method by NCMnKFMASH system for sample G98686 in the kyanite zone. The P-T-X-M modeling for the first mineral assemblages shows that the prediction is similar to the measured values in gossular, almandine and spessartine but mole fraction of pyrope and Fe/(Fe+Mg) deviated far from the contours; while that for the second mineral assemblages exhibits that the prediction is consistent with the measured value of pyrope, grossular content and Fe/(Fe+Mg) of garnet. A thermal tectonic model that there are at least three structure levels across the thrnst-decollement zones is presented according to the P-T paths, metamorphic grades and deformation styles for the staurolite-kyanite zone of the Barroviau type metamorphism, which will provide some constraints for the evolution of the nappe complex.     

川滇地区某纯橄榄岩地质特征

本文对川滇地区某纯橄榄岩体的地质特征进行了初步研究。该岩体的岩石新鲜，几乎没有蛇纹石化。岩体具层状构造，岩石中发育扭折带、巨晶、碎斑、等粒镶嵌结构、板块镶嵌结构等特殊的地幔岩结构构造。此外，岩石化学及地球化学特征了都表明该纯橄榄岩体属于蛇绿岩层序中堆积的一个组成部分。     

富氟花岗岩中萤石岩浆成因的新证据

通过富氟花岗岩-HF-H2O体系的熔化-结晶实验,在620～700℃、1×108Pa条件下获得了石英+碱性长石+黄玉+云母+萤石的矿物组合.在该实验体系中首次发现了八面体萤石.实验结果表明,在岩浆条件下可以形成萤石,从而为富氟花岗岩中萤石的岩浆成因提供了新证据.     

石笋氧同位素和微量元素记录的陕南地区4200～2000a B.P.高分辨率季风降雨变化

基于陕南祥龙洞石笋XL2的19个230Th年龄、218个氧同位素分析以及896个Sr/Ca分析数据,高分辨率重建了4200～1972a B.P.期间陕南地区季风降雨变化.重建结果显示陕南地区这一时期季风降雨有显著的127～105a和57a周期,可能分别受控于太阳活动、PDO和/或AMO的变化.重建时段有3次百年尺度的干旱事件,分别发生于2200～2100a B.P.,2900～2700a B.P.和3600～3400a B.P.,其中2900～2700a B.P.干旱事件对应于北大西洋地区2.8ka冷事件.对比研究显示,尽管祥龙洞石笋和董哥洞石笋δ18O记录整体一致,但除了2900～ 2700aB.P.干旱事件之外,其他两次干旱事件在董哥洞石笋记录中并不明显.而尽管总体上祥龙洞和和尚洞石笋δ18O记录的差异要大,但XL2的3次干旱事件在和尚洞记录都有明显体现.有精确年代控制的祥龙洞、董哥洞及和尚洞石笋氧同位素记录的差异,揭示晚全新世我国季风降雨在十一百年尺度存在区域差异.     

小体积萃取-石墨炉原子吸收法测定高纯硝酸钡中纳克级重金属元素

本文研究了石墨炉原子吸收光谱法测定高纯硝酸钡中超痕量重金属元素的分析技术。提出在大量钡基体存在时,采用小体积萃取体系APDC-MIBK同时萃取纳克级的Fe、Cu、Co和Ni。该法具有灵敏度高、无干扰、操作方便和减少沾污等特点。方法检出限为:Fe 7.2ng/g、Cu 12.8ng/g、Co 4.4ng/g和Ni 6.7ng/g。应用于红外光纤原料硝酸钡、硝酸铝中痕量重金属的测定,效果良好。