MedLog by Visit

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 [url removed, login to view]" 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 [url removed, login to view]" was created by interpolating the data from "Medlog [url removed, login to view]" in between the dates for VisitDay. Approximately 3% of the time, an error was introduced. So, whilst you can use "medlong by visit manual [url removed, login to view]" to make the changes, you will need to cross-check with the data in "Medlog [url removed, login to view]" 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.



Alternatively and perhaps more simply, you can use the source data in "medlog Visitdays.xls" and "Medlog 2014Feb24.xls" to create the desired medlog by visit data file. This will remove the need to cross check the data.

I have added a worked example in the file "medlog by visit worked example.xlsx" to give you a better idea of what is required.

Beceriler: Veri Girişi, Veri İşleme, Excel

Daha fazlasını gör: log cross, data entry from raw, dat entry, raw log, missing columns data, annotate, data conversion manual entry, cross check excel, project clinic, excel data entry cross check, cross check data excel, conversion dat file excel, data cross check, time conversion excel, dat excel conversion, excel file dat file, dat file excel conversion, medications, dat file conversion excel, excel cross check, make dat file excel file, excel time log data entry, excel data dat file, dat file excel, dat file conversion xls file

İşveren Hakkında:
( 1 değerlendirme ) Somerville, El Salvador

Proje NO: #6518574



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 m Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 250%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(2 Değerlendirme)

Bu iş için 9 freelancer ortalamada $389 teklif veriyor


A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde588%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(15 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(28 Değerlendirme)

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. Daha Fazla

in %bids___i_period_sub_35% gün içinde355%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(14 Değerlendirme)

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 inter Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(15 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)

I am a Pharmacist with excellent knowledge of medicines.I have experience of medical writing and research.

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)