对JB/T7510-1994工艺参数优化方法正交试验法示例的改进

对本标准4个正交试验示例的数据分析,突破了常规的极差分析、方差分析,巧用EXCEL的"回归"和"规划求解"模块,以获得显著改进.如以回归带出方差分析结果;在回归基础上用规划求解选优;根据趋势图分析因子的形态、交互作用并恰当变项等.     

利用EXCEL辅助机房运行环境分析

机房运行环境的正常与否,将直接影响到机房各项业务能否正常开展,本文介绍了如何在机房巡检的基础上利用EXCEL来及时分析环境参数的异常变化,使机房运行环境处于良好的状态     

基于EXCEL的内燃机排放计算程序开发

根据ISO8178国际排放测量标准,介绍了基于EXCEL软件开发的内燃机排放计算程序。该程序适用于直采式排放测量的结果计算,通用于大多数稳态排放测试循环,方便内燃机工作者用来进行排放结果计算和排放控制预测。     

Expanded reliability-based design of piles in spatially variable soil using efficient Monte Carlo simulations

Inherent spatial variability is considered as a major source of uncertainties in soil properties, and it affects significantly the performance of geotechnical structures. However, research that considers, directly and explicitly, the inherent spatial variability in reliability-based design (RBD) of geotechnical structures is limited. This paper develops a RBD approach that integrates a Monte Carlo Simulation (MCS)-based RBD approach, namely the expanded RBD approach, with random field theory to model, both directly and explicitly, the inherent spatial variability of soil properties in RBD of drilled shafts. The proposed approach is implemented in a commonly-available spreadsheet environment to effectively remove the hurdle of reliability computational algorithms and to provide a user-friendly graphical user interface to practicing engineers. To improve the efficiency and resolution of MCS at small probability levels, the expanded RBD approach is enhanced with an advanced MCS method called “Subset Simulation”. Equations are derived for the integration of the expanded RBD approach and Subset Simulation. The proposed approach is illustrated through a drilled shaft design example, and is applied to explore the effects of inherent spatial variability (including the scale of fluctuation and correlation structure) and to evaluate systematically the equivalent variance technique that is commonly used to indirectly model inherent spatial variability in current RBD approaches. It is found that inherent spatial variability significantly affects the RBD of drilled shafts, and its effects are considered in RBD using the proposed approach in a direct and explicit manner. In addition, the results show that the indirect modeling of inherent spatial variability using the equivalent variance technique with the simplified form of variance reduction function in RBD might lead to relatively conservative designs in design practice.     

“锅炉原理”课程设计模式的改革与实践

锅炉课程设计是"锅炉原理"课程体系中重要的组成部分。通过手工热力校核计算与在EXCEL中做验证性计算相结合这一创新模式,达到了课程设计的教学目的,获到了较好的教学效果。     

浅谈土建工程量的快速计法

在预算工作实践中掌握工程量计算的内在规律,只要是适合自己在业务上处理的方式和习惯,而又能快速、准确地计算工程量,就是最好的计法。     

EXCEL2000在理化检验中的应用

本文阐述了在理化检验中应用EXCEL 2000进行检验数据回归分析、结果计算及应用其数据库功能登记管理样品,出具检验报告,还可应用该软件进行大量实验数据分析。     

用EXCEL计算玻璃配合料

简要介绍了EXCEL软件的应用功能,剖折了配合料的计算过程,详细说明了与以往配合料计算程序相比用EXCEL进行浮法玻璃配合料计算的优越性.     

EXCEL的几点使用技巧

随着EXCEL的不断普及,人们往往会遇到一些特殊需求,本文简单介绍了自动操行、特殊复制、共享工作表等功能.     

巧用Excel实现勘察数据共享与统计分析

针对目前岩土工程勘察软件在勘察数据处理中存在的不足，提出巧用Excel(电子表格软件)来实现对勘察数据的数据共享与统计分析，从而克服目前岩土工程勘察软件的缺陷和满足工程师们处理勘察数据时的独特要求，减轻其工作量；并建议在勘察报告中用相关图表来直观显示总体勘察数据，便于人员间对勘察成果的理解与交流．