Sample Workbooks — Bundled template files

DVDAddin ships 6 sample Excel files — open one and it is ready to use, with no need to design the column structure yourself. These are not decorative files: many of the add-in's commands read data using the exact sheet names and column order of these templates, so starting from a template is the surest way to get a command working correctly on the first try.

Installation location

The installer places every template file in:

C:\DVDAddin\Template\
├── GanttChart.xlsx          — construction schedule (Gantt)
├── RebarCutOptimizer.xlsx   — rebar cut optimization
├── FormNTCV.xlsx            — work acceptance
├── FormNTVL.xlsx            — material acceptance
├── FormNKCT.xlsx            — construction diary
└── SendEmail.xlsx           — bulk email sending

Besides the installation folder, the add-in also looks for a Template\ folder next to the open workbook — handy when you want to publish your company's own template set to the whole team. If it is found in neither place, the add-in reports an error listing the paths it probed.

Opening a template from the ribbon

Each template has its own command to open it; they are not gathered into a single menu:

Template file	Command to open	Location
GanttChart.xlsx	Gantt Tpl	DVD Cons → Schedule → Setup
RebarCutOptimizer.xlsx	Cutting Tpl	DVD Cons → Optimizer → Templates
FormNTCV.xlsx	Work Record Tpl	DVD Cons → QAQC and Diary → Templates
FormNTVL.xlsx	Material Record Tpl	DVD Cons → QAQC and Diary → Templates
FormNKCT.xlsx	Diary Template	DVD Cons → QAQC and Diary → Templates
SendEmail.xlsx	Email Template	DVD Addin → File and Print → Email Menu

Save As before editing

Gantt Tpl opens a new workbook built from the template, so the original is safe. The other five commands open the original file itself in the installation folder — do a Save As to another location immediately, otherwise you will damage the machine's shared template.

The other two cutting problems do not use a template file; they create sheets directly in the open workbook: Bar Tpl generates CatThanh_Phoi + CatThanh_Thanh and Panel Tpl generates CatTam_Phoi + CatTam_Tam, both with sample data so you can trial-run them.

The template list

1. GanttChart.xlsx — Construction schedule

The input template for Gantt Chart and the whole Schedule command group.

Sheet	Purpose
HuongDan	Explains each column plus the FS / SS / FF / SF relationship code table
Input	List of public holidays, the weekly working calendar, and the solar–lunar calendar cross-reference table
MHC.VP_Schedule_Template	Full schedule table (with EVM columns), sample data from an office refurbishment project
OPL.HY_Schedule_Templete	Condensed schedule table, sample data from a foundation–structure job

The standard columns the add-in recognizes, in exactly the order used in MHC.VP_Schedule_Template:

Activity ID · Activity Name · Duration · Start · Finish · Predecessors · Constraint Type · Constraint Date · Level · Main Activity · Manpower · Actual Start · Actual Finish · Complete (%) · Schedule % · Forecast · Δ Finish · Status · Remaining Duration · BAC · AC · EV · PV · SV · SPI · Note · Photo URL · Total Float · Free Float

The condensed OPL.HY_Schedule_Templete table keeps only the first 12 columns — enough to draw the Gantt chart, not enough for EVM.

How to use:

1. Open the template → pick one of the two schedule sheets → delete the sample data and enter your own tasks.
2. Write Predecessors as Activity ID + relationship code, for example MHC1060FS, MHC1090SS, MHC1150FF.
3. Level is the grouping level; mark Main Activity with Y for the main tasks.
4. Turn on Auto Calc so the schedule recalculates automatically when you edit Duration / Start / Finish.
5. Click Gantt Chart, choose the Month / Week / Day scale and the column to start drawing from.

The template also ships with a few sample output sheets produced by the PRO commands (EVM Report …, Dashboard …, Lookahead …, the _BL_… baseline sheets and the _Snap_… snapshots) so you can see what the output looks like before running them yourself. Delete them when you build a real schedule.

2. RebarCutOptimizer.xlsx — Rebar cut optimization

The input template for Rebar Cut. The sheet names are numbered in working order:

