Platemaker Wizard Utilities

Describes the many Utilities provided by the platemaker wizard including: the template editor, experimental register, page utilities and other useful utilities such as globally replacing text across multiple platemaker wizard built workbooks.

Rename Image Files

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.

Rename Image Files Read More »

Multiple Row Area Paste

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

Multiple Row Area Paste Read More »

Formula Copy/Paste

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”

Formula Copy/Paste Read More »

Draw table outline

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.

Draw table outline Read More »

Copy to/from Prism Graph

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

Copy to/from Prism Graph Read More »

Add to formula

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)

Add to formula Read More »

Scroll to Top