Date: Tue, 8 Aug 1995 13:42:49 -0400 From: bl275@cleveland.freenet.edu (Dan Diaz) Subject: SoluPred; biology spreadsheet contribution This Excel 4.0 spreadsheet allows one to predict the solubility of recombinant proteins in E. coli based on the amino acid content. A user enters the content of several amino acids and the spreadsheet predicts whether a protein will be soluble based on the method of Wilkinson and Harrison, as described in their paper: "Predicting the solubility of recombinant proteins in Escherichia coli" Bio/Technology, vol. 9, p. 443-448 (1991). A few errors noted in this paper have been corrected, and the corrected model for protein solubility has been used in this spreadsheet. solupred.xl.hqx is an HQX encoded version for Excel 4.0 for the Macintosh. A uuencoded version for Lotus for DOS/Windows machines is also available. Many DOS/Windows applications are now able to open Macintosh files; it is also possible to open this file on a Macintosh and save it in DOS/Windows format onto a DOS-formatted floppy. The original spreadsheet was sent to me by Dr. Roger Harrison of the University of Oklahoma, who asked my help in finding the spreadsheet a home on the Internet. I have made some slight interface modifications, the remainder is Dr. Harrison's work. Please feel free to contact me if I can supply any further information. Dan Diaz BL275@cleveland.freenet.edu (This file must be converted with BinHex 4.0) :$e0[E(93FQ9N,RKX,R0TG!"6594%8dP8)3#3"!Ml!*!%-mG6593K!!%!!!MlFNa KG3)!N!3@!*!$$3Y6Efae8(*PC#jiE!(q#Z!!*Sh+!*!$J!#3"!)',SkZB!#3'[q 3"&K-8c4B3d9-!3kX6N%@V%j"&J#3"K"r!*!'#(8!!&I)!*!'k8B-!*RVS*cN!-m FG"S!Aq1Ha[AX1Ae11cQKI'eJh@E&,-TTPr[)[R@IiAX!HNSB2SpZr(AGAMRjIC3 2)T2pK&0br-KY-YTNfj-"*j[F2M,C4cLjIH6C2V,*lb1$6@iIf@5f*I[)D"qj63E lb2',F(*FFL[`i`Y2lA1668DE$$LCEi+56IED!3!*l'9idL+LM,(cl#I4(*1XihQ cV(cjI&TZH+ULj0Q[PIHb)3%$f36EJrF$'$lEcYJ+iicYYm&,BqhdkU"A*lh1XcK lp1irIVqHhmKd%C'Nee-iP9dPl@9k[8E%2X`lr&hQD&GShf3#H)epLbDm#UpIL'R HcRi0D[eVdC[+8EYQ!'KR!$m$p$1JkD%AD(lPKJ%Ca$E-E5@[E,a1RYqJej8`Qlp Q4TYD+Y6qRKPVDZ[X&3J%2$&YA"Y(T[A2m8IeVpCIEmZhe26Y5%TrK-D1D4c)L[! I!YG3ddBl+IcM(fF$fJ%T5b&c1J&qll!fJ)SdA)145j6KIAKGC!Pa$V3BTZkCGN, 3INdP4!a-LkRd&%KaT[()b2M)#'LY602MT"(Dbc644I,,BmrQ8U6NaK*LJ'Q4#iI FjcG9m3Y0H*!!DG'q3`p(Fd&%HTKTX8Y0qRKkBm3J*0HAI$*jC2a3$!a`l9+6EKJ i(L%Cjd1(`'%)64eRA'CF6jl1H1bN-5M#)Sa2AFBpL@J4T%"VC6%@4fhY+Zj*#iZ bk%K1CLBcb%De1)UJJY`#Y4!Y6aBRDl@%D'HkGUkBQbLAblN*")$Qd3$!9GAe@)K f3"QfPKC!PX[VNa[V#G%&&GQ"a),[Ke#-#5i3`[P#McAiK1KN3V3&aR-b'0!#A4! 0dNl35D#$dXpMF"6S8#Z4)dNF55e(8[4)LKe*m@iUR!&k&HM93kp9d3D[$qZ5XGp L8D'ZSIl"Ih6qL8jqrXH&VX&D(1Q412!I0IASBlhYXAlZXGjqUU1r*`kDqNA3hcl 9j4Y0[IfaM[RXRqSMj`2p,6M$cZrVGAah(86ThAdJk0ec%+-h1f$dlYf2e&q#lB6 cJZ1*-B%((2b2mr10+d9!0A`!rhd2'ET`L2NL+(FP-YJ4!E--LN9ci)CU-1M+9mL JVi"C*fr)4%)QJiFG-GKS!A-$&$MZJ)QGcLiMJiGE`'b'IPT$CJ@cU#!6E!FbU2L [)Y-4-X1JI)pQGiE-Lk'I,YS(C#k"mKYLZN-QJ3GD&c)p)B-ZA"fChK2'Sad`6TM 01$)A6KKQ)Y0h`QMNZrpd$M%$rjicH-)%f@*k!B0d-"[6#jJIiA&*$'j$`-b#-[H 4i*qMH3EXf0TA#XU@XqNTZDXmhh)Gk@l*cI60Y2b8kAQ@lcUM[VcY9UUqp(FmC4E pNP)9@A%PU%@V!&**5GqeUhR,YLSe+39IT%Baf"`$,jiUZ1@mjCK1"8Dk&@8j[V3 FZHBA5XUc#LA,P!AAYU4CN62cmTh9"Be(UAi-Z*jZ8HPd3JRGfT)eYbThURREmNZ bD&C-kHBVTZ@SSUckPV-059JR+Bh,(9ZC[T)&Uk)@"(q@fXTJ-q`cP[d!FR#GFCP 0hdj,dbQHKMiZNr!""[-0M#Q)GB@+c@!,V"RhIa01*h%jEP%9'T!!k)VP6Yj6KC, MfZjfE9cZZRCDASI3dR*fGQCLG[DD6%eI[cipPTBbG3Gm,8Lj,,I8RP5HjhSqQ,P $(@T!TcV!&p%e,F'1ZD-m@6*hPF`VjB"p$e+##H-80HBC)V,X&U%#YP`2ihQ1'YK Jcl"'P-HlA6,p`%r9EjTYEPak62!ip69e)Vp)l@a!Nkij&8MNd*-$AlPJ)GHTXJf feX!aPbhAYYdph$V,J8c+CJ9,UHS8J8mkeA)HhV4d[P@X+MmT8l"EeE)M9m&l2l@ M!4qm-%kddh!-CJHKpcQ`hHc1[e`)hNSAJ!&eXqaYSicP6l,[S)bp(mJl+'1m+0q dUbKMf`Gb$@8XHT4[emJCGMc+'jk,-YBlbRH9*rJ&kQi$&J&@`2,#`!5Ae1m'60p 8IY@Zq"KB`E3,9CYf`SG-Zf!'"rFYE2@qR*!!UrG(&k2Lb`$TN!!"Ibdfp2CD[Fl Jfpj`lXeIITMkBhSTfr13!'F[214kYKmI!r!`XS-2HG5)$11)h*Z,5pPZQ0'(H1p $,V)'2))C`qmP[[kh&prl6NBXpl1)#%cP2Xi)`E[KmY!Jbh0X$dT2344b%AFZ!IP d`Qi96-Ge,)K2lTUHCHCY*H$$(haaJTN45'm8aed"!&Fd`AC0ZkS`m+,P&cbV(,4 VDP&1TqHRar#SH5)mDVk,KjL2c*-KmbY3j&eN,SI-#-kaN!#j%M,S3Y(XdC!!H5S mTP)KNd5NMXcBbI()$'4`BX$JX9bQfIJa-@$Qb)rJ2H6@J(Sm2#eFCb%UPJ(MX1A m@ZaR2hiIeh@5$6qiqXp[[rr@Rc,$f@rBIrRihGpPXTFHkVKdqV$cIHhRNHiI%"' KKiL+)TM3k602M)d[S)P0KLbFJfd$2-Rk,Q'aj-fMU`A2Rm0L(iL2X,l"X`R([-j @i(15i-1dB`DdbphQ0EMR@C8+R!Aj'R65%+fF!ApC,bdhh@fSfZCPK9Z1qiGEIVG 3FPdE[Dk@9*RDBFhCKSX1cLB(@MK"@fP!`EhN@(5I"XQmm-!f5flCa-,((FA#[i1 h!YaY,haDcXp-69r(-a4h&Fr3HmT@1bAA`3XU06Xe0bCRRTkEQ*ejCVla@Ih'mQG 2d,PVdc1#6p0L'f"$6C40biB4T8D+5kLAA,q59J8RAA8I1+kA9N8i"Zl4jRHbfqb HCcTqd09i,`HA0YiPkfE"FLSZA,(jQXbDMXaDjLXbYA,lkIQjTB+YGT809eTkbi0 6#fiUX$@f#-9UmhlY$eHr0-6BFr"CjkG"rm"[#0cUZ*EiVH"*@Y!I3Q&*9[rNKep arJm@A`!!: