The Neusoft MNL Attendance Management System is a comprehensive Streamlit web application designed to automate the management and organization of attendance data for Neusoft employees. Utilizing data produced by DingTalk, this application transforms raw attendance data into a clear, understandable, and downloadable format. The system simplifies the attendance data management process, making it more efficient and less prone to human error.
- Data Transformation: Converts raw attendance data into an easily understandable and manageable format.
- Master List Integration: Merges attendance data with the master employee list for comprehensive management.
- Schedule Processing: Incorporates employee schedules to accurately apply attendance codes.
- Custom Filters: Offers customizable filters for employee name, LOB, shift, site, leader, and employer for targeted data analysis.
- Data Visualization: Visualizes multiple logs and missed punches with progress columns for easy understanding.
- Downloadable Reports: Allows for the downloading of processed attendance data in Excel format, complete with styled cells for better readability.
- Upload Files: Upload the required Excel files for attendance raw data, master list, and schedule through the provided file uploaders.
- Data Processing: Once all files are uploaded, the application processes the data, merging the attendance with the master list and applying the necessary codes based on the employee schedule.
- Customization: Use the sidebar to filter the displayed data according to specific criteria such as employee name, LOB, shift, among others.
- Visualization: Analyze the processed data through the visualization of multiple logs and missed punches. The application uses progress columns for a clear representation of the data.
- Download: Finally, download the processed and styled attendance data in Excel format for offline analysis or record-keeping.
If you have any feedback, please reach out to John Paul Curada.
