Test Plan (QA/QC)

Test Plan and Acceptance Plan, both in the QAQC and Diary group of the DVD Cons tab, cover the planning half of a construction quality file: which material needs which tests, to which standard and at what frequency — and which work item has to be accepted on which date.

They are aimed at QA/QC engineers and site managers at project start-up, or whenever the supervision consultant asks for the test plan / acceptance listing for the coming stage.

PRO feature

Both commands belong to the PRO tier. STANDARD accounts activated before 1 July 2026 keep access until their licence expires; other Standard accounts get an upgrade dialog.

Commands in this group

Command	What it does
Test Plan	Reads material names in the selection, matches the bundled TCVN/QCVN database and generates a seven-column test-plan sheet
Acceptance Plan	Reads the schedule on the active sheet and generates a ten-column acceptance plan (Decree 06/2021 + Circular 10)
Material Record Tpl	Opens FormNTVL.xlsx — the acceptance record for the very materials you just planned tests for
Work Record Tpl	Opens FormNTCV.xlsx — the work acceptance record that follows the acceptance plan
Preferences	Choose the AI service and enter the API key used by the TCVN suggestion feature

Setting up the quality plan at project start-up

1. Select the material or work-item names — typically the material column of a bill of quantities.
2. Click Test Plan. The Test Plan Generator window opens and the Source selection line reports the sheet, range and cell count it captured. If you change the selection afterwards, click 🔁 Reselect.
3. Optionally tick Use AI to suggest TCVN for queries outside the database — the box is disabled while no API key is configured.
4. Click 🔍 Preview. The grid lists each matched material with the columns # | From cell | Material | Standard | # Tests | AI, and the status line summarises materials found, criteria and unmatched queries.
5. Deal with the unmatched entries: tidy the material names on the sheet, or open ⚙ Manage DB… and tick materials straight from the database (that route needs no selection at all).
6. Click 📄 Generate Sheet → a sheet named Kế hoạch TN YYYY-MM-DD with seven columns: No., Material, Criterion, Test standard, Sampling standard, Sample spec, Notes/Frequency. The No. and Material columns are merged per material block.
7. Review the italic rows — those are the AI suggestions, and the standard number must be verified before the sheet goes into a quality file.
8. Once the programme is fixed, run Acceptance Plan on the schedule sheet to get the dated acceptance listing, then use Material Record Tpl / Work Record Tpl for the individual records.

Example

The substructure BoQ has a material column reading:

Cell	Material in the BoQ	Scan result
C12	Ready-mix concrete M300	Matched — compressive strength, slump… with sampling frequency
C18	Rebar CB400-V	Matched — tensile and bend tests per batch
C25	Fill sand	Matched — grading, silt and clay content…
C31	Tunnel-kiln brick	Matched — compressive strength, water absorption…

Select C12, C18, C25, C31 → Test Plan → 🔍 Preview (four rows with the criteria count each) → 📄 Generate Sheet. Sheet Kế hoạch TN 2026-08-22 prints as is, with row heights already auto-fitted.

Tips and caveats

• Make the selection before opening the window, unless you go through ⚙ Manage DB… and tick materials there. Clicking 📄 Generate Sheet without a preview prompts you to scan first.
• AI-suggested blocks are flagged in italic in the output sheet — AI can cite the wrong TCVN number, so always verify.
• The AI fallback uses whichever service you picked in Preferences ▸ AI Assistant (Gemini / OpenAI / Groq / NVIDIA) and needs a valid API key.
• The database is TCVN-Standards.json (baseline) plus TCVN-Custom.json (your own entries) in %APPDATA%\DVDAddin; custom entries survive a reinstall. After editing, click 🔄 Reload DB to pick the change up without restarting Excel.
• The ⚙ Manage DB… window lets you filter baseline vs custom entries, add or delete materials and criteria, back up / restore the custom file and import from Excel — handy for standardising one database across the QA/QC team.
• The output sheet is named by date; running it twice in one day overwrites it, and that cannot be undone with Ctrl+Z.
• Acceptance Plan requires a recognisable schedule table on the active sheet (task names plus Start/Finish dates); the planned acceptance date is always the task finish date, so adjust it on the output sheet if you need a different one.

See also

• Construction Diary — the record catalog and daily diary side of the same quality file.
• Acceptance Plan — every field of the acceptance plan window in detail.
• Gantt Chart — build the schedule table that Acceptance Plan can detect.
• Preferences — choose the AI provider and enter the API key.