MapForums

Hi All,

Stumbled across this site whilst researching for a project I'm doing.

I'm looking at design, optimisation and simulation of large supply chains (1400+ product lines from 120+ locations supplied daily).

I have a little bit of VBA experience (A level ICT at college, but a few years ago now!) and would like to do most of my calcs etc. in excel for ease of use.

If anyone has any pointers on where to start with the route planning side of things; I'd be most grateful. I'm struggling to get started with the actual calcs. So far all I really have is a (slowly populating as I type) mileage chart.

Cheers for reading!

O

Welcome to the board!

Regarding Excel, MapPoint, and supply chain optimization, take a look at this recent article on MP2K Magazine --

Routene Excel and MapPoint Update - MapPoint Articles - MP2K Magazine

I think you will find some useful stuff..

Also, to get started, take a look at the MapPoint / Excel examples at
Working With Excel and MapPoint - MP2K Magazine

Eric

__________________