The idea is to assist and automate association of patient codes with actual patients as much as possible. Barcodes are provided to avoid manual input errors.
We have created multiple Excel tables with patient pseudonym codes and label contents:
| File | Description | |
|---|---|---|
| Pilot | R-LiNK_patients_pilot_2019-04-04.xlsx | Test codes for patients 998 and 999 in centre 01 to 16 |
| Pilot | R-LiNK_labels_pilot_2019-04-04.xlsx | Labels generated for the above test patients - M00 time point only |
| Batch 1 | R-LiNK_patients_batch1_2019-09-12.xlsx | Codes for patients 001 to 020 in centres 01 to 03 |
| Batch 1 | R-LiNK_labels_batch1_2019-09-12.xlsx | Labels generated for the above patients - time points M00 and M03 |
| Batch 2 | R-LiNK_patients_batch2_2019-09-16.xlsx | Codes for patients 001 to 020 in centres 04-07, 09-10, 15 |
| Batch 2 | R-LiNK_labels_batch2_2019-09-16.xlsx | Labels generated for the above patients - time points M00 and M03 |
| Batch 3 | R-LiNK_patients_batch3_2019-09-30.xlsx | Codes for patients 001 to 020 in centres 08, 11-14, 16 |
| Batch 3 | R-LiNK_labels_batch3_2019-09-30.xlsx | Labels generated for the above patients - time points M00 and M03 |
| Batch 4 | R-LiNK_patients_batch4_2020-10-26.xlsx | Codes for 10 patients from all centres - Covid-19 crisis delay |
| Batch 4 | R-LiNK_labels_batch4_2020-10-26.xlsx | Labels generated for the above patients - time points M00 and M03 |
| Batch 5 | R-LiNK_patients_batch5_2021-01-18.xlsx | Codes for the remaining patients from all centres - Covid-19 crisis delay |
| Batch 5 | R-LiNK_labels_batch5_2021-01-18.xlsx | Labels generated for the above patients - time points M00 and M03 |
| Batch 6 | R-LiNK_patients_batch6_2021-05-20.xlsx | Labels to re-print - some time points only |
| Batch 6 | R-LiNK_labels_batch6_2021-05-20.xlsx | Labels to re-print - some time points only |
| Batch 7 | R-LiNK_patients_batch7_2021-12-13.xlsx | Codes for new patients 021 to 025 in centre 15 |
| Batch 7 | R-LiNK_labels_batch7_2021-12-13.xlsx | Labels generated for the above patients - time points M00 and M03 |
| Batch 8 | R-LiNK_patients_batch8_2022-01-18.xlsx | Re-print patients 001 to 005 in centre 12 |
| Batch 8 | R-LiNK_labels_batch8_2022-01-18.xlsx | Re-print labels for the above patients - time points M00 and M03 |
| Batch 9 | R-LiNK_patients_batch9_2022-03-11.xlsx | Codes for new patients 026 to 030 in centre 15 |
| Batch 9 | R-LiNK_labels_batch9_2022-03-11.xlsx | Labels generated for the above patients - time points M00 and M03 |
We have prepared Word templates for patient inclusion sheets and packaging labels:
| File | Description |
|---|---|
| R-LiNK_sheets.docx | 1 patient inclusion sheet and 2 MRI session sheets |
| R-LiNK_labels.docx | labels for packaging |
They contain mail merge fields that can be associated to the Patient column of the above Excel tables.
To print Word documents:
- Publipostage
- Démarrer la fusion et le publipostage | Lettres
- Terminer & fusionner | Imprimer les documents...
Here are a few links of interest:
- How to Print Barcodes With Excel and Word
DISPLAYBARCODEandMERGEBARCODE: How to Insert or Mail Merge BarcodesDISPLAYBARCODEMERGEBARCODEMERGEFIELD
We have prepared a model to generate labels for biolgical samples:
| File | Description |
|---|---|
| R-LiNK_labels_pilot_2019-04-08.l6t | model of labels used for pilot |
| R-LiNK_labels.l6t | model of labels used for batches 1, 2, 3 |
This model can be associated to the Barcode and Type columns of the above Excel tables.
Here are a few links of interest: