Reverse the Order of Worksheets in an Excel Workbook

Today I found myself wanting to reverse the order of sheet tabs in an Excel file.  The VBA code snippet below does just that.

Sub Worksheet_Reverse_Order()
Dim MySheet As Worksheet
Dim i As Integer

For Each MySheet In Worksheets
Debug.Print MySheet.Index, MySheet.Name
Next

For i = 2 To Worksheets.Count
Set MySheet = Worksheets(i)
MySheet.Move before:=Worksheets(1)
Next i

For Each MySheet In Worksheets
Debug.Print MySheet.Index, MySheet.Name
Next

End Sub


Background...
I had been maintaining weekly status updates as Excel spreadsheets, all grouped into one XLS document.  Each week I'd add a new sheet to the right of the previous week's worksheet tab.

But due to a change in workflow, I now have to copy the new sheet into that workbook rather than create it in the workbook.  In order to keep placing the new sheet after all the others, it's necessary to scroll to the end of the list of sheets and select "(move to end)".

"It would be so much easier if the sheets were in reverse order," I sighed to myself.  The thought of dragging them into reverse order manually was, well, unthinkable.  And thus this VBA macro was born.

When Flourescent Lights Go Bad

Fluorescent lights produce a lot of light for little power.  My kitchen lights, which use two T9 bulbs, are rated at 32W, 2400lm and 22W, 1400lm¹.  The bulbs are expensive and not easy to find, but they supposedly last five years.

The problem is that the performance and longevity of fluorescent lights depends on the ballast.  This is an electrical module that conditions the current, and it's not 100% efficient.  Also the ballast will degrade and eventually need to be replaced.  Sometimes a faulty ballast makes itself evident when the light flickers, or when the light doesn't turn on immediately and you need to flip the light switch off and on to get it to light.  At this point the bulbs will burn out quickly.

The ballast is even more expensive and harder to find than the bulbs.  And replacing the ballast isn't meant to be done by the consumer, although a home owner who can replace a light switch or electrical outlet will be able to replace a ballast in about ten minutes if the fixture is designed well.

I mention all this because I again find it necessary to replace the ballasts in the two kitchen lights.  In fact, I was thinking of replacing these fixtures with new fixtures that have multiple sockets for standard (Edison screw) bulbs.  I figured this was a better long-range solution because it would allow me to use Compact Fluorescent Bulbs today and then eventually graduate to LED bulbs.  Never again would I need to search for the expensive ballasts and replace them.

But I did manage to find the ballasts for quite a reasonable price.  So it didn't make sense to replace them this time.  But in ten years, if I'm still in this house, I think I'll be buying new fixtures.

---

¹ For a comparison of the lighting efficiency of various types of bulbs, please see https://en.wikipedia.org/wiki/Luminous_efficacy#Lighting_efficiency.

Trials with an Old Computer

