Custom Spreadsheet Functions

Pebble Stream

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

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)

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.