Thursday, August 16, 2012

Insert Tab A Into Slot B

I have become, for the most part, a self taught guru of Excel.  I recall that about 12 years ago, when I was looking for a new job, I had an interview with a company for a position that sounded great!.  The only problem was that they needed someone with a working knowledge of Excel who could take to the ground running and I had never used Excel in my life.  Despite my being quick on the uptake, they didn't have time to train.
 
Would-a, could-a, should-a.  Oh, well.  Life worked out and the Lord got me my job at the law firm where I am now.  We'll assume that He'll let me know when it's time to move on… hopefully in a less emotionally catastrophic way.
 
Anyway, Big Boss Man #1, Steve, has a fondness for spreadsheets, charts and the like.  In the beginning it was one small chart that was originally just a table in Word.  But then his appetite was only whetted.  Before I knew it, we had spreadsheets with tables and pie charts and graphs.. (Oh, my!)   Frankly, I remember attending a staff meeting where the mental health person came and chatted with us and told us about being wary of enabling people.  I'm concerned that I'm enabling Steve's addiction.  It's fun, though, so I don't complain.
 
Each month, I run reports from our software and take certain info from these reports and enter it all into my spreadsheet and print out his monthly helping of information.  He also gets weekly snack-size portions of reports and stuff, but as the name would suggest, it's much smaller.
 
All was well until last year when, as you may recall, I was off for not one, but two surgeries.  (One planned, the other, not so much.)  As I was preparing to be off for the first surgery, I knew that during my time off, there would be a month-end in there that someone would have to prepare Steve's info, lest the poor boy start going thru withdrawal symptoms.  The only problem with someone else doing the reports, charts, etc., was that I was going to have to prepare explicit instructions on how to do each thing.  Either that or it was going to be a monster conference call to Rose for telephonic instructions.
 
I started back in February, as soon as we knew for sure that the surgery was going to happen.  Since I feel that my odds of being run over by a bus (I tend to envision a red double-decker like in England, don't know why) while crossing the street one evening are much greater than they were of me dying on the table, I probably should have started the instruction manual a LONG time ago, but that's neither here nor there.  I now have a three-ring binder with instructions on each aspect of my job, or most of them, in case that ubiquitous bus runs me over in the street.  (It's a work in progress really.)  Otherwise, I just know that Steve would really break down at my funeral and probably even have to engage a medium to conduct frequent séances to reach me from the other side to help someone could run his reports, etc., and frankly, when I go to my eternal rest, I want to rest!
 
Why am I bringing this up today?  Well, glad you asked.  Yesterday, as I prepared the August month-end reports, etc., I was fine-tuning a new report that Steve's imagination and my Excel skills had come up with in July.  All the while, I knew, just KNEW, that I was going to have to translate all of what I was doing it into written instructions.  As it is, the poor girl who runs these things when I'm out of the office during month-end (which isn't often, but I'm sure she feels like it is) panics whenever I email her a new or updated set of instructions, just sure that I'm taking next month off… (oh, that sounds nice… I wonder if there are any other surgeries I could plan for the fall…  memo to self, investigate that).
 
Today, I spent hours, HOURS, writing up instructions for running this report and producing the corresponding chart for Steve.  Also, I took the opportunity to update/correct the already written instructions and to whip up instructions on another area that was missing.  Now imagine, if you will, writing up instructions for something that you've done for years, mostly by habit by now, and for the most part not even consciously thinking about what you're doing.  The instructions are for someone who is only vaguely familiar with Excel and only does it rarely, so each time might as well be the first time. 
 
For example, to blow your nose, the instructions would go 1) go to store, 2) walk down aisle 6, 3) look left, 4) choose box of tissues, 5) walk to counter, 6) pay dude behind counter for tissues… and then under number 6 there would have to be sub instructions regarding payment… and you've never even got to the nose yet!
 
It's a good thing that I take it as a challenge to write clear, concise instructions... and I like to write.  And aren't you glad?  :) 

Wednesday, August 15, 2012

IT Department... Call on Line 2

Tuesday, after a rather uneventful, but still tiring day, I came home to a perfectly lovely meal. I took my plate, my ipad and myself out onto the balcony to decompress and kill zombies over my bowl with the cats.

After a lovely dinner with the kids and a wee bit o zombie-related carnage, I forced myself to return to my bedroom where not only was the laptop not working, but my poor lovely computer had been salvaged for parts and lay in pieces. Ok, not really, the keyboard was unplugged and the internet was hooked into the laptop, but otherwise it was ok.


