Can you think of an option to represent the rooms by floors instead of dates? for example floor 1 2 3 4 5 6 7 9 12 ... 1 free occupied 2 3 4
Yes, it is possible.
You'd need to map the dates (e.g. the day of year part) to floors using a technique used in the ASP.NET timetable tutorial: https://code.daypilot.org/65101/timetable-tutorial-asp-net-c-vb-net
It uses the Calendar component but you should get the idea.
Great!! Thanks