Grant Wrangling Tutorial

Grant Wrangling Tutorial

The Educational Modulefor Flight Tracker
In this module, you'll learn how to track and validate your scholars' grants through a process we call Grant Wrangling.

[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.

  • “Internal K” is any internal funding that is similar to a career development award. This might be called bridge funding at your institution. You’ll have to enter these via the custom grant form as they will not pull in from any of the sources Flight Tracker pulls grants data from.
  • KL2 or K12 are NIH mechanisms where a midcareer or senior faculty member is PI of the grant, and there are “slots” for individual scholars. Scholars are then appointed to these grants for varying amounts of time.
  • An individual K is any NIH K award, such as K08 or K23.
  • K equivalents are career development awards that aren’t from the NIH or your institution, so VA CDAs or foundation awards. They are automatically classed as K equivalents if the scholar has at least 50% effort on the grant and it lasts for at least two years.
  • R01s are NIH R01s, while
  • R01 equivalents are large awards similar to R01s. These might include MIRA R35s, U01s, VA Merit, American Cancer Society Research Scholar awards, and so on. Flight Tracker automatically classifies any award of at least $1,250,000 total direct budget as an R01 equivalent.

For reference, these definitions are at the top of the Summary form and each Custom Grant form.

  • Training appointments are for when scholars receive a position on a T32 or other “group” predoc/postdoc training grant
  • Research fellowships encompass both NIH F30-31-32 awards and foundation research fellowships. These are almost always for pre and postdocs.
  • The Mentoring/Training Grant Admin classification is used for K12s and T32s where the scholar is the PI, not just a scholar appointed to the grant, and for mid-career mentoring awards like the NIH K24 and K26.
  • K99/R00 awards aren’t entirely a K nor entirely an R01, so we call them bridge awards. F99/K00 awards also fit in this category.
  • Finally, the N/A category is for any other research grant that doesn’t meet the budget or length criteria for R01 equivalence, which can include R03s, R21s, and many foundation grants.

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.

Questions
Email the Edge team at info@edgeforscholars.org
upcoming Grant Wrangling Tutorial events [ view all events ]
December 7, 2026 | 1:00 pm (In-Person) Dr. Todd Edwards & Dr. Digna Velez Edwards | Room MCE 8380 B
Workshop
Mentoring
Mid career faculty
Senior faculty
January 14, 2027 | 12:00 pm (In-Person) Panel Discussion | Location TBA
EFS Seminar
Mentoring
Pre/Post Doc
Early career faculty
January 28, 2027 | 12:00 pm (Virtual) Dr. Stephany Duda and Dr. Alvin Jeffery
EFS Seminar
Productivity
Life Hacks
Pre/Post Doc
Early career faculty
January 29, 2027 | 9:00 am (In-Person) Student Life Center
Forum
Doing Research
Pre/Post Doc
Early career faculty
Mid career faculty
Senior faculty
February 4, 2027 | 12:00 pm (In-Person) Panel Discussion | Location TBA
EFS Seminar
Grants & Funding
Writing & Publishing
February 18, 2027 | 12:00 pm (Virtual) Dr. Alvin Jeffery
EFS Seminar
Faculty Life
Pre/Post Doc
Early career faculty
February 25, 2027 | 12:00 pm (Virtual) Dr. Evan Brittain
EFS Seminar
Faculty Life
Early career faculty
March 4, 2027 | 12:00 pm (Virtual) Dr. Antentor Hinton
EFS Seminar
Writing & Publishing
Pre/Post Doc
Early career faculty
Testimonials
Success

Assistant Professor

Department
Obstetrics & Gynecology, Division of Quantitative & Division of General Obstetrics
Award Type
  • K01 Recipient
Assistant Professor
Department
Health Policy/Pharmacoepidemiology
Award Type
  • R01
Dr. Myrick Shinall
Associate Professor
Department
Surgery and Medicine
Award Type
  • R01
EFS Programs Used

Assistant Professor

Department
Molecular Physiology and Biophysics
Award Type
  • R03
  • Breatkthrough T1D Your Way Innovation Award
EFS Programs Used



find out first