I called iYogi. This time I got Ramesh. I gave Ramesh the 411 so he could pull up the notes from my session on Monday night with Raj. I told him that I couldn’t do the backup because of the “catastrophic error” and that I was ready to have him walk me through reinstalling the OS.

Now, I have actually done this myself, but there are generally all these questions and it was nice to be able to ask someone which choice to choose. I think I would have made all the same choices, but… Anyone who’s ever installed software like this, knows that it can take a while while it deletes things and downloads new things and installs other things. So Ramesh and I had a chance to get to know each other.

He asked me how the weather was. I told him that it was quite nice. That it had been horribly hot, but since the weekend we’d had some rain and it was cooler, in the 80’s.

I asked how the weather was there. He said they were currently in the monsoon season, so it was rainy. I asked when they had summer – he said April to July, generally.

He asked if I or anyone I knew had ever been to India. I told him that my bro-in-law had just returned from there on Sunday. He’d been there for work, but I wasn’t sure why. I told him I’d never been anywhere. (I didn’t see the point in going into the whole trip to England/Scotland/appendix story.)

I asked him if it was tomorrow there already… if it was Wednesday. He said yes, it was 5:30am on Wednesday there… and that today (Wednesday) was India’s Independence Day. I said that on our Independence Day, I got the day off. He said he had to work, but would get off at 11am.

At this point in our mutual lovefest, the software installation got to the point where it was going to take another 45 minutes. Ramesh told me the answers to the next few questions, and told me to call after the installation was finished, so someone could continue to help resolve my problems, wished me good karma and hung up.

I finished the installation and, since the mid-season finale of Rizzoli and Isles was coming on at 8pm, decided I’d done enough for one night.

Tuesday, August 14, 2012

IT Department... Call on Line 1

Haley, Sib #2, was down to visit this weekend and I said something while she was here that has come back to bite me in my much smaller than it was 18 months ago hiney (NOTE: I had to Google how to spell “hiney” and spellcheck still doesn’t like it!) Mom said that she’d found a photograph (or two) that she would like to have scanned so she could enlarge them and hang them somewhere. I, not knowing how to use the scanner that is a part of the printer/copier/scanner that we have, suggested that before she left, Haley could help Mom with that because Haley is the “techie” daughter. (i.e., Rose is perfectly happy not knowing how to use the printer/copier/scanner thingee). Haley did help Mom figure it out and life went on.

So how did my harmless comment come back to bite me on the bum? Well, let me tell ya.

Monday night, after a long, but relatively successful day at the mines, I came home. Mom had dinner ready and while we are sitting at the table, she says she has a couple of things to discuss with me. I was game, so I said, “shoot!”

First, Mom had, the previous week, lost her driver’s license. She got on the BMV website to find out what she would need to get a new license and was pleased to find out that she qualified to renew (it was going to expire in December anyway) it online, but she wasn’t sure if she had an account already with the BMV (she did, I set it up in February when I renewed our plates), so she decided to wait for me to get home. Well, piece of cake. While we are sitting there eating, I get on her laptop, which is sitting on the table beside me, and quick like a bunny, log on and renew her license! I looked at her with a very satisfied look in my eyes and said, “Next?”

B) The virus protection software on Mom’s two computers, the desktop and the laptop, was getting ready to expire in five days. She had got online to see about renewing it and discovered (she thought) that she could get it renewed for all three of our computers (mine, too) for the price of $39.99! But before she did it, she wanted to make sure that she’d read the thing right. Again, quick like a bunny that really wanted to just spend the rest of her evening on the balcony killing zombies with a cat in her lap, I went to their site, confirmed that that was in fact the deal, and renewed the virus protection stuff. I got the renewal code and entered it and next thing I know, the laptop goes to the BLUE SCREEN OF DEATH! (cue lightning sound effect).

My first thought was to say, “Ok, that’s done! Now let’s go kill zombies!” I could feel my butt being nibbled on. But being the good girl that I am… sigh. So the BLUE SCREEN OF DEATH (“BSD”) said that if this was the first time we got it, to reboot and see if the problem went away. I did. It didn’t. Next, the BSD said that if you got it after rebooting, to do something… I didn’t fully understand what, but I thought I’d log on in “safe mode” and uninstall the virusware… maybe that would work. So I got on in safe mode and started thinking that man, I really wished Haley was here. She is fearless where computers are concerned. My next thought was that I really hate talking on the telephone, but I’m going to have to call iYogi.


