Full command reference
All 224 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 schedule (data date) License — Re-plan the schedule from the data date — like F9 in Primavera P6
- 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) — Import a schedule from a MS Project XML file (P6 exports too)
- Setup › Import .xer (P6) — Read a Primavera P6 .xer file without P6 installed
- 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 › Health Check PRO — Schedule quality / health check (DCMA ~12 metrics)
- Reports › EVM Report PRO — Generate Earned Value Management report + S-curve (PV/EV/AC)
- Reports › Variance Dashboard PRO — Generate 1-page variance dashboard combining Schedule + EVM
- Reports › 2-Week Lookahead PRO — Generate 2-week lookahead plan for site supervisor
- Reports › 3-Week Lookahead PRO — Generate 3-week lookahead plan for site supervisor
- Reports › Schedule (custom range) PRO — Draw a real Gantt (shapes) for any date range (From → To)
- Reports › Baseline PRO — Save schedule baseline + compare with original plan
- Reports › Snapshot PRO — Capture current project state to hidden sheet for trend tracking
- Reports › Snapshot Trend PRO — Generate trend chart from saved snapshots (SPI/CPI/Critical Slip over time)
- Reports › Manpower PRO — Weekly manpower histogram + over-allocation detection
- Reports › Level resources PRO — Move activities with float to flatten the manpower profile
- Reports › Cash-flow PRO — Planned cash-flow curve + cumulative S-curve
Group: Optimizer
- Rebar Cut License — Run rebar cutting optimization
- Manual schedule — Type a rebar schedule by hand in the DVDKATABBS layout, picking shapes from a window
- Bar schedule License — Build a bar bending schedule from shapes and dimensions
- 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 License — Build an acceptance plan from the schedule (Decree 207/2026)
- Accept. record License — Draw up work acceptance records from acceptance-plan rows (Decree 207/2026)
- Punch list — Register of defects to close before handover
- RFI — Register of requests for information
- Submittals — Register of material, drawing and method submittals
Group: QS
- AI Estimate PRO — AI-estimated unit prices for selected construction items
- Payment License — Build the interim-payment value-of-completed-work table
- Compare BoQ License — Compare BoQ quantities between two versions — two sheets or two issued files
- Price adj. License — Material price compensation and contract indexation
- Estimate bridge License — Import a BoQ from another estimating package's Excel export
- PDF takeoff PRO — Measure quantities straight off a PDF drawing
- Compare dwgs License — Compare two PDF drawings and show exactly what changed
- Data query — Build a dvdSQL statement by picking, preview it, then insert
- Variations 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
- Filled circle — Add filled-circle bullet
- Filled star — Add filled-star bullet
- Minus — Add minus-sign bullet
- Filled diamond — Add filled-diamond bullet
- Plus — Add plus-sign bullet
- Asterisk — Add asterisk bullet
- Checkbox — Add empty-checkbox bullet
- Checked — Add checked-checkbox bullet
- Rejected — Add rejected-checkbox bullet
- Remove bullets — Remove the current bullet
- Number list — Apply number list
- Roman list — Apply Roman numbered list
- Upper letters list — Apply uppercase letter list
- Lower letters list — Apply lowercase letter list
- Remove list numbering — Remove the current numbered list
- Multilevel 1.1.1 — Apply 1.1.1 multilevel numbering
- Remove multilevel numbering — Remove the current 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 — 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 › Number Shapes — Rename the selected shapes 1, 2, 3… by position
- Shape Menu › Get Position — Get Shape coordinates
- Shape Menu › Linked Labels License — Place linked pictures of cells on same-named shapes
- Shape Menu › Make Labels Static — Turn every linked label on the sheet into a static one — one click
- Shape Menu › Footing shapes from DWG PRO — Read footings from the DWG, match them onto the plan picture and draw exact-outline shapes
- Shape Menu › Pile shapes from DWG PRO — Read round and square piles from the DWG, match them onto the pile-plan picture and draw shapes named by pile mark (P1…)
- Shape Menu › Column/wall shapes from DWG PRO — Read concrete columns and walls from the plan DWG, match them onto the plan picture and draw true-section shapes (columns C1…, walls V1…)
- Shape Menu › Plan progress License — Track progress per shape on a plan: status table, colouring, counted legend, PDF export
- 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
- Revision Cloud — Drag to draw a rectangular revision cloud on the sheet
- Cloud Menu › Polygon Cloud — Click corner points to draw a polygon cloud
- Cloud Menu › Cloud Around Selection — Draw a cloud around the selected cells or shapes
- Cloud Menu › Convert to Cloud — Turn the selected shapes into clouds — along the corners of freeforms, diamonds and triangles, around the frame of other shapes
- Cloud Menu › Arrow — Drag to draw an arrow on the sheet
- Cloud Menu › Text Note — Click and type a text note right on the sheet
- Cloud Menu › Sticky Note — A yellow sticky note typed right on the sheet
- Cloud Menu › Callout — Press at the point, drag to where the text goes — a callout with an arrow leader
- Cloud Menu › Cloud Options… — Colour, line weight, scallop size and margin of clouds; font, text size and arrowhead size of notes
Group: File and Print
- File Tools › File List — Get list of filenames
- File Tools › Combine files — Combine several Excel files into one
- File Tools › Split table — Split one table into several sheets or files by a key column
- File Tools › Compare sheets — Compare two sheets cell by cell and list the differences
- File Tools › Merge tables — Bring columns from a lookup table into the main table by key
- 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 — View, annotate and edit PDF files
- PDF / OCR › PDF Manager License — Open PDF Manager
- PDF / OCR › Stamp PDF License — Number pages and stamp PDFs in bulk
- 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
- Sync page setup License — Copy page setup from one sheet to the others
- 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 › Tab Bar — Show a tab bar of open workbooks
- 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
- Help › Preferences — System preferences
- Help › Quick start guide — Re-open the welcome screen
- Help › User guide — Open the user guide (PDF)
- Help › Restore data — Restore a sheet from the automatic backup taken before a command ran
- Help › Check Update — Check for new version
- Help › Download Tool — Download latest installer
- Help › Export support log — Create a .zip to send to support
- Help › About — About DVD Addin
- License — License: status, sign in, buy / renew