Assignments based on coordinates

[lasonico]

I wish to assign a object (a) to a person (1 or 2 or 3) based on the following (see image)

1. The lat/long of the object must be equal (=) to or +/- 0.05 the lat/long of the person.
   
   
2. The Max/Min wait days for the object assigned to person (1 or 2 or 3) can between 27 to 34 days (excluding sundays)
   
   
3. The total and maximun objects to assign to a person is 5. When this condition is met then assign object to next available person who meets the criteria of number 1
   

Is there a way of doing this in excel, I would appreciate help with this formula, or VBA macro, google sheets

 

[Hui]

Lasonico

Firstly, Welcome to the Chandoo.org Forums

Can I please recommend that you upload a sample file and include an example of the output you require