S.I/Lisp/

"Single-function formulas."

Definition Editor

Lispis Latinam I

Spreadsheet Lisp (SL) is a superset of spreadsheet functions designed to simplify 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

Aliases

Fun Functions

Type Functions

List Functions

Text Functions

Number Functions

Sheet Functions

Functional Functions

Sentential Functions

Miscellaneous Functions

Aliases

• NO
• OTHERWISE
• YES

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])
• BEGINSWITH?(text, beginning, [case_insensitive?])
• CAPITALIZE(text)
• ENDSWITH?(text, ending, [case_insensitive?])
• 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])
• BUILTINS()
• CONSTANCY(x, y)
• CURRY(function, argument1)
• DEFAULT(optional_argument, fallback_value)
• FOREACH(range, function_to_apply)
• FUNCTION([name])
• FUNCTIONS()
• IDENTITY(x)
• IS(value)
• PROVIDED?(value)
• SL()

Sentential Functions

• _?_is_1.(_1, knowledgebase)
• _?_is_the_1_of_2.(_1, _2, knowledgebase)
• _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)
• _1_is_the_2_of_?.(_1, _2, knowledgebase)
• _1_is_the_2_of_3.(_1, _2, _3)
• _All_?_are_1.(_1, knowledgebase)
• _All_1_are_?.(_1, knowledgebase)
• _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)
• TODO(description)

Source (GitHub)

Forum (Reddit)