Spreadsheet: 30766d1226439946-formula-to-reference-previous-cell-in-row-ud-2
Sheet: HOURS (Sr)

UD-002 (Rev. 08/2005)
MICHIGAN STATE POLICE
FIELD SERVICES BUREAU DAILY REPORT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REVIEWED BY |  |  |  |  |  |  |  |  |  | ENTERED BY
NAME |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RANK |  |  |  |  |  |  | BADGE NO. |  |  |  |  |  |  |  |  | WORK SITE |  |  |  |  |  |  |  |  |  | ASSIGNMENT |  |  |  |  |  |  | SHIFT WORKED |  |  |  |  |  | DATE
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  | 6 |  |  |  |  |  | 7
PASS |  |  |  | [NAME]. |  |  |  | OT |  |  | S/D |  |  | S/D OT |  |  | Annual |  |  | Pers-Sick |  |  | Other Sick |  |  | Def. Used |  |  | Non-Pay |  | Union |  | Comp. Used |  |  | Comp. Earned |  |  |  | Stand-By |  | Other |  |  | Signature of Supervisor
8 |  |  | A | 9 |  |  | B | 10 |  | C | 11 |  | D | 12 |  | E | 13 |  | F | 14 |  | G | 15 |  | J | 16 |  | K | 17 | L | 18 | M | 19 |  | N | 20 |  |  | P | 21 | SB | 22 | X |  | 23
OBLIGATED TIME
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UNOBLIGATED OUTPUTS-ACTIVITY
Field Services Bureau |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TRAFFIC ARRESTS |  |  |  |  |  |  |  |  |  |  | Jr. |  | Sr.
 |  | D |  |  |  | A |  |  |  | T
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FREEWAY |  |  |  |  | TRUNKLINE |  |  |  |  |  |  | COUNTY |  |  |  |  |  |  | 24 |  |  | PATROL |  |  |  |  |  |  | Hazardous Traffic |  |  |  |  |  |  |  |  |  |  | 25 |  | 26
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jr. |  | Sr. |  |  | Jr. |  |  | Sr. |  |  |  | Jr. |  |  | Sr. |  |  |  | Jr. |  |  |  | Sr.
 |  | 27 |  |  |  | 28 |  |  |  | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nonhazardous Traffic |  |  |  |  |  |  |  |  |  |  | 38 |  | 39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  | 31 |  |  | 32 |  |  | 33 |  |  |  | 34 |  |  | 35 |  |  |  | 36 |  |  |  | 37
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O.W.I. |  |  |  |  |  |  |  |  |  |  | 43 |  | 44
 | 3
 |  | 40 |  |  |  | 41 |  |  |  | 42 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL TRAFFIC ARREST
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CRIMINAL INCIDENTS
 |  | Office of the Director |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ARRESTS AND COUNTS
 |  | D |  |  |  | A |  |  |  | T |  |  |  |  |  | 45 |  |  |  | State……………………………………….. |  |  |  |  |  |  |  |  |  |  | 0100-0300 |  |  |  |  |  | 46 |  |  |  | 47
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Felons Arrested |  |  |  |  |  |  |  |  |  |  | 51 |  | 52
 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 |  |  |  | Against Person………………………………. |  |  |  |  |  |  |  |  |  |  | 0900-1400 |  |  |  |  |  | 49 |  |  |  | 50
 |  | 53 |  |  |  | 54 |  |  |  | 55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Misdemeanants Arrested |  |  |  |  |  |  |  |  |  |  | 59 |  | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56 |  |  |  | Property ( Part I )………………………………………… |  |  |  |  |  |  |  |  |  |  | 2000-2400 |  |  |  |  |  | 57 |  |  |  | 58
 |  | State Services Bureau |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL PERSONS ARRESTED
 |  | D |  |  |  | A |  |  |  | T |  |  |  |  |  | 61 |  |  |  | Prperty ( Part II )………………………………………………….. |  |  |  |  |  |  |  |  |  |  | 2500-2900 |  |  |  |  |  | 62 |  |  |  | 63
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Patrol Counts |  |  |  |  |  |  |  |  |  |  | 64 |  | 65
 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66 |  |  |  | Morals / Decency……………………………….. |  |  |  |  |  |  |  |  |  |  | 3500-4200 |  |  |  |  |  | 67 |  |  |  | 68
 |  | 71 |  |  |  | 72 |  |  |  | 73 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Investgative Counts |  |  |  |  |  |  |  |  |  |  | 69 |  | 70
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 74 |  |  |  | Public Order…………………………….. |  |  |  |  |  |  |  |  |  |  | 4800-8900 |  |  |  |  |  | 75 |  |  |  | 76
 | Additional Coding Areas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL ARREST COUNTS
 |  | D |  |  |  | A |  |  |  | T |  |  |  |  |  | 79 |  |  |  | Criminal Traffic……………………………….. |  |  |  |  |  |  |  |  |  |  | 5400 1&3 |  |  |  |  |  | 80 |  |  |  | 81
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fugitives Arrested |  |  |  |  |  |  |  |  |  |  | 77 |  | 78
 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 84 |  |  |  | OWI………………………………………………. |  |  |  |  |  |  |  |  |  |  |  | 5400-2 |  |  |  |  | 85 |  |  |  | 86
 |  | 300 |  |  |  | 301 |  |  |  | 302 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Warrants/Wants Satisfied |  |  |  |  |  |  |  |  |  |  | 82 |  | 83
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NON CRIMINAL INCIDENTS
Administrative Services Bureau |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PATROL ACTIVITY
 |  | D |  |  |  | A |  |  |  | T |  |  |  |  |  | 92 |  |  |  | Juvenile……………………………………………… |  |  |  |  |  |  |  |  |  |  |  | 7000 |  |  |  |  | 93 |  |  |  | 94 |  |  |  |  | Traffic Stops |  |  |  |  |  |  |  |  |  |  | 87 |  | 88
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 97 |  |  |  | Civil Custodies……………………………………….. |  |  |  |  |  |  |  |  |  |  |  | 9200 |  |  |  |  | 98 |  |  |  | 99 |  |  |  |  | Cars Assisted |  |  |  |  |  |  |  |  |  |  | 90 |  | 91
 |  | 102 |  |  |  | 103 |  |  |  | 104
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 105 |  |  |  | Traffic Accidents…………………………………………… |  |  |  |  |  |  |  |  |  |  | 9300-1,2 |  |  |  |  |  | 106 |  |  |  | 107 |  |  |  |  | Cars Investigated |  |  |  |  |  |  |  |  |  |  | 95 |  | 96
 | Additional Coding Areas
 |  | D |  |  |  | A |  |  |  | T |  |  |  |  |  | 110 |  |  |  | Traffic………………………………………. |  |  |  |  |  |  |  |  |  |  | 9300-3,9 |  |  |  |  |  | 111 |  |  |  | 112 |  |  |  |  | Vehicles Inspected |  |  |  |  |  |  |  |  |  |  | 100 |  | 101
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 115 |  |  |  | Fire…………………………………………….. |  |  |  |  |  |  |  |  |  |  | 9500-1,2 |  |  |  |  |  | 116 |  |  |  | 117 |  |  |  |  | Property Inspections |  |  |  |  |  |  |  |  |  |  | 108 |  | 109
120 |  | 121 |  |  |  | 122 |  |  |  | 123
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 124 |  |  |  | Accidents, All Other…………………………………. |  |  |  |  |  |  |  |  |  |  |  | 9700 |  |  |  |  | 125 |  |  |  | 126 |  |  |  |  | Liquor Inspections |  |  |  |  |  |  |  |  |  |  | 113 |  | 114
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 133 |  |  |  | Inspect / Investgation………………………… |  |  |  |  |  |  |  |  |  |  |  | 9800 |  |  |  |  | 134 |  |  |  | 135 |  |  |  |  | Verbal Warnings |  |  |  |  |  |  |  |  |  |  | 118 |  | 119
129 |  | 130 |  |  |  | 131 |  |  |  | 132
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 139 |  |  |  | Miscellaneous Incidents…………………………. |  |  |  |  |  |  |  |  |  |  |  | 9900 |  |  |  |  | 140 |  |  |  | 141 |  |  |  |  | Motor Vehicle Acidents |  |  |  |  |  |  |  |  |  |  | 127 |  | 128
 |  | TOTAL
 |  | OBLIGATED |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NONINCIDENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MV Acc. Closed By [NAME]. Arr. |  |  |  |  |  |  |  |  |  |  | 137 |  | 136
 |  | TIME |  |  |  |  |  |  |  | 138
