Challenge #26: Service Technician Travel Distance

[Inactive User]

Spoiler

Used a multi-row formula to rename sites as Hotel_Start,Hotel_End or Worksite. Cross-tabbed data and calculated distances. Summed them up and selected required columns.

[rcor]

Spoiler

[leona0409]

This was a great exercise to learn about spatial objects!

[MartinStraech]

Starting to feel a bit more comfortable with the Multi Row Formula tool. And felt like a more elegant solution than the last challenge I did.

Spoiler

[ocasey]

Here is my solution.

[fmeo]

Spoiler

[JoeS]

Nice and straight forward.

Spoiler

Tile tool to collect together by date, Crosstab columns round, formula tool to calculate and sum the distances.

[bnelly1987]

Both Solutions founds. Each using a different method.

Spoiler

[Tom_Pilgrem]

Nice and simple once I figured out to add the order before transposing! 

Spoiler