Spreadsheet: 136535d1326713011-summing-the-max-value-of-each-row-in-an-array-with-one-formula-operational-times
Sheet: Operational Times

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Program code tests
 |  |  |  | Control Programs
 |  |  | Hour | Normal open | Sunday Open | Office Open | Always off | Always 25% | Always 50% | Always 75% | Always 100% | Off at weekends | Off During daylight | Not in use | Not in use | Not in use | Not in use | Not in use | Not in use | Not in use | Not in use | Not in use |  |  | separate cells |  | array over cells | Sum of array
 |  |  | 00:00:00 | 0 | 0 | 0 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 1
 |  | 2 | 01:00:00 | 0 | 0 | 0 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 1
 |  | 3 | 02:00:00 | 0 | 0 | 0 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 1
 |  | 4 | 03:00:00 | 0 | 0 | 0 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 1
 |  | 5 | 04:00:00 | 0 | 0 | 0 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 1
 |  | 6 | 05:00:00 | 0 | 0 | 0 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 1
 |  | 7 | 06:00:00 | 0 | 0 | 0 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 1
 |  | 8 | 07:00:00 | 1 | 0 | 0 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 1
 |  | 9 | 08:00:00 | 1 | 0 | 1 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 0
 |  | 10 | 09:00:00 | 1 | 0 | 1 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 0
 |  | 11 | 10:00:00 | 1 | 1 | 1 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 0
 |  | 12 | 11:00:00 | 1 | 1 | 1 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 0
 |  | 13 | 12:00:00 | 1 | 1 | 1 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 0
 |  | 14 | 13:00:00 | 1 | 1 | 1 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 0
 |  | 15 | 14:00:00 | 1 | 1 | 1 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 0
 |  | 16 | 15:00:00 | 1 | 1 | 1 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 0
 |  | 17 | 16:00:00 | 1 | 1 | 1 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 0
 |  | 18 | 17:00:00 | 1 | 1 | 1 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 0
 |  | 19 | 18:00:00 | 1 | 0 | 1 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 1
 |  | 20 | 19:00:00 | 1 | 0 | 0 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 1
 |  | 21 | 20:00:00 | 1 | 0 | 0 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 1
 |  | 22 | 21:00:00 | 0 | 0 | 0 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 1
 |  | 23 | 22:00:00 | 0 | 0 | 0 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 1
 |  | 24 | 23:00:00 | 0 | 0 | 0 | 0 | 0.25 | 0.5 | 0.75 | 1 | 0 | 1
 |  | Not yet implemented | Monday | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Tuesday | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A |  | B | C
 |  |  | Wednesday | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | Would expect B to equal C? but it is 0.25 x 24…
 |  |  | Thursday | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Friday | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Saturday | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Sunday | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Program ID | 1 | 2 | 4 | 8 | 16 | 32 | 64 | 128 | 256 | 512 | 1024 | 2048 | 4096 | 8192 | 16384 | 32768 | 65536 | 131072 | 262144 |  |  | 17 | Test Program Code, consists of adding Program IDs together.
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  |  | D
 |  |  | Example Intended Usage
 |  |  |  |  |  | Daily
 |  |  | Luminaire Id | Power | Prog. Code | Hours | KWh
 |  |  | A11 | 11 | 17
 |  |  | A12 | 15 | 16
 |  |  | Total