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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|