We are a medical clinic working alongside other clinics. We look after acute (new) medical problems as well as chronic (long-standing) medical problems. We prescribe drugs based on the patients problems. When patients have chronic (long-standing) problems or use certain drugs, monitoring of blood levels may be required. I wish to automate the process of producing the blood form for these chronic disease patient.
Initial excel document - we already have a copy but this may need to be modified. See attached document.
1. We will need to create a list of searches that will need to be performed on our clinical system. The different lists we will include different medical conditions and also users of different medications. We will import this data from our medical system into the excel document.
2. Need an Excel document. First sheet will be where we copy our raw data. It will be a culmination of all the lists created in number 1. It will mean that some patients may have multiple duplicate records on this sheet if they have more than one medical problem or use multiple drugs that need monitoring.
3. The next sheet will automatically take this excel document and put it into order of the unique identifier which is the NHS number. It will now be easy to see the duplicate records for the same patient.
4. The next sheet will automatically combine the different data for each patient onto a single row. The duplicate records for the same patient and same NHS number are removed. We are left with one row per patient with all the lists in step 1 visible (if they have that medical problem or use that particular drug).
The blood form
1. The blood form example is attached.
2. The variable fields on the blood form include: doctors name, surgery barcode, NHS number, patient name, DOB, address, tick boxes for all the tests that could be picked, clinical details and additional tests that can be free typed. They may some others but these are the main ones I can see at present.
Automating the blood form completion
1. Different doctors will want different tests performed on the blood test depending on the medical problem a patient has. We therefore need a document which the doctor can adjust at any time to state what tests should be done for any listed medical condition or drug. It should be possible for us to change the different tests we want to order by a simple command.
An example copy of the different blood tests that will be required is attached. This list is not exhaustive and will a function for me to be able to add other diseases which require other blood tests.
2. Once the doctor is happy with this list detailed in automation step 1, all the blood forms can be created for all the patients in step 4 of the excel document.
Therefore, based on the 'excel document (step 4)', each patient listed on this sheet will have one (single sheet) blood form, with the appropriate tests ticked or added as per the rules set within 'automating the blood form step 1.
I would get a mail merge of all the blood forms in one go for all the patients on the excel list for that year.
12 freelancers are bidding on average $160 for this job
I'm a medical doctor I usually work with excel to do my statistics medical works I will be quick to finish this work If you are interested please answer back