An article last week in ZDNet Healthcare, titled “ Creating personal health record value from the bottom up ”, focused on my recent posts about our Personal Health Profiler™ (PH Profiler) system. It describes the PH Profiler as a spreadsheet-based system in which “data is nested so you can drill into the detail. Links and databases can be added automatically so that when someone clicks on a condition the data says they have, they get real advice on what to do. … The goal [is] to link personal data to actionable information so you become a better-informed health consumer.” That’s true.
A bottom-up approach to PHR development, in contrast, is a process focusing on defining the fine details first, and then building up from those details to create the complete system. For me, the bottom-up process went something like this:
One thing this bottom-up approach taught me early on is that the data collected, reports generated, and technical methods used must be able to evolve continually as health knowledge grows, new technologies emerge, and standards change. That meant the PHP had to be a very flexible and adaptive system.
Furthermore, since I began this process in 1981, there was no Internet, the first personal computers were just coming to market, and it was decades before the ideas of a PHR was even being discussed in the healthcare industry. That meant we had to discover an original way to build the PH Profiler system. It also meant that we had to find a very cost-efficient way to operate the system since, back then, computer memory, speed and data storage capacity were tiny compared to today.
Having been intrigued by spreadsheet’s power, efficiency, ease-of-use, and “plasticity” (like molding clay into different forms), we began building the PH Profiler using spreadsheets in unique ways.
I've referred to the PH Profiler system as a “discontinuous/disruptive” innovation, This means it uses a radically different technological approach to developing personal health records, compared to existing dominant technologies or status quo products in a market. Unfortunately, disruptive innovations often go unnoticed, or they are ignored for many years. When they are finally recognized, businesses with a stake in maintaining conventional technologies tend to see them as threats and try to lock them out of the market. In fact, my idea of using spreadsheets as the foundation of a PHR application has been ridiculed and dismissed by conventional software developers in the past. This could be because they don’t realize how spreadsheets can be used in novel ways, they are fearful they might lose business to a simpler and less expensive technology, they don’t want to learn a new of developing software, or for other such reasons.
Nevertheless, I’ve persisted … and here’s why …
There are many huge advantages to using the spreadsheet for PHRs and other health information technologies, as long as you know how to handle the challenges. Spreadsheets, after all, have been around for decades, making them one of most sound and solid software ever created. They are efficient, low-cost, easy-to-use, and infinitely flexible (i.e., they can be molded into unlimited types of applications). In addition, spreadsheets have powerful data collection and sharing, computation, model-building, reporting, and automation capabilities. In other words, they offer a quick and easy way to obtain, organize, synthesize, analyze, evaluate, distribute, and display information.
On the down side, spreadsheets must be examined and controlled in order to prevent errors and unauthorized changes. The PH Profiler does all this in innovative ways.
One thing most people fail to realize is that a spreadsheet is much more than just a big electronic grid with charts. The truth is, a spreadsheet application has three major components:
These cells and code modules make spreadsheets excellent vehicles for developing robust health information applications from the bottom up, as I describe next.
Examples of how the PH Profiler uses Spreadsheets in Novel Ways
To exemplify what I’ve just written about spreadsheets, following are four groups of screen shots showing how the PH Profiler system uses spreadsheet forms, grids and modules in innovative ways that deliver a unique range of capabilities and benefits. They explain these processes:
1. First comes data definition and collection. As I said earlier, when I started developing the PH Profiler system, my goal was to create a software application able to manage every piece of relevant information over people’s lifetimes. This information would have the potential to help consumers/patients and their healthcare professionals develop a full and deep understanding of the person’s strengths, weaknesses, risks, problems, health trends (changes over time) and preferences, as well as the suitable options for prevention and treatment. I also wanted the information to be “self-actionable” by providing instruction, insight & guidance and warnings & alerts, which would promote a better quality of life by motivating and enabling the person to help him/herself deal with physical, emotional and behavioral concerns.
To accomplish this monumental task, I spent many years researching the healthcare literature and examining health questionnaires. During this process, I built “evergreen” (continually evolving) spreadsheet grids containing lists of questions to be answered by a consumer/patient, as well as by healthcare professionals. The PH Profiler system was then designed to manage people’s answers to these questions, along with data obtained from databases, web sites, data streams and electronic documents (including XML files). Figure 1 (below) shows a small section of one of the PH Profiler’s Question Grids.
This bottom-up path led to the invention of my patented CP Split™ technology and other “discontinuous/disruptive” innovations, which became key components of the PH Profiler system.
Referring to Figure 1:
Figure 2 (below) shows a series of screen shot depicting a type of user form the PHP system uses for manual data input. Macros automate the process by which the forms read the Question Grid above and present the questions and response options to the person; they also collect and store the person’s responses.
Figure 2 (click to enlarge)
As with all the PH Profiler system components, this patented data collection process is very flexible:
Note that entirely new Question Grids can be constructed at any time in the same manner. In fact, entire libraries of Question Grids can be developed for use by people with different roles and in different situations.
In any case, as the questions are answered, the PH Profiler automatically stores person’s responses in a list containing the question ID (in a cell of column A) and the person’s response next to it (in column B)—which comprise the “raw data” —as shown in Figure 3 (below). Note that data not manually entered (e.g., data queried from databases, extracted from documents, or streamed from medical devices) can be added automatically to the manually input data using custom macros.
Figure 3 (click to enlarge)
2. Next comes data organization and analysis. Once the raw data are collected, the PH Profiler uses another spreadsheet grid—the Publisher Spreadsheet Grid shown in Figure 4 (below)—whose cells contain an assortment of formulas (which are not visible in the screen shot). A portion of the Publisher Spreadsheet Grid is which, along with its macros, automatically transform the raw data into structured information ready for report writing. Most of the rules (algorithms) for analyzing the data are included in this spreadsheet and others to which it is linked. These rules may contain criteria identifying when certain data indicate the existence of a health problem (e.g., when a lab test is abnormal, when someone’s emotional or state or cognitions reflects a serious psychological concern, when a reported symptom may be due to an adverse medication side-effect, etc.).
Since this involves technical spreadsheet model-building, I’m not going to take the time to explain what exactly is in this spreadsheet. Suffice to say that the data in this publisher spreadsheet are organized and calculated in a predefined manner that corresponds to the PHP reports.
Figure 4 (click to enlarge)
3. Then the contents of the Publisher Spreadsheet Grid are stored and shared. The contents of the Publisher Spreadsheet Grid are now stored in another file, without any macros, formulas or formats. A section of the stored grid, which is called a “Content File,” is shown in Figure 5 (below). The Content File (which can be converted easily to a delimited text file ) is encrypted to protect the data inside. It can retrieved at any time the data needs to be updated, and whenever the person wants to view their information. And if they want, people can share any portions of of their Content File with individuals they authorize.
Note that the Content File can be saved in any location the person wants and its security is compliant with HIPPA regulations. This addresses a concern raised in a recent NY Times article, titled “Warning on Storage of Health Records”. The article discusses how the benefits of personal health records stored in Web-based databases is offset by concerns about risk to privacy. One way to diminish this risk is by putting health records directly in hands of the individual to whom they belong; that way individuals have complete control over who (if anyone) gets to see their personal information. The PH Profiler Content Files enable such protection.
Figure 5 (click to enlarge)
4. Now comes report generation. Figure 6 (below) portrays a piece of the PH Profiler report, which I discussed in my initial post on the topic. Only this time I’m showing columns B through F, which are hidden in the actual report.
Figure 6 (click to enlarge)
The cells in these columns contain numeric data that have been extracted from the PH Profiler Content File (described above). Other cells use these data to determine what rows should be visible and how the data should be displayed. For example, the series of blue boxes in cells K352 and K380, which indicate the amount of distress the person experiences in two situations, are created by a formula in those cells that use data in column E to determine the number of boxes to display.
A few other things about using spreadsheets for the PH Profiler reports:
Web-Enabling the PH Profiler System
The PH Profiler system was originally built as a stand-alone desktop application. We are now in the process of making in web-enabled as well, so anyone with a browser and Internet connection can use it. I will have more to say about this in future posts.
Fertilizing the Seed
The quote from the ZDNet article at the beginning of this post included the statement that the bottom-up strategy often resembles a “seed” model in which an application’s small beginning eventually grows in complexity and completeness. This requires that the “seed” be nourished (fertilized). The PH Profiler system is designed to grow and evolve continually through a collaborative process in which consumers/patients, sick-care and well-care professionals, research scientists, educators, software developers and others provide ideas and content that are incorporated into the system. Because it is built with highly efficient and flexible spreadsheets, uses a library of categorized data definitions (similar to a book libraries Dewey Decimal system), has a modular structure, and can interoperate with most (all?) other software system, the PH Profiler is able to molded and expanded into ever-more-powerful knowledge tools that are tailored to the needs of just about anyone. And best of all, this can be done for little cost and with little hassle, which is an important consideration in today’s difficult economic climate.
My hope is that these posts will help motivate people from all groups to join our team of collaborators and grow the seed we’ve been nourishing into a complete, diversified personal health knowledge system that has a positive impact on the health and wellbeing of all people.
In my next post, I discuss the strategy of open source software licensing as a means for imprive health worldwide.