WEEKLY RAPE CASES WITH WARRANT OF ARREST (Covering Period: WEDNESDAY TO THURSDAY)

STEP 1: GENERATE FROM JANUARY 2021 TO PRESENT. STEP 2: CLICK SORT AND FILTER STEP 3: CLICK SORT A TO Z.

STEP 4: FILTER STAGES OF FELONY, CHOOSE CONSUMATED STEP 5: FILTER OFFENSE, SEARCH "RAPE" AND THEN PRESS "OK" STEP 6: FILTER CASE STATUS SELECT "CLEARED".

STEP 7: CHECK "SUSPECTS Status", IT SHOULD ONLY BE "AT-LARGE" IF THERE IS "ARRESTED / ON BAIL / RELEASED" KINDLY ASK THE CONCERN STATION TO CHANGE OR UPDATE THEIR CIRAS BEFORE YOU CONTINUE WITH THE WEEKLY COMPLIANCE..

STEP 8: AFTER STEP 1 TO 7 PROCEED TO WEEKLY RAPE CASES WITH WARRANT OF ARREST EXCEL FORMAT. STEP 9: INSERT A COLUMN BESIDE THE "SUSPECT'S NAME" (WHEREVER YOU PREFER TO INSERT A COLUMN).

STEP 10: GO BACK TO YOUR GENERATED CIRAS AND COPY THE "SUSPECTS Name" AND PASTE IN THE COLUMN YOU INSERTED ON THE WEEKLY RAPE CASES WITH WARRANT OF ARREST EXCEL FORMAT..

STEP 11: HIGHLIGHT BOTH SUSPECTS NAME (REMEMBER THE SIDE WHERE YOU PASTE THE CURRENT SUSPECTS NAME VS LAST WEEK).

STEP 12: AFTER YOU HIGHLIGHTED BOTH COLUMN GO TO TAB "HOME" LOOK AND CLICK "CONDITIONAL FORMATTING" AND THEN CLICK "HIGHLIGHT CELLS RULES" AND CLICK "DUPLICATE VALUES" THEN CLICK "OK".

STEP 13: COUNT THE UNHIGHLIGHTENED NAME COLUMN ON "SUSPECTS NAME" LAST WEEK COLUMN, THEN REMEMBER THE FIGURE YOU WILL GET..

STEP 14: GO TO THE FIRST SHEET OF THE WEEKLY RAPE CASES WITH WARRANT OF ARREST EXCEL FORMAT"AS OF AUGUST 3, 2023" OR "DISPOSITION OF RAPE CASES " IN HERE, YOU ADD TO THE COLUMN "NR OF WOA SERVED" AND "NR ACCUSED ARRESTED" THE FIGURE YOU COUNT ON STEP 13..

STEP 15: GO BACK TO THE CURRENT SHEET AND COUNT ALL ROW THAT HAVE A CRIMINAL CASE (CC) NR / "WITH WOA (CC NR)" (REMOVE "TF" / "TO FOLLOW" / DOCKET NR)..

STEP 16: AFTER COUNTING ALL THE CC NR GO BACK TO THE FIRST SHEET OF THE WEEKLY RAPE CASES WITH WARRANT OF ARREST EXCEL FORMAT"AS OF AUGUST 3, 2023" OR "DISPOSITION OF RAPE CASES " IN HERE, YOU WILL TYPE TO THE COLUMN "NR OF ISSUED WOA" THE NUMBER YOUVE COME UP / COUNT ON STEP 15..

STEP 17: UPDATE THE Covered Period ON THE FIRST SHEET. AND THEN FINISH..