Excel在大学物理实验中的应用

利用Excel的强大功能，对实验数据进行处理、分析，对实验过程及实验结果的监控。     

Effect of pH on the Crystallization of Homogeneously Precipitated Nanosized PZT Powder

Nanosized lead zirconate titanate (PZT) powder with Zr:Ti ratio in the morphotropic phase boundary region was synthesized by homogeneous precipitation of metal ions. The powder precipitated at 90°C and at pH 6.7 resulted single-phase perovskite lead zirconate titanate powder when calcined at 550°C and above for 4 hours in air. The solution pH and the precipitation temperature strongly affect the composition of the calcined powder. The results obtained by structural characterization of homogeneously precipitated powder were compared with that obtained from the conventional precipitation method using ammonia in terms of crystallization, homogeneity, and microstructure. The homogeneously precipitated powder showed smaller particle size, minimum agglomeration and uniform shape on calcination and annealing. Powdered samples that precipitated by homogeneous precipitation crystallized directly to perovskite PZT, without any intermediate pyrochlore phase formation. In contrast, the NH₃ precipitated powder converted to perovskite PZT via metastable pyrochlore and it showed phase segregation upon annealing at higher temperatures. The reaction kinetics has been studied by X-ray diffraction, differential thermal analysis, and differential scanning calorimetry.     

Surface Hardening of High-Strength Low Alloy Steels (HSLA) Dual-Phase Steels by Ball Burnishing Using Factorial Design

Burnishing is used increasingly as a finishing operation which gives additional advantages such as increased hardness, fatigue strength, and wear resistance. Experimental work based on 3⁴ factorial design was carried out to establish the effects of ball burnishing parameters on the surface hardness of high-strength low alloy steels (HSLA) dual-phase (DP) steel specimens. Statistical analysis of the results shows that the speed, feed, lubricant and ball diameter have significant effect on surface hardness.     

三元吸收制冷的研究进展

氨—水和溴化锂—水是目前使用最广泛的两种二元吸收工质对，但各有缺陷，为此人们希望采用三元吸收工质克服这两种二元工质对的不足。国外许多学者对三元吸收制冷尤其是氨—水—溴化锂三元吸收制冷作了大量理论和试验研究，国内未见这方面的文献发表，该文从物性和循环两方面对这些研究作简单介绍，并对三元吸收制冷研究简单展望。     

钢样成分化验分析结果网络传输系统的开发与应用

钢样成分化验分析结果网络传输系统将碳硫分析仪、光谱分析仪和相应的计算机控制系统按以太网络结构组联,形成"炉前分析网络",采用分析网主服务器系统软件和网络分析系统软件实现网络传输。该系统可将炉前钢样化验分析结果实时传输到炉前大屏,具有传输速度快、准确率高的特点,提高了工作效率和产品合格率,降低了生产成本。     

Success and failures in urban transport planning in Europe—understanding the transport system

Technological determinism has become a kind of religion for many people since it appears to offer solutions for societal problems as never before in history. Transport is one of the fascinating technology branches developed during the last 200 years. Effortless movement over long distances has become possible for car users as long as cheap fossil energy is available. However, the effect of fast transport on urban structures and society was not taken into account when developing these technical means. Technologists and economists have used indicators for expected benefits of these fast transport modes without taking into account the real system effects on society and urban structures. Plausible assumptions and hopes instead of scientific understanding of the complex system are used in practice. In contradiction to widely held beliefs of transportation planners, there is actually no growth of mobility if counted in number of trips per person per day, no time saving by increasing speed in the system, and no real freedom of modal choice. Modal choice is dependent on physical and other structures, the artificial environment built by urban planners, transport experts and political decisions. The core hypothesis of traditional urban and transport planning ‘growth of mobility’, ‘travel time saving by increasing speed’ and ‘freedom of modal choice’ are myths and do not exist in the real urban and transport system. This is the reason why urban planning and transport planning based on traditional non-scientific assumptions is creating continuously not only more transport problems, but also environmental and social as well as economic problems all over the world, where these principals are applied. Urban transport planning in Europe, understanding the transport system and the solutions are presented in this paper.     

炼钢厂成本分析信息系统的开发设计

文章介绍了包钢炼钢厂生产管理信息系统中成本分析子系统的可行性分析以及具体的数据归集流程,详细介绍了该系统的开发环境以及该系统的模块和数据库的结构、功能及其具体的设计思想;简要介绍了Oraele Develop数据库开发应用的一些特点.     

漫谈钢铁企业用空分装置的流程选择

钢铁企业的氧气厂要深入了解本企业的用氧情况及周边市场的需要，据此确定拟新增空分装置的设计参数，选定最适宜的空分流程。探讨了空分流程选择时要考虑的几个方面。介绍了一种对空分装置的投资和长期运行费用之间进行经济性分析的定量计算公式，并得出了四点结论。     

500kW以下发电机组常见励磁故障及处理

通过对500kW以下水轮发电机励磁系统使用中常见典型故障结合实际进行深度分析,提出处理方法和整改措施.