Instructions

Toggle Absolute/Relative Address A useful extension to using the F4 key inside the formula box at the top of Excel to change a formula from a relative address (without dollar signs) to an absolute address (with dollar signs). Unlike the F4 key, this little utility allows you to select a whole range that contains formulas […]

Rename Image Files If you have a directory of exported images, it is possible with this function to globally replace the computer generated Unique plate ID number with something more descriptive about the experiment like “New Adhesion Experiment” Figure 1: The rename Image files function.

Multiple Row Area Paste Although this function is provided when the Platemaker wizard build is paused, if you also want to use this function outside of building a Platemaker wizard workbook, then you can include it as a separate menu item by selecting it in the program options menu. The function allows the user to

Global Text Replace across Files This is a useful function which can save hours of time when trying to correct a drug spelling error that maybe present in some workbooks but not others. For example, imagine that one of your templates contained a spelling error such that the EGFR inhibitor Gefitinib is spelt incorrectly. In

Get Well information from a datapoint If you want to get the plate number and well address of an individual data point, simply select the data point as you would if you were going to use the data cleaning function to remove it (see Data Cleaning). Be careful that the number you select is a

Formula Copy/Paste This is a little function is provided to allow you copy 2D array to another part of your workbook creating formulas back to the original array. This option can be achieved using the “Paste Link” button from the “Paste Special” submenu located in the Home section of the Excel ribbon. However, “Plate Link”

Draw table outline If you like the table borders that the Platemaker wizard creates when it creates tables then this little function allows you to add the same table border to your Excel tables (Figure 1B) by first selecting it (Figure 1A). Figure 1: The draw table outline function in action.

Create Text File of Flat Data If you have a workbook open and you select this option, a single text file page is produced of the Flat table complete with well addresses in it. This function helps data managers who wish to parse a Platemaker Wizard Flat Data table into a relational database. Figure 1:

Copy to/from Prism Graph Most instruments that measure ELISA assays allow you to fit data to a standard curve before exporting it. However, if you only have raw absorbance data that requires fitting to a standard curve then the “Copy to/From Prism Graph” function is useful to help you export the data to a curve

Add to formula This utility allows the user to add another IF statement to a preexisting formula. In Figure 1, cell A20 is selected. It already has a formula in it which is: =IF(OR(ISERROR($A$8),ISBLANK($A$8)),””,$A8) When this cell is selected, and the Add to Formula utility is run, the form automatically retrieves the source cell (A8)