Norwegian Association of Refrigeration Meeting in Oslo,March 13th 2014 Excel中的计算参数 专为制冷循环设计的计算工具 附带在Excelr中的示例计算 ·RnLib给出制冷剂的热力学数据 HxLib给出湿空气的热力学数据 KbLibs给出载冷剂的热力学数据 Trygve M.Eikevik Professor Norwegian University of Science and Technology (NTNU) trygve.m.eikevik@ntnu.no http://folk.ntnu.no/tme
Excel 中的计算参数 专为制冷循环设计的计算工具 附带在Excel中的示例计算 Trygve M. Eikevik Professor Norwegian University of Science and Technology (NTNU) trygve.m.eikevik@ntnu.no http://folk.ntnu.no/tme Norwegian Association of Refrigeration Meeting in Oslo, March 13th 2014 • RnLib 给出制冷剂的热力学数据 • HxLib给出湿空气的热力学数据 • KbLib给出载冷剂的热力学数据
安装： 创建下面的文件： C://kktdlls/bin 下面的文档必须被复制到上面创建的文件夹： KKTserver (应用文件-exe文件) Master-Sheet (使用的excel文件) 。ibgcc s dw2-1.dl (应用扩展) libstdc++-6.dll (应用扩展) 所有的新计算必须通过打开kMaster-Sheet>》开始，复制工作表. 不要直接通过程序开启excel,,通过双击文档打开
安装: 创建下面的文件: C://kktdlls/bin 下面的文档必须被复制到上面创建的文件夹: • KKTserver (应用文件-exe文件) • Master-Sheet (使用的excel文件) • ibgcc_s_dw2-1.dll (应用扩展) • libstdc++-6.dll (应用扩展) 所有的新计算必须通过打开«Master-Sheet»开始，复制工作表. 不要直接通过程序开启excel,通过双击文档打开
RnLib-在Excel中的计算公式 ·通过“=”导出计算公式 ·示例： -R_cpgasTP Cp=R_cpgasTP(kR717w;25,0,857077,6) ·R表示计算的是制冷剂的相关参数 ·制冷剂的代号（必须大写） ·cpgas:表示是气体状态的cp ·TP:T(摄氏度)+P(帕斯卡)
RnLib – 在Excel中的计算公式 • 通过“ = ”导出计算公式 • 示例: – R_cpgasTP CP=R_cpgasTP(«R717»;25,0; 857077,6) • R_ 表示计算的是制冷剂的相关参数 • 制冷剂的代号(必须大写) • cpgas: 表示是气体状态的cp • TP: T (摄氏度) + P (帕斯卡)
Description of functions Function Ingoing values cp-比热 sat-饱和状态 Working fluid number dh-比蒸发潜热 gas-气体 T-温度 dv-饱和气体动力粘度 iq-液体 P-压力 h-比焓 1qgs-两相区 s熵 p-压力 x-两相区 H焓 s-比熵 max-最大值 V-体积 tc-热导率 min-最小值 X-干度 t-温度 crit-临界点 v-比体积 x-干度 所有单位都是标准S1单位： 压力： Pa 温度： oC 比焓： J/kg 比熵： J/kgK 比体积： m3/kg
Description of functions • cp- 比热 • dh- 比蒸发潜热 • dv- 饱和气体动力粘度 • h- 比焓 • p- 压力 • s- 比熵 • tc- 热导率 • t-温度 • v- 比体积 • x- 干度 • sat- 饱和状态 • gas- 气体 • liq- 液体 • lqgs- 两相区 • x- 两相区 • max- 最大值 • min- 最小值 • crit- 临界点 • Working fluid number • T- 温度 • P- 压力 • S- 熵 • H- 焓 • V- 体积 • X- 干度 Function Ingoing values 所有单位都是标准SI 单位: 压力: Pa 温度: oC 比焓: J/kg 比熵： J/kgK 比体积: m3/kg
一级制冷循环 1 2 4 又 3 EXCEL-example
一级制冷循环 2 4 3 1 EXCEL-example
二级制冷循环 1 2 3 4 8 又 7 6 5 EXCEL-example
二级制冷循环 3 6 5 4 8 7 1 2 EXCEL-example
Descriptions of functions in HxLib Functions Ingoing values Function name Unit Function call Ingoing parameters Enthalpy moisture air J/kg HX_H_trh 空气压力(Pa;实际温度(C相对湿度(%) J/kg HX_H_tx air pressure(Pa;actual temperature(oC;绝对湿度(kg/kg Relative humidity % HX RH_th air pressure(Pa);actual temperature(C);enthalpy (J/kg) % HX_RH_tt air pressure(Pa;actual temperature(oC;湿球温度(C) % HX RH tx air pressure(Pa);actual temperature(C);absolute humidity(kg/kg) Temperature C HX_T_hrh air pressure(Pa);enthalpy(J/kg);relative humidity(%) C HX_T_hx air pressure(Pa);enthalpy(J/kg);absolute humidity(kg/kg) C HX_T_xrh air pressure(Pa);absolute humidity(kg/kg);relative humidity(%) Dew point ℃ HX_Tdugg_trh air pressure(Pa);actual temperature(C);relative humidity(%) Specific volume m3/kg HX Vfukt_trh air pressure(Pa);actual temperature(oC);relative humidity(%) Specific volume m3/kg HX Vtoerr_trh air pressure(Pa);actual temperature(C);relative humidity(%) Absolute humidity kg/kg HXX_th air pressure(Pa);actual temperature(C);enthalpy(J/kg) kg/kg HX X trh air pressure(Pa);actual temperature(C);relative humidity(%)
Descriptions of functions in HxLib Functions Ingoing values Function name Unit Function call Ingoing parameters Enthalpy moisture air J/kg HX_H_trh 空气压力(Pa); 实际温度(oC相对湿度(%) J/kg HX _H_tx air pressure (Pa); actual temperature (oC); 绝对湿度(kg/kg) Relative humidity % HX _RH_th air pressure (Pa); actual temperature (oC); enthalpy (J/kg) % HX _RH_tt air pressure (Pa); actual temperature (oC); 湿球温度(oC) % HX _RH_tx air pressure (Pa); actual temperature (oC); absolute humidity (kg/kg) Temperature oC HX _T_hrh air pressure (Pa); enthalpy (J/kg); relative humidity (%) oC HX _T_hx air pressure (Pa); enthalpy (J/kg); absolute humidity (kg/kg) oC HX _T_xrh air pressure (Pa); absolute humidity (kg/kg); relative humidity (%) Dew point oC HX _Tdugg_trh air pressure (Pa); actual temperature (oC); relative humidity (%) Specific volume m3/kg HX _Vfukt_trh air pressure (Pa); actual temperature (oC); relative humidity (%) Specific volume m3/kg HX _Vtoerr_trh air pressure (Pa); actual temperature (oC); relative humidity (%) Absolute humidity kg/kg HX _X_th air pressure (Pa); actual temperature (oC); enthalpy (J/kg) kg/kg HX _X_trh air pressure (Pa); actual temperature (oC); relative humidity (%)
HxLib中的参数 t: 湿空气温度(c) t: 湿球温度(c) h: enthalpy (J/kg) rh: 相对湿度(%) V: 比体积(m3/kg) X: 干度(kg/kg dry air) tt: means:air temperature wet bulb temperature
t: 湿空气温度(oC) t: 湿球温度(oC) h: enthalpy (J/kg) rh: 相对湿度(%) v: 比体积(m3/kg) x: 干度(kg/kg dry air) tt: means: air temperature + wet bulb temperature HxLib 中的参数
Secondary fluids-KbLib Fluid number nr. Norwegian name English name Eutectic Eutectic temperaturee concentration (c) (weight % KB101 Vann Water KB110 Ammoniakk Ammonia -100 33 Glycols KB201 Etylenglykol Ethylene glycol(EG) -51 57 KB202 Propylenglykol Propylene glycol(PG) -50 60 Alcohols KB301 Etylalkohol Ethyl alcohol(EA) -118 93,5 KB302 Metylalkohol Methyl alcohol(MA) -116 87,7 Glycerol KB401 Glyserol Glycerol(GL) -47 67 Salts KB501 Kaliumkarbonat Potassium carbonate -37,5 40 KB502 Kalsiumklorid Calcium chloride -50 30,5 KB503 Magnesiumklorid Magnesium chloride -33 21,8 KB504 Natriumklorid Sodium chloride -21 23,4 KB505 Kaliumacetat Potassium acetate(KAC) -52 45 Fluid number is not an official number,but simplify the choice of medium
Secondary fluids - KbLib Fluid number nr. Norwegian name English name Eutectic temperaturee (oC) Eutectic concentration (weight %) KB101 Vann Water KB110 Ammoniakk Ammonia -100 33 Glycols KB201 Etylenglykol Ethylene glycol (EG) -51 57 KB202 Propylenglykol Propylene glycol (PG) -50 60 Alcohols KB301 Etylalkohol Ethyl alcohol (EA) -118 93,5 KB302 Metylalkohol Methyl alcohol (MA) -116 87,7 Glycerol KB401 Glyserol Glycerol (GL) -47 67 Salts KB501 Kaliumkarbonat Potassium carbonate -37,5 40 KB502 Kalsiumklorid Calcium chloride -50 30,5 KB503 Magnesiumklorid Magnesium chloride -33 21,8 KB504 Natriumklorid Sodium chloride -21 23,4 KB505 Kaliumacetat Potassium acetate (KAC) -52 45 Fluid number is not an official number, but simplify the choice of medium
Function name Unit Function call Ingoing parameters Specific heat J/kgK KB cp ttf Fluid number;temperature;freezing point J/kgK KB cp_tx Fluid number;temperature;concentration(%) Dynamic viscosity Pas KB dv ttf Fluid number;temperature,freezing point Pas KB dv tx Fluid number;temperature;concentration(%) Actual temperature oC KB t hx Fluid number;enthalpy;concentration(%) Thermal conductivity W/mK KB tc ttf Fluid number;temperature;freezing point W/mK KB tc tx Fluid number;temperature;concentration(%) Freezing point oC KB_tf_x Fluid number;concentration(%) Specific volume m3/kg KB v ttf Fluid number;temperature;freezing point m3/kg KB vtx Fluid number;temperature;concentration(%) Density kg/m3 KB rho tx Fluid number;temperature;concentration(%) Concentration % KB x tf Fluid number;freezing point Max temperature ℃ KB tmax Fluid number(gives maximum temperature) Min temperature C KB tmin Fluid number(gives minimum temperature) KB CoolantDe Fluid number name scrNO Fluid number KB CoolantDe Fluid number name scr Fluid number KB_GetAllNam Fluid number es Give a Fluid number-returns all number in the library
Function name Unit Function call Ingoing parameters Specific heat J/kgK KB_cp_ttf Fluid number; temperature; freezing point J/kgK KB_cp_tx Fluid number; temperature; concentration (%) Dynamic viscosity Pa s KB_dv_ttf Fluid number; temperature, freezing point Pa s KB_dv_tx Fluid number; temperature; concentration (%) Actual temperature oC KB_t_hx Fluid number; enthalpy; concentration (%) Thermal conductivity W/mK KB_tc_ttf Fluid number; temperature; freezing point W/mK KB_tc_tx Fluid number; temperature; concentration (%) Freezing point oC KB_tf_x Fluid number; concentration (%) Specific volume m3/kg KB_v_ttf Fluid number; temperature; freezing point m3/kg KB_v_tx Fluid number; temperature; concentration (%) Density kg/m3 KB_rho_tx Fluid number; temperature; concentration (%) Concentration % KB_x_tf Fluid number; freezing point Max temperature oC KB_tmax Fluid number (gives maximum temperature) Min temperature oC KB_tmin Fluid number (gives minimum temperature) Fluid number name - KB_CoolantDe scrNO Fluid number Fluid number name - KB_CoolantDe scr Fluid number Fluid number - KB_GetAllNam es Give a Fluid number – returns all number in the library