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

 |  | Round-Trip Travel Cost (Actual Travel Days Only) |  |  |  |  |  |  |  | Airfare: |  | 125 |  | Hotel Rate: |  |  | 250 |  | Per-Diem Food Allowance |  |  |  |  |  | Advance Work
 |  |  | No. of Men | Hr. Up | Days on Site | Hr. Back | Hr. or [NAME] | Round Trip Cost |  | No. of Tkts. | Round Trip Fare | Total Airfare |  | No. of Rooms | No. of Nights | Hotel Rate | Total Hotel |  | Man Days | Per Diem | No. of Chk | Check Amt | Total Per Diem |  | Description | Men | Hours | Rate | Cost
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2 | 8 | 55 | 880
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  | Tiger Management | 1 | 8 | 4 | 8 | 55 | 880 |  | 1 | 125 | 125 |  | 1 | 6 | 250 | 1500 |  | 6 | 35 | 1 | 210 | 210 |  |  |  | 0 | 0 | 0
 |  | Tiger Management | 1 | 8 |  | 8 | 55 | 880 |  | 1 | 125 | 125 |  | 1 | 2 | 250 | 500 |  | 2 | 35 | Invoiced |  | 70 |  |  |  | 0 | 0 | 0
 |  | Tiger Management Trainee |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Total: | 880
 |  | Tiger Hourly Employees | 2 | 8 | 4 | 8 | 55 | 1760 |  | 2 | 125 | 250 |  | 1 | 6 | 250 | 1500 |  | 6 | 35 | 2 | 210 | 420
 |  | Carpenters |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | FREIGHT & SHIPPING
 |  | Carpenter - Laborers |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | Description |  | No. | Rate | Total
 |  | Finshers |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | Freight - CA to Job |  | 1 | 2500 | 2500
 |  | Finsher - Laborers |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | Freight - Job to CA |  |  | 2500 | 0
 |  | Demolition Crew |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 |  | Delivery Charges (Grating) |  |  | 350 | 0
 |  | Rod Busters |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 |  | Ship Demo Equipment |  |  | 5500 | 0
 |  | Sawcutter |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 |  | Other |  |  | 2500 | 0
 |  | Pumper |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  |  |  | 0
 |  | Other |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0
 |  | ± Extra Rooms: |  |  |  |  |  | 3520 |  | Total: | 500 |  |  | 0 | 1 | 0 | 0 |  | 14 |  | 3 | Total: | 700 |  |  | Total: |  | 2500
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Total: | 3500
 |  | Equipment Rentals |  |  |  |  |  |  |  |  |  |  |  | Travel Summary |  |  |  |  | Alternate Totals
 |  | Rental Description | No. | Time | Cost |  | Deliv. | Fuel | Tax % |  | Total Rental |  |  | Round Trip Travel Cost: |  |  | 3520 |  | Equipment Rentals: |  |  |  | 3095.5125
 |  | [NAME] | 1 | Day | 125 |  | 0 | 18.75 | 0.1 |  | 156.25 |  |  | Extra Labor Costs |  |  | 2500 |  | Mobilization Expense: |  |  |  | 15203
 |  | [NAME] |  |  | 0 |  | 0 | 0 | 0 |  | 0 |  |  | Air Fare: |  |  | 500 |  | Total: |  |  |  | 18298.5125
 |  | Bobcat 435 Rubber Track Mini Ex | 1 | Day | 475 |  | 290 | 40 | 0.1 |  | 852.5 |  |  | Hotel Cost: |  |  | 3500
 |  | Breaker for Mini Ex | 1 | Day | 308 |  | 0 | 0 | 0.1 |  | 338.8 |  |  | Food Per-Diem: |  |  | 700 |  | Alternate Totals
 |  | 48" Bucket for Mini Ex | 1 | Day | 30 |  | 0 | 0 | 0.1 |  | 33 |  |  | Equipment Rentals: |  |  | 2691.75 |  | Equipment Rentals: |  |  |  | 3095.5125
 |  | Bobcat S175 w/ 6' Smooth Bucket | 1 | Day | 592 |  | 290 | 40 | 0.1 |  | 981.2 |  |  | Freight & Shipping: |  |  | 2500 |  | Freight & Shipping: |  |  |  | 2875
 |  | [NAME] for Skid Steer | 1 | Day | 300 |  | 0 | 0 | 0.1 |  | 330 |  |  | Other: |  |  |  |  | Mobilization Expense: |  |  |  | 12328
 |  | Small Loader: [NAME] |  |  | 0 |  | 0 | 0 | 0 |  | 0 |  |  | Other: |  |  |  |  | Total: |  |  |  | 18298.5125 |  | Named Range in Cell to the left
 |  | Hammer for Backhoe |  |  | 0 |  | 0 | 0 | 0 |  | 0 |  |  | Other:
 |  | Dump Truck: 6 Yard |  |  | 0 |  | 0 | 0 | 0 |  | 0 |  |  | Other:
 |  | Wacker RD11A 36" Drum Ride-on Roller |  |  | 0 |  | 0 | 0 | 0 |  | 0 |  |  | Sub-Total: |  |  | 15911.75
 |  | Loader: Cat 414E w/ Rear Grade Attachment |  |  | 0 |  | 0 | 0 | 0 |  | 0 |  |  | 0.15 |  |  | 2386.7625
 |  | Skytrack 10054 10K Telehandler |  |  | 0 |  | 0 | 0 | 0 |  | 0 |  |  | Total: |  |  | 18298.5125
 |  | 5K Warehouse Forklift |  |  | 0 |  | 0 | 0 | 0 |  | 0
 |  | Other |  |  | 0 |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  | Total: |  | 2691.75