使用Excel和Visual Basic for Applications（VBA）开发了一个综合分析模型，用于模拟交通制冷和公交车空调系统的生命周期气候性能（LCCP）。LCCP模型包括制冷剂排放的直接影响、用于运行制冷和/或冷却系统的能源消耗的间接影响，以及制造和安全处置装置和制冷剂的能源。制冷运行的年能耗或燃油消耗量由一个动态链接库（DLL）文件计算，该文件从MATLAB（R）程序转换而来，使用详细的输入，包括应用、箱体结构、运行计划、天气数据等。通过适当的输入，该程序可以评估各种应用系统的LCCP，包括拖车和卡车制冷，海运集装箱制冷和公交车空调。它可以处理现有的或新的技术，如独立发动机或卡车发动机轴驱动装置、交流发电机装置，以及使用热能或电能存储的混合系统。 本文介绍了使用该工具的方法、Excel程序和模拟结果示例。引文:ASHRAE论文CD:2014 ASHRAE年会，华盛顿州西雅图

A comprehensive analytical model using Excel and Visual Basic for Applications (VBA) was developed to simulate life cycle climate performance(LCCP) for transport refrigeration and bus air conditioning systems. The LCCP model includes the direct impact of refrigerant emissions, theindirect impact of energy consumption used to operate the refrigeration and/or cooling system, and the energy to manufacture and safely dispose of theunit and refrigerant. The annual energy or fuel consumption for refrigeration operation is calculated with a dynamic link library (DLL) file convertedfrom a MATLAB(R) program using detailed input including the application, box structure, operation schedule, weather data, etc. With appropriateinput, the program can evaluate the LCCP of various application systems including trailer and truck refrigeration, sea-going container refrigeration,and bus air conditioning. It can handle existing or new technologies such as independent engine or truck engine shaft driven units, alternator units,and hybrid systems using thermal or electricity storage. This paper introduces the methodology, the Excel program, and sample simulation resultsusing the new tool.