Tim Ferriss shared this spreadsheet that helps to predict hospital capacity:
We like it so much, we've adapted it into a dynamic tool so you can change key assumptions and check how it affects the results.
Dynamic COVID Hospital Capacity v1 - Excel File