A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Company office moves



 
 
Thread Tools Display Modes
  #1  
Old June 11th, 2004, 08:37 PM
Frank Kabel
external usenet poster
 
Posts: n/a
Default Company office moves

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

--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
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?


  #2  
Old June 11th, 2004, 08:38 PM
Peo Sjoblom
external usenet poster
 
Posts: n/a
Default Company office moves

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

wrote in message
...
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?



  #3  
Old June 11th, 2004, 08:51 PM
Frank Kabel
external usenet poster
 
Posts: n/a
Default Company office moves

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
:-)


--
Regards
Frank Kabel
Frankfurt, Germany


Peo Sjoblom wrote:
For thing like this paper and pen is the best method.


wrote in message
...
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?


  #4  
Old June 11th, 2004, 10:17 PM
Peo Sjoblom
external usenet poster
 
Posts: n/a
Default Company office moves

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" wrote in message
...
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
:-)


--
Regards
Frank Kabel
Frankfurt, Germany


Peo Sjoblom wrote:
For thing like this paper and pen is the best method.


wrote in message
...
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?




  #5  
Old June 11th, 2004, 10:25 PM
Frank Kabel
external usenet poster
 
Posts: n/a
Default Company office moves

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

--
Regards
Frank Kabel
Frankfurt, Germany


Peo Sjoblom wrote:
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.


"Frank Kabel" wrote in message
...
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 :-)


--
Regards
Frank Kabel
Frankfurt, Germany


Peo Sjoblom wrote:
For thing like this paper and pen is the best method.


wrote in message
...
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?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.