All resources

ChatGPT · Architecture & BTP · XLSX

Construction defects tracker

Update an Excel register with history, summary and breakdown by trade.

Follow the tutorial

Before you start

Existing register, source records, new observations, agreed dates and verification evidence. The session must support reading your files and creating the requested format. Pack deliverables are in French.

Construction defects tracker with ChatGPT: method

1. Download the skill

Download the ZIP pack below and keep it without extracting it. The standalone SKILL.md file is also available under details, with the exact filename required by the importer.

Download the ZIP pack

2. Import the skill into ChatGPT

On the skill import screen, select the downloaded ZIP and complete the import. Then open a conversation and ask ChatGPT to use the “suivi-reserves” skill. If your interface does not offer skill imports, paste the contents of SKILL.md into the conversation as instructions.

3. Add project documents

Existing register, source records, new observations, agreed dates and verification evidence.

4. Generate and review the draft

Reuse the workbook and its IDs. The pack specifies three sheets: Suivi des réserves, Synthèse and Par lot. Preserve initial observations, dates and updates; a reported repair needs verification. Summary indicators must use formulas referencing actual sheet names.

A request to try

Use my installed skill « suivi-reserves ». Fictional example: R12 concerns lobby paint. The contractor reports a repair without a closure inspection. Add the report to history and keep the defect open. An unspecified inspection date remains pending. Create a downloadable French draft in XLSX. If a capability is unavailable, say so without claiming to have created a file.

5. Check the result

  • Check IDs, totals by status and formulas on an empty register. Deadlines and clearance dates must not be invented.
  • Open the file and check readability, incomplete fields and source references.
Files and advanced installation

The instruction file is in French.

Download the ZIP packDownload the instructions — SKILL.md ↓

Pack adapted for ChatGPT. Keep the complete ZIP: it includes the workbook structure reference. For manual use, provide that reference alongside the instructions.