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

 |  |  | Proposal/Routing # | 193107 |  |  |  | Summary Budget Information
 |  |  | Speedtype/Project # | 63019086 | 25A8074
 |  |  | PI | Deininger, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  | Sponsor | PhRMA Foundation
 |  |  | Award | AWD-193107
 |  |  | Current Budget Period: | 2019-08-01 00:00:00 | 2020-07-31 00:00:00
 |  |  | Project Period: | 2019-08-01 00:00:00 | 2021-07-31 00:00:00
 |  |  |  | Personnel | Fringe | Stipends | Supplies | Travel | Animals | Patients* | Tuition* | Insur/Fees* | Equipment* | Subcontract* | Direct | Indirect | Total
 |  |  | Award
 |  |  | Year 1
 |  |  | Year 2
 |  |  | Year 3
 |  |  | Year 4
 |  |  | Year 5
 |  |  | Total Award
 |  |  | Expenditures
 |  |  | Year 1
 |  |  | Year 2
 |  |  | Year 3
 |  |  | Year 4
 |  |  | Year 5
 |  |  | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Belong to the PSP [NAME] account!
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Portions of this belong to [NAME] account!
 |  |  | 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
 |  |  | Deininger, [NAME] | 0.806452653 |  |  |  |  | 2019-08-01 00:00:00 | 2020-07-31 00:00:00 |  | 0 | 261738
 |  |  | Total FTE Supported
 |  |  | 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
2020-08-01 00:00:00 |  |  | Actuals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Belongs to PSP account tab
 |  |  | 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