Material Record Tpl

Location on ribbon: Tab DVD Cons → Group QAQC and Diary → Menu Templates

Command ID: btnMaterialRecordTpl

What it does

Opens FormNTVL.xlsx, the incoming-material acceptance record template shipped with DVDAddin. The form already contains the delivery details block, certificate (CO/CQ) references, inspection results and the signature block for all parties.

Use it every time material arrives on site and has to be accepted before use: cement, rebar, blocks, aggregate, ready-mix concrete, finishing materials.

How to use

1. Click Templates ▸ Material Record Tpl in the QAQC and Diary group.
2. The add-in looks for Template\FormNTVL.xlsx in the add-in install folder (C:\DVDAddin\Template\), then in a Template\ folder next to the active workbook.
3. The template opens in Excel.
4. Fill in the general information (project, works, location, province, contract, package, parties) on sheet TTC. Enter one row per delivery on sheet DATA (material code, building element, material, grade, date received, form numbers, inspection date and times, sampling and test report number, signatories), then type the number of the row to print in cell B9 of DATA — YCNTVL, BBNTVL, BBKTVL and BBLMVL fill themselves from that row.
5. Save As with a record-specific name so the shipped template stays untouched.

Video tutorial

Narrated in Vietnamese, with Vietnamese subtitles. Kế hoạch và Biên bản nghiệm thu · 6 min 59 s · 12 cases · Download the video · Practice workbook for the video

Commands in this video: Acceptance Plan · Acceptance Record · Material Record Tpl · Work Record Tpl

Chapters (17)

1. Giới thiệu
2. Mở lệnh
3. 1 · Lập kế hoạch từ tiến độ
4. 2 · Tiêu đề phải cùng một dòng
5. 3 · Dòng tổng, cột Cấp, chạy lại
6. 4 · Mốc và ngày nghiệm thu
7. 5 · Rà cột Tiêu chuẩn áp dụng
8. Lệnh Biên bản NT
9. 6 · Biên bản cho một công việc
10. 7 · Không đạt – nghiệm thu lại
11. 8 · Nhiều việc, một biên bản
12. 9 · Kèm chỉ tiêu thí nghiệm
13. 10 · Mỗi việc một biên bản
14. 11 · Mẫu NT công việc, vật liệu
15. 12 · Khi nhập sai
16. Mẹo
17. Kết thúc

Illustrated walkthrough

Practice

Download this command's sample workbook — the data matches the pictures below (sheet TTC), so you can follow each step right away.

Step 1. On the ribbon, open the DVD Cons tab → QAQC and Diary group → open Templates → choose Material Record Tpl.

Step 2. The add-in opens the template FormNTVL.xlsx from the add-in folder C:\DVDAddin\Template\ (failing that, from a Template\ folder next to the open workbook; if neither exists it lists the paths it searched). Go to sheet TTC (1) and fill in the general information (2): every form in the file takes the project, works, package and parties from here, and Tỉnh thành (province) starts the "…, ngày … tháng … năm …" date line of the records.

Step 3. On sheet DATA (material acceptance record list) each row is one delivery: material code, building element, material, grade, date received, form numbers, inspection date and times, sampling and test report number, signatories. Type the number of the row to print in cell B9: YCNTVL (material acceptance request), BBNTVL (material acceptance record), BBKTVL (material checklist) and BBLMVL (sampling record) fill themselves from that row. Attach the CO/CQ and test reports when the forms go for signature.

Step 4. Use Save As with your own name, for example D:\DuAn\VP9T\BBNT-VatLieu-Thep.xlsx — the file you opened is the original in the install folder, and editing it directly spoils the shared template. The forms are a starting point; check them against the client's / supervision consultant's own formats.

Example

A delivery of Ø18 CB400-V rebar arrives on 12 March: click Material Record Tpl, fill in the project details on sheet TTC, add a row on sheet DATA for the delivery (material, grade Ø18 CB400-V, received 12/03, inspection date and times, samples for tensile and bend testing), type that row's number in cell B9 of DATA so the forms pick it up, then save it as BBNT-VL-THEP-03.xlsx to sign alongside the CO/CQ and the delivery note.

Notes

• If the file is not found the add-in shows a warning listing the paths it searched — usually a sign the Template\ folder is missing from the installation.
• For workbooks on OneDrive or SharePoint the add-in also checks for a Template\ folder beside the locally synced copy.
• The file that opens is the master copy in the install folder — always Save As before editing.
• A material acceptance record normally needs the CO/CQ and laboratory test certificates attached; the template only provides the frame.

Related

• Work Record Tpl — acceptance record for completed work items.
• Test Plan — generates the required TCVN test criteria for these same materials.
• Diary Template — the daily construction diary form.