1) tell me exactly what databases to use to download all of openstreetmaps of the US
• I will pay for an account
2) download OSM into the proper databases
3) for transportation trips with appointment times and unique pickup and dropoff addresses in GOOGLE SHEETS, use sceipt editor to calculate driving time and distance between pickup and dropoff
4) calculate pickup time to get to appointment time based on the calculated driving time - factor margin for error and add a specified amount of extra time for pickup time that increases based on distance (will be discussed)
5) calculate driving time and distance of each trips dropoff to the next pickup
●automatically dropoff from TRIP1 to pickup of TRIP 2, **EXCEPT when driver column is populated
FOR EXAMPLE if there is trip 1,2,3,4, and 5
and I manually assign driverA to trip 1 3 and 5
and I manually assign driverB to trips 2 and 4
instead of calculating dropoff of trip1 to pickup of trip2,
dropoff of trip1 to pickup of trip3 will be calculated, dropoff of trip3 to pickup of trip5 will be calculated,
dropoff of trip2 to pickup of trip4 will be calculated
so automatic layer of routing dropoff to pickup is the unassigned trips ordered by appointment time
but when drivers are assigned - the driver assignment is the first sorting layer
if a dropoff to a pickup will result in the appojntment being over 1 min late but less than 10 min late, highlight both rows orange
if a dropoff to the routed next pickuo will result in the appojntment being 10+ min late, highlight both trips red