How to articles, some life hack tips, basically your daily dose of brain food. Subscribe for Daily updates

November 26, 2009

Re: datasets of doctors

Here's what we're offering for this week:

Certified Physicians in the USA

788,244 in total * 17,676 emails

Physician in over 34 specialties

16 different sortable fields

American Pharmaceutical Company List
47,000 names and emails of the major positions

Hospital Facilities in the US
Complete contact information for the important jobs held at the hospitals

Extensive Listing of Dentists in the United States
Practically every dentist in the United States is listed here

Directory of US Chiropractors
Over than 100k chiropractors practicing in the United States

Reduced to only:
$396 for all listed above

send us an email:

Offer ends this Friday

to terminate please send a blank message to

November 25, 2009

There is data for over 34 different medical specialties

Here is a catalog of US contact lists we have for sale:

+Alternative Medicine
+Nursing Homes
+Pharmaceutical Companies
+Physical Therapists
+Massage Therapists
+Medical Equipment Suppliers
+Mental Health Counselors
+Visiting Nurses & RN's

The lists have many different fields including phone, fax, postal address, email and much more. This week you can buy any 4 of the above lists for just $349.
Please contact me here: (please include this email when responding)

To stop receiving this email correspondence please send an email to

November 16, 2009

Directory of small to medium sized businesses for the United States

This list has phone, fax, email, contact name and many more fields

1.8 million total records - all data collected this year

This week only you pay only: $290 - for this week

Email us at:

Send email to for deleted status

November 05, 2009

Re: Lists of MDs and Dentists

Are you still looking for directories of US doctors or dentists? I have lots of US medical lists, let me know what you need and I will get you some more info, samples and a good price.

you can reach me at:

For your subscription status modification please contact

May 18, 2009

GoogleLookup: do things you never thought possible with spreadsheets

For those of you not familiar with functions in Google Spreadsheets (the function-savvy may skip to paragraph 3), here’s a really simple example of a more conventional function: sum. In any spreadsheet cell, if I enter =SUM(3+5) and hit the “return” button, the content of the cell will display 8. Functions can also refer to values already in your spreadsheet, which is what makes them particularly useful. For instance, the function =SUM(A2:A20) will instantly sum all of the values in column A, rows 2 through 20. If you want to try this yourself, go to and open a new spreadsheet. You can also learn more about functions in the Google Docs Help Center.

So what makes GoogleLookup really cool is that it references data not just from your spreadsheet (as with functions like =SUM(A2:A20)), but searches that incredibly expansive body of published information: the world wide web. By performing a targeted websearch, GoogleLookup attempts to return some fact about the entity you specify. City populations are a nice example. Entering =GoogleLookup(”Philadelphia”; “population”) in any spreadsheet cell…

screenshot: GoogleLookup function

screenshot: GoogleLookup function

screenshot: GoogleLookUp loading

screenshot: GoogleLookUp loading

returns the value 1,449,634, which is in fact accurate. This may sound like magic, but go ahead and try it in a spreadsheet of your own. Now try swapping out “Philadelphia” for other city names: New York, Boston, San Francisco, Bangkok, London…

Radical, no? Perhaps you are saying to yourself, “this seemingly magical feature is indeed rad, but what real world scenario would actually warrant use of this function? How can GoogleLookup help me?” Let’s look at one example.

My good friend Caroline recently asked me and Dan to recommend some awesome dance songs for her upcoming wedding. Needless to say, Dan and I had lots of suggestions. Rather than rattle them off while she took notes on a scrap of paper, I told Caroline that I would send her a spreadsheet. When I got home, I opened a new spreadsheet and typed out 26 dancable song titles. But I wanted to give Caroline a little more information — I wanted to include the artist of each song. I didn’t know the artists for some of the songs on the list (especially for some of the more questionable tracks, all suggested by Dan) but I could have looked each one up and then typed out the artists name. This might have taken 20 minutes. Instead, I used GoogleLookup to automate that process.

Take a look at the spreadsheet. In cell B2 (under “artist”) I typed =GoogleLookup($A2, “artist”). (ignore the $ symbol; it just means that I want the function to use column A even if I copy the formula into another column). I then copied this function into all of the cells in column B (just drag the lower right-hand corner and drop). Within moments, all of those cells were populated with likely values for the attribute “artist” given the entity in column A, the song title.

Now, as you will observe, the values are not perfect. Gloria Trevi is NOT the artist I had in mind when I suggested the classic rock tune, “Gloria.” And while UB40 did do a version of “Can’t Help Falling in Love With You,” I would urge Caroline to stick with the Elvis original. But there were also a lot of accurate values. And one cool subfeature of GoogleLookup is that clicking into the cell will trigger a pop-up citing the source (url) of the value and offering a “more options…” link.

screenshot: click into cell for more info

screenshot: click into cell for more info

Clicking “More options…” will give you up to three alternative values (and the sources from which these values come).

screenshot: more options for GoogleLookup

screenshot: more options for GoogleLookup

You can easily change the displayed value by selecting one of these alternatives.

As you can see on my Good Dance Songs spreadsheet, I used GoogleLookup to populate two more columns: album and year, both of which will be helpful to Caroline and her DJ (the functions, respectively: =GoogleLookup($A2, “album”), =GoogleLookup($A2, “year”)).

So next time your boss hands you a list of US states and asks you to fill in the capital of each state by EOD; or a list of years for which she would like the Academy Award winner for “Best Film”; or a 200 row list of NBA players, each of which needs a “height”… don’t fret, use GoogleLookup to quickly get the data you need.

