Create Excel Workbook for annual leave and shift rota
£5-10 GBP / 時間
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 人のフリーランサーが、平均£8/時間で、この仕事に入札しています。
Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful
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 もっと
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 もっと
With a good typing speed and confidence i will complete your work in time perfectly as per your need.
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.