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

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

2019年中国气候主要特征及主要天气气候事件

2019年我国气候总体呈现暖湿特征。全国年平均气温较常年同期偏高0.79℃,为1951年以来连续第五暖年,四季气温均偏高,春、秋季明显偏暖;年降水量为645.5 mm,较常年同期偏多2.5%,冬、春、夏季降水偏多,秋季偏少。华南前汛期开始早、结束晚,为1961年以来最长前汛期,雨量为1961年以来次多;西南雨季开始和结束均偏晚,雨量偏少;入梅晚、出梅早,梅雨量偏少;华北雨季开始晚,结束与常年一致,雨量偏少;东北雨季开始早、结束晚,雨量偏多;华西秋雨开始早、结束晚,雨量偏多。2019年,台风生成多,登陆强度总体偏弱,仅台风利奇马灾损重;暴雨洪涝、干旱、强对流、低温冷冻害和雪灾、沙尘暴等气象灾害均偏轻。     

多普勒天气雷达波束水平距离的计算方法

从球坐标系出发,利用三角形余弦定理和大气折射理论,推导了不作任何近似的、包含地球曲率和大气折射影响的多普勒天气雷达波束水平距离D_m的计算公式,并与斜距投影D_r、地表平面近似的计算公式(不考虑地球曲率和大气折射,记为D_d)和地表球面近似的计算公式(不考虑大气折射,记为D_s)进行了对比分析。结果发现,在标准大气状态下,D_m与D_r在高仰角相差2.5 km以上(D_r大),最高距离差达3.5 km(19.5°仰角最大斜距处);与D_d在低仰角相差0.5 km以上(D_d大),与D_r相差在0.5 km以下(Dm大)。并利用2011—2015年南昌站的探空资料,分析了南昌地区各个季节大气折射的变化情况及其与标准大气的区别。结果显示,夏季南昌上空电磁波的传播受大气折射的影响最大,冬季电磁波受大气折射的影响最小。最后,给出了南昌地区各个季节地球曲率K及等效地球半径Rm与标准大气的订正关系。     

巴旦杏越冬冻害气象指标

低温冻害是危害新疆林果业持续健康高效发展的三大灾害之一,通过对越冬期间果树冻害历史灾情资料的调查及最低气温数据库的建立,研究冻害的发生时间、界限温度以及冻害发生年各项气象因子的变化特征,阐明果树越冬冻害与气象因子的关系.结果表明,可根据冬季平均气温、最低气温、降温天气及低温持续时间等确定该区巴旦杏越冬期发生冻害的气象指标.研究结果可为有效防范低温冻害提供理论依据,为林果业生产服务.     

太原城市化进程对城市热岛的影响

采用城市化的多项要素指标,系统考察了太原1980-2009年期间城市化的发展对其城市热岛效应的影响关系,发现城市化的发展是导致城市热岛效应形成和加剧的主要原因.认为:①近30年,太原市郊区的增温率为0.51℃/10a,市区的增温率为0.90℃/10a,热岛强度的增温率为0.39℃/10a,热岛效应不断增强;②各类城市发展指数与城市热岛效应都有很好的相关关系;③太原城郊温差和总人口对数呈线性相关关系,其长期变化相关系数为0.81;④太原城郊温差和城市房屋建筑面积对数呈线性关系,其长期变化相关系数为0.85.     

A new lunar absolute control point: established by images from the landing camera on Chang'e-3

The establishment of a lunar control network is one of the core tasks in selenodesy, in which defining an absolute control point on the Moon is the most important step. However, up to now, the number of absolute control points has been very sparse. These absolute control points have mainly been lunar laser ranging retroreflectors, whose geographical location can be observed by observations on Earth and also identified in high resolution lunar satellite images. The Chang'e-3(CE-3) probe successfully landed on the Moon, and its geographical location has been monitored by an observing station on Earth. Since its positional accuracy is expected to reach the meter level, the CE-3 landing site can become a new high precision absolute control point. We use a sequence of images taken from the landing camera, as well as satellite images taken by CE-1 and CE-2, to identify the location of the CE-3 lander. With its geographical location known, the CE-3 landing site can be established as a new absolute control point, which will effectively expand the current area of the lunar absolute control network by 22%, and can greatly facilitate future research in the field of lunar surveying and mapping, as well as selenodesy.     

