I have pasted a dropbox 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)
https://www.dropbox.com/s/a5dllb4gzoxb7mj/Sample%20sheet%20for%20Chandoo%20forum-%20Mar%202013.xlsx
Thanks in adance
Sean
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)
https://www.dropbox.com/s/a5dllb4gzoxb7mj/Sample%20sheet%20for%20Chandoo%20forum-%20Mar%202013.xlsx
Thanks in adance
Sean