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 on the Stacked Data worksheet. (So you can edit your plate data and re-run to update the stacked data.)

**Plate Name:**" or "

**Property ID:**" in the upper left, and the data diagonally adjacent. The value of the cell next to "Property:" is used as the column name for that data.

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

- Data may be of any size and shape as long as the shape is the same for all data blocks.
- Any data in adjacent cells to the plate data will be picked up and included in the table. Thus make sure the plate data block is separated from other data blocks or values by at least one row or column of empty cells.

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.

## 0 Comments