Embedded Files
A business uses Excel to schedule employee meetings with clients. Employees want to fill out the schedule from their perspective, but managers want to view the final schedule from the perspective of clients.
This scheduling process is completed once a week for hundreds of employees and clients. There were no simple solutions using only Excel. Manually processing the schedule took several hours each week and was prone to errors.
Input
Input
Days of the week along columns, employees and time of day along the rows, and client names in the cells. The first row contained the word "Schedule".
Desired Output
Desired Output
Days of the week along columns, client names and time of day along the rows, and employees in the cells. Double-booked clients had multiple employees in the same cell.
Solution
Solution
Data Dot Plus developed a simple web application (LINK) to upload, invert, and download the schedule. Employees and managers are both able to work with the schedule in their preferred format.
The web app was developed with no up-front cost and is available for a low monthly fee of $10 / month.
Contact Data Dot Plus today for a free consultation: Contact
Page updated
Google Sites
Report abuse