Multi-Hospital Resource Allocation Predictive Dashboard

Develop a comprehensive spreadsheet dashboard for hospital resource allocation that uses predictive modeling techniques. Requirements include: 1) Integration of historical patient admission data, 2) Machine learning-based forecasting of bed occupancy rates, 3) Real-time risk assessment algorithms, 4) Automated scenario modeling for pandemic/emergency preparedness, 5) Interactive visualization of potential resource constraints. The dashboard must support dynamic data input and generate actionable insights for hospital administrators.