Object Assignments based on coordinates

lasonico · Jul 15, 2018

Object	Last day person had the object	lat	long	Min wait days	Max wait days	Person	Lat	Long	Object assigned to person?
a	27	17.33333	-20.77777	27	34	1	17.77777	-20.33333
b	28	17.44444	-20.66666	27	34	2	18.22221	-19.88889
c	28	17.55555	-20.55555	27	34	3	18.55554	-19.55556
d	30	17.66666	-20.44444	27	34
e	32	17.77777	-20.33333	27	34
f	33	17.88888	-20.22222	27	34
g	34	17.99999	-20.11111	27	34
h	27	18.1111	-20	27	34
i	28	18.22221	-19.88889	27	34
j	28	18.33332	-19.77778	27	34
k	30	18.44443	-19.66667	27	34
l	32	18.55554	-19.55556	27	34
m	33	18.66665	-19.44445	27	34
n	34	18.77776	-19.33334	27	34
o	28	18.88887	-19.22223	27	34

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

The lat/long of the object must be equal (=) to or between +/- 0.05 the lat/long of the person.

The Max/Min wait days for the object to be assigned to person (1 or 2 or 3) can between 27 to 34 days (excluding sundays)

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

Object Assignments based on coordinates

lasonico

New member

Attachments