I am looking for a guru in MapPoint. I need the ability to open a GUI and enter or upload Lat/Longs manually or by uploading a .csv or .xls file. The icons need to automatically appear on the map. I also need to be able to enter some specific information (azimuth) into the GUI related to each Lat/Long where an image will appear on the map depicting a 'sector' and distance from that point on the map. Please contact me if this sounds like something you can assist me with. This is my first post on a forum of any kind, so be patient with me as I navigate through this process. Thanks, Brian.

This sounds straightforward, can you post some sample data?

The XLS File attached illustrates data I physically need to look at prior to determining the exact row I need to plot on the map. I need to be able to first articulate the azimuth of Sector 1, in order to properly map the other sectors.

Example, using the XLS attached:

Row 2 tells me the azimuth of sector 1 is 0. There are 6 ‘sides’ to this structure located at Lat/Long 33.95278, -118.19586. This also means that 0 is the center point of sector 1, meaning there is 30 degrees of ‘space’ on either side of the 0… which if drawn manually would look like the MapPoint map attached. This is information I must visually determine prior to plotting any of the other 5 sectors on a map. In this case, it is simple, as the first sector is true north, or 0 (zero).

There are times however, where sector 1 is not 0. For example if sector 1 were 65 degrees, then the other sectors, when plotted with an on-screen protractor, would not actually be the numbers (azimuths) listed in the XLS file. In other words, if sector 1 is 65, and sector 3 is listed as 80, then in order to plot sector 3 correctly, I would have to first find sector 1 at 65 and start my on-screen protractor at that point calling it, in theory, 0 degrees.. and then plot 80 degrees for sector 3. I’m not sure if I have explained this well, but it basically means I have to always determine the ‘zero’ of sector 1 before I can accurately plot the given azimuth of any other sector. In this scenario explained, the center of sector 3 would actually be (when using an on-screen protractor) 65+80 or 145 degrees from true north (0) even though the XLS file could indicate 80. In short, sector 1 will always determine the true visualization of the other sectors, when plotted.

If I were to upload an XLS file such as the one attached, I would need MapPoint to first look at the azimuth of sector 1 and use that information to accurately plot sector 3… as sector 1 is always the starting point that determines the true accuracy when visually plotting the other sectors.

When I upload a file such as this XLS file, I need to be able to choose the specific sector I want on the map. I also need to be able to tell it to go a specific distance from the Lat/Long (2 miles). I need to be able to select one of three colors (blue, red, or green). I need that color to be behind the roads as illustrated in the MapPoint file attached. I also would need the icon highlighted yellow (a feature of MapPoint).

On the map attached, there are also 2 other locations with no “azimuth” illustrated. I need to be able to plot azimuths on those locations as well, if desired. In other words, it is possible I may have 1 map, with multiple illustrations. I know this is a long winded scenario, and confusing. I apologize. I have never had to try and type this out before. I just know that when I have 100 of these maps to make, it is painfully time consuming. Any advice would be much appreciated.

This looks familiar ... like something we wrote for a government agency.
If you're still in the market for this, we can write a COM Addin or application for this.