ACTIVITY DURING OBLIGATED TIME |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 147 |  |  | Report Writing……………………….……………………………………………………… |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 148 |  |  |  | 149 |  |  |  |  | A -…………………. |  |  |  |  |  |  |  |  |  |  | 142 |  | 143
 | Incidents |  |  |  |  |  |  | 146
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 153 |  |  | District Court…………..……. |  |  |  |  |  |  | (154 |  |  |  | ) | (155 |  |  |  | ) |  | 156 |  |  |  | 157 |  |  |  |  | Passenger Restraint Cits |  |  |  |  |  |  |  |  |  |  | 144 |  | 145
 | Criminal Arrests |  |  |  |  |  |  | 152
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 159 |  |  | Circuit Court……………………………….…………………. |  |  |  |  |  |  |  |  |  |  |  | (160 |  |  |  | ) |  | 161 |  |  |  | 162 |  |  |  |  | Passenger [NAME] |  |  |  |  |  |  |  |  |  |  | 150 |  | 151
 | Traffic Arrests |  |  |  |  |  |  | 158
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 164 |  |  | Desk Assignment…………………………………..………………………………………… |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 165 |  |  |  | 166 |  |  |  |  | UNOBLIGATED INCIDENTS
 | [NAME] |  |  |  |  |  |  | 163 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Original Dispatched |  |  |  |  |  |  |  |  |  |  | 167 |  | 168
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 169 |  |  | Operational Support……………………………………… |  |  |  |  |  |  |  |  |  |  |  | (170 |  |  |  | ) |  | 171 |  |  |  | 172
 | MEALS AND LODGING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Original Patrol |  |  |  |  |  |  |  |  |  |  | 173 |  | 174
 |  |  | B |  |  | L |  |  | D |  |  | LG |  |  |  |  |  |  | TOTAL UNOBLIGATED HOURS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 179 |  |  |  | 180 |  |  |  |  | TOTAL ORIGINAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Supplementary |  |  |  |  |  |  |  |  |  |  | 181 |  | 182
 | 175 |  |  | 176 |  |  | 177 |  |  | 178
 |  |  |  |  |  |  |  |  |  |  | Traffic |  |  |  |  |  |  |  | Other |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | County Road Patrol |  |  |  |  |  |  |  |  |  |  | Total Patrol Mileage