Sheet	Contents
HuongDan	Step-by-step instructions
00_ThietLapChung	Kerf, allowed cutting tolerance (±), dead-end offcut, scrap limit (%)
01_DuongKinh	Steel grade, diameter, kg/m, standard stock-bar length, splice type, splice length, reuse (Yes/No)
02_NhuCauCat	Main input table — Cấu kiện (member) · Số hiệu (mark) · Mác thép (steel grade) · Đường kính (diameter) · Chiều dài yêu cầu (required length) · Số lượng (quantity) · Cho phép nối (splicing allowed, Yes/No) · Ghi chú (note)
04_TonKhoDu	Leftover pieces still in stock for the algorithm to reuse
03_KetQuaCat	Result — plan code, cutting details, number of bars, offcuts, utilization %
05_PhieuIn	Result — cutting tickets issued to the workshop, with a diagram of every bar
06_ThepRac	Result — offcuts that cannot be reused
07_BaoCaoTong	Result — summary of new bars, new kg, stock kg used and scrap kg by diameter

How to use: fill in 00, 01, 02 (and 04 if you have leftover stock) → press Rebar Cut → review in the rebar cut preview window → ✓ Apply to write the four result sheets. Pressing Close cancels completely and no sheet is written.

The columns that decide the quality of the plan

Cho phép nối (Yes/No) on 02_NhuCauCat and Chiều dài cây tiêu chuẩn on 01_DuongKinh. Set No for bars nearly as long as an 11.7 m stock bar and every plan will produce large offcuts.

3. FormNTCV.xlsx — Work Acceptance Report

A work-acceptance dossier set, already wired up to Batch print.

Sheet	Purpose
DATA	Data table, one acceptance dossier per row
Mucluc	Declares the row-expansion cell + page-break rows for each sheet, and the Work code → Sheets to print table
TTC, TCXD	Project information and the list of applicable construction standards
DMTD_DoBT, DMTD_Dot	Tracking lists for concrete pour batches
YCNTCV / BBNTCV	Work acceptance request form and work acceptance report
YCNTGD / BBNTGD	Stage acceptance
YCNTBG / BBNTBG	Handover acceptance
KT_* (17 sheets)	A separate inspection checklist for each work item — see the table just below
HinhAnh, MatBang	Site photos and layout drawings attached to the dossier
DVDAddinSetting	Hidden sheet storing this workbook's Batch print configuration

The 17 ready-made work inspection checklists:

KT_DD earth excavation · KT_SD earth levelling and filling · KT_LD backfilling · KT_BTL lean concrete · KT_CT rebar · KT_VK formwork · KT_DBT concrete pouring · KT_LMBT concrete sampling · KT_CLBT concrete quality · KT_XT masonry walls · KT_TT wall plastering · KT_BBSL skim coat + primer · KT_SP topcoat paint · KT_LN floor screed · KT_OL tiling · KT_TBVS sanitary fixture installation · KT_HRT steel fencing.

The main columns of DATA (header row on row 10): STT (no.) · SỐ HS (dossier no.) · MÃ CV (work code) · HẠNG MỤC (work package) · CẤU KIỆN (member) · VỊ TRÍ (location) · ĐỐI TƯỢNG NGHIỆM THU (item being accepted) · THỜI GIAN THI CÔNG (construction period) · YÊU CẦU NGHIỆM THU (acceptance request) · NGHIỆM THU CÔNG VIỆC (work acceptance) · ĐỢT ĐỔ BT (concrete pour batch) · KHỐI LƯỢNG (quantity) · MÁC BÊ TÔNG (concrete grade) · ĐỘ SỤT TK (design slump) · SỐ KQTN (test result no.) · THÀNH PHẦN KÝ HỒ SƠ (signatories) · TIÊU CHUẨN XÂY DỰNG (construction standards) · MẶT BẰNG (layout) · GHI CHÚ (note).

How to use:

