Remember Me?

#1
July 15th 18, 11:45 PM
 Junior Member First recorded activity by ExcelBanter: Jul 2018 Posts: 1
Object Assignments based on coordinates

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
Attached Images

#2
July 16th 18, 04:35 AM posted to microsoft.public.excel.misc,microsoft.public.excel
 external usenet poster First recorded activity by ExcelBanter: Jan 2017 Posts: 11
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 |
+-------------------------------------------------------------------+

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post ker_01 Excel Programming 3 September 11th 09 09:54 PM Eric Excel Discussion (Misc queries) 4 August 5th 07 07:27 PM benitAAvi Excel Programming 1 May 18th 05 07:50 PM Steve[_50_] Excel Programming 3 December 2nd 03 06:48 PM Bruce Roberson Excel Programming 6 July 28th 03 09:03 PM

All times are GMT +1. The time now is 11:25 PM.