Attachment C-15 Dormitory Schedule Sample.xlsx

This is a sample dormitory scheduling spreadsheet that appears to track student housing occupancy and bed availability for training programs at a federal facility from January 2024 through July 2025. The spreadsheet contains detailed daily tracking of student counts across multiple housing categories including on-center lodging, off-center lodging, hotel accommodations, and "no lodging" requirements. It includes formulas to flag when available beds fall below certain thresholds (24 beds triggers yellow warning, 1 bed triggers red warning). The facility appears to have different types of accommodations including ADA rooms, single rooms, double rooms with capacity ranging from 39-390 beds depending on the category. The schedule tracks multiple training programs occurring simultaneously with student counts ranging from small groups of 7-10 up to larger classes of 135+ students. Programs vary in length from 1-day sessions to extended training lasting 75 days.