9.4.4 R9. Operating Room Scheduling - Video 3 Solving the Problem
Here we are in LibreOffice, and you'll see that we have all the data we discussed in the previous videos loaded into the spreadsheet here. Let's take a minute to familiarize ourselves with how the data is set up. So here we see we've got the number of surgical teams per department per day, and we've got it listed by department-- all five of them are here-- and by day of the week-- Monday, Tuesday, Wednesday, Thursday, and Friday. Remember, for all departments, we have the same number of teams in per day, except for oral surgery, because the oral surgeon is only present on Tuesdays and Thursdays. Scrolling across, we see that for all five departments, again, we've got the minimum number of operating rooms that each one requires each day. This is simply 0. As we keep going, we see the maximum number of operating rooms that each department requires each day. Going down to the next set of data, we've got the weekly department requirements. We've go...