formula comparing data in mulitple columns

jimerinbowers

New Member
Joined
Oct 19, 2002
Messages
2
If column BB contains "discharge to: info" for patient (i.e., "SNF", "Home", "Expired", etc) and column J contains "age: info" for patient (i.e., "55", "92", "16", etc), what formula (SUM, AVG, etc) do I write that considers only patients' "ages info" who have "expired" (i.e., BB4 contains "expired" and J4 contains "44"; BB7 contains "expired" and J7 contains "17"; etc). I need a formula that compares ONLY LIKE DATA from cells ("expired") in one column (BB, for instance) to data in cells in other columns (J or K or AA, etc) but on the SAME row (4). Probably a standard, elementary question but I am new to this and cannot find the proper "HELP" in the program or other materials at hand. Can you assist? Thank you.
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Hello jimerinbowers
Welcome to the Board

It may look like would use a cominiation of IF, Vlookup, or some others...

Care to post a sample of your data on a spreadsheet and the expected outcome you would like to see...someone here will solve this real quick.

You can use the Download Colo's cool utility for displaying your Excel Worksheet on the board...see below this message box..

pll
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
On 2002-10-20 15:30, jimerinbowers wrote:
If column BB contains "discharge to: info" for patient (i.e., "SNF", "Home", "Expired", etc) and column J contains "age: info" for patient (i.e., "55", "92", "16", etc), what formula (SUM, AVG, etc) do I write that considers only patients' "ages info" who have "expired" (i.e., BB4 contains "expired" and J4 contains "44"; BB7 contains "expired" and J7 contains "17"; etc). I need a formula that compares ONLY LIKE DATA from cells ("expired") in one column (BB, for instance) to data in cells in other columns (J or K or AA, etc) but on the SAME row (4). Probably a standard, elementary question but I am new to this and cannot find the proper "HELP" in the program or other materials at hand. Can you assist? Thank you.

What is the question?
 

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Hello jimerinbowers


I read your question again and tried to put a spreadsheet summary of what you might be asking. If this is the case, I have presented two sections ...one with raw data and then that range sorted.....by "Discharge" field first and "Age info" second field. You should be able to do this by highlighting the entire range including the names of the column, then data, sort, sort by selection....

If this is not what you are looking for, please clarify your question.

pll
Book1
FGHIJKLMNO
13Raw dataAfter Sort
14Discharge toAge InfoDischarge toAge Info
15SNF55Expired16
16Home92Expired17
17Expired16Expired44
18Expired44Expired55
19Home54Home54
20Expired55Home92
21Expired17SNF55
22
23
24
Sheet6
 

jimerinbowers

New Member
Joined
Oct 19, 2002
Messages
2

ADVERTISEMENT

