Spreadsheet: 150630d1334628195-help-with-vlookup-or-if-statements-formula-test-1
Sheet: Sheet1

Fund | Level | FiscalYear | OfficeID | [NAME] | OrgID | Program | UnitDescr | BudgetType | Account | AcctType | AcctDescr | PrevActualAmt | PrevBudgetAmt | ActualAmt | FY 11-12 Base Budget | BaseAmt | RequestAmt | [NAME] | Pers Adjust | ApprovedAmt | ActualFTE | BaseFTE | [NAME] | OBFPFTE | ApprovedFTE | OfficeDescr
201010 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 611100 | P | EPA Administrative Salary | 208977.62 | 0 | 178640 |  | 178640 | 0 | -5000 |  |  | 3 | 3 | 0 | 0 | 3 | V/C Academic Affairs
201010 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 612100 | P | SPA Regular Salary | 78942.5 | 0 | 143197 |  | 143197 | 0 | 18574 | 261 |  | 11 | 11 | 0 | 0 | 11 | V/C Academic Affairs
201010 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 612700 | P | SPA Longevity Pay | 2041.3 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201010 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 613100 | P | EPA Academic Salary | 2685366.5 | 0 | 3057198 |  | 1286711 | 0 | -33172 | -12000 |  | 39.64 | 39.64 | 0 | 0 | 39.64 | V/C Academic Affairs
201010 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 613400 | P | EPA Teaching Employee On Loan | 8750 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201010 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 614100 | P | Temporary | 0 | 0 | 78000 |  | 78000 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201010 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 618100 | B | Social Security | 223718.07 | 0 | 264464 |  | 129021 | 0 | -1499 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201010 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 618200 | B | State Retirement | 119141.9 | 0 | 355136 |  | 169058 | 0 | -2060 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201010 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 618300 | P | Medical Insurance | 138242.37 | 0 | 163545 |  | 77854 | 0 | -949 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201010 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 618700 | P | TIAA Optional Retirement | 80101.06 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201010 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 715920 | O | Employee Recognition Award | 0 | 0 | 10000 |  | 10000 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201010 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 72000P | O | Supplies | 22258.08 | 0 | 95000 |  | 95000 | 0 | -39766 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201010 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 73100P | O | Purchase Services | 99753.44 | 0 | 114090 |  | 114090 | 0 | -18574 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201010 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 73900P | O | Contract Services | 63441.13 | 0 | 307321 |  | 199324 | 0 | -25307 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201010 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 74000P | O | Fixed Charges | 31221.07 | 0 | 19000 |  | 19000 | 0 | -19000 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201010 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 74600P | O | Non-Library Expenses | 16733.08 | 0 | 200000 |  | 200000 | 0 | -151926 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201010 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC/Provost Academic Affairs | S | 75000P | O | Property Plant & Equipment | 181021.55 | 0 | 10050 |  | 10050 | 0 | -10000 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201019 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC Academic Affairs Reserve | S | 613100 | P | EPA Academic Salary | 10000.02 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201019 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC Academic Affairs Reserve | S | 618100 | B | Social Security | 753.25 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201019 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC Academic Affairs Reserve | S | 618200 | B | State Retirement | 1051.02 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201019 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC Academic Affairs Reserve | S | 618300 | P | Medical Insurance | 532.56 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201019 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC Academic Affairs Reserve | S | 72000P | O | Supplies | 5719.54 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201019 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC Academic Affairs Reserve | S | 73100P | O | Purchase Services | 2324.06 | 0 | 195037 |  | 195037 | 0 | -59858 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201019 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC Academic Affairs Reserve | S | 73900P | O | Contract Services | 1659 | 0 | 107550 |  | 107550 | 0 | -49000 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201019 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC Academic Affairs Reserve | S | 75000P | O | Property Plant & Equipment | 1196.77 | 0 | 67626 |  | 67626 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201019 | 4 | 2013 | 10 | 1A | 10034 | 101 | VC Academic Affairs Reserve | S | 76910P | O | Stipends | 20870 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201050 | 4 | 2013 | 10 | 1A | 10034 | 101 | Faculty Recuriting | S | 73100P | O | Purchase Services | 49672.11 | 0 | 115500 |  | 115500 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201054 | 4 | 2013 | 10 | 1A | 10034 | 101 | Accreditation | S | 72000P | O | Supplies | 1813.54 | 0 | 45500 |  | 45500 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201054 | 4 | 2013 | 10 | 1A | 10034 | 101 | Accreditation | S | 73100P | O | Purchase Services | 22071.18 | 0 | 64500 |  | 64500 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201054 | 4 | 2013 | 10 | 1A | 10034 | 101 | Accreditation | S | 73900P | O | Contract Services | 4600 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201054 | 4 | 2013 | 10 | 1A | 10034 | 101 | Accreditation | S | 74600P | O | Non-Library Expenses | 54696 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201054 | 4 | 2013 | 10 | 1A | 10034 | 101 | Accreditation | S | 75000P | O | Property Plant & Equipment | 2324 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | V/C Academic Affairs
201070 | 4 | 2013 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 611100 | P | EPA Administrative Salary | 46789.59 | 0 | 0 |  | 0 | 0 | 0 |  |  | 1 | 1 | 0 | 0 | 1 | Chancellor
201070 | 4 | 2013 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 611310 | P | EPA Premiumn Payment | 294.89 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Chancellor
201070 | 4 | 2013 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 612100 | P | SPA Regular Salary | 471771.88 | 0 | 595186 |  | 595186 | 0 | 121770 |  |  | 7 | 7 | 0 | 0 | 7 | Chancellor
201070 | 4 | 2013 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 612200 | P | SPA Overtime Payments | 284.48 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Chancellor
201070 | 4 | 2013 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 612700 | P | SPA Longevity Pay | 1366 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Chancellor
201070 | 4 | 2013 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 613100 | P | EPA Academic Salary | 3500 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Chancellor
201070 | 4 | 2013 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 614100 | P | Temporary | 64087.3 | 0 | 51465 |  | 51465 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Chancellor
201070 | 4 | 2013 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 614500 | P | Student Work Aid | 77859.6 | 0 | 80143 |  | 80143 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Chancellor
201070 | 4 | 2013 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 618100 | B | Social Security | 42777.48 | 0 | 55600 |  | 55600 | 0 | 9315 |  |  | 0 | 0 | 0 | 0 | 0 | Chancellor
201070 | 4 | 2013 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 618200 | B | State Retirement | 54123.54 | 0 | 62554 |  | 62554 | 0 | 12798 |  |  | 0 | 0 | 0 | 0 | 0 | Chancellor
201070 | 4 | 2013 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 618300 | P | Medical Insurance | 50117.6 | 0 | 28807 |  | 28807 | 0 | 5894 |  |  | 0 | 0 | 0 | 0 | 0 | Chancellor
201070 | 4 | 2013 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 72000P | O | Supplies | 10844.06 | 0 | 26299 |  | 26299 | 0 | 199275 |  |  | 0 | 0 | 0 | 0 | 0 | Chancellor
201070 | 4 | 2013 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 73100P | O | Purchase Services | 9581.37 | 0 | 28630 |  | 28630 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Chancellor
201070 | 4 | 2013 | 01 | 0I | 01600 | 101 | Education-Technology Fee | S | 73900P | O | Contract Services | 29995.79 | 0 | 29416 |  | 29416 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Chancellor