• Click the name Blood Test Data in the Assay List to see the "Runs" imported using it.

• In this case, a single run (spreadsheet) "BloodTest_Run1.xls" has been imported. Click the Assay ID (in this case the file name) to see the results.

• Click Re-Import Run above the grid.
• The first page shows:
• Assay Properties: These are fixed properties, like the assay design name, that are read only for all imports using this design.
• Batch Properties: These properties will apply to a set of files uploaded together. For example, here they include specifying how the data is identified (the Participant/Visit setting) and selecting a target study to use if any data is to be copied. Select /Example Project/Research Study (Research Study).

• Click Next.
• On the next page, notice the batch properties are now read only.
• Below them are Run Properties to specify; these could be entered differently for each run in the assay, such as the "Assay ID". If not provided, the name of the file is used, as in our example.
• Here you also provide the data from the assay run, either by uploading a data file (or reusing the one we already uploaded) or entering your own new data.
• Click Show Expected Data Fields. You will see the list of fields expected to be in the spreadsheet. When you design the assay, you specify the name, type, and other properties of expected columns.

• Click Download Spreadsheet Template to generate a blank template spreadsheet. It will be named "data_<datetimestamp>.xls". You could open and populate it in Excel, then upload it to this server as a new run. Save this template file and use it when you get to the Files section below.

• Since we are just reviewing the process right now, click Cancel after reviewing this page.

• From the Blood Test Data Runs page, select Manage Assay Design > Edit assay design to open it.

The sections correspond to how a user will set properties as they import a run. Click each section heading to open it.

• Assay Properties: Values that do not vary per run or batch.
• Batch Fields: Values set once for each batch of runs.
• Run Fields: Values set per run; in this case none are defined, but as you saw when importing the file, some built in things like "Assay ID" are defined per run.
• Results Fields: This is the heart of the assay design and where you would identify what columns (fields) are expected in the spreadsheet, what their data type is and whether they are required.

• Click the (expansion icon) for a row to see or set other properties of each column. With this panel open, click Advanced Settings for even more settings and properties, including things like whether a value can be used as a "measure" in reporting, as shown here for the WBC field. Learn more about using the field editor in this topic: Field Editor.

• Review the contents of this page, but make no changes and click Cancel.
• Return to the main folder page by clicking the Laboratory Data link near the top of the page.

• Click the header of the WBC column and select Sort Descending.
• Notice the (sort) icon that appears in the column header.

• Click the header of the Participant ID column and select Filter... to open a popup.
• Use the checkboxes to "Choose Values". For this example, uncheck the box for "202".
• The "Choose Values is only available when there are a limited number of distinct values.
• Switching to the "Choose Filters" tab in this popup would let you use filter expressions instead.

• Click OK to apply the filter.
• Notice the (filter) icon shown in the column header. There is also a new entry in the filter panel above the grid - you can clear this filter by clicking the for the "Participant <> 202" filter.

• Click the header of the MCV column and select Summary Statistics... to open a popup.
• Select the statistics you would like to show (the values are previewed in the popup.)
• Premium Feature: Many summary statistics shown are only available with premium editions of LabKey Server. Learn more here.
• In this case, Mean and Standard Deviation might be the most interesting. Click Apply.

• Notice the new row at the bottom of the grid showing the statistics we selected for this column.

• Click Save next to the grid modification message.

• Select Named and give the new grid a name (such as "Grid with Statistics").
• Check the box for "Make this grid view available to all users."
• Click Save.
• Notice that the grid now has Grid With Statistics shown above it.
• To switch between grid views, use the (Grid Views) menu in the grid header. Switch between "default" and "Grid With Statistics" to see the difference.

• Return to the "default" view before proceeding with this walkthrough.

• Open the template you downloaded earlier. It is an Excel file named "data_<datetimestamp>.xls"
• Enter some values. Some participant ID values to use are 101, 202, 303, 404, 505, and 606, though any integer values will be accepted. You can ignore the VisitID column and enter any dates you like. The WBC and MCV columns are integers, HGB is a double. The more rows of data you enter, the more "new" results you will have available to "analyze."
• Save the spreadsheet with the name "data_run2.xls" if you want to match our instructions.
• Click here to download ours if you want your data to match our screenshots: data_run2.xls

• Return to the Example Project > Laboratory Data folder.
• Drag and drop the "data_run2.xls" file into the Files web part to upload it.

• Select it using the checkbox and click Import Data.
• Scroll down to find the "Import Text or Excel Assay" category.
• Select Use Blood Test Data - the assay design we predefined. Notice you also have the option to create a new "General Purpose" assay design instead if you wanted to change the way it is imported.
• Click Import.

• You will see the Assay Properties and be able to enter Batch Properties; select "Example Project/Research Study" as the Target Study.
• Click Next.
• On the Run Properties and Data File page, notice your "data_run2.xls" file listed as the Run Data. You don't need to make any changes on this page.
• Click Save and Finish.
• Now you will see the runs grid, with your new run added to our original sample.

• Click the file name to see the data you created.
• Notice the (Grid Views) menu includes the custom grid view "Grid with Statistics" we created earlier - select it.
• Notice the grid also shows a filter "Run = 2" (the specific run number may vary) because you clicked the run name to view only results from that run. Click the for the filter to delete it.
• You now see the combined results from both runs.

• If you saved any visualizations earlier using the original spreadsheet of data, view them now from the (Charts/Reports) menu, and notice they have been updated to include your additional data.

• Navigate to the main page of the Laboratory Data folder.
• Drag and drop your "mydata.xls" file to the Files web part.
• Select the file and click Import Data.

• In the popup, choose "Create New General Assay Design" and click Import.
• Give your new assay design a Name, such as "MyData".
• Notice the default Location is the current project. Select instead the "Current Folder (Laboratory Data)".
• The Columns for Assay Data section shows the columns imported from your spreadsheet and the data types the server has inferred from the contents of the first few rows of your spreadsheet.
• If you see a column here that you do not want to import, simply uncheck it. If you want to edit column properties, you can do that using the (triangle) button next to the column name.

• You can change the inferred data types as necessary. For example, if you have a column that happens to contain whole number values, the server will infer it is of type "Integer". If you want it to be "Number (Double)" instead, select that type after clicking the (caret) button next to the type. If a column happens to be empty in the first few rows, the server will guess "Text (String)" but you can change that as well.
• Column Mapping below these inferrals is where you would map things like Participant ID and Date information. For instance, if you have a column called "When" that contains the date information, you can tell the server that here. It is not required that you provide mappings at all.

• When you are satisfied with how the server will interpret your spreadsheet, scroll back up and click Begin Import.
• You will be simultaneously creating the assay design (for this and future uses) and importing this single run. Enter batch properties if needed, then click Next.
• Enter run properties if needed, including an Assay ID if you want to use a name other than your file name.
• Click Show Expected Data Fields to review how your data will be structured. Notice that if you didn't provide mappings, new columns will be created for Specimen, Participant, Visit ID, and Date.
• Click Save and Finish.

• You now see your new run in a grid, and the new assay design has been created.

• Click the filename (in the Assay ID column) to see your data.
• Click column headers to sort, filter, or create quick visualizations.
• Select Manage Assay Design > Edit assay design to review the assay design.
• Click Laboratory Data to return to the main folder page.
• Notice your new assay design is listed in the Assay List.

• You can now upload and import additional spreadsheets with the same structure using it. When you import .xls files in the future, your own assay design will be one of the options for importing it.