Spreadsheet: 180147d1347490113-formula-to-calculate-value-based-on-current-cell-and-all-data-above-12-13-budget-test
Sheet: NSD Orders

Req # & T# | Purchase Order/ Document Type | SPO | Vendor/Faculty | Date | Change Order # | Dept. | Account # | Account  Code | Program Code | Expended | Transfers | SPO  Running Balance | Comments
26144 | APPROP |  | Studica | 2012-07-01 00:00:00 |  | PENG | 17800 - 301010 | 441000 | 000000 |  | -3730
26144 | APPROP |  | Studica | 2012-07-01 00:00:00 |  | PENG | 17800 - 301010 | 584000 | Other |  | 3730 |  | 090100
25702 |  |  | Ocean Institute | 2012-07-10 00:00:00 |  | BIOL | SPECIAL FUND | 589010 | Other | 1400 |  |  | 040100
25813 | 24945 | X | Lowes | 2012-07-11 00:00:00 |  | NSD | 11000 - 301010 | 451000 | 601000 | 2000
25810 | 24708 | X | Office Solutions | 2012-07-11 00:00:00 |  | NSD | 11000 - 301010 | 451000 | 601000 | 2500
25888 | 24963 | X | Grainger | 2012-07-12 00:00:00 |  | NSD | 11000 - 301010 | 451000 | 601000 | 1500
25810 | 24708 | X | Office Solutions | 2012-07-12 00:00:00 |  | NSD |  |  |  | -179.99 |  |  | W1198065
25810 | 24708 | X | Office Solutions | 2012-07-16 00:00:00 |  | NSD |  |  |  | -185.9 |  |  | W1198503
25946 | 25062 | X | Radio Shack | 2012-07-17 00:00:00 |  | ESA | 11000 - 301010 | 431000 | Other | 200 |  |  | 191400
25946 | APPROP |  | Radio Shack | 2012-07-17 00:00:00 |  | ESA | 11000 - 301010 | 431000 | 601000 |  | -200
25946 | APPROP |  | Radio Shack | 2012-07-17 00:00:00 |  | ESA | 11000 - 301010 | 431000 | Other |  | 200 |  | 191400
26093 | 25145 | X | Konica | 2012-07-25 00:00:00 |  | NSD | 11000 - 301030 | 564500 | 601000 | 1400
26094 | APPROP |  | Konica | 2012-07-25 00:00:00 |  | NSD | 11000 - 301010 | 643700 | 601000 |  | 3605 |  | Transfer from Chem and Biology
26094 | 25623 |  | Konica | 2012-07-25 00:00:00 |  | NSD | 11000 - 301010 | 643700 | 601000 | 3604.67
26094 | APPROP |  | Konica | 2012-07-25 00:00:00 |  | NSD | 11000 - 301030 | 564500 | 601000 |  | -19
26144 | 25019 |  | Studica | 2012-07-30 00:00:00 |  | PENG | 17800 - 301010 | 584000 | Other
25810 | 24708 | X | Office Solutions | 2012-07-30 00:00:00 |  | NSD |  |  |  | -208.05 |  |  | [NAME]
26193 | 25214 |  | Grainger | 2012-07-31 00:00:00 |  | NSD | 11000 - 301010 | 641200 | 601000 | 308.37 |  |  | Cancelled
26193 | APPROP |  | Grainger | 2012-07-31 00:00:00 |  | NSD | 11000 - 301010 | 451000 | 601000 |  | -309
26193 | APPROP |  | Grainger | 2012-07-31 00:00:00 |  | NSD | 11000 - 301010 | 641200 | 601000 |  | 309
- | Revolving |  | [NAME] | 2012-07-31 00:00:00 |  | NSD | 11000 - 301010 | 451000 | 601000 | 16.27
- | INVOICE |  | Verizon Wireless | 2012-07-31 00:00:00 |  | NSD | 11000 - 301020 | 554500 | 601000 | 95.17 |  |  | M.Pawlak Cell
25810 | 24708 | X | Office Solutions | 2012-08-01 00:00:00 |  | NSD |  |  |  | -242.84 |  |  | W1201571
 | CONF/P |  | [NAME], [NAME] | 2012-08-22 00:00:00 |  | BIOL | 11000 - 301010 | 525000 | Other | 200 |  |  | 040100
 | APPROP |  | [NAME] | 2012-08-28 00:00:00 |  | AG | 11000 - 301010 | 525000 | 000000 |  | -400 |  | 010900
 | CONF/P |  | [NAME] | 2012-09-18 00:00:00 |  | AG | 11000 - 301010 | 525000 | Other | 400 |  |  | 010900