1. Fill in DATA, one dossier per row. The MÃ CV column decides which set of sheets is printed — look it up in the table on the right-hand side of the Mucluc sheet (DD → YCNTCV+BBNTCV+KT_DD, BT → YCNTCV+BBNTCV+KT_DBT+KT_LMBT+KT_CLBT…).
2. Open Batch print — the configuration is already saved in the workbook: driver cell DATA!$B$9, sheet-print cell DATA!$B$8, filename cell DATA!$T$9.
3. Set the number range (continuous or individual values) → Export PDF or Print.

4. FormNTVL.xlsx — Material Acceptance Report

The same mechanism as FormNTCV, but for incoming materials.

Sheet	Purpose
DATA	One accepted material lot per row
Mucluc	Row-expansion / page-break cells + the Material code → Material name table (THEP → Cốt thép / rebar, GTN → Gạch tuynen / tunnel-kiln brick, GBL → Gạch block / concrete block, SN → Sơn nước / emulsion paint…)
TTC, SoHS, BangTra, DMTD, DMTD_Dot	Project information, dossier numbering, lookup tables and tracking lists
YCNTVL / BBNTVL	Material acceptance request form and material acceptance report
BBKTVL / BBKTLM_Thep / BBLMVL	Inspection report, steel inspection and sampling report, material sampling report
PrintSetting	Batch print configuration: driver DATA!$B$9, sheet-print DATA!$B$8, filename DATA!$J$9

The main columns of DATA: STT (no.) · STT HSNT (acceptance dossier no.) · MÃ VẬT LIỆU (material code) · HẠNG MỤC (work package) · ĐỐI TƯỢNG NGHIỆM THU (item being accepted — Vật liệu / Chủng loại, material / type) · NGÀY NHẬP KHO (date received into store) · SỐ BIÊN BẢN (report numbers — 4 form numbers) · PHIẾU YC (request form) · NGHIỆM THU VL (material acceptance) · KIỂM TRA – LẤY MẪU (inspection – sampling, with a Lấy Mẫu Yes/No column, Ngày KQ, Số KQ) · KÝ BIÊN BẢN (report signatures — CĐT / TVGS / Nhà thầu, i.e. employer / supervision consultant / contractor, with job titles) · GHI CHÚ (note).

The Lấy Mẫu column = YES/NO is the work code that drives the printed sheet set: YES also prints BBLMVL, NO does not.

5. FormNKCT.xlsx — Construction Diary

Sheet	Purpose
DATA	The diary table, one row per day
NKCT	The one-page printed form for a single day, pulling data through the driver cell
DMTD	List of equipment / materials entering and leaving the site over the whole project
DMTD_Ngay	List of equipment / materials for just the day being printed
Mucluc, PrintSetting, DVDAddinSetting	Sheet and Batch print configuration

The column groups of DATA: STT (no.) · Ngày (date) · Thời tiết (weather — Nắng / Mưa / Nhiệt độ / Thời gian mưa: sun, rain, temperature, rain duration) · Nhân lực (manpower — site manager, engineer, safety officer, storekeeper, security guard, workers, plus spare columns) · Thiết bị (equipment — pile-jacking robot, excavator, bulldozer, roller, mixer, survey instrument, laser level, plus spares) · ATLĐ – VSMT (occupational safety – environmental sanitation) · Công tác thi công trong ngày (work carried out that day) · Công tác nghiệm thu trong ngày (acceptance carried out that day) · Người ký (signatories — DVTC / TVGS, contractor / supervision consultant) · Theo dõi tình trạng nhật ký (diary status tracking) · Ghi chú (note).

This template's Batch print configuration differs from the two above: driver cell DATA!$A$3, sheet-print cell DATA!$A$2, filename cell DATA!$A$1.

How to use: add one row to DATA every day; at the end of the month open Batch print, set the number range to that month's STT range and hit Export PDF — one page per day. Also use New Diary to expand the work-item catalog into daily content instead of typing it by hand, and Pick Rest Days to declare non-working days.

6. SendEmail.xlsx — Bulk Email Sending

The input template for Send Email. The SendEmail sheet has its header row on row 9 and data from row 10:

