|
The Stick
Join Date: Dec 2007
Location: Someplace Safe?
Posts: 17,328
|
We have an employee meeting once a month. Since we currently have over 600 employees they have to break the meetings up into 4 separate groups. They have been changing which departments go to which meeting. Today they've tried to revise this month's meeting assignments 3 times so far. They keep including at least two departments in more than one meeting. The last iteration is exactly the same as last months schedule. I think they just gave up.
Each week I get an Excel spread sheet of all the current employees from the HR department. It includes their department and which shift they work. I put the list in a database and update it with exports from Office365 and Adobe to include what licenses for email, office, crm, creative apps, etc. are being used and where for out department. I could easily make a report in my database to list how many users are in each department and what shift. Then it would be pretty easy to choose the meeting assignments to make sure the employees were distributed equally between the meetings. My guess they are trying to use Excel to do the job of a database.
__________________
Richard aka "The Stick"
06 Cayenne S Titanium Edition
Last edited by RKDinOKC; 03-13-2017 at 03:34 PM..
|