### startsWith Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Tests if a string starts with a specified prefix. ```APIDOC ## startsWith ### Description Tests if a string starts with a specified prefix. Returns true if it does, false otherwise. ### Syntax startsWith(expression,prefix) or startsWith(expression,prefix,start,end) ### Parameters - **expression** (string) - Required - The string to test. - **prefix** (string) - Required - The prefix to search for. - **start** (integer) - Optional - The position to start searching. - **end** (integer) - Optional - The position to end searching. ### Example startsWith('Granite', 'Gra') returns true. ``` -------------------------------- ### Sample Type Prompt Using the Modulo Function Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/formula-gallery.htm Creates a Count column that assigns row numbers starting at 1, then uses that Count column in a sample type prompt formula. The formula prompts the logger to insert a BLANK, CRM, or DUP sample type every seventh row, based on the modulo result. ```formula previous({Count},0)+1 ``` ```formula ifThen([(({Count}/7)%3)==1,'BLANK'],[(({Count}/7)%3)==2,'CRM'],[(({Count}/7)%3)==0,'DUP']) ``` -------------------------------- ### Reference Project Area Header Field Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/formula-gallery.htm References the Project Area header field in a formula. Use this as a basic example of how to reference a header field input. ```formula {YourHeader.ProjectArea} ``` -------------------------------- ### Au-Equivalent Formula Using Ranked Columns Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/formula-gallery.htm Calculates Au equivalent using ranked columns from the samples table. The constant 1.58 is an example placeholder for your own constant. Ranked columns are populated once the lab certificate is released. ```formula {Au-DD_RankedCol, ppm (Activity-DD CoreLogging)}+1.58* ({Sb_RankedCol, ppm (Activity-DD CoreLogging)}/10000) ``` -------------------------------- ### Finish Date Cannot Be Earlier Than Start Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/validations/validations-gallery.htm Validation rule for ensuring the end date is not earlier than the start date. Uses two date type inputs, EndDate and StartDate. The second block is the validation message that can be copied and used. ```plaintext {EndDate}>{StartDate} ``` ```plaintext {EndDate.source} cannot be earlier than {StartDate.source}: {StartDate.value} ``` -------------------------------- ### Oxide Calculation Formula Using Ranked Column Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/formula-gallery.htm Converts the pure LA (Lanthium) laboratory result into LA 203 ppm by multiplying the ranked column La ME-MS61_RankedCol by the constant 1.1728. The constant is an example placeholder for your own constant. ```formula {La ME-MS61_RankedCol, ppm (Activity-DD CoreLogging)}*1.1728 ``` -------------------------------- ### Box Number formula using previous() Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/formula-gallery.htm Calculates the box number by starting at 0 and adding 1 to each new row. When creating a new column, first save it as a standard numeric column without the calculated button toggled to yes, then add the formula. ```formula previous({Box Number},0)+1 ``` -------------------------------- ### Validate Sample ID using search and string functions Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/formula-gallery.htm Validates a Sample ID by checking three criteria: Hole/Point.Number contains '-24-', the last two digits of the year of DateSampled are '24', and SampleID starts with '444'. If any check fails, it returns 'Invalid Sample ID'. ```formula ifElse(search('(-24-)',{Hole/Point.Number}) & right(str(year({DateSampled})),2)=='24' & left(str({SampleID}),3)=='444','','Invalid Sample ID') ``` -------------------------------- ### Deviation in Azimuth Values using previous() and ifElse() Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/formula-gallery.htm Two-step workflow to flag excessive deviation in azimuth values. First create a calculated column using previous() to get the previous row's DH_Azimuth value, then use that new column in a formula that flags when the difference exceeds 10%. The previous function cannot be used on a column that is also used elsewhere in a function, as that causes an 'An argument of the function has an inappropriate type' error. ```formula previous({DH_Azimuth},0) ``` ```formula ifElse(abs(({DH_Azimuth}-{PreviousDH_Azimuth})/{DH_Azimuth})>0.1,'Check Az','') ``` -------------------------------- ### Sample Type Prompt Using the in Function Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/formula-gallery.htm Prompts the logger to insert a duplicate sample every 20th sample and a blank sample every 5th sample, based on the rightmost digits of the Sample Number. The prompt 'Insert FieldDup' appears when the rightmost 2 digits are 20, 40, 60, or 80; 'Insert Blank' appears when the rightmost digit is 0 or 5. ```formula ifThen([in(right({Sample Number},2),'20','40','60','80'),'Insert FieldDup'],[in(right({Sample Number},1),'0','5'),'Insert Blank']) ``` -------------------------------- ### str Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Converts the input expression to a text string. ```APIDOC ## str ### Description A type conversion function that converts the input expression to a text string. ### Syntax str(value) ### Parameters - **value** (any) - Required - The expression to convert to a string. ### Example str(1234) returns '1234'. ``` -------------------------------- ### trim Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Removes both the preceding and following text or blank spaces from a string. ```APIDOC ## trim ### Description Removes both the preceding and following text or blank spaces from a string. ### Syntax trim(expression,text) ### Parameters - **expression** (string) - Required - The string to trim. - **text** (string) - Required - The text to remove from both ends of the string. ### Example trim('day shift', 'shift') returns 'day '. ``` -------------------------------- ### date() Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Formats the input string expression that is in ISO 8601 format as a date. Only date and text column types work with this function. ```APIDOC ## date() ### Description Formats the input string expression that is in ISO 8601 format as a date. Only date and text column types work with this function. ### Syntax ```text date(expression) ``` ### Parameters - `expression` (string) - Required - The ISO 8601 formatted string to convert to a date. ### Usage Notes - Example: The string '2015-04-18' will be formatted as a date. ``` -------------------------------- ### log Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Returns the natural logarithm of the expression, or the logarithm to a specified base. ```APIDOC ## log ### Description Returns the natural logarithm of the expression, when no base is specified. When the optional base is provided, returns the logarithm of the expression to the specified base. ### Syntax ``` log(expression) log(expression, base) ``` ### Parameters - **expression** (number) - Required - The value to take the logarithm of. - **base** (number) - Optional - The base of the logarithm. If omitted, natural logarithm is used. ### Example log(10) returns approximately 2.3026. log(8, 2) returns 3. ### Notes Calculate the natural log of the interval length. The log of the interval length is calculated to the base of 2. ``` -------------------------------- ### day() Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Takes a date and displays only the day. Only text and numeric column types will work with this function. ```APIDOC ## day() ### Description Takes a date and displays only the day. Only text and numeric column types will work with this function. ### Syntax ```text day(dateValue) ``` ### Parameters - `dateValue` (date) - Required - The date from which to extract the day. ### Usage Notes - While the Drill Date column displays the full date, the day function leaves just the day. ``` -------------------------------- ### previous(column.name) or previous(column.name, initial-value) Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm References data from the previous row in a column, with an optional initial value for the first row. ```APIDOC ## previous(column.name) or previous(column.name, initial-value) ### Description Use this function to reference data for a column from the previous row. You can also, optionally, specify the initial value that should be used when the function is applied to the first row, i.e there is no previous row value to obtain. If no initial value is provided, then 0 will be used instead. ### Syntax `previous(column.name)` or `previous(column.name, initial-value)` ### Parameters - **column.name** (string) - Required - The column from which to retrieve the previous row's value. - **initial-value** (number) - Optional - The value to use for the first row when there is no previous row. Defaults to 0 if not provided. ### Remarks - You cannot use the previous function for a column that is also used elsewhere in a function. For instance, the following function fails with a 'An argument of the function has an inappropriate type' error. - To achieve the goal of referencing both the current and previous values for a column in the same function, you will need to create a new calculated column that contains the value of the previous row and reference that calculated column instead. ### Example `previous(Azimuth) + 12.5` returns the previous row's Azimuth value plus 12.5, with 0 assumed for the first row. ``` -------------------------------- ### ltrim Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Removes the specified text or blank spaces found at the beginning of a string. ```APIDOC ## ltrim ### Description Removes the specified text or blank spaces found at the beginning of a string. ### Syntax ltrim(expression,text) ### Parameters - **expression** (string) - Required - The string to trim. - **text** (string) - Required - The text to remove from the beginning of the string. ### Example ltrim('the texture', 'the ') returns 'texture'. ``` -------------------------------- ### min Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Returns the minimum value of any given amount of specified values. ```APIDOC ## min ### Description Returns the minimum value of any given amount of specified values. ### Syntax ``` min(numeric1, numeric2, numeric3) ``` ### Parameters - **numeric1** (number) - Required - The first value. - **numeric2** (number) - Required - The second value. - **numeric3** (number) - Required - The third value. ### Example min(5, 2, 8) returns 2. ### Notes The minimum alteration intensity value will be given in the calculated column. ``` -------------------------------- ### month() Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Takes a date and displays only the month. Only text and numeric column types will work with this function. ```APIDOC ## month() ### Description Takes a date and displays only the month. Only text and numeric column types will work with this function. ### Syntax ```text month(dateValue) ``` ### Parameters - `dateValue` (date) - Required - The date from which to extract the month. ### Usage Notes - While the Drill Date column displays the full date, the month function leaves just the month. ``` -------------------------------- ### upper Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Changes the case of a string to uppercase. ```APIDOC ## upper ### Description Changes the case of a string to uppercase. ### Syntax upper(expression) ### Parameters - **expression** (string) - Required - The string to convert to uppercase. ### Example upper('grain size') returns 'GRAIN SIZE'. ``` -------------------------------- ### lower Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Changes the case of a string to lowercase. ```APIDOC ## lower ### Description Changes the case of a string to lowercase. ### Syntax lower(expression) ### Parameters - **expression** (string) - Required - The string to convert to lowercase. ### Example lower('GRAIN SIZE') returns 'grain size'. ``` -------------------------------- ### asin(angle) Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Calculates the arcsine (inverse sine) of an angle, returning the result in radians. ```APIDOC ## asin(angle) ### Description The trigonometric arcsine (or inverse sine) function. Calculates the arcsine of an angle returning a result in radians (not degrees). ### Syntax `asin(angle)` ### Parameters - **angle** (number) - Required - The angle for which to calculate the arcsine. ### Remarks - The result is in radians. - The input must be within the domain of the arcsine function. ### Example `asin(1)` returns approximately 1.5708 radians. ``` -------------------------------- ### len Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Returns the number of characters (length) in a string. ```APIDOC ## len ### Description Returns the number of characters (length) in a string. ### Syntax len(expression) ### Parameters - **expression** (string) - Required - The string to measure. ### Example len('Sample') returns 6. ``` -------------------------------- ### concat Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Concatenates two or more strings with an optional separator. ```APIDOC ## concat ### Description Concatenates two or more strings. The last parameter in the function argument identifies a separator that will be injected between tokens to separate them in the result. ### Syntax concat(expression1,expression2,expression3,separator) ### Parameters - **expression1** (string) - Required - The first string to concatenate. - **expression2** (string) - Required - The second string to concatenate. - **expression3** (string) - Required - The third string to concatenate. - **separator** (string) - Required - The separator to insert between strings. ### Example concat('pre', 'ext', 'value', '_') returns 'pre_ext_value'. ``` -------------------------------- ### Combine Ranked Columns from Different Activities with ifThen Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/formula-gallery.htm Use this formula to combine assay results from ranked columns across different activities (e.g., Diamond and RC drilling) into one merged column for modelling reporting. ```formula ifThen([NOT isEmpty({Au-DD_RankedCol, ppm (Activity-DD CoreLogging)}),{Au-DD_RankedCol, ppm (Activity-DD CoreLogging)}],[NOT isEmpty({Au-RC_RankedCol, ppm (Activity-RC)}),{Au-RC_RankedCol, ppm (Activity-RC)}]) ``` -------------------------------- ### Sample Weight Check formula using ifElse() Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/formula-gallery.htm Checks the FieldDup Weight against the Original Sample Weight and flags if the variance exceeds 50%. When adding the new column, select text type, not numeric, because the formula returns the text 'Check Weight'. ```formula ifElse(abs(({Original Sample Weight}-{FieldDup Weight})/({Original Sample Weight}))>0.50,'Check Weight','') ``` -------------------------------- ### rtrim Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Removes the specified text or blank spaces found at the end of a string. ```APIDOC ## rtrim ### Description Removes the specified text or blank spaces found at the end of a string. ### Syntax rtrim(expression,text) ### Parameters - **expression** (string) - Required - The string to trim. - **text** (string) - Required - The text to remove from the end of the string. ### Example rtrim('Sample000', '000') returns 'Sample'. ``` -------------------------------- ### year() Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Takes a date and displays only the year. Only text and numeric column types will work with this function. ```APIDOC ## year() ### Description Takes a date and displays only the year. Only text and numeric column types will work with this function. ### Syntax ```text year(dateValue) ``` ### Parameters - `dateValue` (date) - Required - The date from which to extract the year. ### Usage Notes - While the Drill Date column displays the full date, the year function leaves just the year. ``` -------------------------------- ### degrees(angle) Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Converts an angle from radians to degrees. ```APIDOC ## degrees(angle) ### Description Calculates the angle from radians to degrees. ### Syntax `degrees(angle)` ### Parameters - **angle** (number) - Required - The angle in radians to convert to degrees. ### Remarks - The input angle must be in radians. - The result is the angle in degrees. ### Example `degrees(3.14159)` returns approximately 180. ``` -------------------------------- ### sum Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Sums the set of any given amount of specified values. ```APIDOC ## sum ### Description Sums the set of any given amount of specified values. ### Syntax ``` sum(numeric1, numeric2, numeric3) ``` ### Parameters - **numeric1** (number) - Required - The first value. - **numeric2** (number) - Required - The second value. - **numeric3** (number) - Required - The third value. ### Example sum(1, 2, 3) returns 6. ### Notes The sum of the intervals will be calculated. ``` -------------------------------- ### radians(angle) Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Converts an angle from degrees to radians. ```APIDOC ## radians(angle) ### Description Calculates the angle from degrees to radians. ### Syntax `radians(angle)` ### Parameters - **angle** (number) - Required - The angle in degrees to convert to radians. ### Remarks - The input angle must be in degrees. - The result is the angle in radians. ### Example `radians(180)` returns approximately 3.14159. ``` -------------------------------- ### today() Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Adds the current local date stamp to a new row. Works best in date and text column types. ```APIDOC ## today() ### Description Adds the current local date stamp to a new row. This function works best in date and text column types. ### Syntax ```text today() ``` ### Usage Notes - Today's date will appear automatically when a new row is created. - This function will not run a recalculation; it only works when a new row of data has been created, it does not run on old data. ``` -------------------------------- ### right Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Returns the specified number of the rightmost characters from a string. ```APIDOC ## right ### Description Returns the specified number of the rightmost characters from a string. ### Syntax right(string,count) ### Parameters - **string** (string) - Required - The string to extract characters from. - **count** (integer) - Required - The number of rightmost characters to return. ### Example right('Sample Number', 3) returns 'ber'. ``` -------------------------------- ### sin(angle) Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Calculates the trigonometric sine of an angle in radians. ```APIDOC ## sin(angle) ### Description Calculates the trigonometric sine of an angle, expecting the angle provided to be in radians (not degrees). ### Syntax `sin(angle)` ### Parameters - **angle** (number) - Required - The angle in radians for which to calculate the sine. ### Remarks - The angle must be provided in radians. - The result is the sine of the given angle. ### Example `sin(1.5708)` returns approximately 1.0. ``` -------------------------------- ### max Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Returns the maximum value of any given amount of specified values. ```APIDOC ## max ### Description Returns the maximum value of any given amount of specified values. ### Syntax ``` max(numeric1, numeric2, numeric3) ``` ### Parameters - **numeric1** (number) - Required - The first value. - **numeric2** (number) - Required - The second value. - **numeric3** (number) - Required - The third value. ### Example max(5, 2, 8) returns 8. ### Notes The maximum alteration intensity value will be given in the calculated column. ``` -------------------------------- ### Delayed By in Days formula using ifThen Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/formula-gallery.htm Combines the ExpectedDate and LabTurnaroundTime formulas to show the delay of lab results in days. If ResultsReceivedDate is empty, it calculates the difference from today to ExpectedDate; otherwise, if LabTurnaroundTime is greater than 15, it calculates the difference from ResultsReceivedDate to ExpectedDate. ```formula ifThen([{ResultsReceivedDate}=='',dateDiff(today(),{ExpectedDate},'days')],[{LabTurnaroundTime}>15,dateDiff({ResultsReceivedDate},{ExpectedDate},'days')]) ``` -------------------------------- ### pow Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Returns the given expression raised to the specified power. ```APIDOC ## pow ### Description Returns the given expression raised to the specified power. ### Syntax ``` pow(base, exponent) ``` ### Parameters - **base** (number) - Required - The base value. - **exponent** (number) - Required - The exponent to raise the base to. ### Example pow(2, 3) returns 8. ### Notes Here the pow function is used in the formula to calculate the volume of each core interval. ``` -------------------------------- ### dateAdd() Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Adds a specified number of days or weeks to the input date. Works best in date and text column types. ```APIDOC ## dateAdd() ### Description Adds a specified number of days or weeks to the input date. This function works best in date and text column types. ### Syntax ```text dateAdd({date-value}, add-value, unit) ``` ### Parameters - `{date-value}` (date) - Required - The date to which the addition is applied. - `add-value` (number) - Required - The number of units to add. - `unit` (string) - Required - The unit of time to add (e.g., 'day', 'week'). ### Usage Notes - Example: 1 day will be added to the Drill Date in the calculated column. ``` -------------------------------- ### avg Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Averages the set of any given amount of specified values. ```APIDOC ## avg ### Description Averages the set of any given amount of specified values. ### Syntax ``` avg(numeric1, numeric2, numeric3) ``` ### Parameters - **numeric1** (number) - Required - The first value to average. - **numeric2** (number) - Required - The second value to average. - **numeric3** (number) - Required - The third value to average. ### Example avg(2, 4, 6) returns 4. ### Notes Calculating the average across 3 different pH Reading columns. ``` -------------------------------- ### search Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Tests if a string contains a character pattern using a regular expression. ```APIDOC ## search ### Description Tests if a string contains a character pattern using a regular expression. Returns true if it does, false otherwise. ### Syntax search(regex,expression) ### Parameters - **regex** (string) - Required - The regular expression pattern to search for. - **expression** (string) - Required - The string to search within. ### Example search('^Original[^0-9]', 'Original') returns true. ``` -------------------------------- ### sqrt Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Returns the square root of a given expression. ```APIDOC ## sqrt ### Description Returns the square root of a given expression. ### Syntax ``` sqrt(expression) ``` ### Parameters - **expression** (number) - Required - The value to take the square root of. ### Example sqrt(16) returns 4. ### Notes The square root is calculated on the Volume M2 variable. ``` -------------------------------- ### left Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Returns the specified number of the leftmost characters from a string. ```APIDOC ## left ### Description Returns the specified number of the leftmost characters from a string. ### Syntax left(string,count) ### Parameters - **string** (string) - Required - The string to extract characters from. - **count** (integer) - Required - The number of leftmost characters to return. ### Example left('Texture', 3) returns 'Tex'. ``` -------------------------------- ### Expected Date formula using dateAdd Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/formula-gallery.htm Adds 15 days to the DateDispatched column to calculate the expected date for lab results. The result is in date format, so the new column should be set to the date type. ```formula dateAdd({DateDispatched},15,'days') ``` -------------------------------- ### floor Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Decrements a decimal value to the next lowest integer. ```APIDOC ## floor ### Description Decrements a decimal value to the next lowest integer. ### Syntax ``` floor(decimal) ``` ### Parameters - **decimal** (number) - Required - The value to round down. ### Example If the length is 4.2, it will display as 4 in the calculated column. ### Notes This formula will show the floor of the length for the From To interval. ``` -------------------------------- ### in Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm The in conditional function returns true if the expression is found in the set of test items. ```APIDOC ## in ### Description The in conditional function returns true if the result of the expression is found in the set of test items. There can be any number of test items not just three. ### Syntax ``` in(expression, test-item1, test-item2, test-item3) ``` ### Parameters - **expression** (any) - Required - The expression to test. - **test-item1** (any) - Required - The first test item. - **test-item2** (any) - Required - The second test item. - **test-item3** (any) - Required - The third test item. ### Example in(Lithology.Value, "Qal", "Tba", "Ktc") ### Notes If the Lithology.Value field contains one of the listed values then the function returns Found; otherwise it returns Missing. ``` -------------------------------- ### dateStr() Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Formats the input date as a text string controlled by an explicit format string. Choose either text or numeric column types, depending on if the result is text or numeric. The date column type does not work with this function. ```APIDOC ## dateStr() ### Description Formats the input date as a text string controlled by an explicit format string. Choose either text or numeric column types, depending on if the result is text or numeric. The date column type does not work with this function. ### Syntax ```text dateStr(dateValue, expression) ``` ### Parameters - `dateValue` (date) - Required - The date to format. - `expression` (string) - Required - The format string that controls the output. ### Format String Expressions | Expression | Description | Example | |------------|-------------|---------| | %a | Weekday, short version | Wed | | %A | Weekday, full version | Wednesday | | %w | Weekday as a number 0-6, 0 is Sunday | 3 | | %d | Day of month 01-31 | 27 | | %b | Month name, short version | Dec | | %B | Month name, full version | December | | %m | Month as a number 01-12 | 12 | | %y | Year, short version, without century | 24 | | %Y | Year, full version | 2024 | | %Z | Timezone | AEST | | %j | Day number of year 001-366 | 365 | | %U | Week number of year, Sunday as the first day of week, 00-53 | 52 | | %W | Week number of year, Monday as the first day of week, 00-53 | 52 | | %C | Century | 21 | | %x | Local version of date | 31/12/2024 | ### Usage Notes - Example: The string expression used will format the date to display as a short version of the year. ``` -------------------------------- ### ifThen Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm The ifThen conditional function tests multiple conditions and returns the result of the first true condition. ```APIDOC ## ifThen ### Description The ifThen conditional function is used when a number of conditions need to be tested. In this sense, it is more like a switch or case statement than an if conditional, but it is not limited to testing a single conditional input. Provide a list of comma-separated conditional expression pairings inside square brackets, with each pairing comprising a test condition and a result value to return if the test condition is true. The ifThen statement will return the result value of the first conditional expression pairing where the test condition is true. There is no specific limit for the number of conditional expression pairings that can be listed. ### Syntax ``` ifThen( [test-condition1, result1], [test-condition2, result2], [test-condition3, result3] ) ``` ### Parameters - **test-condition1** (boolean) - Required - The first condition to test. - **result1** (any) - Required - The value returned if the first condition is true. - **test-condition2** (boolean) - Required - The second condition to test. - **result2** (any) - Required - The value returned if the second condition is true. - **test-condition3** (boolean) - Required - The third condition to test. - **result3** (any) - Required - The value returned if the third condition is true. ### Example ifThen( [Lithology.Value == "Qal", "Qal"], [Lithology.Value == "Tba", "Tba"], [Lithology.Value == "Ktc", "Ktc"], [Lithology.Value == "Mig", "Mig"] ) ### Notes For each of Lithology.Values Qal, Tba, Ktc and Mig, a different result value is specified. ``` -------------------------------- ### abs Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Returns the absolute value of a given expression. ```APIDOC ## abs ### Description Returns the absolute value of a given expression. ### Syntax ``` abs(expression) ``` ### Parameters - **expression** (number) - Required - The expression to take the absolute value of. ### Example If the Dip value is -45, the result is 45. ### Notes Here the Dip value in the survey table will display as its absolute value; that is, without the negative symbol preceding it. ``` -------------------------------- ### Validate That Data is Filled Sequentially Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/validations/validations-gallery.htm Validation rule to ensure values are entered in order. Uses two text type inputs, Column_1 and Column_2. The second block is the validation message that can be copied and used. ```plaintext NOT(isEmpty({Column_1}))|isEmpty({Column_2}) ``` ```plaintext {Column_1.source} is not logged yet, log a value in {Column_1.source} first ``` -------------------------------- ### Merge Field and Lab Sample Weight Columns with ifThen Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/formula-gallery.htm Use this formula in a calculated column (e.g., Master Weight) to merge two columns, preferring the field sample weight and falling back to the lab sample weight (RecvdWt_RankedCol) when the field value is empty. ```formula ifThen([NOT isEmpty({Field Sample Weight}),{Field Sample Weight}],[NOT isEmpty({RecvdWt_RankedCol, kg (Activity-DD CoreLogging)}),{RecvdWt_RankedCol, kg (Activity-DD CoreLogging)}]) ``` -------------------------------- ### e Constant Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm The constant e, the base of the natural logarithm, is an existing item you do not need to define yourself. It is approximately equal to 2.71828. ```APIDOC ## e Constant ### Description The constant e, the base of the natural logarithm, is an existing item you do not need to define yourself. It is approximately equal to 2.71828. ### Usage Notes - Euler's base is multiplied with the cosine of the Core Angle. ``` -------------------------------- ### median Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Returns the median value, number in the middle, of any given amount of specified values. ```APIDOC ## median ### Description Returns the median value, number in the middle, of any given amount of specified values. ### Syntax ``` median(numeric1, numeric2, numeric3) ``` ### Parameters - **numeric1** (number) - Required - The first value. - **numeric2** (number) - Required - The second value. - **numeric3** (number) - Required - The third value. ### Example median(3, 1, 2) returns 2. ### Notes The middle number of the pH Readings will be shown in the calculated column. ``` -------------------------------- ### endsWith Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Tests if a string ends with a specified suffix. ```APIDOC ## endsWith ### Description Tests if a string ends with a specified suffix. Returns true if it does, false otherwise. ### Syntax endsWith(expression,prefix) or endsWith(expression,prefix,start,end) ### Parameters - **expression** (string) - Required - The string to test. - **prefix** (string) - Required - The suffix to search for. - **start** (integer) - Optional - The position to start searching. - **end** (integer) - Optional - The position to end searching. ### Example endsWith('check', 'ck') returns true. ``` -------------------------------- ### atan2(y,x) Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Calculates the two-argument arctangent (y/x) returning the angle in radians. ```APIDOC ## atan2(y,x) ### Description The two-argument trigonometric arctangent (or inverse tangent) function, taking y and x arguments instead of a distance as an input, where (x,y) are the coordinates of a point; the result is the angle between the positive x axis and the vector to (x,y). atan2(y,x) is the same as atan(y/x). The result is an angle in radians. ### Syntax `atan2(y,x)` ### Parameters - **y** (number) - Required - The y-coordinate of the point. - **x** (number) - Required - The x-coordinate of the point. ### Remarks - The result is in radians. - The function determines the angle between the positive x-axis and the vector to the point (x,y). ### Example `atan2(1,1)` returns approximately 0.7854 radians. ``` -------------------------------- ### cos(angle) Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Calculates the trigonometric cosine of an angle in radians. ```APIDOC ## cos(angle) ### Description Calculates the trigonometric cosine of an angle, expecting the angle provided to be in radians (not degrees). ### Syntax `cos(angle)` ### Parameters - **angle** (number) - Required - The angle in radians for which to calculate the cosine. ### Remarks - The angle must be provided in radians. - The result is the cosine of the given angle. ### Example `cos(0)` returns 1.0. ``` -------------------------------- ### PI Constant Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm The mathematical constant pi, the ratio of a circle's circumference to its diameter, is an existing item you do not need to define yourself. It is approximately equal to 3.14159. ```APIDOC ## PI Constant ### Description The mathematical constant pi, the ratio of a circle's circumference to its diameter, is an existing item you do not need to define yourself. It is approximately equal to 3.14159. ### Usage Notes - Example: PI is used to calculate the volume of core for a specific interval. ``` -------------------------------- ### contains Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Tests if a string contains a specified substring. ```APIDOC ## contains ### Description Tests if a string contains a specified substring. Returns true if it does, false otherwise. ### Syntax contains(search space,target) ### Parameters - **search space** (string) - Required - The string to search within. - **target** (string) - Required - The substring to search for. ### Example contains('braccia', 'bra') returns true. ``` -------------------------------- ### round Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Rounds a decimal value to the closest integer. ```APIDOC ## round ### Description Rounds a decimal value to the closest integer. ### Syntax ``` round(decimal) ``` ### Parameters - **decimal** (number) - Required - The value to round. ### Example If the input is 4.5, the result is 5. ### Notes The variable input is RQD, and in this calculated column, the output is the value rounded up or down to the nearest whole number. ``` -------------------------------- ### Calculate Corrected Azimuth with Magnetic Declination Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/formula-gallery.htm Calculates the Corrected Azimuth based on a Magnetic North flag. If Magnetic North is 'Yes', adds the Magnetic Declination from the Collar Header and applies modulo 360; otherwise returns the Azimuth unchanged. To guarantee a result in every row, turn off the Required field for Magnetic North in Edit Inputs; blank values would otherwise produce blank results. ```formula ifElse({Magnetic North}=='Yes',({Azimuth}+{Collar Header.Magnetic Declination})%360,{Azimuth}) ``` -------------------------------- ### ceil Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Increments a decimal value to the next highest integer. ```APIDOC ## ceil ### Description Increments a decimal value to the next highest integer. ### Syntax ``` ceil(decimal) ``` ### Parameters - **decimal** (number) - Required - The value to round up. ### Example If the length is 4.2, it will display as 5 in the calculated column. ### Notes This formula will show the ceiling of the length for the From To interval. ``` -------------------------------- ### atan(angle) Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Calculates the arctangent (inverse tangent) of an angle, returning the result in radians. ```APIDOC ## atan(angle) ### Description The trigonometric arctangent (or inverse tangent) function. Calculates the arctangent of an angle, in radians. ### Syntax `atan(angle)` ### Parameters - **angle** (number) - Required - The angle for which to calculate the arctangent. ### Remarks - The result is in radians. ### Example `atan(1)` returns approximately 0.7854 radians. ``` -------------------------------- ### dateDiff() Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Returns the difference in either days or weeks between two specified dates. Works best in numeric and text column types. ```APIDOC ## dateDiff() ### Description Returns the difference in either days or weeks between the specified dates. The latter date should be listed first, before the initial date, to enable accurate subtraction. This function works best in numeric and text column types. ### Syntax ```text dateDiff(latterDateValue - initialDateValue, unit) ``` ### Parameters - `latterDateValue` (date) - Required - The later date. - `initialDateValue` (date) - Required - The initial date. - `unit` (string) - Required - The unit of time for the difference (e.g., 'day', 'week'). ### Usage Notes - Example: This formula calculates the amount of weeks between the Drill Date, when drilling started, and Today's Date. ``` -------------------------------- ### Duplicate Entries Not Allowed Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/validations/validations-gallery.htm Validation rule to display an error if duplicates are logged across two column entries. Uses two text type inputs, Column_1 and Column_2. The second block is the validation message that can be copied and used. ```plaintext {Column_2}!={Column_1} ``` ```plaintext {Column_2.source} cannot be {Column_2.value} because {Column_1.value} has been logged in {Column_1.source} ``` -------------------------------- ### tan(angle) Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Calculates the trigonometric tangent of an angle in radians. ```APIDOC ## tan(angle) ### Description The trigonometric tangent function, expecting the angle provided to be in radians (not degrees). ### Syntax `tan(angle)` ### Parameters - **angle** (number) - Required - The angle in radians for which to calculate the tangent. ### Remarks - The angle must be provided in radians. - The result is the tangent of the given angle. ### Example `tan(0.7854)` returns approximately 1.0. ``` -------------------------------- ### Depth Check Against Target Depth Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/formula-gallery.htm Validation formula that checks if the depth exceeds the target depth from the header. Returns an error message if the depth is greater than the target depth, otherwise returns an empty string. When the Character length is set to less than the text return character length, the cell can be highlighted red as a warning while logging in the survey table. ```formula ifElse({YourHeader.Target depth}<{Depth},'Depth Error-Depth value more than target depth','') ``` -------------------------------- ### acos(angle) Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Calculates the arccosine (inverse cosine) of an angle, returning the result in radians. ```APIDOC ## acos(angle) ### Description The trigonometric arccosine (or inverse cosine) function. Calculates the arccosine of an angle returning a result in radians (not degrees). ### Syntax `acos(angle)` ### Parameters - **angle** (number) - Required - The angle for which to calculate the arccosine. ### Remarks - The result is in radians. - The input must be within the domain of the arccosine function. ### Example `acos(0)` returns approximately 1.5708 radians. ``` -------------------------------- ### Validate Data Against a Previous Amount Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/validations/validations-gallery.htm Validation rule that warns if the azimuth value in the survey table deviates more than 5 degrees from the previously logged value. Uses a numeric type input, Azi. The second block is the validation message that can be copied and used. ```plaintext abs({Azi}-previous({Azi}))<=5 ``` ```plaintext Survey has deviated more than 5 degrees from previous measurement ``` -------------------------------- ### Turnaround Time formula using dateDiff Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/formula-gallery.htm Calculates the turnaround time for lab results as the difference in days between ResultsReceivedDate and DateDispatched. The result is a number, so the column type should be Numeric. The Max value can be set to 14 to flag cells red when the turnaround is 15 or more days. ```formula dateDiff({ResultsReceivedDate},{DateDispatched},'days') ``` -------------------------------- ### ifElse Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm The ifElse conditional function evaluates a test condition and returns the first result if true, otherwise the second result. ```APIDOC ## ifElse ### Description The ifElse conditional function is the natural function to use when a condition is being tested. It evaluates a test condition and if true, the first result value provided will be returned. If the test condition is false, the second result value provided will be returned. ### Syntax ``` ifElse(test-condition, true-result, false-result) ``` ### Parameters - **test-condition** (boolean) - Required - The condition to evaluate. - **true-result** (any) - Required - The value returned if the condition is true. - **false-result** (any) - Required - The value returned if the condition is false. ### Example ifElse(contains(Description, "braccia"), "Yes", "No") ### Notes The test condition is a search of the Description column of a Mineralisation table. If the column contains the word braccia the true result is Yes and if false the result is No. In the example shown here, we have chosen to have a text value returned of Valid or Not Valid based on the Strength Value of 0-5 selected by a logger in a structural table. For this column we have selected a text type column as the return value is text and not numeric. ``` -------------------------------- ### trunc Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/catalogue.htm Truncates a number to the decimal point, removing all digits to the right of the decimal point. ```APIDOC ## trunc ### Description Removes all digits to the right of the decimal point for any value. ### Syntax ``` trunc(decimal) ``` ### Parameters - **decimal** (number) - Required - The value to truncate. ### Example If the input is 4.2, the result is 4. ### Notes The variable input is the RQD, and in this calculated column, only the whole number will be displayed. ``` -------------------------------- ### Flagging Characters Not Allowed Source: https://help.seequent.com/MXDeposit/en-GB/Content/admin/validations/validations-gallery.htm Validation rule that gives an error if a comma is used because it conflicts with CSV exports. Uses a text type input, Field. The second block is the validation message that can be copied and used. ```plaintext NOT(contains({Field},',')) ``` ```plaintext Please remove all commas from {Field.source}. ``` === COMPLETE CONTENT === This response contains all available snippets from this library. No additional content exists. Do not make further requests.