So I'm attempting to do a VRP to calculate travel time using patients and clinics as ordered pairs. By this I mean I have an excel document where each row contains two pairs of coordinates: the coordinates of the location of the patient (origin) as well as the coordinates of the clinic (destination)
In Arcgis's tutorial for a very similar problem, they use geocoded addresses, which are located in a singular field in the excel table. However for my problem I have two fields for both the origin and destination; latitude and longitude. I've tried to fiddle around with the location analysis properties but I can't seem to figure it out. I know that my network dataset is functional because I've used it to solve an OD cost matrix.
Any tips would be greatly appreciated!