Forum Discussion

mathetes's avatar
mathetes
Silver Contributor
Apr 09, 2022
I inserted a text box....basically asking for some more clarification on the pay rate to be assigned to each worker for each shift. I'm suggesting we delay the whole matter of seniority for the time being and get the other part resolved first. It's not just a matter of whether it was day or night, it's whether it was red_day or red_night or blue_day or blue-night. You can't just record day or night. Who gets assigned to the various days is a different matter. One thing at a time.

I'm going to be largely unavailable for the rest of the weekend....As time permits I'll try to check back, but don't expect immediate responses.
Gonsa17's avatar
Gonsa17
Copper Contributor
Apr 10, 2022
Right. I'm sorry again.
The pay rate will always be for 4 hour shifts. It's a set value which is the 20/35/15/30, depending on Red_D/Red_N/Blue_D/Blue_N.
  • mathetes's avatar
    mathetes
    Silver Contributor
    Apr 14, 2022

    Gonsa17 

     

    I'm attaching a spreadsheet in Excel where there are now two tabs, the first of which takes care of compensation calculations based on the days and shifts worked. I gave two ways to do that, one of which works with the entire list of shifts, the other with selected start and end dates. This also uses the FILTER function, which won't work in Google Sheets; it requires the most current version of Excel as well.

     

    The second tab is the separate matter of scheduling, and I need to ask you to write out the rules in far more detail there. It may also be necessary to write a Power Query or macro/VBA routine, things that I do not know how to do. But let's begin with really clear rules. You'll see how I suggest you conceive of that in a text box on that second tab.

     

    May I suggest that, when you send back a response, you try to attach your Excel sheet to the posting here on these boards. If that doesn't work, let me know and we'll try a different route.

Resources