#3 Click this link to see Blog page --> 02/01/2014 Tracey has a bunch of year end stuff to compile and tabulate for work and she asked me to write an #Excel program to help her figure out last years patient census for the year. She also wants to make it easier to keep track of all this stuff for the future as well. They are supposed to keep track of things like gender, age group, ethnicity, race, and a variety of classifications of patient status such as new patient, transfer in or out, got a transplant, died, ETC. It took me most of yesterday to figure out how to make it all work and we stayed up until midnight last night populating this spreadsheet with data for the year 2013. Tracey has been going crazy looking for 1 category that is off by 1 person. We found him! Evidently somebody at #Medicare or #Fresenius or whomever decided this guy was dead or gone or whatever. Medicare has killed off some of her patients over the past months and she has to call Medicare up and resurrect the patients information in the database. |
MjL |