ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Object Assignments based on coordinates (https://www.excelbanter.com/excel-discussion-misc-queries/454122-object-assignments-based-coordinates.html)

lasonico

Object Assignments based on coordinates
 
1 Attachment(s)
I wish to assign a object (a) 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

Wally W.

Object Assignments based on coordinates
 
On Sun, 15 Jul 2018 23:45:31 +0100, lasonico wrote:


I wish to assign a object (a) 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


+-------------------------------------------------------------------+
|Filename: Excel .jpg |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=1057|
+-------------------------------------------------------------------+



If you *must* post to more than one group, please cross-post.

Multi-posting is bad.



All times are GMT +1. The time now is 01:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com