Archive for the ‘Uncategorized’ category

HOWTO collect photos from hundreds of contributors

August 24th, 2012

So you want to collect a few photos from several hundred people and organize them into a web album. You can't be sure that these people have Google accounts or Dropbox accounts. Never fear! Using a Picasa web album, you can do so quite easily. Your contributors don't need anything other than an email account to submit their photos. Here's how:

  1. Create a Picasa web album called "Testing emailed photos"
  2. Follow these instructions to enable uploading photos by email
  3. Email this link to the potential photo contributors. All they have to do is email the photos to the special email address you created within your Picasa settings in Step 2. As long as the subject line matches the name of your album "Testing emailed photos," the photos will be automatically added to the album.

Caveats: photos are limited to 20MB (total attachment size) and photos are automatically added to the album. This could be a problem if you don't know what kind of photos you will be receiving.

HOWTO: extract hyperlink contents in Excel for Mac

January 16th, 2011

You have a series of hyperlinks from which you want to extract the URLs. You want to keep the hyperlink display text as well.

  1. Copy the hyperlinks into a column in Excel (column A).
  2. Copy the hyperlinks into the adjacent column as well (column B).
  3. Select column B and right-click on the selected cells. Choose "Edit Hyperlink"
  4. In "Display" the value will be "multiple cells". Delete this text and save. Just the URLs will remain in column B.
  5. Select column A and right-click on the selected cells. Choose "Remove Hyperlink". Just the display text will remain in column A.

Home buying with Google maps

July 6th, 2009
Home Buying with Google Maps

Home Buying with Google Maps

We are looking to buy a home in London. Since we don't have a car, we are using the My Maps feature of Google Maps to visualize our geographic preferences. The circles (really complex polygons created using Scribble Maps, since Google Maps doesn't have a good way of creating circles) are roughly 9km in diameter. Once you create and position the circle in Scribble Maps, you can export it to a KML file and then import the KML to your My Map. The green circles are for city golf courses, the yellow one is for the train station and the purple one is for UWO. The red polygon is the riding of London West. We can add potential homes to the map to quickly see where they fall in relation to these preferences, and we have also mapped other useful things, such as grocery stores. Neat, eh?

Tip: when you use circles, the maps become too complex to display all at once. Use this tip about importing your map's KML file to create a map where the placemarks and polygons are shown all at once.

Six month retrospective

October 18th, 2008

No, this isn't a tracking poll for the Liberal Party's popularity, it's a graph of my handicap factor for the past six months. I'm glad that I've been able to lower my factor by 46 per cent, from 14.4 to 7.8. My improvement is largely due to an improved full swing and overall better power game. My wedge game and my putting have also improved, but not as much.

As the end of this golf season approaches, I am quite pleased with my swing, which feels as simple as it ever has. With better wedge play and better chipping, I could be shooting just over par. My goal for next year is to bring my factor as far as possible below 5.0.

I Am Not Afraid

June 9th, 2006

I'm not willing to let terrorists scare me too much. I Am Not Afraid.

richest 793 people: combined net worth of $2.6 trillion

March 10th, 2006

The rise of emerging markets and a host of new billionaires from third-world countries helped boost the ranks of the 10-figure club to a record 793, as 102 people managed to make the leap. The average net worth of the list's members is $3.3-billion (U.S.). Their combined wealth grew 18 per cent to $2.6-trillion, greater than the GDP of all but six countries in the world.

Guy Kawasaki on hockey

January 12th, 2006

My kind of Guy: a Mac and hockey lover

Templeton on instant messenger

September 20th, 2005

Brad Templeton's blog is good. It's mostly an ideas blog, and his post on the implications of IM on friendships is worth reading.

tune in to Cancer FM for Vatican Radio

May 9th, 2005

Electro-smog isn't good for you.

Coming soon

March 2nd, 2005

A post with some substance.