Duplicator
The Duplicator feature allows you to copy a formula or layout across multiple values within a dimension—such as accounts, customers, products, or time periods. It automates the creation of repeated report sections while preserving the dynamic behavior of your NecAccess formulas.
Use this tool to avoid manually duplicating formulas when generating similar report blocks. The Duplicator is ideal for preparing printable reports or dashboards where repeated sections are required for different values—all without writing the same formula more than once.
note
The worksheet must alreeady include NECAccess formulas to use the Duplicator.
When to use the Duplicator
- Repeating layouts or formulas across dimension values: Duplicate a section for each customer, account, or other dimension item.
- Generating uniform reports across entities: Create a consistent structure across multiple business units, periods, or categories
- Avoiding manual copy-paste: Automate formula replication and ensure filters update correctly for each block.
- Producing printable reports: Output repeated sections per dimension value in a layout ready for printing or export.
Use the Duplicator
- In the Add‑ins tab, select Duplicator.
- In the dialog, configure the following:
- Select the Data Model and Environment.
- Choose the Dimension you want to duplicate by.
- Specify the Reference Cell containing the value used by the formulas in order to duplicate.
- Click OK to generate the duplicated content.
Duplicator properties
| Field | Description |
|---|---|
| Data Model | Select the data model to use. |
| Environment | Select the environment (if more than one is available). |
| Dimension | Choose the dimension you want to duplicate across. |
| Filter value position for this dimension | Specify the cell where the dimension value will be inserted. Note: This cell must be referenced by the existing formulas for the Duplicator to work correctly. |
Example
Create the same report for each department.
- For the Data Model, select GL Detail Transactions.
- From the Dimmension dropdowm menu, select Analytical Department.
- Set the cell reference where the department is used in the sheet to
'Financials Analysis'!$F$7. - Select OK to generate individual tabs—one for each department.