“Work smarter, not harder.”
When I started keeping a medical log I had to decide between using my text editor or a spreadsheet. I chose the text editor; it’s fast, simple, free-form, and the files are plain ASCII. A spreadsheet would take longer to input data and it would be a hassle making random notes or changes. I persuaded myself I’d never need to do any processing of the numeric data, and went with the text file.
Which worked, for five years or so, when I needed averages of various figures to put into a spreadsheet for the doc.
Well, fooey.
So, add up all the values for, say, systolic blood pressure, cursor over the numbers to count how many, divide, type in the average. El sucko.
I found a really interesting calculator called Speedcrunch. It’s like… sort of like a word processor for numbers. It’s just a text screen, and you type numbers into it. Up and down arrows scroll through the history. Left and right arrows let you edit the current or historic lines. And it has various functions, including one to average a string of numbers. ‘average(90;83;102;111;94)’ will do it.
I was doing that for a while, but each *day* of readings required entering 50-ish numbers into Speedcrunch. Surely there’s a better way.
Hm. I’m using the ‘average’ function on the spreadsheet to average daily entries to monthly. Can I cut numbers from the text file, paste them into a spare column, and average them using the spreadsheet as a scratchpad? Not with my default editor, which dates from 1986 and runs in a DOS emulator that doesn’t support X Window cut and paste operations, but I loaded the file into a GUI editor, cut a column of numbers out in block mode, and pasted it into the scratch column… yes!
Not perfect, but much less hassle than before. And I finally finished moving all the numeric data to a set of spreadsheets, 2016 to 2022.
I didn’t record anything before 2016.
The reason for the long columns of numbers is I have been watching my blood pressure and pulse rate bounce around like a Superball; systolic pressure will range randomly from, say, 95 to 145 in the same day. My doc doesn’t see any problem with that, but it bothers me enough that I’m still collecting the data and will get a second opinion sometime. I don’t see how the usual “blood pressure at the doctor’s office twice a year” schtick has any useful purpose if it’s normal for BP to move around like that.
Collecting less data will simplify things, but that’s at least a few months off.
…and all this started because I wondered about the relationship between my pulse, BP, and O2, and thought some graphs would be handy…
I like having all of each day’s data and notes in a nice block in my editor, but I’m probably going to have to start entering the numeric data directly into the spreadsheet, then copy it over to the text file, which keeps track of everything else.
Microsnot used to gibber about how you could embed a spreadsheet into a word processor document with Office; it turns out you can do the same thing with LibreOffice. But I don’t like LO’s word processor much; it looks and works like Microsoft’s, which means clunky, slow, and dain-bramaged.