Worksheet calculation:

INPUT:

OUTPUT:

Equivalent Function:

Lets convert this to a function. Symbol # is used to prevent interaction between existing worksheet variables and variables inside function (so the variable name inside function is different from variable name outside function):

lets check our function:

Function works an ready to be "fed" data!

Export to spreadsheet:

initial spreadsheet row

Lets convert the above to function. Note that row.out parameter is used without # at the end so can be passed back to the SMath worksheet outside of the function:

lets set the starting row of spreadsheet to "15":

now lets loop the function: