Generally a decently sized hospital require a software based approach for MIS with softwares such HMIS by CDAC etc..
However, if you are looking for something excel based, then it needs to be customized in discussions with management to incorporate their decision making needs...