Production Plan - Start From Specific Date Only

Hi,

I have a production plan for 4 types of columns.
The total number of columns required and the max no of columns that can be produced daily for each type are given.

With some help,I have prepared a production plan which distributes the columns on a daily basis,but I am not able to control the start date of production.


I would like to modify the production plan to have a constraint ( a specific start date) for each column type so that the distribution for that particular column type starts from only that day.


I have attached the sample file.




Thanks in advance.

Hi
Try to use in B8, and drag right and down, this formula

Formula:

Please Login or Register  to view this content.

Rectified myself!!

Thanks!!

I use
1) --MID to convert the string "Day1" to value 1 or "Day2" to value 2, ...
2) INDEX to get 'Start Day' in D2:D5 in row that MATCH each value A8:A11 in A2:A5
3) IF Day in B6 is greater or equal to 'Start Day' then cell is filled else do nothing.

Why use -- in front of MID?

Also 999 in the formula

Use this formula in B8 of given sample

Please Login or Register  to view this content.

Now write this to C8 of Given sample

Please Login or Register  to view this content.

Now copy C8 formulas to Right as many as you need. Then copy them down. That's it.

Hi
-- is to convert a string to a value --"1" is 1
999 is the max number of chars that follow the string "Day". The sintaxe for MID is MID(String,Start,Num_Chars)

Thanks!!!

For the other solution!!