We have this service. I’m not sure how Mom came across them, but we’ve had it for about a year now, called iYogi and we have an 800 number that goes to India where there are all these techie computer people and they help us do whatever we need on our computers. We can’t print, call them and they log on and fix it for us over the internet. They will scan our computers and clean it up, speed it up, etc. Things I could probably do on my computer but generally don’t take the time and certainly don’t want to do on both of Mom’s computers.

So I called iYogi. Got this very nice guy – I didn’t catch his name and while I don’t want to be insulting, I can’t resist calling him Rajesh Koothrappali. Raj really earned his wages that evening/(morning (in India). We tried to set it up so Raj could log in to the computer over the internet, only to discover that I’d chosen the wrong safe mode. So I rebooted and chose the correct safe mode (with internet). Again we tried to set it up so Raj could log in to the computer over the internet, only to discover that the wireless wasn’t working on the laptop. Sigh. So I trucked the whole kit-n-kaboodle into my bedroom, hooked it directly up to the internet, avoiding the wireless router. AGAIN we tried to set it up so Raj could log in to the computer over the internet, only to discover that although the mouse was working, the keyboard was non-responsive. So I unplugged the keyboard to my desktop and hooked it onto the laptop, only to discovery that the keyboard was STILL non-responsive. I could mouse, but that wasn’t good enough as I had to type in the code to let him take over the computer.

At this point, Raj had to keep putting me on hold to figure out what to do next… and the hold times kept getting longer and longer. I imagined this phone bank of workers feverishly trying to resolve my issues! After over an hour and a half, poor Raj was forced to tell me that I was going to have to reinstall the operating system. We decided that I’d hang up, perform a backup, find the CD’s and then call back when I was ready to reinstall. We said a tender goodbye; he wished me “good karma;” and hung up. Sniff… I still miss him… 
I assigned Mom the task of finding the CD’s while I attempted to backup her genealogy info. I was distressed to be advised by the laptop, upon my attempts to perform said backup, that there had been a “catastrophic error” and that no backup could be performed. I informed Mom of this and we each said a quick prayer that she’d not done too much on it since the last time we did a back up. And she probably hasn’t, since we went on vacation and then she had her back problems and then the heart attack that wasn’t really a heart attack.. (I know, I’ve not told you about that, but this would be why there’s been no blogs for a while.)

We found the CD’s and decided that I didn’t have it in me to do anymore that evening. Plus, the series finale of The Closer was coming on at 8:00 pm and I didn’t want to miss it and my phone needed charging.  I want a cookie.

Tuesday, July 3, 2012

Hot Dogs! Get Your Hot Dogs!!

Today is National Hot Dog Day. Or maybe it’s that July is National Hot Dog Month. Whatever. At the office, we take every opportunity to A) bring food in and/or 2) raise fundage for our annual holiday adoption of less advantaged families in the community. Therefore, as a two-fer, today we had our First Annual Hot Dog Day celebration with the proceeds to be added to our Christmas fund.

We added this event to our social/fund-raising calendar after last year’s Cinco De Mayo Nacho Day was such a hit. This year, unfortunately, that event had to be renamed Cuatro de Mayo Nacho Day because Mayo Cinco was el sábado. But it was still hugely successful.

But back to today. One of the attorneys, Greg, is a BIG hot dog fiend and he has a wife who is a nutritionist and, therefore, limits his munchification of hot dogs to zero. Obviously, Greg was all for this celebration. He insists that the world’s best hot dogs come from some butcher shop in Jasper, Indiana and he volunteered to pick them up. It didn’t hurt that he had to be in Jasper last week for some case! My mother insists that the world’s best hot dogs are Nathan’s and specifically, from Sam’s Club. Every time she goes to Sam’s, she plans the trip around lunch time so she can get their drink and a hot dog for $1.50 special. The woman has been going thru hot dog withdrawal since she’s been stuck in the house recuperating from her slipped discs. Fortunately for her, I take pity on her periodically and bring her home a dog. I’m nice that way.

But again, I digress. People brought in a variety of toppings, sides, and desserts, so a yummy lunch was had by all who were willing to fork over $5 for lunch. And why not? You can’t get much more than a Happy Meal for $5 if you go out for lunch! One of the desserts was brought in by Shawn, our HR peep. She really missed her calling. Not that she isn’t a great HR person, but she really should open up a cupcake shop. During one of the planning meetings, we jokingly mentioned that she should bring in hot dog cupcakes and voila! These are what she made…


