Page 2 of 3 FirstFirst 1 2 3 LastLast
Results 11 to 20 of 26

Thread: Help needed for a weekend rota - not quite so straightforward.

  1. #11
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0


    Register for a FREE account, and/
    or Log in to avoid these ads!

    So you want to easily retrofit my approach to their sheet? And do you want the code to check to see if a cell is highlighted or is that not really relevent to the code and more a case of being able to implement something new without upsetting HR's applecart?

  2. #12
    They'll just use this sheet (as long as it won't interfere with your approach). It's not really relevant to my team whether HR sign it off or not, I just wanted you to know in case you were taking an approach where colours were involved. They will literally just highlight cells as they go through each month to pay those that actually worked (marking them off). They won't be coding anything, or require any coding. Their current spreadsheet is basically a table, and they manually update it frequently throughout the month, so I'm thinking they should save some time here sharing this sheet, rather than us working from separate sheets.

  3. #13
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Okay that's simple enough. One more question. I note your data starts as at 1 June 2013. Because we don't have 3 months of data before this date, then we've got no way of checking for the first three months of that date range whether they've covered a particular contract in the last 3 months or not. So you really need to put the previous 3 months data in there as well (perhaps hidden to the left of 1 June).

    Your thoughts? If that's a requirement, can you amend your spreadsheet to suit and upload it. Should only take me 30 minutes max to code it up once you've done that.

  4. #14
    That's no problem, I'll source the data now and put it all in.

    ooh it's exciting!

  5. #15
    Sorry, it took a while getting on to the network at work. I have added all the data I can for the previous three months. They are all currently 'pay' as 'day' is a new trial - just in case you look at it and wonder why there are no days in there.
    weekend_working.xlsx

    I'm trying to think of anything I might have missed. We have around 20 new starters joining over the next couple of months. Will there be any issue just adding them to the bottom of the list as they join us? and can we lock the formulas so no one other than me can edit them? I have no option but to share the sheet as the workers' Line Managers add them to the sheet, and it has been known where someone comes along and accidentally deletes something, or decides to try something new - overwriting what you've done. I'll keep a master copy of course, but locking some cells would be very handy.

  6. #16
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    No problem. One potential issue. Above, I'd mentioned that you also need a dropdown or something setting out when they last had training in a particular contract. Instead of that, I think you need 4 columns - one for each contract type - where they just put the most recent date that they completed training for each contract type. Sound good?

  7. #17
    Yeah, I think that could work. I was wondering how it might work in the drop-down. I've been playing about with different layouts, but I think I have looked at it for so long that I've stopped seeing anything that seemed like the best option. With the potential to type in the most recent training, we could have only the Managers update it once they provide the training (or my team in Quality), so that could work really well.

  8. #18
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Carrie...this slipped off my radar, sorry. Just about to pick it up again. Before I do, have you revised the structure/layout of your file at all? IF you have, best you upload it so I can make the requisite changes to the final copy.

  9. #19
    No problem at all - I know how busy you are. I haven't changed anything as I was concerned that you were working on it and would come back to me uploading another version.

  10. #20
    Sorry, Jeffrey. I've been out of the country (unexpectedly) and had wifi that was completely useless.

    Shall I change the layout? - I'm conscious that I might do something whilst you're doing something else, and don't want to waste your time.

Page 2 of 3 FirstFirst 1 2 3 LastLast

Posting Permissions

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