I am surprsied that there still staff within NHS who can waste time developing software.
The solution is not a manual chart or excel.
This is not a professional attitude and I suggest YOU LOOK at activity and recommend a professional service and package to your Trust.
In house software is not an option, so forget about it.
alex