Background Depending on whether you purchased the Academic or Commercial version of the Platemaker Wizard, determines which experimental register your lab or organisation will be using. An example page from the commercial version of the Experimental Register is shown in Figure 1. Figure 1: An example page from the experiment register provided when you purchase […]
Open Experiment Register Database Read More »
Undoing Deletions It is possible to undo any deletions made with the clean data utility. Leaving the “Data value is” text field blank is effectively the inverse of placing the global “*” character in that field: the former Data value globally deletes values while the blank field globally restores them. If you select one of
Cherry Picking Clean Data If you want to cherry pick values in one go from the Flat Data table, simply put a character (say #) in the column next to the Dimension column and then set Excel to filter on this column (under Data tab on the ribbon “Filter”). Then set the filter to only
Cherry Picking Clean Data Read More »
Cleaning up Data Figure 1: The clean data main menu. In this example, the cursor was placed on a field that contained a value so that value has been helpfully copied into the “Data Value is:” field. Background: Once you have imported and generated visualisations of your data you can then look for obvious problems.
Importing Arrayscan data This option is not available in the default menu that is set when you first install the program as most labs will not have an Arrayscan store. Additionally, you must have tab Thermo in Excel. If the ribbon tab says Add-ins then you cannot directly import data from an Arrayscan store because
Importing Arrayscan data Read More »
Using Plate Ranges with the Generic Plate Import Program 1. Source Range less than target plate area and target is a single cell Such a selection is shown in Figure 1A. The program interprets this to mean that the user wants to copy the selected range of the source area into the entire target plate
Importing Generic Plate Data Figure 1: The generic import data form. Background The output of most plate reading instruments are simple CSV files (which open in Excel as single page workbooks) or sometimes native Excel files with a list of numbers in table(s) that match the dimension of the original plate read. The Generic Platemaker
Importing Generic Plate Data Read More »
Make Manual Plate layout Global Sometimes you might want to just physically move around a few wells on a container worksheet plate after the workbook has been built. You can do this if you go to one of the dependent variable containers, because when you drag and drop workbook cells, Excel cleverly updates all the
Make Manual Plate layout Global Read More »
Add/Remove/Rename Data Page. Once you have built a Platemaker wizard container workbook, you might want to add, remove or rename one of its dependent data worksheets. You might think that the latter two operations are simple (it is very easy to rename a worksheet in Excel) but you should not do this using Excel. The
Add/Remove/Rename Data Page. Read More »
Resume Last Workbook Build If you push the Cancel button while you are in the process of defining a new workbook (or modifying a template) the information that you have currently entered is saved to the Access database. Using this option reloads page 1 of the “Create New Data Entry Workbook” wizard with any information
Resume Last Workbook Build Read More »
Click here to view our privacy and data retention policies.
Click here to view our refund policies.
