Working with Dynamic Maps using Google Maps & Spreadsheets

This is a quick start guide to building & adding data to a Google Map created with GPS Visualizer.  Heres how to do it, quickly, with further info & details below.

1. Open the Distribution List spreadsheet in Google docs.
2. Open Google Maps in another window.
3. Size both so you can work easily with Copy <cmd>c and Paste <cmd>v between the windows
4. Copy <cmd>c the business name on the spreadsheet and Paste <cmd>v it into the search ield on the Google Map
5. Find the right business ( you may have to add in the city field to get the right item) and paste it into the Street field on the spreadsheet
6. Repeat steps 4 - 5 until you're done

---Easy Peasey---

Now for some other gory details, please refer to these previous posts;
creating-maps-with-gpsvisualizer
dynamic-linking-of-map-spreadsheet

For locations that DON'T resolve with GPS Visualizers  routine - You can hover over the location on Google maps and the latitude longitude values are displayed.  They can then be manually entered on the spreadsheet.
Google API key -  AIzaSyCOUBN9LPQ0lSMByTWE1JtmAAx35eo2CYs
Bing API key - (use this to geocode big lists)
Am9Z9PSFoZ6sRVh7x5H7SIAFGI1LTJxR7LU-qK4WaJo18DnYoGIk9ORF98_VLDRz
Mapquest API key -  MIUAvSGuQS27RAYgQX4KRrBAOiDKVOHH

Example of the dynamic link URL (note the gid at the end) - https://docs.google.com/spreadsheets/d/1yhmKwXDLn40oZTBzPOTja09V8z3x1kVwQNR1qI8Ie3U/view#gid=293688314

Rounded Rectangle Buttons in iOS 7 - Old school!

iOS 7 has moved away from realistic UI into this new world of flatness.   One element that doesn't work for me is the new UIButton which I guess is supposed to look like a link or something.  Ugh!
Here is a simple way to achieve the simple gray rounded rectangle of yester years.  Courtesy of tech tutorials and their great little YouTube tutorial



In the Identity Inspector add the 2 new Runtime attributes. 
Set background color & text in the Attributes Inspector.

Here's another good tutorial; http://ios-blog.co.uk/tutorials/user-defined-runtime-attributes/ 

Now for some geeky details;
These attributes (properties) are properties of CALayer