Create staffing sheet
Budget $250-750 CAD
Job Description:
I would like to create an employee staffing file (excel or open to recommendation) that can tell me where to staff each employee based on the following:
Background on job employees are working:
- employees work 4 days a week with 3 days off using the following shift schedules. Employee ID and shift schedule will be given but schedule days working or not working should change based on employee shift code below (DA, DL DC, etc)
Shift codes
1. DA - Sunday to Wednesday
2. DL - Saturday to Tuesday
3. DN - Thursday to Sunday
4. DC - Monday, Tuesday, Thursday, Friday
5. DB - Wednesday to Saturday
Requirement for file or sheet:
-badge ID# of employees (up to 100 employees). All employees will be scanned and IDs will auto populate in a sheet. That sheet will be used for employees present that morning. Therefore, file Requires Ability to edit employee sheet or auto populate it from another location
-jobs each employees can do that shift(given below 1-14 in example). Ability to add additional jobs.
Conditions:
- ability to place a category from 1 to 3 on each job can edit job category. Category 1 can be done only 2 days in a row and 3rd day must be different, category 2 can only be done 1 day in a row, category 3 job must be switched mid-day so these employees would do 1 job first half of the day and another job for second half and category 0 can be done multiple days in a row with no restriction.
- ability to request how many pers to staff into each job every day. For example, enter 10 for OP and only 10 personnel will be chosen for that shift.
Example
Jobs- category-# employees required for shift
1. Mezz - 1 - unlimited
2. OP - 1 - 15
3. PSolve - 1 - 5
4. Damages - 2 - 1
5. IOL - 2 - 1
6. QC - 2 - 2
7. RT - 2 - 7
8. CB - 2 - 0
9. VRC - 3 - 6
10. WS - 3 - 2
11. Ambassador - 1
12. PA - 0 - 2
13. PG - 0 - 1
14. Accomm- 0- unlimited
- Sheet can be auto populated for the day or week.
Please let me know if you have any questions and I can work with you to answer them.
36 freelances font une offre moyenne de 443 $ pour ce travail
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. If you Plus
"""""""""""""""""""""""""""""""""EXCEL STAFF SHEET"""""""""""""""""""""""""""""""""""""""""" "Sir, I can create this staffing sheet and it will be fully automatic and will be able to automatically provide you with seve Plus
Hi there! I have more than 10 years of experience as a Data Base Administrator and Analytics Engineer. I would love to work together on your project and fulfill all the necessary requirements and positions for your pro Plus
Hi I'm Access guru. I'll build ms access desktop app from scratch for your stuff with a user friendly GUI. I am an Access/Excel/SQL/VBA expert and mathematician from Georgia, working as a full-time freelancer. Over t Plus
Hey Good morning , Just finished reading the brief details . I see you have been looking for someone who has experience with these tech stacks Excel VBA, Microsoft Access, Data Processing and Excel. I will request you Plus
Hello: After reading in detail the requirements of your project and concluding that they match my areas of knowledge and skills, I would like to introduce myself. My name is Umair Anwar and I am the lead engineer for E Plus
Hi, I have gone through the Job details and am interested in taking it up. Correct me if I am wrong, in your example: "2. OP - 1 - 15" 1 means the category and 15 means the number of employees. I need you to share more Plus
Hi, Dear Employer, I am Al.A. I am a Ph.D. backgrounder and professional Excel and data scraper. I will provide you high-quality Excel file. I have worked on similar projects of /Excel /Web Scraping /Data Mining/, Exce Plus
Hello, I can make you a web-application (website in simple terms), will work and look great. Data will be stored in database and easy to manage. Alexander
Hi there, I'm a Advanced Level Excel Macros and VBA, Data Processing expert. ***GIVE ME A CHANCE THIS TIME*** Can we discuss more details about this project? If you are interested, feel free to message me and I will tr Plus
Hi! I am skilled writer with the vast skills and qualifications necessary for this job. I have experience in Microsoft Access, Excel VBA, Data Processing and Excel. I am confident that I can produce high-quality work Plus
Dear there I have checked your project Create staffing sheet and would like to offer my Assistant to you. I am experienced Virtual Assistant/Executive assistant having more than 5 years of experience and served variou Plus
Hi I hope you will fine. I can read your instructions carefully. I can help you for this work. I can work perfectly and honestly.
Hi there, It seems you need support to make some Conditional formatting Attendance in excel. My expertise includes Ms Office, and Excel Formulas. I am an admin in constriction Company my services to create a simple For Plus
Hola tengo la experiencia necesaria para completar este trabajo me gustaría formar parte de su equipo y realizar el trabajo de la mejor manera posible. Gracias.
I AM GOOD IN EXCEL AND DATA ENTRY AS AN ACCOUNTANT. I HAVE BEEN DEVELOPING EXCEL SHEETS FOR MANAGEMENT OF FINANCES IN SMALL GROUPS
Escucho, pongo atención al cliente y sobre todo trato de que el cliente se puede sentir en confianza y conforme con mí trabajo.
Good afternoon sir, I can do the job easily and simply, I would agree to work according to the assigned schedule without inconvenience. I hope you choose me to do it, I am the one and I require experience, thank you ve Plus
I have completed vba automation and excel advance certification. I am a corporate emplyee now. and i have handled many reports and projects.
Hi Dear, If you hire me, I'll do my best to complete your work perfectly. And give you the best output you have ever seen. I also give you unlimited feedback. If you want, you can contact me through email & whatsapp a Plus
