基于Excel的层次分析法及化工企业危险性分析应用

Excel-based Analytical Hierarchy Process and Application of Risk Analysis of Chemical Companies

为了对化工企业的危险性进行综合评价分析,基于层次分析法构建了符合实际的化工企业危险性指标体系。这个体系包括3个子体系,它们分别涉及企业自身安全状况、企业安全管理状况和周边区域安全状况3个方面。同时,针对层次分析法计算的不足,运用Excel巧解层次分析,编制了相应的计算表,使得权重计算快捷准确。结果表明,企业自身安全状况和企业安全管理状况在化工企业危险性中占有较大权重,为企业降低危险性提供了一定的理论支持。

In order to carry out the risk of chemical enterprises comprehensive evaluation and analysis,the risk index system was constructed in line with the actual chemical industry based on AHP.This system consists of three sub-systems,which are involved in their own security,enterprise security management status and surrounding regional security situation three aspects.Meanwhile,for the lack of AHP calculated using ExcellSolving level analysis,the preparation of the corresponding statement,making fast and accurate weight calculation.The results show that the security situation and their own corporate safety management have a large weight in the chemical business risk,in order to reduce the risk of the enterprise to provide a theoretical support.