Spreadsheet: 786828d1657476751-transposing-data-from-matrix-to-linear-format-sample-2-
Sheet: Master Sheet

Item | Project # | Project | Contract Amount (ex GST) | Claimed to Date | Remaining to Claim | Remaining to be Paid | Invoice #1 | Column1 | Column2 | Column3 | Column4 | Invoice #2 | Column5 | Column6 | Column7 | Column8 | Invoice #3 | Column9 | Column10 | Column11 | Column12 | Invoice #4 | Column13 | Column14 | Column15 | Column16 | Invoice #5 | Column17 | Column18 | Column19 | Column20 | Invoice #6 | Column21 | Column22 | Column23 | Column24 | Invoice #7 | Column25 | Column26 | Column27 | Column28 | Invoice #8 | Column29 | Column30 | Column31 | Column32 | Invoice #9 | Column33 | Column34 | Column35 | Column36 | Invoice #10 | Column37 | Column38 | [NAME] | Column40
 |  |  |  |  |  |  | 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
 | 2019 - 001 | Preparation of Generic Briefing Document for Literature Review and Gap Analysis |  |  |  |  | 3300 | 2019-10-28 00:00:00 | 2019-JPS-001-01 | 2019-11-21 00:00:00 | 3300
 | 2019 - 006 | Review of Community Sites | 7840 |  |  |  | 7840 | 2019-12-19 00:00:00 | 2019-006-01 | 2020-01-14 00:00:00 | 7840
 | 2019 - 014 | MITS Earthworks Review | 22680 |  |  |  | 20020 | 2020-02-19 00:00:00 | 2019-014-01 | 2020-03-12 00:00:00 | 20020 | 1540 | 2020-03-02 00:00:00 | 2019 -014-02 | 2020-03-24 00:00:00 | 1540 | 1120 | 2020-06-26 00:00:00 | 2019-014-03 | 2020-07-07 00:00:00 | 1120
 | 2019 - 015 | MITS Rigid Pavement Review | 20160 |  |  |  | 19316 | 2020-02-19 00:00:00 | 2019-015-01 | 2020-03-12 00:00:00 | 19316 | 884 | 2020-06-26 00:00:00 | 2019-015-02 | 2020-07-07 00:00:00 | 884
 | 2019 - 017 | Dickson S72 Driveway Review | 13440 |  |  |  | 9040 | 2020-03-12 00:00:00 | 2019-017-01 | 2020-03-31 00:00:00 |  | 4400 | 2020-03-26 00:00:00 | 2019-017-02 | 2020-04-07 00:00:00
 | 2019 - 027 | MITS & TRITS (RMS) Consultation | 21200 |  |  |  | 17020 | 2020-06-26 00:00:00 | 2019-027-01 | 2020-07-07 00:00:00 | 17020 | 4180 | 2020-11-25 00:00:00 | 2019-027-02 | 2020-12-03 00:00:00 | 4180
 | 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 | 2022-06-16 00:00:00
 | 2021 - 024 | Denman Prospect 3 SIR |  |  |  |  | 29817 | 2021-12-13 00:00:00 | 2021-024-01 | 2021-09-02 00:00:00 |  | 24416.39 | 2021-09-17 00:00:00 | 2021-024-02 | 2021-09-23 00:00:00 |  | 2900 | 2021-10-18 00:00:00 | 2021-024-03 | 2021-10-28 00:00:00 |  | 24036 | 2021-11-25 00:00:00 | 2021-024-04 | 2021-12-14 00:00:00 |  | 14785.5 | 2021-12-21 00:00:00 | 2021-024-05 | 2022-01-06 00:00:00 |  |  | 2022-02-02 00:00:00 | 2021-024-06 | 2022-02-10 00:00:00 |  | 4498.7 | 2022-03-10 00:00:00 | 2021-024-07 | 2022-03-17 00:00:00 |  | 10550.06 | 2022-04-13 00:00:00 | 2021-024-08 | 2022-04-26 00:00:00 | 10550.06 | 18323.47 | 2022-05-05 00:00:00 | 2021-024-09 | 2022-05-12 00:00:00 | 18323.47
 | 2021 - 025 | 42 Cowper Street | 10800 |  |  |  | 7200 | 2021-08-12 00:00:00 | 2021-025-01 | 2021-08-31 00:00:00 |  | 2800 | 2021-09-17 00:00:00 | 2021-025-02 | 2021-09-17 00:00:00 | 2800 | 800 | 2021-10-18 00:00:00 | 2021-025-03 | 2021-10-19 00:00:00 | 800
 | 2021 - 026 | [NAME] | 16000 |  |  |  | 2400 | 2021-08-12 00:00:00 | 2021-026-01 | 2021-12-12 00:00:00 |  | 11200 | 2021-09-17 00:00:00 | 2021-026-02 | 2021-10-17 00:00:00 |  | 1600 | 2021-11-25 00:00:00 | 2021-026-03 | 2021-12-12 00:00:00
 | 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-06-15 00:00:00 | 5500
 | 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 - 005 | Kooyoo Street | 5000 |  |  |  | 2400 | 2021-09-17 00:00:00 | 2022-005-01 | 2021-10-04 00:00:00 |  | 300 | 2021-11-25 00:00:00 | 2022-005-02 | 2022-03-24 00:00:00
 | 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
 | Project # | Project | Contract Amount (ex GST) | Invoice # | Amount | Date of Issue | Amount Paid | Date Paid
 | 2019 - 001 | Preparation of Generic Briefing Document for Literature Review and Gap Analysis | 3300 | 2019-JPS-001-01 | 3300 | 2019-10-28 00:00:00 | 3300 | 2019-11-21 00:00:00
 | 2019 - 006 | Review of Community Sites | 7840 | 2019-006-01 | 7840 | 2019-12-19 00:00:00 | 7840 | 2020-01-14 00:00:00
 | 2019 - 014 | MITS Earthworks Review | 22680 | 2019-014-01 | 20020 | 2020-02-19 00:00:00 | 20020 | 2020-03-12 00:00:00
 | 2019 - 014 | MITS Earthworks Review | 22680 | 2019-014-01 | 20020 | 2020-02-19 00:00:00 | 20020 | 2020-03-12 00:00:00
 | 2020 - 014 | MITS Earthworks Review | 22680 | 2019 -014-02 | 1540 | 2020-03-02 00:00:00 | 1540 | 2020-03-24 00:00:00
 | 2021 - 014 | MITS Earthworks Review | 22680 | 2019-014-03 | 1120 | 2020-06-26 00:00:00 | 1120 | 2020-07-07 00:00:00
 | Project # | Project | Contract Amount (ex GST) | Value | Amount | Date of Issue | Amount Paid | Date Paid
 | 2019 - 001 | Preparation of Generic Briefing Document for Literature Review and Gap Analysis | 3300 | 3300 | 3300 | 2019-10-28 00:00:00 | 3300 | 2019-11-21 00:00:00
 | 2019 - 006 | Review of Community Sites | 7840 | 7840 | 7840 | 2019-12-19 00:00:00 | 7840 | 2020-01-14 00:00:00
 | 2019 - 014 | MITS Earthworks Review | 22680 | 22680 | 22680 | 2020-02-19 00:00:00 | 20020 | 2020-03-12 00:00:00
 | 2019 - 014 | MITS Earthworks Review | 22680 | 1540 |  | 2020-03-02 00:00:00 | 1540 | 2020-03-24 00:00:00
 | 2019 - 014 | MITS Earthworks Review | 22680 | 1120 |  | 2020-06-26 00:00:00 | 1120 | 2020-07-07 00:00:00
 | 2019 - 015 | MITS Rigid Pavement Review | 20160 | 20200 | 20200 | 2020-02-19 00:00:00 | 19316 | 2020-03-12 00:00:00
 | 2019 - 015 | MITS Rigid Pavement Review | 20160 | 884 |  | 2020-06-26 00:00:00 | 884 | 2020-07-07 00:00:00
 | 2019 - 017 | Dickson S72 Driveway Review | 13440 | 13440 | 13440 | 2020-03-12 00:00:00 | 9040 | 2020-03-31 00:00:00
 | 2019 - 017 | Dickson S72 Driveway Review | 13440 | 4400 |  | 2020-03-26 00:00:00 | 4400 | 2020-04-07 00:00:00
 | 2019 - 027 | MITS & TRITS (RMS) Consultation | 21200 | 21200 | 21200 | 2020-06-26 00:00:00 | 17020 | 2020-07-07 00:00:00
 | 2019 - 027 | MITS & TRITS (RMS) Consultation | 21200 | 4180 |  | 2020-11-25 00:00:00 | 4180 | 2020-12-03 00:00:00
 | 2020 - 007 | [NAME] | 53940 | 53940 | 53940 | 2020-12-01 00:00:00 | 7840 | 2020-12-20 00:00:00
 | 2020 - 007 | [NAME] | 53940 | 4960 |  | 2021-06-01 00:00:00 | 4960 | 2021-01-18 00:00:00
 | 2020 - 007 | [NAME] | 53940 | 5440 |  | 2021-03-01 00:00:00 | 5440 | 2021-03-12 00:00:00
 | 2020 - 007 | [NAME] | 53940 | 7040 |  | 2021-04-04 00:00:00 | 7040 | 2021-04-21 00:00:00
 | 2020 - 007 | [NAME] | 53940 | 6720 |  | 2021-05-13 00:00:00 | 7360 | 2021-05-31 00:00:00
 | 2020 - 007 | [NAME] | 53940 | 2240 |  | 2021-06-04 00:00:00 | 2240 | 2021-06-14 00:00:00
 | 2020 - 007 | [NAME] | 53940 | 10400 |  | 2021-06-30 00:00:00 | 10400 | 2021-07-17 00:00:00
 | 2020 - 007 | [NAME] | 53940 | 3360 |  | 2021-08-12 00:00:00 | 3360 | 2021-10-14 00:00:00
 | 2020 - 007 | [NAME] | 53940 | 660 |  | 2022-03-10 00:00:00 | 641.8182 | 2022-06-16 00:00:00
 | 2021 - 024 | Denman Prospect 3 SIR | 199291.8 | 147932.798 | 147932.798 | 2021-12-13 00:00:00 | 29817 | 2021-09-02 00:00:00
 | 2021 - 024 | Denman Prospect 3 SIR | 199291.8 | 24416.39 |  | 2021-09-17 00:00:00 | 24416.3909 | 2021-09-23 00:00:00
 | 2021 - 024 | Denman Prospect 3 SIR | 199291.8 | 2900 |  | 2021-10-18 00:00:00 | 2900 | 2021-10-28 00:00:00
 | 2021 - 024 | Denman Prospect 3 SIR | 199291.8 | 24036 |  | 2021-11-25 00:00:00 | 24036 | 2021-12-14 00:00:00
 | 2021 - 024 | Denman Prospect 3 SIR | 199291.8 | 14785.5 |  | 2021-12-21 00:00:00 | 14785.5 | 2022-01-06 00:00:00
 | 2021 - 024 | Denman Prospect 3 SIR | 199291.8 | 18605.678 |  | 2022-02-02 00:00:00 | 18605.6818 | 2022-02-10 00:00:00
 | 2021 - 024 | Denman Prospect 3 SIR | 199291.8 | 4498.7 |  | 2022-03-10 00:00:00 | 4498.7 | 2022-03-17 00:00:00
 | 2021 - 024 | Denman Prospect 3 SIR | 199291.8 | 10550.06 |  | 2022-04-13 00:00:00 | 10550.06 | 2022-04-26 00:00:00
 | 2021 - 024 | Denman Prospect 3 SIR | 199291.8 | 18323.47 |  | 2022-05-05 00:00:00 | 18323.47 | 2022-05-12 00:00:00
 | 2021 - 025 | 42 Cowper Street | 10800 | 10800 | 10800 | 2021-08-12 00:00:00 | 7200 | 2021-08-31 00:00:00
 | 2021 - 025 | 42 Cowper Street | 10800 | 2800 |  | 2021-09-17 00:00:00 | 2800 | 2021-09-17 00:00:00
 | 2021 - 025 | 42 Cowper Street | 10800 | 800 |  | 2021-10-18 00:00:00 | 800 | 2021-10-19 00:00:00
 | 2021 - 026 | [NAME] | 16000 | 15200 | 15200 | 2021-08-12 00:00:00 | 2400 | 2021-12-12 00:00:00
 | 2021 - 026 | [NAME] | 16000 | 11200 |  | 2021-09-17 00:00:00 | 11200 | 2021-10-17 00:00:00
 | 2021 - 026 | [NAME] | 16000 | 1600 |  | 2021-11-25 00:00:00 | 1600 | 2021-12-12 00:00:00
 | 2022 - 001 | Gladstone Coal Exporters Sports Complex | 28300 | 28300 | 28300 | 2021-09-17 00:00:00 | 6400 | 2021-11-10 00:00:00
 | 2022 - 001 | Gladstone Coal Exporters Sports Complex | 28300 | 6000 |  | 2021-10-18 00:00:00 | 6000 | 2021-11-02 00:00:00
 | 2022 - 001 | Gladstone Coal Exporters Sports Complex | 28300 | 2800 |  | 2021-11-25 00:00:00 | 2800 | 2021-12-15 00:00:00
 | 2022 - 001 | Gladstone Coal Exporters Sports Complex | 28300 | 4400 |  | 2022-02-02 00:00:00 | 4400 | 2022-04-01 00:00:00
 | 2022 - 001 | Gladstone Coal Exporters Sports Complex | 28300 | 3200 |  | 2022-03-10 00:00:00 | 3200 | 2022-03-24 00:00:00
 | 2022 - 001 | Gladstone Coal Exporters Sports Complex | 28300 | 5500 |  | 2022-04-13 00:00:00 | 5500 | 2022-06-15 00:00:00
 | 2022 - 004 | CSIRO Ginninderra Due Diligence | 30100 | 30100 | 30100 | 2021-10-18 00:00:00 | 3200 | 2021-11-09 00:00:00
 | 2022 - 004 | CSIRO Ginninderra Due Diligence | 30100 | 7200 |  | 2021-11-25 00:00:00 | 7200 | 2021-12-07 00:00:00
 | 2022 - 004 | CSIRO Ginninderra Due Diligence | 30100 | 6200 |  | 2022-02-02 00:00:00 | 6200 | 2022-02-10 00:00:00
 | 2022 - 004 | CSIRO Ginninderra Due Diligence | 30100 | 12300 |  | 2022-03-10 00:00:00 | 12300 | 2022-05-10 00:00:00
 | 2022 - 004 | CSIRO Ginninderra Due Diligence | 30100 | 1200 |  | 2022-04-13 00:00:00 | 1200 | 2022-05-10 00:00:00
 | 2022 - 005 | Kooyoo Street | 5000 | 2700 | 2700 | 2021-09-17 00:00:00 | 2400 | 2021-10-04 00:00:00
 | 2022 - 005 | Kooyoo Street | 5000 | 300 |  | 2021-11-25 00:00:00 | 300 | 2022-03-24 00:00:00
 | 2022 - 006 | [NAME] and Rond Terrace Superintendence | 104140 | 75255 | 75255 | 2021-10-18 00:00:00 | 6400 | 2021-11-09 00:00:00
 | 2022 - 006 | [NAME] and Rond Terrace Superintendence | 104140 | 14976 |  | 2021-11-25 00:00:00 | 14976 | 2021-12-07 00:00:00
 | 2022 - 006 | [NAME] and Rond Terrace Superintendence | 104140 | 19968 |  | 2022-02-02 00:00:00 | 19968 | 2022-02-15 00:00:00
 | 2022 - 006 | [NAME] and Rond Terrace Superintendence | 104140 | 24216 |  | 2022-03-10 00:00:00 | 24216 | 2022-04-26 00:00:00
 | 2022 - 006 | [NAME] and Rond Terrace Superintendence | 104140 | 9695 |  | 2022-04-13 00:00:00 | 9695 | 2022-05-10 00:00:00