[Note: This is a direct transcription of the video and as such may refer to items on screen at the time in the video.]
In this module, you’ll learn how to track and validate your scholars’ grants through a process we call Grant Wrangling.
Grant Wrangler allows you to update and correct information about individual grants, such as start and end dates, type of grant (such as career development award, R01 equivalent award, or training grant PI), and whether the grant actually belongs to that scholar. You can also choose which grants to use to define the story of a scholar’s career. These career-defining awards tell the “big story” of a scholar’s career trajectory.
To get to the Grant Wrangler, click the “Wrangle” menu and then click “Grant Wrangler.” If you have a scholar with a lot of grants, this may take several minutes to load.
You’ll see an individual scholar’s wrangler page. If the scholar has a lot of grants, this page can get very complex. This one is for Julie Bastarache, who has been a PI for many years. At the top of the page are some navigation tools and a timeline, which we’ll cover in detail later in this presentation.
After that, you’ll see individual boxes for each budget year of each of her grants. The colors map to individual types of grants, which we’ll also cover a little later.
Grants are in two columns. The left contains grants from any source, so this can include NIH RePORTER, a scholar answering a survey, you entering a custom grant, or institutional grant software, if you have that hooked up. You will need to review these for accuracy, as occasionally the information pulled in will be wrong or won’t make sense.
The right column displays auto-processed awards that you have adjusted.
We’re going to go through a single grant box in detail from top to bottom.
At the top is the PI name. Rarely, grants by the wrong person can be pulled in if the name is common; for example, you have two John Smiths at your institution. I call these “doppelgangers.” If the scholar’s first or last name is very short, it can also affect name matching. At Vanderbilt, I have a scholar named Jo, J-O, Wilson. Sometimes grants from a John Wilson get pulled in, because “John Wilson” contains all the letters in “Jo Wilson.”
This area tells you the role of the scholar on this grant. The options are PI or Co-PI; Grant Wrangler does not pull in grants where they are Co-Is. If you’ve hooked in to your institution’s grant software, you may also receive information on the percentage effort the scholar has on that grant.
This is the last time the information was downloaded from whichever source it came from. Flight Tracker defaults to updating once per week unless you change your settings.
This area includes the grant number and title. Each budget year will get its own box, so for a five-year grant like this one there will be five boxes. This is the first year of this grant, which you can tell by the -01A1 at the end of the grant number. The second year will have -02, the third -03, and so on.
These boxes are the project period and budget year start and end dates, both of which are editable in Grant Wrangler. The dates here indicate that this grant ran for six years, likely because it was a traditional five-year K with a no-cost extension for an additional year after. For federal grants, the budget box should almost always be only one year of the project period.
The dollar figures here are both total and direct costs for that budget year only, not the entire grant.
Moving further down, we have some other information about the grant in case you find it useful. Key here is that there’s a link to view the original record with information pulled from whichever source, or instrument, it came from.
Grant type information is used by several different processes in Flight Tracker, so it’s important to categorize these correctly. I’ll explain all these types of grants shortly.
At the bottom, there are two buttons you can click. “Don’t Use This” keeps the grant in their record, but does not include it in their career-defining grants, which are generally their career development award or awards and any R01 or equivalent grants. If the grant is flat wrong, like my Jo Wilson vs. John Wilson example from before, you can click “not their grant” to delete it.
We’ll take a minute to go through the types of grants as Flight Tracker defines them.
For reference, these definitions are at the top of the Summary form and each Custom Grant form.
Why does Flight Tracker ask you to put so much time into this classification? Because that information drives other processes in Flight Tracker. Any table that’s related to “career progression” only considers career development awards, R01s, R01 equivalents, and training grant admin awards, and leaves off all other grants. These can be found in several places, including under the Grants tab in Flight Tracker and in the Scholar Portal, as well as the timeline at the top of each scholar’s Grant Wrangler page. Be aware that this specific timeline is built using budget years rather than project periods, so if the scholar is currently in Year 3 of a five-year grant, the grant will only show up as three years on this one timeline.
All right, you’ve made your edits, classified the grant, and you’re ready to save your work. Simply drag the award to the right to enact the change. For multi-year grants, you only need to change one of the boxes, not all of them, to have the change propagate across all years.
Other things you can do in Grant Wrangler include:
Instead of having Flight Tracker automatically count Ks, R01s, and so on as career-defining grants according to its prebuilt algorithm, if you turn flags on you are entirely in control of which grants get counted as career-defining.
Here’s where you can remove incorrectly matched names.
You can navigate between scholars by using the dropdown or typing in a last name. You can also just go to the next record in the project.
Clicking “add new grant” will take you to a custom grant entry form.
“New Grants Only” leads to the process you’ll probably use the most. You can click this on any scholar’s Grant Wrangler page.
When you do, the page will reload to the first record in your project that’s had new grants added in the period you specify. Flight Tracker defaults to the last 60 days, but you can change this in the text box above the scholar’s name. When you’re viewing in this mode, only grants added during this period will show up on each scholar’s page.
A button called “view next new record” will also appear. When you click this, you’ll be taken to the next record with new grants in the time you specify.
Here are some best practices. When you add a new scholar, review their Grant Wrangler page to make sure everything is correct and add any doppelgangers to the exclusion list. Review new grants at least once every 60 days to ensure accuracy and prevent having to do a lot of work at once.
Assistant Professor

Assistant Professor