Spreadsheet: 691632d1597793489-pulling-specific-account-data-from-one-large-data-sheet-book1
Sheet: FacAward

 |  |  | Proposal/Routing # | N/A |  |  |  | Summary Budget Information
 |  |  | Speedtype/Project # | 62068738
 |  |  | PI | Aquilante |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  | Sponsor | Internal
 |  |  | Award | Auxilary Enterprises
 |  |  | Current Budget Period: | 2020-07-01 00:00:00 | 2021-06-30 00:00:00
 |  |  | Project Period: | 2013-07-01 00:00:00 | 2023-06-30 00:00:00
 |  |  |  | Personnel | Fringe | Stipends | Supplies | Travel | Animals | Patients* | Tuition* | Insur/Fees* | Equipment* | Subcontract* | Direct | Indirect | Total
 |  |  | Award
 |  |  | Year 1
 |  |  | Expenditures
 |  |  | Year 1
 |  |  | Year 2
 |  |  | Year 3
 |  |  | Year 4
 |  |  | Year 5
 |  |  | Year 6
 |  |  | Year 7
 |  |  | Year 8
 |  |  | Year 9
 |  |  | Year 10
 |  |  | Year 11
 |  |  | Year 12
 |  |  | Year 13
 |  |  | Year 14
 |  |  | Total Expenditures
 |  |  | Available
 |  |  | Year 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Total | Grand
Date | Fiscal Mon | Fiscal YR |  | Personnel | Fringe | Stipends | Supplies | Travel | Animals | Patients* | Tuition* | Insur/Fees* | Equipment* | Subcontract* | Direct | Indirect | Total
 |  |  | Actuals
 |  |  | Encumbrances
 |  |  | Current Award
 |  |  | Expenditures
 |  |  | Current Balance
 |  |  | Projected Exp.
 |  |  | [NAME].
 |  |  | Name | Percent | Monthly |  | Monthly | Monthly | Effective | Effective
 |  |  |  | Recovery | Salary |  | Fringe | Total | Beginning | Until | Salary | Fringe | Empl ID
 |  |  | Year 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Total | Grand
Date | Fiscal Mon | Fiscal YR |  | Personnel | Fringe | Stipends | Supplies | Travel | Animals | Patients* | Tuition* | Insur/Fees* | Equipment* | Subcontract* | Direct | Indirect | Total
 |  |  | Actuals
 |  |  | Encumbrances
 |  |  | Current Award
 |  |  | Expenditures
 |  |  | Current Balance
 |  |  | Projected Exp.
 |  |  | [NAME].
 |  |  | Name | Percent | Monthly |  | Monthly | Monthly | Effective | Effective
 |  |  |  | Recovery | Salary |  | Fringe | Total | Beginning | Until | Salary | Fringe | Empl ID
 |  |  | Year 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Total | Grand
Date | Fiscal Mon | Fiscal YR |  | Personnel | Fringe | Stipends | Supplies | Travel | Animals | Patients* | Tuition* | Insur/Fees* | Equipment* | Subcontract* | Direct | Indirect | Total
 |  |  | Actuals
 |  |  | Encumbrances
 |  |  | Current Award
 |  |  | Expenditures
 |  |  | Current Balance
 |  |  | Projected Exp.
 |  |  | [NAME].
 |  |  | Name | Percent | Monthly |  | Monthly | Monthly | Effective | Effective
 |  |  |  | Recovery | Salary |  | Fringe | Total | Beginning | Until | Salary | Fringe | Empl ID
 |  |  | Year 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Total | Grand
Date | Fiscal Mon | Fiscal YR |  | Personnel | Fringe | Stipends | Supplies | Travel | Animals | Patients* | Tuition* | Insur/Fees* | Equipment* | Subcontract* | Direct | Indirect | Total
 |  |  | Actuals
 |  |  | Encumbrances
 |  |  | Current Award
 |  |  | Expenditures
 |  |  | Current Balance
 |  |  | Projected Exp.
 |  |  | [NAME].
 |  |  | Name | Percent | Monthly |  | Monthly | Monthly | Effective | Effective
 |  |  |  | Recovery | Salary |  | Fringe | Total | Beginning | Until | Salary | Fringe | Empl ID
 |  |  | Year 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Total | Grand
Date | Fiscal Mon | Fiscal YR |  | Personnel | Fringe | Stipends | Supplies | Travel | Animals | Patients* | Tuition* | Insur/Fees* | Equipment* | Subcontract* | Direct | Indirect | Total
 |  |  | Actuals
 |  |  | Encumbrances
 |  |  | Current Award
 |  |  | Expenditures
 |  |  | Current Balance
 |  |  | Projected Exp.
 |  |  | [NAME].
 |  |  | Name | Percent | Monthly |  | Monthly | Monthly | Effective | Effective
 |  |  |  | Recovery | Salary |  | Fringe | Total | Beginning | Until | Salary | Fringe | Empl ID
 |  |  | Year 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Total | Grand
Date | Fiscal Mon | Fiscal YR |  | Personnel | Fringe | Stipends | Supplies | Travel | Animals | Patients* | Tuition* | Insur/Fees* | Equipment* | Subcontract* | Direct | Indirect | Total
 |  |  | Actuals
 |  |  | Encumbrances
 |  |  | Current Award
 |  |  | Expenditures
 |  |  | Current Balance
 |  |  | Projected Exp.
 |  |  | [NAME].
 |  |  | Name | Percent | Monthly |  | Monthly | Monthly | Effective | Effective
 |  |  |  | Recovery | Salary |  | Fringe | Total | Beginning | Until | Salary | Fringe | Empl ID
 |  |  | Year 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Total | Grand
Date | Fiscal Mon | Fiscal YR |  | Personnel | Fringe | Stipends | Supplies | Travel | Animals | Patients* | Tuition* | Insur/Fees* | Equipment* | Subcontract* | Direct | Indirect | Total
 |  |  | Actuals
 |  |  | Encumbrances
 |  |  | Current Award
 |  |  | Expenditures
 |  |  | Current Balance
 |  |  | Projected Exp.
 |  |  | [NAME].
 |  |  | Name | Percent | Monthly |  | Monthly | Monthly | Effective | Effective
 |  |  |  | Recovery | Salary |  | Fringe | Total | Beginning | Until | Salary | Fringe | Empl ID
 |  |  | Year 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Total | Grand
Date | Fiscal Mon | Fiscal YR |  | Personnel | Fringe | Stipends | Supplies | Travel | Animals | Patients* | Tuition* | Insur/Fees* | Equipment* | Subcontract* | Direct | Indirect | Total
 |  |  | Actuals
 |  |  | Encumbrances
 |  |  | Current Award
 |  |  | Expenditures
 |  |  | Current Balance
 |  |  | Projected Exp.
 |  |  | [NAME].
 |  |  | Name | Percent | Monthly |  | Monthly | Monthly | Effective | Effective
 |  |  |  | Recovery | Salary |  | Fringe | Total | Beginning | Until | Salary | Fringe | Empl ID