Find Jobs
Hire Freelancers

Create Excel Workbook for annual leave and shift rota

£5-10 GBP / hour

Closed
Posted about 9 years ago

£5-10 GBP / hour

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
Project ID: 7192155

About the project

22 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
22 freelancers are bidding on average £9 GBP/hour for this job
User Avatar
A proposal has not yet been provided
£25 GBP in 5 days
4.9 (154 reviews)
6.9
6.9
User Avatar
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this regard. with thanks and regards
£8 GBP in 20 days
4.6 (85 reviews)
6.1
6.1
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 225 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
£10 GBP in 5 days
4.9 (104 reviews)
6.0
6.0
User Avatar
Hello! I'm an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
£10 GBP in 5 days
4.9 (39 reviews)
5.0
5.0
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards
£10 GBP in 10 days
4.9 (34 reviews)
4.8
4.8
User Avatar
Hello sir...Would you can just click on discuss button and start chat with me.. Kindly if you want high quality work then as soon as possible contact me. Please give me chance to prove myself. Thanks Regard’s Junaid Software Engineer
£7 GBP in 5 days
5.0 (29 reviews)
4.8
4.8
User Avatar
Hello Sir just contact me once through personal message waiting for your response Thank you...................................
£8 GBP in 10 days
4.8 (25 reviews)
4.7
4.7
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
£12 GBP in 5 days
4.8 (36 reviews)
4.7
4.7
User Avatar
Hi, I am pleased to introduce myself as an excel expert. I use excel for the following: 1) Tracking daily attendance for regular staff. 2) Preparation of Payroll 3) Preparation of financial 4) Cost sheet 5) Export sales analysis 6) Domestic sales and transport Invoice I have more than 10 years experience in preparation and use of those above tables. If you feel I can do justice to the project do call me. Thanks
£8 GBP in 5 days
5.0 (10 reviews)
3.8
3.8
User Avatar
Hi, I am working as software professional in IT industry from last 4 years. I work on VB scripting along with VBA for MS office applications. Also developed various Desktop based application using Visual Studio in VB and C# I have done projects related to VBA and VB in past. If you like my proposal,lets start. Thanks Abhinov
£10 GBP in 20 days
5.0 (9 reviews)
3.6
3.6
User Avatar
Hello there, I am living in virtual world for more than 3 years. I like everything we have in this world. I am really happy to have enough knowledge about my living place. Some times it's making me able to implement my creative thoughts. I think I am enough experienced to join you and also make a successful team. I have many reviews where you can't see anything that's gonna confuse you working with me. I like to work hard and working in a challenging environment. I was in USA for 4 months. I was working there as a customer service agent also taking care of all administrative staffs. Waiting for your reply. Kind regards, Md Mridha
£5 GBP in 15 days
4.8 (15 reviews)
3.6
3.6
User Avatar
Hello sir... i guarantee you 100% satisfaction and my expertise lies in quality service and delivery on Time kindly if you wants high quality work then as soon as possible contact me. Please give me chance to prove myself. Thank u!
£8 GBP in 5 days
5.0 (9 reviews)
3.2
3.2
User Avatar
Предложение еще не подано
£11 GBP in 15 days
5.0 (8 reviews)
2.5
2.5
User Avatar
Hello, I have seen your project. I am offering my services for this work.I can complete this task with 100% accuracy and within defined timelines. Completing the job with 100% accuracy and with punctuality is my first priority. I believe I would be a good contractor for this job and assure you that my first work will leads to long term working relation. Looking forward to hearing from you soon. Thanks!
£5 GBP in 12 days
5.0 (6 reviews)
2.0
2.0
User Avatar
Hi, Your project sounds very interesting and simple enough and I believe that I'll be able to perform the task perfectly. As for my experience, you can see for yourself that I've worked here mainly as a content and article writer; but, I've also done some VA work, which included a lot of both Excel and MS Word work as well as some Access and VBS tinkering. You're welcome to check my reviews and should you have any questions, I'll be happy to answer. Kindest regards. Milan
£5 GBP in 20 days
4.9 (2 reviews)
0.8
0.8
User Avatar
Hello SIr, I can complete this project, please contact me.................................................................................
£10 GBP in 5 days
5.0 (1 review)
0.0
0.0
User Avatar
Hello sir, i live in GMT +3 and as i see you are in GMT 0 timezone. I am ready to work in AM hours, 7:00-14:00 and PM 9:30-17:00. You didn't mention payment, how much will staff member get in a day? Rest of the requirements suit me and i would like to work for you. Best regards, El.
£10 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have a Bachelor Degree in Teaching English I have 5years experience as computer administrative ( Word, Excel, PowerPoint, Outlook, PDF-Word-Excel converter, data entry, transcription, editing doc, Adobe writer...) , purchase and communication, I am top-notch on various fields : legal, creative, web search , commercial, cultural… I always meet deadlines, I can fully apply my skills and knowledge to success your project
£8 GBP in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello there! I am a fresh candidate with promising reviews and I would like to work on projects like this. I will do my best to deliver the job fast and well done. I am a serious and hardworking freelancer. I would be happy to work with you.
£5 GBP in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am data analyst by profession with huge experience in Excel/VBA, I can help with this project. Regards Michal
£5 GBP in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Kidderminster, United Kingdom
5.0
15
Payment method verified
Member since Jan 7, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.