Spreadsheet: 780285d1652373171-return-multiple-values-across-many-rows-and-columns-20210302-projects
Sheet: Master Sheet

 | All cost amounts in table are exclusive of GST
Item | Project # | Project | Contract Amount (ex GST) | Claimed to Date | Remaining to Claim | Remaining to be Paid | Invoice #1 |  |  |  |  | Invoice #2 |  |  |  |  | Invoice #3 |  |  |  |  | Invoice #4 |  |  |  |  | Invoice #5 |  |  |  |  | Invoice #6 |  |  |  |  | Invoice #7 |  |  |  |  | Invoice #8 |  |  |  |  | Invoice #9 |  |  |  |  | Invoice #10
 |  |  |  |  |  |  | Amount | Date of Issue | Invoice # | Date Paid | Amount Paid | Amount | Date of Issue | Invoice # | Date Paid | Amount Paid | Amount | Date of Issue | Invoice # | Date Paid | Amount Paid | Amount | Date of Issue | Invoice # | Date Paid | Amount Paid | Amount | Date of Issue | Invoice # | Date Paid | Amount Paid | Amount | Date of Issue | Invoice # | Date Paid | Amount Paid | Amount | Date of Issue | Invoice # | Date Paid | Amount Paid | Amount | Date of Issue | Invoice # | Date Paid | Amount Paid | Amount | Date of Issue | Invoice # | Date Paid | Amount Paid | Amount | Date of Issue | Invoice # | Date Paid | Amount Paid
 | 2020 - 007 | [NAME] |  |  |  |  | 7840 | 2020-12-01 00:00:00 | 2020-007-01 | 2020-12-20 00:00:00 |  |  | 2021-06-01 00:00:00 | 2020-007-02 | 2021-01-18 00:00:00 |  |  | 2021-02-01 00:00:00 | 2020-007-03 | 2021-02-17 00:00:00 |  | 5440 | 2021-03-01 00:00:00 | 2020-007-04 | 2021-03-12 00:00:00 |  | 7040 | 2021-04-04 00:00:00 | 2020-007-05 | 2021-04-21 00:00:00 |  | 6720 | 2021-05-13 00:00:00 | 2020-007-06 | 2021-05-31 00:00:00 |  | 2240 | 2021-06-04 00:00:00 | 2020-007-07 | 2021-06-14 00:00:00 |  | 10400 | 2021-06-30 00:00:00 | 2020-007-08 | 2021-07-17 00:00:00 |  | 3360 | 2021-08-12 00:00:00 | 2020-007-09 | 2021-10-14 00:00:00 |  | 660 | 2022-03-10 00:00:00 | 2020-007-10
 | 2021 - 014 | Hanwood Stormwater Peer Review | 10000
 | 2021 - 015 | Lake Wyangan Detailed Design |  |  |  |  | 3240 | 2021-04-04 00:00:00 | 2021-015-01 | 2021-05-31 00:00:00 |  | 1080 | 2021-05-13 00:00:00 | 2021-015-02 | 2021-06-20 00:00:00 |  | 1080 | 2021-09-17 00:00:00 | 2021-015-03 | 2021-10-14 00:00:00 |  | 12910 | 2021-11-25 00:00:00 | 2021-015-04 | 2022-02-13 00:00:00 |  | 37120 | 2022-04-29 00:00:00 | 2021-015-05
 | 2022 - 001 | Gladstone Coal Exporters Sports Complex |  |  |  |  | 6400 | 2021-09-17 00:00:00 | 2022-001-01 | 2021-11-10 00:00:00 |  | 6000 | 2021-10-18 00:00:00 | 2022-001-02 | 2021-11-02 00:00:00 |  | 2800 | 2021-11-25 00:00:00 | 2022-001-03 | 2021-12-15 00:00:00 |  | 4400 | 2022-02-02 00:00:00 | 2022-001-04 | 2022-04-01 00:00:00 |  | 3200 | 2022-03-10 00:00:00 | 2022-001-05 | 2022-03-24 00:00:00 |  | 5500 | 2022-04-13 00:00:00 | 2022-001-06
 | 2022 - 002 | Throsby Playing Fields Review |  |  |  |  | 10400 | 2021-09-17 00:00:00 | 2022-002-01 | 2021-11-10 00:00:00 |  | 2600 | 2021-11-25 00:00:00 | 2022-002-02 | 2022-01-05 00:00:00
 | 2022 - 004 | CSIRO Ginninderra Due Diligence |  |  |  |  | 3200 | 2021-10-18 00:00:00 | 2022-004-01 | 2021-11-09 00:00:00 |  | 7200 | 2021-11-25 00:00:00 | 2022-004-02 | 2021-12-07 00:00:00 |  | 6200 | 2022-02-02 00:00:00 | 2022-004-03 | 2022-02-10 00:00:00 |  |  | 2022-03-10 00:00:00 | 2022-004-04 | 2022-05-10 00:00:00 | 12300 | 1200 | 2022-04-13 00:00:00 | 2022-004-05 | 2022-05-10 00:00:00 | 1200
 | 2022 - 006 | [NAME] and Rond Terrace Superintendence |  |  |  |  | 6400 | 2021-10-18 00:00:00 | 2022-006-01 | 2021-11-09 00:00:00 |  | 14976 | 2021-11-25 00:00:00 | 2022-006-02 | 2021-12-07 00:00:00 |  | 19968 | 2022-02-02 00:00:00 | 2022-006-03 | 2022-02-15 00:00:00 |  | 24216 | 2022-03-10 00:00:00 | 2022-006-04 | 2022-04-26 00:00:00 |  | 9695 | 2022-04-13 00:00:00 | 2022-006-05 | 2022-05-10 00:00:00 | 9695
 | 2022 - 011 | [NAME] | 2200 |  |  |  | 1980 | 2022-05-05 00:00:00 | 2022-011-01
 | 2022 - 012 | ACT Standards Review |  |  |  |  | 5880 | 2022-05-05 00:00:00 | 2022-012-01
 | 2022 - 013 | Scotts Crossing Signals | 880 |  |  |  | 880 | 2022-04-13 00:00:00 | 2022-013-01
 | 2022 - 014 | Parkes Signals | 440 |  |  |  | 440 | 2022-04-13 00:00:00 | 2022-014-01
 | 2022 - 015 | Gungahlin Rural Block 348 |  |  |  |  | 1650 | 2022-04-13 00:00:00 | 2022-015-01
 | 2022 - 018 | Windle Road Sports Precinct | 1000 |  |  |  | 440 | 2022-05-05 00:00:00 | 2022-018-01
 |  |  |  |  |  |  | Sum for Year | 2021-07-01 00:00:00 | 2022-06-30 00:00:00
 |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  | Sum for Year | 2020-07-01 00:00:00 | 2021-06-30 00:00:00
 |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  | Sum for Year | 2019-07-01 00:00:00 | 2020-06-30 00:00:00
 |  |  |  |  |  |  |  | Total
 |  | [NAME] | 660 | 2022-03-10 00:00:00
 |  | Lake Wyangan Detailed Design | 37120 | 2022-04-29 00:00:00
 |  | Gladstone Coal Exporters Sports Complex | 5500 | 2022-04-13 00:00:00
 |  | [NAME] | 1980 | 2022-05-05 00:00:00
 |  | ACT Standards Review | 5880 | 2022-05-05 00:00:00
 |  | Scotts Crossing Signals | 880 | 2022-04-13 00:00:00
 |  | Parkes Signals | 440 | 2022-04-13 00:00:00
 |  | Gungahlin Rural Block 348 | 1650 | 2022-04-13 00:00:00
 |  | Windle Road Sports Precinct | 440 | 2022-05-05 00:00:00