Page 1 of 1

Offer: Quickcheck of your depots / customer relations

Posted: Wed Dec 20, 2017 9:22 am
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 9322 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 9322 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.