Full command reference
All 186 ribbon commands in DVDAddin, in the order they appear on the two tabs. Open a command for its full guide: what it does, how to use it, an example and caveats.
Legend: PRO PRO plan only · License needs an active account (the trial includes it).
Tab: DVD Cons
Group: Schedule
- Gantt Chart License — Draw construction Gantt chart
- Auto Calc — Toggle auto date calculation
- Auto Draw — Auto-redraw Gantt while Auto Calc is on
- Update Status License — Add 5 columns PV/SV/SPI/Δ Finish/Status + refresh task status
- Setup — Gantt & Calendar Setup
- Setup › Gantt Tpl — Open construction Gantt template
- Setup › Constraints PRO — Set date constraints on tasks (P6 / MS Project style)
- Setup › Header Language — Switch column headers between Vietnamese ⇄ English
- Setup › Export XML (P6/MSP) PRO — Export schedule to MS Project XML (P6 can import it too)
- Setup › Import XML (P6/MSP) PRO — Import a schedule from a MS Project XML file (P6 exports too)
- Schedule AI › AI Gantt Builder PRO — Gemini builds schedule outline from BoQ or description
- Schedule AI › Schedule Recovery PRO — Schedule variance analysis → propose recovery plan
- Reports & Snapshot › Health Check PRO — Schedule quality / health check (DCMA ~12 metrics)
- Reports & Snapshot › EVM Report PRO — Generate Earned Value Management report + S-curve (PV/EV/AC)
- Reports & Snapshot › Variance Dashboard PRO — Generate 1-page variance dashboard combining Schedule + EVM
- Reports & Snapshot › 2-Week Lookahead PRO — Generate 2-week lookahead plan for site supervisor
- Reports & Snapshot › 3-Week Lookahead PRO — Generate 3-week lookahead plan for site supervisor
- Reports & Snapshot › Schedule (custom range) PRO — Draw a real Gantt (shapes) for any date range (From → To)
- Reports & Snapshot › Baseline PRO — Save schedule baseline + compare with original plan
- Reports & Snapshot › Snapshot PRO — Capture current project state to hidden sheet for trend tracking
- Reports & Snapshot › Snapshot Trend PRO — Generate trend chart from saved snapshots (SPI/CPI/Critical Slip over time)
- Reports & Snapshot › Manpower PRO — Weekly manpower histogram + over-allocation detection
- Reports & Snapshot › Cash-flow PRO — Planned cash-flow curve + cumulative S-curve
Group: Optimizer
- Rebar Cut License — Run rebar cutting optimization
- Bar Cut 1D License — Optimize 1D linear cutting (pipe/box/lumber/profile)
- Panel Cut 2D License — Optimize 2D panel/sheet cutting (plywood/glass/steel/MDF)
- Templates › Cutting Tpl — Open rebar cutting template
- Templates › Bar Tpl — Create input template sheets for 1D Bar Cut
- Templates › Panel Tpl — Create input template sheets for 2D Panel Cut
Group: QAQC and Diary
- New Diary License — Create a daily log catalog from the record catalog.
- Diary Menu › Export Category License — Export acceptance records category
- Diary Menu › Pick Rest Days — Pick rest days to fill into the diary's rest-days column
- Templates › Work Record Tpl — Work acceptance record template
- Templates › Material Record Tpl — Material acceptance record template
- Templates › Diary Template — Construction diary template
- Test Plan PRO — Generate a TCVN test plan from the selected cells
- Acceptance Plan PRO — Build an acceptance plan from the schedule (Decree 06/2021 + Circular 10)
Group: QS
- AI Construction Estimate PRO — AI-estimated unit prices for selected construction items
- Interim Payment License — Build the interim-payment value-of-completed-work table
- Compare BoQ License — Compare BoQ quantities between two versions (delta by code)
- Variation Register License — Build a variation / additional-works register with valuation (increase/decrease, net)
Group: Connection
- Connect License — Networking for teamwork via LAN or internet.
- Disconnect — Disconnect from the teamwork session
- Send Format — Send formatting to connected teammates
- Admin — Establish user rights.
Group: Quick
- Find Cmd — Find and run commands quickly (Ctrl+Shift+Q)
Tab: DVD Addin
Group: Text and Number
- Numbering — Auto numbering (start + step)
- Roman — I, II, III, ...
- Upper letters — A, B, C, ...
- Lower letters — a, b, c, ...
- Assign Level — Assign the Level by description (AI) or by cell background colour
- Bullets › (None) — Remove the current bullet
- Bullets › Filled circle — Add filled-circle bullet
- Bullets › Filled star — Add filled-star bullet
- Bullets › Minus — Add minus-sign bullet
- Bullets › Filled diamond — Add filled-diamond bullet
- Bullets › Plus — Add plus-sign bullet
- Bullets › Asterisk — Add asterisk bullet
- Bullets › Checkbox — Add empty-checkbox bullet
- Bullets › Checked — Add checked-checkbox bullet
- Bullets › Rejected — Add rejected-checkbox bullet
- Numbered list › (None) — Remove the current numbered list
- Numbered list › Roman list — Apply Roman numbered list
- Numbered list › Number list — Apply number list
- Numbered list › Upper letters list — Apply uppercase letter list
- Numbered list › Lower letters list — Apply lowercase letter list
- Multilevel › (None) — Remove the current multilevel numbering
- Multilevel › Multilevel 1.1.1 — Apply 1.1.1 multilevel numbering
- Case › Sentence case — Capitalize first letter of each sentence
- Case › UPPERCASE — Convert all to UPPERCASE
- Case › lowercase — Convert all to lowercase
- Case › Proper Case — Capitalize first letter of each word
- Case › SMART case (AI) — Smart-capitalize using AI context
- Italic — Italicize text after delimiter
- Italic Menu › Text Reverse — Reverse text via delimiter
- Italic Menu › Font Change — Change font after delimiter
- Text ops › Remove extra spaces — Remove extra spaces in text
- Text ops › Add text — Insert extra text into selection
- Text ops › Remove accents — Strip Vietnamese accents from text
- Text ops › Add accents (AI) — Use AI to add Vietnamese accents
- Text ops › Auto format — Auto-format numbers and dates
- Text ops › Superscript — Superscript characters after digits (m²)
- Text ops › Subscript — Subscript digits in chemistry formulas
- Text ops › Bulk find / replace… — Bulk find & replace across sheets / workbooks with preview + regex
- Text ops › Smart Data Cleaning… — Clean data: trim, case, fix Vietnamese encoding, dates, phones, dedup
- Encoding — Convert Vietnamese font
- To Unicode — Convert to Unicode
- To VNI — Convert to VNI
- To TCVN3 — Convert to TCVN3
- Translate License — Translate text
- Quick Input License — Quick input from list
- Auto-suggest on cell select — Toggle auto-suggest popup
- Configure source ranges… License — Configure Target → Source rules
Group: Cells and Rows
- Insert Rows — Insert multiple rows above
- Insert Menu › Insert Columns — Insert multiple columns left
- Insert Menu › Insert and Copy — Insert and copy data below
- Delete blanks — Delete blank rows in selection
- Delete hidden rows — Delete hidden rows
- Delete unused formats — Delete unused formats
- Delete error Defined Names — Delete broken Defined Names
- Strip junk styles — Strip junk Cell Styles from external file
- Merge cells › Merge keep data — Merge cells while keeping all data
- Merge cells › Merge similar — Merge adjacent cells with the same value
- Merge cells › Merge rows by key License — Merge rows sharing the same key
- Merge cells › Auto group License — Auto-group rows by outline level
- Merge cells › AutoFit merged — AutoFit row height for merged cells
- Merge cells › Select visible — Select only visible cells
- Merge cells › Copy/Paste visible License — Copy and Paste only visible cells
- Join Text — Join selected cells values
- Join Merged — Concatenate merged cell addresses
Group: Formula
- Trace › Formula View — View parameters in the formula
- Trace › Lookup Trace — To the cell containing the value found by the lookup formula
- Trace › Dependents — Navigate to the formula cell of the selected cell
- Autosum — Auto insert Sum function
- Calculate Menu › Fill Results License — Display calc result in cell
- Calculate Menu › Direct Ref License — Assign direct reference
- Calculate Menu › Rounding Func — Add/Remove Round function
- Calculate Menu › Lock Ref — Add/Remove $ in formulas
- Calculate Menu › Error Check — Check formula errors
Group: Graphics
- Color Shapes License — Color Shapes by value
- Shape Menu › Color Rects — Draw rectangles by cell color
- Shape Menu › List Shapes — List all Shapes in sheet
- Shape Menu › Rename Shapes — Batch rename Shapes
- Shape Menu › Get Position — Get Shape coordinates
- Shape Menu › Get Color Code — Get cell background color code
- Shape Menu › Auto Click License — Mouse auto clicker
- Pictures — Insert multiple pictures
- Insert Pic Menu › Insert by Name — Insert pictures by filename
- Insert Pic Menu › Pic Comment — Insert picture into Comment
- Insert Pic Menu › Comment by Name — Insert pic into Comment by name
- Insert Pic Menu › Move/Resize — Move and resize pictures
- Insert Pic Menu › Capture and Annotate — Capture the screen then annotate it (Zalo-style) — shortcut Ctrl+Alt+S
Group: File and Print
- File Tools › File List — Get list of filenames
- File Tools › Rename Files — Batch rename files
- File Tools › File Tree License — Create file directory tree
- File Tools › Create Hyperlink — Create hyperlink from cell value
- File Tools › Folder Tree License — Create folder directory tree
- File Tools › Create Folder License — Create folders from list
- File Tools › UnDiacritics Folder — Remove accents in Folder name
- File Tools › Resize Images — Batch resize images
- File Tools › Export Images — Export images from Excel
- File Tools › Transcribe Audio License — Transcribe audio to text
- File Tools › Unprotect Sheet License — Remove Sheet password
- Read PDF — Read PDF content into Excel
- PDF / OCR › PDF Manager License — Open PDF Manager
- PDF / OCR › Word → PDF — Batch-convert Word files to PDF
- PDF / OCR › Visio → PDF — Convert Visio file to PDF
- PDF / OCR › OCR file License — OCR an image or PDF file via AI
- PDF / OCR › Extract Table License — Extract a table from a PDF/image into Excel via AI
- PDF / OCR › OCR Screen Clip License — OCR a screen clip via AI
- Batch print License — Batch print/PDF using a driver cell
- Set page margins — Set page margins for selected sheets
- Print pages License — Print individual pages of the active sheet
- Mirror margins License — Build a PDF with mirrored margins for two-sided
- Sheets → PDF — Export selected sheets to one PDF
- Send Email License — Send Email via Outlook
- Email Menu › Import Email License — Import data from Outlook
- Email Menu › Email Template — Email sending template
- Merge to Word License — Merge Excel data to Word
- Merge Menu › Create Title — Create merge title ([...])
Group: View and Sheets
- Reading Layout — Highlight active row/col
- Sheet List — List all Sheets
- Sheet Menu › Rename Sheets — Batch rename Sheets
- Sheet Menu › Sheet Numbering — Add number prefix to Sheet
- Sheet Menu › UnDiacritics — Remove accents in Sheet name
- Sheet Menu › Hide Unselected — Hide unselected sheets
- Sheet Menu › Unhide All — Unhide all hidden sheets
- Navigation — Open Workbook, Sheet Management window
- Navigation Menu › View Image — Image zoom view mode
- Navigation Menu › Hide Empty Rows — Hide rows without data
- Navigation Menu › Reset Note — Reset Note position
Group: AI
- AI Chat License — Open AI Assistant window
- AI Menu › Explain formula (Coach) — AI Formula Coach — interactive dialog explanation
- AI Menu › Fix formula error — AI diagnose #N/A #VALUE! etc + propose a corrected formula
- AI Menu › Grammar License — Check grammar (Grammarly)
- AI Menu › Solver License — Solve multiple choice questions
- DVD Chat License — Team chat inside Excel
Group: About
- Lang: EN — Chuyển giao diện sang tiếng Việt
- About — Author information
- About Menu › Buy License — Open Buy License dialog — pick plan + generate QR
- About Menu › Check Update — Check for new version
- About Menu › Download Tool — Download latest installer
- About Menu › Preferences — System preferences
- About Menu › Quick start guide — Open the feature overview dialog
- License — Open Sign-in / Activate License dialog
- Buy License — Open Buy License dialog — pick plan + generate QR