Automatic scheduling in excel
- Thread starter SAN04
- Start date
Hello all,
I want to schedule dates automatically for installation of item 1 and item 2.
Installation dates of item 1 will be based on the selection of batch (1,2,3, etc) and start date of 01 Jan 2019; Also installation dates of item 1 drives dates of the installation of item 2. (Item 1 and 2 will be installed on well A, B, C, D, E & F)
I have shown through an example (in the attached sheet) the dates for the installation of item 1 (with a batch size of "2") for reference.
But I want to update dates in the blank table in my sheet using the highlighted yellow cell where I will punch batch size of item 1 viz. 1 , 2 , 3 , 4 , 5, 6) and requirement is that installation dates should be automatically update based on the batch size for both item 1 and 2 for Well A, B, C, D, E&F.
Please help!
Installation durations are in the attached sheet
(Sheet attached again)
I want to schedule dates automatically for installation of item 1 and item 2.
Installation dates of item 1 will be based on the selection of batch (1,2,3, etc) and start date of 01 Jan 2019; Also installation dates of item 1 drives dates of the installation of item 2. (Item 1 and 2 will be installed on well A, B, C, D, E & F)
I have shown through an example (in the attached sheet) the dates for the installation of item 1 (with a batch size of "2") for reference.
But I want to update dates in the blank table in my sheet using the highlighted yellow cell where I will punch batch size of item 1 viz. 1 , 2 , 3 , 4 , 5, 6) and requirement is that installation dates should be automatically update based on the batch size for both item 1 and 2 for Well A, B, C, D, E&F.
Please help!
Installation durations are in the attached sheet
(Sheet attached again)
Cross posted https://www.excelforum.com/excel-general/1288539-scheduling-in-excel.html#post5187238
As I suggested to you in a PM it would be a good idea for you to read the rules
As I suggested to you in a PM it would be a good idea for you to read the rules
Site Rules - New Users - Please Read
Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
Marc L
Excel Ninja
If you have ever read the rules you did not forget what every forum expects in initial post !
So your must read this !
AndiLovesExcel
New Member
Hello San,
your most recent example file is still faulty, but I think I grasp the essence of what you aim to do. However it's been hard to understand.
The more effort you spend in preparing your question and example in an easy to understand way, higher the chances you'll receive helpful replies.
There seems to be something wrong regarding durations which you might need to correct. I've assumed the following:
Finish date= Start Date + duration of days - 1
That means: Start 2019-01-01 -> Finish 2019-01-01 (morning until evening)
Start date = last Finish Date + 1 (next morning)
Thus Finish Date formulae are very basic and Start Date are the tricky ones.
I've colour coded the unique formula cells. Those are then copied down.
Not that Offset is a volatile function and if you should run into performance issues, you should exchange that for say INDEX + MATCH (google for many explanations of this common usecase).
Regards
your most recent example file is still faulty, but I think I grasp the essence of what you aim to do. However it's been hard to understand.
The more effort you spend in preparing your question and example in an easy to understand way, higher the chances you'll receive helpful replies.
There seems to be something wrong regarding durations which you might need to correct. I've assumed the following:
Finish date= Start Date + duration of days - 1
That means: Start 2019-01-01 -> Finish 2019-01-01 (morning until evening)
Start date = last Finish Date + 1 (next morning)
Thus Finish Date formulae are very basic and Start Date are the tricky ones.
I've colour coded the unique formula cells. Those are then copied down.
Not that Offset is a volatile function and if you should run into performance issues, you should exchange that for say INDEX + MATCH (google for many explanations of this common usecase).
Regards