This macro-enabled workbook is designed to help with creating a formatted analysis list for the Echo® MS system, using 96-well plate maps or lists
How to use:
- For 96-well plate sample lists using the numbered format location (1 to 96, instead of A1 to H12)
- Copy sample names to 96 Well List, beginning in cell B3
- Copy well locations to 96 Well List, beginning in cell C3
- Click View –> Macros and select Make_96_Well_Plate. Click Run.
- The plate map to the left should be populated with the sample names from the list
- The contents of this map can be copied to the 96 Well Plates Tab
- If you are provided a 96-well plate map, copy the contents to the appropriate quadrant location on the 96 Well Plates tab
- To merge up to 4 96-well plates into a single 384-well plate, copy sample name information into the appropriate locations on the 96 Well Plates tab
- Note: Samples will be copied from 96 well-plates to 384-well plates in a “quadrant” manner. This allows for easy plate combination using a 12-channel pipette. See 384-well plate curated figure for a sample merged plate.
- Once the 96-well plates are populated, click View –> Macros and select Make_384_Well_Plate. Click Run.
- The 384-well plate map should now be populated with the sample names from all the 96-well plate quadrants.
- To merge up to 4 96-well plates into a single 384-well plate, copy sample name information into the appropriate locations on the 96 Well Plates tab
- From here, you can create a run list from the 384-well plate generated for easy pasting into SCIEX OS software.
- Click ViewàMacros and select Make_List. Click Run.
- The macro will try to create the list in the order that SCIEX OS software will arrange the ejection order. Note that the algorithm used by SCIEX OS software may change, so it may not be a match in all cases.
Make 96-well plate
Make 384-well plate
384-well plate curated
Run list made for SCIEX OS software
RUO-MKT-18-14212-A
Great tool for converting 96-well plate data to 384-well plates! To ensure accurate results, use a precise 96-well plate template( https://96wellplatetemplate.com ) for data entry. This will enhance macro functionality and streamline your workflow for SCIEX OS software. Accurate templates minimize errors and improve efficiency.