About six years ago, I mused about what to do with an old computer, a 500MHz Pentium III.  My idea was to reformat the hard drive (20GB) and install one of these operating systems: Windows 2000 (already obsolete); Windows XP (facing obsolescence); and Linux (Ubuntu, although I don't recall why I decided on that flavor).

I tried all three plus Dyne:bolic, a Linux variant specialized for music and video production on under-powered computers.  Here's how I fared....

Dyne:bolic was easy to try out, and I didn't have to reformat the Window NT drive to do it.  So I tried it first.  After downloading version 2, I burned the ISO image to a CD.  It booted up just fine and I ran it from the CD.  It performed well, but it was set up for a single root-level user, and it wouldn't "play" Flash content.

Next was XP.  The first problem I had was that I couldn't activate the OS, even though I had a valid key.  But I played around with it anyway during the evaluation period.  Just twenty minutes was enough to know it would be way too slow.

Then I installed Windows 2000.  This involved a lot of tedious business with multiple CDs for the OS itself, then Service Pack 6 and then more CDs with security software and utilities.  Everything went well until I installed the antivirus program and updated it.  After that, the OS would not start.

Finally I decided to give Linux a try.  Rather than download images files, I decided to search the local public library system for Linux books that had accompanying CDs.  And I limited my search to old books, too, since I really needed the installer to be on CD-ROMs and not a DVD.  There were some Red Hat Linux books, so I got one and tried it.  It installed and ran really well except for the web browser, Mozilla, which had me pressing Ctrl-Alt-Del and longing for Task Manager to come up so I could kill it.

Of these four options, Dyne:bolic was clearly the best.  Unfortunately, by the time I got around to realizing it, Jaromil released version 3.0.0, whose 1.6GB image now must be burned onto DVD, not CD.  (I can't find the CD that had version 2 on it. And booting from USB is not an option in this computer's BIOS.)  This latest Dyne:bolic is totally awesome -- I tried the Live CD on my main home desktop (a P4), and I created a small virtual machine on my work computer, which boots the image file.

In order to run D:B3 on my PIII, I need a DVD drive.  Since I had two on my main desktop, I removed one and installed it on the PIII.  But, alas, it didn't work.  The computer detected the drive, but it won't boot from it, and Linux won't mount it.  So I think the laser is shot.  I've encountered a few non-functioning DVD drives in this manufacturer's computers, so I really do think the drive is defective.  In fact I wasn't able to boot from the drive recently when it was in the P4 that I took it out of.

So this is where I am now.  I need a working IDE DVD drive, which are expensive and/or refurbished.  There are adapters that can convert a SATA drive to IDE, but that's an extra expense I didn't want to pay.  Plus, I'm not sure this small form factor case will have any room for it, although I can put the new SATA drive with IDE adapter into the main desktop and move the working IDE DVD drive from the main desktop to the PIII if I really had to.

If / when I clear this hurdle I'll check in again.  Hopefully D:B3 will still be available!

Creative Door Repair

The back door of our home never quite opened and closed smoothly. It was necessary to lift the doorknob while closing it in order to prevent the bottom from scraping the threshold.

Very recently the upper hinge pulled completely away from the door frame.  My wife and daughter couldn't finesse the door closed any more.  I re-tightened the screws, but the holes for the screws had widened, so the screw threads no longer had enough wood to bite into.  The hinge wouldn't stay secure for long.

My first impulse was to replace the screws with longer ones of the same diameter.  But not finding any in my collection, I realized I would have to visit the hardware store.

I really enjoy going to the hardware store.  Not the big, nation-wide chain stores like Home Depot or Lowes, though.  I prefer the small, neighborhood shops that seem to carry the odd-ball bits of fixture parts that were used in our neighborhood over fifty years ago when our homes were built.  Our stores are usually staffed by a retired handyman or engineer.  Or maybe the guy just likes hanging out there, giving out free advice without even getting paid for it.

Alas I was too busy to make the trip.  So I busied my mind, thinking of alternative repair options while carrying out the many tedious chores I had to deal with.

My next idea was to plug the screw holes with wooden dowels.  In fact I had many ¼ inch dowel pins left over from an old wood-working project.  I could use those.  But because they were much larger than the screws and the holes, I'd have to drill out the holes first before inserting the pins.  And then I'd have to drill pilot holes into the dowels themselves so that I could get the screws into the pins.  And I'd probably have to use carpenter's glue to hold the dowel pin in place before drilling.

If I had much smaller dowels, I could simply stick them into the holes and jam the screws in.  This would certainly be enough to keep the screws fastened tightly.  But because I didn't have the smaller dowels, I'd have to go to the hardware anyway.

Finally the solution came to me.  I had all the dowels I needed right outside my door!  All I had to do was stroll through the wooded area of our yard to find the right size twig.  Which I did.  It took about 30 seconds.

One oak twig about four inches long was enough to fill all four screw holes.  I broke the twig into four pieces and inserted them into the holes and tightened the screws.

And now the door opens and closes easily, without needing to be lifted, and without scraping the bottom.

This to me is what makes home repair an art form.

Execute Text in MS Word Using the System Shell

I was writing a tutorial in Microsoft Word that describes commands that the reader is supposed to enter at the command prompt.  I thought it would be neat if I could run those commands from within Word to validate them as I entered them.

And so I came up with a surprisingly simple VBA subroutine that sends selected text to the shell.  It is quoted, below.  The code should be placed into a module in Normal.dot.

Note that I invoke two statements in the Shell.  They are separated by the double ampersands.  I combine them into a single string (strCmd) that I pass to the shell.

The first statement is to change to the current working directory, which I assume is the same directory that the Word document resides in.  This isn't fool proof, however.  One failure mode would be if someone were to start Word and create a new document without saving it to the hard drive before calling the routine.  Another failure mode would be if the Word document were to reside on a remote share through a UNC path, such as \\FileServer\ShareName\tutorial.doc -- it's not possible to CD into a UNC path.

The second statement is merely the selected text.

Also note that strCmd  is preceded by the Win32 command prompt CMD.EXE.  The "/D" switch makes sure that no "AutoRun" commands get executed.  The "/C" switch terminates CMD after the command is finished executing.  CMD is included because Shell isn't able to find DOS commands such as CD.

Sorry for the small font on this source code, but I wanted to ensure it wouldn't wrap.

Sub InvokeWithShell()
' Executes the selected text to using the shell
' 2014-06-09 LudditeGeek Created
    Dim strCmd As String
   
    If Selection.Characters.Count <= 1 Then
        MsgBox "Nothing Selected!", vbExclamation, "Invoke With Shell Macro Message"
    ElseIf Selection.Paragraphs.Count > 1 Then
        MsgBox "Multiple Lines Selected!", vbExclamation, "Invoke With Shell Macro Message"
    Else
        strCmd = Selection.Text
        Debug.Print "Invoking " & strCmd
        strCmd = "cd " & ActiveDocument.Path & "\ && " & strCmd
        Shell "cmd /D /C " & strCmd
    End If
   
End Sub

Blackphone and Webroot

Friday on NRP, Morning Edition featured the Blackphone, a smart phone with privacy as its number one priority.  Also mentioned were Black, Boeing's super secure smart phone, and Webroot, a security application.

Read more at http://www.npr.org/blogs/alltechconsidered/2014/02/28/283523473/a-smartphone-that-tries-to-slip-you-off-the-grid.

Disable Outlook's Junk Email Filters

After upgrading to Outlook 2010 over a year ago, it became apparent that its junk email filter continued to work even after we disabled it.

It took so long for me to notice because I use Popfile to categorize the email I download from my ISP's POP3 server.  Popfile would catch the most obvious spam before the Outlook junk email would process it.

But occasionally a message that Popfile marked as valid would end up in the Deleted Items folder.  Outlook's occasional false positive would make me wonder what was going on, but it happened so rarely that it was easier just to check for these false positives than to research the issue.  Besides, the corporate bulk mail filter running on the Exchange serve would stash things into the Junk Email folder, and I needed to check for false positives from that filter.

But then there was an incident that triggered an intra-departmental¹ outcry about the issue.  It was the day that several messages from our Content Management System got flagged by Junk Email and then deleted, causing folks not to notice updates on a few project files.

We all dutifully set Outlook's Junk Email filter to Disabled.  But I continued to see valid messages from my ISP placed into Deleted Items.  Recently I obtained a few spare moments² and quickly found a solution to the issue.  It was my favorite Outlook/Exchange website that I landed on.  Here's the link:

http://www.slipstick.com/outlook/how-to-disable-outlooks-junk-email-filter/

The text says to change the value in a registry key, but in my case, the key didn't exist, so I created it, first.

Only time will tell whether this works.  I will know for sure only if it doesn't.  I suppose I can find an old message that triggered a false positive and send it to myself, but the header of that message would be different from the original header.

---

¹ The emphasis is on the part of the word that contains "mental".

² A good way to obtain spare moments is to schedule a meeting right after another meeting, so that if the other meeting runs late, the participants will be milling around outside the meeting room.  After a while, you get a sense of which meetings will run the longest based on the topic and especially on whether certain coworkers will be in them.  Some meetings can run so late that the folks who mill around will disperse and take an additional five minutes to reassemble, assuming they haven't gone off to lunch or embarked on an early vacation or retirement.

Excel Hyperlinks -- Relative vs. Absolute Path

I rarely insert hyperlinks into an Excel spreadsheet.  So every time I do, I get burned by Excel's predilection for turning Absolute paths into Relative paths.

Here's the scenario...

I'll use Excel to create a flat file database on my local hard drive.  I'll include links to the file server on the network using UNC paths, such as \\File-Server\Share-Name\Path2File\MyFile.ext.  (The Ctrl-k keystroke is really handy for creating hyperlinks, BTW.)

After building the table by adding fields in columns, adding formatting, and entering a few records in rows for testing, I'll consider the database to be production ready.  At this point I'll upload it to the same file server that my links point to.

The next time a user opens the network version of that spreadsheet, Excel will convert those carefully-entered absolute links to relative links.  So if the spreadsheet resides in \\File-Server\NewShare\Reports\Databases\LG.xls, the links to MyFile.ext turn into this: ..\..\..\Share-Name\Path2File\MyFile.ext.  They work just fine while the spreadsheet remains in that location.

But suppose the user saves the database and then e-mails it someone else in the organization, or copies it to his or her local hard drive.  The links are broken.  Furthermore, there's no easy way to fix them.  Search and Replace (Ctrl-h) won't find the ..\..\..\ in the hyperlinks.  You'll have to either fix them manually or write a program to do it.  And then the same thing could happen again, anyway.

But there is (thankfully) a trick to keep Excel from bastardizing your carefully designed links.  But it's a preventive measure -- you have to know about the trick before you get stuck with the link conversion.

The trick is to open the File Properties dialog.  Choose the Summary tab and enter C:\ in the text box next to the label that reads "Hyperlink base:".  Be sure to OK your way out and save.  These instructions are for Excel 2000 and 2003.  Later versions probably have the same properties dialog, but the way to open it might be different.

Really, it's best to do this before entering any hyperlinks.  Ideally, Excel would have an Option for this.  But alas, all I could find was a checkbox to enable Excel to prompt for workbook properties.

Hopefully, by writing this post, I've seared this information into my brain so that the next time I'm tempted to enter a hyperlink, I'll remember to set this property.

Hmmm, it just occurred to me to code this property using VBA....

Brain Games

What kind of Geek could resist an opportunity to improve his or her mind?  If there is such a geek, I am not that kind.

So when I heard the advertisements sponsorship acknowledgments on NPR for Lumosity, I decided to check it out.

Lumosity develops and offers online games that improve mental function.  Their aim is to enable anyone to achieve his or her full potential, brain-wise, at least.

Lumosity provides two tiers of service: free, and subscription.  Users of free accounts are restricted to just three games per day, while subscribers have access not only to unlimited games, but also Personalized Training, Performance Tracking, and comparisons to other Lumosity users.

Since I joined way back on June 1, I've improved slowly and steadily to match the ability of someone half my age, assuming that someone is a slug.  Haha.  Just kidding.  Actually I have no idea because I'm using a free account.  All I know is that four weeks ago my score was 1025 and now it is 1111.

See?

Here's my Brain Performance broken down into various categories:

So check out Lumosity. It's free. It's fun. And you might just gain enough improvement to survive the upcoming Zombie Apocolypse.

Outlook 2010 Macros -- Adventures in Getting Them to Work

In a post that included Outlook VBA code, I mentioned that I stopped using the macro because of Outlook's tougher security.

Today, I decided to try to eliminate the main problem that I had, namely an inability to run the macro except from within the VBA Project IDE.

Here's the scenario:  I have code that worked on Outlook 2000.  I assigned a toolbar button to call it.  But the toolbar button doesn't work in Outlook 2010.  Nothing happens.  Pressing Alt-F8 and clicking Run opens the VBA macro in the IDE and displays an error "Subroutine or Function not found" (paraphrased).  But then I can run the macro by clicking the play button.

One aspect of my solution was to make sure macros were not being disabled.  I choose to self-sign the macro rather than enable all macros.  First I used SelfCert.exe, which I found in the Outlook program directory (C:\Program Files\Microsoft Office\Office14).  SelfCert.exe can be used to create personal certificate -- it would work for me on my local computer.  After I created the certificate, I signed the macro (Tools | Digital Signatures | Choose).  After clicking OK, I immediately pressed Ctrl-sto save the macro.  And then I closed Outlook.  But when I did, it asked me whether I wanted to save VbaProject.OTM.  Odd.  First I responded No.  But when I reopened the VBA editor and checked for digital signatures, it reported that the macro was unsigned.  But answering Yes to the prompt to save didn't help either.  The macro still wasn't signed.

I wondered if the Read Only attribute had been set on VbaProject.OTM.  But no, I had Full Control rights on the file.  Yet, the file's timestamp was old!  It wasn't getting saved!  Ahh, but the old timestamp was a trick, an undocumented "feature".  According to this support thread, it was normal for the timestamp and file size of VbaProject.OTM to remain unchanged after a save.  (This is why the phrase "WTF?" was invented.)  I verified that the save was taking place by adding a comment to my code, saving, closing Outlook and then re-opening the macro.

After that little detour, I found that it was necessary for me to install the certificate in the "Trusted Root Certification Authorities."  This can be done deep within the bowels of the VBA editor.  Tools | Digital Signatures | Choose.  Click the link that says "Click here to view the certificate prope..."  Click the button "Install Certificate..." then Next.  In the next dialog box, click the radio button for "Place all certificates in the following store" then Browse.  Select "Trusted Root Certification Authorities" and then OK / Next your way out.  Save and close Outlook again.

BTW, every time you close Outlook, you should use Task Manager to verify that the Outlook process is not running.

Still the macro would not run except from within the editor.  But I found the solution in another thread.  My code was in a module.  After I moved it to ThisOutlookSession, I was able to assign an actual functioning toolbar button to it.

Whew!

It is very nice that even though I have other macros working that access the From and To properties of a message, I no longer get the annoying message box that warns me that my address book is being accessed and asks whether I want to allow that.

Android Tablet Possibly For Sale

So far my tablet is leading me to the conclusion that it's not worth buying one.  While the portability of it is really neat, it's still not small enough to fit in any pocket, except perhaps a generous jacket pocket.  Sans jacket, I've stowed it inside my button-down shirt by opening one button, slipping it in, and then closing the button.  But during bouts of warm T-shirt weather, I'm forced to either hold the tablet or put it down somewhere when I'm not actually using it.

For example, when I went grocery shopping last week, I placed the tablet in the "seat" of the shopping cart.  When I was done shopping, and I had loaded the car, I returned the cart to one of the spots set aside for the empty carts.  As I walked away, I glanced back to make sure I didn't leave anything behind in the cart, and then I drove home.  And as soon as I got home, I wondered where my tablet was.  I realized I had left it in the cart.  And the reason I didn't notice it when I walked away from the cart was that it lay atop a store circular that had been folded over it by the wind.  Luckily it was in the same spot I left it.  But had I not been able to find it, I'd've not bothered to replace it or even miss it.  I might've felt a bit relieved.  In fact, right now I'm wondering how much I can get for it.

I like having a computer.  It enables me to communicate through e-mail, blogs, message boards and even social media.  And the mobility of it would be extremely fantastic if: 1) Free WiFi were accessible everywhere; 2) It didn't take ten times longer to compose meaningful content.  BTW, I'm typing this right now on a public library computer, even though I have my tablet with me and have access to free WiFi.  Even with the Nexus' Speech-to-Text feature and the Hacker's Keyboard, I still prefer to enter content through an "old fashioned" keyboard.