They even have tiny relish on them! I nabbed one to take home to mom. I nabbed her one of the hot dogs, too; since I can’t eat all that much, and really should avoid hot dogs. I did have one, though… like I’m NOT going to try one?!

Over the weekend, on a trip to CVS I found the perfect holiday addition to my ensemble for the day.


Imagine if you will, me sitting at my desk, doing my thing, (today it was collections crap, er.. stuff,) wearing my boppers. People walk by my desk, see me and my boppers, and are in no way phased. I’ve been here almost 12 years, so I guess they’re used to me. The best one was early in the morning, just after I put them on, one of the managing partners walked by, looked at me and said “Good Morning, Rosemary” and just kept on walking!

Friday, June 29, 2012

There's An App for That!

I love my iPhone, as I'm pretty sure I've mentioned.  I enjoy being able to read my book on the Kindle app.  I enjoy being able to pull up people on the IMDB app at any time, for example, today at lunch, Jennifer and I were discussing who is in the movie I'm going to go see this evening, and I was listing the people, but I couldn't remember the name of the guy or the series that he stars in.  I could only remember that my niece Natalie thinks he has creepy eyes.  (And if she's reading this, she knows who I'm talking about!)  (And if she isn't reading this, WHY ISN'T SHE READING THIS!??)  So I whipped out my phone and looked him up, right there at the table! 
 
I love not having to carry my Bible to church because I can just get my phone out and read the passage from the app!  I love being able to play solitaire or mahjong  or whatever bit of mindless fun I'm currently addicted to whenever I have to wait for something or someone. 
 
Yesterday, I was having a discussion with some of the girls with whom I'm going to the movies this evening.  One of them was going last night to buy our tickets.  I asked if she had a Stubz card and from her response of "Huh?" knew that she did not, so I gave her my card so Rose could get the points!  The other girl mentions that she has an app that keeps track of all of her cards, and when she's at the store, the sales clerk just scans her phone or, if that doesn't work, keys in the numbers.  I am THERE!!
 
I'm forever going to the grocery store (IGA/Buy-Low) and forgetting my card.  The sales person always dutifully says, "Keep your receipt and bring it in with your card and you can get credit for the purchase."  To which I politely respond, "yeah, thanks" when in fact I want to scream, ahem.. "IF I WAS ABLE TO REMEMBER TO DO THAT, I'D HAVE REMEMBERED THE FREAKIN' CARD TODAY!!!"  Or sometimes, I'll run into CVS with only my keys and wallet.  What's the problem with that?, you ask.  Well, I have so many of those cards, I keep them on a totally separate key ring, so when I say I only have my keys with me, I only have my KEYS.  Sigh.
 
Last night, I downloaded that puppy (keyringapp.com) and quick like a bunny scanned and entered my cards.  And now, I can't wait to go to the movie tonight so they can scan my card/phone when I get my popcorn!  Yeah!
 
Anyway, that's my app recommendation of the week… or whatever time period will be between now and the next app I recommend.

Monday, June 25, 2012

And Now, For the Rest of the Story...

Monday began a new week.  Mom called her doctor's office and they scheduled a CT scan for Tuesday afternoon and, because the nit-wit at the scheduling desk said they (the doctor's office) might not have the CT results by the time of Mom's Wednesday morning with her doctor, they rescheduled it for Friday.
 
Meanwhile, Sophie did not appreciate my administering the steroid cream on her ears twice a day, but the afternoon that Mom called to tell me that she'd seen/overheard Sophie at the food bowl THREE times that day so far.  Of course, knowing my little persnickety turd, she's been at the bowl containing the Meow Mix that the other three eat and not the bowl containing her $55 a bag expensive stuff.  But at this point, I don't care what it is, if she'll eat it and keep it down.  It's just particularly irritating because shortly after I adopted Sophie and Gizmo, I attempted to get them to eat Meow Mix (because their previous caretaker fed them Science Diet, which I thought was SO expensive… little did I know that now I'd kill to feed her Science Diet) and she would have nothing to do with it. I tried different flavors, including the hairball formula, and no.  I don't think Mom and Dad had to buy cat food for a month because they benefited from every bag I bought and Ms. Picky turned down.
 
