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#

ProblemFixes
No Values ReturnedRe-log in to your Splashback account, your session may have timed out.
#VALUE returnedTry 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#

FunctionDescription
SPLASHBACK.PARAMETER_COUNTDetermines
SPLASHBACK.SAMPLE_COUNTThe location the sample was collected from.
SPLASHBACK.SITE_LOOKUP_DATE_TIMEThe location the sample was collected from.
SPLASHBACK.DATE_TIME_RANGE_EXISTSInput must be a value that is in the datetime format in Microsoft Excel
SPLASHBACK.DATE_TIME_RANGE_PERCENTILEThe location the sample was collected from.
SPLASHBACK.DATE_TIME_RANGE_VALUEThe program the samples of interest are being sampled under. If not specified will default to
SPLASHBACK.DAY_FROM_DATE_TIME_EXISTSInput must be a value that is in the datetime format in Microsoft Excel
SPLASHBACK.DAY_FROM_DATE_TIME_PERCENTILEInput must be a value that is in the datetime format in Microsoft Excel
SPLASHBACK.DAY_FROM_DATE_TIME_VALUEThe program the samples of interest are being sampled under. If not specified will default to
SPLASHBACK.WEEK_FROM_DATE_TIME_EXISTSInput must be a value that is in the datetime format in Microsoft Excel
SPLASHBACK.WEEK_FROM_DATE_TIME_PERCENTILEInput must be a value that is in the datetime format in Microsoft Excel
SPLASHBACK.WEEK_FROM_DATE_TIME_VALUEThe program the samples of interest are being sampled under. If not specified will default to
SPLASHBACK.MONTH_FROM_DATE_TIME_EXISTSInput must be a value that is in the datetime format in Microsoft Excel
SPLASHBACK.MONTH_FROM_DATE_TIME_PERCENTILEInput must be a value that is in the datetime format in Microsoft Excel
SPLASHBACK.MONTH_FROM_DATE_TIME_VALUEThe program the samples of interest are being sampled under. If not specified will default to
SPLASHBACK.YEAR_FROM_DATE_TIME_EXISTSInput must be a value that is in the datetime format in Microsoft Excel
SPLASHBACK.YEAR_FROM_DATE_TIME_PERCENTILEInput must be a value that is in the datetime format in Microsoft Excel
SPLASHBACK.YEAR_FROM_DATE_TIME_VALUEThe program the samples of interest are being sampled under. If not specified will default to