Friday, December 2, 2011

Candles, a Spreadsheet, and Taking a Break

I'd love to be working on Spiral Light Candle's website (spirallightcandle.com) upgrade, but it's just as well that I'm not. My site design and programming skills are a bit rusty. And seriously out-of-date. Writing HTML aside, I haven't worked with the nuts-and-bolts end of website design for a few years.

Skills: Old, New, and Rusty

Which, at age 60, doesn't feel like much time. But when it comes to information technology, it's a little like an expert flint knapper thinking about working as a machinist. I've been asking my son, who earned his A+ certification recently, when there's a technical issue.

And: yes, those are the words of a proud dad.

Amazon.com's user interface is designed with non-technical folks in mind, though, so I've been able to lend a hand with the Spiral Light Candle Corp. Storefront there.

Thanks to a checkered job history, I've been a licensed radio operator/disk jockey, have experience delivering flowers, and spent about a decade as 'the computer guy' and database manager at a small publishing company. I also answer phones and make coffee.

Speaking of coffee, it's time for a coffee break.

Analysis: A Task That's Work

I learned how to set up spreadsheets, among other things, in that 'database' job: including getting spreadsheets to do things that aren't in the manual. And that's another topic.

The point is, I know how to set up something where you put in numbers and get organized, calculated, results.

That's what I've been doing this week, setting up a complicated, über-detailed budget and sales forecast spreadsheet for Spiral Light Candle. Actually, I don't think it's "über-detailed." But there's a lot of equipment, processes, and people, that go into making and marketing candles: and my son-in-law has mapped out what he thinks we'll need for the next several months.

My task is to take his notes, and make a working spreadsheet out of then. By last Wednesday.

I enjoy working with data: figuring out how to break it out into categories; finding relationships between sets of data; setting up the results so that someone else can easily use them.

When I have to do something on a deadline, though: that's more 'work' than 'fun.' Deadlines are wonderful motivators though.

Break Time, Productive Time

That Wednesday deadline went whizzing by, but that was the for the 'detailed rough' version. Today, I'm closing in on getting what he'll need when he talks to some folks next week.

This 'coffee break' is taking longer than most: but I think it's worth the 'extra' time. I was literally getting a headache, almost unheard of for me, figuring out how some of the data was supposed to connect.

Now that I've been away from that maddening matrix for several minutes, I think it's going to make more sense. You've heard the usual psychobabble about 'subconscious' and 'unconscious' before, so I'll skip that.

I still have time for the 'done and ready' version of this spreadsheet, and decided to use my brain for something unrelated. The light exercise of walking over to the microwave and heating coffee helps, too.

Anyway, break time's over. I don't see it as 'wasted' time, since I'm coming back to the task at hand with a (slightly) fresher mind and a (marginally) revived body.

Urgency, Priority, and Nitpicking

This spreadsheet is still high priority, and it's now urgent.

But the difference between "priority" and "urgency" is another topic. Several, actually.

Good grief! I was going to say why I think it's vital to get so nitpicking about details: and I'm out of time. That'll have to go in another post.

Not-entirely-unrelated posts:

Tuesday, November 29, 2011

Spiral Light Candle: Website; New Phones Now Working

Right now, Spiral Light Candle's website, spirallightcandle.com, is up and running. It's doing everything it's designed to do: which doesn't include taking online orders. The Spiral Light Candle retail storefront, Spiral Light Candle Corp. Storefront at Amazon.com has been around for a while now, and got updated recently.

Which brings me to a big of Web nostalgia.

Remembering the 'Good Old Days'

Back in the 'good old days,' you'd see "UNDER CONSTRUCTION" graphics on many websites. I liked the animated ones. There were silhouettes shoveling; and a frazzled programmers pounding a keyboard, with a hammer in one case.

They were funny, attention-getting, and a useless distraction.

I haven't seen that sort of thing much lately. Partly, I suspect, because website developers and users realized that a good website is always 'under construction' in some way. It's a rare business that hasn't changed something about products, services, prices - or seasonal sales.

There's something to be said for maintaining a consistent visual style on a corporate website. On the other hand, it's wise to distinguish between "consistent," "archaic," and "apparently abandoned."

Making Sure it's "Coming Soon"

Not all bad ideas for websites are as obviously misguided as, say, green-on-purple text or an investment service with an animated puppy on its 'about us' page.

Sometimes a caffeinated developer decides to re-name pages that customers have bookmarked/Favorited/whatever: because 'everybody's using [this week's hot database software].'

"Coming soon" announcements, like anything else, need to be managed, updated, and sometimes removed. But I think they're basically okay. I'll get back to that idea.

Flash, a Movie About Coffee, and Clueless Supervisors

Then there are the dilbertesque supervisors, who are a lot funnier in the comics, than in real life:

Dilbert.com
Dilbert.com
Dilbert.com
(Scott Adams' Dilbert, used w/o permission)

Technology, Telephones, and Me

My son is more tech-savvy than I am, but I get along with computers pretty well. I've even learned to cope with telephone menus.

Automated telephone menus have improved since companies started using them. A lot. I think it helped, when someone realized that the most loyal customer would eventually get fed up.

I've learned quite a bit about telephone menus in the last few days. Spiral Light Candle now has a working customer service section - complete with a mercifully-short menu. Spiral Light and the service we're using got the system up and running yesterday.

Spiral Light Candle's system isn't quite so simple on the 'company' side, but I've gotten familiar with the basics. Which is a good thing, since I'm answering phones for the company now.

Also doing the occasional spreadsheet, and whatever else I can lend a hand with.

"Currently Working on Our Website"

I mentioned Spiral Light Candle's new website yesterday. The developer has a nice, clean, and simple home page; easy-to-spot navigation; and graphics that unobtrusively match the product line.

I like it. More to the point: it's being done by a competent developer, and isn't any fancier than it needs to be.

The software that will support our online ordering is still getting tweaked, but I heard yesterday that it's progressing. In the right direction.

That's why I don't have a problem with this snippet from Spiral Light Candle's home page:
"...We are currently working on our website, so please check back again soon...."
We won't launch the new website tomorrow. At least I don't think so. But work on Spiral Light Candle's website is in good hands.

I'm looking forward to seeing the result.

Related posts:

("Following" list moved here, after Blogger changed formats)

Small Business Watchers