+ Reply to Thread
Results 1 to 6 of 6

Rosters

  1. #1
    Registered User
    Join Date
    10-17-2019
    Location
    London
    MS-Off Ver
    office 365
    Posts
    3

    Rosters

    Hi guys,

    I was wondering if theres a way i can have an automated rostering tool that works out 4 weeks in advance. for example, I'd like it to take into account store opening hours, colleague hourly contract and fill it in automatically and i'd just have to make small adjustments? Would be amazing if someone could help me out with formulas etc?

    many thanks,
    Mikey

  2. #2
    Valued Forum Contributor
    Join Date
    04-26-2015
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    500

    Re: Rosters

    Formulas depend on the criteria. Open/closed hours, how many Employees, etc.

    Here is a start for you. (Don't worry about the Holiday Schedule yet, this template is set up for Canadian Holidays).
    Attached Files Attached Files
    Uploading an attachment will assist Forum Members in finding the correct Solution for you. Create a dummy worksheet if necessary, add your start data and show where / what your expected results should be. TO ADD A FILE:

    Go to 'Advanced. click on 'Manage Attachments. Select 'Browse & Choose your file, Select 'Upload and then close the Attachment window.

  3. #3
    Registered User
    Join Date
    10-17-2019
    Location
    London
    MS-Off Ver
    office 365
    Posts
    3

    Re: Rosters

    Quote Originally Posted by BlindAlley View Post
    Formulas depend on the criteria. Open/closed hours, how many Employees, etc.

    Here is a start for you. (Don't worry about the Holiday Schedule yet, this template is set up for Canadian Holidays).
    hey buddy, thank you for getting back to me,

    I was wondering if it would be possible... like for opening hours its 4am to 9pm. and about 12 colleagues but they all have different contracted hours.

    Thanks in advanced

  4. #4
    Registered User
    Join Date
    10-17-2019
    Location
    London
    MS-Off Ver
    office 365
    Posts
    3

    Re: Rosters

    Quote Originally Posted by BlindAlley View Post
    Formulas depend on the criteria. Open/closed hours, how many Employees, etc.

    Here is a start for you. (Don't worry about the Holiday Schedule yet, this template is set up for Canadian Holidays).
    hey dude, sorry to ask again, I don't quite understand how to use this template...

  5. #5
    Valued Forum Contributor
    Join Date
    04-26-2015
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    500

    Re: Rosters

    Use the template and write over the day column formulas to show me what you expect to see for each employee. Use the ABCD column and use a unique identifier that will trigger the contracted hours. For example 9 - 1pm could be A, 9 - 5pm could be B, and so on. Leave the fake names for now and repost the template using the instructions below.

    I may not get back to you until tomorrow though.

  6. #6
    Valued Forum Contributor
    Join Date
    04-26-2015
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    500

    Re: Rosters

    In the meantime you could try and follow the formulas to see why they say days aft & nights or remain blank because that is where we are heading.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to reconcile two rosters...maybe?
    By jaredcass in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2015, 03:11 PM
  2. adding fomulars to rosters
    By primal_chef in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-03-2015, 08:15 AM
  3. looking to email individul rosters
    By tvt0290 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-21-2013, 07:26 AM
  4. Setting up Rosters
    By ian.clark in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-21-2013, 02:53 AM
  5. 40 hours perweek Rosters
    By darellharrison in forum Excel General
    Replies: 1
    Last Post: 04-18-2012, 10:54 PM
  6. Creating Individual Rosters from RAW Data
    By grumpyrogue in forum Excel General
    Replies: 3
    Last Post: 12-14-2011, 10:19 PM
  7. [SOLVED] Staff Rosters.
    By Delma in forum Excel General
    Replies: 1
    Last Post: 12-12-2005, 11:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1