Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 15th 18, 11:45 PM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2018
Posts: 1
Default 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   Report Post  
Old 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
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Overlay shapes on a map image based on map coordinates ker_01 Excel Programming 3 September 11th 09 09:54 PM
How to determine the x & y coordinates based on angles for circle? Eric Excel Discussion (Misc queries) 4 August 5th 07 07:27 PM
Object coordinates benitAAvi Excel Programming 1 May 18th 05 07:50 PM
Converting MouseDown Coordinates to Chart Point Coordinates Steve[_50_] Excel Programming 3 December 2nd 03 06:48 PM
Cases/Set object to take coordinates of Print Range Bruce Roberson Excel Programming 6 July 28th 03 09:03 PM


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

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017