Seat Capacity

PSI sends file (Channel report)

• Save Channel report to C:\Users\adewald\OneDrive - ASWB\Exam Admin - General\CSC Info\PSI\PSI Seat Capacity\PSI Weekly Sent Reports

• Use “Site_Utilization” tab

• Sort by state & separate each state by adding row highlighted in yellow

• Highlight closed locations or duplicate locations in red.

  • Remove any numerical data in these rows.

• Add “Seats Available” for each state.

  • Do this for 3 months' worth of data.

• Add “Seats Offered” for each state.

  • Do this for 3 months' worth of data.

Log Available seats and offered seats into “PSI Seat Capacity Monthly Percentages USA.”

• Open Excel sheet to track data.

  • Located here: C:\Users\adewald\OneDrive - ASWB\Exam Admin - General\CSC Info\PSI\PSI Seat Capacity

• Create new Tab and title it with the date of the report.

  • Copy and paste the last tab’s report and remove the numerical data from the first 3 columns.

• Update the date in the column heading and the months if necessary.

• Log the added data from the Channel List to the correct column, this will auto generate the percentages.

• If percentage is below 50% highlight in red