General Surgery Residency Data Repository
List Categorical Residents
List Active Residents
List All Residents
List Residents w/o a Faculty Adviser
List Resident Mentors
Add Resident Mentor
List Active Faculty
List All Faculty
List Faculty w/o Advisees
Manage Mock Oral Exams
Manage ABSITE Exams
Manage Semi-Annual Evaluations
Manage Case Reports
Manage SIMPL Reports
Prepare ACGME Caselogs
Prepare ACGME PGY II Reports
Current User's Profile
Prepare PGY II CSV File
This gives you a quick description how to create the CSV file to use for the csv:create:Pgy2cases command
General Surgery Year 2 Minimum
. Use the Excel format, pick the residents you are interested in and use the aggregate layout.
Open the downloaded Excel file.
"Unhide" and "unmerge" the whole worksheet.
Delete all rows above the header row.
Delete rows with content below the last row with case data.
Delete the empty columns within the data and the 'Total' column (total numbers are calculated by the app).
Fix the headers:
Change 'Category Minimums' to 'Resident'.
Remove the number '200' from 'Defined Category Procedures & Vascular Exposure Codes'.
Remove the number '0' from 'Additional Procedures'.
Finally, save the worksheet as a plain csv file.
You are now ready to use this csv file for the csv:create:pgy2cases command.