UNOBLIGATED |  |  |  |  |  |  |  |  |  |  | Jr. |  |  |  | Sr. |  |  |  | Jr. |  |  |  | Sr. |  |  |  | Jr. |  |  |  | Sr. |  |  | Jr. |  |  |  |  | Sr. |  |  |  | Jr. |  |  |  |  | Sr. |  |  |  |  |  | Jr. |  |  |  | Sr.
MILEAGE
 |  |  |  |  |  |  |  |  |  |  | 183 |  |  |  | 184 |  |  |  | 185 |  |  |  | 186 |  |  |  | 187 |  |  |  | 188 |  |  | 189 |  |  |  |  | 190 |  |  |  | 191 |  |  |  |  | 192 |  |  |  |  |  | 193 |  |  |  | 194
TRAFFIC ENFORCEMENT SUMMARY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LOCAL USE
Race / Sex |  |  |  |  |  |  |  | CITATIONS |  |  |  |  |  |  |  |  | V/W |  |  |  |  |  |  |  | Consent |  |  |  |  |  |  |  | PC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jr. |  |  | Sr.
W/M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 197 |  |  |  |  |  |  |  | 198 |  |  |  |  |  |  |  | 199 |  |  |  |  |  |  |  | 200 |  | 1-…………………………………………………… |  |  |  |  |  |  |  |  |  |  | 195 |  |  |  |  | 196
W/F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 205 |  |  |  |  |  |  |  | 206 |  |  |  |  |  |  |  | 207 |  |  |  |  |  |  |  | 208 |  | 2-………………………………………………….. |  |  |  |  |  |  |  |  |  |  | 203 |  |  |  |  | 204
B/M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 213 |  |  |  |  |  |  |  | 214 |  |  |  |  |  |  |  | 215 |  |  |  |  |  |  |  | 216 |  | 3-………………………………………………….. |  |  |  |  |  |  |  |  |  |  | 211 |  |  |  |  | 212
B/F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 221 |  |  |  |  |  |  |  | 222 |  |  |  |  |  |  |  | 223 |  |  |  |  |  |  |  | 224 |  | 4-………………………………………………….. |  |  |  |  |  |  |  |  |  |  | 219 |  |  |  |  | 220
L/M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 229 |  |  |  |  |  |  |  | 230 |  |  |  |  |  |  |  | 231 |  |  |  |  |  |  |  | 232 |  | 5-………………………………………………….. |  |  |  |  |  |  |  |  |  |  | 227 |  |  |  |  | 228
L/F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 237 |  |  |  |  |  |  |  | 238 |  |  |  |  |  |  |  | 239 |  |  |  |  |  |  |  | 240 |  | 6-………………………………………………….. |  |  |  |  |  |  |  |  |  |  | 235 |  |  |  |  | 236
O/M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 245 |  |  |  |  |  |  |  | 247 |  |  |  |  |  |  |  | 247 |  |  |  |  |  |  |  | 248 |  | 7- [NAME]……………………… |  |  |  |  |  |  |  |  |  |  | 243 |  |  |  |  | 244
O/F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 253 |  |  |  |  |  |  |  | 254 |  |  |  |  |  |  |  | 255 |  |  |  |  |  |  |  | 256 |  | 8- [NAME] |  |  |  |  |  |  |  |  |  |  | 251 |  |  |  |  | 252
OFFICER'S SIGNATURE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9- Original - Felony…….………………. |  |  |  |  |  |  |  |  |  |  | 259 |  |  |  |  | 260
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10- Original - Misdemeanor……… |  |  |  |  |  |  |  |  |  |  | 265 |  |  |  |  | 266