Functions Home
Build reports to easily publish data regularly without rebuilding from scratch, right in Excel.
Really quick video of using, because it will explain everything
Troubleshooting#
| Problem | Fixes |
|---|---|
| No Values Returned | Re-log in to your Splashback account, your session may have timed out. |
| #VALUE returned | One of the function inputs is incorrectly formatted, often this is a datetime. Try entering datetime into a cell, right click on that cell and select the format option. From this menu format the cell as a datetime, then reference that cell in the input to the functions. |
Function reference#
| Function | Description |
|---|---|
| SBK.PARAMETER_COUNT | Determines |
| SBK.PARAMETER_COUNT | Determines |
| SBK.SAMPLE_COUNT | The location the sample was collected from. |
| SBK.SITE_LOOKUP_DATE_TIME | The location the sample was collected from. |
| SBK.DATE_TIME_RANGE_EXISTS | Input must be a value that is in the datetime format in Microsoft Excel |
| SBK.DATE_TIME_RANGE_PERCENTILE | The location the sample was collected from. |
| SBK.DATE_TIME_RANGE_VALUE | The program the samples of interest are being sampled under. If not specified will default to |
| SBK.DAY_FROM_DATE_TIME_EXISTS | Input must be a value that is in the datetime format in Microsoft Excel |
| SBK.DAY_FROM_DATE_TIME_PERCENTILE | Input must be a value that is in the datetime format in Microsoft Excel |
| SBK.DAY_FROM_DATE_TIME_VALUE | The program the samples of interest are being sampled under. If not specified will default to |
| SBK.WEEK_FROM_DATE_TIME_EXISTS | Input must be a value that is in the datetime format in Microsoft Excel |
| SBK.WEEK_FROM_DATE_TIME_PERCENTILE | Input must be a value that is in the datetime format in Microsoft Excel |
| SBK.WEEK_FROM_DATE_TIME_VALUE | The program the samples of interest are being sampled under. If not specified will default to |
| SBK.MONTH_FROM_DATE_TIME_EXISTS | Input must be a value that is in the datetime format in Microsoft Excel |
| SBK.MONTH_FROM_DATE_TIME_PERCENTILE | Input must be a value that is in the datetime format in Microsoft Excel |
| SBK.MONTH_FROM_DATE_TIME_VALUE | The program the samples of interest are being sampled under. If not specified will default to |
| SBK.YEAR_FROM_DATE_TIME_EXISTS | Input must be a value that is in the datetime format in Microsoft Excel |
| SBK.YEAR_FROM_DATE_TIME_PERCENTILE | Input must be a value that is in the datetime format in Microsoft Excel |
| SBK.YEAR_FROM_DATE_TIME_VALUE | The program the samples of interest are being sampled under. If not specified will default to |