Premiado

Excel Monthly Scheduling Program -- 2

I am in need of an excel program that will generate a monthly shift schedule that will auto complete dates in calendar format.

I will need the shift times/employee initials listed in color code included (see attached excel example)

Details of Info required to be displayed.

shifts will be 9 hours. There will be 3 shifts

times of each shift:

Shift 1: 0600-1500L

Shift 2: 1400L-2300L

shift 3: 2200L-0700L (next day.)

There will be rotating weekend coverage from 0700-2300L

Shift 1 will cover first weekend

Shift 2 will cover second weekend

Mgr will cover 3rd weekend

Shift 3 will not be included in weekend coverage rotation.

Ideally i would like day cells to be large enough to include time and 2 letter initial of employee

ie: 0600-1500L (2 letter initial) // 1400-2300L (2 letter initial) // 2200-0700L (2 letter initial)

every 3 months (based on calendar dates 1 Nov-Feb 1) employee on shift 1 will move to shift two.

Employee on shift two will move to shift 3. Employee on shift three will move to shift one.

Example attached is just for visual aid. Willing to accept different layouts as long as schedule can be auto populated.

Habilidades: Processamento de dados, Excel

Ver mais: the example of cover letter, format of a cover letter, format for cover letter, format cover letter, format a cover letter, example of cover letter format, example of cover letter, example of a cover letter, example for cover letter, example cover letter format, example cover letter, cover letter format example, cover letter format, cover letter example, an example of a cover letter, a cover letter example, shift scheduling, move data excel, rotating schedule, day shift schedule, day rotation shift calendar, rotating weekend shift schedule, excel program scheduling, scheduling excel, day rotation employee schedule

Acerca do Empregador:
( 24 comentários ) Katy, United States

ID do Projeto: #6824816

14 freelancers estão ofertando em média $47 para este trabalho

zExcel

A proposal has not yet been provided

$100 USD em 1 dia
(220 Comentários)
7.4
Teloquence

Hello, I am top freelancer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your reference. E Mais

$30 USD in 0 dias
(298 Comentários)
7.5
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 220 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Mais

$30 USD in 3 dias
(88 Comentários)
6.0
elqueabandona

Hello, my name is Cristian, I have a degree in Business and am Financial Advisor. Besides working with excel every day. I have much experience with spreadsheets, complex formulas and macros to process the information. Mais

$77 USD in 3 dias
(88 Comentários)
6.0
vikas0903

I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on pricing models, income statements, conjoint surveys, business analysis etc. Prior that I have completed MBA and bachelors in Engineering. Mais

$77 USD in 3 dias
(39 Comentários)
5.6
sajidmahmud

Dear sir I am ready to start your job, if you give me chance I can do it properly and right time delivery. Thanks

$30 USD em 1 dia
(144 Comentários)
5.4
TonmoyRoy111

Dear Sir, I ensure you of completing the project within the specified time. I have a previous experience of Data Modification work in Excel using Macro. Besides I am an Electrical Engineer and currently working in Mais

$45 USD em 1 dia
(54 Comentários)
4.5
renesontiongson

Hi! excel automation is my masterpiece in my accounting field. It is my pleasure to help your project. Thank you.

$30 USD em 1 dia
(25 Comentários)
4.1
MKL7

*** EDIT: I have seen the attachment. Please have a look at my profile, the projects I already completed and the reviews I received. Let's have a look together at this project and work on it step by step. Not only wil Mais

$50 USD in 5 dias
(18 Comentários)
3.2
SrinivasaBagade

Dear Employer, Good morning, I am interested in this job as I have over 18 years of experience in the field of MS excel & VBA programming, data-entry and I am a computer savvy, goals are to make the employer/ cust Mais

$25 USD em 1 dia
(4 Comentários)
2.6
igotmail9

Dear Sponsor, I am a hard core developer with 14 years of experience in software development with Java (3Y), C++ (10Y), C#(3Y), Visual Basic, Excel, VBA programming, Web programming, HTML5, PHP, MySQL, Linux and Win Mais

$35 USD in 2 dias
(1 Comentário)
1.6
tandonshailendra

I have planned duty schedule for a railway network in Excel. The program can be automated by use of macro. We shall need to prepare a list of workers and managers. Initial duty allocation will be with manual interventi Mais

$100 USD in 3 dias
(2 Comentários)
1.4
mahmoudalgendy

A proposal has not yet been provided

$15 USD em 1 dia
(0 Comentários)
0.0
elaineperfas

I am an accountant in a private and public firm. I am reliable and fast worker. I am excellent in data entry, copy writing, data mining, Excel and Word. I am working almost 10 years using MS Excel and Word and I enjoy Mais

$25 USD in 3 dias
(1 Comentário)
0.0
sujeetkumar1987

My name is sujeet Kumar. I have total 4 year experience of marketing Customer satisfaction is my first precedence. I try to provide 100% output in the right time. My work are maintained by our strong management, I am Mais

$25 USD em 1 dia
(0 Comentários)
0.5