Quick Steps

Blood Pressure Tracker documentation

2 Simple Steps to start working

  1. Enter your Name, Age, Start Date & Gender on the "Daily Record" Worksheet. Choose the number of Readings per Day and enter the Readings Times. Select the AM/PM Readings to be displayed in the "Blood Pressure Tracker" Worksheet
  2. Enter your Systolic, Diastolic & Heart Rate Readings in the Table in the "Daily Record" Worksheet - now you have began the process to monitor your Blood Pressure

Acknowledgement

Blood Pressure Tracker was written by Mark Kubiszyn

  • the latest version is version 2
  • as per terms of the Software License, you should leave the following code attribution in situ

' © Copyright/Author:
' Mark Kubiszyn 2012-2017. All Rights Reserved
' Website/Follow:
' http://www.kubiszyn.co.uk/
' https://www.facebook.com/Kubiszyn.co.uk/
						

Purchase

You can Purchase Blood Pressure Tracker for £2.99 via FastSpring by clicking here

The How To Worksheet

The "How to..." Worksheet contains helful information on how to setup, record and print your Blood Pressure Readings - there are also Hyperlinks that you can click to navigate to the various sections (using the little triangles). It is recommended that you follow each part of the "How to..." when first using the Blood Pressure Tracker

The Daily Record Worksheet

The "Daily Record" Worksheet is used to setup your personal details and enter your daily Readings - there are 3 steps that you should follow to enter data into this section:

1. Edit the data in the shaded Cells to setup the Blood Pressure Tracker
- Populate the shaded areas with your Name, Age, Gender etc.
- Select the number of Readings per day to perform and enter the Times. You can have up to 4 Readings a day for different times ie. 08:00:00, 11:00:00, 16:00:00 & 21:00:00
- Set the Targets for Systolic and Diastolic ranges so that if they are exceeded they will be Conditionally Formatted in Red Fill with a Yellow Font ie. 140/80
- Select the AM and PM Reading Times that will be displayed in the Blood Pressure Tracker Worksheet as a summary. These can be chosen from a Drop-down Combo Box and the options are the Times that you setup for your daily Readings

2. Tab across and enter your daily SYSTOLIC, DIASTOLIC & HEART RATE readings
- Use the Tab Key to move across and enter your Readings. As you Tab through the Table you will see that the Formula automatically create the correct Calendar Days and Times for all of your Readings based upon the settings that you have made. You can also enter a Note in the last Column

3. Tab across to the last Table Cell in a Row to automatically add the next line of measurements
- To extend your Readings in the Table Tab in the last Cell of the last Column of the last Row in the Table

The Blood Pressure Tracker Worksheet

The "Blood Pressure Tracker" Worksheet is used to display a summary of the daily Readings in Tables and Charts. It details average Readings for individual Weeks and grouped averages across 4, 8, 12 & 26 Weeks depending on the length of time that you have been monitoring and updating your Readings in the "Daily Record" Worksheet. You can also drill-down and view average Readings by Week and Time in a Table containing all of your current Readings aggregated to Week (scroll down the Worksheet a little)

The data will update as you fill in your daily Readings and the Charts will track your progress displaying a graphical view of Systolic, Diastolic & Heart rate. Two Trendlines are displayed to detail the linear Trend in Systolic and Diastolic Readings

The Record Worksheet

Use the Record Sheet to Print a Sheet that you can populate with your Blood Pressure readings if you don't want to enter every reading direclty into the Blood Pressure Tracker. You can then update the Tracker whenever you like

Screen Shots

Blood Pressure Monitor How-to Screen Shot - gives you some basic information about how to fill in each section and allows navigation to each separate Worksheet:

Blood Pressure Tracker How-to Screen Shot

Blood Pressure Monitor Daily Record Screen Shot - this is where you fill in your Name, Age, choose how many readings you want per Day etc. and also where you enter your daily readings :

Blood Pressure Tracker Daily Record Screen Shot

Blood Pressure Tracker Screen Shot - this is the Tracker that details your readings in a summary giving you averages of all of your readings and a Chart that plots them to give a graphical representation of Diastolic, Systolic and Heart Rate against Time:

Blood Pressure Tracker Screen Shot

Blood Pressure Record Sheet Screen Shot - this is a simple printable Sheet so that you can record readings without the Software (I use this to record lots of readings and then I transfer them into the Blood Pressure Monitor at a later point in time):

Blood Pressure Record Screen Shot

Support

Support is only given to Purchased Software. You should only contact me on the Support Email address supplied by FastSpring - please provide proof of purchase ie. Email address or Order Reference

Changelog

13.05.2017 - Version 2 - slight modifications to the Charts, Formula & License

08.11.2015 - Version 1 released