Asfaar Burhaniyah 2.0

Asfaar Mubaraka of al Dai al Fatemi Syedna Mohammad Burhanuddin (tus) across the globe since 1424. (previous asfaar shall be added too insha allah as soon as possible.)The Placemark centered is the Current Location of His Holiness Dr. Syedna Mohammad Burhanuddin (TUS). comments are welcome.

Thursday, June 26, 2008

Map it in your Spreadsheet - Google Map Gadget

The situation: My good friend Tomashi is visiting New York, and I want to map out a few places for her to visit near my work before we meet for the evening.

What do I do? I use the spreadsheets map gadget, which easily adds a Google map pinpointing all the addresses I've entered.

Here's how:

  1. I choose some places in the neighborhood that I think Tomashi would like visiting, and add their addresses along the first column of my spreadsheet.
  2. In the next column, I enter the name of each place, and a short description.
  3. I highlight all of the cells that contain information I'd like included in the map.
  4. Along the top of the toolbar, I click, "Insert Gadget." In the menu that appears I select "Maps" from the list on the left, and choose, simply, the "Map" gadget.
  5. Finally, I give the map a title, check the box next to "Last column as tooltip" and, as is my preference, choose to allow zoom using mouse wheel. When all's done, I click "Apply and close."
Here's the published map (which can be embedded in any HTML page, if you'd like):

And, here's a link to the full spreadsheet, showing the guide that I'll share with Tomashi when she visits.

Of course, this is great for a lot of other things, apart from visiting friends. These include:
  • House hunting (enter the addresses in one column, and any corresponding numbers, or information in the next)
  • Road trip planning
  • Charting restaurants, shops, or other places you'd like to visit
  • Anything else where a map could flesh out a list of addresses :)

Where Am I