Monthly PC Incident Reports

You will need access to ASWB Query DB

In the ASWB Query DB

1. On the left hand side scroll until you see Incident, double click

2. In the toolbar click on View

3. Change the exam date to the month range you are running the report for

   1. Between #03/01/2024# And #03/24/2024#

4. Remove the number for TestFacility

5. Click on the ! Run

6. When the data shows you will need to copy and paste into a blank/new spreadsheet

7. In the data you will need to click to the left of ACTNo

8. Once highlighted, right click on copy and the paste the data into the spreadsheet

9. Once you have pasted into the new spreadsheet

10. You will need to sort & filter the spreadsheet

11. You will then sort by name

12. Once sorted, delete row 1; and highlight from the first A name to the last K name

    1. Take note of the number that the last K name is on

13. You will enter the number from 12a; into the Quarterly spreadsheet under Incidents A-K

14. You will then go back to the spreadsheet, delete the A - K names

15. Highlight from the first L name to the last Z name

    1. Take note of the number that the last Z name is on

16. You will enter the number from 15a into the quarterly spreadsheet under Incidents L-Z

17. Once you have the data from the spreadsheet you can close, do not save the spreadsheet

The total number of incidents will automatically populate