The marriage of location-aware note-taking and image capture that Evernote provides would be useful if the Nexus had a good-quality rear camera.

Blamed For Doing Its Job

The IRS recently was criticized for scrutinizing certain organizations applying for tax free status.  It seems that organizations that had "Tea Party" in their names received extra scrutiny.

First of all, "Tea Party" generally refers to a political organization.  And the fact is that political organizations are not entitled to tax free status.

Second, "Tea Party" is a reference to a revolt conducted by vandals who were opposed to paying taxes.

So these critics are essentially saying that an organization whose name implies that it's political in nature and opposed to taxes should not be scrutinized when it applies for tax free status?

Huh?

How I Got My Computer to Chime

It all started with a blog post by Sacha Chua that made me think, "I bet there's an app for that."  She described how she set up her smart phone to vibrate every half hour.

Soon after, I found Chime Time, by Hyperfine, which turned my tablet into an Aberdeen mantel clock.  And I loved the idea of chimes and bells so much that I also installed Bodhi Timer, by Yuttadhammo, which can be set up as a timer and play a variety of tones, including singing bowl, when the time is up.

Chime Time starts up automatically when Android starts up.  But Bodhi Timer does not, so I start it in the morning.  I might set it to go off every 15 minutes starting at about 7 minutes after the hour (or any 15-minute interval afterwards), or every 10 minutes starting at 5 after the hour (or any 10-minute interval afterwards), depending on when I can remember to do it.

Having bells and chimes sound off every so often reminds me to live in the present.  When I hear the sound I ask myself whether I'm using time mindfully.

However, my wife absolutely hates it.

Anyway, after enjoying this for a few days on my tablet, I wondered if there were something similar that I could use on my work computer.  I didn't feel like running the tablet just to have it make noise.

That motivated me to search on SourceForge, where I found TeaTimer.  But TeaTimer would pop up an alert box at the end of each interval because it was really intended as a timer for steeping tea.  So I decided to write my own in Visual Basic 6.

I wrote a simple application that would simply play a WAV file whenever it was invoked.  I chose chimes.wav from Microsoft Office, although I'm sure there's an equivalent from OpenOffice, as well.  Then I set a job in Task Scheduler to call it every 15 minutes.  There is a special trick to pulling this off, though, because while my program worked fine when invoked interactively, it refused to work when triggered by Task Scheduler.

I found the solution on the Microsoft Support website: http://support.microsoft.com/kb/86281.

Here's the source code in its entirety, comments removed for clarity:

Declare Function sndPlaySound Lib "WINMM.DLL" Alias "sndPlaySoundA" _
    (ByVal lpszSoundName As String, ByVal uFlags As Long) As Long
Public Const SND_SYNC = &H0
Public Const SND_ASYNC = &H1
Public Const SND_NODEFAULT = &H2
Public Const SND_LOOP = &H8
Public Const SND_NOSTOP = &H10
'Here are explanations for the parameters: (removed)
Private Sub Main()
    Dim SoundName$
    Dim x%, wFlags%
   
    SoundName$ = "C:\Program Files (x86)\Microsoft Office\OFFICE11\MEDIA\CHIMES.WAV"
    wFlags% = SND_NODEFAULT ' Or SND_ASYNC
    x% = sndPlaySound(SoundName$, wFlags%)

End Sub

Android Tablet -- a GPS Device Poser

I concede that I was exaggerating a bit when I referred to my new tablet as "a GPS device, RF scanner, MP3 player, eReader, camera, digital voice recorder, hand held gaming device, clock, portable translator...." It's the "GPS device" boast that's questionable.

Well it depends on how you define GPS Device. If it's a merely a device that displays a map and shows you where you are on that map using the Global Positioning System network of satellites, then, yes, the tablet is such a device.

But if you expect the device to allow you to enter a destination and provide real-time instruction on how to get there, along with an reasonably accurate estimate of when you can expect to reach your destination, then the tablet is merely a GPS Device Poser.

On my Nexus 7, directions are provided by Google Maps, which does a very good job of routing. But something called Navigator assumes the role of proving the actual turn-by-turn directions and arrival time.

Navigator works fine as long as you follow the initial route and as long as traffic conditions do not change during the trip. For example, if you start out at home while the tablet has an Internet connection, Google Maps will check the traffic conditions and provide both a route and an estimate of arrival time that's fairly accurate. You have the option of downloading a rectangular map that encompasses the route, too, so you can use Navigator offline.

But during the trip when the Internet connection is missing, Navigator cannot adapt to a traffic problem. Well, that's to be expected, and it's no reason to find fault in the app. The real problem is that Navigator does not recalculate the trip when you deviate from the route.

On my 20-minute commute to work, I can take one of four different major routes, two of which are on state highways, both of which are littered by red traffic lights. So I like to take the back roads, which are scenic and have fewer stops, albeit longer. It's reasonable for Navigator to prefer the state highways. But when I ignore the chosen route, Navigator refuses to recalculate. Instead it provides directions to return me to the point where I went off course. So the closer I get to work via the back road, the longer the trip time. I've seen the 20-minute commute spike up to 1 hour and 45 minutes. And when I finally do come to an intersection with the highway, it will actually direct me in the opposite direction, presumably to reach a way point on it's own route.

