# 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 &lt;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

Tentang Majikan:
( 2 ulasan ) Vancouver, Canada

ID Projek: #1543990

torajiv

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

(71 Ulasan)
5.6

## 14 pekerja bebas membida secara purata \$116 untuk pekerjaan ini

pishty

I am interested in your project.

(30 Ulasan)
5.6
imudita

I have done it. Please see PM.

(27 Ulasan)
4.6
selopezr

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

(15 Ulasan)
4.2
hfbaker

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

(4 Ulasan)
3.7
TarekYagh

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.

(6 Ulasan)
3.1
AccuPro

Can do this.

(4 Ulasan)
3.0
gerrymwalsh

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

(1 Ulasan)
2.4
doaabayoumy

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

(2 Ulasan)
1.6
iosifrn

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

(1 Ulasan)
1.0
daexpert

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,

(0 Ulasan)
0.0
samuelfranca

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,

(0 Ulasan)
0.0
EdDrakes

Please see the private message and attachment.