Install the Riffyn Functions AddIn here.

Macros

Use these by clicking their corresponding button on the AddIns tab of the Ribbon.

**Stack**

*Description*

Reshapes matrix data (e.g., 96-well or 384-well plate data) into a standard table. Select a range of cells, and then click the Stack button on the AddIns Ribbon.

**Stack Multiple**

*Description*

**Stack Multiple** searches your current worksheet for all plate data blocks, then reshapes, joins and concatenates them into a single table, with one column for each property name defined in the plate blocks. The output is placed into a “Stacked Data” worksheet. And you can re-run the AddIn repeatedly and it will just update the data in place. (So you can edit your plate data and re-run to update the stacked data.)

**Stack Multiple**button on the AddIns Ribbon. You can try it out on the example file attached below (testbook.xlsx).

Functions

Use these functions like any other Excel function. Enter "=rif...(...)" in any cell.

**rifFDR**

rifFDR(Pval, PvalDist, [Q], [FDRType])

*Description*

Calculates the false discovery rate for a P-value using a set of P-values calculated from the same null hypothesis.

*Arguments*

Pval: the P-value for which the FDR will be calculated

PvalDist: Range of cells containing the set of all P-values calculated for the experiment. All P-values must be calculated using the same null hypothesis (e.g., the same control data). If you have data P-values that come from (or potentially come from) multiple underlying distributions, consider using this very impressive method (not available in Excel though).

Q: Optional. If TRUE, then return the q-value. If FALSE return the unadjusted FDR.

FDRType: Optional. Selects the method used for calculating the FDR.

**rifInterpolate**

rifInterpolate(Xvalue, Xvalues, Yvalues)

*Description*

Returns and interpolated value of Y at a given value X, among an array of X and Y values of equal length.

*Arguments*

Xvalue: the value of X at which to calculate the interpolated Y value.

Xvalues: an array of X values.

Yvalues: an array of Y values of equal length to the Xvalue array.

**rifIncRnum**

rifIncRnum(rnum)

*Description*

Increments the value of a Riffyn run number in the form R####. E.g., =rifIncRnum("R0014") will return "R0015".

*Arguments*

rnum: a string in the form C####, where C is any single character and # is any digit.