Riffyn Functions Help

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.

PastedGraphic-2.png

 


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.)

The only requirement is that the plate blocks are all the same size (any size, as long at they’re all the same), and all well positions have data (use "-" for empty wells). The blocks must also be  in a format like the image below with "Plate name:" and "Property Name:" up in the upper left, and the data diagonally adjacent. Data may be of any size and shape as long as the shape is the same for all data blocks.
 
PastedGraphic-1.png
 
Execute the AddIn by clicking the 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.

 


  

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request