MapForums

DCM · #1 (**permalink**) 12-12-2005

Hello all,

I am currently stuck trying to sort out how to sort data for a massive spreadsheet, and I am stuck. I have:

1. 160 employees across the USA
2. 11 Managers
3. 320+ Clinical Research projects

My boss wants me to import this into Map Point and show which of the 160 employees are working on which of the 320 plus Clinical Projects!

The main problem is that the clinical projects have a name and not a number, and when you add up all of the lines in Excel, there are over 14000 lines of data!

Is this a hard thing to figure out?

If someone can point me in the right direction, I would appreciate it greatly!

Thank you again

DCM

Dazzer · #2 (**permalink**) 12-13-2005

This is just an idea and I don't know how easy it would be for you to implement as i'm not sure how your data is formated but could you have a spreadsheet that looked something like

Emp Zip Code | Project ID
--------------------------------
ab123 | 1
bc345 | 2
de456 | 3

Then you could import this into mappoint set it to 'multiple symbol' and 'unique values' then for every zip code (row) in your spreadsheet you would have a pin thats color is based on the project ID.

The project ID would have to be a unique incrementing number, if you don't already have such an ID you could use MS Access to generate one and some queries to fill out the ID for the employees then export back out to excel. (please remember i'm in the UK and have no idea what US zip codes look like!

)

DCM · #3 (**permalink**) 12-15-2005

Hi Dazzer!

Thanks a million for the idea! It put into a new direction and so far it is working. I decided to use the pushpins to highlight each CRA and imported the excel data that is important to that persons manager. I have to input the data manually in each balloon, but it gets me through the day!

Thanks again

DCM

Dazzer · #4 (**permalink**) 12-16-2005

Glad I could help, I don't envy you have to enter all that data manually though, good luck.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mapping-Tools.com releases pre-computed US mileage charts	Winwaed	News and Announcements	1	11-14-2006 07:43 AM
Creating Mileage Charts	ekrupa	MapPoint 2006/2009 Discussion	2	11-30-2004 08:37 AM
Automatic Bar/Pie Charts (with Data from SQLServer)	webjagger	MapPoint 2006/2009 Discussion	3	05-27-2004 10:16 AM
How can I change charts size?	julior	MapPoint 2006/2009 Discussion	0	03-12-2004 04:22 AM
Sized Pie Charts - Legend Query	stephen kilbee	MapPoint 2006/2009 Discussion	0	01-15-2004 12:20 PM

MapForums

Help Please!!! With Mapping information to pie charts

Help Please!!! With Mapping information to pie charts

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads