Table 2.
Worksheets in TransfectionTracker1221.xlsm and their function.
| Worksheet name | Worksheet type | Description |
|---|---|---|
| Documentation | Documentation | Key commands and workflows |
| Calendar | Data entry | Enter daily activities |
| Metadata Template | Template | Blank template for entering transfection details |
| 20200113mChOCT4sg2 | Completed template | Example metadata for a specific transfection. A unique metadata worksheet is created for each transfection |
| 20200120mCHOCT4sg2 | Completed template | Example metadata for a specific transfection. A unique metadata worksheet is created for each transfection |
| 20200220mChOCT4sg2 | Completed template | Example metadata for a specific transfection. A unique metadata worksheet is created for each transfection |
| Data | Report | Tabular form of all entries on Calendar |
| ActivityList | List of terms | Activities that can be selected on the Calendar |
| Cell Samples | Report | All samples created and that can be selected on the Calendar |
| Data validation criteria | List of terms | Source of all drop-down lists on the Metadata Template |
| TransfectionsReport | Report | Simple query of all records in Data associated with activity Transfect |
| FreezeReport | Report | Simple query of all records in Data associated with activity Freeze |
| DiscontinueReport | Report | Simple query of all records in Data associated with activity Discontinue |
| ExtractDNAReport | Report | Simple query of all records in Data associated with activity ExtractDNA |
| 20200113mChOCT4sg2Report | Report | Records from Data associated with selected Cell Sample Name |
| 20200120mCHOCT4sg2Report | Report | Records from Data associated with selected Cell Sample Name |
| 20200220mCHOCT4sg2Report | Report | Records from Data associated with selected Cell Sample Name |
| Passage#s200113_C6 | Report | Activities from CloneReport selected to allow counting of numbers of passages of that cell line |
| Passage#s200120_B9 | Report | Activities from CloneReport selected to allow counting of numbers of passages of that cell line |
| Passage#s2020220_A7 | Report | Activities from CloneReport selected to allow counting of numbers of passages of that cell line |
| Passage#s200220_C6 | Report | Activities from CloneReport selected to allow counting of numbers of passages of that cell line |
| Passage#s200220_C10 | Report | Activities from CloneReport selected to allow counting of numbers of passages of that cell line |
| AllClonesIist | Report | List of all unique cell samples |
| ClonesSummaries | Report | Compiled data for all clones |
| Notes | Report | Daily notes recorded on Calendar (contains no data) |