Numbers Template to monitor Blood Pressure
Does anyone have or know of a Numbers Template to monitor and chart Blood Pressure?
iMac (Retina 5K, 27-inch, Late 2014), OS X Yosemite (10.10.3)
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Does anyone have or know of a Numbers Template to monitor and chart Blood Pressure?
iMac (Retina 5K, 27-inch, Late 2014), OS X Yosemite (10.10.3)
Mr Barrett,
there is no template. You can, however, create one very easily.
In the first row enter "Date and Time" in column A
In the first row enter "Systolic" in column B
In the first row enter "Diastolic" in column C
in the table formatter on the right make the table have one header row:
enter the date and time in column A with the corresponding measurements in columns B and C
You only have to do this once:
now select columns A, B and C:
now add a scatter chart from the charts menu:
Now add data to the table as you measure blood pressure:
Mr Barrett,
there is no template. You can, however, create one very easily.
In the first row enter "Date and Time" in column A
In the first row enter "Systolic" in column B
In the first row enter "Diastolic" in column C
in the table formatter on the right make the table have one header row:
enter the date and time in column A with the corresponding measurements in columns B and C
You only have to do this once:
now select columns A, B and C:
now add a scatter chart from the charts menu:
Now add data to the table as you measure blood pressure:
Depending on your use case, and if you have an iPhone, maybe the Health app would be a good place to store the data.
I tried to download your template but Google Drive says that the file is in your trash.
I have made a file that you can download here - https://drive.google.com/open?id=0B0y79HErN0jDdy1YRGhzRERxaDg
If you open it, you can save it as a template.
You fill in the systolic and diastolic and pulse values. I have included a second set of values so that you can take your pressure a few minutes apart because it changes minute by minute. The sheet will automatically work out whether your pressure is High, Pre-high, Normal or Low in the status fields.
The only fields you have to fill in are Date, AM or PM, 1st Systolic, 1st Diastolic, 1st Pulse, 2nd Systolic, 2nd Diastolic and 2nd Pulse. The chart will automatically update for you to show your readings over time.
If you save as a template, you can start with a clean table every time you fill one up, which will keep all of your history.
Hope this helps.
I added another column for heart rate and included it in the scatter plot. Is there any way to select the colors used? I'd like to make the Heart rate red.
Thanks
Numbers Template to monitor Blood Pressure