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

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

Kinetic analysis for effect of initial substrate concentration on growth and secondary metabolite production in cultures of Nicotiana tabacum

Suspension cultures of tobacco cells were studied using airlift and rotary-drum bioreactors. The effect of initial concentrations of a major substrate, sucrose, on the growth and production of a secondary metabolite, phenolic compounds, was investigated. The dry weights and total concentrations of the phenolic compounds increased with the initial sucrose concentration in both bioreactors. Both bioreactors were found to have the same tendency for the effect of initial sucrose concentration. The structured model, presented previously was modified by considering that sucrose was hydrolyzed to glucose and fructose by an enzymatic reaction. The previous and the new models were applied to the above two sets of experimental data obtained with two bioreactors, independently. The hydrolysis of sucrose was elucidated to contribute slightly to the overall kinetics of growth and secondary metabolite production in these cultures. Furthermore, the levels of shear damage in each bioreactor were quantitatively compared based on the death rate constant, k_i, which is one of the model constants.     

Atmospheric Freeze Drying—Modeling and Simulation of a Tunnel Dryer

Drying is an important unit operation in processing of foods and other biotechnological products. Vacuum freeze drying is said to be the best drying technology regarding product quality of the end product, but the disadvantages are, among others, expensive operational costs and batch drying. Atmospheric freeze drying was introduced to lower the production costs of high-quality dried foods, and the need of simulation tools became important in estimations of the industrial drying processes.

A simplified mathematical model (AFDsim) is developed based on uniformly retreating ice front (URIF) considerations. The model is used to calculate theoretical drying curves of atmospheric freeze dried foods in a tunnel dryer. Studies of thermal and mass transfer properties during drying are essential for understanding the changes in product quality and for designing and dimensioning the drying process. The model can be used to simulate industrial atmospheric freeze drying of different foodstuff in a tunnel. The results from AFDsim modeling are in good accordance with the experimental results.     

Characterizing Performance Variation of Product Designs

Quality and reliability design practitioners have utilized Taguchi's methodology of matrix experimentation to generate computer simulation data for characterizing performance variation of product designs. However, the sampling strategy employed renders computer implementation of matrix experimentation cumbersome and statistically invalid. Weaknesses of this approach also include sample size limitation and overestimation of performance variation. An alternative approach that combines Monte Carlo simulation with the strategies of independent sampling across runs and correlated sampling between runs is presented. An application case study shows that the proposed approach constitutes an improvement on the matrix approach with respect to statistical validity and estimation accuracy.     

石英砂的相变与换向器套筒铸件的变形

用呋喃树脂石英砂工艺生产牵引电机换向器套筒出现变形、裂纹等铸造缺陷,是由石英砂相变膨胀引起,后用高铬刚玉砂代替石英砂得到解决.     

提高磷酸二铵产品质量方法浅析

针对磷酸二铵(DAP)产品养分波动大、含水量偏高、易结块、颜色变化大等缺点,在生产过程中采取了相应的解决措施,如配矿、联产、设备改造、工艺指标调整等,使DAP装置不仅保持了原有的优点,而且产品质量问题也得到了有效解决。养分基本保持在64.0%~64.6%,水分下降到2.1%~2.2%,结块现象较少,颜色也比较统一。     

Surface Areas of Nitrated Hydrotalcites

Hydrotalcites in the nitrate form were prepared using microwave irradiation in the hydrotreatment step. The surface area (BET) of nitrated hydrotalcites was evaluated. Solids were characterized by atomic absorption, X-ray diffraction and BET analysis. Thermal pretreatment temperature determined the surface area of the hydrotalcites.     

Influence of the composition of the binder and the carbonation on the zeta potential values of hardened cementitious materials

Electroosmotic experiments have been carried out on eight different mixes of hardened cementitious matrixes including concrete, mortar and pastes, different types of binders, carbonated and non-carbonated specimens and different test conditions. From these trials, the zeta potential values have been determined and the optimum experimental parameters and devices have been established. In addition, the influence of the composition of the binder on the zeta potential has been quantified indicating that higher amounts of Al₂O₃ in the binder lead to higher positive values of zeta potential, while the SiO₂ acts just on the opposite side. This has been explained in terms of the different i.e.p. (isoelectric point) for both oxides. Concerning the influence of carbonation, it increases the absolute value of the zeta potential toward more negative values; this behaviour has been attributed to the influence of the specifically adsorbed Ca²⁺ in the negative sites of the surface in the non-carbonated samples.     

Effect of mixing leaves with olives on organoleptic quality of oil obtained by centrifugation

Variable quantities of leaves were added to ripe olives prior to extraction to determine their effect on the quality of the resulting olive oil. The addition of 1–3% w/w leaves improved the organoleptic quality. An increase intrans-2-hexenal aldehyde content occurred, giving the pleasant flavor of “freshly cut grass.” This compound was produced by the enzymatic breakdown of 13-L-hydroperoxide of linolenic acid in leaf homogenates.     

基于现场总线的油品添加剂生产监控系统的设计

油品添加剂在工业中的应用越来越广泛,加入油品中能显著改善油品原有性能或赋予油品某些新的品质。介绍了油品添加剂的生产控制要求,通过对三合仪表自主研发的SHCAN2000系统以及FIX组态软件资料的查阅,设计一套基于现场总线的油品添加剂生产监控系统。