Custome Functions for Excel

This document introduces a collection of custom functions that can be used in the Excel.

SL.ASK

• Description: This function calls an LL model. The first parameter specifies the model to use, including gpt-3.5-turbo, gpt-4, and glm-4.
• Custom Function Name: SL.ASK
• Parameters:
  • model: Model to use, including gpt-3.5-turbo, gpt-4, and glm-4.
  • a: Value or cell address.
  • b: Value or cell address.
  • others: Value or cell address.
• Returns: Content from the LL model.

Sample:

SL.ASK("gpt-3.5-turbo", A1, B1, "Your question here")

SL.ASK("gpt-4", A1, B1, "Your question here")

SL.GPT3

• Description: This function calls the GPT3.5 model.
• Custom Function Name: SL.GPT3
• Parameters:
  • a: Value or cell address.
  • b: Value or cell address.
  • c: Value or cell address.
• Returns: Content from the LL model.

Sample:

SL.GPT3(A1, B1, "Your question here")

SL.GPT4

• Description: This function calls the GPT4 model.
• Custom Function Name: SL.GPT4
• Parameters:
  • a: Value or cell address.
  • b: Value or cell address.
  • c: Value or cell address.
• Returns: Content from the LL model.

Sample:

SL.GPT4(A1, B1, "Your question here")

SL.GLM

• Description: This function calls the GLM model.
• Custom Function Name: SL.GLM
• Parameters:
  • a: Value or cell address.
  • b: Value or cell address.
  • c: Value or cell address.
• Returns: Content from the LL model.

Sample:

SL.GLM(A1, B1, "Your question here")

SL.PY

• Description: Run Python code in Cell,the code need to have a main function.
• Custom Function Name: SL.PY
• Parameters:
  • code: Python code with the main function.
  • args: Values or cell addresses.
• Returns: Result of the function.

Sample:

SL.PY("def main(a, b): return a + b", A1, B1)