Your cart is currently empty!
Excel – Employee Tracker Spreadsheet
Excel: “VBA” Overhaul of plain “Employee” Spreadsheet with added functionality.
Employee Tracker MS Excel Help
Problem Statement:
Make the current Employee Spreadsheet easier to use and off-load most of the maintenance and updating of the Spreadsheet to to End-Users. Currently the Spreadsheet has 20 plus columns that lack validation when updating is error prone due to the linear Scrolling back and forth.
Currently the Owner and or his Wife has to update by going to each Employee an or copy information from another Time Sheet Spread sheet on a weekly basis.
Also the use use of the term Employee is misleading since the Company intermingles actual Employees, 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
Summary:
Customer of a Small Manufacturer that supplies Educational and Promotional materials to a major metropolitan Public School System. This Company employs between 50 to 150 Employees on a seasonal basis. They take Product Orders year-round and the bulk of the Product Deliveries are from from April through late June
Spreadsheet for Employees to Track Time, PTO, and Sick-Time.
⦁ Create individual Time sheet for Employees in Shared Folder with Authentication
A little Video Snippet of the new UserForm in action.!
Employee -Tracker
Solution
Customer’s original Table where Columns with “orange letters” represent the Added Columns
** Be advised that the Data is simulated /fake to facilitate sheet functionality and testing.
Our First Draft for Client Testing.
Created VBA ‘UserForms’, to allowed for consistent control over Job Titles, Departments,
Frost-Design LLC’s Problem Statement
Make the current Employee Spreadsheet easier to use and off-load most of the maintenance and updating of the Spreadsheet to to 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.
Currently the Owner and or his Wife have to update the Spreadsheet by going to each Employee an or copy information from another Excel Time-Sheet Spreadsheet on a weekly basis.
Also the use use of the term Employee is misleading since the Company intercomigles actual Employees, 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
Solution Design Offered by ITHDS
Add Custom Data Entry Forms with validation Fields to reduce errors.
⦁ Add Additional Fields to Help with Data Collection
⦁ Create Menu driven Interface system to control Access to Spreadsheet.
⦁ Add dynamic List to assist with Data Entry
⦁ Add Rules Based Access to Spreadsheet.
⦁ Add Charts for High-Level Views of Employees by Department, Employees By Shift,
and Employees by Status/Type.
⦁ Create Satellite Spreadsheets with Data connection back to the Employee-Tracker Spreadsheet for Employees to Track Time, PTO, and Sick-Time.
⦁ Create individual Time-sheet(s) for Employees in Shared Folder with Authentication.
Need Help Like this…., ?
Absolutely, it’s possible. Reach out to our tech support team to Open a Ticket for assistance. The Cost is around $99 per Upgraded Spreadsheet of 40 Columns or less, and commensurate at a Rate of 10 Columns at $50 per additional 10 Columns. Additional Fees apply for Formula Complexity beyond basic Math of Sum, Avg, Percent, Etc.
Looking to get your Spreadsheet Upgraded
Do You want Help with your Spreadsheets further?
If So…, Go to our HelpDesk Page and Open a Ticket and Select Excel for the Ticket Type and
fill-out the Form with Details explaining your Spreadsheet and then attach a Copy of your current Spreadsheet
that you require Help.
Please be sure “Not” to include Personal info like SSN#, Drivers Licenses, Etc.
Leave a Reply