Functions Home
Build reports to easily publish data regularly without rebuilding from scratch, right in Excel.
#
Getting startedNavigate 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
#
TroubleshootingProblem | 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 referenceFunction | 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 |