RosterLab Blog

Insights, tips, and updates on workforce management and employee scheduling.

Roster more effectively with Excel Ep2: Sleep Days after Night Shifts

Roster more effectively with Excel Ep2: Sleep Days after Night Shifts

For those of us writing rosters with 24-hour coverage, there is the necessity to account for sleep days for those that are transitioning from night shifts to day shifts. Sometimes in the deep roster writing state, we can lose track of these things in the struggle to fill every shift. Let's set up some Excel formulas to check this for us instead of seeing it ourselves much later.

Daniel Ge
Daniel Ge
person using excel spreadsheet on desktop

Roster more effectively with Excel Ep1: Staffing level counts

Have you ever wondered how to set up your rostering spreadsheet to quickly check if you have the right number of people on every day? Maybe you already have, but you would like some colour coding or even a quick check that every day is staffed correctly. In this post, I will go over some easy-to-implement excel formulas to do just that.

Sunny Feng
Sunny Feng
Rosterlab’s New Rostering Assistant Tier - The What’s and the Why’s.

Rosterlab’s New Rostering Assistant Tier - The What’s and the Why’s.

When we set out to make an AI rostering platform, the team at Rosterlab encountered many, many Excel spreadsheets. We’ve also wound up making innumerable spreadsheets ourselves. It's part of the territory of rostering, and also part of the territory of testing a rostering AI. In this post, we go into the how what, and why of the new Rosterlab Free Tier (the who is us, and when is sign up here now).

Sunny Feng
Sunny Feng