Well there are other GPS apps, even free ones, that can provide turn-by-turn directions. Right now I'm evaluating Navfree USA: Free. It does a better job of dealing with my willful disregard of the planned route. But it's a little rough. For example, it fails to give you the first instruction at the beginning of the trip. Also you need to have an Internet connection in order to get directions to an address because it queries Google maps.  (That's not an issue if you've saved your destination as a Favorite.) I'm assuming that the same is true for Points of Interest.  The biggest problem with it, though, is that it will crash after 30 to 40 minutes and need to be restarted.

So alas, I'm not about to give up my Garmin Nuvi just yet.  It would provide real time traffic updates in some areas and serve as a backup to the tablet in the event that I needed to follow a detour.

---

Edited on 2013-04-13 to add two sentences to the Navfree paragraph.

My Geeky Reward

Recently I took my stash of credit card rewards and, all at once, I bought a GPS device, RF scanner, MP3 player, eReader, camera, digital voice recorder, hand held gaming device, clock, portable translator....

That's one heck of a reward!

Well, if you haven't guessed by now, I bought a tablet.  I suppose "RF Scanner" might've thrown you off, but with the Scanner Radio app, you can turn an Android tablet into a police scanner as long as you're connected to a Wi-Fi network.  Plus you can listen to the goings on of the LAPD¹ from the East Coast.

The six $50 gift cards that I bought with $240 of rewards allowed me to pay for the Google Nexus 7 tablet, tax included, plus the two-year warranty extension, which I chose because I was not paying by credit card.  I usually decline such extended warranty plans on the grounds that my credit card offers the same coverage.  But since I wasn't using the credit card to pay for the purchase, and I was saving so much money anyway, I figured I might as well go for it.  Although I do realize that the device might be obsolete before it expires.

Anyway, I love the device.   I found an app that works with my public library's downloadable book collection.  So if I'm in the mood to read Dave Barry late at night, I can use the app to borrow Dave Barry in Cyberspace, for free.

---

¹ Los Angeles Police Department. The radio traffic of the LAPD and that of San Bernardino County was very popular a few weeks ago during the manhunt for Christopher Dorner.

Earth is 9000 Years Old!

I did not realize until just a few moments ago that our Earth is 9000 years old, and it was created in six days.  So says Rep. Paul C. Broun, a republican from Georgia.  He is a member of a key congressional science advisory committee,  so he must know what he's taking about.

He also refers to evolution, embryology and the Big Bang theory as "all lies straight from the pit of Hell."

http://www.huffingtonpost.com/2012/10/07/bill-nye-paul-broun-science-space-technology_n_1947125.html

Presidential Candidates' Answers to the 2012 Top 14 Science and Technology Questions

ScienceDebate.org invited thousands of scientists, engineers and concerned citizens to submit what they felt were the the most important science questions facing the nation that the candidates for president should be debating on the campaign trail.

ScienceDebate then worked with leading US science and engineering organizations ... to refine the questions and arrive at a universal consensus on what the most important science policy questions facing the United States are in 2012.

...We call on the candidates for President to also debate these Top American Science Questions that affect all voters' lives.

https://www.sciencedebate.org

Facebook's Illusion of Privacy

...whatever you post on Facebook, you should just assume that the public can see it, because even though Facebook tries to put in protections and permissions and privacy controls, there’s really no way to guarantee that only your friends can see your data.

http://spectrum.ieee.org/podcast/telecom/internet/stalking-on-facebook-is-easier-than-you-think

Putting Water Adhesion and Cohesion to Work

I lost the grommet that allows me to attach a drain hose to my air conditioner.  So I decided to see whether water's properties of adhesion and cohesion would come to my rescue.

I suspended the drain hose below the air condition drain opening.  Then I placed one end of a wet, rolled up paper towel in the air conditioner, touching the drain pan.  I placed the other end into the hose.  The set up is shown below.

Normally, you'd just let the water drip out onto the ground.  But this A/C is installed between a kitchen and a carpeted enclosed porch, and we wanted to keep the carpet dry.

The rig works like a charm.  No spillage.  All the condensate ends up in the bottle, which I then empty into the washing machine or the garden.  In fact it works better than if I'd used a grommet to connect the hose.  With the grommet, the water level had to rise high enough to breach the rim of the grommet.  In fact, I used to put a piece of cotton string in the grommet to help lift the water up over the grommet ledge and into the hose.  Otherwise, the water would leak out all four corners of the pan.

There is some rust forming around the edge of that unfinished knockout.  I'll need to paint that at the end of the season if I don't want the rust to spread.

How I Became Paging System Monitor

One of my unofficial volunteer work responsibilities is that of Paging System Monitor.  This is someone who listens to a page over the public address system and then verifies that the pager hung up properly.  Because if the person does not hang up the phone, no one else can issue a page.

Generally this doesn't happen often.  But when it does, it's inconvenient.  It can be embarrassing, too, if the pager continues speaking, thinking that the conversation is not getting broadcast to all the bosses.

Usually it's an easy job to find the off-hook phone, if the person included the (correct) phone extension number in the page.  When you hear, "Joe Smith please call 73," for example, you can assume that the pager used the phone at extension 73.  Then if the phone was not hung up properly, you (or Joe) can just call it, and that phone should ring on the second line.

But if it's one of those generic announcements, such as, "It's starting to rain.  If you left your car windows open, now's a good time to close them;" or "I'll be rebooting the file server in five minutes.  Please close all open files;" or "Would the janitor please come to the men's room -- it's an emergency.  Please bring a mop," then the process turns into a fun game of deduction.

Well, in the case of the call for the janitor, you can assume that the phone is near one of the men's rooms."  So you can walk over to any nearby office and check the phones.  But if a location isn't implied, then you have to revert to recognizing the sound of the voice and then figure out whom it belongs to.  This is easier than you might think.  In fact, I had a good lesson in grade school in how easy "voice recognition" really is.

We were reading a story out loud, and the plot hinged on a character figuring out who someone was just by the sound of his voice.  I asked the teacher how that could happen, and I expressed doubt that you can know who was speaking to you without actually seeing the person.  So the teacher decided to really convince me.  She invited me to close my eyes.  Then one by one, each of my classmates spoke, and I had to guess who it was.  There were only two out of about 30 voices that I couldn't figure out (and one of them belonged to someone named Joe, in fact).  Yes, the teacher was pretty cool.  But it was Open House Day, and our parents were also in the room.  So I suspect she might not have done this if she weren't showing off for them.

Anyway, once you know who the person is, you can usually resolve the problem by calling his or her extension.  Or you might have to walk around and find the person and then ask which phone was used.  I had to do this recently for an announcement the janitor made about locking up the building.  Usually he locks the building because he's the last to leave.  But since he was leaving earlier than usual, he wanted to let us know that one of us had to lock up.  It's a good thing I found him because he used a phone deep in purchasing that I wouldn't have guessed right away.

All this rigamarole wouldn't be necessary if the phone system's PA mode were designed to "time-out" after 30 seconds.  But again, technology fails us yet again, and we resort to wasteful effort to compensate.

Recalculating

I bought the GPS about one month before driving my family to Washington DC.  In order to get used to it, I would use it on my work commute.  I quickly discovered that it had an undesirable habit of choosing congested roads with many traffic lights.

It didn't seem to matter whether I choose Shortest Route, or Quickest Route.  It was oblivious to the Avoid Highways setting.  Even the intriguing Econo-Route setting made no difference.  It was stuck on an undocumented mode I call "Maximize Encounters with Red Traffic Lights."  And where I drive, at least every 1 of 4 traffic lights will be red on any given commute.  If you know how many traffic lights (L) are on the route, you can get a realistic arrival time (if you obey the speed limit) by adding this many minutes to the arrival time the GPS claims: T = 0.5 * L.  My meager 10-mile commute to work features an amazing 21 traffic lights and is ten minutes shorter at 3am when most lights are either green or disabled.

And unlike Monty Python's Flying Circus, I hate traffic lights, even when they're green.  Because a green light is one that is bound to turn red just as you get to it.  Of course anyone who has read my rant on traffic lights (and the follow up post) knows where I stand.

Computers Outnumber People in our House

With the purchase of the HP laptop a few weeks ago, the number of computers in our home exceeded the number of humans.

I bought the new laptop because the screen on the previous laptop went dead. And while the instructions for replacing the inverter board on the Inside My Laptop site were easy to follow, the screen remained blank. For a while I used this laptop with an external monitor. But then its screen started to work again. Yet, I cannot rely on it working all the time -- it seems to dislike rebooting. It's a shame because I just bought a genuine HP battery for it, and the OS (Vista Home Premium) should be around for a few more years.

