Spreadsheet: 866335d1713283079-sum-if-with-blank-option-equipment-allocations-03-30-2024-test
Sheet: List

Location / Assignment | STATE | COUNTY | JOB # | JOB NAME |  | EQUIPMENT TYPE |  | SUB JOBS | SUB JOBS DEF. |  | COST CODES | COST CODES DEF. |  | Monthly Rate Sheet | 2023 | 2024 | Delta | United Rentals | Equipment Share | HERC
7102102 - Thunder Wolf | CO | Pueblo | 7102102 | [NAME] |  | Buses |  | 00 | COST OF WORK |  | 6300.14 | OFFICE RENT - DIV 1400 |  | ATV Mattracks | 0 | 0 |  | 0 | 0 | 0
7102103 - Neptune | CO | Pueblo | 7102103 | Neptune |  | Cab |  | 05 | MOWING |  | 6530.4 | EQUIP. RENTAL / R&M SOLAR - W/H |  | Buses | 1320 | 1400 |  | 0 | 0 | 0
7102106 - Pisgah Ridge | TX | Navarro | 7102106 | [NAME] |  | [NAME] |  | 10 | PILES |  | 01.3890.00 | HEAVY EQUIPMENT |  | [NAME] | 1500 | 1600 |  | 0 | 0 | 0
7102108 - Waco | TX | Hill | 7102108 | [NAME] |  | Excavators |  | 15 | RACKING |  | 01.3915.00 | SMALL TOOLS & EQUIP. |  | Cable Plow | 0 | 8516 |  | 0 | 0 | 0
7102110 - Big Cypress | AR | White | 7102110 | Big Cypress |  | Fork Spreaders |  | 20 | PV |  | 01.5213.00 | FIELD OFFICE & SHEDS |  | Chasis | 970 | 1250 |  | 0 | 0 | 0
7102113 - Hardeetown | FL | [NAME] | 7102113 | Hardeetown |  | Forklifts 10K - Closed Cab |  | 25 | ELECTRICAL |  | 48.3003.00 | DRIVE PILES |  | Compact Roller | 0 | 0 |  | 0 | 0 | 0
7102115 - Longroad - Foxhound | VA | Halifax | 7102115 | Longroad - Foxhound |  | Forklifts 10K - Open Cab |  | 50 | GEN. CONDITIONS |  | 48.6000.00 | MOWING |  | Containers | 400 | 495 |  | 0 | 0 | 0
7102120 - Sonoran | AZ | Maricopa | 7102120 | [NAME] |  | Forklifts 5K |  |  |  |  |  |  |  | Dandy Digger | 0 | 0 |  | 0 | 0 | 0
7102132W01 - Bell Ridge Warranty | FL | Gilchrist | 7102132W01 | Bell Ridge |  | [NAME] |  |  |  |  |  |  |  | Drilling Accessories | 0 | 0 |  | 0 | 0 | 0
7102135W01 - Saw Palmetto-Warranty | FL | Bay | 7102135W01 | Saw Palmetto |  | Gators |  |  |  |  |  |  |  | [NAME] | 0 | 0 |  | 0 | 0 | 0
7102136 - Cypress Pond | FL | Washington | 7102136 | Cypress Pond |  | Mowers |  |  |  |  |  |  |  | Excavator 50G | 1920 | 3300 |  | 3170
7102138 - Shirer Branch | FL | [NAME] | 7102138 | Shirer Branch |  | [NAME] |  |  |  |  |  |  |  | Fork Spreaders - 6' System | 265 | 700 |  | 0 | 0 | 0
7102205 - Newport | AR | [NAME] | 7102205 | Newport |  | Specialty |  |  |  |  |  |  |  | Fork Spreaders - 8' System | 760 | 760 | 0 | 0 | 0 | 0
7102216 - Driver | AR | White | 7102216 | Driver |  | Tractors |  |  |  |  |  |  |  | Forklift - 10k | 2385 | 4005 |  | 3344
7102219 - Harvest Gold | MS | Sunflower | 7102219 | Harvest Gold |  | Trailers |  |  |  |  |  |  |  | Forklift - 12k | 0 | 0 |  | 4082
7102220 - Washington County | GA | Washington | 7102220 | Washington County |  | Utility Attachments |  |  |  |  |  |  |  | Forklift - 5k | 1300 | 2108 |  | 1616
7102221 - Decatur | GA | Decatur | 7102221 | Decatur |  |  |  |  |  |  |  |  |  | Forklift - 7k | 1710 | 4860 |  | 2500
7102223 - NEER Saint BESS | FL | Washington | 7102223 | [NAME] |  |  |  |  |  |  |  |  |  | Furniture | 0 | 0 | 0 | 0 | 0 | 0
7102224 - IBIS | FL | Alachua | 7102224 | IBIS |  |  |  |  |  |  |  |  |  | Gators | 0 | 0 |  | 510
7102225 - Prairie Creek | FL | DeSoto | 7102225 | Prairie Creek |  |  |  |  |  |  |  |  |  | Generators | 0 | 0 |  | 0 | 0 | 0
7102226 - Terrill Creek | FL | Clay | 7102226 | Terrill Creek |  |  |  |  |  |  |  |  |  | Grinders | 0 | 0 |  | 0 | 0 | 0
7102227 - White Tail | FL | Martin | 7102227 | White Tail |  |  |  |  |  |  |  |  |  | Ground Penetrating Radar | 0 | 0 |  | 0 | 0 | 0
7102228 - Silver Palm | FL | Palm Beach | 7102228 | Silver Palm |  |  |  |  |  |  |  |  |  | [NAME] Mower | 1500 | 1600 |  | 0 | 0 | 0
7102229 - Pineapple | FL | St. Lucie | 7102229 | Pineapple |  |  |  |  |  |  |  |  |  | Kubota [NAME] | 1500 | 1600 |  | 0 | 0 | 0
7102230 - Pecan Tree | FL | [NAME] | 7102230 | Pecan Tree |  |  |  |  |  |  |  |  |  | Lease Buyout | 0 | 0 |  | 0 | 0 | 0
7102231 - Sambucus | FL | Manatee | 7102231 | Sambucus |  |  |  |  |  |  |  |  |  | Mattracks Track Systems | 500 | 500 |  | 0 | 0 | 0
7102232 - Three Creeks | FL | Manatee | 7102232 | Three Creeks |  |  |  |  |  |  |  |  |  | Mower Attachment | 0 | 210 |  | 0 | 0 | 0
7102233 - Four Mile Creek | FL | [NAME] | 7102233 | Four Mile Creek |  |  |  |  |  |  |  |  |  | Office Equipment/Copiers | 0 | 0 | 0 | 0 | 0 | 0
7102234 - Hawthorne Creek | FL | Washington | 7102234 | Hawthorne Creek |  |  |  |  |  |  |  |  |  | Pallet Jack | 0 | 0 |  | 0 | 0 | 0
7102235 - Nature Trail | FL | Okeechobee | 7102235 | [NAME] |  |  |  |  |  |  |  |  |  | PD10s & Accessories | 22500 | 25000 |  | 0 | 26000 | 0
7102236 - Wild Quail | FL | [NAME] | 7102236 | Wild Quail |  |  |  |  |  |  |  |  |  | Plate Compactor | 0 | 0 |  | 0 | 0 | 0
7102301 - West Memphis | AR | [NAME] | 7102301 | West Memphis |  |  |  |  |  |  |  |  |  | Portable Loading Dock | 0 | 0 |  | 0 | 0 | 0
7102302 - Hickerson | TX | [NAME] | 7102302 | Hickerson |  |  |  |  |  |  |  |  |  | Power Rake | 325 | 463 |  | 0 | 0 | 0
7102305 - Green River | GA | Washington | 7102305 | Green River |  |  |  |  |  |  |  |  |  | RDO / GPS Equipment | 0 | 0 |  | 0 | 0 | 0
7102307 - Mitchell Creek | FL | [NAME] | 7102307 | Mitchell Creek |  |  |  |  |  |  |  |  |  | RTV | 0 | 0 |  | 0 | 0 | 0
7102309 - Norton Creek | FL | [NAME] | 7102309 | Norton Creek |  |  |  |  |  |  |  |  |  | Seed Spreader | 0 | 0 |  | 0 | 0 | 0
7102310 - Cedar Trail | FL | Clay | 7102310 | Cedar Trail |  |  |  |  |  |  |  |  |  | Skid Steer Accessories | 0 | 0 |  | 0 | 0 | 0
7102311 - Georges Lake | FL | Clay | 7102311 | George's Lake |  |  |  |  |  |  |  |  |  | [NAME] / 333Gs | 1650 | 3400
7102312 - Buttonwood | FL | Gilchrist | 7102312 | Buttonwood |  |  |  |  |  |  |  |  |  | Sunswing Mower | 1500 | 1600 |  | 0 | 0 | 0
7102313 - Honeybell | FL | DeSoto | 7102313 | Honeybell |  |  |  |  |  |  |  |  |  | Track Wear Stripes And Rollers | 0 | 0 |  | 0 | 0 | 0
7102314 - Hendry Isles | FL | [NAME] | 7102314 | Hendry Isles |  |  |  |  |  |  |  |  |  | Tractors (75 HP) | 1900 | 2155 |  | $1,697 (50HP) | 0 | 0
7102316 - Big Water | FL | Alachua | 7102316 | Big Water |  |  |  |  |  |  |  |  |  | Trailer - Big Tex | 650 | 813 |  | 0 | 0 | 0
7102320 - Fox Trail | FL | Manatee | 7102320 | [NAME] |  |  |  |  |  |  |  |  |  | Trailers - Cargo | 650 | 680 |  | 0 | 0 | 0
7102321 - Redlands | FL | Okeechobee | 7102321 | Redlands |  |  |  |  |  |  |  |  |  | Trailers - Generator | 3842 | 4066 |  | 0 | 0 | 0
7102323 - Thomas Creek | FL | St. Lucie | 7102323 | [NAME] |  |  |  |  |  |  |  |  |  | Trailers - Gooseneck | 1150 | 1175 |  | 0 | 0 | 0
7102326 - Long Creek | FL | DeSoto | 7102326 | Long Creek |  |  |  |  |  |  |  |  |  | Trailers - High | 3842 | 5260 |  | 0 | 0 | 0
7102327 - Hog Bay | FL | [NAME] | 7102327 | Hog Bay |  |  |  |  |  |  |  |  |  | Tremble GPS Equipment | 0 | 0 |  | 0 | 0 | 0
7102328 - Flat Fork | AR | White | 7102328 | Flat Fork |  |  |  |  |  |  |  |  |  | Trench Compactor | 0 | 0 |  | 0 | 0 | 0
7102329 - Gilchrist | FL | Gilchrist | 7102329 | GILCHRIST |  |  |  |  |  |  |  |  |  | [NAME] | 0 | 0 |  | 0 | 0 | 0
7102330 - SUNDANCE |  |  | 7102330 | SUNDANCE |  |  |  |  |  |  |  |  |  | Van 15 Passenger | 0 | 0 |  | 1361 | 0
7102331 - ROARING SPRINGS |  |  | 7102331 | ROARING SPRINGS |  |  |  |  |  |  |  |  |  | [NAME] | 0 | 250 |  | 0 | 0 | 0
7102333 - DIVER |  |  | 7102333 | DIVER |  |  |  |  |  |  |  |  |  | Waste Processing Equipment | 0 | 0 |  | 0 | 0 | 0
7102335 - YAUPON |  |  | 7102335 | [NAME] |  |  |  |  |  |  |  |  |  | Water Truck 2k - 2.5k | 0 | 0 | 0 | 2381
7102401 - BIG BROOK |  |  | 7102401 | BIG BROOK |  |  |  |  |  |  |  |  |  | Water Truck 4k - 4.5k | 0 | 0 | 0 | 0
7102402 - BOARDWALK |  |  | 7102402 | BOARDWALK
7102403 - FLATFORD |  |  | 7102403 | FLATFORD
7102404 - GOLDEN ROD |  |  | 7102404 | GOLDEN ROD
7102405 - MALLARD |  |  | 7102405 | MALLARD
7102406 - MARE BRANCH |  |  | 7102406 | MARE BRANCH
7102407 - PRICE CREEK |  |  | 7102407 | PRICE CREEK
7102408 - SWAMP CABBAGE |  |  | 7102408 | SWAMP CABBAGE
7102409 - COMPADRE |  |  | 7102409 | COMPADRE
7102410 - NEW MADRID |  |  | 7102410 | NEW MADRID
9999999 - Fort Drum | FL | Okeechobee |  | Fort Drum
AT BEARD FOR REPAIR | FL | Okeechobee |  | AT BEARD FOR REPAIR
BCYARD | AR | White |  | BCYARD
BRYARD | FL | Gilchrist |  | BRYARD
BTYARD | FL | [NAME] |  | BTYARD
BYARD | FL | Manatee |  | BYARD
BYYARD - Beard | FL | Okeechobee |  | BYYARD - Beard - Okeechobee
BYYARD - Beard  - Clay | FL | Clay |  | BYYARD - Beard - Clay
BYYARD - Beard - Gilchrist | FL | Gilchrist |  | BYYARD - Beard - Gilchrist
CDYARD | FL | Okeechobee |  | CDYARD
CED Warehouse | NC | Vance |  | CED Warehouse
CEDYARD | NC | Vance |  | CEDYARD
CETYARD | FL | Okeechobee |  | CETYARD
CEYard | FL | [NAME] |  | CEYard
CHAYARD | FL | [NAME] |  | CHAYARD
CLYARD | FL | [NAME] |  | CLYARD
CURRENTLY MISSING | MISSING | MISSING |  | CURRENTLY MISSING
DJYARD | FL | Palm Beach |  | DJYARD
DRYARD | AR | White |  | DRYARD
ECYARD | FL | Alachua |  | ECYARD
Electrical | FL | Okeechobee |  | Electrical
EPYARD | FL | Okeechobee |  | EPYARD
EVYARD | FL | Clay |  | EVYARD
GYARD | FL | [NAME] |  | GYARD
HBLAYDOWN YARD | FL | [NAME] |  | HBLAYDOWN YARD
HBYARD | FL | [NAME] |  | HBYARD
HDYARD | FL | [NAME] |  | HDYARD
HGYARD | MS | Sunflower |  | HGYARD
HI DIV OH | HI | Honolulu |  | HI DIV OH
HIYARD | FL | Gilchrist |  | HIYARD
HSPYARD | FL | Alachua |  | HSPYARD
HSPYARD - Luis Medina | FL | Alachua |  | HSPYARD - Luis Medina
IBYARD | FL | Alachua |  | IBYARD
J [NAME] | FL | Okeechobee |  | J [NAME]
J Howell | FL | Okeechobee |  | J Howell
JPYARD | FL | Gilchrist |  | JPYARD
[NAME] | HI | Honolulu | 7102011 | Mililani I
MMYARD | FL | Okeechobee |  | MMYARD
MPYARD | AR | [NAME] |  | MPYARD
NEPYARD | AR | [NAME] |  | NEPYARD
NPYARD | CO | Pueblo |  | NPYARD
SBYARD | FL | Manatee |  | SBYARD
SONYARD | AZ | Maricopa |  | SONYARD
SPYARD | FL | Palm Beach |  | SPYARD
SSYARD | TX | Hill |  | SSYARD
TCYARD | FL | Manatee |  | TCYARD
TRYARD | FL | Putnam |  | TRYARD
TTYARD | FL | Okeechobee |  | TTYARD
UA Yard | TX | Hill |  | UA Yard
URYARD | FL | Clay |  | URYARD
URYARD - Clay FL | FL | Clay |  | URYARD - Clay
URYARD - Manatee FL | FL | Manatee |  | URYARD - Manatee FL
URYARD - Washington GA | GA | Washington |  | URYARD - Washington GA
Waiawa - 7102010 | HI | Honolulu | 7102010 | Waiawa
WAYARD | FL | Gilchrist |  | WAYARD
WCYARD | TX | Hill |  | WCYARD
WMYARD | AR | [NAME] |  | WMYARD
WTYARD | FL | Martin |  | WTYARD
WYARD | MS | Sunflower |  | WYARD