May 15, 2009

Incredibly Strange Landscapes Created By Humans

No, this isn't Photoshopped - it's a real image, taken from a helicopter among the apartment buildings of mainland Hong Kong. Photographer Jason Hawkes captures bizarre human-made formations from the air - some unrecognizable.

This is in England, in a lot where cars and vans are stored before being shipped out to dealers. When Hawkes flew overhead, it just happened to be red SUV day.

What the hell is this? Balls? Trash? Grain? No. These are heaping piles of tomatoes dumped along a river in France.

May 14, 2009

Kill Frozen Programs in Windows With a Shortcut


If you're a Windows user, it pretty much goes without saying that you've encountered a frozen program before. Often these jammed apps get labeled with the dreaded "Not Responding" message and simply refuse to do anything, even close. Usually, the only solution is to open the task manager, find the appropriate process, and choose to close it. Fortunately, a quicker and easier way exists.

As the good people at Lifehacker have pointed out (with the aid of HaxAttack), you can create a desktop shortcut that will automatically close any "Not Responding" applications whenever you double-click the shortcut. Here's how to set it up -- it's really easy:

  1. Right click while on your desktop and select "create a new shortcut."
  2. Quotes included, enter the following as the location: taskkill.exe /f /fi "status eq not responding"
That's it. From here, you can change the icon to make it prettier, or even set a shortcut key if double-clicking is too much work for you. When you launch the shortcut, your computer will automatically identify and terminate any programs that the computer deems "Not Responding." This useful little trick works on Windows XP Pro (but not XP Home), all versions of Vista, and Windows 7, so give it a try and see if it doesn't make you feel like a hacker.



While You Sleep, Your Brain Keeps Working

You think when you go to sleep, you just, well, sleep?

Sleep, as it turns out, is far more complicated than we thought. And the brain not only doesn’t turn off, but appears to help keep itself healthy.

We’ve all heard of REM — rapid eye movement — discovered by the late physiologists Eugene Aserinsky and Nathaniel Kleitman at the University of Chicago in 1953. Scientific American has the story:

During REM sleep, our brain waves—the oscillating electromagnetic signals that result from large-scale brain activity—look similar to those produced while we are awake. And in subsequent decades, the late Mircea Steriade of Laval University in Quebec and other neuroscientists discovered that individual collections of neurons were independently firing in between these REM phases, during periods known as slow-wave sleep, when large populations of brain cells fire synchronously in a steady rhythm of one to four beats each second. So it became clear that the sleeping brain was not merely “resting,” either in REM sleep or in slow-wave sleep. Sleep was doing something different. Something active.

Discovering REM sleep was the first clue that sleep didn’t just help keep our bodies healthy, but our minds as well. And while many studies have been conducted on sleep since 1953, it’s only been in the last decade where we’ve begun to appreciate the complexity and importance of sleep for our minds. In 2000, researchers discovered that people that received more than 6 hours of sleep during an experiment helped improve their performance on tasks designed to tax the memory.

The key came in the discovery that participants didn’t just require REM sleep to improve their performance — they needed all that other sleep time too (what scientists call ’slow-wave’ sleep).

The long article also provides a nice description of our current understanding of how memory works:

To understand how that could be so, it helps to review a few memory basics. When we “encode” information in our brain, the newly minted memory is actually just beginning a long journey during which it will be stabilized, enhanced and qualitatively altered, until it bears only faint resemblance to its original form. Over the first few hours, a memory can become more stable, resistant to interference from competing memories. But over longer periods, the brain seems to decide what is important to remember and what is not—and a detailed memory evolves into something more like a story.

The researchers also discovered that sleep helps stabilize memories — sleep changes our memory, “making it robust and more resistant to interference in the coming day,” as the article notes.

But wait, sleep does more! It may not just stabilize our memories, it may actually help our brains process the memories, keeping the bits we need for long-term memories (especially the emotional components), and dropping the extraneous details that would clog our limited storage capacity:

Over just the past few years, a number of studies have demonstrated the sophistication of the memory processing that happens during slumber. In fact, it appears that as we sleep, the brain might even be dissecting our memories and retaining only the most salient details. [...] Instead of deteriorating, memories for the emotional objects actually seemed to improve by a few percent overnight, showing about a 15 percent improvement relative to the deteriorating backgrounds. After a few more nights, one could imagine that little but the emotional objects would be left. We know this culling happens over time with real-life events, but now it appears that sleep may play a crucial role in this evolution of emotional memories.

But wait, sleep does even more!

Even more recent research suggests that sleep helps our brain to process the information of the day and solve problems.

The upshot is that sleep is far, far more important than most of us realize and few of us appreciate. We miss it and think nothing of chopping off a few hours here or there. But the emerging research suggests that when we cut out sleep, we may be actually harming our formation of new memories for the recent past, and our ability to perform up to our usual standards. The researchers sum it up best:

As exciting findings such as these come in more and more rapidly, we are becoming sure of one thing: while we sleep, our brain is anything but inactive. It is now clear that sleep can consolidate memories by enhancing and stabilizing them and by finding patterns within studied material even when we do not know that patterns might be there. It is also obvious that skimping on sleep stymies these crucial cognitive processes: some aspects of memory consolidation only happen with more than six hours of sleep. Miss a night, and the day’s memories might be compromised—an unsettling thought in our fast-paced, sleep-deprived society.