{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Case_Log"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Case_Log","index":0,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Case log feeding Dashboard and annual report"]
["Source Video","Case Number","Incident Date","Incident Time","Location","City","Offense","Date Charges Filed","Party Names","Disposition","Camera Type","BWC Used?","In-Car Used?","Suggested Category","Normalized Disposition","Duplicate"]
["Both","X251550080","2025-06-04","13:45:00","Rt 84 / 14th Ave","Fulton","Stop Sign","2025-06-04","King, David","Citation",{"$f":"IF(ISNUMBER(SEARCH(\"BOTH\",UPPER(A3))),\"Both\",IF(ISNUMBER(SEARCH(\"BWC\",UPPER(A3))),\"BWC\",\"Other\"))","v":"Both"},{"$f":"IF(OR(K3=\"BWC\",K3=\"Both\"),1,0)","v":1},{"$f":"IF(K3=\"Both\",1,0)","v":1},{"$f":"IF(OR(ISNUMBER(SEARCH(\"DUI\",UPPER(G3))),ISNUMBER(SEARCH(\"DWL\",UPPER(G3))),ISNUMBER(SEARCH(\"STOP SIGN\",UPPER(G3))),ISNUMBER(SEARCH(\"YIELD\",UPPER(G3))),ISNUMBER(SEARCH(\"SIGNAL\",UPPER(G3))),ISNUMBER(SEARCH(\"LAMP\",UPPER(G3))),ISNUMBER(SEARCH(\"PASS\",UPPER(G3))),ISNUMBER(SEARCH(\"VALID DL\",UPPER(G3))),ISNUMBER(SEARCH(\"REG\",UPPER(G3))),ISNUMBER(SEARCH(\"SPEED\",UPPER(G3))),ISNUMBER(SEARCH(\"INS\",UPPER(G3))),ISNUMBER(SEARCH(\"EXHAUST\",UPPER(G3))),ISNUMBER(SEARCH(\"LIGHT\",UPPER(G3)))),\"Traffic\",IF(OR(ISNUMBER(SEARCH(\"OOP\",UPPER(G3))),ISNUMBER(SEARCH(\"BATT\",UPPER(G3))),ISNUMBER(SEARCH(\"BATTERY\",UPPER(G3))),ISNUMBER(SEARCH(\"BURGLARY\",UPPER(G3))),ISNUMBER(SEARCH(\"TRES\",UPPER(G3))),ISNUMBER(SEARCH(\"DISORDERLY\",UPPER(G3))),ISNUMBER(SEARCH(\"METH\",UPPER(G3))),ISNUMBER(SEARCH(\"CONT SUB\",UPPER(G3))),ISNUMBER(SEARCH(\"CANNABIS\",UPPER(G3)))),\"Criminal\",\"Other\"))","v":"Traffic"},{"$f":"IF(LEFT(UPPER(TRIM(J3)),6)=\"ARREST\",\"Arrest\",IF(LEFT(UPPER(TRIM(J3)),8)=\"CITATION\",\"Citation\",IF(UPPER(TRIM(J3))=\"REPORT FILED\",\"Report Filed\",IF(UPPER(TRIM(J3))=\"HANDLED BY WCSO\",\"Handled by WCSO\",TRIM(J3)))))","v":"Citation"},{"$f":"IF(COUNTIF($B:$B,B3)>1,1,0)","v":0}]
["Both","X251310022","2025-05-11","07:20:00","6th St / 23rd Ave","Fulton","No Valid DL","2025-05-11","Pidde, Guy","Citation","Both",1,1,"Traffic","Citation",0]
["BWC",2500169,"2025-07-05","13:56:00","1317 15th Ave","Fulton","Viol OOP","2025-07-05","Pearson, Tyler","Arrest","BWC",1,0,"Criminal","Arrest",0]
["Both",2500181,"2025-07-11","16:36:00","1317 15th Ave","Fulton","Vio OOP","2025-07-11","Pearson, Tyler","Arrest","Both",1,1,"Criminal","Arrest",0]
["Both",2500179,"2025-07-11","01:43:00","19200 Elston Rd","Fulton","Dom Batt","2025-07-11","Palmer, Richard","Arrest","Both",1,1,"Criminal","Arrest",0]
["Both",2500178,"2025-07-10","11:50:00","Waller Rd./ 14th Ave.","Fulton","DWLR","2025-07-10","Riojas, Tami","Arrest","Both",1,1,"Traffic","Arrest",0]
["Both",2500142,"2025-06-07","19:51:00","14th Ave / 10th St.","Fulton","DWLR/Illegal Trans/ex reg.","2025-06-07","Caldwell/ Macon/ Norwood","Arrest","Both",1,1,"Traffic","Arrest",0]
["Both",2500281,"2025-10-09","15:39:00","10th Ave / Waller Rd","Fulton","DUI/ Misc Traffic","2025-10-09","Green","Arrest","Both",1,1,"Traffic","Arrest",0]
["BWC",2500296,"2025-11-01","14:15:00","804 20th Ave Lot 19","Fulton","Disorderly Conduct","2025-11-01","Schneider, Emma","Arrest","BWC",1,0,"Criminal","Arrest",0]
["BWC",2500293,"2025-10-31","1:04PM","1301 11th Ave","Fulton","VOOP","2025-10-31","Love, Rebecca","Arrest","BWC",1,0,"Criminal","Arrest",1]
["Both",2500320,"2025-10-31","9:32PM","Waller Rd / Schaefer Rd","Fulton","Improper Pass Em Veh","2025-10-31","L'Heureux, Lindsi","Citation","Both",1,1,"Traffic","Citation",0]
["Both",2500295,"2025-11-01","2:33AM","14th Ave / 10th St.","Fulton","Reg. Lamp/ DUI","2025-11-01","DeWitt-Sprout","Arrest","Both",1,1,"Traffic","Arrest",0]
["Both",2500290,"2025-10-27","9:30PM","10th Ave / 6th St.","Fulton","DWLS/ Poss Cont Sub","2025-10-27","Grimes","Arrest","Both",1,1,"Traffic","Arrest",0]
["Both",2500308,"2025-11-13","5:13PM","1601 9th Ave","Fulton","Domestic Battery","2025-11-13","Schork","Arrest","Both",1,1,"Criminal","Arrest",0]
["Both",2500301,"2025-11-07","2:39AM","800 BLK 9th Ave","Fulton","DUI/ No Valid DL","2025-11-07","Hays","Arrest","Both",1,1,"Traffic","Arrest",1]
["Both",2500253,"2025-09-12","12:26AM","21st Ave./ Waller Rd","Fulton","DWLR/No Ins/ Disoby Stop","2025-09-12","Chavez","Arrest","Both",1,1,"Traffic","Arrest",0]
["Both",2500187,"2025-07-17","6:04PM","17th St. / Waller Rd","Fulton","DWLS/No Valid Reg/Ins","2025-07-17","Carreno","Arrest","Both",1,1,"Traffic","Arrest",0]
["Both",2500291,"2025-10-28","1:44AM","4th St./ 24th Ave.","Fulton","DWLS/Poss. Meth","2025-10-28","Goulden","Arrest","Both",1,1,"Traffic","Arrest",0]
["Both",2500300,"2025-11-07","12:36AM","13th St./ 16th Ave","Fulton","DWLS/ No Ins.","2025-11-07","Bielenberg","Arrest/ Parent","Both",1,1,"Traffic","Arrest",0]
["Both",2500292,"2025-10-29","3:22AM","Waller Rd./ 21 St. Ave.","Fulton ","DWLS/ Cannabis","2025-10-29","Martinolich","Arrest","Both",1,1,"Traffic","Arrest",0]
["BWC/ 2nd Send",2500293,"2025-10-31","1:05PM","809 20th Ave.","Fulton","Violation OP","2025-10-31","Love","Report Filed","BWC",1,0,"Other","Report Filed",1]
["BWC",2406807,"2024-07-13","6:32AM","2007 4th St","Fulton","Burglary","2024-07-13","Guzman","Handled by WCSO","BWC",1,0,"Criminal","Handled by WCSO",0]
["Both",2500274,"2025-10-03","6:26AM","Waller Rd and 136","Fulton","DWLS/No Ins/Speed","2025-10-03","Lopez","Arrest","Both",1,1,"Traffic","Arrest",0]
["Both",2500008,"2026-01-07","6:03PM","518 24th Ave Lot 23","Fulton","Criminal Tresspass","2026-01-07",true,"Arrest","Both",1,1,"Traffic","Arrest",0]
["Both",2500301,"2025-11-07","2:39AM","800 Blk 9th Ave","Fulton","DUI/No Valid DL","2025-11-07","Hays","Arrest","Both",1,1,"Traffic","Arrest",1]
["Both",2600040,"2026-02-08","2:00AM","100 Blk 14th Ave","Fulton","Fail to Yield/Disobey Stop Sign/Fail to Signal","2026-02-08","Covey","Citations","Both",1,1,"Traffic","Citation",0]
["Both",2600039,"2026-02-07","1:36AM","10th Ave/ 5th St.","Fulton","DUI/Fail to Signal/No Lights When Required","2026-02-07","Bruggenwirth","Arrest","Both",1,1,"Traffic","Arrest",0]
["Both",2600056,"2026-02-22","19:18:00","Waller /Holy","Fulton","DUI/Signal/Lane Use","2026-02-23","Ramirez","Arrest","Both",1,1,"Traffic","Arrest",0]
["Both",2600064,"2026-03-07","01:24:00","Waller/Clinton","Fulton","DUI","2026-03-07","Dauen","Arrest","Both",1,1,"Traffic","Arrest",0]
["Both",2600032,"2026-01-31","03:33:00","17th Ave / 4th St","Fulton","DUI","2026-01-31","Winter","Arrest","Both",1,1,"Traffic","Arrest",0]
["BWC",2600008,"2026-01-07","17:52:00","518 24th Ave Lot 23","Fulton","Crim Tres to Res","2026-01-07",true,"Arrest","BWC",1,0,"Criminal","Arrest",0]
["Both",2500342,"2025-12-31","22:00:00","Elston Rd / 19th Ave","Fulton","DUI","2025-12-31","Huling","Arrest","Both",1,1,"Traffic","Arrest",0]
["Both",2500049,"2025-03-03","16:47:00","633 E. Lincolnway Rd","Morrison","DUI / Assist O/A","2025-03-03","Meeks","Arrrest","Both",1,1,"Traffic","Arrrest",0]
["Both",2600047,"2026-02-17","15:21:00","19200 Elston Rd","Fulton","Domestic Battery","2025-02-17","Collalti","Arrest","Both",1,1,"Criminal","Arrest",0]
["Both",2600061,"2026-03-02","18:44:00","Waller Rd / 31st Ave","Fulton","DUI","2026-03-02","Bower","Arrest","Both",1,1,"Traffic","Arrest",0]
["Both",2600057,"2026-02-23","1:51AM","3rd St./ 14th Ave.","Fulton","DWLS/Backing/Exhaust","2026-02-23","Harris","Arrest ","Both",1,1,"Traffic","Arrest",0]
["Both",2500193,"2025-07-22","11:28PM","Clinton Rd. / Waller Rd","Fulton","DWLS/ Warrants","2025-07-22","Roberts","Arrest","Both",1,1,"Traffic","Arrest",0]
["Both",2600089,"2026-04-14","11:36PM","4th St/ 14th Ave","Fulton","DUI","2026-04-14","Everson","Arrest","Both",1,1,"Traffic","Arrest",0]
["Both",2600088,"2026-04-14","2:07AM","Clinton Rd. / Waller Rd","Fulton","DUI","2026-04-14","Songaila","Arrest","Both",1,1,"Traffic",{"$f":"IF(LEFT(UPPER(TRIM(J41)),6)=\"ARREST\",\"Arrest\",IF(LEFT(UPPER(TRIM(J41)),8)=\"CITATION\",\"Citation\",IF(UPPER(TRIM(J41))=\"REPORT FILED\",\"Report Filed\",IF(UPPER(TRIM(J41))=\"HANDLED BY WCSO\",\"Handled by WCSO\",TRIM(J41)))))","v":"Arrest"},0]