| 利用Excel的自定义公式进行原料配料 |
| |
| 引用本文： | 魏元芳,徐江涛. 利用Excel的自定义公式进行原料配料[J]. 水泥工程, 2011, 0(3): 34-37 |
| |
| 作者姓名： | 魏元芳 徐江涛 |
| |
| 作者单位： | 山东东华水泥有限公司,山东淄博,255144 |
| |
| 摘 要： | 利用Excel最简单的自定义公式功能,根据尝试拼凑法的原理来进行原料配料计算。详细介绍了其计算步骤以及利用Excel自定义公式计算的具体设置方法。一般试凑两、三次即可得到所需要的三率值控制目标值,此方法简便易懂。
|
| 关 键 词： | Excel 自定义公式 原料配料 尝试拼凑法 三率值 |
Proportioning raw material by the user-defined formula function of Excel |
| |
| Nei Yuanfang,Xu Jiangtao. Proportioning raw material by the user-defined formula function of Excel[J]. Cement Engineering, 2011, 0(3): 34-37 |
| |
| Authors: | Nei Yuanfang Xu Jiangtao |
| |
| Affiliation: | Wei Yuanfang,Xu Jiangtao(Shangdong Donghu Cement CO.,Ltd.,Zibo,Shangdong,255144) |
| |
| Abstract: | According to the principle of trial-and-error method, proportioning the raw material by the user--defined formula function of Excel. And the calculation steps were introduced in detail as well as the concrete setting methods of Excel user-defined formula. Generally, the ideal proportion scheme meets the requirement of designed modulus would be obtained by two or three times of trying, which proves it is a simple method. |
| |
| Keywords: | Excel user-defined formula raw material proportion trial-and-error method three modulus |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