And remember the computer that I wasn't sure what to do with?  Well, I loaded Windows 2000 Professional on it.  It turns out that Firefox 12 runs on Windows 2000, so it's a good enough solution.  However, after I installed and updated AVG Anti-virus, the computer failed to reboot.  I guess I'll try the repair option and then reinstall if it doesn't work.

I did try installing XP first.  But it was very slow.  Plus I had the issue of an invalid CD key and no prospect of activating it.  I do actually own XP, but I'm not sure how to convince the computer of that.

Another neat thing I do with this computer is I boot Dynebolic from the CD.  It runs really well, but there is the issue that there's no Flash player for it.  As well I couldn't figure out how to create multiple password-protected user accounts.  So I wouldn't want to use it for any secret, anonymous activity, like updating this blog, without pretending it's a public computer.

Tainted Chocolate For a Scary Halloween

The melamine that was found in tainted milk could be in the chocolate that's passed out this Halloween.

Please watch this "Candy Product Review 2008 of Potentially MELAMINE Tainted Treats, A SERIOUS Warning By Mike Mozart of JeepersMedia on You Tube" and warn others.

And consider giving out stickers, yourself.

Thank you.

Bailout, Schmailout

Congress thinks we need a bailout. Wall Street definitely needs a bailout. What do you think?

I'll tell you what I think. We don't need it.

Our economy is self-correcting. Higher interest rates caused trouble for people who were in too much debt. They could no longer pay back their loans. As well, the ever increasing cost for gasoline and heating oil put an extra strain on the entire working class.

But now, the rates on Treasury bills are ridiculously low. This means the rates on home equity lines of credit and the interest rates on ARMs (Adjustable Rate Mortgages) have fallen because they're both usually indexed to one of the Treasury bills.

We're also seeing much lower prices for gasoline. Drivers are practically swerving off the side of the road to stare at the prices. "Wait, did that actually read $3.19? No it must've been $4.19. Let me look again."

One big problem remains. Businesses may start to fire workers because they cannot finance growth projects or even payroll. In this case, the appropriate course of action for our government is to finance projects that lead to new jobs.

Imagine how many jobs $700 Billion could start. You could create a whole oil-free energy infrastructure with that amount of money. People would have jobs, and we'd finally be independent from unfriendly oil-producing nations.

But then, what kind of jobs will the greedy Wall Street CEO's get? My advice is to put them on disability -- essentially pay them to not work. We'll all be better off then.

More USA Election 2008 Resources

Watch the Biden-Palin debate online.

Then skip over to FactCheck.org to find out how accurate each candidate was.

The first Obama-McCain debate also is on Hulu.

Find the FactCheck.org response to it.

I wrote about Science debate two weeks ago.

Check out the Information Technology & Innovation Foundation's "Comparing the Candidates' Technology and Innovation Policies."

Scientists and Engineers for America helps you determine how each candidate voted on energy and technology-related bills while in Congress. (Its database covers all members of Congress):

http://sharp.sefora.org/

---

2024-10-01 LG Update links to FactCheck.org. Change SEforA links because it is inactive.

Beware Bank Phish E-mail

Experts predict Spike in Fraudulent Activity Due to Banking Turmoil

Woking, UK. 25th September 2008 An
increase in fraudulent activity is likely to follow the recent events
in the banking sector according to UK Company, First Cyber Security.
Customers with internet banking accounts are urged to take care if
asked to respond to emails from banks which have been named as being
involved in the recent takeovers and mergers.

- First Cyber Security (FCS)

Read more...

So be very suspicious of e-mail asking you to click a link and login. Okay, that's just about every commerce-related e-mail. But if the content urges you to "login right away and confirm personal information otherwise your account will be suspended," be very suspicious. And never enter personal information into the body of an e-mail itself.

I recommend that you equip your browser with an anti-phishing toolbar. You can learn more about them on the CastleCops website, in the Anti-Phishing Toolbar thread.

Obama's and McCain's Answers to the Top 14 Science Questions Facing America

"Science Debate 2008 worked with ... leading organizations ... to craft the top 14 questions the [Presidential] candidates should answer.  These questions are broad enough to allow for wide variations in response, but they are specific enough to help guide the discussion toward many of the largest and most important unresolved challenges currently facing the United States."

Read the candidates' answers here:

http://www.sciencedebate.org












http://www.sciencedebate.org/news20080830.html

What Should I Do With This Computer?

I have an old computer that I'm wondering what to do with. It's a Pentium III, 500MHz, with 256MB RAM and a 10GB hard drive, with only less than 3GB left.

The case is a low profile style, so there's no bracket for an additional drive, which I do have. If I add the second drive, I'd have to attach it with double-sided tape.

The computer is configured to dual boot into either Windows 98 or Windows NT 4.0 SP. The NT partition has Office 97 installed on it. It still works. But I'd like to be able to install somewhat modern software on it and use the USB ports.

Three ideas I have:

• Reformat the drive with a single partition and do a fresh install of Windows 2000. It would be comparable to the software configuration on my current desktop. This would get the USB ports working. But some programs, such as iTunes, no longer support Windows 2000.


• Reformat the drive with a single partition and do a fresh install of Windows XP. Not sure how it will perform on this system, though.


• Reformat the drive and install Ubuntu. Not sure what software is available -- maybe just a web browser, Open Office and a PDF viewer. And of course Emacs. Most likely no one else in the house would use the computer. And I wonder if I can get all the drivers I'll need.

The first step is to get the second drive installed, if I can.

What do you think?

Follow Up to "Career Doldrums"

Just a quick follow up to my previous post.

I was a bit unfair in saying that the book advises you to deal with doldrums by changing careers. That's not all it does. It's also great confidence booster, especially for baby boomers who are worried that they're too old to find a new job.

