Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forward & Backwards Quarters from an Entered Date | Excel Worksheet Functions | |||
Date going forward | Excel Worksheet Functions | |||
Auto calculate for date + days forward to yield new date | Excel Worksheet Functions | |||
how do I do a Planned vs Actual start date & end date graph | Charts and Charting in Excel | |||
Timeline with critical date markers | Charts and Charting in Excel |