Column	Contents
No.	Sequence number — also the value of the driver cell when sending in bulk
Send Date	Send date
Sender Email	The Outlook account used to send
To / Cc / Bcc	Recipients; separate multiple addresses with ;
Subject	Message subject
Name	Recipient name (multiple lines with Alt+Enter)
Company	The recipient's organization
Body	Message body
Link	Links to insert into the message, one per line as Label: address or just the address
Attachment	Path of the attached file — one path per line (Alt+Enter)
Note	Internal note, not sent

How to use: fill in the table → open Send Email → point each field (To, Subject, Recipient name, Company, Body, Attachment) at the matching cell with the ⤴ button → turn on the Bulk frame, set the Driver cell (n) to the sequence-number cell and pick the number range → press Preview for the first pass, then Send.

Sending through Outlook

The command sends mail through Microsoft Outlook on the machine; it does not connect to a mail server directly. Outlook must be installed with an account already configured. A message that has been sent cannot be recalled — always Preview the first pass.

Building your own template

Design rules for a Batch print template

The three record templates above all follow the same pattern, which you can apply to your own forms:

1. One data sheet (usually named DATA), one dossier per row, with a clear header row.
2. A driver cell at a fixed position — the add-in writes the number of the current loop iteration into this cell. Every formula in the form refers to it.
3. A form sheet that uses INDEX/MATCH or VLOOKUP keyed on the driver cell:

   =INDEX(DATA!$A:$AH, DATA!$B$9, MATCH("ĐỐI TƯỢNG NGHIỆM THU", DATA!$10:$10, 0))

4. A sheet-print cell holding the names of the sheets to print in that iteration, joined with +:

   YCNTCV+BBNTCV+KT_DD

   Have a formula build this string from the work code so that each dossier automatically prints its own set of forms.
5. A filename cell holding a formula that builds the PDF file name for each iteration:

   ="BBNTCV_"&INDEX(DATA!$D:$D, $B$9)&"_"&TEXT(TODAY(),"yyyy-mm-dd")

6. Open Batch print, point the three cells above at the right positions and press Save — the settings are written to the hidden DVDAddinSetting sheet inside the workbook, so the configuration travels with the file when you send it to someone else.

If the form has picture cells using the dvdPic formula with no picture attached yet, remember to turn on the two options skip a range / print page that has dvdPic but no image so you do not get blank pages.

Design rules for a Merge to Word template

1. Open Word → design the complete layout (logo, header, footer, styles).
2. At each position to be filled, type a placeholder in the form [TenCot] — square brackets, matching the column header on the sheet exactly, including Vietnamese diacritics and spaces.
3. Put all the template files in one folder — the Merge to Word window selects by folder and lets you tick several templates so that each data row produces a complete set of documents.
4. The data range scanned in Excel must include the header row; pick one column for the output file name, and that column should hold unique values.

Placeholders inside the template's header / footer / text boxes may not be replaced — trial-run a few rows before releasing the whole batch.

Sharing templates with the team

Putting your own template set next to the workbook

Because the add-in also probes the Template\ folder next to the open workbook, the neatest way to publish your company's own templates is:

D:\DuAn_ABC\
├── Template\
│   ├── FormNTCV.xlsx        ← version adjusted to the employer's requirements
│   └── GanttChart.xlsx
└── 01_TienDo.xlsx

Anyone who opens a file in the project folder gets exactly that template set, no matter what is installed on their machine.

Versioning templates

Name the file with a version: BBNT_v2_2026-05.xlsx — whoever comes next knows which version they are holding. Record the changes on a Changelog sheet at the end of the file.

Locking the template against accidental edits

File → Info → Protect Workbook → Mark as Final, or set password sheet protection on the configuration sheets (Mucluc, PrintSetting, DVDAddinSetting).

Related

• Batch print — run a form as a loop over the driver cell.
• Merge to Word — generate Word files from a [TenCot] template.
• Gantt Chart — build a Gantt chart from GanttChart.xlsx.
• Rebar Cut — run the algorithm on RebarCutOptimizer.xlsx.
• New Diary — expand the work-item catalog into the construction diary.
• Full command reference — 186 ribbon commands.