This is a conversion of a medication log that reports the exact days when the meds were started and stopped into a data set that shows which medications a person was using when they visit the clinic.
Refer to "medlog by visit manual [login to view URL]" and the worked examples for subjects DAT-102-06-13 to DAT-04-107-09, and the raw data for subjects before and after these.
The medications can be started (MedStatus=1), changed (Medstatus=2), or stopped (Medstatus=5) in between visits, but we only want to keep data that shows which Medications (coded by number, colum H) are currently being taken at each VisitDay. Thus, when changes to medications occur prior to, or in between VisitDay(s), we are only interested in the most recent changes.
For each subject (ID), where VisitDay is < the lowest MedChangeDay, 0's need to be entered in columns D-H.
Where VisitDay=MedChangeDay, the medications that were current for immediately prior to VisitDay are entered for that VisitDay.
You will need to keep "bringing forward" medications that are started prior to a visit, but are not changed between Visits. See worked examples.
Similarly, when there are multiple Visits after the last MedChangeDay, the medications will need to be "brought forward" for all subsequent visits, unless there is a change in MedStatus in between those visits which dictates a change.
Finally, "medlog by visit manual [login to view URL]" was created by interpolating the data from "Medlog [login to view URL]" in between the dates for VisitDay. Approximately 3% of the time, an error was introduced. So, whilst you can use "medlong by visit manual [login to view URL]" to make the changes, you will need to cross-check with the data in "Medlog [login to view URL]" to ensure that the error is fixed or marked to our attention. Similarly, please annotate the file where data is missing (eg MedChangeDay is missing in 1% of cases).
Accuracy is important in this project.
Thanks,
Brendon
I have worked in back office operations for an investment bank for the last 14 years so firmly appreciate the importance of accuracy in a project like this. I have also programmed data extraction exercises like this many times - most particularly when we acquired new businesses and needed to import their historical data into our operational systems.
I would tackle this project programatically with all the required logic handled automatically. That way the efficiency and accuracy is assured. Communication is key with any project where the client and freelancer are in different countries - having English as a first language will help avoid any confusion. In addition I have a strong background in project management so will ensure all the necessary controls are in place to get this delivered on time and budget. You can review my previous project reviews for corroboration.
If you would like to contact me to get further detail on my background and abilities, please message me. I look forward to working with you on this if I am successful in the bid.
Regards
Steve
$250 USD 3 gün içinde
5,0 (2 değerlendirme)
4,2
4,2
9 freelancers are bidding on average $389 USD for this job
Hi!
I have reviewed the details but I think we need to talk on skype. Please send me chat so that I can send you my skype id to discuss the project in detail.
Regards
Khurram
Hello,
I am very interested in this project. I will use Visual Basic for Applications to analyze and report on the medications log, it should be very straightforward.
I am an Engineer from Nova Scotia, Canada. I work for a large Engineering/Project Management company. I am relatively new to Freelancer, but I've programmed countless VBA projects for my employer; budgeting tools, reporting tools, Access databases, etc. I am a native English speaker and I am easy to communicate with.
Please have a look at my feedback.
Cheers,
William
Hello, I should be able to do this for you. I would have some additional questions to verify your exact intent. I look forward to possibly helping you out.
Respected Client,
Resourcefulness. Dedication. Professionalism.
As an expert Virtual Assistant, these are the attributes that drive me and these are the attributes that I bring to work.
I am keenly interested in helping you out with this task and assure about two things:
1. 100% Accuracy
2. Delivery within Deadline
I have always taken pride in my straight forward approach to service, as well as my ability to attain clear details, and willingness to learn new and advance technologies. I would like the opportunity to share more of my passion, dedication and know how in person.
I am Looking forward to a hearing from you.
Regards
Rabail Malik
I am into US healthcare business since last 8 years. I have worked with several doctor offices and with many pharmaceutical company's as an admin assistant. I know what exactly you are looking for. PM me lets chat and finalize. i look forward to hear from you soon!!