中小型冷库CAD和Excel 5.0

Medium and Small Cooling Store CAD and Excel 5 0

本文采用Ｅｘｃｅｌ５０和ＡｕｔｏＣＡＤ１２相结合的方法来研究中小型冷库计算机辅助设计。软件采用ＶＢＡ和Ｅｘｃｅｌ４０宏语言对工程计算和数据传递到ＡｕｔｏＣＡＤ制图进行编程，并采用ＤＤＥ功能来连接Ｅｘｃｅｌ和ＡｕｔｏＣＡＤ。软件包括了中小型冷库设计的整套设计方法，步骤，计算公式及说明，和庞大的数据库，并能参数化设计生成全套平面图，系统图和设备安装图。本文还提出了采用Ｅｘｃｅｌ编程计算制冷剂热力性质的方法。

The study of the computer aided design for medium and small cooling stores is carried by using the method of combining Excel 5.0 with Auto CAD 12. The engineering calculation, transferring of data and drawing were programed by using Visual Basic for Application and Excel 5.0 Macro Language, with the linkage of Excel and Auto CAD finished by the DDE function in Microsoft Windows. There are complete design method, procedures,calculating formulas and its specifications,and a huge data base in the software which provides parametric designs and a set of drawings of site, system and equipment installation. The methods of calculation the thermodynamic properties of NH 3 are also presented.