Download Excel File: Fiscal year 1968 through fiscal yearÌý2024. Updated annually in the fall after release of the Office of Contracts and Grants (OCG) annual report.Ìý
Data are shown:
- By "OCG unit," to match listings in OCG reports.
- With both awards (number and amount, from FY 1968 and on) and expenditures in the unit (from FY 1997 and on). OCG cautions that "the most accurate way to make year-to-year comparisons of data on research and other sponsored program activity is to look at actual expenditures." This is primarily because awards can be multiyear.
- By ODA Department.
- Awards are not shown in this, ONLY research expenditures
- ODA Dept is assigned from the sponsoring department ID of the research project
- Research expenditures in the unit since FY 2000 from the CIW dataset GL_BUDG_ACT_ENCUMB_LINES_BASE.
- And with expenditures allocated one department to another, for FY 2000 and later only, based on the tenure department of the PI of a project. Previous versions of this file were done with a gross approximation. Click here for more information on allocation methods and a comparison between the two calculations.
- See the tab 'Alloc_detail' for a summary of the most recent FY showing how expenditures are being allocated from one ODA Dept to another
- We are not able to match EXACTLY to the totals in the OCG unit (but within $500k for a given FY)
- With VC division, college, and A&S cluster shown for each unit in all listings
- By individual fiscal year
- And summarized over all fiscal years since 1968, the most recent five fiscal years, and most recent fiscal year
- In listings which can be further summarized or filtered
- And in pivot tables of two types: with school, college, cluster, and division results and for reconciling to OCG totals
- The file also includes definitions, and correspondence between OCG and ODA units.