S.I/Lisp/

"Single-function formulas."

Spreadsheet Lisp (SL)—a pure subset of the LISP programming paradigm—is designed to simplify, and thus enhance, spreadsheet formulas. By approaching (asymptotically) "single-function formulas", Spreadsheet Lisp (SL) abstracts away unnecessary formula complexity in order to:

reduce formula lengths, thereby
improving formula readability, which
minimizes formula typos/mistakes and
multiplies formula workloads.

Either download SpreadsheetLisp.xlsx

or install Spreadsheet Lisp manually

List of Contents

Fun Functions

Type Functions

List Functions

Text Functions

Number Functions

Sheet Functions

Functional Functions

Sentential Functions

Miscellaneous Functions

Experimental Functions

Aliases

Fun Functions

COINTOSS()
DICEROLL()
FLIPCOIN([times])
FULLDECK([vertical])
MAGIC8BALL(question)
ROCKPAPERSCISSORS(throw)
ROLLDICE([times])

Type Functions

EMPTYLIST?(input)
EQUAL(a, b)
ISATOM(value)
NOTEQUAL(a, b)
RANGE?(value)
TYPESTRING(value)

List Functions

ALL(truth_values)
APPEND(head, body)
CAR(range)
CDR(range)
CONS(value, range)
COUNTCELLS(range)
FIRST(range)
FIRSTCOLUMN(range)
FIRSTROW(range)
HLIST([value1], [valueN], [value25])
HORIZONTAL?(range)
INDICES(subset, superset)
LAST(range)
MEMBER(needle, haystack)
REST(range)
REVERSE(range)
VERTICAL?(range)
VLIST([value1], [valueN], [value25])

Text Functions

ALPHABET([vertical])
CAPITALIZE(text)
FIRSTLETTER(text)
FIRSTWORD(text)
FORMAT(template_text, [first_value], ...)
TEXTBETWEEN(source_text, first_boundary, second_boundary)
TEXTTOCOLUMNS(text, delimiter)
TEXTTOROWS(text, delimiter)
TRIMALL(range)
TRIMSPLIT(source_text, split_at, [display_vertically])

Number Functions

CUBEROOT(x)
DECREMENT(number)
DIFFERENCE(minuend, subtrahend)
GREATERTHAN?(x, y)
GTE?(x, y)
INCREMENT(number)
LESSTHAN?(x, y)
LTE?(x, y)
NEGATIVE?(x)
ONE?(x)
POSITIVE?(x)
RATIO(numerator, denominator)
SQUAREROOT(x)
ZERO?(x)

Sheet Functions

CELLNAME([reference], [absolute?])
COLUMNLETTER([cell_reference])
FILENAME([reference])
SHEETNAME([reference])

Functional Functions

APPLY(function, [argument1], ..., [argument10])
ARITY([arg1], ..., [arg25])
CONSTANCY(x, y)
CURRY(function, argument1)
DEFAULT(optional_argument, fallback_value)
FOREACH(range, function_to_apply)
IDENTITY(x)
IS(value)
PROVIDED?(value)

Sentential Functions

_1_are_2.(_1, _2)
_1_is_2.(_1, _2)
_1_is_2_if_3_are_4.(_1, _2, _3, _4, knowledgebase)
_1_is_not_2.(_1, _2)
_Is_1_2?(_1, _2, knowledgebase)

Miscellaneous Functions

ASSERT(condition, [message])
CASE(case_1a, case_1b, ..., [case_10a], [case_10b])
CONTAINS(haystack, needle)
CRITERIATABLE(column_names, row_conditions)
EXTRACTOPERATOR(condition_string)
EXTRACTOPERATORS(condition_strings)
HEADLESS(range)
INDICES(subset, superset)
MEETSCRITERIA(row_data, criteria_table)
IFOMITTED(optional_argument, value_if_omitted, value_if_provided)
PICK(choice1, [choiceN], [choice25])
SELECTCOLUMNS(table_range, [columns])
SELECTFROM(columns, table_range, [row_conditions])
SELECTROWS(table_range, [row_conditions])
SIEVE(table_range, filter_lookup_table)
SL()

Experimental Functions

QUESTION(knowledgebase, [fragment1], ..., [fragment10])
STATEMENT(fragment1, ..., [fragment10])