Minimize Transportation Costs Using Mapping

Let’s say your transportation costs are too high. With Mapline, you can easily optimize your transportation costs by identifying the closest distribution center to your retail stores.

Just take your Excel spreadsheet with the list of your store locations and the list of all the distribution centers. You want to find the distribution center that has the shortest distance to each store location. So, once these are pasted into Mapline, just select the Distance Calculations option. Now you need to pick the two data sets that represent the distribution centers and the stores. Once you hit download you will get a spreadsheet that shows the distances between each store and each distribution center.

Now, using Excel, you can easily run a minimum formula to find which distribution center is closest to each of your stores.

And that’s how easy it is to minimize transportation costs using Mapline! Sign up to try it out yourself.

Continue Reading

Streamline Operations with Mapping

Mapline makes it simple for you to streamline operations by identifying backup supply options.

Let’s say that you own some gas stations, and there are occasionally supply outages from your fuel supplier. You want to find some backup supply options so that your operations aren’t affected.

This is simple to do with mapping. Just plot your gas stations and suppliers in Mapline. This can be added with a simple paste from your Excel spreadsheet.

Once the gas stations and suppliers are on your map, just go to the Distance Calculations option and select these two data sets. Once you hit download you’ll get a spreadsheet showing the gas stations along the left rows and the suppliers along the top columns. Where the Row and Column intersects is the distance between the two points.

Now that you have a huge distance grid spreadsheet, you can easily run a =SMALL() formula in Excel to identify the first, second, and third closest supply locations to evaluate your options!

And that’s how you can streamline operations using Mapline! Sign up to start streamlining your operations with mapping.

Continue Reading

Leverage Sales Territory Mapping for Your Business

Visualize Your Territories with Territory Mapping Software

Well-defined sales territories directly impact sales results. But how do you take the data you have and visualize it, so you can view your current sales territories and identify new opportunities? This is where Mapline’s quick and easy sales territory mapping feature can help.

 

Territory Mapping with Mapline’s Drawing Pad

Let’s say your business has grown to the point where you need to restructure your sales territories so they can be more effective. There are two ways to build sales territories, and they are both super simple. The first way is to leverage the drawing pad to draw territories on your map. This is easy if there aren’t too many territories and you aren’t looking for perfection.

Create Sales Territory with Overlays

The other way to build sales territories is by mapping territory overlays. This method is best if your sales territories consist of groupings of zip code, county, or state boundaries, and you’d like to color each territory (such as zip code or county) according to the sales territory it belongs to. Let’s assume you’d like to do this with zip codes.

Steps for Sales Territory Mapping

  1. Go to your Excel spreadsheet and make the first column header “Territory.”
  2. Below that, enter all the zip codes you have.
  3. Make the second column header “Color.”
  4. Next to each zip code, enter the color you would like it to appear on the map. (Perhaps you want Clark’s zip codes to be “Blue” and Peter’s zip codes to be “Green” and so on.)
  5. Then, just paste those two columns into Mapline and you’re done!

That’s how easy it is to build sales territories with mapping. There’s so much more you can do with Mapline! Check out all of our features to make sure you’re getting the most out of your account.

Continue Reading

How to Draw Shapes on Your Territory Maps

Customize Your Territories for Your Specific Needs

If you have territories that are unique to your company and don’t quite match up to existing shapes, you can plot shapes on a map to meet your individual needs. With Mapline’s Draw Pad feature, you can quickly draw custom territories and shapes on your map. Once shapes are created, you can get a list of locations inside the shape and export them for deeper analysis.

Steps to Draw Custom Shapes in Your Territory Map

To plot shapes on your map:

  1. For circles and squares, just click on the map to create the shape where you want.
  2. For polygons and other custom shapes, click on the Draw Polygon button.
  3. Click to begin drawing your shape around the pins on your map.
  4. Click around all the pins you want to include to make the shape bigger.
  5. Click on the first pin you’ve drawn to close the shape.
  6. To include pins outside of your shape, click on the Edit button.
  7. Hit Save when you finish creating the shape.
  8. To change the color of the shape, click on the Paint Bucket.
  9. Click on the Fill Color and choose the color you want from the color spectrum that appears.
  10. To get more information about the pins within your shape, click within the shape.
  11. After clicking, you’ll see square mileage of your shape and a summary of all the data points inside the shape.
  12. Download the summary and location reports to use for further analysis.

Continue Reading

Using Radial Heat Maps

Visualizing Your Data with a Geographic Radial Heat Map

Radial heat maps look like weather radar and show color coded concentrations of your data. With radial mapping software options you’re not only able to visualize your data on a map but you can also easily and immediately understand where the majority of your activity is located.

By presenting more densely populated areas in one color and sparser locations in another from the gradient, Mapline makes analysis of your data simple, whether you’re mapping customers, sales or other calculations from your spreadsheet. You can view heat map overlays with your data pins and you’re also able to hide the pins for a clearer picture.

Steps to overlay a radial style heat maps

  1. Open your map.
  2. Click the drop down menu next to your dataset.
  3. Select “Heat Map.”
  4. Select whether you would like to apply the heat the area around the pins or the overlapping radius areas.
  5. Define the radius (miles or kilometers).
  6. Select whether you would like the heat map to be based on location density or the sum or average of your data.
  7. Click on the “Styling” tab to set the opacity and blur. You can also remove the legend and fade the edges of the heat map.
  8. Click “OK.”

If you want to hide the map pins so you only see the heat map, here’s what you can do:

  1. Click the pin icon on the left sidebar.
  2. Click the “Remove” button.



Ready to use our radial mapping software? Check out our plans and pricing to find the right option for you.

Continue Reading