Excel表格在某机械加工企业化学因素检测数据分析中的应用

Application of Excel on data analysis for chemical hazards in a machinery processing enterprise

目的采用Excel表格对化学因素检测数据进行统计分析,绘制统计图进行可视化呈现,提出基于数据统计分析的防护措施对策。方法将2012—2015年某机械加工企业的化学因素检测数据录入Excel表格,建立信息表。将职业接触限值导入Excel表格形成数据库。利用Excel表格的计算功能进行数据的自动查找、转换和统计分析。对化学因素的检测结果采用接触限值比(检测结果/接触限值)进行归一化处理以便于进行统计分析。根据职业病危害因素的数据统计分析结果,提出相应的职业病危害防护措施对策。结果 2012—2015年TWA接触限值比平均值前三位依次为电焊烟尘(0.75)、砂轮磨尘(0.40)、石墨粉尘(0.40),有毒化学物质基本在0.1以下;2012—2015年粉尘EL超限倍数接触限值比平均值前三位依次为电焊烟尘(0.44)、石墨粉尘(0.35)、砂轮磨尘(0.27),有毒化学物质均在0.11以下;2012—2015年C-MAC的有毒化学物质接触限值比平均值均在0.11以下。结论根据统计图表呈现的结果,该企业职业暴露程度较高为生产性粉尘,其中以电焊烟尘的职业接触程度最高。

To analysis the chemical hazards test data statistically by Excel with a chart visualizing the data, and provide the basis for preventative countermeasures. Methods Excel was used to entry test data of chemical hazards from 2012 to 2015 in a certain machinery processing enterprise, and establish entry information form, database was formed by entering occupational exposure ratio. Calculation function of Excel was uses to make automatic search, conversion and statistical analysis of data. The test results of chemical factors were normalized by contact limit ratio （test result/contact limit） for statistical analysis. According to the data statistic analysis results of the occupational chemical hazards, the countermeasure of the corresponding occupational disease prevention measures was put forward. Results The top three TWA exposure limit ratio from 2012 to 2015 were welding fume（0.75）, grinding wheel grinding dust（0.40）, graphite dust（0.40）.The TWA exposure limit ratio of toxic chemicals were all below 0.1. The top three EL exposure limit ratio from 2012 to 2015 were welding fume（0.44）, graphite dust（0.35）, grinding wheel grinding dust（0.27）. The EL exposure limit ratios of toxic chemicals were all below 0.11. The limit ratio of toxic chemicals from 2012 to 2015 were all below 0.11. Conclusion According to the statistical analysis, the high exposure degree chemicals of was industrial dust, among which the welding fume had the highest exposure degree.