Spreadsheet.Institute/

Instructions

1. Download 0.9.0.sl
2. If Microsoft Excel: run SpreadsheetLisp.vba
3. If Google Sheets: run SpreadsheetLisp.gs
4. Select "0.9.0.sl" download file
5. Use SL functions directly in your formulas

List of Contents

1. Aliases
2. Fun Functions
3. Functional Functions
4. Type Functions
5. List Functions
6. Text Functions
7. Number Functions
8. Sheet Functions
9. Experimental Functions

Aliases

• OTHERWISE

Fun Functions

• =COINTOSS()
• =FLIPCOIN([times])
• =MAGIC8BALL(question)
• =ROCKPAPERSCISSORS(throw)

Functional Functions

• =ARITY([arg1], [argN], [arg25])
• =CASE(, [argN], [arg25])
• =ID(value)
• =IS(value)
• =MAYBE(value)
• =MAYBENOT(value, default)
• =PROVIDED(value)

Type Functions

• =ISATOM(value)
• =TRUTHY(value)
• =TYPESTRING(value)

List Functions

• =ALL(truth_values)
• =CAR(range)
• =CDR(range)
• =CONS(value, range)
• =HETEROGENOUS(range)
• =HLIST(value1, [valueN], [value25])
• =HOMOGENOUS(range)
• =ISHORIZONTAL(range)
• =ISVERTICAL(range)
• =LENGTH(range)
• =MEMBER(needle, haystack)
• =VLIST(value1, [valueN], [value25])

Text Functions

• =ALPHABET([vertical])
• =FIRSTLETTER(text)
• =FIRSTWORD(text)
• =INTERPOLATE(template, [_1], [_2], [_3], [_4], [_5])
• =ISSUBSTRING(needle, haystack, [case_sensitive])
• =TEXTCONTAINS(haystack, needle, [case_sensitive])

Number Functions

• =CAGR(start, end, [periods])
• =DECREMENT(number)
• =DIFFERENCE(minuend, subtrahend)
• =GREATERTHAN(x, y)
• =GTE(x, y)
• =INCREMENT(number)
• =INVERSE(number)
• =ISNEGATIVE(number)
• =ISPOSITIVE(number)
• =LESSTHAN(x, y)
• =LTE(x, y)
• =NEGATE(number)
• =RATIO(numerator, denominator)

Sheet Functions

• =COLUMNLETTER(reference)
• =GET(name|range, [sheet], [file|path])
• =GETCOLUMN(column_number, range)
• =SHEETNAME([reference])

Experimental Functions

• =SQL(table, query)
• =SUBSET(table, query)

GitHub