CAJ | 학술논문

指纹考勤数据往往由于人事单位制定的打卡规则和用户行为发生的不同呈现“多、乱、脏”、有价值数据较少的特点。进行数据统计处理时，需要先对数据进行清洗、抽取、转换等一系列预操作。鉴于EXCEL的通用性和强大的数据处理能力，本文提出了一种基于EXCEL的考勤数据处理统计方法。该方法具有普适性、易操作的特点。
지문고근수거왕왕유우인사단위제정적타잡규칙화용호행위발생적불동정현“다、란、장”、유개치수거교소적특점。진행수거통계처리시，수요선대수거진행청세、추취、전환등일계렬예조작。감우EXCEL적통용성화강대적수거처리능력，본문제출료일충기우EXCEL적고근수거처리통계방법。해방법구유보괄성、역조작적특점。
Due to the unit different rules and user personnel behavior ,the Fingerprint attendance data often renders more , messy , dirty and less valuable .When statistic and processing the data, need to a series of pre operation—clean , extraction, con?version and so on. Based on the universality and powerful data processing ability of the EXCEL, this paper proposes a method of attendance data processing based on EXCEL. This method has the characteristics of universality, easy to operate.