Custom Spreadsheet Functions

Pebble Stream

Pebble Stream functions are prefixed with "PS." and are available for all Pebble Stream users.

PS.PING

This function is a test function that returns the value provided. It is used to verify Pebble Stream custom functions are correctly loaded.

=PS.PING("hello")

This formula returns the string "hello".

PS.MATCHES

This function returns the position of the nth occurrence of a value in a one-dimensional range.

=PS.MATCHES("pebble", AA2:AA10, 3)

This formula will return the position of the third occurrence of the word "pebble" from the range AA2:AA10.

RSM

RSM functions are prefixed with "RSM." and are available only to approved RSM users.

RSM.NPV

Implements RSM's custom net present value calculation solution for RSM's approved users only. Please see internal documentation for more information.

RSM.YIELD

Implements RSM's custom yield calculation solution for RSM's approved users only. Please see internal documentation for more information.