Timeline Start date forward

[Carrie]

I am really stuck on the function statement in column four. I realize it is
not correct as it is written but I simply cannot figure out a way to write it
correctly. Can anyone help?

To explain the table below it is a time line of repairs and stocking levels
needed to have on hand during repairs.

The first column lists days 1 - 720 [labeled Day]

The second column [labeled Failure] has a formula of
"=IF(A8/$B$1=ROUND(A8/$B$1,0),1,0)" which works fine to calculate how many
days between an expected repair

The third column [labeled RI] with a formula of
"=IF($A8/($B$1+$B$4)=ROUND($A8/($B$1+$B$4),0),1,0)" also works fine, same
formula as the second column with some added days

The fourth column [labeled RC] is where I am stuck. the formula currently in
the cell not working correctly is
"=IF($A8<$B$2+$B$7,0,IF($A8=$B$2+$B$7,1,IF($A8/$B$2=ROUND($A8/$B$2,0),1,0)))"
It is the last portion of the formula not working correctly. In this case I
need to have a starting point..such as day 11....and then input a "1" in a
cell for every "7" days after day 11.

The fifth column [labeled OH] has the formula "=$B$6-C8+D8" simple works
fine just gives me the expected on hand quantities of inventory during a
repair cycle.

(Cell B1) Failure 5
(Cell B2) Repair Time 7
(Cell B3) Total Time 9
(Cell B4) Ship Time1 2
(Cell B5) Ship Time2 1
(Cell B6) Start In-stock Qty 4
(Cell B7) Start Repair 4


Day Failure RI RC OH
1 0 0 0 4
2 0 0 0 4
3 0 0 0 4
4 0 0 0 4
5 1 0 0 4
6 0 0 0 4
7 0 1 0 3
8 0 0 0 3
9 0 0 0 3
10 1 0 0 3
11 0 0 1 4
12 0 0 0 4
13 0 0 0 4
14 0 1 1 4
15 1 0 0 4
16 0 0 0 4

 

[Sandy Mann]

I don't understand what you are saying:

The first column lists days 1 - 720 [labeled Day]

Presumably Column A?

The second column [labeled Failure] has a formula of
"=IF(A8/$B$1=ROUND(A8/$B$1,0),1,0)"

Presumably Column B? But you are referencing B1 so it can't be Column B

If you want you can send me a copy of your spreadsheet. Change my e-mail
address as it says in the signature

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

I am really stuck on the function statement in column four. I realize it is
not correct as it is written but I simply cannot figure out a way to write
it
correctly. Can anyone help?

To explain the table below it is a time line of repairs and stocking
levels
needed to have on hand during repairs.

The first column lists days 1 - 720 [labeled Day]

The second column [labeled Failure] has a formula of
"=IF(A8/$B$1=ROUND(A8/$B$1,0),1,0)" which works fine to calculate how many
days between an expected repair

The third column [labeled RI] with a formula of
"=IF($A8/($B$1+$B$4)=ROUND($A8/($B$1+$B$4),0),1,0)" also works fine, same
formula as the second column with some added days

The fourth column [labeled RC] is where I am stuck. the formula currently
in
the cell not working correctly is
"=IF($A8<$B$2+$B$7,0,IF($A8=$B$2+$B$7,1,IF($A8/$B$2=ROUND($A8/$B$2,0),1,0)))"
It is the last portion of the formula not working correctly. In this case
I
need to have a starting point..such as day 11....and then input a "1" in a
cell for every "7" days after day 11.

The fifth column [labeled OH] has the formula "=$B$6-C8+D8" simple works
fine just gives me the expected on hand quantities of inventory during a
repair cycle.

(Cell B1) Failure 5
(Cell B2) Repair Time 7
(Cell B3) Total Time 9
(Cell B4) Ship Time1 2
(Cell B5) Ship Time2 1
(Cell B6) Start In-stock Qty 4
(Cell B7) Start Repair 4


Day Failure RI RC OH
1 0 0 0 4
2 0 0 0 4
3 0 0 0 4
4 0 0 0 4
5 1 0 0 4
6 0 0 0 4
7 0 1 0 3
8 0 0 0 3
9 0 0 0 3
10 1 0 0 3
11 0 0 1 4
12 0 0 0 4
13 0 0 0 4
14 0 1 1 4
15 1 0 0 4
16 0 0 0 4