Instructions
This macro is used to build a map of a 384-well plate from four 96-well plate
maps.
This macro allows you to prepare your 384 plates in batch. You just have to
prepare a text file, named "Worlist.txt"
containing the following information (and nothing else!):
1) the name of your 384 plate
2) the list of the four 96-well plates that will be the components of the
384-well plate
3) the mode of rearrangement of your plates : Z or N
4) 4 plates rearranged in mode N :
| Plate 1 | Plate 3 |
| Plate 2 | Plate 4 |
in mode Z
| Plate 1 | Plate 2 |
| Plate 3 | Plate 4 |
Please notice that Worklist.xls is an Excel File
!
No blank lines in this file!
Example of input format:
Plate384_1
Plate96_1.xls
Plate96_2.xls
Plate96_3.xls
Plate96_4.xls
Z
Plate384_2
Plate96_5.xls
Plate96_6.xls
Plate96_7.xls
Plate96_8.xls
N
and so on…
Once you have scrupulously read the examples and verified that your files are in the proper format, shown here:
Input File (96-well plates)
| ABC123 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| A | 100 | 521 | 654 | 352 | 7744 | 354 | 3789 | 987 | 367 | 633 | 5412 | 6527 |
| B | 123 | 965 | 4354 | 654 | 5421 | 387 | 325 | 998 | 652 | 557 | 6954 | 3651 |
| C | 789 | 447 | 867 | 451 | 742 | 873 | 417 | 119 | 786 | 449 | 3625 | 1205 |
| D | 465 | 114 | 456 | 786 | 365 | 545 | 368 | 129 | 369 | 652 | 2498 | 1600 |
| E | 4562 | 7552 | 78 | 4654 | 321 | 450 | 325 | 352 | 852 | 141 | 6528 | 685 |
| F | 852 | 687 | 142 | 637 | 120 | 653 | 599 | 657 | 741 | 55745 | 230 | 5212 |
| G | 427 | 877 | 352 | 980 | 321 | 594 | 607 | 853 | 657 | 9547 | 659 | 1651 |
| H | 965 | 853 | 79 | 365 | 231 | 125 | 405 | 351 | 125 | 362 | 3629 | 9854 |
Output File (one 384-well plate)
| Plate 384 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| A | ||||||||||||||||||||||||
| B | ||||||||||||||||||||||||
| C | ||||||||||||||||||||||||
| D | ||||||||||||||||||||||||
| E | ||||||||||||||||||||||||
| F | ||||||||||||||||||||||||
| G | ||||||||||||||||||||||||
| H | ||||||||||||||||||||||||
| I | ||||||||||||||||||||||||
| J | ||||||||||||||||||||||||
| K | ||||||||||||||||||||||||
| L | ||||||||||||||||||||||||
| M | ||||||||||||||||||||||||
| N | ||||||||||||||||||||||||
| O | ||||||||||||||||||||||||
| P |
4 plates rearranged :
in mode N :
| Plate 1 | Plate 3 |
| Plate 2 | Plate 4 |
in mode Z
| Plate 1 | Plate 2 |
| Plate 3 | Plate 4 |
you are ready to use 96to384.
Just go to the Welcome sheet and push button "Choose your "Worklist.xls"
file"
You have to check carefully that the worklist and all the necessary 96-well
plate files are in the same folder.
Description of the macro.
Download the macro.
Back to the program list.
This page was last updated on: January 06, 2005 by Stéphanie Monnier