Homesteading Forum banner

Need Spreadsheet Help

1K views 11 replies 5 participants last post by  NRA_guy 
#1 ·
I want to track my blood pressure and heart rate in Calc. The main thing I want is a graph that shows BP over time, with a variable number of readings per day.

Here's my biggest problem: I have several readings a day at random times. If my BP is in normal range, I might have only 2 or 3 readings, but on days when BP is spiking, I might have as many as 12 (or more) readings.

It would be interesting to graph either by systolic, diastolic, or heart rate, but include all 3 values in graph.

Would it make sense to have a separate sheet for each day?

My thinking is each row would represent a time on a specific date. That would give me a simple record of date, time, systolic, diastolic, heart rate, comment. Then as many rows as I have times for that day.
 
#5 ·
Just bit info. If you dont have an android device, there are windows and linux emulators you can use to run android apps.

If you dont have excel, many excel templates will work with other free spreadsheet programs. You most likely will have to rename the template from "xlsx" to just "xls" I had no problem opening above excel template for bloodpressure in Gnumeric spreadsheet in Puppy Linux once I renamed it with xls suffix. Sure it would work fine in LibreOffice spreadsheet too.
 
  • Like
Reactions: miggyb
#8 ·
Here is the one I made with excel, but had to convert to jpg to upload. I made this when my Dr gave me a log to use and it was horrible. He loves this one and I gave him blanks for his other patients.. Hope this helps
 

Attachments

#10 ·
It used to be easier to create graphs in earlier versions of Excel, but you can do it. I do it fairly often.

I have a graph that tracks my PSA numbers.

I also have a spreadsheet (that the PSA graph comes from) that tabulates all of my blood pressure readings, heart rate, weight, and PSA numbers. I get the numbers at various times throughout a year. My data goes back about 10 years.

All you need to do is format column A in the date format that also includes the time of day. (That is one of the choices in formatting a column.) You can also enter a heading in A1 such as "DATE AND TIME".

Then format columns B, C, and D as numbers and label the headers "SYSTOLIC", "DIASTOLIC", and "HEART RATE".

Then enter your data in rows in chronological order. (Or you can let Excel sort them in chronological order.)

Then select with your mouse the whole filled in data set including the headers.

Then click in the top of the sheet "INSERT"---> "CHART" and choose "INSERT LINE CHART".

That should do it.

If you have trouble, email me at JerryHaskins@hotmail.com. If you send me some data (does not have to be your actual numbers) I can probably create the spreadsheet with the graph for you and send it back to your email address as an attachment, which you can save.

Then you can edit and add to it at will. But when you add rows of data, you will just have to reselect the data with your mouse that you want to show in the graph. No big deal.
 
#11 ·
It used to be easier to create graphs in earlier versions of Excel, but you can do it. I do it fairly often.
Thanks. I made one several years ago to track PSA too. I think your idea of combining date and time may work better than the way I was setting mine up, which was separate columns for date and time.

I got sidetracked on other projects, so haven't got back to working on the spreadsheet.
 
#12 ·
OK.

The date format that you probably want to look for is "3/14/12 1:30 PM".

It's in the pull-down list of date format choices.

I've never really used that particular format because the time of day is rarely important in the things I do.

But I experimented with it last night and it seemed to work.

Good luck.
 
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.
Top