Introduction
DVDAddin is a professional Excel add-in for construction professionals — translation, quantity surveying, schedule charting, mail-merge to Word, batch PDF printing, integrated AI assistant.
Key features
1. Domain-specific translation
- Google Translate free (default).
- Gemini / ChatGPT / Groq / Cerebras — more accurate for construction terminology. The prompt is tuned for:
- Rebar: starter bar, dowel bar, stirrup, rebar
- Concrete: lean concrete, blinding concrete, construction joint
- Pile foundations: bored pile, jacked-in pile, raft foundation
- FIDIC / TCVN / ISO terms
2. Gantt chart drawing
- Auto-compute start/finish dates from project start + duration.
- Resource Histogram below.
- Critical path, % complete progress bars.
- Display options: start/finish dates, duration, milestones.
3. Mail merge to Word
- Source: Excel table.
- Destination: Word template with
{{placeholder}}. - Output: 1 Word/PDF file per data row.
- Use cases: acceptance reports, contracts, official letters, payslips.
4. Batch print + PDF export
- Loop a number range (Start..End or discrete list).
- Each iteration: change driver cell → recalculate → print/export PDF.
- Smart page break placement, AutoFilter refresh, auto-fit merged cells.
- Merge multiple PDFs into one final file (PdfSharp).
5. Integrated AI assistant
- AI Assistant: chat with AI to analyze tables, suggest formulas, auto-color/format.
- AI Solver: send a math problem image → AI solves it.
- AI Grammarly: fix spelling + grammar.
- AI Explain: explain complex Excel formulas.
6. General utilities
- Auto-numbering (1, 1.1, 1.1.1, ...).
- Merge / unmerge / Copy-Paste visible cells.
- Remove Vietnamese diacritics (file/folder names).
- Audio transcription (speech-to-text).
- OCR images / PDFs.
- Unlock protected sheets (your own files or with permission).
System requirements
| Requirement | Minimum version |
|---|---|
| Windows | Windows 10 (64-bit recommended) |
| Microsoft Excel | 2016, 2019, 2021, 2024, or Microsoft 365 |
| .NET Desktop Runtime | 8.0 (auto-installed by setup.exe) |
| Disk space | ~50 MB |
| Internet | Needed for license activation, AI translate, AI Assistant |