Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 2 of 2

first time use - mp04 and excel

This is a discussion on first time use - mp04 and excel within the MapPoint Desktop Discussion forums, part of the Map Forums category; Ok - I got MapPoint at work to do a much better job mapping sales territories and data. I've discovered ...

  1. #1
    Clbe is offline Junior Member White Belt
    Join Date
    Sep 2004
    Posts
    1

    first time use - mp04 and excel

    Ok - I got MapPoint at work to do a much better job mapping sales territories and data. I've discovered that MapPoint is nothing more than a map-centric data server and that I have to program any smarts. Not a problem - just a surprise...

    I have my sales territories all mapped and saved to a file.

    I have a dealer base all mapped and saved to a seperate file.

    I have an excel report that shows MTD shipped, written, quota, and various performance metrics based on all of the above.

    I would like to start integrating all this.

    First - I want to use a pivot table to select a specific territory. Then ONLY that territory is shown. Within that territory, via the pivot table, I want to show SHIPPED or WRITTEN based on dealer (available from pivot by customer number and territory fields). As I get the hang of this, I'd like to bring more data sets like competitor dealer locators and the such.

    I've poked around here and there's some good information. What I *think* I need is a functional block of code that does what I describe with real good comments. I can then start hacking and tweaking that code to work for me. Right?

    Help?

    Clbe

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    I think there are several guys active in this board that would be eager to help. I've only had one client specifically ask for the code, but for all the custom projects I've delivered, all code is included, and I always offer extra "training" to explain the code..

    I'm kinda busy and to be honest I'm not 100% comfortable with the power of pivot tables.. (I just started poking around at the D functions in Excel recently --- I'm really an Access guy). However if someone doesn't take you up on the request, I promise not to charge you for any time I spend learning advanced Excel functionality. Send me a PM.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. GetMap time
    By sbedin in forum Bing Maps and MapPoint Web Service
    Replies: 1
    Last Post: 01-12-2005, 11:41 AM
  2. hiding drive time box
    By chaching in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 08-30-2004, 03:45 PM
  3. Problem using MP04 from Outlook 03
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 07-17-2004, 04:12 AM
  4. MPControl embedded in excel - excel loses functionality
    By ruyasan in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 05-20-2004, 04:41 AM
  5. Drive Time Addin
    By kez100 in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 03-04-2004, 08:29 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25