Would someone be willing to post or email me (drjim@drspattyandjim.com) an example of an Excel speadsheet they use for tracking of this sort of thing? I remember reading this thread several months ago about how handy this tool is. I've used Excel before but not sure I'm handy enough with it to design my own spreadsheet capable of doing this.
My recollection is that the blank spreadsheet is saved to each patient's chart and then data is filled in as it comes in, correct? Can Excel then look at entire practice data (like, "what's my practice's average hemoglobin Aic?" or "list the names of all patients currently on coumadin") by extracting data from multiple individual spreadsheets, as well as looking at trends for any individual?
Thanks,
Jim (who's going live with AC in about a month and will likely be posting here a lot as I stumble through)
