Map A to Z Index Search CU Home University of Colorado
 
  Strategic Planning Institutional Research and Analysis Campus Budget and Finances About PBA

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%).
    • See tab "Pivot summary"

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\

Last revision 10/24/12


PBA Home  |   Strategic Planning  |   Institutional Research & Analysis |  Budget & Finances  | 
Questions? Comments? |  Legal & Trademarks |  Privacy
15 UCB, University of Colorado Boulder, Boulder, CO 80309-0015, (303)492-8631
  © Regents of the University of Colorado