iansmith
Dec19-03, 01:49 PM
I doing hydrophobicity prediction of protein using this formula
H(i)=0.25*(h(i-2)+h(i)+h(i-2)+h(i+4))
h: hydrophobicity indices
i: a given amino acid
I doing wrote the following formula in excel
=0.25*((VLOOKUP(UPPER(B4),$G$2:$H$21,2,FALSE))+(VL OOKUP(UPPER(B2),$G$2:$H$21,2,FALSE))+(VLOOKUP(UPPE R(B6),$G$2:$H$21,2,FALSE))+(VLOOKUP(UPPER(B8),$G$2 :$H$21,2,FALSE)))
What I want to do is to add another set of lookup when there some specific amino acid on position (i-2) or (i+4)?
H(i)=0.25*(h(i-2)+h(i)+h(i-2)+h(i+4))
h: hydrophobicity indices
i: a given amino acid
I doing wrote the following formula in excel
=0.25*((VLOOKUP(UPPER(B4),$G$2:$H$21,2,FALSE))+(VL OOKUP(UPPER(B2),$G$2:$H$21,2,FALSE))+(VLOOKUP(UPPE R(B6),$G$2:$H$21,2,FALSE))+(VLOOKUP(UPPER(B8),$G$2 :$H$21,2,FALSE)))
What I want to do is to add another set of lookup when there some specific amino acid on position (i-2) or (i+4)?