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-departmental1 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 moments2 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.
1 The emphasis is on the part of the word that contains "mental".
2 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.
Saturday, February 01, 2014
Friday, October 18, 2013
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....
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....
Saturday, September 28, 2013
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 theadvertisements 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.
So when I heard the
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.
Monday, August 05, 2013
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.
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.
Saturday, May 25, 2013
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.
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.
Friday, May 17, 2013
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?
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?
Friday, April 26, 2013
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:
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
Saturday, March 23, 2013
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.
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.
Saturday, March 02, 2013
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 LAPD1 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.
1 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.
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 LAPD1 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.
1 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.
Tuesday, October 09, 2012
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
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
Monday, September 17, 2012
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.https://www.sciencedebate.org
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.
Labels:
election 2012,
recommendations,
science,
technology,
websites
Monday, July 30, 2012
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
Tuesday, July 17, 2012
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.
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.
Labels:
DIY,
efficiency,
engineering,
kludge,
repair,
science
Friday, July 13, 2012
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.
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.
Monday, July 02, 2012
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.
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.
Monday, June 25, 2012
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.
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.
Wednesday, October 29, 2008
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.
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.
Friday, October 10, 2008
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.
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.
Friday, October 03, 2008
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.
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.
Thursday, October 02, 2008
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)
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.
Subscribe to:
Posts (Atom)