Hospital Workload Matrix Review

I am looking for a data scientist or analyst to help create an HTML calculator for hospital physician workload in a specific specialty. The calculator should stratify workload as Critical, High, Medium, or Low, and determine how many Full-Time Equivalents (FTEs) are needed to run the service efficiently. The Excel sheet is attached (examples are available in the second sheet = comment) Details: The calculator must use these FTE values: Consultant = 1 FTE Senior Registrar = 0.95 FTE Registrar = 0.75 FTE Fellow = 0.65 Contract hours are 48 hours per week. Maximum consultant on-call shifts allowed: 10 per month. All relevant elements should be considered in the calculation. I have used AI to generate a draft, but the output is not scientifically sound. I need expert input to make sure the calculations and logic are accurate. Deliverable: A shareable HTML link for instant calculation and interpretation of physician workload.

ID do Projeto: 39985762