...
Red Pipeline Time segment calculation:
| Pipeline N-1 | ||
| Pipeline N | Green | Red |
| Green | 0 | Green end time- Red end time |
| Red | 0 | 0 |
| if N-1 prior to Red is also Red then go till the last Red on the way | ||
Red Pipeline Time % = ∑Red Pipeline Time segment/Time overall
...