Create Excel Workbook for annual leave and shift rota

終了済み 投稿 Feb 23, 2015 着払い
終了済み

I am supervising a team of upto 10 people and currently have multiple spreadsheets for annual leave, attendance, shift rota, schedules however I want to consolidate these into one workbook which is then driven by a number of macros to pull data from various schedules and then plot into a master sheet than can be printed / saved and distributed.

Each staff member will have the option of being put onto one of the following Monday to Friday shifts:-

0800-1630hrs

0900-1730hrs

0915-1530hrs

0915-1600hrs

0915-1700hrs

Each member of staff will be able to book the following leave:-

ALL Day

Half Day AM

Half Day PM

There will then need to be a number of checks to ensure that only 2 people are on break at any time. Break times are 1200hrs and 1300hrs. Specific staff prefer certain breaks so these will take preference.

There is a separate rota for Saturday cover which will then be another sheet.

There is also additional sheets for three main tasks such as Appointments, Training and Documentation. If a person is flagged against one of these roles then it will posted as an additional field in the overview / master sheet.

I will want to grow the functionality of the spreadsheet so this will require additional paid work in the future

データ入力 情報処理 エクセル

プロジェクトID: #7192277

プロジェクトについて

16個の提案 リモートプロジェクト アクティブ Apr 1, 2015

16 人のフリーランサーが、平均£8/時間で、この仕事に入札しています。

DataHome

A proposal has not yet been provided

£7 GBP / 時間
(50件のレビュー)
8.4
zExcel

A proposal has not yet been provided

£25 GBP / 時間
(155件のレビュー)
6.9
flashsaiful

Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful

£8 GBP / 時間
(78件のレビュー)
5.7
piekn

Hello. Generally all is clear. I created a various Excel workbooks in sales department of energy company during almost 10 years (and, of course, had made many consolidating workbooks). So, I'm sure - I able to make もっと

£5 GBP / 時間
(2件のレビュー)
1.4
kingzero07

A proposal has not yet been provided

£8 GBP / 時間
(レビュー1件)
0.2
KAIMULHAQUE

Dear Buyer, It is our pleasure to inform that we are the team which has 2 years of experience in the field of data entry, web research, Copy writing and so on. We have qualified professionals with us regarding thes もっと

£8 GBP / 時間
(0件のレビュー)
0.0
engmomenshaban

Dear sir: I'm an Electrical engineer, So I have more experience in writing field via Microsoft programs while I perform all of my reports by this programs. I can perform your task as soon as you need with high accurac もっと

£5 GBP / 時間
(0件のレビュー)
0.0
satnammalhi

A proposal has not yet been provided

£8 GBP / 時間
(0件のレビュー)
0.0
danero

Propunerea nu a fost încă furnizată

£8 GBP / 時間
(0件のレビュー)
0.0
AmirAli123

A proposal has not yet been provided

£6 GBP / 時間
(0件のレビュー)
0.0
hani741

A proposal has not yet been provided

£8 GBP / 時間
(0件のレビュー)
0.0
bhojraj777

With a good typing speed and confidence i will complete your work in time perfectly as per your need.

£5 GBP / 時間
(0件のレビュー)
0.0
robpt

Hi, I am an engineer for more than 15 years with strong experience in Excel including VBA Macro programming. I am interested to create this spreadsheet in satisfying your requirements. Please consider me for this pr もっと

£10 GBP / 時間
(0件のレビュー)
0.0
havishaagroup

We are good at Microsoft office 2010 and data entry. MOS certified in excel with 100% accuracy. We will complete your work within the time limit.

£5 GBP / 時間
(0件のレビュー)
0.0
dil1990

A proposal has not yet been provided

£8 GBP / 時間
(0件のレビュー)
0.0