Functions Home
Build reports to easily publish data regularly without rebuilding from scratch, right in Excel.
Getting started#
Navigate to the Splashback tab in the ribbon up the top of Excel and select Functions.
image
You will be prompted to log in, and then select a Pool from those you have available.
image
Select an empty cell, type into it '=SPLASHBACK'. Excel should suggest to you all the Splashback functions available. also see how the functions interface changes, it might be different in a bit, but you can probably also see all the functions from there, also documentation might get connected to the interface
image
To begin with lets try a
Troubleshooting#
| Problem | Fixes |
|---|---|
| No Values Returned | Re-log in to your Splashback account, your session may have timed out. |
| #VALUE returned | Try entering dates being used into a cell, right click on that cell to and go to format and format it as a datetime, then reference that cell in the input to the functions. |
Function reference#
| Function | Description |
|---|---|
| SPLASHBACK.PARAMETER_COUNT | Determines |
| SPLASHBACK.SAMPLE_COUNT | The location the sample was collected from. |
| SPLASHBACK.SITE_LOOKUP_DATE_TIME | The location the sample was collected from. |
| SPLASHBACK.DATE_TIME_RANGE_EXISTS | Input must be a value that is in the datetime format in Microsoft Excel |
| SPLASHBACK.DATE_TIME_RANGE_PERCENTILE | The location the sample was collected from. |
| SPLASHBACK.DATE_TIME_RANGE_VALUE | The program the samples of interest are being sampled under. If not specified will default to |
| SPLASHBACK.DAY_FROM_DATE_TIME_EXISTS | Input must be a value that is in the datetime format in Microsoft Excel |
| SPLASHBACK.DAY_FROM_DATE_TIME_PERCENTILE | Input must be a value that is in the datetime format in Microsoft Excel |
| SPLASHBACK.DAY_FROM_DATE_TIME_VALUE | The program the samples of interest are being sampled under. If not specified will default to |
| SPLASHBACK.WEEK_FROM_DATE_TIME_EXISTS | Input must be a value that is in the datetime format in Microsoft Excel |
| SPLASHBACK.WEEK_FROM_DATE_TIME_PERCENTILE | Input must be a value that is in the datetime format in Microsoft Excel |
| SPLASHBACK.WEEK_FROM_DATE_TIME_VALUE | The program the samples of interest are being sampled under. If not specified will default to |
| SPLASHBACK.MONTH_FROM_DATE_TIME_EXISTS | Input must be a value that is in the datetime format in Microsoft Excel |
| SPLASHBACK.MONTH_FROM_DATE_TIME_PERCENTILE | Input must be a value that is in the datetime format in Microsoft Excel |
| SPLASHBACK.MONTH_FROM_DATE_TIME_VALUE | The program the samples of interest are being sampled under. If not specified will default to |
| SPLASHBACK.YEAR_FROM_DATE_TIME_EXISTS | Input must be a value that is in the datetime format in Microsoft Excel |
| SPLASHBACK.YEAR_FROM_DATE_TIME_PERCENTILE | Input must be a value that is in the datetime format in Microsoft Excel |
| SPLASHBACK.YEAR_FROM_DATE_TIME_VALUE | The program the samples of interest are being sampled under. If not specified will default to |