Skip to main content

Functions Home

img

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#

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

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