Spreadsheet: 786330d1657117587-count-specific-cells-with-multiple-criteria-duplicated-content-must-only-be-counted-once-test-project-tracker-work-in-progress-christhomas99-
Sheet: Vacant Property Input

 |  |  | Year | Date From | Date to | Target Properties | Budget Allocation | Current Quoted Works | Fully Invoiced Work | Budget Balance Based on Quoted & Invoiced Works
 |  |  | 2022 | 2022-06-01 00:00:00 | 2022-12-31 00:00:00 | 35
 |  |  | 2023 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 | 80
 |  |  | 2024 | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 | 120
 |  |  | 2025 | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 | 65
 |  |  | Year | Date From | Date to | Target Properties | In Progress | Complete | On Hold Awaiting Approval | No. Metro | No. Regional | Total Properties | Targeted Homes Still Required
 |  |  | 2022 | 2022-06-01 00:00:00 | 2022-12-31 00:00:00
 |  |  | 2023 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00
 |  |  | 2024 | 2024-01-01 00:00:00 | 2024-12-31 00:00:00
 |  |  | 2025 | 2025-01-01 00:00:00 | 2025-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UPGRADES UNDERTAKEN |  |  |  |  |  |  |  |  |  |  |  |  | Totals
 | Date Property Identified | Manager | Main Contact Contact | Property ID | Property Address | Suburb | Postcode | Property Type | Metro / Regional | Builder | Date Issued for Scoping | Date Scope Accepted | Phoptos Received with Scope | Total  Business Days to Receive Scope | Property Status | P/O # | W/O Category Overide Checked | Cost Centre | W/O Category Overide Confirmed | Date Work Actually Started | % of Completon | Date Completed | Total Business Days Undertaken | Initial/Quoted ValueValue Excl. GST | Variation Value | Total Quoted Cost | Total Invoiced Cost | Final Inspection Date | Inspected By | Sold Date | Scope ID for Photos | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Comments | [NAME] | CPL | IP | HLD
 | 2022-06-21 00:00:00 | [NAME] | [NAME] | 8500000103 | 39 Green St | Suburb 1 | 112345 | HSE | Regional | [NAME] the Builder | 2022-06-21 00:00:00 | 2022-06-21 00:00:00 | YES |  | IP - Work in Progress | 810947/1 | 2022-07-01 00:00:00 | AB127 | NO | 2022-06-22 00:00:00 | 0 |  |  | 38598.64 |  |  |  |  |  |  | 52393 | Concrete Driveway | Paving | Window Replacement | Painting Indoor | Fencing & Gates
 | 2022-06-21 00:00:00 | [NAME] | [NAME] | 8500000103 | 39 Green St | Suburb 1 | 112345 | HSE | Regional | [NAME] the Builder | 2022-06-21 00:00:00 | 2022-06-21 00:00:00 | YES |  | CPL - Works Complete | 811861/1 | 2022-07-01 00:00:00 | AB127 | NO | 2022-06-22 00:00:00 | 0 |  |  | 17298.15 |  |  |  |  |  |  | 52393 | [NAME]
 | 2022-06-24 00:00:00 | [NAME] | [NAME] | 430023852 | 6 Start  Ct | Suburb 6 | 251081 | HSE | Metro | Smurfs R Us | 2022-07-04 00:00:00 |  |  |  | IP - Issued for Scoping |  |  | AB127 | NO |  | 0
 | 2022-06-28 00:00:00 | [NAME] | [NAME] | 11103108 | 10 Celtic Close | Suburb 3 | 250442 | FLT | Metro | Mr [NAME] |  |  |  |  | HLD - Awaiting Approval |  |  | AB127 | NO |  | 0
 | 2022-06-28 00:00:00 | [NAME] | [NAME] | 11103511 | 11 Celtic Close | Suburb 3 | 450442 | HSE | Metro | Mr [NAME] |  |  |  |  | HLD - Awaiting Approval |  |  | AB127 | NO |  | 0
 | 2022-06-28 00:00:00 | [NAME] | [NAME] | 11103167 | 12 Celtic Close | Suburb 3 | 450442 | HSE | Metro | Mr [NAME] |  |  |  |  | HLD - Awaiting Approval |  |  | AB127 | NO |  | 0
 | 2022-06-28 00:00:00 | [NAME] | [NAME] | 11103087 | 13 Celtic Close | Suburb 3 | 650441 | FLT | Metro | Mr [NAME] |  |  |  |  | HLD - Awaiting Approval |  |  | AB127 | NO |  | 0
 | 2022-06-28 00:00:00 | [NAME] | [NAME] | 11103079 | 14 Celtic Close | Suburb 3 | 650446 | FLT | Metro | Mr [NAME] |  |  |  |  | HLD - Awaiting Approval |  |  | AB127 | NO |  | 0
 | 2022-06-28 00:00:00 | [NAME] | [NAME] | 11103693 | 15 Celtic Close | Suburb 3 | 850446 | FLT | Metro | Mr [NAME] |  |  |  |  | HLD - Awaiting Approval |  |  | AB127 | NO |  | 0
 | 2022-06-28 00:00:00 | [NAME] | [NAME] | 11103685 | 16 Celtic Close | Suburb 3 | 250446 | FLT | Metro | Mr [NAME] |  |  |  |  | HLD - Awaiting Approval |  |  | AB127 | NO |  | 0
 | 2022-06-28 00:00:00 | [NAME] | [NAME] | 11103773 | 17 Celtic Close | Suburb 3 | 250446 | FLT | Metro | Mr [NAME] |  |  |  |  | HLD - Awaiting Approval |  |  | AB127 | NO |  | 0
 | 2022-06-28 00:00:00 | [NAME] | [NAME] | 300000154 | 89 [NAME] | Suburb 7 | 252904 | HSE | Regional | Smurfs R Us | 2022-07-01 00:00:00 |  |  |  | IP - Issued for Scoping | 811089/1 |  | AB127 | NO |  | 0
 | 2022-06-28 00:00:00 | [NAME] | [NAME] | 300000154 | 89 [NAME] | Suburb 7 | 252904 | HSE | Regional | Smurfs R Us | 2022-07-01 00:00:00 |  |  |  | IP - Issued for Scoping | 811388/1 |  | AB127 | NO |  | 0
 | 2022-06-28 00:00:00 | [NAME] | Nevill Porter | 590004457 | 44 [NAME] | Suburb 5 | 756064 | HSE | Regional | Smurfs R Us | 2022-07-04 00:00:00 |  |  |  | IP - Issued for Scoping |  |  | AB127 | NO |  | 0
 | 2022-06-28 00:00:00 | [NAME] | [NAME] | 90005026 | 33 Lexcen Walk | Suburb 2 | 751682 | HSE | Metro | Mr [NAME] |  |  |  |  | HLD - Awaiting Approval |  |  | AB127 | NO |  | 0
 | 2022-06-28 00:00:00 | [NAME] | [NAME] | 740045595 | 199 [NAME] | Suburb 2 | 756082 | HSE | Regional | [NAME] the Builder | 2022-07-04 00:00:00 |  |  |  | IP - Issued for Scoping |  |  | AB127 | NO |  | 0