# Rosendaal INR Calculation

Healthcare outpatient center (coumadin clinic) that needs a spreadsheet that will automatically calculate a % of a procedure that is in range as follows; 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. I could provied the general format needed and then you could put in the formulas.

Taidot: Excel

( 1 review ) Hagerstown, United States

Projektin tunnus: #398857

## 11 freelanceria on tarjonnut keskimäärin 53 \$ tähän työhön

lilyofthevalley

Excel Expert. Please check PM for details

30 \$ USD 0 päivässä
(0 arvostelua)
0.0
shikaymaru

I can do for less than \$30..and I'm very good at excel.

30 \$ USD 0 päivässä
(0 arvostelua)
0.0
Narenkotak

110 \$ USD 1 päivässä
(0 arvostelua)
0.0
JeffPerson

hello there. you wont regret it if you will choose me to do the task..ive done alot of excel and also access stuff with AGSE and NJA Theraphy (Pomona, CA) regards, Jeff.

50 \$ USD 0 päivässä
(0 arvostelua)
0.0
Ashmi

Hi, Am from INdia,Good in excel.

30 \$ USD 2 päivässä
(0 arvostelua)
0.0

While it seems like a simple project I always like to make suggestions if I can. Please check PMB for more details.

150 \$ USD 5 päivässä
(0 arvostelua)
0.0
SanelMuller

I'm deliver my work with professionalism and dignity. I'm a hard working South African committed to the job.

60 \$ USD 2 päivässä
(0 arvostelua)
0.0
cidai2000

My bid is for the minimum of \$30 to be finished within the day. merl

30 \$ USD 1 päivässä
(0 arvostelua)
0.0
kammeh1

I am Master degree holder (MBA finance) having lot of experience in accounting field. I also worked in one of the major pharma company in Pakistan i.e. Amson Vaccines & Pharma (pvt) more than 4 years. Being in accounti Lisää

30 \$ USD 5 päivässä
(0 arvostelua)
0.0
Sunny155

Hello Sir, I have created many complex calculation sheets in excel. I can do this work for you.

30 \$ USD 2 päivässä
(0 arvostelua)
0.0