Rosendaal INR

I need help to create a so-called Rosendaal calculator of INR (a measurement in blood) for our research project. Our data has 3000000 rows and here I attached a sample of it in MS Access. PT_ID is a patient identifier. INR is the test value. Date – date of the test. Each patient had multiple measurements – and is suppose to have the test value in range from 2-3 (inclusive). Our goal is to calculate the percentage of time each patient was within the specified range (2-3).

Example: Patient has an INR reading of 2.4 on October 1st, then a reading of 3.2 on October 17th. Assuming the patient gradually moves toward a reading of 3.2 throuhout the 16 day period between Oct. 1st and the 17th we can estimate that the patient was within their therapeutic range (2-3) for a majority of that time period. The spreadsheet would need to 1. calculate the total shift (example 2.4-3.2 = 0.8 increase) that is within therapeutic range (0.6 of shift within range (2.4-3.0 = 0.6) 2. Calculate the percent of total shift within therapeutic range (0.6/0.8 = 75%) 3. estimate number of days since last visit that were within range (75% x 16 days since last visit = 0.75 x 16 = 12 days within range, 4 days out of range) Percentage for that time period is 75% in range, and 12 total days in range.

0) We need to exclude Patients with less than 5 measurements (PT_ID repeated <5 times)

1) We need to sort data ascending for both PT_ID and Date.

2) Calculate the time difference (days) between every test for each Patient

3) Calculate the difference between each test value

4) Calculate the fraction of time each patient was within the specified range (2-3)

I can see the end result as report where rows are represented by non-duplicate PT_ID with a value of percentage of time each patient was within the INR range (2-3).

Kemahiran: Pemprosesan Data, Excel, Microsoft Access

Lihat lagi: rosendaal inr, inr rosendaal calculator, rosendaal inr range, rosendaal sample data, reading inr, less than excel, excel less than, october 14, measurement, increase value of project, excel duplicate, excel sort date, shift report spreadsheet, sort excel date, inr spreadsheet, sample test data processing, period calculator, blood excel, time within therapeutic range, days shift, shift days, rosendaal spreadsheet, access create estimate, data processing excel test, access calculator

Tentang Majikan:
( 2 ulasan ) Vancouver, Canada

ID Projek: #1543990

Dianugerahkan kepada:


I am a Lab Technologist by profession and an Access programmer by hobby. I know coding and I know what is INR! More details in PMB Thanks

$80 CAD dalam 2 hari
(71 Ulasan)

14 pekerja bebas membida secara purata $116 untuk pekerjaan ini


I am interested in your project.

$120 CAD dalam 4 hari
(30 Ulasan)

I have done it. Please see PM.

$50 CAD dalam sehari
(27 Ulasan)

Hello there! It´ll be a pleasure to serve you!. I´m attaching a sample of my work.

$30 CAD dalam sehari
(15 Ulasan)

I will calculate the percentage of time that each patient has an INR reading outside the range 2 to 3 based on the assumption that INR varies linearly between the beginning and end of each interval. I will send a priva Lagi

$120 CAD dalam sehari
(4 Ulasan)

Hi. I have the required skills and knowledge to satisfy your needs. I have made several Access databases so far. Please check your messages inbox for more details.

$30 CAD dalam 3 hari
(6 Ulasan)

Can do this.

$110 CAD dalam 3 hari
(4 Ulasan)

Hi, I have over 20 years access database development experience and can produce this excel spreadsheet for you.

$150 CAD dalam 5 hari
(1 Ulasan)

HI I have experience creating complex queries for accounting purposes; i think i can do this for you easily please read you private message

$150 CAD dalam 7 hari
(2 Ulasan)

Hello, I have over 16 years of programming experience in MS Access, VBA, Excel, Web Development, ASP.NET, SQL Server, ORACLE, MySQL, C#, Visual Basic and others. I worked for companies like SIKORSKY, GE Aircraft Engin Lagi

$125 CAD dalam 7 hari
(1 Ulasan)

Hi, I can help you for getting the final report. I had good skills in MS access. Please refer to PM for more details. Regards,

$250 CAD dalam 5 hari
(0 Ulasan)

I can help because I have an experience of 10 years in handling databases in MS Access. Please if um need more details, you can email me. Regards,

$100 CAD dalam 5 hari
(0 Ulasan)

Please see the private message and attachment.

$200 CAD dalam sehari
(0 Ulasan)

This is an interesting job for me and I will complete within 2 days. Check PM to complete your job with me. Thks.

$110 CAD dalam 2 hari
(0 Ulasan)