Offer: Quickcheck of your depots / customer relations

Deals with clustering based on locations but also on time regularity.
Post Reply
User avatar
Bernd Welter
Site Admin
Posts: 2564
Joined: Mon Apr 14, 2014 10:28 am
Contact:

Offer: Quickcheck of your depots / customer relations

Post by Bernd Welter »

HI there,

I developed a testclient that enables me to use xTerritory 1 to calculate some simple usecase scenarios. For those of you who are interested I can offer to demonstrate the capabilities in a 1:1 websession. Just provide some sample data with the following structure:
File 1: locations (of your customers)
For the locations I need at least the ID and x/y coordinates. Further properties such as activity are optional.<br />3:CZ-120 00 Praha;1604886,1226;6452761,1803;25;;;false;<br />9568:CZ-252 63 Roztoky;1600336,295;6466968,5704;1;;;false;<br />12579:CZ-253 01 Hostivice;1585287,2349;6453112,277;1;;;false;<br />13720:CZ-252 42 Jesenice;1613995,3971;6433441,2461;10;;;false;<br />15543:CZ-252 28 Cernosice;1592520,7876;6431964,7164;1;;;false;<br />17250:CZ-250 70 Odolena Voda;1602452,4939;6479569,573;25;;;false;<br />18721:CZ-251 01 Ricany;1629823,6031;6437668,8344;1;;;false;<br />.....
For the locations I need at least the ID and x/y coordinates. Further properties such as activity are optional.
3:CZ-120 00 Praha;1604886,1226;6452761,1803;25;;;false;
9568:CZ-252 63 Roztoky;1600336,295;6466968,5704;1;;;false;
12579:CZ-253 01 Hostivice;1585287,2349;6453112,277;1;;;false;
13720:CZ-252 42 Jesenice;1613995,3971;6433441,2461;10;;;false;
15543:CZ-252 28 Cernosice;1592520,7876;6431964,7164;1;;;false;
17250:CZ-250 70 Odolena Voda;1602452,4939;6479569,573;25;;;false;
18721:CZ-251 01 Ricany;1629823,6031;6437668,8344;1;;;false;
.....
locations.png (5.7 KiB) Viewed 8455 times
locations.map.png
File 2: territories (your own depots, sales offices, ...)
Same as above: the ID, x/y coordinates are mandatory (and should be using the same coordinate format as the locations).<br />120 00 Praha;1604886;6452761;<br />301 00 Plzen;1488004;6395330;<br />602 00 Brno;1846243;6301342;<br />779 00 Olomouc;1918011;6368844;<br />702 00 Ostrava;2033589;6411302;<br />... and so on
Same as above: the ID, x/y coordinates are mandatory (and should be using the same coordinate format as the locations).
120 00 Praha;1604886;6452761;
301 00 Plzen;1488004;6395330;
602 00 Brno;1846243;6301342;
779 00 Olomouc;1918011;6368844;
702 00 Ostrava;2033589;6411302;
... and so on
territories.png (3.11 KiB) Viewed 8455 times
territories.map.png
Alltogether I can compute the optimal assignment of territories with the goal of geographic compactness
Compact territories
Compact territories
and balanced activity
The aggregated sum of activity in each territory is almost on the same level
The aggregated sum of activity in each territory is almost on the same level
Let me know if you are interested in such a quick check,
Best regards,
Bernd

PS: The tool itself isn't public.
Bernd Welter
Technical Partner Manager Developer Components
PTV Logistics - Germany

Bernd at... The Forum,LinkedIn, Youtube, StackOverflow
I like the smell of PTV Developer in the morning... :twisted:
Post Reply