Provided by Christ Notes
Bible Search

Z-score in Excel

Posted on August 30, 2012

I recently made an Excel udf to calculate the z-score (z-factor or what you would like to call it...) of a HTS plate. If you dare, you can download it here or if you prefer, copy the code below and paste into the VBA editor. The function is tested on Excel 2011 on Mac, but it should work at least with Excel 2010 and I believe also Excel 2007.

Function zscore(pos As Range, neg As Range) As Single
posmean = Application.WorksheetFunction.Average(pos)
negmean = Application.WorksheetFunction.Average(neg)
posstd = Application.WorksheetFunction.StDev(pos)
negstd = Application.WorksheetFunction.StDev(neg)
zscore = 1 - 3 * (posstd + negstd) / Math.Abs(posmean - negmean)
End Function

Biological activities database schema

Posted on October 14, 2011

In my day job I'm currently redesigning our database for biological activities of chemicals in preparation for our next big project that will hopefully start with a HTS within this year.
From the experiences I/we have had of our last system, I would like this one to be able to capture the raw data better, and then we would have software to calculate and visualize the end points (like percentage of control, fold change, EC50, etc.).
My idea is to base this on plates (with a generous definition of a plate that could also hold for example a set of cages with animals...) and experiments. I have attached an example DB schema to this post, click the image to enlarge to a zoomable version, or click here to download it as an MySQL Workbench document. Each well in the plate is marked as being positive or negative control, empty, or holding a test compound. There should also be information about everything that is put into it, such as cells, cofactors, stimulants, blockers, etc, and finally, there should be readouts, with the possibility to record time series.

If you have any comments, like the setup, or have ideas as to how this approach could be improved, please let me know in the comments.

Chemical structure editor

Posted on October 7, 2009

Thanks to a contest held by Metamolecular I started to think about what I believe are the most important functions for a chemical structure editor. (I use their product ChemWriter in a project of mine that hopefully will be available for public beta testing in a few months.)
Anyway, my main cirteria is ease of use! I like the editor to have simple keyboard shortcuts that are intuitive so that I remember them.
The first runners up is the looks, the editor should produce nice looking structures, preferably with the option to make custom labels that keep their chemical interpretation.

New updates to w2w!

Posted on April 15, 2008

I have now updated the public version of w2w to fix the problem with cUrl error no 5. The new version, 0.98, also includes automatic update checks and can be found here.

I have also made a new beta that shows some progress information during the upload process. If you are interested in trying that version (and are not already in the beta-program) please let me know in a comment or email.

Beta-testers wanted

Posted on September 5, 2007

I have made a new version of w2w that should solve the cURL error #5. Before I release it I would like to have it tested, so if you have seen the problem and would like to help me, please let me know in the comments or in an email.


w2w version 0.95

Posted on November 3, 2006

I have updated w2w to resolve a bug that occured when used on a directory with many files in it (such as an actual website... :-) ).

Many thanks to Reborg for his help with debugging!


Posted on October 6, 2006

Today, I got two hints into the macosxhints site. Both make use of launchd to start programs at specific occasions. One restarts a crashed program and the other offers an ability to print from Classic without installing a printer in the Classic-environment.

The important thing is that launchd is a great tool in OSX Tiger and it gets even better through Lingon, a graphical interface to launchd created by Peter Borg (who also happens to be the creator of my favorite text-editor, Smultron).

SpotSmart - Substructure search on your Mac

Posted on September 25, 2006

I have made a perl-script to enhance the excellent ChemSpotlight with substructure searching. The script in itself translates the output from mdfind into a valid smiles-file that could be searched using obgrep.

Update: A new version of the script solves an issue with long SMILES

More substructure searches

Posted on September 19, 2006

I have been using a customised version of the Lab Notebook from Macs In Chemistry as my labbook for several years now. I have however never really liked the substructure search in it. I don't want to first create a database and then search. When I'm looking for somehting I'm looking for it now... Besides, the fact that it uses ChemFinder that's still only available for Classic makes it even less attractive.

I have lately discovered the beauty of Open Babel and I figured that it's substructure search program obgrep should be possible to use to search in the Lab Notebook.