And this was a pretty non-productive day, too, in regards to REAL work getting done...
But I did make a lot of progress on the
Online Journaller's Keirsey Profiles stuff... I'm working with Excel, and it's a real bitch if you want to do anything out of the ordinary.
And everything that I want to do is, naturally, out of the ordinary.
For instance... I want to make one field a hyperlink to another field, across about 450 entries. I've been trying for months now to find a way to do that, and today I gave up, and I'm doing each one manually. Well, I got the hyperlinks done for the journal name/URL, now I'm about half-way the ones for the journaller's name and their email addy.
RSI, here I come.
Select the name... hit the right arrow button to select the email address. If you select the email address, you send mail, but if you slide over to it, you don't.
Go to the formula bar and select the entire address. Do a CTRL+C to copy it. Go back to the name field and hit the right mouse button, then select *add hyperlink*... it's the one at the very bottom, of course.
Do a CTRL+V to enter the email address... then hit OK.
Move on to the next one.
Pain in the ass, and the wrist, and the elbow, too. Not to mention the head.
I've got about 300 to go. Then I need to add in the sixty or so that've wanted to get added for the last four months.
And the report for the thing... I'm having a bitch of a time with that, too. Most of the stuff is easy, but... I want to do something *out of the ordinary* again. I want to nest formulae. I need to know the number of people who are male AND have a profile of ENTP, for instance. I have spent four hours this evening just working on that. The really bad thing is... I've done it before, and I've forgotten how I did it. I remember that it wasn't really logical, so I've been trying to think illogically...
Don't laugh.
Don't even think what you're thinking. And I know what you're thinking, you know.
So stop it. And, if you happen to know Excel, give me some help. I really need it.
Anyway, this is one of those things that has been bugging me for quite a while, and I will be happy to get it behind me. There are a lot of things like that around here, and I need to be working on all of them.
Another thing is... I've taken over the bill-paying for right now. I made Karen start doing it after I had my first coronary, and she's always hated it. So she's helping me for a while, but it's reverting back to me. I hate paying bills, but I always feel a sense of accomplishment when it's done for the month...
Especially when I'm trying to deal with Excel. I should be doing this all with a database, but no, I thought that I needed to learn Excel. So here I am, beating my bald head against the wall.
O'well. Actually, I'd be beating my head on the wall using Access, too.
Mas maņana... heh. ALT+0241. Or it it manaņa? Nope, that doesn't look right. Good night.
I need that sense of accomplishment... it's been absent from my life a lot lately. Even that little bit, it helps.