It appears you have not yet Signed Up with our community. To Sign Up for free, please click here....



High & Low Blood Pressure Message Board
Post New Thread   Closed Thread
LinkBack Thread Tools
Old 11-24-2004, 12:37 AM   #1
Member
 
Join Date: Apr 2004
Location: Hampshire, England
Posts: 63
*Paul HB User
Hi Beerzoids

Hi,
In my previous thread about BP readings you discussed you techniques and that you had many readings you have taken over the years. I was wondering do you have an effective spreadsheet you use to understand these readings (That you wouldn't mind sharing), after all those readings you must have a great system in place. At present my own spread sheet caters for 2 readings a day (AM and PM), but if i try adding and more the how sheet becomes muddied and i think the doc will have trouble following it. If you don't mind sharing your secrets that would be much appreciated.


Thanks for all your advice

Paul

Last edited by *Paul; 11-24-2004 at 06:14 AM.

 
Sponsors Lightbulb
   
Old 11-24-2004, 07:30 AM   #2
Senior Veteran
(male)
 
Machaon's Avatar
 
Join Date: Feb 2003
Location: Fort Laud
Posts: 4,018
Blog Entries: 22
Machaon HB UserMachaon HB UserMachaon HB UserMachaon HB UserMachaon HB UserMachaon HB UserMachaon HB UserMachaon HB UserMachaon HB UserMachaon HB UserMachaon HB User
Re: Hi Beerzoids

Quote:
Originally Posted by *Paul
Hi,
In my previous thread about BP readings you discussed you techniques and that you had many readings you have taken over the years. I was wondering do you have an effective spreadsheet you use to understand these readings (That you wouldn't mind sharing), after all those readings you must have a great system in place.
I use a database program to store my readings by date, by hour. Then I use the database to summarize my readings by day, or by year and week, or by year and month, or by hour, and then copy and paste the summarized readings into my spreadsheet for charts.

If you didn't have a database program, or weren't familar with one, then you could use a word processor to enter your readings, or a product like Notepad.

I use a 24 hour clock for storing my readings. Here is an example of how I would store my readings using Notepad:

date,hour,syst,diast
11/23/2004,20,159,106
11/23/2004,21,142,89
11/23/2004,21,161,99
11/24/2004,6,127,77
11/24/2004,7,144,99
11/24/2004,8,127,77

Notice that I only store the hour, without the minutes. The 20 on 11/23/2004 means 8pm. The easy way to convert is to add 12 to the "pm" time starting with 1pm through 12pm, which converts to 13 through 24.

Most spreadsheets allow you "text to column" operations, which allows you to take the readings, separated by commas and spread them to individual cells so that you can do charts.

Once you get the readings spread to individual cells, you can then do "sort" and "subtotal" type of data functions to average your readings by day or by hour. If you want other types of averagings, like by month and year, you would have to massage the date, using date functions.

One of my favorite charts is the one by hour. It shows me my blood pressure pattern during the average day, and also shows me when my blood pressure meds kick in, and when they start losing their effectiveness. Each one of us has a circadian rhythm, which controls at which times our endocrine system pumps chemicals (hormones) into our systems, which effects our blood pressure during the day. So, summarizing the readings by hour, and then doing a chart by "hour" will really open your eyes regarding how your blood pressure might change during the day.

Quote:
At present my own spread sheet caters for 2 readings a day (AM and PM), but if i try adding and more the how sheet becomes muddied and i think the doc will have trouble following it. If you don't mind sharing your secrets that would be much appreciated.


Thanks for all your advice

Paul
I don't mind at all.

I don't understand why your spread sheet only allows 2 readings per day. You can store anything you want in a spreadsheet.

What do you think about storing the readings in a world processor, or text processor like notepad? You can actually store your readings in the spreadsheet, if you find that more suitable, and then you would not have to cut and paste it into your spreadsheet.

Let me know if you have any more questions on how to do this, or questions about the individual steps or any problems you encounter while attempting to set it up. It would be interesting finding out what kind of charts you come up with, and what they tell you about your own blood pressure experiences.

Last edited by Machaon; 11-24-2004 at 10:14 AM.

 
Sponsors Lightbulb
   
Old 11-25-2004, 05:58 AM   #3
Member
 
Join Date: Apr 2004
Location: Hampshire, England
Posts: 63
*Paul HB User
Re: Hi Beerzoids

thanks for the advice, it has given me some good ideas. I think i need to expand on my current spreadsheet. Your process for storing the info in note pad seems a good place to start.

thanks again
Paul

 
Closed Thread

Similar Threads
Thread Thread Starter Board Replies Last Post
Beerzoids... bethsheba High & Low Blood Pressure 2 11-29-2007 03:49 AM
beerzoids, question about different way to use hydrogen peroxide 2talll Allergies 17 01-02-2005 08:46 PM
beerzoids, why Kosher salt? cicka Allergies 7 10-08-2004 03:53 AM
This is for beerzoids bharkins High & Low Blood Pressure 3 08-15-2004 10:13 AM
Beerzoids is right. chigs489 Allergies 2 07-24-2004 11:41 AM




Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




Sign Up Today!

Ask our community of thousands of members your health questions, and learn from others experiences. Join the conversation!

I want my free account

All times are GMT -7. The time now is 12:34 AM.



Site owned and operated by HealthBoards.comô
Terms of Use © 1998-2014 HealthBoards.comô All rights reserved.
Do not copy or redistribute in any form!