Also, the previous week, during my fit of feeling useless, I'd ordered something to help Sophie.  Jackson Galaxy, the guy with all the tattoos and piercings on the Animal Planet show "My Cat From Hell", well, he's written a book – a biography, I suppose – and my friend Deborah is reading it and keeping me updated as she goes.  Anyway, Deborah tells me that early on in his cat experience, he had a difficult cat… I don't remember the name… and he'd tried everything to get the cat to eat.. I think that was the problem.. and he was at his wits end when he heard about some woman selling holistic formulas made up of "essential" oils, whatever those are, and supposedly they'd help the cat.  So, like me, being at the end of his rope, he said, "WTF!?"  Now I gather that they helped his cat and Jackson was so impressed that he was like, "I've got to meet this woman!"  He met her, and ended up buying the company!! 
 
(Very) long story short, I got on the website, www.spiritessences.com, and bought some of both the "Happy Tummy" formula for Sophie specifically, and the "Stress Stopper" for everyone in general.  It arrived on Friday and I put a few drops of the Stress Stopper in both of the water fountains and I rubbed some of the Happy Tummy in my hands and then wiped them on Sophie (per the instructions.)  And now, a weekend later, I'm telling you that I'm sold!  Well, first, Sophie is eating.  And…now here, I guess you'd have to have cats to understand this, but Sophie's fur is like silk.  I've never felt anything softer.  And when she isn't 100%, her fur loses its softness… feels like hair.. or more bristly… which is the way Winifred always feels, but with Sophie, it's an indicator to me that something's amiss.  Anyway, for the last month or so, her fur hasn't been "right."  Now, after a week of the steroid cream on her ears and a weekend of the essential oils, she is happy, silky, and, dare I say, more friendly.  She's even a little more tolerant (not 100%, but a little bit) of Winifred and I think, when Sophie chases Winifred out of my bedroom and up/down the stairs, there's a bit of playfulness in it.
 
One patient is fixed (literally…hahaha!).  As for the other, we went to Mom's doctor appointment on Friday.  The CT scan showed that she did have a mild bulging disc on the left side at L4-5 and a moderate herniated disc at L3-4 on the right.  But the thing on the right isn't the one she's having problems with, for whatever reason, so we don't worry about it at the moment.  The left problem isn't bad enough to require surgery.  (One of Mom's, and my, worries down.)  Then I asked the doctor if there was something she could prescribe, nothing addictive, because we are too poor to risk becoming addicts, which could help Mom sleep.  Mom not having had a decent night's sleep in a month.  The doctor gave her a prescription for Flexeril. (Another of Mom's concerns taken care of.)  And finally, Mom asked about exercises or something to help her (Mom) not feel like such a slug, just laying around and nothing else.  So the doctor ordered physical therapy.  (The third and final of Mom's concerns gone!)  When we left that appointment, Mom felt ten times better, not even having had the first pill or PT appointment!
 
Friday night, she took her first Flexeril and slept like a rock.  She was so happy the next morning!  Of course, as one might have guessed, she then proceeded to do too much, at least in my opinion, over the weekend, so she was rather tired when she got up this morning.  Other than her PT appointments, she is going to rest and recuperate this week!  So Patient #2 is doing better and I'm feeling useful, so all is well in Roselandia!!

Sunday, June 24, 2012

And the Secret is...

Sorry.  I didn't mean to leave you all hanging in regard to the secret of picking out watermelons, I was just going with the flow of my topic.  I know that for years I was told to thump them and the ripe ones sounded different.  Let me tell you I have thumped many a watermelon and rarely heard anything different between them.  Consequently, it was more of a crap shoot as to whether it was good or not.

Holly's secret.. and honestly, I think she got it from Alton Brown on the Food Network's show Good Eats, is to look at the spot where the melon was laying on the ground (see picture below - it's the discolored area that doesn't look like all the rest) and to find the one that is more yellow. 


It's that easy - almost too simple.  Now I don't know if this is a scientific type of tip, but it has worked for me all summer.  In fact I bought two more yesterday at Sam's (oh, and I've got all my good ones this summer at Sam's - again, don't know if that's relevant, but..) and the one I cut up to put in the fridge yesterday afternoon - sugar sweet. 

Oh, and my apologies for the picture.  I kept taking the pics with my phone and I turned them all the correct way, but then when I load it here, it's on its side and I can't figure out how to fix it.  So I'm sorry for you having to crick your neck to see the pic correctly.