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.
11 freelanceria on tarjonnut keskimäärin 53 $ tähän työhön
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.