Spreadsheet: 101398d1299536462-excel-formula-that-sums-the-times-rules-were-observed-by-line-of-business-lob-safecomm-data
Sheet: SafeComm Summary

Safe Con Observations
Date | Hauling Site | Truck # | Driver Name | LCR Observed | LCR Observed | Overall Score
2011-02-01 00:00:00 | Atlanta-East | 406480 | [NAME] | N/A | N/A | 99
2011-01-03 00:00:00 | Atlanta-East | 502394 | [NAME] | N/A | N/A | 96
2011-01-03 00:00:00 | Atlanta-East | 303670 | [NAME] | N/A | N/A | 96
2011-01-03 00:00:00 | Atlanta-East | 210505 | [NAME] | N/A | N/A | 95
2011-02-01 00:00:00 | Atlanta-East | 209749 | [NAME] | N/A | N/A | 94
2011-02-01 00:00:00 | Atlanta-East | 412223 | [NAME] | N/A | N/A | 75
2011-01-03 00:00:00 | Atlanta-East | 309720 | [NAME] | 3 | N/A | 73
2011-02-01 00:00:00 | Atlanta-East | 410177 | [NAME] | 5 | 5 | 70
2011-01-06 00:00:00 | Atlanta-South | 412006 | [NAME] | N/A | N/A | 97
2011-02-03 00:00:00 | Atlanta-South | 631721 | [NAME] | N/A | N/A | 97
2011-02-03 00:00:00 | Atlanta-South | 412691 | Tyron Mentor | N/A | N/A | 92
2011-01-06 00:00:00 | Atlanta-South | 209750 | [NAME] | N/A | N/A | 90
2011-02-03 00:00:00 | Atlanta-South | 209750 | [NAME] | N/A | N/A | 85
2011-01-06 00:00:00 | Atlanta-South | 410683 | [NAME] | N/A | N/A | 78
2011-02-03 00:00:00 | Atlanta-South | 210095 | Mahindra Jenkins | 4 | 4 | 67
2011-01-06 00:00:00 | Atlanta-South | 412221 | [NAME] | N/A | N/A | 59
2011-01-05 00:00:00 | Atlanta-West | 412049 | [NAME] | N/A | N/A | 98
2011-01-05 00:00:00 | Atlanta-West | 412213 | [NAME] | N/A | N/A | 94
2011-01-05 00:00:00 | Atlanta-West | 411923 | [NAME] | N/A | N/A | 89
2011-01-05 00:00:00 | Atlanta-West | 209310 | [NAME] | 3 | N/A | 61
2011-01-07 00:00:00 | Augusta | 405252 | [NAME] | N/A | N/A | 100
2011-01-07 00:00:00 | Augusta | 309487 | [NAME] | N/A | N/A | 97
2011-02-04 00:00:00 | Augusta | 210037 | [NAME] | N/A | N/A | 92
2011-02-04 00:00:00 | Augusta | 405253 | [NAME] | N/A | N/A | 90
2011-02-04 00:00:00 | Augusta | 410511 | [NAME] | N/A | N/A | 79
2011-01-07 00:00:00 | Augusta | 205949 | [NAME] | 5 | N/A | 78
2011-02-07 00:00:00 | Columbia | 402654 | [NAME] | N/A | N/A | 100
2011-02-07 00:00:00 | Columbia | 408938 | [NAME] | N/A | N/A | 85
2011-02-07 00:00:00 | Columbia | 206755 | [NAME] | N/A | N/A | 76
2011-02-07 00:00:00 | Columbia | 412652 | [NAME] | N/A | N/A | 73
2011-02-15 00:00:00 | Fayetteville | 101840 | [NAME] | N/A | N/A | 100
2011-02-15 00:00:00 | Fayetteville | 103190 | [NAME] | N/A | N/A | 96
2011-02-15 00:00:00 | Fayetteville | 103193 | [NAME] | N/A | N/A | 87
2011-02-15 00:00:00 | Fayetteville | 210509 | [NAME] | N/A | N/A | 75
2011-01-24 00:00:00 | Gastonia | 208250 | [NAME] | N/A | N/A | 94
2011-01-24 00:00:00 | Gastonia | 409062 | [NAME] | N/A | N/A | 94
2011-01-24 00:00:00 | Gastonia | 411872 | [NAME] | N/A | N/A | 90
2011-01-24 00:00:00 | Gastonia | 409258 | [NAME] | N/A | N/A | 84
2011-01-31 00:00:00 | Granite Quarry | 673884 | [NAME] | N/A | N/A | 97
2011-01-31 00:00:00 | Granite Quarry | 102810 | [NAME] | N/A | N/A | 95
2011-02-14 00:00:00 | Granite Quarry | 103539 | [NAME] | N/A | N/A | 95
2011-01-31 00:00:00 | Granite Quarry | 102885 | [NAME] | N/A | N/A | 93
2011-01-31 00:00:00 | Granite Quarry | 103002 | [NAME] | N/A | N/A | 90
2011-02-14 00:00:00 | Granite Quarry | 405465 | [NAME] | N/A | N/A | 86
2011-02-14 00:00:00 | Granite Quarry | 412389 | [NAME] | N/A | N/A | 86
2011-02-14 00:00:00 | Granite Quarry | 208882 | [NAME] | N/A | N/A | 77
2011-02-16 00:00:00 | Jacksonville | 152567 | [NAME] | N/A | N/A | 100
2011-02-16 00:00:00 | Jacksonville | 206759 | [NAME] | N/A | N/A | 100
2011-02-16 00:00:00 | Jacksonville | 152392 | [NAME] | N/A | N/A | 97
2011-01-25 00:00:00 | Mt. Airy | 151559 | [NAME] | N/A | N/A | 100
2011-01-25 00:00:00 | Mt. Airy | 409828 | [NAME] | N/A | N/A | 100
2011-01-25 00:00:00 | Mt. Airy | 208279 | [NAME] | N/A | N/A | 95
2011-02-08 00:00:00 | Orangeburg | 412651 | [NAME] | N/A | N/A | 100
2011-02-08 00:00:00 | Orangeburg | 410014 | [NAME] | N/A | N/A | 99
2011-02-08 00:00:00 | Orangeburg | 405558 | [NAME] | N/A | N/A | 95
2011-02-08 00:00:00 | Orangeburg | 206091 | [NAME] | N/A | N/A | 93
2011-01-28 00:00:00 | Raleigh | 412565 | [NAME] | N/A | N/A | 99
2011-02-22 00:00:00 | Raleigh | 203705 | [NAME] | N/A | N/A | 97
2011-02-22 00:00:00 | Raleigh | 411198 | [NAME] | N/A | N/A | 97
2011-01-28 00:00:00 | Raleigh | 210511 | [NAME] | N/A | N/A | 96
2011-01-28 00:00:00 | Raleigh | 409743 | [NAME] | N/A | N/A | 96
2011-02-22 00:00:00 | Raleigh | 207315 | [NAME] | N/A | N/A | 96
2011-02-22 00:00:00 | Raleigh | 407111 | Adrian Campbell | N/A | N/A | 92
2011-01-27 00:00:00 | [NAME] | 152541 | [NAME] | N/A | N/A | 96
2011-01-27 00:00:00 | [NAME] | 208296 | [NAME] | N/A | N/A | 95
2011-01-27 00:00:00 | [NAME] | 102806 | [NAME] | N/A | N/A | 89
2011-01-27 00:00:00 | [NAME] | 309799 | Edwin Escabor/Burnice Kelly | N/A | N/A | 76
2011-01-11 00:00:00 | Savannah | 412387 | Freddie Jasper | N/A | N/A | 97
2011-02-09 00:00:00 | Savannah | 408299 | [NAME] | N/A | N/A | 97
2011-01-11 00:00:00 | Savannah | 361142 | Freddie Molina | N/A | N/A | 94
2011-01-11 00:00:00 | Savannah | 309595 | [NAME] | N/A | N/A | 94
2011-01-11 00:00:00 | Savannah | 210035 | [NAME] | N/A | N/A | 87
2011-02-09 00:00:00 | Savannah | 411938 | Nate Drayton | N/A | N/A | 84
2011-02-09 00:00:00 | Savannah | 207584 | [NAME] | N/A | N/A | 83
2011-02-09 00:00:00 | Savannah | 208248 | [NAME] | N/A | N/A | 82
2011-03-03 00:00:00 | Savannah | 309849 |  | N/A | N/A | 82
2011-03-03 00:00:00 | Savannah | 309594 |  | N/A | N/A | 97
2011-03-03 00:00:00 | Savannah | 309595 |  | N/A | N/A | 94
2011-03-03 00:00:00 | Savannah | 310552 |  | N/A | N/A | 100
2011-02-23 00:00:00 | Selma | 208178 | [NAME] | N/A | N/A | 100
2011-02-23 00:00:00 | Selma | 152661 | [NAME] | N/A | N/A | 94
2011-02-23 00:00:00 | Selma | 101163 | [NAME] | N/A | N/A | 83
2011-02-23 00:00:00 | Selma | 152618 | [NAME] | N/A | N/A | 82
2011-01-21 00:00:00 | Spartanburg | 405865 | [NAME] | N/A | N/A | 99
2011-01-21 00:00:00 | Spartanburg | 152620 | [NAME] | N/A | N/A | 94
2011-01-21 00:00:00 | Spartanburg | 411291 | Agustin Berrios | N/A | N/A | 87
2011-01-21 00:00:00 | Spartanburg | 409058 | [NAME] | N/A | N/A | 86
2011-01-26 00:00:00 | Stoneville | 401061 | [NAME] | N/A | N/A | 100
2011-01-26 00:00:00 | Stoneville | 103257 | [NAME] | N/A | N/A | 97
2011-01-26 00:00:00 | Stoneville | 207640 | [NAME] | N/A | N/A | 96
2011-01-26 00:00:00 | Stoneville | 401059 | [NAME] | 5 | N/A | 80
2011-01-14 00:00:00 | Winston-Salem | 411843 | [NAME] | N/A | N/A | 100
2011-02-25 00:00:00 | Winston-Salem | 409573 | [NAME] | N/A | N/A | 99
2011-02-24 00:00:00 | Winston-Salem | 209531 | [NAME] | N/A | N/A | 95
2011-02-24 00:00:00 | Winston-Salem | 506844 | [NAME] | N/A | N/A | 94
2011-02-25 00:00:00 | Winston-Salem | 409931 | [NAME] | N/A | N/A | 93
2011-02-24 00:00:00 | Winston-Salem | 506016 | [NAME] | N/A | N/A | 92
2011-02-24 00:00:00 | Winston-Salem | 506848 | [NAME] | N/A | N/A | 91
2011-02-25 00:00:00 | Winston-Salem | 506927 | [NAME] | N/A | N/A | 83
2011-02-25 00:00:00 | Winston-Salem | 411843 | [NAME] | N/A | N/A | 75
2011-01-14 00:00:00 | Winston-Salem | 409931 | [NAME] | 5 | N/A | 56
2011-01-14 00:00:00 | Winston-Salem | 209531 | [NAME] | N/A | N/A | 55
2011-01-14 00:00:00 | Winston-Salem | 407093 | [NAME] | N/A | N/A | 47
2011-01-04 00:00:00 | Woodstock | 309997 | [NAME] | N/A | N/A | 100
2011-02-02 00:00:00 | Woodstock | 206491 | [NAME] | N/A | N/A | 97
2011-01-04 00:00:00 | Woodstock | 409639 | [NAME] | N/A | N/A | 94
2011-02-02 00:00:00 | Woodstock | 362521 | [NAME] | N/A | N/A | 94
2011-02-02 00:00:00 | Woodstock | 412227 | [NAME] | N/A | N/A | 93
2011-01-04 00:00:00 | Woodstock | 310867 | [NAME] | N/A | N/A | 92
2011-01-04 00:00:00 | Woodstock | 409646 | [NAME] | N/A | N/A | 82
2011-02-02 00:00:00 | Woodstock | 410176 | [NAME] | 5 | N/A | 62