How to figure out the most efficient route (optimization) based on latlong(s).

[Tiger1]

I have a table that changes daily.  The list will get new items and delete old ones.  In the list I have [latlong] PER item.  I am wanting an expression that could help calculate the most efficient driving route based on today() list.  Is this possible?  If so, how?

[WillowMobileSys]

---

@Tiger1 wrote:

I am wanting an expression that could help calculate the most efficient driving route based on today() list.  Is this possible?  If so, how?

---

There are entire services devoted to exactly this problem.  It is not an easy solution as there are many factors that COULD complication the algorithm.  You may be able to simplify this making certain assumptions.

I recommend searching for "route optimization algorithm" or possibly look into integrating with an existing service.

Good luck!  I hope this helps!

[Tiger1]

Thank for your help.  I will search this more...