Spreadsheet: 58345d1258617647-extracting-data-from-multiple-sheets-help-needed-vehicle-fleet-dashboard
Sheet: Sheet1

INT NO | PLATE NO | PETROCARD | USER NAME | DEPT | BADGE NO |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | F TOTAL | CASE # OF ACC # 1 | DATE OF ACC # 1 | NATURE OF ACC # 1 | CASE # OF ACC # 2 | DATE OF ACC # 2 | NATURE OF ACC # 2 | CASE # OF ACC # 3 | DATE OF ACC # 3 | NATURE OF ACC # 3 | CASE # OF ACC # 4 | DATE OF ACC # 4 | NATURE OF ACC # 5 | DATE OF TRAFFIIC VIOLATION # 1 | TYPE OF VIOLATION # 1 | AMOUNT OF VIOLATION # 1 | DATE OF TRAFFIIC VIOLATION # 2 | TYPE OF VIOLATION # 2 | AMOUNT OF VIOLATION # 2 | DATE OF TRAFFIIC VIOLATION # 3 | TYPE OF VIOLATION # 3 | AMOUNT OF VIOLATION # 3 | DATE OF TRAFFIIC VIOLATION # 4 | TYPE OF VIOLATION # 4 | AMOUNT OF VIOLATION # 4 | DATE OF TRAFFIIC VIOLATION # 5 | TYPE OF VIOLATION # 5 | AMOUNT OF VIOLATION # 5 | DATE OF TRAFFIIC VIOLATION # 6 | TYPE OF VIOLATION # 6 | AMOUNT OF VIOLATION # 6
[NAME] | 60885 | 70 | [NAME] | Administration and Finance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 022/008 | 2008-01-02 00:00:00 | Turn-over | 012/009 | 2009-04-05 00:00:00 | Hit by other vehicle |  |  |  |  |  |  | 2008-03-02 00:00:00 | Over speed | 30
[NAME] | 092 | 3 | [NAME] | Administration and Finance
BNE-003 | 16829 | 2 | [NAME] | Administration and Finance
BNE-004 | 091 | 6 | [NAME] | Administration and Finance
BNE-005 |  |  | [NAME] | Administration and Finance
BNE-006 |  |  | [NAME] | Communication
BNE-007 | 18402 | 18 | [NAME] | Communication
BNE-008 | 23293 | 24 | [NAME] | Communication
BNE-009 | 23248 | 19 | Jayden | Communication
[NAME] | 23184 | 5 | [NAME] | Communication
BNE-011 | 18480 | 7 | [NAME] | Business-Economics
BNE-012 | 23296 | 15 | [NAME] | Business-Economics
BNE-013 | 18306 | 4 | [NAME] | Business-Economics
BNE-014 | 18268 | 13 | Aiden | Business-Economics
BNE-015 | 18436 | 17 | [NAME] | Business-Economics
BNE-016 | 18419 | 16 | [NAME] | Business-Economics
BNE-017 | 18168 | 48 | Logan | Business-Economics
BNE-018 | 18041 | 11 | [NAME] | Business-Economics
BNE-019 | 23228 | 8 | Nathan | Accounting
BNE-020 | 18396 | N/A | Elijah | Accounting
BNE-021 | 18237 | 20 | Christian | Accounting
BNE-022 | 18395 | 12 | [NAME] | Accounting
BNE-023 | 18415 | 10 | [NAME] | Accounting
BNE-024 | 2805 | 25 | [NAME] | Accounting
BNE-025 | 2843 | N/A | Tyler | Accounting
BNE-026 |  |  | [NAME] | Accounting
BNE-027 |  |  | [NAME] | Accounting
BNE-028 | 094 | 21 | Gavin | Information Technology Services
BNE-029 | 18413 | N/A | [NAME] | Information Technology Services
BNE-030 | 23367 | N/A | [NAME] | Information Technology Services
[NAME] | 18351 | 57 | [NAME] | Information Technology Services
BNE-032 | 18060 | 58 | Caleb | Information Technology Services
BNE-033 | 23137 | N/A | Mason | Information Technology Services
BNE-034 | 23229 | N/A | [NAME] | Facilities Automotive
BNE-035 | 23251 | N/A | [NAME] | Facilities Automotive
BNE-036 | 18261 | N/A | [NAME] | Facilities Automotive
BNE-037 | 18024 | N/A | [NAME] | Facilities Automotive
BNE-038 | 23128 | N/A | [NAME] | Facilities Automotive
BNE-039 | 18014 | N/A | [NAME] | Procurement & Payment Services
[NAME] | 18422 | N/A | [NAME] | Procurement & Payment Services
BNE-041 | 23472 | 45 | [NAME] | Procurement & Payment Services
BNE-042 | 18313 | 32 | Landon | Procurement & Payment Services
BNE-043 | 18289 | N/A | Justin | Procurement & Payment Services
BNE-044 | 18443 | 51 | Lucas | Procurement & Payment Services
BNE-045 | 18263 | 55 | Zachary | Procurement & Payment Services
BNE-046 | 23425 | 31 | Jordan | Facilities Automotive
BNE-047 | 18499 | 54 | [NAME] | Facilities Automotive
BNE-048 | 18460 | N/A | [NAME] | Facilities Automotive
[NAME] | 23103 | 34 | Brayden | Facilities Automotive
BNE-050 | 23083 | 47 | [NAME] | Facilities Automotive
BNE-051 | 23341 | 38 | Cameron | Facilities Automotive
BNE-052 | 18070 | 36 | [NAME] | Facilities Automotive
BNE-053 | 18453 | N/A | [NAME] | Facilities Automotive
BNE-054 | 23090 | 37 | Adrian | Facilities Automotive
BNE-055 | 23360 | 63 | Connor | Environmental Health and Safety
BNE-056 | 18225 | 35 | [NAME] | Environmental Health and Safety
BNE-057 | 23377 | 44 | Aidan | Environmental Health and Safety
BNE-058 | 18467 | N/A | [NAME] | Environmental Health and Safety
BNE-059 | 23333 | 43 | Julian | Environmental Health and Safety
BNE-060 | 18305 | N/A | [NAME] | Environmental Health and Safety
BNE-061 | 18475 | N/A | [NAME] | Environmental Health and Safety
BNE-062 | 23391 | 46 | [NAME] | Environmental Health and Safety
BNE-063 | 18166 | 56 | [NAME] | Environmental Health and Safety
BNE-064 | 23449 | 40 | Juan | Facilities Administration
BNE-065 | 18030 | 64 | Chase | Facilities Administration
BNE-066 | 18193 | 14 | Diego | Facilities Administration
BNE-067 | 18242 | N/A | Jeremiah | Facilities Administration
BNE-068 | 23366 | N/A | Brody | Facilities Administration
BNE-069 | 23369 | N/A | Xavier | Facilities Administration
BNE-070 | 23325 | 62 | Adam | Facilities Administration
BNE-071 | 18128 | N/A | [NAME] | Facilities Administration
BNE-072 | 23076 | 39 | [NAME] | Facilities Administration
BNE-073 | 23265 | N/A | [NAME] | Facilities Administration
BNE-074 | 23231 | N/A | Hayden | Facilities Administration
BNE-075 | 23093 | N/A | [NAME] | Facilities Administration
BNE-076 | 23183 | N/A | [NAME] | Facilities Administration
[NAME] | 23454 | N/A | [NAME] | Facilities Administration
BNE-078 | 23256 | 42 | Ian | Facilities Administration
[NAME] | 18145 | N/A | Tristan | Facilities Administration
BNE-080 | 23245 | N/A | [NAME] | Procurement & Payment Services
BNE-081 | 18097 | 33 | Sean | Procurement & Payment Services
BNE-082 | 18152 | N/A | Cole | Procurement & Payment Services
BNE-083 | 18174 | 59 | [NAME] | Procurement & Payment Services
BNE-084 | 23054 | N/A | [NAME] | Procurement & Payment Services
BNE-085 | 18175 | N/A | [NAME] | Procurement & Payment Services
BNE-086 | 23395 | N/A | Jaden | Procurement & Payment Services
BNE-087 | 23432 | 61 | [NAME] | Procurement & Payment Services
BNE-088 | 23299 | 52 | Blake | Procurement & Payment Services
[NAME] | 23191 | 50 | Ayden | Procurement & Payment Services
BNE-090 | 18200 | 53 | Cooper | Procurement & Payment Services
BNE-091 | 18111 | 49 | Dominic | Procurement & Payment Services
BNE-092 | 23244 | N/A | [NAME] | Procurement & Payment Services
BNE-093 | 23390 | N/A | Caden | Procurement & Payment Services
BNE-094 | 23461 | N/A | Josiah | Recreational Services
BNE-095 | 23091 | N/A | [NAME] | Recreational Services
BNE-096 | 23450 | N/A | Colton | Recreational Services
BNE-097 | 18332 | N/A | Kaden | Recreational Services
BNE-098 | 18349 | N/A | Eli | Recreational Services
[NAME] | 18011 | N/A | Miguel | Recreational Services
[NAME] |  |  | [NAME] | Recreational Services
BNE-101 |  |  | Parker | Recreational Services
BNE-102 |  |  | [NAME] | Recreational Services
BNE-103 |  |  | Alejandro | Recreational Services
BNE-104 |  |  | Riley | Recreational Services
BNE-105 |  |  | [NAME] | Recreational Services
BNE-106 |  |  | Timothy | Recreational Services
BNE-107 |  |  | [NAME] | Recreational Services
BNE-108 |  |  | [NAME] | Recreational Services
BNE-109 |  |  | Victor | Recreational Services
BNE-110 | 18116 | N/A | Jake | Facilities Alterations
BNE-111 | 18076 | N/A | Joel | Facilities Alterations
BNE-112 | 18133 | 66 | [NAME] | Facilities Alterations
BNE-113 | 18140 | N/A | Kaleb | Facilities Alterations
BNE-114 | 18147 | N/A | [NAME] | Facilities Alterations
BNE-115 |  |  | [NAME] | Facilities Alterations
BNE-116 | 18181 | N/A | [NAME] | Facilities Alterations
BNE-117 | 18447 | N/A | [NAME] | Facilities Alterations
BNE-118 | 23049 | N/A | Vincent | Facilities Alterations
BNE-119 | 18219 | N/A | Ashton | Facilities Alterations
BNE-120 | 23249 | N/A | [NAME] | Facilities Alterations
BNE-121 | 18059 | N/A | Micah | Facilities Alterations
BNE-122 | 18434 | N/A | Preston | Design and Production
BNE-123 | 23209 | N/A | Marcus | Design and Production
BNE-124 | 23133 | N/A | [NAME] | Design and Production
BNE-125 | 23470 | N/A | [NAME] | Design and Production
BNE-126 | 23254 | N/A | [NAME] | Design and Production
BNE-127 | 23078 |  | Jeremy | Design and Production
BNE-128 | 18025 | N/A | Peyton | Design and Production
BNE-129 | 23416 | N/A | Nolan | Design and Production
BNE-130 | 23490 | N/A | [NAME] | Design and Production
BNE-131 | 18446 | N/A | Damian | Design and Production
BNE-132 | 18423 | N/A | Maxwell | Design and Production
BNE-133 | 23411 | N/A | [NAME] | Leadership & Community Dvlmnt
BNE-134 | 23257 | N/A | [NAME] | Leadership & Community Dvlmnt
[NAME] | 23331 | N/A | Jonah | Leadership & Community Dvlmnt
BNE-136 | 23334 | N/A | Jorge | Leadership & Community Dvlmnt
[NAME] | 23324 | N/A | Mark | Leadership & Community Dvlmnt
[NAME] | 23382 | N/A | Giovanni | Leadership & Community Dvlmnt
BNE-139 | 23372 | N/A | Eduardo | Leadership & Community Dvlmnt
BNE-140 | 23342 | N/A | Grant | Leadership & Community Dvlmnt
BNE-141 | 18158 | N/A | Collin | Information Strategies and Design
BNE-142 | 23121 | N/A | Gage | Information Strategies and Design
BNE-143 | 18228 | N/A | [NAME] | Information Strategies and Design
BNE-144 | 23272 | N/A | Emmanuel | Information Strategies and Design
BNE-145 |  |  | Trevor | Information Strategies and Design
[NAME] |  |  | [NAME] | Information Strategies and Design
[NAME] |  |  | Ricardo | Information Strategies and Design
BNE-148 |  |  | Cristian | Information Strategies and Design
BNE-149 |  |  | [NAME] | Information Strategies and Design
BNE-150 | 86497 | N/A | Kayden | Information Strategies and Design
BNE-151 | 86489 | N/A | George | Information Strategies and Design
BNE-152 | 31493 | N/A | Jaxon | Information Strategies and Design
BNE-153 | 31061 | N/A | [NAME] | Information Strategies and Design
BNE-154 | 86256 | N/A | Braden | Strategic Communications & Media Group
BNE-155 | 86371 | N/A | Elias | Strategic Communications & Media Group
BNE-156 | 86315 | N/A | Andres | Strategic Communications & Media Group
BNE-157 | 5237 | N/A | Derek | Strategic Communications & Media Group
BNE-158 |  |  | Garrett | Strategic Communications & Media Group
BNE-159 | 87184 | N/A | Tanner | Strategic Communications & Media Group
BNE-160 | 16827 | N/A | Malachi | Strategic Communications & Media Group
BNE-161 | 16834 | N/A | [NAME] | Strategic Communications & Media Group
[NAME] | 1243 | N/A | [NAME] | Strategic Communications & Media Group
BNE-163 | 16695 | N/A | Cesar | Strategic Communications & Media Group