Jeffrey McManus

11 Comments so far

1. gina on November 3rd, 2005

   Jeffrey, This is a great tool for those of us lacking technical savvy or programming skills to create maps of our particular data. I’ve passed your url along to some folks who were desperately seeking a simple way to take their Excel documents and create a map. This is a nice start for us. BTW - since you mentioned the bug fix for Canada, does this mean that your tool is geared only toward the US and Canada addresses? Just wondering. Thanks!

2. Mike on November 11th, 2005

   Jeffrey, this is great! I was out tonight looking for some over the counter software that would do just this very thing, no luck. One question, When using this template does it prevent printing? It seems as though printing has been disabled? Thanks.

3. Jeffrey Mcmanus on November 11th, 2005

   Thanks Mike, glad you like it. Printing isn’t an option using the template unless you save off the XML data it generates and post it to a Web site, similar to what you see here: http://api.maps.yahoo.com/Maps/V1/annotatedMaps?appid=jeffreymcmanus&xmlsrc=http://mcmanus.typepad.com/sandiegotrolley.xml

4. Matt on November 17th, 2005

   Jeffrey, I’m having trouble with this. When I click on the button saying “Send to Yahoo! Maps” I get an error message at the YMaps page saying “We need a city, state; city, state, zip; or a zip to generate a map.”

   I’m using Excel 2003 and Firefox 1.0.7

   Thanks! (I’ve been looking for a tool like this forever.)

5. Andrew on November 17th, 2005

   Same problem with IE6 - and just when I needed it for a project.

   Hope you get it fixed soon

6. Jeffrey McManus on November 18th, 2005

   Sorry about that guys, they changed something on the server side and I needed to futz with the template to accomodate it.

   I just posted a new version that fixes the problem, get it from http://www.well.com/user/jeffreyp/mapmaker/

7. Matt on November 30th, 2005

   Cool, thanks! Any plans on making it capable of plotting more than 100 data points? That would be rad.

8. Jeffrey McManus on November 30th, 2005

   The 100-point limit is a limitation of the maps back-end, not the spreadsheet, unfortunately.

9. Victoria on February 5th, 2008

   I have Excel 2007 which does not have a Menu bar that has Tools on it for this template. Do you have any suggestions? Work around?

10. Jeffrey McManus on February 5th, 2008

    Sorry, Victoria, I haven’t upgraded to Excel 2007 yet so I haven’t had a chance to test this tool with it. It should work though, it’s probably just a matter of finding the appropriate command in Excel 2007’s confounded new menu structure.

11. Nick on November 7th, 2008

    Jeffrey,

    What a fantastic app! Has anyone figured out how to use this in excel 2007? I can think of a dozen ways to use this!

    Thanks,
    Nick

Leave a comment