Blood Count (CBC) Tracker

Tracking the results of your Complete Blood Count (CBC) tests is one of the tools that your doctor may use to make decisions about diagnosis and treatment. Some online medical services will show graphs of past results, but if you are getting tests from various labs, or switching doctors, or just wanting to avoid being kept in the dark about your own health, you may want a place such as a spreadsheet to keep track of all your own tests.

This spreadsheet was designed specifically for tracking results related to Polycythemia Vera, but it may also be helpful for other conditions. You should not use it, or make decisions based on it, without the assistance of your qualified doctor. The worksheets were designed for printing, so you can take your charts and data with you to appointments if you want to discuss them. Always consult with your doctor regarding any changes in medications and symptoms!

Blood Count Tracker

for Excel

Download

⤓ Excel (.xlsx)

For: Excel 2013 or later

License: Personal Use (not for distribution or resale)

Author: Jon Wittwer

Note: The sample data used in this image are meant only for illustrating features of the template such as the graph and timeline labels, and not meant to be used or analyzed as an actual case study.

⤓ Google Sheets

The GS version is slightly different - doesn't have the same functionality as Excel.

Description

This spreadsheet provides a starting point for you to be able to log your test results and graph them. Charts are particularly useful and I've included charts for some values such as Hemoglobin, Platelets, RBC, Hematocrit, and WBC. You may want to track other values, and doing so would involve adding more columns to the "My Lab Data" worksheet and also creating new graphs. Creating and editing the graphs may require significant knowledge of Excel.

Consult with your doctor about what levels for these various tests are "normal" for you. The template includes some generic ranges which are shown as horizontal lines on the graphs, but you can edit these ranges at the top of the "My Lab Data" worksheet.

🖈 Timeline: In addition to graphing CBC test results, it may be useful to include notes directly on the graph. In addition to adding data labels for specific test results, I've added a timeline series to the graph with pin-like markers. You can make notes about symptoms, procedures, medication, etc. For more information about creating timelines in Excel, see the Vertical Timeline in Excel page.

Graphing Something Else: At the moment, the main graph is showing the Hematocrit level, because that is one of the main numbers monitored for Polycythemia Vera patients. If you are familiar with modifying chart series, you can change the chart to graph a different test result. If you want to create a new chart, make a copy of the existing chart and then modify the data series in the new chart.