Spreadsheet: 193086d1352723675-formula-help-for-hire-summary-sheet-weekly-plant-hire
Sheet: Site 1

Weekly Plant Hire Sheet.
[NAME] | Plant Description | Cost | Per | Order Number | Date on hire | Estimated off hire date | Actual off hire date | Off hire number. | Hire Cost to Date | Add. Costs | Purchase Cost | Comment
Aqua Express | Water Cooler | 2.5 | week |  | 2010-01-14 00:00:00 |  | 2012-09-04 00:00:00 |  |  |  |  | Not to purchase; Sanitation costs still occur
Wernick | Steel Stairs | 6 | Week | 5501/7301 | 2010-08-03 00:00:00 |  |  |  |  |  |  | £1,800 new; £900 used
Wernick | [NAME] | 57 | week | 5501/7607 | 2010-11-26 00:00:00 |  | 2012-01-26 00:00:00
Speedy | 5/3 Cement Mixer | 15 | Week | 5501/8258 | 2011-07-13 00:00:00 |  | 2011-08-31 00:00:00 | 138047747-2
Speedy | Masonry Table Saw | 57.6 | Week | 5501/8288 | 2011-07-25 00:00:00 |  | 2011-08-19 00:00:00 |  |  | 315 |  | [NAME] - lots of blocks in underbuild
MacKenzie | Road Sweeper | 300 | Day | 5501/7518 | 2011-07-27 00:00:00 |  | 2011-07-27 00:00:00
Speedy | 12nr  no.2 Trestles |  | Week | 5501/8409 | 2011-08-06 00:00:00 |  | 2011-09-21 00:00:00 | 138047759/6
Speedy | 24nr  13ft timber battens |  | Week | 5501/8409 | 2011-08-06 00:00:00 |  | 2011-09-21 00:00:00 | 138047759/6
Speedy | 12 x no2 Trestles |  | Week | 5501/8352 | 2011-08-09 00:00:00 |  | 2011-08-19 00:00:00 |  |  |  |  | Underbuilding Blockwork
Speedy | 24 x 13ft Scaffold Boards | 43.2 | Week | 5501/8352 | 2011-08-09 00:00:00 |  | 2011-08-19 00:00:00 |  |  |  |  | Underbuilding Blockwork
Speedy | 3nr Fixed Boss Platform | 15 | Week | 5501/8352 | 2011-08-09 00:00:00 |  | 2011-08-19 00:00:00 |  |  |  |  | Underbuilding Blockwork
Leggat | 80T Crane | 1000 | Day | 5501/8329 | 2011-08-18 00:00:00 |  | 2011-08-18 00:00:00 | 12837 |  |  |  | Steel Decking Lift
Speedy | 110v Puddle Pump | 21.02 | Week | 5501/8357 | 2011-08-22 00:00:00 |  | 2011-08-23 00:00:00 | C141416967 |  |  |  | [NAME]
Speedy | 2.4Kva [NAME] 110v | 21.48 | Week | 5501/8357 | 2011-08-22 00:00:00 |  | 2011-08-23 00:00:00 | C141416967
Leggat | Road Brush Visit | 135 | 4 Hours | 5501/8365 | 2011-08-25 00:00:00 |  | 2011-08-25 00:00:00
Speedy | 1/2 Bag Petrol Mixer | 10 | Week | 5501/8353 | 2011-08-26 00:00:00 |  | 2011-09-30 00:00:00 | C141495216
Apex | 10 Kva Generator | 66 | week | 5501/8433 | 2011-09-12 00:00:00 |  | 2011-10-05 00:00:00 | 2149 |  | 180 |  | £90-Delivery £90- Collection
Apex | 1000L Bunded Fuel Tank | 10 | week | 5501/8433 | 2011-09-12 00:00:00 |  | 2011-10-05 00:00:00 | 2149
Speedy | Dehumidifier | 30.68 | week | 5501/8436 | 2011-09-12 00:00:00 |  | 2011-10-07 00:00:00 | C141500746
Speedy | 110V Submersible pump | 20.35 | week | 5501/8475 | 2011-09-21 00:00:00 |  | 2011-09-22 00:00:00 | 138074494-4
Speedy | [NAME] | 17.18 | week | 5501/8475 | 2011-09-21 00:00:00 |  | 2011-09-22 00:00:00 | 138074494-4
Speedy | 12nr No.3 Trestles |  | week | 5501/8501 | 2011-09-29 00:00:00 |  | 2011-10-24 00:00:00 | 138047506-2 |  |  |  | 2 no. lost - DG to speak to [NAME]
Speedy | 24nr  13ft timber battens |  | week | 5501/8501 | 2011-09-29 00:00:00 |  | 2011-10-24 00:00:00 | 138047506-2 |  | 11.18 |  | Damage Board £11.18 - 2 missing
Speedy | stihl saw | 10 | week | 5501/8502 | 2011-09-30 00:00:00 |  | 2011-09-30 00:00:00 | C141495211
Speedy | [NAME] | 21.48 | week | 5501/8502 | 2011-10-03 00:00:00 |  | 2011-10-07 00:00:00 | C141503205
Speedy | Submersible Pump | 25.44 | week | 5501/8502 | 2011-10-03 00:00:00 |  | 2011-10-07 00:00:00 | C141503205
Speedy | 10nr Accros No.1 type | 23.6 | week | 5501/8520 | 2011-10-04 00:00:00 |  | 2012-01-18 00:00:00 | [PHONE]-10
Speedy | Stihl Saw | 10 | week | 5501/8564 | 2011-10-19 00:00:00 |  | 2011-10-21 00:00:00
Speedy | Masonry Table Saw | 57.6 | week | 5501/8560 | 2011-10-21 00:00:00 |  | 2011-11-03 00:00:00 | [PHONE]-4
Speedy | 10nr heras fence panel | 14 | week | 5501/8586 | 2011-10-24 00:00:00 |  | 2011-11-02 00:00:00 |  |  |  |  | Purchased - 2/11/11
Speedy | 110V Submersible pump | 25.44 | week | 5501/8570 | 2011-10-24 00:00:00 |  | 2011-10-28 00:00:00 | [PHONE]-4
Speedy | 20nr Pedestrian Barriers | 36 | week | 5501/8586 | 2011-10-24 00:00:00 |  | 2011-11-02 00:00:00 |  |  |  |  | Purchased - 2/11/11
Speedy | [NAME] | 21.48 | week | 5501/8570 | 2011-10-24 00:00:00 |  | 2011-10-28 00:00:00 | [PHONE]-4
Leggat | Road Sweeper | 135 | 4Hours | 5501/8588 | 2011-10-25 00:00:00 |  | 2011-10-25 00:00:00
Leggat | Road Sweeper | 135 | 4Hours | 5501/8588 | 2011-10-26 00:00:00 |  | 2011-10-26 00:00:00
Speedy | [NAME] bottle | 11.872 | week | 5501/8620 | 2011-11-01 00:00:00 |  | 2011-11-03 00:00:00 | [PHONE]-4 |  | 33 |  | £33 - Diamond blade
Speedy | [NAME] | 17.18 | week | 5501/8644 | 2011-11-08 00:00:00 |  | 2011-11-10 00:00:00 | 0138-075385-4
Speedy | T76 hilti breaker | 20 | week | 5501/8644 | 2011-11-08 00:00:00 |  | 2011-11-10 00:00:00 | 0138-075385-4 |  |  |  | Condensation, walls require vents
Speedy | 4nr 110v floodlights + cables | 26.4 | week | 5501/8663 | 2011-11-16 00:00:00 |  | 2011-11-21 00:00:00 | C141591595
Speedy | [NAME] | 21.48 | week | 5501/8663 | 2011-11-16 00:00:00 |  | 2011-11-25 00:00:00 | [PHONE]-9
Leggat | Road Brush Visit | 135 | 4 Hours | 5501/8665 | 2011-11-16 00:00:00 |  | 2011-11-16 00:00:00
Speedy | T76 hilti breaker | 20 | week | 5501/8663 | 2011-11-16 00:00:00 |  | 2011-11-21 00:00:00
Speedy | 4nr space heaters |  | week | 5501/8701 | 2011-11-21 00:00:00 |  | 2012-06-04 00:00:00 |  |  |  | 0 | 3nr 47kg refills- 26/1/12 -  Technician repaired 2 units 26/1/12; 3nr 31/1/12; 4 nr refill 06/02/2012, 4nr refill 23/2/12
Speedy | Submersible Pump | 20.35 | week | 5501/8680 | 2011-11-21 00:00:00 |  | 2011-11-25 00:00:00 | [PHONE]-9
Speedy | Core Gun incl 52, 38[NAME] bits | 26.6 | Week | 5501/8742 | 2011-12-07 00:00:00 |  | 2011-12-22 00:00:00 | 138047910-1 |  | 45 |  | Wear rate £45.00
speedy | 4 Nr Extension cables | 4 | week | 5501/8766 | 2011-12-15 00:00:00 |  | 2011-12-22 00:00:00 | 138047910-1
Speedy | 4 Nr floodlights incl tripods | 26.4 | week | 5501/8766 | 2011-12-15 00:00:00 |  | 2011-12-22 00:00:00 | 138047910-1 |  |  |  | 1 floodlight not delivered 15/12/11
[NAME] | 20ft Steel Container | 10.5 | week | 5501/8722 | 2011-12-19 00:00:00 |  | 2012-07-06 00:00:00 |  |  |  |  | [NAME]
[NAME] | 20ft Steel Container | 10.5 | week | 5501/8722 | 2011-12-19 00:00:00 |  | 2012-09-07 00:00:00 |  |  |  |  | [NAME]
Speedy | [NAME] + extension cable | 37.86 | week | 5501/8778 | 2011-12-20 00:00:00 |  | 2011-12-22 00:00:00 | 138047910-1
Speedy | Submersible Pump | 28.48 | week | 5501/8800 | 2012-01-04 00:00:00 |  | 2012-01-10 00:00:00 | 468096
Speedy | Core Gun , extension bar, 30+50mm diamond bits |  | week | 5501/8799 | 2012-01-10 00:00:00 |  | 2012-02-16 00:00:00 | 0138-047847-1
Speedy | [NAME] | 23.2 | week | 5501/8809 | 2012-01-12 00:00:00 |  | 2012-01-23 00:00:00 | [PHONE]-8
Speedy | T76 hilti breaker |  | week | 5501/8809 | 2012-01-12 00:00:00 |  | 2012-01-23 00:00:00 | [PHONE]-8
Leggat | Road Sweeper | 135 | 4 Hours | 5501/8816 | 2012-01-13 00:00:00 |  | 2012-01-13 00:00:00
Speedy | 2nr Floodlights + 1nr 110v spider |  | week | 5501/8825 | 2012-01-16 00:00:00 |  | 2012-01-23 00:00:00 | [PHONE]-8
Speedy | 4nr Acro props | 10 | week | 5501/8845 | 2012-01-20 00:00:00 |  | 2012-03-07 00:00:00
[NAME] | 1nr Half bag mixer | 10 | week | 5501/8844 | 2012-01-23 00:00:00 |  | 2012-01-27 00:00:00 | 3083083
Easi-Uplifts | [NAME] | 360 | week | 5501/8848 | 2012-01-24 00:00:00 |  | 2012-02-03 00:00:00 | 32-JH |  | 120 |  | £60 Pick up + £60 Delivery
Leggat | Road Sweeper | 135 | 4 Hours | 5501/8851 | 2012-01-25 00:00:00 |  | 2012-01-25 00:00:00
Leggat | Road Sweeper | 135 | 4 Hours | 5501/8851 | 2012-01-26 00:00:00 |  | 2012-01-26 00:00:00
Leggat | Road Sweeper | 135 | 4 Hours | 5501/8851 | 2012-01-27 00:00:00 |  | 2012-01-27 00:00:00
Speedy | 25nr Pedestrian Barriers |  | week | 5501/8876 | 2012-01-31 00:00:00 |  | 2012-03-30 00:00:00 |  |  |  | 525 | Purchased - 30/3/12 - £525 - added to asset list
Leggat | Road Sweeper | 135 | 4 Hours | 5501/8884 | 2012-02-02 00:00:00 |  | 2012-02-02 00:00:00
Leggat | Road Sweeper | 185 | 6 Hours | 5501/8884 | 2012-02-03 00:00:00 |  | 2012-02-03 00:00:00
Leggat | Road Sweeper | 185 | 6 Hours | 5501/8884 | 2012-02-04 00:00:00 |  | 2012-02-04 00:00:00
Speedy | 8nr Trestles | 22.08 | week | 5501/8903 | 2012-02-06 00:00:00 |  | 2012-03-23 00:00:00 | 074531-8
Apex | 15 Kva Generator | 117 | week | 5501/8902 | 2012-02-07 00:00:00 | 2012-03-27 00:00:00 | 2012-06-13 00:00:00 |  |  |  |  | Incl Fuel Tank - £90 Deliver + £90 Collect +£250 fuel feb- fuel manage = £0.88ppl
Leggat | Road Sweeper | 100 | 4 Hours | 5501/8910 | 2012-02-09 00:00:00 |  | 2012-02-09 00:00:00
Speedy | 4nr 110v spiders | 8 | week | 5501/8927 | 2012-02-13 00:00:00 |  | 2012-03-07 00:00:00
Speedy | 7nr floodlights (tripod type) | 51.1 | week | 5501/8927 | 2012-02-13 00:00:00 |  | 2012-03-07 00:00:00
Speedy | 9nr extension cables | 9 | week | 5501/8927 | 2012-02-13 00:00:00 |  | 2012-03-07 00:00:00
Speedy | [NAME] | 23.2 | week | 5501/8927 | 2012-02-13 00:00:00 |  | 2012-03-07 00:00:00
Speedy | T76 hilti breaker | 37.5 | week | 5501/8927 | 2012-02-13 00:00:00 |  | 2012-02-15 00:00:00 | 074511-3
Speedy | Petrol Masonry Table Saw | 60.48 | week | 5501/8927 | 2012-02-14 00:00:00 |  | 2012-02-20 00:00:00 | 074514-1
Speedy | Submersible Pump | 27.48 | week | 5501/8963 | 2012-02-27 00:00:00 |  | 2012-02-29 00:00:00 | 074520-7 |  |  |  | picked up late - 6/3/12 - Speedy's own fault
Apex | 30KVA generator + cable |  | week | 5501/9001 | 2012-03-07 00:00:00 |  | 2012-03-15 00:00:00 | 2857 |  |  |  | £90 delivery + £90 pick up + fuel management
Leggat | Road Sweeper | 185 | 6 Hours | 5501/9004 | 2012-03-12 00:00:00 |  | 2012-03-12 00:00:00 |  | 185
Speedy | Submersible Pump | 28.48 | week | 5501/9008 | 2012-03-12 00:00:00 |  | 2012-04-13 00:00:00 | [PHONE]-4
Speedy | [NAME] | 12 | week | 5501/9016 | 2012-03-13 00:00:00 |  | 2012-03-15 00:00:00 | 074529-5
Easi-Uplifts | [NAME] | 360 | week | 5501/9021 | 2012-03-15 00:00:00 |  | 2012-03-16 00:00:00 | LM-1378 |  |  |  | £60 Pick up + £60 Delivery + £99.75 Fuel
Leggat | Road Sweeper | 100 | 4 Hours | 5501/9057 | 2012-03-26 00:00:00 |  | 2012-03-26 00:00:00
Leggat | Road Sweeper | 100 | 4 Hours | 5501/9066 | 2012-03-28 00:00:00 |  | 2012-03-28 00:00:00
Leggat | Road Sweeper | 100 | 4 Hours | 5501/9066 | 2012-03-29 00:00:00 |  | 2012-03-29 00:00:00
Leggat | Road Sweeper | 100 | 4 Hours | 5501/9066 | 2012-03-30 00:00:00 |  | 2012-03-30 00:00:00
Speedy | Stihl Saw | 10 | week | 5501/9096 | 2012-04-10 00:00:00 |  | 2012-04-29 00:00:00 | Ma0134523 |  | 31.77 |  | On Loan to [NAME] Bricklaying- all costs contra'd
Speedy | Generator | 23.2 | week | 5501/9118 | 2012-04-17 00:00:00 |  | 2012-04-18 00:00:00 | [PHONE]-1
Speedy | [NAME] + extension cable | 37.5 | week | 5501/9118 | 2012-04-17 00:00:00 |  | 2012-04-18 00:00:00 | [PHONE]-1
Speedy | 4nr #3 Accros | 8 | week | 5501/9151 | 2012-05-02 00:00:00 |  | 2012-05-22 00:00:00 |  |  |  |  | Switched for #1 Acro's on 18/5/12
Speedy | Floor Planer incl Knock down box | 88.4 | week | 5501/9151 | 2012-05-02 00:00:00 |  | 2012-05-04 00:00:00 | [PHONE]-2
Leggat | Road Sweeper | 135 | week | 5501/9159 | 2012-05-04 00:00:00 |  | 2012-05-04 00:00:00
Easi-Uplifts | [NAME] | 500 | week | 5501/9164 | 2012-05-09 00:00:00 |  | 2012-05-31 00:00:00 | KM191-1806 |  |  |  | £60 pick up, £60 delivery, £130 Fuel
Speedy | 25nr Heras fence panels + clips + bases | 49 | week | 5501/9167 | 2012-05-10 00:00:00 |  | 2012-06-22 00:00:00 | 0467/245039/4 |  | 0
Speedy | Stihl Saw | 10 | week | 5501/9181 | 2012-05-10 00:00:00 |  | 2012-05-11 00:00:00 | MA0134498 |  | 4.13 |  | On Loan to [NAME] Bricklaying- all costs contra'd
Leggat | Road Sweeper | 135 | 4 Hours | 5501/9176 | 2012-05-11 00:00:00 |  | 2012-05-11 00:00:00
Leggat | Road Sweeper | 135 | 4 Hours | 5501/9206 | 2012-05-17 00:00:00 |  | 2012-05-17 00:00:00
Leggat | Road Sweeper | 135 | 4 Hours | 5501/9206 | 2012-05-18 00:00:00 |  | 2012-05-18 00:00:00
Speedy | Stihl Saw | 10 | week | 5501/9181 | 2012-05-18 00:00:00 |  | 2012-05-19 00:00:00
Leggat | Road Sweeper | 135 | 4 Hours | 5501/9232 | 2012-05-23 00:00:00 |  | 2012-05-23 00:00:00
Leggat | Road Sweeper | 135 | 4 Hours | 5501/9232 | 2012-05-24 00:00:00 |  | 2012-05-24 00:00:00
Leggat | Road Sweeper | 100 | 4 Hours | 5501/9232 | 2012-05-25 00:00:00 |  | 2012-05-25 00:00:00
Leggat | Road Sweeper | 135 | 4 Hours | 5501/9232 | 2012-06-01 00:00:00 |  | 2012-06-01 00:00:00
Speedy | 4 Nr 110v transformers | 12 | week | 5501/9262 | 2012-06-08 00:00:00 |  | 2012-08-31 00:00:00 | 0138/047698/2 |  | 46.25 |  | 3nr transformers off hired 22/6/12
Leggat | Road Sweeper | 100 | 4 Hours | 5501/9232 | 2012-06-08 00:00:00 |  | 2012-06-08 00:00:00
Leggat | Road Sweeper | 100 | 4 Hours | 5501/9232 | 2012-06-10 00:00:00 |  | 2012-06-10 00:00:00
Leggat | Road Sweeper | 100 | 4 Hours | 5501/9232 | 2012-06-19 00:00:00 |  | 2012-06-19 00:00:00
Leggat | Road Sweeper | 100 | 4 Hours | 5501/9232 | 2012-06-20 00:00:00 |  | 2012-06-20 00:00:00
Leggat | Road Sweeper | 100 | 4 Hours | 5501/9232 | 2012-06-21 00:00:00 |  | 2012-06-21 00:00:00
Leggat | Road Sweeper | 150 | 6 Hours | 5501/9232 | 2012-06-25 00:00:00 |  | 2012-06-25 00:00:00
Speedy | Core Gun + 2nr cores | 26.6 | Week | 5501/9306 | 2012-06-29 00:00:00 |  | 2012-07-02 00:00:00
Leggat | Road Sweeper | 100 | 4 Hours | 5501/9232 | 2012-06-29 00:00:00 |  | 2012-06-29 00:00:00
EnviroClean | CCTV Inspection | 1300 | 1 Day | 5501/9411 | 2012-08-10 00:00:00 |  | 2012-08-10 00:00:00
Leggat | Road Sweeper | 135 | 4 Hours | 5501/9232 | 2012-08-10 00:00:00 |  | 2012-08-10 00:00:00
Speedy | 3m [NAME] | 39.23 | week | 5501/9421 | 2012-08-15 00:00:00 |  | 2012-08-15 00:00:00 | 0250-1618-1412 |  | 25
Leggat | Road Sweeper | 135 | 4 Hours | 5501/9232 | 2012-08-19 00:00:00 |  | 2012-08-19 00:00:00
Leggat | Road Sweeper | 135 | 4 Hours | 5501/9232 | 2012-08-21 00:00:00 |  | 2012-08-21 00:00:00
Leggat | Road Sweeper | 135 | 4 Hours | 5501/9232 | 2012-08-24 00:00:00 |  | 2012-08-24 00:00:00
Leggat | Road Sweeper | 100 | 4 Hours | 5501/9232 | 2012-08-24 00:00:00 |  | 2012-08-24 00:00:00
Speedy | [NAME] + extension cable | 30 | week | 5501/9468 | 2012-08-29 00:00:00 |  | 2012-08-31 00:00:00
Speedy | 240V Dehumidifier + MCB |  | week | 5501/9490 | 2012-09-10 00:00:00 |  | 2012-09-12 00:00:00 | 0138/050035/4
Speedy | [NAME] |  | week | 5501/9505 | 2012-09-13 00:00:00 |  | 2012-09-13 00:00:00
Leggat | Road Sweeper | 100 | 4 Hours | 5501/9232 | 2012-09-27 00:00:00 |  | 2012-09-27 00:00:00
Leggat | Road Sweeper | 100 | 4 Hours | 5501/9232 | 2012-09-27 00:00:00 |  | 2012-09-27 00:00:00 | 0138/050047/5
Leggat | Road Sweeper | 100 | 4 Hours | 5501/9232 | 2012-09-27 00:00:00 |  | 2012-09-27 00:00:00
Speedy | Dehumidifier | 36.16 | week | 5501/9532 | 2012-10-01 00:00:00 |  | 2012-10-04 00:00:00
Speedy | [NAME] toilet | 30 | week | 5501/9532 | 2012-10-01 00:00:00 |  | 2012-10-11 00:00:00 | AW-524959 |  | 50
Leggat | Road Sweeper | 100 | 4 Hours | 5501/9232 | 2012-10-03 00:00:00 |  | 2012-10-03 00:00:00
Leggat | Road Sweeper | 100 | 4 Hours | 5501/9232 | 2012-10-08 00:00:00 |  | 2012-10-08 00:00:00
Total
Year | Month | Month Total
2012
2012
2012
2012
2012
2012
2012
2012
2012
2012
2012
2012