Repexel addin for Excel

Repexel Data in Databases

Repexel utilizes local and remote databases to save the data and keep it consistent. Users access rights to the remote databases are controlled in Microsoft Entra.

User have Local database as default. If user has been given access to cloud databases (Instances), those will be available at the top of the taskpane in the instance dropdown selector.

An administrator User can copy Table desings and Dimensions from Local instance to his/her own cloud databaseInstance.

Cloud databases require separate subscription with monthly fee starting from 200 EUR (Tax excl.).

Create and Manage Data Tables and Forms

Defining and setting up Repexel Tables

You can build a new Table by adding and defining new Fields to it.

Alternatively you can generate the Repexel Table from data of a existing table or range in Excel worksheet.

Design Forms

When you are managing and defining the Repexel Table in the taskpane, the Repexel Form template will be visible in a worksheet window.

You can move the Fields inside the Form and insert texts and objects in any ay that makes the Form look out as you prefer.

Define dimensions

Dimensions are features of the data entries, that can be used to filter the data when retrieved. Using dimensions make it possible to look the data from different perspectives. F.ex: sales per customer or sales per product from sales data.

Dimensions are linked to Fields to define and restrict the possible values.

Create and Define a Dimension

You can create a new Dimension in the Dimension list that will then open an empty worksheet table where you can enter possible values for the dimensions.

Alternatively you can create a dimension form a selected table or a range on a worksheet.

In addition when you change fieldtype of a Field to a Dimension (select New Dimension), then all the distinct values in the database will be added to Dimension value options.

On the Dimension worksheet you can create a hierarchy for the Dimension values. Column marks the hierarchy level. So all the Dimension Value below to the Parent Dimension value until the next in the same or lower hierarchylevel/column, are its subvalues.

Reporting

Users can open the reporting tables and forms, that are listed in the Reporting taskpane. They can open an empty form or table to add new entry/entries. Alternatively they can retrieve existing Entries for editing by selecting the Filter option of a Table in the list.

Filter Entries for modification

User can filter entries of a Repexel Table by time and filter Field values. He/she will get the entries based on his/her access rights and filters he/she has given.

When saved to the database all the existing entries based on the filters and users access rights will be replaced by the entries saved.

Modify Entry in Form

User can also select entries from the Entries table to be Modified in the worksheet Form.

Reports

User can generate new Reports from database Tables in Reports taskpane. A Pivottable will generated to the selected and active location in the workbook. If there is not enough space int active location, then a new workseet will be opened for it.

Reports will also generate a separate worksheet with the report data in a source table. The same source table can be used to generate multiple PivotTables and PivotCharts.

Saved Reports

Each time a workbook containing Repexel Tables is opened and Repexel activated, then the lataest data will be retrieved from the database. If a he Excel-file is shared with other users, then other users will retrieve data based on his/her access rights.