Excel Function Index
Estimated reading time: 8 minutesOverview
Interject provides features by leveraging spreadsheet formulas that are familiar to many users. These formulas can be used to direct data into a spreadsheet, creating practical and adaptable reports. By adding report drills and navigation through additional spreadsheet formulas, these reports become a comprehensive reporting solution.
Data Pull Functions
Data Pull Functions are focused on getting specific data to the report in the right way and placed inside the spreadsheet. There are a variety of functions and options therein to give flexibility in what data is displayed.
| Formula | Description |
|---|---|
| ReportRange() | Inserts data into a single range of a spreadsheet |
| ReportFixed() | Pulling in data to a predetermined fixed point. |
| ReportVariable() | Insert data into rows that include multiple ranges or sections |
| ReportLookup() | Insert a specific data value into a cell based on certain criteria. |
Data Save Functions
The Data Save Function ReportSave is designed to save data within the sheet back to the data source, making it easy to manipulate the data without having to edit the database directly.
| Formula | Description |
|---|---|
| ReportSave() | Save data on the sheet back to the database. |
Data Drill Functions
The Data Drill Function ReportDrill provides a convenient way to run another targeted function while at the same time, transferring contextual data for filtering to that function. It is widely used as a way to connect and pass information between workbooks and worksheets.
| Formula | Description |
|---|---|
| ReportDrill() | Drilling down on data and Navigating between reports |
Event Functions
Event Functions are functions designed to run when a designated event triggers them. An Interject event is a Clear Data or Run event. A Run event can be a Pull Data action or a Save action. The values defined within the event trigger function will determine when it is executed. These functions allow synchronization and data precision witin the report.
| Formula | Description |
|---|---|
| ReportMacro | Call VBA macros. |
| ReportRun() | Execute Report functions in other sheets. |
| ReportCalc() | Executes a calculation on a worksheet or workbook. |
| ReportDefaults() | Captures and send values from one cell(s) to another. |
| ReportGrouping() | Expands or collapses groups. |
| ReportHideRowOrColumn() | Hides rows or columns. |
Helper Functions
Helper Functions are functions that help streamline the report generation process and offer additional customization. They are often embedded into other parent functions to be leveraged into more specific and accurate functions or enhance their capabilities. Some can also be used as stand-alone functions to add functionality to the page. Other Helper Functions are focused on the report itself and does not impact or direct data in the report. These functions can improve the speed and presentation of which data can be understood, manipulated and viewed in the report.
| Formula | Description |
|---|---|
| jDropdown() | Returns a set of data in a dropdown list for easy insertion into the sheet. |
| jFocus() | Sets the Excel focus (active cell selection) upon a freeze panes action. |
| jFreezePanes() | Used with the QuickTools option for freeze/unfreeze panes. |
| jCombine() | Concatenate the values of cells while simultaneously skipping any empty cell. |
| jCombineIf() | Uses a conditional statement to determine which values should be included into a single concatenated string. |
| jDataPortal() | Helpful function for developers to further leverage DataPortals. |
| jColumnDef() | Assists financial reports using the FinCube Data Portal to specify segment filters for each amount column. |
| jRangeTag() | Used to label or tag a range or a single cell with a custom name. |
| jWorkbookProperty() | Provides context and information about a workbook in a report. |
| Pair() | Used with a variety of report functions to specify a from value or range to a target location or range. |
| PairGroup() | Used to string multiple Pair() functions together into one comma delimited string |
| Param() | Used to help select one or multiple parameters for each of your report formulas. |
Data Cell Functions
Data Cells are focused on a single formula which can be placed anywhere in the spreadsheet and can ask for any financial number or summary from it. Once this single formula approach is understood, there is no limit to the combinations that can be created. This is typically an easier method to start writing custom reports. However, given their flexibility the report run times can take more than just a few seconds to complete, sometimes up to 5 minutes. Larger reports, such as one with 70,000 formulas, can take up to 10 minutes to complete. Fortunately, users may continue working with a spreadsheet while waiting for Data Cell reports to finish calculating.
| Formula | Description |
|---|---|
| jAcct() | Specifies filters for up to six segments of a Chart of Accounts |
| jCell/jCellN() | Retrieves data based on the provided parameters |
| jDesc() | Used to look up a context description based on a specific segment. |