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

w2w and Snac goes open source!

Posted on May 10, 2010

I have finally decided to release the source codes of w2w and Snac. Neither of the programs have seen much activity from my part lately, and I'm having difficulties to find time to fiddle with them. I therefor have uploaded both to GitHub (w2w, Snac), where you are welcome to branch off and fix things yourselves. Please let me know if you have made any improvements that should go back into the main code and I will try to merge it and release a new public version.

Have fun!

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!

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.