Automated Shift work Roster EXCEL

Hi Guys,

I have a xls roster that is requiring to much time in manual handling.

It is a rotating line roster and there are 22 lines/names on it (that part already exists)There are also 4 partimers and 4 supervisors all on same kind of roster on same sheet.

What I need:

-To be able to select the new date at the beginning of every week and with it everyone drops down a line into their new shifts for that week (names can drop or line number)

- To have a daily work sheet generated from the above that i can print daily (showing everyone on that roster for the day, and breaks)

- to have a fortnightly sheet generated for payroll which has hours worked and overtime (payroll sheet exists but is not connected to main)

- A drop down list of all staff names on all shifts so that when Tom changes shift with Harry their swaped over shifts change also (this currently exists and happens (concatuate and vlookup)

-there is currently as overtime sheet - I want overtime that is entered there to show up on the (existing) payroll sheet as overtime

- Similar to overtime sheet is leave sheet, i would like leave information that is entered here to also reflect on the weekly roster (as leave) Leave is holidays/sick/other/day in lue.

I would like it to be easy for the layman to-

-Enter new staff names and line number with the programing intact

- Shift swapping to include the break start and finish times (feautre currently exists but has only the start times of breaks included in code)

Basically I am paying for this out of my own pocket as i have to maintain this roster and its a major headache. I would like it in excel format but if anyone has a easier/cheaper option that i can save on my HD and do through browser Im open to that.

I can give you simply the names/line numbers and the times for the shifts and you can start from scratch or I can give you all existing spreadsheets - however you like to work. I have spent hours on these spread sheets and reckon if you know what your doing it would be 2-4hrs.

The quote should only be a flat fee, I wont pay by the hour, Im in Australia and can do paypal in your currency. I will pay only when work is tested and complete. Guarantee more xls work to you when we are done




Skills: Excel, PHP

See more: shift roster excel, automated roster excel, work roster, leave roster excel, excel shift roster, create roster excel, shift roster xls, automated shift roster, six day work rosters, work shift excel, shift work rosters, work roster php, php shift roster, excel automated roster, shift roster php, shift roster excel format, automated work shift excel, programing excel shift work, shifts excel, roster automated excel, automated roster, excel shift work roster, work roster xls, excel automated rotating overtime roster, excel roster sample

About the Employer:
( 11 reviews ) sydney, Australia

Project ID: #298914

17 freelancers are bidding on average $130 for this job


Please Check PM

$150 USD in 7 days
(6 Reviews)

Hi, Please see the Private Message Board for my detailed quote. Thank you.

$145 USD in 5 days
(8 Reviews)

Dear Juan! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

$138 USD in 3 days
(10 Reviews)

Have programming experience with Excel

$50 USD in 12 days
(6 Reviews)

Yes, this can certainly be done in Excel and VBA. Please note that 5 days are required for communication, etc.

$125 USD in 5 days
(5 Reviews)

Hi, based in UK. Please see PM.

$150 USD in 7 days
(8 Reviews)

Hi, I have build salary softwares and other data analysis softwares. I am working as programmer in a Charitable Hospital looking after all the data processing work from stores, staff salary, income and billings etc us More

$70 USD in 2 days
(0 Reviews)

Dear Juan. I do have extensive experience and knowledge in excel and its formulas. I will be happy to assist you with your project.

$100 USD in 5 days
(0 Reviews)

See PM for details.

$150 USD in 3 days
(0 Reviews)

Provide me all the spreadsheets to work on....

$140 USD in 7 days
(0 Reviews)

Hi, your project sounds interesting. I am sure that I can deliver a satisfactory solution for you in a weeks time. I have done quite a lot of "office automation" application in Excel using VBA. Regards / Henric

$150 USD in 7 days
(0 Reviews)

I can build an Excel program for you that will work however you want. Please send me the existing spreadsheet. I have 15 years of experience in building Excel applications.

$125 USD in 3 days
(0 Reviews)

Hello. I have a huge expirience in VB programming. Can make it fast and cheap.

$100 USD in 3 days
(0 Reviews)

We have 30 users which are already working with same projects, Please send some sample work to check our quality and fastly uploading work shedule. thanks, Omprakash

$225 USD in 6 days
(0 Reviews)

Looking forward to hear from you.Thanks.

$50 USD in 3 days
(0 Reviews)

I am a Chartered Accountant from India with managing my financial consultancy. I have good expertise in excel modelling and will be able to help you.

$150 USD in 7 days
(0 Reviews)

Hi I operate a dedicated and professional consultancy in Melbourne Australia with years of commercial experience, but most importantly experience with creating customised Rosters. Please visit my website at [url removed, login to view] More

$200 USD in 5 days
(0 Reviews)