Spreadsheet: 271687d1382021935-setting-a-value-based-on-a-range-with-multiple-possible-outcomes-sample_sheet
Sheet: Table A

 |  |  | H12345
 | Process Steps |  |  |  |  |  |  | Status | Equipment ID
A1 |  |  | 2013-11-06 08:00:00 |  |  | 0 |  | In progress
A2 |  |  | 2013-11-06 08:30:00 |  |  | 0 |  | Not Started
A3 |  |  | 2013-11-08 08:00:00 |  |  | 0 |  | Not Started
A4 |  |  | 2013-11-08 08:00:00 |  |  | 0 |  | Not Started
A5 |  |  |  |  |  | 0 |  | Not Started
A6 |  |  |  |  |  | 0 |  | Not Started
A7 |  |  | 2013-11-08 08:00:00 |  |  | -10 |  | Not Started
A8 |  |  | 2013-11-08 08:00:00 |  |  | 20 |  | Not Started
A9 |  |  |  |  |  | -100 |  | Not Started
A10 |  |  | 2013-11-07 20:00:00 |  |  | 0 |  | Not Started
A11 |  |  |  |  |  | 0 |  | Not Started
A12 |  |  | 2013-11-08 20:00:00 |  |  | 0 |  | Not Started | N/A
A13 |  |  | 2013-11-08 20:00:00 |  |  | 0 |  | Not Started
A14 |  |  |  |  |  | 0 |  | Not Started | N/A
A15 |  |  | 2013-11-07 20:00:00 |  |  | 0 |  | Not Started
C1 |  |  |  |  |  | 0 |  | Not Started
B1 |  |  |  |  |  | 0 |  | Not Started | N/A
B2 |  |  |  |  |  | 0 |  | Not Started | N/A
B3 |  |  |  |  |  | 0 |  | Not Started | N/A
B4 |  |  |  |  |  | 0 |  | Not Started | N/A
B5 |  |  |  |  |  | 0 |  | Not Started | N/A
B6 |  |  |  |  |  | 0 |  | Not Started | N/A
B7 |  |  |  |  |  | 0 |  | Not Started | N/A
B8 |  |  |  |  |  | 0 |  | Not Started | N/A
B9 |  |  |  |  |  | 0 |  | Not Started
B10 |  |  |  |  |  | 0 |  | Not Started | N/A
B11 |  |  |  |  |  | 0 |  | Not Started | N/A
B12 |  |  |  |  |  | 0 |  | Not Started | N/A
B13 |  |  |  |  |  | 0 |  | Not Started | N/A
B14 |  |  |  |  |  | 0 |  | Not Started | N/A
B15 |  |  |  |  |  | 0 |  | Not Started | N/A
B16 |  |  |  |  |  | 0 |  | Not Started | N/A
B17 |  |  |  |  |  | 0 |  | Not Started | N/A
B18 |  |  |  |  |  | 0 |  | Not Started | N/A
B19 |  |  |  |  |  | 0 |  | Not Started | N/A
[NAME] |  |  |  |  |  | 0 |  | Not Started | N/A
C2 |  |  |  |  |  | 0 |  | Not Started
[NAME] |  |  |  |  |  | 0 |  | Not Started
C4 |  |  |  |  |  | 0 |  | Not Started
C5 |  |  |  |  |  | 0 |  | Not Started
C6 |  |  |  |  |  | 0 |  | Not Started
C7 |  |  |  |  |  | 0 |  | Not Started
C8 |  |  |  |  |  | 0 |  | Not Started
C9 |  |  |  |  |  | 0 |  | Not Started
A16 |  |  |  |  |  | 0 |  | Not Started
A17 |  |  |  |  |  | 0 |  | Not Started | N/A
A18 |  |  |  |  |  | 0 |  | Not Started
B21 |  |  |  |  |  | 0 |  | Not Started
B22 |  |  |  |  |  | 0 |  | Not Started | N/A
B23 |  |  |  |  |  | 0 |  | Not Started | N/A
B24 |  |  |  |  |  | 0 |  | Not Started | N/A
B25 |  |  |  |  |  | 0 |  | Not Started | N/A
C10 |  |  |  |  |  | 0 |  | Not Started
C11 |  |  |  |  |  | 0 |  | Not Started
C12 |  |  |  |  |  | 0 |  | Not Started
C13 |  |  |  |  |  | 0 |  | Not Started
C14 |  |  |  |  |  | 0 |  | Not Started
C15 |  |  |  |  |  | 0 |  | Not Started
A19 |  |  |  |  |  | 0 |  | Not Started
A20 |  |  |  |  |  | 0 |  | Not Started | N/A
B26 |  |  |  |  |  | 0 |  | Not Started | N/A
B27 |  |  |  |  |  | 0 |  | Not Started | N/A
A21 |  |  |  |  |  | 0 |  | Not Started | N/A
B28 |  |  |  |  |  | 0 |  | Not Started | N/A
B29 |  |  |  |  |  | 0 |  | Not Started | N/A
B30 |  |  |  |  |  | 0 |  | Not Started | N/A
B31 |  |  |  |  |  | 0 |  | Not Started | N/A
C14 |  |  |  |  |  | 0 |  | Not Started | N/A
C15 |  |  |  |  |  | 0 |  | Not Started | N/A
 |  | Expected total time
 |  | Overall variance
In progress
Complete
Not started
Type 4
Type 9V
Type 14
Type 19A
Type 23F