电子表格EXCEL5.0在选煤线性规划问题中的应用

采用电子表格软件ＥＸＣＥＬ５．０可以方便地解决许多选煤生产中的线性规划问题。本文通过选煤过程线性规划实例介绍ＥＸＣＥＬ５．０在此领域的应用方法。     

SQL语言中量词和空值的使用技术

在ＳＱＬ语言中可以引入全称量词符号ＦＯＲＡＬＬ，使ＳＱＬ语言使用更为自然，方便。本文讨论全称量词，存在量词和ＡＬＬ三种谓词之间的转换，联系和区别，以及空值存在时ＳＱＬ的使用技术。     

Dynamics of Solidification in 2% Corn Starch-Water Mixtures: Effect of Variations in Freezing Rate on Product Homogeneity

Directional solidification studies of gelatinized corn starch-water mixtures were undertaken in order to examine, in situ, the freezing behavior of this food model. The solidification rate was controlled by varying sample cell velocity as it moved from a 25°C hot stage to a -25°C cold stage. While freezing at cell velocities ≤7.5 μm/sec, starch granules were alternately pushed or entrapped by the advancing solid-liquid interface producing a segregated structure consisting of alternating high-starch and low-starch bands. At a cell velocity of 10 μm/sec, the frozen product was homogeneous. The relationship between the solid-liquid interface velocity and segregation behavior was quantified and compared to an existing model of particle-interface interactions.     

浅谈湖滨带生态恢复建设工程施工监理的特点

指出湖滨带是连接湖泊水体和陆地的一个功能过渡界面区。它作为生物的重要栖息地,具有净化水质、缓解波浪等多种功能。因此,对湖滨带实行生态恢复建设,应予以高度的重视。笔者通过具体工程的实践,阐述了湖滨带生态恢复建设工程的特点、施工阶段的监理工作,以及对监理人员的素质要求,可供类似工程借鉴、参考。     

浅谈水泥基渗透结晶型防水材料标准及性能指标

针对GB18445-2001《水泥基渗透结晶型防水材料》标准在使用过程中发现的一些问题，对标准中的部分性能指标的确定及试验方法提出修改意见。     

水生生物环境诊断(AOD)技术应用研究

介绍一种新型的毒性试验方法——水生生物环境诊断(AOD)技术，该方法将冷冻浓缩和生物测试技术有机地相结合，较好地解决了低毒性水体的毒性测试问题。应用本项技术以红鳍鱼为受试生物，分别对湖北武汉马伧湖、墨水湖、广东深圳河、长江干流寸滩等几个断面、丹江口水库白河、丹江河口、老灌河等不同水体进行AOD测试，所得48hr-LC\-50结果与实际水质状况基本相符。     

根本技术创新产品需求的获取及评价研究

根本技术创新对企业的发展具有决定性的意义。并对工程作为现代产品开发中新发展的系统化方法，在应用其对根本技术创新产品需求搜集及评价时，出现了满足顾客需求和创造顾客需求、资源需求与技术创新、理性决策与非理性决策、企业文化与技术创新等之间的矛盾。本文对产生这些矛盾的原因进行了分析，提出了相应的解决办法。     

成品油汽运发货系统的研究与开发

介绍成品油传统汽运发货流程.指出其中的弊端,提出采用计算机网络化管理的思路,并对计算机成品油汽运发货系统的优点和功能进行了介绍,然后详细讨论了该系统的开发过程和功能实现,最后提出改进和发展方向。     

Influences of land use/cover on water quality in the upper and middle reaches of River Njoro, Kenya

Data from 10 sampling sites along the River Njoro are used to examine the contribution of nutrients from upstream land uses draining each of the sampling sites. The data also are used to assess whether both the proportion of land uses and the size of the subwatersheds account for the variability in water quality in the River Njoro watershed. Geographical Information System analysis was used to determine the spatial distribution of land‐cover types and subwatersheds contributing run‐off to the sampling sites in the River Njoro. Standard Digital Elevation Model‐based routines were used to establish the watershed area contributing run‐off to each sampling site. Water and sediment samples were collected for chemical analysis, and the nutrient levels were related to the upstream land‐use types and the size of the subwatersheds. The mid‐stream portion of the River Njoro (near Egerton University) accounts for the highest nutrient contributions. The percentage contribution is magnified by additions from industrial, human settlements and agricultural land uses around the University. There is a significant decrease in nutrient levels downstream, however, indicating natural purification as the river flows through an area of large‐scale farming with intense, well‐preserved riparian and in‐stream vegetation. Steep slopes of the land upstream of Egerton University enhance erosion and nutrient losses from those subwatersheds. Mixed small‐scale agricultural and bare lands contribute over 55% of the phosphorus load to the upper and mid‐reaches of the River Njoro. The size of the subwatershed accounts for about 53% of the variability in the soluble phosphorus in the river. The land‐use subwatershed proportions are important for characterizing and modelling water quality in the River Njoro watershed. Upland land uses are as important as near‐stream land uses. We suggest that conservation of intact riparian corridor along the river and its tributaries contributes significantly to natural purification processes and recovery of the ecological integrity of the River Njoro ecosystem.     

易逝品联合采购订货决策分析

采购联盟成员间的信息不完全,彼此均以对方的期望需求作为对方实际需求的估计.针对易逝品的特点,提出了调剂价格的特殊约束条件并建立了联盟期望利润模型,最后进行了数值仿真.研究表明:联合采购使联盟总体利润得到改善,但不能使联盟成员的利润都得到改善.