Spreadsheet: 704544d1605618608-extract-and-return-a-values-in-a-summary-sheet-from-various-sheets-book1-1-
Sheet: Summary

 |  |  |  |  |  |  |  |  |  |  |  |  | desired results
Date | Ref | Description | Man Hours | Plant Hours | Tender-Labour | Tender-Plant | Actual-Labour | Actual-Plant |  |  |  |  | Date | Ref | Description | Man Hours | Plant Hours | Tender-Labour | Tender-Plant | Actual-Labour | Actual-Plant
Date | Ref | Activity | Man Hours | Plant Hours | Tender-Hour | Tender-Plant | Actual Cost | Actual-Plant |  | 2020-11-01 00:00:00 | C001.1 | Labour -Site Related Activities | 20 | 0 | 0 | 0 | 219.2 | 0
2020-11-01 00:00:00 | C001.1 | Labour -Site Related Activities | 20 | 0 | 0 | 0 | 219.2 | 0 |  | 2020-11-01 00:00:00 | C001.1 | Labour -Site Related Activities | 30 | 0 | 0 | 0 | 328.8 | 0
2020-11-01 00:00:00 | C001.1 | Labour -Site Related Activities | 30 | 0 | 0 | 0 | 328.8 | 0 |  | 2020-11-01 00:00:00 | A022 | Backfilling for Utilites | 20 | 2 | 525.6 | 333 | 219.2 | 320
2020-11-01 00:00:00 | A022 | Backfilling for Utilites | 20 | 2 | 525.6 | 333 | 219.2 | 320 |  | 2020-11-01 00:00:00 | A021 | Excavation for Utilities | 50 | 35 | 936 | 2644.8 | 548 | 2825
2020-11-01 00:00:00 | A021 | Excavation for Utilities | 50 | 35 | 936 | 2644.8 | 548 | 2825 |  | 2020-11-01 00:00:00 | A021 | Excavation for Utilities | 40 | 28 | 780 | 2204 | 438.4 | 2580
2020-11-01 00:00:00 | A021 | Excavation for Utilities | 40 | 28 | 780 | 2204 | 438.4 | 2580 |  | 2020-11-01 00:00:00 | A045 | Other-General Works | 40 | 0 | 0 | 0 | 438.4 | 0
2020-11-01 00:00:00 | A045 | Other-General Works | 40 | 0 | 0 | 0 | 438.4 | 0 |  | 2020-11-01 00:00:00 | A032 | 1400mm dia. Pipe laying | 44 | 8 | 354.0802993527508 | 477.1475323624596 | 482.24 | 1240
2020-11-01 00:00:00 | A032 | 1400mm dia. Pipe laying | 44 | 8 | 354.0802993527508 | 477.1475323624596 | 482.24 | 1240
2020-11-02 00:00:00 | C001.1 | Labour -Site Related Activities | 20 | 0 | 0 | 0 | 219.2 | 0 |  | 2020-11-02 00:00:00 | C001.1 | Labour -Site Related Activities | 20 | 0 | 0 | 0 | 219.2 | 0
2020-11-02 00:00:00 | C001.1 | Labour -Site Related Activities | 30 | 0 | 0 | 0 | 328.8 | 0 |  | 2020-11-02 00:00:00 | C001.1 | Labour -Site Related Activities | 30 | 0 | 0 | 0 | 328.8 | 0
2020-11-02 00:00:00 | A022 | Backfilling for Utilites | 20 | 2 | 525.6 | 333 | 219.2 | 320 |  | 2020-11-02 00:00:00 | A022 | Backfilling for Utilites | 20 | 2 | 525.6 | 333 | 219.2 | 320
2020-11-02 00:00:00 | A021 | Excavation for Utilities | 50 | 35 | 936 | 2644.8 | 548 | 2825 |  | 2020-11-02 00:00:00 | A021 | Excavation for Utilities | 50 | 35 | 936 | 2644.8 | 548 | 2825
2020-11-02 00:00:00 | A021 | Excavation for Utilities | 40 | 28 | 780 | 2204 | 438.4 | 2580 |  | 2020-11-02 00:00:00 | A021 | Excavation for Utilities | 40 | 28 | 780 | 2204 | 438.4 | 2580
2020-11-02 00:00:00 | A045 | Other-General Works | 40 | 0 | 0 | 0 | 438.4 | 0 |  | 2020-11-02 00:00:00 | A045 | Other-General Works | 40 | 0 | 0 | 0 | 438.4 | 0
2020-11-02 00:00:00 | A032 | 1400mm dia. Pipe laying | 44 | 8 | 354.0802993527508 | 477.1475323624596 | 482.24 | 1240 |  | 2020-11-02 00:00:00 | A032 | 1400mm dia. Pipe laying | 44 | 8 | 354.0802993527508 | 477.1475323624596 | 482.24 | 1240