View Single Post
  #4  
Old Mon Oct 27, 2014, 10:54 PM
MissDaisy MissDaisy is offline
Member
 
Join Date: Sep 2013
Posts: 6
Quote:
Originally Posted by Data View Post
Hello,
I started tracking my CBC results when I noticed a decline in a few parameters (RBCs, WBCs, Platelets, etc.). I made the attached spreadsheet and thought some of the folks on this forum might find it helpful.

First of all the data in the spreadsheet is just bogus data to illustrate the functions. As you enter a CBC result under the correct date it will indicate whether the value is above or below the normal values with an up or down arrow in the cell. You can change the low and high for each CBC parameter. As you enter successive values for a CBC parameter the graph will give you a visual presentation of the data over time. It is useful for seeing levels that are trending down or up or a spike at some point in time.

The graph will keep track of WBCs (Leukocytes), RBCs (Erythrocytes), Hemoglobin, Platelets, Hematocrit, and Mean Corpuscular Volume. The WBCs, RBCs, and Hemoglobin are in red and tracked on the left Y axis. The Platelets, Hematocrit, and Mean Corpuscular Volume are in green and are tracked on the right axis. Both axis are set to auto range. The X axis (date) will also auto range.

The spreadsheet was created in Excel 2010 and does not use any macros.

I hope this will be helpful.

Data
How timely that I found your post tonight. I was discussing this with my hubby to see if he would create a spreadsheet to track my labs.

I don't have anything seriously wrong with me, but I am diagnosed with Chronic Idiopathic Neutropenia. I am not neutropenic at the moment but I do have times when I am.

I will take a look at your spreadsheet and thank you for all your hard work.

MissDaisy
Reply With Quote