Spreadsheet: 42990d1241610723-value-question-and-sum-average-question-test
Sheet: MPS2 P'formance

Year | Month | MSO | Build Order | Serial Number | [NAME] | Planned Truck Completion Date | Actual Truck Completion Date | Factory Performance
2009 | 1 |  |  |  |  | 2009-01-29 00:00:00 | 2009-01-28 00:00:00 | -3
2009 | 1 |  |  |  |  | 2009-01-29 00:00:00 | 2009-01-28 00:00:00 | -3
2009 | 1 |  |  |  |  | 2009-01-29 00:00:00 | 2009-01-28 00:00:00 | -3
2009 | 1 |  |  |  |  | 2009-01-29 00:00:00 | 2009-01-28 00:00:00 | -3
2009 | 1 |  |  |  |  | 2009-01-29 00:00:00 | 2009-01-28 00:00:00 | -3
2009 | 1 |  |  |  |  | 2009-01-13 00:00:00 | 2009-01-13 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-14 00:00:00 | 2009-01-14 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-15 00:00:00 | 2009-01-15 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-20 00:00:00 | 2009-01-20 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-21 00:00:00 | 2009-01-21 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-22 00:00:00 | 2009-01-22 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-27 00:00:00 | 2009-01-27 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-13 00:00:00 | 2009-01-13 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-19 00:00:00 | 2009-01-19 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-26 00:00:00 | 2009-01-26 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-28 00:00:00 | 2009-01-28 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-13 00:00:00 | 2009-01-13 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-13 00:00:00 | 2009-01-13 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-15 00:00:00 | 2009-01-15 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-20 00:00:00 | 2009-01-20 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-21 00:00:00 | 2009-01-21 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-22 00:00:00 | 2009-01-22 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-27 00:00:00 | 2009-01-27 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-28 00:00:00 | 2009-01-28 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-13 00:00:00 | 2009-01-13 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-13 00:00:00 | 2009-01-13 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-14 00:00:00 | 2009-01-14 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-14 00:00:00 | 2009-01-14 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-15 00:00:00 | 2009-01-15 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-19 00:00:00 | 2009-01-19 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-19 00:00:00 | 2009-01-19 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-20 00:00:00 | 2009-01-20 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-21 00:00:00 | 2009-01-21 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-22 00:00:00 | 2009-01-22 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-26 00:00:00 | 2009-01-26 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-26 00:00:00 | 2009-01-26 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-27 00:00:00 | 2009-01-27 00:00:00 | 0
2009 | 1 |  |  |  |  | 2009-01-28 00:00:00 | 2009-01-28 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-10 00:00:00 | 2009-03-10 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-10 00:00:00 | 2009-03-10 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-11 00:00:00 | 2009-03-11 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-12 00:00:00 | 2009-03-12 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-26 00:00:00 | 2009-03-26 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-10 00:00:00 | 2009-03-10 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-10 00:00:00 | 2009-03-10 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-10 00:00:00 | 2009-03-10 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-10 00:00:00 | 2009-03-10 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-11 00:00:00 | 2009-03-11 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-16 00:00:00 | 2009-03-16 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-10 00:00:00 | 2009-03-10 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-11 00:00:00 | 2009-03-11 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-18 00:00:00 | 2009-03-18 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-19 00:00:00 | 2009-03-19 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-10 00:00:00 | 2009-03-10 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-10 00:00:00 | 2009-03-10 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-10 00:00:00 | 2009-03-10 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-10 00:00:00 | 2009-03-10 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-10 00:00:00 | 2009-03-10 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-11 00:00:00 | 2009-03-11 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-11 00:00:00 | 2009-03-11 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-12 00:00:00 | 2009-03-12 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-12 00:00:00 | 2009-03-12 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-13 00:00:00 | 2009-03-13 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-16 00:00:00 | 2009-03-16 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-17 00:00:00 | 2009-03-17 00:00:00 | 0
2009 | 3 |  |  |  |  | 2009-03-11 00:00:00 | 2009-03-12 00:00:00 | 1
2009 | 3 |  |  |  |  | 2009-03-17 00:00:00 | 2009-03-18 00:00:00 | 1
2009 | 3 |  |  |  |  | 2009-03-18 00:00:00 | 2009-03-19 00:00:00 | 1
2009 | 3 |  |  |  |  | 2009-03-23 00:00:00 | 2009-03-24 00:00:00 | 1
2009 | 3 |  |  |  |  | 2009-03-16 00:00:00 | 2009-03-17 00:00:00 | 1
2009 | 3 |  |  |  |  | 2009-03-17 00:00:00 | 2009-03-18 00:00:00 | 1
2009 | 3 |  |  |  |  | 2009-03-18 00:00:00 | 2009-03-19 00:00:00 | 1
2009 | 3 |  |  |  |  | 2009-03-16 00:00:00 | 2009-03-17 00:00:00 | 1
2009 | 3 |  |  |  |  | 2009-03-17 00:00:00 | 2009-03-18 00:00:00 | 1
2009 | 3 |  |  |  |  | 2009-03-24 00:00:00 | 2009-03-25 00:00:00 | 1
2009 | 3 |  |  |  |  | 2009-03-25 00:00:00 | 2009-03-26 00:00:00 | 1
2009 | 3 |  |  |  |  | 2009-03-16 00:00:00 | 2009-03-17 00:00:00 | 1
2009 | 3 |  |  |  |  | 2009-03-18 00:00:00 | 2009-03-19 00:00:00 | 1
2009 | 3 |  |  |  |  | 2009-03-20 00:00:00 | 2009-03-23 00:00:00 | 1
2009 | 3 |  |  |  |  | 2009-03-23 00:00:00 | 2009-03-24 00:00:00 | 1
2009 | 3 |  |  |  |  | 2009-03-12 00:00:00 | 2009-03-16 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-13 00:00:00 | 2009-03-17 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-16 00:00:00 | 2009-03-18 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-19 00:00:00 | 2009-03-23 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-20 00:00:00 | 2009-03-24 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-23 00:00:00 | 2009-03-25 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-24 00:00:00 | 2009-03-26 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-24 00:00:00 | 2009-03-26 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-12 00:00:00 | 2009-03-16 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-17 00:00:00 | 2009-03-19 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-18 00:00:00 | 2009-03-20 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-12 00:00:00 | 2009-03-16 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-17 00:00:00 | 2009-03-19 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-18 00:00:00 | 2009-03-20 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-19 00:00:00 | 2009-03-23 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-19 00:00:00 | 2009-03-23 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-20 00:00:00 | 2009-03-24 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-23 00:00:00 | 2009-03-25 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-23 00:00:00 | 2009-03-25 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-24 00:00:00 | 2009-03-26 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-24 00:00:00 | 2009-03-26 00:00:00 | 2
2009 | 3 |  |  |  |  | 2009-03-19 00:00:00 | 2009-03-24 00:00:00 | 3
2009 | 3 |  |  |  |  | 2009-03-19 00:00:00 | 2009-03-24 00:00:00 | 3
2009 | 3 |  |  |  |  | 2009-03-23 00:00:00 | 2009-03-26 00:00:00 | 3
2009 | 3 |  |  |  |  | 2009-03-24 00:00:00 | 2009-03-27 00:00:00 | 3
2009 | 4 |  |  |  |  | 2009-04-20 00:00:00 | 2009-04-16 00:00:00 | -4
2009 | 4 |  |  |  |  | 2009-04-20 00:00:00 | 2009-04-16 00:00:00 | -4
2009 | 4 |  |  |  |  | 2009-04-20 00:00:00 | 2009-04-16 00:00:00 | -4
2009 | 4 |  |  |  |  | 2009-04-15 00:00:00 | 2009-04-14 00:00:00 | -3
2009 | 4 |  |  |  |  | 2009-04-22 00:00:00 | 2009-04-21 00:00:00 | -3
2009 | 4 |  |  |  |  | 2009-04-16 00:00:00 | 2009-04-16 00:00:00 | 0
2009 | 4 |  |  |  |  | 2009-04-20 00:00:00 | 2009-04-20 00:00:00 | 0
2009 | 4 |  |  |  |  | 2009-04-23 00:00:00 | 2009-04-23 00:00:00 | 0
2009 | 4 |  |  |  |  | 2009-04-27 00:00:00 | 2009-04-27 00:00:00 | 0
2009 | 4 |  |  |  |  | 2009-04-14 00:00:00 | 2009-04-14 00:00:00 | 0
2009 | 4 |  |  |  |  | 2009-04-14 00:00:00 | 2009-04-14 00:00:00 | 0
2009 | 4 |  |  |  |  | 2009-04-14 00:00:00 | 2009-04-14 00:00:00 | 0
2009 | 4 |  |  |  |  | 2009-04-14 00:00:00 | 2009-04-14 00:00:00 | 0
2009 | 4 |  |  |  |  | 2009-04-15 00:00:00 | 2009-04-15 00:00:00 | 0
2009 | 4 |  |  |  |  | 2009-04-15 00:00:00 | 2009-04-15 00:00:00 | 0
2009 | 4 |  |  |  |  | 2009-04-21 00:00:00 | 2009-04-21 00:00:00 | 0
2009 | 4 |  |  |  |  | 2009-04-21 00:00:00 | 2009-04-21 00:00:00 | 0
2009 | 4 |  |  |  |  | 2009-04-22 00:00:00 | 2009-04-22 00:00:00 | 0
2009 | 4 |  |  |  |  | 2009-04-22 00:00:00 | 2009-04-22 00:00:00 | 0
2009 | 4 |  |  |  |  | 2009-04-23 00:00:00 | 2009-04-23 00:00:00 | 0
2009 | 4 |  |  |  |  | 2009-04-27 00:00:00 | 2009-04-27 00:00:00 | 0
2009 | 4 |  |  |  |  | 2009-04-27 00:00:00 | 2009-04-27 00:00:00 | 0
2009 | 4 |  |  |  |  | 2009-04-21 00:00:00 | 2009-04-22 00:00:00 | 1
2009 | 4 |  |  |  |  | 2009-04-22 00:00:00 | 2009-04-23 00:00:00 | 1
2009 | 4 |  |  |  |  | 2009-04-20 00:00:00 | 2009-04-21 00:00:00 | 1
2009 | 4 |  |  |  |  | 2009-04-16 00:00:00 | 2009-04-20 00:00:00 | 2
2009 | 4 |  |  |  |  | 2009-04-21 00:00:00 | 2009-04-23 00:00:00 | 2
2009 | 4 |  |  |  |  | 2009-04-16 00:00:00 | 2009-04-20 00:00:00 | 2
2009 | 4 |  |  |  |  | 2009-04-20 00:00:00 | 2009-04-23 00:00:00 | 3
2009 | 4 |  |  |  |  | 2009-04-15 00:00:00 | 2009-04-20 00:00:00 | 3
2009 | 4 |  |  |  |  | 2009-04-15 00:00:00 | 2009-04-21 00:00:00 | 4
2009 | 4 |  |  |  |  | 2009-04-21 00:00:00 | 2009-04-27 00:00:00 | 4
2009 | 4 |  |  |  |  | 2009-04-14 00:00:00 | 2009-04-21 00:00:00 | 5
2009 | 4 |  |  |  |  | 2009-04-14 00:00:00 | 2009-04-21 00:00:00 | 5
2009 | 4 |  |  |  |  | 2009-04-15 00:00:00 | 2009-04-22 00:00:00 | 5
2009 | 4 |  |  |  |  | 2009-04-28 00:00:00 |  | #N/A
2009 | 4 |  |  |  |  | 2009-04-21 00:00:00 |  | #N/A
2009 | 4 |  |  |  |  | 2009-04-22 00:00:00 |  | #N/A
2009 | 4 |  |  |  |  | 2009-04-22 00:00:00 |  | #N/A
2009 | 4 |  |  |  |  | 2009-04-27 00:00:00 |  | #N/A
2009 | 4 |  |  |  |  | 2009-04-27 00:00:00 |  | #N/A
2009 | 4 |  |  |  |  | 2009-04-28 00:00:00 |  | #N/A
2009 | 4 |  |  |  |  | 2009-04-28 00:00:00 |  | #N/A
2009 | 4 |  |  |  |  | 2009-04-29 00:00:00 |  | #N/A
2009 | 4 |  |  |  |  | 2009-04-29 00:00:00 |  | #N/A
2009 | 4 |  |  |  |  | 2009-04-30 00:00:00 |  | #N/A
2009 | 4 |  |  |  |  | 2009-04-27 00:00:00 |  | #N/A
2009 | 4 |  |  |  |  | 2009-04-28 00:00:00 |  | #N/A
2009 | 4 |  |  |  |  | 2009-04-28 00:00:00 |  | #N/A
2009 | 4 |  |  |  |  | 2009-04-28 00:00:00 |  | #N/A
2009 | 4 |  |  |  |  | 2009-04-29 00:00:00 |  | #N/A
2009 | 4 |  |  |  |  | 2009-04-29 00:00:00 |  | #N/A
2009 | 4 |  |  |  |  | 2009-04-29 00:00:00 |  | #N/A
2009 | 4 |  |  |  |  | 2009-04-30 00:00:00 |  | #N/A
2009 | 4 |  |  |  |  | 2009-04-30 00:00:00 |  | #N/A
2009 | 5 |  |  |  |  | 2009-05-05 00:00:00 |  | #N/A
2009 | 5 |  |  |  |  | 2009-05-05 00:00:00 |  | #N/A
2009 | 5 |  |  |  |  | 2009-05-06 00:00:00 |  | #N/A
2009 | 5 |  |  |  |  | 2009-05-07 00:00:00 |  | #N/A
2009 | 5 |  |  |  |  | 2009-05-11 00:00:00 |  | #N/A
2009 | 5 |  |  |  |  | 2009-05-05 00:00:00 |  | #N/A
2009 | 5 |  |  |  |  | 2009-05-05 00:00:00 |  | #N/A
2009 | 5 |  |  |  |  | 2009-05-06 00:00:00 |  | #N/A
2009 | 5 |  |  |  |  | 2009-05-06 00:00:00 |  | #N/A