Employee-Tracker ver. 3 (Excel)

MS Excel Employee-Tracker Spreadsheet

Company: Frost-Design LLC’s Problem Statement

Problem Statement:
We need a Fix for the problem of difficult to maintain Spreadsheet by Adding Automation and Data Entry Forms.

Frost-Design employs between 50 to 150 Employees on a seasonal basis. They take Product Orders year-round but only manufacture (6) Months out of the year, and the bulk of the Product Deliveries are from from April through late June.

Frost-Design use a plain Microsoft Excel Spreadsheet to track the following…, Employee Data, Salary, Hours, Sick-Time, Vacation and more.

ITHDS’s Solution:

ITHDS was tasked with how to make the current Employee Spreadsheet easier to use and off-load most of the maintenance and updating of the Spreadsheet to automation and select End-Users.
Currently the Spreadsheet has 20 plus columns that lack validation when updating, and is error prone due to the linear Scrolling back and forth when entering Data.
The Owner, his Wife a couple of trusted Employees have to update the Spreadsheet by going to each Employee an or copying information from another Excel Time-Sheet Spreadsheet on a daily and weekly basis.
Also the use use of the term Employee is misleading since the Company intermingles actual Employees, with Consultants, and Contractors as entries in the Spreadsheet.
The Owner would like to track Labor Cost ant Time and Time Off, and Vacation per Employee and Department

Frost-Design’s Current Spreadsheet

Please be advised that the data within this Blog/Excel Spreadsheet has been scrubbed and does not represent real people
This solution is for Educational purposes and its Data contents as it relates to actual people are fictional. Any resemblance to real life figures, characters and or personal identifiable information is purely coincidental!