Spreadsheet: 150603d1334615799-help-with-vlookup-or-if-statements-formula-test-2
Sheet: Sheet1

FundID | Level | FiscalYear | OfficeID | [NAME] | OrgID | Program | UnitDescr | BudgetType | Account | AcctType | AcctDescr | PrevActualAmt | PrevBudgetAmt | FY 10-11 | Benefits Adjustments | BaseAmt | RequestAmt | [NAME] | Budget Reduction | ApprovedAmt | ActualFTE
201010 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 611100 | P | EPA Administrative Salary | 165807.62 | 0 | 184324 |  | 184324 | 0 | -5684 | 0 |  | 3
201010 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 612100 | P | SPA Regular Salary | 60470.99 | 0 | 217748 |  | 217748 | 0 | -74551 |  |  | 11
201010 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 613100 | P | EPA Academic Salary | 1842913.09 | 0 | 1522017 |  | 1522017 | 516350 | 1018831 | -1770487 |  | 39.64
201010 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 613400 | P | EPA Teaching Employee On Loan | 8750 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
201010 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 614100 | P | Temporary | 0 | 0 | 78000 |  | 78000 | 0 | 0 |  |  | 0
201010 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 618100 | B | Social Security | 155636.58 | 0 | 147193 |  | 153160 | 39501 | 71803 | -135443 |  | 0
201010 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 618200 | B | State Retirement | 79319.65 | 0 | 168357 |  | 202222 | 54268 | 98646 | -179705 |  | 0
201010 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 618300 | P | Medical Insurance | 110484.67 | 0 | 69267 |  | 93126 | 24991 | 45428 | -163545 |  | 0
201010 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 618700 | P | TIAA Optional Retirement | 66798.56 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
201010 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 715920 | O | Employee Recognition Award | 0 | 0 | 10000 |  | 10000 | 0 | 0 |  |  | 0
201010 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 72000P | O | Supplies | 14700.41 | 0 | 20000 |  | 20000 | 0 | 75000 |  |  | 0
201010 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 73100P | O | Purchase Services | 57817.5 | 0 | 92770 |  | 92770 | 0 | 21320 |  |  | 0
201010 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 73900P | O | Contract Services | 29581.91 | 0 | 394800 |  | 394800 | 0 | -87479 | -107997 |  | 0
201010 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 74000P | O | Fixed Charges | 27976.58 | 0 | 25000 |  | 25000 | 0 | -6000 |  |  | 0
201010 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 74600P | O | Non-Library Expenses | 10104.08 | 0 | 200000 |  | 200000 | 0 | 0 |  |  | 0
201010 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 75000P | O | Property Plant & Equipment | 161960.14 | 0 | 25000 |  | 25000 | 0 | -14950 |  |  | 0
201019 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC Academic Affairs Reserve | S | 613100 | P | EPA Academic Salary | 10000.02 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
201019 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC Academic Affairs Reserve | S | 618100 | B | Social Security | 753.25 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
201019 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC Academic Affairs Reserve | S | 618200 | B | State Retirement | 1051.02 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
201019 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC Academic Affairs Reserve | S | 618300 | P | Medical Insurance | 532.56 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
201019 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC Academic Affairs Reserve | S | 73100P | O | Purchase Services | 0 | 0 | 0 |  | 0 | 0 | 195037 |  |  | 0
201019 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC Academic Affairs Reserve | S | 73900P | O | Contract Services | 0 | 0 | 0 |  | 0 | 0 | 107550 |  |  | 0
201019 | 4 | 2012 | 10 | 1A | 10034 | 101 | VC Academic Affairs Reserve | S | 75000P | O | Property Plant & Equipment | 0 | 0 | 0 |  | 0 | 0 | 67626 |  |  | 0
201050 | 4 | 2012 | 10 | 1A | 10034 | 101 | Faculty Recuriting | S | 73100P | O | Purchase Services | 39243.4 | 0 | 115500 |  | 115500 | 0 | 0 |  |  | 0
201054 | 4 | 2012 | 10 | 1A | 10034 | 101 | Accreditation | S | 72000P | O | Supplies | 834.97 | 0 | 45500 |  | 45500 | 0 | 0 |  |  | 0
201054 | 4 | 2012 | 10 | 1A | 10034 | 101 | Accreditation | S | 73100P | O | Purchase Services | 20829.6 | 0 | 64500 |  | 64500 | 0 | 0 |  |  | 0
201054 | 4 | 2012 | 10 | 1A | 10034 | 101 | Accreditation | S | 73900P | O | Contract Services | 4600 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
201054 | 4 | 2012 | 10 | 1A | 10034 | 101 | Accreditation | S | 74600P | O | Non-Library Expenses | 53697 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
201054 | 4 | 2012 | 10 | 1A | 10034 | 101 | Accreditation | S | 75000P | O | Property Plant & Equipment | 884 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
201070 | 4 | 2012 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 611100 | P | EPA Administrative Salary | 24167.24 | 0 | 50000 |  | 50000 | 0 | -50000 |  |  | 1
201070 | 4 | 2012 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 612100 | P | SPA Regular Salary | 343975.39 | 0 | 544749 |  | 544749 | 0 | 50437 |  |  | 7
201070 | 4 | 2012 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 612200 | P | SPA Overtime Payments | 284.48 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
201070 | 4 | 2012 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 612700 | P | SPA Longevity Pay | 1366 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
201070 | 4 | 2012 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 613100 | P | EPA Academic Salary | 3500 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
201070 | 4 | 2012 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 614100 | P | Temporary | 61953.7 | 0 | 70971 |  | 70971 | 0 | -19506 |  |  | 0
201070 | 4 | 2012 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 614500 | P | Student Work Aid | 64614.6 | 0 | 80143 |  | 80143 | 0 | 0 |  |  | 0
201070 | 4 | 2012 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 618100 | B | Social Security | 31768.33 | 0 | 45498 |  | 57059 | 0 | -1459 |  |  | 0
201070 | 4 | 2012 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 618200 | B | State Retirement | 38677.68 | 0 | 52041 |  | 62508 | 0 | 46 |  |  | 0
201070 | 4 | 2012 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 618300 | P | Medical Insurance | 36561.2 | 0 | 21411 |  | 28786 | 0 | 21 |  |  | 0
201070 | 4 | 2012 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 72000P | O | Supplies | 7412.35 | 0 | 26299 |  | 26299 | 0 | 0 |  |  | 0
201070 | 4 | 2012 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 73100P | O | Purchase Services | 2490.33 | 0 | 28630 |  | 28630 | 0 | 0 |  |  | 0
201070 | 4 | 2012 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 73900P | O | Contract Services | 1872 | 0 | 29416 |  | 29416 | 0 | 0 |  |  | 0
201070 | 4 | 2012 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 74000P | O | Fixed Charges | 100665.21 | 0 | 74111 |  | 74111 | 0 | 0 |  |  | 0
201070 | 4 | 2012 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 75000P | O | Property Plant & Equipment | 176621.42 | 0 | 177733 |  | 177733 | 0 | 88253 |  |  | 0
201071 | 4 | 2012 | 10 | 1A | 10034 | 101 | Educational Tech Other | S | 611100 | P | EPA Administrative Salary | 19165.4 | 0 | 0 |  | 0 | 0 | 121770 |  |  | 0
201071 | 4 | 2012 | 10 | 1A | 10034 | 101 | Educational Tech Other | S | 618100 | B | Social Security | 1463.68 | 0 | 0 |  | 0 | 0 | 9315 |  |  | 0