At VA Doc's request, I'm tracking my BP daily. I've recently found out that "pulse pressure" (Systolic minus Diastolic pressures) is also a diagnostic indicator.

Currently, I'm entering data twice: BP in Sys/Dia as 130/80 and then Sys and Dia in separate columns to calculate the PP. Just out of curiosity (and because I'm lazy...) I'd like to enter data just once.

Either enter Sys and Dia in separate columns to do the calc and have it transpose that data into a 3rd column in the Sys/Dia format, or the reverse.

Obviously NOT a huge problem, mostly curious. Hints? I'm using Open Office but I expect Excel methods would work as well.

Assuming Excel, but these are pretty basic formulas, so should work in things like Google Sheets & whatever the Apple version of Excel is.

ColA: Sys
ColB: Dia
ColC: =ColA&"/"&ColB
ColD: =ColA-ColB

Then you just enter your Sys & Dia in A & B and the other 2 auto calculate.

That works, thanks! (prior message, if you saw it, was because I screwed up the syntax...)

I spend most of my day in Excel, so this one was a lay-up

Some of the guys here that know VBA & Macros excel [pun] beyond my skillset, just not much need for those in my application.

quote:

At VA Doc's request, I'm tracking my BP daily. I've recently found out that "pulse pressure" (Systolic minus Diastolic pressures) is also a diagnostic indicator.

Currently, I'm entering data twice: BP in Sys/Dia as 130/80 and then Sys and Dia in separate columns to calculate the PP. Just out of curiosity (and because I'm lazy...) I'd like to enter data just once.

Either enter Sys and Dia in separate columns to do the calc and have it transpose that data into a 3rd column in the Sys/Dia format, or the reverse.

Obviously NOT a huge problem, mostly curious. Hints? I'm using Open Office but I expect Excel methods would work as well.

This is the perfect use case for a chatgpt account:

You can streamline your BP data entry and calculations in OpenOffice Calc (or Excel) by using formulas to automatically handle the transposition and pulse pressure calculation. Here’s how you can do it:

Option 1: Enter Sys/Dia in Separate Columns and Concatenate
Column A: Enter the Systolic values.
Column B: Enter the Diastolic values.
Column C: Calculate the Pulse Pressure (PP):
Formula in C2: =A2-B2
Column D: Concatenate the Sys/Dia format:
Formula in D2: =A2 & "/" & B2


Option 2: Enter Sys/Dia in a Single Column and Split
If you prefer to enter the data as Sys/Dia and split it:

Column A: Enter the BP values as 130/80.
Column B: Extract the Systolic value:
Formula in B2: =LEFT(A2, FIND("/", A2)-1)
Column C: Extract the Diastolic value:
Formula in C2: =RIGHT(A2, LEN(A2)-FIND("/", A2))
Column D: Calculate the Pulse Pressure:
Formula in D2: =B2-C2

Additional Tips:
Data Validation: You can use data validation to ensure that your entries in the Sys/Dia format are correct.
Conditional Formatting: Highlight abnormal pulse pressures automatically by setting up conditional formatting rules.
These setups will save you from redundant data entry while keeping your records neat and accurate.

I'm an Excel spreadsheet wizard but I use a BP that connects to a phone app that tracks my bp and heart rate. I can download the data into a spreadsheet if I so wish.

Omron is the brand. I'm sure others does the same thing as well.