Making you hate normalization from 96-well plates less.
Have to add or take different volumes to/from each well of a 96 well plate?
This will let you do it in less than 15 minutes.
Use this script to generate an html file from a csv and open the html file on a tablet. Then start transfering to/from the highest-volume well (highlighted in yellow) and click to find the next-highest volume well.
Created by Tami Lieberman, 2014.
- Download the repository folder via the button on the right and unzip. Move it to your Dropbox folder (e.g. ~/Dropbox/Pipette-Guide-96)
- Paste desired volumes into volumes.csv
- Run "python makehtml.py" in the repository folder
- Open the updated index.html on your tablet/phone and get pipetting
For easy finding of wells, draw 3 lines on your 96 well plate, as shown in red on the pipette guide. (Between rows D&E, columns 4&5, and columns 8&9)
A shared dropbox between your PC and tablet will allow you to easily open index.html on your tablet.
Feel free to rename index.html, so that you can have one html file per plate.
If running on a Mac or Linux machine you can make this slightly faster by double-clicking on generate.sh in step 3. You may need to change the first line of generate.sh to point to the correct directory.
As of May 2016, there are suitable tablets available online for ~$60 (e.g. bestbuy.com, newegg.com)
Suggestions for improvements welcome!!