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 the Thermo Addin that allows Excel to talk to an Arrayscan store is not installed. Assuming your version of Excel can talk to an Arrayscan store, first go to Platemaker Wizard “Program Options” and in the Menu Options Importing Utilities section, select from the dropdown list one of the options that includes the Arrayscan Import function (Figure 1).

Figure 1: Gaining access to the Arrayscan import functionality of the Platemaker Wizard by first using the Program options menu to add the function to the Platemaker Wizard’s main menu.

Open a workbook that has been built by the Platemaker Wizard and is where you want to send the Arrayscan store data.

Select Platemaker Wizard Import Arrayscan Data. The menu of Figure 2 will be displayed.

Push the centre button “Populate Source Workbook with Plate Data”

This prompt will appear

Do not push OK!

Figure 2: The Arrayscan Importing menu.

Go back to thermos menu and select “Launch plate selector”

The following Thermofisher store menu will appear

Now use the filters on the left to select the appropriate plates. In this example, I have type “Ascites C2574 into PlateID/Barcode

Now select the plates from this you want to import using the green + key

Once you have selected the plates you will get a screen similar to that shown in Figure 3.

Figure 3: The Cellomics Importing from Store Screen with several plates selected.

Now select the features you want to import. In our example we will import SelectedObjectCount and %High_CircSpot_CountCh2.

Now click Import Data button.

You will now be returned to the following prompt.

Now you can push OK.

Now you will be returned to this screen but this time the dependent variable dropdown box is active (Figure 4).

Figure 4: The Platemaker Wizard Arrayscan import menu after data has been selected from the Store.

At this point you need to associate the target plate name variable with the Arrayscan variable by using the dropdown box on Dependent Name (Figure 5).

Figure 5: Associating the dependent variable of the Excel workbook with the Arrayscan variables from the store. In this example, we want Cell Count to receive the “Selected Object Count” and Cell Death to receive “%High_CircSpotCountCh2”.

For example, Cell Count will be associated with SelectedObjectCount and Cell Death will be associated with %High_CircSpotCountCh2. Once you have selected the correct Arrayscan variable push the Add key which will be active. After both have been associated your import screen should look something like Figure 6.

Figure 6: The Arrayscan import menu after the dependent variables of the workbook have been associated with the Arrayscan variables.

Now click the import data button.

You will see the plates imported and will end up on a new workbook page called “Import Info” which contains the unique Store database IDs of the plates you have imported and the matching of the workbook dependent variables with the Arrayscan variables that you have created (Figure 7).

Figure 7: A new page added to the workbook after data has been imported from the Arrayscan Store. This page records in the left table what unique plate IDs from the store have been imported into the corresponding plates in the workbook and the right table records which Arrayscan parameters are associated with which dependent workbook variables.

© 2025 Bensonium ().

Click here to view our privacy and data retention policies.
Click here to view our refund policies.

Scroll to Top