All commands
DVDAddin adds 2 ribbon tabs to Excel with 186 commands in total: the DVD Cons tab for construction work (schedule, cutting optimization, QAQC, quantity surveying, teamwork sessions) and the DVD Addin tab for everyday spreadsheet utilities (text, cells and rows, formulas, graphics, files and printing, sheets, AI).
This page is the map: how many commands each ribbon group holds and where to read more. To look up one specific command, go to the 186-command reference — a list generated straight from the add-in's ribbon.
Command groups on the DVD Cons tab
| Group | Commands | Topic guides |
|---|---|---|
| Schedule | 23 (16 PRO) | Gantt Chart · Calendar Setup · 🔒 Schedule Pro |
| Optimizer | 6 | Cutting Optimizer |
| QAQC and Diary | 8 (2 PRO) | Construction Diary · 🔒 Test Plan |
| QS | 4 (1 PRO) | 🔒 AI Construction Estimate · Interim Payment · Compare BoQ · Variation Register |
| Connection | 4 | Connect Server |
| Quick | 1 | Find Cmd — Ctrl+Shift+Q |
Command groups on the DVD Addin tab
| Group | Commands | Topic guides |
|---|---|---|
| Text and Number | 47 | Smart Case · Numbering · Bullets · Text utilities · Encoding · Translate · Quick Input · Bulk Find/Replace · Data Cleaning |
| Cells and Rows | 17 | Insert / Delete / Merge |
| Formula | 9 | Formula tools · Formula view & lookup tracing |
| Graphics | 13 | Shapes · Insert Pictures · Auto Click |
| File and Print | 28 (15 license-gated) | File Tools · PDF & OCR · Batch Print · Print utilities · Send Email · Import Email · Merge to Word · Create Title · Transcribe Audio |
| View and Sheets | 11 | Sheet List · View tools |
| AI | 6 | AI Assistant · Formula Coach · DVD Chat |
| About | 9 | About & License · Preferences |
Besides the ribbon, the add-in installs 47 dvd… worksheet functions you can type straight into a cell — see UDF functions.
Getting started
- Install the add-in, open Excel and check that both the DVD Addin and DVD Cons tabs appear.
- Go to DVD Addin → About → License and sign in. During the trial period every command is fully unlocked.
- Go to About → About menu → Preferences to set defaults for the groups you use most (rounding function, merge separator, paper size…) and to enter your API key under AI Assistant if you plan to use the AI commands.
- Cannot remember where a command lives: press Ctrl+Shift+Q (Find Cmd), type a few letters of its name and press Enter.
- Click About menu → Quick start guide for the dialog that introduces the main features.
Example: a typical week for a site engineer
| Task | Command | Group |
|---|---|---|
| Update the weekly schedule and redraw the chart | Gantt Chart | DVD Cons ▸ Schedule |
| Build the diary catalog from the record catalog | New Diary | DVD Cons ▸ QAQC and Diary |
| Optimize rebar cutting for the next fabrication batch | Rebar Cut | DVD Cons ▸ Optimizer |
| Clean up the description column before printing records | Smart Data Cleaning | DVD Addin ▸ Text and Number |
| Print 120 acceptance records to PDF | Batch Print | DVD Addin ▸ File and Print |
| Email the acceptance sheet to the supervision consultant | Send Email | DVD Addin ▸ File and Print |
| Query the take-off team about a cell that does not add up | DVD Chat | DVD Addin ▸ AI |
Tips and caveats
- In the reference pages, a License badge (39 commands) means the command needs a valid DVDAddin account; a PRO badge (19 commands) means it belongs to the PRO tier. Everything else works without activation.
- STANDARD accounts activated before 1 July 2026 keep access to the PRO commands until their license expires; other Standard accounts get an upgrade dialog instead.
- Several AI and overwrite commands (Grammar, Solver, Send Format…) cannot be undone with Ctrl+Z — back up before running them over a large range.
- Indicative pricing: Standard 500,000 ₫/year or 1,500,000 ₫ perpetual; PRO 890,000 ₫/year or 2,690,000 ₫ perpetual. The full multi-seat table is on the license page.
- The 186-command reference is generated from the add-in's own ribbon, so it always matches the installed build; topic pages like this one only explain how the commands work together.
See also
- 186-command reference by ribbon tab
- UDF functions (47
dvd…functions) - Preferences — defaults shared by many commands
- License activation