Spreadsheet: 741330d1626973741-returning-value-directly-next-to-pivot-table-example-5
Sheet: Sheet1

PROJECT NUMBER | YEAR | ITEM NUMBER | [NAME] | [NAME] | ITEM DESCRIPTION/ PROJECT | DATE | UNIT/QUANTITY | UNIT | ENGR. EST. | AVERAGE BID | AWARDED BID |  | Row Labels
 | 2015 | 201-00000 |  |  | Clear and [NAME] |  | LUMP SUM |  |  |  |  |  | 201-00000
 |  |  |  |  |  |  |  |  |  |  |  |  | 2015
 |  |  |  |  |  |  |  |  |  |  |  |  | 201-00001
STM012A-046 | 2015 |  |  |  | Job 1 | 01/15/15 | 1 |  | 10000 | 15487 | 20000 |  | 2015
NHPP0702-336 | 2015 |  |  |  | Job 2 | 01/29/15 | 1 |  | 75000 | 235000 | 235000 |  | 202-00000
NHPP 5502-077 | 2015 |  |  |  | Job 3 | 01/29/15 | 1 |  | 10000 | 9946.67 | 5000 |  | 2015
BR0402-086 | 2015 |  |  |  | Job 4 | 02/05/15 | 1 |  | 15000 | 29942.64 | 24863.18
NHPP0703-412 | 2015 |  |  |  | Job 5 | 02/05/15 | 1 |  | 9000 | 12833.33 | 8500
STA0131-063 | 2015 |  |  |  | Job 6 | 02/19/15 | 1 |  | 32000 | 76885.63 | 48000
SHE0212-006 | 2015 |  |  |  | Job 7 | 03/05/15 | 1 |  | 69000 | 66756.63 | 110000
FBR160A-024 | 2015 |  |  |  | Job 8 | 03/05/15 | 1 |  | 5000 | 7551.45 | 10482.89
STA160A-025 | 2015 |  |  |  | Job 9
NHPP1601-070 | 2015 |  |  |  | Job 10 | 03/05/15 | 1 |  | 10000 | 33646.12 | 3100
FBR0703-410 | 2015 |  |  |  | Job 11 | 03/09/15 | 1 |  | 19938 | 12500 | 12500
NHPP0703-418 | 2015 |  |  |  | Job 12
STA016A-042 | 2015 |  |  |  | Job 13 | 03/12/15 | 1 |  | 30000 | 24622.47 | 14620.43
ER0253-239 | 2015 |  |  |  | Job 14 | 03/18/15 | 1 |  | 15000 | 319500 | 395000
SHE1602-151 | 2015 |  |  |  | Job 15 | 03/26/15 | 1 |  | 20000 | 37225.71 | 16131.72
NH0242-054 | 2015 |  |  |  | Job 16 | 04/09/15 | 1 |  | 20000 | 159561.39 | 41149.4
NH2873-176 | 2015 |  |  |  | Job 17 | 04/16/15 | 1 |  | 10000 | 14700 | 14700
CR600-409 | 2015 |  |  |  | Job 18 | 04/30/15 | 1 |  | 20000 | 140333.33 | 150000
STRR200-205 | 2015 |  |  |  | Job 19 | 05/21/15 | 1 |  | 5000 | 43367.93 | 43103.79
STA 340A-017 | 2015 |  |  |  | Job 20 | 05/21/15 | 1 |  | 5000 | 10476.67 | 6430
FSA5502-072 | 2015 |  |  |  | Job 21 | 05/28/15 | 1 |  | 30000 | 40900 | 16800
NHPP 076A-008 | 2015 |  |  |  | Job 22 | 05/28/15 | 1 |  | 2500 | 18000 | 7000
FSA145A-057 | 2015 |  |  |  | Job 23 | 05/28/15 | 1 |  | 9000 | 11775.19 | 6050.37
SHE165A-012 | 2015 |  |  |  | Job 24 | 06/11/15 | 1 |  | 7200 | 18933.33 | 11800
SHE151A-008 | 2015 |  |  |  | Job 25 | 06/25/15 | 1 |  | 11000 | 11766.2 | 27500
SHE172A-018 | 2015 |  |  |  | Job 26 | 06/25/15 | 1 |  | 5000 | 7767.89 | 15000
SRP052A-032 | 2015 |  |  |  | Job 27 | 07/02/15 | 1 |  | 5000 | 8666.67 | 2000
NHPP 0701-223 | 2015 |  |  |  | Job 28 | 07/09/15 | 1 |  | 10000 | 18660 | 22000
C0501-061 | 2015 |  |  |  | Job 29 | 07/09/15 | 1 |  | 5000 | 1350 | 1500
ER R400-326 | 2015 |  |  |  | Job 30 | 07/09/15 | 1 |  | 10000 | 77544.06 | 45000
ER0703-424 | 2015 |  |  |  | Job 31 | 07/16/15 | 1 |  | 15000 | 75000 | 75000
STA0451-010 | 2015 |  |  |  | Job 32 | 07/23/15 | 1 |  | 10000 | 20114.64 | 5272.27
TAP 0703-382 | 2015 |  |  |  | Job 33 | 07/30/15 | 1 |  | 10000 | 104530.15 | 31000
STA 0702-362 | 2015 |  |  |  | Job 34 | 08/26/15 | 1 |  | 6268.69 | 6268.69 | 6268.69
=============== | 2015 | 201-00000 |  |  | Clear and [NAME] |  | LUMP SUM |  | ==============
NHPP0702-337 | 2015 |  |  |  | Job 1 | 10/22/15 | 1 |  | 10000 | 90000 | 150000
NHPP5502-079 | 2015 |  |  |  | Job 2 | 10/29/15 | 1 |  | 10000 | 13725.89 | 1290
BR0063-044 | 2015 |  |  |  | Job 3 | 10/29/15 | 1 |  | 35000 | 54666.67 | 6500
STA2873-100 | 2015 |  |  |  | Job 4 | 11/05/15 | 1 |  | 50000 | 314496.17 | 225000
STA0131-065 | 2015 |  |  |  | Job 5 | 11/05/15 | 1 |  | 20000 | 73230 | 25000
STU1211-084 | 2015 |  |  |  | Job 6 | 11/12/15 | 1 |  | 10000 | 77496.57 | 158895.16
STM021A-003 | 2015 |  |  |  | Job 7 | 11/12/15 | 1 |  | 30000 | 44835.3 | 85000
FBR 0821-094 | 2015 |  |  |  | Job 8 | 12/01/15 | 1 |  | 15652.98 | 15498 | 15498
NHPP0063-050 | 2015 |  |  |  | Job 9
NHPP 0821-104 | 2015 |  |  |  | Job 10
FBR 0821-105 | 2015 |  |  |  | Job 11
NHPP0703-425 | 2015 |  |  |  | Job 12 | 12/17/15 | 1 |  | 10000 | 28419.17 | 30000
=============== | 2015 | 201-00001 |  |  | Clear and [NAME] |  | Acre |  | ==============
SHE0504-070 | 2015 |  |  |  | Job 1 | 04/30/15 | 8.6 |  | 2200 | 4375.46 | 7126.37
NHPP030A-032 | 2015 |  |  |  | Job 2 | 10/22/15 | 0.12 |  | 3000 | 52428 | 46284
STA 0702-327 | 2015 |  |  |  | Job 3 | 12/11/15 | 1 |  | 26939.14 | 26939.14 | 26939.14
=============== | 2015 | 202-00000 |  |  | [NAME] and Obstructions |  | LUMP SUM |  | ==============
 | 2015
 | 2015
IM 0703-381 | 2015 |  |  |  | EISENHOWER JOHNSON TUNNEL ROO | 04/09/15 | 1 |  | 5000 | 77787.4 | 100000
 | 2015
 | 2015
=============== | 2015 | 202-00000 |  |  | [NAME] and Obstructions |  | LUMP SUM |  | ==============
 | 2015
 | 2015
 | 2015
 | 2015
SRP052A-032 | 2015 |  |  |  | SH 52, Main St. In Hudson | 07/02/15 | 1 |  | 7500 | 9150 | 5350
C0501-061 | 2015 |  |  |  | SH 50 & San Juan Ave. Interse | 07/09/15 | 1 |  | 15000 | 3100 | 2500
 | 2015
 | 2015
 | 2015
 | 2015
NHPP0702-337 | 2015 |  |  |  | I-70 Vail Chain Station Impro | 10/22/15 | 1 |  | 150 | 5235.53 | 3100
STU1211-084 | 2015 |  |  |  | WADSWORTH (HIGHLAND TO 10TH) | 11/12/15 | 1 |  | 10000 | 40121.36 | 12400