Timeline Start date forward
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 |
All times are GMT +1. The time now is 01:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com