26275 | APPROP |  | Target | 2012-08-07 00:00:00 |  | NSD | 11000 - 301010 | 451000 | 601000 |  | -100
26275 | APPROP |  | Target | 2012-08-07 00:00:00 |  | NSD | 11000 - 301010 | 471000 | 601000 |  | 100
26275 | 25301 | X | Target | 2012-08-07 00:00:00 |  | NSD | 11000 - 301010 | 471000 | 601000 | 100
25810 | 24708 | X | Office Solutions | 2012-08-07 00:00:00 |  | NSD |  |  |  | -182.19 |  |  | W1202429
- | APPROP |  | Student Accounts | 2012-08-09 00:00:00 |  | NSD | 11000 - 301010 | 241000 | 000000 |  | -32200
- | APPROP |  | Student Accounts | 2012-08-09 00:00:00 |  | BIOL | 11000 - 301010 | 241000 | Other |  | 7400 |  | 040100
- | APPROP |  | Student Accounts | 2012-08-09 00:00:00 |  | PENG | 11000 - 301010 | 241000 | Other |  | 600 |  | 220200
- | APPROP |  | Student Accounts | 2012-08-09 00:00:00 |  | PENG | 11000 - 301010 | 241000 | Other |  | 8200 |  | 190100
- | APPROP |  | Student Accounts | 2012-08-09 00:00:00 |  | ESA | 11000 - 301010 | 241000 | Other |  | 6600 |  | 191400
- | APPROP |  | Student Accounts | 2012-08-09 00:00:00 |  | MCS | 11000 - 301010 | 241000 | Other |  | 6200 |  | 170100
- | APPROP |  | Student Accounts | 2012-08-09 00:00:00 |  | CHEM | 11000 - 301010 | 241000 | Other |  | 3200 |  | 190500
26335 | 25291 |  | [NAME] | 2012-08-09 00:00:00 |  | NSD | 11000 - 301010 | 451000 | 601000 | 409.94
 | APPROP |  | [NAME] | 2012-08-28 00:00:00 |  | AG | 11000 - 301010 | 525000 | Other |  | 400 |  | 010900
 | APPROP |  | Di Mauro, Eileen | 2012-08-09 00:00:00 |  | CHEM | 11000 - 301010 | 525000 | 000000 |  | -200
 | CONF/P |  | Di Mauro, Eileen | 2012-08-19 00:00:00 |  | CHEM | 11000 - 301010 | 525000 | Other | 200 |  |  | 190500
- | Revolving |  | Redinger, [NAME] | 2012-08-14 00:00:00 |  | NSD | 11000 - 301010 | 451000 | 601000 | 57.13
25810 | 24708 | X | Office Solutions | 2012-08-14 00:00:00 |  | NSD |  |  |  | -161.09 |  |  | W1203564 - (182.18 - item cancelled)
25810 | 24708 | X | Office Solutions | 2012-08-20 00:00:00 |  | NSD |  |  |  | -89.22 |  |  | W1204693
 | APPROP |  | Di Mauro, Eileen | 2012-08-09 00:00:00 |  | CHEM | 11000 - 301010 | 525000 | Other |  | 200 |  | 190500
26598 |  |  | Office Solutions | 2012-08-23 00:00:00 |  | NSD | 11000 - 301010 | 451000 | 601000 | 72.5
26598 |  |  | Office Solutions | 2012-08-23 00:00:00 |  | NSD | 11000 - 301010 | 641200 | 601000 | 313.94
T0005927 | APPROP |  | [NAME] | 2012-08-04 00:00:00 |  | ESA | 11000 - 301010 | 525000 | 000000 |  | -200 |  | 191400
T0005927 | CONF/C |  | [NAME] | 2012-08-04 00:00:00 |  | ESA | 11000 - 301010 | 525000 | Other | 200 |  |  | 191400
T0005927 | APPROP |  | [NAME] | 2012-08-04 00:00:00 |  | ESA | 11000 - 301010 | 525000 | Other |  | 200 |  | 191400
- | Mileage |  | Poncetta, [NAME] | 2012-08-28 00:00:00 |  | AG | 11000 - 301020 | 522000 | 601000 | 461.2
26520 | APPROP |  | Maplesoft | 2012-08-28 00:00:00 |  | MCS | 17800 - 301010 | 431000 | 000000 |  | -4244 |  | 17800-313010-58400-170100
- | CONF |  | [NAME] | 2012-08-28 00:00:00 |  | AG |  |  |  | 200 |  |  | Gifting to [NAME]
- | CONF |  | [NAME] | 2012-08-28 00:00:00 |  | AG |  |  |  | 200 |  |  | Gifting to [NAME]
 | APPROP |  | Rexach, Carmen | 2012-08-28 00:00:00 |  | BIOL | 11000 - 301010 | 525000 | 000000 |  | -200 |  | 040100
 | CONF/P |  | Rexach, Carmen | 2012-10-05 00:00:00 |  | BIOL | 11000 - 301010 | 525000 | Other | 200 |  |  | 040100
 | APPROP |  | Rexach, Carmen | 2012-08-28 00:00:00 |  | BIOL | 11000 - 301010 | 525000 | Other |  | 200 |  | 040100
25810 | 24708 | X | Office Solutions | 2012-08-29 00:00:00 |  | NSD |  |  |  | -64.34 |  |  | W1206609
25810 | 24708 | X | Office Solutions | 2012-08-30 00:00:00 |  | NSD |  |  |  | -30.21 |  |  | W1206778
25810 | 24708 | X | Office Solutions | 2012-09-06 00:00:00 |  | NSD |  |  |  | -28.51 |  |  | W1207793
25810 | 24708 | X | Office Solutions | 2012-09-11 00:00:00 |  | NSD |  |  |  | -85.42 |  |  | W1208451
26856 |  |  | Wards | 2012-09-12 00:00:00 |  | NSD | 11000 - 301010 | 431000 | Other | 893 |  |  | 191400
26856 | APPROP |  | Wards | 2012-09-12 00:00:00 |  | NSD | 11000 - 301010 | 431000 | 601000 |  | -893 |  | 191400
26856 | APPROP |  | Wards | 2012-09-12 00:00:00 |  | NSD | 11000 - 301010 | 431000 | Other |  | 893 |  | 191400
25810 | 24708 | X | Office Solutions | 2012-09-12 00:00:00 |  | NSD |  |  |  | -110.75 |  |  | W1208812