Ouch! I am so sorry that I didn't respond sooner. Got a little distracted and missed this, glad it got bumped.
In my example when I import an excell spread sheet it is handled as an .xlsx file. When you try to open it, it returns to Excell to open it. When it is open in Excell it is a "living" document and YOU CAN MAKE CHANGES. I don't believe that will fly with CCHIT, but I am neither an IT person nor any sort of expert on CCHIT. To be legit, and what you would do if this was a paper chart, you must PRINT the spread sheet and then save it. Of course you can import the printed, (dead, permanent, unalterable) files into your chart.
In the past I, (like many of you) used pages that allowed multiple entries that often were not dated. The Problem list was one. I once testified in a case to defend a cardiologist, and because my first entry for alcoholic cardiomyopathy was undated on the problem list the judge would not allow that I had proof of the pre-existence of this condition. A CCHIT record would (I hope) not allow that sort of thing. In my current use of excell I do double entries, EVERYTHING on the spread sheet is in AC in the conventional (and unalterable ) manner. But the spread sheet allows me to see it at a glance, and to allow the system to help me calculate the dose.
To answer RomiB, neither will do what you want really at this point. The excell spread sheet is not a part of AC and you can't search it. The summary sheet in AC is very good for flu shots, but cumbersome for lab values.
I cling to the belief that when the big pieces are done, (CCHIT nad the PM portions) Jon will be able to return to some of these bells and whistles that we all dream of.
Martin
