Transport scheduling macro

Hi People,

Can anybody help me write a transportation scheduling macro:

I have the following things with me:

1. Delivery list for the day which has items to be transported & the space they will occupy in the truck (% of total capacity of truck)
2. Total installation time of each product to be delivered (in minutes).
3. Distance chart for all the points (route is to be designed using nearest point principle,i.e., the next point of delivery will be which is nearest to the previous point of delivery)

Have been breaking my head on it whole of last week.

Sounds like this is a bit much for a volunteer to take on in their own time, i'm afraid.