Spreadsheets

• Create New Spreadsheet
• List Spreadsheets
• Assign Beamline Positions
• Inside a Spreadsheet

The Spreadsheets tab is the primary way to manage sample information in the Crystal Server. Each spreadsheet (also called a SIL — Sample Information List) represents a container of crystal samples that you bring to the beamline.

Create New Spreadsheet

Spreadsheets can be created by clicking on Create New under the Spreadsheets Tab (Fig. xx)

There are two ways to create a spreadsheet:

• Download Template: Choose a container type (SSRL Cassette, Uni-puck, or SSRL Plate) and click Download Template and fill in your sample information, then click on Upload Spreadsheet to upload the spreadsheet to the Crystal Server database.
• Quick Start: Choose a container type and click Quick Start. The system creates a spreadsheet in the datasbase with default port names as sample names, ready for immediate use.

List Spreadsheets

Click on List Spreadsheets under the Spreadsheets tab to view all your spreadsheets (Fig xx). A table is displayed with the following information:"

• Last Modified: The last time the file was modified
• Spreadsheet Name: Click to view samples
• Spreadsheet ID: Internal identifier SIL
• Processed Datasets: Number of samples with processing results
• Assigned Beamline: Beamline the spreadsheet is assigned to for data collection
• Assigned Position: Slot position on the beamline
• Container Type: Cassette, Puck, or Plate
• Upload Time: When the spreadsheet was last uploaded
• Owner: Username of the spreadsheet owner

Actions and Options

Hover over the Actions column to see options (Fig xx) or click on Options to see a complete list of options (Fig. xx):

• Assign: OPens the Assign Beamline Postions tab to connect or disconnect from a beamline and container position for automated data collection.
• Rename: Change the display name.
• Download: Export to Excel with all data and processing results.
• Delete: Permanently remove the spreadsheet and all related sample information from the database.

Assigned Beamline Positions (Staff Only)

Shows all spreadsheets currently assigned to beamline positions across the facility. Useful for managing which samples are queued for screening.

User Spreadsheets (Staff Only)

Look up and view spreadsheets belonging to any user. Search by username to access their data for support or administrative tasks.

Inside a Spreadsheet

Clicking a spreadsheet name opens its detail view. Samples are organized by port (mount position) in two groups:

• Mounts with Multiple Samples — Ports that contain more than one crystal.
• Mounts with Single Sample — The standard single-crystal-per-mount layout.

Each sample shows its Crystal ID, Protein, Compound, Metal, Person, Priority, and Grid Location. Click a Crystal ID to edit sample details including experimental parameters and conditions.

If processing results exist, a Processing Results tab appears alongside the default Screening Results tab, showing autoprocessing data for that spreadsheet's samples.

Container Types