Spreadsheet: 88829d1288658352-bring-back-value-based-on-date-copy-of-formula-sample
Sheet: PROJECT INVOICE LOG

 |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
Budget Line Number | REXP | PURCHASE | PROJECT | COST | G/L / | INVOICE # | INVOICE DATE | VENDOR NAME | CURRENT | ORIGINAL | CHANGE | INVOICE AMOUNT | PO | DATE RCV'D BY CC | FINAL SIGNATURE APPROVAL | SIGNATURE DATE | CHECK # | DATE PAID | PAID | CODE | INVOICE DESCRIPTION / COMMENTS
OC-08 |  | 8361 | 060016--146 | 930000 | [PHONE]-092300 |  |  | SAGE ENVIRONMENTAL - 2010 | 118289.06 |  |  | 64394.1 | 53894.96
 |  | 8361 | 060016--146 | 930000 | [PHONE]-092300 |  |  | SAGE ENVIRONMENTAL - 2010 |  | 118289.06
 |  | 8361 | 060016-146 | 930000 | [PHONE]-092300 | 231-1-49-01 | 2010-02-28 00:00:00 | Sage Environmental |  |  |  | 8093.1 |  | 2010-03-25 00:00:00 | TCHAMPEAUX | 2010-03-25 00:00:00 | 130917 | 2010-04-05 00:00:00 | OC-08 | 310 | Environmental Services for Revamp project
 |  | 8361 | 060016-146 | 930000 | [PHONE]-092300 | 231-1-49-07 | 2010-08-31 00:00:00 | Sage Environmental |  |  |  | 17964.69 |  | 2010-10-07 00:00:00 | TCHAMPEAUX | 2010-10-07 00:00:00 |  |  | OC-08 | 1010 | Environmental Services for Revamp project
 |  | 8361 | 060016-146 | 930000 | [PHONE]-092300 | 231-1-49-05 | 2010-06-30 00:00:00 | Sage Environmental |  |  |  | 2124.24 |  | 2010-08-09 00:00:00 | TCHAMPEAUX | 2010-08-09 00:00:00 | 138233 | 2010-08-16 00:00:00 | OC-08 | 810 | Environmental Services for Revamp project
 |  | 8361 | 060016-146 | 930001 | [PHONE]-092300 | 231-1-49-06 | 2010-07-31 00:00:00 | Sage Environmental |  |  |  | 17977.59 |  | 2010-08-18 00:00:00 | TCHAMPEAUX | 2010-08-19 00:00:00 | 140192 | 2010-08-27 00:00:00 | OC-08 | 810 | Environmental Services for Revamp project
 |  | 8361 | 060016-146 | 930000 | [PHONE]-092300 | 231-1-49-04 | 2010-05-31 00:00:00 | Sage Environmental |  |  |  | 10488.44 |  | 2010-06-22 00:00:00 | TCHAMPEAUX | 2010-06-22 00:00:00 | 136433 | 2010-07-02 00:00:00 | OC-08 | 610 | Environmental Services for Revamp project
 |  | 8361 | 060016-146 | 930000 | [PHONE]-092300 | 231-1-24-38 | 2010-01-31 00:00:00 | Sage Environmental |  |  |  | 7746.04 |  | 2010-02-26 00:00:00 | TCHAMPEAUX | 2010-02-26 00:00:00 | 128396 | 2010-03-03 00:00:00 | OC-08 | 210 | Environmental Services for Revamp project
 |  |  |  |  |  |  |  | COMPANY 2 |  |  |  | 500 |  | 2010-10-30 00:00:00 |  | 2010-11-30 00:00:00 |  | 2010-12-30 00:00:00
 |  |  |  |  |  |  |  | COMPANY 3 |  |  |  | 600 |  | 2010-10-31 00:00:00 |  | 2010-12-01 00:00:00 |  | 2010-12-31 00:00:00
 |  |  |  |  |  |  |  | COMPANY 4 |  |  |  | 700 |  | 2010-11-01 00:00:00 |  | 2010-12-02 00:00:00 |  | 2011-01-01 00:00:00
 |  |  |  |  |  |  |  | COMPANY 5 |  |  |  | 800 |  | 2010-11-02 00:00:00 |  | 2010-12-03 00:00:00 |  | 2011-01-02 00:00:00
 |  |  |  |  |  |  |  | COMPANY 6 |  |  |  | 900 |  | 2010-11-03 00:00:00 |  | 2010-12-04 00:00:00 |  | 2011-01-03 00:00:00
 |  |  |  |  |  |  |  | COMPANY 7 |  |  |  | 1000 |  | 2010-11-04 00:00:00 |  | 2010-12-05 00:00:00 |  | 2011-01-04 00:00:00
 |  |  |  |  |  |  |  | COMPANY 8 |  |  |  | 1100 |  | 2010-11-05 00:00:00 |  | 2010-12-06 00:00:00 |  | 2011-01-05 00:00:00
 |  |  |  |  |  |  |  | COMPANY 9 |  |  |  | 1200 |  | 2010-11-06 00:00:00 |  | 2010-12-07 00:00:00 |  | 2011-01-06 00:00:00
 |  |  |  |  |  |  |  | COMPANY 10 |  |  |  | 1300 |  | 2010-11-07 00:00:00 |  | 2010-12-08 00:00:00 |  | 2011-01-07 00:00:00
 |  |  |  |  |  |  |  | COMPANY 11 |  |  |  | 1400 |  | 2010-11-08 00:00:00 |  | 2010-12-09 00:00:00 |  | 2011-01-08 00:00:00