Spreadsheet: 716658d1612302416-using-1-duplicate-criteria-in-a-single-column-pull-row-details-into-a-new-spreadsheet-sample-sheet
Sheet: Project List

Status | Project Office | Bid Type | Date  Added | PC Job # | Date  Awarded | Active Job # | Project Name | Project Address | Project Complexity | Chance of Winning | County | Estimator | Bid Due Date | Estimated Cost | Per Diem | Owner's Rep | Projected Start Date | Projected Finish Date | Project  Duration | Notes
Awarded | Georgia | Hard Bid | 2021-01-05 00:00:00 | PC1001 | 2021-01-10 00:00:00 | BU1001 | Project 1 | Address 1 | 1 | 0.5 | Shelby | Estimator 1 | 2020-07-03 00:00:00 | 211000 | No | Owner's Rep 1 | 2021-02-01 00:00:00
Bid Pending Award | Georgia | Negotiated | 2021-01-06 00:00:00 | PC1002 |  |  | Project 2 | Address 2 | 1 | 0.75 | [NAME] | Estimator 1 | 2020-03-23 00:00:00 | 14087 | No | Owner's Rep 2 | 2021-03-01 00:00:00
Bid Pending Award | Georgia | Hard Bid | 2021-01-06 00:00:00 | PC1003 |  |  | Project 3 | Address 3 | 1 | 1 | Fulton | Estimator 5 | 2020-08-21 00:00:00 | 156304 | Yes | Owner's Rep 3 | 2021-03-21 00:00:00
Pipeline | Georgia | Hard Bid | 2021-01-18 00:00:00 | PC1004 |  |  | Project 4 | Address 4 | 2 | 0.5 | Dekalb | Estimator 2 | 2020-01-01 00:00:00 | 100000 | Yes | Owner's Rep 4 | 2021-04-21 00:00:00
Not Awarded | Georgia | Hard Bid | 2021-01-15 00:00:00 | PC1005 |  |  | Project 5 | Address 5 | 1 | 0.25 | Fulton | Estimator 3 | 2020-12-03 00:00:00 | 213950 |  | Owner's Rep 5 | 2021-02-01 00:00:00 | 2021-04-01 00:00:00 | 6
Currently Bidding | Georgia | Negotiated | 2020-12-31 00:00:00 | PC1006 |  |  | Project 6 | Address 6 | 1 | 0.25 | Muscogee | Estimator 4 | 2021-01-01 00:00:00 | 100000 | No | Owner's Rep 6 | 2021-02-21 00:00:00
Bid Pending Award | Mid-Atlantic | Negotiated | 2020-12-02 00:00:00 | PC1007 |  |  | Project 7 | Address 7 | 1 | 1 | Henrico | Estimator 1 | 2020-12-30 00:00:00 | 6232.46 | No | Owner's Rep 7 | 2021-01-01 00:00:00 | 2021-01-22 00:00:00 | 1
Bid Pending Award | Mid-Atlantic | Negotiated | 2020-11-03 00:00:00 | PC1008 |  |  | Project 8 | Address 8 | 1 | 1 | Chesterfield | Estimator 1 | 2020-12-30 00:00:00 | 6103.52 | No | Owner's Rep 8 | 2021-01-01 00:00:00 | 2021-01-22 00:00:00 | 1
Bid Pending Award | North Carolina | Hard Bid | 2020-10-05 00:00:00 | PC1009 |  |  | Project 9 | Address 9 | 1 | 0.5 | Mecklenburg | Estimator 5 | 2020-12-09 00:00:00 | 116007 | No | Owner's Rep 9 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00
Not Awarded | North Carolina | Hard Bid | 2021-01-15 00:00:00 | PC1010 |  |  | Project 10 | Address 10 | 3 | 0.5 | Mecklenburg | Estimator 2 | 2020-12-07 00:00:00 | 900000 | No | Owner's Rep 10 | 2021-01-19 00:00:00 | 2021-06-22 00:00:00 | 48
Pipeline | North Carolina | Hard Bid | 2020-11-03 00:00:00 | PC1011 |  |  | Project 11 | Address 11 | 1 | 0.25 | Union | Estimator 3 | 2020-12-10 00:00:00 | 250000 | No | Owner's Rep 11 | 2021-03-21 00:00:00
Currently Bidding | North Carolina | Negotiated | 2021-01-26 00:00:00 | PC1012 |  |  | Project 12 | Address 12 | 1 | 0.5 | Mecklenburg | Estimator 4 | 2021-01-01 00:00:00 | 10000 | Yes | Owner's Rep 12 | 2021-04-21 00:00:00
Not Awarded | North Carolina | Hard Bid | 2021-01-02 00:00:00 | PC1013 |  |  | Project 13 | Address 13 | 2 | 0.25 | [NAME] | Estimator 1 | 2020-12-11 00:00:00 | 1514000 | Yes | Owner's Rep 13 | 2021-02-01 00:00:00 | 2021-07-05 00:00:00 | 22
Awarded | North Carolina | Hard Bid | 2020-12-06 00:00:00 | [NAME] | 2021-01-01 00:00:00 | BU1014 | Project 14 | Address 14 | 2 | 0.25 | [NAME] | Estimator 1 | 2020-12-04 00:00:00 | 117213 | Yes | Owner's Rep 14 | 2021-01-01 00:00:00 |  | 3
Bid Pending Award | North Florida | Negotiated | 2021-01-12 00:00:00 | PC1015 |  |  | Project 15 | Address 15 | 1 | 1 | Duval | Estimator 5 | 2020-11-13 00:00:00 | 6975 | No | Owner's Rep 15 | 2021-03-21 00:00:00 |  | 1
Bid Pending Award | North Florida | Negotiated | 2021-01-05 00:00:00 | PC1016 |  |  | Project 16 | Address 16 | 2 | 1 | Duval | Estimator 2 | 2020-11-13 00:00:00 | 8975 | No | Owner's Rep 16 | 2021-03-21 00:00:00 |  | 1
Cancelled | South Florida | Negotiated | 2020-12-03 00:00:00 | PC1017 |  |  | Project 17 | Address 17 | 1 | 0.25 | Broward | Estimator 3 | 2021-02-02 00:00:00 | 50000 | Yes | Owner's Rep 17 | 2021-03-21 00:00:00
Bid Pending Award | South Florida | Hard Bid | 2021-01-01 00:00:00 | PC1018 |  |  | Project 18 | Address 18 | 3 | 0.25 | Collier | Estimator 4 | 2021-01-29 00:00:00 | 123707.21 | No | Owner's Rep 18 | 2021-03-01 00:00:00 | 2021-05-03 00:00:00 | 9
Bid Pending Award | West Florida | Hard Bid | 2021-01-01 00:00:00 | PC1019 |  |  | Project 19 | Address 19 | 2 | 0.25 | Hillsborough | Estimator 1 | 2021-03-01 00:00:00 | 78150 | No | Owner's Rep 19 | 2021-04-21 00:00:00
Bid Pending Award | South Florida | Hard Bid | 2021-01-15 00:00:00 | PC1020 |  |  | Project 20 | Address 20 | 1 | 0.25 | Miami Dade | Estimator 1 | 2021-01-29 00:00:00 | 100360.33 | No | Owner's Rep 20 | 2021-02-01 00:00:00 | 2021-03-28 00:00:00 | 9
Bid Pending Award | South Florida | Hard Bid | 2021-01-15 00:00:00 | PC1021 |  |  | Project 21 | Address 21 | 1 | 0.25 | Miami Dade | Estimator 5 | 2021-01-29 00:00:00 | 240628.23 | No | Owner's Rep 21 | 2021-02-01 00:00:00 | 2021-04-28 00:00:00 | 12
Currently Bidding | Mid-Atlantic | Negotiated | 2021-01-27 00:00:00 | PC1022 |  |  | Project 22 | Address 22 | 1 | 1 | York | Estimator 2 | 2021-02-10 00:00:00 | 350000 | Yes | Owner's Rep 22 | 2021-04-21 00:00:00