Spreadsheet: 851464d1701700593-formula-to-pick-a-value-based-on-date-range-weighted-avg-based-on-date
Sheet: Sheet1

Project | Bid Date | Winning/Losing | Pay Item No | Description | Qty | Unit | Bid | Total Cost | Highest Bid | Highest Total Cost | Average vs Low | Expected result
002228A | 2023-01-01 00:00:00 | Winning | 005-0700 | Survey,  [NAME] | 1 | LS | 20350 | 20350
002927A | 2023-01-01 00:00:00 | Winning | 005-0700 | SURVEY, CONSTRUCTION LAYOUT | 1 | LS | 42000 | 42000
000087A | 2022-12-05 00:00:00 | Winning | 005-0701 | SURVEY AND LAYOUT BY CONTRACTOR | 1 | LS | 65000
003894A | 2023-06-08 00:00:00 | Winning | 005-0701 | Survey and Layout | 1 | LS | 98500 | 98500
005210A | 2023-03-30 00:00:00 | Winning | 005-0701 | Survey and Layout | 1 | LS | 40000 | 40000
003894A | 2023-06-08 00:00:00 | Winning | 005-0703 | Earthwork Quantity Measurements | 1 | LS | 1500 | 1500
003894A | 2023-06-08 00:00:00 | Winning | 005-0705 | SURVEY, Permitting As-built Requirements | 1 | LS | 10000 | 10000
002228A | 2023-04-21 00:00:00 | Winning | 005-0800 | Survey, Quantity Measurements | 1 | LS | 11550 | 11550
002927A | 2023-05-09 00:00:00 | Winning | 005-0800 | SURVEY, Quantity Measurements | 1 | LS | 3200 | 3200
002228A | 2023-04-21 00:00:00 | Winning | 005-0850 | Survey, As-Built Survey | 1 | LS | 11550 | 11550
002927A | 2023-05-09 00:00:00 | Winning | 005-0850 | SURVEY, PERMITTING AS-BUILT REQUIREMENTS | 1 | LS | 12000 | 12000
000087A | 2023-06-08 00:00:00 | Winning | 101-0100 | MOBILIZATION | 1 | LS | 725000 | 725000
002228A | 2023-04-21 00:00:00 | Winning | 101-0100 | MOBILIZATION | 1 | LS | 441000 | 441000
002927A | 2023-05-09 00:00:00 | Winning | 101-0100 | MOBILIZATION | 1 | LS | 379000 | 379000
003894A | 2023-06-08 00:00:00 | Winning | 101-0100 | Mobilization | 1 | LS | 225000 | 225000
005210A | 2023-03-30 00:00:00 | Winning | 101-0100 | MOBILIZATION | 1 | LS | 175000 | 175000
ADA | 2023-06-15 00:00:00 | Winning | 101-0310 | EMERGENCY Mobilization at County's Request | 10 | EA | 7000 | 70000
ADA | 2023-06-15 00:00:00 | Winning | 101-0311 | REMOBILIZATION AT COUNTY'S REQUEST | 10 | EA | 6000 | 60000
000087A | 2023-06-08 00:00:00 | Winning | 102-1000 | [NAME] | 1 | LS | 405000 | 405000
002228A | 2023-04-21 00:00:00 | Winning | 102-1000 | [NAME] | 1 | LS | 185000 | 185000
002927A | 2023-05-09 00:00:00 | Winning | 102-1000 | [NAME] | 1 | LS | 127500 | 127500
003894A | 2023-06-08 00:00:00 | Winning | 102-1000 | Maintenance of Traffic | 1 | LS | 15000 | 15000
005210A | 2023-03-30 00:00:00 | Winning | 102-1000 | [NAME] | 1 | LS | 100000 | 100000
ADA | 2023-06-15 00:00:00 | Winning | 102-1074 | CHANNELIZING DEVICE- PEDESTRIAN LCD (LONGITUDINAL CHANNELIZING DEVICE), FDOT 102-600 | 50000 | LF | 2.5 | 125000
ADA | 2023-06-15 00:00:00 | Winning | 102-1076 | ARROW BOARD/ADVANCED WARNING ARROW PANEL | 1000 | EA/DAY | 35 | 35000
Pavement | 2023-06-22 00:00:00 | Winning | 102-1076 | ADVANCED ARROW WARNING PANEL | 2000 | DAY | 2.5 | 5000
002228A | 2023-04-21 00:00:00 | Winning | 102-1099 | SIGN, VARIABLE MESSAGE (3 Lines) (Temporary) | 360 | ED | 16 | 5760
002927A | 2023-05-09 00:00:00 | Winning | 102-1099 | SIGN, VARIABLE MESSAGE | 880 | ED | 12 | 10560
003894A | 2023-06-08 00:00:00 | Winning | 102-1099 | Variable Message Board | 21 | ED | 30 | 630
005651A | 2023-03-15 00:00:00 | Winning | 102-1099 | PORTABLE CHANGEABLE MESSAGE SIGN (PCMS) -TEMPORARY | 175 | EA/DAY | 13 | 2275