Purpose of project is to generate a user friendly excel interface to create & manage an employee listing (csv format) as a data source for rostering software. This file would be maintained & updated by multiple managers.
Data fields : (see attached csv file)
- Employee Id :
- Name :
- Start Date :
- Employement type :
- Primary Position : department / job title / position ID
- Secondary positions (up to 25) : department / job title / position ID
ROSTER PREFERENCES :
- Prefered Time : By Day of week (e.g Sun 0800-16:00)
- Available TIme : By Day of week (e.g Sun 0800-16:00)
- Inconvenient Time : By Day of week
Addtional Details :
> approx 30 departments with on average 5 positions per department . Multiple employees have same position. Business has approx 400 associates.
> positions able to be selected varies by department.
> it would be good if only "admin" user could create & delete associates, ammend positions & department details.
> automatic backup important.
> needs to work in Excel 2003 & 2010.
46 freelancers are bidding on average $395 for this job
I have developed many macros in excel in my company to automate various tasks and also providing training to my colleagues on how to develop vba macros in excel. I will by happy to develop this for you.