|
PBA Home >
Institutional Research & Analysis >
Faculty and Staff >
Research expenditures and awards by departments
University of Colorado Boulder
Sponsored research expenditures and awards by department, 1968 to present
Click here for the large Excel file that shows awards and
expenditures 1968 through fiscal year 2011-2012. It will be updated annually in the fall after release of the
Office of Contracts and Grants (OCG) annual report.
This report is updated in the fall with figures for the previous fiscal year (i.e. report released
in fall 2002 contains data from fiscal year 2001-2002).
Highlights with notes on query methods
- In fiscal year 2012, 13 PBA units had $10 million or more in sponsored research expenditures, accounting
together for $285 million of the total $393 million in expenditures (72%). Five of the 13 units are
institutes (CIRES, IBG, INSTAAR, JILA, and LASP), plus astrophysical and planetary sciences (APS), aerospace engineering,
chemistry, chemical engineering, ECEN, MCDB, and physics.
- See these results using the "top 10" data filter in the "PBA Depts summary" tab with
the measure "Exp. in unit, last FY"
- In the same year, 11 instructional PBA units had $3 million or more in sponsored research expenditures allocated from
non-instructional PBA units (i.e. institutes or administrative units) based on the tenure department of the principal
investigator (PI) on an individual project. These 11 units accounted for $136 million of the total $148 million in
allocated expenditures (92%). These 11 units are APS, atmospheric & oceanic sciences, chemistry, CVEN, geography, geology,
physics, psychology and sociology. Click here for more information on allocation methods.
- See these results using the "top 10" data filter in the "PBA Depts summary" tab with
the measure "Exp. allocated from institutes, last FY"
- 24 OCG units have had sponsored research activity in all 45 fiscal years since 1968
- "Top 10" data filter, "OCGunits summary", "Yrs w activity FY68+"
- Sponsored research expenditures over the last five fiscal years (2008-2012) have totaled over
one billion dollars ($1.65 billion). 93% of these have been in A&S natural science units (23%),
engineering units (16%), and the research institutes (54%).
Format of the Excel file
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 PBA Department.
- Awards are not shown in this, ONLY research expenditures
- PBA 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 PBA 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 PBA units.
CAUTION: The Excel file is quite large (405 kb). We recommend
downloading to your own machine if you intend to do additional queries or manipulations.
Also see sponsored research expenditures by the principal investigator's (PI) job category, code and title.
FY 2006-07 |
FY 2007-08 |
FY 2008-09 |
FY 2009-10 |
FY 2010-11
PBA: L:\datalib\Depts\Rsrch\
|
