While lesson planning, indicate with an icon or a highlight next to their name at the top of the spreadsheet, which students have a planned lesson. In this way it is easier to ensure that each student has at least one lesson planned (assuming you're only planning for one week or a short period of time).