Spreadsheet for assistant professors

Tenure & Promotion Dossier Tracker

Most tenure anxiety comes from not knowing where you stand. This keeps the five parts of the dossier in one file and compares each against the target you set, and against where an even pace would put you today.

How it works

Your clock and your targets

Enter your start date, your dossier date and your department's expectations: journal articles, top-tier articles, lead-authored work, funding as PI, courses, evaluations, service and students. No institution's standards are built in; you set them from your handbook and your annual-review letters.

Five logs

Publications (venue, tier, your author position, student coauthors, citations), grants (role, amount, your share), teaching (course, enrollment, evaluation as a share of the scale), service (level and hours) and mentoring (chair or committee). Only items dated after your start date count.

Dashboard

Each target beside what you have and what an even pace predicts by today. "Behind pace" means below the pro-rated share, not failing: at half the clock, four of eight articles is on pace. A bar chart shows the share of each target reached.

Timeline

Third-year review, dossier and external-letter dates with the days remaining, flagged as they get close.

What you get: one .xlsx workbook with nine tabs (Start Here, Dashboard, Settings, Publications, Grants, Teaching, Service, Mentoring, Timeline), with one fictional example on each log. It tracks progress; it does not predict a tenure decision.

Excel or Google Sheets

Open the .xlsx in Excel as it is. For Google Sheets, choose File, Import, Upload, and pick "Replace spreadsheet"; the formulas, dropdowns and colour flags come across. It also comes in the researcher bundle in a six-spreadsheet bundle for $39, along with the other trackers and the Grant Budget Builder.

Buy the spreadsheet, $12 All spreadsheets