Company office moves

[Guest]

I have a list of 400 people that will be moving offices.
Some of the offices are currently occupied and they will
have to be moved before the new person is moved into it.

I have an excel spreadsheet giving old/new office
locations. I would like to come up with a way for excel
to tell me in what order to move each office so that we do
not try and move a person into and office that has not yet
been emptied. Any such animal?

 

[Frank Kabel]

Hi
no solution but try searching Google for dedicated applications for
this. This is not a simple question as there're probably several valid
solutions and Excel (or any other application) has to check them

 

[Peo Sjoblom]

For thing like this paper and pen is the best method.

--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Frank Kabel]

Hi Peo
slightly disagree (depending on the number of employees / offices).
There're some really good solutions for this kind of facility
management.

So for 400 people I would assume using something like an inventory
software in combination with such planning tools could be quite useful

 

[Peo Sjoblom]

Frank,

I didn't mean software developed for similar situations, just compared to
excel..
There are definitely things I would use paper and pen for compared to trying
to
use excel for the same things.

--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Frank Kabel]

Hi Peo
o.k. now i fully agree with you
In this case I also would use pencil and paer instead of developing
sophisticated macros to do a kind of 'linear optimisation'. Probably
you have relocated your staff before you have finished these coding
<vbg>