职业健康检查完成之后,要出具一份体检报告,通常将每个人的个人信息、体检结果录入并给出处理意见,常把检查结果录入同一栏中(即每人一条记录),这个字符串中包含了多个需要统计的项目,且内容的多少、格式不一,不便使用专业的统计软件对数据进行统计,而使用EXCEL中集成的Visul B After the completion of the occupational health examination, a medical examination report should be issued. Each person’s personal information and medical examination results are usually entered and given opinions. The examination results are usually entered in the same column (that is, one record for each person). In this string Contains a number of items that need statistics, and the content of the number of different formats, inconvenience to use professional statistical software for data statistics, and use EXCEL integrated Visul B