General Surgery Residency Data Repository
Home
Residents
Manage Residents
List Categorical Residents
List Active Residents
List All Residents
List Residents w/o a Faculty Adviser
List Advisers
Add Resident
Add Adviser
Faculty
Manage Faculty
List Active Faculty
List All Faculty
List Faculty w/o Advisees
Add Faculty
Add Adviser
Advisers
Manage Advisers
Add Adviser
Schedule
Manage Schedule
Milestones
Manage Milestones
Mock Oral
Manage Mock Oral Exams
ABSITE
Manage ABSITE Exams
Reports
Manage Semi-Annual Evaluations
Manage Case Reports
Manage SIMPL Reports
Prepare ACGME Caselogs
Prepare ACGME PGY II Reports
||
Login
Users
Current User's Profile
Search
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
Download the
General Surgery Year 2 Minimum
report
here
. 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.