Healthcare Resource Allocation Predictive Dashboard

Design a Python-based dynamic spreadsheet analysis tool that predicts hospital resource allocation using machine learning models. Implement a system that ingests historical patient data, bed occupancy rates, and seasonal health trends to generate real-time resource optimization recommendations. Use libraries like scikit-learn for predictive modeling, create interactive visualizations with plotly, and develop a Google Sheets add-on that updates dynamically. Include a confidence interval calculation and explain the predictive methodology.