I have attached an excel 2013 file which is an example of a data sheet that a Medical Practice will use to record patient reviews. There will be 44 practices involved within the project and each practice will need their own workbook.
How can I simplify the process so that each Practice workbook automatically updates a central summary sheet?
If you could help me set up one of the items below, then I should be able to do the rest.
The summary sheet should be able to report on by practice, and by a particular month and overall (note as more than one row can be completed per patient depending upon the number of medicines reviewed I only need to count this once per patient):
1. No. of patients reviewed (Column A)
2. No. of patients (and therefore %) over or under ordered (+->20%)(Column W).
2. No. of repeats (Column H)
3. Top 10 list of Drug names that appear most commonly with Column Z showing the phrase "Patient overordering and dose taken different to the computer recorded dose".
4. Savings made (Column AO)
Thanks in advance
Sean
Bookmarks