pll:
I know this would be easier to answer if I downloaded the spreadsheet program but I am a little leary of doing that at this time. See if this makes sense to you: A sample group of...
Only those patients who are expired (for instance) are to be considered in any formulation. A number of different category columns describe other characteristics of the patient (Age, Length of Stay, various periods of time between certain administration events concerning patient, attending doctor, nursing station, etc.). By just considering "expired" patients, I can then calculate formulations pertinent to expired patients alone separate from the entire pool of patients hospitalized over a period of time (Not everyone dies here ;o)). I did not want to sort "expired" to another worksheet and use the formulas from the main spreadsheet for that group. Rather I wanted to add another column to the to the main spreadsheet that would include information regarding "expired" patients only along side the column(s) that contained calculations for all patients. Some of the categories by row (from columns a:d--separated from the section containing data entries of each patient--columns f:bz) would be Average length of stay, days from consult to expiration, days from admission to DNR code status, and a multitude of other categories. I consider averages, sums, percent of category responses, percent of patient considered, etc.
Does this make sense? Somehow I need to isolate groups of patients by unique characteristics (i.e., "expired") appearing in one column and relate that info in various ways to the data that appears on those patients that has been inputted in cells from other columns. (In all cases ONLY considering data that appears on the same ROWS of the column that contains the cell with the unique characteristic (as exampled, "expired"). There are fify +/-columns of various categories concerning each patient. Sorry if this is tedious. I appreciate your help. God bless.
 

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Hello jimerinbowers

I think to give you as many options as possible and to make your question a bit more clear.... a sample representaion of your data and your expected results would be very helpful. A short display is all that is needed.


pll
 

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS

ADVERTISEMENT

Hello jimerinbowers



I have received your PM with the worksheet attached. It is in the best interest to try to post any details and sample worksheets to this board, as this is a sharing and learning forum for all participating. I took the liberty to extract a sample portion of your large worksheet to help identify your question to many others much more capable than I.

I will try to restate your question...You want to compare/collect from each of the deceased persons selected data that you have arranged in columnar format. For those reading this inquiry the full worksheets is approx 55 columns and as many rowws down.

A possible solution might be to autofilter the range you would like to compare...In that process you can select on any of columns you select in the filter. Is this the direction would are looking for. If not, please restate your question referring to the spreadsheet posted... and the outcome you expect so others might give some better suggestions.

good luck
pll
Test.xls
BCDEFGHIJKLM
20
21DateMedical Record #Acct #NameAgeGenderEncountersConsult HoursDischarged toAge Exp
22Patients Expired Over 30 DaysApr02xy101x190F11.5Expired90
23??????????Apr02xy102x269F22Hospice at HomeFALSE
24??????????Apr02xy103x312M2028Expired12
25??????????Apr02xy104x422M11Own HomeFALSE
26??????????Apr02xy105x585F22SNFFALSE
27??????????Apr02xy106x663F12Expired63
28??????????Apr02xy107x70M11.5Expired0
29??????????Apr02xy108x880M11Hospice at HomeFALSE
30??????????Apr02xy109x970F11.5SNFFALSE
31??????????Apr02xy110x1074F1822Expired74
32??????????May02xy111x1180F21.25Expired80
33??????????May02xy112x1245M11.5Own HomeFALSE
34??????????May02xy113x1370F55SNF/HospiceFALSE
35
Sheet2
 

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
I appologize, but I would like to bump this inquiry up as additional feedback would be helpful to the sender


pll
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi jimerinbowers:

As it has been stated warlier, it is not clear what information you want to extract. I have used the data posted by pletterei, and assumed you want to extract, say 3 fields for all expired patients -- I have used Advanced Filter to extract the records next to the original table. See the worksheet simulation and advise if this is wwhat you are looking for.<SCRIPT LANGUAGE="JavaScript" SRC="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT><CENTER><TABLE align=CENTER cellpadding=0 cellspacing=0><TR><TD COLSPAN=16 BGCOLOR=#0C266B style="border-left:.5pt solid #000000;border-right:.5pt solid #000000;border-top:.5pt solid #000000;"><TABLE ALIGN=CENTER BORDER=0 WIDTH=100%><TR><TD ALIGN=LEFT><FONT COLOR=WHITE>Microsoft Excel - y021020h1.xls</FONT></TD><TD ALIGN=RIGHT style="font-size:9pt;color:#000000;font-family:caption;color:#ffffff;">___Running: xl97 : OS = Windows 98</FONT></TD></TR></TABLE></TD></TR><TR><TD BGCOLOR=#D4D0C8 COLSPAN=16 style="border-left:.5pt solid #000000;border-right:.5pt solid #000000;height:25px;"><TABLE BORDER=0 ALIGN=CENTER VALIGN=MIDDLE WIDTH=100%><TR><TD style="font-size:10pt;color:#000000;font-family:caption;">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp (<U>A</U>)bout</TD><TD ALIGN=RIGHT VALIGN=MIDDLE><FORM NAME='formCb774123'><INPUT TYPE='Button' NAME='btCb986984' value='Copy Formula' onClick='window.clipboardData.setData("Text",document.formFb705783.sltNb197640.value);'></FORM></TD></TR></TABLE></TD></TR><TR><TD BGCOLOR=WHITE COLSPAN=16 style="border-left:.5pt solid #000000;border-right:.5pt solid #000000;"><TABLE BORDER=0><TR><Form name='formFb705783'><TD ALIGN=CENTER BGCOLOR=White style="width: 60px;"><SELECT NAME='sltNb197640' onChange='document.formFb705783.txbFb115412.value = document.formFb705783.sltNb197640.value'><option value=''>B17</select></TD><TD WIDTH=3% ALIGN=RIGHT BGCOLOR=#D4D0C8 >=</TD><TD ALIGN=LEFT BGCOLOR=White><input type='text' name='txbFb115412' size='80' value=''></TD></form></TR></TABLE></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="border-top:.5pt solid #000000;border-left:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>B</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>C</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>D</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>E</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>F</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>G</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>H</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>I</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>J</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>K</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>L</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>M</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>N</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>O</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>P</CENTER></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>17</CENTER></TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">source data</TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFF99;border-top:.5pt solid #000000;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">Age_Exp</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>18</CENTER></TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFF99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">criteria</TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFF99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">>=0</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>19</CENTER></TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">output</TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>20</CENTER></TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #000000;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #000000;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>21</CENTER></TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">NoHeader</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Date</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Medical Record #</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Acct#</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Name</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Age</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Gender</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Encounters</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Consult Hours</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Discharged to</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Age_Exp</TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">Acct#</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">Age</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">Name</TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>22</CENTER></TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Patients Expired Over 30 days</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2-Apr</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">y101</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x1</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">90</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">F</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">1</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">1.5</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Expired</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">90</TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">y101</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">90</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">x1</TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>23</CENTER></TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">??????????</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2-Apr</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">y102</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x2</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">69</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">F</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Hospice at home</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">FALSE</TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">y103</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">12</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">x3</TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>24</CENTER></TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">??????????</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2-Apr</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">y103</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x3</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">12</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">M</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">20</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">28</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Expired</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">12</TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">y106</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">63</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">x6</TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>25</CENTER></TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">??????????</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2-Apr</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">y104</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x4</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">22</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">M</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">1</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">1</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Own Home</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">FALSE</TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">y107</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">0</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">x7</TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>26</CENTER></TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">??????????</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2-Apr</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">y105</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x5</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">85</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">F</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">SNF</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">FALSE</TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">y110</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">74</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">x10</TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>27</CENTER></TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">??????????</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2-Apr</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">y106</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x6</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">63</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">F</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">1</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Expired</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">63</TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">y111</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">80</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFCC99;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">x11</TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>28</CENTER></TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">??????????</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2-Apr</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">y107</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x7</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">0</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">M</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">1</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">1.5</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Expired</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">0</TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>29</CENTER></TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">??????????</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2-Apr</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">y108</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x8</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">80</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">M</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">1</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">1</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Hospiceat home</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">FALSE</TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>30</CENTER></TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">??????????</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2-Apr</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">y109</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x9</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">70</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">F</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">1</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">1.5</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">SNF</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">FALSE</TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>31</CENTER></TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">??????????</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2-Apr</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">y110</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x10</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">74</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">F</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">18</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">22</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Expired</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">74</TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>32</CENTER></TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">??????????</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2-May</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">y111</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x11</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">80</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">F</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">1.25</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Expired</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">80</TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>33</CENTER></TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">??????????</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2-May</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">y112</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x12</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">45</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">M</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">1</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">1.5</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Own Home</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">FALSE</TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>34</CENTER></TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">??????????</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2-May</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">y113</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">x13</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">70</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">F</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">5</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">5</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">SNF/Hospice</TD><TD style=" text-align: center; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">FALSE</TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: middle;background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD COLSPAN=16 style="border-left:.5pt solid #000000;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;border-top:.5pt solid #808080;;background-color:#D4D0C8;"><TABLE ALIGN=LEFT VALIGN=TOP width=100%><TR><TD ALIGN=LEFT style="border-left:.5pt solid #000000;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;border-top:.5pt solid #808080;background-color: #FFFFFF; width:120pt;"><U>Sheet5</U></TD><TD> </TD></TR></TABLE></TD></TR></TABLE><FONT COLOR=#339966 SIZE=1>[HtmlMaker 2.20]</FONT><FONT COLOR=#339966 SIZE=1>To see the formula in the cells just click on the cells hyperlink or click the Name box</FONT><FONT COLOR=RED SIZE=1>PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAG

Regards!

Yogi
This message was edited by Yogi Anand on 2002-10-20 21:40
 

Watch MrExcel Video

Forum statistics

Threads
1,122,564
Messages
5,596,875
Members
414,106
Latest member
Tigretto

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top