As a deputy director of health planning, research and statistics in a 500-bedded hospital, I know for a fact that every hospital, big or small, has the responsibility to monitor and evaluate its services geared towards improving quality of care to her clients or patients. This can’t be possible without having access to certain basic statistics.

These statistics fall within but not limited to the following:

1. Admissions
2. Discharges
3. Deliveries
4. Deaths and Death Rates
5. Deaths by diagnosis
6. Bed Occupancy Rates
7. Average Length of Stay
8. Bed Turnover Rates
9. Patient Care Days
10.Re-admission Rates and many more.

Derived from personal experience of over 20 years on the job, I have automated Excel program made up of 2 Excel files. The first file comprises 4 Excel Spreadsheets which are data-tracking sheets 1 and 2; and data entry 01 and data entry 02.

The data entry 01 automatically processes admissions, discharges, deliveries, inpatient mortality across age brackets, outpatient attendance with each entry sheet having a printable analysis output page comprising illustration trends and charts.

The data entry 02 automatically processes inputs for deaths recorded in the facility and spread the number of deaths across possible diagnoses. The printable output pages indicate trend line for death rates, chart distribution for number of deaths per gender per cause of death, percentage spread between male and female gender, etc.

The second file comprises data tracking form, 6 hospital wards spreadsheets and 2 output pages which display printable table of annual performance across wards, trend line for bed occupancy rates, table of average length of stay and a table showing death rates reported in different wards of the facility.

So, for a 6-hospital wards package priced at $80, clients will receive 2 Excel package files, and each file provides charts and trends of the hospital operations after analysis to guide decision making for greater good of the hospital’s system of service delivery.

Whether a hospital is a Primary Healthcare Centre, General Hospital, Specialist or Teaching Hospital, this package is a ready product to be applied.

I will therefore recommend that you acquire this package, because it will be of immense benefit to your hospital in terms of planning, budgeting and proper allocation of resources ranging from personnel, equipment and medical consumables. It will also help you to provide appropriate health statistics to government agencies or authorities that may demand for such statistics.