Fill Results

Location on ribbon: Tab DVD Addin → Group Formula → Menu Calculate Menu

Command ID: btnFillInResults

License required

This command needs an active DVDAddin account (Standard or PRO). It is fully available during the trial period.

What it does

This command appends computed results to the description cells themselves, in the form "text = result". The add-in pairs each row between the description range and the result range, then rewrites the description cell so the number sits inside it.

That is the shape quantity take-off sheets and BoQ submissions are expected to have: the description column must show both the calculation and its result (2 x 4.5 x 0.8 = 7.2) instead of forcing the reviewer to look at another column.

How to use

1. Prepare a table with a description column (the calculation text) and a matching result column, row by row.
2. Go to tab DVD Addin → group Formula → menu Calculate Menu → click Fill Results.
3. The tool window opens on the Fill Results tab (the Calculate tab group).
4. In Description, pick the range holding the text or calculation string.
5. In Result, pick the range holding the corresponding values (same number of rows).
6. Click Fill results. Each description cell is rewritten as <existing text> = <result>.

Example

Excavation take-off sheet:

	B (Description) — before	C (Quantity)
8	4 pits x 2.5 x 2.5 x 1.6	40.00
9	Tie beam: 2 x 18.4 x 0.4 x 0.5	7.36

Set Description = B8:B9, Result = C8:C9, then click Fill results:

	B (Description) — after
8	4 pits x 2.5 x 2.5 x 1.6 = 40
9	Tie beam: 2 x 18.4 x 0.4 x 0.5 = 7.36

Notes

• Both ranges must have the same number of rows; an offset pairs the wrong result with the wrong line.
• The description cell is overwritten with plain text: if it previously held a formula, that formula is lost. Work on a copy, or save first.
• The change cannot be reversed with Ctrl + Z — the add-in writes directly, outside Excel's undo stack.
• Running the command twice over the same range appends a second "= result" to the end of the string.
• The number written in is the value at the moment of the run; if the result range recalculates later, the text in the description cell does not follow.

Related

• Autosum — sibling tab that builds SUBTOTAL rows per package before results are filled in.
• Rounding Func — fix the decimals of the result column before merging it into the text.
• Direct Ref — link a detail table to a summary table with reference formulas.