Data processing and initial results from the CE-3 Extreme Ultraviolet Camera

The Extreme Ultraviolet Camera(EUVC) onboard the Chang'e-3(CE-3)lander is used to observe the structure and dynamics of Earth's plasmasphere from the Moon. By detecting the resonance line emission of helium ions(He+) at 30.4 nm, the EUVC images the entire plasmasphere with a time resolution of 10 min and a spatial resolution of about 0.1 Earth radius(RE) in a single frame. We first present details about the data processing from EUVC and the data acquisition in the commissioning phase, and then report some initial results, which reflect the basic features of the plasmasphere well. The photon count and emission intensity of EUVC are consistent with previous observations and models, which indicate that the EUVC works normally and can provide high quality data for future studies.     

Tail Emission from a Ring-like Jet: Its Application to Shallow Decays of Early Afterglows and GRB 050709

Similar to the case of pulsars the magnetic axis and the spin axis of gamma-ray burst sources may not lie on the same line. This may cause the formation of a ring-like jet due to collimation of the processing magnetic axis. We analyze the tail emission from such a jet, and find that it has a shallow decay phase with a temporal index of -1/2 if the Lorentz factor of the ejecta is not very high, which is consistent with the shallow decay phase of some early X-ray afterglow detected by Swift. The ring-like jet has a tail cusp with sharp rising and very sharp decay. This effect can provide an explanation for the re-brightening and sharp decay of the X-ray afterglow of GRB 050709.     

A temperature inversion in "Chinese Arctic Research Expedition 1999

1　ＩｎｔｒｏｄｕｃｔｉｏｎＴｈｅＡｒｃｔｉｃａｒｅａ ,ａｓｔｈｅｂａｃｋｇｒｏｕｎｄｏｆｇｌｏｂａｌｃｌｉｍａｔｅａｎｄｅｎｖｉｒｏｎｍｅｎｔ,ｄｒａｗｓｐｅｏ ｐｌｅ’ｓａｔｔｅｎｔｉｏｎｗｉｔｈｉｔｓｉｍｐａｃｔｏｎｇｌｏｂａｌｃｈａｎｇｅ (ＩＰＣＣ 1 990 ) .Ｇｒｅａｔａｍｏｕｎｔｏｆｅｎｅｒｇｙａｎｄｍａｓｓａｒｅｅｘｃｈａｎｇｅｄｂｅｔｗｅｅｎｔｈｅｓｅａａｎｄａｉｒｗｉｔｈｓｐｅｃｉａｌｉｎｔｅｒｆａｃｅ,ａｉｒ ｉｃｅ ｓｅａｓｕｒｆａｃｅ ,ｉｎｔｈｉｓａｒｅａ .Ｔｈｅｒｅｆｏｒｅｉｔｉ…     

A Catalog of Luminous Infrared Galaxies in the IRAS Survey and Second Data Release of SDSS

We selected a sample of luminous infrared galaxies by cross-identification of the Faint Source Catalogue (FSC) and Point Source Catalogue (PSC) of the IRAS Survey with the Second Data Release of the SDSS. The size of our sample is 1267 for FSC and 427 for PSC by using the 2σ significance level cross-section. The "likelihood ratio" method is used to estimate the individual's reliability and for defining two more reliable subsamples (908 for FSC and 356 for PSC). A catalog of infrared, optical and radio data is compiled and will be used in further work. Some statistical results show that luminous infrared galaxies are quite different from ultra-luminous infrared galaxies. The AGN fractions of galaxies at different infrared luminosities and the radio-infrared correlations are consistent with the previous studies.