It explains the differences among the Baby Boom, Gen X and the latest generation (Gen Y. See Wikipedia's List of Generations for generation definitions.) This comparison serves as a foundation to convince the baby boomer that his/her contribution at a new company will be valued. Gen Y wants immediate gratification and frequent rewards, but Baby Boomers don't need that. Gen Y doesn't want to waste time giving their boss progress reports -- they just want to dive in to the work and finish it as quickly as possible.

The generational comparisons also help older workers understand their younger bosses, who come in to the workplace and turn it up-side-down.

So I found it interesting. And it ultimately helped me understand that I might be better off staying where I am.

Resources from the "Career Doldrums" Book

I finally got around to reading "Escape the Mid-Career Doldrums: What to do Next When You're Bored, Burned Out, Retired or Fired", which I mentioned in my January 17 post, "Book Recommendations From CareerBuilder.com".

Basically, the Escape involves switching careers. This involves making extreme financial sacrifices and tapping into a vast store of retirement savings. The assumption is that you've already raised your child(ren) and he/she/they've somehow managed to become self-sufficient. For some reason, the book didn't mention playing the lottery.

This is not a book written for my generation.

Anyway, I wanted to record some of the online resources that the book offers:

www.engineeringjobs.com

Occupational Outlook Handbook -- www.bls.gov

www.hotjobs.com

www.jobbankusa.com

www.computerwork.com

www.computerjobs.com

www.dice.com

www.justtechjobs.com


Philanthropy News Digest -- news regarding fundraising and establishing a foundation.
www.foundationcenter.org/pnd

www.idealist.org

www.nonprofitoyster.com


Self Employment

www.betheboss.com

www.money.cnn.com

www.wibo.org "Boot camp" for entrepreneurs.

www.franchise1.com

www.smartbiz.com

www.sbaonline.sba.gov

Enjoy!

How New Blinds and Windows Can Keep You Cool

I've had the new window shades since November, but I didn't start to appreciate them until the warm weather arrived.

The neat thing about these shades is that they open at the top and the bottom. So do the windows. (The picture is of Bali's DiamondCell - Solitaire 3/8" Double Cell Shade, which is the style of shade I bought and installed.)

So that means I can keep the top of the windows and blinds open even at night without compromising privacy. And the hot air that collects near the ceilings can leak out more easily.

It also helps that the window panes are coated to reflect the heat of the sun.

It's simple things like this that prevents us from wasting energy.

Social Networks for Book Lovers

I just learned about LibraryThing from reading Sacha Chua's blog post, "Taking book notes." LibraryThing is a social network for book lovers.

The general idea is that you enter books into your library by searching for a title or ISBN. There's also an import tool that will scan a webpage and pull in the ISBNs it can recognize. I used this to import the 106 books that were referenced on my "List of Books I've Read Recently," which I might decide to replace with some references to my library on LibraryThing.

Once you have books in your library, LibraryThing will provide links to profiles of users that have many of the same books in their libraries. You can navigate to their libraries and leave comments on their profiles.

Well, that's just a brief overview. Check out LibraryThing for yourself.

For a more in-depth discussion of LibraryThing and other such sites, check out NPR's All Things Considered discussion of social networks for book lovers.

Help Our Airlines Save Fuel

Airlines are struggling with the ever-increasing cost of fuel. They've started to charge passengers to check baggage. Let's think of other ways they can stay aloft in this turbulent economy:

1. Charge passengers a fee that's proportional to the total weight of the passenger plus all his/her baggage, both carry on and checked.


2. Offer passengers stationary bicycles and other exercise machines to prevent DVT, but secretly use the machines to drive electrical generators, which can power such non-essential systems as entertainment, lighting and navigation.


3. Offer passengers free refreshments in the terminal. Lace the refreshments with laxatives and diuretics. ^{1, 2}
   

What can you do personally? Why not leave the heavy luggage behind? Just choose baggy clothing to wear at your destination, and put it all on before you leave your home. Better yet, don't even bother bringing extra clothes. Just buy your change of clothes at your destination.

With lots of creative planning, we can yet again save our beloved airline industry.

---

¹ Empty passengers are lighter.
² Whatever they leave behind can be used as bio-fuel.

Driving to Optimize Fuel Economy

In my area, gas prices have jumped beyond $4.00 per gallon over the last couple of weeks. I ranted before about how traffic lights contribute to decreased fuel economy. But I didn't mention that driving technique can dramatically influence fuel economy.

An extreme type of driving that maximizes fuel economy is called Hypermiling. Generally the idea is to minimize acceleration and braking. Unless you're going down a steep hill, acceleration requires more gasoline than just maintaining speed. And braking converts all your car's motion (which came from gasoline) into heat energy. So essentially, braking is like throwing away gasoline.

If this is the kind of topic that gives you goosebumps, you might be interested in the forums at CleanMPG, especially Wayne Gerdes' post "Beating the EPA - The Why’s and how to Hypermile".

And rather than boycotting gasoline for one day, folks should either not drive on that day, or at least drive more efficiently. With the subsequent drop in demand, gas prices would relax.

MySpace Notes

My pre-teen daughter already has a website and just started a blog. So I figured I should start learning more about MySpace. She's not on MySpace right now, but she might be in a few years.

I've just finished reading "Me, MySpace, and I," by Larry D. Rosen. It suggests that parents open an account on MySpace because there are many areas on the website that you can't access unless you're logged in.

Many websites require users to provide a real name and real address when you open an account. This is particularly true of commerce sites like Amazon.com. So I was not alarmed when MySpace asked for my real name and town, "so other members can search for you." It assured me that it wouldn't display my name, but I cautiously provided a bogus name, anyway.

When I finished entering the required information, it showed me the profile page that it created for me. And there was the bogus name and town displayed in nice bold type. Thanks for preserving my anonymity, MySpace.

Well, anyway, I'm there now, and no harm was done to me.

Some things from the book I thought worth mentioning. This quote, for example:

"Some MySpace young people have told me that they like to pretend to be dumb just to see what other people do and say. One guy got a date with a girl by pretending to be a "C" student and when she met him and found out he was a "brain" she canceled the date."

- page 70

Check out http://www.ypulse.com for trends in the lives of tweens, teens and young adults.

Other resources:

http://www.isafe.org
http://www.parenthood.com
http://www.allianceforchildhood.net
http://www.kids.getnetwise.org
http://www.cybersmart.org
http://www.netsmartz.org
http://www.besafe.com
http://www.protectkids.com
http://www.webwisekids.com
http://www.internetbehavior.com
http://www.safeteens.com
http://www.blogsafely.com
http://www.commonsensemedia.com
http://www.safefamilies.org
http://www.wiredsafety.org
http://www.netfamilynews.com https://www.cyberghostvpn.com/privacyhub/guide-to-sharenting/

---

2025-07-07 LG Add link to www.cyberghostvpn.com and target="_blank" param to a tags

Autism Awareness

April is Autism Awareness Month here in USA. Would you be able to recognize the symptoms of autism if you saw them? Probably not.

The latest estimate of the prevalence of autism is that 1 in 150 people in the USA have been diagnosed with an Autism Spectrum Disorder (ASD), which is also known as Pervasive Developmental Disorder (PDD).

If you're in the fields of engineering, computer science, physics or math, the chances are even higher that you, your children, your coworkers or their children could be diagnosed with this disorder. And you should check out http://firstsigns.org/, which is dedicated to the early identification and intervention of children with developmental delays and disorders, including Autism Spectrum Disorders.

The diagnostic criteria for ASD in children concern development and ability in the areas of social interaction, communication and play. Please see "Diagnosis and Epidemiology of Autism Spectrum Disorders," by Lee Tidmarsh, MD, Fred R Volkmar, MD.

Early detection of an ASD is crucial because when interventions are tried at an early age (say at 3 to 5 years of age), they seem to be more effective than when tried later on.

Those who have an ASD and who can communicate say that they don't want to be cured; they just want to be accepted. Thus, it's not they who have the problem, it is society. Nevertheless, interventions can make things easier for children and the autistic adults they grow in to.

What kinds of interventions can reduce the symptoms of an ASD? A change in diet -- avoiding wheat and dairy productions, for example -- can help those with Leaky Gut Syndrome, which can manifest as symptoms of ASD. Another effective, diet-related approach is supplementation with mega doses of vitamin B6, or its active co-enzyme, P5P. Play therapy or Applied Behavioral Analysis (ABA) has been proven to help. In some cases, mercury detoxification may help. There are many more interventions for a parent to choose from. Then there are interventions aimed at easing the secondary symptoms that accompany ASD such as Obsessive Compulsive Disorder and Depression.

Scientists can spend entire careers looking for signs of intelligent life in the Universe. Meanwhile, medical researchers have overlooked signs of intelligence in people with autism. They assume that people who can't talk and who respond differently to stimuli must be lacking in intelligence.

If you don't believe me, consider the amazing website, Getting the Truth Out, which was originally written in response to an objectionable Autism Awareness fundraising campaign called "Getting the Word Out." Be sure to follow the presentation completely to the end.

If you suspect that you or a loved one is struggling with an ASD, visit the Online Asperger Syndrome Information & Support (OASIS). (Asperger Syndrome is an ASD, and is sometimes referred to as High-Functioning Autism.) As its name suggests, you can get a great deal of information from the site. You can find most of the support by clicking on the Message Boards menu choice and registering for the "OASIS: Asperger Syndrome Forum".

How to Avoid a Recession

There's a lot of talk about what to do about the economy. One group of economists believes that Federal Reserve Board Chair Ben Bernanke made a mistake in cutting interest rates recently. They think that will lead to inflation.

Most politicians agree that we need some form of tax cut. Some say that the middle class should get a tax break. Others say no, the middle class will just use it to pay down debt, and that businesses need tax breaks in order to hire more workers.

Some suggest that saving sub-prime mortgage borrowers from bankruptcy is the key to bringing about economic recovery.

Many of these opinions have merit, but they fail to address the cause of the faltering economy. The real problem is the rising cost of energy.

The economy depends on energy for growth. You cannot manufacture items unless you use energy. You cannot transport these manufactured goods unless you use energy. And consumers cannot afford to buy these goods if they're spending most of their disposable income on energy.

You might think we'd've learned a lesson from the oil crisis of the 1970s. But our favorite energy source still seems to be based on oil. And as the oil supply tightens, our economy falters.

Imagine this scenario: It's the distant future, and our world is without oil. Where does our energy come from for manufacturing, transportation and consumer use? Solar and nuclear.

Equatorial countries are the world's energy movers and shakers. They get the most intense solar radiation. They produce the most electricity per photo-voltaic cell. Their biofuel is the richest and most abundant on the planet.

So perhaps it's time to cut taxes on oil, gasoline and electricity. Maybe it's even time to think about subsidizing energy costs? It depends on how serious our government is about maintaining economic growth.

Engineers Week

Engineers Week was last week. One reason the organizers put effort into making and promoting Engineers Week is to get kids interested in engineering. So why does it take place during winter vacation week?

So I'll be belatedly "celebrating" Engineers Week this week by visiting my daughter's elementary school class and talking about electricity. My presentation is titled, "Watt is Electricity?" Get it?

I made a little electromagnet kit for each student. All I did was wind about four feet of solid 22 gauge copper wire around a nail. I placed this in a bag with a D battery, some paper clips and a sheet of paper with this text:

Electromagnet Test Kit
Contains:

• 4’ 22 AWG Solid Insulated Copper Wire
• Steel Nail
• D Battery (1.5V)
• Paperclips (to test electromagnet)
  

When electrical current flows through a wire, a magnetic field develops around the wire. By winding the wire into a tight coil around an iron core, the magnetic flux is concentrated, and the magnetic attraction is strong.

Touch the bare wire ends to the battery terminals.

Watch Out – it gets HOT.

How many paper clips can you pick up?

What do you think would happen if:

• You unwrapped some of the wire?
• You used a 9V or 12V battery?
• You wrapped the wire around a pencil?

Science Links for Kids
http://www.energyquest.ca.gov/projects/
http://www.eia.doe.gov/kids/
http://www.ieee-virtual-museum.org/
http://www.discoverengineering.org/

Those links are pretty cool. Check them out when you get a chance!

More on Traffic Lights

I was too tired to continue my previous post. So I'll add some comments here in a new post.

I wrote:

If the number of cars on the main road is so great that you need to interrupt the flow in order to let yet more cars on it, you're contributing to yet more traffic congestion.

Actually, about 16 years ago, traffic lights were introduced on entrance ramps to the Long Island Expressway. The idea was to prevent cars from entering the highway during rush hour. That demonstrates an appropriate use of traffic lights -- to improve the flow of traffic rather than to impede it.

I wrote:

It's inefficient to force several cars to stop for the sake of one or two cars that are already stopped. Forcing a car to stop and then accelerate back up to cruising speed is a significant waste of gas. In fact every time a driver applies the brake, he or she "throws away" the fuel that was used to accelerate the car. And acceleration is what uses the most fuel.

And...

Many of these intersections are so small that when cars turn onto them from the main road, the cars trigger the Hall effect sensor that causes the light to cycle. Thus, the light turns red for those who navigate the main road even when there's no car to yield to! More waste!

You can solve both problems simply by installing (or moving) the sensors farther back from the intersection and decreasing the sensitivity. That way the light won't cycle unless there are a few cars queued up. It might be a good idea to change the mode to blinking red-yellow during non-peak hours to allow cars to enter the main roadway whenever it's clear, but then have the light switch to give the right-of-way to the smaller roadway when enough cars are waiting.

I can imagine the day when every intersection will have a traffic light. Hopefully I'll be dead by then. Or perhaps traffic lights will be part of a Intelligent Vehicle System that's designed to route traffic for maximum efficiency. Lights will be used to tell motorists when it's safe to enter the intersection rather than stop other cars to allow them to enter.

The Problem With Traffic Lights

"'See, I can time them perfectly,' the [traffic] light said with satisfaction. 'I get hundreds of them each day. No one gets through my intersection without paying his tax in gas and rubber.'"

"'Go blow a bulb!' the car growled at the light.

"'Go soak your horn!' the light flashed back."

- from pages 187 to 188 of "Centaur Aisle," by Piers Anthony

I've had this quote in my "Quote du Jour" for several weeks, ready for the day I finally rant about traffic lights.

In my town, traffic lights are installed indiscriminately as a feeble response to town growth. The rich folks flock to buy McMansions in new developments. Then they complain that they can't get onto the main road without waiting a minute or two for a break in the traffic. So up goes yet another traffic light.

There are intersections where traffic lights are needed, such where two main highways intersect.

But why install one at a "T" intersection on a busy main road for a tiny side street? Here's why it's not a good idea:

• If the number of cars on the main road is so great that you need to interrupt the flow in order to let yet more cars on it, you're contributing to yet more traffic congestion.
• It's inefficient to force several cars to stop for the sake of one or two cars that are already stopped. Forcing a car to stop and then accelerate back up to cruising speed is a significant waste of gas. In fact every time a driver applies the brake, he or she "throws away" the fuel that was used to accelerate the car. And acceleration is what uses the most fuel.
• Many of these intersections are so small that when cars turn onto them from the main road, the cars trigger the Hall effect sensor that causes the light to cycle. Thus, the light turns red for those who navigate the main road even when there's no car to yield to! More waste!
• Finally, traffic lights waste electrical power all day and night. In fact, they remain powered up even in the wee hours of the morning when no one needs them. At night they're so bright you could read a large-print book under them. Why not reduce the light intensity after dark and save money? True, some lights are set to blink red-yellow, and thus they require half the electricity to light the lamps. But the controllers that run them also waste electricity. So just shut them down completely and get that power consumption down to zero. Drivers know anyway to stop before they enter a main road in the absence of traffic control.
  

Book Recommendations From CareerBuilder.com

The CareerBuilder section in our December 16, 2007 newspaper featured 16 career guidance books in its list of "this year's most interesting career books." A few of them look as though they'd be really helpful for me. Unfortunately I couldn't find the article online. I'll list the book titles with links....

• "The IT Factor: Be the One People Like, Listen To, and Remember" Maybe?
• "Winning Nice: How to Succeed in Business and Life Without Waging War" Maybe?
• "Lessons on Leadership: The 7 Fundamental Management Skills for Leaders at All Levels"
• "Whoever Tells the Best Story Wins: How to Use Your Own Stories to Communicate With Power and Impact"
• "Get Your M.B.A. Part-Time, Fourth Edition: For the Part-Time Student with a Full-Time Life"
• "Buzz: How to Create It and Win With It"
• "Work Like You're Showing Off: The Joy, Jazz, and Kick of Being Better Tomorrow Than You Were Today" Maybe?
• "Making a Living While Making a Difference: Conscious Careers for an Era of Interdependence"
  This sounds like a good one!
• "Get Ahead by Going Abroad: A Woman's Guide to Fast-track Career Success"
• "Saving the Earth as a Career: Advice on Becoming a Conservation Professional" This sounds like another good one!
• "Escape the Mid-Career Doldrums: What to do Next When You're Bored, Burned Out, Retired or Fired" Yes, this is what I need!
• "Time Power: A Proven System for Getting More Done in Less Time Than You Ever Thought Possible" Bingo! (But I suspect the authors don't advocate Spending an hour blogging about career books.)
• "Make Your Contacts Count: Networking Know-how for Business And Career Success"
• "College Majors Scorecard" The self-assessment tool sounds interesting.
• "The Girl's Guide to Building a Million-Dollar Business"
• "Career and Corporate Cool" Maybe?

Anniversary Dates for Engineers

When an engineer picks a wedding date, chances are it has some numeric meaning. It's a fun challenge to come up with a sequence of numbers that forms a date that falls on a weekend. And afterwards, it lessens the likelihood that the anniversary will be forgotten.

Here are some simple weekend dates in MM/DD/YY format that are based on simple multiplication facts: 02/16/08, 12/08/96.

Here are dates based on sequences: 06/07/08, 05/10/15, 09/16/xx. With that last one, the month and day are so good, we'll ignore the year.

Some other nice dates: 08/16/08, 03/14/15, which are the first five digits of Pi.

Are you an engineer that married? What date did you choose?

Emacs: Yet Another Cool High-Tech Thing

Two years ago, I wrote about Servant Salamander. In that post, I described how Servant Salamander substituted nicely for Norton Commander when I made the switch from MS-DOS to Windows NT.

The other software substitute I made was to replace my favorite text editor, Brief. When I started using Brief, it was by a company called "Underware." When I stopped using it, it had been taken over by Borland. They had no plans to make it Windows-compatible.

I loved Brief's ability to record and playback keyboard macros. It had undo. Its regular expression search and replace capability was powerful. It could cut and paste columns of text. It could be scripted. It supported multiple windows.

I continued to use Brief on Windows NT, even though its cut and paste didn't work with the Windows clipboard. And I recall having display problems at certain video resolutions.

So I set off in search of a new Windows text editor. The minimum requirements were:

• Column marking, cutting, pasting.
• Undo.
• Regular expression search / replace.
• Keystroke macros.
• Windows compatible.
  

I wanted an editor that could be scripted. And even better, one with the same keystrokes as Brief, or with a reconfigurable keyboard.

I came across Crisp, Zeus and then Vedit a bit later.

I rejected Crisp almost immediately, even though it seemed to be the ideal replacement. The problem was that it was unstable. Or, more accurately, it made my computer unstable. So I dropped it quickly.

I was mostly happy with Zeus. But sometimes I needed to edit binary files, and one thing I did not like was that Zeus could not handle null characters. (And it wasn't 100% Brief-compatible.) That's why I got Vedit. Vedit did a great job with all kinds of files of all sizes. I was even able to edit EBCDIC files, which helped when I was writing an EBCDIC to ASCII translator. But I never got comfortable with Vedit, so I continued to use Zeus primarily.

One day I decided to try another search for the Ultimate Text Editor. Someone recommended Gnu Emacs.

Emacs was "sort of" Brief compatible. In fact, it was Crisp-compatible with its Crisp-mode Lisp add-on. But in reviewing Emacs, I came across the advice that it's best to learn the native key-mapping. So that's what I did, back in 2001.

It was a bit hard to get used Emacs, and I did have to remap the keyboard a tiny bit. For example, back then, Emacs would interpret the Del key as Backspace, which deletes the previous character instead of the next character. (This is not true of more recent versions.) Also, I stumbled over Emacs terminology. For example, it's not "Cut" and "Paste" but rather "Kill" and "Yank."

But all the effort I put in to it was well worth it. Now, I don't bother to write text-manipulation programs because it's easier (and more fun) to script Emacs to perform that kind of work. I enjoy using Emacs Planner to keep track of tasks and notes that pertain to numerous work projects. And at one time, I enjoyed using the newsreader Gnus with it's wonderful ability to score message threads based on any number of regular expression filters I could come up with.

Emacs is licensed under the GNU General Public License, which means that it's free, not only in the sense that you can obtain it without cost, but also that you are free to modify and distribute the software, provided you pass along this same freedom.

Emacs is amazing. It is constantly being improved by intelligent people who demand great things from their programs. It can run on many different platforms. Try it out!

The Personable Computer

We call them Personal Computers. But why can't they be Personable?

The other day I was typing an e-mail. I thought I had on-the-fly spell checking enabled. Then I typed the word "triennial" and didn't see the red squiggly underline. I wondered, "Did I really spell that right?" and "Is spell check really turned on?" I decided to run the spell check manually. And it ran, finishing with a disappointing absence of fanfare over my correctly spelled word.

Why couldn't it respond, "Hey, great job at spelling triennial, big guy"? I am an engineer, after all, so I'm supposedly disposed toward bad spelling.

How should that response have worked, exactly, without actually being annoying? Certainly a focus-stealing pop-up would've been downright annoying. And a little checkmark after the word might not have been effusive¹ enough. Perhaps a message in the status bar would've afforded the best trade-off between noticeability² and interference.

The reason computers don't provide this kind of feedback is because of how intensely users loathed Clippy, the default Microsoft Office 97 help mascot. Clippy was best known for saying, "It looks like you're typing a letter. Would you like some help with that?"³ Of course users loathed that. We know how to type a freaking letter. We don't appreciate being patronized by something with half the intelligence of an earthworm. Whoever designed that hadn't ever held a door open for a feminist.

But if Clippy had offered praise instead of assistance (or perhaps in addition to assistance), he/it might've been accepted or at least tolerated. And it would've been better if it weren't so dorky looking.

I'm sure we'll see a return of something like Clippy, albeit well-disguised. It's just too tempting a feature to ignore for long.

---

¹I spelled this correctly the first time, too!

²But alas, I did not spell this correctly the first time.

³And there are wonderful parodies⁴ of this too, such as, "It looks like you're typing a suicide note. Would you like some help with that? Okay, first tell me, how do you plan to kill yourself? Choose one: Gunshot to the Head; Slash Wrists; Overdose; Jump Off Tall Building or Bridge; Step In front of a Moving Train, Truck or Automobile. Great! Thanks! Next, tell me the reason why you're killing yourself: No One Understands Me; My Lover Left Me; I'm Broke; I Can't Stand This Asinine Clippy... And so on.

⁴See, for example, One Egg Shy's Clippy's Guide to Suicide Notes, or his Clippy’s Guide to Ransom Notes.

Hey buddy, can you spare a few CPU cycles?

Do you leave your computer running and connected to the Internet? If so, why not donate its idle CPU cycles to scientific research? You could help figure out the cause of Alzheimer's disease, predict climate, or search for evidence of gravitational waves or extraterrestrial intelligence.

The Folding@Home distributed computing project is committed to exploring protein folding. Its goal is to gain an understanding of:

• Alzheimer's Disease
• Cancer
• Huntington's Disease
• Osteogenesis Imperfecta
• Parkinson's Disease
• Ribosome & antibiotics

All it takes to get started is to download and run a small program. Click here for more details. Other protein research projects include Rosetta@home and Predictor@home.

Other things your computer could work on:

• CPDN: climate prediction.
• SETI@home: the search for extraterrestrial intelligence.
• Einstein@Home: find spinning neutron stars.

Download an installer and join the research!

The True Meaning of Christmas

It finally clicked in me -- the True Meaning of Christmas.

It was when I heard the Christmas story retold for the fourteenth consecutive time, at last night's Family Christmas Eve service, at our local church. The Pastor had read Luke's Gospel, and then he expounded on it.

He started by describing Luke 2:1-7 in more detail. The reason that Jesus, Mary and Joseph were staying in a stable is that there was no room at the inn. That I've known since I was a child, but nothing more.

The rest of it needs to be appreciated against a backdrop of adult experiences. The child I was did not bother to wonder why they needed to find an inn.

The Pastor explained that Joseph needed to haul himself (and the pregnant woman he was engaged to) 80 miles, by foot, from his home in Nazareth back to Bethlehem in order to be counted in the census. So he could be taxed.

That's my wife and me, Joseph and Mary. Not only do we have to undertake some pain-in-the-ass journey for some poorly-planned government bullshit, we have to do it when we're about to give birth. All for the ultimate pleasure of paying taxes. This is jury duty on a Grand Scale.

To make the story more interesting, Joseph is caring for a woman whose child she carries is not even his.

And this is the way the Universe works. Even God's Children cannot escape suffering the idiocy that this world has to offer.

Time Magazine Person of the Year (What Else?)

As soon as I heard that Time Magazine's Person of the Year (POTY) was "Me," I knew I had another sarcastic blog entry to write. By now, this entry is but one of many that pokes fun at Time. And if you want to listen to great commentary on the topic, redirect your browser to today's commentary by Bill Langworthy on NPR's All Things Considered.

I'd rather not waste much content on Time. POTY noise actually rewards Time in the end, even if it's criticism. I just want to point out that choosing me as POTY (along with hundreds of thousands MySpace teenagers who are either horny or lonely or both) was plain laziness. If Time had done a little research, they'd've discovered the term blogosphere, which might've led them to this special issue of Communications of the ACM. And somewhere in this two-year-old, well-researched set of papers would be the person or team responsible for creating the technology that enables us POTY winners to blog.

If it sounds like I'm angry at Time, it's because I am. Aren't I supposed to receive some monetary award? Because I didn't. Hello?

Build My Own Universe? Are you Joking?

Okay, I finally accept that my elementary-school-aged daughter can design her own web page and probably make it look a whole lot nicer than this site. But could the next generation one day build its own universe?

Incredibly, some physicists think so, according to this feature on NPR's All Things Considered:

http://www.npr.org/templates/story/story.php?storyId=6545246

This is a cool page, not just for the feature article, but for the related links. The one bit of disappointment I feel is that I wish this came out nearer to April Fool's Day. That way I could fool people into thinking that something is a joke when, in fact, it's actually real.

So I wonder if our Universe was once created by a team of ambitious physicists in a higher level universe? What if they have to shut down their experiment due to lack of funding? Or what happens if a student overheats a Twinkie and in the process accidentally destroys the lab while attempting to redo one of the Twinkie Experiments?