Spreadsheet: 452613d1458828565-sum-a-named-range-across-multiple-worksheets-01-estimator-sample
Sheet: Rates

 | Description | Travel | Regular |  | OT | DT
 | Principal | 125 | 175 |  | 200 | 225
 | [NAME] | 55 | 125 |  | 150 | 175
 | Laborer | 55 | 95 |  | 120 | 145
 |  |  |  |  |  |  |  |  | Gasoline: | 3.75
 | Pull-down list for equipment rentals |  |  |  |  |  |  |  | Diesel: | 4 |  |  |  |  |  |  |  | Times | Spacing
 |  | Owned | Rental | Tiger | Day | Wk. | Mo. | Delivery | Gal/Day | FDay | FWk. | FMo. |  | 1 - Sack Sand Slurry | 2000 | @ 24 hr. |  | 00:01:00
 | [NAME] |  |  |  | 125 | 500 | 1500 |  | 5 | 18.75 | 93.75 | 375 |  | 1½ - Sack Sand Slurry | 2500 | @ 48 hr. |  | 00:15:00 | 5
 | [NAME] |  |  |  | 125 | 500 | 1500 |  | 5 | 18.75 | 93.75 | 375 |  | 2 - Sack Sand Slurry | 3000 | @ 72 hr. |  | 00:30:00 | 10
 | Bobcat 435 Rubber Track Mini Ex |  |  |  | 475 | 1900 | 5700 | 290 | 10 | 40 | 200 | 800 |  | ¾" Rock | 4000 | @ 7 days |  | 00:45:00 | 15
 | Breaker for Mini Ex |  |  |  | 308 | 1232 | 3696 |  |  | 0 | 0 | 0 |  | ⅜" Pea Gravel | 5000 | @ 28 days |  | 01:00:00 | 20
 | 48" Bucket for Mini Ex |  |  |  | 30 | 120 | 360 |  |  | 0 | 0 | 0 |  |  |  |  |  | 01:15:00 | 25
 | Bobcat S175 w/ 6' Smooth Bucket |  |  |  | 592 | 2368 | 7104 | 290 | 10 | 40 | 200 | 800 |  |  |  |  |  | 01:30:00 | 30
 | [NAME] for Skid Steer |  |  |  | 300 | 1200 | 3600 |  |  | 0 | 0 | 0 |  |  |  |  |  | 01:45:00 | 35
 | Small Loader: [NAME] |  |  |  | 937 | 3748 | 11244 | 290 | 10 | 40 | 200 | 800 |  |  |  |  |  | 02:00:00 | 40
 | Hammer for Backhoe |  |  |  | 650 | 2600 | 7800 |  |  |  |  |  |  |  |  |  |  | 02:15:00 | 45
 | Medium Loader: Cat 924H CU |  |  |  | 475 | 1900 | 5700 | 290 | 10 | 40 | 200 | 800 |  | No Fly Ash |  |  |  | 02:30:00 | 50
 | Dump Truck: 6 Yard |  |  |  | 592 | 2368 | 7104 | 290 | 10 | 40 | 200 | 800 |  | Fiber Mesh |  |  |  | 02:45:00 | 55
 | Wacker RD11A 36" Drum Ride-on Roller |  |  |  | 175 | 700 | 2100 | 290 | 5 | 20 | 100 | 400 |  | No Added Air Entrainment |  |  |  | 03:00:00 | 60
 | Loader: Cat 414E w/ Rear Grade Attachment |  |  |  | 270 | 1080 | 3240 | 290 | 10 | 40 | 200 | 800 |  | 1% Air Entrainment |  |  |  | 03:15:00
 | 5K Warehouse Forklift (Long Forks) |  |  |  | 270 | 1080 | 3240 | 290 | 10 | 40 | 200 | 800 |  | 2% Air Entrainment |  |  |  | 03:30:00
 | 5K All-Terrain Forklift (Long Forks) |  |  |  | 126 | 504 | 1512 | 290 | 10 | 40 | 200 | 800 |  | 3% Air Entrainment |  |  |  | 03:45:00
 | Skytrack 10054 10K Telehandler |  |  |  | 410 | 1640 | 4920 | 290 | 10 | 40 | 200 | 800 |  | 4% Air Entrainment |  |  |  | 04:00:00
 | Other |  |  |  |  | 0 | 0 | 290 | 10 | 40 | 200 | 800 |  | 5% Air Entrainment |  |  |  | 04:15:00
 |  |  |  |  |  | 0 | 0 | 290 | 10 | 40 | 200 | 800 |  | 6% Air Entrainment |  |  |  | 04:30:00
 |  |  |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 |  |  |  |  |  | 04:45:00
 | Sub-Contractor Owned Equipment w/ Operator |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  | 05:00:00
 | [NAME] | 135 | 80 | 80 |  |  | 0 |  |  | 0 | 0 | 0 |  |  |  |  |  | 05:15:00
 | Mini Excavator | 135 | 80 | 80 |  |  | 0 |  |  | 0 | 0 | 0 |  |  |  |  |  | 05:30:00
 | Tractor Breaker | 185 | 80 | 80 |  |  | 0 |  |  | 0 | 0 | 0 |  |  |  |  |  | 05:45:00
 | Slab Excavation | 110 | 80 | 80 |  |  | 0 |  |  | 0 | 0 | 0 |  |  |  |  |  | 06:00:00
 | Pit Excavation | 110 | 80 | 80 |  |  | 0 |  |  | 0 | 0 | 0 |  |  |  |  |  | 06:15:00
 | Shuttle Time | 110 | 80 | 80 |  |  | 0 |  |  | 0 | 0 | 0 |  |  |  |  |  | 06:30:00
 | Install Sand | 110 | 80 | 80 |  |  | 0 |  |  | 0 | 0 | 0 |  |  |  |  |  | 06:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00
 | This is the pull-down list for the pump on sheet RFQ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:15:00
 | Operator |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00
 | Oiler |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:45:00
 | [NAME] (4" [NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00
 | Pea Gravel Trailer Pump (3" [NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:15:00
 | Total Feet of 4" Hard Pipe System |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:30:00
 | Total Feet of 4" [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:45:00
 | Total Feet of 3" [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00
 | 4" to 3" Reducer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:15:00
 | Snorkel for Cleanout Back to Truck |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:30:00
 | 105' Telebelt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:45:00
 | 17m Boom |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00
 | 20m Boom |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:15:00
 | 22m Boom
 | 24m Boom
 | 32m Boom
 | 39m Boom
 | 47m Boom |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:30:00
 | 58m Boom |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:45:00